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

>10,000 rows count all where station_code = "US0002" 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
9273500 9273500 20260128064426_8Ft6G US0002 2026-01-29T14:30:02.157Z 2026-01-29T14:30:25.826Z
9273496 9273496 20260128064249_bNm7y US0002 2026-01-29T14:30:01.738Z 2026-01-29T14:30:25.826Z
9273401 9273401 20260128060523_0jtH4 US0002 2026-01-29T14:29:40.505Z 2026-01-29T14:30:25.803Z
9273261 9273261 20260128052038_Mpkmy US0002 2026-01-29T14:29:14.206Z 2026-01-29T14:30:25.779Z
9273100 9273100 20260128044425_3CTO5 US0002 2026-01-29T14:28:45.076Z 2026-01-29T14:30:25.750Z
9272492 9272492 20260128021654_67fuE US0002 2026-01-29T14:26:56.207Z 2026-01-29T14:30:25.355Z
9269224 9269224 20260128124826_lLzk8 US0002 2026-01-29T14:07:03.051Z 2026-01-29T14:07:03.051Z
9269128 9269128 20260128123403_Cgp38 US0002 2026-01-29T14:06:38.631Z 2026-01-29T14:06:38.631Z
9268957 9268957 20260128115128_kJH2q US0002 2026-01-29T14:05:43.531Z 2026-01-29T14:05:43.531Z
9268348 9268348 20260128095908_gza9V US0002 2026-01-29T14:02:37.124Z 2026-01-29T14:02:37.124Z
9268252 9268252 20260128093126_yU3c1 US0002 2026-01-29T14:02:03.835Z 2026-01-29T14:02:03.835Z
9268049 9268049 20260128082402_Ct1h3 US0002 2026-01-29T14:00:45.176Z 2026-01-29T14:00:45.176Z
9268041 9268041 20260128081330_RlBXd US0002 2026-01-29T14:00:40.667Z 2026-01-29T14:00:40.667Z
9267961 9267961 20260127072115_2p35E US0002 2026-01-28T14:24:01.941Z 2026-01-29T14:35:59.681Z
9264833 9264833 20260127132005_pudhv US0002 2026-01-28T14:07:54.311Z 2026-01-29T14:30:24.309Z
9264766 9264766 20260127130805_us3RZ US0002 2026-01-28T14:07:32.520Z 2026-01-29T14:30:24.281Z
9264761 9264761 20260127130710_QE4gP US0002 2026-01-28T14:07:31.373Z 2026-01-29T14:30:24.280Z
9264665 9264665 20260127125317_6CuP4 US0002 2026-01-28T14:07:05.695Z 2026-01-29T14:30:24.240Z
9264637 9264637 20260127125131_xJuA7 US0002 2026-01-28T14:06:59.063Z 2026-01-29T14:30:24.234Z
9264611 9264611 20260127125036_TaQp8 US0002 2026-01-28T14:06:54.538Z 2026-01-29T14:30:24.229Z
9264597 9264597 20260127124955_zohHA US0002 2026-01-28T14:06:49.295Z 2026-01-29T14:30:24.227Z
9264318 9264318 20260127120104_35rk4 US0002 2026-01-28T14:05:29.194Z 2026-01-29T14:30:20.853Z
9264226 9264226 20260127114332_U2iQS US0002 2026-01-28T14:05:03.117Z 2026-01-29T14:30:20.554Z
9263829 9263829 20260127101938_S6Mtg US0002 2026-01-28T14:03:02.957Z 2026-01-29T14:30:18.959Z
9263630 9263630 20260127093058_tLoJG US0002 2026-01-28T14:01:51.912Z 2026-01-29T14:30:16.601Z
9263586 9263586 20260127092048_sSHj6 US0002 2026-01-28T14:01:36.287Z 2026-01-29T14:30:16.583Z
9263404 9263404 20260127073920_PuGXr US0002 2026-01-28T14:00:20.338Z 2026-01-29T14:30:16.488Z
9263114 9263114 20260126072454_vOjyG US0002 2026-01-27T14:17:05.721Z 2026-01-29T14:39:17.392Z
9263077 9263077 20260126070211_4UOrI US0002 2026-01-27T14:16:55.579Z 2026-01-29T14:39:13.530Z
9263010 9263010 20260126061331_OAdUV US0002 2026-01-27T14:16:36.078Z 2026-01-29T14:39:09.324Z
9262858 9262858 20260126035400_233xO US0002 2026-01-27T14:15:43.251Z 2026-01-29T14:38:54.198Z
9261775 9261775 20260126131746_w0Lb6 US0002 2026-01-27T14:05:36.595Z 2026-01-29T14:32:57.311Z
9261722 9261722 20260126125936_KpMfC US0002 2026-01-27T14:05:15.942Z 2026-01-29T14:32:53.298Z
9261708 9261708 20260126125755_8GZ8g US0002 2026-01-27T14:05:13.844Z 2026-01-29T14:32:50.865Z
9261682 9261682 20260126124835_yV2ds US0002 2026-01-27T14:05:06.497Z 2026-01-29T14:32:48.481Z
9261601 9261601 20260126122803_jWymq US0002 2026-01-27T14:04:39.979Z 2026-01-29T14:32:42.774Z
9261561 9261561 20260126121447_gQ5u5 US0002 2026-01-27T14:04:21.782Z 2026-01-29T14:32:40.106Z
9261491 9261491 20260126115336_MGwjw US0002 2026-01-27T14:03:58.981Z 2026-01-29T14:32:31.543Z
9261337 9261337 20260126111027_33jl6 US0002 2026-01-27T14:03:15.351Z 2026-01-29T14:32:12.644Z
9261304 9261304 20260126110456_5hzLO US0002 2026-01-27T14:03:08.803Z 2026-01-29T14:32:11.170Z
9261250 9261250 20260126104815_F1tVU US0002 2026-01-27T14:02:50.089Z 2026-01-29T14:32:08.306Z
9261218 9261218 20260126103351_RsFJn US0002 2026-01-27T14:02:40.682Z 2026-01-29T14:32:05.569Z
9261144 9261144 20260126100127_mL8RT US0002 2026-01-27T14:02:12.759Z 2026-01-29T14:31:59.405Z
9261121 9261121 20260126095558_01R3O US0002 2026-01-27T14:02:01.819Z 2026-01-29T14:31:57.839Z
9261106 9261106 20260126095332_GrZPv US0002 2026-01-27T14:01:54.820Z 2026-01-29T14:31:56.857Z
9261065 9261065 20260126094328_bT506 US0002 2026-01-27T14:01:44.163Z 2026-01-29T14:31:43.330Z
9261044 9261044 20260126093731_zXB6d US0002 2026-01-27T14:01:38.065Z 2026-01-29T14:31:33.110Z
9261011 9261011 20260126092151_qErEp US0002 2026-01-27T14:01:23.528Z 2026-01-29T14:31:23.205Z
9260997 9260997 20260126091501_6ymY8 US0002 2026-01-27T14:01:19.530Z 2026-01-29T14:31:19.300Z
9260875 9260875 20260126082740_DBZy1 US0002 2026-01-27T14:00:35.670Z 2026-01-29T14:31:04.032Z
9252934 9252934 20260123082711_OWRL7 US0002 2026-01-24T14:17:53.028Z 2026-01-29T14:53:43.054Z
9252905 9252905 20260123074748_3hge1 US0002 2026-01-24T14:17:42.065Z 2026-01-29T14:53:41.523Z
9252648 9252648 20260123045926_pn8Yn US0002 2026-01-24T14:16:33.307Z 2026-01-29T14:53:13.504Z
9252643 9252643 20260123045817_49C9q US0002 2026-01-24T14:16:32.865Z 2026-01-29T14:53:13.360Z
9249809 9249809 20260122085943_1LvhC US0002 2026-01-23T14:16:17.278Z 2026-01-29T14:58:58.739Z
9249747 9249747 20260122082242_mvz5I US0002 2026-01-23T14:16:08.901Z 2026-01-29T14:58:53.198Z
9249701 9249701 20260122071237_wZEU4 US0002 2026-01-23T14:15:57.127Z 2026-01-29T14:58:50.311Z
9249697 9249697 20260122070914_Kd1tO US0002 2026-01-23T14:15:56.556Z 2026-01-29T14:58:50.148Z
9249688 9249688 20260122064129_eBS3B US0002 2026-01-23T14:15:54.801Z 2026-01-29T14:58:49.600Z
9249141 9249141 20260122034706_iA9BK US0002 2026-01-23T14:14:39.896Z 2026-01-29T14:58:14.279Z
9245242 9245242 20260122112430_fR5vb US0002 2026-01-23T14:01:10.768Z 2026-01-29T14:49:17.412Z
9244687 9244687 20260121094352_PD3QH US0002 2026-01-22T14:26:31.681Z 2026-01-29T15:06:31.132Z
9244462 9244462 20260121083459_ch73H US0002 2026-01-22T14:25:46.352Z 2026-01-29T15:06:10.454Z
9244269 9244269 20260121071254_osxOR US0002 2026-01-22T14:24:47.633Z 2026-01-29T15:05:58.504Z
9244211 9244211 20260121064825_RFFvn US0002 2026-01-22T14:24:37.603Z 2026-01-29T15:05:56.126Z
9244067 9244067 20260121060648_fT6P9 US0002 2026-01-22T14:24:04.410Z 2026-01-29T15:05:50.502Z
9244044 9244044 20260121060122_pIKu6 US0002 2026-01-22T14:24:00.524Z 2026-01-29T15:05:49.584Z
9243968 9243968 20260121054508_L8Rof US0002 2026-01-22T14:23:41.179Z 2026-01-29T15:05:37.093Z
9243828 9243828 20260121052432_sAnxj US0002 2026-01-22T14:23:19.621Z 2026-01-29T15:05:29.361Z
9243777 9243777 20260121051522_n7MeF US0002 2026-01-22T14:22:58.205Z 2026-01-29T15:05:27.111Z
9243484 9243484 20260121043909_3bR2r US0002 2026-01-22T14:22:04.073Z 2026-01-29T15:05:06.120Z
9242602 9242602 20260121022348_x85ui US0002 2026-01-22T14:18:31.742Z 2026-01-29T15:04:13.297Z
9239907 9239907 20260121130639_5y70Y US0002 2026-01-22T14:03:43.576Z 2026-01-29T14:55:01.221Z
9239892 9239892 20260121130205_NYO8p US0002 2026-01-22T14:03:39.056Z 2026-01-29T14:55:00.680Z
9239800 9239800 20260121123606_B6gkA US0002 2026-01-22T14:03:12.496Z 2026-01-29T14:54:43.030Z
9239753 9239753 20260121121246_PrFTq US0002 2026-01-22T14:03:00.261Z 2026-01-29T14:54:39.354Z
9239700 9239700 20260121115134_WkhdX US0002 2026-01-22T14:02:42.018Z 2026-01-29T14:54:36.337Z
9239684 9239684 20260121114353_fDD4o US0002 2026-01-22T14:02:35.720Z 2026-01-29T14:54:35.496Z
9239667 9239667 20260121113713_23Ebr US0002 2026-01-22T14:02:31.532Z 2026-01-29T14:54:34.745Z
9239653 9239653 20260121113251_fZG3b US0002 2026-01-22T14:02:27.508Z 2026-01-29T14:54:33.872Z
9239510 9239510 20260121110027_h3Azp US0002 2026-01-22T14:01:47.447Z 2026-01-29T14:54:20.627Z
9239373 9239373 20260121103543_ckVkM US0002 2026-01-22T14:01:13.207Z 2026-01-29T14:54:11.931Z
9239243 9239243 20260121101045_XJp32 US0002 2026-01-22T14:00:33.151Z 2026-01-29T14:54:01.646Z
9239201 9239201 20260121100014_U6VVd US0002 2026-01-22T14:00:21.105Z 2026-01-29T14:53:53.746Z
9239193 9239193 20260121095904_LbuZR US0002 2026-01-22T14:00:19.955Z 2026-01-29T14:53:53.445Z
9239153 9239153 20260115112742_psPaj US0002 2026-01-21T14:56:49.964Z 2026-01-22T15:05:40.174Z
9239143 9239143 20260115102213_FJFCC US0002 2026-01-21T14:56:34.433Z 2026-01-22T15:05:32.072Z
9239137 9239137 20260115052437_2x5yL US0002 2026-01-21T14:55:51.332Z 2026-01-22T15:04:13.754Z
9239101 9239101 20260116055330_J1bBe US0002 2026-01-21T14:52:17.274Z 2026-01-24T15:13:21.919Z
9238957 9238957 20260118130042_6J2cg US0002 2026-01-21T14:34:05.063Z 2026-01-27T14:59:17.822Z
9238927 9238927 20260120073933_KsO45 US0002 2026-01-21T14:31:22.518Z 2026-01-28T15:02:10.717Z
9238843 9238843 20260120095836_5FlUU US0002 2026-01-21T14:30:41.418Z 2026-01-28T15:03:03.846Z
9238720 9238720 20260120093853_Q4Eae US0002 2026-01-21T14:30:27.748Z 2026-01-28T15:02:47.799Z
9238715 9238715 20260120093829_P0WGq US0002 2026-01-21T14:30:27.037Z 2026-01-28T15:02:47.396Z
9238553 9238553 20260120090035_O55eu US0002 2026-01-21T14:29:56.884Z 2026-01-28T15:02:38.580Z
9238326 9238326 20260120082311_ksy1k US0002 2026-01-21T14:29:23.037Z 2026-01-28T15:02:29.330Z
9238320 9238320 20260120082254_4cHl7 US0002 2026-01-21T14:29:22.801Z 2026-01-28T15:02:29.080Z
9238282 9238282 20260120081541_T4J3S US0002 2026-01-21T14:29:06.296Z 2026-01-28T15:02:18.047Z
9238240 9238240 20260120080758_ckFYj US0002 2026-01-21T14:28:59.716Z 2026-01-28T15:02:15.571Z
9232864 9232864 20260120124322_ApDUi US0002 2026-01-21T14:03:36.545Z 2026-01-29T15:00:21.431Z

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