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 = "USL00L" 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
8501920 8501920 20251117120221_NVw1l USL00L 2025-11-19T14:00:57.365Z 2025-11-26T15:06:01.524Z
8499607 8499607 20251117094417_7etO2 USL00L 2025-11-18T14:36:21.585Z 2025-11-25T15:11:24.439Z
8499398 8499398 20251117083343_W3Gdf USL00L 2025-11-18T14:35:15.397Z 2025-11-25T15:11:15.892Z
8499390 8499390 20251117082747_97PRo USL00L 2025-11-18T14:35:10.605Z 2025-11-25T15:11:15.759Z
8499346 8499346 20251117080255_jsp3h USL00L 2025-11-18T14:34:55.438Z 2025-11-25T15:11:13.845Z
8499318 8499318 20251117074529_hLzAH USL00L 2025-11-18T14:34:50.696Z 2025-11-25T15:11:13.184Z
8499280 8499280 20251117072127_8G3Be USL00L 2025-11-18T14:34:34.867Z 2025-11-25T15:11:11.560Z
8499195 8499195 20251117063955_NFV7u USL00L 2025-11-18T14:34:12.451Z 2025-11-25T15:11:07.596Z
8499173 8499173 20251117063140_Lwg4S USL00L 2025-11-18T14:34:04.836Z 2025-11-25T15:11:03.819Z
8499151 8499151 20251117062147_PjTMJ USL00L 2025-11-18T14:33:54.177Z 2025-11-25T15:11:01.229Z
8499138 8499138 20251117061859_kOosb USL00L 2025-11-18T14:33:52.248Z 2025-11-25T15:11:00.925Z
8499109 8499109 20251117061414_hhAuB USL00L 2025-11-18T14:33:39.904Z 2025-11-25T15:10:58.783Z
8499107 8499107 20251117061414_7d38k USL00L 2025-11-18T14:33:39.620Z 2025-11-25T15:10:58.774Z
8499014 8499014 20251117050341_7JsfB USL00L 2025-11-18T14:32:37.712Z 2025-11-25T15:10:29.495Z
8486446 8486446 20251115113307_JdnN1 USL00L 2025-11-17T14:34:25.519Z 2025-11-23T15:20:35.039Z
8486396 8486396 20251115113058_L3MJN USL00L 2025-11-17T14:34:20.271Z 2025-11-23T15:20:31.852Z
8486311 8486311 20251115112557_lF2ng USL00L 2025-11-17T14:34:16.367Z 2025-11-23T15:20:28.992Z
8486227 8486227 20251115112230_ZyPHk USL00L 2025-11-17T14:34:14.530Z 2025-11-23T15:20:27.280Z
8486066 8486066 20251115111625_uH2fd USL00L 2025-11-17T14:34:10.055Z 2025-11-23T15:20:19.364Z
8485903 8485903 20251115110932_7QWvI USL00L 2025-11-17T14:34:06.823Z 2025-11-23T15:20:14.235Z
8485880 8485880 20251115110852_wIbyB USL00L 2025-11-17T14:34:05.871Z 2025-11-23T15:20:12.797Z
8485874 8485874 20251115110842_MweMk USL00L 2025-11-17T14:34:05.738Z 2025-11-23T15:20:12.669Z
8485501 8485501 20251115104838_5JZG3 USL00L 2025-11-17T14:33:55.436Z 2025-11-23T15:20:04.947Z
8485234 8485234 20251115103320_KeUlC USL00L 2025-11-17T14:33:47.688Z 2025-11-23T15:19:57.691Z
8485116 8485116 20251115102714_uoydD USL00L 2025-11-17T14:33:23.681Z 2025-11-23T15:19:55.767Z
8485051 8485051 20251115102252_iZQ7j USL00L 2025-11-17T14:33:12.491Z 2025-11-23T15:19:54.177Z
8485044 8485044 20251115102201_ZhSzR USL00L 2025-11-17T14:33:07.443Z 2025-11-23T15:19:54.026Z
8484899 8484899 20251115101342_QReR3 USL00L 2025-11-17T14:33:02.171Z 2025-11-23T15:19:50.435Z
8484792 8484792 20251115100519_EKN0b USL00L 2025-11-17T14:32:58.204Z 2025-11-23T15:19:48.405Z
8484757 8484757 20251115100337_EqtDH USL00L 2025-11-17T14:32:56.852Z 2025-11-23T15:19:47.324Z
8484688 8484688 20251115095759_rb8dW USL00L 2025-11-17T14:32:54.869Z 2025-11-23T15:19:46.243Z
8484438 8484438 20251115094334_c7Yzr USL00L 2025-11-17T14:32:47.198Z 2025-11-23T15:19:36.835Z
8484336 8484336 20251115093627_nbCH5 USL00L 2025-11-17T14:32:44.680Z 2025-11-23T15:19:34.451Z
8484231 8484231 20251115092938_CcsV4 USL00L 2025-11-17T14:32:41.089Z 2025-11-23T15:19:31.540Z
8484121 8484121 20251115092227_nKgTb USL00L 2025-11-17T14:32:16.722Z 2025-11-23T15:19:27.952Z
8484083 8484083 20251115092122_pprk8 USL00L 2025-11-17T14:32:11.642Z 2025-11-23T15:19:26.230Z
8483988 8483988 20251115091430_uVlnk USL00L 2025-11-17T14:32:07.901Z 2025-11-23T15:19:21.919Z
8483969 8483969 20251115091250_XlWqH USL00L 2025-11-17T14:32:07.144Z 2025-11-23T15:19:21.470Z
8483930 8483930 20251115091039_uBpe6 USL00L 2025-11-17T14:32:05.467Z 2025-11-23T15:19:20.595Z
8483856 8483856 20251115090335_emIg0 USL00L 2025-11-17T14:32:02.133Z 2025-11-23T15:19:15.657Z
8483823 8483823 20251115090024_ryRI5 USL00L 2025-11-17T14:32:01.395Z 2025-11-23T15:19:15.481Z
8483694 8483694 20251115085244_v0Hte USL00L 2025-11-17T14:31:57.110Z 2025-11-23T15:19:07.510Z
8483638 8483638 20251115084858_uoLXf USL00L 2025-11-17T14:31:54.851Z 2025-11-23T15:19:04.667Z
8483611 8483611 20251115084717_m2RV8 USL00L 2025-11-17T14:31:53.325Z 2025-11-23T15:19:04.013Z
8483547 8483547 20251115084124_yETHD USL00L 2025-11-17T14:31:50.461Z 2025-11-23T15:19:03.052Z
8483444 8483444 20251115082936_T80qS USL00L 2025-11-17T14:31:43.677Z 2025-11-23T15:18:54.910Z
8483434 8483434 20251115082859_qfvNb USL00L 2025-11-17T14:31:40.922Z 2025-11-23T15:18:54.714Z
8483337 8483337 20251115082222_cmzYb USL00L 2025-11-17T14:31:19.083Z 2025-11-23T15:18:51.196Z
8483163 8483163 20251115080534_5yjQV USL00L 2025-11-17T14:31:02.258Z 2025-11-23T15:18:44.554Z
8483075 8483075 20251115075245_b2EhL USL00L 2025-11-17T14:30:59.432Z 2025-11-23T15:18:41.565Z
8482875 8482875 20251115071400_PzuDQ USL00L 2025-11-17T14:30:49.404Z 2025-11-23T15:18:30.474Z
8482849 8482849 20251115070955_pSBIK USL00L 2025-11-17T14:30:47.525Z 2025-11-23T15:18:29.916Z
8482776 8482776 20251115070107_mhIia USL00L 2025-11-17T14:30:44.181Z 2025-11-23T15:18:28.283Z
8482733 8482733 20251115065200_dKSVv USL00L 2025-11-17T14:30:33.730Z 2025-11-23T15:18:27.615Z
8474348 8474348 20251115125930_cAtYf USL00L 2025-11-17T14:04:20.807Z 2025-11-24T15:02:55.665Z
8473815 8473815 20251115123109_9Lk1y USL00L 2025-11-17T14:02:59.576Z 2025-11-24T15:02:51.774Z
8473767 8473767 20251115122820_asqcQ USL00L 2025-11-17T14:02:53.591Z 2025-11-24T15:02:48.185Z
8473658 8473658 20251115122339_Ogiwk USL00L 2025-11-17T14:02:43.623Z 2025-11-24T15:02:44.596Z
8473344 8473344 20251115120912_NCJeT USL00L 2025-11-17T14:01:47.836Z 2025-11-24T15:02:35.430Z
8473325 8473325 20251115120838_YNf8E USL00L 2025-11-17T14:01:45.461Z 2025-11-24T15:02:35.291Z
8473276 8473276 20251115120628_gjrGc USL00L 2025-11-17T14:01:41.154Z 2025-11-24T15:02:33.778Z
8473260 8473260 20251115120603_VF2IV USL00L 2025-11-17T14:01:39.974Z 2025-11-24T15:02:33.688Z
8473080 8473080 20251115115606_P3iS2 USL00L 2025-11-17T14:01:09.347Z 2025-11-24T15:02:29.385Z
8472926 8472926 20251115114959_7BMd8 USL00L 2025-11-17T14:00:39.302Z 2025-11-24T15:02:25.326Z
8472817 8472817 20251115114244_bTIZr USL00L 2025-11-17T14:00:27.705Z 2025-11-24T15:02:16.840Z
8472749 8472749 20251115114023_2U2eE USL00L 2025-11-17T14:00:20.680Z 2025-11-24T15:02:15.329Z
8472716 8472716 20251115113825_rW4iL USL00L 2025-11-17T14:00:15.568Z 2025-11-24T15:02:14.033Z
8470829 8470829 20251115055329_S11bO USL00L 2025-11-16T14:23:41.121Z 2025-11-16T14:34:04.624Z
8470796 8470796 20251115054526_fFa8h USL00L 2025-11-16T14:23:38.607Z 2025-11-23T15:18:19.448Z
8470749 8470749 20251115053837_E33Kc USL00L 2025-11-16T14:23:35.179Z 2025-11-23T15:18:18.752Z
8470621 8470621 20251115051814_XiIRw USL00L 2025-11-16T14:23:06.601Z 2025-11-23T15:18:15.705Z
8470549 8470549 20251115051153_VYB6H USL00L 2025-11-16T14:23:01.139Z 2025-11-16T14:34:04.458Z
8470454 8470454 20251115050227_vEnag USL00L 2025-11-16T14:22:52.858Z 2025-11-23T15:18:10.040Z
8470394 8470394 20251115045704_YpucP USL00L 2025-11-16T14:22:47.363Z 2025-11-23T15:18:08.453Z
8470390 8470390 20251115045658_wEjT2 USL00L 2025-11-16T14:22:47.066Z 2025-11-23T15:18:08.428Z
8470380 8470380 20251115045605_sZ9ZP USL00L 2025-11-16T14:22:44.543Z 2025-11-23T15:18:05.998Z
8470358 8470358 20251115045529_tlKWG USL00L 2025-11-16T14:22:28.766Z 2025-11-23T15:18:05.775Z
8470325 8470325 20251115045242_DiaUI USL00L 2025-11-16T14:22:25.307Z 2025-11-23T15:18:05.063Z
8470287 8470287 20251115044521_V3y5k USL00L 2025-11-16T14:22:18.286Z 2025-11-23T15:18:02.717Z
8470178 8470178 20251115043053_Xc304 USL00L 2025-11-16T14:22:08.348Z 2025-11-23T15:18:00.949Z
8470166 8470166 20251115043013_cDgsF USL00L 2025-11-16T14:22:07.576Z 2025-11-23T15:18:00.831Z
8470080 8470080 20251115041421_WoG23 USL00L 2025-11-16T14:22:00.859Z 2025-11-23T15:18:00.137Z
8470057 8470057 20251115041041_90hAR USL00L 2025-11-16T14:21:46.905Z 2025-11-16T14:34:04.141Z
8469936 8469936 20251115035238_1ZdNs USL00L 2025-11-16T14:21:31.625Z 2025-11-23T15:17:58.907Z
8469923 8469923 20251115035040_w3gt3 USL00L 2025-11-16T14:21:30.546Z 2025-11-23T15:17:58.863Z
8469871 8469871 20251115034400_mpj6b USL00L 2025-11-16T14:21:25.130Z 2025-11-16T14:34:04.029Z
8469722 8469722 20251115032326_h3tEU USL00L 2025-11-16T14:20:52.606Z 2025-11-16T14:34:03.933Z
8469680 8469680 20251115031854_4PkRh USL00L 2025-11-16T14:20:49.682Z 2025-11-23T15:17:56.461Z
8469214 8469214 20251115021819_ZDjnK USL00L 2025-11-16T14:19:36.092Z 2025-11-23T15:17:37.552Z
8469135 8469135 20251115020515_myLRZ USL00L 2025-11-16T14:19:24.379Z 2025-11-16T14:34:03.586Z
8462455 8462455 20251112042859_fxwTi USL00L 2025-11-15T14:39:40.382Z 2025-11-20T15:25:31.381Z
8462397 8462397 20251114114450_dIBUz USL00L 2025-11-15T14:26:07.696Z 2025-11-22T15:24:23.157Z
8462301 8462301 20251114112651_Dgoyt USL00L 2025-11-15T14:26:00.453Z 2025-11-22T15:24:16.568Z
8462100 8462100 20251114104619_YT0ml USL00L 2025-11-15T14:25:33.333Z 2025-11-22T15:24:01.376Z
8461940 8461940 20251114102102_6S4Qz USL00L 2025-11-15T14:25:17.546Z 2025-11-15T14:26:16.143Z
8461861 8461861 20251114101122_02umS USL00L 2025-11-15T14:24:58.767Z 2025-11-15T14:26:16.119Z
8461773 8461773 20251114100252_YP9VT USL00L 2025-11-15T14:24:52.828Z 2025-11-22T15:23:41.184Z
8461654 8461654 20251114094806_VjmYK USL00L 2025-11-15T14:24:43.446Z 2025-11-22T15:23:35.983Z
8461617 8461617 20251114094128_bwSwx USL00L 2025-11-15T14:24:41.380Z 2025-11-22T15:23:33.580Z
8461373 8461373 20251114091221_dMRFu USL00L 2025-11-15T14:24:10.902Z 2025-11-22T15:23:20.987Z

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