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

4,284 rows where station_code = "AU000T" 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
9270105 9270105 20260128145704_Z98cc AU000T 2026-01-29T14:10:51.621Z 2026-01-29T14:10:51.621Z
9270098 9270098 20260128145443_U8e33 AU000T 2026-01-29T14:10:50.028Z 2026-01-29T14:10:50.028Z
9269306 9269306 20260128130020_P1Wh5 AU000T 2026-01-29T14:07:25.916Z 2026-01-29T14:07:25.916Z
9268950 9268950 20260128114702_O5ncv AU000T 2026-01-29T14:05:41.169Z 2026-01-29T14:05:41.169Z
9266125 9266125 20260127172821_Z2n8d AU000T 2026-01-28T14:12:30.015Z 2026-01-29T14:30:24.887Z
9266079 9266079 20260127171208_m61Wb AU000T 2026-01-28T14:12:21.468Z 2026-01-29T14:30:24.848Z
9265737 9265737 20260127155520_Fdakm AU000T 2026-01-28T14:11:12.151Z 2026-01-29T14:30:24.666Z
9265720 9265720 20260127155310_zz3j2 AU000T 2026-01-28T14:11:08.243Z 2026-01-29T14:30:24.661Z
9265616 9265616 20260127153947_amASt AU000T 2026-01-28T14:10:44.471Z 2026-01-29T14:30:24.623Z
9265270 9265270 20260127145309_XJOAR AU000T 2026-01-28T14:09:42.829Z 2026-01-29T14:30:24.518Z
9264740 9264740 20260127130502_228qu AU000T 2026-01-28T14:07:26.373Z 2026-01-29T14:30:24.267Z
9264470 9264470 20260127122847_goKq2 AU000T 2026-01-28T14:06:16.317Z 2026-01-29T14:30:24.179Z
9264334 9264334 20260127120135_lhPw9 AU000T 2026-01-28T14:05:33.382Z 2026-01-29T14:30:20.857Z
9264148 9264148 20260127112259_IxTpy AU000T 2026-01-28T14:04:38.721Z 2026-01-29T14:30:20.074Z
9262132 9262132 20260126162843_8CGmC AU000T 2026-01-27T14:07:47.126Z 2026-01-29T14:33:44.284Z
9262114 9262114 20260126161211_nIQu6 AU000T 2026-01-27T14:07:40.399Z 2026-01-29T14:33:41.818Z
9258560 9258560 20260124143130_PQSS2 AU000T 2026-01-26T14:12:58.948Z 2026-01-29T14:41:26.053Z
9258389 9258389 20260124111352_A7EOM AU000T 2026-01-26T14:11:27.219Z 2026-01-29T14:40:44.527Z
9258004 9258004 20260125175125_z7qPG AU000T 2026-01-26T14:09:05.725Z 2026-01-29T14:37:57.503Z
9257993 9257993 20260125174541_0dzhK AU000T 2026-01-26T14:09:00.556Z 2026-01-29T14:37:56.817Z
9257959 9257959 20260125173012_ZjutY AU000T 2026-01-26T14:08:48.577Z 2026-01-29T14:37:55.382Z
9257935 9257935 20260125171250_d5oG2 AU000T 2026-01-26T14:08:40.938Z 2026-01-29T14:37:53.934Z
9257874 9257874 20260125164131_TWbQA AU000T 2026-01-26T14:08:15.835Z 2026-01-29T14:37:46.052Z
9257863 9257863 20260125163027_vitQ5 AU000T 2026-01-26T14:08:13.512Z 2026-01-29T14:37:45.597Z
9257838 9257838 20260125161848_YXtqh AU000T 2026-01-26T14:08:05.695Z 2026-01-29T14:37:44.121Z
9257821 9257821 20260125160411_oNI8U AU000T 2026-01-26T14:07:55.512Z 2026-01-29T14:37:43.311Z
9257812 9257812 20260125160015_b1WVc AU000T 2026-01-26T14:07:49.904Z 2026-01-29T14:37:42.780Z
9257729 9257729 20260125154311_39HbM AU000T 2026-01-26T14:07:29.912Z 2026-01-29T14:37:37.308Z
9257703 9257703 20260125152956_EtOe3 AU000T 2026-01-26T14:07:21.109Z 2026-01-29T14:37:35.952Z
9257679 9257679 20260125152446_9QsPA AU000T 2026-01-26T14:07:14.148Z 2026-01-29T14:37:34.714Z
9257646 9257646 20260125151351_7VjwC AU000T 2026-01-26T14:06:57.270Z 2026-01-29T14:37:32.719Z
9257612 9257612 20260125145612_2sIfe AU000T 2026-01-26T14:06:43.178Z 2026-01-29T14:37:30.396Z
9257552 9257552 20260125143225_JGhkM AU000T 2026-01-26T14:06:20.600Z 2026-01-29T14:37:27.098Z
9257550 9257550 20260125142939_4uukG AU000T 2026-01-26T14:06:19.923Z 2026-01-29T14:37:26.991Z
9257452 9257452 20260125134409_okx1w AU000T 2026-01-26T14:05:42.475Z 2026-01-29T14:37:13.235Z
9257424 9257424 20260125133116_zsiD0 AU000T 2026-01-26T14:05:33.602Z 2026-01-29T14:37:11.639Z
9257379 9257379 20260125131432_iKtMy AU000T 2026-01-26T14:05:14.178Z 2026-01-29T14:37:09.158Z
9256885 9256885 20260125105741_Lgln2 AU000T 2026-01-26T14:02:32.676Z 2026-01-29T14:36:34.138Z
9253970 9253970 20260124171621_780Jc AU000T 2026-01-25T14:05:15.970Z 2026-01-29T14:42:12.093Z
9253968 9253968 20260124165744_O0kdf AU000T 2026-01-25T14:05:15.259Z 2026-01-29T14:42:08.704Z
9253939 9253939 20260124160307_lPxKg AU000T 2026-01-25T14:05:05.252Z 2026-01-29T14:41:51.634Z
9253937 9253937 20260124160257_33m3m AU000T 2026-01-25T14:05:04.649Z 2026-01-29T14:41:51.401Z
9253923 9253923 20260124155012_JyVOp AU000T 2026-01-25T14:05:01.012Z 2026-01-29T14:41:49.722Z
9253905 9253905 20260124154107_0DJIu AU000T 2026-01-25T14:04:55.975Z 2026-01-29T14:41:47.131Z
9253873 9253873 20260124152807_T76ZS AU000T 2026-01-25T14:04:46.354Z 2026-01-29T14:41:44.495Z
9253829 9253829 20260124150519_rwm4u AU000T 2026-01-25T14:04:35.340Z 2026-01-29T14:41:40.329Z
9253823 9253823 20260124150418_f6wcp AU000T 2026-01-25T14:04:33.316Z 2026-01-29T14:41:39.588Z
9253805 9253805 20260124145227_VMWAG AU000T 2026-01-25T14:04:30.379Z 2026-01-29T14:41:32.091Z
9253791 9253791 20260124144039_040N5 AU000T 2026-01-25T14:04:26.219Z 2026-01-29T14:41:30.683Z
9253766 9253766 20260124143130_jHjtg AU000T 2026-01-25T14:04:20.134Z 2026-01-29T14:41:25.853Z
9253738 9253738 20260124141942_sId1n AU000T 2026-01-25T14:04:10.553Z 2026-01-29T14:41:22.664Z
9253727 9253727 20260124140338_g3Swv AU000T 2026-01-25T14:04:07.921Z 2026-01-29T14:41:20.129Z
9253717 9253717 20260124140117_HS8E2 AU000T 2026-01-25T14:04:05.618Z 2026-01-29T14:41:19.489Z
9253708 9253708 20260124135757_YjPWp AU000T 2026-01-25T14:04:03.627Z 2026-01-29T14:41:18.841Z
9253666 9253666 20260124133219_wJHGF AU000T 2026-01-25T14:03:52.023Z 2026-01-29T14:41:15.141Z
9253514 9253514 20260124122442_OLKn9 AU000T 2026-01-25T14:03:05.386Z 2026-01-29T14:40:54.523Z
9253489 9253489 20260124121147_82F8Y AU000T 2026-01-25T14:02:58.932Z 2026-01-29T14:40:52.987Z
9250559 9250559 20260123174916_nzcTY AU000T 2026-01-24T14:03:33.780Z 2026-01-29T14:46:03.650Z
9250550 9250550 20260123174004_0O8eX AU000T 2026-01-24T14:03:32.264Z 2026-01-29T14:46:02.203Z
9250543 9250543 20260123171056_NmvsS AU000T 2026-01-24T14:03:30.639Z 2026-01-29T14:45:59.816Z
9250532 9250532 20260123161933_IRqWZ AU000T 2026-01-24T14:03:25.259Z 2026-01-29T14:45:54.543Z
9250507 9250507 20260123154923_crrcN AU000T 2026-01-24T14:03:17.941Z 2026-01-29T14:45:43.815Z
9250488 9250488 20260123153358_G1ZAZ AU000T 2026-01-24T14:03:12.235Z 2026-01-29T14:45:38.677Z
9250468 9250468 20260123152429_IqHLM AU000T 2026-01-24T14:03:06.401Z 2026-01-29T14:45:37.618Z
9250434 9250434 20260123145608_V31Nk AU000T 2026-01-24T14:02:55.724Z 2026-01-29T14:45:34.357Z
9250430 9250430 20260123144951_gbgnd AU000T 2026-01-24T14:02:54.291Z 2026-01-24T14:02:54.291Z
9250398 9250398 20260123142402_gDK5d AU000T 2026-01-24T14:02:43.426Z 2026-01-29T14:45:30.845Z
9250390 9250390 20260123141632_JHOf4 AU000T 2026-01-24T14:02:39.771Z 2026-01-29T14:45:30.228Z
9250348 9250348 20260123132012_mW6Qk AU000T 2026-01-24T14:02:27.827Z 2026-01-29T14:45:25.208Z
9250346 9250346 20260123131954_yE7ty AU000T 2026-01-24T14:02:27.350Z 2026-01-29T14:45:25.108Z
9250329 9250329 20260123130647_aBPS6 AU000T 2026-01-24T14:02:22.613Z 2026-01-29T14:45:23.779Z
9250294 9250294 20260123123157_ljoBc AU000T 2026-01-24T14:02:09.519Z 2026-01-29T14:45:13.649Z
9250285 9250285 20260123121433_Xs8rU AU000T 2026-01-24T14:02:06.620Z 2026-01-29T14:45:13.042Z
9250252 9250252 20260123114835_n62fs AU000T 2026-01-24T14:01:57.569Z 2026-01-29T14:45:09.004Z
9250190 9250190 20260123105928_6KsJl AU000T 2026-01-24T14:01:37.502Z 2026-01-29T14:45:04.634Z
9250188 9250188 20260123105905_Akg2d AU000T 2026-01-24T14:01:36.861Z 2026-01-29T14:45:04.490Z
9250138 9250138 20260123104201_JFdQv AU000T 2026-01-24T14:01:22.356Z 2026-01-29T14:45:01.455Z
9250121 9250121 20260123103305_w1Yww AU000T 2026-01-24T14:01:16.607Z 2026-01-29T14:45:00.539Z
9247307 9247307 20260121175751_6BC43 AU000T 2026-01-23T14:09:41.257Z 2026-01-29T14:56:03.233Z
9247201 9247201 20260121173543_TnBIm AU000T 2026-01-23T14:09:24.068Z 2026-01-29T14:55:49.539Z
9247181 9247181 20260121173045_1BHy2 AU000T 2026-01-23T14:09:20.920Z 2026-01-29T14:55:48.360Z
9247079 9247079 20260121165129_E01rc AU000T 2026-01-23T14:08:59.575Z 2026-01-29T14:55:41.781Z
9247058 9247058 20260121163333_PUOjT AU000T 2026-01-23T14:08:56.145Z 2026-01-29T14:55:40.506Z
9247028 9247028 20260121162333_FhRIm AU000T 2026-01-23T14:08:51.993Z 2026-01-29T14:55:39.092Z
9246885 9246885 20260121151911_er2iO AU000T 2026-01-23T14:08:17.020Z 2026-01-29T14:55:18.422Z
9246875 9246875 20260121151228_joz8C AU000T 2026-01-23T14:08:15.536Z 2026-01-29T14:55:17.917Z
9246837 9246837 20260121145624_a6OMg AU000T 2026-01-23T14:08:05.462Z 2026-01-29T14:55:13.991Z
9246819 9246819 20260121145116_Q6Son AU000T 2026-01-23T14:08:03.374Z 2026-01-29T14:55:13.350Z
9246740 9246740 20260121140920_w3YPi AU000T 2026-01-23T14:07:51.285Z 2026-01-29T14:55:08.851Z
9246736 9246736 20260121140620_aG7wI AU000T 2026-01-23T14:07:50.495Z 2026-01-29T14:55:08.402Z
9246688 9246688 20260121134227_btkyG AU000T 2026-01-23T14:07:36.081Z 2026-01-29T14:55:05.066Z
9246659 9246659 20260121131814_ESHBB AU000T 2026-01-23T14:07:31.207Z 2026-01-29T14:55:03.396Z
9246610 9246610 20260121125036_NUEdY AU000T 2026-01-23T14:07:20.053Z 2026-01-29T14:54:49.141Z
9246585 9246585 20260121124144_KmB2I AU000T 2026-01-23T14:07:12.452Z 2026-01-29T14:54:44.416Z
9246569 9246569 20260121122844_cQ32A AU000T 2026-01-23T14:07:05.803Z 2026-01-29T14:54:42.126Z
9246503 9246503 20260121104231_vlJ4N AU000T 2026-01-23T14:06:30.640Z 2026-01-29T14:54:14.361Z
9246495 9246495 20260121102720_bpvl6 AU000T 2026-01-23T14:06:24.194Z 2026-01-29T14:54:08.686Z
9246096 9246096 20260122164542_4LZi3 AU000T 2026-01-23T14:04:45.176Z 2026-01-29T14:50:44.207Z
9246085 9246085 20260122163540_SOQ5u AU000T 2026-01-23T14:04:43.235Z 2026-01-29T14:50:43.301Z
9245897 9245897 20260122152208_CuijY AU000T 2026-01-23T14:03:58.954Z 2026-01-29T14:50:21.399Z

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