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

5,590 rows where station_code = "US002L" 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
8690803 8690803 20251205015314_NAPh0 US002L 2025-12-06T14:15:35.183Z 2025-12-06T14:18:00.963Z
8687080 8687080 20251204031920_zfAwU US002L 2025-12-05T14:13:50.213Z 2025-12-06T14:22:29.157Z
8684071 8684071 20251204103318_uUkId US002L 2025-12-05T14:01:43.417Z 2025-12-06T14:18:00.408Z
8683860 8683860 20251204090344_kSl3y US002L 2025-12-05T14:00:54.483Z 2025-12-06T14:18:00.353Z
8683772 8683772 20251204080041_sUUAw US002L 2025-12-05T14:00:31.580Z 2025-12-06T14:18:00.325Z
8683768 8683768 20251204075508_rBxPE US002L 2025-12-05T14:00:30.989Z 2025-12-06T14:18:00.324Z
8683699 8683699 20251204070050_Q3TTZ US002L 2025-12-05T14:00:14.909Z 2025-12-06T14:18:00.305Z
8683696 8683696 20251204070013_LCxXL US002L 2025-12-05T14:00:14.168Z 2025-12-06T14:18:00.305Z
8080192 8080192 20251009093436_ALrED US002L 2025-10-11T12:20:20.218Z 2025-10-17T12:38:08.548Z
8080188 8080188 20251009092302_mFMJn US002L 2025-10-11T12:20:17.751Z 2025-10-17T12:38:07.950Z
8080180 8080180 20251009075123_bIdoI US002L 2025-10-11T12:20:01.562Z 2025-10-17T12:38:04.906Z
8080176 8080176 20251009060114_QIHwa US002L 2025-10-11T12:19:48.436Z 2025-10-17T12:38:02.444Z
8080174 8080174 20251009043924_gD3vK US002L 2025-10-11T12:19:34.019Z 2025-10-17T12:37:59.417Z
8080172 8080172 20251009032525_5WAJT US002L 2025-10-11T12:19:13.275Z 2025-10-17T12:37:52.729Z
8080170 8080170 20251009031438_g3n9C US002L 2025-10-11T12:19:09.914Z 2025-10-17T12:37:51.643Z
8080168 8080168 20251009025548_VX2Ke US002L 2025-10-11T12:19:03.181Z 2025-10-17T12:37:48.756Z
8080108 8080108 20251010094428_AVxYX US002L 2025-10-11T12:14:24.155Z 2025-10-18T13:00:28.734Z
8080105 8080105 20251010094403_2PZnv US002L 2025-10-11T12:14:23.881Z 2025-10-18T13:00:28.678Z
8079987 8079987 20251010092255_b3oRC US002L 2025-10-11T12:13:55.431Z 2025-10-18T13:00:26.808Z
8079908 8079908 20251010085936_ihnyM US002L 2025-10-11T12:13:46.144Z 2025-10-18T13:00:26.063Z
8079873 8079873 20251010085000_PN9T4 US002L 2025-10-11T12:13:42.751Z 2025-10-18T13:00:25.736Z
8079784 8079784 20251010082428_2a3FU US002L 2025-10-11T12:13:18.442Z 2025-10-18T13:00:24.709Z
8079752 8079752 20251010081318_VpNsU US002L 2025-10-11T12:13:14.722Z 2025-10-18T13:00:24.673Z
8079675 8079675 20251010074120_Hzuum US002L 2025-10-11T12:13:03.813Z 2025-10-18T13:00:23.250Z
8079654 8079654 20251010073123_bESK8 US002L 2025-10-11T12:13:01.222Z 2025-10-18T13:00:23.119Z
8079511 8079511 20251010061510_E22gN US002L 2025-10-11T12:12:22.553Z 2025-10-18T13:00:21.851Z
8079364 8079364 20251010045859_YX2gf US002L 2025-10-11T12:11:54.168Z 2025-10-18T13:00:20.523Z
8079226 8079226 20251010042520_FBFah US002L 2025-10-11T12:11:27.767Z 2025-10-18T13:00:18.373Z
8078745 8078745 20251010024011_Kt9sG US002L 2025-10-11T12:09:51.344Z 2025-10-18T13:00:07.543Z
8078727 8078727 20251010023755_pTDwC US002L 2025-10-11T12:09:49.040Z 2025-10-18T13:00:07.164Z
8078267 8078267 20251010002259_32adG US002L 2025-10-11T12:07:57.999Z 2025-10-18T12:59:58.001Z
8078258 8078258 20251010001717_Sg3ZR US002L 2025-10-11T12:07:57.199Z 2025-10-18T12:59:57.994Z
8077700 8077700 20251009100252_LTyqw US002L 2025-10-11T12:04:34.895Z 2025-10-18T12:59:22.972Z
8076418 8076418 20251010100945_5rKFw US002L 2025-10-11T12:00:22.150Z 2025-10-19T12:49:10.333Z
8076316 8076316 20251009092149_pecbW US002L 2025-10-10T12:12:04.494Z 2025-10-17T12:38:07.893Z
8076203 8076203 20251009081457_RBgES US002L 2025-10-10T12:11:49.342Z 2025-10-17T12:38:05.529Z
8076134 8076134 20251009073556_1OX2q US002L 2025-10-10T12:11:27.114Z 2025-10-17T12:38:04.829Z
8076118 8076118 20251009072513_epkEq US002L 2025-10-10T12:11:25.124Z 2025-10-17T12:38:04.710Z
8075988 8075988 20251009060821_0S7M2 US002L 2025-10-10T12:11:05.773Z 2025-10-17T12:38:02.835Z
8074711 8074711 20251009003431_x7uw3 US002L 2025-10-10T12:07:06.806Z 2025-10-17T12:37:37.441Z
8074556 8074556 20251009000604_df8EU US002L 2025-10-10T12:06:39.467Z 2025-10-17T12:37:32.820Z
8072919 8072919 20251009094209_B6O7s US002L 2025-10-10T12:00:11.895Z 2025-10-18T12:59:21.389Z
8070971 8070971 20251007062930_GsBAI US002L 2025-10-08T12:10:05.188Z 2025-10-15T12:44:38.255Z
8070938 8070938 20251007054915_qoK3Z US002L 2025-10-08T12:10:00.432Z 2025-10-15T12:44:35.141Z
8070588 8070588 20251007012159_Ymln8 US002L 2025-10-08T12:08:47.757Z 2025-10-15T12:44:22.092Z
8069238 8069238 20251006100037_sEpCP US002L 2025-10-08T12:04:13.831Z 2025-10-15T12:43:20.012Z
8069229 8069229 20251006095732_HjjWT US002L 2025-10-08T12:04:12.590Z 2025-10-15T12:43:19.872Z
8069149 8069149 20251006092355_Vbr44 US002L 2025-10-08T12:03:57.703Z 2025-10-15T12:43:14.041Z
8068107 8068107 20251004074825_LPRaX US002L 2025-10-07T12:39:46.718Z 2025-10-12T12:33:40.220Z
8068097 8068097 20251004073530_K9jva US002L 2025-10-07T12:39:44.403Z 2025-10-12T12:33:36.344Z
8068032 8068032 20251005080753_Na4a9 US002L 2025-10-07T12:35:27.740Z 2025-10-13T12:34:25.770Z
8067974 8067974 20251005075627_wD4SA US002L 2025-10-07T12:35:24.509Z 2025-10-13T12:34:24.892Z
8067765 8067765 20251005065807_wqnLe US002L 2025-10-07T12:34:46.189Z 2025-10-13T12:34:16.533Z
8067654 8067654 20251005062326_Iy2mX US002L 2025-10-07T12:34:26.359Z 2025-10-13T12:34:14.486Z
8067616 8067616 20251005060431_wMvHZ US002L 2025-10-07T12:34:23.705Z 2025-10-13T12:34:13.994Z
8067488 8067488 20251005050904_S3vvq US002L 2025-10-07T12:34:13.859Z 2025-10-13T12:34:12.436Z
8066661 8066661 20251005035634_Mqdma US002L 2025-10-07T12:33:07.233Z 2025-10-13T12:33:59.685Z
8065868 8065868 20251005024204_ZTf93 US002L 2025-10-07T12:32:03.163Z 2025-10-13T12:33:53.433Z
8063429 8063429 20251004100526_DujQD US002L 2025-10-07T12:26:02.798Z 2025-10-13T12:32:28.764Z
8063408 8063408 20251004100325_TtAPR US002L 2025-10-07T12:25:58.400Z 2025-10-13T12:32:28.266Z
8062996 8062996 20251004085426_S0q2z US002L 2025-10-07T12:24:33.550Z 2025-10-13T12:32:08.306Z
8062818 8062818 20251004082621_ZQqq2 US002L 2025-10-07T12:23:53.235Z 2025-10-13T12:32:01.880Z
8062615 8062615 20251006075533_b4WrB US002L 2025-10-07T12:23:04.989Z 2025-10-14T12:35:18.637Z
8062408 8062408 20251006061244_d2UxM US002L 2025-10-07T12:22:34.805Z 2025-10-14T12:35:11.170Z
8062266 8062266 20251006060228_ikUKy US002L 2025-10-07T12:16:48.590Z 2025-10-14T12:35:10.701Z
8062257 8062257 20251006060035_BAwMt US002L 2025-10-07T12:16:38.851Z 2025-10-14T12:35:10.436Z
8062148 8062148 20251006051652_cBLqQ US002L 2025-10-07T12:16:12.747Z 2025-10-14T12:35:07.148Z
8061540 8061540 20251006025803_iCDvZ US002L 2025-10-07T12:13:51.592Z 2025-10-14T12:34:39.819Z
8061451 8061451 20251006023536_iplqf US002L 2025-10-07T12:13:29.773Z 2025-10-14T12:34:37.966Z
8061197 8061197 20251006011052_ExG12 US002L 2025-10-07T12:12:19.456Z 2025-10-14T12:34:32.409Z
8061190 8061190 20251006011020_KF8vG US002L 2025-10-07T12:12:18.632Z 2025-10-14T12:34:32.232Z
8058766 8058766 20251005094550_TbY5r US002L 2025-10-07T12:03:00.464Z 2025-10-14T12:33:03.982Z
8058728 8058728 20251005093819_Yv4H3 US002L 2025-10-07T12:02:43.856Z 2025-10-14T12:33:02.654Z
8058551 8058551 20251005090452_OOTRq US002L 2025-10-07T12:01:52.325Z 2025-10-14T12:32:54.153Z
8058495 8058495 20251005085646_95DTL US002L 2025-10-07T12:01:35.995Z 2025-10-14T12:32:50.409Z
8058460 8058460 20251005085253_0e2qU US002L 2025-10-07T12:01:21.596Z 2025-10-14T12:32:47.277Z
8058444 8058444 20251005085116_HlNyp US002L 2025-10-07T12:01:17.542Z 2025-10-14T12:32:46.397Z
8058362 8058362 20251005083457_W9gkz US002L 2025-10-07T12:00:51.497Z 2025-10-14T12:32:41.941Z
8058351 8058351 20251005083305_fRX26 US002L 2025-10-07T12:00:48.746Z 2025-10-14T12:32:41.461Z
8057657 8057657 20251004054433_A5GUW US002L 2025-10-05T12:31:38.608Z 2025-10-12T12:33:13.429Z
8057581 8057581 20251004050402_osglD US002L 2025-10-05T12:31:03.754Z 2025-10-12T12:33:08.130Z
8057529 8057529 20251004044058_TsOXy US002L 2025-10-05T12:30:48.516Z 2025-10-12T12:33:02.863Z
8053233 8053233 20251003100144_828Au US002L 2025-10-05T12:04:40.507Z 2025-10-12T12:30:20.211Z
8052844 8052844 20251003091404_aIiKb US002L 2025-10-05T12:02:53.331Z 2025-10-12T12:29:49.846Z
8052532 8052532 20251003082522_JtjFT US002L 2025-10-05T12:01:25.313Z 2025-10-12T12:29:45.637Z
8052047 8052047 20251003071049_rk3JP US002L 2025-10-04T12:45:35.025Z 2025-10-11T12:42:51.110Z
8051348 8051348 20251003035605_0fUwI US002L 2025-10-04T12:43:52.705Z 2025-10-11T12:42:19.399Z
8051345 8051345 20251003035604_u2wVZ US002L 2025-10-04T12:43:52.332Z 2025-10-11T12:42:19.340Z
8050436 8050436 20251003002612_3nLYi US002L 2025-10-04T12:41:23.370Z 2025-10-11T12:40:21.335Z
8049803 8049803 20251002064221_yIabI US002L 2025-10-04T12:38:47.470Z 2025-10-10T12:42:38.272Z
8049797 8049797 20251002052655_cPOCa US002L 2025-10-04T12:37:47.184Z 2025-10-10T12:42:24.630Z
8049795 8049795 20251002045345_nC32q US002L 2025-10-04T12:37:33.340Z 2025-10-10T12:42:17.360Z
8045836 8045836 20251002095838_FWIol US002L 2025-10-04T12:06:39.591Z 2025-10-11T12:37:56.605Z
8045740 8045740 20251002094753_WjcfQ US002L 2025-10-04T12:06:17.699Z 2025-10-11T12:37:54.774Z
8045701 8045701 20251002094227_1jBXg US002L 2025-10-04T12:06:05.851Z 2025-10-11T12:37:54.137Z
8045552 8045552 20251002092755_gldoS US002L 2025-10-04T12:05:23.342Z 2025-10-11T12:37:52.072Z
8045409 8045409 20251002091250_TEudE US002L 2025-10-04T12:04:40.677Z 2025-10-11T12:37:48.675Z
8045116 8045116 20251002083730_3a0nF US002L 2025-10-04T12:03:22.899Z 2025-10-11T12:37:31.545Z
8044962 8044962 20251002082256_ozcHp US002L 2025-10-04T12:02:36.098Z 2025-10-11T12:37:08.921Z
8044518 8044518 20251002072601_ybwKG US002L 2025-10-04T12:00:31.479Z 2025-10-11T12:36:53.386Z

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