participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,654 rows where station_code = "KR000B" 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 |
---|---|---|---|---|---|
5537195 | 5537195 | 20241112205503_1KEez | KR000B | 2024-11-14T14:11:16.933Z | 2024-11-21T14:26:09.596Z |
5537097 | 5537097 | 20241112202623_k2myI | KR000B | 2024-11-14T14:11:02.043Z | 2024-11-21T14:26:08.744Z |
5536981 | 5536981 | 20241112195844_2ubiX | KR000B | 2024-11-14T14:10:48.466Z | 2024-11-21T14:26:07.676Z |
5536840 | 5536840 | 20241112192419_aMn2t | KR000B | 2024-11-14T14:10:36.522Z | 2024-11-21T14:26:06.255Z |
5536790 | 5536790 | 20241112191132_ooTDJ | KR000B | 2024-11-14T14:10:33.350Z | 2024-11-21T14:26:05.521Z |
5536755 | 5536755 | 20241112190211_3JZpS | KR000B | 2024-11-14T14:10:32.067Z | 2024-11-21T14:26:05.419Z |
5536619 | 5536619 | 20241112184011_TkthW | KR000B | 2024-11-14T14:10:24.339Z | 2024-11-21T14:26:03.684Z |
5536548 | 5536548 | 20241112182729_e802W | KR000B | 2024-11-14T14:10:16.099Z | 2024-11-21T14:26:02.691Z |
5536457 | 5536457 | 20241112180832_mBajt | KR000B | 2024-11-14T14:10:00.250Z | 2024-11-21T14:26:01.099Z |
5536445 | 5536445 | 20241112180508_p9MSy | KR000B | 2024-11-14T14:09:57.631Z | 2024-11-21T14:26:00.972Z |
5536274 | 5536274 | 20241112170326_vl2t1 | KR000B | 2024-11-14T14:09:30.659Z | 2024-11-21T14:25:59.648Z |
5536240 | 5536240 | 20241112164558_oulO4 | KR000B | 2024-11-14T14:09:25.721Z | 2024-11-21T14:25:59.017Z |
5528338 | 5528338 | 20241111202537_clmtT | KR000B | 2024-11-13T14:10:28.252Z | 2024-11-20T14:25:28.553Z |
5528287 | 5528287 | 20241111201252_TeZvr | KR000B | 2024-11-13T14:10:24.211Z | 2024-11-20T14:25:27.944Z |
5528229 | 5528229 | 20241111195647_J2xRE | KR000B | 2024-11-13T14:10:17.122Z | 2024-11-20T14:25:26.869Z |
5528175 | 5528175 | 20241111194958_GjrKZ | KR000B | 2024-11-13T14:10:12.786Z | 2024-11-20T14:25:26.329Z |
5528140 | 5528140 | 20241111194345_wmdhV | KR000B | 2024-11-13T14:10:02.542Z | 2024-11-20T14:25:25.583Z |
5528122 | 5528122 | 20241111194121_B6eHY | KR000B | 2024-11-13T14:09:56.713Z | 2024-11-20T14:25:25.361Z |
5527926 | 5527926 | 20241111190101_c4lPe | KR000B | 2024-11-13T14:09:34.705Z | 2024-11-20T14:25:23.166Z |
5527755 | 5527755 | 20241111182803_KmvoG | KR000B | 2024-11-13T14:09:02.868Z | 2024-11-20T14:25:19.691Z |
5527532 | 5527532 | 20241111173026_Ye2ro | KR000B | 2024-11-13T14:08:36.789Z | 2024-11-20T14:25:13.208Z |
5527430 | 5527430 | 20241111163642_f3Fam | KR000B | 2024-11-13T14:08:13.277Z | 2024-11-20T14:25:10.935Z |
5527409 | 5527409 | 20241111161421_2J3k5 | KR000B | 2024-11-13T14:08:10.489Z | 2024-11-20T14:25:10.465Z |
5527364 | 5527364 | 20241111154512_HtZ0u | KR000B | 2024-11-13T14:08:04.331Z | 2024-11-20T14:25:08.637Z |
5525608 | 5525608 | 20241105205027_QlDYF | KR000B | 2024-11-12T14:26:46.037Z | 2024-11-14T14:23:17.387Z |
5525562 | 5525562 | 20241105183926_GEUHE | KR000B | 2024-11-12T14:26:42.430Z | 2024-11-14T14:23:12.583Z |
5525558 | 5525558 | 20241105183739_OVzpw | KR000B | 2024-11-12T14:26:42.364Z | 2024-11-14T14:23:12.512Z |
5525551 | 5525551 | 20241105182005_4KdSf | KR000B | 2024-11-12T14:26:41.546Z | 2024-11-14T14:23:11.652Z |
5525549 | 5525549 | 20241105181228_hc2i5 | KR000B | 2024-11-12T14:26:40.585Z | 2024-11-14T14:23:11.106Z |
5525517 | 5525517 | 20241105164219_I9fEU | KR000B | 2024-11-12T14:26:35.335Z | 2024-11-14T14:23:07.436Z |
5525495 | 5525495 | 20241105161059_WbRqf | KR000B | 2024-11-12T14:26:34.830Z | 2024-11-14T14:23:06.921Z |
5525486 | 5525486 | 20241105155703_AyLEG | KR000B | 2024-11-12T14:26:34.625Z | 2024-11-14T14:23:06.791Z |
5525482 | 5525482 | 20241105151141_C9Ms8 | KR000B | 2024-11-12T14:26:34.057Z | 2024-11-14T14:23:06.036Z |
5525475 | 5525475 | 20241105143214_LaCR5 | KR000B | 2024-11-12T14:26:33.603Z | 2024-11-14T14:23:05.435Z |
5525461 | 5525461 | 20241105135329_f3d0v | KR000B | 2024-11-12T14:26:32.862Z | 2024-11-14T14:23:04.849Z |
5525437 | 5525437 | 20241106204958_xGdub | KR000B | 2024-11-12T14:25:56.162Z | 2024-11-15T14:24:51.826Z |
5525421 | 5525421 | 20241106200123_oBPb2 | KR000B | 2024-11-12T14:25:54.223Z | 2024-11-15T14:24:49.842Z |
5525407 | 5525407 | 20241106193208_smylz | KR000B | 2024-11-12T14:25:52.408Z | 2024-11-15T14:24:48.442Z |
5525383 | 5525383 | 20241106191000_ss8kS | KR000B | 2024-11-12T14:25:51.365Z | 2024-11-15T14:24:47.933Z |
5525374 | 5525374 | 20241106185732_i8PhK | KR000B | 2024-11-12T14:25:50.655Z | 2024-11-15T14:24:47.457Z |
5525356 | 5525356 | 20241106180344_BZpgl | KR000B | 2024-11-12T14:25:46.966Z | 2024-11-15T14:24:45.048Z |
5525326 | 5525326 | 20241106173327_nsYfK | KR000B | 2024-11-12T14:25:45.108Z | 2024-11-15T14:24:43.641Z |
5525307 | 5525307 | 20241106165920_5MrDQ | KR000B | 2024-11-12T14:25:43.095Z | 2024-11-15T14:24:41.541Z |
5525305 | 5525305 | 20241106165027_7xeSt | KR000B | 2024-11-12T14:25:42.838Z | 2024-11-15T14:24:41.291Z |
5525300 | 5525300 | 20241106163739_7Vqt4 | KR000B | 2024-11-12T14:25:42.454Z | 2024-11-15T14:24:40.868Z |
5525273 | 5525273 | 20241106155445_1Eq2j | KR000B | 2024-11-12T14:25:41.183Z | 2024-11-15T14:24:40.037Z |
5525241 | 5525241 | 20241106145907_mzWdb | KR000B | 2024-11-12T14:25:37.269Z | 2024-11-15T14:24:37.577Z |
5525222 | 5525222 | 20241106135555_SdHCi | KR000B | 2024-11-12T14:25:34.540Z | 2024-11-15T14:24:35.787Z |
5525192 | 5525192 | 20241106121434_mtA8Z | KR000B | 2024-11-12T14:25:32.089Z | 2024-11-15T14:24:31.633Z |
5525138 | 5525138 | 20241108205431_SAMfF | KR000B | 2024-11-12T14:23:09.743Z | 2024-11-17T14:23:37.562Z |
5525134 | 5525134 | 20241108204723_Hpx1J | KR000B | 2024-11-12T14:23:08.606Z | 2024-11-17T14:23:36.978Z |
5525112 | 5525112 | 20241108193247_9fBsM | KR000B | 2024-11-12T14:23:04.002Z | 2024-11-17T14:23:34.008Z |
5525100 | 5525100 | 20241108185048_lro9C | KR000B | 2024-11-12T14:23:02.102Z | 2024-11-17T14:23:31.940Z |
5525098 | 5525098 | 20241108183916_dewK3 | KR000B | 2024-11-12T14:23:01.509Z | 2024-11-17T14:23:31.662Z |
5525095 | 5525095 | 20241108183603_4uzoc | KR000B | 2024-11-12T14:23:00.808Z | 2024-11-17T14:23:31.526Z |
5525080 | 5525080 | 20241108181449_ggOZQ | KR000B | 2024-11-12T14:22:59.660Z | 2024-11-17T14:23:31.131Z |
5525078 | 5525078 | 20241108180732_iQXDL | KR000B | 2024-11-12T14:22:58.506Z | 2024-11-17T14:23:30.550Z |
5525076 | 5525076 | 20241108180111_a6aI8 | KR000B | 2024-11-12T14:22:58.206Z | 2024-11-17T14:23:30.192Z |
5525074 | 5525074 | 20241108180108_bCSJT | KR000B | 2024-11-12T14:22:58.185Z | 2024-11-17T14:23:30.169Z |
5525069 | 5525069 | 20241108173951_SMgnv | KR000B | 2024-11-12T14:22:55.842Z | 2024-11-17T14:23:28.772Z |
5525036 | 5525036 | 20241108155411_Tvd3g | KR000B | 2024-11-12T14:22:50.482Z | 2024-11-17T14:23:23.067Z |
5525026 | 5525026 | 20241108152057_GjK3L | KR000B | 2024-11-12T14:22:47.722Z | 2024-11-17T14:23:21.648Z |
5525010 | 5525010 | 20241108141258_mJbxb | KR000B | 2024-11-12T14:22:42.650Z | 2024-11-17T14:23:17.568Z |
5525004 | 5525004 | 20241108135232_1KAZE | KR000B | 2024-11-12T14:22:40.709Z | 2024-11-17T14:23:16.591Z |
5524995 | 5524995 | 20241108125032_YBlnt | KR000B | 2024-11-12T14:22:37.078Z | 2024-11-17T14:23:14.092Z |
5522529 | 5522529 | 20241110202028_iMwoU | KR000B | 2024-11-12T14:13:29.633Z | 2024-11-19T14:22:03.481Z |
5522454 | 5522454 | 20241110200500_0g5J6 | KR000B | 2024-11-12T14:13:17.843Z | 2024-11-19T14:22:02.477Z |
5522421 | 5522421 | 20241110195953_2qlLD | KR000B | 2024-11-12T14:13:14.686Z | 2024-11-19T14:22:01.835Z |
5522224 | 5522224 | 20241110192711_n0Y7D | KR000B | 2024-11-12T14:12:59.312Z | 2024-11-19T14:21:59.588Z |
5522067 | 5522067 | 20241110185950_gDvf2 | KR000B | 2024-11-12T14:12:41.479Z | 2024-11-19T14:21:57.555Z |
5521880 | 5521880 | 20241110182834_nwiaM | KR000B | 2024-11-12T14:12:05.388Z | 2024-11-19T14:21:55.888Z |
5521443 | 5521443 | 20241110171218_qnelg | KR000B | 2024-11-12T14:11:07.587Z | 2024-11-19T14:21:52.768Z |
5521228 | 5521228 | 20241110163142_GMZlg | KR000B | 2024-11-12T14:10:39.289Z | 2024-11-19T14:21:50.558Z |
5521018 | 5521018 | 20241110154622_31SSd | KR000B | 2024-11-12T14:10:09.166Z | 2024-11-19T14:21:47.570Z |
5520927 | 5520927 | 20241110152718_apTnr | KR000B | 2024-11-12T14:09:49.636Z | 2024-11-19T14:21:45.748Z |
5520697 | 5520697 | 20241110134313_vJNna | KR000B | 2024-11-12T14:09:02.121Z | 2024-11-19T14:21:41.907Z |
5467226 | 5467226 | 20241102202600_k9QZT | KR000B | 2024-11-04T14:11:07.820Z | 2024-11-11T14:22:45.726Z |
5467195 | 5467195 | 20241102202228_FSD3W | KR000B | 2024-11-04T14:11:05.053Z | 2024-11-11T14:22:45.565Z |
5467174 | 5467174 | 20241102201906_rEaCh | KR000B | 2024-11-04T14:11:01.767Z | 2024-11-11T14:22:45.508Z |
5466996 | 5466996 | 20241102194245_yHeYG | KR000B | 2024-11-04T14:10:26.725Z | 2024-11-11T14:22:44.816Z |
5466750 | 5466750 | 20241102184622_Up3Cs | KR000B | 2024-11-04T14:09:43.117Z | 2024-11-11T14:22:43.109Z |
5466568 | 5466568 | 20241102180542_eNpJj | KR000B | 2024-11-04T14:09:21.083Z | 2024-11-11T14:22:41.357Z |
5466518 | 5466518 | 20241102175407_JOXCQ | KR000B | 2024-11-04T14:09:05.820Z | 2024-11-11T14:22:41.206Z |
5466455 | 5466455 | 20241102174512_2OCQR | KR000B | 2024-11-04T14:08:55.851Z | 2024-11-11T14:22:41.055Z |
5466407 | 5466407 | 20241102173408_FTOVw | KR000B | 2024-11-04T14:08:48.640Z | 2024-11-11T14:22:40.865Z |
5466288 | 5466288 | 20241102170344_RTdmk | KR000B | 2024-11-04T14:08:33.179Z | 2024-11-11T14:22:40.118Z |
5466266 | 5466266 | 20241102165916_BhS33 | KR000B | 2024-11-04T14:08:28.969Z | 2024-11-11T14:22:40.074Z |
5465998 | 5465998 | 20241102155606_TjTKa | KR000B | 2024-11-04T14:07:50.568Z | 2024-11-11T14:22:37.821Z |
5465962 | 5465962 | 20241102153843_iSjBI | KR000B | 2024-11-04T14:07:34.641Z | 2024-11-11T14:22:37.252Z |
5465956 | 5465956 | 20241102153740_HXrqK | KR000B | 2024-11-04T14:07:34.025Z | 2024-11-11T14:22:37.208Z |
5465939 | 5465939 | 20241102152643_T8M3a | KR000B | 2024-11-04T14:07:28.568Z | 2024-11-11T14:22:36.957Z |
5465897 | 5465897 | 20241102151035_cVs4X | KR000B | 2024-11-04T14:07:20.292Z | 2024-11-11T14:22:36.045Z |
5465841 | 5465841 | 20241102144935_R0g8n | KR000B | 2024-11-04T14:07:12.150Z | 2024-11-11T14:22:35.577Z |
5465837 | 5465837 | 20241102144612_pyEl3 | KR000B | 2024-11-04T14:07:09.737Z | 2024-11-11T14:22:35.222Z |
5465779 | 5465779 | 20241102140311_Aj1b1 | KR000B | 2024-11-04T14:06:42.006Z | 2024-11-11T14:22:33.976Z |
5465655 | 5465655 | 20241102124537_wR4oG | KR000B | 2024-11-04T14:06:04.956Z | 2024-11-11T14:22:31.946Z |
5465550 | 5465550 | 20241102111732_fz8gE | KR000B | 2024-11-04T14:05:22.911Z | 2024-11-11T14:22:28.820Z |
5392520 | 5392520 | 20241026175549_p3zLN | KR000B | 2024-10-28T12:08:05.584Z | 2024-11-04T14:28:40.522Z |
5392509 | 5392509 | 20241026174725_eMPsZ | KR000B | 2024-10-28T12:08:03.426Z | 2024-11-04T14:28:40.281Z |
5392491 | 5392491 | 20241026173439_YBKEn | KR000B | 2024-10-28T12:08:01.530Z | 2024-11-04T14:28:39.374Z |
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);