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 = "AU001A" 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
9851487 9851487 20260504180929_YCpfF AU001A 2026-05-06T12:15:40.045Z 2026-05-06T12:17:26.235Z
9851432 9851432 20260504171447_E8QR8 AU001A 2026-05-06T12:14:51.692Z 2026-05-06T12:17:25.675Z
9851378 9851378 20260504161542_oz7E4 AU001A 2026-05-06T12:14:06.818Z 2026-05-06T12:17:25.503Z
9851350 9851350 20260504154801_Eg3OP AU001A 2026-05-06T12:13:56.417Z 2026-05-06T12:17:25.427Z
9851308 9851308 20260504144433_69CDR AU001A 2026-05-06T12:12:50.030Z 2026-05-06T12:17:25.237Z
9851195 9851195 20260504123845_ZL2Fm AU001A 2026-05-06T12:11:53.233Z 2026-05-06T12:17:24.787Z
9851164 9851164 20260504115027_2kPj4 AU001A 2026-05-06T12:11:46.563Z 2026-05-06T12:17:24.713Z
9846640 9846640 20260503190955_xmA4O AU001A 2026-05-05T12:17:07.303Z 2026-05-06T12:21:26.116Z
9846606 9846606 20260503184718_vxtYN AU001A 2026-05-05T12:17:00.635Z 2026-05-06T12:21:25.142Z
9846564 9846564 20260503182221_JhdaT AU001A 2026-05-05T12:16:55.693Z 2026-05-06T12:21:22.008Z
9846515 9846515 20260503175445_Ji6lq AU001A 2026-05-05T12:16:46.958Z 2026-05-06T12:21:20.158Z
9846489 9846489 20260503174140_RGhXj AU001A 2026-05-05T12:16:23.465Z 2026-05-06T12:21:18.393Z
9846477 9846477 20260503173208_oVHaD AU001A 2026-05-05T12:16:20.044Z 2026-05-06T12:21:17.619Z
9846461 9846461 20260503171533_X0pZa AU001A 2026-05-05T12:16:13.774Z 2026-05-06T12:21:16.090Z
9846419 9846419 20260503163751_Q3pNi AU001A 2026-05-05T12:15:52.121Z 2026-05-06T12:21:13.010Z
9846406 9846406 20260503163237_DWPYP AU001A 2026-05-05T12:15:50.276Z 2026-05-06T12:21:12.594Z
9846391 9846391 20260503161203_bO44S AU001A 2026-05-05T12:15:39.592Z 2026-05-06T12:21:11.048Z
9846357 9846357 20260503152939_jQ3BG AU001A 2026-05-05T12:15:29.315Z 2026-05-06T12:21:08.475Z
9846348 9846348 20260503151600_ZnP5r AU001A 2026-05-05T12:15:26.329Z 2026-05-06T12:21:05.788Z
9846337 9846337 20260503151131_LH5I8 AU001A 2026-05-05T12:15:24.270Z 2026-05-06T12:20:51.259Z
9846333 9846333 20260503150655_hqfFU AU001A 2026-05-05T12:15:14.119Z 2026-05-06T12:20:50.255Z
9846324 9846324 20260503150001_cey7Q AU001A 2026-05-05T12:15:11.078Z 2026-05-06T12:20:49.473Z
9846314 9846314 20260503143251_OFfmt AU001A 2026-05-05T12:15:05.457Z 2026-05-06T12:20:48.379Z
9846294 9846294 20260503134806_XF9Xc AU001A 2026-05-05T12:14:58.249Z 2026-05-06T12:20:45.676Z
9846284 9846284 20260503133123_GXasr AU001A 2026-05-05T12:14:57.064Z 2026-05-06T12:20:43.846Z
9846274 9846274 20260503132151_qHr92 AU001A 2026-05-05T12:14:54.804Z 2026-05-06T12:20:43.052Z
9841436 9841436 20260501154253_CiYm3 AU001A 2026-05-04T12:21:59.682Z 2026-05-06T12:27:24.164Z
9841427 9841427 20260501153550_fs9o1 AU001A 2026-05-04T12:21:56.760Z 2026-05-06T12:27:23.957Z
9841341 9841341 20260501112751_NzrYN AU001A 2026-05-04T12:21:17.652Z 2026-05-06T12:27:13.844Z
9841330 9841330 20260501111649_Qkfh2 AU001A 2026-05-04T12:21:14.475Z 2026-05-06T12:27:13.396Z
9841324 9841324 20260501110126_k6KK9 AU001A 2026-05-04T12:21:06.900Z 2026-05-06T12:27:12.652Z
9841164 9841164 20260502134340_PSMXi AU001A 2026-05-04T12:15:00.365Z 2026-05-06T12:23:47.498Z
9841151 9841151 20260502121508_5NpXa AU001A 2026-05-04T12:14:19.501Z 2026-05-06T12:23:24.486Z
9834334 9834334 20260501205740_wWUs6 AU001A 2026-05-03T12:01:39.464Z 2026-05-06T12:21:55.780Z
9834086 9834086 20260501182421_GX2lA AU001A 2026-05-03T12:00:33.115Z 2026-05-06T12:21:49.681Z
9833810 9833810 20260430122333_Q7MhF AU001A 2026-05-02T12:21:35.152Z 2026-05-06T12:30:43.069Z
9829893 9829893 20260430194927_46BV3 AU001A 2026-05-02T12:02:17.447Z 2026-05-06T12:25:04.920Z
9824674 9824674 20260429203039_aNDPg AU001A 2026-05-01T12:05:30.499Z 2026-05-06T12:28:26.175Z
9824672 9824672 20260429202827_Y2Qgr AU001A 2026-05-01T12:05:29.876Z 2026-05-06T12:28:26.068Z
9804734 9804734 20260425131955_aMRJM AU001A 2026-04-27T12:52:20.978Z 2026-05-02T13:04:33.421Z
9804669 9804669 20260425131424_8uJie AU001A 2026-04-27T12:52:12.049Z 2026-05-02T13:04:32.591Z
9804541 9804541 20260425130302_7k5tb AU001A 2026-04-27T12:52:04.206Z 2026-05-02T13:04:30.818Z
9804502 9804502 20260425125732_R1H4m AU001A 2026-04-27T12:52:01.674Z 2026-05-02T13:04:30.097Z
9797607 9797607 20260425211154_kG8oM AU001A 2026-04-27T12:20:11.190Z 2026-05-04T12:43:39.927Z
9797475 9797475 20260425205131_yrAzy AU001A 2026-04-27T12:19:39.474Z 2026-05-04T12:43:34.333Z
9797374 9797374 20260425203646_yWiAi AU001A 2026-04-27T12:19:09.505Z 2026-05-04T12:43:31.509Z
9797344 9797344 20260425203121_GKjPC AU001A 2026-04-27T12:19:03.470Z 2026-05-04T12:43:30.577Z
9797299 9797299 20260425202416_K09rK AU001A 2026-04-27T12:18:57.352Z 2026-05-04T12:43:29.695Z
9797297 9797297 20260425202416_gqI5M AU001A 2026-04-27T12:18:56.979Z 2026-05-04T12:43:29.585Z
9797283 9797283 20260425202311_3HoIv AU001A 2026-04-27T12:18:54.573Z 2026-05-04T12:43:29.187Z
9797238 9797238 20260425201325_8W263 AU001A 2026-04-27T12:18:41.432Z 2026-05-04T12:43:27.857Z
9797222 9797222 20260425201052_KnQ1h AU001A 2026-04-27T12:18:36.158Z 2026-05-04T12:43:27.423Z
9797218 9797218 20260425201006_OFYzy AU001A 2026-04-27T12:18:35.775Z 2026-05-04T12:43:27.390Z
9797215 9797215 20260425201004_WQKKG AU001A 2026-04-27T12:18:35.468Z 2026-05-04T12:43:27.324Z
9797206 9797206 20260425200750_aBJ0l AU001A 2026-04-27T12:18:33.176Z 2026-05-04T12:43:27.041Z
9797201 9797201 20260425200729_eQ2dw AU001A 2026-04-27T12:18:32.661Z 2026-05-04T12:43:26.951Z
9797192 9797192 20260425200655_Y0Gve AU001A 2026-04-27T12:18:30.747Z 2026-05-04T12:43:26.747Z
9797174 9797174 20260425200045_tRlme AU001A 2026-04-27T12:18:26.656Z 2026-05-04T12:43:26.355Z
9797172 9797172 20260425200045_x4oXJ AU001A 2026-04-27T12:18:26.314Z 2026-05-04T12:43:26.244Z
9797117 9797117 20260425194557_YHCjk AU001A 2026-04-27T12:18:05.258Z 2026-05-04T12:43:24.615Z
9797018 9797018 20260425193303_r3ujF AU001A 2026-04-27T12:17:44.844Z 2026-05-04T12:43:22.241Z
9796968 9796968 20260425192539_7HKph AU001A 2026-04-27T12:17:34.184Z 2026-05-04T12:43:05.120Z
9796958 9796958 20260425192512_Zb96E AU001A 2026-04-27T12:17:31.842Z 2026-05-04T12:43:04.820Z
9796875 9796875 20260425191611_MRqUJ AU001A 2026-04-27T12:17:12.127Z 2026-05-04T12:43:03.020Z
9796863 9796863 20260425191258_bmkRx AU001A 2026-04-27T12:17:09.035Z 2026-05-04T12:43:02.577Z
9796810 9796810 20260425190253_0JH7Z AU001A 2026-04-27T12:16:51.952Z 2026-05-04T12:43:01.261Z
9796768 9796768 20260425185417_MyVQR AU001A 2026-04-27T12:16:38.844Z 2026-05-04T12:42:57.794Z
9796744 9796744 20260425184911_Vsa9h AU001A 2026-04-27T12:16:33.974Z 2026-05-04T12:42:57.224Z
9796734 9796734 20260425184554_spc3G AU001A 2026-04-27T12:16:32.136Z 2026-05-04T12:42:56.879Z
9796727 9796727 20260425184516_26aX2 AU001A 2026-04-27T12:16:31.398Z 2026-05-04T12:42:56.672Z
9796710 9796710 20260425184049_gk7co AU001A 2026-04-27T12:16:21.077Z 2026-05-04T12:42:56.157Z
9796679 9796679 20260425183721_rCJKD AU001A 2026-04-27T12:16:11.298Z 2026-05-04T12:42:55.235Z
9796664 9796664 20260425183504_fOXcs AU001A 2026-04-27T12:16:08.491Z 2026-05-04T12:42:54.684Z
9796644 9796644 20260425182923_pzOOB AU001A 2026-04-27T12:16:04.278Z 2026-05-04T12:42:53.941Z
9796636 9796636 20260425182845_y6AaY AU001A 2026-04-27T12:16:02.678Z 2026-05-04T12:42:53.731Z
9796590 9796590 20260425182300_7W5Cp AU001A 2026-04-27T12:15:48.295Z 2026-05-04T12:42:52.489Z
9796574 9796574 20260425182100_DROVP AU001A 2026-04-27T12:15:42.956Z 2026-05-04T12:42:52.131Z
9796313 9796313 20260425175030_ZD1To AU001A 2026-04-27T12:15:00.332Z 2026-05-04T12:42:47.577Z
9796290 9796290 20260425174940_4pNOz AU001A 2026-04-27T12:14:57.910Z 2026-05-04T12:42:47.305Z
9796214 9796214 20260425174421_j12pT AU001A 2026-04-27T12:14:40.723Z 2026-05-04T12:42:46.338Z
9796182 9796182 20260425174254_6Z5Fy AU001A 2026-04-27T12:14:35.844Z 2026-05-04T12:42:45.777Z
9796170 9796170 20260425174207_c8ReE AU001A 2026-04-27T12:14:34.202Z 2026-05-04T12:42:45.649Z
9796130 9796130 20260425173925_e3z5i AU001A 2026-04-27T12:14:28.947Z 2026-05-04T12:42:44.882Z
9796096 9796096 20260425173616_WmUi8 AU001A 2026-04-27T12:14:19.009Z 2026-05-04T12:42:44.167Z
9795995 9795995 20260425173135_66O03 AU001A 2026-04-27T12:14:06.391Z 2026-05-04T12:42:42.648Z
9795986 9795986 20260425173053_aHZer AU001A 2026-04-27T12:14:05.160Z 2026-05-04T12:42:41.815Z
9795865 9795865 20260425172414_cw6nG AU001A 2026-04-27T12:13:38.991Z 2026-05-04T12:42:23.678Z
9795768 9795768 20260425172115_8nkvZ AU001A 2026-04-27T12:13:30.105Z 2026-05-04T12:42:22.563Z
9795396 9795396 20260425165943_0oNif AU001A 2026-04-27T12:12:28.709Z 2026-05-04T12:42:14.369Z
9795331 9795331 20260425165324_gvl2f AU001A 2026-04-27T12:12:15.869Z 2026-05-04T12:42:13.017Z
9795306 9795306 20260425165229_ikT6K AU001A 2026-04-27T12:12:14.129Z 2026-05-04T12:42:12.779Z
9795301 9795301 20260425165206_xD39p AU001A 2026-04-27T12:12:12.729Z 2026-05-04T12:42:12.435Z
9795182 9795182 20260425164543_VMYZk AU001A 2026-04-27T12:11:48.696Z 2026-05-04T12:42:10.528Z
9794978 9794978 20260425163257_TBgHR AU001A 2026-04-27T12:11:14.517Z 2026-05-04T12:42:07.204Z
9794893 9794893 20260425162623_BKBVz AU001A 2026-04-27T12:10:53.548Z 2026-05-04T12:42:05.749Z
9794807 9794807 20260425162029_37wsc AU001A 2026-04-27T12:10:42.550Z 2026-05-04T12:42:04.339Z
9794782 9794782 20260425161851_j87o5 AU001A 2026-04-27T12:10:38.026Z 2026-05-04T12:42:03.778Z
9794572 9794572 20260425155926_jy9KO AU001A 2026-04-27T12:09:55.819Z 2026-05-04T12:41:50.202Z
9794533 9794533 20260425155634_Tizxm AU001A 2026-04-27T12:09:51.872Z 2026-05-04T12:41:45.954Z
9794218 9794218 20260425153019_egRrc AU001A 2026-04-27T12:08:54.982Z 2026-05-04T12:41:36.259Z

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