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,454 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
8689702 8689702 20251205194757_PtFWU KR002F 2025-12-06T14:09:31.529Z 2025-12-06T14:09:31.529Z
8689674 8689674 20251205193005_D9QGW KR002F 2025-12-06T14:09:24.550Z 2025-12-06T14:09:24.550Z
8689641 8689641 20251205191147_xRT6d KR002F 2025-12-06T14:09:19.494Z 2025-12-06T14:09:19.494Z
8689635 8689635 20251205190623_Zg6i2 KR002F 2025-12-06T14:09:17.774Z 2025-12-06T14:09:17.774Z
8689609 8689609 20251205185126_qTs9n KR002F 2025-12-06T14:09:11.200Z 2025-12-06T14:09:11.200Z
8686847 8686847 20251203210210_xbxBi KR002F 2025-12-05T14:13:01.809Z 2025-12-06T14:22:09.731Z
8686810 8686810 20251203205704_lCV5j KR002F 2025-12-05T14:12:50.924Z 2025-12-06T14:22:07.684Z
8686606 8686606 20251203201448_vqZM1 KR002F 2025-12-05T14:12:28.871Z 2025-12-06T14:21:59.384Z
8686530 8686530 20251203200044_243zh KR002F 2025-12-05T14:12:06.112Z 2025-12-06T14:21:56.900Z
8686510 8686510 20251203195658_CFTHX KR002F 2025-12-05T14:12:04.196Z 2025-12-06T14:21:56.010Z
8686498 8686498 20251203195559_dgLSG KR002F 2025-12-05T14:12:03.256Z 2025-12-06T14:21:55.499Z
8686417 8686417 20251203194333_p83Uj KR002F 2025-12-05T14:11:51.050Z 2025-12-06T14:21:50.082Z
8686402 8686402 20251203194243_GgWNa KR002F 2025-12-05T14:11:50.685Z 2025-12-06T14:21:49.934Z
8686362 8686362 20251203193709_Ca4jS KR002F 2025-12-05T14:11:48.250Z 2025-12-06T14:21:49.149Z
8686329 8686329 20251203193441_5gN9H KR002F 2025-12-05T14:11:44.381Z 2025-12-06T14:21:44.119Z
8686155 8686155 20251203185302_3ANaM KR002F 2025-12-05T14:11:08.820Z 2025-12-06T14:21:32.189Z
8686118 8686118 20251203184726_b2f6H KR002F 2025-12-05T14:11:05.051Z 2025-12-06T14:21:30.996Z
8685952 8685952 20251203174923_2oVk3 KR002F 2025-12-05T14:10:34.122Z 2025-12-06T14:21:22.933Z
8685874 8685874 20251203172130_BW1ZA KR002F 2025-12-05T14:10:21.564Z 2025-12-06T14:21:09.286Z
8685844 8685844 20251203171223_6d76R KR002F 2025-12-05T14:10:06.245Z 2025-12-06T14:21:07.271Z
8685835 8685835 20251203170716_ZlvMA KR002F 2025-12-05T14:10:05.657Z 2025-12-06T14:21:06.926Z
8685803 8685803 20251203165552_jpBAG KR002F 2025-12-05T14:09:59.501Z 2025-12-06T14:21:02.643Z
8685779 8685779 20251203164759_o6JVz KR002F 2025-12-05T14:09:56.524Z 2025-12-06T14:21:00.926Z
8685770 8685770 20251203164222_2W4LM KR002F 2025-12-05T14:09:54.734Z 2025-12-06T14:20:59.396Z
8685716 8685716 20251203161953_ESe76 KR002F 2025-12-05T14:09:46.651Z 2025-12-06T14:20:56.957Z
8685670 8685670 20251203154846_r0Uqi KR002F 2025-12-05T14:09:31.551Z 2025-12-06T14:20:51.749Z
8685614 8685614 20251203153046_sxl54 KR002F 2025-12-05T14:09:22.116Z 2025-12-06T14:20:48.093Z
8685578 8685578 20251203151036_9ehJO KR002F 2025-12-05T14:09:14.474Z 2025-12-06T14:20:38.633Z
8685559 8685559 20251203145734_Fvect KR002F 2025-12-05T14:09:05.156Z 2025-12-06T14:20:35.950Z
8685549 8685549 20251203144903_RUKTf KR002F 2025-12-05T14:09:00.779Z 2025-12-06T14:20:35.087Z
8685355 8685355 20251204204550_Y38D1 KR002F 2025-12-05T14:06:54.090Z 2025-12-06T14:18:00.810Z
8685344 8685344 20251204202316_TfsGF KR002F 2025-12-05T14:06:50.990Z 2025-12-06T14:18:00.804Z
8678800 8678800 20251202173432_WWQBD KR002F 2025-12-04T14:08:13.575Z 2025-12-06T14:25:28.486Z
8678733 8678733 20251202171343_zOzVM KR002F 2025-12-04T14:08:00.865Z 2025-12-06T14:25:22.306Z
8673108 8673108 20251201165740_jaG3F KR002F 2025-12-03T14:17:34.712Z 2025-12-06T14:32:44.434Z
8673032 8673032 20251201162545_4Txg3 KR002F 2025-12-03T14:17:09.329Z 2025-12-06T14:32:31.276Z
8673010 8673010 20251201161834_OCrp8 KR002F 2025-12-03T14:17:06.752Z 2025-12-06T14:32:30.584Z
8672934 8672934 20251201154033_L9MuR KR002F 2025-12-03T14:16:57.673Z 2025-12-06T14:32:27.316Z
8671536 8671536 20251201123023_uA6mZ KR002F 2025-12-03T14:12:56.448Z 2025-12-06T14:31:10.030Z
8663530 8663530 20251130205640_hs7m7 KR002F 2025-12-02T14:18:24.581Z 2025-12-06T14:40:02.180Z
8663450 8663450 20251130204810_v3CCk KR002F 2025-12-02T14:18:18.416Z 2025-12-06T14:40:00.875Z
8663132 8663132 20251130201445_FDWQG KR002F 2025-12-02T14:17:30.369Z 2025-12-06T14:39:53.171Z
8663076 8663076 20251130200609_vjTfm KR002F 2025-12-02T14:17:24.521Z 2025-12-06T14:39:48.467Z
8663038 8663038 20251130195939_JNglA KR002F 2025-12-02T14:17:19.527Z 2025-12-06T14:39:42.558Z
8662972 8662972 20251130195040_wd0u0 KR002F 2025-12-02T14:17:13.202Z 2025-12-06T14:39:36.767Z
8662962 8662962 20251130195029_gaOzb KR002F 2025-12-02T14:17:12.825Z 2025-12-06T14:39:36.601Z
8662915 8662915 20251130194643_33tST KR002F 2025-12-02T14:17:00.964Z 2025-12-06T14:39:35.249Z
8662900 8662900 20251130194643_DdfYp KR002F 2025-12-02T14:17:00.117Z 2025-12-06T14:39:35.040Z
8658185 8658185 20251128134120_TPf8s KR002F 2025-12-01T14:40:34.707Z 2025-12-06T14:52:21.752Z
8650376 8650376 20251129200428_CDenH KR002F 2025-12-01T14:15:56.250Z 2025-12-06T14:45:55.127Z
8649156 8649156 20251129162738_6PpDv KR002F 2025-12-01T14:11:14.146Z 2025-12-06T14:44:50.160Z
8649150 8649150 20251129162556_XERVl KR002F 2025-12-01T14:11:13.114Z 2025-12-06T14:44:50.060Z
8649085 8649085 20251129160616_n1vjT KR002F 2025-12-01T14:10:51.083Z 2025-12-06T14:44:48.043Z
8649072 8649072 20251129160135_ZvdVF KR002F 2025-12-01T14:10:48.256Z 2025-12-06T14:44:47.707Z
8648950 8648950 20251129152423_LDLoC KR002F 2025-12-01T14:10:02.174Z 2025-12-06T14:44:42.125Z
8648944 8648944 20251129152237_CKMZV KR002F 2025-12-01T14:10:01.234Z 2025-12-06T14:44:42.027Z
8648895 8648895 20251129144922_RKGpt KR002F 2025-12-01T14:09:17.080Z 2025-12-06T14:44:38.755Z
8648712 8648712 20251129095838_12eRg KR002F 2025-12-01T14:01:53.489Z 2025-12-06T14:43:04.801Z
8645218 8645218 20251128205259_ttt23 KR002F 2025-11-30T14:23:13.193Z 2025-12-06T14:54:51.615Z
8645157 8645157 20251128204436_ijSMl KR002F 2025-11-30T14:23:10.191Z 2025-12-06T14:54:51.085Z
8645088 8645088 20251128203458_yUTWO KR002F 2025-11-30T14:23:02.390Z 2025-12-06T14:54:50.564Z
8644910 8644910 20251128201406_DhCRC KR002F 2025-11-30T14:22:51.563Z 2025-12-06T14:54:48.850Z
8644853 8644853 20251128200546_nCyju KR002F 2025-11-30T14:22:47.766Z 2025-12-06T14:54:48.228Z
8644649 8644649 20251128193905_EXgwC KR002F 2025-11-30T14:22:11.772Z 2025-12-06T14:54:45.536Z
8644503 8644503 20251128192855_WcX8i KR002F 2025-11-30T14:22:02.848Z 2025-12-06T14:54:43.093Z
8644439 8644439 20251128192649_9CbGG KR002F 2025-11-30T14:22:00.008Z 2025-12-06T14:54:42.217Z
8644189 8644189 20251128190549_5cLIw KR002F 2025-11-30T14:21:26.740Z 2025-12-06T14:54:39.124Z
8643933 8643933 20251128183953_lY6W6 KR002F 2025-11-30T14:20:49.989Z 2025-12-06T14:54:33.601Z
8643903 8643903 20251128183744_DUr3m KR002F 2025-11-30T14:20:47.953Z 2025-12-06T14:54:31.803Z
8643860 8643860 20251128183204_ibtwy KR002F 2025-11-30T14:20:45.272Z 2025-12-06T14:54:28.326Z
8643795 8643795 20251128182749_oC0e5 KR002F 2025-11-30T14:20:41.183Z 2025-12-06T14:54:16.024Z
8643760 8643760 20251128182338_QjCYt KR002F 2025-11-30T14:20:38.930Z 2025-12-06T14:54:12.728Z
8643632 8643632 20251128180932_ghEyB KR002F 2025-11-30T14:20:27.926Z 2025-12-06T14:53:59.949Z
8643574 8643574 20251128180705_K2WwD KR002F 2025-11-30T14:20:13.712Z 2025-12-06T14:53:51.470Z
8643466 8643466 20251128175950_v0Jc2 KR002F 2025-11-30T14:20:03.341Z 2025-12-06T14:53:49.840Z
8643381 8643381 20251128174751_cvJLU KR002F 2025-11-30T14:19:57.642Z 2025-12-06T14:53:48.573Z
8643266 8643266 20251128173954_pP3h7 KR002F 2025-11-30T14:19:48.971Z 2025-12-06T14:53:45.037Z
8643234 8643234 20251128173708_2AIcn KR002F 2025-11-30T14:19:44.317Z 2025-12-06T14:53:44.186Z
8642800 8642800 20251128165004_s1RE3 KR002F 2025-11-30T14:18:37.647Z 2025-12-06T14:53:36.470Z
8642745 8642745 20251128164304_clIaU KR002F 2025-11-30T14:18:33.980Z 2025-12-06T14:53:35.870Z
8642578 8642578 20251128162503_sMmIw KR002F 2025-11-30T14:18:19.329Z 2025-12-06T14:53:33.770Z
8642422 8642422 20251128160305_2OsaW KR002F 2025-11-30T14:17:53.649Z 2025-12-06T14:53:31.440Z
8642272 8642272 20251128154610_y6qaq KR002F 2025-11-30T14:17:43.171Z 2025-12-06T14:53:27.026Z
8642260 8642260 20251128154426_gZKU8 KR002F 2025-11-30T14:17:42.862Z 2025-12-06T14:53:26.703Z
8642194 8642194 20251128153732_kIDNY KR002F 2025-11-30T14:17:39.656Z 2025-12-06T14:53:22.357Z
8642166 8642166 20251128153600_E67zf KR002F 2025-11-30T14:17:38.005Z 2025-12-06T14:53:20.880Z
8641385 8641385 20251128143938_xNbq3 KR002F 2025-11-30T14:15:52.232Z 2025-12-06T14:52:34.357Z
8641158 8641158 20251128135917_nmMXZ KR002F 2025-11-30T14:14:37.506Z 2025-12-06T14:52:25.935Z
8641075 8641075 20251128134120_gV8oG KR002F 2025-11-30T14:14:05.074Z 2025-11-30T14:30:17.978Z
8640837 8640837 20251128115949_7zvMk KR002F 2025-11-30T14:11:09.917Z 2025-12-06T14:51:30.446Z
8632513 8632513 20251127211509_mDMWB KR002F 2025-11-29T14:17:44.936Z 2025-12-06T15:01:23.974Z
8632269 8632269 20251127204502_fI1rW KR002F 2025-11-29T14:17:11.962Z 2025-12-06T15:01:07.326Z
8632056 8632056 20251127202755_pPfDV KR002F 2025-11-29T14:16:46.396Z 2025-12-06T15:00:50.759Z
8631995 8631995 20251127201905_Exscz KR002F 2025-11-29T14:16:39.183Z 2025-12-06T15:00:49.272Z
8631982 8631982 20251127201736_Of5Pw KR002F 2025-11-29T14:16:37.877Z 2025-12-06T15:00:48.667Z
8631907 8631907 20251127201348_Ojm3b KR002F 2025-11-29T14:16:32.876Z 2025-12-06T15:00:46.056Z
8631811 8631811 20251127200240_5yfz7 KR002F 2025-11-29T14:16:25.546Z 2025-12-06T15:00:43.232Z
8631803 8631803 20251127200221_v9B3c KR002F 2025-11-29T14:16:25.073Z 2025-12-06T15:00:42.294Z
8631771 8631771 20251127195856_vDzl2 KR002F 2025-11-29T14:16:22.247Z 2025-12-06T15:00:41.487Z
8631766 8631766 20251127195856_wgCKe KR002F 2025-11-29T14:16:21.889Z 2025-12-06T15:00:41.473Z

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