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

159 rows where station_code = "AU004U" 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
9812388 9812388 20260427195839_PZN2x AU004U 2026-04-29T12:09:41.329Z 2026-04-29T12:24:06.944Z
9812364 9812364 20260427194326_13wG8 AU004U 2026-04-29T12:09:29.660Z 2026-04-29T12:24:06.927Z
9812299 9812299 20260427182054_cFcdr AU004U 2026-04-29T12:09:08.291Z 2026-04-29T12:24:06.874Z
9812241 9812241 20260427175656_zInmU AU004U 2026-04-29T12:08:54.338Z 2026-04-29T12:24:06.845Z
9809619 9809619 20260426133552_2Alxz AU004U 2026-04-28T12:33:31.574Z 2026-04-29T12:43:02.423Z
9805129 9805129 20260426173025_fsqPg AU004U 2026-04-28T12:05:20.640Z 2026-04-29T12:26:44.174Z
9805120 9805120 20260426172447_Y319A AU004U 2026-04-28T12:05:08.682Z 2026-04-29T12:26:42.620Z
9804941 9804941 20260426145244_bbT4v AU004U 2026-04-28T12:00:52.254Z 2026-04-29T12:24:18.440Z
9804937 9804937 20260426143657_5V7jb AU004U 2026-04-28T12:00:38.994Z 2026-04-29T12:24:16.234Z
9796648 9796648 20260425183021_F1XgH AU004U 2026-04-27T12:16:05.108Z 2026-04-29T12:37:36.357Z
9796490 9796490 20260425180435_N4eg0 AU004U 2026-04-27T12:15:32.347Z 2026-04-29T12:37:27.787Z
9795605 9795605 20260425171239_VFZeU AU004U 2026-04-27T12:13:01.126Z 2026-04-29T12:36:52.656Z
9795359 9795359 20260425165729_icOPB AU004U 2026-04-27T12:12:19.125Z 2026-04-29T12:36:45.222Z
9791221 9791221 20260424125242_cYUGw AU004U 2026-04-26T12:34:56.824Z 2026-04-29T13:00:05.364Z
9791205 9791205 20260424125210_dUaTR AU004U 2026-04-26T12:34:56.629Z 2026-04-29T13:00:03.893Z
9789230 9789230 20260424093000_5mW8q AU004U 2026-04-26T12:33:07.476Z 2026-04-29T12:59:06.140Z
9789110 9789110 20260424090403_t2dB7 AU004U 2026-04-26T12:32:30.777Z 2026-04-29T12:59:02.248Z
9782785 9782785 20260424195303_5RVV4 AU004U 2026-04-26T12:12:47.291Z 2026-04-29T12:46:51.784Z
9782779 9782779 20260424195108_977md AU004U 2026-04-26T12:12:46.669Z 2026-04-29T12:46:51.498Z
9782249 9782249 20260424182759_SqL1w AU004U 2026-04-26T12:11:28.323Z 2026-04-29T12:46:23.563Z
9782220 9782220 20260424182104_Xhh3o AU004U 2026-04-26T12:11:25.642Z 2026-04-29T12:46:22.566Z
9782208 9782208 20260424181951_VCgz9 AU004U 2026-04-26T12:11:24.161Z 2026-04-29T12:46:21.864Z
9781862 9781862 20260424175356_74MBb AU004U 2026-04-26T12:10:42.409Z 2026-04-29T12:46:03.324Z
9781735 9781735 20260424174351_GgaDH AU004U 2026-04-26T12:10:20.250Z 2026-04-29T12:45:58.223Z
9781433 9781433 20260424172613_3L4wK AU004U 2026-04-26T12:09:40.732Z 2026-04-29T12:45:50.429Z
9781285 9781285 20260424171943_Ah8iJ AU004U 2026-04-26T12:09:20.470Z 2026-04-29T12:45:47.212Z
9781156 9781156 20260424171048_eZeiN AU004U 2026-04-26T12:09:06.222Z 2026-04-29T12:45:30.417Z
9780984 9780984 20260424170236_Lv1Kw AU004U 2026-04-26T12:08:40.930Z 2026-04-29T12:45:27.070Z
9780974 9780974 20260424170145_DE36F AU004U 2026-04-26T12:08:38.031Z 2026-04-29T12:45:26.675Z
9780505 9780505 20260424163508_aa272 AU004U 2026-04-26T12:07:54.583Z 2026-04-29T12:45:15.205Z
9780298 9780298 20260424162251_zakmG AU004U 2026-04-26T12:07:24.891Z 2026-04-29T12:45:09.759Z
9779988 9779988 20260424160605_7M6kx AU004U 2026-04-26T12:06:59.664Z 2026-04-29T12:45:03.721Z
9779867 9779867 20260424155925_UXIDo AU004U 2026-04-26T12:06:32.677Z 2026-04-29T12:44:51.443Z
9779660 9779660 20260424154829_T0EVH AU004U 2026-04-26T12:06:19.250Z 2026-04-29T12:44:45.268Z
9778371 9778371 20260424144008_TU9bq AU004U 2026-04-26T12:03:33.105Z 2026-04-29T12:44:05.895Z
9778258 9778258 20260424143238_hDuXg AU004U 2026-04-26T12:03:10.098Z 2026-04-29T12:44:03.483Z
9777533 9777533 20260424134547_iH9Nm AU004U 2026-04-26T12:01:32.005Z 2026-04-29T12:43:35.199Z
9777496 9777496 20260424134420_bQhya AU004U 2026-04-26T12:01:19.847Z 2026-04-29T12:43:34.379Z
9776937 9776937 20260424131223_3QJ7b AU004U 2026-04-26T12:00:27.172Z 2026-04-29T12:43:14.783Z
9775056 9775056 20260423094201_BBZeQ AU004U 2026-04-25T12:55:45.547Z 2026-04-29T13:09:48.379Z
9763912 9763912 20260423193123_X91aw AU004U 2026-04-25T12:14:11.426Z 2026-04-29T12:54:25.585Z
9763682 9763682 20260423184854_b60D3 AU004U 2026-04-25T12:13:28.060Z 2026-04-29T12:54:19.547Z
9763598 9763598 20260423183329_oCpSW AU004U 2026-04-25T12:13:10.175Z 2026-04-29T12:54:18.223Z
9762420 9762420 20260423164400_Gb2Pb AU004U 2026-04-25T12:09:39.927Z 2026-04-29T12:53:37.632Z
9762073 9762073 20260423161018_nVwyT AU004U 2026-04-25T12:08:31.916Z 2026-04-29T12:53:31.627Z
9760656 9760656 20260423143227_W0z3b AU004U 2026-04-25T12:04:32.274Z 2026-04-29T12:52:51.635Z
9759257 9759257 20260422114237_kfSlG AU004U 2026-04-24T12:10:04.461Z 2026-04-29T13:17:22.582Z
9759076 9759076 20260422112136_w0Ui0 AU004U 2026-04-24T12:10:01.694Z 2026-04-29T13:17:08.021Z
9747749 9747749 20260422195702_gklyQ AU004U 2026-04-24T12:02:53.274Z 2026-04-29T13:02:42.895Z
9747730 9747730 20260422195215_DAi3p AU004U 2026-04-24T12:02:52.690Z 2026-04-29T13:02:42.491Z
9747706 9747706 20260422194114_uCDrI AU004U 2026-04-24T12:02:51.646Z 2026-04-29T13:02:41.840Z
9747602 9747602 20260422190824_M35hg AU004U 2026-04-24T12:02:47.121Z 2026-04-29T13:02:40.037Z
9747583 9747583 20260422185506_wFrsR AU004U 2026-04-24T12:02:45.893Z 2026-04-29T13:02:39.471Z
9747465 9747465 20260422181231_N9VMR AU004U 2026-04-24T12:02:42.083Z 2026-04-29T13:02:38.025Z
9747286 9747286 20260422175324_GL7w4 AU004U 2026-04-24T12:02:35.381Z 2026-04-29T13:02:35.869Z
9747280 9747280 20260422175236_r0uSQ AU004U 2026-04-24T12:02:34.815Z 2026-04-29T13:02:35.776Z
9746452 9746452 20260422170640_8EPj6 AU004U 2026-04-24T12:02:17.458Z 2026-04-29T13:02:29.489Z
9745508 9745508 20260422161406_9dAnm AU004U 2026-04-24T12:02:00.566Z 2026-04-29T13:01:43.690Z
9745506 9745506 20260422161406_dxL8S AU004U 2026-04-24T12:02:00.480Z 2026-04-29T13:01:43.632Z
9744738 9744738 20260422153102_ZpJI7 AU004U 2026-04-24T12:01:40.210Z 2026-04-29T13:01:34.981Z
9743982 9743982 20260422145156_56Yiv AU004U 2026-04-24T12:01:19.468Z 2026-04-29T13:01:27.974Z
9743530 9743530 20260422141904_CJLKK AU004U 2026-04-24T12:01:05.458Z 2026-04-29T13:01:10.357Z
9742269 9742269 20260422123414_ijuE8 AU004U 2026-04-24T12:00:25.254Z 2026-04-29T13:00:34.325Z
9742178 9742178 20260422122446_AfDpi AU004U 2026-04-24T12:00:22.508Z 2026-04-29T13:00:33.207Z
9731421 9731421 20260421173341_01P7P AU004U 2026-04-23T12:05:41.760Z 2026-04-29T13:11:48.566Z
9731395 9731395 20260421172451_jRHt1 AU004U 2026-04-23T12:05:35.559Z 2026-04-29T13:11:47.943Z
9731279 9731279 20260421164748_dmHrB AU004U 2026-04-23T12:04:57.414Z 2026-04-29T13:11:28.341Z
9731095 9731095 20260421154155_PBPCH AU004U 2026-04-23T12:03:59.195Z 2026-04-29T13:11:13.808Z
9730991 9730991 20260421150727_ygEv8 AU004U 2026-04-23T12:03:21.091Z 2026-04-29T13:11:09.290Z
9730823 9730823 20260421135306_tLom9 AU004U 2026-04-23T12:02:21.024Z 2026-04-29T13:11:05.622Z
9730792 9730792 20260421134055_TPeEx AU004U 2026-04-23T12:02:10.173Z 2026-04-29T13:11:04.931Z
9730779 9730779 20260421133118_woax3 AU004U 2026-04-23T12:02:05.839Z 2026-04-29T13:11:04.356Z
9721561 9721561 20260420090520_nAspv AU004U 2026-04-21T12:31:04.322Z 2026-04-28T13:39:49.066Z
9716567 9716567 20260419190450_sxlKv AU004U 2026-04-21T12:16:28.168Z 2026-04-28T13:36:07.427Z
9715801 9715801 20260419163703_Festg AU004U 2026-04-21T12:13:27.208Z 2026-04-28T13:35:33.749Z
9715291 9715291 20260419142820_MSXNj AU004U 2026-04-21T12:11:01.729Z 2026-04-28T13:34:46.950Z
9715158 9715158 20260419134711_8x7eJ AU004U 2026-04-21T12:10:21.262Z 2026-04-28T13:34:43.618Z
9715122 9715122 20260419133647_43W1h AU004U 2026-04-21T12:10:04.089Z 2026-04-28T13:34:42.546Z
9715058 9715058 20260419132550_Robic AU004U 2026-04-21T12:09:45.174Z 2026-04-28T13:34:40.487Z
9714832 9714832 20260419120612_pl3kL AU004U 2026-04-21T12:08:31.605Z 2026-04-28T13:34:08.739Z
9714013 9714013 20260420135553_Oc8Tl AU004U 2026-04-21T12:03:59.333Z 2026-04-29T13:17:54.294Z
9706817 9706817 20260418194342_pipCh AU004U 2026-04-20T12:11:48.283Z 2026-04-27T13:45:39.983Z
9706666 9706666 20260418184313_ObnFw AU004U 2026-04-20T12:11:00.629Z 2026-04-27T13:45:30.348Z
9706535 9706535 20260418175926_75SWc AU004U 2026-04-20T12:10:20.219Z 2026-04-27T13:45:25.423Z
9706434 9706434 20260418172011_fLjI7 AU004U 2026-04-20T12:09:47.601Z 2026-04-27T13:45:01.541Z
9706408 9706408 20260418171158_QJzUv AU004U 2026-04-20T12:09:43.296Z 2026-04-27T13:45:00.853Z
9706395 9706395 20260418170904_CiMD7 AU004U 2026-04-20T12:09:40.639Z 2026-04-27T13:45:00.284Z
9706224 9706224 20260418160746_IWMBR AU004U 2026-04-20T12:08:54.751Z 2026-04-27T13:44:50.969Z
9706145 9706145 20260418153137_jxOOv AU004U 2026-04-20T12:08:28.494Z 2026-04-27T13:44:47.293Z
9705997 9705997 20260418142120_borfN AU004U 2026-04-20T12:07:39.882Z 2026-04-27T13:44:40.583Z
9705939 9705939 20260418133904_p08x0 AU004U 2026-04-20T12:07:24.595Z 2026-04-27T13:44:23.916Z
9705875 9705875 20260418130409_egetR AU004U 2026-04-20T12:07:02.515Z 2026-04-27T13:44:18.830Z
9705856 9705856 20260418125532_StNI5 AU004U 2026-04-20T12:06:57.678Z 2026-04-27T13:44:17.445Z
9705808 9705808 20260418122616_vAKt2 AU004U 2026-04-20T12:06:36.762Z 2026-04-27T13:44:14.735Z
9705772 9705772 20260418114812_ZWHL5 AU004U 2026-04-20T12:06:28.324Z 2026-04-27T13:44:12.566Z
9705730 9705730 20260418110512_T5yh1 AU004U 2026-04-20T12:05:56.854Z 2026-04-27T13:43:50.150Z
9705707 9705707 20260418104313_F29C6 AU004U 2026-04-20T12:05:43.041Z 2026-04-27T13:43:44.004Z
9705659 9705659 20260418100227_pNYPy AU004U 2026-04-20T12:05:15.036Z 2026-04-27T13:43:35.221Z
9693952 9693952 20260416171502_61jl0 AU004U 2026-04-18T12:18:12.378Z 2026-04-25T13:56:59.774Z
9693753 9693753 20260416165923_GwV2G AU004U 2026-04-18T12:17:44.481Z 2026-04-25T13:56:53.601Z

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