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

8,619 rows where station_code = "US0020" 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
8683486 8683486 20251202070131_Kgq2V US0020 2025-12-04T14:27:05.936Z 2025-12-05T14:29:22.617Z
8677202 8677202 20251203071024_XbV49 US0020 2025-12-04T14:00:21.374Z 2025-12-05T14:14:34.763Z
8677119 8677119 20251202065745_tmCUi US0020 2025-12-03T14:26:19.573Z 2025-12-05T14:29:21.762Z
8676777 8676777 20251202062416_GNjb3 US0020 2025-12-03T14:25:34.632Z 2025-12-05T14:29:13.256Z
8676352 8676352 20251202054838_aNDD5 US0020 2025-12-03T14:25:08.971Z 2025-12-05T14:28:55.102Z
8676058 8676058 20251202053427_3rYCo US0020 2025-12-03T14:24:38.689Z 2025-12-05T14:28:47.272Z
8675245 8675245 20251202042312_mDlTd US0020 2025-12-03T14:23:24.035Z 2025-12-05T14:28:17.976Z
8675194 8675194 20251202041751_rptKz US0020 2025-12-03T14:23:17.373Z 2025-12-05T14:28:16.681Z
8675167 8675167 20251202041107_fu2Nm US0020 2025-12-03T14:23:14.776Z 2025-12-05T14:28:14.135Z
8675088 8675088 20251202040013_3kDvt US0020 2025-12-03T14:23:01.535Z 2025-12-05T14:28:10.814Z
8674991 8674991 20251202034555_c9I8U US0020 2025-12-03T14:22:48.811Z 2025-12-05T14:28:08.595Z
8674912 8674912 20251202033917_tEq3Q US0020 2025-12-03T14:22:42.818Z 2025-12-05T14:28:06.483Z
8674777 8674777 20251202032451_EkYNF US0020 2025-12-03T14:22:21.255Z 2025-12-05T14:28:02.823Z
8674530 8674530 20251202024219_D7j8A US0020 2025-12-03T14:21:45.214Z 2025-12-05T14:27:53.992Z
8671865 8671865 20251201130941_BeqkK US0020 2025-12-03T14:14:02.087Z 2025-12-05T14:24:57.441Z
8671687 8671687 20251201124825_0R4Fz US0020 2025-12-03T14:13:20.084Z 2025-12-05T14:24:40.336Z
8671520 8671520 20251201123019_tF8m3 US0020 2025-12-03T14:12:54.570Z 2025-12-05T14:24:32.895Z
8671486 8671486 20251201122341_0x8aK US0020 2025-12-03T14:12:44.025Z 2025-12-05T14:24:31.143Z
8671321 8671321 20251201120123_9HVnb US0020 2025-12-03T14:12:09.649Z 2025-12-05T14:24:24.038Z
8671249 8671249 20251201114616_J1xGH US0020 2025-12-03T14:11:55.140Z 2025-12-05T14:24:19.702Z
8671206 8671206 20251201113402_l4XZF US0020 2025-12-03T14:11:46.096Z 2025-12-05T14:24:17.864Z
8670997 8670997 20251201110022_sLGmW US0020 2025-12-03T14:11:02.091Z 2025-12-05T14:23:58.930Z
8670969 8670969 20251201105554_unqXI US0020 2025-12-03T14:10:57.202Z 2025-12-05T14:23:58.100Z
8670960 8670960 20251201105533_6Ozmw US0020 2025-12-03T14:10:51.574Z 2025-12-05T14:23:57.807Z
8670720 8670720 20251201100408_n9nFK US0020 2025-12-03T14:09:55.685Z 2025-12-05T14:23:46.892Z
8670716 8670716 20251201100349_sR25c US0020 2025-12-03T14:09:55.324Z 2025-12-05T14:23:46.677Z
8670711 8670711 20251201100334_q9f8Q US0020 2025-12-03T14:09:54.883Z 2025-12-05T14:23:46.567Z
8670639 8670639 20251201095035_tfm2t US0020 2025-12-03T14:09:37.545Z 2025-12-05T14:23:43.098Z
8668372 8668372 20251130074625_pgFSz US0020 2025-12-02T14:42:21.622Z 2025-12-05T14:46:07.574Z
8668359 8668359 20251130074126_hiIHt US0020 2025-12-02T14:42:20.762Z 2025-12-05T14:46:07.307Z
8668302 8668302 20251130071358_xZGm5 US0020 2025-12-02T14:42:17.763Z 2025-12-05T14:46:06.289Z
8668164 8668164 20251130062707_vwBii US0020 2025-12-02T14:42:07.311Z 2025-12-05T14:46:00.141Z
8668131 8668131 20251130061406_Y1V21 US0020 2025-12-02T14:42:03.801Z 2025-12-05T14:45:49.868Z
8668096 8668096 20251130060135_MyYto US0020 2025-12-02T14:42:00.767Z 2025-12-05T14:45:35.828Z
8667986 8667986 20251130053605_DAjDx US0020 2025-12-02T14:41:27.172Z 2025-12-05T14:45:27.398Z
8667871 8667871 20251130044625_moo8o US0020 2025-12-02T14:40:53.161Z 2025-12-05T14:44:51.038Z
8667866 8667866 20251130044529_0BIdt US0020 2025-12-02T14:40:49.502Z 2025-12-05T14:44:48.570Z
8667746 8667746 20251130034548_OQuvJ US0020 2025-12-02T14:40:14.823Z 2025-12-05T14:44:29.037Z
8667727 8667727 20251130033331_YuFD1 US0020 2025-12-02T14:40:08.842Z 2025-12-05T14:44:24.303Z
8667500 8667500 20251130015638_yEy02 US0020 2025-12-02T14:38:43.412Z 2025-12-05T14:43:03.789Z
8666884 8666884 20251201063547_bQOpr US0020 2025-12-02T14:30:39.447Z 2025-12-05T14:37:03.070Z
8666837 8666837 20251201041753_lZMAD US0020 2025-12-02T14:28:15.784Z 2025-12-05T14:36:26.256Z
8666822 8666822 20251201040415_Texue US0020 2025-12-02T14:28:04.939Z 2025-12-05T14:36:22.222Z
8666788 8666788 20251201030057_BnJcX US0020 2025-12-02T14:27:51.369Z 2025-12-05T14:35:50.499Z
8660356 8660356 20251130123809_uDIko US0020 2025-12-02T14:07:30.834Z 2025-12-05T14:31:06.324Z
8660058 8660058 20251130114955_Z0UUL US0020 2025-12-02T14:06:23.111Z 2025-12-05T14:30:42.295Z
8659992 8659992 20251130113818_JvxX9 US0020 2025-12-02T14:06:01.787Z 2025-12-05T14:30:39.936Z
8659828 8659828 20251130112058_2RxGv US0020 2025-12-02T14:05:26.530Z 2025-12-05T14:30:33.013Z
8659676 8659676 20251130110407_zXhPz US0020 2025-12-02T14:04:50.599Z 2025-12-05T14:30:27.479Z
8659418 8659418 20251130102529_bliJb US0020 2025-12-02T14:03:51.092Z 2025-12-05T14:30:05.371Z
8659188 8659188 20251130094245_BpNkn US0020 2025-12-02T14:02:52.570Z 2025-12-05T14:29:56.220Z
8658905 8658905 20251130085452_zEk3f US0020 2025-12-02T14:01:34.414Z 2025-12-05T14:29:34.865Z
8648468 8648468 20251129080419_wCdTB US0020 2025-11-30T14:30:14.435Z 2025-12-05T14:53:29.690Z
8648415 8648415 20251129074633_OnJlU US0020 2025-11-30T14:30:09.084Z 2025-12-05T14:53:21.886Z
8648409 8648409 20251129074454_5tn79 US0020 2025-11-30T14:30:08.509Z 2025-12-05T14:53:21.509Z
8648236 8648236 20251129070926_piCKF US0020 2025-11-30T14:29:58.920Z 2025-12-05T14:53:03.170Z
8647800 8647800 20251129053501_GB0iZ US0020 2025-11-30T14:28:57.379Z 2025-12-05T14:52:48.076Z
8647677 8647677 20251129050658_hXbii US0020 2025-11-30T14:28:44.258Z 2025-12-05T14:52:45.342Z
8647211 8647211 20251129040550_R0Vn3 US0020 2025-11-30T14:27:50.863Z 2025-12-05T14:52:35.364Z
8646826 8646826 20251129030010_ss3Bx US0020 2025-11-30T14:27:00.622Z 2025-12-05T14:51:54.997Z
8646316 8646316 20251129014436_DgeXR US0020 2025-11-30T14:25:49.972Z 2025-12-05T14:51:39.253Z
8646241 8646241 20251129013058_QunoB US0020 2025-11-30T14:25:43.607Z 2025-12-05T14:51:37.047Z
8640243 8640243 20251129131339_K9um6 US0020 2025-11-30T14:07:37.368Z 2025-12-05T14:39:06.488Z
8639868 8639868 20251129121815_JCVoT US0020 2025-11-30T14:06:19.324Z 2025-12-05T14:38:34.839Z
8639504 8639504 20251129111342_IBzN4 US0020 2025-11-30T14:05:10.224Z 2025-12-05T14:38:23.796Z
8639384 8639384 20251129110040_dVoUy US0020 2025-11-30T14:04:45.114Z 2025-12-05T14:38:20.162Z
8639107 8639107 20251129102754_wzkgX US0020 2025-11-30T14:03:43.333Z 2025-12-01T14:35:19.674Z
8638832 8638832 20251129095147_VpNJK US0020 2025-11-30T14:02:33.474Z 2025-12-05T14:37:44.927Z
8638738 8638738 20251129093532_JZOQJ US0020 2025-11-30T14:02:02.168Z 2025-12-05T14:37:41.552Z
8638725 8638725 20251129093300_EtBN7 US0020 2025-11-30T14:01:59.866Z 2025-12-05T14:37:41.043Z
8638718 8638718 20251129093251_GwIv2 US0020 2025-11-30T14:01:58.703Z 2025-12-05T14:37:40.844Z
8638702 8638702 20251129092651_Q40AK US0020 2025-11-30T14:01:55.985Z 2025-12-05T14:37:40.137Z
8638693 8638693 20251129092513_3sCEz US0020 2025-11-30T14:01:54.418Z 2025-12-05T14:37:39.835Z
8638584 8638584 20251129091041_21zaq US0020 2025-11-30T14:01:32.612Z 2025-12-05T14:37:36.653Z
8637857 8637857 20251128065723_Z30pt US0020 2025-11-29T14:27:56.493Z 2025-12-05T15:00:32.818Z
8637834 8637834 20251128064922_I0cvu US0020 2025-11-29T14:27:54.663Z 2025-12-05T15:00:30.993Z
8637716 8637716 20251128062248_4EubV US0020 2025-11-29T14:27:45.734Z 2025-12-05T15:00:19.980Z
8636650 8636650 20251128041503_MT0N8 US0020 2025-11-29T14:25:52.841Z 2025-12-05T14:59:27.632Z
8636367 8636367 20251128033848_mfcOb US0020 2025-11-29T14:25:25.428Z 2025-12-05T14:59:23.265Z
8628728 8628728 20251128130614_aY72k US0020 2025-11-29T14:07:00.860Z 2025-12-05T14:47:49.297Z
8628724 8628724 20251128130605_TIPMd US0020 2025-11-29T14:07:00.490Z 2025-12-05T14:47:49.111Z
8628569 8628569 20251128125749_HyFFK US0020 2025-11-29T14:06:39.980Z 2025-12-05T14:47:46.052Z
8627821 8627821 20251128113943_90wKv US0020 2025-11-29T14:04:34.472Z 2025-12-05T14:47:06.674Z
8626856 8626856 20251128094750_VS92u US0020 2025-11-29T14:01:40.583Z 2025-12-05T14:46:22.394Z
8626815 8626815 20251128094050_Gtlmp US0020 2025-11-29T14:01:34.347Z 2025-12-05T14:46:21.293Z
8626594 8626594 20251128091038_v6tSb US0020 2025-11-29T14:00:59.634Z 2025-12-05T14:46:14.538Z
8626576 8626576 20251128090445_YZGpV US0020 2025-11-29T14:00:50.968Z 2025-12-05T14:46:13.975Z
8625192 8625192 20251127083024_7vogk US0020 2025-11-28T14:26:24.491Z 2025-12-05T15:05:47.113Z
8625179 8625179 20251127082731_dvg4i US0020 2025-11-28T14:26:23.555Z 2025-12-05T15:05:46.814Z
8625124 8625124 20251127080932_3HetE US0020 2025-11-28T14:26:16.853Z 2025-12-05T15:05:42.611Z
8624754 8624754 20251127062901_x0kOw US0020 2025-11-28T14:25:25.791Z 2025-12-05T15:05:26.983Z
8624751 8624751 20251127062524_XEQNq US0020 2025-11-28T14:25:25.274Z 2025-12-05T15:05:26.224Z
8624734 8624734 20251127062230_Cftdp US0020 2025-11-28T14:25:24.777Z 2025-12-05T15:05:25.920Z
8624641 8624641 20251127054404_FT6H0 US0020 2025-11-28T14:25:14.981Z 2025-12-05T15:05:19.460Z
8624519 8624519 20251127051842_dB7dN US0020 2025-11-28T14:25:06.195Z 2025-12-05T15:05:11.301Z
8624515 8624515 20251127051625_z8rGP US0020 2025-11-28T14:25:05.986Z 2025-12-05T15:05:11.246Z
8623710 8623710 20251127014935_U0RBI US0020 2025-11-28T14:22:27.839Z 2025-12-05T15:04:11.250Z
8623632 8623632 20251127013150_lBK7k US0020 2025-11-28T14:22:18.245Z 2025-12-05T15:04:05.707Z
8623596 8623596 20251127012216_eph0y US0020 2025-11-28T14:22:14.401Z 2025-12-05T15:04:04.236Z
8618718 8618718 20251127131534_Pw75i US0020 2025-11-28T14:05:34.412Z 2025-12-05T14:54:23.472Z

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