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

>10,000 rows count all where station_code = "KR000N" 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
9583851 9583851 20260326191249_GfJ3G KR000N 2026-03-27T12:09:56.529Z 2026-04-04T12:41:41.514Z
9583542 9583542 20260326155725_IXvn6 KR000N 2026-03-27T12:09:05.823Z 2026-04-04T12:41:23.822Z
9583529 9583529 20260326155247_62BTe KR000N 2026-03-27T12:09:04.133Z 2026-04-04T12:41:23.240Z
9583525 9583525 20260326154727_fpOxq KR000N 2026-03-27T12:09:03.823Z 2026-04-04T12:41:22.848Z
9583419 9583419 20260326145145_ujoMy KR000N 2026-03-27T12:08:44.907Z 2026-04-04T12:41:11.104Z
9583362 9583362 20260326134636_zR2il KR000N 2026-03-27T12:08:34.215Z 2026-04-04T12:41:05.134Z
9583328 9583328 20260326124456_TzCKN KR000N 2026-03-27T12:08:25.940Z 2026-04-04T12:41:03.030Z
9583310 9583310 20260326121828_GNcny KR000N 2026-03-27T12:08:21.137Z 2026-04-04T12:41:02.007Z
9575023 9575023 20260323182127_YX5sH KR000N 2026-03-25T12:20:05.599Z 2026-03-31T12:28:46.701Z
9574986 9574986 20260323180218_Qqz82 KR000N 2026-03-25T12:20:01.081Z 2026-03-31T12:28:45.828Z
9574981 9574981 20260323175709_I5O5r KR000N 2026-03-25T12:19:59.926Z 2026-03-31T12:28:45.787Z
9574620 9574620 20260324190719_LNFEY KR000N 2026-03-25T12:11:08.779Z 2026-04-02T12:37:05.824Z
9570245 9570245 20260322201448_8t6Op KR000N 2026-03-24T12:22:52.457Z 2026-03-30T12:30:37.956Z
9570216 9570216 20260322195737_2fE1l KR000N 2026-03-24T12:22:49.495Z 2026-03-30T12:30:37.290Z
9570185 9570185 20260322194158_Nu34a KR000N 2026-03-24T12:22:46.425Z 2026-03-30T12:30:29.249Z
9570096 9570096 20260322191139_xGMay KR000N 2026-03-24T12:22:34.636Z 2026-03-30T12:30:27.786Z
9570085 9570085 20260322190846_br1pU KR000N 2026-03-24T12:22:33.883Z 2026-03-30T12:30:27.570Z
9570035 9570035 20260322190029_JHCH7 KR000N 2026-03-24T12:22:30.207Z 2026-03-30T12:30:26.824Z
9570031 9570031 20260322185945_y7U6N KR000N 2026-03-24T12:22:29.869Z 2026-03-30T12:30:26.684Z
9569967 9569967 20260322183852_GbyFN KR000N 2026-03-24T12:22:24.476Z 2026-03-30T12:30:25.523Z
9569927 9569927 20260322182716_k8mYp KR000N 2026-03-24T12:22:21.886Z 2026-03-30T12:30:25.029Z
9569899 9569899 20260322182411_NbkJv KR000N 2026-03-24T12:22:19.895Z 2026-03-30T12:30:24.687Z
9569879 9569879 20260322181508_3Tg1C KR000N 2026-03-24T12:22:17.418Z 2026-03-30T12:30:22.880Z
9569695 9569695 20260322170131_9L3Wa KR000N 2026-03-24T12:21:51.836Z 2026-03-30T12:30:17.079Z
9569649 9569649 20260322163721_Q8pq9 KR000N 2026-03-24T12:21:37.675Z 2026-03-30T12:30:13.177Z
9569414 9569414 20260322152653_2tjEg KR000N 2026-03-24T12:20:54.527Z 2026-03-30T12:29:53.488Z
9569405 9569405 20260322152248_FLCOn KR000N 2026-03-24T12:20:52.506Z 2026-03-30T12:29:52.788Z
9569287 9569287 20260322144254_6TzXC KR000N 2026-03-24T12:20:26.880Z 2026-03-30T12:29:45.120Z
9568630 9568630 20260323170746_QULH9 KR000N 2026-03-24T12:15:25.530Z 2026-03-31T12:28:39.137Z
9568600 9568600 20260323170102_HECtC KR000N 2026-03-24T12:15:21.599Z 2026-03-31T12:28:38.423Z
9568498 9568498 20260323165045_deS9J KR000N 2026-03-24T12:15:12.033Z 2026-03-24T12:24:25.468Z
9568470 9568470 20260323164709_Kx2Z4 KR000N 2026-03-24T12:15:09.952Z 2026-03-31T12:28:29.682Z
9568354 9568354 20260323163430_nx2FS KR000N 2026-03-24T12:14:56.724Z 2026-03-31T12:28:27.970Z
9568346 9568346 20260323163325_Jql2Y KR000N 2026-03-24T12:14:55.701Z 2026-03-31T12:28:27.671Z
9568189 9568189 20260323161827_zUac2 KR000N 2026-03-24T12:14:42.357Z 2026-03-31T12:28:24.328Z
9568148 9568148 20260323161618_DKom3 KR000N 2026-03-24T12:14:37.550Z 2026-03-31T12:28:23.584Z
9568111 9568111 20260323161438_Icb32 KR000N 2026-03-24T12:14:35.006Z 2026-03-31T12:28:23.164Z
9567984 9567984 20260323160349_GH8pm KR000N 2026-03-24T12:14:21.733Z 2026-03-24T12:24:25.373Z
9567906 9567906 20260323155913_TJ3Ly KR000N 2026-03-24T12:14:16.885Z 2026-03-31T12:28:20.404Z
9567353 9567353 20260323150938_zK15F KR000N 2026-03-24T12:13:25.882Z 2026-03-24T12:24:25.263Z
9567268 9567268 20260323150056_UJlZa KR000N 2026-03-24T12:13:19.389Z 2026-03-24T12:24:25.248Z
9567228 9567228 20260323145452_9IDT1 KR000N 2026-03-24T12:13:15.236Z 2026-03-31T12:28:10.803Z
9567214 9567214 20260323145343_PjLwG KR000N 2026-03-24T12:13:13.884Z 2026-03-31T12:28:10.399Z
9567010 9567010 20260323143203_C3Lyd KR000N 2026-03-24T12:12:51.022Z 2026-03-31T12:28:07.140Z
9565481 9565481 20260323121224_t1Mcf KR000N 2026-03-24T12:10:16.183Z 2026-03-31T12:27:36.216Z
9551586 9551586 20260320202549_D1Qk2 KR000N 2026-03-22T12:26:49.674Z 2026-03-28T12:36:58.388Z
9551543 9551543 20260320201431_NgOsL KR000N 2026-03-22T12:26:46.978Z 2026-03-28T12:36:57.734Z
9551267 9551267 20260320190440_Q5zDx KR000N 2026-03-22T12:26:21.438Z 2026-03-28T12:36:41.650Z
9551132 9551132 20260320183406_UnP30 KR000N 2026-03-22T12:26:12.687Z 2026-03-28T12:36:40.293Z
9551094 9551094 20260320182028_G3Uuf KR000N 2026-03-22T12:26:10.291Z 2026-03-28T12:36:39.920Z
9551066 9551066 20260320180816_C2xcC KR000N 2026-03-22T12:26:08.651Z 2026-03-28T12:36:39.513Z
9551017 9551017 20260320174601_wkTro KR000N 2026-03-22T12:26:05.019Z 2026-03-28T12:36:38.967Z
9551002 9551002 20260320174337_kzaOm KR000N 2026-03-22T12:26:04.241Z 2026-03-28T12:36:38.887Z
9550861 9550861 20260320171717_TKrNs KR000N 2026-03-22T12:25:48.461Z 2026-03-28T12:36:37.073Z
9550729 9550729 20260320170718_3UbAK KR000N 2026-03-22T12:25:40.225Z 2026-03-28T12:36:35.494Z
9550517 9550517 20260320164521_RC88n KR000N 2026-03-22T12:25:27.854Z 2026-03-28T12:36:32.066Z
9550231 9550231 20260320162225_fiHAl KR000N 2026-03-22T12:25:03.275Z 2026-03-28T12:36:28.538Z
9550144 9550144 20260320161253_409HM KR000N 2026-03-22T12:24:57.781Z 2026-03-28T12:36:27.608Z
9550138 9550138 20260320161152_sTna8 KR000N 2026-03-22T12:24:57.177Z 2026-03-28T12:36:27.456Z
9550079 9550079 20260320160654_zqY3g KR000N 2026-03-22T12:24:54.452Z 2026-03-28T12:36:26.977Z
9547853 9547853 20260321140358_TPjP6 KR000N 2026-03-22T12:14:24.609Z 2026-03-29T12:20:21.941Z
9545745 9545745 20260321110408_1K6bZ KR000N 2026-03-22T12:10:08.763Z 2026-03-22T12:27:38.102Z
9541375 9541375 20260319202626_vWoRd KR000N 2026-03-21T12:28:52.724Z 2026-03-27T12:42:37.005Z
9541252 9541252 20260319201037_rZVN4 KR000N 2026-03-21T12:28:46.764Z 2026-03-27T12:42:35.938Z
9541247 9541247 20260319201034_ohr5J KR000N 2026-03-21T12:28:46.470Z 2026-03-27T12:42:35.892Z
9541191 9541191 20260319195815_u4215 KR000N 2026-03-21T12:28:42.790Z 2026-03-27T12:42:35.181Z
9541160 9541160 20260319194606_JwRpg KR000N 2026-03-21T12:28:40.324Z 2026-03-27T12:42:34.738Z
9541136 9541136 20260319193921_bcACl KR000N 2026-03-21T12:28:38.646Z 2026-03-27T12:42:34.377Z
9541078 9541078 20260319191930_ZuvKg KR000N 2026-03-21T12:28:29.003Z 2026-03-27T12:42:33.771Z
9541023 9541023 20260319190210_lDJ46 KR000N 2026-03-21T12:28:24.311Z 2026-03-27T12:42:33.165Z
9540956 9540956 20260319184238_hCoSB KR000N 2026-03-21T12:28:19.339Z 2026-03-27T12:42:32.499Z
9540801 9540801 20260319180747_r9kZH KR000N 2026-03-21T12:28:10.077Z 2026-03-27T12:42:31.129Z
9540779 9540779 20260319175515_1NpeX KR000N 2026-03-21T12:28:08.707Z 2026-03-27T12:42:30.879Z
9540773 9540773 20260319175305_9wHZr KR000N 2026-03-21T12:28:08.629Z 2026-03-27T12:42:30.858Z
9540759 9540759 20260319174952_nseoJ KR000N 2026-03-21T12:28:07.709Z 2026-03-27T12:42:30.727Z
9540705 9540705 20260319172535_dkLee KR000N 2026-03-21T12:27:55.264Z 2026-03-27T12:42:29.874Z
9540690 9540690 20260319172319_MIAZp KR000N 2026-03-21T12:27:53.064Z 2026-03-27T12:42:29.586Z
9540681 9540681 20260319172115_5iyzE KR000N 2026-03-21T12:27:52.095Z 2026-03-27T12:42:29.513Z
9540659 9540659 20260319171329_Qvvs3 KR000N 2026-03-21T12:27:48.381Z 2026-03-27T12:42:29.080Z
9540512 9540512 20260319160625_l02nX KR000N 2026-03-21T12:27:07.719Z 2026-03-27T12:42:23.495Z
9540497 9540497 20260319155952_KBV47 KR000N 2026-03-21T12:27:05.422Z 2026-03-27T12:42:23.170Z
9540472 9540472 20260319154741_5a1mX KR000N 2026-03-21T12:27:02.633Z 2026-03-27T12:42:22.422Z
9540360 9540360 20260319152526_POCYw KR000N 2026-03-21T12:26:54.197Z 2026-03-27T12:42:20.490Z
9540324 9540324 20260319151501_t2mxC KR000N 2026-03-21T12:26:50.601Z 2026-03-27T12:42:19.636Z
9540295 9540295 20260319150221_O6bH4 KR000N 2026-03-21T12:26:40.869Z 2026-03-27T12:42:13.099Z
9540248 9540248 20260319144956_347LT KR000N 2026-03-21T12:26:33.899Z 2026-03-27T12:42:04.945Z
9540122 9540122 20260319132650_FkVSN KR000N 2026-03-21T12:26:11.570Z 2026-03-27T12:41:59.875Z
9540021 9540021 20260319123224_3I3zZ KR000N 2026-03-21T12:25:56.581Z 2026-03-27T12:41:56.363Z
9539390 9539390 20260320143904_2rWyg KR000N 2026-03-21T12:19:27.881Z 2026-03-28T12:36:00.187Z
9539031 9539031 20260320140443_NVPk2 KR000N 2026-03-21T12:18:51.761Z 2026-03-28T12:35:56.244Z
9538431 9538431 20260320130458_nwUQz KR000N 2026-03-21T12:17:42.423Z 2026-03-21T12:30:06.475Z
9538059 9538059 20260320122914_7ERlK KR000N 2026-03-21T12:17:01.271Z 2026-03-28T12:35:34.127Z
9537746 9537746 20260320120032_4eXc6 KR000N 2026-03-21T12:16:24.248Z 2026-03-28T12:35:28.922Z
9530060 9530060 20260318200223_awGhC KR000N 2026-03-20T12:23:57.281Z 2026-03-26T12:39:08.858Z
9529811 9529811 20260318193338_lq0vE KR000N 2026-03-20T12:23:39.845Z 2026-03-26T12:39:06.697Z
9529701 9529701 20260318191539_IpvzL KR000N 2026-03-20T12:23:34.088Z 2026-03-26T12:39:05.660Z
9529695 9529695 20260318191300_Ah5tD KR000N 2026-03-20T12:23:33.668Z 2026-03-26T12:39:05.600Z
9529641 9529641 20260318190105_cRtOM KR000N 2026-03-20T12:23:30.415Z 2026-03-26T12:39:05.067Z
9529577 9529577 20260318185542_fwGcv KR000N 2026-03-20T12:23:19.572Z 2026-03-26T12:39:04.539Z
9529399 9529399 20260318181134_sPDK1 KR000N 2026-03-20T12:23:08.452Z 2026-03-26T12:39:02.331Z

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