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

2,441 rows where station_code = "AU0004" 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
9824681 9824681 20260429203835_i26eL AU0004 2026-05-01T12:05:32.653Z 2026-05-04T12:23:26.216Z
9804624 9804624 20260425130920_JVT2v AU0004 2026-04-27T12:52:09.096Z 2026-05-02T13:04:32.055Z
9804561 9804561 20260425130441_GiSgL AU0004 2026-04-27T12:52:05.776Z 2026-05-02T13:04:31.242Z
9804347 9804347 20260425124409_K23Wj AU0004 2026-04-27T12:51:40.030Z 2026-05-02T13:04:26.595Z
9804345 9804345 20260425124409_3MOOl AU0004 2026-04-27T12:51:39.740Z 2026-05-02T13:04:26.508Z
9804061 9804061 20260425121914_tuaKf AU0004 2026-04-27T12:51:15.669Z 2026-05-02T13:04:22.702Z
9803762 9803762 20260425114208_k4PNj AU0004 2026-04-27T12:50:36.871Z 2026-05-02T13:04:05.977Z
9797837 9797837 20260425214231_KL0xN AU0004 2026-04-27T12:21:03.120Z 2026-05-04T12:44:00.305Z
9797831 9797831 20260425214027_tRULT AU0004 2026-04-27T12:21:01.733Z 2026-05-04T12:44:00.084Z
9797824 9797824 20260425214000_Bk8py AU0004 2026-04-27T12:21:00.910Z 2026-05-04T12:43:59.978Z
9797379 9797379 20260425203652_CtXOu AU0004 2026-04-27T12:19:10.560Z 2026-05-04T12:43:31.659Z
9797162 9797162 20260425195902_foDX4 AU0004 2026-04-27T12:18:24.350Z 2026-05-04T12:43:26.021Z
9797154 9797154 20260425195621_QEm1q AU0004 2026-04-27T12:18:16.302Z 2026-05-04T12:43:25.764Z
9797148 9797148 20260425195431_ayytI AU0004 2026-04-27T12:18:14.829Z 2026-05-04T12:43:25.666Z
9797069 9797069 20260425193824_qwzoH AU0004 2026-04-27T12:17:58.358Z 2026-05-04T12:43:23.360Z
9797005 9797005 20260425193005_gmWC9 AU0004 2026-04-27T12:17:39.626Z 2026-05-04T12:43:21.097Z
9796761 9796761 20260425185311_U2hRs AU0004 2026-04-27T12:16:37.531Z 2026-05-04T12:42:57.632Z
9796562 9796562 20260425181923_ZtkZc AU0004 2026-04-27T12:15:41.319Z 2026-05-04T12:42:51.807Z
9796405 9796405 20260425175455_RDx5O AU0004 2026-04-27T12:15:09.015Z 2026-05-04T12:42:48.898Z
9796195 9796195 20260425174333_z3os6 AU0004 2026-04-27T12:14:38.093Z 2026-05-04T12:42:46.010Z
9795657 9795657 20260425171544_ySryu AU0004 2026-04-27T12:13:06.940Z 2026-05-04T12:42:20.479Z
9795237 9795237 20260425164848_uEW0S AU0004 2026-04-27T12:12:00.314Z 2026-05-04T12:42:11.511Z
9794934 9794934 20260425163108_Qdp2V AU0004 2026-04-27T12:11:08.780Z 2026-05-04T12:42:06.598Z
9793934 9793934 20260425151118_Paf0C AU0004 2026-04-27T12:08:06.165Z 2026-05-04T12:41:31.221Z
9793417 9793417 20260425143619_CW71j AU0004 2026-04-27T12:06:37.273Z 2026-05-04T12:41:22.913Z
9791081 9791081 20260424124331_iVwk7 AU0004 2026-04-26T12:34:54.600Z 2026-05-02T13:14:40.769Z
9790811 9790811 20260424122343_PQpE9 AU0004 2026-04-26T12:34:48.742Z 2026-05-02T13:14:37.751Z
9790432 9790432 20260424115018_uVlEb AU0004 2026-04-26T12:34:42.850Z 2026-05-02T13:14:30.650Z
9789933 9789933 20260424110902_KyrP5 AU0004 2026-04-26T12:33:47.492Z 2026-05-02T13:14:20.461Z
9783668 9783668 20260424213931_eQTjh AU0004 2026-04-26T12:15:11.087Z 2026-05-02T12:59:26.419Z
9783448 9783448 20260424212244_v2dDC AU0004 2026-04-26T12:14:50.145Z 2026-05-02T12:59:21.010Z
9783365 9783365 20260424211524_IcaqS AU0004 2026-04-26T12:14:35.921Z 2026-05-02T12:59:18.061Z
9783178 9783178 20260424205017_3Kizo AU0004 2026-04-26T12:14:00.904Z 2026-05-02T12:58:57.860Z
9782875 9782875 20260424200624_ZvD3L AU0004 2026-04-26T12:13:13.131Z 2026-05-02T12:58:43.968Z
9782873 9782873 20260424200527_Bjyqt AU0004 2026-04-26T12:13:12.725Z 2026-05-02T12:58:43.880Z
9782828 9782828 20260424200035_RMP9a AU0004 2026-04-26T12:12:53.312Z 2026-05-02T12:58:42.542Z
9782793 9782793 20260424195410_eFbU2 AU0004 2026-04-26T12:12:48.135Z 2026-05-02T12:58:41.641Z
9782726 9782726 20260424194340_lbWfw AU0004 2026-04-26T12:12:41.864Z 2026-05-02T12:58:39.256Z
9782567 9782567 20260424191735_NLfGr AU0004 2026-04-26T12:12:14.255Z 2026-05-02T12:58:31.416Z
9782458 9782458 20260424190352_qW3ba AU0004 2026-04-26T12:12:00.668Z 2026-05-02T12:58:14.050Z
9782304 9782304 20260424183748_1iEAT AU0004 2026-04-26T12:11:32.766Z 2026-05-02T12:58:07.044Z
9782145 9782145 20260424181317_VFeUQ AU0004 2026-04-26T12:11:19.278Z 2026-05-02T12:58:02.304Z
9782139 9782139 20260424181314_4Fyiy AU0004 2026-04-26T12:11:18.863Z 2026-05-02T12:58:02.045Z
9781777 9781777 20260424174715_xL27E AU0004 2026-04-26T12:10:22.623Z 2026-05-02T12:57:53.898Z
9781272 9781272 20260424171904_1Jfqa AU0004 2026-04-26T12:09:16.716Z 2026-05-02T12:57:22.874Z
9780862 9780862 20260424165643_okO0V AU0004 2026-04-26T12:08:31.380Z 2026-05-02T12:57:12.009Z
9779290 9779290 20260424152249_JzCbC AU0004 2026-04-26T12:05:16.993Z 2026-05-02T12:56:09.807Z
9779091 9779091 20260424151511_MfaEh AU0004 2026-04-26T12:04:59.165Z 2026-05-02T12:56:02.651Z
9778021 9778021 20260424141539_n7ZhW AU0004 2026-04-26T12:02:36.942Z 2026-05-02T12:55:24.576Z
9777518 9777518 20260424134455_rAdJz AU0004 2026-04-26T12:01:21.590Z 2026-05-02T12:55:00.092Z
9775945 9775945 20260423110025_kGywx AU0004 2026-04-25T12:57:22.225Z 2026-04-30T13:14:43.796Z
9772123 9772123 20260422124700_d36Az AU0004 2026-04-25T12:37:46.322Z 2026-04-30T13:04:59.731Z
9764062 9764062 20260423201101_CXSG4 AU0004 2026-04-25T12:14:50.618Z 2026-05-02T13:07:51.571Z
9763544 9763544 20260423182253_Nq55k AU0004 2026-04-25T12:13:02.179Z 2026-05-02T13:07:35.780Z
9763197 9763197 20260423173715_3veXC AU0004 2026-04-25T12:11:51.100Z 2026-05-02T13:07:07.446Z
9763017 9763017 20260423172613_eeLHX AU0004 2026-04-25T12:11:23.492Z 2026-05-02T13:07:05.486Z
9763007 9763007 20260423172610_axQlS AU0004 2026-04-25T12:11:22.470Z 2026-05-02T13:07:05.359Z
9762937 9762937 20260423171921_9Rp0C AU0004 2026-04-25T12:11:11.547Z 2026-05-02T13:07:02.342Z
9762662 9762662 20260423170145_Sqyw5 AU0004 2026-04-25T12:10:23.032Z 2026-05-02T13:06:57.412Z
9761211 9761211 20260423151407_4FGrm AU0004 2026-04-25T12:06:07.048Z 2026-05-02T13:06:01.269Z
9741833 9741833 20260421110246_fvYiL AU0004 2026-04-23T12:38:17.632Z 2026-04-29T13:23:11.157Z
9732733 9732733 20260421214224_I5tvX AU0004 2026-04-23T12:10:30.763Z 2026-04-30T13:17:02.740Z
9732627 9732627 20260421213420_Zdlyo AU0004 2026-04-23T12:10:09.998Z 2026-04-30T13:17:01.677Z
9732577 9732577 20260421212807_UXgaC AU0004 2026-04-23T12:10:03.537Z 2026-04-30T13:17:01.263Z
9732016 9732016 20260421203241_NFFTJ AU0004 2026-04-23T12:08:20.012Z 2026-04-30T13:16:55.180Z
9731904 9731904 20260421201439_irNEv AU0004 2026-04-23T12:07:52.362Z 2026-04-30T13:16:53.883Z
9731873 9731873 20260421200928_Puyj8 AU0004 2026-04-23T12:07:48.369Z 2026-04-30T13:16:53.588Z
9731869 9731869 20260421200854_19d0z AU0004 2026-04-23T12:07:47.906Z 2026-04-30T13:16:53.557Z
9731837 9731837 20260421200146_mXtbf AU0004 2026-04-23T12:07:41.496Z 2026-04-30T13:16:53.000Z
9731769 9731769 20260421194912_JPOru AU0004 2026-04-23T12:07:20.998Z 2026-04-30T13:16:52.189Z
9731734 9731734 20260421193245_kMns9 AU0004 2026-04-23T12:07:15.529Z 2026-04-30T13:16:51.817Z
9731728 9731728 20260421193032_qa17N AU0004 2026-04-23T12:07:14.649Z 2026-04-30T13:16:51.763Z
9731717 9731717 20260421192524_8lZoS AU0004 2026-04-23T12:07:12.742Z 2026-04-30T13:16:51.629Z
9731699 9731699 20260421191816_wD1sy AU0004 2026-04-23T12:07:09.345Z 2026-04-30T13:16:51.283Z
9731605 9731605 20260421184302_6qZhP AU0004 2026-04-23T12:06:43.417Z 2026-04-30T13:16:49.940Z
9731484 9731484 20260421175226_5sk2i AU0004 2026-04-23T12:06:10.508Z 2026-04-30T13:16:48.045Z
9731434 9731434 20260421173751_RYNXt AU0004 2026-04-23T12:05:48.160Z 2026-04-30T13:16:46.671Z
9731427 9731427 20260421173552_pD3hE AU0004 2026-04-23T12:05:45.624Z 2026-04-30T13:16:46.496Z
9731422 9731422 20260421173403_ZzTvS AU0004 2026-04-23T12:05:43.409Z 2026-04-30T13:16:46.418Z
9731374 9731374 20260421171619_FR9lS AU0004 2026-04-23T12:05:25.364Z 2026-04-30T13:16:45.149Z
9731325 9731325 20260421170343_vSGw9 AU0004 2026-04-23T12:05:13.187Z 2026-04-30T13:16:27.290Z
9731311 9731311 20260421170100_pG65o AU0004 2026-04-23T12:05:11.477Z 2026-04-30T13:16:25.792Z
9731309 9731309 20260421170042_7E4eQ AU0004 2026-04-23T12:05:10.892Z 2026-04-30T13:16:23.700Z
9731303 9731303 20260421165820_jH5Fc AU0004 2026-04-23T12:05:10.113Z 2026-04-30T13:16:23.394Z
9731297 9731297 20260421165631_WKFiM AU0004 2026-04-23T12:05:08.431Z 2026-04-30T13:16:22.219Z
9731214 9731214 20260421161814_BHdWx AU0004 2026-04-23T12:04:37.628Z 2026-04-30T13:16:00.325Z
9731176 9731176 20260421160245_Rgpar AU0004 2026-04-23T12:04:21.131Z 2026-04-30T13:15:59.697Z
9731135 9731135 20260421155036_K103b AU0004 2026-04-23T12:04:07.782Z 2026-04-30T13:15:58.946Z
9731133 9731133 20260421155026_cRFD9 AU0004 2026-04-23T12:04:07.015Z 2026-04-30T13:15:58.924Z
9731118 9731118 20260421154517_DkRt2 AU0004 2026-04-23T12:04:03.051Z 2026-04-30T13:15:58.639Z
9731037 9731037 20260421152837_cpdzm AU0004 2026-04-23T12:03:35.753Z 2026-04-30T13:15:57.256Z
9731008 9731008 20260421151826_riK6W AU0004 2026-04-23T12:03:25.946Z 2026-04-30T13:15:56.654Z
9731006 9731006 20260421151821_8QbxZ AU0004 2026-04-23T12:03:25.310Z 2026-04-30T13:15:56.609Z
9730998 9730998 20260421151615_d3kkd AU0004 2026-04-23T12:03:23.593Z 2026-04-30T13:15:56.484Z
9730745 9730745 20260421132216_LKLV7 AU0004 2026-04-23T12:01:51.142Z 2026-04-30T13:15:48.967Z
9730647 9730647 20260421122341_OYEbX AU0004 2026-04-23T12:01:14.899Z 2026-04-30T13:15:46.515Z
9730557 9730557 20260421112621_iVcfv AU0004 2026-04-23T12:00:43.957Z 2026-04-30T13:15:43.820Z
9730509 9730509 20260421111436_jolCM AU0004 2026-04-23T12:00:30.948Z 2026-04-30T13:15:22.298Z
9724170 9724170 20260420210910_6koWv AU0004 2026-04-22T12:13:28.943Z 2026-04-29T13:19:13.358Z
9723968 9723968 20260420204817_ruqvJ AU0004 2026-04-22T12:12:51.788Z 2026-04-29T13:19:11.350Z

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