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

9,589 rows where station_code = "KR0011" 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
9607764 9607764 20260404133915_dWZQ7 KR0011 2026-04-05T12:03:55.171Z 2026-04-06T12:16:14.510Z
9607752 9607752 20260404125327_9KdbJ KR0011 2026-04-05T12:03:52.349Z 2026-04-06T12:16:14.507Z
9603842 9603842 20260402130751_yE2ns KR0011 2026-04-03T12:04:51.611Z 2026-04-06T12:22:37.158Z
9603840 9603840 20260402130454_gFqag KR0011 2026-04-03T12:04:51.096Z 2026-04-06T12:22:36.904Z
9590745 9590745 20260328110418_NP6xU KR0011 2026-03-29T12:03:12.407Z 2026-04-06T12:38:32.597Z
9583884 9583884 20260326192856_sogYg KR0011 2026-03-27T12:10:01.576Z 2026-04-04T12:41:50.255Z
9583776 9583776 20260326180026_E1E4o KR0011 2026-03-27T12:09:43.845Z 2026-04-04T12:41:38.434Z
9583709 9583709 20260326172605_0uvIK KR0011 2026-03-27T12:09:34.208Z 2026-04-04T12:41:32.600Z
9583678 9583678 20260326170820_C3646 KR0011 2026-03-27T12:09:29.259Z 2026-04-04T12:41:30.925Z
9578956 9578956 20260325165601_j3s93 KR0011 2026-03-26T12:08:59.751Z 2026-04-03T12:38:47.456Z
9578847 9578847 20260325151311_mzfW4 KR0011 2026-03-26T12:08:40.815Z 2026-04-03T12:38:35.924Z
9575018 9575018 20260323181944_w93D8 KR0011 2026-03-25T12:20:05.378Z 2026-03-31T12:28:46.640Z
9574960 9574960 20260323175153_v5RSL KR0011 2026-03-25T12:19:57.336Z 2026-03-31T12:28:45.225Z
9574807 9574807 20260323172212_B3s2X KR0011 2026-03-25T12:19:43.175Z 2026-03-31T12:28:42.437Z
9574676 9574676 20260323121137_HiDv2 KR0011 2026-03-25T12:15:00.635Z 2026-03-31T12:27:36.101Z
9570259 9570259 20260322201600_R2Ouo KR0011 2026-03-24T12:22:53.284Z 2026-03-30T12:30:38.131Z
9570250 9570250 20260322201547_IoU74 KR0011 2026-03-24T12:22:52.805Z 2026-03-30T12:30:38.074Z
9570222 9570222 20260322200249_IJ23R KR0011 2026-03-24T12:22:49.715Z 2026-03-30T12:30:37.416Z
9570207 9570207 20260322195059_dTSFE KR0011 2026-03-24T12:22:48.292Z 2026-03-30T12:30:33.598Z
9570048 9570048 20260322190117_72ikN KR0011 2026-03-24T12:22:31.172Z 2026-03-30T12:30:26.983Z
9569991 9569991 20260322184850_H1ZeT KR0011 2026-03-24T12:22:26.744Z 2026-03-30T12:30:26.039Z
9569886 9569886 20260322181642_yaJQi KR0011 2026-03-24T12:22:18.244Z 2026-03-30T12:30:24.327Z
9569859 9569859 20260322181047_mQ2Em KR0011 2026-03-24T12:22:15.758Z 2026-03-30T12:30:22.424Z
9569846 9569846 20260322175927_zFiCd KR0011 2026-03-24T12:22:14.731Z 2026-03-30T12:30:22.241Z
9569841 9569841 20260322175926_3zMnu KR0011 2026-03-24T12:22:14.368Z 2026-03-30T12:30:22.202Z
9569681 9569681 20260322165202_l4Dne KR0011 2026-03-24T12:21:47.716Z 2026-03-30T12:30:15.456Z
9569554 9569554 20260322161243_WTWCw KR0011 2026-03-24T12:21:22.376Z 2026-03-30T12:30:08.828Z
9569533 9569533 20260322160906_aMhG7 KR0011 2026-03-24T12:21:19.205Z 2026-03-30T12:30:07.677Z
9569510 9569510 20260322160014_oF19Y KR0011 2026-03-24T12:21:15.904Z 2026-03-30T12:30:06.524Z
9569376 9569376 20260322151402_jAPQx KR0011 2026-03-24T12:20:48.298Z 2026-03-30T12:29:51.436Z
9569374 9569374 20260322151325_NJ1YX KR0011 2026-03-24T12:20:47.761Z 2026-03-30T12:29:51.153Z
9569326 9569326 20260322145508_MSjQ3 KR0011 2026-03-24T12:20:34.537Z 2026-03-30T12:29:47.435Z
9569309 9569309 20260322145018_Hvw5p KR0011 2026-03-24T12:20:30.779Z 2026-03-30T12:29:46.570Z
9568904 9568904 20260322111454_grdJV KR0011 2026-03-24T12:18:54.320Z 2026-03-30T12:29:06.600Z
9568877 9568877 20260322105204_mPVMR KR0011 2026-03-24T12:18:45.880Z 2026-03-30T12:29:03.159Z
9568654 9568654 20260323170920_EFFQW KR0011 2026-03-24T12:15:28.094Z 2026-03-31T12:28:39.723Z
9568362 9568362 20260323163457_vUZHq KR0011 2026-03-24T12:14:57.520Z 2026-03-31T12:28:28.231Z
9568305 9568305 20260323163037_LJGF8 KR0011 2026-03-24T12:14:51.716Z 2026-03-31T12:28:27.164Z
9567924 9567924 20260323160043_4duuU KR0011 2026-03-24T12:14:17.816Z 2026-03-31T12:28:20.764Z
9567899 9567899 20260323155825_7tyWl KR0011 2026-03-24T12:14:16.559Z 2026-03-31T12:28:20.368Z
9567791 9567791 20260323154938_PRjhK KR0011 2026-03-24T12:14:09.015Z 2026-03-31T12:28:18.893Z
9567644 9567644 20260323153819_1MpwN KR0011 2026-03-24T12:13:54.668Z 2026-03-31T12:28:17.153Z
9565040 9565040 20260323114048_I1y3i KR0011 2026-03-24T12:09:18.203Z 2026-03-31T12:27:21.734Z
9564500 9564500 20260323104218_Enlb2 KR0011 2026-03-24T12:08:12.423Z 2026-03-31T12:27:10.237Z
9551595 9551595 20260320202735_rDfQt KR0011 2026-03-22T12:26:50.392Z 2026-03-28T12:36:58.515Z
9551466 9551466 20260320195354_6FUCq KR0011 2026-03-22T12:26:42.317Z 2026-03-28T12:36:54.599Z
9551463 9551463 20260320195331_oa0hX KR0011 2026-03-22T12:26:42.158Z 2026-03-28T12:36:54.597Z
9551456 9551456 20260320195231_rXF9U KR0011 2026-03-22T12:26:41.626Z 2026-03-28T12:36:53.655Z
9551382 9551382 20260320193956_VCTpR KR0011 2026-03-22T12:26:37.155Z 2026-03-28T12:36:49.024Z
9551314 9551314 20260320191737_yUFSB KR0011 2026-03-22T12:26:25.367Z 2026-03-28T12:36:44.056Z
9551160 9551160 20260320183935_vDG9R KR0011 2026-03-22T12:26:13.969Z 2026-03-28T12:36:40.423Z
9551143 9551143 20260320183521_owaUh KR0011 2026-03-22T12:26:13.053Z 2026-03-28T12:36:40.308Z
9551114 9551114 20260320182718_YJUfb KR0011 2026-03-22T12:26:11.147Z 2026-03-28T12:36:40.078Z
9551089 9551089 20260320181621_guy9n KR0011 2026-03-22T12:26:10.062Z 2026-03-28T12:36:39.878Z
9551080 9551080 20260320181120_dDbaE KR0011 2026-03-22T12:26:09.301Z 2026-03-28T12:36:39.741Z
9551026 9551026 20260320174715_M79Fu KR0011 2026-03-22T12:26:05.287Z 2026-03-28T12:36:38.993Z
9550879 9550879 20260320171954_fS2A2 KR0011 2026-03-22T12:25:49.080Z 2026-03-28T12:36:37.206Z
9550275 9550275 20260320162639_LFhfO KR0011 2026-03-22T12:25:05.908Z 2026-03-28T12:36:29.079Z
9550076 9550076 20260320160642_rDx7n KR0011 2026-03-22T12:24:54.154Z 2026-03-28T12:36:26.902Z
9549936 9549936 20260320155532_rlm61 KR0011 2026-03-22T12:24:38.046Z 2026-03-28T12:36:24.257Z
9549726 9549726 20260320153152_q8ZGF KR0011 2026-03-22T12:24:25.050Z 2026-03-28T12:36:17.222Z
9549342 9549342 20260320144853_G3LQU KR0011 2026-03-22T12:23:53.264Z 2026-03-28T12:36:01.596Z
9548878 9548878 20260321154353_EkJRY KR0011 2026-03-22T12:16:07.070Z 2026-03-29T12:20:29.852Z
9548870 9548870 20260321154246_wciIk KR0011 2026-03-22T12:16:06.260Z 2026-03-29T12:20:29.655Z
9548556 9548556 20260321151408_PxvYr KR0011 2026-03-22T12:15:34.530Z 2026-03-29T12:20:27.187Z
9548185 9548185 20260321143926_XAxz0 KR0011 2026-03-22T12:15:01.089Z 2026-03-29T12:20:24.551Z
9547770 9547770 20260321135723_bf02R KR0011 2026-03-22T12:14:18.042Z 2026-03-29T12:20:21.160Z
9547661 9547661 20260321134831_3Un1r KR0011 2026-03-22T12:14:03.691Z 2026-03-22T12:27:38.513Z
9547363 9547363 20260321132056_LZtUK KR0011 2026-03-22T12:13:30.850Z 2026-03-29T12:20:09.024Z
9547211 9547211 20260321130540_ClYLx KR0011 2026-03-22T12:13:12.617Z 2026-03-29T12:20:07.914Z
9547103 9547103 20260321125227_MtY8L KR0011 2026-03-22T12:13:00.471Z 2026-03-29T12:20:06.786Z
9546734 9546734 20260321122249_QfjPa KR0011 2026-03-22T12:12:18.322Z 2026-03-29T12:20:03.644Z
9546298 9546298 20260321115014_s07wU KR0011 2026-03-22T12:11:27.086Z 2026-03-29T12:19:49.187Z
9541330 9541330 20260319201734_xlVpo KR0011 2026-03-21T12:28:50.098Z 2026-03-27T12:42:36.563Z
9541186 9541186 20260319195417_Gd5Vl KR0011 2026-03-21T12:28:42.220Z 2026-03-27T12:42:35.099Z
9541148 9541148 20260319194201_DmKfS KR0011 2026-03-21T12:28:39.529Z 2026-03-27T12:42:34.574Z
9541084 9541084 20260319192135_2w2tw KR0011 2026-03-21T12:28:29.338Z 2026-03-27T12:42:33.835Z
9540967 9540967 20260319184434_OdeYy KR0011 2026-03-21T12:28:20.065Z 2026-03-27T12:42:32.514Z
9540910 9540910 20260319183142_IAZKi KR0011 2026-03-21T12:28:16.812Z 2026-03-27T12:42:32.033Z
9540902 9540902 20260319183033_GIkrf KR0011 2026-03-21T12:28:16.545Z 2026-03-27T12:42:32.020Z
9540877 9540877 20260319182521_k0933 KR0011 2026-03-21T12:28:15.111Z 2026-03-27T12:42:31.793Z
9540872 9540872 20260319182328_fDOHs KR0011 2026-03-21T12:28:14.982Z 2026-03-27T12:42:31.757Z
9540832 9540832 20260319181407_qT5iR KR0011 2026-03-21T12:28:11.455Z 2026-03-27T12:42:31.271Z
9540824 9540824 20260319181340_680z9 KR0011 2026-03-21T12:28:11.124Z 2026-03-27T12:42:31.261Z
9540807 9540807 20260319180814_zTG3o KR0011 2026-03-21T12:28:10.281Z 2026-03-27T12:42:31.143Z
9540790 9540790 20260319180009_JvXGj KR0011 2026-03-21T12:28:09.400Z 2026-03-27T12:42:31.009Z
9540717 9540717 20260319173145_HydpX KR0011 2026-03-21T12:27:57.182Z 2026-03-27T12:42:30.228Z
9540714 9540714 20260319173010_MIMHK KR0011 2026-03-21T12:27:56.919Z 2026-03-27T12:42:30.188Z
9540651 9540651 20260319171010_IOKpy KR0011 2026-03-21T12:27:47.035Z 2026-03-27T12:42:28.849Z
9540601 9540601 20260319165411_1KzKa KR0011 2026-03-21T12:27:36.703Z 2026-03-27T12:42:27.070Z
9540453 9540453 20260319154441_dXmLx KR0011 2026-03-21T12:27:01.293Z 2026-03-27T12:42:22.165Z
9540377 9540377 20260319152820_QlaMj KR0011 2026-03-21T12:26:55.789Z 2026-03-27T12:42:20.808Z
9540321 9540321 20260319151119_6Tq3A KR0011 2026-03-21T12:26:49.883Z 2026-03-27T12:42:19.461Z
9540259 9540259 20260319145131_Ursm2 KR0011 2026-03-21T12:26:34.818Z 2026-03-27T12:42:05.161Z
9539967 9539967 20260319115604_HHqOn KR0011 2026-03-21T12:25:39.621Z 2026-03-27T12:41:52.659Z
9539957 9539957 20260319113804_t0xWR KR0011 2026-03-21T12:25:32.264Z 2026-03-27T12:41:50.851Z
9539937 9539937 20260319110546_152rx KR0011 2026-03-21T12:25:19.706Z 2026-03-27T12:41:47.210Z
9539919 9539919 20260319110344_fI2yx KR0011 2026-03-21T12:25:18.149Z 2026-03-27T12:41:46.822Z
9539903 9539903 20260319104054_QggDx KR0011 2026-03-21T12:25:08.113Z 2026-03-27T12:41:44.866Z
9538397 9538397 20260320125919_VN8wT KR0011 2026-03-21T12:17:37.436Z 2026-03-21T12:30:06.462Z

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