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 = "US000G" 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
8691494 8691494 20251205060117_rmF91 US000G 2025-12-06T14:17:54.977Z 2025-12-06T14:18:01.128Z
8691465 8691465 20251205054702_Kxzvn US000G 2025-12-06T14:17:50.701Z 2025-12-06T14:18:01.121Z
8691251 8691251 20251205041512_ATyrB US000G 2025-12-06T14:17:02.418Z 2025-12-06T14:18:01.069Z
8691184 8691184 20251205040021_dgN2f US000G 2025-12-06T14:16:49.462Z 2025-12-06T14:18:01.052Z
8691062 8691062 20251205031744_pRBoy US000G 2025-12-06T14:16:23.382Z 2025-12-06T14:18:01.024Z
8690968 8690968 20251205023432_rtvGA US000G 2025-12-06T14:16:01.509Z 2025-12-06T14:18:01.002Z
8690902 8690902 20251205021648_6r43C US000G 2025-12-06T14:15:48.435Z 2025-12-06T14:18:00.984Z
8690857 8690857 20251205020612_nkMX9 US000G 2025-12-06T14:15:42.530Z 2025-12-06T14:18:00.974Z
8690839 8690839 20251205020252_scVXA US000G 2025-12-06T14:15:39.058Z 2025-12-06T14:18:00.969Z
8690835 8690835 20251205020252_ZuJRn US000G 2025-12-06T14:15:38.700Z 2025-12-06T14:18:00.969Z
8688734 8688734 20251205123040_fuTgW US000G 2025-12-06T14:05:36.763Z 2025-12-06T14:05:36.763Z
8688680 8688680 20251205122313_97nwq US000G 2025-12-06T14:05:24.228Z 2025-12-06T14:05:24.228Z
8688637 8688637 20251205121621_0fMZa US000G 2025-12-06T14:05:14.569Z 2025-12-06T14:05:14.569Z
8688588 8688588 20251205120650_5KVH4 US000G 2025-12-06T14:05:05.968Z 2025-12-06T14:05:05.968Z
8688186 8688186 20251205104410_5VZRX US000G 2025-12-06T14:03:35.202Z 2025-12-06T14:03:35.202Z
8687946 8687946 20251205094949_4dB1k US000G 2025-12-06T14:02:29.296Z 2025-12-06T14:02:29.296Z
8687873 8687873 20251205092336_2e3p9 US000G 2025-12-06T14:02:06.813Z 2025-12-06T14:02:06.813Z
8687690 8687690 20251205083057_rjQgv US000G 2025-12-06T14:01:23.647Z 2025-12-06T14:01:23.647Z
8687671 8687671 20251205081950_UFqtX US000G 2025-12-06T14:01:18.364Z 2025-12-06T14:01:18.364Z
8684125 8684125 20251204105200_KN8sE US000G 2025-12-05T14:02:00.265Z 2025-12-06T14:18:00.423Z
8682508 8682508 20251203054139_jZDy3 US000G 2025-12-04T14:17:19.520Z 2025-12-06T14:29:12.370Z
8682484 8682484 20251203054007_C9cI6 US000G 2025-12-04T14:17:18.415Z 2025-12-06T14:29:09.534Z
8682462 8682462 20251203053759_BFfzn US000G 2025-12-04T14:17:15.266Z 2025-12-06T14:29:03.987Z
8677781 8677781 20251203123016_dYmFt US000G 2025-12-04T14:02:34.253Z 2025-12-06T14:20:05.203Z
8677710 8677710 20251203115349_fKGJ8 US000G 2025-12-04T14:02:20.900Z 2025-12-06T14:19:58.649Z
8677703 8677703 20251203115242_Xk3u8 US000G 2025-12-04T14:02:19.995Z 2025-12-06T14:19:58.272Z
8677133 8677133 20251202065922_sJ4Ed US000G 2025-12-03T14:26:20.701Z 2025-12-06T14:35:36.392Z
8677026 8677026 20251202064124_HrG7L US000G 2025-12-03T14:26:12.662Z 2025-12-06T14:35:33.174Z
8676076 8676076 20251202053452_qQlML US000G 2025-12-03T14:24:40.464Z 2025-12-06T14:35:07.798Z
8674775 8674775 20251202032451_EkYNF US000G 2025-12-03T14:22:21.255Z 2025-12-06T14:34:18.829Z
8674369 8674369 20251202021311_FuslF US000G 2025-12-03T14:21:32.829Z 2025-12-06T14:34:06.830Z
8669980 8669980 20251202123915_6VGri US000G 2025-12-03T14:06:18.645Z 2025-12-06T14:24:29.161Z
8669967 8669967 20251202123835_7uMT2 US000G 2025-12-03T14:06:13.524Z 2025-12-06T14:24:28.864Z
8669944 8669944 20251202123047_B3SIw US000G 2025-12-03T14:06:06.425Z 2025-12-06T14:24:27.913Z
8669923 8669923 20251202122927_lfTTp US000G 2025-12-03T14:06:03.696Z 2025-12-06T14:24:27.502Z
8669870 8669870 20251202121907_JFSHN US000G 2025-12-03T14:05:52.968Z 2025-12-06T14:24:23.997Z
8669690 8669690 20251202115909_4Le47 US000G 2025-12-03T14:05:10.822Z 2025-12-06T14:24:15.514Z
8669668 8669668 20251202115542_2aYMu US000G 2025-12-03T14:04:54.681Z 2025-12-06T14:24:14.000Z
8669661 8669661 20251202115359_Oj1uQ US000G 2025-12-03T14:04:53.633Z 2025-12-06T14:24:13.664Z
8669620 8669620 20251202114305_uf1Cp US000G 2025-12-03T14:04:43.705Z 2025-12-06T14:24:06.695Z
8669609 8669609 20251202114212_VrZGK US000G 2025-12-03T14:04:41.849Z 2025-12-06T14:24:06.111Z
8669560 8669560 20251202113137_Kcvhi US000G 2025-12-03T14:04:32.789Z 2025-12-06T14:24:02.302Z
8669520 8669520 20251202112557_x6W4d US000G 2025-12-03T14:04:18.661Z 2025-12-06T14:23:59.396Z
8669186 8669186 20251202102947_1f9lq US000G 2025-12-03T14:02:49.372Z 2025-12-06T14:23:39.451Z
8669169 8669169 20251202102901_q3OTB US000G 2025-12-03T14:02:47.387Z 2025-12-06T14:23:38.817Z
8669119 8669119 20251202101550_vokXQ US000G 2025-12-03T14:02:39.134Z 2025-12-06T14:23:34.269Z
8669089 8669089 20251202101111_jF83B US000G 2025-12-03T14:02:22.575Z 2025-12-06T14:23:31.507Z
8669066 8669066 20251202100759_YNibN US000G 2025-12-03T14:02:13.110Z 2025-12-06T14:23:30.239Z
8669059 8669059 20251202100650_GJ3n6 US000G 2025-12-03T14:02:11.316Z 2025-12-06T14:23:29.900Z
8669046 8669046 20251202100031_Ghxhf US000G 2025-12-03T14:02:07.935Z 2025-12-06T14:23:28.648Z
8669011 8669011 20251202095219_JfLpm US000G 2025-12-03T14:02:00.787Z 2025-12-06T14:23:25.834Z
8668827 8668827 20251202090915_36u2S US000G 2025-12-03T14:01:24.378Z 2025-12-06T14:23:13.196Z
8668790 8668790 20251202090001_Mo1Bx US000G 2025-12-03T14:01:17.687Z 2025-12-06T14:23:10.031Z
8668749 8668749 20251202085109_wFCji US000G 2025-12-03T14:01:01.845Z 2025-12-06T14:23:08.220Z
8668712 8668712 20251202083646_XLL74 US000G 2025-12-03T14:00:55.145Z 2025-12-06T14:23:06.335Z
8668658 8668658 20251202081130_HXfpL US000G 2025-12-03T14:00:44.968Z 2025-12-06T14:23:01.040Z
8668611 8668611 20251202075914_A2zdb US000G 2025-12-03T14:00:34.293Z 2025-12-06T14:22:57.404Z
8668602 8668602 20251202075706_Vf24j US000G 2025-12-03T14:00:32.645Z 2025-12-06T14:22:56.927Z
8668565 8668565 20251202073723_wSQuJ US000G 2025-12-03T14:00:24.593Z 2025-12-06T14:22:49.464Z
8668554 8668554 20251202073135_AS7j0 US000G 2025-12-03T14:00:20.854Z 2025-12-06T14:22:47.957Z
8668455 8668455 20251129052332_6uUog US000G 2025-12-02T14:48:29.296Z 2025-12-06T14:56:47.105Z
8668339 8668339 20251130072747_tnClC US000G 2025-12-02T14:42:19.819Z 2025-12-06T14:50:30.550Z
8668328 8668328 20251130072543_cy3ss US000G 2025-12-02T14:42:19.504Z 2025-12-06T14:50:30.483Z
8668320 8668320 20251130072249_lRiPD US000G 2025-12-02T14:42:19.137Z 2025-12-06T14:50:30.391Z
8667912 8667912 20251130050836_aKA8P US000G 2025-12-02T14:41:17.506Z 2025-12-06T14:49:39.848Z
8667878 8667878 20251130045008_DryZ4 US000G 2025-12-02T14:41:08.432Z 2025-12-06T14:49:33.575Z
8667724 8667724 20251130033158_gminr US000G 2025-12-02T14:40:07.142Z 2025-12-06T14:48:47.972Z
8667598 8667598 20251130023704_n3hDw US000G 2025-12-02T14:39:03.913Z 2025-12-06T14:48:29.827Z
8667546 8667546 20251130020833_aGl01 US000G 2025-12-02T14:38:49.875Z 2025-12-06T14:47:54.744Z
8667522 8667522 20251130020407_DMUY3 US000G 2025-12-02T14:38:47.131Z 2025-12-06T14:47:52.135Z
8667411 8667411 20251130010217_oJwmL US000G 2025-12-02T14:38:00.452Z 2025-12-06T14:47:34.310Z
8666754 8666754 20251201012448_y3rVd US000G 2025-12-02T14:27:23.440Z 2025-12-06T14:40:54.746Z
8660385 8660385 20251130124421_Vs2MW US000G 2025-12-02T14:07:43.105Z 2025-12-06T14:37:14.834Z
8660085 8660085 20251130115457_n48TF US000G 2025-12-02T14:06:28.596Z 2025-12-06T14:36:52.504Z
8660028 8660028 20251130114451_FWnCz US000G 2025-12-02T14:06:16.467Z 2025-12-06T14:36:50.533Z
8659991 8659991 20251130113818_JvxX9 US000G 2025-12-02T14:06:01.786Z 2025-12-06T14:36:49.420Z
8659967 8659967 20251130113412_wN13d US000G 2025-12-02T14:05:56.371Z 2025-12-06T14:36:48.563Z
8659941 8659941 20251130113138_glf42 US000G 2025-12-02T14:05:53.004Z 2025-12-06T14:36:47.946Z
8659921 8659921 20251130113053_CAwQK US000G 2025-12-02T14:05:50.063Z 2025-12-06T14:36:47.395Z
8659839 8659839 20251130112140_nunbD US000G 2025-12-02T14:05:28.676Z 2025-12-06T14:36:44.171Z
8659737 8659737 20251130111027_kEVRl US000G 2025-12-02T14:05:10.840Z 2025-12-06T14:36:40.985Z
8659734 8659734 20251130110955_G9t2J US000G 2025-12-02T14:05:10.191Z 2025-12-06T14:36:40.857Z
8659645 8659645 20251130110023_SgkjU US000G 2025-12-02T14:04:44.253Z 2025-12-06T14:36:26.424Z
8659581 8659581 20251130105100_2Q4h1 US000G 2025-12-02T14:04:33.913Z 2025-12-06T14:36:24.224Z
8659523 8659523 20251130104046_oWgnV US000G 2025-12-02T14:04:19.532Z 2025-12-06T14:36:22.703Z
8659446 8659446 20251130102856_HmXRG US000G 2025-12-02T14:03:55.751Z 2025-12-06T14:36:18.770Z
8659367 8659367 20251130101534_v2Zn5 US000G 2025-12-02T14:03:38.753Z 2025-12-06T14:36:16.419Z
8659249 8659249 20251130095815_m6wOB US000G 2025-12-02T14:03:13.255Z 2025-12-06T14:36:12.187Z
8659151 8659151 20251130094111_PiZu7 US000G 2025-12-02T14:02:46.506Z 2025-12-06T14:36:09.051Z
8659044 8659044 20251130092412_Dqh6C US000G 2025-12-02T14:02:21.931Z 2025-12-06T14:36:03.987Z
8659004 8659004 20251130091712_sEE7w US000G 2025-12-02T14:02:06.616Z 2025-12-06T14:36:02.393Z
8658996 8658996 20251130091623_Fr9QH US000G 2025-12-02T14:02:05.271Z 2025-12-06T14:36:02.282Z
8658984 8658984 20251130091330_JaWRF US000G 2025-12-02T14:02:01.694Z 2025-12-06T14:36:01.690Z
8658962 8658962 20251130090627_MQhPF US000G 2025-12-02T14:01:51.015Z 2025-12-06T14:35:59.951Z
8658950 8658950 20251130090346_UyY3E US000G 2025-12-02T14:01:47.846Z 2025-12-06T14:35:59.010Z
8658921 8658921 20251130085707_H0yu1 US000G 2025-12-02T14:01:39.145Z 2025-12-06T14:35:53.611Z
8658916 8658916 20251130085646_w2uWb US000G 2025-12-02T14:01:37.391Z 2025-12-06T14:35:52.782Z
8658886 8658886 20251130085000_9oCwv US000G 2025-12-02T14:01:24.036Z 2025-12-06T14:35:44.831Z
8658881 8658881 20251130084637_FcITA US000G 2025-12-02T14:01:22.626Z 2025-12-06T14:35:44.655Z
8658862 8658862 20251130084234_A8B6Y US000G 2025-12-02T14:01:17.373Z 2025-12-06T14:35:43.874Z

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