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 = "BE000C" 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
9611441 9611441 20260405020211_rwpgH BE000C 2026-04-06T12:14:36.130Z 2026-04-06T12:16:14.800Z
9611273 9611273 20260405010905_CrTp9 BE000C 2026-04-06T12:13:48.716Z 2026-04-06T12:16:14.767Z
9611244 9611244 20260405005906_DHWmO BE000C 2026-04-06T12:13:37.718Z 2026-04-06T12:16:14.761Z
9610819 9610819 20260404220902_xSs4p BE000C 2026-04-06T12:11:30.031Z 2026-04-06T12:16:14.668Z
9610731 9610731 20260404212548_NRgHM BE000C 2026-04-06T12:10:59.858Z 2026-04-06T12:16:14.647Z
9610677 9610677 20260404211120_okYae BE000C 2026-04-06T12:10:41.060Z 2026-04-06T12:16:14.633Z
9609208 9609208 20260405035832_ji2qv BE000C 2026-04-06T12:00:42.880Z 2026-04-06T12:00:42.880Z
9609107 9609107 20260405033550_sH36i BE000C 2026-04-06T12:00:17.919Z 2026-04-06T12:00:17.919Z
9606835 9606835 20260402220352_W6YHW BE000C 2026-04-04T12:11:53.172Z 2026-04-06T12:23:47.697Z
9606828 9606828 20260402220209_N0Bdk BE000C 2026-04-04T12:11:52.209Z 2026-04-06T12:23:47.416Z
9606804 9606804 20260402213042_TS3Jz BE000C 2026-04-04T12:11:47.016Z 2026-04-06T12:23:45.894Z
9606791 9606791 20260402211629_gqC33 BE000C 2026-04-04T12:11:43.237Z 2026-04-06T12:23:44.483Z
9604889 9604889 20260402013832_dQNtg BE000C 2026-04-03T12:12:03.161Z 2026-04-06T12:26:29.819Z
9604851 9604851 20260402012022_Uy527 BE000C 2026-04-03T12:11:54.842Z 2026-04-06T12:26:27.531Z
9604845 9604845 20260402011729_Fl7t2 BE000C 2026-04-03T12:11:53.624Z 2026-04-06T12:26:27.154Z
9604775 9604775 20260402003336_F20pd BE000C 2026-04-03T12:11:30.939Z 2026-04-06T12:26:18.480Z
9604729 9604729 20260402000855_qBVj2 BE000C 2026-04-03T12:11:21.958Z 2026-04-06T12:26:14.276Z
9604671 9604671 20260401232507_TjB3L BE000C 2026-04-03T12:11:05.707Z 2026-04-06T12:26:10.629Z
9604668 9604668 20260401232215_eFRDM BE000C 2026-04-03T12:11:05.173Z 2026-04-06T12:26:10.428Z
9604593 9604593 20260401214918_S6SSQ BE000C 2026-04-03T12:10:48.085Z 2026-04-06T12:26:05.539Z
9604564 9604564 20260401210512_ijVOF BE000C 2026-04-03T12:10:28.699Z 2026-04-06T12:26:02.137Z
9602764 9602764 20260402030707_pE5QQ BE000C 2026-04-03T12:00:30.810Z 2026-04-06T12:21:08.969Z
9602715 9602715 20260402024522_rAvtc BE000C 2026-04-03T12:00:19.688Z 2026-04-06T12:21:05.296Z
9602679 9602679 20260402023219_vXtPB BE000C 2026-04-03T12:00:11.456Z 2026-04-06T12:21:01.496Z
9588363 9588363 20260326221036_rBjV0 BE000C 2026-03-28T12:10:56.897Z 2026-04-04T12:42:01.264Z
9588274 9588274 20260326203051_oRjjx BE000C 2026-03-28T12:10:44.864Z 2026-04-04T12:41:53.873Z
9585505 9585505 20260327012301_7HGIR BE000C 2026-03-28T12:00:31.643Z 2026-04-05T12:32:24.370Z
9581852 9581852 20260326040233_f3Xch BE000C 2026-03-27T12:03:57.304Z 2026-04-04T12:39:22.513Z
9580061 9580061 20260324235838_Aap1i BE000C 2026-03-26T12:15:01.218Z 2026-04-02T12:37:40.626Z
9579961 9579961 20260324233629_6qgmK BE000C 2026-03-26T12:14:46.027Z 2026-04-02T12:37:36.575Z
9579793 9579793 20260324225627_n8fHn BE000C 2026-03-26T12:14:25.104Z 2026-04-02T12:37:30.437Z
9579680 9579680 20260324221216_Tx02G BE000C 2026-03-26T12:14:11.924Z 2026-04-02T12:37:25.783Z
9579636 9579636 20260324220156_APKlA BE000C 2026-03-26T12:14:06.582Z 2026-04-02T12:37:18.574Z
9579519 9579519 20260324211203_Uio9d BE000C 2026-03-26T12:13:52.388Z 2026-04-02T12:37:13.494Z
9575953 9575953 20260325005032_BQ0x8 BE000C 2026-03-26T12:00:49.130Z 2026-04-03T12:35:30.948Z
9575950 9575950 20260325004927_d31X8 BE000C 2026-03-26T12:00:48.151Z 2026-04-03T12:35:30.847Z
9575848 9575848 20260325002817_cEX7j BE000C 2026-03-26T12:00:25.126Z 2026-04-03T12:35:26.486Z
9575750 9575750 20260321215314_5xbfo BE000C 2026-03-25T12:31:43.931Z 2026-03-29T12:21:01.865Z
9575702 9575702 20260321022746_hDyHs BE000C 2026-03-25T12:27:54.923Z 2026-03-29T12:19:02.337Z
9575684 9575684 20260322214059_np1eK BE000C 2026-03-25T12:26:58.869Z 2026-03-30T12:30:44.302Z
9575674 9575674 20260322202133_giHlf BE000C 2026-03-25T12:26:49.285Z 2026-03-30T12:30:38.893Z
9575666 9575666 20260322033310_XBNv3 BE000C 2026-03-25T12:23:14.397Z 2026-03-30T12:28:08.300Z
9575660 9575660 20260322022710_t1YhO BE000C 2026-03-25T12:22:47.675Z 2026-03-30T12:27:55.814Z
9575645 9575645 20260322010454_fYFoN BE000C 2026-03-25T12:22:08.839Z 2026-03-30T12:27:33.936Z
9575626 9575626 20260323235821_b2bTG BE000C 2026-03-25T12:21:32.604Z 2026-03-31T12:29:03.529Z
9575611 9575611 20260323234154_K3LtU BE000C 2026-03-25T12:21:30.745Z 2026-03-31T12:29:03.024Z
9575431 9575431 20260323220541_8Ha37 BE000C 2026-03-25T12:21:04.566Z 2026-03-31T12:28:57.328Z
9571628 9571628 20260324031750_t8bK1 BE000C 2026-03-25T12:02:09.359Z 2026-04-02T12:34:35.373Z
9571549 9571549 20260324025205_B93Vo BE000C 2026-03-25T12:01:53.452Z 2026-04-02T12:34:31.627Z
9571124 9571124 20260322234913_sH5ad BE000C 2026-03-24T12:24:21.932Z 2026-03-30T12:30:55.520Z
9571095 9571095 20260322234503_KNmgJ BE000C 2026-03-24T12:24:20.262Z 2026-03-30T12:30:55.149Z
9571075 9571075 20260322234333_lhLiY BE000C 2026-03-24T12:24:19.052Z 2026-03-30T12:30:54.848Z
9571062 9571062 20260322234215_1C6OQ BE000C 2026-03-24T12:24:17.866Z 2026-03-30T12:30:54.604Z
9570842 9570842 20260322225806_mCuEA BE000C 2026-03-24T12:23:54.488Z 2026-03-30T12:30:50.319Z
9570829 9570829 20260322225746_oM2f7 BE000C 2026-03-24T12:23:52.645Z 2026-03-30T12:30:50.026Z
9570752 9570752 20260322224005_SH1IN BE000C 2026-03-24T12:23:46.479Z 2026-03-30T12:30:48.739Z
9570538 9570538 20260322215655_HyM72 BE000C 2026-03-24T12:23:25.890Z 2026-03-30T12:30:45.044Z
9570516 9570516 20260322214503_uytRE BE000C 2026-03-24T12:23:23.367Z 2026-03-30T12:30:44.579Z
9570498 9570498 20260322214059_BhieV BE000C 2026-03-24T12:23:22.138Z 2026-03-30T12:30:44.339Z
9570477 9570477 20260322213758_rqpN2 BE000C 2026-03-24T12:23:20.783Z 2026-03-30T12:30:43.937Z
9570300 9570300 20260322202537_HOQux BE000C 2026-03-24T12:22:57.643Z 2026-03-30T12:30:39.235Z
9570172 9570172 20260322193612_XInEJ BE000C 2026-03-24T12:22:44.980Z 2026-03-30T12:30:29.024Z
9570135 9570135 20260322192632_sO8Cu BE000C 2026-03-24T12:22:38.268Z 2026-03-30T12:30:28.312Z
9562986 9562986 20260323042217_p4GV4 BE000C 2026-03-24T12:04:39.450Z 2026-03-31T12:26:31.619Z
9562954 9562954 20260323040702_Qd8Ls BE000C 2026-03-24T12:04:34.193Z 2026-03-31T12:26:30.765Z
9562925 9562925 20260323035034_tApwR BE000C 2026-03-24T12:04:28.907Z 2026-03-31T12:26:29.558Z
9562803 9562803 20260323031643_8ND4G BE000C 2026-03-24T12:04:07.028Z 2026-03-31T12:26:26.386Z
9562774 9562774 20260323031314_Hm4W7 BE000C 2026-03-24T12:04:01.059Z 2026-03-31T12:26:25.702Z
9562606 9562606 20260323024617_i93BF BE000C 2026-03-24T12:03:32.867Z 2026-03-31T12:26:15.499Z
9562565 9562565 20260323023440_Yhs2M BE000C 2026-03-24T12:03:26.945Z 2026-03-31T12:26:14.488Z
9562545 9562545 20260323023200_xS1Uy BE000C 2026-03-24T12:03:23.405Z 2026-03-31T12:26:13.885Z
9562541 9562541 20260323023120_3xYL4 BE000C 2026-03-24T12:03:21.766Z 2026-03-31T12:26:13.661Z
9562448 9562448 20260323022147_Jo39u BE000C 2026-03-24T12:03:08.765Z 2026-03-31T12:26:10.556Z
9562427 9562427 20260323022035_BWYOO BE000C 2026-03-24T12:03:05.959Z 2026-03-31T12:26:10.183Z
9562397 9562397 20260323021646_fOCzZ BE000C 2026-03-24T12:02:59.096Z 2026-03-31T12:26:09.292Z
9562007 9562007 20260323011416_4nNEV BE000C 2026-03-24T12:01:52.576Z 2026-03-31T12:25:59.183Z
9561838 9561838 20260323004928_eIDRF BE000C 2026-03-24T12:01:26.735Z 2026-03-31T12:25:54.831Z
9561719 9561719 20260323003316_Oezoo BE000C 2026-03-24T12:01:03.943Z 2026-03-31T12:25:51.819Z
9561498 9561498 20260322235322_dgOaj BE000C 2026-03-24T12:00:11.357Z 2026-03-31T12:25:45.384Z
9561424 9561424 20260321233147_yNAPw BE000C 2026-03-23T12:12:18.790Z 2026-03-29T12:21:07.141Z
9561398 9561398 20260321232925_9dULx BE000C 2026-03-23T12:12:18.187Z 2026-03-29T12:21:06.969Z
9561383 9561383 20260321232801_xqBSm BE000C 2026-03-23T12:12:17.920Z 2026-03-29T12:21:06.877Z
9561380 9561380 20260321232642_AdKWR BE000C 2026-03-23T12:12:17.867Z 2026-03-29T12:21:06.848Z
9561218 9561218 20260321230908_SX1PK BE000C 2026-03-23T12:12:14.070Z 2026-03-29T12:21:05.763Z
9561213 9561213 20260321230906_ybUYw BE000C 2026-03-23T12:12:13.918Z 2026-03-29T12:21:05.724Z
9561106 9561106 20260321230118_YmuKo BE000C 2026-03-23T12:12:11.765Z 2026-03-29T12:21:05.202Z
9560989 9560989 20260321224257_liCI6 BE000C 2026-03-23T12:12:08.978Z 2026-03-29T12:21:04.459Z
9560981 9560981 20260321224232_zIjez BE000C 2026-03-23T12:12:08.770Z 2026-03-29T12:21:04.389Z
9560948 9560948 20260321223916_oekKm BE000C 2026-03-23T12:12:08.425Z 2026-03-29T12:21:04.174Z
9560933 9560933 20260321223657_3kInR BE000C 2026-03-23T12:12:07.937Z 2026-03-29T12:21:04.048Z
9560904 9560904 20260321223402_3m9HC BE000C 2026-03-23T12:12:06.900Z 2026-03-29T12:21:03.834Z
9560541 9560541 20260321213751_X9vQp BE000C 2026-03-23T12:11:51.258Z 2026-03-29T12:21:01.221Z
9560504 9560504 20260321213404_3liJs BE000C 2026-03-23T12:11:49.500Z 2026-03-29T12:21:00.847Z
9560313 9560313 20260321210136_E7Vk2 BE000C 2026-03-23T12:11:42.505Z 2026-03-29T12:20:59.230Z
9560272 9560272 20260321205521_vAIvy BE000C 2026-03-23T12:11:40.962Z 2026-03-29T12:20:58.859Z
9560196 9560196 20260321204652_YRSEA BE000C 2026-03-23T12:11:40.181Z 2026-03-29T12:20:58.556Z
9560184 9560184 20260321204341_eeWYJ BE000C 2026-03-23T12:11:39.798Z 2026-03-24T12:28:51.257Z
9560063 9560063 20260321202919_hc20P BE000C 2026-03-23T12:11:37.160Z 2026-03-29T12:20:57.713Z
9559928 9559928 20260321201124_ltnjI BE000C 2026-03-23T12:11:34.033Z 2026-03-29T12:20:56.674Z
9554869 9554869 20260322033957_UjP5j BE000C 2026-03-23T12:02:53.942Z 2026-03-30T12:28:10.652Z

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