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 = "AU001E" 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
8673493 8673493 20251201193909_RW3Tp AU001E 2025-12-03T14:19:00.405Z 2025-12-04T14:24:22.161Z
8673489 8673489 20251201193520_u4Had AU001E 2025-12-03T14:18:59.731Z 2025-12-04T14:24:21.865Z
8673430 8673430 20251201190351_J1428 AU001E 2025-12-03T14:18:50.085Z 2025-12-04T14:24:17.093Z
8673418 8673418 20251201185956_awyiw AU001E 2025-12-03T14:18:48.122Z 2025-12-04T14:24:15.247Z
8673365 8673365 20251201184640_vTFrP AU001E 2025-12-03T14:18:28.563Z 2025-12-04T14:24:07.067Z
8673330 8673330 20251201182928_aXypI AU001E 2025-12-03T14:18:18.476Z 2025-12-04T14:24:01.547Z
8673217 8673217 20251201173156_BwdIl AU001E 2025-12-03T14:18:00.399Z 2025-12-04T14:23:50.746Z
8673165 8673165 20251201171939_TBsGj AU001E 2025-12-03T14:17:43.277Z 2025-12-04T14:23:45.582Z
8672549 8672549 20251201144514_1odoE AU001E 2025-12-03T14:15:53.162Z 2025-12-04T14:22:57.434Z
8672504 8672504 20251201143906_Acipg AU001E 2025-12-03T14:15:41.989Z 2025-12-04T14:22:54.217Z
8672192 8672192 20251201140133_USCvd AU001E 2025-12-03T14:14:55.579Z 2025-12-04T14:22:34.371Z
8662810 8662810 20251130193426_KHSES AU001E 2025-12-02T14:16:46.684Z 2025-12-04T14:31:37.385Z
8662795 8662795 20251130193232_RaNwR AU001E 2025-12-02T14:16:44.285Z 2025-12-04T14:31:36.882Z
8662738 8662738 20251130192536_cDUic AU001E 2025-12-02T14:16:26.539Z 2025-12-04T14:31:33.890Z
8662563 8662563 20251130191107_Bzc5a AU001E 2025-12-02T14:15:54.269Z 2025-12-04T14:31:27.622Z
8662542 8662542 20251130190728_92n2Z AU001E 2025-12-02T14:15:51.731Z 2025-12-04T14:31:26.604Z
8662524 8662524 20251130190556_ppRr9 AU001E 2025-12-02T14:15:49.478Z 2025-12-04T14:31:25.943Z
8662507 8662507 20251130190231_IxNHe AU001E 2025-12-02T14:15:46.178Z 2025-12-04T14:31:25.153Z
8662335 8662335 20251130183422_llitL AU001E 2025-12-02T14:15:10.230Z 2025-12-04T14:31:05.901Z
8662096 8662096 20251130175654_bfbDV AU001E 2025-12-02T14:14:18.032Z 2025-12-04T14:30:52.530Z
8662094 8662094 20251130175647_bvxKB AU001E 2025-12-02T14:14:17.662Z 2025-12-04T14:30:52.428Z
8662019 8662019 20251130174406_TDrOU AU001E 2025-12-02T14:13:59.773Z 2025-12-04T14:30:48.626Z
8661958 8661958 20251130173556_ozW5T AU001E 2025-12-02T14:13:42.291Z 2025-12-04T14:30:44.828Z
8661583 8661583 20251130160621_1cR6X AU001E 2025-12-02T14:12:06.016Z 2025-12-04T14:30:08.966Z
8661249 8661249 20251130150255_EKpqL AU001E 2025-12-02T14:10:56.751Z 2025-12-04T14:29:42.141Z
8660810 8660810 20251130135345_qftJn AU001E 2025-12-02T14:09:14.407Z 2025-12-04T14:29:12.299Z
8660807 8660807 20251130135344_uH6Nx AU001E 2025-12-02T14:09:13.981Z 2025-12-04T14:29:12.178Z
8650309 8650309 20251129195157_jcrso AU001E 2025-12-01T14:15:46.479Z 2025-12-04T14:38:48.612Z
8650290 8650290 20251129194903_nwKrC AU001E 2025-12-01T14:15:43.738Z 2025-12-04T14:38:47.985Z
8650267 8650267 20251129194831_9EDed AU001E 2025-12-01T14:15:41.520Z 2025-12-04T14:38:47.623Z
8650240 8650240 20251129194600_DxmQ4 AU001E 2025-12-01T14:15:32.909Z 2025-12-04T14:38:46.730Z
8650181 8650181 20251129193517_bfBFY AU001E 2025-12-01T14:15:20.079Z 2025-12-04T14:38:44.160Z
8649385 8649385 20251129171829_vsLAu AU001E 2025-12-01T14:12:21.914Z 2025-12-04T14:37:55.327Z
8649328 8649328 20251129170739_jdCZC AU001E 2025-12-01T14:12:01.929Z 2025-12-04T14:37:52.835Z
8649321 8649321 20251129170547_jS5qP AU001E 2025-12-01T14:12:01.065Z 2025-12-04T14:37:52.636Z
8649222 8649222 20251129164302_jmxn7 AU001E 2025-12-01T14:11:29.975Z 2025-12-04T14:37:49.057Z
8649192 8649192 20251129163506_ezY31 AU001E 2025-12-01T14:11:23.892Z 2025-12-04T14:37:47.828Z
8649185 8649185 20251129163321_dytbt AU001E 2025-12-01T14:11:22.263Z 2025-12-04T14:37:47.523Z
8649157 8649157 20251129162740_FBpLz AU001E 2025-12-01T14:11:14.582Z 2025-12-04T14:37:46.364Z
8649135 8649135 20251129162059_ZDlcM AU001E 2025-12-01T14:11:04.743Z 2025-12-04T14:37:44.832Z
8649116 8649116 20251129161607_hXlBu AU001E 2025-12-01T14:10:59.598Z 2025-12-04T14:37:37.222Z
8649090 8649090 20251129160734_tF3Gq AU001E 2025-12-01T14:10:52.676Z 2025-12-04T14:37:29.009Z
8648988 8648988 20251129154035_y28sr AU001E 2025-12-01T14:10:21.394Z 2025-12-04T14:37:21.469Z
8648986 8648986 20251129154001_xtB69 AU001E 2025-12-01T14:10:18.484Z 2025-12-04T14:37:21.373Z
8648918 8648918 20251129150744_VuPJY AU001E 2025-12-01T14:09:34.326Z 2025-12-04T14:37:14.751Z
8648879 8648879 20251129142542_MgcDD AU001E 2025-12-01T14:08:52.019Z 2025-12-04T14:37:08.621Z
8648855 8648855 20251129141114_lelBA AU001E 2025-12-01T14:08:30.111Z 2025-12-04T14:37:05.861Z
8644508 8644508 20251128192909_ZdPXw AU001E 2025-11-30T14:22:03.299Z 2025-12-04T14:48:27.757Z
8644420 8644420 20251128192601_Ce83M AU001E 2025-11-30T14:21:59.002Z 2025-12-04T14:48:26.619Z
8644346 8644346 20251128192234_nuBNq AU001E 2025-11-30T14:21:40.568Z 2025-12-04T14:48:25.101Z
8644294 8644294 20251128191835_RHgZJ AU001E 2025-11-30T14:21:36.246Z 2025-12-04T14:48:24.143Z
8644270 8644270 20251128191342_WppGl AU001E 2025-11-30T14:21:32.934Z 2025-12-04T14:48:23.517Z
8644174 8644174 20251128190527_AQYUh AU001E 2025-11-30T14:21:26.152Z 2025-12-04T14:48:21.627Z
8644142 8644142 20251128190223_ppEqP AU001E 2025-11-30T14:21:24.084Z 2025-12-04T14:48:20.996Z
8644079 8644079 20251128185554_sO3L1 AU001E 2025-11-30T14:21:18.915Z 2025-12-04T14:48:19.606Z
8643896 8643896 20251128183657_Cf0qM AU001E 2025-11-30T14:20:47.657Z 2025-12-04T14:48:15.582Z
8643373 8643373 20251128174656_5ePtJ AU001E 2025-11-30T14:19:57.158Z 2025-12-04T14:47:43.681Z
8638170 8638170 20251126190249_P2RyB AU001E 2025-11-29T14:33:30.805Z 2025-12-04T15:02:29.012Z
8631062 8631062 20251127180949_WlMwL AU001E 2025-11-29T14:14:29.848Z 2025-12-04T14:54:25.278Z
8622247 8622247 20251126182357_CwonV AU001E 2025-11-28T14:18:13.769Z 2025-12-04T15:02:04.094Z
8622241 8622241 20251126182243_6HZ3e AU001E 2025-11-28T14:18:12.819Z 2025-12-04T15:02:03.824Z
8622182 8622182 20251126180832_C7aZM AU001E 2025-11-28T14:18:04.695Z 2025-12-04T15:01:57.478Z
8622046 8622046 20251126173921_TbiIK AU001E 2025-11-28T14:17:33.151Z 2025-12-04T15:01:50.443Z
8605677 8605677 20251125155740_Vdq3t AU001E 2025-11-27T14:07:17.046Z 2025-12-04T15:05:36.728Z
8595576 8595576 20251124170241_s2Obg AU001E 2025-11-26T14:11:40.684Z 2025-12-02T15:06:01.850Z
8595518 8595518 20251124163753_1321P AU001E 2025-11-26T14:11:31.378Z 2025-12-02T15:06:00.136Z
8595115 8595115 20251124140921_87GNf AU001E 2025-11-26T14:10:06.537Z 2025-12-02T15:05:41.007Z
8586065 8586065 20251123183811_QEjD3 AU001E 2025-11-25T14:11:45.300Z 2025-12-02T15:10:40.168Z
8577932 8577932 20251122191256_vE28k AU001E 2025-11-24T14:10:12.400Z 2025-12-01T15:19:03.605Z
8577808 8577808 20251122185625_Aym2z AU001E 2025-11-24T14:09:43.546Z 2025-12-01T15:18:58.850Z
8577697 8577697 20251122184750_16D1Q AU001E 2025-11-24T14:09:27.844Z 2025-12-01T15:18:56.656Z
8577679 8577679 20251122184556_FeqUT AU001E 2025-11-24T14:09:25.347Z 2025-12-01T15:18:56.277Z
8577449 8577449 20251122181008_A38Yw AU001E 2025-11-24T14:08:38.363Z 2025-12-01T15:18:50.493Z
8577257 8577257 20251122174448_JFYOy AU001E 2025-11-24T14:08:06.917Z 2025-12-01T15:18:45.755Z
8577154 8577154 20251122172607_w3bZJ AU001E 2025-11-24T14:07:50.819Z 2025-12-01T15:18:44.314Z
8576819 8576819 20251122162022_AkKDi AU001E 2025-11-24T14:06:48.712Z 2025-12-01T15:18:40.459Z
8575970 8575970 20251122135726_3oU0E AU001E 2025-11-24T14:04:35.445Z 2025-12-01T15:18:32.185Z
8563266 8563266 20251121154008_b5DBg AU001E 2025-11-23T14:07:53.361Z 2025-11-30T15:03:37.122Z
8563230 8563230 20251121153332_0erXw AU001E 2025-11-23T14:07:41.041Z 2025-11-30T15:03:36.712Z
8562821 8562821 20251121144745_ywuD8 AU001E 2025-11-23T14:06:36.487Z 2025-11-30T15:03:33.200Z
8562696 8562696 20251121143851_9p8XV AU001E 2025-11-23T14:06:23.065Z 2025-11-30T15:03:32.384Z
8562365 8562365 20251121141039_XiZMd AU001E 2025-11-23T14:05:28.615Z 2025-11-30T15:03:28.259Z
8562254 8562254 20251121135459_zcLpf AU001E 2025-11-23T14:05:11.293Z 2025-11-30T15:03:25.567Z
8502675 8502675 20251117152707_ZZM9U AU001E 2025-11-19T14:03:18.311Z 2025-11-26T15:06:13.235Z
8502644 8502644 20251117152155_zhRuE AU001E 2025-11-19T14:03:15.510Z 2025-11-26T15:06:13.000Z
8502606 8502606 20251117151414_nD3LG AU001E 2025-11-19T14:03:10.848Z 2025-11-26T15:06:12.354Z
8502375 8502375 20251117141941_BUt2Q AU001E 2025-11-19T14:02:19.801Z 2025-11-26T15:06:09.809Z
8502246 8502246 20251117133643_afs28 AU001E 2025-11-19T14:02:03.695Z 2025-11-26T15:06:07.937Z
8501667 8501667 20251114192404_ghWBe AU001E 2025-11-18T14:50:10.611Z 2025-11-23T15:17:06.000Z
8500006 8500006 20251115195641_W2VIs AU001E 2025-11-18T14:42:00.680Z 2025-11-24T15:04:47.841Z
8498746 8498746 20251116173436_WpnCm AU001E 2025-11-18T14:31:22.434Z 2025-11-25T15:07:41.039Z
8489656 8489656 20251116171639_2vPHM AU001E 2025-11-18T14:11:00.761Z 2025-11-25T15:07:34.976Z
8489296 8489296 20251116155245_R3WLh AU001E 2025-11-18T14:09:30.899Z 2025-11-25T15:07:23.630Z
8489229 8489229 20251116154120_Oqh6d AU001E 2025-11-18T14:09:13.760Z 2025-11-25T15:07:21.705Z
8488969 8488969 20251116151646_vFCzD AU001E 2025-11-18T14:08:11.758Z 2025-11-25T15:07:00.544Z
8488513 8488513 20251116143345_0Dqdp AU001E 2025-11-18T14:06:44.123Z 2025-11-25T15:06:49.381Z
8488505 8488505 20251116143242_B22x7 AU001E 2025-11-18T14:06:42.240Z 2025-11-25T15:06:48.671Z
8488115 8488115 20251116135800_6Jq5H AU001E 2025-11-18T14:05:27.919Z 2025-11-25T15:06:40.608Z
8487908 8487908 20251116134141_zN9LB AU001E 2025-11-18T14:04:49.423Z 2025-11-25T15:06:31.988Z
8479402 8479402 20251115191548_i2p2C AU001E 2025-11-17T14:15:47.790Z 2025-11-24T15:04:44.487Z

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