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

8,316 rows where station_code = "KR000S" 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
9267148 9267148 20260126195000_Bzmxr KR000S 2026-01-28T14:19:44.343Z 2026-01-29T14:34:24.912Z
9266809 9266809 20260127213038_68yMG KR000S 2026-01-28T14:14:38.436Z 2026-01-29T14:30:25.222Z
9266798 9266798 20260127212707_7WFEA KR000S 2026-01-28T14:14:36.913Z 2026-01-29T14:30:25.219Z
9266787 9266787 20260127212019_l984k KR000S 2026-01-28T14:14:34.509Z 2026-01-28T14:14:34.509Z
9266758 9266758 20260127210444_72iqS KR000S 2026-01-28T14:14:27.946Z 2026-01-29T14:30:25.212Z
9266700 9266700 20260127204910_3q6VA KR000S 2026-01-28T14:14:20.243Z 2026-01-29T14:30:25.187Z
9266684 9266684 20260127203934_CmhMB KR000S 2026-01-28T14:14:16.341Z 2026-01-29T14:30:25.172Z
9266630 9266630 20260127201032_dAqHK KR000S 2026-01-28T14:14:07.700Z 2026-01-29T14:30:25.143Z
9266624 9266624 20260127200843_l2N2E KR000S 2026-01-28T14:14:07.257Z 2026-01-29T14:30:25.142Z
9266619 9266619 20260127200800_2mBtN KR000S 2026-01-28T14:14:06.530Z 2026-01-29T14:30:25.141Z
9266615 9266615 20260127200740_YTVzu KR000S 2026-01-28T14:14:05.909Z 2026-01-29T14:30:25.141Z
9266538 9266538 20260127194522_FpVEz KR000S 2026-01-28T14:13:48.303Z 2026-01-29T14:30:25.082Z
9266452 9266452 20260127192404_4Edb2 KR000S 2026-01-28T14:13:37.169Z 2026-01-29T14:30:25.032Z
9266443 9266443 20260127192334_Z0eWn KR000S 2026-01-28T14:13:36.519Z 2026-01-29T14:30:25.032Z
9266364 9266364 20260127185908_T80uD KR000S 2026-01-28T14:13:18.566Z 2026-01-28T14:13:18.566Z
9266307 9266307 20260127184805_6dT6P KR000S 2026-01-28T14:13:12.292Z 2026-01-29T14:30:24.991Z
9266262 9266262 20260127183331_NW0id KR000S 2026-01-28T14:13:06.707Z 2026-01-29T14:30:24.969Z
9266147 9266147 20260127174124_HID2r KR000S 2026-01-28T14:12:38.679Z 2026-01-29T14:30:24.896Z
9266140 9266140 20260127173920_8aNgx KR000S 2026-01-28T14:12:37.434Z 2026-01-29T14:30:24.895Z
9266055 9266055 20260127165906_RlJDV KR000S 2026-01-28T14:12:16.855Z 2026-01-29T14:30:24.837Z
9266027 9266027 20260127164153_UVZoq KR000S 2026-01-28T14:12:10.887Z 2026-01-29T14:30:24.817Z
9266016 9266016 20260127163607_014KC KR000S 2026-01-28T14:12:08.882Z 2026-01-29T14:30:24.813Z
9266007 9266007 20260127163451_OycvQ KR000S 2026-01-28T14:12:07.970Z 2026-01-29T14:30:24.813Z
9265621 9265621 20260127154202_YVKiR KR000S 2026-01-28T14:10:45.262Z 2026-01-29T14:30:24.624Z
9265436 9265436 20260127151558_E38pF KR000S 2026-01-28T14:10:10.589Z 2026-01-29T14:30:24.549Z
9265184 9265184 20260127143303_6HQty KR000S 2026-01-28T14:09:22.360Z 2026-01-29T14:30:24.496Z
9263803 9263803 20260127101500_JUaSV KR000S 2026-01-28T14:02:52.599Z 2026-01-29T14:30:18.940Z
9262451 9262451 20260126204050_PpqKK KR000S 2026-01-27T14:09:06.106Z 2026-01-29T14:34:35.061Z
9262446 9262446 20260126203834_PeVXr KR000S 2026-01-27T14:09:05.439Z 2026-01-29T14:34:34.896Z
9262413 9262413 20260126202217_Y6gQG KR000S 2026-01-27T14:08:57.975Z 2026-01-29T14:34:29.718Z
9262410 9262410 20260126202144_2AMzI KR000S 2026-01-27T14:08:57.365Z 2026-01-29T14:34:29.409Z
9262396 9262396 20260126201942_q5Q62 KR000S 2026-01-27T14:08:55.785Z 2026-01-29T14:34:29.230Z
9262390 9262390 20260126201436_W2Yxx KR000S 2026-01-27T14:08:54.414Z 2026-01-29T14:34:28.519Z
9262298 9262298 20260126185745_ElYOc KR000S 2026-01-27T14:08:31.117Z 2026-01-27T14:08:31.117Z
9262287 9262287 20260126184838_v5emn KR000S 2026-01-27T14:08:25.976Z 2026-01-27T14:08:25.976Z
9262272 9262272 20260126184540_gvRmk KR000S 2026-01-27T14:08:23.592Z 2026-01-29T14:34:14.072Z
9262258 9262258 20260126183845_7tL0N KR000S 2026-01-27T14:08:20.895Z 2026-01-29T14:34:12.503Z
9262254 9262254 20260126183717_OzCR2 KR000S 2026-01-27T14:08:20.287Z 2026-01-29T14:34:12.164Z
9262243 9262243 20260126182951_7kDzM KR000S 2026-01-27T14:08:18.461Z 2026-01-29T14:34:09.419Z
9262213 9262213 20260126181541_pQr4D KR000S 2026-01-27T14:08:12.362Z 2026-01-29T14:34:00.075Z
9262210 9262210 20260126181420_bYGXy KR000S 2026-01-27T14:08:11.766Z 2026-01-29T14:33:59.711Z
9262206 9262206 20260126181415_o3fZT KR000S 2026-01-27T14:08:11.118Z 2026-01-29T14:33:59.537Z
9259432 9259432 20260124205000_CzNbm KR000S 2026-01-26T14:16:59.010Z 2026-01-29T14:42:54.430Z
9259418 9259418 20260124204503_1TBWV KR000S 2026-01-26T14:16:57.559Z 2026-01-29T14:42:53.956Z
9259387 9259387 20260124204019_AVv8i KR000S 2026-01-26T14:16:51.246Z 2026-01-29T14:42:50.757Z
9259348 9259348 20260124203059_UhST0 KR000S 2026-01-26T14:16:40.000Z 2026-01-26T14:23:12.998Z
9259314 9259314 20260124201408_3sep7 KR000S 2026-01-26T14:16:30.389Z 2026-01-29T14:42:47.293Z
9259133 9259133 20260124190210_27cwn KR000S 2026-01-26T14:15:52.629Z 2026-01-29T14:42:38.145Z
9259099 9259099 20260124185028_tSOMj KR000S 2026-01-26T14:15:41.601Z 2026-01-29T14:42:36.994Z
9258930 9258930 20260124180404_gdXaH KR000S 2026-01-26T14:15:06.198Z 2026-01-29T14:42:19.934Z
9258736 9258736 20260124163129_Ltxm8 KR000S 2026-01-26T14:14:05.730Z 2026-01-29T14:41:59.015Z
9258701 9258701 20260124161146_B3Sjm KR000S 2026-01-26T14:13:58.869Z 2026-01-29T14:41:53.959Z
9258683 9258683 20260124160506_pqhCz KR000S 2026-01-26T14:13:53.977Z 2026-01-29T14:41:52.108Z
9258659 9258659 20260124154543_ZCfY1 KR000S 2026-01-26T14:13:40.208Z 2026-01-29T14:41:48.747Z
9258608 9258608 20260124150837_Ju9Hq KR000S 2026-01-26T14:13:19.435Z 2026-01-29T14:41:40.902Z
9258605 9258605 20260124150836_m9ckJ KR000S 2026-01-26T14:13:18.417Z 2026-01-29T14:41:40.780Z
9258519 9258519 20260124141040_3ovAt KR000S 2026-01-26T14:12:39.138Z 2026-01-29T14:41:21.313Z
9258466 9258466 20260124131632_qZZBi KR000S 2026-01-26T14:12:18.617Z 2026-01-29T14:41:05.878Z
9258439 9258439 20260124125136_augrJ KR000S 2026-01-26T14:12:07.137Z 2026-01-29T14:40:58.994Z
9258167 9258167 20260125191931_kQtK1 KR000S 2026-01-26T14:09:53.842Z 2026-01-29T14:38:06.491Z
9258164 9258164 20260125191922_8tMLP KR000S 2026-01-26T14:09:53.057Z 2026-01-29T14:38:06.374Z
9258109 9258109 20260125184227_nWMEI KR000S 2026-01-26T14:09:37.704Z 2026-01-29T14:38:03.381Z
9258079 9258079 20260125183243_2v8K1 KR000S 2026-01-26T14:09:32.954Z 2026-01-29T14:38:02.463Z
9258072 9258072 20260125182238_ARGm4 KR000S 2026-01-26T14:09:25.434Z 2026-01-29T14:38:01.797Z
9258014 9258014 20260125175852_Ftf3c KR000S 2026-01-26T14:09:08.558Z 2026-01-29T14:37:57.947Z
9257909 9257909 20260125170618_cz73y KR000S 2026-01-26T14:08:31.669Z 2026-01-29T14:37:52.927Z
9257870 9257870 20260125164116_kjDDI KR000S 2026-01-26T14:08:15.150Z 2026-01-29T14:37:45.783Z
9257780 9257780 20260125155621_Gbjzj KR000S 2026-01-26T14:07:43.194Z 2026-01-29T14:37:39.482Z
9257769 9257769 20260125155250_F3MLg KR000S 2026-01-26T14:07:40.346Z 2026-01-29T14:37:38.794Z
9256852 9256852 20260125104352_izz1o KR000S 2026-01-26T14:02:16.049Z 2026-01-29T14:36:27.401Z
9256834 9256834 20260125104019_vYnDt KR000S 2026-01-26T14:02:11.539Z 2026-01-29T14:36:26.362Z
9254806 9254806 20260123213052_maxyU KR000S 2026-01-25T14:10:47.567Z 2026-01-29T14:46:43.241Z
9254803 9254803 20260123212534_wMtcj KR000S 2026-01-25T14:10:47.079Z 2026-01-29T14:46:43.120Z
9254755 9254755 20260123211145_5xLtk KR000S 2026-01-25T14:10:35.031Z 2026-01-29T14:46:40.952Z
9254747 9254747 20260123210826_w2bEI KR000S 2026-01-25T14:10:33.963Z 2026-01-29T14:46:40.382Z
9254722 9254722 20260123210500_t3HBU KR000S 2026-01-25T14:10:28.243Z 2026-01-29T14:46:37.554Z
9254716 9254716 20260123210222_El32B KR000S 2026-01-25T14:10:27.302Z 2026-01-29T14:46:37.324Z
9254632 9254632 20260123203338_3FHVp KR000S 2026-01-25T14:10:06.929Z 2026-01-29T14:46:33.133Z
9254600 9254600 20260123201904_j4eN3 KR000S 2026-01-25T14:10:00.659Z 2026-01-29T14:46:31.734Z
9254545 9254545 20260123200759_e0tRm KR000S 2026-01-25T14:09:46.252Z 2026-01-29T14:46:29.628Z
9254525 9254525 20260123195554_cWhll KR000S 2026-01-25T14:09:38.372Z 2026-01-29T14:46:28.521Z
9254512 9254512 20260123195121_ZAi0A KR000S 2026-01-25T14:09:33.440Z 2026-01-29T14:46:27.634Z
9254473 9254473 20260123193356_3eTBl KR000S 2026-01-25T14:09:23.433Z 2026-01-29T14:46:25.543Z
9254392 9254392 20260123185105_NBWz4 KR000S 2026-01-25T14:08:57.903Z 2026-01-29T14:46:13.503Z
9254309 9254309 20260123180728_CMXw3 KR000S 2026-01-25T14:08:26.686Z 2026-01-29T14:46:05.579Z
9251605 9251605 20260122212638_NO3qS KR000S 2026-01-24T14:12:35.334Z 2026-01-29T14:51:54.105Z
9251066 9251066 20260122181457_NTCdc KR000S 2026-01-24T14:09:49.770Z 2026-01-29T14:50:59.903Z
9251026 9251026 20260122175019_r1xhP KR000S 2026-01-24T14:09:31.057Z 2026-01-29T14:50:55.856Z
9250844 9250844 20260122160559_rH2h1 KR000S 2026-01-24T14:08:01.830Z 2026-01-29T14:50:38.540Z
9247949 9247949 20260121204328_kodbq KR000S 2026-01-23T14:11:36.344Z 2026-01-29T14:56:45.283Z
9247836 9247836 20260121200516_n1xEf KR000S 2026-01-23T14:11:13.904Z 2026-01-29T14:56:39.896Z
9247616 9247616 20260121191542_FXgZJ KR000S 2026-01-23T14:10:36.100Z 2026-01-29T14:56:19.750Z
9247591 9247591 20260121191002_02yXp KR000S 2026-01-23T14:10:32.758Z 2026-01-29T14:56:16.331Z
9247563 9247563 20260121190202_ZzExq KR000S 2026-01-23T14:10:28.904Z 2026-01-29T14:56:14.571Z
9247476 9247476 20260121184231_t631s KR000S 2026-01-23T14:10:09.995Z 2026-01-29T14:56:11.052Z
9247383 9247383 20260121181852_eWb6T KR000S 2026-01-23T14:09:57.621Z 2026-01-29T14:56:06.638Z
9247102 9247102 20260121170107_NnSFw KR000S 2026-01-23T14:09:02.711Z 2026-01-29T14:55:42.886Z
9247062 9247062 20260121164242_i6qOK KR000S 2026-01-23T14:08:56.776Z 2026-01-29T14:55:40.763Z
9246948 9246948 20260121154454_cDSN5 KR000S 2026-01-23T14:08:33.909Z 2026-01-29T14:55:22.010Z
9246909 9246909 20260121153448_FPIjV KR000S 2026-01-23T14:08:28.040Z 2026-01-29T14:55:19.786Z

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