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 = "AU0002" 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
8679418 8679418 20251202200721_Eb2zJ AU0002 2025-12-04T14:09:47.278Z 2025-12-04T14:19:08.314Z
8679366 8679366 20251202195349_bldmp AU0002 2025-12-04T14:09:39.907Z 2025-12-04T14:19:08.304Z
8679350 8679350 20251202195126_6LL2f AU0002 2025-12-04T14:09:31.392Z 2025-12-04T14:19:08.300Z
8679347 8679347 20251202194908_FLpOJ AU0002 2025-12-04T14:09:30.965Z 2025-12-04T14:19:08.299Z
8679284 8679284 20251202193709_7RHKE AU0002 2025-12-04T14:09:21.088Z 2025-12-04T14:19:08.287Z
8679173 8679173 20251202191555_yxU2T AU0002 2025-12-04T14:09:09.479Z 2025-12-04T14:19:08.269Z
8679164 8679164 20251202191114_liAPo AU0002 2025-12-04T14:09:08.495Z 2025-12-04T14:19:08.268Z
8673542 8673542 20251201195930_FX6iA AU0002 2025-12-03T14:19:09.732Z 2025-12-04T14:24:25.533Z
8673491 8673491 20251201193654_FVYBf AU0002 2025-12-03T14:19:00.085Z 2025-12-04T14:24:21.943Z
8673465 8673465 20251201192258_0J8z9 AU0002 2025-12-03T14:18:56.040Z 2025-12-04T14:24:20.309Z
8673438 8673438 20251201191235_2KrXt AU0002 2025-12-03T14:18:51.997Z 2025-12-04T14:24:17.917Z
8673434 8673434 20251201190937_c69EV AU0002 2025-12-03T14:18:51.046Z 2025-12-04T14:24:17.623Z
8673405 8673405 20251201185812_dIGvJ AU0002 2025-12-03T14:18:46.665Z 2025-12-04T14:24:14.064Z
8673394 8673394 20251201185510_y3d44 AU0002 2025-12-03T14:18:45.203Z 2025-12-04T14:24:13.353Z
8673360 8673360 20251201184546_MOJA9 AU0002 2025-12-03T14:18:28.332Z 2025-12-04T14:24:06.937Z
8673318 8673318 20251201182246_1Ji4L AU0002 2025-12-03T14:18:16.018Z 2025-12-04T14:24:00.407Z
8673310 8673310 20251201182129_Dwh2w AU0002 2025-12-03T14:18:15.106Z 2025-12-04T14:24:00.209Z
8673264 8673264 20251201175655_i2iBv AU0002 2025-12-03T14:18:07.981Z 2025-12-04T14:23:54.811Z
8673257 8673257 20251201175311_Xe0c0 AU0002 2025-12-03T14:18:07.073Z 2025-12-04T14:23:54.321Z
8673160 8673160 20251201171512_2Fa56 AU0002 2025-12-03T14:17:42.364Z 2025-12-04T14:23:41.546Z
8673133 8673133 20251201170629_HtZMV AU0002 2025-12-03T14:17:38.547Z 2025-12-04T14:23:38.913Z
8673102 8673102 20251201165557_lthYV AU0002 2025-12-03T14:17:33.806Z 2025-12-04T14:23:36.832Z
8673093 8673093 20251201165346_2o0sd AU0002 2025-12-03T14:17:32.421Z 2025-12-04T14:23:34.385Z
8673067 8673067 20251201164259_HXVHq AU0002 2025-12-03T14:17:17.302Z 2025-12-04T14:23:32.240Z
8673047 8673047 20251201163108_AbN3c AU0002 2025-12-03T14:17:14.714Z 2025-12-04T14:23:31.081Z
8673015 8673015 20251201162125_fWrMb AU0002 2025-12-03T14:17:07.560Z 2025-12-04T14:23:29.346Z
8672990 8672990 20251201161309_nCROj AU0002 2025-12-03T14:17:04.888Z 2025-12-04T14:23:27.810Z
8672985 8672985 20251201160702_4odtA AU0002 2025-12-03T14:17:04.045Z 2025-12-04T14:23:27.486Z
8672899 8672899 20251201153702_1C21g AU0002 2025-12-03T14:16:52.918Z 2025-12-04T14:23:22.327Z
8672878 8672878 20251201153437_dELHP AU0002 2025-12-03T14:16:50.852Z 2025-12-04T14:23:20.816Z
8672851 8672851 20251201152858_xj7rm AU0002 2025-12-03T14:16:41.925Z 2025-12-04T14:23:14.467Z
8672560 8672560 20251201144649_IpJR0 AU0002 2025-12-03T14:15:54.648Z 2025-12-04T14:22:58.262Z
8671762 8671762 20251201125626_OIX1P AU0002 2025-12-03T14:13:40.680Z 2025-12-04T14:22:05.422Z
8667254 8667254 20251129192500_yw7oI AU0002 2025-12-02T14:35:56.988Z 2025-12-04T14:38:41.951Z
8662881 8662881 20251130194440_LrZfC AU0002 2025-12-02T14:16:55.483Z 2025-12-04T14:31:39.770Z
8662839 8662839 20251130193844_hHboM AU0002 2025-12-02T14:16:50.246Z 2025-12-04T14:31:38.339Z
8662742 8662742 20251130192608_d52m6 AU0002 2025-12-02T14:16:27.213Z 2025-12-04T14:31:34.107Z
8662713 8662713 20251130192332_MdHBt AU0002 2025-12-02T14:16:23.005Z 2025-12-04T14:31:32.725Z
8662504 8662504 20251130190112_by6R3 AU0002 2025-12-02T14:15:45.724Z 2025-12-02T14:15:45.724Z
8662458 8662458 20251130185406_KWh0L AU0002 2025-12-02T14:15:39.837Z 2025-12-04T14:31:23.094Z
8662440 8662440 20251130185044_0Avc9 AU0002 2025-12-02T14:15:29.068Z 2025-12-04T14:31:22.120Z
8662437 8662437 20251130185016_O3Dq1 AU0002 2025-12-02T14:15:28.721Z 2025-12-04T14:31:22.034Z
8662432 8662432 20251130184953_hZe5o AU0002 2025-12-02T14:15:28.244Z 2025-12-04T14:31:21.880Z
8662423 8662423 20251130184908_yPBG2 AU0002 2025-12-02T14:15:27.155Z 2025-12-04T14:31:20.506Z
8662408 8662408 20251130184559_2zsSV AU0002 2025-12-02T14:15:24.045Z 2025-12-04T14:31:09.785Z
8662397 8662397 20251130184331_JVejo AU0002 2025-12-02T14:15:21.992Z 2025-12-04T14:31:09.199Z
8662395 8662395 20251130184305_iA3GQ AU0002 2025-12-02T14:15:21.668Z 2025-12-04T14:31:09.012Z
8662358 8662358 20251130183810_jLwpZ AU0002 2025-12-02T14:15:14.305Z 2025-12-04T14:31:07.257Z
8662355 8662355 20251130183755_2xP9G AU0002 2025-12-02T14:15:14.114Z 2025-12-04T14:31:07.204Z
8662151 8662151 20251130180716_w0Ycz AU0002 2025-12-02T14:14:31.825Z 2025-12-04T14:30:55.731Z
8661940 8661940 20251130173416_SL9uB AU0002 2025-12-02T14:13:39.779Z 2025-12-04T14:30:43.739Z
8661908 8661908 20251130173023_O2o2s AU0002 2025-12-02T14:13:35.285Z 2025-12-04T14:30:31.945Z
8661872 8661872 20251130172615_pggi3 AU0002 2025-12-02T14:13:28.469Z 2025-12-04T14:30:29.901Z
8661825 8661825 20251130171916_oTCFH AU0002 2025-12-02T14:13:10.121Z 2025-12-04T14:30:27.006Z
8661818 8661818 20251130171801_dqOJl AU0002 2025-12-02T14:13:08.851Z 2025-12-04T14:30:24.686Z
8661723 8661723 20251130170022_ifKJM AU0002 2025-12-02T14:12:49.545Z 2025-12-04T14:30:19.713Z
8661620 8661620 20251130163418_WvZKv AU0002 2025-12-02T14:12:21.445Z 2025-12-04T14:30:12.335Z
8661598 8661598 20251130161646_I8Wk4 AU0002 2025-12-02T14:12:09.729Z 2025-12-04T14:30:10.527Z
8661519 8661519 20251130154211_Bp4f3 AU0002 2025-12-02T14:11:44.538Z 2025-12-04T14:30:01.878Z
8661515 8661515 20251130154130_zd7wx AU0002 2025-12-02T14:11:43.860Z 2025-12-04T14:29:57.930Z
8661477 8661477 20251130152945_fin6D AU0002 2025-12-02T14:11:36.581Z 2025-12-04T14:29:54.627Z
8661414 8661414 20251130151814_Fqtaf AU0002 2025-12-02T14:11:25.968Z 2025-12-04T14:29:49.048Z
8660811 8660811 20251130135349_LGlPm AU0002 2025-12-02T14:09:14.934Z 2025-12-04T14:29:12.479Z
8660696 8660696 20251130133513_Tbaqu AU0002 2025-12-02T14:08:49.084Z 2025-12-04T14:29:07.560Z
8660648 8660648 20251130132304_y5kzj AU0002 2025-12-02T14:08:39.958Z 2025-12-04T14:29:04.649Z
8660574 8660574 20251130130801_WuKoI AU0002 2025-12-02T14:08:18.671Z 2025-12-04T14:29:01.165Z
8660506 8660506 20251130130101_cUAbK AU0002 2025-12-02T14:08:11.054Z 2025-12-04T14:28:58.973Z
8650326 8650326 20251129195446_w6yCU AU0002 2025-12-01T14:15:49.484Z 2025-12-04T14:38:49.317Z
8650315 8650315 20251129195240_8LdW0 AU0002 2025-12-01T14:15:47.309Z 2025-12-04T14:38:48.734Z
8650227 8650227 20251129194320_kcdv4 AU0002 2025-12-01T14:15:29.728Z 2025-12-04T14:38:46.268Z
8650087 8650087 20251129191921_b5DST AU0002 2025-12-01T14:15:02.438Z 2025-12-04T14:38:40.868Z
8649920 8649920 20251129185303_9NPtv AU0002 2025-12-01T14:14:26.873Z 2025-12-04T14:38:34.499Z
8649914 8649914 20251129185203_UrZ9n AU0002 2025-12-01T14:14:25.057Z 2025-12-01T14:35:20.981Z
8649908 8649908 20251129185052_0r9Nf AU0002 2025-12-01T14:14:18.407Z 2025-12-04T14:38:33.975Z
8649874 8649874 20251129184447_26NxK AU0002 2025-12-01T14:14:11.642Z 2025-12-04T14:38:32.633Z
8649872 8649872 20251129184433_3STew AU0002 2025-12-01T14:14:11.144Z 2025-12-04T14:38:32.579Z
8649864 8649864 20251129184056_KACXe AU0002 2025-12-01T14:14:09.630Z 2025-12-01T14:35:20.958Z
8649826 8649826 20251129183647_r90Pp AU0002 2025-12-01T14:14:04.242Z 2025-12-04T14:38:30.766Z
8649812 8649812 20251129183255_wluA9 AU0002 2025-12-01T14:14:02.011Z 2025-12-04T14:38:29.375Z
8649789 8649789 20251129182600_WDzwI AU0002 2025-12-01T14:13:57.696Z 2025-12-04T14:38:27.141Z
8649774 8649774 20251129182323_tDiah AU0002 2025-12-01T14:13:54.195Z 2025-12-04T14:38:16.849Z
8649727 8649727 20251129181323_HXil2 AU0002 2025-12-01T14:13:37.846Z 2025-12-01T14:35:20.874Z
8649723 8649723 20251129181226_dyDdQ AU0002 2025-12-01T14:13:37.037Z 2025-12-04T14:38:10.710Z
8649682 8649682 20251129180628_QPFpb AU0002 2025-12-01T14:13:29.727Z 2025-12-04T14:38:09.524Z
8649586 8649586 20251129175308_bglzt AU0002 2025-12-01T14:13:10.969Z 2025-12-01T14:35:20.824Z
8649552 8649552 20251129174717_CS7qB AU0002 2025-12-01T14:13:01.975Z 2025-12-04T14:38:03.225Z
8649544 8649544 20251129174447_2Sw4j AU0002 2025-12-01T14:13:00.451Z 2025-12-04T14:38:02.814Z
8649532 8649532 20251129174242_U4Lij AU0002 2025-12-01T14:12:58.665Z 2025-12-04T14:38:02.357Z
8649449 8649449 20251129172741_2Eq5L AU0002 2025-12-01T14:12:37.844Z 2025-12-04T14:37:58.428Z
8649430 8649430 20251129172557_3pK2b AU0002 2025-12-01T14:12:31.664Z 2025-12-01T14:35:20.733Z
8649387 8649387 20251129171836_Gzm5o AU0002 2025-12-01T14:12:22.560Z 2025-12-04T14:37:55.416Z
8649292 8649292 20251129170019_M3Ke9 AU0002 2025-12-01T14:11:55.263Z 2025-12-04T14:37:51.702Z
8649242 8649242 20251129164935_jI2oy AU0002 2025-12-01T14:11:38.007Z 2025-12-04T14:37:50.080Z
8649152 8649152 20251129162734_pwpJm AU0002 2025-12-01T14:11:13.565Z 2025-12-04T14:37:46.189Z
8649132 8649132 20251129162058_grSzR AU0002 2025-12-01T14:11:04.183Z 2025-12-04T14:37:44.677Z
8649120 8649120 20251129161704_mrWGd AU0002 2025-12-01T14:11:00.489Z 2025-12-04T14:37:42.358Z
8649063 8649063 20251129155916_8QhWa AU0002 2025-12-01T14:10:46.428Z 2025-12-04T14:37:27.797Z
8648994 8648994 20251129154124_DQzeM AU0002 2025-12-01T14:10:23.112Z 2025-12-04T14:37:21.732Z
8648926 8648926 20251129151244_eTpnl AU0002 2025-12-01T14:09:44.540Z 2025-12-04T14:37:16.001Z
8648560 8648560 20251127165101_9g2dN AU0002 2025-11-30T14:33:33.384Z 2025-12-04T14:54:02.721Z

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