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

2,355 rows where station_code = "KR002H" 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
8749778 8749778 20251209153949_ass34 KR002H 2025-12-13T15:36:57.994Z 2025-12-17T15:26:13.623Z
8749563 8749563 20251209150930_nI5xU KR002H 2025-12-13T15:36:36.183Z 2025-12-17T15:26:10.817Z
8749423 8749423 20251209144934_7Xls2 KR002H 2025-12-13T15:36:18.599Z 2025-12-17T15:26:09.182Z
8749054 8749054 20251209140014_02xv3 KR002H 2025-12-13T15:35:37.949Z 2025-12-17T15:25:42.664Z
8748827 8748827 20251209132429_2LvJf KR002H 2025-12-13T15:35:25.655Z 2025-12-17T15:25:17.359Z
8748533 8748533 20251209124338_mqotm KR002H 2025-12-13T15:34:32.859Z 2025-12-17T15:25:07.910Z
8748184 8748184 20251209115914_uwRfn KR002H 2025-12-13T15:33:47.154Z 2025-12-17T15:24:59.905Z
8748103 8748103 20251209114617_laLtG KR002H 2025-12-13T15:33:38.874Z 2025-12-17T15:24:58.447Z
8748080 8748080 20251209114349_q2qx9 KR002H 2025-12-13T15:33:37.804Z 2025-12-17T15:24:58.122Z
8747926 8747926 20251209112014_kVcan KR002H 2025-12-13T15:33:26.559Z 2025-12-17T15:24:42.163Z
8735600 8735600 20251211203347_NJY1w KR002H 2025-12-13T14:54:12.262Z 2025-12-20T14:25:15.783Z
8735494 8735494 20251211201840_U7T52 KR002H 2025-12-13T14:53:44.662Z 2025-12-20T14:25:14.918Z
8735394 8735394 20251211200809_bykWq KR002H 2025-12-13T14:53:37.229Z 2025-12-20T14:25:14.352Z
8734998 8734998 20251211192534_4r1jP KR002H 2025-12-13T14:52:40.512Z 2025-12-20T14:25:05.524Z
8734781 8734781 20251211185527_rz3XF KR002H 2025-12-13T14:52:04.840Z 2025-12-20T14:24:56.765Z
8734757 8734757 20251211185303_F6qCp KR002H 2025-12-13T14:52:04.119Z 2025-12-20T14:24:56.617Z
8734503 8734503 20251211182400_CilYe KR002H 2025-12-13T14:51:13.566Z 2025-12-20T14:24:41.048Z
8734416 8734416 20251211181436_YX3tW KR002H 2025-12-13T14:51:04.273Z 2025-12-20T14:24:38.375Z
8734379 8734379 20251211180951_glhx8 KR002H 2025-12-13T14:51:00.355Z 2025-12-20T14:24:37.479Z
8734232 8734232 20251211175603_4zERp KR002H 2025-12-13T14:50:43.050Z 2025-12-20T14:24:35.244Z
8733699 8733699 20251211170120_h9KuU KR002H 2025-12-13T14:49:01.617Z 2025-12-20T14:24:16.344Z
8733625 8733625 20251211165321_Qtop4 KR002H 2025-12-13T14:48:54.464Z 2025-12-20T14:24:15.024Z
8733571 8733571 20251211164612_3dZh5 KR002H 2025-12-13T14:48:49.664Z 2025-12-20T14:24:13.614Z
8733491 8733491 20251211163335_Z4GXo KR002H 2025-12-13T14:48:40.689Z 2025-12-20T14:24:10.300Z
8733332 8733332 20251211161721_GkPtz KR002H 2025-12-13T14:48:15.829Z 2025-12-20T14:24:08.753Z
8733287 8733287 20251211160858_lW4XH KR002H 2025-12-13T14:48:12.727Z 2025-12-20T14:24:08.055Z
8733259 8733259 20251211160405_AA3cV KR002H 2025-12-13T14:48:08.393Z 2025-12-20T14:24:06.745Z
8733195 8733195 20251211154931_4mOdf KR002H 2025-12-13T14:47:56.061Z 2025-12-20T14:24:05.825Z
8733186 8733186 20251211154931_HfNp5 KR002H 2025-12-13T14:47:55.506Z 2025-12-20T14:24:05.810Z
8733161 8733161 20251211154647_ah11h KR002H 2025-12-13T14:47:49.339Z 2025-12-20T14:24:05.602Z
8733142 8733142 20251211154352_ImfMi KR002H 2025-12-13T14:47:47.680Z 2025-12-20T14:24:05.365Z
8733013 8733013 20251211153241_3aOak KR002H 2025-12-13T14:47:34.231Z 2025-12-20T14:24:03.627Z
8732098 8732098 20251211140910_JiQ4k KR002H 2025-12-13T14:44:49.922Z 2025-12-20T14:23:48.229Z
8731473 8731473 20251211130515_yU5zy KR002H 2025-12-13T14:42:40.512Z 2025-12-20T14:23:44.970Z
8731372 8731372 20251211125944_B5uaV KR002H 2025-12-13T14:42:20.705Z 2025-12-20T14:23:44.613Z
8730799 8730799 20251211113155_doVNm KR002H 2025-12-13T14:37:16.947Z 2025-12-20T14:23:32.174Z
8730753 8730753 20251211110931_FNPuQ KR002H 2025-12-13T14:36:19.468Z 2025-12-20T14:23:22.167Z
8705690 8705690 20251208202228_ISDb3 KR002H 2025-12-09T14:17:05.389Z 2025-12-17T15:33:19.511Z
8705659 8705659 20251208201810_vgaxm KR002H 2025-12-09T14:17:03.618Z 2025-12-17T15:33:17.997Z
8705489 8705489 20251208193554_k6OyW KR002H 2025-12-09T14:16:35.843Z 2025-12-17T15:32:57.548Z
8705434 8705434 20251208190902_QlX7b KR002H 2025-12-09T14:16:32.395Z 2025-12-17T15:32:53.630Z
8705382 8705382 20251208185736_IrIgT KR002H 2025-12-09T14:16:29.351Z 2025-12-17T15:32:49.995Z
8705379 8705379 20251208185711_R4j3R KR002H 2025-12-09T14:16:29.055Z 2025-12-17T15:32:49.972Z
8705233 8705233 20251208182428_4m46d KR002H 2025-12-09T14:16:18.716Z 2025-12-17T15:32:28.920Z
8705215 8705215 20251208181831_mce7u KR002H 2025-12-09T14:16:15.963Z 2025-12-17T15:32:16.181Z
8705177 8705177 20251208181259_4ZJsp KR002H 2025-12-09T14:16:07.406Z 2025-12-17T15:32:13.547Z
8705157 8705157 20251208181046_8IRaO KR002H 2025-12-09T14:16:06.479Z 2025-12-17T15:32:13.412Z
8705133 8705133 20251208180354_7mTuB KR002H 2025-12-09T14:16:04.441Z 2025-12-17T15:32:11.692Z
8705102 8705102 20251208175345_oelqa KR002H 2025-12-09T14:16:00.312Z 2025-12-17T15:32:05.529Z
8705077 8705077 20251208175146_33R34 KR002H 2025-12-09T14:15:59.618Z 2025-12-17T15:32:04.650Z
8705068 8705068 20251208175006_2bVVP KR002H 2025-12-09T14:15:58.940Z 2025-12-17T15:32:04.338Z
8705025 8705025 20251208174104_t8WIK KR002H 2025-12-09T14:15:54.859Z 2025-12-17T15:32:03.204Z
8704959 8704959 20251208173217_gdvD5 KR002H 2025-12-09T14:15:50.655Z 2025-12-17T15:32:02.638Z
8704927 8704927 20251208172832_CM3z2 KR002H 2025-12-09T14:15:49.242Z 2025-12-17T15:32:02.431Z
8704861 8704861 20251208171515_PXF6M KR002H 2025-12-09T14:15:41.795Z 2025-12-17T15:32:01.940Z
8704601 8704601 20251208161346_ZaZfs KR002H 2025-12-09T14:15:04.534Z 2025-12-17T15:31:58.392Z
8704569 8704569 20251208160424_xpRJ7 KR002H 2025-12-09T14:15:00.702Z 2025-12-17T15:31:55.412Z
8704516 8704516 20251208155034_F1VGs KR002H 2025-12-09T14:14:42.669Z 2025-12-17T15:31:54.965Z
8704499 8704499 20251208154753_tqd7K KR002H 2025-12-09T14:14:40.187Z 2025-12-17T15:31:54.824Z
8703801 8703801 20251208141724_BUqTF KR002H 2025-12-09T14:12:57.773Z 2025-12-17T15:31:48.475Z
8703708 8703708 20251208140205_UXP3t KR002H 2025-12-09T14:12:34.423Z 2025-12-17T15:31:47.282Z
8703622 8703622 20251208135453_RyKKl KR002H 2025-12-09T14:12:25.707Z 2025-12-17T15:31:46.499Z
8703552 8703552 20251208134638_111Er KR002H 2025-12-09T14:12:18.037Z 2025-12-17T15:31:45.374Z
8703427 8703427 20251208132935_9rCEz KR002H 2025-12-09T14:11:47.043Z 2025-12-17T15:31:43.948Z
8701528 8701528 20251208095648_uJ1ff KR002H 2025-12-09T14:05:20.970Z 2025-12-17T15:30:35.197Z
8701407 8701407 20251208094545_9ZkrH KR002H 2025-12-09T14:04:55.773Z 2025-12-17T15:30:22.806Z
8663622 8663622 20251130211209_Ow5Za KR002H 2025-12-02T14:18:37.254Z 2025-12-09T14:57:35.062Z
8663471 8663471 20251130204901_b8gLd KR002H 2025-12-02T14:18:20.423Z 2025-12-09T14:57:32.271Z
8663189 8663189 20251130202019_LP25K KR002H 2025-12-02T14:17:37.680Z 2025-12-09T14:57:26.469Z
8663049 8663049 20251130200016_EHTU9 KR002H 2025-12-02T14:17:20.814Z 2025-12-09T14:57:23.839Z
8662922 8662922 20251130194703_1ez7Y KR002H 2025-12-02T14:17:02.055Z 2025-12-09T14:57:21.741Z
8644330 8644330 20251128192027_llAF7 KR002H 2025-11-30T14:21:39.551Z 2025-12-07T14:56:19.496Z
8644149 8644149 20251128190332_NsANE KR002H 2025-11-30T14:21:24.361Z 2025-12-07T14:56:14.951Z
8644072 8644072 20251128185500_H0CPv KR002H 2025-11-30T14:21:18.178Z 2025-12-07T14:56:13.278Z
8643815 8643815 20251128182845_daYCF KR002H 2025-11-30T14:20:42.603Z 2025-12-07T14:56:08.569Z
8643734 8643734 20251128181947_2Tm3K KR002H 2025-11-30T14:20:37.558Z 2025-12-07T14:56:07.240Z
8643252 8643252 20251128173848_ptJMJ KR002H 2025-11-30T14:19:48.177Z 2025-12-07T14:55:58.389Z
8643186 8643186 20251128173137_mKfS7 KR002H 2025-11-30T14:19:25.826Z 2025-12-07T14:55:56.961Z
8643179 8643179 20251128173041_S925x KR002H 2025-11-30T14:19:25.292Z 2025-12-07T14:55:56.750Z
8643093 8643093 20251128172033_HAxIu KR002H 2025-11-30T14:19:19.231Z 2025-12-07T14:55:38.683Z
8643058 8643058 20251128171608_2ubj3 KR002H 2025-11-30T14:19:16.567Z 2025-12-07T14:55:35.762Z
8643044 8643044 20251128171527_7Xmyg KR002H 2025-11-30T14:19:15.953Z 2025-12-07T14:55:34.106Z
8642824 8642824 20251128165346_22ktm KR002H 2025-11-30T14:18:41.692Z 2025-12-07T14:55:17.301Z
8642565 8642565 20251128162403_UP7SE KR002H 2025-11-30T14:18:18.915Z 2025-12-07T14:55:10.841Z
8642432 8642432 20251128160343_wd2U3 KR002H 2025-11-30T14:17:54.219Z 2025-12-07T14:55:08.777Z
8642402 8642402 20251128160047_o8WTp KR002H 2025-11-30T14:17:52.261Z 2025-12-07T14:55:08.388Z
8642288 8642288 20251128154737_kglXx KR002H 2025-11-30T14:17:44.299Z 2025-12-07T14:55:07.065Z
8641646 8641646 20251128150445_5eGVP KR002H 2025-11-30T14:16:36.906Z 2025-12-07T14:54:57.974Z
8641606 8641606 20251128150111_iRIev KR002H 2025-11-30T14:16:34.698Z 2025-12-07T14:54:57.491Z
8641301 8641301 20251128142217_CnerE KR002H 2025-11-30T14:15:26.287Z 2025-12-07T14:54:27.477Z
8641178 8641178 20251128140242_tmiyC KR002H 2025-11-30T14:14:47.538Z 2025-12-07T14:54:20.573Z
8641121 8641121 20251128134531_0jZWp KR002H 2025-11-30T14:14:21.882Z 2025-12-07T14:54:17.143Z
8631911 8631911 20251127201416_cOi9k KR002H 2025-11-29T14:16:33.112Z 2025-12-06T15:00:46.073Z
8631827 8631827 20251127200424_vNlQe KR002H 2025-11-29T14:16:26.507Z 2025-12-06T15:00:43.516Z
8631733 8631733 20251127195524_PkvQy KR002H 2025-11-29T14:16:17.837Z 2025-12-06T15:00:39.142Z
8631667 8631667 20251127194202_m8TFA KR002H 2025-11-29T14:15:56.785Z 2025-12-06T15:00:34.364Z
8631570 8631570 20251127192716_P7dEk KR002H 2025-11-29T14:15:46.322Z 2025-12-06T15:00:20.808Z
8631510 8631510 20251127191904_QbeJ9 KR002H 2025-11-29T14:15:39.097Z 2025-12-06T15:00:15.390Z
8631487 8631487 20251127191401_7eSqx KR002H 2025-11-29T14:15:36.013Z 2025-12-06T15:00:14.328Z
8631424 8631424 20251127190557_YEg3w KR002H 2025-11-29T14:15:20.321Z 2025-12-06T15:00:11.486Z

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