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

576 rows where station_code = "US005K" 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
9633754 9633754 20260408043515_mOHI6 US005K 2026-04-09T12:28:30.759Z 2026-04-09T12:28:35.311Z
9633112 9633112 20260408030327_2WP38 US005K 2026-04-09T12:27:14.590Z 2026-04-09T12:28:35.161Z
9624981 9624981 20260408090757_ywW4Q US005K 2026-04-09T12:03:39.265Z 2026-04-09T12:03:39.265Z
9616963 9616963 20260407080543_zJo2U US005K 2026-04-08T12:01:09.233Z 2026-04-09T12:28:33.485Z
9612328 9612328 20260406094928_gtm3W US005K 2026-04-07T12:01:31.058Z 2026-04-09T12:29:44.174Z
9593084 9593084 20260329052621_U9MsE US005K 2026-03-30T12:02:53.082Z 2026-04-07T12:27:01.198Z
9593052 9593052 20260329044021_5FODN US005K 2026-03-30T12:02:45.334Z 2026-04-07T12:27:00.136Z
9572254 9572254 20260324082127_3LKHm US005K 2026-03-25T12:04:26.130Z 2026-04-02T12:35:10.997Z
9555956 9555956 20260322084939_i1wgd US005K 2026-03-23T12:04:11.882Z 2026-03-30T12:28:40.227Z
9535492 9535492 20260320074558_2spoT US005K 2026-03-21T12:10:57.578Z 2026-03-28T12:34:45.031Z
9535184 9535184 20260320060148_PSYPY US005K 2026-03-21T12:09:58.621Z 2026-03-28T12:34:28.994Z
9535142 9535142 20260320054930_FuL4O US005K 2026-03-21T12:09:53.133Z 2026-03-28T12:34:28.280Z
9512350 9512350 20260318052557_WHWNe US005K 2026-03-19T12:12:15.738Z 2026-03-26T12:37:44.340Z
9512328 9512328 20260318051532_J5P2x US005K 2026-03-19T12:12:12.025Z 2026-03-26T12:37:44.081Z
9478251 9478251 20260314085448_ED6W5 US005K 2026-03-15T12:10:37.509Z 2026-03-22T12:42:09.250Z
9477924 9477924 20260314073900_n3Vq2 US005K 2026-03-15T12:09:41.042Z 2026-03-22T12:42:06.479Z
9452382 9452382 20260310094900_24UOZ US005K 2026-03-11T12:05:20.139Z 2026-03-18T12:39:12.400Z
9415981 9415981 20260302070322_3nmXA US005K 2026-03-03T14:02:20.477Z 2026-03-10T12:35:55.075Z
9410075 9410075 20260228085654_k0NHZ US005K 2026-03-01T14:02:51.324Z 2026-03-08T12:41:50.244Z
9409883 9409883 20260228062717_P8SFs US005K 2026-03-01T14:02:27.217Z 2026-03-08T12:41:36.719Z
9403345 9403345 20260227091642_nLnbc US005K 2026-02-28T14:07:59.878Z 2026-03-07T14:47:47.880Z
9402982 9402982 20260227061048_Vq36A US005K 2026-02-28T14:06:46.296Z 2026-03-07T14:47:19.677Z
9383575 9383575 20260224062118_LQ27D US005K 2026-02-25T14:02:13.336Z 2026-03-04T14:17:51.539Z
9359349 9359349 20260221083641_OipzO US005K 2026-02-22T14:04:32.036Z 2026-03-02T14:21:14.319Z
9359054 9359054 20260221070307_XzAhC US005K 2026-02-22T14:03:35.134Z 2026-03-02T14:21:10.675Z
9358982 9358982 20260221062707_aV5cV US005K 2026-02-22T14:03:16.229Z 2026-03-02T14:21:09.775Z
9358761 9358761 20260221043820_N6hCT US005K 2026-02-22T14:02:16.660Z 2026-03-02T14:20:53.590Z
9358689 9358689 20260221040050_ahNA2 US005K 2026-02-22T14:01:59.023Z 2026-03-02T14:20:52.330Z
9358406 9358406 20260221005537_jlAM1 US005K 2026-02-22T14:00:39.186Z 2026-03-02T14:20:45.916Z
9341549 9341549 20260219093418_Co1i2 US005K 2026-02-20T14:00:56.956Z 2026-02-28T14:43:51.938Z
9323934 9323934 20260214070044_jce5k US005K 2026-02-15T14:07:45.768Z 2026-02-23T14:46:49.341Z
9322679 9322679 20260214034307_dEOhh US005K 2026-02-15T14:03:35.016Z 2026-02-23T14:46:20.876Z
9308584 9308584 20260209103401_eUInJ US005K 2026-02-10T14:08:03.093Z 2026-02-18T15:00:08.835Z
9307898 9307898 20260209081915_2zcbK US005K 2026-02-10T14:04:49.907Z 2026-02-18T14:59:11.094Z
9307758 9307758 20260209073534_yniOs US005K 2026-02-10T14:04:08.252Z 2026-02-18T14:59:02.464Z
9288582 9288582 20260203000001_tHbWa US005K 2026-02-04T14:10:48.759Z 2026-02-11T14:51:02.013Z
9286603 9286603 20260202103219_MqV3V US005K 2026-02-03T14:02:00.288Z 2026-02-11T14:50:08.756Z
9286567 9286567 20260202100744_B4o9K US005K 2026-02-03T14:01:41.259Z 2026-02-11T14:50:05.097Z
9284567 9284567 20260131024348_dNGa7 US005K 2026-02-01T14:16:13.911Z 2026-02-08T14:50:10.673Z
9253114 9253114 20260124092605_3ip36 US005K 2026-01-25T14:00:45.524Z 2026-02-02T14:45:53.960Z
9244545 9244545 20260121090308_VVyYG US005K 2026-01-22T14:25:58.964Z 2026-01-29T15:06:25.112Z
9244441 9244441 20260121083021_NwRBw US005K 2026-01-22T14:25:32.445Z 2026-01-29T15:06:09.362Z
9239367 9239367 20260121103336_AUbNO US005K 2026-01-22T14:01:11.801Z 2026-01-30T14:51:50.943Z
9238993 9238993 20260119080240_aNtW4 US005K 2026-01-21T14:40:04.889Z 2026-01-27T15:06:30.001Z
9238852 9238852 20260120095935_KkHng US005K 2026-01-21T14:30:43.365Z 2026-01-28T15:03:04.217Z
9235808 9235808 20260120020110_ZMtfO US005K 2026-01-21T14:20:25.965Z 2026-01-28T14:59:21.689Z
9232337 9232337 20260120110709_RIIwv US005K 2026-01-21T14:01:21.014Z 2026-01-29T14:59:26.603Z
9232068 9232068 20260120101746_snQ7W US005K 2026-01-21T14:00:12.227Z 2026-01-29T14:59:05.797Z
9231844 9231844 20260119100249_D87nH US005K 2026-01-20T14:34:30.531Z 2026-01-27T15:07:02.031Z
9231312 9231312 20260119071424_ZnSTe US005K 2026-01-20T14:32:18.278Z 2026-01-27T15:06:22.742Z
9226026 9226026 20260119104951_gsCIv US005K 2026-01-20T14:00:30.413Z 2026-01-28T14:54:29.312Z
9215825 9215825 20260116110703_U6zRk US005K 2026-01-17T14:27:00.548Z 2026-01-24T15:15:14.409Z
9214920 9214920 20260116084546_nQQ0b US005K 2026-01-17T14:23:47.050Z 2026-01-24T15:14:21.656Z
9214849 9214849 20260116082410_8qiKM US005K 2026-01-17T14:23:31.085Z 2026-01-24T15:14:10.190Z
9214840 9214840 20260116082137_6RUiI US005K 2026-01-17T14:23:28.313Z 2026-01-24T15:14:09.713Z
9212657 9212657 20260116000837_KfoJC US005K 2026-01-17T14:13:10.048Z 2026-01-24T15:11:09.162Z
9196997 9196997 20260113095135_grtq9 US005K 2026-01-14T14:20:59.198Z 2026-01-21T15:06:12.206Z
9167660 9167660 20260108035502_n3jLQ US005K 2026-01-09T14:08:42.343Z 2026-01-16T15:11:34.914Z
9167457 9167457 20260108015459_GnRUu US005K 2026-01-09T14:07:49.435Z 2026-01-16T15:11:20.722Z
9163911 9163911 20260107111349_HWQ1n US005K 2026-01-08T14:10:59.695Z 2026-01-13T15:03:53.262Z
9114955 9114955 20251231043713_G26zl US005K 2026-01-01T14:23:52.894Z 2026-01-08T15:10:16.189Z
9066122 9066122 20251226055347_4qsAp US005K 2025-12-29T14:39:38.862Z 2026-01-03T15:37:32.564Z
9066120 9066120 20251226055347_YHOUg US005K 2025-12-29T14:39:38.514Z 2025-12-30T15:19:25.655Z
9065684 9065684 20251226052410_32gj3 US005K 2025-12-29T14:38:58.639Z 2026-01-03T15:37:11.432Z
9059852 9059852 20251225230406_upE3o US005K 2025-12-29T14:28:06.653Z 2025-12-29T14:51:12.390Z
9037755 9037755 20251224094853_08y35 US005K 2025-12-28T14:38:05.656Z 2026-01-01T15:54:52.935Z
9023977 9023977 20251220233856_s5FlN US005K 2025-12-27T15:10:26.846Z 2025-12-27T15:10:26.846Z
9019103 9019103 20251220090330_BApac US005K 2025-12-27T15:03:14.739Z 2025-12-27T15:03:14.739Z
9019083 9019083 20251220090205_uhRJg US005K 2025-12-27T15:03:08.899Z 2025-12-29T15:24:28.742Z
9018495 9018495 20251220070244_yOt2N US005K 2025-12-27T15:02:39.229Z 2025-12-29T15:23:40.948Z
9018057 9018057 20251220061244_VsmxS US005K 2025-12-27T15:02:07.905Z 2025-12-27T15:02:07.905Z
9016621 9016621 20251220041934_YuhAJ US005K 2025-12-27T14:59:50.688Z 2025-12-29T15:23:24.693Z
9007115 9007115 20251221085914_cLD2B US005K 2025-12-27T14:39:35.643Z 2025-12-27T14:39:35.643Z
9006804 9006804 20251221073415_rbj05 US005K 2025-12-27T14:38:53.973Z 2025-12-27T14:38:53.973Z
9006676 9006676 20251221070332_WjNse US005K 2025-12-27T14:38:23.694Z 2025-12-27T14:38:23.694Z
9006671 9006671 20251221070203_YEbnB US005K 2025-12-27T14:38:23.190Z 2025-12-27T14:38:23.190Z
9006640 9006640 20251221065408_OGVwv US005K 2025-12-27T14:38:20.476Z 2025-12-27T14:38:20.476Z
9006588 9006588 20251221064558_qpc1o US005K 2025-12-27T14:38:16.407Z 2025-12-27T14:38:16.407Z
9006407 9006407 20251221060159_RikIa US005K 2025-12-27T14:37:44.196Z 2025-12-27T14:37:44.196Z
9006404 9006404 20251221060128_plzfR US005K 2025-12-27T14:37:43.848Z 2025-12-27T14:37:43.848Z
9006312 9006312 20251221054011_vUmN0 US005K 2025-12-27T14:37:33.769Z 2025-12-27T14:37:33.769Z
9005232 9005232 20251221002850_AlUsK US005K 2025-12-27T14:33:28.479Z 2025-12-27T14:33:28.479Z
9002079 9002079 20251222110909_uxCeX US005K 2025-12-27T14:24:07.822Z 2025-12-30T15:48:04.502Z
9001682 9001682 20251222103342_ZPgos US005K 2025-12-27T14:22:56.847Z 2025-12-30T15:48:00.688Z
9001377 9001377 20251222100939_iAbEx US005K 2025-12-27T14:21:59.551Z 2025-12-30T15:47:57.700Z
9000818 9000818 20251222092735_WFJQh US005K 2025-12-27T14:20:28.871Z 2025-12-30T15:47:52.061Z
9000593 9000593 20251222091156_5t5rl US005K 2025-12-27T14:19:49.779Z 2025-12-30T15:47:49.813Z
9000202 9000202 20251222084929_InXrU US005K 2025-12-27T14:18:56.193Z 2025-12-30T15:47:46.170Z
8999597 8999597 20251222075718_wC3LT US005K 2025-12-27T14:17:13.647Z 2025-12-30T15:47:21.893Z
8999166 8999166 20251222070724_QU9J9 US005K 2025-12-27T14:15:47.116Z 2025-12-30T15:46:55.164Z
8998983 8998983 20251222064658_AOjZ3 US005K 2025-12-27T14:15:18.127Z 2025-12-30T15:46:53.344Z
8996774 8996774 20251222025418_tOMAW US005K 2025-12-27T14:06:25.016Z 2025-12-30T15:46:07.749Z
8996591 8996591 20251222023546_Rzjm2 US005K 2025-12-27T14:05:36.570Z 2025-12-28T14:58:07.598Z
8995505 8995505 20251218004759_kbfMJ US005K 2025-12-26T15:05:54.281Z 2025-12-26T15:05:54.281Z
8995469 8995469 20251218004037_FzwMr US005K 2025-12-26T15:05:52.139Z 2025-12-26T15:05:52.139Z
8987276 8987276 20251218075827_IYG6t US005K 2025-12-26T14:39:58.468Z 2025-12-27T15:20:07.274Z
8987255 8987255 20251218075534_emV3y US005K 2025-12-26T14:39:56.980Z 2025-12-26T14:39:56.980Z
8987131 8987131 20251218073701_AMI2W US005K 2025-12-26T14:39:32.957Z 2025-12-27T15:20:04.106Z
8986932 8986932 20251218070234_f9ifW US005K 2025-12-26T14:39:08.090Z 2025-12-27T15:19:54.454Z
8986541 8986541 20251218055148_pAQf2 US005K 2025-12-26T14:38:13.710Z 2025-12-27T15:19:18.579Z

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