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,305 rows where station_code = "US005A" 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
8687204 8687204 20251204054551_Ak3F3 US005A 2025-12-05T14:14:23.734Z 2025-12-05T14:14:35.651Z
8687137 8687137 20251204051619_Opngv US005A 2025-12-05T14:14:02.688Z 2025-12-05T14:14:35.631Z
8684558 8684558 20251204131312_rJAF6 US005A 2025-12-05T14:03:44.967Z 2025-12-05T14:03:44.967Z
8684425 8684425 20251204123410_Z3hJp US005A 2025-12-05T14:03:09.179Z 2025-12-05T14:03:09.179Z
8684378 8684378 20251204122314_j7tV2 US005A 2025-12-05T14:02:51.829Z 2025-12-05T14:02:51.829Z
8684344 8684344 20251204121054_VfkR6 US005A 2025-12-05T14:02:46.388Z 2025-12-05T14:02:46.388Z
8684300 8684300 20251204120004_7zg8D US005A 2025-12-05T14:02:39.995Z 2025-12-05T14:02:39.995Z
8684281 8684281 20251204115503_kpnog US005A 2025-12-05T14:02:36.489Z 2025-12-05T14:02:36.489Z
8684260 8684260 20251204114921_1AjcC US005A 2025-12-05T14:02:24.258Z 2025-12-05T14:02:24.258Z
8684221 8684221 20251204113121_uUkbo US005A 2025-12-05T14:02:12.531Z 2025-12-05T14:02:12.531Z
8684043 8684043 20251204102734_tV8UN US005A 2025-12-05T14:01:37.236Z 2025-12-05T14:01:37.236Z
8684036 8684036 20251204102449_mbnrU US005A 2025-12-05T14:01:35.927Z 2025-12-05T14:01:35.927Z
8684018 8684018 20251204100859_zq4fW US005A 2025-12-05T14:01:33.491Z 2025-12-05T14:01:33.491Z
8683924 8683924 20251204092429_5CHkk US005A 2025-12-05T14:01:05.365Z 2025-12-05T14:01:05.365Z
8683898 8683898 20251204091837_I3D2l US005A 2025-12-05T14:01:01.350Z 2025-12-05T14:01:01.350Z
8683881 8683881 20251204091207_qXi0y US005A 2025-12-05T14:00:59.526Z 2025-12-05T14:00:59.526Z
8683763 8683763 20251204075020_ARYAx US005A 2025-12-05T14:00:29.878Z 2025-12-05T14:00:29.878Z
8683762 8683762 20251204074938_P9TXz US005A 2025-12-05T14:00:29.315Z 2025-12-05T14:00:29.315Z
8683759 8683759 20251204074711_MyOcP US005A 2025-12-05T14:00:28.676Z 2025-12-05T14:00:28.676Z
8683749 8683749 20251204074030_93PBw US005A 2025-12-05T14:00:27.347Z 2025-12-05T14:00:27.347Z
8683184 8683184 20251203063741_2nYZC US005A 2025-12-04T14:18:52.394Z 2025-12-05T14:23:10.534Z
8683155 8683155 20251203063340_hAg8H US005A 2025-12-04T14:18:39.476Z 2025-12-05T14:23:09.292Z
8682465 8682465 20251203053811_eAB1r US005A 2025-12-04T14:17:15.542Z 2025-12-05T14:22:39.431Z
8680998 8680998 20251203021130_ReuDv US005A 2025-12-04T14:13:31.900Z 2025-12-05T14:21:10.488Z
8680832 8680832 20251203012700_6Nf2U US005A 2025-12-04T14:13:01.443Z 2025-12-05T14:21:02.780Z
8677347 8677347 20251203090536_OXxXm US005A 2025-12-04T14:00:51.907Z 2025-12-05T14:14:34.809Z
8677335 8677335 20251203085508_EeqpS US005A 2025-12-04T14:00:49.467Z 2025-12-05T14:14:34.805Z
8677259 8677259 20251203080344_GGqmN US005A 2025-12-04T14:00:31.112Z 2025-12-05T14:14:34.779Z
8677217 8677217 20251203072233_KuMds US005A 2025-12-04T14:00:23.558Z 2025-12-05T14:14:34.767Z
8676996 8676996 20251202063659_Zy542 US005A 2025-12-03T14:25:59.838Z 2025-12-05T14:29:17.596Z
8676607 8676607 20251202060719_l120E US005A 2025-12-03T14:25:21.716Z 2025-12-05T14:29:08.855Z
8676297 8676297 20251202054443_ELsuP US005A 2025-12-03T14:24:58.122Z 2025-12-05T14:28:53.980Z
8675878 8675878 20251202052034_3lbS6 US005A 2025-12-03T14:24:28.405Z 2025-12-05T14:28:43.317Z
8675089 8675089 20251202040013_3kDvt US005A 2025-12-03T14:23:01.535Z 2025-12-05T14:28:10.814Z
8674878 8674878 20251202033641_ORwe8 US005A 2025-12-03T14:22:40.101Z 2025-12-05T14:28:05.740Z
8674456 8674456 20251202022817_jeqH8 US005A 2025-12-03T14:21:40.074Z 2025-12-05T14:27:42.241Z
8671521 8671521 20251201123019_tF8m3 US005A 2025-12-03T14:12:54.570Z 2025-12-05T14:24:32.895Z
8671378 8671378 20251201120953_lbv3D US005A 2025-12-03T14:12:17.886Z 2025-12-05T14:24:26.199Z
8671214 8671214 20251201113715_BwWAA US005A 2025-12-03T14:11:47.581Z 2025-12-05T14:24:18.258Z
8671207 8671207 20251201113402_l4XZF US005A 2025-12-03T14:11:46.096Z 2025-12-05T14:24:17.864Z
8671007 8671007 20251201110116_5vbrg US005A 2025-12-03T14:11:03.033Z 2025-12-05T14:23:59.277Z
8671002 8671002 20251201110113_trUkS US005A 2025-12-03T14:11:02.654Z 2025-12-05T14:23:59.114Z
8670970 8670970 20251201105554_unqXI US005A 2025-12-03T14:10:57.202Z 2025-12-05T14:23:58.100Z
8670945 8670945 20251201105128_kWfDu US005A 2025-12-03T14:10:47.867Z 2025-12-05T14:23:56.923Z
8670892 8670892 20251201103949_YSgsT US005A 2025-12-03T14:10:38.885Z 2025-12-05T14:23:54.721Z
8670857 8670857 20251201103400_uqRvK US005A 2025-12-03T14:10:34.488Z 2025-12-05T14:23:53.654Z
8670096 8670096 20251202130836_I2Jib US005A 2025-12-03T14:06:54.373Z 2025-12-05T14:18:11.386Z
8670082 8670082 20251202130413_wy8zs US005A 2025-12-03T14:06:50.511Z 2025-12-05T14:18:10.432Z
8670057 8670057 20251202125629_AfC3I US005A 2025-12-03T14:06:38.398Z 2025-12-05T14:18:08.486Z
8669758 8669758 20251202120811_rFy0t US005A 2025-12-03T14:05:22.489Z 2025-12-05T14:17:46.021Z
8669717 8669717 20251202120341_dzrH4 US005A 2025-12-03T14:05:16.012Z 2025-12-05T14:17:43.817Z
8669680 8669680 20251202115701_nMiVJ US005A 2025-12-03T14:04:56.410Z 2025-12-05T14:17:41.052Z
8669551 8669551 20251202113051_BLGp9 US005A 2025-12-03T14:04:30.531Z 2025-12-05T14:17:30.506Z
8669539 8669539 20251202112857_5CZaS US005A 2025-12-03T14:04:24.296Z 2025-12-05T14:17:29.160Z
8669506 8669506 20251202112254_J5XMS US005A 2025-12-03T14:04:12.553Z 2025-12-05T14:17:27.335Z
8669443 8669443 20251202111243_9bpYR US005A 2025-12-03T14:03:57.750Z 2025-12-05T14:17:21.525Z
8669220 8669220 20251202103344_8wNCU US005A 2025-12-03T14:02:53.734Z 2025-12-05T14:16:59.242Z
8669049 8669049 20251202100215_jkXK6 US005A 2025-12-03T14:02:08.594Z 2025-12-05T14:16:46.735Z
8668948 8668948 20251202093738_c8TZ0 US005A 2025-12-03T14:01:41.781Z 2025-12-05T14:16:21.304Z
8668867 8668867 20251202091419_2r2qD US005A 2025-12-03T14:01:29.664Z 2025-12-05T14:15:43.936Z
8668802 8668802 20251202090149_XZuMP US005A 2025-12-03T14:01:20.864Z 2025-12-05T14:15:29.651Z
8668742 8668742 20251202084805_v0RNu US005A 2025-12-03T14:01:00.475Z 2025-12-05T14:15:10.353Z
8668165 8668165 20251130062707_vwBii US005A 2025-12-02T14:42:07.311Z 2025-12-05T14:46:00.141Z
8667872 8667872 20251130044625_moo8o US005A 2025-12-02T14:40:53.161Z 2025-12-05T14:44:51.038Z
8667805 8667805 20251130040827_N72wK US005A 2025-12-02T14:40:26.469Z 2025-12-05T14:44:36.137Z
8667646 8667646 20251130030535_kwHA3 US005A 2025-12-02T14:39:35.315Z 2025-12-05T14:43:51.865Z
8648226 8648226 20251129070358_mC0Tl US005A 2025-11-30T14:29:58.496Z 2025-12-05T14:53:02.675Z
8647801 8647801 20251129053501_GB0iZ US005A 2025-11-30T14:28:57.379Z 2025-12-05T14:52:48.076Z
8647711 8647711 20251129051332_TaWvD US005A 2025-11-30T14:28:48.088Z 2025-12-05T14:52:46.177Z
8647665 8647665 20251129050415_2NpO1 US005A 2025-11-30T14:28:42.956Z 2025-12-05T14:52:44.893Z
8647489 8647489 20251129044402_5zYrJ US005A 2025-11-30T14:28:29.622Z 2025-12-05T14:52:41.210Z
8647183 8647183 20251129035832_sbtAI US005A 2025-11-30T14:27:48.388Z 2025-12-05T14:52:34.882Z
8646607 8646607 20251129023002_c336B US005A 2025-11-30T14:26:15.416Z 2025-12-05T14:51:45.388Z
8646550 8646550 20251129022031_lKsSN US005A 2025-11-30T14:26:09.112Z 2025-12-05T14:51:44.268Z
8646378 8646378 20251129015527_YToJt US005A 2025-11-30T14:25:55.430Z 2025-12-05T14:51:40.761Z
8638359 8638359 20251129083126_tUElk US005A 2025-11-30T14:00:39.843Z 2025-12-05T14:37:11.340Z
8638318 8638318 20251129082651_Sd3iK US005A 2025-11-30T14:00:30.027Z 2025-12-05T14:37:09.816Z
8637832 8637832 20251128064909_jssQL US005A 2025-11-29T14:27:54.551Z 2025-12-05T15:00:30.735Z
8628768 8628768 20251128130933_PU3cl US005A 2025-11-29T14:07:04.783Z 2025-12-05T14:47:49.810Z
8628542 8628542 20251128125533_0lwhP US005A 2025-11-29T14:06:34.878Z 2025-12-05T14:47:45.419Z
8628184 8628184 20251128122544_87HZo US005A 2025-11-29T14:05:39.656Z 2025-12-05T14:47:31.139Z
8628096 8628096 20251128121411_1r6FB US005A 2025-11-29T14:05:20.587Z 2025-12-05T14:47:14.002Z
8628018 8628018 20251128120745_tnyA3 US005A 2025-11-29T14:05:07.495Z 2025-12-05T14:47:12.376Z
8627782 8627782 20251128113635_fpAQX US005A 2025-11-29T14:04:29.846Z 2025-12-05T14:47:06.159Z
8627766 8627766 20251128113541_XwcV9 US005A 2025-11-29T14:04:28.125Z 2025-12-05T14:47:05.925Z
8627744 8627744 20251128113439_BQB0Z US005A 2025-11-29T14:04:26.072Z 2025-12-05T14:47:05.662Z
8627559 8627559 20251128111330_yTjvi US005A 2025-11-29T14:03:59.401Z 2025-12-05T14:47:02.238Z
8627552 8627552 20251128111251_8Ybmi US005A 2025-11-29T14:03:57.559Z 2025-12-05T14:47:01.716Z
8627397 8627397 20251128105617_jSdZ3 US005A 2025-11-29T14:03:28.724Z 2025-12-05T14:46:58.610Z
8627134 8627134 20251128102636_05LSu US005A 2025-11-29T14:02:47.763Z 2025-12-05T14:46:53.907Z
8625168 8625168 20251127081946_UPUcg US005A 2025-11-28T14:26:20.170Z 2025-12-05T15:05:46.257Z
8625143 8625143 20251127081257_wTW2T US005A 2025-11-28T14:26:18.139Z 2025-12-05T15:05:43.244Z
8625100 8625100 20251127080232_HvK22 US005A 2025-11-28T14:26:14.538Z 2025-12-05T15:05:42.109Z
8625054 8625054 20251127074822_lSH8L US005A 2025-11-28T14:26:11.078Z 2025-12-05T15:05:41.113Z
8624877 8624877 20251127065732_EO2uX US005A 2025-11-28T14:25:42.897Z 2025-12-05T15:05:31.023Z
8624652 8624652 20251127054710_Lnyzx US005A 2025-11-28T14:25:15.687Z 2025-12-05T15:05:19.632Z
8624590 8624590 20251127053154_i3iLT US005A 2025-11-28T14:25:10.999Z 2025-12-05T15:05:15.766Z
8624587 8624587 20251127053108_SfgeG US005A 2025-11-28T14:25:10.828Z 2025-12-05T15:05:15.662Z
8624569 8624569 20251127052901_hiPMz US005A 2025-11-28T14:25:09.746Z 2025-12-05T15:05:15.302Z
8624083 8624083 20251127030241_91uze US005A 2025-11-28T14:23:44.778Z 2025-12-05T15:04:43.905Z

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