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

6,865 rows where station_code = "KR003M" 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
9591677 9591677 20260328185459_ykS84 KR003M 2026-03-29T12:04:50.007Z 2026-04-06T12:39:38.603Z
9583867 9583867 20260326191634_RmQ2f KR003M 2026-03-27T12:09:58.231Z 2026-04-04T12:41:48.879Z
9583849 9583849 20260326191136_iRUZz KR003M 2026-03-27T12:09:55.905Z 2026-04-04T12:41:41.359Z
9583779 9583779 20260326180805_Utg6r KR003M 2026-03-27T12:09:44.330Z 2026-04-04T12:41:38.573Z
9575249 9575249 20260323195330_rQs6w KR003M 2026-03-25T12:20:40.691Z 2026-03-31T12:28:52.226Z
9575062 9575062 20260323182848_Q69jV KR003M 2026-03-25T12:20:12.582Z 2026-03-31T12:28:47.384Z
9575005 9575005 20260323180853_SKhZA KR003M 2026-03-25T12:20:03.375Z 2026-03-31T12:28:46.214Z
9574975 9574975 20260323175356_E9hjd KR003M 2026-03-25T12:19:58.922Z 2026-03-31T12:28:45.621Z
9574833 9574833 20260323172558_HwTdy KR003M 2026-03-25T12:19:44.782Z 2026-03-31T12:28:42.849Z
9569995 9569995 20260322184850_H1ZeT KR003M 2026-03-24T12:22:26.744Z 2026-03-30T12:30:26.039Z
9569963 9569963 20260322183547_qtOcn KR003M 2026-03-24T12:22:24.000Z 2026-03-30T12:30:25.489Z
9569918 9569918 20260322182457_XKuYQ KR003M 2026-03-24T12:22:20.616Z 2026-03-30T12:30:24.780Z
9569832 9569832 20260322175605_V8G2R KR003M 2026-03-24T12:22:09.734Z 2026-03-30T12:30:22.080Z
9569817 9569817 20260322175000_ZYuFT KR003M 2026-03-24T12:22:08.566Z 2026-03-30T12:30:21.805Z
9569785 9569785 20260322173622_Jv0Lq KR003M 2026-03-24T12:22:05.895Z 2026-03-30T12:30:20.974Z
9568882 9568882 20260322105838_7YPeb KR003M 2026-03-24T12:18:47.275Z 2026-03-30T12:29:03.703Z
9568864 9568864 20260322103134_KZY6B KR003M 2026-03-24T12:18:37.744Z 2026-03-30T12:29:00.570Z
9567171 9567171 20260323144732_PRCs6 KR003M 2026-03-24T12:13:09.507Z 2026-03-31T12:28:09.585Z
9566654 9566654 20260323135942_Hstab KR003M 2026-03-24T12:12:15.722Z 2026-03-31T12:27:55.081Z
9549196 9549196 20260320120148_Nopr6 KR003M 2026-03-22T12:21:49.067Z 2026-03-28T12:35:29.232Z
9548262 9548262 20260321144920_ug3mO KR003M 2026-03-22T12:15:07.976Z 2026-03-29T12:20:24.985Z
9547287 9547287 20260321131300_20oJB KR003M 2026-03-22T12:13:19.897Z 2026-03-29T12:20:08.397Z
9546764 9546764 20260321122538_zJZMz KR003M 2026-03-22T12:12:22.017Z 2026-03-29T12:20:04.117Z
9545550 9545550 20260321104656_UHeaQ KR003M 2026-03-22T12:09:43.213Z 2026-03-29T12:19:41.203Z
9545529 9545529 20260321104502_W04wv KR003M 2026-03-22T12:09:38.713Z 2026-03-29T12:19:41.037Z
9541273 9541273 20260319201232_CQdG6 KR003M 2026-03-21T12:28:47.551Z 2026-03-27T12:42:36.061Z
9541095 9541095 20260319192206_t2wzv KR003M 2026-03-21T12:28:29.658Z 2026-03-27T12:42:33.888Z
9541085 9541085 20260319192135_2w2tw KR003M 2026-03-21T12:28:29.338Z 2026-03-27T12:42:33.835Z
9541068 9541068 20260319191737_4RBGi KR003M 2026-03-21T12:28:28.124Z 2026-03-27T12:42:33.586Z
9540998 9540998 20260319185118_VDwmG KR003M 2026-03-21T12:28:22.000Z 2026-03-27T12:42:32.785Z
9540851 9540851 20260319181523_E1Zsl KR003M 2026-03-21T12:28:13.138Z 2026-03-27T12:42:31.499Z
9540738 9540738 20260319173547_QwsHZ KR003M 2026-03-21T12:28:03.833Z 2026-03-27T12:42:30.478Z
9540590 9540590 20260319164606_S234Q KR003M 2026-03-21T12:27:33.392Z 2026-03-27T12:42:26.494Z
9540509 9540509 20260319160430_IQ2fk KR003M 2026-03-21T12:27:07.238Z 2026-03-27T12:42:23.400Z
9540458 9540458 20260319154441_dXmLx KR003M 2026-03-21T12:27:01.293Z 2026-03-27T12:42:22.165Z
9540430 9540430 20260319154024_hog6R KR003M 2026-03-21T12:26:59.873Z 2026-03-27T12:42:21.726Z
9540188 9540188 20260319141437_B8rlP KR003M 2026-03-21T12:26:25.765Z 2026-03-27T12:42:02.868Z
9540168 9540168 20260319140346_88b5p KR003M 2026-03-21T12:26:23.539Z 2026-03-27T12:42:02.411Z
9540119 9540119 20260319131424_9MytV KR003M 2026-03-21T12:26:10.124Z 2026-03-27T12:41:59.364Z
9540101 9540101 20260319125328_BXfh3 KR003M 2026-03-21T12:26:03.174Z 2026-03-27T12:41:58.116Z
9540093 9540093 20260319124815_Q5lUm KR003M 2026-03-21T12:26:02.356Z 2026-03-27T12:41:57.944Z
9540041 9540041 20260319123721_BBoJx KR003M 2026-03-21T12:25:58.070Z 2026-03-27T12:41:56.678Z
9529931 9529931 20260318194327_XvG25 KR003M 2026-03-20T12:23:50.105Z 2026-03-26T12:39:07.608Z
9529899 9529899 20260318193920_nFtFO KR003M 2026-03-20T12:23:47.807Z 2026-03-26T12:39:07.282Z
9528322 9528322 20260318160611_YXGBQ KR003M 2026-03-20T12:22:12.679Z 2026-03-26T12:38:35.397Z
9496986 9496986 20260316123917_52SOF KR003M 2026-03-17T12:11:03.721Z 2026-03-24T12:41:21.962Z
9496564 9496564 20260316115334_k2bgk KR003M 2026-03-17T12:10:04.867Z 2026-03-24T12:41:20.326Z
9491524 9491524 20260315170326_Wku4U KR003M 2026-03-16T12:21:11.377Z 2026-03-23T12:22:39.780Z
9489038 9489038 20260315124237_K1e5w KR003M 2026-03-16T12:16:19.996Z 2026-03-23T12:22:32.979Z
9488929 9488929 20260315123525_h2RuK KR003M 2026-03-16T12:16:09.327Z 2026-03-23T12:22:32.665Z
9488873 9488873 20260315122639_DiCNE KR003M 2026-03-16T12:15:59.913Z 2026-03-23T12:22:32.548Z
9488835 9488835 20260315122146_rXcyz KR003M 2026-03-16T12:15:54.810Z 2026-03-23T12:22:32.497Z
9473862 9473862 20260313203247_viWnx KR003M 2026-03-14T12:16:06.147Z 2026-03-21T12:50:18.090Z
9473820 9473820 20260313195541_uy6GX KR003M 2026-03-14T12:16:00.080Z 2026-03-21T12:50:11.594Z
9473738 9473738 20260313184311_6AgNu KR003M 2026-03-14T12:15:43.886Z 2026-03-21T12:50:00.864Z
9473634 9473634 20260313174154_MrxaT KR003M 2026-03-14T12:15:29.814Z 2026-03-21T12:49:58.982Z
9473595 9473595 20260313172944_nY2yz KR003M 2026-03-14T12:15:22.097Z 2026-03-21T12:49:58.766Z
9473420 9473420 20260313165413_bQSFS KR003M 2026-03-14T12:15:02.811Z 2026-03-21T12:49:57.275Z
9473004 9473004 20260313153327_FoBGa KR003M 2026-03-14T12:14:17.387Z 2026-03-21T12:49:53.216Z
9472948 9472948 20260313152649_NL24f KR003M 2026-03-14T12:14:12.868Z 2026-03-21T12:49:52.901Z
9472401 9472401 20260313135849_EZCAY KR003M 2026-03-14T12:13:08.173Z 2026-03-21T12:49:48.374Z
9472383 9472383 20260313135622_WXTun KR003M 2026-03-14T12:13:06.366Z 2026-03-21T12:49:48.268Z
9472306 9472306 20260313133914_Z24B3 KR003M 2026-03-14T12:12:52.807Z 2026-03-21T12:49:47.660Z
9471982 9471982 20260313121604_tIuVt KR003M 2026-03-14T12:12:01.201Z 2026-03-21T12:49:45.138Z
9455051 9455051 20260310181725_rsPGk KR003M 2026-03-11T12:10:20.960Z 2026-03-18T12:39:52.591Z
9455009 9455009 20260310175918_LBctv KR003M 2026-03-11T12:10:12.539Z 2026-03-18T12:39:51.466Z
9454921 9454921 20260310173254_3Ijzh KR003M 2026-03-11T12:10:03.716Z 2026-03-18T12:39:50.549Z
9454868 9454868 20260310172247_N4EB9 KR003M 2026-03-11T12:09:59.929Z 2026-03-18T12:39:50.036Z
9454721 9454721 20260310165024_fdWnU KR003M 2026-03-11T12:09:46.450Z 2026-03-18T12:39:48.520Z
9453862 9453862 20260310144731_fvMKP KR003M 2026-03-11T12:08:20.940Z 2026-03-18T12:39:41.146Z
9453689 9453689 20260310142201_7RrMy KR003M 2026-03-11T12:08:02.313Z 2026-03-18T12:39:39.364Z
9453089 9453089 20260310123428_GazPs KR003M 2026-03-11T12:06:52.222Z 2026-03-18T12:39:20.436Z
9444128 9444128 20260308123623_NU9vR KR003M 2026-03-09T12:09:58.664Z 2026-03-16T12:44:26.319Z
9444090 9444090 20260308123218_rTpI2 KR003M 2026-03-09T12:09:52.326Z 2026-03-16T12:44:25.876Z
9440426 9440426 20260307175934_kwhty KR003M 2026-03-08T12:13:34.091Z 2026-03-15T12:42:05.806Z
9440298 9440298 20260307170336_bCM93 KR003M 2026-03-08T12:13:17.648Z 2026-03-15T12:42:04.866Z
9440100 9440100 20260307160932_HV3V2 KR003M 2026-03-08T12:12:38.788Z 2026-03-15T12:42:03.223Z
9440078 9440078 20260307160446_Pt42r KR003M 2026-03-08T12:12:34.587Z 2026-03-15T12:42:02.984Z
9439487 9439487 20260307134932_iydOC KR003M 2026-03-08T12:10:30.229Z 2026-03-15T12:41:42.960Z
9439364 9439364 20260307133023_DS0R2 KR003M 2026-03-08T12:10:13.015Z 2026-03-15T12:41:42.076Z
9408809 9408809 20260227210048_VbadK KR003M 2026-02-28T14:26:30.929Z 2026-03-07T14:51:10.855Z
9408747 9408747 20260227204358_tVmIV KR003M 2026-02-28T14:26:24.691Z 2026-03-07T14:51:07.363Z
9408531 9408531 20260227193433_NOt7l KR003M 2026-02-28T14:25:59.630Z 2026-03-07T14:50:56.868Z
9389754 9389754 20260224203149_vr6Oz KR003M 2026-02-25T14:25:22.987Z 2026-03-04T14:19:23.107Z
9389678 9389678 20260224195605_4a61Q KR003M 2026-02-25T14:25:19.187Z 2026-03-04T14:19:20.584Z
9389581 9389581 20260224192701_pIwns KR003M 2026-02-25T14:25:07.036Z 2026-03-04T14:19:19.081Z
9389306 9389306 20260224182553_8D62Y KR003M 2026-02-25T14:24:39.242Z 2026-03-04T14:19:15.081Z
9389283 9389283 20260224181902_nASEJ KR003M 2026-02-25T14:24:36.231Z 2026-03-04T14:19:14.791Z
9381179 9381179 20260222211045_Ulh33 KR003M 2026-02-24T14:24:21.097Z 2026-02-24T14:24:21.097Z
9380981 9380981 20260222204043_5hwr4 KR003M 2026-02-24T14:23:59.560Z 2026-02-24T14:23:59.560Z
9380974 9380974 20260222204021_3qjsg KR003M 2026-02-24T14:23:59.387Z 2026-02-24T14:23:59.387Z
9380855 9380855 20260222202551_KE2kq KR003M 2026-02-24T14:23:49.975Z 2026-02-24T14:23:49.975Z
9380669 9380669 20260222200542_wK17x KR003M 2026-02-24T14:23:33.430Z 2026-02-24T14:23:33.430Z
9380191 9380191 20260222190455_A24wS KR003M 2026-02-24T14:22:45.875Z 2026-02-24T14:22:45.875Z
9379948 9379948 20260222183303_s6lqf KR003M 2026-02-24T14:22:27.495Z 2026-02-24T14:22:27.495Z
9379889 9379889 20260222182321_8KRIZ KR003M 2026-02-24T14:22:18.674Z 2026-02-24T14:22:18.674Z
9379354 9379354 20260222164504_VK8MK KR003M 2026-02-24T14:21:16.419Z 2026-02-24T14:21:16.419Z
9379308 9379308 20260222163741_XMJH9 KR003M 2026-02-24T14:21:09.770Z 2026-02-24T14:21:09.770Z
9379193 9379193 20260222162423_sOZJp KR003M 2026-02-24T14:20:58.489Z 2026-02-24T14:20:58.489Z
9379168 9379168 20260222161934_Dyg8y KR003M 2026-02-24T14:20:54.847Z 2026-02-24T14:20:54.847Z

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