participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,130 rows where station_code = "KR000H" 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 |
---|---|---|---|---|---|
5490037 | 5490037 | 20241105204733_BVZQZ | KR000H | 2024-11-07T14:13:05.721Z | 2024-11-08T14:16:15.864Z |
5490010 | 5490010 | 20241105204125_Rg5Ni | KR000H | 2024-11-07T14:13:02.054Z | 2024-11-08T14:16:14.809Z |
5489992 | 5489992 | 20241105203959_fzQu6 | KR000H | 2024-11-07T14:13:00.306Z | 2024-11-08T14:16:14.572Z |
5489967 | 5489967 | 20241105203415_Gcqkc | KR000H | 2024-11-07T14:12:58.257Z | 2024-11-08T14:16:13.778Z |
5489897 | 5489897 | 20241105202448_Oq0qC | KR000H | 2024-11-07T14:12:53.688Z | 2024-11-08T14:16:12.688Z |
5489883 | 5489883 | 20241105202423_Ap7U6 | KR000H | 2024-11-07T14:12:52.932Z | 2024-11-08T14:16:12.525Z |
5489793 | 5489793 | 20241105200051_7qL9b | KR000H | 2024-11-07T14:12:45.951Z | 2024-11-08T14:16:10.771Z |
5489744 | 5489744 | 20241105195648_JbkTB | KR000H | 2024-11-07T14:12:42.782Z | 2024-11-08T14:16:10.058Z |
5489693 | 5489693 | 20241105194313_vFCYC | KR000H | 2024-11-07T14:12:36.389Z | 2024-11-08T14:16:08.929Z |
5489629 | 5489629 | 20241105193021_oPWX1 | KR000H | 2024-11-07T14:12:21.546Z | 2024-11-08T14:16:06.877Z |
5489604 | 5489604 | 20241105192532_N8ndC | KR000H | 2024-11-07T14:12:17.701Z | 2024-11-08T14:16:05.907Z |
5489540 | 5489540 | 20241105191149_9qCf7 | KR000H | 2024-11-07T14:12:10.873Z | 2024-11-08T14:16:03.867Z |
5489450 | 5489450 | 20241105185649_eqRfX | KR000H | 2024-11-07T14:12:03.088Z | 2024-11-08T14:16:02.037Z |
5489221 | 5489221 | 20241105180946_e1qYv | KR000H | 2024-11-07T14:11:31.944Z | 2024-11-08T14:15:57.747Z |
5489162 | 5489162 | 20241105175920_N6Tzi | KR000H | 2024-11-07T14:11:23.916Z | 2024-11-08T14:15:56.449Z |
5489134 | 5489134 | 20241105175523_2eG2f | KR000H | 2024-11-07T14:11:21.566Z | 2024-11-08T14:15:56.168Z |
5489127 | 5489127 | 20241105175419_pMeCe | KR000H | 2024-11-07T14:11:20.327Z | 2024-11-08T14:15:55.969Z |
5489060 | 5489060 | 20241105174259_3NfYW | KR000H | 2024-11-07T14:11:14.572Z | 2024-11-08T14:15:53.752Z |
5489005 | 5489005 | 20241105173238_FEuRD | KR000H | 2024-11-07T14:11:10.244Z | 2024-11-08T14:15:52.354Z |
5488991 | 5488991 | 20241105173112_QldZ8 | KR000H | 2024-11-07T14:11:08.537Z | 2024-11-08T14:15:51.601Z |
5488949 | 5488949 | 20241105172523_CU3vm | KR000H | 2024-11-07T14:11:05.404Z | 2024-11-08T14:15:50.410Z |
5488920 | 5488920 | 20241105172055_ckpHf | KR000H | 2024-11-07T14:10:57.807Z | 2024-11-08T14:15:49.722Z |
5488901 | 5488901 | 20241105171340_yRPCH | KR000H | 2024-11-07T14:10:51.197Z | 2024-11-08T14:15:49.464Z |
5488886 | 5488886 | 20241105171020_Zcoeu | KR000H | 2024-11-07T14:10:47.923Z | 2024-11-08T14:15:48.948Z |
5488870 | 5488870 | 20241105170705_QxKz3 | KR000H | 2024-11-07T14:10:44.650Z | 2024-11-08T14:15:48.664Z |
5488779 | 5488779 | 20241105165134_qNnhN | KR000H | 2024-11-07T14:10:37.091Z | 2024-11-08T14:15:47.497Z |
5488767 | 5488767 | 20241105164953_pXZ1V | KR000H | 2024-11-07T14:10:36.679Z | 2024-11-08T14:15:47.477Z |
5488755 | 5488755 | 20241105164545_hLozI | KR000H | 2024-11-07T14:10:35.062Z | 2024-11-08T14:15:46.954Z |
5488738 | 5488738 | 20241105163957_gAMcK | KR000H | 2024-11-07T14:10:32.970Z | 2024-11-08T14:15:46.376Z |
5488725 | 5488725 | 20241105163536_oWv2W | KR000H | 2024-11-07T14:10:32.011Z | 2024-11-08T14:15:45.916Z |
5488718 | 5488718 | 20241105163501_sbbRQ | KR000H | 2024-11-07T14:10:31.415Z | 2024-11-08T14:15:45.772Z |
5488715 | 5488715 | 20241105163334_3BhIg | KR000H | 2024-11-07T14:10:31.210Z | 2024-11-08T14:15:45.737Z |
5488671 | 5488671 | 20241105161959_YDQ5Z | KR000H | 2024-11-07T14:10:27.819Z | 2024-11-08T14:15:43.828Z |
5488666 | 5488666 | 20241105161602_l3IGT | KR000H | 2024-11-07T14:10:27.350Z | 2024-11-08T14:15:43.414Z |
5488656 | 5488656 | 20241105161229_2UrxK | KR000H | 2024-11-07T14:10:26.592Z | 2024-11-08T14:15:42.887Z |
5488646 | 5488646 | 20241105161029_Z34LX | KR000H | 2024-11-07T14:10:25.279Z | 2024-11-08T14:15:42.256Z |
5488641 | 5488641 | 20241105160811_duoD7 | KR000H | 2024-11-07T14:10:24.529Z | 2024-11-08T14:15:42.075Z |
5488634 | 5488634 | 20241105160718_U5ren | KR000H | 2024-11-07T14:10:24.118Z | 2024-11-08T14:15:41.855Z |
5488587 | 5488587 | 20241105155246_YuGYG | KR000H | 2024-11-07T14:10:21.168Z | 2024-11-08T14:15:40.873Z |
5488552 | 5488552 | 20241105154042_TntxV | KR000H | 2024-11-07T14:10:17.090Z | 2024-11-08T14:15:39.684Z |
5488538 | 5488538 | 20241105153717_3kozp | KR000H | 2024-11-07T14:10:09.419Z | 2024-11-08T14:15:38.951Z |
5488462 | 5488462 | 20241105145853_3jvcw | KR000H | 2024-11-07T14:09:56.613Z | 2024-11-08T14:15:36.596Z |
5488411 | 5488411 | 20241105143350_CyQIE | KR000H | 2024-11-07T14:09:51.301Z | 2024-11-08T14:15:34.346Z |
5488405 | 5488405 | 20241105142925_4NOHJ | KR000H | 2024-11-07T14:09:49.821Z | 2024-11-08T14:15:33.641Z |
5488376 | 5488376 | 20241105141602_F5hmi | KR000H | 2024-11-07T14:09:46.837Z | 2024-11-08T14:15:31.905Z |
5488353 | 5488353 | 20241105140308_j2oRS | KR000H | 2024-11-07T14:09:43.872Z | 2024-11-08T14:15:30.397Z |
5488349 | 5488349 | 20241105140000_C9aB3 | KR000H | 2024-11-07T14:09:43.186Z | 2024-11-08T14:15:30.160Z |
5488295 | 5488295 | 20241105130216_5x75m | KR000H | 2024-11-07T14:09:27.087Z | 2024-11-08T14:15:26.986Z |
5488238 | 5488238 | 20241105121120_cTBym | KR000H | 2024-11-07T14:09:13.828Z | 2024-11-08T14:15:20.554Z |
5488212 | 5488212 | 20241105114627_QCCdt | KR000H | 2024-11-07T14:09:07.147Z | 2024-11-08T14:15:17.325Z |
5488209 | 5488209 | 20241105114346_J4T53 | KR000H | 2024-11-07T14:09:05.339Z | 2024-11-08T14:15:16.852Z |
5488201 | 5488201 | 20241105113339_PxBcq | KR000H | 2024-11-07T14:08:56.323Z | 2024-11-08T14:15:15.827Z |
5488084 | 5488084 | 20241106203625_PSq2P | KR000H | 2024-11-07T14:07:29.804Z | 2024-11-08T14:14:34.888Z |
5488069 | 5488069 | 20241106202923_pqegI | KR000H | 2024-11-07T14:07:28.399Z | 2024-11-08T14:14:34.882Z |
5488060 | 5488060 | 20241106202550_r7i4w | KR000H | 2024-11-07T14:07:27.415Z | 2024-11-08T14:14:34.876Z |
5488027 | 5488027 | 20241106201514_zNy3T | KR000H | 2024-11-07T14:07:24.482Z | 2024-11-08T14:14:34.861Z |
5488003 | 5488003 | 20241106200807_OuRpz | KR000H | 2024-11-07T14:07:22.487Z | 2024-11-08T14:14:34.851Z |
5487999 | 5487999 | 20241106200602_zVRLV | KR000H | 2024-11-07T14:07:22.157Z | 2024-11-08T14:14:34.848Z |
5487983 | 5487983 | 20241106195310_BzPD2 | KR000H | 2024-11-07T14:07:20.418Z | 2024-11-08T14:14:34.830Z |
5487949 | 5487949 | 20241106194205_C6U81 | KR000H | 2024-11-07T14:07:17.698Z | 2024-11-08T14:14:34.813Z |
5487898 | 5487898 | 20241106191930_ovl47 | KR000H | 2024-11-07T14:07:07.398Z | 2024-11-08T14:14:34.782Z |
5487880 | 5487880 | 20241106191633_gHosR | KR000H | 2024-11-07T14:07:02.048Z | 2024-11-08T14:14:34.777Z |
5487861 | 5487861 | 20241106190901_FYXkF | KR000H | 2024-11-07T14:06:58.155Z | 2024-11-08T14:14:34.767Z |
5487833 | 5487833 | 20241106190230_Ixzie | KR000H | 2024-11-07T14:06:52.658Z | 2024-11-08T14:14:34.754Z |
5487829 | 5487829 | 20241106185651_w0Vg2 | KR000H | 2024-11-07T14:06:52.057Z | 2024-11-08T14:14:34.746Z |
5487810 | 5487810 | 20241106185522_R4Y5E | KR000H | 2024-11-07T14:06:50.282Z | 2024-11-08T14:14:34.742Z |
5487772 | 5487772 | 20241106183338_zLYUO | KR000H | 2024-11-07T14:06:45.964Z | 2024-11-08T14:14:34.709Z |
5487766 | 5487766 | 20241106183159_W2saG | KR000H | 2024-11-07T14:06:45.338Z | 2024-11-08T14:14:34.706Z |
5487743 | 5487743 | 20241106182216_DR5zZ | KR000H | 2024-11-07T14:06:41.975Z | 2024-11-08T14:14:34.690Z |
5487737 | 5487737 | 20241106181913_TBu8k | KR000H | 2024-11-07T14:06:41.147Z | 2024-11-08T14:14:34.686Z |
5487735 | 5487735 | 20241106181834_kY3Y6 | KR000H | 2024-11-07T14:06:40.848Z | 2024-11-08T14:14:34.685Z |
5487709 | 5487709 | 20241106180711_BvBxd | KR000H | 2024-11-07T14:06:38.496Z | 2024-11-08T14:14:34.673Z |
5487677 | 5487677 | 20241106175250_ZBPmW | KR000H | 2024-11-07T14:06:29.603Z | 2024-11-08T14:14:34.651Z |
5487673 | 5487673 | 20241106175204_AwtSa | KR000H | 2024-11-07T14:06:28.070Z | 2024-11-08T14:14:34.650Z |
5487660 | 5487660 | 20241106174748_MKnm5 | KR000H | 2024-11-07T14:06:24.292Z | 2024-11-08T14:14:34.641Z |
5487645 | 5487645 | 20241106174338_YEQX9 | KR000H | 2024-11-07T14:06:22.778Z | 2024-11-08T14:14:34.635Z |
5487612 | 5487612 | 20241106173029_SNw2s | KR000H | 2024-11-07T14:06:19.593Z | 2024-11-08T14:14:34.618Z |
5487590 | 5487590 | 20241106172335_71DzX | KR000H | 2024-11-07T14:06:17.163Z | 2024-11-08T14:14:34.607Z |
5487579 | 5487579 | 20241106171620_Tz1te | KR000H | 2024-11-07T14:06:15.462Z | 2024-11-08T14:14:34.599Z |
5487572 | 5487572 | 20241106171313_QZxKF | KR000H | 2024-11-07T14:06:14.335Z | 2024-11-08T14:14:34.595Z |
5487561 | 5487561 | 20241106171034_pwxyG | KR000H | 2024-11-07T14:06:13.353Z | 2024-11-08T14:14:34.590Z |
5487552 | 5487552 | 20241106170913_ER24S | KR000H | 2024-11-07T14:06:12.883Z | 2024-11-08T14:14:34.586Z |
5487536 | 5487536 | 20241106170125_LWocG | KR000H | 2024-11-07T14:06:10.865Z | 2024-11-08T14:14:34.576Z |
5487534 | 5487534 | 20241106170118_3VM2w | KR000H | 2024-11-07T14:06:10.516Z | 2024-11-08T14:14:34.575Z |
5487516 | 5487516 | 20241106164813_Q985S | KR000H | 2024-11-07T14:06:07.910Z | 2024-11-08T14:14:34.561Z |
5487512 | 5487512 | 20241106164538_L3ZyG | KR000H | 2024-11-07T14:06:07.076Z | 2024-11-08T14:14:34.560Z |
5487497 | 5487497 | 20241106164006_3If8N | KR000H | 2024-11-07T14:06:05.136Z | 2024-11-08T14:14:34.555Z |
5487464 | 5487464 | 20241106162616_LWcb2 | KR000H | 2024-11-07T14:05:52.209Z | 2024-11-08T14:14:34.542Z |
5487453 | 5487453 | 20241106162311_xmrvr | KR000H | 2024-11-07T14:05:50.479Z | 2024-11-08T14:14:34.539Z |
5487423 | 5487423 | 20241106160521_WXA3Y | KR000H | 2024-11-07T14:05:44.968Z | 2024-11-08T14:14:34.522Z |
5487348 | 5487348 | 20241106154224_EYxpI | KR000H | 2024-11-07T14:05:34.867Z | 2024-11-08T14:14:34.494Z |
5487300 | 5487300 | 20241106153557_bmxCO | KR000H | 2024-11-07T14:05:30.004Z | 2024-11-08T14:14:34.485Z |
5487165 | 5487165 | 20241106150144_ZFS1K | KR000H | 2024-11-07T14:05:04.789Z | 2024-11-08T14:14:34.438Z |
5487069 | 5487069 | 20241106144022_vVnuD | KR000H | 2024-11-07T14:04:54.935Z | 2024-11-08T14:14:34.411Z |
5487025 | 5487025 | 20241106142836_bVCpj | KR000H | 2024-11-07T14:04:43.114Z | 2024-11-08T14:14:34.397Z |
5486986 | 5486986 | 20241106141538_z1ox7 | KR000H | 2024-11-07T14:04:33.635Z | 2024-11-08T14:14:34.383Z |
5486964 | 5486964 | 20241106141219_oSkh2 | KR000H | 2024-11-07T14:04:31.414Z | 2024-11-08T14:14:34.379Z |
5486958 | 5486958 | 20241106141103_J2p7u | KR000H | 2024-11-07T14:04:29.642Z | 2024-11-08T14:14:34.377Z |
5486849 | 5486849 | 20241106134201_sweLq | KR000H | 2024-11-07T14:04:15.432Z | 2024-11-08T14:14:34.350Z |
5486808 | 5486808 | 20241106133022_dnlsb | KR000H | 2024-11-07T14:04:09.478Z | 2024-11-08T14:14:34.339Z |
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);