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

3,805 rows where station_code = "KR002F" 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
9613112 9613112 20260406193600_POsbd KR002F 2026-04-07T12:03:50.793Z 2026-04-07T12:03:50.793Z
9613070 9613070 20260406191135_4zBma KR002F 2026-04-07T12:03:43.570Z 2026-04-07T12:03:43.570Z
9612947 9612947 20260406180330_QBnPz KR002F 2026-04-07T12:03:17.511Z 2026-04-07T12:03:17.511Z
9612669 9612669 20260406151142_a9lmz KR002F 2026-04-07T12:02:31.782Z 2026-04-07T12:02:31.782Z
9612589 9612589 20260406142259_fM3ot KR002F 2026-04-07T12:02:12.689Z 2026-04-07T12:02:12.689Z
9612550 9612550 20260406135434_ehaRP KR002F 2026-04-07T12:02:07.781Z 2026-04-07T12:02:07.781Z
9612470 9612470 20260406121526_2xovg KR002F 2026-04-07T12:01:56.157Z 2026-04-07T12:01:56.157Z
9609974 9609974 20260405113703_HgOKs KR002F 2026-04-06T12:05:03.919Z 2026-04-07T12:13:19.153Z
9602125 9602125 20260401195233_R0uXk KR002F 2026-04-02T12:05:01.120Z 2026-04-07T12:21:29.156Z
9602117 9602117 20260401194523_m5NRd KR002F 2026-04-02T12:04:57.723Z 2026-04-07T12:21:28.513Z
9600756 9600756 20260329142800_YS2KL KR002F 2026-04-01T12:13:41.209Z 2026-04-07T12:27:34.166Z
9591676 9591676 20260328185459_ykS84 KR002F 2026-03-29T12:04:50.007Z 2026-04-06T12:39:38.603Z
9591649 9591649 20260328181224_eefHV KR002F 2026-03-29T12:04:47.008Z 2026-04-06T12:39:36.995Z
9591639 9591639 20260328180346_mA3dD KR002F 2026-03-29T12:04:46.457Z 2026-04-06T12:39:28.174Z
9591392 9591392 20260328161556_RfQcf KR002F 2026-03-29T12:04:20.908Z 2026-04-06T12:39:13.771Z
9591113 9591113 20260328132742_2HdIE KR002F 2026-03-29T12:03:51.619Z 2026-04-06T12:39:01.234Z
9588124 9588124 20260327192944_UElss KR002F 2026-03-28T12:07:12.620Z 2026-04-05T12:35:09.536Z
9588113 9588113 20260327192529_tOdp4 KR002F 2026-03-28T12:07:11.794Z 2026-04-05T12:35:09.146Z
9588074 9588074 20260327182831_ofCfn KR002F 2026-03-28T12:07:07.512Z 2026-04-05T12:35:07.108Z
9588069 9588069 20260327182338_BUtDp KR002F 2026-03-28T12:07:07.255Z 2026-04-05T12:35:06.996Z
9587831 9587831 20260327162135_Mcj2W KR002F 2026-03-28T12:06:29.113Z 2026-04-05T12:34:45.724Z
9587808 9587808 20260327160902_TOBxE KR002F 2026-03-28T12:06:23.717Z 2026-04-05T12:34:44.433Z
9583914 9583914 20260326201036_FafTT KR002F 2026-03-27T12:10:07.076Z 2026-04-04T12:41:53.042Z
9583873 9583873 20260326192118_fTJ2N KR002F 2026-03-27T12:09:58.754Z 2026-04-04T12:41:49.041Z
9579095 9579095 20260325201046_GZ9L0 KR002F 2026-03-26T12:09:18.487Z 2026-04-03T12:39:16.738Z
9579029 9579029 20260325174507_vD9sZ KR002F 2026-03-26T12:09:10.581Z 2026-04-03T12:38:51.521Z
9578937 9578937 20260325163002_CEw7h KR002F 2026-03-26T12:08:54.469Z 2026-04-03T12:38:44.255Z
9578892 9578892 20260325154328_tZkjv KR002F 2026-03-26T12:08:46.485Z 2026-04-03T12:38:39.238Z
9578886 9578886 20260325154203_apW1Q KR002F 2026-03-26T12:08:46.033Z 2026-04-03T12:38:38.805Z
9578811 9578811 20260325150301_PB85X KR002F 2026-03-26T12:08:35.274Z 2026-04-03T12:38:34.470Z
9578774 9578774 20260325143316_aa16G KR002F 2026-03-26T12:08:30.665Z 2026-04-03T12:38:32.203Z
9578556 9578556 20260325121426_4WGrO KR002F 2026-03-26T12:07:54.829Z 2026-04-03T12:38:08.053Z
9578553 9578553 20260325121407_OJE2b KR002F 2026-03-26T12:07:54.314Z 2026-04-03T12:38:07.882Z
9575314 9575314 20260323203207_jgF2u KR002F 2026-03-25T12:20:48.842Z 2026-03-31T12:28:54.532Z
9575264 9575264 20260323200008_NfFiP KR002F 2026-03-25T12:20:42.109Z 2026-03-31T12:28:52.672Z
9575258 9575258 20260323195711_gwIjU KR002F 2026-03-25T12:20:41.434Z 2026-03-31T12:28:52.496Z
9575227 9575227 20260323194058_sKEpa KR002F 2026-03-25T12:20:34.396Z 2026-03-31T12:28:51.655Z
9575198 9575198 20260323192142_9DdAF KR002F 2026-03-25T12:20:30.225Z 2026-03-31T12:28:50.874Z
9575095 9575095 20260323183950_2qM0Z KR002F 2026-03-25T12:20:16.062Z 2026-03-31T12:28:48.050Z
9570248 9570248 20260322201448_8t6Op KR002F 2026-03-24T12:22:52.457Z 2026-03-30T12:30:37.956Z
9570102 9570102 20260322191139_xGMay KR002F 2026-03-24T12:22:34.636Z 2026-03-30T12:30:27.786Z
9570088 9570088 20260322190900_flNGQ KR002F 2026-03-24T12:22:34.099Z 2026-03-30T12:30:27.627Z
9570064 9570064 20260322190416_gWV8Y KR002F 2026-03-24T12:22:32.191Z 2026-03-30T12:30:27.243Z
9570053 9570053 20260322190125_tR3jy KR002F 2026-03-24T12:22:31.452Z 2026-03-30T12:30:27.098Z
9570037 9570037 20260322190029_JHCH7 KR002F 2026-03-24T12:22:30.207Z 2026-03-30T12:30:26.824Z
9570012 9570012 20260322185152_3QsG1 KR002F 2026-03-24T12:22:28.080Z 2026-03-30T12:30:26.358Z
9569970 9569970 20260322183852_GbyFN KR002F 2026-03-24T12:22:24.476Z 2026-03-30T12:30:25.523Z
9569547 9569547 20260322161009_EY1po KR002F 2026-03-24T12:21:20.874Z 2026-03-30T12:30:08.305Z
9569184 9569184 20260322135732_g1fjx KR002F 2026-03-24T12:20:01.090Z 2026-03-30T12:29:37.124Z
9569153 9569153 20260322134712_GZGtD KR002F 2026-03-24T12:19:55.252Z 2026-03-30T12:29:35.624Z
9569142 9569142 20260322133339_LKu9L KR002F 2026-03-24T12:19:52.735Z 2026-03-30T12:29:34.578Z
9569027 9569027 20260322123722_Ee8tF KR002F 2026-03-24T12:19:27.338Z 2026-03-30T12:29:19.107Z
9568881 9568881 20260322105838_7YPeb KR002F 2026-03-24T12:18:47.275Z 2026-03-30T12:29:03.703Z
9568633 9568633 20260323170746_QULH9 KR002F 2026-03-24T12:15:25.530Z 2026-03-31T12:28:39.137Z
9566652 9566652 20260323135942_Hstab KR002F 2026-03-24T12:12:15.704Z 2026-03-31T12:27:55.081Z
9551576 9551576 20260320202319_QTb4y KR002F 2026-03-22T12:26:49.127Z 2026-03-28T12:36:58.287Z
9551248 9551248 20260320190154_nFqY3 KR002F 2026-03-22T12:26:20.512Z 2026-03-28T12:36:41.471Z
9551199 9551199 20260320185158_jbdu7 KR002F 2026-03-22T12:26:17.234Z 2026-03-28T12:36:40.983Z
9551135 9551135 20260320183406_UnP30 KR002F 2026-03-22T12:26:12.687Z 2026-03-28T12:36:40.293Z
9550394 9550394 20260320163625_tzuU7 KR002F 2026-03-22T12:25:12.998Z 2026-03-28T12:36:30.322Z
9550333 9550333 20260320163028_2z4Zr KR002F 2026-03-22T12:25:08.733Z 2026-03-28T12:36:29.638Z
9550083 9550083 20260320160654_zqY3g KR002F 2026-03-22T12:24:54.452Z 2026-03-28T12:36:26.977Z
9548179 9548179 20260321143912_GWC91 KR002F 2026-03-22T12:15:00.373Z 2026-03-29T12:20:24.524Z
9546763 9546763 20260321122538_zJZMz KR002F 2026-03-22T12:12:22.017Z 2026-03-29T12:20:04.117Z
9545526 9545526 20260321104502_W04wv KR002F 2026-03-22T12:09:38.632Z 2026-03-29T12:19:41.037Z
9541066 9541066 20260319191737_4RBGi KR002F 2026-03-21T12:28:28.124Z 2026-03-27T12:42:33.586Z
9541024 9541024 20260319190210_lDJ46 KR002F 2026-03-21T12:28:24.311Z 2026-03-27T12:42:33.165Z
9540996 9540996 20260319185118_VDwmG KR002F 2026-03-21T12:28:22.000Z 2026-03-27T12:42:32.785Z
9540960 9540960 20260319184238_hCoSB KR002F 2026-03-21T12:28:19.339Z 2026-03-27T12:42:32.499Z
9540920 9540920 20260319183306_JngYR KR002F 2026-03-21T12:28:16.958Z 2026-03-27T12:42:32.037Z
9540849 9540849 20260319181523_E1Zsl KR002F 2026-03-21T12:28:13.137Z 2026-03-27T12:42:31.499Z
9540515 9540515 20260319160625_l02nX KR002F 2026-03-21T12:27:07.743Z 2026-03-27T12:42:23.495Z
9540464 9540464 20260319154615_hN7cE KR002F 2026-03-21T12:27:01.669Z 2026-03-27T12:42:22.271Z
9540187 9540187 20260319141437_B8rlP KR002F 2026-03-21T12:26:25.765Z 2026-03-27T12:42:02.868Z
9540091 9540091 20260319124815_Q5lUm KR002F 2026-03-21T12:26:02.356Z 2026-03-27T12:41:57.944Z
9538176 9538176 20260320123926_Yb2Di KR002F 2026-03-21T12:17:13.710Z 2026-03-28T12:35:35.610Z
9537749 9537749 20260320120032_4eXc6 KR002F 2026-03-21T12:16:24.275Z 2026-03-28T12:35:28.922Z
9530196 9530196 20260318202356_wVOWz KR002F 2026-03-20T12:24:11.555Z 2026-03-26T12:39:10.254Z
9529149 9529149 20260318172010_J2pl3 KR002F 2026-03-20T12:22:55.587Z 2026-03-26T12:38:47.515Z
9473740 9473740 20260313184400_wzxLK KR002F 2026-03-14T12:15:44.147Z 2026-03-21T12:50:00.901Z
9473650 9473650 20260313174748_63ziL KR002F 2026-03-14T12:15:32.042Z 2026-03-21T12:49:59.116Z
9473569 9473569 20260313172238_h9KBU KR002F 2026-03-14T12:15:19.821Z 2026-03-21T12:49:58.669Z
9473482 9473482 20260313170348_MBWNP KR002F 2026-03-14T12:15:09.001Z 2026-03-21T12:49:58.070Z
9473465 9473465 20260313170200_FXNGZ KR002F 2026-03-14T12:15:07.529Z 2026-03-21T12:49:57.975Z
9473295 9473295 20260313163222_HtvTw KR002F 2026-03-14T12:14:47.830Z 2026-03-21T12:49:55.659Z
9473013 9473013 20260313153634_UHe4T KR002F 2026-03-14T12:14:18.825Z 2026-03-21T12:49:53.298Z
9473003 9473003 20260313153327_FoBGa KR002F 2026-03-14T12:14:17.387Z 2026-03-21T12:49:53.216Z
9472742 9472742 20260313145533_MAtBK KR002F 2026-03-14T12:13:49.201Z 2026-03-21T12:49:51.633Z
9472736 9472736 20260313145446_82lD2 KR002F 2026-03-14T12:13:48.025Z 2026-03-21T12:49:51.630Z
9472052 9472052 20260313124008_3dJZV KR002F 2026-03-14T12:12:13.916Z 2026-03-21T12:49:45.817Z
9468398 9468398 20260312201223_iL7E0 KR002F 2026-03-13T12:21:45.556Z 2026-03-20T12:37:15.446Z
9468386 9468386 20260312200425_o7WXF KR002F 2026-03-13T12:21:44.509Z 2026-03-20T12:37:15.353Z
9468378 9468378 20260312195630_BLg1y KR002F 2026-03-13T12:21:43.498Z 2026-03-20T12:37:15.254Z
9468349 9468349 20260312194616_eve5w KR002F 2026-03-13T12:21:41.745Z 2026-03-20T12:37:14.965Z
9468345 9468345 20260312194331_iEvz1 KR002F 2026-03-13T12:21:41.494Z 2026-03-20T12:37:14.944Z
9468317 9468317 20260312192537_2gv6Z KR002F 2026-03-13T12:21:39.322Z 2026-03-20T12:37:14.631Z
9468095 9468095 20260312172345_yGgvA KR002F 2026-03-13T12:21:10.552Z 2026-03-20T12:37:12.538Z
9467944 9467944 20260312155212_9SBV8 KR002F 2026-03-13T12:20:38.784Z 2026-03-20T12:37:11.000Z
9467748 9467748 20260312123921_Y7YZC KR002F 2026-03-13T12:19:52.038Z 2026-03-20T12:37:08.595Z
9462052 9462052 20260311195753_HvjZF KR002F 2026-03-12T12:18:23.039Z 2026-03-19T12:45:47.930Z

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