participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,395 rows where station_code = "KR0024" 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 |
---|---|---|---|---|---|
5063084 | 5063084 | 20240909194830_6qGj8 | KR0024 | 2024-09-14T12:13:25.860Z | 2024-09-16T12:19:41.577Z |
5063067 | 5063067 | 20240909194728_wuMoQ | KR0024 | 2024-09-14T12:13:24.531Z | 2024-09-16T12:19:41.545Z |
5063039 | 5063039 | 20240909194209_o3ufe | KR0024 | 2024-09-14T12:13:21.656Z | 2024-09-16T12:19:41.382Z |
5063028 | 5063028 | 20240909194047_Hfm3S | KR0024 | 2024-09-14T12:13:20.226Z | 2024-09-16T12:19:41.374Z |
5062993 | 5062993 | 20240909193139_g3iCS | KR0024 | 2024-09-14T12:13:14.942Z | 2024-09-16T12:19:40.737Z |
5062984 | 5062984 | 20240909192749_2A3sT | KR0024 | 2024-09-14T12:13:13.716Z | 2024-09-16T12:19:40.710Z |
5062911 | 5062911 | 20240909185958_xLhaA | KR0024 | 2024-09-14T12:13:02.393Z | 2024-09-16T12:19:40.247Z |
5062867 | 5062867 | 20240909184534_7nQy3 | KR0024 | 2024-09-14T12:12:59.481Z | 2024-09-16T12:19:39.890Z |
5062830 | 5062830 | 20240909183456_MvFyR | KR0024 | 2024-09-14T12:12:55.796Z | 2024-09-16T12:19:39.765Z |
5062761 | 5062761 | 20240909181716_RBV1E | KR0024 | 2024-09-14T12:12:47.942Z | 2024-09-16T12:19:39.275Z |
5062750 | 5062750 | 20240909181327_COhaf | KR0024 | 2024-09-14T12:12:47.196Z | 2024-09-16T12:19:39.237Z |
5062744 | 5062744 | 20240909181124_Tuai6 | KR0024 | 2024-09-14T12:12:46.828Z | 2024-09-16T12:19:39.228Z |
5062710 | 5062710 | 20240909180350_Mo0TX | KR0024 | 2024-09-14T12:12:44.545Z | 2024-09-16T12:19:38.874Z |
5062703 | 5062703 | 20240909180323_Me516 | KR0024 | 2024-09-14T12:12:44.126Z | 2024-09-16T12:19:38.839Z |
5062697 | 5062697 | 20240909180258_0rc11 | KR0024 | 2024-09-14T12:12:43.825Z | 2024-09-16T12:19:38.822Z |
5062685 | 5062685 | 20240909180034_AGfVV | KR0024 | 2024-09-14T12:12:42.989Z | 2024-09-16T12:19:38.781Z |
5062657 | 5062657 | 20240909175643_sc518 | KR0024 | 2024-09-14T12:12:40.991Z | 2024-09-16T12:19:38.340Z |
5062632 | 5062632 | 20240909175106_ynnaI | KR0024 | 2024-09-14T12:12:38.887Z | 2024-09-16T12:19:38.251Z |
5062624 | 5062624 | 20240909175022_YLW0p | KR0024 | 2024-09-14T12:12:38.357Z | 2024-09-16T12:19:38.219Z |
5062617 | 5062617 | 20240909174833_FJ39f | KR0024 | 2024-09-14T12:12:37.800Z | 2024-09-16T12:19:38.201Z |
5062604 | 5062604 | 20240909174627_9SD4Z | KR0024 | 2024-09-14T12:12:36.506Z | 2024-09-16T12:19:38.012Z |
5062562 | 5062562 | 20240909174101_Vlc1B | KR0024 | 2024-09-14T12:12:33.372Z | 2024-09-16T12:19:37.769Z |
5061918 | 5061918 | 20240909162319_eX33F | KR0024 | 2024-09-14T12:11:38.796Z | 2024-09-16T12:19:34.683Z |
5061866 | 5061866 | 20240909161436_2lIeF | KR0024 | 2024-09-14T12:11:34.454Z | 2024-09-16T12:19:34.413Z |
5061752 | 5061752 | 20240909155123_GFfbJ | KR0024 | 2024-09-14T12:11:19.524Z | 2024-09-16T12:19:33.587Z |
5061747 | 5061747 | 20240909155018_O3zC7 | KR0024 | 2024-09-14T12:11:18.928Z | 2024-09-16T12:19:33.480Z |
5061654 | 5061654 | 20240909153746_2r7XR | KR0024 | 2024-09-14T12:11:06.803Z | 2024-09-16T12:19:32.941Z |
5061511 | 5061511 | 20240909151712_89Ttr | KR0024 | 2024-09-14T12:10:54.475Z | 2024-09-16T12:19:31.979Z |
5061502 | 5061502 | 20240909151617_DUjx5 | KR0024 | 2024-09-14T12:10:53.230Z | 2024-09-16T12:19:31.802Z |
5061311 | 5061311 | 20240909144458_iDhSk | KR0024 | 2024-09-14T12:10:41.467Z | 2024-09-16T12:19:30.525Z |
5061184 | 5061184 | 20240909142738_jpax8 | KR0024 | 2024-09-14T12:10:27.710Z | 2024-09-16T12:19:29.708Z |
5061074 | 5061074 | 20240909140520_oJODX | KR0024 | 2024-09-14T12:10:13.408Z | 2024-09-16T12:19:28.960Z |
5061021 | 5061021 | 20240909135250_yJ3GI | KR0024 | 2024-09-14T12:10:06.464Z | 2024-09-16T12:19:28.665Z |
5061015 | 5061015 | 20240909135119_K8XG3 | KR0024 | 2024-09-14T12:10:05.468Z | 2024-09-16T12:19:28.598Z |
5060965 | 5060965 | 20240909133802_c4BYI | KR0024 | 2024-09-14T12:10:00.013Z | 2024-09-16T12:19:28.437Z |
5059312 | 5059312 | 20240910172951_GkEfn | KR0024 | 2024-09-14T12:05:41.502Z | 2024-09-16T12:18:03.740Z |
5058660 | 5058660 | 20240910163425_2FhR5 | KR0024 | 2024-09-14T12:04:16.661Z | 2024-09-16T12:17:56.873Z |
5058334 | 5058334 | 20240910160525_xR20y | KR0024 | 2024-09-14T12:03:32.516Z | 2024-09-16T12:17:52.992Z |
5058146 | 5058146 | 20240910154756_y2Mrj | KR0024 | 2024-09-14T12:03:02.063Z | 2024-09-16T12:17:50.652Z |
5057793 | 5057793 | 20240910151342_2ZJ5w | KR0024 | 2024-09-14T12:02:04.680Z | 2024-09-16T12:17:47.741Z |
5057637 | 5057637 | 20240910145821_22GHe | KR0024 | 2024-09-14T12:01:36.234Z | 2024-09-16T12:17:45.717Z |
5057351 | 5057351 | 20240910141335_6siN6 | KR0024 | 2024-09-14T12:00:54.077Z | 2024-09-16T12:17:42.828Z |
5050413 | 5050413 | 20240907151859_LHB2g | KR0024 | 2024-09-13T12:13:30.781Z | 2024-09-16T12:20:57.582Z |
5050336 | 5050336 | 20240907151126_pZeT6 | KR0024 | 2024-09-13T12:13:26.037Z | 2024-09-16T12:20:57.195Z |
5050134 | 5050134 | 20240909125355_fmwjI | KR0024 | 2024-09-13T12:12:42.414Z | 2024-09-16T12:20:45.744Z |
5044008 | 5044008 | 20240908135148_5Y1Ho | KR0024 | 2024-09-13T12:01:14.739Z | 2024-09-16T12:20:19.659Z |
5043212 | 5043212 | 20240907140749_VcfPw | KR0024 | 2024-09-12T12:17:25.316Z | 2024-09-16T12:20:55.896Z |
5018693 | 5018693 | 20240904193701_mDnFu | KR0024 | 2024-09-10T12:11:17.274Z | 2024-09-13T12:19:48.532Z |
5018677 | 5018677 | 20240904193042_KBDqu | KR0024 | 2024-09-10T12:11:11.918Z | 2024-09-13T12:19:48.510Z |
5018666 | 5018666 | 20240904192745_j93AC | KR0024 | 2024-09-10T12:11:10.071Z | 2024-09-13T12:19:48.455Z |
5018663 | 5018663 | 20240904192711_U1MTS | KR0024 | 2024-09-10T12:11:09.894Z | 2024-09-13T12:19:48.453Z |
5018623 | 5018623 | 20240904191329_dVi2o | KR0024 | 2024-09-10T12:11:00.628Z | 2024-09-13T12:19:48.338Z |
5018553 | 5018553 | 20240904184747_Yy2In | KR0024 | 2024-09-10T12:10:50.730Z | 2024-09-13T12:19:48.148Z |
5018548 | 5018548 | 20240904184640_0WP1t | KR0024 | 2024-09-10T12:10:50.334Z | 2024-09-13T12:19:48.146Z |
5018509 | 5018509 | 20240904182906_cYE6E | KR0024 | 2024-09-10T12:10:44.788Z | 2024-09-13T12:19:47.994Z |
5018484 | 5018484 | 20240904182215_XJJ6h | KR0024 | 2024-09-10T12:10:42.070Z | 2024-09-13T12:19:47.955Z |
5018416 | 5018416 | 20240904180217_yFNpi | KR0024 | 2024-09-10T12:10:35.732Z | 2024-09-13T12:19:47.867Z |
5018413 | 5018413 | 20240904180208_F3UxM | KR0024 | 2024-09-10T12:10:35.395Z | 2024-09-13T12:19:47.848Z |
5018389 | 5018389 | 20240904175456_BEdRK | KR0024 | 2024-09-10T12:10:33.095Z | 2024-09-13T12:19:47.734Z |
5018365 | 5018365 | 20240904174858_73eGa | KR0024 | 2024-09-10T12:10:31.082Z | 2024-09-13T12:19:47.656Z |
5018271 | 5018271 | 20240904173500_zMD36 | KR0024 | 2024-09-10T12:10:18.446Z | 2024-09-13T12:19:47.506Z |
5018196 | 5018196 | 20240904172433_sqNRQ | KR0024 | 2024-09-10T12:10:08.787Z | 2024-09-13T12:19:47.385Z |
5018116 | 5018116 | 20240904171205_d9rui | KR0024 | 2024-09-10T12:10:01.377Z | 2024-09-13T12:19:47.211Z |
5018041 | 5018041 | 20240904170637_RAgKa | KR0024 | 2024-09-10T12:09:55.038Z | 2024-09-13T12:19:47.167Z |
5017200 | 5017200 | 20240904154124_kWjPm | KR0024 | 2024-09-10T12:08:55.708Z | 2024-09-13T12:19:46.636Z |
5016772 | 5016772 | 20240904145134_eu43t | KR0024 | 2024-09-10T12:08:16.320Z | 2024-09-13T12:19:46.302Z |
5016622 | 5016622 | 20240904143250_MHhNi | KR0024 | 2024-09-10T12:08:01.125Z | 2024-09-13T12:19:45.925Z |
5016482 | 5016482 | 20240904142017_leIcW | KR0024 | 2024-09-10T12:07:52.846Z | 2024-09-13T12:19:45.819Z |
5016475 | 5016475 | 20240904141852_3aShX | KR0024 | 2024-09-10T12:07:52.337Z | 2024-09-13T12:19:45.812Z |
5016028 | 5016028 | 20240904132119_wDVGo | KR0024 | 2024-09-10T12:07:13.815Z | 2024-09-13T12:19:45.138Z |
5016012 | 5016012 | 20240904131842_ijTTY | KR0024 | 2024-09-10T12:07:11.779Z | 2024-09-13T12:19:45.126Z |
5015806 | 5015806 | 20240904123906_pfo4i | KR0024 | 2024-09-10T12:06:48.016Z | 2024-09-13T12:19:44.713Z |
5015729 | 5015729 | 20240904122022_olT9n | KR0024 | 2024-09-10T12:06:42.158Z | 2024-09-13T12:19:44.627Z |
5007047 | 5007047 | 20240903195101_j3oKe | KR0024 | 2024-09-09T12:05:21.337Z | 2024-09-12T12:19:11.184Z |
5007029 | 5007029 | 20240903194840_VkzcX | KR0024 | 2024-09-09T12:05:20.701Z | 2024-09-12T12:19:11.158Z |
5006996 | 5006996 | 20240903194211_mnEkS | KR0024 | 2024-09-09T12:05:18.579Z | 2024-09-12T12:19:11.042Z |
5006954 | 5006954 | 20240903193523_25CN7 | KR0024 | 2024-09-09T12:05:15.347Z | 2024-09-12T12:19:10.961Z |
5006933 | 5006933 | 20240903193221_zbKS6 | KR0024 | 2024-09-09T12:05:13.885Z | 2024-09-12T12:19:10.897Z |
5006884 | 5006884 | 20240903191912_WhBj4 | KR0024 | 2024-09-09T12:05:10.777Z | 2024-09-12T12:19:10.773Z |
5006326 | 5006326 | 20240903172325_4Bt6w | KR0024 | 2024-09-09T12:04:30.986Z | 2024-09-12T12:19:08.137Z |
5006090 | 5006090 | 20240903165343_21HUD | KR0024 | 2024-09-09T12:04:19.944Z | 2024-09-12T12:19:07.628Z |
5006028 | 5006028 | 20240903164547_d8aKt | KR0024 | 2024-09-09T12:04:17.189Z | 2024-09-12T12:19:07.240Z |
5006001 | 5006001 | 20240903164046_9lXT2 | KR0024 | 2024-09-09T12:04:15.929Z | 2024-09-12T12:19:07.180Z |
5005597 | 5005597 | 20240903154136_DCMPt | KR0024 | 2024-09-09T12:03:50.561Z | 2024-09-12T12:19:06.229Z |
5005515 | 5005515 | 20240903152703_3HOhu | KR0024 | 2024-09-09T12:03:47.081Z | 2024-09-12T12:19:06.121Z |
5005402 | 5005402 | 20240903150637_pjy3I | KR0024 | 2024-09-09T12:03:40.972Z | 2024-09-12T12:19:05.881Z |
5005364 | 5005364 | 20240903145905_pMu58 | KR0024 | 2024-09-09T12:03:38.809Z | 2024-09-12T12:19:05.815Z |
5005330 | 5005330 | 20240903145412_O0UKm | KR0024 | 2024-09-09T12:03:37.239Z | 2024-09-12T12:19:05.756Z |
5005219 | 5005219 | 20240903143202_1ztYi | KR0024 | 2024-09-09T12:03:27.233Z | 2024-09-12T12:19:05.486Z |
5005188 | 5005188 | 20240903142652_FuHDl | KR0024 | 2024-09-09T12:03:25.624Z | 2024-09-12T12:19:05.431Z |
5005149 | 5005149 | 20240903141234_Oq2VK | KR0024 | 2024-09-09T12:03:22.862Z | 2024-09-12T12:19:05.365Z |
5004857 | 5004857 | 20240903130715_rN9KF | KR0024 | 2024-09-09T12:03:08.125Z | 2024-09-12T12:19:04.354Z |
5002781 | 5002781 | 20240904104323_zf2Nd | KR0024 | 2024-09-09T12:01:02.129Z | 2024-09-13T12:19:42.120Z |
4988014 | 4988014 | 20240901194011_DI7UW | KR0024 | 2024-09-07T12:06:41.703Z | 2024-09-10T12:19:12.269Z |
4987959 | 4987959 | 20240901192547_7xBwq | KR0024 | 2024-09-07T12:06:34.100Z | 2024-09-10T12:19:12.082Z |
4987750 | 4987750 | 20240901184756_jkq5A | KR0024 | 2024-09-07T12:06:13.368Z | 2024-09-10T12:19:11.276Z |
4963179 | 4963179 | 20240811194905_tYyZB | KR0024 | 2024-09-04T12:05:17.806Z | 2024-09-06T12:04:21.395Z |
4963100 | 4963100 | 20240811194313_jR4Cq | KR0024 | 2024-09-04T12:05:10.704Z | 2024-09-06T12:04:18.218Z |
4963040 | 4963040 | 20240811193846_Pvw2P | KR0024 | 2024-09-04T12:05:07.538Z | 2024-09-06T12:04:15.756Z |
4963005 | 4963005 | 20240811193710_HFs2y | KR0024 | 2024-09-04T12:05:05.735Z | 2024-09-06T12:04:14.648Z |
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);