participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
9,115 rows where station_code = "USL01C" sorted by created_at descending
This data as json, copyable, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
Link | rowid | meteor_unique_trajectory_identifier | station_code | created_at ▲ | updated_at |
---|---|---|---|---|---|
5524794 | 5524794 | 20241111054500_QdN7I | USL01C | 2024-11-12T14:18:01.580Z | 2024-11-12T14:18:08.782Z |
5524710 | 5524710 | 20241111051525_21uiG | USL01C | 2024-11-12T14:17:56.432Z | 2024-11-12T14:18:08.744Z |
5524121 | 5524121 | 20241111031704_H4Ew2 | USL01C | 2024-11-12T14:16:34.006Z | 2024-11-12T14:18:08.478Z |
5520532 | 5520532 | 20241110114647_LzgeL | USL01C | 2024-11-12T14:08:12.200Z | 2024-11-12T14:18:06.541Z |
5520465 | 5520465 | 20241110080209_1KQxZ | USL01C | 2024-11-12T14:06:55.773Z | 2024-11-12T14:18:05.949Z |
5518567 | 5518567 | 20241111081725_4emW0 | USL01C | 2024-11-12T14:01:21.903Z | 2024-11-12T14:01:21.903Z |
5518519 | 5518519 | 20241111080836_GvR0K | USL01C | 2024-11-12T14:01:11.366Z | 2024-11-12T14:01:11.366Z |
5518504 | 5518504 | 20241111080633_RK3rw | USL01C | 2024-11-12T14:01:07.923Z | 2024-11-12T14:01:07.923Z |
5518499 | 5518499 | 20241111080552_tDA6R | USL01C | 2024-11-12T14:01:07.309Z | 2024-11-12T14:01:07.309Z |
5518344 | 5518344 | 20241111071146_ko7K7 | USL01C | 2024-11-12T14:00:40.150Z | 2024-11-12T14:00:40.150Z |
5518143 | 5518143 | 20241110060737_Hz2XO | USL01C | 2024-11-11T14:15:15.714Z | 2024-11-12T14:22:02.857Z |
5516644 | 5516644 | 20241110013251_u9BXe | USL01C | 2024-11-11T14:13:12.896Z | 2024-11-12T14:21:14.836Z |
5513878 | 5513878 | 20241110123507_XdkuV | USL01C | 2024-11-11T14:05:35.017Z | 2024-11-12T14:18:06.685Z |
5513872 | 5513872 | 20241110123342_hymj9 | USL01C | 2024-11-11T14:05:34.106Z | 2024-11-12T14:18:06.680Z |
5513863 | 5513863 | 20241110123112_G3Bj3 | USL01C | 2024-11-11T14:05:33.275Z | 2024-11-12T14:18:06.675Z |
5513719 | 5513719 | 20241110121006_FEIs7 | USL01C | 2024-11-11T14:05:22.420Z | 2024-11-12T14:18:06.619Z |
5513618 | 5513618 | 20241110115730_zwu5p | USL01C | 2024-11-11T14:04:59.340Z | 2024-11-12T14:18:06.576Z |
5513499 | 5513499 | 20241110114026_aJZd3 | USL01C | 2024-11-11T14:04:43.800Z | 2024-11-12T14:18:06.524Z |
5513464 | 5513464 | 20241110113426_22Y90 | USL01C | 2024-11-11T14:04:40.714Z | 2024-11-12T14:18:06.504Z |
5513373 | 5513373 | 20241110112250_tXZJ7 | USL01C | 2024-11-11T14:04:33.073Z | 2024-11-12T14:18:06.467Z |
5513154 | 5513154 | 20241110104520_lJvmZ | USL01C | 2024-11-11T14:03:59.783Z | 2024-11-12T14:18:06.369Z |
5513044 | 5513044 | 20241110102701_Npo4R | USL01C | 2024-11-11T14:03:47.735Z | 2024-11-12T14:18:06.321Z |
5512981 | 5512981 | 20241110101711_KLCk8 | USL01C | 2024-11-11T14:03:42.320Z | 2024-11-12T14:18:06.294Z |
5512918 | 5512918 | 20241110101144_UlHnm | USL01C | 2024-11-11T14:03:35.619Z | 2024-11-12T14:18:06.272Z |
5512859 | 5512859 | 20241110100052_KSC5C | USL01C | 2024-11-11T14:03:18.684Z | 2024-11-12T14:18:06.247Z |
5512809 | 5512809 | 20241110095103_pG6a8 | USL01C | 2024-11-11T14:03:10.499Z | 2024-11-12T14:18:06.228Z |
5512604 | 5512604 | 20241110091715_BoLpV | USL01C | 2024-11-11T14:02:49.041Z | 2024-11-12T14:18:06.141Z |
5512496 | 5512496 | 20241110085901_6HKto | USL01C | 2024-11-11T14:02:25.113Z | 2024-11-12T14:18:06.096Z |
5512451 | 5512451 | 20241110085132_35gsS | USL01C | 2024-11-11T14:02:20.984Z | 2024-11-12T14:18:06.082Z |
5512345 | 5512345 | 20241110083446_hfYP2 | USL01C | 2024-11-11T14:02:08.653Z | 2024-11-12T14:18:06.038Z |
5512142 | 5512142 | 20241110080209_qTA0K | USL01C | 2024-11-11T14:01:36.120Z | 2024-11-11T14:01:36.120Z |
5512049 | 5512049 | 20241110074734_1prqP | USL01C | 2024-11-11T14:01:26.688Z | 2024-11-12T14:18:05.914Z |
5511895 | 5511895 | 20241110071728_aA3HQ | USL01C | 2024-11-11T14:00:59.985Z | 2024-11-12T14:18:05.845Z |
5511882 | 5511882 | 20241110071409_f77wd | USL01C | 2024-11-11T14:00:59.070Z | 2024-11-12T14:18:05.841Z |
5511835 | 5511835 | 20241110070618_lioa2 | USL01C | 2024-11-11T14:00:54.634Z | 2024-11-12T14:18:05.824Z |
5511710 | 5511710 | 20241110064314_0tfQ3 | USL01C | 2024-11-11T14:00:36.011Z | 2024-11-12T14:18:05.766Z |
5511323 | 5511323 | 20241109054534_XXGvU | USL01C | 2024-11-10T14:16:40.601Z | 2024-11-12T14:23:48.402Z |
5511252 | 5511252 | 20241109052141_VMCG2 | USL01C | 2024-11-10T14:16:34.556Z | 2024-11-12T14:23:47.375Z |
5511046 | 5511046 | 20241109041408_O3I8A | USL01C | 2024-11-10T14:16:07.765Z | 2024-11-12T14:23:43.671Z |
5510237 | 5510237 | 20241109020307_WNGpC | USL01C | 2024-11-10T14:14:50.537Z | 2024-11-12T14:23:32.573Z |
5507895 | 5507895 | 20241109124806_oRxTU | USL01C | 2024-11-10T14:06:24.405Z | 2024-11-12T14:19:14.531Z |
5507793 | 5507793 | 20241109122749_KGpMW | USL01C | 2024-11-10T14:06:13.065Z | 2024-11-12T14:19:11.212Z |
5507760 | 5507760 | 20241109122131_kdZTS | USL01C | 2024-11-10T14:06:01.293Z | 2024-11-12T14:19:09.987Z |
5507757 | 5507757 | 20241109121947_4LGXR | USL01C | 2024-11-10T14:06:00.779Z | 2024-11-12T14:19:09.869Z |
5507557 | 5507557 | 20241109115058_gqE3P | USL01C | 2024-11-10T14:05:32.500Z | 2024-11-12T14:19:02.088Z |
5507534 | 5507534 | 20241109114553_rkRGQ | USL01C | 2024-11-10T14:05:29.213Z | 2024-11-12T14:19:00.492Z |
5507517 | 5507517 | 20241109114022_3z85E | USL01C | 2024-11-10T14:05:27.623Z | 2024-11-12T14:19:00.117Z |
5507453 | 5507453 | 20241109113116_49Adp | USL01C | 2024-11-10T14:05:14.679Z | 2024-11-12T14:18:57.382Z |
5507395 | 5507395 | 20241109112346_iMHyM | USL01C | 2024-11-10T14:05:00.223Z | 2024-11-12T14:18:55.476Z |
5507267 | 5507267 | 20241109110247_sbg2O | USL01C | 2024-11-10T14:04:44.547Z | 2024-11-12T14:18:50.898Z |
5507236 | 5507236 | 20241109105523_xq6hh | USL01C | 2024-11-10T14:04:40.797Z | 2024-11-12T14:18:50.256Z |
5506967 | 5506967 | 20241109100737_AWHUj | USL01C | 2024-11-10T14:03:57.728Z | 2024-11-12T14:18:41.989Z |
5506904 | 5506904 | 20241109095840_nhiwt | USL01C | 2024-11-10T14:03:48.104Z | 2024-11-12T14:18:39.416Z |
5506810 | 5506810 | 20241109093918_0B9R9 | USL01C | 2024-11-10T14:03:22.662Z | 2024-11-12T14:18:34.307Z |
5506560 | 5506560 | 20241109085921_lDyYr | USL01C | 2024-11-10T14:02:34.026Z | 2024-11-12T14:18:25.899Z |
5506531 | 5506531 | 20241109085359_swdYh | USL01C | 2024-11-10T14:02:29.673Z | 2024-11-12T14:18:25.178Z |
5506527 | 5506527 | 20241109085333_iDoeC | USL01C | 2024-11-10T14:02:28.966Z | 2024-11-12T14:18:25.106Z |
5506416 | 5506416 | 20241109083526_3pXNR | USL01C | 2024-11-10T14:02:10.173Z | 2024-11-12T14:18:23.776Z |
5506396 | 5506396 | 20241109083406_H5rUH | USL01C | 2024-11-10T14:02:03.776Z | 2024-11-12T14:18:23.561Z |
5506377 | 5506377 | 20241109083202_YaruS | USL01C | 2024-11-10T14:01:58.597Z | 2024-11-12T14:18:23.349Z |
5506171 | 5506171 | 20241109074805_fy2ku | USL01C | 2024-11-10T14:01:24.520Z | 2024-11-12T14:18:17.928Z |
5506150 | 5506150 | 20241109074447_zVtE8 | USL01C | 2024-11-10T14:01:20.271Z | 2024-11-12T14:18:17.577Z |
5506012 | 5506012 | 20241109072317_i2guc | USL01C | 2024-11-10T14:01:02.200Z | 2024-11-12T14:18:15.689Z |
5505998 | 5505998 | 20241109071801_XvwJ9 | USL01C | 2024-11-10T14:01:00.263Z | 2024-11-12T14:18:15.480Z |
5505762 | 5505762 | 20241109063145_ewmS3 | USL01C | 2024-11-10T14:00:19.908Z | 2024-11-12T14:18:11.916Z |
5505708 | 5505708 | 20241109062321_kY233 | USL01C | 2024-11-10T14:00:12.559Z | 2024-11-12T14:18:11.098Z |
5505089 | 5505089 | 20241108035107_A7YUu | USL01C | 2024-11-09T14:15:42.934Z | 2024-11-12T14:25:11.902Z |
5504943 | 5504943 | 20241108032404_cEu0Y | USL01C | 2024-11-09T14:15:26.321Z | 2024-11-12T14:25:10.145Z |
5499639 | 5499639 | 20241108124729_0npy4 | USL01C | 2024-11-09T14:04:30.942Z | 2024-11-12T14:22:36.891Z |
5499502 | 5499502 | 20241108122802_CNW43 | USL01C | 2024-11-09T14:04:13.083Z | 2024-11-12T14:22:33.453Z |
5499491 | 5499491 | 20241108122746_r7Tv4 | USL01C | 2024-11-09T14:04:11.328Z | 2024-11-12T14:22:33.055Z |
5499457 | 5499457 | 20241108122129_0oRO8 | USL01C | 2024-11-09T14:04:08.251Z | 2024-11-12T14:22:32.749Z |
5499424 | 5499424 | 20241108121738_ZfyKo | USL01C | 2024-11-09T14:04:05.311Z | 2024-11-12T14:22:32.307Z |
5499070 | 5499070 | 20241108105814_DO5ce | USL01C | 2024-11-09T14:03:05.330Z | 2024-11-12T14:22:26.244Z |
5498754 | 5498754 | 20241108095244_Ptumh | USL01C | 2024-11-09T14:02:20.728Z | 2024-11-12T14:22:20.701Z |
5498658 | 5498658 | 20241108093258_602R5 | USL01C | 2024-11-09T14:02:07.315Z | 2024-11-12T14:22:18.172Z |
5498600 | 5498600 | 20241108091854_qis1k | USL01C | 2024-11-09T14:01:54.545Z | 2024-11-12T14:22:17.013Z |
5498508 | 5498508 | 20241108084627_qnWgS | USL01C | 2024-11-09T14:01:40.156Z | 2024-11-12T14:22:14.994Z |
5498446 | 5498446 | 20241108083349_IaPCD | USL01C | 2024-11-09T14:01:30.729Z | 2024-11-12T14:22:13.911Z |
5498198 | 5498198 | 20241108072756_eW5Yu | USL01C | 2024-11-09T14:00:48.674Z | 2024-11-12T14:22:08.666Z |
5491901 | 5491901 | 20241106061301_lIeaP | USL01C | 2024-11-07T14:17:18.852Z | 2024-11-12T14:26:56.625Z |
5491894 | 5491894 | 20241106060418_6O8Pr | USL01C | 2024-11-07T14:17:18.548Z | 2024-11-12T14:26:56.617Z |
5471693 | 5471693 | 20241104122657_i3bPU | USL01C | 2024-11-05T14:04:22.171Z | 2024-11-12T14:27:05.200Z |
5471685 | 5471685 | 20241104122547_BKzSB | USL01C | 2024-11-05T14:04:19.960Z | 2024-11-12T14:27:05.183Z |
5471658 | 5471658 | 20241104121944_oFPgl | USL01C | 2024-11-05T14:04:13.986Z | 2024-11-12T14:27:05.051Z |
5471540 | 5471540 | 20241104120052_932qa | USL01C | 2024-11-05T14:03:54.365Z | 2024-11-12T14:27:04.649Z |
5471439 | 5471439 | 20241104114423_cRz33 | USL01C | 2024-11-05T14:03:44.025Z | 2024-11-12T14:27:04.160Z |
5464014 | 5464014 | 20241102063424_i2OL6 | USL01C | 2024-11-03T14:19:29.353Z | 2024-11-10T14:26:37.520Z |
5463981 | 5463981 | 20241102062618_ieJrN | USL01C | 2024-11-03T14:19:27.488Z | 2024-11-10T14:26:37.471Z |
5463916 | 5463916 | 20241102061111_o3eDl | USL01C | 2024-11-03T14:19:25.152Z | 2024-11-10T14:26:37.313Z |
5463770 | 5463770 | 20241102050201_vUxdz | USL01C | 2024-11-03T14:19:16.178Z | 2024-11-10T14:26:36.719Z |
5463610 | 5463610 | 20241102042005_8c8ab | USL01C | 2024-11-03T14:19:02.205Z | 2024-11-10T14:26:35.689Z |
5463234 | 5463234 | 20241102025908_JZ87l | USL01C | 2024-11-03T14:18:27.265Z | 2024-11-10T14:26:34.604Z |
5456583 | 5456583 | 20241102114703_wSsbZ | USL01C | 2024-11-03T14:05:02.318Z | 2024-11-11T14:22:29.828Z |
5456451 | 5456451 | 20241102112338_dh2kq | USL01C | 2024-11-03T14:04:40.518Z | 2024-11-11T14:22:29.064Z |
5456442 | 5456442 | 20241102112143_UcJCQ | USL01C | 2024-11-03T14:04:37.389Z | 2024-11-11T14:22:29.035Z |
5456382 | 5456382 | 20241102111101_ToBw8 | USL01C | 2024-11-03T14:04:21.502Z | 2024-11-11T14:22:28.535Z |
5456343 | 5456343 | 20241102110312_YVCjw | USL01C | 2024-11-03T14:04:15.752Z | 2024-11-11T14:22:27.890Z |
5456294 | 5456294 | 20241102105447_VJmFu | USL01C | 2024-11-03T14:04:07.303Z | 2024-11-11T14:22:27.555Z |
5456255 | 5456255 | 20241102104856_lrn5D | USL01C | 2024-11-03T14:03:54.674Z | 2024-11-11T14:22:27.390Z |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE participating_station ( meteor_unique_trajectory_identifier text NOT NULL, station_code text NOT NULL, created_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), updated_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), FOREIGN KEY (meteor_unique_trajectory_identifier) REFERENCES meteor (unique_trajectory_identifier), FOREIGN KEY (station_code) REFERENCES station (code), UNIQUE (meteor_unique_trajectory_identifier, station_code) ON CONFLICT IGNORE ); CREATE INDEX participating_station_station_code_covering_index ON participating_station (station_code, meteor_unique_trajectory_identifier); CREATE INDEX participating_station_created_at_index ON participating_station (created_at); CREATE INDEX participating_station_updated_at_index ON participating_station (updated_at);