participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "KR0004" 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 |
|---|---|---|---|---|---|
| 9824585 | 9824585 | 20260430193341_rdIaF | KR0004 | 2026-05-01T12:02:24.268Z | 2026-05-02T12:13:43.500Z |
| 9805354 | 9805354 | 20260426190923_OVlLQ | KR0004 | 2026-04-28T12:06:33.548Z | 2026-05-02T12:40:26.482Z |
| 9805326 | 9805326 | 20260426190023_qlCOW | KR0004 | 2026-04-28T12:06:28.882Z | 2026-05-02T12:40:24.403Z |
| 9805272 | 9805272 | 20260426182201_22Vkk | KR0004 | 2026-04-28T12:06:06.000Z | 2026-05-02T12:40:21.805Z |
| 9805102 | 9805102 | 20260426171953_dI7C4 | KR0004 | 2026-04-28T12:04:59.974Z | 2026-05-02T12:39:58.896Z |
| 9805081 | 9805081 | 20260426170245_hg2oq | KR0004 | 2026-04-28T12:04:30.829Z | 2026-05-02T12:39:54.090Z |
| 9805068 | 9805068 | 20260426165732_8Cccd | KR0004 | 2026-04-28T12:04:24.830Z | 2026-05-02T12:39:52.390Z |
| 9804997 | 9804997 | 20260426160855_cNWvO | KR0004 | 2026-04-28T12:02:46.027Z | 2026-05-02T12:39:33.574Z |
| 9804993 | 9804993 | 20260426160121_z21oA | KR0004 | 2026-04-28T12:02:34.027Z | 2026-05-02T12:39:29.436Z |
| 9803561 | 9803561 | 20260425111333_uVyOv | KR0004 | 2026-04-27T12:50:00.395Z | 2026-05-02T13:03:59.834Z |
| 9796878 | 9796878 | 20260425191649_Zn53h | KR0004 | 2026-04-27T12:17:12.668Z | 2026-05-02T12:49:11.657Z |
| 9796852 | 9796852 | 20260425191115_h62DP | KR0004 | 2026-04-27T12:17:06.345Z | 2026-05-02T12:49:10.346Z |
| 9796848 | 9796848 | 20260425190918_GZvrx | KR0004 | 2026-04-27T12:17:05.224Z | 2026-05-02T12:49:09.911Z |
| 9796653 | 9796653 | 20260425183127_9bwW6 | KR0004 | 2026-04-27T12:16:06.720Z | 2026-05-02T12:49:00.266Z |
| 9796599 | 9796599 | 20260425182354_hQ3mQ | KR0004 | 2026-04-27T12:15:50.157Z | 2026-05-02T12:48:47.804Z |
| 9796587 | 9796587 | 20260425182251_RSaH9 | KR0004 | 2026-04-27T12:15:47.982Z | 2026-05-02T12:48:47.227Z |
| 9796546 | 9796546 | 20260425181403_raFnF | KR0004 | 2026-04-27T12:15:40.409Z | 2026-05-02T12:48:46.102Z |
| 9795850 | 9795850 | 20260425172247_RH3PF | KR0004 | 2026-04-27T12:13:35.698Z | 2026-05-02T12:48:14.338Z |
| 9795007 | 9795007 | 20260425163435_ak3kJ | KR0004 | 2026-04-27T12:11:18.023Z | 2026-05-02T12:47:37.841Z |
| 9794697 | 9794697 | 20260425161148_3UYo3 | KR0004 | 2026-04-27T12:10:21.601Z | 2026-05-02T12:47:27.056Z |
| 9794456 | 9794456 | 20260425155220_3s5Oe | KR0004 | 2026-04-27T12:09:38.689Z | 2026-05-02T12:47:13.386Z |
| 9793982 | 9793982 | 20260425151357_jNcjm | KR0004 | 2026-04-27T12:08:18.853Z | 2026-05-02T12:46:57.764Z |
| 9793653 | 9793653 | 20260425145626_SB83e | KR0004 | 2026-04-27T12:07:27.258Z | 2026-05-02T12:46:41.507Z |
| 9793121 | 9793121 | 20260425141734_GZom1 | KR0004 | 2026-04-27T12:05:43.712Z | 2026-05-02T12:46:15.571Z |
| 9793057 | 9793057 | 20260425141224_ocdge | KR0004 | 2026-04-27T12:05:31.487Z | 2026-05-02T12:46:12.409Z |
| 9792904 | 9792904 | 20260425140122_2IYXw | KR0004 | 2026-04-27T12:05:03.528Z | 2026-05-02T12:46:08.717Z |
| 9788641 | 9788641 | 20260423195231_83F33 | KR0004 | 2026-04-26T12:27:17.532Z | 2026-05-02T13:07:47.192Z |
| 9782598 | 9782598 | 20260424192446_87F3S | KR0004 | 2026-04-26T12:12:17.647Z | 2026-05-02T12:58:33.196Z |
| 9782554 | 9782554 | 20260424191617_vYWxw | KR0004 | 2026-04-26T12:12:13.170Z | 2026-05-02T12:58:28.714Z |
| 9782489 | 9782489 | 20260424191046_45H34 | KR0004 | 2026-04-26T12:12:03.967Z | 2026-05-02T12:58:15.143Z |
| 9782213 | 9782213 | 20260424182039_n6Oxk | KR0004 | 2026-04-26T12:11:25.002Z | 2026-05-02T12:58:04.553Z |
| 9782163 | 9782163 | 20260424181436_E1v02 | KR0004 | 2026-04-26T12:11:20.807Z | 2026-05-02T12:58:03.340Z |
| 9782073 | 9782073 | 20260424180809_xPf8O | KR0004 | 2026-04-26T12:11:04.523Z | 2026-05-02T12:58:00.266Z |
| 9782061 | 9782061 | 20260424180725_lk9SL | KR0004 | 2026-04-26T12:11:02.513Z | 2026-05-02T12:58:00.029Z |
| 9782057 | 9782057 | 20260424180721_uVYSC | KR0004 | 2026-04-26T12:11:01.667Z | 2026-05-02T12:57:59.885Z |
| 9782027 | 9782027 | 20260424180423_DPS5k | KR0004 | 2026-04-26T12:10:57.034Z | 2026-05-02T12:57:58.732Z |
| 9782006 | 9782006 | 20260424180222_3lPVg | KR0004 | 2026-04-26T12:10:55.092Z | 2026-05-02T12:57:58.148Z |
| 9781899 | 9781899 | 20260424175706_MlpzU | KR0004 | 2026-04-26T12:10:47.011Z | 2026-05-02T12:57:56.230Z |
| 9781863 | 9781863 | 20260424175415_9qHn5 | KR0004 | 2026-04-26T12:10:43.543Z | 2026-05-02T12:57:55.533Z |
| 9781799 | 9781799 | 20260424174948_RlAYI | KR0004 | 2026-04-26T12:10:23.969Z | 2026-05-02T12:57:54.327Z |
| 9781594 | 9781594 | 20260424173739_oe5ej | KR0004 | 2026-04-26T12:10:01.571Z | 2026-05-02T12:57:34.595Z |
| 9780473 | 9780473 | 20260424163300_eisTT | KR0004 | 2026-04-26T12:07:51.973Z | 2026-05-02T12:56:49.834Z |
| 9780141 | 9780141 | 20260424161400_xXDW6 | KR0004 | 2026-04-26T12:07:10.337Z | 2026-05-02T12:56:41.639Z |
| 9780115 | 9780115 | 20260424161303_1DIzi | KR0004 | 2026-04-26T12:07:08.428Z | 2026-05-02T12:56:40.945Z |
| 9779611 | 9779611 | 20260424154324_bRNeS | KR0004 | 2026-04-26T12:06:00.099Z | 2026-05-02T12:56:30.522Z |
| 9777961 | 9777961 | 20260424141053_DyR28 | KR0004 | 2026-04-26T12:02:30.521Z | 2026-05-02T12:55:23.096Z |
| 9777787 | 9777787 | 20260424140047_p7KrA | KR0004 | 2026-04-26T12:02:04.494Z | 2026-05-02T12:55:18.508Z |
| 9777762 | 9777762 | 20260424135933_d8nRG | KR0004 | 2026-04-26T12:01:56.214Z | 2026-05-02T12:55:17.982Z |
| 9776710 | 9776710 | 20260423121520_fdJzZ | KR0004 | 2026-04-25T12:59:08.320Z | 2026-04-30T13:15:13.180Z |
| 9764017 | 9764017 | 20260423195540_2yc75 | KR0004 | 2026-04-25T12:14:33.180Z | 2026-05-02T13:07:47.774Z |
| 9763925 | 9763925 | 20260423193400_u8gJr | KR0004 | 2026-04-25T12:14:14.085Z | 2026-05-02T13:07:44.695Z |
| 9763898 | 9763898 | 20260423192951_x2Dtv | KR0004 | 2026-04-25T12:14:07.690Z | 2026-05-02T13:07:44.079Z |
| 9763847 | 9763847 | 20260423192057_cUuaU | KR0004 | 2026-04-25T12:13:57.263Z | 2026-05-02T13:07:42.289Z |
| 9763746 | 9763746 | 20260423185523_ZXXSu | KR0004 | 2026-04-25T12:13:33.183Z | 2026-05-02T13:07:39.326Z |
| 9763728 | 9763728 | 20260423185456_Nc3Rz | KR0004 | 2026-04-25T12:13:32.014Z | 2026-05-02T13:07:39.180Z |
| 9763662 | 9763662 | 20260423184639_PzMCD | KR0004 | 2026-04-25T12:13:25.791Z | 2026-05-02T13:07:37.731Z |
| 9763627 | 9763627 | 20260423184020_deMLd | KR0004 | 2026-04-25T12:13:16.552Z | 2026-05-02T13:07:36.985Z |
| 9763599 | 9763599 | 20260423183334_HKs5A | KR0004 | 2026-04-25T12:13:10.660Z | 2026-05-02T13:07:36.560Z |
| 9763554 | 9763554 | 20260423182521_gcPv3 | KR0004 | 2026-04-25T12:13:04.776Z | 2026-05-02T13:07:35.940Z |
| 9763063 | 9763063 | 20260423172850_Wuji0 | KR0004 | 2026-04-25T12:11:32.572Z | 2026-05-02T13:07:06.206Z |
| 9763031 | 9763031 | 20260423172713_ckG7d | KR0004 | 2026-04-25T12:11:26.067Z | 2026-05-02T13:07:05.718Z |
| 9763025 | 9763025 | 20260423172650_QBY2c | KR0004 | 2026-04-25T12:11:24.876Z | 2026-05-02T13:07:05.538Z |
| 9760160 | 9760160 | 20260423135407_03owV | KR0004 | 2026-04-25T12:02:58.083Z | 2026-05-02T13:05:19.343Z |
| 9723630 | 9723630 | 20260420194237_enUaE | KR0004 | 2026-04-22T12:11:22.308Z | 2026-04-29T13:19:06.000Z |
| 9723506 | 9723506 | 20260420191416_onE36 | KR0004 | 2026-04-22T12:11:00.903Z | 2026-04-29T13:19:04.695Z |
| 9723504 | 9723504 | 20260420191336_IQDE7 | KR0004 | 2026-04-22T12:11:00.202Z | 2026-04-29T13:19:04.655Z |
| 9723442 | 9723442 | 20260420185834_Fomj8 | KR0004 | 2026-04-22T12:10:47.548Z | 2026-04-29T13:19:03.789Z |
| 9723376 | 9723376 | 20260420183802_WttlX | KR0004 | 2026-04-22T12:10:27.704Z | 2026-04-29T13:19:02.590Z |
| 9723356 | 9723356 | 20260420183411_z2nXZ | KR0004 | 2026-04-22T12:10:25.175Z | 2026-04-29T13:19:02.238Z |
| 9723328 | 9723328 | 20260420182832_Y2IDa | KR0004 | 2026-04-22T12:10:18.129Z | 2026-04-29T13:19:02.125Z |
| 9723270 | 9723270 | 20260420181523_PsIPJ | KR0004 | 2026-04-22T12:10:07.542Z | 2026-04-29T13:19:01.479Z |
| 9723238 | 9723238 | 20260420180333_GMoau | KR0004 | 2026-04-22T12:10:00.628Z | 2026-04-29T13:18:59.653Z |
| 9716076 | 9716076 | 20260419173440_lsiPj | KR0004 | 2026-04-21T12:14:45.893Z | 2026-04-28T13:35:57.594Z |
| 9716001 | 9716001 | 20260419171555_5ru12 | KR0004 | 2026-04-21T12:14:17.890Z | 2026-04-28T13:35:55.215Z |
| 9715988 | 9715988 | 20260419171305_39T6O | KR0004 | 2026-04-21T12:14:15.535Z | 2026-04-28T13:35:54.843Z |
| 9714118 | 9714118 | 20260420142037_ESZwl | KR0004 | 2026-04-21T12:04:34.880Z | 2026-04-29T13:17:55.600Z |
| 9713976 | 9713976 | 20260420134738_k0dBf | KR0004 | 2026-04-21T12:03:52.014Z | 2026-04-29T13:17:53.903Z |
| 9713647 | 9713647 | 20260420122508_PCImJ | KR0004 | 2026-04-21T12:02:16.265Z | 2026-04-29T13:17:49.610Z |
| 9713506 | 9713506 | 20260420114605_cP7fj | KR0004 | 2026-04-21T12:01:32.734Z | 2026-04-29T13:17:47.452Z |
| 9713325 | 9713325 | 20260420111009_1uS3E | KR0004 | 2026-04-21T12:00:54.521Z | 2026-04-29T13:17:44.995Z |
| 9688501 | 9688501 | 20260415200249_A4Brd | KR0004 | 2026-04-17T12:25:10.491Z | 2026-04-24T12:24:38.550Z |
| 9688397 | 9688397 | 20260415193530_eXev3 | KR0004 | 2026-04-17T12:24:54.423Z | 2026-04-24T12:24:37.278Z |
| 9688230 | 9688230 | 20260415190434_SbAmr | KR0004 | 2026-04-17T12:24:16.576Z | 2026-04-24T12:24:34.927Z |
| 9687953 | 9687953 | 20260415180534_FNP15 | KR0004 | 2026-04-17T12:23:11.998Z | 2026-04-24T12:24:13.226Z |
| 9687817 | 9687817 | 20260415174543_p8q34 | KR0004 | 2026-04-17T12:22:45.361Z | 2026-04-24T12:24:11.377Z |
| 9687564 | 9687564 | 20260415165234_FOAyO | KR0004 | 2026-04-17T12:21:39.854Z | 2026-04-24T12:24:06.347Z |
| 9687546 | 9687546 | 20260415164751_lKNY7 | KR0004 | 2026-04-17T12:21:28.288Z | 2026-04-24T12:24:05.987Z |
| 9687500 | 9687500 | 20260415163608_AEnPz | KR0004 | 2026-04-17T12:21:14.583Z | 2026-04-24T12:24:04.909Z |
| 9687486 | 9687486 | 20260415163302_UPlX3 | KR0004 | 2026-04-17T12:21:12.899Z | 2026-04-24T12:24:04.693Z |
| 9687384 | 9687384 | 20260415161031_BDURc | KR0004 | 2026-04-17T12:20:44.958Z | 2026-04-24T12:24:02.803Z |
| 9687220 | 9687220 | 20260415151655_1gyeq | KR0004 | 2026-04-17T12:19:56.418Z | 2026-04-24T12:23:58.751Z |
| 9687208 | 9687208 | 20260415150836_x6VJK | KR0004 | 2026-04-17T12:19:53.280Z | 2026-04-24T12:23:58.271Z |
| 9687020 | 9687020 | 20260415135648_Vr7BP | KR0004 | 2026-04-17T12:18:31.867Z | 2026-04-24T12:23:34.879Z |
| 9686903 | 9686903 | 20260415132212_K4STs | KR0004 | 2026-04-17T12:17:48.909Z | 2026-04-24T12:23:30.656Z |
| 9686834 | 9686834 | 20260415130356_u2j3k | KR0004 | 2026-04-17T12:17:28.244Z | 2026-04-24T12:23:29.000Z |
| 9686688 | 9686688 | 20260415112954_HaNSK | KR0004 | 2026-04-17T12:16:17.859Z | 2026-04-24T12:23:21.714Z |
| 9643983 | 9643983 | 20260410193220_bOEni | KR0004 | 2026-04-12T12:16:13.584Z | 2026-04-19T13:20:30.262Z |
| 9643899 | 9643899 | 20260410185647_Vxs2n | KR0004 | 2026-04-12T12:15:46.931Z | 2026-04-19T13:20:24.322Z |
| 9643894 | 9643894 | 20260410185317_L79FJ | KR0004 | 2026-04-12T12:15:46.197Z | 2026-04-19T13:20:24.021Z |
| 9643614 | 9643614 | 20260410173831_WBshP | KR0004 | 2026-04-12T12:14:44.401Z | 2026-04-19T13:19:59.410Z |
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);