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

4,003 rows where station_code = "US0051" 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
9273317 9273317 20260128053744_hoUbG US0051 2026-01-29T14:29:19.385Z 2026-01-29T14:30:25.786Z
9273153 9273153 20260128045818_wSgeK US0051 2026-01-29T14:28:51.688Z 2026-01-29T14:30:25.760Z
9272667 9272667 20260128025757_Us24l US0051 2026-01-29T14:27:26.004Z 2026-01-29T14:30:25.436Z
9272541 9272541 20260128023130_XSfqf US0051 2026-01-29T14:27:06.880Z 2026-01-29T14:30:25.373Z
9272510 9272510 20260128022142_KEauN US0051 2026-01-29T14:27:01.637Z 2026-01-29T14:30:25.363Z
9272470 9272470 20260128021228_T9DE9 US0051 2026-01-29T14:26:48.968Z 2026-01-29T14:30:25.352Z
9272308 9272308 20260128013348_I4F9B US0051 2026-01-29T14:26:23.030Z 2026-01-29T14:30:25.326Z
9269287 9269287 20260128125752_G2Uvt US0051 2026-01-29T14:07:22.259Z 2026-01-29T14:07:22.259Z
9269072 9269072 20260128121759_A3MpS US0051 2026-01-29T14:06:17.792Z 2026-01-29T14:06:17.792Z
9269057 9269057 20260128121423_QITvJ US0051 2026-01-29T14:06:12.904Z 2026-01-29T14:06:12.904Z
9268998 9268998 20260128115916_HW2cO US0051 2026-01-29T14:05:54.252Z 2026-01-29T14:05:54.252Z
9268996 9268996 20260128115821_MvSYh US0051 2026-01-29T14:05:53.442Z 2026-01-29T14:05:53.442Z
9268807 9268807 20260128112413_R7CWp US0051 2026-01-29T14:04:58.464Z 2026-01-29T14:04:58.464Z
9268502 9268502 20260128103754_MvMZI US0051 2026-01-29T14:03:25.277Z 2026-01-29T14:03:25.277Z
9268136 9268136 20260128090001_yrUnj US0051 2026-01-29T14:01:18.388Z 2026-01-29T14:01:18.388Z
9268015 9268015 20260128074339_HeWxx US0051 2026-01-29T14:00:26.676Z 2026-01-29T14:00:26.676Z
9267924 9267924 20260127065502_VljpB US0051 2026-01-28T14:23:53.998Z 2026-01-29T14:35:54.263Z
9267911 9267911 20260127064847_xmoVn US0051 2026-01-28T14:23:51.332Z 2026-01-29T14:35:53.316Z
9267909 9267909 20260127064647_H9TEz US0051 2026-01-28T14:23:50.940Z 2026-01-29T14:35:53.104Z
9267894 9267894 20260127063749_02wCI US0051 2026-01-28T14:23:46.993Z 2026-01-29T14:35:51.406Z
9267885 9267885 20260127062654_V6yYM US0051 2026-01-28T14:23:45.247Z 2026-01-29T14:35:50.690Z
9267795 9267795 20260127045929_OaEsy US0051 2026-01-28T14:23:20.436Z 2026-01-29T14:35:43.754Z
9267753 9267753 20260127044513_xflth US0051 2026-01-28T14:23:07.203Z 2026-01-29T14:35:36.459Z
9267606 9267606 20260127033559_oYQUe US0051 2026-01-28T14:22:30.265Z 2026-01-29T14:35:21.788Z
9267476 9267476 20260127015908_boHTa US0051 2026-01-28T14:21:54.122Z 2026-01-29T14:35:06.075Z
9263896 9263896 20260127103605_iOa16 US0051 2026-01-28T14:03:26.094Z 2026-01-29T14:30:19.957Z
9263634 9263634 20260127093058_YYGfr US0051 2026-01-28T14:01:52.867Z 2026-01-29T14:30:16.609Z
9263572 9263572 20260127091610_jPjsC US0051 2026-01-28T14:01:31.234Z 2026-01-29T14:30:16.573Z
9263546 9263546 20260127090659_bB4d0 US0051 2026-01-28T14:01:19.358Z 2026-01-29T14:30:16.557Z
9263517 9263517 20260127085010_oQsMd US0051 2026-01-28T14:01:06.850Z 2026-01-29T14:30:16.549Z
9261706 9261706 20260126125643_sE2ql US0051 2026-01-27T14:05:13.187Z 2026-01-29T14:32:50.675Z
9261699 9261699 20260126125444_0CZ3I US0051 2026-01-27T14:05:10.921Z 2026-01-29T14:32:49.659Z
9261691 9261691 20260126125047_vxTaI US0051 2026-01-27T14:05:08.338Z 2026-01-29T14:32:48.792Z
9261670 9261670 20260126124604_3tw2z US0051 2026-01-27T14:04:58.557Z 2026-01-29T14:32:47.346Z
9261616 9261616 20260126123254_Zwe4v US0051 2026-01-27T14:04:43.949Z 2026-01-29T14:32:43.971Z
9261300 9261300 20260126110341_EVvqw US0051 2026-01-27T14:03:07.595Z 2026-01-29T14:32:10.797Z
9249735 9249735 20260122080518_hvJWO US0051 2026-01-23T14:16:02.392Z 2026-01-29T14:58:52.390Z
9249060 9249060 20260122032614_zgyrs US0051 2026-01-23T14:14:31.530Z 2026-01-29T14:58:11.152Z
9248901 9248901 20260122023858_W7wjI US0051 2026-01-23T14:14:05.396Z 2026-01-29T14:57:54.113Z
9248888 9248888 20260122023659_KoWwP US0051 2026-01-23T14:14:03.220Z 2026-01-29T14:57:53.209Z
9248821 9248821 20260122022050_dZbBi US0051 2026-01-23T14:13:55.192Z 2026-01-29T14:57:48.113Z
9245309 9245309 20260122114430_9svBa US0051 2026-01-23T14:01:27.292Z 2026-01-29T14:49:23.089Z
9245233 9245233 20260122112332_5jq4C US0051 2026-01-23T14:01:09.488Z 2026-01-29T14:49:16.906Z
9245186 9245186 20260122110208_jIdbs US0051 2026-01-23T14:00:54.374Z 2026-01-29T14:49:12.551Z
9245116 9245116 20260122101721_eSnpK US0051 2026-01-23T14:00:40.136Z 2026-01-29T14:49:02.415Z
9245114 9245114 20260122101613_XAYGv US0051 2026-01-23T14:00:38.473Z 2026-01-29T14:49:02.222Z
9245055 9245055 20260122094617_UFhlG US0051 2026-01-23T14:00:19.426Z 2026-01-29T14:48:54.351Z
9239876 9239876 20260121125757_sJUvY US0051 2026-01-22T14:03:35.418Z 2026-01-29T14:54:51.650Z
9239808 9239808 20260121123654_YIHE2 US0051 2026-01-22T14:03:15.622Z 2026-01-29T14:54:43.450Z
9239806 9239806 20260121123610_HF6fy US0051 2026-01-22T14:03:14.961Z 2026-01-29T14:54:43.168Z
9239788 9239788 20260121122843_8WpLZ US0051 2026-01-22T14:03:09.454Z 2026-01-29T14:54:41.991Z
9239648 9239648 20260121113040_ldNDN US0051 2026-01-22T14:02:25.295Z 2026-01-29T14:54:33.550Z
9239611 9239611 20260121112223_iVuzR US0051 2026-01-22T14:02:16.525Z 2026-01-29T14:54:31.987Z
9238450 9238450 20260120084048_IuUoC US0051 2026-01-21T14:29:35.053Z 2026-01-28T15:02:33.768Z
9238303 9238303 20260120081958_i3PL3 US0051 2026-01-21T14:29:14.313Z 2026-01-28T15:02:26.215Z
9238177 9238177 20260120074532_ywKwn US0051 2026-01-21T14:28:51.914Z 2026-01-28T15:02:11.501Z
9238125 9238125 20260120072848_Fo9oV US0051 2026-01-21T14:28:45.167Z 2026-01-28T15:02:08.578Z
9237990 9237990 20260120065012_ol9Kp US0051 2026-01-21T14:28:13.161Z 2026-01-28T15:02:02.091Z
9237728 9237728 20260120055614_g1jWe US0051 2026-01-21T14:27:30.661Z 2026-01-28T15:01:38.048Z
9237618 9237618 20260120054451_fi6zF US0051 2026-01-21T14:27:08.511Z 2026-01-28T15:01:33.341Z
9237606 9237606 20260120054239_SKSol US0051 2026-01-21T14:27:06.678Z 2026-01-28T15:01:32.755Z
9236962 9236962 20260120042306_8c8K2 US0051 2026-01-21T14:24:36.764Z 2026-01-28T15:00:50.983Z
9231963 9231963 20260119102648_YkcmP US0051 2026-01-20T14:34:55.929Z 2026-01-27T15:07:08.236Z
9225131 9225131 20260118080257_8DHaz US0051 2026-01-19T14:27:45.961Z 2026-01-26T15:04:05.734Z
9224936 9224936 20260118064943_TLx2v US0051 2026-01-19T14:26:51.572Z 2026-01-26T15:03:55.266Z
9224893 9224893 20260118063747_3r3Ne US0051 2026-01-19T14:26:38.593Z 2026-01-26T15:03:53.461Z
9220099 9220099 20260118120558_wxXOG US0051 2026-01-19T14:02:42.313Z 2026-01-27T14:58:49.635Z
9219891 9219891 20260118113852_3ubG7 US0051 2026-01-19T14:01:30.876Z 2026-01-27T14:58:38.706Z
9207691 9207691 20260115024509_CPocT US0051 2026-01-16T14:09:41.716Z 2026-01-22T15:03:29.995Z
9207325 9207325 20260115005505_kOpC6 US0051 2026-01-16T14:08:17.200Z 2026-01-22T15:03:18.795Z
9204601 9204601 20260114072417_TtgUs US0051 2026-01-15T14:27:53.112Z 2026-01-22T15:10:47.573Z
9204386 9204386 20260114063510_B2LLP US0051 2026-01-15T14:27:11.650Z 2026-01-22T15:10:26.903Z
9203352 9203352 20260114045239_DJjVy US0051 2026-01-15T14:24:09.001Z 2026-01-22T15:10:06.184Z
9202677 9202677 20260114040007_MIH9z US0051 2026-01-15T14:22:06.536Z 2026-01-22T15:09:24.679Z
9202597 9202597 20260114035324_4cHzU US0051 2026-01-15T14:21:45.409Z 2026-01-22T15:09:23.558Z
9202570 9202570 20260114035153_5GxEO US0051 2026-01-15T14:21:42.612Z 2026-01-22T15:09:23.182Z
9189991 9189991 20260112072401_RUe0e US0051 2026-01-13T14:20:13.974Z 2026-01-20T15:24:01.414Z
9189921 9189921 20260112065733_gPRTm US0051 2026-01-13T14:19:57.816Z 2026-01-20T15:23:47.680Z
9177208 9177208 20260110082628_FCwYj US0051 2026-01-11T14:11:14.238Z 2026-01-18T15:09:22.507Z
9177188 9177188 20260110080931_q10O8 US0051 2026-01-11T14:11:10.668Z 2026-01-18T15:09:20.851Z
9177182 9177182 20260110080647_Pfbj4 US0051 2026-01-11T14:11:09.247Z 2026-01-18T15:09:20.363Z
9177043 9177043 20260110070228_83hAp US0051 2026-01-11T14:10:41.742Z 2026-01-18T15:09:12.555Z
9176705 9176705 20260110060924_XZvA6 US0051 2026-01-11T14:09:46.317Z 2026-01-18T15:08:51.151Z
9176652 9176652 20260110060203_uHQ2m US0051 2026-01-11T14:09:38.020Z 2026-01-18T15:08:47.558Z
9175930 9175930 20260110042104_k339K US0051 2026-01-11T14:07:50.073Z 2026-01-18T15:08:13.878Z
9175011 9175011 20260110004518_PJs3P US0051 2026-01-11T14:05:08.060Z 2026-01-18T15:07:22.793Z
9164339 9164339 20260107125123_BoGuY US0051 2026-01-08T14:12:47.380Z 2026-01-13T15:04:28.380Z
9164308 9164308 20260107124613_mBvvo US0051 2026-01-08T14:12:38.971Z 2026-01-13T15:04:25.821Z
9164293 9164293 20260107124506_uDVOc US0051 2026-01-08T14:12:35.488Z 2026-01-13T15:04:24.739Z
9164279 9164279 20260107124340_ew2RJ US0051 2026-01-08T14:12:32.951Z 2026-01-13T15:04:23.839Z
9164083 9164083 20260107120247_bXZ3M US0051 2026-01-08T14:11:52.417Z 2026-01-13T15:04:03.922Z
9160767 9160767 20260106081507_x21up US0051 2026-01-07T14:13:45.187Z 2026-01-13T15:09:51.686Z
9160721 9160721 20260106074702_C9fga US0051 2026-01-07T14:13:34.380Z 2026-01-13T15:09:49.097Z
9160527 9160527 20260106060847_Q96l5 US0051 2026-01-07T14:12:53.964Z 2026-01-13T15:09:31.011Z
9153219 9153219 20260104013210_jmddS US0051 2026-01-06T14:27:29.980Z 2026-01-12T15:05:41.340Z
9153207 9153207 20260104005031_qTUKG US0051 2026-01-06T14:26:30.868Z 2026-01-12T15:04:58.989Z
9153205 9153205 20260104005017_Spe4o US0051 2026-01-06T14:26:30.425Z 2026-01-12T15:04:58.684Z
9153198 9153198 20260104003157_UoP0k US0051 2026-01-06T14:26:03.464Z 2026-01-12T15:04:31.702Z
9153192 9153192 20260104002916_IIBfD US0051 2026-01-06T14:25:58.690Z 2026-01-12T15:04:29.515Z
9121621 9121621 20260101003807_xS1Fk US0051 2026-01-02T14:08:18.229Z 2026-01-09T14:52:23.123Z

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