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 = "AU000D" 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
9271776 9271776 20260127200407_pqAKe AU000D 2026-01-29T14:23:28.664Z 2026-01-29T14:30:25.135Z
9271758 9271758 20260127195134_SmC3w AU000D 2026-01-29T14:23:18.787Z 2026-01-29T14:30:25.101Z
9271739 9271739 20260127194709_2YVrZ AU000D 2026-01-29T14:23:13.188Z 2026-01-29T14:30:25.085Z
9271733 9271733 20260127194554_N0rzy AU000D 2026-01-29T14:23:11.140Z 2026-01-29T14:30:25.083Z
9271716 9271716 20260127193106_ic3Nf AU000D 2026-01-29T14:22:47.602Z 2026-01-29T14:30:25.047Z
9271658 9271658 20260127190143_1SKk9 AU000D 2026-01-29T14:22:11.666Z 2026-01-29T14:30:25.003Z
9271619 9271619 20260127184214_MSzDz AU000D 2026-01-29T14:21:49.391Z 2026-01-29T14:30:24.975Z
9271589 9271589 20260127181837_UyWkF AU000D 2026-01-29T14:21:39.803Z 2026-01-29T14:30:24.943Z
9271579 9271579 20260127181201_miTCR AU000D 2026-01-29T14:21:36.876Z 2026-01-29T14:30:24.938Z
9271565 9271565 20260127180113_fxemn AU000D 2026-01-29T14:21:27.091Z 2026-01-29T14:30:24.922Z
9271548 9271548 20260127174941_2RQnb AU000D 2026-01-29T14:21:17.541Z 2026-01-29T14:30:24.902Z
9271535 9271535 20260127173743_n5fPV AU000D 2026-01-29T14:21:13.092Z 2026-01-29T14:30:24.893Z
9271507 9271507 20260127172133_UgC2e AU000D 2026-01-29T14:21:05.654Z 2026-01-29T14:30:24.870Z
9271487 9271487 20260127170336_dLv2D AU000D 2026-01-29T14:20:52.030Z 2026-01-29T14:30:24.842Z
9271479 9271479 20260127165612_9t010 AU000D 2026-01-29T14:20:48.762Z 2026-01-29T14:30:24.836Z
9271465 9271465 20260127163358_8EZtK AU000D 2026-01-29T14:20:42.742Z 2026-01-29T14:30:24.812Z
9271456 9271456 20260127162527_XF8R6 AU000D 2026-01-29T14:20:38.993Z 2026-01-29T14:30:24.803Z
9271411 9271411 20260127151808_JXQlp AU000D 2026-01-29T14:19:47.512Z 2026-01-29T14:30:24.554Z
9271409 9271409 20260127151700_ZWpex AU000D 2026-01-29T14:19:42.995Z 2026-01-29T14:30:24.552Z
9271407 9271407 20260127151444_9UXTw AU000D 2026-01-29T14:19:41.222Z 2026-01-29T14:30:24.547Z
9271378 9271378 20260127143723_VIVtd AU000D 2026-01-29T14:19:16.279Z 2026-01-29T14:30:24.501Z
9271374 9271374 20260127142701_Yxl0D AU000D 2026-01-29T14:19:09.874Z 2026-01-29T14:30:24.479Z
9271366 9271366 20260127135817_jIQyp AU000D 2026-01-29T14:18:56.771Z 2026-01-29T14:30:24.418Z
9271360 9271360 20260127133458_10NFa AU000D 2026-01-29T14:18:41.889Z 2026-01-29T14:30:24.391Z
9271358 9271358 20260127133247_TWDKB AU000D 2026-01-29T14:18:40.945Z 2026-01-29T14:30:24.385Z
9271356 9271356 20260127130621_ZTL5g AU000D 2026-01-29T14:18:25.642Z 2026-01-29T14:30:24.278Z
9271352 9271352 20260127122823_k2mDW AU000D 2026-01-29T14:18:01.519Z 2026-01-29T14:30:24.177Z
9267116 9267116 20260126192515_UQ5Bg AU000D 2026-01-28T14:19:21.344Z 2026-01-29T14:34:19.536Z
9267112 9267112 20260126192059_Dv0ge AU000D 2026-01-28T14:19:19.555Z 2026-01-29T14:34:18.917Z
9267100 9267100 20260126185628_02sy8 AU000D 2026-01-28T14:19:13.003Z 2026-01-29T14:34:17.050Z
9267062 9267062 20260126183658_JscNk AU000D 2026-01-28T14:18:48.376Z 2026-01-29T14:34:11.442Z
9267042 9267042 20260126182415_bC7lX AU000D 2026-01-28T14:18:37.581Z 2026-01-29T14:34:01.419Z
9267032 9267032 20260126181421_H1NXb AU000D 2026-01-28T14:18:31.771Z 2026-01-29T14:33:59.888Z
9266982 9266982 20260126173446_kx3va AU000D 2026-01-28T14:18:07.392Z 2026-01-29T14:33:52.184Z
9266978 9266978 20260126173117_n6TJi AU000D 2026-01-28T14:18:05.875Z 2026-01-29T14:33:51.856Z
9266973 9266973 20260126172801_4L2a6 AU000D 2026-01-28T14:18:04.396Z 2026-01-29T14:33:51.477Z
9266969 9266969 20260126172539_2G2F3 AU000D 2026-01-28T14:18:03.300Z 2026-01-29T14:33:50.912Z
9266965 9266965 20260126172401_v221K AU000D 2026-01-28T14:17:56.807Z 2026-01-29T14:33:50.210Z
9266939 9266939 20260126165840_FKJz2 AU000D 2026-01-28T14:17:45.574Z 2026-01-29T14:33:46.405Z
9266931 9266931 20260126164856_kB8jw AU000D 2026-01-28T14:17:43.700Z 2026-01-29T14:33:45.837Z
9266907 9266907 20260126161425_73ylX AU000D 2026-01-28T14:17:28.889Z 2026-01-29T14:33:42.497Z
9266880 9266880 20260126153941_NAgvk AU000D 2026-01-28T14:17:12.764Z 2026-01-29T14:33:31.205Z
9266878 9266878 20260126152918_u3iik AU000D 2026-01-28T14:17:10.055Z 2026-01-29T14:33:29.851Z
9266874 9266874 20260126152402_9PL4c AU000D 2026-01-28T14:17:04.736Z 2026-01-29T14:33:28.288Z
9266851 9266851 20260126142004_2Edrh AU000D 2026-01-28T14:16:38.922Z 2026-01-29T14:33:13.457Z
9266846 9266846 20260126141201_RY1oA AU000D 2026-01-28T14:16:36.255Z 2026-01-29T14:33:12.210Z
9266840 9266840 20260126131755_YVCm0 AU000D 2026-01-28T14:16:15.753Z 2026-01-29T14:32:57.475Z
9266833 9266833 20260126130634_9mgb5 AU000D 2026-01-28T14:16:11.448Z 2026-01-29T14:32:54.906Z
9263350 9263350 20260124184718_dxWes AU000D 2026-01-27T14:21:33.493Z 2026-01-29T14:42:36.576Z
9263330 9263330 20260124175622_VS9Qy AU000D 2026-01-27T14:21:15.941Z 2026-01-29T14:42:18.843Z
9263322 9263322 20260124174706_7K5O6 AU000D 2026-01-27T14:21:07.290Z 2026-01-29T14:42:16.356Z
9263294 9263294 20260124164350_22zg4 AU000D 2026-01-27T14:20:44.762Z 2026-01-29T14:42:01.371Z
9263284 9263284 20260124163658_rClaA AU000D 2026-01-27T14:20:39.220Z 2026-01-29T14:41:59.575Z
9263274 9263274 20260124162911_C3V6W AU000D 2026-01-27T14:20:36.191Z 2026-01-29T14:41:58.361Z
9263270 9263270 20260124161857_CUz0a AU000D 2026-01-27T14:20:33.948Z 2026-01-29T14:41:57.275Z
9263268 9263268 20260124161845_YD2cP AU000D 2026-01-27T14:20:33.365Z 2026-01-29T14:41:57.035Z
9263259 9263259 20260124153932_BUfyL AU000D 2026-01-27T14:20:17.398Z 2026-01-29T14:41:46.834Z
9263223 9263223 20260124141052_xaCeE AU000D 2026-01-27T14:19:39.194Z 2026-01-29T14:41:21.664Z
9263210 9263210 20260124134739_rs9AC AU000D 2026-01-27T14:19:28.433Z 2026-01-29T14:41:17.025Z
9263208 9263208 20260124133658_uDuRr AU000D 2026-01-27T14:19:26.278Z 2026-01-29T14:41:15.804Z
9263202 9263202 20260124131603_f2oSw AU000D 2026-01-27T14:19:18.106Z 2026-01-29T14:41:05.723Z
9263192 9263192 20260124123355_bHHCr AU000D 2026-01-27T14:19:04.757Z 2026-01-29T14:40:56.316Z
9262567 9262567 20260125201431_TSwak AU000D 2026-01-27T14:13:37.528Z 2026-01-29T14:38:14.738Z
9259138 9259138 20260124190716_YATpS AU000D 2026-01-26T14:15:53.188Z 2026-01-29T14:42:38.301Z
9259051 9259051 20260124183429_5GGUw AU000D 2026-01-26T14:15:32.139Z 2026-01-29T14:42:28.159Z
9258888 9258888 20260124175155_wB8eo AU000D 2026-01-26T14:14:54.764Z 2026-01-29T14:42:17.124Z
9258760 9258760 20260124164833_2At5T AU000D 2026-01-26T14:14:16.457Z 2026-01-29T14:42:06.711Z
9258689 9258689 20260124160537_q0IXk AU000D 2026-01-26T14:13:54.755Z 2026-01-29T14:41:52.304Z
9258647 9258647 20260124154311_h4c2E AU000D 2026-01-26T14:13:37.304Z 2026-01-29T14:41:47.286Z
9258629 9258629 20260124152236_HK3zp AU000D 2026-01-26T14:13:30.073Z 2026-01-29T14:41:44.003Z
9258595 9258595 20260124150029_8wy12 AU000D 2026-01-26T14:13:11.108Z 2026-01-29T14:41:33.657Z
9258588 9258588 20260124145324_ThLJ8 AU000D 2026-01-26T14:13:08.617Z 2026-01-29T14:41:32.536Z
9258586 9258586 20260124145245_SWxsp AU000D 2026-01-26T14:13:07.927Z 2026-01-29T14:41:32.335Z
9258508 9258508 20260124140653_mOWoS AU000D 2026-01-26T14:12:37.527Z 2026-01-29T14:41:20.382Z
9258426 9258426 20260124123012_9VZvH AU000D 2026-01-26T14:12:00.829Z 2026-01-29T14:40:55.962Z
9207002 9207002 20260114202029_kRvZg AU000D 2026-01-16T14:06:34.834Z 2026-01-22T15:02:48.285Z
9206986 9206986 20260114201542_4CUUf AU000D 2026-01-16T14:06:31.101Z 2026-01-22T15:02:45.665Z
9206949 9206949 20260114195809_t7HPq AU000D 2026-01-16T14:06:19.348Z 2026-01-22T15:02:44.239Z
9206915 9206915 20260114194521_2geIO AU000D 2026-01-16T14:06:09.412Z 2026-01-22T15:02:43.168Z
9206911 9206911 20260114194506_PY2gS AU000D 2026-01-16T14:06:08.680Z 2026-01-22T15:02:43.113Z
9206908 9206908 20260114194416_EMZnx AU000D 2026-01-16T14:06:07.936Z 2026-01-22T15:02:43.037Z
9206874 9206874 20260114193242_KusHO AU000D 2026-01-16T14:05:58.915Z 2026-01-22T15:02:41.713Z
9206868 9206868 20260114192946_7k3SY AU000D 2026-01-16T14:05:57.512Z 2026-01-22T15:02:41.588Z
9206837 9206837 20260114191432_hPKBc AU000D 2026-01-16T14:05:48.015Z 2026-01-22T15:02:38.190Z
9206810 9206810 20260114190457_YR8gN AU000D 2026-01-16T14:05:40.314Z 2026-01-22T15:02:37.209Z
9206781 9206781 20260114185349_SmgpP AU000D 2026-01-16T14:05:32.880Z 2026-01-22T15:02:36.408Z
9206741 9206741 20260114184032_WuFSX AU000D 2026-01-16T14:05:23.048Z 2026-01-22T15:02:35.290Z
9206735 9206735 20260114184005_I8RuY AU000D 2026-01-16T14:05:21.274Z 2026-01-22T15:02:35.107Z
9206693 9206693 20260114182033_5KcSf AU000D 2026-01-16T14:05:06.918Z 2026-01-22T15:02:33.761Z
9206666 9206666 20260114181628_DmtYE AU000D 2026-01-16T14:05:00.393Z 2026-01-22T15:02:33.208Z
9206626 9206626 20260114175906_P3wTt AU000D 2026-01-16T14:04:49.212Z 2026-01-22T15:02:31.980Z
9206599 9206599 20260114175045_k47SX AU000D 2026-01-16T14:04:40.055Z 2026-01-22T15:02:31.141Z
9206587 9206587 20260114174834_0uO9x AU000D 2026-01-16T14:04:36.946Z 2026-01-22T15:02:30.873Z
9206577 9206577 20260114174653_DSa0W AU000D 2026-01-16T14:04:33.960Z 2026-01-22T15:02:30.545Z
9206556 9206556 20260114174109_uNDlQ AU000D 2026-01-16T14:04:27.180Z 2026-01-22T15:02:29.752Z
9206519 9206519 20260114172555_5AKLG AU000D 2026-01-16T14:04:18.260Z 2026-01-22T15:02:28.812Z
9206494 9206494 20260114171543_TiggG AU000D 2026-01-16T14:04:12.293Z 2026-01-22T15:02:27.934Z
9206465 9206465 20260114170040_W4MoT AU000D 2026-01-16T14:04:03.469Z 2026-01-22T15:02:26.774Z
9206444 9206444 20260114165156_Y2fcX AU000D 2026-01-16T14:03:55.885Z 2026-01-22T15:02:25.938Z
9206405 9206405 20260114163915_ucIzx AU000D 2026-01-16T14:03:45.001Z 2026-01-22T15:02:24.060Z

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