participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
11,352 rows where station_code = "HR000S" 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 |
---|---|---|---|---|---|
5124778 | 5124778 | 20240917220055_0xiRk | HR000S | 2024-09-19T12:01:34.503Z | 2024-09-19T12:06:41.934Z |
5124720 | 5124720 | 20240917215408_rSeS3 | HR000S | 2024-09-19T12:01:22.853Z | 2024-09-19T12:06:41.928Z |
5124542 | 5124542 | 20240917210122_XWSZh | HR000S | 2024-09-19T12:01:06.296Z | 2024-09-19T12:06:41.908Z |
5110467 | 5110467 | 20240911020422_Mw5nt | HR000S | 2024-09-17T12:18:00.717Z | 2024-09-19T12:21:40.573Z |
5091322 | 5091322 | 20240912020502_Mkf4n | HR000S | 2024-09-16T12:13:00.201Z | 2024-09-19T12:21:12.813Z |
5090669 | 5090669 | 20240912013909_v5gsR | HR000S | 2024-09-16T12:12:28.742Z | 2024-09-19T12:21:11.586Z |
5089982 | 5089982 | 20240912010522_5NfAN | HR000S | 2024-09-16T12:11:53.273Z | 2024-09-19T12:21:10.889Z |
5088948 | 5088948 | 20240912001503_KMJX8 | HR000S | 2024-09-16T12:11:10.254Z | 2024-09-19T12:21:09.633Z |
5079898 | 5079898 | 20240911031931_1TccY | HR000S | 2024-09-15T12:16:40.699Z | 2024-09-19T12:21:42.777Z |
5079630 | 5079630 | 20240911030655_hZMAu | HR000S | 2024-09-15T12:16:32.097Z | 2024-09-19T12:21:42.536Z |
5079391 | 5079391 | 20240911025246_bY1fA | HR000S | 2024-09-15T12:16:19.154Z | 2024-09-19T12:21:41.571Z |
5078908 | 5078908 | 20240911022024_WbOIS | HR000S | 2024-09-15T12:15:55.443Z | 2024-09-19T12:21:40.811Z |
5078755 | 5078755 | 20240911021430_IaeVY | HR000S | 2024-09-15T12:15:51.094Z | 2024-09-19T12:21:40.699Z |
5078610 | 5078610 | 20240911020603_nLvlT | HR000S | 2024-09-15T12:15:45.024Z | 2024-09-19T12:21:40.590Z |
5078378 | 5078378 | 20240911015203_cUCxF | HR000S | 2024-09-15T12:15:37.008Z | 2024-09-19T12:21:40.328Z |
5078293 | 5078293 | 20240911014853_bBNzN | HR000S | 2024-09-15T12:15:32.523Z | 2024-09-19T12:21:40.185Z |
5077796 | 5077796 | 20240911011902_3uYIN | HR000S | 2024-09-15T12:15:05.771Z | 2024-09-19T12:21:39.653Z |
5077405 | 5077405 | 20240911004932_aMqkO | HR000S | 2024-09-15T12:14:43.093Z | 2024-09-19T12:21:38.970Z |
5076941 | 5076941 | 20240911001453_Ggn54 | HR000S | 2024-09-15T12:14:13.687Z | 2024-09-19T12:21:37.864Z |
5076846 | 5076846 | 20240911001034_gdbLC | HR000S | 2024-09-15T12:14:06.636Z | 2024-09-19T12:21:37.621Z |
5076771 | 5076771 | 20240911000743_mARg9 | HR000S | 2024-09-15T12:14:01.454Z | 2024-09-19T12:21:37.565Z |
5076244 | 5076244 | 20240910231642_hOr1F | HR000S | 2024-09-15T12:13:24.818Z | 2024-09-19T12:21:36.656Z |
5075379 | 5075379 | 20240911234442_Ra5QF | HR000S | 2024-09-15T12:09:40.018Z | 2024-09-19T12:21:09.178Z |
5074940 | 5074940 | 20240911231758_zsaqN | HR000S | 2024-09-15T12:09:14.756Z | 2024-09-19T12:21:07.942Z |
5074285 | 5074285 | 20240911222845_Gsl1U | HR000S | 2024-09-15T12:08:17.556Z | 2024-09-19T12:21:07.024Z |
5071757 | 5071757 | 20240911181049_lncOH | HR000S | 2024-09-15T12:03:26.104Z | 2024-09-19T12:21:02.643Z |
5069711 | 5069711 | 20240910215955_KntfJ | HR000S | 2024-09-14T12:20:04.652Z | 2024-09-19T12:21:35.260Z |
5060785 | 5060785 | 20240910210617_wZg4W | HR000S | 2024-09-14T12:09:32.895Z | 2024-09-19T12:21:33.596Z |
5060726 | 5060726 | 20240910205713_KQ2OM | HR000S | 2024-09-14T12:09:25.639Z | 2024-09-19T12:21:33.511Z |
5060707 | 5060707 | 20240910205435_8XpcM | HR000S | 2024-09-14T12:09:24.432Z | 2024-09-19T12:21:33.493Z |
5060552 | 5060552 | 20240910203741_3ap0U | HR000S | 2024-09-14T12:09:07.849Z | 2024-09-19T12:21:32.656Z |
5060469 | 5060469 | 20240910203223_LyDY7 | HR000S | 2024-09-14T12:08:50.503Z | 2024-09-19T12:21:32.423Z |
5060240 | 5060240 | 20240910201021_D4926 | HR000S | 2024-09-14T12:08:31.912Z | 2024-09-19T12:21:32.011Z |
5060142 | 5060142 | 20240910195845_I2ByO | HR000S | 2024-09-14T12:08:21.193Z | 2024-09-19T12:21:31.864Z |
5054367 | 5054367 | 20240908024255_aMsfT | HR000S | 2024-09-13T12:16:39.526Z | 2024-09-16T12:21:15.408Z |
5054140 | 5054140 | 20240908021552_7NRUd | HR000S | 2024-09-13T12:16:31.311Z | 2024-09-16T12:21:14.138Z |
5054056 | 5054056 | 20240908020456_EHKKM | HR000S | 2024-09-13T12:16:27.651Z | 2024-09-16T12:21:13.854Z |
5053976 | 5053976 | 20240908015641_W8X9E | HR000S | 2024-09-13T12:16:24.817Z | 2024-09-16T12:21:13.409Z |
5053967 | 5053967 | 20240908015622_gZfFU | HR000S | 2024-09-13T12:16:24.481Z | 2024-09-16T12:21:13.400Z |
5053716 | 5053716 | 20240908012052_bquy5 | HR000S | 2024-09-13T12:16:14.993Z | 2024-09-16T12:21:12.511Z |
5053704 | 5053704 | 20240908011942_ieOWo | HR000S | 2024-09-13T12:16:14.390Z | 2024-09-16T12:21:12.462Z |
5053681 | 5053681 | 20240908011646_6rR9b | HR000S | 2024-09-13T12:16:13.305Z | 2024-09-16T12:21:12.405Z |
5053606 | 5053606 | 20240908010611_7T5GU | HR000S | 2024-09-13T12:16:10.149Z | 2024-09-16T12:21:12.160Z |
5053527 | 5053527 | 20240908005214_07Mi2 | HR000S | 2024-09-13T12:16:07.735Z | 2024-09-16T12:21:11.859Z |
5053457 | 5053457 | 20240908003821_Iv2X0 | HR000S | 2024-09-13T12:16:04.815Z | 2024-09-16T12:21:11.287Z |
5053429 | 5053429 | 20240908003442_glCwL | HR000S | 2024-09-13T12:16:03.751Z | 2024-09-16T12:21:10.592Z |
5053366 | 5053366 | 20240908002035_63qX1 | HR000S | 2024-09-13T12:16:00.455Z | 2024-09-16T12:21:10.421Z |
5053108 | 5053108 | 20240907232951_fWt7u | HR000S | 2024-09-13T12:15:46.926Z | 2024-09-16T12:21:09.516Z |
5052879 | 5052879 | 20240907222927_unJeD | HR000S | 2024-09-13T12:15:34.043Z | 2024-09-16T12:21:08.392Z |
5052820 | 5052820 | 20240907221217_NwPeL | HR000S | 2024-09-13T12:15:29.401Z | 2024-09-16T12:21:07.984Z |
5052591 | 5052591 | 20240907211125_aXG7g | HR000S | 2024-09-13T12:15:14.771Z | 2024-09-16T12:21:06.586Z |
5052502 | 5052502 | 20240907205546_Lbal7 | HR000S | 2024-09-13T12:15:11.937Z | 2024-09-16T12:21:06.001Z |
5032845 | 5032845 | 20240907015517_edDQM | HR000S | 2024-09-12T12:08:09.515Z | 2024-09-15T12:21:28.046Z |
5032571 | 5032571 | 20240907011656_2TBjn | HR000S | 2024-09-12T12:07:41.129Z | 2024-09-15T12:21:26.800Z |
5032549 | 5032549 | 20240907011336_BleRh | HR000S | 2024-09-12T12:07:39.482Z | 2024-09-15T12:21:26.747Z |
5032546 | 5032546 | 20240907011331_bQKAw | HR000S | 2024-09-12T12:07:37.452Z | 2024-09-15T12:21:26.744Z |
5032532 | 5032532 | 20240907011220_FV3AN | HR000S | 2024-09-12T12:07:32.502Z | 2024-09-15T12:21:26.707Z |
5032130 | 5032130 | 20240907001705_t9H9G | HR000S | 2024-09-12T12:06:35.719Z | 2024-09-15T12:21:25.303Z |
5031483 | 5031483 | 20240906220629_wU83J | HR000S | 2024-09-12T12:05:01.686Z | 2024-09-15T12:21:22.706Z |
5031330 | 5031330 | 20240906212645_EE8il | HR000S | 2024-09-12T12:04:32.362Z | 2024-09-15T12:21:22.028Z |
5009741 | 5009741 | 20240904015602_Q1KTw | HR000S | 2024-09-09T12:07:59.400Z | 2024-09-12T12:19:24.180Z |
5009410 | 5009410 | 20240904012059_DjNQl | HR000S | 2024-09-09T12:07:42.973Z | 2024-09-12T12:19:22.704Z |
5009239 | 5009239 | 20240904010600_3I4H6 | HR000S | 2024-09-09T12:07:31.765Z | 2024-09-12T12:19:22.108Z |
5008614 | 5008614 | 20240904000320_eL3Rt | HR000S | 2024-09-09T12:06:55.443Z | 2024-09-12T12:19:18.341Z |
5008168 | 5008168 | 20240903230939_N2r6a | HR000S | 2024-09-09T12:06:29.638Z | 2024-09-12T12:19:16.340Z |
5007801 | 5007801 | 20240903222621_DY2h7 | HR000S | 2024-09-09T12:06:08.740Z | 2024-09-12T12:19:14.999Z |
5007721 | 5007721 | 20240903220531_Z3PcF | HR000S | 2024-09-09T12:06:04.048Z | 2024-09-12T12:19:14.596Z |
5007551 | 5007551 | 20240903213854_YCGw7 | HR000S | 2024-09-09T12:05:53.097Z | 2024-09-12T12:19:13.751Z |
5007524 | 5007524 | 20240903213301_UME6h | HR000S | 2024-09-09T12:05:51.851Z | 2024-09-12T12:19:13.648Z |
5007224 | 5007224 | 20240903202827_RmHmS | HR000S | 2024-09-09T12:05:36.794Z | 2024-09-12T12:19:12.145Z |
4997757 | 4997757 | 20240903012516_IiLKY | HR000S | 2024-09-08T12:06:46.669Z | 2024-09-11T12:21:08.334Z |
4997742 | 4997742 | 20240903012045_TFLJE | HR000S | 2024-09-08T12:06:45.871Z | 2024-09-11T12:21:08.114Z |
4997516 | 4997516 | 20240903003405_GI7ah | HR000S | 2024-09-08T12:06:23.496Z | 2024-09-11T12:21:05.261Z |
4997348 | 4997348 | 20240902235818_yN0cQ | HR000S | 2024-09-08T12:06:07.090Z | 2024-09-11T12:21:03.597Z |
4997198 | 4997198 | 20240902232228_OB3WV | HR000S | 2024-09-08T12:05:53.494Z | 2024-09-11T12:21:02.036Z |
4997150 | 4997150 | 20240902231523_HriI7 | HR000S | 2024-09-08T12:05:50.678Z | 2024-09-11T12:21:01.623Z |
4997137 | 4997137 | 20240902231336_jcjTr | HR000S | 2024-09-08T12:05:49.432Z | 2024-09-11T12:21:01.533Z |
4996964 | 4996964 | 20240902221031_dCqQB | HR000S | 2024-09-08T12:05:30.001Z | 2024-09-11T12:20:59.459Z |
4996837 | 4996837 | 20240902211509_kjFRh | HR000S | 2024-09-08T12:05:20.476Z | 2024-09-11T12:20:58.434Z |
4996464 | 4996464 | 20240902194302_mDivZ | HR000S | 2024-09-08T12:04:50.615Z | 2024-09-11T12:20:54.686Z |
4996305 | 4996305 | 20240902191318_40bl3 | HR000S | 2024-09-08T12:04:41.005Z | 2024-09-11T12:20:52.815Z |
4989252 | 4989252 | 20240901230131_oBNKN | HR000S | 2024-09-07T12:08:41.759Z | 2024-09-10T12:19:17.210Z |
4989141 | 4989141 | 20240901224429_E9uXN | HR000S | 2024-09-07T12:08:33.535Z | 2024-09-10T12:19:16.899Z |
4988994 | 4988994 | 20240901221850_lDyNp | HR000S | 2024-09-07T12:08:19.228Z | 2024-09-10T12:19:16.294Z |
4988822 | 4988822 | 20240901213839_gxzjU | HR000S | 2024-09-07T12:07:59.220Z | 2024-09-10T12:19:15.608Z |
4988565 | 4988565 | 20240901210605_79EVt | HR000S | 2024-09-07T12:07:41.139Z | 2024-09-10T12:19:14.682Z |
4988358 | 4988358 | 20240901203648_FXDZ5 | HR000S | 2024-09-07T12:07:17.966Z | 2024-09-10T12:19:13.628Z |
4983152 | 4983152 | 20240812004149_Z2bJm | HR000S | 2024-09-06T12:15:17.681Z | 2024-09-06T12:15:17.681Z |
4982727 | 4982727 | 20240812003639_nigfS | HR000S | 2024-09-06T12:15:00.231Z | 2024-09-06T12:15:00.231Z |
4982325 | 4982325 | 20240812003235_VN3c0 | HR000S | 2024-09-06T12:14:49.569Z | 2024-09-06T12:14:49.569Z |
4982029 | 4982029 | 20240812002923_dYLTU | HR000S | 2024-09-06T12:14:41.695Z | 2024-09-06T12:14:41.695Z |
4981782 | 4981782 | 20240812002726_fgxYa | HR000S | 2024-09-06T12:14:37.753Z | 2024-09-06T12:14:37.753Z |
4981264 | 4981264 | 20240812002004_FaOBb | HR000S | 2024-09-06T12:14:29.039Z | 2024-09-06T12:14:29.039Z |
4981214 | 4981214 | 20240812001938_4sf9N | HR000S | 2024-09-06T12:14:27.950Z | 2024-09-06T12:14:27.950Z |
4980207 | 4980207 | 20240812000957_9nABf | HR000S | 2024-09-06T12:13:52.917Z | 2024-09-06T12:13:52.917Z |
4979969 | 4979969 | 20240812000700_jjcT6 | HR000S | 2024-09-06T12:13:39.042Z | 2024-09-06T12:13:39.042Z |
4979378 | 4979378 | 20240812000141_9luqy | HR000S | 2024-09-06T12:13:13.183Z | 2024-09-06T12:13:13.183Z |
4979060 | 4979060 | 20240811235852_xAiWW | HR000S | 2024-09-06T12:12:54.976Z | 2024-09-06T12:12:54.976Z |
4978696 | 4978696 | 20240811235409_3K2rU | HR000S | 2024-09-06T12:12:41.122Z | 2024-09-06T12:12:41.122Z |
4978430 | 4978430 | 20240811235043_AYU2A | HR000S | 2024-09-06T12:12:33.583Z | 2024-09-06T12:12:33.583Z |
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);