participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,858 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 |
---|---|---|---|---|---|
5570410 | 5570410 | 20241120193406_6VuTj | KR0017 | 2024-11-22T14:15:20.023Z | 2024-11-22T14:19:21.912Z |
5570001 | 5570001 | 20241120182215_UP7gq | KR0017 | 2024-11-22T14:14:44.302Z | 2024-11-22T14:19:21.845Z |
5569646 | 5569646 | 20241121194955_PIoZ2 | KR0017 | 2024-11-22T14:11:26.257Z | 2024-11-22T14:11:26.257Z |
5569631 | 5569631 | 20241121190653_wZubr | KR0017 | 2024-11-22T14:11:24.893Z | 2024-11-22T14:11:24.893Z |
5569621 | 5569621 | 20241121182547_fd24u | KR0017 | 2024-11-22T14:11:23.921Z | 2024-11-22T14:11:23.921Z |
5569618 | 5569618 | 20241121182121_TOiap | KR0017 | 2024-11-22T14:11:23.651Z | 2024-11-22T14:11:23.651Z |
5569598 | 5569598 | 20241121174127_29bNa | KR0017 | 2024-11-22T14:11:21.569Z | 2024-11-22T14:11:21.569Z |
5552338 | 5552338 | 20241118204932_Kwlrt | KR0017 | 2024-11-19T14:06:24.112Z | 2024-11-22T14:22:16.989Z |
5552255 | 5552255 | 20241118195940_37Bgn | KR0017 | 2024-11-19T14:06:11.391Z | 2024-11-22T14:22:16.244Z |
5552237 | 5552237 | 20241118193340_I8m3o | KR0017 | 2024-11-19T14:06:09.088Z | 2024-11-22T14:22:15.992Z |
5552152 | 5552152 | 20241118183448_JNpHq | KR0017 | 2024-11-19T14:06:03.032Z | 2024-11-22T14:22:15.304Z |
5552136 | 5552136 | 20241118182935_O5a8Z | KR0017 | 2024-11-19T14:06:02.491Z | 2024-11-22T14:22:15.146Z |
5552068 | 5552068 | 20241118174807_8ztSu | KR0017 | 2024-11-19T14:05:59.212Z | 2024-11-22T14:22:14.518Z |
5552051 | 5552051 | 20241118173031_ros4a | KR0017 | 2024-11-19T14:05:58.204Z | 2024-11-22T14:22:14.344Z |
5552026 | 5552026 | 20241118172255_RPoxH | KR0017 | 2024-11-19T14:05:56.025Z | 2024-11-22T14:22:14.072Z |
5550116 | 5550116 | 20241118093411_f002o | KR0017 | 2024-11-19T14:01:36.124Z | 2024-11-22T14:21:58.650Z |
5525538 | 5525538 | 20241105172545_Md3gp | KR0017 | 2024-11-12T14:26:36.894Z | 2024-11-14T14:23:08.779Z |
5525292 | 5525292 | 20241106162837_3qDA7 | KR0017 | 2024-11-12T14:25:41.884Z | 2024-11-15T14:24:40.821Z |
5521746 | 5521746 | 20241110181103_TKQQt | KR0017 | 2024-11-12T14:11:55.914Z | 2024-11-19T14:21:54.742Z |
5521708 | 5521708 | 20241110180602_A5246 | KR0017 | 2024-11-12T14:11:52.519Z | 2024-11-19T14:21:54.485Z |
5521665 | 5521665 | 20241110175332_YVJ41 | KR0017 | 2024-11-12T14:11:48.874Z | 2024-11-19T14:21:54.097Z |
5521603 | 5521603 | 20241110174106_ctiGQ | KR0017 | 2024-11-12T14:11:42.571Z | 2024-11-19T14:21:53.722Z |
5521552 | 5521552 | 20241110173230_II3py | KR0017 | 2024-11-12T14:11:33.964Z | 2024-11-19T14:21:53.500Z |
5521452 | 5521452 | 20241110171325_XyVf4 | KR0017 | 2024-11-12T14:11:09.826Z | 2024-11-19T14:21:52.867Z |
5521135 | 5521135 | 20241110160936_3t76k | KR0017 | 2024-11-12T14:10:31.864Z | 2024-11-19T14:21:49.026Z |
5521087 | 5521087 | 20241110160055_2437R | KR0017 | 2024-11-12T14:10:26.612Z | 2024-11-19T14:21:48.311Z |
5520903 | 5520903 | 20241110151938_UiBdq | KR0017 | 2024-11-12T14:09:44.546Z | 2024-11-19T14:21:45.533Z |
5503239 | 5503239 | 20241107210849_iQSoO | KR0017 | 2024-11-09T14:12:37.962Z | 2024-11-16T14:28:05.057Z |
5502663 | 5502663 | 20241107192919_HjLiY | KR0017 | 2024-11-09T14:11:57.004Z | 2024-11-16T14:27:58.344Z |
5502370 | 5502370 | 20241107181532_aftbX | KR0017 | 2024-11-09T14:11:14.358Z | 2024-11-16T14:27:54.728Z |
5502321 | 5502321 | 20241107180431_FYusy | KR0017 | 2024-11-09T14:11:09.796Z | 2024-11-16T14:27:53.494Z |
5502272 | 5502272 | 20241107175507_AjvZr | KR0017 | 2024-11-09T14:11:07.491Z | 2024-11-16T14:27:52.638Z |
5502251 | 5502251 | 20241107175041_Vwc3A | KR0017 | 2024-11-09T14:11:05.976Z | 2024-11-16T14:27:52.392Z |
5502167 | 5502167 | 20241107173452_q4534 | KR0017 | 2024-11-09T14:11:00.723Z | 2024-11-16T14:27:51.011Z |
5502132 | 5502132 | 20241107172745_2JncK | KR0017 | 2024-11-09T14:10:59.169Z | 2024-11-16T14:27:50.780Z |
5502042 | 5502042 | 20241107170001_kxqDx | KR0017 | 2024-11-09T14:10:52.113Z | 2024-11-16T14:27:49.682Z |
5502021 | 5502021 | 20241107165440_KAPnW | KR0017 | 2024-11-09T14:10:50.370Z | 2024-11-16T14:27:49.483Z |
5501873 | 5501873 | 20241107162100_2F7Yz | KR0017 | 2024-11-09T14:10:38.584Z | 2024-11-16T14:27:48.821Z |
5501811 | 5501811 | 20241107155930_WFoNf | KR0017 | 2024-11-09T14:10:28.115Z | 2024-11-16T14:27:48.407Z |
5501724 | 5501724 | 20241107152704_lUsiP | KR0017 | 2024-11-09T14:10:15.748Z | 2024-11-16T14:27:46.237Z |
5501665 | 5501665 | 20241107150622_iwNkr | KR0017 | 2024-11-09T14:10:10.665Z | 2024-11-16T14:27:44.509Z |
5501531 | 5501531 | 20241107140800_xtTVn | KR0017 | 2024-11-09T14:09:59.539Z | 2024-11-16T14:27:42.191Z |
5501455 | 5501455 | 20241107131504_h2RUJ | KR0017 | 2024-11-09T14:09:46.165Z | 2024-11-16T14:27:39.744Z |
5501313 | 5501313 | 20241107120345_rYNoH | KR0017 | 2024-11-09T14:09:07.517Z | 2024-11-16T14:27:33.991Z |
5500956 | 5500956 | 20241108184004_uLa2k | KR0017 | 2024-11-09T14:07:30.398Z | 2024-11-17T14:23:31.668Z |
5500744 | 5500744 | 20241108171543_uZ3pi | KR0017 | 2024-11-09T14:07:01.083Z | 2024-11-17T14:23:27.391Z |
5500158 | 5500158 | 20241108150029_ZhcAE | KR0017 | 2024-11-09T14:05:55.959Z | 2024-11-17T14:23:19.931Z |
5500005 | 5500005 | 20241108142140_3K5b0 | KR0017 | 2024-11-09T14:05:28.990Z | 2024-11-17T14:23:17.945Z |
5495148 | 5495148 | 20241106185006_QAudY | KR0017 | 2024-11-08T14:09:26.189Z | 2024-11-15T14:24:46.877Z |
5495046 | 5495046 | 20241106182505_O3Hnv | KR0017 | 2024-11-08T14:09:08.892Z | 2024-11-15T14:24:45.860Z |
5494872 | 5494872 | 20241106174134_9qY5d | KR0017 | 2024-11-08T14:08:44.226Z | 2024-11-15T14:24:43.809Z |
5490084 | 5490084 | 20241105205524_v5bq8 | KR0017 | 2024-11-07T14:13:09.409Z | 2024-11-14T14:23:17.469Z |
5489367 | 5489367 | 20241105184054_4GKuK | KR0017 | 2024-11-07T14:11:56.406Z | 2024-11-14T14:23:12.624Z |
5489200 | 5489200 | 20241105180418_Wlam8 | KR0017 | 2024-11-07T14:11:26.385Z | 2024-11-14T14:23:10.815Z |
5489192 | 5489192 | 20241105180411_sw1qG | KR0017 | 2024-11-07T14:11:26.219Z | 2024-11-14T14:23:10.814Z |
5489175 | 5489175 | 20241105180255_E6Bib | KR0017 | 2024-11-07T14:11:25.436Z | 2024-11-14T14:23:10.806Z |
5488961 | 5488961 | 20241105172922_iVJRG | KR0017 | 2024-11-07T14:11:06.609Z | 2024-11-14T14:23:08.955Z |
5488943 | 5488943 | 20241105172412_sHLq2 | KR0017 | 2024-11-07T14:11:03.820Z | 2024-11-14T14:23:08.757Z |
5488896 | 5488896 | 20241105171314_N4TO4 | KR0017 | 2024-11-07T14:10:50.178Z | 2024-11-14T14:23:08.510Z |
5488891 | 5488891 | 20241105171112_GasGL | KR0017 | 2024-11-07T14:10:49.280Z | 2024-11-14T14:23:08.411Z |
5488851 | 5488851 | 20241105170612_pEodl | KR0017 | 2024-11-07T14:10:42.941Z | 2024-11-14T14:23:08.095Z |
5488800 | 5488800 | 20241105165558_GsOfi | KR0017 | 2024-11-07T14:10:38.216Z | 2024-11-14T14:23:07.771Z |
5488732 | 5488732 | 20241105163842_0n217 | KR0017 | 2024-11-07T14:10:32.674Z | 2024-11-14T14:23:07.316Z |
5488628 | 5488628 | 20241105160402_6xWxC | KR0017 | 2024-11-07T14:10:23.765Z | 2024-11-14T14:23:06.857Z |
5488565 | 5488565 | 20241105154059_EWBVy | KR0017 | 2024-11-07T14:10:19.083Z | 2024-11-14T14:23:06.696Z |
5488555 | 5488555 | 20241105154045_BdVMs | KR0017 | 2024-11-07T14:10:17.409Z | 2024-11-14T14:23:06.679Z |
5488448 | 5488448 | 20241105145020_DMJMK | KR0017 | 2024-11-07T14:09:55.443Z | 2024-11-14T14:23:05.633Z |
5488246 | 5488246 | 20241105122245_0Ebxj | KR0017 | 2024-11-07T14:09:17.110Z | 2024-11-14T14:23:03.870Z |
5487548 | 5487548 | 20241106170853_faTus | KR0017 | 2024-11-07T14:06:12.500Z | 2024-11-15T14:24:42.202Z |
5487505 | 5487505 | 20241106164456_pFaZA | KR0017 | 2024-11-07T14:06:06.279Z | 2024-11-15T14:24:41.104Z |
5487446 | 5487446 | 20241106161736_aUUX6 | KR0017 | 2024-11-07T14:05:48.726Z | 2024-11-15T14:24:40.504Z |
5487436 | 5487436 | 20241106161125_KE33h | KR0017 | 2024-11-07T14:05:46.738Z | 2024-11-15T14:24:40.452Z |
5487397 | 5487397 | 20241106155218_etFna | KR0017 | 2024-11-07T14:05:41.318Z | 2024-11-15T14:24:40.027Z |
5487289 | 5487289 | 20241106153225_QKjUp | KR0017 | 2024-11-07T14:05:28.816Z | 2024-11-15T14:24:38.890Z |
5486908 | 5486908 | 20241106135804_aGT2V | KR0017 | 2024-11-07T14:04:22.820Z | 2024-11-15T14:24:35.861Z |
5486726 | 5486726 | 20241106130330_mQJ11 | KR0017 | 2024-11-07T14:03:52.445Z | 2024-11-15T14:24:33.509Z |
5486713 | 5486713 | 20241106130105_uZA43 | KR0017 | 2024-11-07T14:03:50.549Z | 2024-11-15T14:24:33.403Z |
5486540 | 5486540 | 20241106120432_sAbtr | KR0017 | 2024-11-07T14:03:20.049Z | 2024-11-15T14:24:31.178Z |
5486435 | 5486435 | 20241106113745_OrhRL | KR0017 | 2024-11-07T14:02:57.925Z | 2024-11-15T14:24:30.060Z |
5486398 | 5486398 | 20241106112210_42xZ1 | KR0017 | 2024-11-07T14:02:48.805Z | 2024-11-15T14:24:29.816Z |
5486194 | 5486194 | 20241106100156_xaFz3 | KR0017 | 2024-11-07T14:02:11.766Z | 2024-11-15T14:24:27.412Z |
5474765 | 5474765 | 20241103181304_fte98 | KR0017 | 2024-11-05T14:11:55.689Z | 2024-11-12T14:27:54.613Z |
5474587 | 5474587 | 20241103174247_Wl7YH | KR0017 | 2024-11-05T14:11:19.679Z | 2024-11-12T14:27:53.284Z |
5474408 | 5474408 | 20241103171220_mesA2 | KR0017 | 2024-11-05T14:11:03.210Z | 2024-11-12T14:27:51.617Z |
5474216 | 5474216 | 20241103162658_RTPFv | KR0017 | 2024-11-05T14:10:26.769Z | 2024-11-12T14:27:50.718Z |
5474196 | 5474196 | 20241103162335_Vu95P | KR0017 | 2024-11-05T14:10:23.235Z | 2024-11-12T14:27:50.697Z |
5474186 | 5474186 | 20241103162130_sRPdo | KR0017 | 2024-11-05T14:10:21.584Z | 2024-11-12T14:27:50.680Z |
5474162 | 5474162 | 20241103161348_kib9b | KR0017 | 2024-11-05T14:10:15.787Z | 2024-11-12T14:27:50.646Z |
5474140 | 5474140 | 20241103160955_6MYoE | KR0017 | 2024-11-05T14:10:11.398Z | 2024-11-12T14:27:50.616Z |
5474110 | 5474110 | 20241103155439_McS2R | KR0017 | 2024-11-05T14:10:09.093Z | 2024-11-12T14:27:50.569Z |
5473815 | 5473815 | 20241103150755_ZK7F2 | KR0017 | 2024-11-05T14:09:46.394Z | 2024-11-12T14:27:50.047Z |
5473619 | 5473619 | 20241103144146_7k5rU | KR0017 | 2024-11-05T14:09:13.663Z | 2024-11-12T14:27:49.810Z |
5466706 | 5466706 | 20241102183716_1Hyas | KR0017 | 2024-11-04T14:09:35.692Z | 2024-11-11T14:22:42.697Z |
5466688 | 5466688 | 20241102183516_bMWL4 | KR0017 | 2024-11-04T14:09:34.129Z | 2024-11-11T14:22:42.592Z |
5466525 | 5466525 | 20241102175437_7yN6W | KR0017 | 2024-11-04T14:09:07.226Z | 2024-11-11T14:22:41.214Z |
5466442 | 5466442 | 20241102174243_IRive | KR0017 | 2024-11-04T14:08:54.464Z | 2024-11-11T14:22:41.030Z |
5466168 | 5466168 | 20241102163931_Eue23 | KR0017 | 2024-11-04T14:08:08.917Z | 2024-11-11T14:22:39.463Z |
5466143 | 5466143 | 20241102163406_Dr2gf | KR0017 | 2024-11-04T14:08:05.694Z | 2024-11-11T14:22:39.265Z |
5466064 | 5466064 | 20241102161420_A6dr0 | KR0017 | 2024-11-04T14:07:57.916Z | 2024-11-11T14:22:38.802Z |
5466043 | 5466043 | 20241102160558_A6rgq | KR0017 | 2024-11-04T14:07:55.629Z | 2024-11-11T14:22:38.630Z |
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);