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

>10,000 rows count all where station_code = "US001L" 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
8053828 8053828 20251003114450_F0QnE US001L 2025-10-05T12:06:58.301Z 2025-10-12T12:31:02.583Z
8053764 8053764 20251003113512_jHx22 US001L 2025-10-05T12:06:48.957Z 2025-10-12T12:30:58.968Z
8053682 8053682 20251003111418_9ppxm US001L 2025-10-05T12:06:17.733Z 2025-10-12T12:30:50.171Z
8053655 8053655 20251003110839_1XWMH US001L 2025-10-05T12:06:14.537Z 2025-10-12T12:30:47.752Z
8053618 8053618 20251003110309_FvOZl US001L 2025-10-05T12:06:09.655Z 2025-10-12T12:30:45.553Z
8053531 8053531 20251003104926_rurqS US001L 2025-10-05T12:05:48.568Z 2025-10-12T12:30:39.816Z
8053512 8053512 20251003104620_300Po US001L 2025-10-05T12:05:44.296Z 2025-10-12T12:30:38.701Z
8053275 8053275 20251003101617_3ZcFT US001L 2025-10-05T12:04:50.043Z 2025-10-12T12:30:21.838Z
8053034 8053034 20251003093533_Cy0lC US001L 2025-10-05T12:03:37.545Z 2025-10-12T12:30:06.982Z
8052838 8052838 20251003091252_YOp1r US001L 2025-10-05T12:02:51.307Z 2025-10-12T12:29:49.668Z
8052355 8052355 20251003075436_htTdy US001L 2025-10-05T12:00:33.104Z 2025-10-12T12:29:40.685Z
8052347 8052347 20251003075412_nG82b US001L 2025-10-05T12:00:32.061Z 2025-10-12T12:29:40.558Z
8051882 8051882 20251003063731_jpyzx US001L 2025-10-04T12:45:14.097Z 2025-10-11T12:42:41.859Z
8051880 8051880 20251003063642_crnN0 US001L 2025-10-04T12:45:13.792Z 2025-10-11T12:42:41.598Z
8051754 8051754 20251003055908_qOmHi US001L 2025-10-04T12:44:56.981Z 2025-10-11T12:42:28.361Z
8051740 8051740 20251003055540_U2ZKx US001L 2025-10-04T12:44:54.589Z 2025-10-11T12:42:28.063Z
8051568 8051568 20251003045920_Za2dQ US001L 2025-10-04T12:44:31.049Z 2025-10-11T12:42:24.399Z
8051475 8051475 20251003042636_3volO US001L 2025-10-04T12:44:14.600Z 2025-10-11T12:42:22.860Z
8051036 8051036 20251003024850_PS5pO US001L 2025-10-04T12:43:04.564Z 2025-10-11T12:42:08.196Z
8050907 8050907 20251003022536_K2w7N US001L 2025-10-04T12:42:52.417Z 2025-10-11T12:41:51.553Z
8046531 8046531 20251002114556_IGM59 US001L 2025-10-04T12:09:32.444Z 2025-10-11T12:38:11.031Z
8046260 8046260 20251002105328_50T65 US001L 2025-10-04T12:08:22.112Z 2025-10-11T12:38:03.474Z
8046252 8046252 20251002105316_tQXT3 US001L 2025-10-04T12:08:21.234Z 2025-10-11T12:38:03.421Z
8046225 8046225 20251002104741_1TzYh US001L 2025-10-04T12:08:15.144Z 2025-10-11T12:38:03.042Z
8046221 8046221 20251002104652_e2WUZ US001L 2025-10-04T12:08:14.156Z 2025-10-11T12:38:03.000Z
8046044 8046044 20251002102601_l3MwW US001L 2025-10-04T12:07:31.735Z 2025-10-11T12:38:00.583Z
8045894 8045894 20251002100352_VpXtk US001L 2025-10-04T12:06:52.526Z 2025-10-11T12:37:57.644Z
8045737 8045737 20251002094744_IVB5F US001L 2025-10-04T12:06:17.272Z 2025-10-11T12:37:54.757Z
8045456 8045456 20251002091823_NfOe4 US001L 2025-10-04T12:04:53.840Z 2025-10-11T12:37:50.127Z
8045254 8045254 20251002085401_zanmb US001L 2025-10-04T12:03:59.848Z 2025-10-11T12:37:44.533Z
8045183 8045183 20251002084805_2IEua US001L 2025-10-04T12:03:41.761Z 2025-10-11T12:37:38.964Z
8044755 8044755 20251002075653_bUr8P US001L 2025-10-04T12:01:30.762Z 2025-10-11T12:37:00.102Z
8044560 8044560 20251002073013_u6AKu US001L 2025-10-04T12:00:38.104Z 2025-10-11T12:36:54.253Z
8044236 8044236 20251002064901_gRDct US001L 2025-10-03T12:40:59.583Z 2025-10-10T12:42:38.914Z
8044232 8044232 20251002064849_oc43p US001L 2025-10-03T12:40:59.475Z 2025-10-10T12:42:38.880Z
8044203 8044203 20251002064229_HqlEi US001L 2025-10-03T12:40:55.114Z 2025-10-10T12:42:38.315Z
8044169 8044169 20251002063614_FMzEf US001L 2025-10-03T12:40:51.255Z 2025-10-10T12:42:37.949Z
8044089 8044089 20251002062331_uj2pE US001L 2025-10-03T12:40:43.365Z 2025-10-03T12:40:43.365Z
8043751 8043751 20251002053156_Bensd US001L 2025-10-03T12:40:19.464Z 2025-10-10T12:42:24.735Z
8037663 8037663 20251001050758_eX3jL US001L 2025-10-03T12:27:01.597Z 2025-10-09T12:39:49.460Z
8034875 8034875 20251001115452_KSLH8 US001L 2025-10-03T12:10:35.614Z 2025-10-10T12:37:27.291Z
8034822 8034822 20251001114733_IStQf US001L 2025-10-03T12:10:27.888Z 2025-10-10T12:37:24.431Z
8034685 8034685 20251001112825_o27g8 US001L 2025-10-03T12:09:57.856Z 2025-10-10T12:37:19.729Z
8033881 8033881 20251001094542_W4uu4 US001L 2025-10-03T12:06:53.646Z 2025-10-10T12:36:42.336Z
8031942 8031942 20251001054426_RIjQb US001L 2025-10-02T12:48:14.385Z 2025-10-09T12:40:03.277Z
8031841 8031841 20251001050922_5PSSY US001L 2025-10-02T12:48:06.106Z 2025-10-09T12:39:49.549Z
8030590 8030590 20251001023759_Llghk US001L 2025-10-02T12:45:49.723Z 2025-10-09T12:39:20.089Z
8030543 8030543 20251001023453_bjQba US001L 2025-10-02T12:45:47.397Z 2025-10-09T12:39:19.620Z
8022935 8022935 20250930101429_rv34E US001L 2025-10-02T12:06:52.700Z 2025-10-09T12:35:22.602Z
8022855 8022855 20250930100510_aZ5zi US001L 2025-10-02T12:06:25.147Z 2025-10-09T12:35:21.924Z
8022808 8022808 20250930095637_gcRka US001L 2025-10-02T12:06:10.913Z 2025-10-09T12:35:21.287Z
8022460 8022460 20250930085605_WjOJ1 US001L 2025-10-02T12:04:29.973Z 2025-10-09T12:35:00.597Z
8022430 8022430 20250930085313_i0PRo US001L 2025-10-02T12:04:22.331Z 2025-10-09T12:34:58.658Z
8022352 8022352 20250930083901_3eiQi US001L 2025-10-02T12:03:45.528Z 2025-10-09T12:34:55.080Z
8022272 8022272 20250930082452_ckCPL US001L 2025-10-02T12:03:19.990Z 2025-10-09T12:34:40.443Z
8022243 8022243 20250930082131_2cCfT US001L 2025-10-02T12:03:13.399Z 2025-10-09T12:34:37.649Z
8021989 8021989 20250930074229_unLbL US001L 2025-10-02T12:01:59.027Z 2025-10-09T12:34:23.811Z
8021968 8021968 20250930074033_3ywp2 US001L 2025-10-02T12:01:53.626Z 2025-10-09T12:34:21.973Z
8021811 8021811 20250930071627_nzopB US001L 2025-10-02T12:00:58.858Z 2025-10-09T12:34:14.758Z
8021801 8021801 20250930071556_nfHat US001L 2025-10-02T12:00:54.851Z 2025-10-09T12:34:13.277Z
8021478 8021478 20250930060613_5HGnV US001L 2025-10-01T12:48:39.937Z 2025-10-08T12:44:15.589Z
8021472 8021472 20250930060334_84Hvg US001L 2025-10-01T12:48:39.536Z 2025-10-08T12:44:15.490Z
8021046 8021046 20250930043947_konpa US001L 2025-10-01T12:47:51.667Z 2025-10-08T12:44:03.876Z
8020421 8020421 20250930033805_TBuq5 US001L 2025-10-01T12:46:46.914Z 2025-10-08T12:43:51.710Z
8020308 8020308 20250930032637_ghVwn US001L 2025-10-01T12:46:38.929Z 2025-10-08T12:43:49.047Z
8020194 8020194 20250930031636_9Ghsy US001L 2025-10-01T12:46:34.700Z 2025-10-08T12:43:45.989Z
8019815 8019815 20250930024038_OFIQB US001L 2025-10-01T12:46:05.803Z 2025-10-08T12:43:34.083Z
8019430 8019430 20250930020210_2NqrH US001L 2025-10-01T12:44:59.983Z 2025-10-08T12:43:21.534Z
8012097 8012097 20250929101705_r1Z3c US001L 2025-10-01T12:09:27.598Z 2025-10-08T12:41:44.650Z
8011664 8011664 20250929053802_lgPt0 US001L 2025-09-30T12:34:32.546Z 2025-10-07T13:01:31.566Z
8011510 8011510 20250929050036_jvkd0 US001L 2025-09-30T12:33:50.579Z 2025-10-07T13:01:30.134Z
8011138 8011138 20250929043249_RLQww US001L 2025-09-30T12:33:34.152Z 2025-10-07T13:01:26.906Z
8011107 8011107 20250929042930_12L9W US001L 2025-09-30T12:33:32.525Z 2025-10-07T13:01:26.833Z
7998424 7998424 20250929075100_U5Kmf US001L 2025-09-30T12:03:26.752Z 2025-10-08T12:41:11.692Z
7991395 7991395 20250927114428_MzyNR US001L 2025-09-29T12:11:50.118Z 2025-10-05T13:05:16.172Z
7991128 7991128 20250927110331_QudFn US001L 2025-09-29T12:11:03.269Z 2025-10-05T13:05:01.938Z
7990339 7990339 20250928075855_02OeJ US001L 2025-09-29T12:01:25.030Z 2025-10-07T12:59:22.608Z
7989700 7989700 20250926040730_5m93D US001L 2025-09-28T12:36:50.963Z 2025-10-04T13:07:23.900Z
7988990 7988990 20250926032641_L2M72 US001L 2025-09-28T12:36:40.277Z 2025-10-04T13:07:21.143Z
7988177 7988177 20250926024418_ZNzcs US001L 2025-09-28T12:36:07.598Z 2025-10-04T13:07:16.363Z
7987276 7987276 20250926015430_ikudG US001L 2025-09-28T12:35:11.369Z 2025-10-04T13:07:10.749Z
7985998 7985998 20250927044416_NYdgv US001L 2025-09-28T12:27:31.182Z 2025-10-05T13:11:23.286Z
7985569 7985569 20250927033625_J3AYA US001L 2025-09-28T12:26:37.359Z 2025-10-05T13:11:17.150Z
7985552 7985552 20250927033547_1KY6u US001L 2025-09-28T12:26:35.865Z 2025-10-05T13:11:17.019Z
7978728 7978728 20250926115056_r9IsU US001L 2025-09-28T12:12:29.847Z 2025-10-05T13:09:05.553Z
7978453 7978453 20250926112051_z0xR7 US001L 2025-09-28T12:11:50.060Z 2025-10-05T13:09:00.419Z
7978337 7978337 20250926110151_6qUog US001L 2025-09-28T12:11:33.910Z 2025-10-05T13:08:58.520Z
7978230 7978230 20250926104609_nYDjV US001L 2025-09-28T12:11:14.328Z 2025-10-05T13:08:54.933Z
7978118 7978118 20250926102951_eItht US001L 2025-09-28T12:10:56.711Z 2025-10-05T13:08:50.911Z
7978054 7978054 20250926101743_1mbqP US001L 2025-09-28T12:10:36.183Z 2025-10-05T13:08:50.085Z
7977999 7977999 20250926100922_BGX6I US001L 2025-09-28T12:10:28.621Z 2025-10-05T13:08:48.825Z
7977968 7977968 20250926100055_fwjz3 US001L 2025-09-28T12:10:24.513Z 2025-10-05T13:08:47.669Z
7977958 7977958 20250926095900_7dDt3 US001L 2025-09-28T12:10:23.088Z 2025-10-05T13:08:47.469Z
7977684 7977684 20250926090451_aCAGv US001L 2025-09-28T12:09:30.362Z 2025-10-05T13:08:37.479Z
7977505 7977505 20250926082411_yz4mJ US001L 2025-09-28T12:09:00.617Z 2025-10-05T13:08:30.336Z
7977496 7977496 20250926082213_Ag3ev US001L 2025-09-28T12:08:53.069Z 2025-10-05T13:08:30.260Z
7977283 7977283 20250926073433_3byiI US001L 2025-09-28T12:08:11.909Z 2025-10-05T13:08:24.562Z
7977054 7977054 20250926055114_H3nhV US001L 2025-09-28T12:07:12.483Z 2025-10-05T13:08:19.163Z
7977042 7977042 20250926054111_gGm28 US001L 2025-09-28T12:07:10.338Z 2025-10-05T13:08:18.554Z
7976927 7976927 20250926045402_fbvx8 US001L 2025-09-28T12:06:40.062Z 2025-10-05T13:08:14.964Z

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