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 = "USL00M" 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
8501970 8501970 20251117121538_0uA2N USL00M 2025-11-19T14:01:06.002Z 2025-11-26T15:06:02.160Z
8501965 8501965 20251117121349_nEPc4 USL00M 2025-11-19T14:01:05.005Z 2025-11-26T15:06:02.064Z
8499298 8499298 20251117072922_2fmlY USL00M 2025-11-18T14:34:40.228Z 2025-11-25T15:11:12.041Z
8499217 8499217 20251117064824_2Q31Y USL00M 2025-11-18T14:34:16.502Z 2025-11-25T15:11:08.293Z
8499174 8499174 20251117063140_Lwg4S USL00M 2025-11-18T14:34:04.836Z 2025-11-25T15:11:03.819Z
8499152 8499152 20251117062147_PjTMJ USL00M 2025-11-18T14:33:54.177Z 2025-11-25T15:11:01.229Z
8499131 8499131 20251117061825_2nG2h USL00M 2025-11-18T14:33:50.881Z 2025-11-25T15:11:00.858Z
8499127 8499127 20251117061717_MBBA7 USL00M 2025-11-18T14:33:47.717Z 2025-11-25T15:10:59.490Z
8486401 8486401 20251115113141_vKzVb USL00M 2025-11-17T14:34:20.561Z 2025-11-23T15:20:31.867Z
8486072 8486072 20251115111631_S3ORR USL00M 2025-11-17T14:34:10.135Z 2025-11-23T15:20:19.428Z
8485351 8485351 20251115104050_MFVAY USL00M 2025-11-17T14:33:51.824Z 2025-11-23T15:20:00.659Z
8485348 8485348 20251115104042_DjQ2E USL00M 2025-11-17T14:33:51.512Z 2025-11-23T15:20:00.382Z
8485165 8485165 20251115102828_VVU7X USL00M 2025-11-17T14:33:31.124Z 2025-11-23T15:19:56.709Z
8485096 8485096 20251115102607_mIYxe USL00M 2025-11-17T14:33:21.754Z 2025-11-23T15:19:55.143Z
8484900 8484900 20251115101342_QReR3 USL00M 2025-11-17T14:33:02.171Z 2025-11-23T15:19:50.435Z
8484864 8484864 20251115101111_VkzrT USL00M 2025-11-17T14:33:01.278Z 2025-11-23T15:19:49.944Z
8484819 8484819 20251115100610_R03d4 USL00M 2025-11-17T14:32:59.149Z 2025-11-23T15:19:48.812Z
8484793 8484793 20251115100519_EKN0b USL00M 2025-11-17T14:32:58.204Z 2025-11-23T15:19:48.405Z
8484539 8484539 20251115094954_IiTIT USL00M 2025-11-17T14:32:50.375Z 2025-11-23T15:19:39.550Z
8484424 8484424 20251115094235_fNqz9 USL00M 2025-11-17T14:32:46.869Z 2025-11-23T15:19:36.661Z
8484262 8484262 20251115093102_F0kPP USL00M 2025-11-17T14:32:41.778Z 2025-11-23T15:19:32.876Z
8484197 8484197 20251115092755_aSoyq USL00M 2025-11-17T14:32:37.515Z 2025-11-23T15:19:29.142Z
8484084 8484084 20251115092125_IF8uT USL00M 2025-11-17T14:32:12.040Z 2025-11-23T15:19:26.253Z
8483824 8483824 20251115090024_ryRI5 USL00M 2025-11-17T14:32:01.395Z 2025-11-23T15:19:15.481Z
8483634 8483634 20251115084850_mJHOz USL00M 2025-11-17T14:31:54.542Z 2025-11-23T15:19:04.335Z
8483560 8483560 20251115084151_Xf4bB USL00M 2025-11-17T14:31:50.742Z 2025-11-23T15:19:03.161Z
8483401 8483401 20251115082626_2d5cc USL00M 2025-11-17T14:31:22.779Z 2025-11-23T15:18:53.738Z
8483102 8483102 20251115075609_Yo9gh USL00M 2025-11-17T14:31:00.499Z 2025-11-23T15:18:42.345Z
8482922 8482922 20251115072253_1IGUc USL00M 2025-11-17T14:30:51.608Z 2025-11-23T15:18:33.942Z
8474564 8474564 20251115131143_yaaIp USL00M 2025-11-17T14:04:49.823Z 2025-11-24T15:02:56.953Z
8474353 8474353 20251115125959_5Am2R USL00M 2025-11-17T14:04:21.552Z 2025-11-24T15:02:55.722Z
8474159 8474159 20251115124839_Aoy4E USL00M 2025-11-17T14:03:56.550Z 2025-11-24T15:02:54.449Z
8473768 8473768 20251115122820_asqcQ USL00M 2025-11-17T14:02:53.591Z 2025-11-24T15:02:48.185Z
8473475 8473475 20251115121547_sa5Cl USL00M 2025-11-17T14:02:12.001Z 2025-11-24T15:02:39.016Z
8473075 8473075 20251115115550_mXjsr USL00M 2025-11-17T14:01:08.150Z 2025-11-24T15:02:29.143Z
8473052 8473052 20251115115425_APR9m USL00M 2025-11-17T14:01:02.388Z 2025-11-24T15:02:27.783Z
8472723 8472723 20251115113856_TIexE USL00M 2025-11-17T14:00:17.051Z 2025-11-24T15:02:14.541Z
8472704 8472704 20251115113736_2YHCv USL00M 2025-11-17T14:00:13.321Z 2025-11-24T15:02:13.382Z
8471002 8471002 20251115062501_TZMWn USL00M 2025-11-16T14:23:57.854Z 2025-11-23T15:18:21.264Z
8470947 8470947 20251115061822_nEueI USL00M 2025-11-16T14:23:50.392Z 2025-11-16T14:34:04.703Z
8470652 8470652 20251115052258_28Hab USL00M 2025-11-16T14:23:12.653Z 2025-11-23T15:18:16.473Z
8470455 8470455 20251115050227_vEnag USL00M 2025-11-16T14:22:52.858Z 2025-11-23T15:18:10.040Z
8470381 8470381 20251115045605_sZ9ZP USL00M 2025-11-16T14:22:44.543Z 2025-11-23T15:18:05.998Z
8470359 8470359 20251115045529_tlKWG USL00M 2025-11-16T14:22:28.766Z 2025-11-23T15:18:05.775Z
8470288 8470288 20251115044521_V3y5k USL00M 2025-11-16T14:22:18.286Z 2025-11-23T15:18:02.717Z
8470281 8470281 20251115044443_gPeVl USL00M 2025-11-16T14:22:17.790Z 2025-11-23T15:18:02.671Z
8470205 8470205 20251115043541_6577e USL00M 2025-11-16T14:22:10.914Z 2025-11-16T14:34:04.238Z
8470172 8470172 20251115043038_g6ZD6 USL00M 2025-11-16T14:22:07.774Z 2025-11-23T15:18:00.872Z
8470167 8470167 20251115043013_cDgsF USL00M 2025-11-16T14:22:07.576Z 2025-11-23T15:18:00.831Z
8470102 8470102 20251115041642_sMY2Q USL00M 2025-11-16T14:22:02.087Z 2025-11-23T15:18:00.315Z
8470058 8470058 20251115041041_90hAR USL00M 2025-11-16T14:21:46.905Z 2025-11-16T14:34:04.141Z
8469937 8469937 20251115035238_1ZdNs USL00M 2025-11-16T14:21:31.625Z 2025-11-23T15:17:58.907Z
8469924 8469924 20251115035040_w3gt3 USL00M 2025-11-16T14:21:30.546Z 2025-11-23T15:17:58.863Z
8469782 8469782 20251115033258_l40Xu USL00M 2025-11-16T14:21:12.158Z 2025-11-23T15:17:57.496Z
8469645 8469645 20251115031213_5wRWL USL00M 2025-11-16T14:20:46.259Z 2025-11-23T15:17:53.267Z
8469494 8469494 20251115025334_182MC USL00M 2025-11-16T14:20:15.531Z 2025-11-23T15:17:40.414Z
8469454 8469454 20251115025003_J6wZb USL00M 2025-11-16T14:20:12.498Z 2025-11-23T15:17:40.013Z
8469388 8469388 20251115023833_lZ232 USL00M 2025-11-16T14:20:04.508Z 2025-11-23T15:17:39.130Z
8462387 8462387 20251114114251_D53Qh USL00M 2025-11-15T14:26:06.896Z 2025-11-15T14:26:16.274Z
8462375 8462375 20251114114201_kbYUh USL00M 2025-11-15T14:26:06.226Z 2025-11-15T14:26:16.271Z
8462336 8462336 20251114112947_NAWeJ USL00M 2025-11-15T14:26:02.519Z 2025-11-22T15:24:18.539Z
8462309 8462309 20251114112736_oYw2D USL00M 2025-11-15T14:26:01.343Z 2025-11-22T15:24:17.146Z
8462208 8462208 20251114110933_gueHF USL00M 2025-11-15T14:25:41.528Z 2025-11-22T15:24:09.957Z
8462173 8462173 20251114110236_C5xo6 USL00M 2025-11-15T14:25:38.723Z 2025-11-22T15:24:06.828Z
8462019 8462019 20251114102953_JgpWx USL00M 2025-11-15T14:25:24.339Z 2025-11-22T15:23:53.568Z
8462007 8462007 20251114102833_F4nr8 USL00M 2025-11-15T14:25:23.255Z 2025-11-22T15:23:51.662Z
8461978 8461978 20251114102627_2gbed USL00M 2025-11-15T14:25:20.920Z 2025-11-22T15:23:50.960Z
8461888 8461888 20251114101346_n5O4O USL00M 2025-11-15T14:25:00.630Z 2025-11-22T15:23:44.480Z
8461750 8461750 20251114095901_326Kc USL00M 2025-11-15T14:24:50.396Z 2025-11-22T15:23:38.912Z
8461678 8461678 20251114095224_DiHC7 USL00M 2025-11-15T14:24:45.559Z 2025-11-22T15:23:36.729Z
8461471 8461471 20251114092417_VZR6G USL00M 2025-11-15T14:24:19.024Z 2025-11-22T15:23:26.847Z
8461457 8461457 20251114092139_toUe4 USL00M 2025-11-15T14:24:15.848Z 2025-11-22T15:23:25.875Z
8461361 8461361 20251114091144_vOaxM USL00M 2025-11-15T14:24:10.414Z 2025-11-22T15:23:20.712Z
8461321 8461321 20251114090511_72HhF USL00M 2025-11-15T14:24:08.277Z 2025-11-22T15:23:18.755Z
8461295 8461295 20251114090429_2IWxm USL00M 2025-11-15T14:24:07.070Z 2025-11-22T15:23:17.621Z
8461274 8461274 20251114090034_KAk2z USL00M 2025-11-15T14:24:04.913Z 2025-11-22T15:23:16.560Z
8461157 8461157 20251114084551_W7DQz USL00M 2025-11-15T14:23:43.267Z 2025-11-22T15:23:13.257Z
8461139 8461139 20251114084443_xZeNK USL00M 2025-11-15T14:23:41.344Z 2025-11-22T15:23:12.806Z
8460984 8460984 20251114082149_fCB3s USL00M 2025-11-15T14:23:23.553Z 2025-11-22T15:22:58.320Z
8460923 8460923 20251114081242_V8Shs USL00M 2025-11-15T14:23:16.375Z 2025-11-22T15:22:56.567Z
8460575 8460575 20251114072131_JIdOr USL00M 2025-11-15T14:22:17.723Z 2025-11-22T15:22:42.180Z
8460525 8460525 20251114071258_ZWh0r USL00M 2025-11-15T14:22:14.505Z 2025-11-22T15:22:40.879Z
8460516 8460516 20251114071150_TdkT6 USL00M 2025-11-15T14:22:12.226Z 2025-11-22T15:22:39.810Z
8459928 8459928 20251114051144_9BxR6 USL00M 2025-11-15T14:20:52.625Z 2025-11-22T15:22:18.609Z
8459814 8459814 20251114045149_sLAdY USL00M 2025-11-15T14:20:38.042Z 2025-11-22T15:22:13.144Z
8459715 8459715 20251114043157_A38WT USL00M 2025-11-15T14:20:29.697Z 2025-11-22T15:22:10.400Z
8459706 8459706 20251114043058_tLY55 USL00M 2025-11-15T14:20:23.645Z 2025-11-22T15:22:10.317Z
8459691 8459691 20251114042746_6dwUF USL00M 2025-11-15T14:20:17.963Z 2025-11-22T15:22:09.276Z
8459588 8459588 20251114040932_gMeZL USL00M 2025-11-15T14:20:04.317Z 2025-11-22T15:22:03.703Z
8459354 8459354 20251114033313_XMeKl USL00M 2025-11-15T14:19:29.884Z 2025-11-22T15:21:49.357Z
8459229 8459229 20251114031259_ULDqd USL00M 2025-11-15T14:19:16.049Z 2025-11-22T15:21:44.021Z
8459222 8459222 20251114031234_zVb3S USL00M 2025-11-15T14:19:14.668Z 2025-11-22T15:21:43.922Z
8459101 8459101 20251114024752_9Y9a0 USL00M 2025-11-15T14:18:50.404Z 2025-11-22T15:21:38.095Z
8458779 8458779 20251114014407_wL3CC USL00M 2025-11-15T14:17:47.546Z 2025-11-22T15:21:21.811Z
8453038 8453038 20251114123531_fXAhc USL00M 2025-11-15T14:00:50.332Z 2025-11-23T15:15:45.195Z
8452894 8452894 20251114120201_oXIN8 USL00M 2025-11-15T14:00:23.001Z 2025-11-15T14:00:23.001Z
8452891 8452891 20251114120154_53Y2u USL00M 2025-11-15T14:00:22.309Z 2025-11-15T14:00:22.309Z
8452872 8452872 20251114115644_yyqBL USL00M 2025-11-15T14:00:17.381Z 2025-11-23T15:15:32.118Z
8452828 8452828 20251114114700_rxb7S USL00M 2025-11-15T14:00:09.714Z 2025-11-15T14:00:09.714Z
8452307 8452307 20251113114206_csvto USL00M 2025-11-14T14:28:09.011Z 2025-11-21T15:13:50.483Z

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