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

5,542 rows where station_code = "DE000X" 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
9252322 9252322 20260123021404_OSaFl DE000X 2026-01-24T14:15:07.198Z 2026-01-29T14:52:45.239Z
9252237 9252237 20260123015331_C4KIE DE000X 2026-01-24T14:14:49.765Z 2026-01-29T14:52:41.307Z
9251995 9251995 20260123002457_2vWOy DE000X 2026-01-24T14:13:55.357Z 2026-01-29T14:52:21.055Z
9251947 9251947 20260123000620_Nv0Gr DE000X 2026-01-24T14:13:47.916Z 2026-01-29T14:52:18.447Z
9251910 9251910 20260122235425_XToba DE000X 2026-01-24T14:13:38.683Z 2026-01-29T14:52:16.782Z
9251897 9251897 20260122234745_hC1nf DE000X 2026-01-24T14:13:34.793Z 2026-01-29T14:52:15.908Z
9251835 9251835 20260122232009_wtwR3 DE000X 2026-01-24T14:13:21.119Z 2026-01-29T14:52:12.382Z
9251671 9251671 20260122214953_uAJfX DE000X 2026-01-24T14:12:44.905Z 2026-01-29T14:51:57.968Z
9251623 9251623 20260122212943_2ZaWo DE000X 2026-01-24T14:12:37.592Z 2026-01-29T14:51:55.384Z
9251564 9251564 20260122210113_wC2mx DE000X 2026-01-24T14:12:16.411Z 2026-01-29T14:51:49.152Z
9251517 9251517 20260122204128_3LUT2 DE000X 2026-01-24T14:12:07.641Z 2026-01-29T14:51:46.647Z
9250924 9250924 20260122171317_IQLGB DE000X 2026-01-24T14:08:47.466Z 2026-01-29T14:50:46.421Z
9249554 9249554 20260122054827_fO1dl DE000X 2026-01-23T14:15:42.078Z 2026-01-29T14:58:44.485Z
9249371 9249371 20260122050415_sj9zd DE000X 2026-01-23T14:15:14.399Z 2026-01-29T14:58:27.631Z
9249240 9249240 20260122042140_oJZQs DE000X 2026-01-23T14:15:02.495Z 2026-01-29T14:58:19.346Z
9249202 9249202 20260122040657_QfHCe DE000X 2026-01-23T14:14:50.979Z 2026-01-29T14:58:16.669Z
9249192 9249192 20260122040212_uV122 DE000X 2026-01-23T14:14:48.871Z 2026-01-29T14:58:16.087Z
9249036 9249036 20260122031616_fk1CM DE000X 2026-01-23T14:14:28.358Z 2026-01-29T14:58:10.168Z
9248857 9248857 20260122023001_iOca3 DE000X 2026-01-23T14:13:59.793Z 2026-01-29T14:57:49.904Z
9248792 9248792 20260122021053_BY27r DE000X 2026-01-23T14:13:52.005Z 2026-01-29T14:57:46.825Z
9248568 9248568 20260122004340_VkqqI DE000X 2026-01-23T14:13:05.495Z 2026-01-29T14:57:27.885Z
9248506 9248506 20260122002339_jhiHX DE000X 2026-01-23T14:12:57.094Z 2026-01-29T14:57:24.275Z
9248370 9248370 20260121231312_6KbsX DE000X 2026-01-23T14:12:39.431Z 2026-01-29T14:57:15.895Z
9248342 9248342 20260121230238_lnPL2 DE000X 2026-01-23T14:12:32.978Z 2026-01-29T14:57:14.567Z
9248320 9248320 20260121225416_IxDH2 DE000X 2026-01-23T14:12:30.315Z 2026-01-29T14:57:13.772Z
9248308 9248308 20260121225138_bQFPN DE000X 2026-01-23T14:12:29.007Z 2026-01-29T14:57:13.252Z
9248301 9248301 20260121225007_Nq2Xg DE000X 2026-01-23T14:12:26.488Z 2026-01-29T14:57:12.966Z
9248268 9248268 20260121224322_mSktm DE000X 2026-01-23T14:12:22.785Z 2026-01-29T14:57:11.136Z
9247692 9247692 20260121192802_27iVf DE000X 2026-01-23T14:10:48.413Z 2026-01-29T14:56:23.535Z
9247452 9247452 20260121183359_jrs9X DE000X 2026-01-23T14:10:06.164Z 2026-01-29T14:56:09.572Z
9243458 9243458 20260121043445_JBVOE DE000X 2026-01-22T14:22:00.625Z 2026-01-29T15:05:03.432Z
9243429 9243429 20260121043059_12OIN DE000X 2026-01-22T14:21:45.763Z 2026-01-29T15:05:01.980Z
9243425 9243425 20260121043059_UiX7C DE000X 2026-01-22T14:21:45.450Z 2026-01-29T15:05:01.897Z
9242297 9242297 20260121012350_9w3Jk DE000X 2026-01-22T14:17:16.267Z 2026-01-29T15:03:42.774Z
9242186 9242186 20260121005644_ofg9H DE000X 2026-01-22T14:16:49.541Z 2026-01-29T15:03:35.493Z
9242023 9242023 20260121000225_5rNaP DE000X 2026-01-22T14:15:52.762Z 2026-01-29T15:03:25.607Z
9241772 9241772 20260120222258_7kbiW DE000X 2026-01-22T14:14:27.295Z 2026-01-29T15:03:01.627Z
9241745 9241745 20260120220838_YlRVx DE000X 2026-01-22T14:14:22.025Z 2026-01-29T15:03:00.412Z
9241729 9241729 20260120215523_FzBLm DE000X 2026-01-22T14:14:18.515Z 2026-01-29T15:02:59.210Z
9241278 9241278 20260120194756_bN2Zs DE000X 2026-01-22T14:12:24.704Z 2026-01-29T15:02:30.051Z
9241103 9241103 20260120190753_jjTla DE000X 2026-01-22T14:11:40.729Z 2026-01-29T15:02:22.754Z
9241095 9241095 20260120190536_y9JXK DE000X 2026-01-22T14:11:39.081Z 2026-01-29T15:02:22.337Z
9240937 9240937 20260120183130_McY4h DE000X 2026-01-22T14:10:57.742Z 2026-01-29T15:02:03.446Z
9240713 9240713 20260120173150_slfYn DE000X 2026-01-22T14:09:42.241Z 2026-01-29T15:01:50.892Z
9237861 9237861 20260120061503_PTC2X DE000X 2026-01-21T14:27:47.577Z 2026-01-28T15:01:45.336Z
9237702 9237702 20260120055205_5DVQl DE000X 2026-01-21T14:27:27.017Z 2026-01-28T15:01:36.920Z
9237612 9237612 20260120054252_GCk5W DE000X 2026-01-21T14:27:07.370Z 2026-01-28T15:01:32.986Z
9237578 9237578 20260120053843_NmZ93 DE000X 2026-01-21T14:27:03.412Z 2026-01-28T15:01:31.784Z
9237528 9237528 20260120053047_1g0p2 DE000X 2026-01-21T14:26:52.375Z 2026-01-28T15:01:29.689Z
9237328 9237328 20260120050413_8eKP2 DE000X 2026-01-21T14:25:58.183Z 2026-01-28T15:01:19.812Z
9237284 9237284 20260120045750_1tZX5 DE000X 2026-01-21T14:25:50.739Z 2026-01-28T15:01:07.795Z
9237114 9237114 20260120043907_q35CX DE000X 2026-01-21T14:25:18.284Z 2026-01-28T15:00:58.512Z
9237049 9237049 20260120043120_w4TWs DE000X 2026-01-21T14:25:01.563Z 2026-01-28T15:00:55.516Z
9236875 9236875 20260120041307_Cs3i4 DE000X 2026-01-21T14:24:25.079Z 2026-01-28T15:00:40.360Z
9236860 9236860 20260120040855_FJq0a DE000X 2026-01-21T14:24:22.844Z 2026-01-28T15:00:39.593Z
9236816 9236816 20260120040318_0KODS DE000X 2026-01-21T14:24:17.501Z 2026-01-28T15:00:37.549Z
9236753 9236753 20260120035604_p35jE DE000X 2026-01-21T14:23:54.587Z 2026-01-28T15:00:33.543Z
9236727 9236727 20260120035219_b3DSd DE000X 2026-01-21T14:23:48.411Z 2026-01-28T15:00:32.141Z
9236643 9236643 20260120034340_xPlqf DE000X 2026-01-21T14:23:36.424Z 2026-01-28T15:00:27.025Z
9236539 9236539 20260120033139_NoTOD DE000X 2026-01-21T14:23:11.164Z 2026-01-28T15:00:08.228Z
9236505 9236505 20260120032835_riBhp DE000X 2026-01-21T14:23:00.204Z 2026-01-28T15:00:05.576Z
9236178 9236178 20260120024430_NLPdn DE000X 2026-01-21T14:21:53.711Z 2026-01-28T14:59:48.772Z
9236127 9236127 20260120023829_TDpio DE000X 2026-01-21T14:21:34.425Z 2026-01-28T14:59:46.132Z
9236107 9236107 20260120023644_R00wR DE000X 2026-01-21T14:21:27.723Z 2026-01-28T14:59:45.213Z
9236105 9236105 20260120023631_QedY5 DE000X 2026-01-21T14:21:27.369Z 2026-01-28T14:59:45.117Z
9236060 9236060 20260120023127_d6mjd DE000X 2026-01-21T14:21:20.565Z 2026-01-28T14:59:42.851Z
9235991 9235991 20260120022539_GZtyW DE000X 2026-01-21T14:21:10.928Z 2026-01-28T14:59:31.924Z
9235936 9235936 20260120021941_MRQ3D DE000X 2026-01-21T14:20:50.465Z 2026-01-28T14:59:29.492Z
9235865 9235865 20260120020917_Q33cL DE000X 2026-01-21T14:20:36.531Z 2026-01-28T14:59:25.038Z
9235660 9235660 20260120014415_SPAhB DE000X 2026-01-21T14:19:50.364Z 2026-01-28T14:59:15.029Z
9235587 9235587 20260120013649_JHU42 DE000X 2026-01-21T14:19:30.182Z 2026-01-28T14:59:03.553Z
9235550 9235550 20260120013328_Wp3SB DE000X 2026-01-21T14:19:24.012Z 2026-01-28T14:59:02.037Z
9235186 9235186 20260120004139_0B7wv DE000X 2026-01-21T14:17:51.398Z 2026-01-28T14:58:42.536Z
9235165 9235165 20260120003919_KAdrS DE000X 2026-01-21T14:17:48.265Z 2026-01-28T14:58:33.854Z
9235101 9235101 20260120002937_PS8UY DE000X 2026-01-21T14:17:33.083Z 2026-01-28T14:58:30.786Z
9234905 9234905 20260119234802_komsj DE000X 2026-01-21T14:16:38.144Z 2026-01-28T14:58:19.928Z
9234873 9234873 20260119234458_PZjIQ DE000X 2026-01-21T14:16:32.587Z 2026-01-28T14:58:18.243Z
9234554 9234554 20260119221755_I32Ka DE000X 2026-01-21T14:15:06.724Z 2026-01-28T14:57:53.635Z
9234495 9234495 20260119215412_Dxd0W DE000X 2026-01-21T14:14:46.254Z 2026-01-28T14:57:50.520Z
9234446 9234446 20260119213106_l1gVX DE000X 2026-01-21T14:14:30.217Z 2026-01-28T14:57:46.706Z
9234246 9234246 20260119202202_KYvfT DE000X 2026-01-21T14:13:15.006Z 2026-01-28T14:57:24.644Z
9234188 9234188 20260119195925_zOIF1 DE000X 2026-01-21T14:12:53.818Z 2026-01-28T14:57:20.239Z
9233953 9233953 20260119185512_nTxT5 DE000X 2026-01-21T14:11:30.834Z 2026-01-28T14:56:55.100Z
9233914 9233914 20260119184435_1jTkT DE000X 2026-01-21T14:11:22.466Z 2026-01-28T14:56:52.563Z
9233802 9233802 20260119180114_je6L6 DE000X 2026-01-21T14:10:41.870Z 2026-01-28T14:56:42.508Z
9233766 9233766 20260119174346_K21Fa DE000X 2026-01-21T14:10:24.210Z 2026-01-28T14:56:31.479Z
9230935 9230935 20260119053024_YSFZq DE000X 2026-01-20T14:30:31.223Z 2026-01-27T15:05:37.314Z
9230683 9230683 20260119044911_nygC2 DE000X 2026-01-20T14:29:13.750Z 2026-01-27T15:05:20.347Z
9230280 9230280 20260119035106_TxQev DE000X 2026-01-20T14:26:58.256Z 2026-01-27T15:04:45.852Z
9230261 9230261 20260119034659_zgI1C DE000X 2026-01-20T14:26:52.380Z 2026-01-27T15:04:44.935Z
9230254 9230254 20260119034624_17qsx DE000X 2026-01-20T14:26:50.612Z 2026-01-27T15:04:44.674Z
9229995 9229995 20260119030708_Zf5vO DE000X 2026-01-20T14:25:22.464Z 2026-01-27T15:04:18.780Z
9229825 9229825 20260119024316_23Q5l DE000X 2026-01-20T14:24:27.325Z 2026-01-27T15:03:59.084Z
9229530 9229530 20260119015751_7JzPw DE000X 2026-01-20T14:23:01.461Z 2026-01-27T15:03:40.653Z
9229489 9229489 20260119015233_IiWC9 DE000X 2026-01-20T14:22:47.799Z 2026-01-27T15:03:28.477Z
9229431 9229431 20260119014541_wcrru DE000X 2026-01-20T14:22:30.445Z 2026-01-27T15:03:25.554Z
9229387 9229387 20260119013912_OLx0J DE000X 2026-01-20T14:22:19.170Z 2026-01-27T15:03:21.334Z
9229325 9229325 20260119013239_aL7JI DE000X 2026-01-20T14:22:06.146Z 2026-01-27T15:03:17.916Z
9229262 9229262 20260119011517_Bx9es DE000X 2026-01-20T14:21:44.839Z 2026-01-27T15:03:14.300Z
9229182 9229182 20260119010251_LeG1H DE000X 2026-01-20T14:21:21.444Z 2026-01-27T15:03:10.217Z

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