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 = "US000E" 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
9273405 9273405 20260128060523_0jtH4 US000E 2026-01-29T14:29:40.505Z 2026-01-29T14:30:25.803Z
9272852 9272852 20260128034746_UuEjB US000E 2026-01-29T14:28:02.602Z 2026-01-29T14:30:25.582Z
9272610 9272610 20260128024837_lP2Wj US000E 2026-01-29T14:27:14.305Z 2026-01-29T14:30:25.382Z
9269204 9269204 20260128124505_oPKvz US000E 2026-01-29T14:06:58.795Z 2026-01-29T14:06:58.795Z
9269199 9269199 20260128124437_fvjKY US000E 2026-01-29T14:06:57.461Z 2026-01-29T14:06:57.461Z
9269186 9269186 20260128124411_qywlz US000E 2026-01-29T14:06:55.407Z 2026-01-29T14:06:55.407Z
9268920 9268920 20260128114447_rReOD US000E 2026-01-29T14:05:33.723Z 2026-01-29T14:05:33.723Z
9268901 9268901 20260128114134_2ZcVQ US000E 2026-01-29T14:05:24.878Z 2026-01-29T14:05:24.878Z
9268824 9268824 20260128113043_rcgQC US000E 2026-01-29T14:05:04.826Z 2026-01-29T14:05:04.826Z
9268748 9268748 20260128111501_CaYZS US000E 2026-01-29T14:04:43.019Z 2026-01-29T14:04:43.019Z
9268680 9268680 20260128110125_nwele US000E 2026-01-29T14:04:19.244Z 2026-01-29T14:04:19.244Z
9268485 9268485 20260128103033_Is5Qa US000E 2026-01-29T14:03:20.148Z 2026-01-29T14:03:20.148Z
9268436 9268436 20260128102034_spKib US000E 2026-01-29T14:03:01.775Z 2026-01-29T14:03:01.775Z
9268364 9268364 20260128100142_mLVvr US000E 2026-01-29T14:02:40.987Z 2026-01-29T14:02:40.987Z
9268353 9268353 20260128095945_DSEWQ US000E 2026-01-29T14:02:38.156Z 2026-01-29T14:02:38.156Z
9268303 9268303 20260128094530_bU40q US000E 2026-01-29T14:02:17.094Z 2026-01-29T14:02:17.094Z
9268163 9268163 20260128090613_a5jpf US000E 2026-01-29T14:01:28.049Z 2026-01-29T14:01:28.049Z
9268145 9268145 20260128090203_DAxns US000E 2026-01-29T14:01:23.837Z 2026-01-29T14:01:23.837Z
9268094 9268094 20260128084740_vMNlA US000E 2026-01-29T14:01:04.058Z 2026-01-29T14:01:04.058Z
9268067 9268067 20260128082928_e9T0P US000E 2026-01-29T14:00:51.668Z 2026-01-29T14:00:51.668Z
9268016 9268016 20260128074519_ZoTkd US000E 2026-01-29T14:00:27.647Z 2026-01-29T14:00:27.647Z
9267779 9267779 20260127045559_WWzfs US000E 2026-01-28T14:23:16.642Z 2026-01-29T14:35:42.511Z
9267583 9267583 20260127032710_9qj5K US000E 2026-01-28T14:22:24.513Z 2026-01-29T14:35:19.718Z
9267480 9267480 20260127020201_Joh57 US000E 2026-01-28T14:21:54.979Z 2026-01-29T14:35:06.600Z
9264748 9264748 20260127130552_7ZFvY US000E 2026-01-28T14:07:28.533Z 2026-01-29T14:30:24.269Z
9264728 9264728 20260127130328_aEIW4 US000E 2026-01-28T14:07:23.150Z 2026-01-29T14:30:24.264Z
9264687 9264687 20260127125731_Y8Cyw US000E 2026-01-28T14:07:11.086Z 2026-01-29T14:30:24.255Z
9264670 9264670 20260127125347_MRwLE US000E 2026-01-28T14:07:06.779Z 2026-01-29T14:30:24.251Z
9264614 9264614 20260127125036_TaQp8 US000E 2026-01-28T14:06:54.538Z 2026-01-29T14:30:24.229Z
9264574 9264574 20260127124802_qrxec US000E 2026-01-28T14:06:43.757Z 2026-01-29T14:30:24.222Z
9264247 9264247 20260127114825_QfZkm US000E 2026-01-28T14:05:10.044Z 2026-01-29T14:30:20.568Z
9264073 9264073 20260127110944_u38Q2 US000E 2026-01-28T14:04:14.180Z 2026-01-29T14:30:20.040Z
9263941 9263941 20260127104523_Pr0WG US000E 2026-01-28T14:03:37.005Z 2026-01-29T14:30:19.973Z
9263831 9263831 20260127101938_S6Mtg US000E 2026-01-28T14:03:02.957Z 2026-01-29T14:30:18.959Z
9263429 9263429 20260127075344_ifGiB US000E 2026-01-28T14:00:30.679Z 2026-01-29T14:30:16.502Z
9263407 9263407 20260127073920_PuGXr US000E 2026-01-28T14:00:20.382Z 2026-01-29T14:30:16.488Z
9263140 9263140 20260126074025_Qqjdc US000E 2026-01-27T14:17:10.618Z 2026-01-29T14:39:18.795Z
9263118 9263118 20260126072724_V2alY US000E 2026-01-27T14:17:06.159Z 2026-01-29T14:39:17.538Z
9263094 9263094 20260126070809_V5sQh US000E 2026-01-27T14:16:57.542Z 2026-01-29T14:39:16.180Z
9263026 9263026 20260126062024_Ch7B3 US000E 2026-01-27T14:16:39.860Z 2026-01-29T14:39:10.251Z
9263007 9263007 20260126060754_KM42H US000E 2026-01-27T14:16:34.716Z 2026-01-29T14:39:08.961Z
9262930 9262930 20260126050045_M58ZG US000E 2026-01-27T14:16:10.480Z 2026-01-29T14:39:04.245Z
9262851 9262851 20260126034828_3M2dy US000E 2026-01-27T14:15:40.272Z 2026-01-29T14:38:52.542Z
9262829 9262829 20260126033628_E2akl US000E 2026-01-27T14:15:36.729Z 2026-01-29T14:38:51.346Z
9261732 9261732 20260126130215_XawZr US000E 2026-01-27T14:05:17.263Z 2026-01-29T14:32:53.787Z
9261651 9261651 20260126124046_con2L US000E 2026-01-27T14:04:51.816Z 2026-01-29T14:32:46.014Z
9261564 9261564 20260126121447_gQ5u5 US000E 2026-01-27T14:04:21.782Z 2026-01-29T14:32:40.106Z
9261552 9261552 20260126121406_J9QAK US000E 2026-01-27T14:04:19.637Z 2026-01-29T14:32:39.453Z
9261492 9261492 20260126115336_MGwjw US000E 2026-01-27T14:03:58.981Z 2026-01-29T14:32:31.543Z
9261482 9261482 20260126115109_GhCME US000E 2026-01-27T14:03:56.026Z 2026-01-29T14:32:27.715Z
9261476 9261476 20260126115053_y81tU US000E 2026-01-27T14:03:55.256Z 2026-01-29T14:32:27.464Z
9261387 9261387 20260126112117_4Yl7g US000E 2026-01-27T14:03:32.594Z 2026-01-29T14:32:15.454Z
9261354 9261354 20260126111056_v3Frk US000E 2026-01-27T14:03:17.343Z 2026-01-29T14:32:13.094Z
9261332 9261332 20260126111016_EdVnL US000E 2026-01-27T14:03:14.774Z 2026-01-29T14:32:12.490Z
9261226 9261226 20260126103425_BKYIK US000E 2026-01-27T14:02:41.488Z 2026-01-29T14:32:05.765Z
9261173 9261173 20260126101326_rVxc2 US000E 2026-01-27T14:02:21.473Z 2026-01-29T14:32:01.276Z
9261116 9261116 20260126095512_QEM8V US000E 2026-01-27T14:02:00.396Z 2026-01-29T14:31:57.495Z
9261014 9261014 20260126092151_qErEp US000E 2026-01-27T14:01:23.529Z 2026-01-29T14:31:23.205Z
9260946 9260946 20260126085717_jw2Z5 US000E 2026-01-27T14:01:03.485Z 2026-01-29T14:31:15.352Z
9260942 9260942 20260126085308_QL41s US000E 2026-01-27T14:01:02.372Z 2026-01-29T14:31:15.091Z
9260857 9260857 20260126081501_K9OMI US000E 2026-01-27T14:00:30.560Z 2026-01-29T14:31:00.014Z
9260836 9260836 20260126080739_voaXN US000E 2026-01-27T14:00:25.572Z 2026-01-29T14:30:44.970Z
9260788 9260788 20260126074918_rtZhl US000E 2026-01-27T14:00:09.775Z 2026-01-29T14:30:30.642Z
9252961 9252961 20260123083908_wuCGc US000E 2026-01-24T14:18:00.445Z 2026-01-29T14:53:44.783Z
9252946 9252946 20260123083359_9RojQ US000E 2026-01-24T14:17:58.128Z 2026-01-29T14:53:43.745Z
9252907 9252907 20260123074748_3hge1 US000E 2026-01-24T14:17:42.065Z 2026-01-29T14:53:41.523Z
9252652 9252652 20260123045926_pn8Yn US000E 2026-01-24T14:16:33.307Z 2026-01-29T14:53:13.505Z
9252647 9252647 20260123045817_49C9q US000E 2026-01-24T14:16:32.865Z 2026-01-29T14:53:13.360Z
9252512 9252512 20260123034429_yQE86 US000E 2026-01-24T14:15:55.417Z 2026-01-29T14:53:05.099Z
9252272 9252272 20260123020119_mky1Q US000E 2026-01-24T14:14:53.824Z 2026-01-29T14:52:43.112Z
9249834 9249834 20260122091714_VSfx7 US000E 2026-01-23T14:16:20.857Z 2026-01-29T14:59:00.323Z
9249771 9249771 20260122083610_f8rz6 US000E 2026-01-23T14:16:13.006Z 2026-01-29T14:58:54.678Z
9249752 9249752 20260122082257_04NPD US000E 2026-01-23T14:16:09.931Z 2026-01-29T14:58:53.344Z
9249750 9249750 20260122082242_mvz5I US000E 2026-01-23T14:16:08.901Z 2026-01-29T14:58:53.198Z
9249198 9249198 20260122040607_defWn US000E 2026-01-23T14:14:50.123Z 2026-01-29T14:58:16.533Z
9249143 9249143 20260122034706_iA9BK US000E 2026-01-23T14:14:39.920Z 2026-01-29T14:58:14.279Z
9244624 9244624 20260121092042_hLFfe US000E 2026-01-22T14:26:13.564Z 2026-01-29T15:06:28.072Z
9244600 9244600 20260121091356_EjoO1 US000E 2026-01-22T14:26:05.415Z 2026-01-29T15:06:27.178Z
9244535 9244535 20260121085911_xYtRF US000E 2026-01-22T14:25:57.823Z 2026-01-29T15:06:24.809Z
9244522 9244522 20260121085503_fY3pH US000E 2026-01-22T14:25:55.259Z 2026-01-29T15:06:24.195Z
9244508 9244508 20260121084700_sSHat US000E 2026-01-22T14:25:52.766Z 2026-01-29T15:06:23.331Z
9244449 9244449 20260121083203_6w6eZ US000E 2026-01-22T14:25:34.130Z 2026-01-29T15:06:09.873Z
9244364 9244364 20260121080421_hRKmn US000E 2026-01-22T14:25:16.696Z 2026-01-29T15:06:03.476Z
9244216 9244216 20260121064825_RFFvn US000E 2026-01-22T14:24:37.603Z 2026-01-29T15:05:56.126Z
9243954 9243954 20260121054240_CONae US000E 2026-01-22T14:23:39.078Z 2026-01-29T15:05:36.289Z
9243832 9243832 20260121052432_sAnxj US000E 2026-01-22T14:23:19.622Z 2026-01-29T15:05:29.361Z
9243488 9243488 20260121043909_3bR2r US000E 2026-01-22T14:22:04.074Z 2026-01-29T15:05:06.120Z
9243479 9243479 20260121043755_Fqjna US000E 2026-01-22T14:22:03.456Z 2026-01-29T15:05:05.712Z
9243253 9243253 20260121040533_V2w3T US000E 2026-01-22T14:21:07.757Z 2026-01-29T15:04:52.638Z
9242404 9242404 20260121014547_L8rzr US000E 2026-01-22T14:17:37.598Z 2026-01-29T15:03:57.085Z
9239904 9239904 20260121130502_VZ1Zk US000E 2026-01-22T14:03:42.950Z 2026-01-29T14:55:01.047Z
9239884 9239884 20260121130154_xAjZV US000E 2026-01-22T14:03:37.696Z 2026-01-29T14:55:00.298Z
9239870 9239870 20260121125559_Ke3I7 US000E 2026-01-22T14:03:33.880Z 2026-01-29T14:54:51.328Z
9239838 9239838 20260121124520_M9Fqw US000E 2026-01-22T14:03:27.239Z 2026-01-29T14:54:47.398Z
9239822 9239822 20260121123927_zzQXd US000E 2026-01-22T14:03:25.257Z 2026-01-29T14:54:43.991Z
9239816 9239816 20260121123754_SiQT8 US000E 2026-01-22T14:03:24.662Z 2026-01-29T14:54:43.882Z
9239739 9239739 20260121120330_oPogJ US000E 2026-01-22T14:02:57.465Z 2026-01-29T14:54:38.498Z
9239691 9239691 20260121114614_WhakH US000E 2026-01-22T14:02:36.399Z 2026-01-29T14:54:35.636Z
9239687 9239687 20260121114353_fDD4o US000E 2026-01-22T14:02:35.720Z 2026-01-29T14:54:35.496Z
9239606 9239606 20260121112019_jj2sK US000E 2026-01-22T14:02:10.158Z 2026-01-29T14:54:31.835Z

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