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

3,373 rows where station_code = "US0062" 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
8687217 8687217 20251204054902_KogJH US0062 2025-12-05T14:14:25.270Z 2025-12-05T14:14:35.653Z
8687212 8687212 20251204054820_Tx1Tv US0062 2025-12-05T14:14:24.723Z 2025-12-05T14:14:35.652Z
8687136 8687136 20251204051401_t1cmS US0062 2025-12-05T14:14:01.751Z 2025-12-05T14:14:35.631Z
8687106 8687106 20251204042025_ILClL US0062 2025-12-05T14:13:54.357Z 2025-12-05T14:14:35.621Z
8684515 8684515 20251204130039_zS8Wn US0062 2025-12-05T14:03:35.154Z 2025-12-05T14:03:35.154Z
8684266 8684266 20251204114957_ljG0K US0062 2025-12-05T14:02:30.601Z 2025-12-05T14:02:30.601Z
8684218 8684218 20251204112941_MU0Uc US0062 2025-12-05T14:02:12.152Z 2025-12-05T14:02:12.152Z
8684080 8684080 20251204103534_laeRs US0062 2025-12-05T14:01:45.535Z 2025-12-05T14:01:45.535Z
8684008 8684008 20251204100645_7KBqr US0062 2025-12-05T14:01:31.945Z 2025-12-05T14:01:31.945Z
8683957 8683957 20251204094729_w6qgy US0062 2025-12-05T14:01:21.163Z 2025-12-05T14:01:21.163Z
8683953 8683953 20251204094624_wzj1M US0062 2025-12-05T14:01:20.636Z 2025-12-05T14:01:20.636Z
8683885 8683885 20251204091338_P5Ajj US0062 2025-12-05T14:01:00.032Z 2025-12-05T14:01:00.032Z
8683863 8683863 20251204090600_Zyr4r US0062 2025-12-05T14:00:55.098Z 2025-12-05T14:00:55.098Z
8683850 8683850 20251204085853_jXP5R US0062 2025-12-05T14:00:52.057Z 2025-12-05T14:00:52.057Z
8683816 8683816 20251204083418_hAQPX US0062 2025-12-05T14:00:46.626Z 2025-12-05T14:00:46.626Z
8683813 8683813 20251204083403_Bfz3A US0062 2025-12-05T14:00:46.193Z 2025-12-05T14:00:46.193Z
8683806 8683806 20251204082701_798ib US0062 2025-12-05T14:00:42.375Z 2025-12-05T14:00:42.375Z
8683800 8683800 20251204081940_m2GOx US0062 2025-12-05T14:00:41.335Z 2025-12-05T14:00:41.335Z
8683786 8683786 20251204080904_yKQgY US0062 2025-12-05T14:00:34.936Z 2025-12-05T14:00:34.936Z
8683295 8683295 20251203065348_c5Bv4 US0062 2025-12-04T14:19:05.935Z 2025-12-05T14:23:15.234Z
8682776 8682776 20251203060236_GPsFA US0062 2025-12-04T14:17:59.895Z 2025-12-05T14:22:49.692Z
8682192 8682192 20251203045940_21EOs US0062 2025-12-04T14:16:35.597Z 2025-12-05T14:22:18.037Z
8678426 8678426 20251202124704_leMkh US0062 2025-12-04T14:06:43.624Z 2025-12-05T14:18:06.313Z
8677848 8677848 20251203124557_F52m3 US0062 2025-12-04T14:02:47.927Z 2025-12-05T14:14:34.987Z
8677742 8677742 20251203121346_cxyAd US0062 2025-12-04T14:02:26.327Z 2025-12-05T14:14:34.940Z
8677624 8677624 20251203111205_H31gD US0062 2025-12-04T14:02:04.459Z 2025-12-05T14:14:34.901Z
8677621 8677621 20251203110915_kSTzz US0062 2025-12-04T14:02:00.794Z 2025-12-05T14:14:34.899Z
8677604 8677604 20251203105936_1X0h2 US0062 2025-12-04T14:01:56.080Z 2025-12-05T14:14:34.894Z
8677601 8677601 20251203105920_9yrEP US0062 2025-12-04T14:01:55.537Z 2025-12-05T14:14:34.893Z
8677544 8677544 20251203103758_cSaVq US0062 2025-12-04T14:01:39.681Z 2025-12-05T14:14:34.875Z
8677472 8677472 20251203101624_7vseb US0062 2025-12-04T14:01:21.230Z 2025-12-05T14:14:34.852Z
8677441 8677441 20251203100133_akL4u US0062 2025-12-04T14:01:15.729Z 2025-12-05T14:14:34.843Z
8677406 8677406 20251203093847_M6jlo US0062 2025-12-04T14:01:03.745Z 2025-12-05T14:14:34.830Z
8677382 8677382 20251203092918_wmHEq US0062 2025-12-04T14:00:59.301Z 2025-12-05T14:14:34.821Z
8677277 8677277 20251203081123_Yv9vW US0062 2025-12-04T14:00:34.600Z 2025-12-05T14:14:34.784Z
8677274 8677274 20251203081045_VOmVi US0062 2025-12-04T14:00:34.237Z 2025-12-05T14:14:34.784Z
8677257 8677257 20251203075923_gYBey US0062 2025-12-04T14:00:30.725Z 2025-12-05T14:14:34.778Z
8677248 8677248 20251203075658_ukaqW US0062 2025-12-04T14:00:29.480Z 2025-12-05T14:14:34.776Z
8677246 8677246 20251203075629_xeyNZ US0062 2025-12-04T14:00:29.026Z 2025-12-05T14:14:34.775Z
8677234 8677234 20251203073116_zEi39 US0062 2025-12-04T14:00:26.364Z 2025-12-05T14:14:34.771Z
8677221 8677221 20251203072333_2mzLS US0062 2025-12-04T14:00:23.865Z 2025-12-05T14:14:34.768Z
8677213 8677213 20251203071516_2eSlz US0062 2025-12-04T14:00:22.802Z 2025-12-05T14:14:34.765Z
8677205 8677205 20251203071024_XbV49 US0062 2025-12-04T14:00:21.374Z 2025-12-05T14:14:34.763Z
8677199 8677199 20251203070723_EOzR9 US0062 2025-12-04T14:00:20.369Z 2025-12-05T14:14:34.762Z
8677173 8677173 20251203065819_mXmNE US0062 2025-12-04T14:00:13.900Z 2025-12-05T14:14:34.752Z
8677139 8677139 20251202070131_2pM0s US0062 2025-12-03T14:26:21.215Z 2025-12-05T14:29:22.705Z
8676797 8676797 20251202062634_PLnbp US0062 2025-12-03T14:25:42.865Z 2025-12-05T14:29:13.956Z
8676646 8676646 20251202061013_XtkrR US0062 2025-12-03T14:25:23.872Z 2025-12-05T14:29:09.699Z
8676523 8676523 20251202055943_SxTfI US0062 2025-12-03T14:25:16.460Z 2025-12-05T14:28:58.119Z
8676355 8676355 20251202054838_aNDD5 US0062 2025-12-03T14:25:08.971Z 2025-12-05T14:28:55.102Z
8676087 8676087 20251202053516_BhIMD US0062 2025-12-03T14:24:41.336Z 2025-12-05T14:28:48.309Z
8676025 8676025 20251202053345_cIkMK US0062 2025-12-03T14:24:37.125Z 2025-12-05T14:28:46.664Z
8675733 8675733 20251202051149_QD6zp US0062 2025-12-03T14:24:13.089Z 2025-12-05T14:28:39.846Z
8675689 8675689 20251202050722_7Ll9D US0062 2025-12-03T14:24:06.059Z 2025-12-05T14:28:38.464Z
8675686 8675686 20251202050721_t46vM US0062 2025-12-03T14:24:02.635Z 2025-12-05T14:28:38.352Z
8675502 8675502 20251202045025_2RD3D US0062 2025-12-03T14:23:47.985Z 2025-12-05T14:28:34.029Z
8675248 8675248 20251202042312_mDlTd US0062 2025-12-03T14:23:24.035Z 2025-12-05T14:28:17.976Z
8675197 8675197 20251202041751_rptKz US0062 2025-12-03T14:23:17.373Z 2025-12-05T14:28:16.682Z
8674781 8674781 20251202032451_EkYNF US0062 2025-12-03T14:22:21.255Z 2025-12-05T14:28:02.823Z
8671503 8671503 20251201122618_GF1G1 US0062 2025-12-03T14:12:46.567Z 2025-12-05T14:24:32.012Z
8671489 8671489 20251201122341_0x8aK US0062 2025-12-03T14:12:44.025Z 2025-12-05T14:24:31.143Z
8671400 8671400 20251201121247_UzLlM US0062 2025-12-03T14:12:21.235Z 2025-12-05T14:24:27.139Z
8671376 8671376 20251201120943_sHpsw US0062 2025-12-03T14:12:17.468Z 2025-12-05T14:24:26.089Z
8671372 8671372 20251201120714_RIF0W US0062 2025-12-03T14:12:16.474Z 2025-12-05T14:24:25.846Z
8671364 8671364 20251201120626_kQmUt US0062 2025-12-03T14:12:15.638Z 2025-12-05T14:24:25.647Z
8671203 8671203 20251201113358_mP2jA US0062 2025-12-03T14:11:45.801Z 2025-12-05T14:24:17.784Z
8671123 8671123 20251201111746_UVPKA US0062 2025-12-03T14:11:17.867Z 2025-12-05T14:24:06.317Z
8670979 8670979 20251201105748_jlusn US0062 2025-12-03T14:10:59.963Z 2025-12-05T14:23:58.373Z
8670962 8670962 20251201105533_6Ozmw US0062 2025-12-03T14:10:51.574Z 2025-12-05T14:23:57.807Z
8670955 8670955 20251201105319_MHoYk US0062 2025-12-03T14:10:50.749Z 2025-12-05T14:23:57.572Z
8670943 8670943 20251201105104_byYn4 US0062 2025-12-03T14:10:47.648Z 2025-12-05T14:23:56.854Z
8670880 8670880 20251201103640_lcgMb US0062 2025-12-03T14:10:37.196Z 2025-12-05T14:23:54.271Z
8670859 8670859 20251201103431_2tmtm US0062 2025-12-03T14:10:35.209Z 2025-12-05T14:23:53.796Z
8670850 8670850 20251201103149_8Nbox US0062 2025-12-03T14:10:32.265Z 2025-12-05T14:23:52.958Z
8670792 8670792 20251201101621_sAwLN US0062 2025-12-03T14:10:07.625Z 2025-12-05T14:23:49.985Z
8670120 8670120 20251202131356_UUmUm US0062 2025-12-03T14:06:58.640Z 2025-12-05T14:18:12.865Z
8670109 8670109 20251202131011_OjjYj US0062 2025-12-03T14:06:56.470Z 2025-12-05T14:18:12.278Z
8670092 8670092 20251202130728_3OnnM US0062 2025-12-03T14:06:53.287Z 2025-12-05T14:18:11.120Z
8670085 8670085 20251202130452_WxKWi US0062 2025-12-03T14:06:51.464Z 2025-12-05T14:18:10.631Z
8670027 8670027 20251202124704_n0zWy US0062 2025-12-03T14:06:31.859Z 2025-12-03T14:06:31.859Z
8670019 8670019 20251202124624_BzYIE US0062 2025-12-03T14:06:30.289Z 2025-12-05T14:18:05.787Z
8669920 8669920 20251202122655_cvBO2 US0062 2025-12-03T14:06:02.542Z 2025-12-05T14:17:58.252Z
8669877 8669877 20251202122029_RclCG US0062 2025-12-03T14:05:54.262Z 2025-12-05T14:17:55.418Z
8669723 8669723 20251202120523_X9l0l US0062 2025-12-03T14:05:17.177Z 2025-12-05T14:17:44.137Z
8669710 8669710 20251202120304_EB61s US0062 2025-12-03T14:05:14.638Z 2025-12-05T14:17:43.422Z
8669699 8669699 20251202115924_J4NU6 US0062 2025-12-03T14:05:11.900Z 2025-12-05T14:17:42.390Z
8669598 8669598 20251202113947_NOKiQ US0062 2025-12-03T14:04:39.705Z 2025-12-05T14:17:34.699Z
8669439 8669439 20251202111150_z5GYO US0062 2025-12-03T14:03:49.373Z 2025-12-05T14:17:21.289Z
8669350 8669350 20251202105905_QLzPA US0062 2025-12-03T14:03:26.805Z 2025-12-03T14:03:26.805Z
8669277 8669277 20251202104353_83Tvo US0062 2025-12-03T14:03:08.376Z 2025-12-05T14:17:03.213Z
8669203 8669203 20251202103143_2lOnp US0062 2025-12-03T14:02:51.234Z 2025-12-05T14:16:58.259Z
8669143 8669143 20251202101905_S7lxh US0062 2025-12-03T14:02:42.955Z 2025-12-05T14:16:54.474Z
8669082 8669082 20251202100927_lgTVL US0062 2025-12-03T14:02:21.504Z 2025-12-05T14:16:50.007Z
8669036 8669036 20251202095504_WR9CD US0062 2025-12-03T14:02:04.792Z 2025-12-05T14:16:45.124Z
8668983 8668983 20251202094605_aFP4A US0062 2025-12-03T14:01:56.167Z 2025-12-05T14:16:36.132Z
8668955 8668955 20251202094021_3gO8j US0062 2025-12-03T14:01:43.322Z 2025-12-05T14:16:22.576Z
8668947 8668947 20251202093647_UyH1D US0062 2025-12-03T14:01:39.330Z 2025-12-05T14:16:19.980Z
8668779 8668779 20251202085936_nXfD3 US0062 2025-12-03T14:01:13.274Z 2025-12-05T14:15:22.683Z
8668746 8668746 20251202084937_qAZTb US0062 2025-12-03T14:01:00.824Z 2025-12-05T14:15:10.653Z
8668558 8668558 20251202073529_z7xMd US0062 2025-12-03T14:00:22.471Z 2025-12-05T14:14:41.923Z

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