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

537 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
9253114 9253114 20260124092605_3ip36 US005K 2026-01-25T14:00:45.524Z 2026-01-29T14:40:18.090Z
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-29T14:54:11.563Z
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
8986524 8986524 20251218054730_Oe0fz US005K 2025-12-26T14:38:12.112Z 2025-12-27T15:19:18.351Z
8986227 8986227 20251218044416_2n9Pv US005K 2025-12-26T14:37:16.212Z 2025-12-27T15:19:13.866Z
8973870 8973870 20251220014329_O5jbp US005K 2025-12-26T14:03:14.598Z 2025-12-27T14:56:44.475Z
8963578 8963578 20251216055315_DgkIc US005K 2025-12-25T14:39:25.839Z 2025-12-25T14:39:25.839Z
8953845 8953845 20251217050100_y2RbD US005K 2025-12-25T14:08:11.220Z 2025-12-26T14:57:39.762Z
8952260 8952260 20251215022359_CWSX3 US005K 2025-12-24T15:09:21.494Z 2025-12-24T15:09:21.494Z
8950059 8950059 20251215003629_4UdU9 US005K 2025-12-24T15:06:53.703Z 2025-12-24T15:06:53.703Z
8926167 8926167 20251215025244_Icg3C US005K 2025-12-24T14:02:21.157Z 2025-12-24T15:09:28.789Z
8808319 8808319 20251213032128_Lyygd US005K 2025-12-17T14:00:32.139Z 2025-12-23T14:16:19.123Z
8710042 8710042 20251209094501_LCi2N US005K 2025-12-10T14:03:58.324Z 2025-12-17T15:23:27.099Z
8709826 8709826 20251209090634_YIMdR US005K 2025-12-10T14:03:25.102Z 2025-12-17T15:22:56.483Z
8709473 8709473 20251209075631_DG5av US005K 2025-12-10T14:02:30.362Z 2025-12-17T15:22:46.238Z
8709450 8709450 20251209075342_TlmCx US005K 2025-12-10T14:02:28.448Z 2025-12-17T15:22:45.679Z
8694663 8694663 20251207061059_XeaX7 US005K 2025-12-08T14:00:48.308Z 2025-12-16T15:09:36.907Z
8687230 8687230 20251204060001_2VkiK US005K 2025-12-05T14:14:27.504Z 2025-12-11T14:42:05.920Z
8683694 8683694 20251204065827_Y34ZA US005K 2025-12-05T14:00:12.994Z 2025-12-13T16:02:42.528Z
8683141 8683141 20251203063124_av9aw US005K 2025-12-04T14:18:38.048Z 2025-12-11T14:47:33.497Z
8677164 8677164 20251203065547_3HMdF US005K 2025-12-04T14:00:11.567Z 2025-12-11T14:39:16.701Z
8658746 8658746 20251201101229_IjZcs US005K 2025-12-02T14:00:33.813Z 2025-12-02T14:00:33.813Z
8658730 8658730 20251201094244_xwW2f US005K 2025-12-02T14:00:29.128Z 2025-12-10T14:36:40.833Z
8647901 8647901 20251129055855_ZezEk US005K 2025-11-30T14:29:22.264Z 2025-12-07T14:59:22.531Z
8639066 8639066 20251129102137_pes0m US005K 2025-11-30T14:03:37.732Z 2025-12-08T14:50:23.123Z
8638447 8638447 20251129084822_1a9nC US005K 2025-11-30T14:00:57.157Z 2025-12-08T14:50:08.425Z
8637945 8637945 20251128073604_SFkj1 US005K 2025-11-29T14:28:18.854Z 2025-12-06T15:04:05.967Z
8637802 8637802 20251128064420_3Gz8O US005K 2025-11-29T14:27:53.293Z 2025-12-06T15:04:04.452Z
8592737 8592737 20251124091409_uegJs US005K 2025-11-25T14:27:33.250Z 2025-12-02T15:13:06.945Z
8592490 8592490 20251124075955_E5CFC US005K 2025-11-25T14:26:49.581Z 2025-12-02T15:13:04.584Z
8592435 8592435 20251124073440_kkp5D US005K 2025-11-25T14:26:43.393Z 2025-12-02T15:13:04.073Z
8592335 8592335 20251124065005_3hFyF US005K 2025-11-25T14:26:32.104Z 2025-12-02T15:13:03.294Z
8592324 8592324 20251124064418_VWbt3 US005K 2025-11-25T14:26:31.223Z 2025-12-02T15:13:03.239Z
8592173 8592173 20251124055617_bu3nw US005K 2025-11-25T14:25:58.922Z 2025-12-02T15:13:02.171Z
8592003 8592003 20251124053229_rcF3g US005K 2025-11-25T14:25:37.659Z 2025-12-02T15:13:01.365Z
8588875 8588875 20251124004038_ljoAk US005K 2025-11-25T14:18:30.329Z 2025-12-02T15:11:58.408Z
8583417 8583417 20251124105852_Or7Rg US005K 2025-11-25T14:01:52.105Z 2025-12-02T15:05:30.040Z
8583321 8583321 20251124102858_9CCnM US005K 2025-11-25T14:01:19.812Z 2025-12-02T15:05:28.787Z
8583265 8583265 20251124101008_38kgv US005K 2025-11-25T14:01:07.176Z 2025-12-02T15:05:27.749Z
8583213 8583213 20251124100207_FLubB US005K 2025-11-25T14:00:49.399Z 2025-12-02T15:05:26.958Z
8583187 8583187 20251124095525_HdSl3 US005K 2025-11-25T14:00:36.991Z 2025-12-02T15:05:26.610Z
8582977 8582977 20251123092441_vvGvr US005K 2025-11-24T14:34:40.685Z 2025-12-01T15:22:30.241Z

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