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,522 rows where station_code = "AU001Z" 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
9841279 9841279 20260502181007_XGFa1 AU001Z 2026-05-04T12:17:36.226Z 2026-05-04T12:17:36.226Z
9841214 9841214 20260502164102_mDWbl AU001Z 2026-05-04T12:16:29.999Z 2026-05-04T12:16:29.999Z
9841208 9841208 20260502163325_gLr1G AU001Z 2026-05-04T12:16:25.535Z 2026-05-04T12:16:25.535Z
9841197 9841197 20260502160554_5nOsQ AU001Z 2026-05-04T12:16:04.589Z 2026-05-04T12:16:04.589Z
9838546 9838546 20260502204752_38AOP AU001Z 2026-05-04T12:01:25.472Z 2026-05-04T12:09:56.143Z
9838445 9838445 20260502201956_GNChh AU001Z 2026-05-04T12:01:02.864Z 2026-05-04T12:09:56.107Z
9838330 9838330 20260502193726_b8sa3 AU001Z 2026-05-04T12:00:39.124Z 2026-05-04T12:09:56.050Z
9834368 9834368 20260501210645_E7xwl AU001Z 2026-05-03T12:01:46.548Z 2026-05-04T12:11:34.963Z
9834330 9834330 20260501205557_rrcku AU001Z 2026-05-03T12:01:38.467Z 2026-05-04T12:11:31.663Z
9824760 9824760 20260429211232_u3lBx AU001Z 2026-05-01T12:05:52.035Z 2026-05-04T12:23:29.671Z
9824720 9824720 20260429210456_sLHhb AU001Z 2026-05-01T12:05:41.236Z 2026-05-04T12:23:28.022Z
9797869 9797869 20260425214546_8pTKi AU001Z 2026-04-27T12:21:06.149Z 2026-05-04T12:44:00.821Z
9797561 9797561 20260425210436_d2Mmi AU001Z 2026-04-27T12:20:00.255Z 2026-05-04T12:43:36.586Z
9797345 9797345 20260425203121_GKjPC AU001Z 2026-04-27T12:19:03.470Z 2026-05-04T12:43:30.577Z
9797248 9797248 20260425201505_sb6Jn AU001Z 2026-04-27T12:18:42.897Z 2026-05-04T12:43:28.071Z
9797239 9797239 20260425201325_8W263 AU001Z 2026-04-27T12:18:41.432Z 2026-05-04T12:43:27.857Z
9797046 9797046 20260425193453_HLlni AU001Z 2026-04-27T12:17:55.278Z 2026-05-04T12:43:22.839Z
9797021 9797021 20260425193305_7Dlu8 AU001Z 2026-04-27T12:17:45.489Z 2026-05-04T12:43:22.271Z
9796876 9796876 20260425191611_MRqUJ AU001Z 2026-04-27T12:17:12.127Z 2026-05-04T12:43:03.020Z
9796802 9796802 20260425190203_yzsD8 AU001Z 2026-04-27T12:16:50.248Z 2026-05-04T12:43:01.069Z
9796637 9796637 20260425182845_y6AaY AU001Z 2026-04-27T12:16:02.678Z 2026-05-04T12:42:53.731Z
9796240 9796240 20260425174652_cGwc3 AU001Z 2026-04-27T12:14:49.642Z 2026-05-04T12:42:46.765Z
9796131 9796131 20260425173925_e3z5i AU001Z 2026-04-27T12:14:28.947Z 2026-05-04T12:42:44.882Z
9795285 9795285 20260425165156_NmIDm AU001Z 2026-04-27T12:12:10.703Z 2026-05-04T12:42:12.168Z
9783696 9783696 20260424214253_74LSG AU001Z 2026-04-26T12:15:26.190Z 2026-05-02T12:59:27.816Z
9783191 9783191 20260424205307_Ts3zr AU001Z 2026-04-26T12:14:01.845Z 2026-05-02T12:58:58.104Z
9783078 9783078 20260424203830_YhKO3 AU001Z 2026-04-26T12:13:39.005Z 2026-05-02T12:58:55.466Z
9783046 9783046 20260424203353_QZMNi AU001Z 2026-04-26T12:13:32.889Z 2026-05-02T12:58:54.467Z
9782832 9782832 20260424200039_cx2Dh AU001Z 2026-04-26T12:12:53.672Z 2026-05-02T12:58:42.631Z
9782792 9782792 20260424195351_Qt0m8 AU001Z 2026-04-26T12:12:47.865Z 2026-05-02T12:58:41.543Z
9782788 9782788 20260424195322_JfqZx AU001Z 2026-04-26T12:12:47.579Z 2026-05-02T12:58:41.408Z
9782736 9782736 20260424194503_hft41 AU001Z 2026-04-26T12:12:42.505Z 2026-05-02T12:58:39.513Z
9782594 9782594 20260424192243_8aHkC AU001Z 2026-04-26T12:12:16.932Z 2026-05-02T12:58:33.011Z
9782290 9782290 20260424183323_6FavV AU001Z 2026-04-26T12:11:31.652Z 2026-05-02T12:58:06.598Z
9782286 9782286 20260424183146_0sMtI AU001Z 2026-04-26T12:11:30.860Z 2026-05-02T12:58:06.339Z
9782236 9782236 20260424182513_liNoT AU001Z 2026-04-26T12:11:27.149Z 2026-05-02T12:58:05.248Z
9781542 9781542 20260424173227_wntSL AU001Z 2026-04-26T12:09:51.201Z 2026-05-02T12:57:31.558Z
9781310 9781310 20260424172028_NxD5k AU001Z 2026-04-26T12:09:22.468Z 2026-05-02T12:57:23.784Z
9781099 9781099 20260424170804_CmT5i AU001Z 2026-04-26T12:09:02.743Z 2026-05-02T12:57:17.413Z
9778463 9778463 20260424144426_nv5PR AU001Z 2026-04-26T12:03:46.499Z 2026-05-02T12:55:37.116Z
9776976 9776976 20260424131440_6m7Jq AU001Z 2026-04-26T12:00:32.067Z 2026-05-02T12:54:48.731Z
9764211 9764211 20260423204138_PM1mZ AU001Z 2026-04-25T12:15:24.382Z 2026-05-02T13:07:54.337Z
9762593 9762593 20260423165723_Aua8k AU001Z 2026-04-25T12:10:09.149Z 2026-05-02T13:06:55.835Z
9762044 9762044 20260423160659_6OWLv AU001Z 2026-04-25T12:08:22.974Z 2026-05-02T13:06:17.174Z
9761681 9761681 20260423154452_UzEcd AU001Z 2026-04-25T12:07:18.196Z 2026-05-02T13:06:09.703Z
9761063 9761063 20260423150220_huPou AU001Z 2026-04-25T12:05:39.770Z 2026-05-02T13:05:58.525Z
9760608 9760608 20260423142912_zTtSl AU001Z 2026-04-25T12:04:15.750Z 2026-05-02T13:05:28.246Z
9748541 9748541 20260422212438_aO0oB AU001Z 2026-04-24T12:03:24.710Z 2026-04-30T13:07:44.995Z
9743220 9743220 20260422135236_dn2YO AU001Z 2026-04-24T12:00:56.007Z 2026-04-30T13:05:07.579Z
9743147 9743147 20260422134757_J800e AU001Z 2026-04-24T12:00:53.897Z 2026-04-30T13:05:06.994Z
9741939 9741939 20260422115446_J4MxJ AU001Z 2026-04-24T12:00:14.191Z 2026-04-30T13:04:30.126Z
9732085 9732085 20260421204142_HAGOJ AU001Z 2026-04-23T12:08:28.394Z 2026-04-30T13:16:55.967Z
9731798 9731798 20260421195522_xHJQ2 AU001Z 2026-04-23T12:07:27.163Z 2026-04-30T13:16:52.520Z
9731604 9731604 20260421184219_dAiO9 AU001Z 2026-04-23T12:06:43.039Z 2026-04-30T13:16:49.928Z
9731584 9731584 20260421183403_OvjPj AU001Z 2026-04-23T12:06:40.506Z 2026-04-30T13:16:49.717Z
9731568 9731568 20260421182827_cI0Ez AU001Z 2026-04-23T12:06:37.141Z 2026-04-30T13:16:49.443Z
9731548 9731548 20260421182118_OD2Vy AU001Z 2026-04-23T12:06:33.970Z 2026-04-30T13:16:49.254Z
9731386 9731386 20260421172256_JqdCM AU001Z 2026-04-23T12:05:27.636Z 2026-04-30T13:16:45.438Z
9731377 9731377 20260421171851_cJ8R3 AU001Z 2026-04-23T12:05:26.165Z 2026-04-30T13:16:45.242Z
9731228 9731228 20260421162119_E4V7R AU001Z 2026-04-23T12:04:41.967Z 2026-04-30T13:16:00.581Z
9731077 9731077 20260421153724_65rVW AU001Z 2026-04-23T12:03:55.976Z 2026-04-30T13:15:58.112Z
9731003 9731003 20260421151747_dIhlb AU001Z 2026-04-23T12:03:24.115Z 2026-04-30T13:15:56.519Z
9730895 9730895 20260421142355_WFwOO AU001Z 2026-04-23T12:02:47.493Z 2026-04-30T13:15:52.373Z
9730879 9730879 20260421141231_iNayG AU001Z 2026-04-23T12:02:42.476Z 2026-04-30T13:15:51.917Z
9730712 9730712 20260421130229_MqZ6Z AU001Z 2026-04-23T12:01:39.442Z 2026-04-30T13:15:48.039Z
9730704 9730704 20260421130041_hTPUP AU001Z 2026-04-23T12:01:38.198Z 2026-04-30T13:15:47.964Z
9730664 9730664 20260421123704_2FOYh AU001Z 2026-04-23T12:01:26.409Z 2026-04-30T13:15:46.947Z
9724379 9724379 20260420213613_061ll AU001Z 2026-04-22T12:14:02.769Z 2026-04-29T13:19:15.722Z
9724252 9724252 20260420211848_HqCDI AU001Z 2026-04-22T12:13:44.052Z 2026-04-29T13:19:14.344Z
9724133 9724133 20260420210516_2ancc AU001Z 2026-04-22T12:13:20.599Z 2026-04-29T13:19:12.875Z
9723620 9723620 20260420194105_eoY42 AU001Z 2026-04-22T12:11:20.899Z 2026-04-29T13:19:05.862Z
9723591 9723591 20260420193705_cdIPh AU001Z 2026-04-22T12:11:17.807Z 2026-04-29T13:19:05.618Z
9723417 9723417 20260420184836_3rpDp AU001Z 2026-04-22T12:10:38.396Z 2026-04-29T13:19:03.184Z
9717287 9717287 20260419212455_1xDx3 AU001Z 2026-04-21T12:19:19.785Z 2026-04-28T13:37:06.912Z
9717227 9717227 20260419211735_3pqst AU001Z 2026-04-21T12:19:05.547Z 2026-04-28T13:37:06.070Z
9717151 9717151 20260419211123_1NmUJ AU001Z 2026-04-21T12:18:53.375Z 2026-04-28T13:37:04.840Z
9717126 9717126 20260419210408_Zia8i AU001Z 2026-04-21T12:18:49.005Z 2026-04-28T13:37:04.402Z
9717021 9717021 20260419204843_iuyit AU001Z 2026-04-21T12:18:24.577Z 2026-04-28T13:37:02.568Z
9717016 9717016 20260419204832_udVwX AU001Z 2026-04-21T12:18:24.126Z 2026-04-28T13:37:02.489Z
9716961 9716961 20260419203721_hJwDG AU001Z 2026-04-21T12:18:09.125Z 2026-04-28T13:37:00.767Z
9716895 9716895 20260419202615_lPYbR AU001Z 2026-04-21T12:17:54.749Z 2026-04-28T13:36:48.655Z
9716759 9716759 20260419194638_xBTPg AU001Z 2026-04-21T12:17:18.861Z 2026-04-28T13:36:13.938Z
9716738 9716738 20260419194505_MjLyd AU001Z 2026-04-21T12:17:08.557Z 2026-04-28T13:36:13.451Z
9716662 9716662 20260419193058_BcB09 AU001Z 2026-04-21T12:16:53.210Z 2026-04-28T13:36:11.793Z
9716551 9716551 20260419190008_ozO33 AU001Z 2026-04-21T12:16:26.016Z 2026-04-28T13:36:06.216Z
9716525 9716525 20260419185614_N3Q5E AU001Z 2026-04-21T12:16:20.587Z 2026-04-28T13:36:05.697Z
9716493 9716493 20260419184441_yee55 AU001Z 2026-04-21T12:16:06.272Z 2026-04-28T13:36:04.953Z
9716112 9716112 20260419173612_qmtxe AU001Z 2026-04-21T12:14:49.343Z 2026-04-28T13:35:57.851Z
9716110 9716110 20260419173611_4cA12 AU001Z 2026-04-21T12:14:48.811Z 2026-04-28T13:35:57.817Z
9715507 9715507 20260419152735_uBonN AU001Z 2026-04-21T12:12:09.393Z 2026-04-28T13:34:57.443Z
9715503 9715503 20260419152604_iKOBa AU001Z 2026-04-21T12:12:08.535Z 2026-04-28T13:34:57.267Z
9715437 9715437 20260419151253_B8a4k AU001Z 2026-04-21T12:11:50.532Z 2026-04-28T13:34:55.774Z
9715350 9715350 20260419145431_zes8J AU001Z 2026-04-21T12:11:22.603Z 2026-04-28T13:34:49.158Z
9715202 9715202 20260419140301_fkecr AU001Z 2026-04-21T12:10:35.653Z 2026-04-28T13:34:44.990Z
9715085 9715085 20260419132936_E67xV AU001Z 2026-04-21T12:09:51.767Z 2026-04-28T13:34:41.303Z
9714728 9714728 20260419110209_Wn957 AU001Z 2026-04-21T12:07:45.536Z 2026-04-28T13:33:43.462Z
9707024 9707024 20260418204353_tM2Xg AU001Z 2026-04-20T12:12:35.422Z 2026-04-27T13:46:06.737Z
9706845 9706845 20260418195542_PgFh7 AU001Z 2026-04-20T12:11:54.190Z 2026-04-27T13:45:41.402Z
9706766 9706766 20260418192038_Ildis AU001Z 2026-04-20T12:11:27.553Z 2026-04-27T13:45:35.370Z
9706590 9706590 20260418181821_UO248 AU001Z 2026-04-20T12:10:43.554Z 2026-04-27T13:45:27.469Z

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