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

9,558 rows where station_code = "AU000B" 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
9258040 9258040 20260125181337_AL6vN AU000B 2026-01-26T14:09:13.800Z 2026-01-29T14:37:59.675Z
9257998 9257998 20260125174656_M0SFe AU000B 2026-01-26T14:09:02.973Z 2026-01-29T14:37:57.009Z
9257720 9257720 20260125154129_wShKh AU000B 2026-01-26T14:07:27.395Z 2026-01-29T14:37:36.954Z
9257674 9257674 20260125152431_u3rCy AU000B 2026-01-26T14:07:12.518Z 2026-01-29T14:37:34.453Z
9257569 9257569 20260125144301_t2yyw AU000B 2026-01-26T14:06:27.169Z 2026-01-29T14:37:28.244Z
9253976 9253976 20260124172805_NxN7y AU000B 2026-01-25T14:05:18.125Z 2026-01-29T14:42:14.577Z
9253974 9253974 20260124172740_smcdX AU000B 2026-01-25T14:05:17.367Z 2026-01-29T14:42:14.239Z
9253807 9253807 20260124145635_IQW2P AU000B 2026-01-25T14:04:31.018Z 2026-01-29T14:41:32.944Z
9253618 9253618 20260124130925_nTqIc AU000B 2026-01-25T14:03:36.014Z 2026-01-29T14:41:04.392Z
9253559 9253559 20260124124713_O8sHg AU000B 2026-01-25T14:03:20.157Z 2026-01-29T14:40:57.755Z
9250561 9250561 20260123175541_hupY0 AU000B 2026-01-24T14:03:35.378Z 2026-01-29T14:46:04.657Z
9250548 9250548 20260123172524_2Ea5h AU000B 2026-01-24T14:03:31.728Z 2026-01-29T14:46:01.057Z
9250479 9250479 20260123153036_BK0Jx AU000B 2026-01-24T14:03:09.153Z 2026-01-29T14:45:38.065Z
9250451 9250451 20260123150800_y6pBm AU000B 2026-01-24T14:03:00.403Z 2026-01-29T14:45:35.906Z
9247214 9247214 20260121173621_ZZSUB AU000B 2026-01-23T14:09:25.702Z 2026-01-29T14:55:50.158Z
9247212 9247212 20260121173615_9Lkf0 AU000B 2026-01-23T14:09:25.137Z 2026-01-29T14:55:50.023Z
9247068 9247068 20260121164626_UAuWJ AU000B 2026-01-23T14:08:57.653Z 2026-01-29T14:55:41.092Z
9247045 9247045 20260121162755_H96H5 AU000B 2026-01-23T14:08:53.999Z 2026-01-29T14:55:39.779Z
9246971 9246971 20260121155457_Xw7di AU000B 2026-01-23T14:08:37.646Z 2026-01-29T14:55:33.866Z
9246938 9246938 20260121154245_m8K37 AU000B 2026-01-23T14:08:32.354Z 2026-01-29T14:55:21.262Z
9246927 9246927 20260121153913_aGC8B AU000B 2026-01-23T14:08:30.077Z 2026-01-29T14:55:20.573Z
9246864 9246864 20260121150617_Djnts AU000B 2026-01-23T14:08:09.290Z 2026-01-29T14:55:15.182Z
9246811 9246811 20260121144704_UOGp9 AU000B 2026-01-23T14:08:01.897Z 2026-01-29T14:55:12.853Z
9246099 9246099 20260122164611_wsM1k AU000B 2026-01-23T14:04:45.505Z 2026-01-29T14:50:44.445Z
9246066 9246066 20260122162200_H3nmm AU000B 2026-01-23T14:04:39.078Z 2026-01-29T14:50:41.323Z
9246043 9246043 20260122161157_2Ekdz AU000B 2026-01-23T14:04:34.628Z 2026-01-29T14:50:39.432Z
9246007 9246007 20260122155901_4nZVh AU000B 2026-01-23T14:04:20.136Z 2026-01-23T14:04:20.136Z
9245838 9245838 20260122145343_MvlMl AU000B 2026-01-23T14:03:39.872Z 2026-01-29T14:50:16.540Z
9245834 9245834 20260122144932_5uUx5 AU000B 2026-01-23T14:03:39.030Z 2026-01-29T14:50:15.986Z
9245722 9245722 20260122140159_f4ytO AU000B 2026-01-23T14:03:09.269Z 2026-01-29T14:49:59.950Z
9245673 9245673 20260122134050_n8KYv AU000B 2026-01-23T14:02:56.855Z 2026-01-29T14:49:56.521Z
9245542 9245542 20260122125756_6Ie37 AU000B 2026-01-23T14:02:20.359Z 2026-01-29T14:49:45.976Z
9245501 9245501 20260122124808_0YHeD AU000B 2026-01-23T14:02:14.068Z 2026-01-29T14:49:44.435Z
9245282 9245282 20260122113615_IaRL2 AU000B 2026-01-23T14:01:19.909Z 2026-01-29T14:49:20.985Z
9233517 9233517 20260120174102_2QLnC AU000B 2026-01-21T14:06:07.329Z 2026-01-29T15:01:53.616Z
9233504 9233504 20260120163211_l3kko AU000B 2026-01-21T14:06:03.290Z 2026-01-29T15:01:28.826Z
9233457 9233457 20260120154221_FM6Xj AU000B 2026-01-21T14:05:50.760Z 2026-01-29T15:01:20.442Z
9233329 9233329 20260120144503_lTk7x AU000B 2026-01-21T14:05:23.205Z 2026-01-29T15:01:00.793Z
9232924 9232924 20260120125153_nPWqj AU000B 2026-01-21T14:03:48.495Z 2026-01-29T15:00:26.211Z
9221610 9221610 20260118165955_gpYn3 AU000B 2026-01-19T14:08:32.238Z 2026-01-27T15:00:40.330Z
9220354 9220354 20260118124138_oNYc7 AU000B 2026-01-19T14:03:55.034Z 2026-01-27T14:59:02.679Z
9217337 9217337 20260117174834_3bQsr AU000B 2026-01-18T14:05:25.192Z 2026-01-26T15:00:35.236Z
9216834 9216834 20260117130752_f7nm0 AU000B 2026-01-18T14:02:52.903Z 2026-01-26T14:59:31.813Z
9216580 9216580 20260117121456_ygnk4 AU000B 2026-01-18T14:01:26.022Z 2026-01-26T14:59:19.318Z
9206281 9206281 20260114152322_3bCCU AU000B 2026-01-16T14:03:05.414Z 2026-01-22T15:01:57.775Z
9206099 9206099 20260114131006_PSnGD AU000B 2026-01-16T14:02:03.094Z 2026-01-22T15:01:48.361Z
9187599 9187599 20260111175031_Miujc AU000B 2026-01-13T14:07:58.265Z 2026-01-20T15:20:34.721Z
9187156 9187156 20260111152802_v5uFV AU000B 2026-01-13T14:05:48.377Z 2026-01-20T15:20:03.922Z
9186874 9186874 20260112171922_4uNr2 AU000B 2026-01-13T14:03:51.504Z 2026-01-21T15:03:25.727Z
9128581 9128581 20260102180124_cL0Jt AU000B 2026-01-03T14:16:23.551Z 2026-01-09T14:51:10.161Z
9125310 9125310 20251231172902_VlwMx AU000B 2026-01-02T14:54:53.345Z 2026-01-08T15:15:25.077Z
9125284 9125284 20251231172550_bNeoH AU000B 2026-01-02T14:54:50.329Z 2026-01-08T15:15:23.718Z
9125230 9125230 20251231171158_QCxJQ AU000B 2026-01-02T14:54:34.678Z 2026-01-08T15:15:19.485Z
9125140 9125140 20251231164711_BkcNF AU000B 2026-01-02T14:54:19.528Z 2026-01-08T15:15:14.267Z
9125094 9125094 20251231163334_3jJtI AU000B 2026-01-02T14:54:13.121Z 2026-01-08T15:15:11.279Z
9125009 9125009 20251231161005_uqnkq AU000B 2026-01-02T14:53:57.985Z 2026-01-08T15:15:06.760Z
9124832 9124832 20251231151104_Lckkf AU000B 2026-01-02T14:52:58.381Z 2026-01-08T15:14:39.503Z
9124795 9124795 20251231144556_v3h1x AU000B 2026-01-02T14:52:37.793Z 2026-01-08T15:14:25.541Z
9123087 9123087 20260101173707_bz1yE AU000B 2026-01-02T14:16:36.183Z 2026-01-09T14:54:21.749Z
9123068 9123068 20260101171510_FV6fZ AU000B 2026-01-02T14:16:31.122Z 2026-01-09T14:54:19.654Z
9123050 9123050 20260101164906_PCYTt AU000B 2026-01-02T14:16:25.753Z 2026-01-09T14:54:18.612Z
9123037 9123037 20260101164132_4WX1k AU000B 2026-01-02T14:16:20.598Z 2026-01-09T14:54:17.380Z
9123029 9123029 20260101161916_BEXOF AU000B 2026-01-02T14:16:15.457Z 2026-01-09T14:54:08.668Z
9123017 9123017 20260101160714_zehHE AU000B 2026-01-02T14:16:12.007Z 2026-01-09T14:54:07.917Z
9122886 9122886 20260101150104_xIf7K AU000B 2026-01-02T14:15:38.789Z 2026-01-09T14:54:00.274Z
9107367 9107367 20251229153142_GaiQ7 AU000B 2025-12-31T14:40:42.253Z 2026-01-06T15:20:43.017Z
9107269 9107269 20251229145953_9gyq4 AU000B 2025-12-31T14:40:17.497Z 2026-01-06T15:20:24.134Z
9107260 9107260 20251229145231_rl23G AU000B 2025-12-31T14:40:15.215Z 2026-01-06T15:20:23.066Z
9107169 9107169 20251229141242_2Ue5D AU000B 2025-12-31T14:39:51.798Z 2026-01-06T15:20:16.136Z
9097753 9097753 20251227172919_HHcWK AU000B 2025-12-30T15:09:15.985Z 2026-01-04T15:34:20.359Z
9097746 9097746 20251227172851_sewB4 AU000B 2025-12-30T15:09:15.693Z 2026-01-04T15:34:20.151Z
9097438 9097438 20251227163220_7zKQH AU000B 2025-12-30T15:08:41.752Z 2026-01-04T15:33:54.709Z
9097337 9097337 20251227160358_AhxYY AU000B 2025-12-30T15:08:33.564Z 2026-01-04T15:33:50.231Z
9097311 9097311 20251227155652_s6yKa AU000B 2025-12-30T15:08:32.033Z 2026-01-04T15:33:49.095Z
9097132 9097132 20251227153546_8O3k1 AU000B 2025-12-30T15:08:23.850Z 2026-01-04T15:33:43.844Z
9096904 9096904 20251227151633_NFtsj AU000B 2025-12-30T15:08:02.824Z 2025-12-30T15:08:02.824Z
9096014 9096014 20251227142441_lsN4u AU000B 2025-12-30T15:07:10.574Z 2026-01-04T15:32:51.656Z
9095987 9095987 20251227142248_RVA6f AU000B 2025-12-30T15:07:09.017Z 2025-12-30T15:07:09.017Z
9095538 9095538 20251227135502_qmqcb AU000B 2025-12-30T15:06:36.024Z 2026-01-04T15:32:36.626Z
9094639 9094639 20251227124356_Jo2Vo AU000B 2025-12-30T15:05:43.138Z 2026-01-04T15:31:59.805Z
9090881 9090881 20251228171248_kVCfa AU000B 2025-12-30T14:51:22.672Z 2026-01-05T15:13:43.192Z
9090856 9090856 20251228170512_cq2jW AU000B 2025-12-30T14:51:19.696Z 2026-01-05T15:13:40.313Z
9090763 9090763 20251228165017_d2x6A AU000B 2025-12-30T14:51:01.510Z 2026-01-05T15:13:37.786Z
9090759 9090759 20251228164914_3fBfX AU000B 2025-12-30T14:51:01.249Z 2026-01-05T15:13:37.710Z
9090746 9090746 20251228164430_pg2z2 AU000B 2025-12-30T14:50:59.936Z 2026-01-05T15:13:37.079Z
9090640 9090640 20251228160051_UdJaz AU000B 2025-12-30T14:50:48.275Z 2026-01-05T15:13:32.472Z
9090631 9090631 20251228155741_4WciW AU000B 2025-12-30T14:50:46.898Z 2026-01-05T15:13:32.136Z
9090625 9090625 20251228155522_v7sRk AU000B 2025-12-30T14:50:46.022Z 2026-01-05T15:13:31.795Z
9090593 9090593 20251228154554_jyGcc AU000B 2025-12-30T14:50:34.130Z 2026-01-05T15:13:30.749Z
9090561 9090561 20251228153533_NSrU3 AU000B 2025-12-30T14:50:30.763Z 2026-01-05T15:13:29.725Z
9090399 9090399 20251228150724_crMWr AU000B 2025-12-30T14:50:15.154Z 2026-01-05T15:13:09.868Z
9090185 9090185 20251228144225_5qF5h AU000B 2025-12-30T14:49:50.096Z 2026-01-05T15:13:03.290Z
9090042 9090042 20251228142823_7mMsd AU000B 2025-12-30T14:49:36.364Z 2025-12-31T14:55:33.293Z
9073489 9073489 20251225175035_A3CLr AU000B 2025-12-29T14:59:19.255Z 2026-01-02T15:47:51.997Z
9073281 9073281 20251225172055_BSn2N AU000B 2025-12-29T14:59:10.130Z 2026-01-02T15:47:48.383Z
9073279 9073279 20251225172043_LUOWq AU000B 2025-12-29T14:59:10.062Z 2026-01-02T15:47:48.283Z
9073258 9073258 20251225171832_z8BUx AU000B 2025-12-29T14:59:08.903Z 2026-01-02T15:47:47.930Z
9073111 9073111 20251225163846_YP3oO AU000B 2025-12-29T14:59:01.757Z 2025-12-29T14:59:01.757Z
9071071 9071071 20251226174925_3DAyL AU000B 2025-12-29T14:48:52.825Z 2026-01-03T15:42:27.663Z
9070961 9070961 20251226173528_W2PRx AU000B 2025-12-29T14:48:45.585Z 2026-01-03T15:42:20.657Z

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