participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,755 rows where station_code = "KR0017" 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 |
---|---|---|---|---|---|
5430031 | 5430031 | 20241028204957_rgQLL | KR0017 | 2024-10-31T12:17:25.759Z | 2024-11-03T14:24:59.664Z |
5426247 | 5426247 | 20241029191713_EY4aO | KR0017 | 2024-10-31T12:09:43.267Z | 2024-11-03T14:23:53.096Z |
5425968 | 5425968 | 20241029182216_kxvdc | KR0017 | 2024-10-31T12:09:01.524Z | 2024-11-03T14:23:48.672Z |
5425936 | 5425936 | 20241029181815_Q5hfC | KR0017 | 2024-10-31T12:08:59.202Z | 2024-11-03T14:23:48.561Z |
5425846 | 5425846 | 20241029180307_6gY2W | KR0017 | 2024-10-31T12:08:50.756Z | 2024-11-03T14:23:46.861Z |
5425827 | 5425827 | 20241029180155_n8Bvv | KR0017 | 2024-10-31T12:08:49.597Z | 2024-11-03T14:23:46.766Z |
5425780 | 5425780 | 20241029175447_Yrj3c | KR0017 | 2024-10-31T12:08:38.195Z | 2024-11-03T14:23:46.322Z |
5425730 | 5425730 | 20241029174649_KmpSE | KR0017 | 2024-10-31T12:08:27.208Z | 2024-11-03T14:23:46.176Z |
5425684 | 5425684 | 20241029173723_yMawe | KR0017 | 2024-10-31T12:08:19.209Z | 2024-11-03T14:23:45.888Z |
5425599 | 5425599 | 20241029172039_M1ZIb | KR0017 | 2024-10-31T12:08:10.616Z | 2024-11-03T14:23:45.415Z |
5425562 | 5425562 | 20241029171241_fpaib | KR0017 | 2024-10-31T12:08:06.724Z | 2024-11-03T14:23:45.012Z |
5425534 | 5425534 | 20241029170711_QA3xV | KR0017 | 2024-10-31T12:08:03.662Z | 2024-11-03T14:23:44.613Z |
5425500 | 5425500 | 20241029170246_Zy5yv | KR0017 | 2024-10-31T12:07:56.032Z | 2024-11-03T14:23:43.896Z |
5425495 | 5425495 | 20241029170149_lmQCL | KR0017 | 2024-10-31T12:07:54.365Z | 2024-11-03T14:23:43.629Z |
5425309 | 5425309 | 20241029162437_WVSlE | KR0017 | 2024-10-31T12:07:27.194Z | 2024-11-03T14:23:42.161Z |
5425244 | 5425244 | 20241029161346_a80Ck | KR0017 | 2024-10-31T12:07:20.145Z | 2024-11-03T14:23:41.485Z |
5425025 | 5425025 | 20241029154309_3fJEx | KR0017 | 2024-10-31T12:06:41.511Z | 2024-11-03T14:23:40.358Z |
5424816 | 5424816 | 20241029151645_l3Q8k | KR0017 | 2024-10-31T12:06:05.274Z | 2024-11-03T14:23:39.303Z |
5424544 | 5424544 | 20241029144234_v4aDJ | KR0017 | 2024-10-31T12:05:20.763Z | 2024-11-03T14:23:38.052Z |
5424531 | 5424531 | 20241029144041_QVqCg | KR0017 | 2024-10-31T12:05:18.971Z | 2024-11-03T14:23:38.013Z |
5424007 | 5424007 | 20241029123542_PHYVY | KR0017 | 2024-10-31T12:03:33.395Z | 2024-11-03T14:23:33.891Z |
5423969 | 5423969 | 20241029123024_UUST2 | KR0017 | 2024-10-31T12:03:20.988Z | 2024-11-03T14:23:33.429Z |
5423591 | 5423591 | 20241029110615_e52Cq | KR0017 | 2024-10-31T12:02:04.913Z | 2024-11-03T14:23:28.800Z |
5392000 | 5392000 | 20241026143246_7XW8n | KR0017 | 2024-10-28T12:07:01.530Z | 2024-11-03T14:26:16.328Z |
5390813 | 5390813 | 20241026103337_VgxI6 | KR0017 | 2024-10-28T12:04:03.122Z | 2024-11-03T14:26:12.842Z |
5381417 | 5381417 | 20241025181044_gzB81 | KR0017 | 2024-10-27T12:08:25.653Z | 2024-11-03T14:27:16.206Z |
5381372 | 5381372 | 20241025173954_mK52g | KR0017 | 2024-10-27T12:08:21.297Z | 2024-11-03T14:27:15.403Z |
5381331 | 5381331 | 20241025170521_oyjcD | KR0017 | 2024-10-27T12:08:16.515Z | 2024-11-03T14:27:14.936Z |
5381320 | 5381320 | 20241025165618_LCNA2 | KR0017 | 2024-10-27T12:08:15.114Z | 2024-11-03T14:27:14.648Z |
5381310 | 5381310 | 20241025164218_HrLP6 | KR0017 | 2024-10-27T12:08:14.115Z | 2024-11-03T14:27:14.442Z |
5371735 | 5371735 | 20241024151603_g9pbE | KR0017 | 2024-10-26T12:12:29.977Z | 2024-11-02T12:28:22.728Z |
5371360 | 5371360 | 20241024144515_ESqGr | KR0017 | 2024-10-26T12:11:47.155Z | 2024-11-02T12:28:22.088Z |
5371146 | 5371146 | 20241024142646_nZZsU | KR0017 | 2024-10-26T12:11:16.239Z | 2024-11-02T12:28:21.835Z |
5370661 | 5370661 | 20241024133453_mHyLW | KR0017 | 2024-10-26T12:10:07.816Z | 2024-11-02T12:28:21.032Z |
5369655 | 5369655 | 20241024114359_Y3Ut6 | KR0017 | 2024-10-26T12:07:30.612Z | 2024-11-02T12:28:18.988Z |
5362788 | 5362788 | 20241023200032_SdNlI | KR0017 | 2024-10-25T12:15:07.643Z | 2024-11-01T12:26:52.444Z |
5362151 | 5362151 | 20241023191218_Cz6yL | KR0017 | 2024-10-25T12:13:56.624Z | 2024-11-01T12:26:51.048Z |
5362137 | 5362137 | 20241023191051_aPsTt | KR0017 | 2024-10-25T12:13:55.814Z | 2024-11-01T12:26:51.038Z |
5361660 | 5361660 | 20241023183404_PnkaP | KR0017 | 2024-10-25T12:13:05.484Z | 2024-11-01T12:26:50.414Z |
5361617 | 5361617 | 20241023182931_6k9V1 | KR0017 | 2024-10-25T12:13:01.823Z | 2024-11-01T12:26:50.380Z |
5361531 | 5361531 | 20241023182512_Qu9Vp | KR0017 | 2024-10-25T12:12:52.531Z | 2024-11-01T12:26:50.296Z |
5361450 | 5361450 | 20241023181749_L7LTg | KR0017 | 2024-10-25T12:12:41.659Z | 2024-11-01T12:26:50.181Z |
5361443 | 5361443 | 20241023181749_oKyXZ | KR0017 | 2024-10-25T12:12:41.511Z | 2024-11-01T12:26:50.177Z |
5361372 | 5361372 | 20241023180943_MeRr1 | KR0017 | 2024-10-25T12:12:37.207Z | 2024-11-01T12:26:49.837Z |
5361335 | 5361335 | 20241023180817_lwLNU | KR0017 | 2024-10-25T12:12:35.520Z | 2024-11-01T12:26:49.776Z |
5361222 | 5361222 | 20241023180130_1zIRT | KR0017 | 2024-10-25T12:12:28.648Z | 2024-11-01T12:26:49.525Z |
5361102 | 5361102 | 20241023174941_2LLrP | KR0017 | 2024-10-25T12:12:20.114Z | 2024-11-01T12:26:48.870Z |
5360704 | 5360704 | 20241023165833_q3QSY | KR0017 | 2024-10-25T12:11:24.975Z | 2024-11-01T12:26:47.802Z |
5360465 | 5360465 | 20241023162318_3BN9v | KR0017 | 2024-10-25T12:10:57.499Z | 2024-11-01T12:26:47.459Z |
5359938 | 5359938 | 20241023150602_oKL1i | KR0017 | 2024-10-25T12:09:38.767Z | 2024-11-01T12:26:46.882Z |
5359603 | 5359603 | 20241023140858_wI35t | KR0017 | 2024-10-25T12:08:53.087Z | 2024-11-01T12:26:45.970Z |
5359298 | 5359298 | 20241023130945_44Rai | KR0017 | 2024-10-25T12:08:06.051Z | 2024-11-01T12:26:45.394Z |
5359123 | 5359123 | 20241023123222_Y5ASh | KR0017 | 2024-10-25T12:07:40.459Z | 2024-11-01T12:26:44.878Z |
5325496 | 5325496 | 20241020155048_biwmD | KR0017 | 2024-10-21T12:05:58.280Z | 2024-10-29T12:26:31.263Z |
5325468 | 5325468 | 20241020153921_iKGzn | KR0017 | 2024-10-21T12:05:53.855Z | 2024-10-29T12:26:31.188Z |
5325416 | 5325416 | 20241020151953_VUIm3 | KR0017 | 2024-10-21T12:05:48.223Z | 2024-10-29T12:26:31.137Z |
5325410 | 5325410 | 20241020151950_c83EG | KR0017 | 2024-10-21T12:05:47.900Z | 2024-10-29T12:26:31.136Z |
5325403 | 5325403 | 20241020151614_c3KKz | KR0017 | 2024-10-21T12:05:47.592Z | 2024-10-29T12:26:31.135Z |
5325124 | 5325124 | 20241020131513_rhGCh | KR0017 | 2024-10-21T12:05:03.375Z | 2024-10-29T12:26:30.683Z |
5322949 | 5322949 | 20241019193806_IkN2q | KR0017 | 2024-10-20T12:03:36.572Z | 2024-10-28T12:26:42.271Z |
5322918 | 5322918 | 20241019190536_pyjEB | KR0017 | 2024-10-20T12:03:31.854Z | 2024-10-28T12:26:42.108Z |
5322916 | 5322916 | 20241019190409_kxq1d | KR0017 | 2024-10-20T12:03:31.521Z | 2024-10-28T12:26:42.061Z |
5322882 | 5322882 | 20241019180313_cGThQ | KR0017 | 2024-10-20T12:03:26.165Z | 2024-10-28T12:26:41.508Z |
5322874 | 5322874 | 20241019174342_sYbwj | KR0017 | 2024-10-20T12:03:25.213Z | 2024-10-28T12:26:41.451Z |
5322866 | 5322866 | 20241019173238_MO4uT | KR0017 | 2024-10-20T12:03:23.695Z | 2024-10-28T12:26:41.440Z |
5322862 | 5322862 | 20241019170405_AoDEt | KR0017 | 2024-10-20T12:03:22.979Z | 2024-10-28T12:26:41.431Z |
5297687 | 5297687 | 20241012141128_jo5aT | KR0017 | 2024-10-14T12:08:59.990Z | 2024-10-21T12:23:21.903Z |
5273100 | 5273100 | 20241009162325_h2eh8 | KR0017 | 2024-10-11T12:12:00.681Z | 2024-10-18T12:21:59.716Z |
5266164 | 5266164 | 20241008132240_lc612 | KR0017 | 2024-10-10T12:11:26.307Z | 2024-10-17T12:20:02.953Z |
5266090 | 5266090 | 20241008125602_6z2nh | KR0017 | 2024-10-10T12:11:11.799Z | 2024-10-17T12:20:02.805Z |
5265144 | 5265144 | 20241009110810_Ln31Z | KR0017 | 2024-10-10T12:06:14.596Z | 2024-10-18T12:21:49.400Z |
5231864 | 5231864 | 20241004153344_tOQIv | KR0017 | 2024-10-06T12:11:03.408Z | 2024-10-13T12:26:18.408Z |
5230758 | 5230758 | 20241004123915_QUguT | KR0017 | 2024-10-06T12:09:10.144Z | 2024-10-13T12:26:16.835Z |
5230659 | 5230659 | 20241004122400_sOFDG | KR0017 | 2024-10-06T12:09:02.322Z | 2024-10-13T12:26:16.727Z |
5229596 | 5229596 | 20241004100950_q8P2Q | KR0017 | 2024-10-06T12:06:49.973Z | 2024-10-13T12:26:14.512Z |
5222181 | 5222181 | 20241003121404_VhT9Q | KR0017 | 2024-10-05T12:15:13.104Z | 2024-10-12T12:25:03.374Z |
5209957 | 5209957 | 20241001180933_D3iQ3 | KR0017 | 2024-10-03T12:14:06.269Z | 2024-10-10T12:24:44.466Z |
5209786 | 5209786 | 20241001172117_5G1vm | KR0017 | 2024-10-03T12:13:46.205Z | 2024-10-10T12:24:43.915Z |
5209305 | 5209305 | 20241001130734_o1957 | KR0017 | 2024-10-03T12:12:50.796Z | 2024-10-10T12:24:42.612Z |
5208952 | 5208952 | 20241002183220_RD2pH | KR0017 | 2024-10-03T12:09:36.027Z | 2024-10-11T12:23:31.034Z |
5208905 | 5208905 | 20241002181123_9DU64 | KR0017 | 2024-10-03T12:09:32.335Z | 2024-10-11T12:23:30.679Z |
5208854 | 5208854 | 20241002174309_hseFZ | KR0017 | 2024-10-03T12:09:26.350Z | 2024-10-11T12:23:30.585Z |
5208782 | 5208782 | 20241002170734_V59hu | KR0017 | 2024-10-03T12:09:09.207Z | 2024-10-11T12:23:30.464Z |
5208735 | 5208735 | 20241002164247_gKcOm | KR0017 | 2024-10-03T12:09:04.453Z | 2024-10-11T12:23:30.331Z |
5208725 | 5208725 | 20241002163650_fTLl2 | KR0017 | 2024-10-03T12:09:03.954Z | 2024-10-11T12:23:30.326Z |
5204130 | 5204130 | 20240930185627_FNSzd | KR0017 | 2024-10-02T12:11:13.959Z | 2024-10-09T12:29:13.159Z |
5204095 | 5204095 | 20240930184708_bXL1m | KR0017 | 2024-10-02T12:11:09.831Z | 2024-10-09T12:29:13.059Z |
5203959 | 5203959 | 20240930181609_jz8qA | KR0017 | 2024-10-02T12:10:57.886Z | 2024-10-09T12:29:11.431Z |
5203916 | 5203916 | 20240930175946_D7CQ7 | KR0017 | 2024-10-02T12:10:52.954Z | 2024-10-09T12:29:10.986Z |
5203906 | 5203906 | 20240930175451_2kam8 | KR0017 | 2024-10-02T12:10:51.026Z | 2024-10-09T12:29:10.954Z |
5203646 | 5203646 | 20240930163815_4ilTE | KR0017 | 2024-10-02T12:10:29.551Z | 2024-10-09T12:29:08.855Z |
5203173 | 5203173 | 20240930134427_S6rEr | KR0017 | 2024-10-02T12:09:56.603Z | 2024-10-09T12:29:07.509Z |
5198763 | 5198763 | 20240929195848_ltjZU | KR0017 | 2024-10-01T12:15:07.322Z | 2024-10-07T12:21:35.493Z |
5198569 | 5198569 | 20240929191320_SSpz0 | KR0017 | 2024-10-01T12:14:51.110Z | 2024-10-07T12:21:34.541Z |
5198528 | 5198528 | 20240929190110_A6Aks | KR0017 | 2024-10-01T12:14:49.106Z | 2024-10-07T12:21:34.339Z |
5198508 | 5198508 | 20240929185713_KLcE0 | KR0017 | 2024-10-01T12:14:48.174Z | 2024-10-07T12:21:34.203Z |
5193573 | 5193573 | 20240929123338_6Oy5a | KR0017 | 2024-09-30T12:19:21.068Z | 2024-10-07T12:21:26.374Z |
5193425 | 5193425 | 20240929115807_8zJXG | KR0017 | 2024-09-30T12:19:16.966Z | 2024-10-07T12:21:25.640Z |
5191520 | 5191520 | 20240928201440_r2HHY | KR0017 | 2024-09-30T12:17:50.605Z | 2024-10-06T12:28:22.826Z |
5191113 | 5191113 | 20240928191754_7Z51g | KR0017 | 2024-09-30T12:17:29.758Z | 2024-10-06T12:28:21.782Z |
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);