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 = "AU0002" 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
9628239 9628239 20260407202057_wGODj AU0002 2026-04-09T12:15:38.128Z 2026-04-11T12:19:26.260Z
9628086 9628086 20260407195045_H3vyJ AU0002 2026-04-09T12:15:12.991Z 2026-04-11T12:19:08.042Z
9628067 9628067 20260407194908_cIc8G AU0002 2026-04-09T12:15:10.125Z 2026-04-11T12:19:07.262Z
9627980 9627980 20260407191934_i5pjk AU0002 2026-04-09T12:14:41.378Z 2026-04-11T12:18:57.795Z
9627866 9627866 20260407181247_Jv0MS AU0002 2026-04-09T12:14:06.947Z 2026-04-11T12:18:38.753Z
9627799 9627799 20260407171545_gtuow AU0002 2026-04-09T12:13:40.881Z 2026-04-11T12:18:24.198Z
9627728 9627728 20260407155326_edtmh AU0002 2026-04-09T12:13:12.807Z 2026-04-11T12:18:05.288Z
9627723 9627723 20260407154613_61Gkf AU0002 2026-04-09T12:13:10.946Z 2026-04-11T12:18:04.201Z
9627626 9627626 20260407134708_jUz0D AU0002 2026-04-09T12:12:34.116Z 2026-04-11T12:17:36.761Z
9618178 9618178 20260407213458_D5kiZ AU0002 2026-04-08T12:06:32.506Z 2026-04-11T12:20:10.482Z
9618137 9618137 20260407202511_r29V4 AU0002 2026-04-08T12:06:21.598Z 2026-04-11T12:19:27.772Z
9618117 9618117 20260407200352_F3RtD AU0002 2026-04-08T12:06:11.537Z 2026-04-11T12:19:13.323Z
9618111 9618111 20260407195952_20CHT AU0002 2026-04-08T12:06:05.911Z 2026-04-11T12:19:11.013Z
9618087 9618087 20260407195336_Fjd4u AU0002 2026-04-08T12:06:01.311Z 2026-04-11T12:19:08.484Z
9618006 9618006 20260407185906_PCKjt AU0002 2026-04-08T12:05:35.469Z 2026-04-11T12:18:53.709Z
9617884 9617884 20260407175848_R6beq AU0002 2026-04-08T12:05:13.326Z 2026-04-11T12:18:34.971Z
9617823 9617823 20260407174257_Vj74b AU0002 2026-04-08T12:04:56.627Z 2026-04-11T12:18:31.080Z
9617677 9617677 20260407165340_5UP0Q AU0002 2026-04-08T12:04:26.487Z 2026-04-11T12:18:15.950Z
9617617 9617617 20260407160956_u8PJz AU0002 2026-04-08T12:04:07.128Z 2026-04-11T12:18:07.285Z
9617495 9617495 20260407152353_m6NhG AU0002 2026-04-08T12:03:49.264Z 2026-04-11T12:17:55.035Z
9617416 9617416 20260407143812_oD582 AU0002 2026-04-08T12:03:23.944Z 2026-04-11T12:17:44.325Z
9617316 9617316 20260407134708_wuXhk AU0002 2026-04-08T12:03:05.910Z 2026-04-11T12:17:36.880Z
9617289 9617289 20260407130320_qz9I4 AU0002 2026-04-08T12:02:48.126Z 2026-04-11T12:17:33.525Z
9617285 9617285 20260407130011_oHMZi AU0002 2026-04-08T12:02:46.686Z 2026-04-11T12:17:33.173Z
9613233 9613233 20260405120601_6FsKQ AU0002 2026-04-07T12:05:28.752Z 2026-04-11T12:32:18.106Z
9613193 9613193 20260406205613_fEAzs AU0002 2026-04-07T12:04:11.835Z 2026-04-11T12:26:45.767Z
9613187 9613187 20260406204153_W3JJU AU0002 2026-04-07T12:04:10.787Z 2026-04-11T12:26:39.626Z
9613179 9613179 20260406202806_VP3g3 AU0002 2026-04-07T12:04:09.343Z 2026-04-11T12:26:35.438Z
9613096 9613096 20260406192415_oxfkF AU0002 2026-04-07T12:03:47.933Z 2026-04-11T12:26:09.822Z
9613032 9613032 20260406185148_iTwEY AU0002 2026-04-07T12:03:37.633Z 2026-04-11T12:26:04.115Z
9613004 9613004 20260406183104_KhqfZ AU0002 2026-04-07T12:03:30.530Z 2026-04-11T12:26:01.717Z
9612976 9612976 20260406181411_sgXua AU0002 2026-04-07T12:03:23.597Z 2026-04-11T12:25:59.404Z
9612847 9612847 20260406171711_2GTKx AU0002 2026-04-07T12:03:03.272Z 2026-04-11T12:25:46.306Z
9612841 9612841 20260406171203_rdX7x AU0002 2026-04-07T12:03:02.578Z 2026-04-11T12:25:45.939Z
9612795 9612795 20260406163538_ht8WS AU0002 2026-04-07T12:02:49.907Z 2026-04-11T12:25:44.235Z
9610691 9610691 20260404211340_IELqq AU0002 2026-04-06T12:10:44.551Z 2026-04-11T12:37:21.449Z
9610281 9610281 20260405154701_jWCsx AU0002 2026-04-06T12:06:50.998Z 2026-04-11T12:32:38.762Z
9610170 9610170 20260405140934_SkOGD AU0002 2026-04-06T12:06:08.555Z 2026-04-11T12:32:32.604Z
9610120 9610120 20260405131209_p2djD AU0002 2026-04-06T12:05:54.096Z 2026-04-11T12:32:21.571Z
9610084 9610084 20260405124703_NOXMG AU0002 2026-04-06T12:05:38.140Z 2026-04-11T12:32:19.883Z
9609933 9609933 20260405111725_OcpCM AU0002 2026-04-06T12:04:49.975Z 2026-04-11T12:32:09.070Z
9608005 9608005 20260403154529_mje2r AU0002 2026-04-05T12:07:13.269Z 2026-04-11T12:39:49.795Z
9607983 9607983 20260404212531_S3dDg AU0002 2026-04-05T12:05:17.703Z 2026-04-11T12:37:23.003Z
9607976 9607976 20260404211001_COiJm AU0002 2026-04-05T12:05:16.029Z 2026-04-11T12:37:20.833Z
9607971 9607971 20260404204902_RJGgT AU0002 2026-04-05T12:05:14.590Z 2026-04-11T12:37:05.621Z
9606775 9606775 20260402205745_Orts9 AU0002 2026-04-04T12:11:36.803Z 2026-04-11T12:43:26.970Z
9606750 9606750 20260402201326_kEUbs AU0002 2026-04-04T12:11:25.495Z 2026-04-11T12:43:23.611Z
9606732 9606732 20260402195304_71Net AU0002 2026-04-04T12:11:18.326Z 2026-04-11T12:43:22.452Z
9606605 9606605 20260403213829_KOyRj AU0002 2026-04-04T12:07:39.880Z 2026-04-11T12:40:46.793Z
9606581 9606581 20260403205334_Tl4uI AU0002 2026-04-04T12:07:34.169Z 2026-04-11T12:40:33.563Z
9606569 9606569 20260403204610_dakj6 AU0002 2026-04-04T12:07:31.898Z 2026-04-11T12:40:32.741Z
9606565 9606565 20260403203819_u0YQq AU0002 2026-04-04T12:07:30.663Z 2026-04-11T12:40:32.180Z
9606551 9606551 20260403203146_pVK3g AU0002 2026-04-04T12:07:28.056Z 2026-04-11T12:40:31.469Z
9606521 9606521 20260403200035_HdIBP AU0002 2026-04-04T12:07:17.243Z 2026-04-11T12:40:28.270Z
9606508 9606508 20260403195526_9ZSIA AU0002 2026-04-04T12:07:12.582Z 2026-04-11T12:40:25.752Z
9606490 9606490 20260403193705_Ja9BY AU0002 2026-04-04T12:07:08.311Z 2026-04-11T12:40:24.540Z
9606472 9606472 20260403192126_MXbw3 AU0002 2026-04-04T12:07:04.883Z 2026-04-11T12:40:23.501Z
9606465 9606465 20260403191845_GjXgM AU0002 2026-04-04T12:07:03.948Z 2026-04-11T12:40:23.074Z
9606453 9606453 20260403190846_oqPUW AU0002 2026-04-04T12:07:01.306Z 2026-04-11T12:40:21.993Z
9606435 9606435 20260403185448_BJwMM AU0002 2026-04-04T12:06:52.293Z 2026-04-11T12:40:19.467Z
9606421 9606421 20260403183452_WGhGr AU0002 2026-04-04T12:06:48.161Z 2026-04-11T12:40:17.713Z
9606418 9606418 20260403182210_FgI64 AU0002 2026-04-04T12:06:47.701Z 2026-04-11T12:40:16.944Z
9606413 9606413 20260403181921_yHcIg AU0002 2026-04-04T12:06:46.865Z 2026-04-11T12:40:16.424Z
9606403 9606403 20260403181413_NTIIx AU0002 2026-04-04T12:06:44.576Z 2026-04-11T12:40:15.910Z
9606399 9606399 20260403181221_3acPE AU0002 2026-04-04T12:06:43.632Z 2026-04-11T12:40:15.597Z
9606331 9606331 20260403170703_IcxVd AU0002 2026-04-04T12:06:25.770Z 2026-04-11T12:40:11.551Z
9606202 9606202 20260403161728_nbC1g AU0002 2026-04-04T12:05:57.598Z 2026-04-11T12:39:55.059Z
9606021 9606021 20260403142352_3qrCG AU0002 2026-04-04T12:04:59.730Z 2026-04-11T12:39:42.108Z
9605767 9605767 20260403115830_QFKI3 AU0002 2026-04-04T12:03:51.021Z 2026-04-11T12:39:22.075Z
9604513 9604513 20260402212237_gqbsf AU0002 2026-04-03T12:07:52.095Z 2026-04-11T12:43:28.421Z
9604511 9604511 20260402211844_7Cx4z AU0002 2026-04-03T12:07:51.543Z 2026-04-11T12:43:28.149Z
9604507 9604507 20260402205627_N6Ujv AU0002 2026-04-03T12:07:50.415Z 2026-04-11T12:43:26.659Z
9604461 9604461 20260402194159_VTYKR AU0002 2026-04-03T12:07:34.251Z 2026-04-11T12:43:21.927Z
9604453 9604453 20260402192941_sONVS AU0002 2026-04-03T12:07:32.405Z 2026-04-03T12:07:32.405Z
9604433 9604433 20260402185746_jidiS AU0002 2026-04-03T12:07:24.380Z 2026-04-11T12:43:19.890Z
9604311 9604311 20260402170525_63gDE AU0002 2026-04-03T12:06:50.307Z 2026-04-11T12:43:12.974Z
9604217 9604217 20260402163951_YtyTe AU0002 2026-04-03T12:06:24.983Z 2026-04-11T12:43:09.968Z
9602390 9602390 20260331204600_6a9CJ AU0002 2026-04-02T12:08:39.617Z 2026-04-09T12:48:09.423Z
9602285 9602285 20260331190002_U4FfD AU0002 2026-04-02T12:08:07.168Z 2026-04-09T12:48:06.216Z
9602190 9602190 20260401212707_n13NS AU0002 2026-04-02T12:05:15.642Z 2026-04-10T12:36:21.074Z
9602185 9602185 20260401212649_3JEk6 AU0002 2026-04-02T12:05:14.557Z 2026-04-10T12:36:20.995Z
9602183 9602183 20260401211655_VsOKS AU0002 2026-04-02T12:05:13.960Z 2026-04-10T12:36:20.882Z
9602141 9602141 20260401203141_mbTMH AU0002 2026-04-02T12:05:05.361Z 2026-04-10T12:36:19.530Z
9602109 9602109 20260401193408_3X0v2 AU0002 2026-04-02T12:04:55.848Z 2026-04-10T12:36:18.315Z
9602107 9602107 20260401193339_6NVHb AU0002 2026-04-02T12:04:55.266Z 2026-04-10T12:36:18.023Z
9602063 9602063 20260401190258_1I4Fq AU0002 2026-04-02T12:04:43.143Z 2026-04-10T12:36:02.702Z
9602023 9602023 20260401180314_8Q03Q AU0002 2026-04-02T12:04:34.244Z 2026-04-10T12:35:54.309Z
9601580 9601580 20260401155526_E02fz AU0002 2026-04-02T12:03:11.634Z 2026-04-10T12:35:41.660Z
9601357 9601357 20260401145022_IeNMx AU0002 2026-04-02T12:02:32.161Z 2026-04-10T12:35:37.645Z
9600178 9600178 20260331213558_YBL20 AU0002 2026-04-01T12:06:18.284Z 2026-04-09T12:48:11.352Z
9600170 9600170 20260331212344_8AeF2 AU0002 2026-04-01T12:06:16.644Z 2026-04-09T12:48:11.074Z
9600166 9600166 20260331211436_07nIa AU0002 2026-04-01T12:06:15.496Z 2026-04-09T12:48:10.614Z
9600150 9600150 20260331205431_GYrST AU0002 2026-04-01T12:06:12.009Z 2026-04-09T12:48:09.927Z
9600122 9600122 20260331201452_2CdjH AU0002 2026-04-01T12:06:04.799Z 2026-04-09T12:48:08.468Z
9600091 9600091 20260331192546_hUR99 AU0002 2026-04-01T12:05:56.797Z 2026-04-01T12:05:56.797Z
9600054 9600054 20260331185856_883hJ AU0002 2026-04-01T12:05:47.489Z 2026-04-09T12:48:06.042Z
9600043 9600043 20260331185459_J6L9t AU0002 2026-04-01T12:05:44.468Z 2026-04-09T12:48:05.843Z
9600041 9600041 20260331185421_p7buS AU0002 2026-04-01T12:05:42.585Z 2026-04-09T12:48:05.782Z
9600020 9600020 20260331182102_hqvh4 AU0002 2026-04-01T12:05:38.476Z 2026-04-09T12:48:05.174Z
9600008 9600008 20260331181035_Dm4MF AU0002 2026-04-01T12:05:35.417Z 2026-04-09T12:48:04.891Z

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