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
8699000 8699000 20251206193824_TCBft AU001E 2025-12-08T14:19:56.858Z 2025-12-11T14:31:22.307Z
8698972 8698972 20251206192429_T5rQZ AU001E 2025-12-08T14:19:51.362Z 2025-12-11T14:31:20.434Z
8698962 8698962 20251206191822_Nx1NC AU001E 2025-12-08T14:19:50.518Z 2025-12-11T14:31:19.746Z
8698939 8698939 20251206190039_Hn8E7 AU001E 2025-12-08T14:19:45.123Z 2025-12-11T14:31:12.782Z
8698938 8698938 20251206190039_ZpHgu AU001E 2025-12-08T14:19:44.757Z 2025-12-11T14:31:12.251Z
8698915 8698915 20251206184610_j1Rqn AU001E 2025-12-08T14:19:32.783Z 2025-12-11T14:30:58.095Z
8698913 8698913 20251206184512_gsYmv AU001E 2025-12-08T14:19:32.472Z 2025-12-11T14:30:57.829Z
8698898 8698898 20251206182903_DYtGS AU001E 2025-12-08T14:19:28.756Z 2025-12-11T14:30:54.809Z
8698896 8698896 20251206182856_uYYqY AU001E 2025-12-08T14:19:28.439Z 2025-12-11T14:30:54.684Z
8698895 8698895 20251206182855_8C21H AU001E 2025-12-08T14:19:28.139Z 2025-12-11T14:30:54.579Z
8698882 8698882 20251206181913_XCuD5 AU001E 2025-12-08T14:19:26.065Z 2025-12-11T14:30:53.914Z
8698866 8698866 20251206180916_863Ne AU001E 2025-12-08T14:19:23.168Z 2025-12-11T14:30:52.782Z
8698856 8698856 20251206180440_3ZMno AU001E 2025-12-08T14:19:20.671Z 2025-12-11T14:30:51.854Z
8698840 8698840 20251206175452_WxL3m AU001E 2025-12-08T14:19:18.007Z 2025-12-11T14:30:50.760Z
8698830 8698830 20251206174940_4GxgH AU001E 2025-12-08T14:19:14.457Z 2025-12-11T14:30:49.578Z
8698809 8698809 20251206171522_3hsMp AU001E 2025-12-08T14:19:01.794Z 2025-12-11T14:30:46.597Z
8698801 8698801 20251206170829_wZXQS AU001E 2025-12-08T14:19:00.495Z 2025-12-11T14:30:45.568Z
8698790 8698790 20251206170649_3JOQS AU001E 2025-12-08T14:18:58.241Z 2025-12-11T14:30:45.001Z
8698775 8698775 20251206164644_3YsQm AU001E 2025-12-08T14:18:55.153Z 2025-12-11T14:30:43.760Z
8693989 8693989 20251205153236_N4fQi AU001E 2025-12-07T14:12:05.266Z 2025-12-11T14:34:39.919Z
8693988 8693988 20251205153236_Y0f0S AU001E 2025-12-07T14:12:04.852Z 2025-12-11T14:34:39.812Z
8689557 8689557 20251205182154_tGuk7 AU001E 2025-12-06T14:08:55.551Z 2025-12-11T14:34:50.012Z
8689466 8689466 20251205163122_c74CD AU001E 2025-12-06T14:08:34.377Z 2025-12-11T14:34:44.820Z
8689460 8689460 20251205162410_ZeRCq AU001E 2025-12-06T14:08:32.970Z 2025-12-11T14:34:44.192Z
8689445 8689445 20251205161306_fRkB3 AU001E 2025-12-06T14:08:25.930Z 2025-12-11T14:34:43.357Z
8689424 8689424 20251205160028_IjXJR AU001E 2025-12-06T14:08:18.837Z 2025-12-11T14:34:41.956Z
8689374 8689374 20251205153447_rvLgd AU001E 2025-12-06T14:08:09.528Z 2025-12-11T14:34:39.998Z
8673493 8673493 20251201193909_RW3Tp AU001E 2025-12-03T14:19:00.405Z 2025-12-10T14:38:23.911Z
8673489 8673489 20251201193520_u4Had AU001E 2025-12-03T14:18:59.731Z 2025-12-10T14:38:23.743Z
8673430 8673430 20251201190351_J1428 AU001E 2025-12-03T14:18:50.085Z 2025-12-10T14:38:22.276Z
8673418 8673418 20251201185956_awyiw AU001E 2025-12-03T14:18:48.122Z 2025-12-10T14:38:20.896Z
8673365 8673365 20251201184640_vTFrP AU001E 2025-12-03T14:18:28.563Z 2025-12-10T14:38:19.343Z
8673330 8673330 20251201182928_aXypI AU001E 2025-12-03T14:18:18.476Z 2025-12-10T14:38:18.471Z
8673217 8673217 20251201173156_BwdIl AU001E 2025-12-03T14:18:00.399Z 2025-12-10T14:38:15.420Z
8673165 8673165 20251201171939_TBsGj AU001E 2025-12-03T14:17:43.277Z 2025-12-10T14:38:13.935Z
8672549 8672549 20251201144514_1odoE AU001E 2025-12-03T14:15:53.162Z 2025-12-10T14:37:56.753Z
8672504 8672504 20251201143906_Acipg AU001E 2025-12-03T14:15:41.989Z 2025-12-10T14:37:55.939Z
8672192 8672192 20251201140133_USCvd AU001E 2025-12-03T14:14:55.579Z 2025-12-10T14:37:45.119Z
8662810 8662810 20251130193426_KHSES AU001E 2025-12-02T14:16:46.684Z 2025-12-09T14:57:18.829Z
8662795 8662795 20251130193232_RaNwR AU001E 2025-12-02T14:16:44.285Z 2025-12-09T14:57:18.323Z
8662738 8662738 20251130192536_cDUic AU001E 2025-12-02T14:16:26.539Z 2025-12-09T14:57:15.792Z
8662563 8662563 20251130191107_Bzc5a AU001E 2025-12-02T14:15:54.269Z 2025-12-09T14:56:58.247Z
8662542 8662542 20251130190728_92n2Z AU001E 2025-12-02T14:15:51.731Z 2025-12-09T14:56:52.910Z
8662524 8662524 20251130190556_ppRr9 AU001E 2025-12-02T14:15:49.478Z 2025-12-09T14:56:50.262Z
8662507 8662507 20251130190231_IxNHe AU001E 2025-12-02T14:15:46.178Z 2025-12-09T14:56:47.116Z
8662335 8662335 20251130183422_llitL AU001E 2025-12-02T14:15:10.230Z 2025-12-09T14:56:37.575Z
8662096 8662096 20251130175654_bfbDV AU001E 2025-12-02T14:14:18.032Z 2025-12-09T14:56:28.902Z
8662094 8662094 20251130175647_bvxKB AU001E 2025-12-02T14:14:17.662Z 2025-12-09T14:56:28.852Z
8662019 8662019 20251130174406_TDrOU AU001E 2025-12-02T14:13:59.773Z 2025-12-09T14:56:26.853Z
8661958 8661958 20251130173556_ozW5T AU001E 2025-12-02T14:13:42.291Z 2025-12-09T14:56:25.026Z
8661583 8661583 20251130160621_1cR6X AU001E 2025-12-02T14:12:06.016Z 2025-12-09T14:56:04.051Z
8661249 8661249 20251130150255_EKpqL AU001E 2025-12-02T14:10:56.751Z 2025-12-09T14:55:24.413Z
8660810 8660810 20251130135345_qftJn AU001E 2025-12-02T14:09:14.407Z 2025-12-09T14:55:13.980Z
8660807 8660807 20251130135344_uH6Nx AU001E 2025-12-02T14:09:13.981Z 2025-12-09T14:55:13.927Z
8650309 8650309 20251129195157_jcrso AU001E 2025-12-01T14:15:46.479Z 2025-12-08T14:52:57.412Z
8650290 8650290 20251129194903_nwKrC AU001E 2025-12-01T14:15:43.738Z 2025-12-08T14:52:56.945Z
8650267 8650267 20251129194831_9EDed AU001E 2025-12-01T14:15:41.520Z 2025-12-08T14:52:56.675Z
8650240 8650240 20251129194600_DxmQ4 AU001E 2025-12-01T14:15:32.909Z 2025-12-08T14:52:56.221Z
8650181 8650181 20251129193517_bfBFY AU001E 2025-12-01T14:15:20.079Z 2025-12-08T14:52:54.604Z
8649385 8649385 20251129171829_vsLAu AU001E 2025-12-01T14:12:21.914Z 2025-12-08T14:51:56.793Z
8649328 8649328 20251129170739_jdCZC AU001E 2025-12-01T14:12:01.929Z 2025-12-08T14:51:51.291Z
8649321 8649321 20251129170547_jS5qP AU001E 2025-12-01T14:12:01.065Z 2025-12-08T14:51:50.178Z
8649222 8649222 20251129164302_jmxn7 AU001E 2025-12-01T14:11:29.975Z 2025-12-08T14:51:37.246Z
8649192 8649192 20251129163506_ezY31 AU001E 2025-12-01T14:11:23.892Z 2025-12-08T14:51:35.056Z
8649185 8649185 20251129163321_dytbt AU001E 2025-12-01T14:11:22.263Z 2025-12-08T14:51:34.142Z
8649157 8649157 20251129162740_FBpLz AU001E 2025-12-01T14:11:14.582Z 2025-12-08T14:51:32.899Z
8649135 8649135 20251129162059_ZDlcM AU001E 2025-12-01T14:11:04.743Z 2025-12-08T14:51:32.347Z
8649116 8649116 20251129161607_hXlBu AU001E 2025-12-01T14:10:59.598Z 2025-12-08T14:51:31.900Z
8649090 8649090 20251129160734_tF3Gq AU001E 2025-12-01T14:10:52.676Z 2025-12-08T14:51:31.259Z
8648988 8648988 20251129154035_y28sr AU001E 2025-12-01T14:10:21.394Z 2025-12-08T14:51:28.784Z
8648986 8648986 20251129154001_xtB69 AU001E 2025-12-01T14:10:18.484Z 2025-12-08T14:51:28.740Z
8648918 8648918 20251129150744_VuPJY AU001E 2025-12-01T14:09:34.326Z 2025-12-08T14:51:25.080Z
8648879 8648879 20251129142542_MgcDD AU001E 2025-12-01T14:08:52.019Z 2025-12-08T14:51:21.509Z
8648855 8648855 20251129141114_lelBA AU001E 2025-12-01T14:08:30.111Z 2025-12-08T14:51:19.714Z
8644508 8644508 20251128192909_ZdPXw AU001E 2025-11-30T14:22:03.299Z 2025-12-07T14:56:22.203Z
8644420 8644420 20251128192601_Ce83M AU001E 2025-11-30T14:21:59.002Z 2025-12-07T14:56:21.168Z
8644346 8644346 20251128192234_nuBNq AU001E 2025-11-30T14:21:40.568Z 2025-12-07T14:56:19.714Z
8644294 8644294 20251128191835_RHgZJ AU001E 2025-11-30T14:21:36.246Z 2025-12-07T14:56:18.980Z
8644270 8644270 20251128191342_WppGl AU001E 2025-11-30T14:21:32.934Z 2025-12-07T14:56:18.537Z
8644174 8644174 20251128190527_AQYUh AU001E 2025-11-30T14:21:26.152Z 2025-12-07T14:56:15.511Z
8644142 8644142 20251128190223_ppEqP AU001E 2025-11-30T14:21:24.084Z 2025-12-07T14:56:14.866Z
8644079 8644079 20251128185554_sO3L1 AU001E 2025-11-30T14:21:18.915Z 2025-12-07T14:56:13.502Z
8643896 8643896 20251128183657_Cf0qM AU001E 2025-11-30T14:20:47.657Z 2025-12-07T14:56:10.077Z
8643373 8643373 20251128174656_5ePtJ AU001E 2025-11-30T14:19:57.158Z 2025-12-07T14:56:00.654Z
8638170 8638170 20251126190249_P2RyB AU001E 2025-11-29T14:33:30.805Z 2025-12-05T15:02:56.277Z
8631062 8631062 20251127180949_WlMwL AU001E 2025-11-29T14:14:29.848Z 2025-12-06T14:59:52.397Z
8622247 8622247 20251126182357_CwonV AU001E 2025-11-28T14:18:13.769Z 2025-12-05T15:02:54.325Z
8622241 8622241 20251126182243_6HZ3e AU001E 2025-11-28T14:18:12.819Z 2025-12-05T15:02:53.981Z
8622182 8622182 20251126180832_C7aZM AU001E 2025-11-28T14:18:04.695Z 2025-12-05T15:02:53.268Z
8622046 8622046 20251126173921_TbiIK AU001E 2025-11-28T14:17:33.151Z 2025-12-05T15:02:51.014Z
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

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