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 = "AU001U" 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
9851705 9851705 20260504193258_4QFlv AU001U 2026-05-06T12:16:43.409Z 2026-05-06T12:17:26.542Z
9851636 9851636 20260504191647_pmteE AU001U 2026-05-06T12:16:36.012Z 2026-05-06T12:17:26.503Z
9851597 9851597 20260504190044_dxGH3 AU001U 2026-05-06T12:16:29.098Z 2026-05-06T12:17:26.449Z
9851583 9851583 20260504184932_9CMz2 AU001U 2026-05-06T12:16:26.558Z 2026-05-06T12:17:26.424Z
9851553 9851553 20260504183707_3pOYP AU001U 2026-05-06T12:16:22.430Z 2026-05-06T12:17:26.393Z
9851541 9851541 20260504183156_DR22Y AU001U 2026-05-06T12:15:58.446Z 2026-05-06T12:17:26.378Z
9851508 9851508 20260504182043_92cC2 AU001U 2026-05-06T12:15:46.838Z 2026-05-06T12:17:26.339Z
9851493 9851493 20260504181230_yGUkv AU001U 2026-05-06T12:15:42.284Z 2026-05-06T12:17:26.250Z
9851480 9851480 20260504180356_Pyq37 AU001U 2026-05-06T12:15:37.534Z 2026-05-06T12:17:26.215Z
9851409 9851409 20260504165807_Penhk AU001U 2026-05-06T12:14:46.833Z 2026-05-06T12:17:25.631Z
9851404 9851404 20260504164118_QUK3k AU001U 2026-05-06T12:14:27.922Z 2026-05-06T12:17:25.586Z
9851395 9851395 20260504162947_t2PiS AU001U 2026-05-06T12:14:13.389Z 2026-05-06T12:17:25.548Z
9851388 9851388 20260504162052_nxOch AU001U 2026-05-06T12:14:08.850Z 2026-05-06T12:17:25.522Z
9851345 9851345 20260504154432_Nkb2w AU001U 2026-05-06T12:13:38.524Z 2026-05-06T12:17:25.405Z
9851336 9851336 20260504153222_eNW2h AU001U 2026-05-06T12:13:31.785Z 2026-05-06T12:17:25.374Z
9851306 9851306 20260504144402_v1Um2 AU001U 2026-05-06T12:12:49.427Z 2026-05-06T12:17:25.234Z
9851304 9851304 20260504144314_myK3U AU001U 2026-05-06T12:12:49.149Z 2026-05-06T12:17:25.233Z
9851300 9851300 20260504143130_dfuJ9 AU001U 2026-05-06T12:12:46.672Z 2026-05-06T12:17:25.074Z
9851296 9851296 20260504143019_hjfKK AU001U 2026-05-06T12:12:46.188Z 2026-05-06T12:17:25.071Z
9851294 9851294 20260504142141_7F79W AU001U 2026-05-06T12:12:41.165Z 2026-05-06T12:17:25.052Z
9851274 9851274 20260504135357_dXNIw AU001U 2026-05-06T12:12:33.245Z 2026-05-06T12:17:24.942Z
9851242 9851242 20260504132410_P0lsd AU001U 2026-05-06T12:12:06.865Z 2026-05-06T12:17:24.879Z
9851235 9851235 20260504132033_FLFba AU001U 2026-05-06T12:12:06.016Z 2026-05-06T12:17:24.875Z
9851185 9851185 20260504121253_vuha3 AU001U 2026-05-06T12:11:50.405Z 2026-05-06T12:17:24.751Z
9851172 9851172 20260504115938_ESDjh AU001U 2026-05-06T12:11:48.654Z 2026-05-06T12:17:24.730Z
9851143 9851143 20260504105716_qwNzA AU001U 2026-05-06T12:11:32.243Z 2026-05-06T12:17:24.658Z
9846993 9846993 20260504212734_cPKZd AU001U 2026-05-06T12:01:01.173Z 2026-05-06T12:17:20.969Z
9846980 9846980 20260504212542_H0NOq AU001U 2026-05-06T12:01:00.283Z 2026-05-06T12:17:20.964Z
9846978 9846978 20260504212204_jiVJx AU001U 2026-05-06T12:01:00.024Z 2026-05-06T12:17:20.963Z
9846968 9846968 20260504212027_4dw66 AU001U 2026-05-06T12:00:59.329Z 2026-05-06T12:17:20.959Z
9846781 9846781 20260504203224_XxnGa AU001U 2026-05-06T12:00:27.831Z 2026-05-06T12:17:20.877Z
9846760 9846760 20260504202736_P37d8 AU001U 2026-05-06T12:00:25.036Z 2026-05-06T12:17:20.871Z
9846737 9846737 20260504202342_o9q2W AU001U 2026-05-06T12:00:21.207Z 2026-05-06T12:17:20.862Z
9846723 9846723 20260504202125_1hxsX AU001U 2026-05-06T12:00:17.477Z 2026-05-06T12:17:20.857Z
9846704 9846704 20260504201357_N8JER AU001U 2026-05-06T12:00:13.082Z 2026-05-06T12:17:20.850Z
9846618 9846618 20260503185624_QlxsD AU001U 2026-05-05T12:17:02.153Z 2026-05-06T12:21:25.521Z
9846398 9846398 20260503161516_3Ggwd AU001U 2026-05-05T12:15:40.216Z 2026-05-06T12:21:11.250Z
9846305 9846305 20260503140629_JeaSD AU001U 2026-05-05T12:15:00.502Z 2026-05-06T12:20:46.641Z
9846243 9846243 20260503120937_CqLC9 AU001U 2026-05-05T12:14:47.000Z 2026-05-06T12:20:39.367Z
9842085 9842085 20260503214137_utJ5B AU001U 2026-05-05T12:02:00.350Z 2026-05-06T12:17:23.889Z
9842078 9842078 20260503214007_wLbTG AU001U 2026-05-05T12:01:59.210Z 2026-05-06T12:17:23.885Z
9842057 9842057 20260503213209_KkCau AU001U 2026-05-05T12:01:56.020Z 2026-05-06T12:17:23.874Z
9841995 9841995 20260503211922_pv1CP AU001U 2026-05-05T12:01:34.957Z 2026-05-06T12:17:23.834Z
9841777 9841777 20260503202807_V6CFi AU001U 2026-05-05T12:00:46.872Z 2026-05-06T12:17:23.704Z
9841734 9841734 20260503201903_H90nR AU001U 2026-05-05T12:00:35.095Z 2026-05-06T12:17:23.680Z
9841728 9841728 20260503201436_jiaX3 AU001U 2026-05-05T12:00:34.147Z 2026-05-06T12:17:23.677Z
9841725 9841725 20260503201327_Yk9vL AU001U 2026-05-05T12:00:33.606Z 2026-05-06T12:17:23.675Z
9841506 9841506 20260501173352_dvc3r AU001U 2026-05-04T12:22:28.021Z 2026-05-06T12:28:04.220Z
9841457 9841457 20260501161800_xMB50 AU001U 2026-05-04T12:22:13.562Z 2026-05-06T12:27:28.468Z
9841327 9841327 20260501111031_TG1HC AU001U 2026-05-04T12:21:12.720Z 2026-05-06T12:27:13.023Z
9841287 9841287 20260502181524_Tgl0v AU001U 2026-05-04T12:17:45.330Z 2026-05-06T12:24:33.687Z
9841278 9841278 20260502181007_XGFa1 AU001U 2026-05-04T12:17:36.226Z 2026-05-06T12:24:30.307Z
9841264 9841264 20260502175543_J18KJ AU001U 2026-05-04T12:17:25.941Z 2026-05-06T12:24:20.544Z
9841260 9841260 20260502174914_C2Rct AU001U 2026-05-04T12:17:22.683Z 2026-05-06T12:24:15.098Z
9841250 9841250 20260502173555_3E2dV AU001U 2026-05-04T12:17:16.337Z 2026-05-06T12:24:13.702Z
9841225 9841225 20260502164717_dIXJX AU001U 2026-05-04T12:16:36.733Z 2026-05-06T12:24:06.992Z
9838686 9838686 20260502214207_4wEJX AU001U 2026-05-04T12:01:57.289Z 2026-05-06T12:18:17.455Z
9838668 9838668 20260502213723_12xs6 AU001U 2026-05-04T12:01:53.821Z 2026-05-06T12:18:16.868Z
9838626 9838626 20260502211726_ndVQK AU001U 2026-05-04T12:01:42.560Z 2026-05-06T12:18:13.581Z
9838554 9838554 20260502204917_HI0qj AU001U 2026-05-04T12:01:27.119Z 2026-05-06T12:17:54.406Z
9838541 9838541 20260502204612_m5rEL AU001U 2026-05-04T12:01:24.815Z 2026-05-06T12:17:53.198Z
9838535 9838535 20260502204458_l8RdK AU001U 2026-05-04T12:01:23.026Z 2026-05-06T12:17:52.470Z
9838503 9838503 20260502203524_VcQGs AU001U 2026-05-04T12:01:15.122Z 2026-05-06T12:17:49.583Z
9838490 9838490 20260502203158_11R1O AU001U 2026-05-04T12:01:12.539Z 2026-05-06T12:17:48.686Z
9838469 9838469 20260502202611_sH5u3 AU001U 2026-05-04T12:01:07.695Z 2026-05-06T12:17:47.344Z
9838447 9838447 20260502202000_vDEmy AU001U 2026-05-04T12:01:03.281Z 2026-05-06T12:17:45.116Z
9838413 9838413 20260502201323_28O5I AU001U 2026-05-04T12:00:57.151Z 2026-05-06T12:17:41.850Z
9838410 9838410 20260502201300_YUFpW AU001U 2026-05-04T12:00:56.561Z 2026-05-06T12:17:41.670Z
9838379 9838379 20260502200047_75j1B AU001U 2026-05-04T12:00:48.889Z 2026-05-06T12:17:36.760Z
9838374 9838374 20260502195950_Um4hs AU001U 2026-05-04T12:00:47.923Z 2026-05-06T12:17:36.615Z
9838329 9838329 20260502193726_b8sa3 AU001U 2026-05-04T12:00:39.124Z 2026-05-06T12:17:35.048Z
9838324 9838324 20260502193609_xnUR6 AU001U 2026-05-04T12:00:37.042Z 2026-05-06T12:17:34.913Z
9838279 9838279 20260502191716_lFcQJ AU001U 2026-05-04T12:00:29.206Z 2026-05-06T12:17:33.534Z
9838263 9838263 20260502191003_1ZKlZ AU001U 2026-05-04T12:00:26.956Z 2026-05-06T12:17:33.146Z
9838261 9838261 20260502190946_R3q0O AU001U 2026-05-04T12:00:26.509Z 2026-05-06T12:17:33.072Z
9838238 9838238 20260502185627_WN3nx AU001U 2026-05-04T12:00:21.806Z 2026-05-06T12:17:32.219Z
9838218 9838218 20260502184559_2oOfe AU001U 2026-05-04T12:00:18.647Z 2026-05-06T12:17:31.678Z
9838208 9838208 20260502183602_k2m0Z AU001U 2026-05-04T12:00:16.725Z 2026-05-06T12:17:28.846Z
9834513 9834513 20260501214117_XPeii AU001U 2026-05-03T12:02:28.804Z 2026-05-06T12:21:59.709Z
9834451 9834451 20260501212514_KZXyU AU001U 2026-05-03T12:02:13.627Z 2026-05-06T12:21:58.356Z
9834449 9834449 20260501212513_MylTA AU001U 2026-05-03T12:02:13.052Z 2026-05-06T12:21:58.300Z
9834421 9834421 20260501211803_ERgU5 AU001U 2026-05-03T12:02:07.615Z 2026-05-06T12:21:57.654Z
9834403 9834403 20260501211413_XRc4f AU001U 2026-05-03T12:02:02.508Z 2026-05-06T12:21:57.215Z
9834378 9834378 20260501210828_RIAXK AU001U 2026-05-03T12:01:49.834Z 2026-05-06T12:21:56.619Z
9834367 9834367 20260501210645_E7xwl AU001U 2026-05-03T12:01:46.547Z 2026-05-06T12:21:56.519Z
9834340 9834340 20260501205758_0XAWb AU001U 2026-05-03T12:01:41.038Z 2026-05-06T12:21:55.894Z
9834317 9834317 20260501205422_yesPB AU001U 2026-05-03T12:01:36.582Z 2026-05-06T12:21:55.360Z
9834283 9834283 20260501204218_5VrQ7 AU001U 2026-05-03T12:01:32.146Z 2026-05-06T12:21:54.799Z
9834243 9834243 20260501203122_YNx3k AU001U 2026-05-03T12:01:25.301Z 2026-05-06T12:21:53.970Z
9834155 9834155 20260501193324_P2bjD AU001U 2026-05-03T12:00:55.979Z 2026-05-06T12:21:51.453Z
9834152 9834152 20260501193303_XTzoE AU001U 2026-05-03T12:00:55.317Z 2026-05-06T12:21:51.418Z
9834141 9834141 20260501192637_zxOK5 AU001U 2026-05-03T12:00:52.311Z 2026-05-06T12:21:51.105Z
9834137 9834137 20260501192506_nZb2I AU001U 2026-05-03T12:00:51.662Z 2026-05-06T12:21:51.060Z
9834117 9834117 20260501191651_bDL4f AU001U 2026-05-03T12:00:42.161Z 2026-05-06T12:21:50.625Z
9834112 9834112 20260501191243_66zMX AU001U 2026-05-03T12:00:40.377Z 2026-05-06T12:21:50.389Z
9834101 9834101 20260501190307_Oa88p AU001U 2026-05-03T12:00:37.576Z 2026-05-06T12:21:50.138Z
9834084 9834084 20260501182410_vsGlf AU001U 2026-05-03T12:00:32.391Z 2026-05-06T12:21:49.620Z
9834076 9834076 20260501181931_MCc3S AU001U 2026-05-03T12:00:29.140Z 2026-05-06T12:21:49.268Z
9834072 9834072 20260501181802_WxjXR AU001U 2026-05-03T12:00:27.750Z 2026-05-06T12:21:49.151Z
9834056 9834056 20260501175830_pza2D AU001U 2026-05-03T12:00:20.053Z 2026-05-06T12:21:32.478Z

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