participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,369 rows where station_code = "US004B" 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 |
---|---|---|---|---|---|
5573187 | 5573187 | 20241121040503_NenFy | US004B | 2024-11-22T14:19:14.846Z | 2024-11-22T14:19:22.466Z |
5573143 | 5573143 | 20241121035956_D33HU | US004B | 2024-11-22T14:19:12.420Z | 2024-11-22T14:19:22.459Z |
5572361 | 5572361 | 20241121021402_NH3qN | US004B | 2024-11-22T14:18:19.178Z | 2024-11-22T14:19:22.314Z |
5572167 | 5572167 | 20241121014255_tSFq1 | US004B | 2024-11-22T14:18:02.875Z | 2024-11-22T14:19:22.272Z |
5568123 | 5568123 | 20241121115326_MRlti | US004B | 2024-11-22T14:08:09.276Z | 2024-11-22T14:08:09.276Z |
5568099 | 5568099 | 20241121114858_2iZxP | US004B | 2024-11-22T14:08:05.914Z | 2024-11-22T14:08:05.914Z |
5568085 | 5568085 | 20241121114650_7jp4E | US004B | 2024-11-22T14:08:04.291Z | 2024-11-22T14:08:04.291Z |
5568082 | 5568082 | 20241121114629_Wb9XG | US004B | 2024-11-22T14:08:04.100Z | 2024-11-22T14:08:04.100Z |
5567891 | 5567891 | 20241121112313_CeH63 | US004B | 2024-11-22T14:07:30.668Z | 2024-11-22T14:07:30.668Z |
5567799 | 5567799 | 20241121111135_zyz2z | US004B | 2024-11-22T14:07:17.621Z | 2024-11-22T14:07:17.621Z |
5567692 | 5567692 | 20241121105233_9Z1Ak | US004B | 2024-11-22T14:06:59.070Z | 2024-11-22T14:06:59.070Z |
5567580 | 5567580 | 20241121104056_45u6l | US004B | 2024-11-22T14:06:33.769Z | 2024-11-22T14:06:33.769Z |
5567519 | 5567519 | 20241121103116_p9iqS | US004B | 2024-11-22T14:06:26.583Z | 2024-11-22T14:06:26.583Z |
5567441 | 5567441 | 20241121102016_Oe3K5 | US004B | 2024-11-22T14:06:17.184Z | 2024-11-22T14:06:17.184Z |
5567427 | 5567427 | 20241121101753_ffvns | US004B | 2024-11-22T14:06:15.510Z | 2024-11-22T14:06:15.510Z |
5567425 | 5567425 | 20241121101713_z6rFA | US004B | 2024-11-22T14:06:14.768Z | 2024-11-22T14:06:14.768Z |
5567375 | 5567375 | 20241121100649_Owf95 | US004B | 2024-11-22T14:06:02.270Z | 2024-11-22T14:06:02.270Z |
5567186 | 5567186 | 20241121093805_55GLb | US004B | 2024-11-22T14:05:31.389Z | 2024-11-22T14:05:31.389Z |
5567058 | 5567058 | 20241121090446_weNiX | US004B | 2024-11-22T14:05:01.284Z | 2024-11-22T14:05:01.284Z |
5566999 | 5566999 | 20241121085523_2AmwT | US004B | 2024-11-22T14:04:51.334Z | 2024-11-22T14:04:51.334Z |
5566930 | 5566930 | 20241121084304_saBgS | US004B | 2024-11-22T14:04:32.420Z | 2024-11-22T14:04:32.420Z |
5566868 | 5566868 | 20241121082017_XHAIW | US004B | 2024-11-22T14:04:19.617Z | 2024-11-22T14:04:19.617Z |
5566859 | 5566859 | 20241121081805_TDIus | US004B | 2024-11-22T14:04:18.444Z | 2024-11-22T14:04:18.444Z |
5566767 | 5566767 | 20241121074309_Pl8X6 | US004B | 2024-11-22T14:03:53.799Z | 2024-11-22T14:03:53.799Z |
5566610 | 5566610 | 20241121070301_VsRuf | US004B | 2024-11-22T14:03:27.115Z | 2024-11-22T14:03:27.115Z |
5566560 | 5566560 | 20241121064034_OymAh | US004B | 2024-11-22T14:03:11.297Z | 2024-11-22T14:03:11.297Z |
5566468 | 5566468 | 20241121061709_iKczL | US004B | 2024-11-22T14:02:57.498Z | 2024-11-22T14:02:57.498Z |
5566213 | 5566213 | 20241121054722_b6CaJ | US004B | 2024-11-22T14:02:14.468Z | 2024-11-22T14:02:14.468Z |
5566186 | 5566186 | 20241121054414_ojiFj | US004B | 2024-11-22T14:02:09.818Z | 2024-11-22T14:02:09.818Z |
5566175 | 5566175 | 20241121054344_gdLH7 | US004B | 2024-11-22T14:02:07.286Z | 2024-11-22T14:02:07.286Z |
5566169 | 5566169 | 20241121054153_IM7UB | US004B | 2024-11-22T14:02:06.021Z | 2024-11-22T14:02:06.021Z |
5566148 | 5566148 | 20241121053746_caHcY | US004B | 2024-11-22T14:01:58.806Z | 2024-11-22T14:01:58.806Z |
5566146 | 5566146 | 20241121053729_MdZxj | US004B | 2024-11-22T14:01:58.203Z | 2024-11-22T14:01:58.203Z |
5566136 | 5566136 | 20241121053612_soSdS | US004B | 2024-11-22T14:01:55.661Z | 2024-11-22T14:01:55.661Z |
5565795 | 5565795 | 20241121044742_XtYgE | US004B | 2024-11-22T14:00:58.284Z | 2024-11-22T14:00:58.284Z |
5565760 | 5565760 | 20241121044235_U1Hbu | US004B | 2024-11-22T14:00:53.617Z | 2024-11-22T14:00:53.617Z |
5565485 | 5565485 | 20241120043046_ru73Y | US004B | 2024-11-21T14:18:50.957Z | 2024-11-22T14:21:47.684Z |
5564648 | 5564648 | 20241120031613_DrErm | US004B | 2024-11-21T14:17:55.279Z | 2024-11-22T14:21:34.917Z |
5564624 | 5564624 | 20241120031434_mg36y | US004B | 2024-11-21T14:17:53.683Z | 2024-11-22T14:21:34.469Z |
5562944 | 5562944 | 20241120003058_iZr39 | US004B | 2024-11-21T14:15:28.705Z | 2024-11-22T14:21:06.769Z |
5560134 | 5560134 | 20241120120633_srelQ | US004B | 2024-11-21T14:08:06.739Z | 2024-11-22T14:19:21.595Z |
5560099 | 5560099 | 20241120115845_wvbtL | US004B | 2024-11-21T14:08:02.501Z | 2024-11-22T14:19:21.587Z |
5559963 | 5559963 | 20241120113943_3bujW | US004B | 2024-11-21T14:07:42.209Z | 2024-11-22T14:19:21.558Z |
5559954 | 5559954 | 20241120113834_sdSf7 | US004B | 2024-11-21T14:07:40.724Z | 2024-11-22T14:19:21.556Z |
5559897 | 5559897 | 20241120113108_e5gyH | US004B | 2024-11-21T14:07:30.367Z | 2024-11-22T14:19:21.545Z |
5559700 | 5559700 | 20241120110144_yAorJ | US004B | 2024-11-21T14:07:00.198Z | 2024-11-22T14:19:21.505Z |
5559672 | 5559672 | 20241120105628_NMaoE | US004B | 2024-11-21T14:06:56.489Z | 2024-11-22T14:19:21.499Z |
5559636 | 5559636 | 20241120105229_oQEhU | US004B | 2024-11-21T14:06:49.506Z | 2024-11-22T14:19:21.491Z |
5559611 | 5559611 | 20241120104919_mkt11 | US004B | 2024-11-21T14:06:43.472Z | 2024-11-22T14:19:21.484Z |
5559502 | 5559502 | 20241120103445_1dhyY | US004B | 2024-11-21T14:06:28.218Z | 2024-11-22T14:19:21.461Z |
5559324 | 5559324 | 20241120100327_9kTnD | US004B | 2024-11-21T14:05:58.914Z | 2024-11-22T14:19:21.418Z |
5559309 | 5559309 | 20241120100138_T1P3Y | US004B | 2024-11-21T14:05:56.228Z | 2024-11-22T14:19:21.414Z |
5559292 | 5559292 | 20241120095735_EEHYs | US004B | 2024-11-21T14:05:52.219Z | 2024-11-22T14:19:21.409Z |
5559272 | 5559272 | 20241120095246_CG7M9 | US004B | 2024-11-21T14:05:47.327Z | 2024-11-22T14:19:21.403Z |
5559234 | 5559234 | 20241120094214_2efoK | US004B | 2024-11-21T14:05:40.125Z | 2024-11-22T14:19:21.393Z |
5559231 | 5559231 | 20241120094143_iDdhc | US004B | 2024-11-21T14:05:39.788Z | 2024-11-22T14:19:21.392Z |
5559161 | 5559161 | 20241120093213_wuCTU | US004B | 2024-11-21T14:05:30.515Z | 2024-11-22T14:19:21.377Z |
5559065 | 5559065 | 20241120091320_fAhVV | US004B | 2024-11-21T14:05:12.265Z | 2024-11-22T14:19:21.356Z |
5559044 | 5559044 | 20241120090750_eQ0Q4 | US004B | 2024-11-21T14:05:08.988Z | 2024-11-22T14:19:21.352Z |
5558990 | 5558990 | 20241120090257_QhCsT | US004B | 2024-11-21T14:04:59.348Z | 2024-11-22T14:19:21.342Z |
5558956 | 5558956 | 20241120085907_sUrJ0 | US004B | 2024-11-21T14:04:52.982Z | 2024-11-22T14:19:21.335Z |
5558904 | 5558904 | 20241120084630_7dAtf | US004B | 2024-11-21T14:04:46.740Z | 2024-11-22T14:19:21.325Z |
5558857 | 5558857 | 20241120083149_zB3vy | US004B | 2024-11-21T14:04:39.492Z | 2024-11-22T14:19:21.316Z |
5558842 | 5558842 | 20241120082614_k9u1E | US004B | 2024-11-21T14:04:36.921Z | 2024-11-22T14:19:21.312Z |
5558699 | 5558699 | 20241120074021_Wg7Gj | US004B | 2024-11-21T14:04:05.869Z | 2024-11-22T14:19:21.283Z |
5558677 | 5558677 | 20241120072623_zdHVj | US004B | 2024-11-21T14:04:01.411Z | 2024-11-22T14:19:21.277Z |
5558662 | 5558662 | 20241120072348_Im92f | US004B | 2024-11-21T14:03:59.404Z | 2024-11-22T14:19:21.275Z |
5558647 | 5558647 | 20241120071547_Dvk2C | US004B | 2024-11-21T14:03:55.986Z | 2024-11-22T14:19:21.271Z |
5558581 | 5558581 | 20241120064509_4aJjk | US004B | 2024-11-21T14:03:44.566Z | 2024-11-22T14:19:21.256Z |
5558576 | 5558576 | 20241120064211_SqRri | US004B | 2024-11-21T14:03:43.705Z | 2024-11-22T14:19:21.255Z |
5558562 | 5558562 | 20241120063654_F98KK | US004B | 2024-11-21T14:03:41.149Z | 2024-11-22T14:19:21.252Z |
5557963 | 5557963 | 20241120052624_ecn0F | US004B | 2024-11-21T14:02:09.420Z | 2024-11-22T14:19:21.153Z |
5557669 | 5557669 | 20241120050417_kpxVV | US004B | 2024-11-21T14:01:27.787Z | 2024-11-22T14:19:21.108Z |
5557379 | 5557379 | 20241120044131_aAQAR | US004B | 2024-11-21T14:00:39.362Z | 2024-11-22T14:19:21.060Z |
5557095 | 5557095 | 20241119035147_eB6D8 | US004B | 2024-11-20T14:12:16.914Z | 2024-11-22T14:22:22.183Z |
5557070 | 5557070 | 20241119034531_etKdz | US004B | 2024-11-20T14:12:11.956Z | 2024-11-22T14:22:22.057Z |
5556795 | 5556795 | 20241119015542_CEKQ6 | US004B | 2024-11-20T14:11:29.041Z | 2024-11-22T14:22:20.020Z |
5556634 | 5556634 | 20241119003215_qYkLl | US004B | 2024-11-20T14:11:00.301Z | 2024-11-22T14:22:18.931Z |
5555072 | 5555072 | 20241119113304_iin9R | US004B | 2024-11-20T14:04:23.921Z | 2024-11-22T14:19:56.760Z |
5555046 | 5555046 | 20241119112634_Pb3za | US004B | 2024-11-20T14:04:12.707Z | 2024-11-22T14:19:56.074Z |
5555040 | 5555040 | 20241119112522_ZibnS | US004B | 2024-11-20T14:04:11.856Z | 2024-11-22T14:19:55.939Z |
5555006 | 5555006 | 20241119111903_m2IAv | US004B | 2024-11-20T14:04:04.477Z | 2024-11-22T14:19:55.171Z |
5554917 | 5554917 | 20241119110309_2lyYe | US004B | 2024-11-20T14:03:48.245Z | 2024-11-22T14:19:53.984Z |
5554858 | 5554858 | 20241119105039_EA271 | US004B | 2024-11-20T14:03:37.540Z | 2024-11-22T14:19:52.691Z |
5554829 | 5554829 | 20241119104544_yPECd | US004B | 2024-11-20T14:03:25.564Z | 2024-11-22T14:19:52.183Z |
5554822 | 5554822 | 20241119104453_T2Htx | US004B | 2024-11-20T14:03:23.468Z | 2024-11-22T14:19:52.094Z |
5554702 | 5554702 | 20241119101158_OMFf9 | US004B | 2024-11-20T14:03:03.887Z | 2024-11-22T14:19:49.306Z |
5554675 | 5554675 | 20241119100349_GgA52 | US004B | 2024-11-20T14:02:59.460Z | 2024-11-22T14:19:48.651Z |
5554645 | 5554645 | 20241119095626_ndike | US004B | 2024-11-20T14:02:55.729Z | 2024-11-22T14:19:47.909Z |
5554621 | 5554621 | 20241119095057_rNc2t | US004B | 2024-11-20T14:02:44.614Z | 2024-11-22T14:19:45.880Z |
5554494 | 5554494 | 20241119091702_WUgkF | US004B | 2024-11-20T14:02:17.868Z | 2024-11-22T14:19:42.047Z |
5554471 | 5554471 | 20241119091220_UDbiV | US004B | 2024-11-20T14:02:15.099Z | 2024-11-22T14:19:41.564Z |
5554449 | 5554449 | 20241119090234_l5D6V | US004B | 2024-11-20T14:02:09.498Z | 2024-11-22T14:19:41.084Z |
5554397 | 5554397 | 20241119084323_EKths | US004B | 2024-11-20T14:01:53.362Z | 2024-11-22T14:19:39.661Z |
5554272 | 5554272 | 20241119073925_BPEpA | US004B | 2024-11-20T14:01:21.725Z | 2024-11-22T14:19:34.743Z |
5554265 | 5554265 | 20241119073502_Nmu9y | US004B | 2024-11-20T14:01:19.324Z | 2024-11-22T14:19:34.492Z |
5554229 | 5554229 | 20241119071625_8KIao | US004B | 2024-11-20T14:01:12.441Z | 2024-11-22T14:19:34.115Z |
5554221 | 5554221 | 20241119071409_1vcr1 | US004B | 2024-11-20T14:01:11.115Z | 2024-11-22T14:19:33.916Z |
5554211 | 5554211 | 20241119070952_lHg5c | US004B | 2024-11-20T14:01:08.693Z | 2024-11-22T14:19:33.500Z |
5554191 | 5554191 | 20241119070026_OVjvH | US004B | 2024-11-20T14:01:03.863Z | 2024-11-22T14:19:32.487Z |
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);