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 = "AU000D" 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
8683376 8683376 20251201174117_PdBl9 AU000D 2025-12-04T14:23:52.602Z 2025-12-04T14:23:52.602Z
8683373 8683373 20251201173126_rP2kn AU000D 2025-12-04T14:23:50.434Z 2025-12-04T14:23:50.434Z
8683369 8683369 20251201172210_1UIqa AU000D 2025-12-04T14:23:47.956Z 2025-12-04T14:23:47.956Z
8683310 8683310 20251201131739_kZZ9a AU000D 2025-12-04T14:22:18.502Z 2025-12-04T14:22:18.502Z
8683308 8683308 20251201130822_qsXzW AU000D 2025-12-04T14:22:13.085Z 2025-12-04T14:22:13.085Z
8679379 8679379 20251202195807_ONkh8 AU000D 2025-12-04T14:09:41.533Z 2025-12-04T14:19:08.307Z
8679272 8679272 20251202193440_Pipwv AU000D 2025-12-04T14:09:20.406Z 2025-12-04T14:19:08.286Z
8679236 8679236 20251202192831_mbDZi AU000D 2025-12-04T14:09:16.958Z 2025-12-04T14:19:08.280Z
8679209 8679209 20251202192400_H1Geu AU000D 2025-12-04T14:09:13.396Z 2025-12-04T14:19:08.275Z
8679206 8679206 20251202192310_Ov7mP AU000D 2025-12-04T14:09:12.917Z 2025-12-04T14:19:08.275Z
8679186 8679186 20251202192123_w2StU AU000D 2025-12-04T14:09:11.304Z 2025-12-04T14:19:08.272Z
8679101 8679101 20251202185321_a1IdO AU000D 2025-12-04T14:08:58.166Z 2025-12-04T14:19:08.257Z
8679083 8679083 20251202185136_QzS8O AU000D 2025-12-04T14:08:54.037Z 2025-12-04T14:19:08.254Z
8679079 8679079 20251202185136_Ikicx AU000D 2025-12-04T14:08:53.653Z 2025-12-04T14:19:08.253Z
8679044 8679044 20251202184604_phAYp AU000D 2025-12-04T14:08:50.295Z 2025-12-04T14:19:08.249Z
8678974 8678974 20251202182517_JJiqc AU000D 2025-12-04T14:08:42.028Z 2025-12-04T14:19:08.235Z
8673561 8673561 20251201200547_clZZk AU000D 2025-12-03T14:19:18.495Z 2025-12-04T14:24:26.893Z
8673527 8673527 20251201195228_mywKN AU000D 2025-12-03T14:19:07.664Z 2025-12-04T14:24:24.260Z
8673513 8673513 20251201194446_z8AWk AU000D 2025-12-03T14:19:05.229Z 2025-12-04T14:24:23.413Z
8673449 8673449 20251201191811_O1zae AU000D 2025-12-03T14:18:53.809Z 2025-12-04T14:24:19.582Z
8673380 8673380 20251201184904_GGN0E AU000D 2025-12-03T14:18:40.790Z 2025-12-04T14:24:08.160Z
8673374 8673374 20251201184709_10NpG AU000D 2025-12-03T14:18:40.304Z 2025-12-04T14:24:07.878Z
8673371 8673371 20251201184709_zpGi7 AU000D 2025-12-03T14:18:39.904Z 2025-12-04T14:24:07.782Z
8673346 8673346 20251201183646_4ZbRh AU000D 2025-12-03T14:18:26.398Z 2025-12-04T14:24:05.092Z
8673343 8673343 20251201183531_eTGuv AU000D 2025-12-03T14:18:25.924Z 2025-12-04T14:24:04.933Z
8673297 8673297 20251201181720_fGgTa AU000D 2025-12-03T14:18:13.437Z 2025-12-04T14:23:59.405Z
8673260 8673260 20251201175412_Cd2fw AU000D 2025-12-03T14:18:07.436Z 2025-12-04T14:23:54.523Z
8673245 8673245 20251201174732_0YSlY AU000D 2025-12-03T14:18:05.387Z 2025-12-03T14:18:05.387Z
8673241 8673241 20251201174501_PmlsC AU000D 2025-12-03T14:18:04.417Z 2025-12-04T14:23:52.757Z
8673198 8673198 20251201172954_kpKwe AU000D 2025-12-03T14:17:54.066Z 2025-12-04T14:23:49.433Z
8673178 8673178 20251201172158_7fiQh AU000D 2025-12-03T14:17:47.494Z 2025-12-04T14:23:47.317Z
8673089 8673089 20251201165230_IJPS0 AU000D 2025-12-03T14:17:31.440Z 2025-12-04T14:23:34.144Z
8673081 8673081 20251201164819_zKDnV AU000D 2025-12-03T14:17:29.456Z 2025-12-04T14:23:33.545Z
8673063 8673063 20251201164221_RVQDy AU000D 2025-12-03T14:17:16.640Z 2025-12-04T14:23:32.100Z
8673054 8673054 20251201163810_8SUEF AU000D 2025-12-03T14:17:15.517Z 2025-12-04T14:23:31.605Z
8673035 8673035 20251201162828_eBIIT AU000D 2025-12-03T14:17:09.863Z 2025-12-04T14:23:30.314Z
8672972 8672972 20251201160043_xwMb3 AU000D 2025-12-03T14:17:02.261Z 2025-12-04T14:23:26.437Z
8672962 8672962 20251201155640_QoAon AU000D 2025-12-03T14:17:01.206Z 2025-12-04T14:23:25.810Z
8672900 8672900 20251201153702_1C21g AU000D 2025-12-03T14:16:52.918Z 2025-12-04T14:23:22.327Z
8672829 8672829 20251201152608_K9iR4 AU000D 2025-12-03T14:16:38.749Z 2025-12-04T14:23:12.917Z
8672798 8672798 20251201152114_lTFvA AU000D 2025-12-03T14:16:31.349Z 2025-12-04T14:23:11.231Z
8672775 8672775 20251201151707_BwkNh AU000D 2025-12-03T14:16:25.667Z 2025-12-04T14:23:10.254Z
8672729 8672729 20251201151141_JFWCt AU000D 2025-12-03T14:16:20.308Z 2025-12-04T14:23:05.946Z
8672680 8672680 20251201150622_dW0Or AU000D 2025-12-03T14:16:09.389Z 2025-12-04T14:23:03.822Z
8672646 8672646 20251201145833_UwHOc AU000D 2025-12-03T14:16:02.382Z 2025-12-04T14:23:01.978Z
8672553 8672553 20251201144602_YjyCX AU000D 2025-12-03T14:15:53.736Z 2025-12-04T14:22:57.790Z
8672541 8672541 20251201144337_kkh53 AU000D 2025-12-03T14:15:52.135Z 2025-12-04T14:22:56.834Z
8671939 8671939 20251201132701_OcCtn AU000D 2025-12-03T14:14:13.223Z 2025-12-04T14:22:21.855Z
8671665 8671665 20251201124650_o66mK AU000D 2025-12-03T14:13:16.825Z 2025-12-04T14:21:59.045Z
8671340 8671340 20251201120354_dmFQB AU000D 2025-12-03T14:12:12.748Z 2025-12-03T14:12:12.748Z
8667284 8667284 20251129195640_cpU0X AU000D 2025-12-02T14:36:06.488Z 2025-12-04T14:38:51.383Z
8667268 8667268 20251129193334_43vK6 AU000D 2025-12-02T14:35:59.339Z 2025-12-04T14:38:43.779Z
8667250 8667250 20251129192115_tbRu3 AU000D 2025-12-02T14:35:56.267Z 2025-12-04T14:38:41.417Z
8667190 8667190 20251129183403_GRDro AU000D 2025-12-02T14:35:24.386Z 2025-12-04T14:38:29.911Z
8667170 8667170 20251129180444_kSYcl AU000D 2025-12-02T14:35:18.060Z 2025-12-04T14:38:09.173Z
8667142 8667142 20251129173823_SM9Xy AU000D 2025-12-02T14:35:10.621Z 2025-12-04T14:38:01.161Z
8667127 8667127 20251129172809_dAab8 AU000D 2025-12-02T14:35:06.575Z 2025-12-04T14:37:58.609Z
8667115 8667115 20251129171454_BjkIH AU000D 2025-12-02T14:34:47.304Z 2025-12-04T14:37:54.404Z
8667108 8667108 20251129170220_DXXvh AU000D 2025-12-02T14:34:43.227Z 2025-12-04T14:37:52.144Z
8667098 8667098 20251129164932_pYKBj AU000D 2025-12-02T14:34:40.406Z 2025-12-04T14:37:49.980Z
8667053 8667053 20251129155917_QOrgc AU000D 2025-12-02T14:34:29.482Z 2025-12-04T14:37:27.864Z
8667050 8667050 20251129155802_1jHjI AU000D 2025-12-02T14:34:28.916Z 2025-12-04T14:37:27.552Z
8667025 8667025 20251129152343_ixx0K AU000D 2025-12-02T14:34:06.635Z 2025-12-04T14:37:18.179Z
8667016 8667016 20251129150815_YJvsW AU000D 2025-12-02T14:34:01.634Z 2025-12-04T14:37:14.861Z
8666988 8666988 20251129133514_RM35e AU000D 2025-12-02T14:33:44.177Z 2025-12-04T14:36:52.692Z
8666723 8666723 20251130192350_l4LTk AU000D 2025-12-02T14:27:12.581Z 2025-12-04T14:31:33.145Z
8666721 8666721 20251130192242_zvS8N AU000D 2025-12-02T14:27:12.371Z 2025-12-04T14:31:32.255Z
8666719 8666719 20251130191757_adEOS AU000D 2025-12-02T14:27:12.065Z 2025-12-04T14:31:30.576Z
8666708 8666708 20251130185903_Z6mJ6 AU000D 2025-12-02T14:27:11.137Z 2025-12-04T14:31:24.481Z
8666700 8666700 20251130184616_RLeYD AU000D 2025-12-02T14:27:10.294Z 2025-12-04T14:31:11.441Z
8666698 8666698 20251130184558_i046r AU000D 2025-12-02T14:27:10.044Z 2025-12-04T14:31:09.685Z
8666680 8666680 20251130183358_OmeLr AU000D 2025-12-02T14:27:06.848Z 2025-12-04T14:31:05.445Z
8666673 8666673 20251130183115_ZJEPQ AU000D 2025-12-02T14:27:06.255Z 2025-12-04T14:31:02.932Z
8666669 8666669 20251130182654_4LafA AU000D 2025-12-02T14:27:05.707Z 2025-12-04T14:31:01.507Z
8666663 8666663 20251130181745_TWPkv AU000D 2025-12-02T14:27:05.008Z 2025-12-04T14:30:58.245Z
8666657 8666657 20251130180716_R9Evo AU000D 2025-12-02T14:27:04.180Z 2025-12-04T14:30:55.467Z
8666644 8666644 20251130173017_zRNkY AU000D 2025-12-02T14:27:02.323Z 2025-12-04T14:30:31.691Z
8666635 8666635 20251130170057_ydcRI AU000D 2025-12-02T14:27:01.278Z 2025-12-04T14:30:19.806Z
8666604 8666604 20251130154649_In46a AU000D 2025-12-02T14:26:57.611Z 2025-12-04T14:30:06.116Z
8666602 8666602 20251130154417_FflwJ AU000D 2025-12-02T14:26:57.419Z 2025-12-04T14:30:05.092Z
8666600 8666600 20251130154009_RfK8P AU000D 2025-12-02T14:26:57.071Z 2025-12-04T14:29:56.157Z
8666590 8666590 20251130142723_UqDlO AU000D 2025-12-02T14:26:55.426Z 2025-12-04T14:29:24.391Z
8666576 8666576 20251130134524_YaPqX AU000D 2025-12-02T14:26:52.586Z 2025-12-04T14:29:10.017Z
8666572 8666572 20251130133823_f3oD8 AU000D 2025-12-02T14:26:52.042Z 2025-12-04T14:29:08.361Z
8662994 8662994 20251130195306_L30mb AU000D 2025-12-02T14:17:15.504Z 2025-12-04T14:31:46.069Z
8662769 8662769 20251130192901_BoW75 AU000D 2025-12-02T14:16:31.756Z 2025-12-02T14:16:31.756Z
8662736 8662736 20251130192443_xb7ik AU000D 2025-12-02T14:16:26.160Z 2025-12-04T14:31:33.835Z
8662526 8662526 20251130190637_pyThC AU000D 2025-12-02T14:15:49.968Z 2025-12-04T14:31:26.120Z
8662500 8662500 20251130190025_NeKbp AU000D 2025-12-02T14:15:45.361Z 2025-12-04T14:31:25.046Z
8662428 8662428 20251130184918_vrW3W AU000D 2025-12-02T14:15:27.513Z 2025-12-04T14:31:20.978Z
8662344 8662344 20251130183545_lmck1 AU000D 2025-12-02T14:15:12.068Z 2025-12-02T14:15:12.068Z
8662167 8662167 20251130181014_e5tmd AU000D 2025-12-02T14:14:35.510Z 2025-12-04T14:30:56.627Z
8662134 8662134 20251130180444_F1h4m AU000D 2025-12-02T14:14:28.356Z 2025-12-04T14:30:54.748Z
8662081 8662081 20251130175254_NKHEK AU000D 2025-12-02T14:14:16.029Z 2025-12-04T14:30:52.134Z
8662047 8662047 20251130174759_gJzJf AU000D 2025-12-02T14:14:05.692Z 2025-12-04T14:30:50.259Z
8661989 8661989 20251130174014_XQ3A2 AU000D 2025-12-02T14:13:54.703Z 2025-12-04T14:30:46.564Z
8661949 8661949 20251130173522_wr2jZ AU000D 2025-12-02T14:13:40.943Z 2025-12-04T14:30:44.404Z
8661905 8661905 20251130173022_WHjrH AU000D 2025-12-02T14:13:34.822Z 2025-12-04T14:30:31.867Z
8661884 8661884 20251130172913_UIE8T AU000D 2025-12-02T14:13:31.651Z 2025-12-04T14:30:31.000Z
8661816 8661816 20251130171800_Mq4iL AU000D 2025-12-02T14:13:08.498Z 2025-12-04T14:30:24.630Z

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