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

7,840 rows where station_code = "KR000M" 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
9583830 9583830 20260326190123_hU8J5 KR000M 2026-03-27T12:09:54.011Z 2026-04-04T12:41:40.582Z
9583450 9583450 20260326150241_oMkuI KR000M 2026-03-27T12:08:50.567Z 2026-04-04T12:41:12.992Z
9583424 9583424 20260326145345_39Zzh KR000M 2026-03-27T12:08:45.650Z 2026-04-04T12:41:11.293Z
9578830 9578830 20260325150719_tJVzQ KR000M 2026-03-26T12:08:38.607Z 2026-04-03T12:38:35.350Z
9578827 9578827 20260325150708_fuy7K KR000M 2026-03-26T12:08:38.237Z 2026-04-03T12:38:35.224Z
9570191 9570191 20260322194702_3IR7V KR000M 2026-03-24T12:22:46.914Z 2026-03-30T12:30:29.389Z
9570120 9570120 20260322191724_o1QOt KR000M 2026-03-24T12:22:37.013Z 2026-03-30T12:30:28.064Z
9569948 9569948 20260322183307_PrHqy KR000M 2026-03-24T12:22:22.961Z 2026-03-30T12:30:25.249Z
9569945 9569945 20260322183230_IqjAK KR000M 2026-03-24T12:22:22.680Z 2026-03-30T12:30:25.188Z
9569613 9569613 20260322162510_SYWEk KR000M 2026-03-24T12:21:29.769Z 2026-03-30T12:30:11.185Z
9569404 9569404 20260322152248_FLCOn KR000M 2026-03-24T12:20:52.506Z 2026-03-30T12:29:52.788Z
9568920 9568920 20260322112254_tmZAu KR000M 2026-03-24T12:18:58.983Z 2026-03-30T12:29:08.475Z
9568681 9568681 20260323171144_wRfI5 KR000M 2026-03-24T12:15:33.248Z 2026-03-24T12:24:25.506Z
9568301 9568301 20260323163011_rdaJA KR000M 2026-03-24T12:14:51.441Z 2026-03-31T12:28:27.077Z
9567998 9567998 20260323160532_xOos4 KR000M 2026-03-24T12:14:22.307Z 2026-03-24T12:24:25.374Z
9567942 9567942 20260323160147_72ihg KR000M 2026-03-24T12:14:19.262Z 2026-03-31T12:28:20.973Z
9567929 9567929 20260323160117_i7nvL KR000M 2026-03-24T12:14:18.137Z 2026-03-31T12:28:20.804Z
9567226 9567226 20260323145418_sdQS5 KR000M 2026-03-24T12:13:14.831Z 2026-03-31T12:28:10.706Z
9567201 9567201 20260323145238_rz64o KR000M 2026-03-24T12:13:12.778Z 2026-03-24T12:24:25.233Z
9566408 9566408 20260323133505_z5xe7 KR000M 2026-03-24T12:11:48.893Z 2026-03-31T12:27:50.381Z
9565385 9565385 20260323120429_ZmZKf KR000M 2026-03-24T12:10:00.400Z 2026-03-31T12:27:34.172Z
9551585 9551585 20260320202549_D1Qk2 KR000M 2026-03-22T12:26:49.674Z 2026-03-28T12:36:58.388Z
9551449 9551449 20260320195207_MNfF7 KR000M 2026-03-22T12:26:41.188Z 2026-03-28T12:36:53.549Z
9551393 9551393 20260320194052_2jAP8 KR000M 2026-03-22T12:26:37.815Z 2026-03-28T12:36:49.927Z
9551226 9551226 20260320190028_7Ij3G KR000M 2026-03-22T12:26:19.338Z 2026-03-28T12:36:41.224Z
9550982 9550982 20260320173321_xpxLC KR000M 2026-03-22T12:26:03.074Z 2026-03-28T12:36:38.571Z
9550959 9550959 20260320172913_0Mrjb KR000M 2026-03-22T12:26:01.102Z 2026-03-28T12:36:38.259Z
9550893 9550893 20260320172137_y821r KR000M 2026-03-22T12:25:49.789Z 2026-03-28T12:36:37.357Z
9550791 9550791 20260320171157_DsiTd KR000M 2026-03-22T12:25:45.407Z 2026-03-28T12:36:36.102Z
9550728 9550728 20260320170718_3UbAK KR000M 2026-03-22T12:25:40.225Z 2026-03-28T12:36:35.494Z
9549276 9549276 20260320141654_oMlte KR000M 2026-03-22T12:23:29.369Z 2026-03-28T12:35:57.518Z
9548348 9548348 20260321145529_vo2Cw KR000M 2026-03-22T12:15:17.026Z 2026-03-29T12:20:25.493Z
9547391 9547391 20260321132337_L16vX KR000M 2026-03-22T12:13:34.099Z 2026-03-29T12:20:09.235Z
9546296 9546296 20260321115014_s07wU KR000M 2026-03-22T12:11:27.078Z 2026-03-29T12:19:49.187Z
9545892 9545892 20260321111701_OP4vA KR000M 2026-03-22T12:10:34.678Z 2026-03-29T12:19:45.359Z
9545744 9545744 20260321110408_1K6bZ KR000M 2026-03-22T12:10:08.722Z 2026-03-22T12:27:38.102Z
9541381 9541381 20260319202702_V6bnI KR000M 2026-03-21T12:28:53.079Z 2026-03-27T12:42:37.072Z
9541291 9541291 20260319201342_PX6xK KR000M 2026-03-21T12:28:48.489Z 2026-03-27T12:42:36.299Z
9541181 9541181 20260319195410_Cp84A KR000M 2026-03-21T12:28:42.086Z 2026-03-27T12:42:35.013Z
9541058 9541058 20260319191615_M6klB KR000M 2026-03-21T12:28:27.944Z 2026-03-27T12:42:33.548Z
9541048 9541048 20260319191112_sPsME KR000M 2026-03-21T12:28:26.994Z 2026-03-27T12:42:33.421Z
9541042 9541042 20260319190927_Yr1u7 KR000M 2026-03-21T12:28:25.722Z 2026-03-27T12:42:33.361Z
9540926 9540926 20260319183358_3AY9L KR000M 2026-03-21T12:28:17.111Z 2026-03-27T12:42:32.058Z
9540891 9540891 20260319182944_fFOa8 KR000M 2026-03-21T12:28:16.003Z 2026-03-27T12:42:31.913Z
9540888 9540888 20260319182836_T7RoQ KR000M 2026-03-21T12:28:15.754Z 2026-03-27T12:42:31.883Z
9540838 9540838 20260319181456_tke27 KR000M 2026-03-21T12:28:12.635Z 2026-03-27T12:42:31.430Z
9540784 9540784 20260319175601_5B0LB KR000M 2026-03-21T12:28:08.977Z 2026-03-27T12:42:30.919Z
9540753 9540753 20260319174911_TYitE KR000M 2026-03-21T12:28:07.196Z 2026-03-27T12:42:30.682Z
9540704 9540704 20260319172535_dkLee KR000M 2026-03-21T12:27:55.264Z 2026-03-27T12:42:29.874Z
9540674 9540674 20260319171509_NcFK1 KR000M 2026-03-21T12:27:49.636Z 2026-03-27T12:42:29.258Z
9540558 9540558 20260319163200_rO7iL KR000M 2026-03-21T12:27:19.753Z 2026-03-27T12:42:25.502Z
9540446 9540446 20260319154409_33sqc KR000M 2026-03-21T12:27:01.103Z 2026-03-27T12:42:22.110Z
9540388 9540388 20260319152926_ihCAa KR000M 2026-03-21T12:26:56.547Z 2026-03-27T12:42:20.959Z
9540338 9540338 20260319152027_bHz8o KR000M 2026-03-21T12:26:52.062Z 2026-03-27T12:42:20.000Z
9540223 9540223 20260319144305_iV3EI KR000M 2026-03-21T12:26:31.540Z 2026-03-27T12:42:04.453Z
9540020 9540020 20260319123224_3I3zZ KR000M 2026-03-21T12:25:56.581Z 2026-03-27T12:41:56.363Z
9539950 9539950 20260319113010_XBVND KR000M 2026-03-21T12:25:28.678Z 2026-03-27T12:41:49.948Z
9539935 9539935 20260319110546_152rx KR000M 2026-03-21T12:25:19.706Z 2026-03-27T12:41:47.210Z
9538058 9538058 20260320122914_7ERlK KR000M 2026-03-21T12:17:01.265Z 2026-03-28T12:35:34.127Z
9530236 9530236 20260318203004_3TkRs KR000M 2026-03-20T12:24:14.478Z 2026-03-26T12:39:10.673Z
9530059 9530059 20260318200223_awGhC KR000M 2026-03-20T12:23:57.281Z 2026-03-26T12:39:08.858Z
9529935 9529935 20260318194339_p41fp KR000M 2026-03-20T12:23:50.414Z 2026-03-26T12:39:07.639Z
9529810 9529810 20260318193338_lq0vE KR000M 2026-03-20T12:23:39.845Z 2026-03-26T12:39:06.697Z
9529661 9529661 20260318190512_Tn3PT KR000M 2026-03-20T12:23:31.420Z 2026-03-26T12:39:05.293Z
9529625 9529625 20260318190000_VDzhe KR000M 2026-03-20T12:23:24.290Z 2026-03-26T12:39:04.995Z
9529576 9529576 20260318185542_fwGcv KR000M 2026-03-20T12:23:19.572Z 2026-03-26T12:39:04.539Z
9529101 9529101 20260318171447_4y39l KR000M 2026-03-20T12:22:53.170Z 2026-03-26T12:38:45.323Z
9514996 9514996 20260318122506_47QRW KR000M 2026-03-19T12:18:49.680Z 2026-03-19T12:27:30.846Z
9507197 9507197 20260316203049_2H8iN KR000M 2026-03-18T12:19:59.720Z 2026-03-24T12:41:41.761Z
9507107 9507107 20260316202257_iw7QK KR000M 2026-03-18T12:19:54.039Z 2026-03-24T12:41:39.873Z
9507054 9507054 20260316201105_oBJi2 KR000M 2026-03-18T12:19:49.294Z 2026-03-24T12:41:38.211Z
9506629 9506629 20260316183808_3nokO KR000M 2026-03-18T12:19:06.315Z 2026-03-24T12:41:33.837Z
9506587 9506587 20260316183017_OI26Q KR000M 2026-03-18T12:18:58.832Z 2026-03-24T12:41:33.643Z
9504881 9504881 20260317124058_YxbOW KR000M 2026-03-18T12:09:07.476Z 2026-03-25T12:42:25.287Z
9504696 9504696 20260317121509_6wARF KR000M 2026-03-18T12:08:42.134Z 2026-03-25T12:42:23.956Z
9504209 9504209 20260317105740_EXbvS KR000M 2026-03-18T12:07:27.370Z 2026-03-25T12:42:20.266Z
9500152 9500152 20260316174135_37HXQ KR000M 2026-03-17T12:16:50.916Z 2026-03-17T12:25:25.894Z
9500072 9500072 20260316172318_38bti KR000M 2026-03-17T12:16:41.617Z 2026-03-17T12:25:25.870Z
9499870 9499870 20260316165855_BljXE KR000M 2026-03-17T12:16:17.578Z 2026-03-24T12:41:31.710Z
9499566 9499566 20260316163113_ZwkFp KR000M 2026-03-17T12:15:47.899Z 2026-03-17T12:25:25.765Z
9499171 9499171 20260316155732_oPhxE KR000M 2026-03-17T12:15:07.315Z 2026-03-24T12:41:28.259Z
9499146 9499146 20260316155624_E3lKd KR000M 2026-03-17T12:15:05.437Z 2026-03-17T12:25:25.656Z
9499131 9499131 20260316155553_y3SyA KR000M 2026-03-17T12:15:04.420Z 2026-03-17T12:25:25.653Z
9498775 9498775 20260316152635_8EDnH KR000M 2026-03-17T12:14:27.038Z 2026-03-17T12:25:25.579Z
9497872 9497872 20260316141734_36sY2 KR000M 2026-03-17T12:12:50.054Z 2026-03-24T12:41:24.438Z
9497257 9497257 20260316130905_rlJHT KR000M 2026-03-17T12:11:37.398Z 2026-03-17T12:25:25.224Z
9497020 9497020 20260316124625_L7XYh KR000M 2026-03-17T12:11:08.511Z 2026-03-17T12:25:25.176Z
9496772 9496772 20260316121345_2XlI8 KR000M 2026-03-17T12:10:34.020Z 2026-03-24T12:41:21.065Z
9496423 9496423 20260316113204_lZrgT KR000M 2026-03-17T12:09:45.187Z 2026-03-17T12:25:24.969Z
9496285 9496285 20260316110741_Rcf6B KR000M 2026-03-17T12:09:27.624Z 2026-03-24T12:41:19.000Z
9491846 9491846 20260315203341_vRnad KR000M 2026-03-16T12:21:58.594Z 2026-03-23T12:22:42.630Z
9491833 9491833 20260315202810_iEkGD KR000M 2026-03-16T12:21:56.897Z 2026-03-23T12:22:42.551Z
9491769 9491769 20260315193459_oLRc9 KR000M 2026-03-16T12:21:47.593Z 2026-03-23T12:22:41.744Z
9491758 9491758 20260315192524_VyUnV KR000M 2026-03-16T12:21:45.770Z 2026-03-23T12:22:41.560Z
9491747 9491747 20260315191920_ApD3e KR000M 2026-03-16T12:21:44.271Z 2026-03-23T12:22:41.405Z
9491638 9491638 20260315174141_KoR2y KR000M 2026-03-16T12:21:25.840Z 2026-03-23T12:22:40.188Z
9491627 9491627 20260315172951_3xw9R KR000M 2026-03-16T12:21:23.870Z 2026-03-23T12:22:40.095Z
9491326 9491326 20260315163520_7CCF8 KR000M 2026-03-16T12:20:47.078Z 2026-03-23T12:22:39.196Z
9490899 9490899 20260315154417_lJJ52 KR000M 2026-03-16T12:19:58.617Z 2026-03-23T12:22:38.042Z
9490515 9490515 20260315150200_20A3W KR000M 2026-03-16T12:19:14.252Z 2026-03-23T12:22:36.830Z

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