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 = "US0009" 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
8691493 8691493 20251205060117_rmF91 US0009 2025-12-06T14:17:54.977Z 2025-12-06T14:18:01.128Z
8691486 8691486 20251205055941_UnVYc US0009 2025-12-06T14:17:54.113Z 2025-12-06T14:18:01.127Z
8691464 8691464 20251205054702_Kxzvn US0009 2025-12-06T14:17:50.700Z 2025-12-06T14:18:01.121Z
8691427 8691427 20251205052645_qKTeH US0009 2025-12-06T14:17:44.419Z 2025-12-06T14:18:01.111Z
8691250 8691250 20251205041512_ATyrB US0009 2025-12-06T14:17:02.418Z 2025-12-06T14:18:01.069Z
8690967 8690967 20251205023432_rtvGA US0009 2025-12-06T14:16:01.509Z 2025-12-06T14:18:01.002Z
8690901 8690901 20251205021648_6r43C US0009 2025-12-06T14:15:48.435Z 2025-12-06T14:18:00.984Z
8688781 8688781 20251205124257_KWDCd US0009 2025-12-06T14:05:45.482Z 2025-12-06T14:05:45.482Z
8688765 8688765 20251205123931_szBYz US0009 2025-12-06T14:05:42.692Z 2025-12-06T14:05:42.692Z
8688689 8688689 20251205122530_LZaDT US0009 2025-12-06T14:05:25.666Z 2025-12-06T14:05:25.666Z
8688636 8688636 20251205121621_0fMZa US0009 2025-12-06T14:05:14.569Z 2025-12-06T14:05:14.569Z
8688311 8688311 20251205110538_Y0Gfy US0009 2025-12-06T14:04:04.286Z 2025-12-06T14:04:04.286Z
8688185 8688185 20251205104410_5VZRX US0009 2025-12-06T14:03:35.202Z 2025-12-06T14:03:35.202Z
8687992 8687992 20251205095431_V0cQu US0009 2025-12-06T14:02:38.029Z 2025-12-06T14:02:38.029Z
8687945 8687945 20251205094949_4dB1k US0009 2025-12-06T14:02:29.296Z 2025-12-06T14:02:29.296Z
8687852 8687852 20251205091937_eBwOk US0009 2025-12-06T14:02:01.456Z 2025-12-06T14:02:01.456Z
8687826 8687826 20251205091355_rZ57j US0009 2025-12-06T14:01:57.098Z 2025-12-06T14:01:57.098Z
8687670 8687670 20251205081950_UFqtX US0009 2025-12-06T14:01:18.364Z 2025-12-06T14:01:18.364Z
8687589 8687589 20251205075356_oN7hd US0009 2025-12-06T14:00:53.807Z 2025-12-06T14:00:53.807Z
8687543 8687543 20251205071747_vDZTn US0009 2025-12-06T14:00:39.297Z 2025-12-06T14:00:39.297Z
8687509 8687509 20251205065928_4LU3G US0009 2025-12-06T14:00:32.704Z 2025-12-06T14:00:32.704Z
8687484 8687484 20251205063744_37tko US0009 2025-12-06T14:00:26.822Z 2025-12-06T14:00:26.822Z
8687464 8687464 20251205063001_shlEA US0009 2025-12-06T14:00:20.902Z 2025-12-06T14:00:20.902Z
8684433 8684433 20251204123830_nA2hQ US0009 2025-12-05T14:03:13.319Z 2025-12-06T14:18:00.510Z
8684314 8684314 20251204120148_zFaKy US0009 2025-12-05T14:02:41.393Z 2025-12-06T14:18:00.474Z
8684296 8684296 20251204115852_t3EfZ US0009 2025-12-05T14:02:39.111Z 2025-12-06T14:18:00.469Z
8682507 8682507 20251203054139_jZDy3 US0009 2025-12-04T14:17:19.520Z 2025-12-06T14:29:12.370Z
8682413 8682413 20251203052652_o3XuJ US0009 2025-12-04T14:17:07.590Z 2025-12-06T14:29:00.934Z
8680967 8680967 20251203020451_ysHUQ US0009 2025-12-04T14:13:28.022Z 2025-12-06T14:27:35.460Z
8680851 8680851 20251203013123_jC4A0 US0009 2025-12-04T14:13:04.963Z 2025-12-06T14:27:29.253Z
8677709 8677709 20251203115349_fKGJ8 US0009 2025-12-04T14:02:20.899Z 2025-12-06T14:19:58.649Z
8677702 8677702 20251203115242_Xk3u8 US0009 2025-12-04T14:02:19.986Z 2025-12-06T14:19:58.271Z
8677158 8677158 20251202071151_8e0lw US0009 2025-12-03T14:26:22.597Z 2025-12-06T14:35:36.995Z
8677132 8677132 20251202065922_sJ4Ed US0009 2025-12-03T14:26:20.701Z 2025-12-06T14:35:36.392Z
8677130 8677130 20251202065921_s6OtZ US0009 2025-12-03T14:26:20.429Z 2025-12-06T14:35:36.205Z
8674422 8674422 20251202022352_Kcr9b US0009 2025-12-03T14:21:37.340Z 2025-12-06T14:34:08.878Z
8670003 8670003 20251202124516_OorD2 US0009 2025-12-03T14:06:28.343Z 2025-12-06T14:24:30.466Z
8669943 8669943 20251202123047_B3SIw US0009 2025-12-03T14:06:06.425Z 2025-12-06T14:24:27.913Z
8669885 8669885 20251202122140_KIvJ4 US0009 2025-12-03T14:05:55.878Z 2025-12-06T14:24:24.863Z
8669844 8669844 20251202121653_vAS73 US0009 2025-12-03T14:05:49.542Z 2025-12-06T14:24:23.121Z
8669608 8669608 20251202114212_VrZGK US0009 2025-12-03T14:04:41.849Z 2025-12-06T14:24:06.111Z
8669330 8669330 20251202105317_Kh6ZR US0009 2025-12-03T14:03:23.077Z 2025-12-06T14:23:49.320Z
8669118 8669118 20251202101550_vokXQ US0009 2025-12-03T14:02:39.134Z 2025-12-06T14:23:34.269Z
8669110 8669110 20251202101343_rW7ej US0009 2025-12-03T14:02:30.254Z 2025-12-06T14:23:33.023Z
8669088 8669088 20251202101111_jF83B US0009 2025-12-03T14:02:22.575Z 2025-12-06T14:23:31.507Z
8669058 8669058 20251202100650_GJ3n6 US0009 2025-12-03T14:02:11.316Z 2025-12-06T14:23:29.900Z
8668973 8668973 20251202094239_jh9Uk US0009 2025-12-03T14:01:50.832Z 2025-12-06T14:23:23.763Z
8668952 8668952 20251202093821_uJfRJ US0009 2025-12-03T14:01:42.843Z 2025-12-06T14:23:22.847Z
8668899 8668899 20251202091939_jsYys US0009 2025-12-03T14:01:33.523Z 2025-12-06T14:23:20.648Z
8668860 8668860 20251202091253_1U2vu US0009 2025-12-03T14:01:28.699Z 2025-12-06T14:23:14.520Z
8668826 8668826 20251202090915_36u2S US0009 2025-12-03T14:01:24.378Z 2025-12-06T14:23:13.196Z
8668820 8668820 20251202090527_tVHe7 US0009 2025-12-03T14:01:23.354Z 2025-12-06T14:23:12.993Z
8668789 8668789 20251202090001_Mo1Bx US0009 2025-12-03T14:01:17.687Z 2025-12-06T14:23:10.030Z
8668764 8668764 20251202085356_vJ1ZB US0009 2025-12-03T14:01:10.766Z 2025-12-06T14:23:09.045Z
8668601 8668601 20251202075706_Vf24j US0009 2025-12-03T14:00:32.645Z 2025-12-06T14:22:56.926Z
8668564 8668564 20251202073723_wSQuJ US0009 2025-12-03T14:00:24.553Z 2025-12-06T14:22:49.464Z
8668338 8668338 20251130072747_tnClC US0009 2025-12-02T14:42:19.819Z 2025-12-06T14:50:30.550Z
8668319 8668319 20251130072249_lRiPD US0009 2025-12-02T14:42:19.137Z 2025-12-06T14:50:30.390Z
8668298 8668298 20251130071339_ZYJNI US0009 2025-12-02T14:42:17.630Z 2025-12-06T14:50:30.004Z
8668186 8668186 20251130063157_l8m5G US0009 2025-12-02T14:42:09.202Z 2025-12-06T14:50:25.847Z
8668040 8668040 20251130054352_MGDyH US0009 2025-12-02T14:41:31.838Z 2025-12-06T14:50:00.771Z
8667940 8667940 20251130051918_ooAln US0009 2025-12-02T14:41:21.281Z 2025-12-06T14:49:43.111Z
8667927 8667927 20251130051118_o4wH5 US0009 2025-12-02T14:41:19.097Z 2025-12-06T14:49:41.861Z
8667723 8667723 20251130033158_gminr US0009 2025-12-02T14:40:07.142Z 2025-12-06T14:48:47.972Z
8667597 8667597 20251130023704_n3hDw US0009 2025-12-02T14:39:03.913Z 2025-12-06T14:48:29.827Z
8667593 8667593 20251130023523_x3HC7 US0009 2025-12-02T14:39:02.744Z 2025-12-06T14:48:28.729Z
8667565 8667565 20251130021719_1QdT6 US0009 2025-12-02T14:38:54.974Z 2025-12-06T14:47:58.509Z
8666944 8666944 20251129095549_dNs5L US0009 2025-12-02T14:32:04.298Z 2025-12-06T14:43:02.875Z
8666931 8666931 20251129083440_bbNqJ US0009 2025-12-02T14:31:37.516Z 2025-12-06T14:42:49.211Z
8660294 8660294 20251130122547_zlo9o US0009 2025-12-02T14:07:15.327Z 2025-12-06T14:36:59.314Z
8660239 8660239 20251130121036_bJZd3 US0009 2025-12-02T14:07:00.774Z 2025-12-06T14:36:57.726Z
8660084 8660084 20251130115457_n48TF US0009 2025-12-02T14:06:28.596Z 2025-12-06T14:36:52.504Z
8659987 8659987 20251130113757_ShDEg US0009 2025-12-02T14:06:01.208Z 2025-12-06T14:36:49.340Z
8659736 8659736 20251130111027_kEVRl US0009 2025-12-02T14:05:10.840Z 2025-12-06T14:36:40.985Z
8659733 8659733 20251130110955_G9t2J US0009 2025-12-02T14:05:10.191Z 2025-12-06T14:36:40.857Z
8659728 8659728 20251130110948_JSsG3 US0009 2025-12-02T14:05:09.636Z 2025-12-06T14:36:40.697Z
8659587 8659587 20251130105249_wdQIe US0009 2025-12-02T14:04:34.868Z 2025-12-06T14:36:24.338Z
8659537 8659537 20251130104305_hwGVh US0009 2025-12-02T14:04:21.514Z 2025-12-06T14:36:23.000Z
8659349 8659349 20251130101318_m2wKm US0009 2025-12-02T14:03:34.735Z 2025-12-06T14:36:15.638Z
8659264 8659264 20251130100131_5r3w8 US0009 2025-12-02T14:03:18.918Z 2025-12-06T14:36:12.611Z
8659248 8659248 20251130095815_m6wOB US0009 2025-12-02T14:03:13.255Z 2025-12-06T14:36:12.187Z
8659169 8659169 20251130094132_MPtRu US0009 2025-12-02T14:02:48.218Z 2025-12-06T14:36:09.300Z
8659118 8659118 20251130093557_4mFHM US0009 2025-12-02T14:02:40.077Z 2025-12-06T14:36:07.483Z
8659023 8659023 20251130091851_yuLJ3 US0009 2025-12-02T14:02:14.741Z 2025-12-06T14:36:03.143Z
8659003 8659003 20251130091712_sEE7w US0009 2025-12-02T14:02:06.616Z 2025-12-06T14:36:02.393Z
8658983 8658983 20251130091330_JaWRF US0009 2025-12-02T14:02:01.694Z 2025-12-06T14:36:01.690Z
8658920 8658920 20251130085707_H0yu1 US0009 2025-12-02T14:01:39.145Z 2025-12-06T14:35:53.611Z
8658915 8658915 20251130085646_w2uWb US0009 2025-12-02T14:01:37.391Z 2025-12-06T14:35:52.782Z
8658792 8658792 20251130080831_ykwzg US0009 2025-12-02T14:00:53.012Z 2025-12-06T14:35:41.486Z
8658771 8658771 20251130075953_nZh8j US0009 2025-12-02T14:00:46.363Z 2025-12-06T14:35:40.584Z
8648458 8648458 20251129080215_NTrrX US0009 2025-11-30T14:30:11.488Z 2025-12-06T14:57:44.361Z
8648395 8648395 20251129074336_1ZUiX US0009 2025-11-30T14:30:08.130Z 2025-12-06T14:57:36.761Z
8648377 8648377 20251129074058_jLVdn US0009 2025-11-30T14:30:07.118Z 2025-12-06T14:57:36.540Z
8648351 8648351 20251129073328_PW3jd US0009 2025-11-30T14:30:05.488Z 2025-12-06T14:57:33.217Z
8648332 8648332 20251129073201_UJkJO US0009 2025-11-30T14:30:04.494Z 2025-12-06T14:57:32.212Z
8648317 8648317 20251129072752_EI7gD US0009 2025-11-30T14:30:03.326Z 2025-12-06T14:57:31.895Z
8648110 8648110 20251129063934_XD68I US0009 2025-11-30T14:29:38.092Z 2025-12-06T14:57:13.611Z
8648058 8648058 20251129063257_CmB5a US0009 2025-11-30T14:29:32.122Z 2025-12-06T14:57:10.974Z
8647251 8647251 20251129041255_12zY6 US0009 2025-11-30T14:27:53.776Z 2025-12-06T14:56:34.878Z
8646957 8646957 20251129031930_K7Ydn US0009 2025-11-30T14:27:10.996Z 2025-12-06T14:56:28.672Z

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