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,376 rows where station_code = "KR0021" 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
9613057 9613057 20260406190340_vWl3b KR0021 2026-04-07T12:03:41.379Z 2026-04-07T12:03:41.379Z
9612994 9612994 20260406182713_WzCsD KR0021 2026-04-07T12:03:29.093Z 2026-04-07T12:03:29.093Z
9612937 9612937 20260406180140_J2dXL KR0021 2026-04-07T12:03:16.559Z 2026-04-07T12:03:16.559Z
9612902 9612902 20260406174202_4UpVg KR0021 2026-04-07T12:03:10.810Z 2026-04-07T12:03:10.810Z
9612888 9612888 20260406173953_cYCq2 KR0021 2026-04-07T12:03:09.490Z 2026-04-07T12:03:09.490Z
9612511 9612511 20260406133037_lYvNM KR0021 2026-04-07T12:02:02.298Z 2026-04-07T12:02:02.298Z
9591714 9591714 20260328201017_Ym2Qh KR0021 2026-03-29T12:04:53.429Z 2026-04-06T12:39:43.012Z
9591706 9591706 20260328195959_UJLqW KR0021 2026-03-29T12:04:52.894Z 2026-04-06T12:39:42.198Z
9583813 9583813 20260326184052_5bp2y KR0021 2026-03-27T12:09:51.450Z 2026-04-04T12:41:40.001Z
9575203 9575203 20260323192652_eBs7p KR0021 2026-03-25T12:20:31.833Z 2026-03-31T12:28:51.000Z
9575162 9575162 20260323190131_x2pR7 KR0021 2026-03-25T12:20:25.835Z 2026-03-31T12:28:50.076Z
9570352 9570352 20260322204105_aUTsS KR0021 2026-03-24T12:23:03.487Z 2026-03-30T12:30:40.589Z
9570152 9570152 20260322193146_Z04pj KR0021 2026-03-24T12:22:39.522Z 2026-03-30T12:30:28.632Z
9570108 9570108 20260322191145_xDpAJ KR0021 2026-03-24T12:22:35.616Z 2026-03-30T12:30:27.848Z
9570015 9570015 20260322185233_AFGAQ KR0021 2026-03-24T12:22:28.241Z 2026-03-30T12:30:26.419Z
9569529 9569529 20260322160551_3woBc KR0021 2026-03-24T12:21:18.775Z 2026-03-30T12:30:07.511Z
9567738 9567738 20260323154448_tLg3q KR0021 2026-03-24T12:14:05.272Z 2026-03-31T12:28:18.170Z
9567678 9567678 20260323154012_Gjrka KR0021 2026-03-24T12:13:57.491Z 2026-03-24T12:24:25.321Z
9566685 9566685 20260323140412_ZrH9D KR0021 2026-03-24T12:12:18.589Z 2026-03-31T12:27:55.560Z
9547717 9547717 20260321135306_u8RX7 KR0021 2026-03-22T12:14:09.881Z 2026-03-29T12:20:11.367Z
9541393 9541393 20260319202944_4vbX7 KR0021 2026-03-21T12:28:53.480Z 2026-03-27T12:42:37.213Z
9540668 9540668 20260319171439_NkIkT KR0021 2026-03-21T12:27:49.224Z 2026-03-27T12:42:29.167Z
9540661 9540661 20260319171434_SdIyR KR0021 2026-03-21T12:27:48.905Z 2026-03-27T12:42:29.159Z
9540645 9540645 20260319171000_j3eMZ KR0021 2026-03-21T12:27:46.782Z 2026-03-27T12:42:28.804Z
9539895 9539895 20260319103717_Jf3aZ KR0021 2026-03-21T12:25:05.315Z 2026-03-27T12:41:39.136Z
9538846 9538846 20260320135052_TYQBY KR0021 2026-03-21T12:18:28.871Z 2026-03-28T12:35:53.587Z
9530040 9530040 20260318195724_kayQQ KR0021 2026-03-20T12:23:56.347Z 2026-03-26T12:39:08.678Z
9529608 9529608 20260318185911_Bu35P KR0021 2026-03-20T12:23:21.163Z 2026-03-26T12:39:04.830Z
9506623 9506623 20260316183759_1KV36 KR0021 2026-03-18T12:19:05.978Z 2026-03-24T12:41:33.820Z
9498606 9498606 20260316151557_P4w45 KR0021 2026-03-17T12:14:10.669Z 2026-03-24T12:41:26.583Z
9491693 9491693 20260315183204_9e2Au KR0021 2026-03-16T12:21:36.857Z 2026-03-23T12:22:40.970Z
9490711 9490711 20260315152524_DO2i5 KR0021 2026-03-16T12:19:37.308Z 2026-03-23T12:22:37.317Z
9489198 9489198 20260315125839_35BPZ KR0021 2026-03-16T12:16:41.968Z 2026-03-23T12:22:33.480Z
9488875 9488875 20260315122833_XFey6 KR0021 2026-03-16T12:16:00.392Z 2026-03-23T12:22:32.558Z
9481247 9481247 20260314145505_Znm7v KR0021 2026-03-15T12:17:28.682Z 2026-03-22T12:42:43.891Z
9479889 9479889 20260314123447_PDc3U KR0021 2026-03-15T12:14:47.769Z 2026-03-22T12:42:39.833Z
9473687 9473687 20260313182300_DSJmk KR0021 2026-03-14T12:15:37.709Z 2026-03-21T12:50:00.187Z
9473602 9473602 20260313173232_LoWEs KR0021 2026-03-14T12:15:25.935Z 2026-03-21T12:49:58.832Z
9473161 9473161 20260313155843_1t0iW KR0021 2026-03-14T12:14:34.437Z 2026-03-21T12:49:54.540Z
9471679 9471679 20260313111503_rjPuJ KR0021 2026-03-14T12:11:06.056Z 2026-03-21T12:49:41.732Z
9468447 9468447 20260312205623_OyqBg KR0021 2026-03-13T12:21:49.934Z 2026-03-20T12:37:16.250Z
9468305 9468305 20260312191236_i3bVW KR0021 2026-03-13T12:21:38.255Z 2026-03-20T12:37:14.444Z
9468247 9468247 20260312183949_mPhuT KR0021 2026-03-13T12:21:32.545Z 2026-03-20T12:37:13.980Z
9468217 9468217 20260312182932_6I3FM KR0021 2026-03-13T12:21:30.449Z 2026-03-20T12:37:13.701Z
9467840 9467840 20260312144658_9KPFD KR0021 2026-03-13T12:20:20.335Z 2026-03-20T12:37:09.839Z
9461272 9461272 20260311153217_h5ZGY KR0021 2026-03-12T12:16:52.806Z 2026-03-19T12:45:16.196Z
9461012 9461012 20260311131609_Dm2ns KR0021 2026-03-12T12:16:08.351Z 2026-03-19T12:45:09.801Z
9454980 9454980 20260310174949_Z0LNQ KR0021 2026-03-11T12:10:09.611Z 2026-03-18T12:39:51.229Z
9454687 9454687 20260310164535_YtrHr KR0021 2026-03-11T12:09:41.928Z 2026-03-18T12:39:48.390Z
9453587 9453587 20260310140646_uAPnK KR0021 2026-03-11T12:07:53.652Z 2026-03-18T12:39:38.672Z
9450086 9450086 20260309200644_Cl8D9 KR0021 2026-03-10T12:14:43.758Z 2026-03-17T12:42:38.747Z
9450080 9450080 20260309195753_aKYA8 KR0021 2026-03-10T12:14:42.228Z 2026-03-17T12:42:38.126Z
9450063 9450063 20260309184827_n8yns KR0021 2026-03-10T12:14:37.931Z 2026-03-17T12:42:34.543Z
9444392 9444392 20260308134450_gnBAM KR0021 2026-03-09T12:10:43.158Z 2026-03-16T12:44:28.966Z
9440628 9440628 20260307203620_ch0Qj KR0021 2026-03-08T12:14:06.194Z 2026-03-15T12:42:11.248Z
9440606 9440606 20260307202352_dN0LJ KR0021 2026-03-08T12:14:02.190Z 2026-03-15T12:42:10.818Z
9439245 9439245 20260307125612_akBcR KR0021 2026-03-08T12:09:55.415Z 2026-03-15T12:41:41.103Z
9438954 9438954 20260307120240_W9hAO KR0021 2026-03-08T12:09:06.279Z 2026-03-15T12:41:37.224Z
9423546 9423546 20260304105626_FP1ye KR0021 2026-03-05T14:05:17.520Z 2026-03-12T12:32:58.818Z
9408754 9408754 20260227204750_r845A KR0021 2026-02-28T14:26:25.541Z 2026-03-07T14:51:07.832Z
9408437 9408437 20260227190012_oaN3S KR0021 2026-02-28T14:25:50.646Z 2026-03-07T14:50:52.934Z
9408402 9408402 20260227183919_1LOAx KR0021 2026-02-28T14:25:45.883Z 2026-03-07T14:50:50.487Z
9396711 9396711 20260225210245_8tQSb KR0021 2026-02-26T14:23:35.810Z 2026-03-05T14:38:52.763Z
9396660 9396660 20260225204331_n31Q5 KR0021 2026-02-26T14:23:32.874Z 2026-03-05T14:38:49.710Z
9396430 9396430 20260225192522_CZ6y2 KR0021 2026-02-26T14:23:17.437Z 2026-03-05T14:38:39.919Z
9396243 9396243 20260225184829_sc9rY KR0021 2026-02-26T14:22:59.974Z 2026-03-05T14:38:35.865Z
9395611 9395611 20260225152600_GUcDV KR0021 2026-02-26T14:22:02.600Z 2026-03-05T14:38:00.798Z
9389328 9389328 20260224182926_yO50Q KR0021 2026-02-25T14:24:41.596Z 2026-03-04T14:19:15.422Z
9381219 9381219 20260222211658_CtNc7 KR0021 2026-02-24T14:24:25.098Z 2026-02-24T14:24:25.098Z
9380153 9380153 20260222190122_nXGOc KR0021 2026-02-24T14:22:43.634Z 2026-02-24T14:22:43.634Z
9380122 9380122 20260222185710_L4c29 KR0021 2026-02-24T14:22:40.931Z 2026-02-24T14:22:40.931Z
9379305 9379305 20260222163741_XMJH9 KR0021 2026-02-24T14:21:09.770Z 2026-02-24T14:21:09.770Z
9379143 9379143 20260222161459_9TBf7 KR0021 2026-02-24T14:20:47.703Z 2026-02-24T14:20:47.703Z
9370964 9370964 20260221161601_zTC2L KR0021 2026-02-23T14:22:36.100Z 2026-03-02T14:22:03.506Z
9370682 9370682 20260221142029_1hH0A KR0021 2026-02-23T14:20:40.492Z 2026-03-02T14:21:55.921Z
9364234 9364234 20260220200431_z6DRD KR0021 2026-02-22T14:21:03.960Z 2026-03-01T14:22:52.117Z
9363870 9363870 20260220174643_qc3Rv KR0021 2026-02-22T14:20:14.253Z 2026-03-01T14:22:48.691Z
9363307 9363307 20260220145149_AZ0sk KR0021 2026-02-22T14:18:16.634Z 2026-03-01T14:22:20.396Z
9363293 9363293 20260220144900_RoSWH KR0021 2026-02-22T14:18:15.233Z 2026-03-01T14:22:20.314Z
9362906 9362906 20260220120517_TDpal KR0021 2026-02-22T14:16:30.506Z 2026-03-01T14:22:09.556Z
9357997 9357997 20260219212302_AQT3E KR0021 2026-02-21T14:17:20.890Z 2026-02-28T14:44:46.222Z
9357338 9357338 20260219174938_CzL7U KR0021 2026-02-21T14:15:48.103Z 2026-02-28T14:44:32.773Z
9357270 9357270 20260219172849_vM5O5 KR0021 2026-02-21T14:15:39.884Z 2026-02-28T14:44:31.185Z
9349510 9349510 20260218182526_MgbhS KR0021 2026-02-20T14:01:57.907Z 2026-02-27T14:35:50.706Z
9349247 9349247 20260218173605_2i47v KR0021 2026-02-20T14:01:57.234Z 2026-02-27T14:35:47.904Z
9348837 9348837 20260218162940_Ig84f KR0021 2026-02-20T14:01:55.724Z 2026-02-27T14:35:35.904Z
9347974 9347974 20260218145658_S8E5j KR0021 2026-02-20T14:01:53.282Z 2026-02-27T14:35:12.459Z
9347463 9347463 20260218134944_ZdsbE KR0021 2026-02-20T14:01:52.143Z 2026-02-27T14:35:06.755Z
9339053 9339053 20260217202605_xqG7y KR0021 2026-02-18T14:13:40.847Z 2026-02-18T14:13:40.847Z
9338974 9338974 20260217191716_nWnxy KR0021 2026-02-18T14:13:24.710Z 2026-02-26T14:40:05.498Z
9338949 9338949 20260217184633_sl1ww KR0021 2026-02-18T14:13:16.809Z 2026-02-26T14:40:04.225Z
9338903 9338903 20260217180913_Vw9LX KR0021 2026-02-18T14:13:05.697Z 2026-02-26T14:40:02.461Z
9338821 9338821 20260217174209_dHcze KR0021 2026-02-18T14:12:47.453Z 2026-02-26T14:39:58.083Z
9338294 9338294 20260217143838_3oP3Q KR0021 2026-02-18T14:10:31.113Z 2026-02-26T14:39:38.196Z
9338072 9338072 20260217123133_kDAHa KR0021 2026-02-18T14:09:39.072Z 2026-02-26T14:39:34.391Z
9337977 9337977 20260217110539_E2VZV KR0021 2026-02-18T14:09:15.678Z 2026-02-26T14:39:33.070Z
9333538 9333538 20260216202606_373Au KR0021 2026-02-17T14:16:16.872Z 2026-02-25T14:42:44.258Z
9333517 9333517 20260216201750_IJoow KR0021 2026-02-17T14:16:11.939Z 2026-02-25T14:42:43.767Z
9333417 9333417 20260216194318_fL3Xk KR0021 2026-02-17T14:15:57.214Z 2026-02-25T14:42:42.516Z
9333398 9333398 20260216193607_2P792 KR0021 2026-02-17T14:15:54.414Z 2026-02-25T14:42:41.810Z

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