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 = "AU001P" 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
8679356 8679356 20251202195130_9QQqQ AU001P 2025-12-04T14:09:32.222Z 2025-12-04T14:19:08.301Z
8679354 8679354 20251202195129_1x96k AU001P 2025-12-04T14:09:31.856Z 2025-12-04T14:19:08.301Z
8679352 8679352 20251202195126_6LL2f AU001P 2025-12-04T14:09:31.392Z 2025-12-04T14:19:08.300Z
8679349 8679349 20251202194908_FLpOJ AU001P 2025-12-04T14:09:30.965Z 2025-12-04T14:19:08.299Z
8679311 8679311 20251202194224_hZSOd AU001P 2025-12-04T14:09:24.878Z 2025-12-04T14:19:08.293Z
8679310 8679310 20251202194134_pG5NZ AU001P 2025-12-04T14:09:24.381Z 2025-12-04T14:19:08.292Z
8679286 8679286 20251202193709_7RHKE AU001P 2025-12-04T14:09:21.088Z 2025-12-04T14:19:08.288Z
8679174 8679174 20251202191555_yxU2T AU001P 2025-12-04T14:09:09.479Z 2025-12-04T14:19:08.269Z
8678899 8678899 20251202180619_jZjQJ AU001P 2025-12-04T14:08:29.124Z 2025-12-04T14:19:08.222Z
8673530 8673530 20251201195346_JdEKu AU001P 2025-12-03T14:19:08.252Z 2025-12-04T14:24:24.700Z
8673526 8673526 20251201195227_bri4F AU001P 2025-12-03T14:19:07.352Z 2025-12-04T14:24:24.172Z
8673500 8673500 20251201194115_CzzbP AU001P 2025-12-03T14:19:00.958Z 2025-12-04T14:24:22.439Z
8673484 8673484 20251201192650_djUFD AU001P 2025-12-03T14:18:58.867Z 2025-12-04T14:24:21.609Z
8673479 8673479 20251201192450_dAYmR AU001P 2025-12-03T14:18:58.130Z 2025-12-04T14:24:21.323Z
8673415 8673415 20251201185947_cSN6F AU001P 2025-12-03T14:18:47.649Z 2025-12-04T14:24:14.578Z
8673397 8673397 20251201185510_y3d44 AU001P 2025-12-03T14:18:45.203Z 2025-12-04T14:24:13.353Z
8673389 8673389 20251201185334_nRyMh AU001P 2025-12-03T14:18:41.523Z 2025-12-04T14:24:12.502Z
8673282 8673282 20251201180829_7Ygp9 AU001P 2025-12-03T14:18:10.931Z 2025-12-04T14:23:57.141Z
8673273 8673273 20251201175927_9yYTZ AU001P 2025-12-03T14:18:09.464Z 2025-12-04T14:23:55.860Z
8671435 8671435 20251201121847_M5jOn AU001P 2025-12-03T14:12:28.352Z 2025-12-04T14:21:44.896Z
8662925 8662925 20251130194716_4by6E AU001P 2025-12-02T14:17:02.499Z 2025-12-04T14:31:41.393Z
8662888 8662888 20251130194551_JGHXm AU001P 2025-12-02T14:16:56.953Z 2025-12-04T14:31:40.120Z
8662841 8662841 20251130193844_hHboM AU001P 2025-12-02T14:16:50.246Z 2025-12-04T14:31:38.339Z
8662457 8662457 20251130185237_3eCZo AU001P 2025-12-02T14:15:39.576Z 2025-12-04T14:31:23.011Z
8662436 8662436 20251130184953_hZe5o AU001P 2025-12-02T14:15:28.244Z 2025-12-04T14:31:21.880Z
8662422 8662422 20251130184819_3voIo AU001P 2025-12-02T14:15:26.773Z 2025-12-04T14:31:20.368Z
8662392 8662392 20251130184249_ynOlU AU001P 2025-12-02T14:15:20.593Z 2025-12-04T14:31:08.795Z
8662360 8662360 20251130183810_jLwpZ AU001P 2025-12-02T14:15:14.305Z 2025-12-04T14:31:07.257Z
8662339 8662339 20251130183441_BMBYL AU001P 2025-12-02T14:15:10.654Z 2025-12-04T14:31:06.029Z
8662331 8662331 20251130183417_lYIfA AU001P 2025-12-02T14:15:09.805Z 2025-12-04T14:31:05.784Z
8662263 8662263 20251130182454_SA22b AU001P 2025-12-02T14:14:51.760Z 2025-12-04T14:31:00.460Z
8662226 8662226 20251130181946_wwjSy AU001P 2025-12-02T14:14:44.542Z 2025-12-04T14:30:59.198Z
8662164 8662164 20251130180934_Wm1ca AU001P 2025-12-02T14:14:34.561Z 2025-12-04T14:30:56.436Z
8662090 8662090 20251130175357_YcSHO AU001P 2025-12-02T14:14:16.771Z 2025-12-04T14:30:52.304Z
8661986 8661986 20251130173948_h7Unz AU001P 2025-12-02T14:13:48.526Z 2025-12-04T14:30:46.281Z
8661965 8661965 20251130173721_BiS3k AU001P 2025-12-02T14:13:44.299Z 2025-12-04T14:30:45.267Z
8661916 8661916 20251130173044_WBK4q AU001P 2025-12-02T14:13:36.617Z 2025-12-04T14:30:40.001Z
8661911 8661911 20251130173031_6c72C AU001P 2025-12-02T14:13:35.703Z 2025-12-04T14:30:34.959Z
8661890 8661890 20251130172948_8ThfZ AU001P 2025-12-02T14:13:32.781Z 2025-12-04T14:30:31.255Z
8661867 8661867 20251130172454_5VENF AU001P 2025-12-02T14:13:20.326Z 2025-12-04T14:30:29.500Z
8661798 8661798 20251130171253_5EU4H AU001P 2025-12-02T14:13:04.228Z 2025-12-04T14:30:23.705Z
8661763 8661763 20251130170821_4N1ox AU001P 2025-12-02T14:12:57.594Z 2025-12-04T14:30:22.370Z
8661741 8661741 20251130170325_MM0H7 AU001P 2025-12-02T14:12:53.032Z 2025-12-04T14:30:20.546Z
8661718 8661718 20251130165811_AQZRS AU001P 2025-12-02T14:12:42.953Z 2025-12-04T14:30:19.287Z
8661645 8661645 20251130164039_2hx3W AU001P 2025-12-02T14:12:27.292Z 2025-12-04T14:30:13.981Z
8650332 8650332 20251129195646_4RC8a AU001P 2025-12-01T14:15:50.338Z 2025-12-04T14:38:51.613Z
8650321 8650321 20251129195253_OUeXU AU001P 2025-12-01T14:15:48.510Z 2025-12-04T14:38:48.894Z
8650316 8650316 20251129195240_8LdW0 AU001P 2025-12-01T14:15:47.309Z 2025-12-04T14:38:48.735Z
8650314 8650314 20251129195206_2t2nL AU001P 2025-12-01T14:15:46.944Z 2025-12-04T14:38:48.691Z
8650235 8650235 20251129194503_GzdXr AU001P 2025-12-01T14:15:31.453Z 2025-12-04T14:38:46.492Z
8650148 8650148 20251129192906_YiJS6 AU001P 2025-12-01T14:15:14.133Z 2025-12-04T14:38:42.776Z
8650095 8650095 20251129192048_1pG63 AU001P 2025-12-01T14:15:03.735Z 2025-12-04T14:38:41.190Z
8650071 8650071 20251129191753_hQqCa AU001P 2025-12-01T14:14:59.722Z 2025-12-04T14:38:40.304Z
8650067 8650067 20251129191528_Ei4St AU001P 2025-12-01T14:14:58.558Z 2025-12-04T14:38:39.863Z
8650030 8650030 20251129190922_q2XAb AU001P 2025-12-01T14:14:44.717Z 2025-12-04T14:38:38.349Z
8649993 8649993 20251129190133_5qTcu AU001P 2025-12-01T14:14:39.718Z 2025-12-04T14:38:36.990Z
8649890 8649890 20251129184931_UnfKQ AU001P 2025-12-01T14:14:15.600Z 2025-12-04T14:38:33.468Z
8649866 8649866 20251129184103_pC2a9 AU001P 2025-12-01T14:14:09.992Z 2025-12-04T14:38:32.140Z
8649813 8649813 20251129183255_wluA9 AU001P 2025-12-01T14:14:02.011Z 2025-12-04T14:38:29.375Z
8649746 8649746 20251129181713_SlSRr AU001P 2025-12-01T14:13:44.091Z 2025-12-04T14:38:11.928Z
8649734 8649734 20251129181439_48qyj AU001P 2025-12-01T14:13:41.773Z 2025-12-04T14:38:11.265Z
8649553 8649553 20251129174717_CS7qB AU001P 2025-12-01T14:13:01.975Z 2025-12-04T14:38:03.225Z
8649533 8649533 20251129174242_U4Lij AU001P 2025-12-01T14:12:58.665Z 2025-12-04T14:38:02.357Z
8649519 8649519 20251129173834_7r6fh AU001P 2025-12-01T14:12:54.781Z 2025-12-04T14:38:01.302Z
8649450 8649450 20251129172741_2Eq5L AU001P 2025-12-01T14:12:37.844Z 2025-12-04T14:37:58.428Z
8649388 8649388 20251129171836_Gzm5o AU001P 2025-12-01T14:12:22.561Z 2025-12-04T14:37:55.416Z
8649355 8649355 20251129171408_Jl3Jb AU001P 2025-12-01T14:12:11.081Z 2025-12-04T14:37:54.197Z
8644716 8644716 20251128194716_NSpOe AU001P 2025-11-30T14:22:20.060Z 2025-12-04T14:48:34.191Z
8644682 8644682 20251128194351_RyAK6 AU001P 2025-11-30T14:22:14.336Z 2025-12-04T14:48:33.491Z
8644544 8644544 20251128193208_2us2h AU001P 2025-11-30T14:22:05.522Z 2025-12-04T14:48:28.410Z
8644352 8644352 20251128192314_IJDuI AU001P 2025-11-30T14:21:41.008Z 2025-12-04T14:48:25.203Z
8644214 8644214 20251128190812_P9iw9 AU001P 2025-11-30T14:21:28.569Z 2025-12-04T14:48:22.266Z
8643765 8643765 20251128182507_Uvv6e AU001P 2025-11-30T14:20:39.098Z 2025-12-04T14:47:51.981Z
8643750 8643750 20251128182232_FLtrJ AU001P 2025-11-30T14:20:38.429Z 2025-12-04T14:47:51.792Z
8643289 8643289 20251128174112_mjBds AU001P 2025-11-30T14:19:50.438Z 2025-12-04T14:47:41.967Z
8643212 8643212 20251128173505_lt8sP AU001P 2025-11-30T14:19:32.140Z 2025-12-04T14:47:40.633Z
8642807 8642807 20251128165115_QrBo1 AU001P 2025-11-30T14:18:38.170Z 2025-12-04T14:47:33.122Z
8642709 8642709 20251128164020_gtJHI AU001P 2025-11-30T14:18:30.103Z 2025-12-04T14:47:31.363Z
8642558 8642558 20251128162218_On6Ea AU001P 2025-11-30T14:18:18.247Z 2025-12-04T14:47:09.183Z
8631512 8631512 20251127191945_LVVml AU001P 2025-11-29T14:15:39.334Z 2025-12-04T14:54:35.278Z
8631492 8631492 20251127191626_aUQMg AU001P 2025-11-29T14:15:37.275Z 2025-12-04T14:54:34.802Z
8631447 8631447 20251127190845_N2YvN AU001P 2025-11-29T14:15:22.381Z 2025-12-04T14:54:33.859Z
8631354 8631354 20251127185220_dLpD8 AU001P 2025-11-29T14:15:09.287Z 2025-12-04T14:54:31.527Z
8631308 8631308 20251127184740_MXoO3 AU001P 2025-11-29T14:15:05.933Z 2025-12-04T14:54:30.839Z
8630755 8630755 20251127171403_61wn3 AU001P 2025-11-29T14:13:40.126Z 2025-12-04T14:54:18.097Z
8630578 8630578 20251127164648_i2cBL AU001P 2025-11-29T14:13:02.328Z 2025-12-04T14:53:56.448Z
8630094 8630094 20251127141817_yQ5I7 AU001P 2025-11-29T14:11:33.519Z 2025-12-04T14:53:28.126Z
8622509 8622509 20251126194047_V1Rf0 AU001P 2025-11-28T14:19:01.494Z 2025-12-04T15:02:46.017Z
8622492 8622492 20251126193737_aU9bC AU001P 2025-11-28T14:18:59.107Z 2025-12-04T15:02:45.598Z
8622490 8622490 20251126193615_dplR2 AU001P 2025-11-28T14:18:58.741Z 2025-12-04T15:02:45.510Z
8622488 8622488 20251126193510_YxpEB AU001P 2025-11-28T14:18:58.355Z 2025-12-04T15:02:45.481Z
8622427 8622427 20251126191532_jmHAh AU001P 2025-11-28T14:18:51.027Z 2025-12-04T15:02:39.538Z
8622392 8622392 20251126190224_aNayt AU001P 2025-11-28T14:18:46.313Z 2025-12-04T15:02:28.556Z
8622385 8622385 20251126190057_naOAW AU001P 2025-11-28T14:18:45.163Z 2025-12-04T15:02:27.577Z
8622332 8622332 20251126184931_T2d1w AU001P 2025-11-28T14:18:26.484Z 2025-12-04T15:02:20.082Z
8622254 8622254 20251126182542_9rjEL AU001P 2025-11-28T14:18:14.940Z 2025-12-04T15:02:06.291Z
8622237 8622237 20251126182144_j0kj0 AU001P 2025-11-28T14:18:12.191Z 2025-12-04T15:02:03.649Z
8622221 8622221 20251126181854_3AEDm AU001P 2025-11-28T14:18:10.097Z 2025-12-04T15:02:03.244Z
8622207 8622207 20251126181416_qWAVc AU001P 2025-11-28T14:18:07.744Z 2025-12-04T15:02:01.395Z
8622163 8622163 20251126180244_y5mfe AU001P 2025-11-28T14:17:50.986Z 2025-12-04T15:01:53.272Z

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