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

2,881 rows where station_code = "DE000J" 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
9259675 9259675 20260124230719_TU7zf DE000J 2026-01-26T14:18:04.334Z 2026-01-29T14:43:12.666Z
9259668 9259668 20260124230301_YFVMw DE000J 2026-01-26T14:18:02.211Z 2026-01-29T14:43:12.198Z
9251709 9251709 20260122221045_Q1xCM DE000J 2026-01-24T14:12:59.290Z 2026-01-29T14:52:02.998Z
9251690 9251690 20260122220528_aROtO DE000J 2026-01-24T14:12:56.429Z 2026-01-29T14:51:59.286Z
9251688 9251688 20260122220528_Dm7mX DE000J 2026-01-24T14:12:55.540Z 2026-01-29T14:51:59.114Z
9251015 9251015 20260122174937_mqctT DE000J 2026-01-24T14:09:29.053Z 2026-01-29T14:50:55.334Z
9249663 9249663 20260122061529_LOu0I DE000J 2026-01-23T14:15:51.995Z 2026-01-29T14:58:48.550Z
9249466 9249466 20260122052653_vgaDn DE000J 2026-01-23T14:15:28.211Z 2026-01-29T14:58:40.882Z
9249457 9249457 20260122052642_Ua8l0 DE000J 2026-01-23T14:15:27.752Z 2026-01-29T14:58:40.657Z
9249446 9249446 20260122052324_Ue3Ne DE000J 2026-01-23T14:15:26.963Z 2026-01-29T14:58:40.019Z
9249434 9249434 20260122051847_tUAPn DE000J 2026-01-23T14:15:25.892Z 2026-01-29T14:58:37.113Z
9249413 9249413 20260122051139_7Dauy DE000J 2026-01-23T14:15:19.701Z 2026-01-29T14:58:29.462Z
9249383 9249383 20260122050545_58si0 DE000J 2026-01-23T14:15:16.309Z 2026-01-29T14:58:28.267Z
9249343 9249343 20260122050221_2uYtC DE000J 2026-01-23T14:15:12.807Z 2026-01-29T14:58:26.930Z
9249015 9249015 20260122030828_Ph4NP DE000J 2026-01-23T14:14:25.776Z 2026-01-29T14:58:09.064Z
9248947 9248947 20260122025335_RdoGu DE000J 2026-01-23T14:14:09.403Z 2026-01-29T14:57:55.928Z
9248505 9248505 20260122002339_jhiHX DE000J 2026-01-23T14:12:57.094Z 2026-01-29T14:57:24.275Z
9248495 9248495 20260122001525_DR2kK DE000J 2026-01-23T14:12:56.262Z 2026-01-29T14:57:23.813Z
9248394 9248394 20260121233155_uXVGR DE000J 2026-01-23T14:12:42.702Z 2026-01-29T14:57:16.962Z
9248267 9248267 20260121224322_mSktm DE000J 2026-01-23T14:12:22.785Z 2026-01-29T14:57:11.136Z
9248227 9248227 20260121222452_4qTRz DE000J 2026-01-23T14:12:16.382Z 2026-01-29T14:57:09.223Z
9248117 9248117 20260121213828_Pi732 DE000J 2026-01-23T14:11:59.085Z 2026-01-29T14:56:55.640Z
9247659 9247659 20260121192439_YaF89 DE000J 2026-01-23T14:10:41.941Z 2026-01-29T14:56:22.104Z
9241768 9241768 20260120221820_c9szX DE000J 2026-01-22T14:14:26.771Z 2026-01-29T15:03:01.495Z
9241719 9241719 20260120214612_Fxtu3 DE000J 2026-01-22T14:14:16.299Z 2026-01-29T15:02:58.692Z
9241705 9241705 20260120214125_dme2A DE000J 2026-01-22T14:14:12.886Z 2026-01-29T15:02:57.979Z
9241595 9241595 20260120211504_kwKx9 DE000J 2026-01-22T14:13:50.335Z 2026-01-29T15:02:54.437Z
9240692 9240692 20260120172532_Jpwsa DE000J 2026-01-22T14:09:36.935Z 2026-01-29T15:01:45.924Z
9237731 9237731 20260120055710_aHRjV DE000J 2026-01-21T14:27:31.264Z 2026-01-28T15:01:38.282Z
9237697 9237697 20260120055126_ZpJ7O DE000J 2026-01-21T14:27:26.314Z 2026-01-28T15:01:36.798Z
9237669 9237669 20260120054913_g6cn2 DE000J 2026-01-21T14:27:16.331Z 2026-01-28T15:01:35.511Z
9237349 9237349 20260120050607_u4WOq DE000J 2026-01-21T14:26:04.295Z 2026-01-28T15:01:21.081Z
9236616 9236616 20260120034023_K61YA DE000J 2026-01-21T14:23:32.264Z 2026-01-28T15:00:25.034Z
9236423 9236423 20260120031502_TI7g1 DE000J 2026-01-21T14:22:47.419Z 2026-01-28T14:59:59.590Z
9235957 9235957 20260120022053_ig15o DE000J 2026-01-21T14:20:53.107Z 2026-01-28T14:59:30.448Z
9235840 9235840 20260120020713_TQDyT DE000J 2026-01-21T14:20:32.588Z 2026-01-28T14:59:23.739Z
9235708 9235708 20260120015059_F2ECn DE000J 2026-01-21T14:20:01.867Z 2026-01-28T14:59:16.788Z
9235595 9235595 20260120013748_lohp3 DE000J 2026-01-21T14:19:33.376Z 2026-01-28T14:59:11.544Z
9235438 9235438 20260120011405_v8P4l DE000J 2026-01-21T14:18:54.241Z 2026-01-28T14:58:55.309Z
9235200 9235200 20260120004313_rasDc DE000J 2026-01-21T14:17:53.636Z 2026-01-28T14:58:43.211Z
9235092 9235092 20260120002904_LAymY DE000J 2026-01-21T14:17:29.313Z 2026-01-28T14:58:30.501Z
9234748 9234748 20260119231456_dQijU DE000J 2026-01-21T14:15:58.809Z 2026-01-28T14:58:04.354Z
9230780 9230780 20260119050819_QVfeM DE000J 2026-01-20T14:29:44.178Z 2026-01-27T15:05:26.260Z
9230631 9230631 20260119044221_3r82M DE000J 2026-01-20T14:28:59.748Z 2026-01-27T15:05:17.661Z
9230279 9230279 20260119035106_TxQev DE000J 2026-01-20T14:26:58.256Z 2026-01-27T15:04:45.852Z
9230037 9230037 20260119031453_RI6BP DE000J 2026-01-20T14:25:34.538Z 2026-01-27T15:04:21.700Z
9229924 9229924 20260119025624_n2azM DE000J 2026-01-20T14:25:00.898Z 2026-01-27T15:04:15.052Z
9229439 9229439 20260119014644_Nq3ji DE000J 2026-01-20T14:22:37.059Z 2026-01-27T15:03:26.217Z
9223309 9223309 20260118001046_Io4aE DE000J 2026-01-19T14:18:38.691Z 2026-01-26T15:02:01.857Z
9182659 9182659 20260111060110_fVIBO DE000J 2026-01-12T14:15:20.211Z 2026-01-19T15:18:53.995Z
9181474 9181474 20260111015543_hXrfg DE000J 2026-01-12T14:10:54.974Z 2026-01-19T15:17:20.924Z
9181465 9181465 20260111015349_F9JXo DE000J 2026-01-12T14:10:53.174Z 2026-01-19T15:17:20.586Z
9181437 9181437 20260111014436_5xcN4 DE000J 2026-01-12T14:10:48.717Z 2026-01-19T15:17:17.909Z
9181395 9181395 20260111013757_pTT3s DE000J 2026-01-12T14:10:39.590Z 2026-01-19T15:17:16.332Z
9181274 9181274 20260111011231_PrivI DE000J 2026-01-12T14:10:12.983Z 2026-01-19T15:17:10.686Z
9181167 9181167 20260111004050_cf2w7 DE000J 2026-01-12T14:09:49.379Z 2026-01-19T15:17:06.265Z
9181137 9181137 20260111003250_DtTSO DE000J 2026-01-12T14:09:41.923Z 2026-01-19T15:17:05.063Z
9180967 9180967 20260110233758_FEIBL DE000J 2026-01-12T14:09:06.575Z 2026-01-19T15:16:42.512Z
9180880 9180880 20260110230846_mOoQV DE000J 2026-01-12T14:08:44.096Z 2026-01-19T15:16:37.021Z
9162370 9162370 20260107023405_McUu2 DE000J 2026-01-08T14:04:52.255Z 2026-01-13T15:02:05.139Z
9162085 9162085 20260106204214_adbbx DE000J 2026-01-08T14:02:42.793Z 2026-01-13T15:01:34.354Z
9119417 9119417 20251230175220_mor22 DE000J 2026-01-01T14:56:06.355Z 2026-01-07T15:12:42.948Z
9104391 9104391 20251230055008_7L5HF DE000J 2025-12-31T14:21:05.889Z 2026-01-07T15:09:41.207Z
9103553 9103553 20251230043904_Y6JHr DE000J 2025-12-31T14:18:13.457Z 2026-01-07T15:08:49.593Z
9103196 9103196 20251230040620_yas1A DE000J 2025-12-31T14:16:52.417Z 2026-01-07T15:08:31.579Z
9103095 9103095 20251230035650_ufK3K DE000J 2025-12-31T14:16:26.835Z 2026-01-07T15:08:18.866Z
9103073 9103073 20251230035420_YrG9t DE000J 2025-12-31T14:16:22.194Z 2026-01-07T15:08:17.969Z
9102776 9102776 20251230033341_YLpZx DE000J 2025-12-31T14:15:19.942Z 2026-01-07T15:08:05.690Z
9084402 9084402 20251228013906_dhXB6 DE000J 2025-12-30T14:35:36.833Z 2026-01-05T15:08:41.452Z
9074455 9074455 20251225200328_DNtgP DE000J 2025-12-29T15:00:55.980Z 2026-01-02T15:48:31.827Z
9074326 9074326 20251225194110_1LIWQ DE000J 2025-12-29T15:00:46.771Z 2026-01-02T15:48:29.169Z
9074305 9074305 20251225193928_gHA7P DE000J 2025-12-29T15:00:41.087Z 2026-01-02T15:48:28.877Z
9074058 9074058 20251225190602_hjmUg DE000J 2025-12-29T15:00:03.847Z 2026-01-02T15:48:06.453Z
9074048 9074048 20251225190602_Kz2zg DE000J 2025-12-29T15:00:03.744Z 2026-01-02T15:48:06.411Z
9073712 9073712 20251225182104_ny3Mk DE000J 2025-12-29T14:59:51.390Z 2026-01-02T15:47:57.041Z
9073361 9073361 20251225173413_7kksa DE000J 2025-12-29T14:59:14.286Z 2026-01-02T15:47:49.967Z
9072089 9072089 20251226201901_UGCt6 DE000J 2025-12-29T14:50:22.415Z 2026-01-03T15:43:41.231Z
9071971 9071971 20251226200210_nsEWw DE000J 2025-12-29T14:50:17.652Z 2026-01-03T15:43:35.928Z
9071720 9071720 20251226191940_kN3JN DE000J 2025-12-29T14:49:45.518Z 2026-01-03T15:43:20.706Z
9070978 9070978 20251226173805_kkSYI DE000J 2025-12-29T14:48:46.814Z 2026-01-03T15:42:22.432Z
9066302 9066302 20251226060517_juISA DE000J 2025-12-29T14:39:50.650Z 2026-01-03T15:37:39.173Z
9066155 9066155 20251226055507_mjgzG DE000J 2025-12-29T14:39:41.205Z 2026-01-03T15:37:33.398Z
9065728 9065728 20251226052649_efJi6 DE000J 2025-12-29T14:39:00.697Z 2026-01-03T15:37:16.845Z
9065702 9065702 20251226052617_VGsaC DE000J 2025-12-29T14:38:59.794Z 2026-01-03T15:37:15.633Z
9065587 9065587 20251226051937_1AEcV DE000J 2025-12-29T14:38:42.974Z 2026-01-03T15:37:01.448Z
9065535 9065535 20251226051715_834nb DE000J 2025-12-29T14:38:39.769Z 2026-01-03T15:37:00.119Z
9064998 9064998 20251226044719_m8qzb DE000J 2025-12-29T14:37:53.506Z 2026-01-03T15:36:34.101Z
9064251 9064251 20251226040028_Mjg8r DE000J 2025-12-29T14:36:40.768Z 2026-01-03T15:35:55.806Z
9064195 9064195 20251226035402_dF9bJ DE000J 2025-12-29T14:36:33.950Z 2026-01-03T15:35:52.582Z
9064140 9064140 20251226035202_5XKis DE000J 2025-12-29T14:36:30.088Z 2026-01-03T15:35:51.167Z
9063760 9063760 20251226033111_qp3GM DE000J 2025-12-29T14:35:52.721Z 2026-01-03T15:35:38.733Z
9062444 9062444 20251226021539_Vjov2 DE000J 2025-12-29T14:33:26.641Z 2025-12-29T14:51:13.986Z
9061657 9061657 20251226011748_UTYtV DE000J 2025-12-29T14:31:44.863Z 2026-01-03T15:33:55.934Z
9061626 9061626 20251226011427_QKD7c DE000J 2025-12-29T14:31:40.974Z 2026-01-03T15:33:44.492Z
9061459 9061459 20251226010229_63EuF DE000J 2025-12-29T14:31:27.507Z 2026-01-03T15:33:37.864Z
9060816 9060816 20251226001405_jbYhX DE000J 2025-12-29T14:30:10.677Z 2026-01-03T15:33:09.302Z
9060788 9060788 20251226001141_fkOFB DE000J 2025-12-29T14:30:08.711Z 2026-01-03T15:33:08.687Z
9060614 9060614 20251226000237_dL33z DE000J 2025-12-29T14:29:45.331Z 2026-01-03T15:33:01.384Z
9060059 9060059 20251225232436_mLGNL DE000J 2025-12-29T14:28:43.542Z 2026-01-03T15:32:32.423Z
9060011 9060011 20251225232005_254x4 DE000J 2025-12-29T14:28:37.965Z 2026-01-03T15:32:30.847Z

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