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

951 rows where station_code = "AU0001" 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
8670354 8670354 20251202173931_eQwCi AU0001 2025-12-03T14:08:09.438Z 2025-12-04T14:19:08.207Z
8670345 8670345 20251202172633_4vrYW AU0001 2025-12-03T14:08:07.485Z 2025-12-04T14:19:08.198Z
8670333 8670333 20251202170812_YiGQe AU0001 2025-12-03T14:08:01.436Z 2025-12-04T14:19:08.185Z
8670305 8670305 20251202162600_iDBz5 AU0001 2025-12-03T14:07:55.487Z 2025-12-04T14:19:08.159Z
8670297 8670297 20251202162053_o12Ji AU0001 2025-12-03T14:07:53.844Z 2025-12-04T14:19:08.156Z
8544999 8544999 20251120155707_QTEP3 AU0001 2025-11-22T14:09:27.841Z 2025-11-29T14:53:57.496Z
8544665 8544665 20251120152542_fnK2i AU0001 2025-11-22T14:08:34.786Z 2025-11-29T14:53:49.390Z
8544521 8544521 20251120151701_7IVIu AU0001 2025-11-22T14:08:09.099Z 2025-11-29T14:53:46.994Z
8544134 8544134 20251120145158_Sx9pi AU0001 2025-11-22T14:07:01.692Z 2025-11-29T14:53:41.463Z
8303689 8303689 20251029175207_enODX AU0001 2025-10-31T12:07:04.555Z 2025-11-07T15:09:44.519Z
8303582 8303582 20251029173737_k8e2u AU0001 2025-10-31T12:06:45.538Z 2025-11-07T15:09:39.356Z
8303575 8303575 20251029173653_LzZZr AU0001 2025-10-31T12:06:44.734Z 2025-11-07T15:09:39.271Z
8303400 8303400 20251029171114_TwxO4 AU0001 2025-10-31T12:06:25.475Z 2025-11-07T15:09:36.102Z
8303158 8303158 20251029163229_dxHoi AU0001 2025-10-31T12:05:47.617Z 2025-11-07T15:09:25.504Z
8289000 8289000 20251028180926_30X4W AU0001 2025-10-30T12:12:07.379Z 2025-11-06T15:11:36.735Z
8287876 8287876 20251028163116_oLnLO AU0001 2025-10-30T12:08:33.644Z 2025-11-06T15:10:54.256Z
8287694 8287694 20251028161537_6foVL AU0001 2025-10-30T12:08:04.014Z 2025-11-06T15:10:46.910Z
8287675 8287675 20251028161017_OyF8v AU0001 2025-10-30T12:07:53.988Z 2025-11-06T15:10:46.819Z
8287343 8287343 20251028154929_WFdro AU0001 2025-10-30T12:06:44.282Z 2025-11-06T15:10:36.555Z
8286676 8286676 20251028150200_g5O47 AU0001 2025-10-30T12:04:27.864Z 2025-11-06T15:10:26.350Z
8285049 8285049 20251027120012_mdxlo AU0001 2025-10-29T12:47:02.362Z 2025-11-04T15:48:31.104Z
8278342 8278342 20251027120012_b5lQ2 AU0001 2025-10-29T12:33:27.673Z 2025-11-04T15:48:31.088Z
8277791 8277791 20251027110517_gJS6E AU0001 2025-10-29T12:32:21.695Z 2025-11-04T15:47:54.196Z
8270782 8270782 20251027180908_O7Qf2 AU0001 2025-10-29T12:06:29.140Z 2025-11-05T15:19:26.274Z
8270744 8270744 20251027180535_lOSAR AU0001 2025-10-29T12:06:25.550Z 2025-11-05T15:19:26.048Z
8270712 8270712 20251027180442_pBnLc AU0001 2025-10-29T12:06:23.122Z 2025-11-05T15:19:24.672Z
8270619 8270619 20251027175749_MCKnp AU0001 2025-10-29T12:06:15.749Z 2025-11-05T15:19:23.518Z
8270523 8270523 20251027175032_ypDF2 AU0001 2025-10-29T12:05:59.377Z 2025-11-05T15:19:18.604Z
8268974 8268974 20251027153012_sOcpv AU0001 2025-10-29T12:02:33.006Z 2025-11-05T15:18:37.786Z
8268574 8268574 20251027143144_8F6iW AU0001 2025-10-29T12:01:31.202Z 2025-11-05T15:18:30.909Z
8268311 8268311 20251027134208_ftRRY AU0001 2025-10-29T12:00:52.418Z 2025-11-05T15:18:29.429Z
8228542 8228542 20251024120702_0Hdhy AU0001 2025-10-26T12:48:01.274Z 2025-11-01T13:11:33.561Z
8208113 8208113 20251024175043_CejBc AU0001 2025-10-26T12:11:01.376Z 2025-11-02T15:05:04.411Z
8207818 8207818 20251024164306_x0Bh2 AU0001 2025-10-26T12:09:48.269Z 2025-11-02T15:05:02.744Z
8207545 8207545 20251024160745_seZmW AU0001 2025-10-26T12:08:55.050Z 2025-11-02T15:05:01.921Z
8205677 8205677 20251024131840_tqWgn AU0001 2025-10-26T12:01:39.060Z 2025-11-02T15:04:50.339Z
8199658 8199658 20251023162639_CQaaR AU0001 2025-10-25T12:05:48.341Z 2025-11-01T13:09:33.376Z
8151138 8151138 20251018100228_MT41N AU0001 2025-10-20T12:42:26.189Z 2025-10-26T13:16:24.904Z
8140979 8140979 20251018160131_hKHPR AU0001 2025-10-20T12:04:59.322Z 2025-10-27T13:09:33.523Z
8140756 8140756 20251018144510_RJ4Ng AU0001 2025-10-20T12:04:13.847Z 2025-10-27T13:09:30.858Z
8140667 8140667 20251018140757_aDU2r AU0001 2025-10-20T12:03:52.610Z 2025-10-27T13:09:28.181Z
8130780 8130780 20251017181048_pkhiB AU0001 2025-10-19T12:05:36.263Z 2025-10-26T13:14:55.702Z
8130742 8130742 20251017174853_iG6Xz AU0001 2025-10-19T12:05:30.079Z 2025-10-26T13:14:55.046Z
8130713 8130713 20251017170923_Ck5fL AU0001 2025-10-19T12:05:15.321Z 2025-10-26T13:14:54.733Z
8130711 8130711 20251017170530_ljU7d AU0001 2025-10-19T12:05:13.689Z 2025-10-26T13:14:54.730Z
8130686 8130686 20251017164706_5cWoe AU0001 2025-10-19T12:05:07.814Z 2025-10-26T13:14:54.617Z
8130649 8130649 20251017163408_2lVFB AU0001 2025-10-19T12:05:02.063Z 2025-10-26T13:14:54.422Z
8130283 8130283 20251017154102_GzXl3 AU0001 2025-10-19T12:04:16.382Z 2025-10-26T13:14:49.688Z
8130250 8130250 20251017153548_Lo5cv AU0001 2025-10-19T12:04:14.088Z 2025-10-26T13:14:49.332Z
8109607 8109607 20251015182626_qUv0I AU0001 2025-10-17T12:05:38.497Z 2025-10-24T13:15:27.648Z
8109598 8109598 20251015182402_Q03kI AU0001 2025-10-17T12:05:31.815Z 2025-10-24T13:15:27.534Z
8109505 8109505 20251015175628_s9zYu AU0001 2025-10-17T12:05:23.775Z 2025-10-24T13:15:24.647Z
8109502 8109502 20251015175602_dbU0D AU0001 2025-10-17T12:05:23.436Z 2025-10-24T13:15:24.643Z
8109380 8109380 20251015173229_og0b2 AU0001 2025-10-17T12:04:50.912Z 2025-10-24T13:15:22.115Z
8109288 8109288 20251015170014_96T55 AU0001 2025-10-17T12:04:41.471Z 2025-10-24T13:15:18.555Z
8109278 8109278 20251015165142_vyRTr AU0001 2025-10-17T12:04:40.708Z 2025-10-24T13:15:18.348Z
8109189 8109189 20251015162202_YVcM5 AU0001 2025-10-17T12:04:23.946Z 2025-10-24T13:15:14.185Z
8108819 8108819 20251015124418_d7yGF AU0001 2025-10-17T12:02:33.909Z 2025-10-24T13:14:40.937Z
8108760 8108760 20251015120202_qHtSb AU0001 2025-10-17T12:02:19.500Z 2025-10-24T13:14:32.566Z
8096766 8096766 20251014174351_pVKFp AU0001 2025-10-15T12:08:59.159Z 2025-10-23T13:07:57.942Z
8090230 8090230 20251013163811_wUSFA AU0001 2025-10-14T12:02:52.280Z 2025-10-22T13:09:16.109Z
8090124 8090124 20251013161351_4LOOf AU0001 2025-10-14T12:02:36.737Z 2025-10-22T13:09:10.952Z
8090074 8090074 20251013160553_RBY3o AU0001 2025-10-14T12:02:31.655Z 2025-10-22T13:09:10.356Z
8089961 8089961 20251013154622_rjFP3 AU0001 2025-10-14T12:02:16.353Z 2025-10-22T13:09:07.684Z
8089929 8089929 20251013153707_fGKfT AU0001 2025-10-14T12:02:06.081Z 2025-10-22T13:09:06.922Z
8089800 8089800 20251013151027_6u5bJ AU0001 2025-10-14T12:01:49.178Z 2025-10-22T13:09:02.894Z
8089798 8089798 20251013151025_7Zj8f AU0001 2025-10-14T12:01:48.829Z 2025-10-22T13:09:02.828Z
8089676 8089676 20251013143903_13KhA AU0001 2025-10-14T12:01:27.932Z 2025-10-22T13:08:57.126Z
8089591 8089591 20251013141454_WLO2X AU0001 2025-10-14T12:01:15.578Z 2025-10-22T13:08:51.084Z
8089367 8089367 20251013131858_xnGQ4 AU0001 2025-10-14T12:00:51.204Z 2025-10-22T13:08:47.275Z
8089267 8089267 20251013123320_7U447 AU0001 2025-10-14T12:00:34.948Z 2025-10-22T13:08:42.575Z
8054316 8054316 20251003182008_tdh80 AU0001 2025-10-05T12:09:03.021Z 2025-10-12T12:31:35.392Z
8054197 8054197 20251003172307_UDHrS AU0001 2025-10-05T12:08:28.194Z 2025-10-12T12:31:24.902Z
7999814 7999814 20250928142554_UQBFc AU0001 2025-09-30T12:10:13.890Z 2025-10-07T12:59:39.846Z
7999494 7999494 20250928122659_3KI6D AU0001 2025-09-30T12:09:13.351Z 2025-10-07T12:59:34.409Z
7999445 7999445 20250928115010_ebLlS AU0001 2025-09-30T12:09:03.163Z 2025-10-07T12:59:32.517Z
7992442 7992442 20250927154425_scFk8 AU0001 2025-09-29T12:15:16.321Z 2025-10-05T13:05:56.541Z
7877951 7877951 20250918143635_wvsiA AU0001 2025-09-20T12:27:17.646Z 2025-09-27T12:47:14.588Z
7877440 7877440 20250918123259_KTFDQ AU0001 2025-09-20T12:25:58.276Z 2025-09-27T12:47:07.632Z
7868171 7868171 20250917120806_vdVrI AU0001 2025-09-19T12:21:33.720Z 2025-09-25T13:12:00.961Z
7841214 7841214 20250914165235_yhxLM AU0001 2025-09-16T12:32:26.475Z 2025-09-22T13:08:51.627Z
7840117 7840117 20250914144902_ZTV1f AU0001 2025-09-16T12:30:43.101Z 2025-09-22T13:08:38.353Z
7839905 7839905 20250914142925_vinIG AU0001 2025-09-16T12:30:34.674Z 2025-09-22T13:08:35.899Z
7838701 7838701 20250914121145_2jMhb AU0001 2025-09-16T12:28:52.648Z 2025-09-22T13:08:21.494Z
7837397 7837397 20250914093256_MkH83 AU0001 2025-09-16T12:26:15.255Z 2025-09-22T13:07:55.190Z
7782177 7782177 20250907192435_2u32O AU0001 2025-09-08T12:01:03.963Z 2025-09-16T12:50:39.892Z
7782170 7782170 20250907192005_nYLEl AU0001 2025-09-08T12:01:02.602Z 2025-09-16T12:50:39.732Z
7782093 7782093 20250907182515_7Z7Ch AU0001 2025-09-08T12:00:48.248Z 2025-09-16T12:50:35.345Z
7782004 7782004 20250907175357_SanY2 AU0001 2025-09-08T12:00:26.694Z 2025-09-16T12:50:34.100Z
7781937 7781937 20250907174103_BI04d AU0001 2025-09-08T12:00:14.217Z 2025-09-16T12:50:32.894Z
7641171 7641171 20250824135437_YyuW0 AU0001 2025-08-26T12:10:56.948Z 2025-09-02T12:50:58.860Z
7639853 7639853 20250824093932_xnsmv AU0001 2025-08-26T12:06:54.579Z 2025-09-02T12:50:48.560Z
7631780 7631780 20250823184001_2Jk2l AU0001 2025-08-25T12:16:00.746Z 2025-09-01T12:55:50.222Z
7630393 7630393 20250823160707_0FZum AU0001 2025-08-25T12:12:17.352Z 2025-09-01T12:55:42.487Z
7629776 7629776 20250823150056_1gWJH AU0001 2025-08-25T12:10:38.262Z 2025-09-01T12:55:39.935Z
7628797 7628797 20250823130324_hRC9i AU0001 2025-08-25T12:07:52.590Z 2025-09-01T12:55:35.874Z
7622286 7622286 20250822194322_3DAhY AU0001 2025-08-24T12:19:11.584Z 2025-08-31T12:53:52.904Z
7622278 7622278 20250822194249_bl4EA AU0001 2025-08-24T12:19:10.635Z 2025-08-31T12:53:52.859Z
7618802 7618802 20250822142948_QASjX AU0001 2025-08-24T12:11:29.313Z 2025-08-31T12:53:27.185Z
7618788 7618788 20250822142850_DRPWY AU0001 2025-08-24T12:11:28.443Z 2025-08-31T12:53:27.174Z

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