home / gmn_data_store / participating_station

Menu
  • Dashboards

participating_station

Each row represents a station recording a meteor sighting.

Data license: CC BY 4.0 license · Data source: Global Meteor Network

6,794 rows where station_code = "KR003J" sorted by created_at descending

✎ View and edit SQL

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
9583747 9583747 20260326174043_xhNpu KR003J 2026-03-27T12:09:39.393Z 2026-04-04T12:41:37.131Z
9569977 9569977 20260322184134_iwJPl KR003J 2026-03-24T12:22:25.123Z 2026-03-30T12:30:25.713Z
9569950 9569950 20260322183307_PrHqy KR003J 2026-03-24T12:22:22.961Z 2026-03-30T12:30:25.249Z
9569946 9569946 20260322183230_IqjAK KR003J 2026-03-24T12:22:22.680Z 2026-03-30T12:30:25.189Z
9569902 9569902 20260322182411_NbkJv KR003J 2026-03-24T12:22:19.895Z 2026-03-30T12:30:24.687Z
9568449 9568449 20260323164541_wiLji KR003J 2026-03-24T12:15:08.492Z 2026-03-31T12:28:29.425Z
9568113 9568113 20260323161438_Icb32 KR003J 2026-03-24T12:14:35.006Z 2026-03-31T12:28:23.164Z
9548350 9548350 20260321145529_vo2Cw KR003J 2026-03-22T12:15:17.026Z 2026-03-29T12:20:25.493Z
9547393 9547393 20260321132337_L16vX KR003J 2026-03-22T12:13:34.099Z 2026-03-29T12:20:09.235Z
9547312 9547312 20260321131533_Oat74 KR003J 2026-03-22T12:13:24.283Z 2026-03-29T12:20:08.557Z
9541292 9541292 20260319201342_PX6xK KR003J 2026-03-21T12:28:48.489Z 2026-03-27T12:42:36.299Z
9541254 9541254 20260319201037_rZVN4 KR003J 2026-03-21T12:28:46.764Z 2026-03-27T12:42:35.938Z
9541249 9541249 20260319201034_ohr5J KR003J 2026-03-21T12:28:46.470Z 2026-03-27T12:42:35.892Z
9541182 9541182 20260319195410_Cp84A KR003J 2026-03-21T12:28:42.086Z 2026-03-27T12:42:35.013Z
9541139 9541139 20260319193932_cpeOW KR003J 2026-03-21T12:28:38.973Z 2026-03-27T12:42:34.436Z
9541000 9541000 20260319185144_3LaR2 KR003J 2026-03-21T12:28:22.378Z 2026-03-27T12:42:32.796Z
9540930 9540930 20260319183358_3AY9L KR003J 2026-03-21T12:28:17.111Z 2026-03-27T12:42:32.058Z
9540854 9540854 20260319181524_y0iCb KR003J 2026-03-21T12:28:13.357Z 2026-03-27T12:42:31.562Z
9540841 9540841 20260319181456_tke27 KR003J 2026-03-21T12:28:12.635Z 2026-03-27T12:42:31.430Z
9540796 9540796 20260319180010_3EsOH KR003J 2026-03-21T12:28:09.694Z 2026-03-27T12:42:31.068Z
9540660 9540660 20260319171329_Qvvs3 KR003J 2026-03-21T12:27:48.381Z 2026-03-27T12:42:29.080Z
9540498 9540498 20260319155952_KBV47 KR003J 2026-03-21T12:27:05.422Z 2026-03-27T12:42:23.170Z
9540476 9540476 20260319154741_5a1mX KR003J 2026-03-21T12:27:02.633Z 2026-03-27T12:42:22.422Z
9540469 9540469 20260319154735_4CwGQ KR003J 2026-03-21T12:27:02.424Z 2026-03-27T12:42:22.405Z
9540436 9540436 20260319154041_TO887 KR003J 2026-03-21T12:27:00.028Z 2026-03-27T12:42:21.798Z
9540339 9540339 20260319152027_bHz8o KR003J 2026-03-21T12:26:52.062Z 2026-03-27T12:42:20.000Z
9540328 9540328 20260319151501_t2mxC KR003J 2026-03-21T12:26:50.601Z 2026-03-27T12:42:19.636Z
9540279 9540279 20260319145515_4Ew6o KR003J 2026-03-21T12:26:37.075Z 2026-03-27T12:42:05.636Z
9540024 9540024 20260319123224_3I3zZ KR003J 2026-03-21T12:25:56.581Z 2026-03-27T12:41:56.363Z
9539912 9539912 20260319105434_R20ns KR003J 2026-03-21T12:25:11.662Z 2026-03-27T12:41:46.202Z
9527698 9527698 20260318150646_I21C6 KR003J 2026-03-20T12:21:38.600Z 2026-03-26T12:38:30.548Z
9491749 9491749 20260315191920_ApD3e KR003J 2026-03-16T12:21:44.271Z 2026-03-23T12:22:41.405Z
9491640 9491640 20260315174141_KoR2y KR003J 2026-03-16T12:21:25.840Z 2026-03-23T12:22:40.188Z
9491628 9491628 20260315172951_3xw9R KR003J 2026-03-16T12:21:23.870Z 2026-03-23T12:22:40.095Z
9491502 9491502 20260315170051_xl1T7 KR003J 2026-03-16T12:21:08.590Z 2026-03-23T12:22:39.691Z
9473556 9473556 20260313172131_Hpu7W KR003J 2026-03-14T12:15:18.685Z 2026-03-21T12:49:58.619Z
9473210 9473210 20260313160815_pswG7 KR003J 2026-03-14T12:14:38.124Z 2026-03-21T12:49:54.926Z
9473137 9473137 20260313155503_ZIdGh KR003J 2026-03-14T12:14:32.280Z 2026-03-21T12:49:54.405Z
9472685 9472685 20260313144333_ghr1d KR003J 2026-03-14T12:13:41.602Z 2026-03-21T12:49:50.767Z
9472563 9472563 20260313142047_3buz3 KR003J 2026-03-14T12:13:25.747Z 2026-03-21T12:49:49.567Z
9472338 9472338 20260313134601_gB13f KR003J 2026-03-14T12:12:58.657Z 2026-03-21T12:49:48.023Z
9454385 9454385 20260310160641_s4qaE KR003J 2026-03-11T12:09:11.745Z 2026-03-18T12:39:45.550Z
9454249 9454249 20260310154544_bMazL KR003J 2026-03-11T12:08:58.857Z 2026-03-18T12:39:44.519Z
9453968 9453968 20260310150637_dkSA6 KR003J 2026-03-11T12:08:30.063Z 2026-03-18T12:39:42.194Z
9443513 9443513 20260308103642_349a8 KR003J 2026-03-09T12:08:05.191Z 2026-03-16T12:44:05.122Z
9440645 9440645 20260307204941_Nmgpy KR003J 2026-03-08T12:14:09.043Z 2026-03-15T12:42:11.950Z
9440634 9440634 20260307204034_F11T5 KR003J 2026-03-08T12:14:07.325Z 2026-03-15T12:42:11.378Z
9440601 9440601 20260307202222_iXYU6 KR003J 2026-03-08T12:14:01.611Z 2026-03-15T12:42:10.732Z
9440578 9440578 20260307200530_VBooN KR003J 2026-03-08T12:13:56.858Z 2026-03-15T12:42:09.996Z
9440482 9440482 20260307185618_1tBdh KR003J 2026-03-08T12:13:44.196Z 2026-03-15T12:42:07.400Z
9440334 9440334 20260307172030_GFPYP KR003J 2026-03-08T12:13:22.517Z 2026-03-15T12:42:05.148Z
9440289 9440289 20260307170023_wowvQ KR003J 2026-03-08T12:13:16.370Z 2026-03-15T12:42:04.705Z
9440143 9440143 20260307161744_XCpiq KR003J 2026-03-08T12:12:45.548Z 2026-03-15T12:42:03.504Z
9439906 9439906 20260307152147_CchKD KR003J 2026-03-08T12:12:01.022Z 2026-03-15T12:42:01.257Z
9439844 9439844 20260307150735_Fkten KR003J 2026-03-08T12:11:45.889Z 2026-03-15T12:42:00.736Z
9439820 9439820 20260307150135_NFGLU KR003J 2026-03-08T12:11:42.325Z 2026-03-15T12:42:00.552Z
9439678 9439678 20260307143249_vVlY3 KR003J 2026-03-08T12:11:10.343Z 2026-03-15T12:41:44.763Z
9439453 9439453 20260307134537_VtPyZ KR003J 2026-03-08T12:10:27.156Z 2026-03-15T12:41:42.733Z
9439281 9439281 20260307130255_puwSH KR003J 2026-03-08T12:10:01.423Z 2026-03-15T12:41:41.351Z
9438494 9438494 20260307103652_x87Mx KR003J 2026-03-08T12:07:40.953Z 2026-03-15T12:41:32.621Z
9408650 9408650 20260227201629_pXojk KR003J 2026-02-28T14:26:16.261Z 2026-03-07T14:51:03.260Z
9408564 9408564 20260227194311_2Gg5J KR003J 2026-02-28T14:26:03.130Z 2026-03-07T14:50:58.192Z
9408503 9408503 20260227192615_kRftQ KR003J 2026-02-28T14:25:58.162Z 2026-03-07T14:50:56.007Z
9408463 9408463 20260227190902_cHpc3 KR003J 2026-02-28T14:25:52.886Z 2026-03-07T14:50:54.069Z
9389686 9389686 20260224195653_28xoZ KR003J 2026-02-25T14:25:19.582Z 2026-03-04T14:19:20.648Z
9389648 9389648 20260224194600_njJS8 KR003J 2026-02-25T14:25:13.138Z 2026-03-04T14:19:19.958Z
9381046 9381046 20260222204943_eLo3n KR003J 2026-02-24T14:24:06.435Z 2026-02-24T14:24:06.435Z
9380699 9380699 20260222201029_zzX9o KR003J 2026-02-24T14:23:35.394Z 2026-02-24T14:23:35.394Z
9380221 9380221 20260222191126_eGBnv KR003J 2026-02-24T14:22:48.849Z 2026-02-24T14:22:48.849Z
9380197 9380197 20260222190506_DKyId KR003J 2026-02-24T14:22:46.156Z 2026-02-24T14:22:46.156Z
9380133 9380133 20260222185738_Uww9k KR003J 2026-02-24T14:22:41.536Z 2026-02-24T14:22:41.536Z
9379627 9379627 20260222173609_5I9fb KR003J 2026-02-24T14:21:54.701Z 2026-02-24T14:21:54.701Z
9378902 9378902 20260222153206_Pqezo KR003J 2026-02-24T14:20:08.902Z 2026-02-24T14:20:08.902Z
9378841 9378841 20260222152109_TGbGV KR003J 2026-02-24T14:19:59.052Z 2026-02-24T14:19:59.052Z
9378774 9378774 20260222151132_o410U KR003J 2026-02-24T14:19:46.736Z 2026-02-24T14:19:46.736Z
9378535 9378535 20260222141724_rM15L KR003J 2026-02-24T14:18:58.611Z 2026-02-24T14:18:58.611Z
9378499 9378499 20260222140601_xkcFR KR003J 2026-02-24T14:18:49.573Z 2026-02-24T14:18:49.573Z
9378433 9378433 20260222135114_IEEct KR003J 2026-02-24T14:18:36.310Z 2026-02-24T14:18:36.310Z
9378417 9378417 20260222134809_nuFHs KR003J 2026-02-24T14:18:33.764Z 2026-02-24T14:18:33.764Z
9378388 9378388 20260222133917_suU7S KR003J 2026-02-24T14:18:27.751Z 2026-02-24T14:18:27.751Z
9378357 9378357 20260222133144_cIyeK KR003J 2026-02-24T14:18:24.095Z 2026-02-24T14:18:24.095Z
9378325 9378325 20260222132235_LNQEi KR003J 2026-02-24T14:18:16.889Z 2026-02-24T14:18:16.889Z
9378050 9378050 20260222113210_u81O9 KR003J 2026-02-24T14:16:59.719Z 2026-02-24T14:16:59.719Z
9378043 9378043 20260222113210_vrOpm KR003J 2026-02-24T14:16:59.333Z 2026-02-24T14:16:59.333Z
9378031 9378031 20260222110802_Bvc4p KR003J 2026-02-24T14:16:51.604Z 2026-02-24T14:16:51.604Z
9378024 9378024 20260222110641_nkxZf KR003J 2026-02-24T14:16:51.035Z 2026-02-24T14:16:51.035Z
9371713 9371713 20260221192026_pDHRP KR003J 2026-02-23T14:25:04.035Z 2026-03-02T14:22:14.663Z
9371607 9371607 20260221185225_dCU8j KR003J 2026-02-23T14:24:44.475Z 2026-03-02T14:22:13.367Z
9371528 9371528 20260221183340_p3ylt KR003J 2026-02-23T14:24:33.257Z 2026-03-02T14:22:11.401Z
9371464 9371464 20260221181837_KqP2s KR003J 2026-02-23T14:24:21.171Z 2026-03-02T14:22:10.631Z
9371442 9371442 20260221181627_1UCC2 KR003J 2026-02-23T14:24:16.427Z 2026-03-02T14:22:10.411Z
9363961 9363961 20260220182228_ARMSs KR003J 2026-02-22T14:20:22.848Z 2026-03-01T14:22:49.397Z
9362589 9362589 20260221184545_jQ3vx KR003J 2026-02-22T14:13:35.283Z 2026-03-02T14:22:13.010Z
9362587 9362587 20260221184137_3XVY2 KR003J 2026-02-22T14:13:34.821Z 2026-03-02T14:22:11.955Z
9357698 9357698 20260219193229_r26yC KR003J 2026-02-21T14:16:39.304Z 2026-02-28T14:44:40.571Z
9357324 9357324 20260219174412_2QIPG KR003J 2026-02-21T14:15:46.238Z 2026-02-28T14:44:32.118Z
9357114 9357114 20260219164108_Ls6gs KR003J 2026-02-21T14:15:14.964Z 2026-02-28T14:44:27.581Z
9356728 9356728 20260219143200_q3oKb KR003J 2026-02-21T14:13:29.302Z 2026-02-28T14:44:05.026Z
9351495 9351495 20260217202255_2XdpI KR003J 2026-02-20T14:02:44.906Z 2026-02-26T14:40:08.343Z
9351417 9351417 20260217200140_2EOEP KR003J 2026-02-20T14:02:44.444Z 2026-02-26T14:40:07.175Z

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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);
Powered by Datasette · Queries took 1.2ms · Data license: CC BY 4.0 license · Data source: Global Meteor Network