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 = "AU000A" 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
8679419 8679419 20251202200721_Eb2zJ AU000A 2025-12-04T14:09:47.279Z 2025-12-04T14:19:08.314Z
8679389 8679389 20251202195946_qfq1V AU000A 2025-12-04T14:09:42.941Z 2025-12-04T14:19:08.308Z
8679351 8679351 20251202195126_6LL2f AU000A 2025-12-04T14:09:31.392Z 2025-12-04T14:19:08.300Z
8679285 8679285 20251202193709_7RHKE AU000A 2025-12-04T14:09:21.088Z 2025-12-04T14:19:08.287Z
8673551 8673551 20251201200140_3C5rZ AU000A 2025-12-03T14:19:14.536Z 2025-12-04T14:24:26.204Z
8673441 8673441 20251201191402_5dldg AU000A 2025-12-03T14:18:52.514Z 2025-12-04T14:24:18.373Z
8673420 8673420 20251201190053_NkXZ7 AU000A 2025-12-03T14:18:48.491Z 2025-12-04T14:24:16.236Z
8673413 8673413 20251201185947_cSN6F AU000A 2025-12-03T14:18:47.649Z 2025-12-04T14:24:14.578Z
8673387 8673387 20251201185334_nRyMh AU000A 2025-12-03T14:18:41.523Z 2025-12-04T14:24:12.502Z
8673239 8673239 20251201174111_fFfJJ AU000A 2025-12-03T14:18:04.090Z 2025-12-04T14:23:52.394Z
8673190 8673190 20251201172538_2bbt3 AU000A 2025-12-03T14:17:49.364Z 2025-12-04T14:23:48.642Z
8673147 8673147 20251201171006_XEX2y AU000A 2025-12-03T14:17:40.444Z 2025-12-04T14:23:39.769Z
8672860 8672860 20251201153131_NM26H AU000A 2025-12-03T14:16:43.124Z 2025-12-04T14:23:18.230Z
8666735 8666735 20251130194644_E12hT AU000A 2025-12-02T14:27:15.083Z 2025-12-04T14:31:40.990Z
8666729 8666729 20251130193802_8H3e6 AU000A 2025-12-02T14:27:13.235Z 2025-12-04T14:31:38.182Z
8666609 8666609 20251130160451_kPWZJ AU000A 2025-12-02T14:26:58.058Z 2025-12-04T14:30:08.522Z
8666598 8666598 20251130154005_oX4Az AU000A 2025-12-02T14:26:56.834Z 2025-12-04T14:29:56.004Z
8662824 8662824 20251130193558_lCb5l AU000A 2025-12-02T14:16:48.176Z 2025-12-04T14:31:37.663Z
8662522 8662522 20251130190510_vDg4e AU000A 2025-12-02T14:15:49.256Z 2025-12-04T14:31:25.902Z
8662454 8662454 20251130185237_3eCZo AU000A 2025-12-02T14:15:39.576Z 2025-12-04T14:31:23.011Z
8662433 8662433 20251130184953_hZe5o AU000A 2025-12-02T14:15:28.244Z 2025-12-04T14:31:21.880Z
8662424 8662424 20251130184908_yPBG2 AU000A 2025-12-02T14:15:27.155Z 2025-12-04T14:31:20.506Z
8662337 8662337 20251130183441_BMBYL AU000A 2025-12-02T14:15:10.654Z 2025-12-04T14:31:06.029Z
8662186 8662186 20251130181442_Sri3F AU000A 2025-12-02T14:14:38.732Z 2025-12-04T14:30:57.603Z
8662089 8662089 20251130175357_YcSHO AU000A 2025-12-02T14:14:16.770Z 2025-12-04T14:30:52.304Z
8662007 8662007 20251130174151_x8yrg AU000A 2025-12-02T14:13:57.508Z 2025-12-04T14:30:47.649Z
8661811 8661811 20251130171701_p7GyQ AU000A 2025-12-02T14:13:07.653Z 2025-12-04T14:30:24.476Z
8661797 8661797 20251130171253_5EU4H AU000A 2025-12-02T14:13:04.228Z 2025-12-04T14:30:23.705Z
8661683 8661683 20251130165254_f3EKW AU000A 2025-12-02T14:12:35.924Z 2025-12-04T14:30:17.326Z
8661660 8661660 20251130164624_VfhGN AU000A 2025-12-02T14:12:30.644Z 2025-12-04T14:30:15.208Z
8661644 8661644 20251130164039_2hx3W AU000A 2025-12-02T14:12:27.292Z 2025-12-04T14:30:13.981Z
8661577 8661577 20251130160243_RafpE AU000A 2025-12-02T14:12:05.166Z 2025-12-04T14:30:08.270Z
8661550 8661550 20251130154712_RQQpT AU000A 2025-12-02T14:11:59.991Z 2025-12-04T14:30:06.256Z
8661544 8661544 20251130154614_ZcpZY AU000A 2025-12-02T14:11:58.609Z 2025-12-04T14:30:05.680Z
8661537 8661537 20251130154502_e1oHS AU000A 2025-12-02T14:11:50.419Z 2025-12-04T14:30:05.385Z
8661495 8661495 20251130153623_lXTuF AU000A 2025-12-02T14:11:40.244Z 2025-12-04T14:29:55.402Z
8661157 8661157 20251130145118_BFSAo AU000A 2025-12-02T14:10:34.175Z 2025-12-04T14:29:37.776Z
8660913 8660913 20251130141228_DebOh AU000A 2025-12-02T14:09:42.546Z 2025-12-04T14:29:17.811Z
8660836 8660836 20251130135952_L58CU AU000A 2025-12-02T14:09:21.839Z 2025-12-04T14:29:14.348Z
8650320 8650320 20251129195253_OUeXU AU000A 2025-12-01T14:15:48.510Z 2025-12-04T14:38:48.894Z
8650197 8650197 20251129193738_3L2aQ AU000A 2025-12-01T14:15:24.067Z 2025-12-04T14:38:44.808Z
8650119 8650119 20251129192820_k2RTm AU000A 2025-12-01T14:15:08.121Z 2025-12-04T14:38:42.298Z
8650072 8650072 20251129191816_iy1vN AU000A 2025-12-01T14:15:00.291Z 2025-12-04T14:38:40.468Z
8650070 8650070 20251129191753_hQqCa AU000A 2025-12-01T14:14:59.722Z 2025-12-04T14:38:40.304Z
8650068 8650068 20251129191742_ELiK9 AU000A 2025-12-01T14:14:59.159Z 2025-12-04T14:38:40.216Z
8650047 8650047 20251129191318_4ijlr AU000A 2025-12-01T14:14:51.109Z 2025-12-04T14:38:39.083Z
8650005 8650005 20251129190550_miRWI AU000A 2025-12-01T14:14:42.216Z 2025-12-04T14:38:37.723Z
8649998 8649998 20251129190419_pL9dh AU000A 2025-12-01T14:14:40.626Z 2025-12-04T14:38:37.214Z
8649990 8649990 20251129190133_5qTcu AU000A 2025-12-01T14:14:39.718Z 2025-12-04T14:38:36.990Z
8649888 8649888 20251129184931_UnfKQ AU000A 2025-12-01T14:14:15.599Z 2025-12-04T14:38:33.468Z
8649806 8649806 20251129183051_Tl3ec AU000A 2025-12-01T14:14:00.618Z 2025-12-04T14:38:29.080Z
8649744 8649744 20251129181713_SlSRr AU000A 2025-12-01T14:13:44.091Z 2025-12-04T14:38:11.928Z
8649735 8649735 20251129181505_C1cyb AU000A 2025-12-01T14:13:42.264Z 2025-12-04T14:38:11.415Z
8649733 8649733 20251129181439_48qyj AU000A 2025-12-01T14:13:41.773Z 2025-12-04T14:38:11.265Z
8649550 8649550 20251129174544_auCZt AU000A 2025-12-01T14:13:01.502Z 2025-12-04T14:38:02.968Z
8649458 8649458 20251129173014_0m1sl AU000A 2025-12-01T14:12:39.999Z 2025-12-04T14:37:58.959Z
8649187 8649187 20251129163324_hR12I AU000A 2025-12-01T14:11:22.730Z 2025-12-04T14:37:47.565Z
8649161 8649161 20251129162844_w7zzW AU000A 2025-12-01T14:11:15.409Z 2025-12-04T14:37:46.552Z
8649098 8649098 20251129160905_gnsjN AU000A 2025-12-01T14:10:54.481Z 2025-12-04T14:37:29.503Z
8649094 8649094 20251129160830_qcuel AU000A 2025-12-01T14:10:53.768Z 2025-12-04T14:37:29.202Z
8649024 8649024 20251129154651_Vyi15 AU000A 2025-12-01T14:10:30.755Z 2025-12-04T14:37:25.373Z
8648960 8648960 20251129153213_bCR60 AU000A 2025-12-01T14:10:09.840Z 2025-12-04T14:37:19.767Z
8648927 8648927 20251129151244_eTpnl AU000A 2025-12-01T14:09:44.569Z 2025-12-04T14:37:16.001Z
8644791 8644791 20251128195749_0UE7P AU000A 2025-11-30T14:22:38.260Z 2025-12-04T14:48:35.543Z
8644680 8644680 20251128194351_RyAK6 AU000A 2025-11-30T14:22:14.336Z 2025-12-04T14:48:33.491Z
8644542 8644542 20251128193208_2us2h AU000A 2025-11-30T14:22:05.522Z 2025-12-04T14:48:28.410Z
8644303 8644303 20251128191851_uI4qw AU000A 2025-11-30T14:21:37.167Z 2025-12-04T14:48:24.244Z
8644244 8644244 20251128191104_MFw58 AU000A 2025-11-30T14:21:30.559Z 2025-12-04T14:48:22.827Z
8644212 8644212 20251128190812_P9iw9 AU000A 2025-11-30T14:21:28.569Z 2025-12-04T14:48:22.266Z
8644027 8644027 20251128185122_Bokhu AU000A 2025-11-30T14:21:14.559Z 2025-12-04T14:48:18.160Z
8643972 8643972 20251128184432_O6OjS AU000A 2025-11-30T14:20:56.157Z 2025-12-04T14:48:16.803Z
8643763 8643763 20251128182507_Uvv6e AU000A 2025-11-30T14:20:39.098Z 2025-12-04T14:47:51.981Z
8643751 8643751 20251128182244_2Pk48 AU000A 2025-11-30T14:20:38.580Z 2025-12-04T14:47:51.863Z
8643748 8643748 20251128182232_FLtrJ AU000A 2025-11-30T14:20:38.429Z 2025-12-04T14:47:51.792Z
8643705 8643705 20251128181733_5861c AU000A 2025-11-30T14:20:35.135Z 2025-12-04T14:47:50.851Z
8643677 8643677 20251128181336_jlidW AU000A 2025-11-30T14:20:33.017Z 2025-12-04T14:47:50.411Z
8643641 8643641 20251128181120_3h5oX AU000A 2025-11-30T14:20:30.054Z 2025-12-04T14:47:49.699Z
8643557 8643557 20251128180629_ykCBE AU000A 2025-11-30T14:20:13.009Z 2025-12-04T14:47:48.525Z
8643314 8643314 20251128174327_GDyTI AU000A 2025-11-30T14:19:53.142Z 2025-12-04T14:47:42.591Z
8643077 8643077 20251128171931_sAWR3 AU000A 2025-11-30T14:19:17.932Z 2025-12-04T14:47:38.612Z
8642953 8642953 20251128170701_l7Qn4 AU000A 2025-11-30T14:19:02.865Z 2025-12-04T14:47:36.108Z
8642922 8642922 20251128170240_hr6B3 AU000A 2025-11-30T14:18:59.828Z 2025-12-04T14:47:35.444Z
8642869 8642869 20251128165918_Swsfm AU000A 2025-11-30T14:18:45.093Z 2025-12-04T14:47:34.326Z
8642707 8642707 20251128164020_gtJHI AU000A 2025-11-30T14:18:30.103Z 2025-12-04T14:47:31.363Z
8642551 8642551 20251128161935_urVDy AU000A 2025-11-30T14:18:14.123Z 2025-12-04T14:47:07.837Z
8642535 8642535 20251128161847_Lyex5 AU000A 2025-11-30T14:18:07.601Z 2025-12-04T14:47:06.128Z
8642399 8642399 20251128160045_M0UCU AU000A 2025-11-30T14:17:51.943Z 2025-12-04T14:47:00.443Z
8642357 8642357 20251128155510_K7w43 AU000A 2025-11-30T14:17:49.734Z 2025-12-04T14:47:00.146Z
8642350 8642350 20251128155254_Ho89j AU000A 2025-11-30T14:17:49.016Z 2025-12-04T14:46:59.898Z
8642325 8642325 20251128155016_XTFtC AU000A 2025-11-30T14:17:47.417Z 2025-12-04T14:46:59.593Z
8642279 8642279 20251128154700_eRhk3 AU000A 2025-11-30T14:17:43.745Z 2025-12-04T14:46:58.807Z
8641793 8641793 20251128151403_3ErEh AU000A 2025-11-30T14:17:01.354Z 2025-12-04T14:46:50.316Z
8641745 8641745 20251128151109_MehID AU000A 2025-11-30T14:16:46.117Z 2025-12-04T14:46:49.491Z
8641392 8641392 20251128144218_8IiUu AU000A 2025-11-30T14:16:01.425Z 2025-12-04T14:46:43.025Z
8641356 8641356 20251128143543_Q3BFa AU000A 2025-11-30T14:15:47.555Z 2025-12-04T14:46:40.928Z
8641328 8641328 20251128143147_SFg2j AU000A 2025-11-30T14:15:43.320Z 2025-12-04T14:46:38.497Z
8641269 8641269 20251128141851_qZPPe AU000A 2025-11-30T14:15:15.635Z 2025-12-04T14:46:18.508Z
8641149 8641149 20251128135618_Vl5fj AU000A 2025-11-30T14:14:35.336Z 2025-12-04T14:46:10.972Z
8631704 8631704 20251127194914_rtlJh AU000A 2025-11-29T14:16:04.745Z 2025-12-04T14:54:43.274Z
8631699 8631699 20251127194803_qqdFU AU000A 2025-11-29T14:16:04.310Z 2025-12-04T14:54:43.185Z

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