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,736 rows where station_code = "KR001G" 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
9583905 9583905 20260326200230_dKjPu KR001G 2026-03-27T12:10:05.994Z 2026-04-04T12:41:52.304Z
9583891 9583891 20260326195800_XfLvs KR001G 2026-03-27T12:10:03.135Z 2026-04-04T12:41:51.600Z
9583877 9583877 20260326192353_yaRi0 KR001G 2026-03-27T12:09:59.747Z 2026-04-04T12:41:49.530Z
9583811 9583811 20260326184035_oQzFN KR001G 2026-03-27T12:09:51.009Z 2026-04-04T12:41:39.912Z
9579075 9579075 20260325192634_pg98B KR001G 2026-03-26T12:09:16.599Z 2026-04-03T12:39:11.525Z
9579072 9579072 20260325191644_nDptO KR001G 2026-03-26T12:09:16.177Z 2026-04-03T12:39:10.753Z
9578999 9578999 20260325171838_Zc2gp KR001G 2026-03-26T12:09:06.601Z 2026-04-03T12:38:49.361Z
9578971 9578971 20260325170320_qL4Kk KR001G 2026-03-26T12:09:02.848Z 2026-04-03T12:38:48.385Z
9575241 9575241 20260323195310_v65lc KR001G 2026-03-25T12:20:40.309Z 2026-03-31T12:28:52.118Z
9574721 9574721 20260323154857_7tLav KR001G 2026-03-25T12:17:49.334Z 2026-03-31T12:28:18.772Z
9570303 9570303 20260322202703_c0Ak8 KR001G 2026-03-24T12:22:57.897Z 2026-03-30T12:30:39.384Z
9570233 9570233 20260322200730_CvXx9 KR001G 2026-03-24T12:22:50.924Z 2026-03-30T12:30:37.585Z
9569504 9569504 20260322155912_5k3sR KR001G 2026-03-24T12:21:15.501Z 2026-03-30T12:30:06.461Z
9569457 9569457 20260322154150_aG3mr KR001G 2026-03-24T12:21:02.315Z 2026-03-30T12:30:03.750Z
9551555 9551555 20260320201923_8iuqj KR001G 2026-03-22T12:26:47.759Z 2026-03-28T12:36:57.987Z
9551398 9551398 20260320194221_bQV3T KR001G 2026-03-22T12:26:38.198Z 2026-03-28T12:36:50.330Z
9551368 9551368 20260320193520_c2Twy KR001G 2026-03-22T12:26:36.174Z 2026-03-28T12:36:48.111Z
9551078 9551078 20260320180927_M3H8c KR001G 2026-03-22T12:26:09.016Z 2026-03-28T12:36:39.681Z
9551047 9551047 20260320175958_2geHH KR001G 2026-03-22T12:26:07.407Z 2026-03-28T12:36:39.353Z
9550063 9550063 20260320160437_Tfeff KR001G 2026-03-22T12:24:53.153Z 2026-03-28T12:36:26.652Z
9550060 9550060 20260320160437_jP9GY KR001G 2026-03-22T12:24:52.871Z 2026-03-28T12:36:26.615Z
9549462 9549462 20260320150046_PS4cN KR001G 2026-03-22T12:24:01.551Z 2026-03-28T12:36:04.475Z
9547907 9547907 20260321141011_vucWA KR001G 2026-03-22T12:14:29.482Z 2026-03-29T12:20:22.351Z
9540420 9540420 20260319153852_aWyHC KR001G 2026-03-21T12:26:59.178Z 2026-03-27T12:42:21.516Z
9540417 9540417 20260319153755_Xw6Q7 KR001G 2026-03-21T12:26:58.998Z 2026-03-27T12:42:21.492Z
9540216 9540216 20260319143845_dsew3 KR001G 2026-03-21T12:26:30.537Z 2026-03-27T12:42:04.130Z
9539386 9539386 20260320143840_n5TzP KR001G 2026-03-21T12:19:27.062Z 2026-03-21T12:30:06.892Z
9530205 9530205 20260318202417_MRilC KR001G 2026-03-20T12:24:12.078Z 2026-03-26T12:39:10.365Z
9529834 9529834 20260318193613_9UDGB KR001G 2026-03-20T12:23:45.328Z 2026-03-26T12:39:06.906Z
9529815 9529815 20260318193350_AL8Is KR001G 2026-03-20T12:23:44.241Z 2026-03-26T12:39:06.702Z
9529446 9529446 20260318182618_yOnmG KR001G 2026-03-20T12:23:11.013Z 2026-03-26T12:39:02.743Z
9529439 9529439 20260318182359_42o2a KR001G 2026-03-20T12:23:10.540Z 2026-03-26T12:39:02.638Z
9529250 9529250 20260318173217_XKLo6 KR001G 2026-03-20T12:22:59.858Z 2026-03-26T12:38:52.444Z
9528222 9528222 20260318155140_Q30tO KR001G 2026-03-20T12:22:00.823Z 2026-03-26T12:38:34.744Z
9473849 9473849 20260313202634_nFo1C KR001G 2026-03-14T12:16:05.136Z 2026-03-21T12:50:17.716Z
9473790 9473790 20260313192034_4oe6y KR001G 2026-03-14T12:15:54.581Z 2026-03-21T12:50:02.120Z
9473775 9473775 20260313191628_wW5Nt KR001G 2026-03-14T12:15:50.249Z 2026-03-21T12:50:01.859Z
9473712 9473712 20260313183129_Gg3Zf KR001G 2026-03-14T12:15:40.556Z 2026-03-21T12:50:00.570Z
9473558 9473558 20260313172159_3CxXq KR001G 2026-03-14T12:15:19.003Z 2026-03-21T12:49:58.643Z
9473449 9473449 20260313165953_0Gwkk KR001G 2026-03-14T12:15:05.883Z 2026-03-21T12:49:57.695Z
9473043 9473043 20260313154022_pDbos KR001G 2026-03-14T12:14:21.782Z 2026-03-21T12:49:53.642Z
9472863 9472863 20260313151650_pk2ST KR001G 2026-03-14T12:14:05.635Z 2026-03-21T12:49:52.480Z
9440474 9440474 20260307185004_Pl6qY KR001G 2026-03-08T12:13:43.122Z 2026-03-15T12:42:07.223Z
9440435 9440435 20260307180758_FrLC2 KR001G 2026-03-08T12:13:36.501Z 2026-03-15T12:42:06.017Z
9440286 9440286 20260307165913_s2AJp KR001G 2026-03-08T12:13:15.899Z 2026-03-15T12:42:04.665Z
9438663 9438663 20260307111036_a5bZh KR001G 2026-03-08T12:08:08.052Z 2026-03-15T12:41:34.273Z
9408712 9408712 20260227203421_qSj2h KR001G 2026-02-28T14:26:22.197Z 2026-03-07T14:51:05.717Z
9408566 9408566 20260227194534_FT4FV KR001G 2026-02-28T14:26:03.492Z 2026-03-07T14:50:58.612Z
9408554 9408554 20260227194055_mi5zd KR001G 2026-02-28T14:26:02.859Z 2026-03-07T14:50:58.092Z
9408508 9408508 20260227192911_1blwk KR001G 2026-02-28T14:25:58.809Z 2026-03-07T14:50:56.307Z
9380027 9380027 20260222184533_B6v1V KR001G 2026-02-24T14:22:33.447Z 2026-02-24T14:22:33.447Z
9379468 9379468 20260222171351_nzXpC KR001G 2026-02-24T14:21:35.903Z 2026-02-24T14:21:35.903Z
9378431 9378431 20260222135044_3QcVd KR001G 2026-02-24T14:18:35.901Z 2026-02-24T14:18:35.901Z
9378424 9378424 20260222134904_Fpevv KR001G 2026-02-24T14:18:34.810Z 2026-02-24T14:18:34.810Z
9371926 9371926 20260221202244_sxnsm KR001G 2026-02-23T14:25:39.308Z 2026-03-02T14:22:17.722Z
9371738 9371738 20260221192822_CtOSS KR001G 2026-02-23T14:25:07.435Z 2026-03-02T14:22:14.920Z
9371505 9371505 20260221182700_oR5i6 KR001G 2026-02-23T14:24:30.239Z 2026-03-02T14:22:11.124Z
9371379 9371379 20260221175923_quRAO KR001G 2026-02-23T14:24:08.951Z 2026-03-02T14:22:09.912Z
9371255 9371255 20260221173643_lQKss KR001G 2026-02-23T14:23:47.569Z 2026-03-02T14:22:08.265Z
9371174 9371174 20260221171424_2oIdm KR001G 2026-02-23T14:23:38.822Z 2026-03-02T14:22:07.595Z
9370995 9370995 20260221162951_owlAw KR001G 2026-02-23T14:22:51.049Z 2026-03-02T14:22:04.369Z
9370805 9370805 20260221153102_UOoa1 KR001G 2026-02-23T14:21:44.605Z 2026-03-02T14:22:00.009Z
9370595 9370595 20260221134455_BIfgt KR001G 2026-02-23T14:20:02.739Z 2026-03-02T14:21:53.232Z
9370549 9370549 20260221133211_MzuMk KR001G 2026-02-23T14:19:55.568Z 2026-03-02T14:21:52.725Z
9364205 9364205 20260220195054_Q32OA KR001G 2026-02-22T14:21:00.235Z 2026-03-01T14:22:51.853Z
9364042 9364042 20260220185231_R6fWH KR001G 2026-02-22T14:20:37.779Z 2026-03-01T14:22:50.370Z
9363840 9363840 20260220173801_51TFI KR001G 2026-02-22T14:20:09.417Z 2026-03-01T14:22:48.400Z
9363689 9363689 20260220163834_0qA7g KR001G 2026-02-22T14:19:44.694Z 2026-03-01T14:22:37.661Z
9357839 9357839 20260219202056_alm40 KR001G 2026-02-21T14:16:59.989Z 2026-02-28T14:44:43.642Z
9350895 9350895 20260217141901_tYAF4 KR001G 2026-02-20T14:02:31.745Z 2026-02-26T14:39:37.600Z
9350277 9350277 20260218201335_3XqMH KR001G 2026-02-20T14:02:00.391Z 2026-02-27T14:35:58.381Z
9349953 9349953 20260218192217_e7AkB KR001G 2026-02-20T14:01:59.600Z 2026-02-27T14:35:54.936Z
9349792 9349792 20260218190202_eAo97 KR001G 2026-02-20T14:01:59.037Z 2026-02-27T14:35:53.239Z
9349396 9349396 20260218180428_yfZOO KR001G 2026-02-20T14:01:57.627Z 2026-02-27T14:35:49.397Z
9349146 9349146 20260218172131_dOnwO KR001G 2026-02-20T14:01:56.885Z 2026-02-27T14:35:47.101Z
9349004 9349004 20260218165429_Q63FJ KR001G 2026-02-20T14:01:56.242Z 2026-02-27T14:35:45.275Z
9348671 9348671 20260218161104_3BPl8 KR001G 2026-02-20T14:01:55.161Z 2026-02-27T14:35:34.120Z
9348464 9348464 20260218154745_lZrps KR001G 2026-02-20T14:01:54.703Z 2026-02-27T14:35:28.577Z
9339070 9339070 20260217210243_sYPSK KR001G 2026-02-18T14:13:46.914Z 2026-02-26T14:40:10.037Z
9339064 9339064 20260217210117_vGKt1 KR001G 2026-02-18T14:13:45.229Z 2026-02-26T14:40:09.897Z
9339039 9339039 20260217201301_4OVVL KR001G 2026-02-18T14:13:37.261Z 2026-02-26T14:40:07.662Z
9339035 9339035 20260217200418_2c1jm KR001G 2026-02-18T14:13:35.988Z 2026-02-26T14:40:07.292Z
9339010 9339010 20260217194432_Bian8 KR001G 2026-02-18T14:13:31.686Z 2026-02-26T14:40:06.301Z
9338958 9338958 20260217185232_W9djF KR001G 2026-02-18T14:13:19.182Z 2026-02-26T14:40:04.492Z
9337994 9337994 20260217112130_wQKt4 KR001G 2026-02-18T14:09:19.288Z 2026-02-26T14:39:33.350Z
9337945 9337945 20260217104942_cOdFt KR001G 2026-02-18T14:09:08.173Z 2026-02-26T14:39:32.490Z
9333660 9333660 20260216205947_pDUWv KR001G 2026-02-17T14:16:34.482Z 2026-02-25T14:42:45.788Z
9333403 9333403 20260216193824_nKVsW KR001G 2026-02-17T14:15:54.985Z 2026-02-25T14:42:42.100Z
9333296 9333296 20260216183342_3dOvG KR001G 2026-02-17T14:15:27.911Z 2026-02-25T14:42:39.302Z
9329138 9329138 20260215162958_vs7qJ KR001G 2026-02-16T14:11:47.200Z 2026-02-24T14:42:38.385Z
9329070 9329070 20260215153801_eayRz KR001G 2026-02-16T14:11:31.064Z 2026-02-24T14:42:36.575Z
9325618 9325618 20260214192227_tSrBa KR001G 2026-02-15T14:15:46.315Z 2026-02-23T14:47:34.201Z
9325603 9325603 20260214185443_O3uBP KR001G 2026-02-15T14:15:41.430Z 2026-02-23T14:47:32.557Z
9325574 9325574 20260214173623_W4zQT KR001G 2026-02-15T14:15:30.645Z 2026-02-23T14:47:23.779Z
9325566 9325566 20260214171049_7k42T KR001G 2026-02-15T14:15:27.954Z 2026-02-23T14:47:18.650Z
9325556 9325556 20260214170003_T1i3r KR001G 2026-02-15T14:15:24.341Z 2026-02-23T14:47:16.401Z
9324799 9324799 20260214131425_Hu32W KR001G 2026-02-15T14:12:21.793Z 2026-02-23T14:47:04.392Z
9321186 9321186 20260213181503_wUBoz KR001G 2026-02-14T14:10:51.849Z 2026-02-22T14:42:23.235Z
9320989 9320989 20260213154239_KA34K KR001G 2026-02-14T14:09:43.807Z 2026-02-22T14:42:16.649Z
9318768 9318768 20260212185854_suPrW KR001G 2026-02-13T14:13:08.854Z 2026-02-21T14:37:32.633Z

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