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 = "AU001B" 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
8683619 8683619 20251130190844_BP0Ho AU001B 2025-12-04T14:31:26.844Z 2025-12-04T14:31:26.844Z
8683594 8683594 20251130173423_ylXwo AU001B 2025-12-04T14:30:43.983Z 2025-12-04T14:30:43.983Z
8683592 8683592 20251130173416_BRENq AU001B 2025-12-04T14:30:43.673Z 2025-12-04T14:30:43.673Z
8683588 8683588 20251130172615_kcGtQ AU001B 2025-12-04T14:30:29.846Z 2025-12-04T14:30:29.846Z
8683550 8683550 20251130154922_Jgrm6 AU001B 2025-12-04T14:30:06.654Z 2025-12-04T14:30:06.654Z
8683546 8683546 20251130154210_x3LAT AU001B 2025-12-04T14:30:01.783Z 2025-12-04T14:30:01.783Z
8683538 8683538 20251130151814_13sYY AU001B 2025-12-04T14:29:48.835Z 2025-12-04T14:29:48.835Z
8683523 8683523 20251130145656_XbxaB AU001B 2025-12-04T14:29:39.133Z 2025-12-04T14:29:39.133Z
8683424 8683424 20251201195258_pHtyl AU001B 2025-12-04T14:24:24.487Z 2025-12-04T14:24:24.487Z
8683408 8683408 20251201190531_VWnQ3 AU001B 2025-12-04T14:24:17.477Z 2025-12-04T14:24:17.477Z
8678668 8678668 20251202164615_emyty AU001B 2025-12-04T14:07:49.364Z 2025-12-04T14:19:08.169Z
8678662 8678662 20251202164341_mts3T AU001B 2025-12-04T14:07:48.302Z 2025-12-04T14:19:08.166Z
8678646 8678646 20251202162918_231hy AU001B 2025-12-04T14:07:45.270Z 2025-12-04T14:19:08.160Z
8678632 8678632 20251202160723_Upt67 AU001B 2025-12-04T14:07:41.386Z 2025-12-04T14:19:08.151Z
8678626 8678626 20251202160334_PyBoy AU001B 2025-12-04T14:07:37.465Z 2025-12-04T14:19:08.150Z
8678613 8678613 20251202160051_ir059 AU001B 2025-12-04T14:07:35.220Z 2025-12-04T14:19:08.145Z
8678611 8678611 20251202155455_zPNqf AU001B 2025-12-04T14:07:31.826Z 2025-12-04T14:19:08.143Z
8678530 8678530 20251202150557_IyHYO AU001B 2025-12-04T14:07:13.363Z 2025-12-04T14:19:08.052Z
8673520 8673520 20251201194526_82446 AU001B 2025-12-03T14:19:06.424Z 2025-12-04T14:24:23.895Z
8673516 8673516 20251201194517_RsTo5 AU001B 2025-12-03T14:19:05.584Z 2025-12-04T14:24:23.547Z
8673514 8673514 20251201194446_z8AWk AU001B 2025-12-03T14:19:05.230Z 2025-12-04T14:24:23.413Z
8673436 8673436 20251201191040_aX6Sc AU001B 2025-12-03T14:18:51.596Z 2025-12-04T14:24:17.769Z
8673432 8673432 20251201190438_XH55P AU001B 2025-12-03T14:18:50.589Z 2025-12-04T14:24:17.272Z
8673411 8673411 20251201185914_uHg31 AU001B 2025-12-03T14:18:47.387Z 2025-12-04T14:24:14.425Z
8673401 8673401 20251201185518_W3skd AU001B 2025-12-03T14:18:46.121Z 2025-12-04T14:24:13.783Z
8673381 8673381 20251201184904_GGN0E AU001B 2025-12-03T14:18:40.790Z 2025-12-04T14:24:08.160Z
8673356 8673356 20251201184023_CaTpJ AU001B 2025-12-03T14:18:27.698Z 2025-12-04T14:24:06.117Z
8673332 8673332 20251201183006_J7tNx AU001B 2025-12-03T14:18:21.123Z 2025-12-04T14:24:03.942Z
8673328 8673328 20251201182651_4zob0 AU001B 2025-12-03T14:18:17.894Z 2025-12-04T14:24:01.022Z
8673324 8673324 20251201182426_1Bnhh AU001B 2025-12-03T14:18:17.116Z 2025-12-04T14:24:00.858Z
8673322 8673322 20251201182324_lqNVO AU001B 2025-12-03T14:18:16.661Z 2025-12-04T14:24:00.651Z
8673320 8673320 20251201182250_20TDs AU001B 2025-12-03T14:18:16.138Z 2025-12-04T14:24:00.492Z
8673293 8673293 20251201181144_BSH8n AU001B 2025-12-03T14:18:12.624Z 2025-12-04T14:23:57.838Z
8673258 8673258 20251201175311_Xe0c0 AU001B 2025-12-03T14:18:07.073Z 2025-12-04T14:23:54.321Z
8673247 8673247 20251201174826_tsHcM AU001B 2025-12-03T14:18:05.914Z 2025-12-04T14:23:53.346Z
8673242 8673242 20251201174501_PmlsC AU001B 2025-12-03T14:18:04.417Z 2025-12-04T14:23:52.757Z
8673226 8673226 20251201173620_irCAn AU001B 2025-12-03T14:18:01.905Z 2025-12-04T14:23:51.348Z
8673222 8673222 20251201173423_GjZb0 AU001B 2025-12-03T14:18:01.094Z 2025-12-04T14:23:51.022Z
8673211 8673211 20251201173046_EVE6w AU001B 2025-12-03T14:17:59.378Z 2025-12-04T14:23:50.012Z
8673199 8673199 20251201172954_kpKwe AU001B 2025-12-03T14:17:54.066Z 2025-12-04T14:23:49.433Z
8673188 8673188 20251201172425_nbs4X AU001B 2025-12-03T14:17:49.078Z 2025-12-04T14:23:48.481Z
8673156 8673156 20251201171401_OruJ4 AU001B 2025-12-03T14:17:41.731Z 2025-12-04T14:23:40.895Z
8673154 8673154 20251201171224_c6yjd AU001B 2025-12-03T14:17:41.412Z 2025-12-04T14:23:40.495Z
8673143 8673143 20251201170948_wHUkR AU001B 2025-12-03T14:17:39.547Z 2025-12-04T14:23:39.365Z
8673122 8673122 20251201170340_5v63H AU001B 2025-12-03T14:17:36.943Z 2025-12-04T14:23:37.993Z
8673094 8673094 20251201165346_2o0sd AU001B 2025-12-03T14:17:32.421Z 2025-12-04T14:23:34.385Z
8673091 8673091 20251201165257_Yal2K AU001B 2025-12-03T14:17:31.950Z 2025-12-04T14:23:34.232Z
8673073 8673073 20251201164713_NYj2M AU001B 2025-12-03T14:17:27.984Z 2025-12-04T14:23:33.075Z
8673041 8673041 20251201163026_Uoj2G AU001B 2025-12-03T14:17:12.777Z 2025-12-04T14:23:30.829Z
8673039 8673039 20251201163025_hOIM4 AU001B 2025-12-03T14:17:12.196Z 2025-12-04T14:23:30.698Z
8673025 8673025 20251201162508_sqqK0 AU001B 2025-12-03T14:17:08.952Z 2025-12-04T14:23:29.895Z
8673023 8673023 20251201162447_MRLDd AU001B 2025-12-03T14:17:08.517Z 2025-12-04T14:23:29.714Z
8672973 8672973 20251201160043_xwMb3 AU001B 2025-12-03T14:17:02.261Z 2025-12-04T14:23:26.437Z
8672963 8672963 20251201155640_QoAon AU001B 2025-12-03T14:17:01.206Z 2025-12-04T14:23:25.810Z
8672799 8672799 20251201152114_lTFvA AU001B 2025-12-03T14:16:31.349Z 2025-12-04T14:23:11.231Z
8672673 8672673 20251201150445_qK0H1 AU001B 2025-12-03T14:16:08.426Z 2025-12-04T14:23:03.407Z
8672462 8672462 20251201143257_oVUvz AU001B 2025-12-03T14:15:37.173Z 2025-12-04T14:22:52.633Z
8672406 8672406 20251201142542_IcLaT AU001B 2025-12-03T14:15:32.079Z 2025-12-04T14:22:50.024Z
8667040 8667040 20251129153603_6UKJ2 AU001B 2025-12-02T14:34:24.076Z 2025-12-04T14:37:20.651Z
8667038 8667038 20251129153326_3lrX2 AU001B 2025-12-02T14:34:23.046Z 2025-12-04T14:37:20.246Z
8666611 8666611 20251130160515_uKobT AU001B 2025-12-02T14:26:58.251Z 2025-12-04T14:30:08.863Z
8666596 8666596 20251130152944_LMGv2 AU001B 2025-12-02T14:26:56.555Z 2025-12-04T14:29:54.497Z
8662892 8662892 20251130194607_OImuO AU001B 2025-12-02T14:16:58.001Z 2025-12-04T14:31:40.480Z
8662827 8662827 20251130193614_6BZ3d AU001B 2025-12-02T14:16:48.519Z 2025-12-04T14:31:37.710Z
8662709 8662709 20251130192258_Nl43u AU001B 2025-12-02T14:16:21.849Z 2025-12-04T14:31:32.499Z
8662671 8662671 20251130191940_y83LS AU001B 2025-12-02T14:16:17.200Z 2025-12-04T14:31:31.199Z
8662527 8662527 20251130190637_pyThC AU001B 2025-12-02T14:15:49.968Z 2025-12-04T14:31:26.120Z
8662469 8662469 20251130185511_3DWzL AU001B 2025-12-02T14:15:41.093Z 2025-12-04T14:31:23.730Z
8662396 8662396 20251130184305_iA3GQ AU001B 2025-12-02T14:15:21.668Z 2025-12-04T14:31:09.012Z
8662393 8662393 20251130184250_2JqW4 AU001B 2025-12-02T14:15:21.137Z 2025-12-04T14:31:08.905Z
8662389 8662389 20251130184243_OSDO4 AU001B 2025-12-02T14:15:20.148Z 2025-12-04T14:31:08.716Z
8662351 8662351 20251130183748_2i1QW AU001B 2025-12-02T14:15:13.183Z 2025-12-04T14:31:06.904Z
8662346 8662346 20251130183740_FD1An AU001B 2025-12-02T14:15:12.463Z 2025-12-04T14:31:06.625Z
8662340 8662340 20251130183447_peOP7 AU001B 2025-12-02T14:15:11.274Z 2025-12-04T14:31:06.162Z
8662300 8662300 20251130182947_M9S1S AU001B 2025-12-02T14:15:04.946Z 2025-12-04T14:31:02.152Z
8662287 8662287 20251130182622_QzseU AU001B 2025-12-02T14:14:57.487Z 2025-12-04T14:31:01.467Z
8662168 8662168 20251130181014_e5tmd AU001B 2025-12-02T14:14:35.510Z 2025-12-04T14:30:56.627Z
8662048 8662048 20251130174759_gJzJf AU001B 2025-12-02T14:14:05.692Z 2025-12-04T14:30:50.259Z
8662021 8662021 20251130174504_2D3EL AU001B 2025-12-02T14:14:00.145Z 2025-12-04T14:30:48.734Z
8661990 8661990 20251130174014_XQ3A2 AU001B 2025-12-02T14:13:54.703Z 2025-12-04T14:30:46.564Z
8661987 8661987 20251130173952_Ut2Yx AU001B 2025-12-02T14:13:49.642Z 2025-12-04T14:30:46.444Z
8661920 8661920 20251130173135_R0ilu AU001B 2025-12-02T14:13:37.290Z 2025-12-04T14:30:42.146Z
8661906 8661906 20251130173022_WHjrH AU001B 2025-12-02T14:13:34.822Z 2025-12-04T14:30:31.867Z
8661876 8661876 20251130172744_V2G5N AU001B 2025-12-02T14:13:29.415Z 2025-12-04T14:30:30.185Z
8661864 8661864 20251130172448_VYBNe AU001B 2025-12-02T14:13:19.874Z 2025-12-04T14:30:29.375Z
8661843 8661843 20251130172219_nOOaM AU001B 2025-12-02T14:13:13.633Z 2025-12-04T14:30:27.983Z
8661817 8661817 20251130171800_Mq4iL AU001B 2025-12-02T14:13:08.498Z 2025-12-04T14:30:24.630Z
8661805 8661805 20251130171517_IDsmG AU001B 2025-12-02T14:13:05.723Z 2025-12-04T14:30:24.021Z
8661771 8661771 20251130171106_BPCjJ AU001B 2025-12-02T14:13:00.026Z 2025-12-02T14:27:01.668Z
8661748 8661748 20251130170442_nzwqY AU001B 2025-12-02T14:12:54.809Z 2025-12-04T14:30:20.992Z
8661744 8661744 20251130170404_S8N3T AU001B 2025-12-02T14:12:53.932Z 2025-12-04T14:30:20.784Z
8661727 8661727 20251130170120_GsCiM AU001B 2025-12-02T14:12:51.319Z 2025-12-04T14:30:19.962Z
8661702 8661702 20251130165607_1SXOT AU001B 2025-12-02T14:12:39.960Z 2025-12-04T14:30:18.290Z
8661663 8661663 20251130164639_mA50t AU001B 2025-12-02T14:12:31.237Z 2025-12-04T14:30:15.458Z
8661631 8661631 20251130163603_Uy6Rq AU001B 2025-12-02T14:12:24.690Z 2025-12-04T14:30:12.939Z
8661606 8661606 20251130162159_KUHQC AU001B 2025-12-02T14:12:14.298Z 2025-12-04T14:30:11.234Z
8661600 8661600 20251130161647_wM9Zi AU001B 2025-12-02T14:12:10.133Z 2025-12-04T14:30:10.628Z
8661533 8661533 20251130154442_kDZTQ AU001B 2025-12-02T14:11:49.381Z 2025-12-04T14:30:05.188Z
8661529 8661529 20251130154351_lJ35A AU001B 2025-12-02T14:11:48.307Z 2025-12-04T14:30:04.859Z
8661493 8661493 20251130153612_SNP1G AU001B 2025-12-02T14:11:39.516Z 2025-12-04T14:29:55.249Z

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