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

77 rows where station_code = "DE0018" 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
9242479 9242479 20260121020003_oJgM8 DE0018 2026-01-22T14:18:00.136Z 2026-01-29T15:04:00.688Z
9229972 9229972 20260119030220_Ke6z9 DE0018 2026-01-20T14:25:14.010Z 2026-01-27T15:04:17.595Z
9206491 9206491 20260114171446_wKWX5 DE0018 2026-01-16T14:04:11.594Z 2026-01-22T15:02:27.874Z
9189147 9189147 20260112031112_bb9R4 DE0018 2026-01-13T14:16:04.408Z 2026-01-20T15:22:44.318Z
9189090 9189090 20260112030008_5sKG7 DE0018 2026-01-13T14:15:43.732Z 2026-01-20T15:22:38.686Z
9188749 9188749 20260112013903_9FPyf DE0018 2026-01-13T14:14:02.600Z 2026-01-20T15:22:11.918Z
9188509 9188509 20260112001344_dJxCq DE0018 2026-01-13T14:12:46.243Z 2026-01-20T15:21:56.202Z
9188433 9188433 20260111233634_MspPu DE0018 2026-01-13T14:12:17.156Z 2026-01-20T15:21:41.699Z
9188319 9188319 20260111223711_vydWF DE0018 2026-01-13T14:11:40.911Z 2026-01-20T15:21:34.036Z
9188257 9188257 20260111214847_0uhMZ DE0018 2026-01-13T14:11:17.777Z 2026-01-20T15:21:30.221Z
9181380 9181380 20260111013513_GLSM4 DE0018 2026-01-12T14:10:35.861Z 2026-01-19T15:17:15.435Z
9181334 9181334 20260111012341_akj9c DE0018 2026-01-12T14:10:25.805Z 2026-01-19T15:17:13.246Z
9181216 9181216 20260111005748_oII0J DE0018 2026-01-12T14:09:59.450Z 2026-01-19T15:17:08.351Z
9181104 9181104 20260111002040_Hb3W1 DE0018 2026-01-12T14:09:34.935Z 2026-01-19T15:17:03.636Z
9180863 9180863 20260110230316_rj7sb DE0018 2026-01-12T14:08:40.460Z 2026-01-19T15:16:36.034Z
9179948 9179948 20260110182311_4OwCZ DE0018 2026-01-12T14:05:05.685Z 2026-01-19T15:15:37.824Z
9167442 9167442 20260108014729_W1u03 DE0018 2026-01-09T14:07:44.723Z 2026-01-16T15:11:19.752Z
9167420 9167420 20260108013318_tGzLm DE0018 2026-01-09T14:07:39.369Z 2026-01-16T15:11:18.015Z
9167378 9167378 20260108010852_TAzww DE0018 2026-01-09T14:07:29.250Z 2026-01-16T15:11:14.143Z
9167064 9167064 20260107221651_uG3vO DE0018 2026-01-09T14:06:04.707Z 2026-01-16T15:10:47.101Z
9166926 9166926 20260107210215_jYUGT DE0018 2026-01-09T14:05:30.860Z 2026-01-16T15:10:30.864Z
9162125 9162125 20260106222035_iFBFZ DE0018 2026-01-08T14:03:05.126Z 2026-01-13T15:01:38.419Z
9157954 9157954 20260105193429_Brcrz DE0018 2026-01-07T14:04:20.565Z 2026-01-13T15:06:47.862Z
9157815 9157815 20260105184934_3ogn2 DE0018 2026-01-07T14:03:41.373Z 2026-01-13T15:06:30.525Z
9147338 9147338 20260104053606_05OeW DE0018 2026-01-05T14:24:05.157Z 2026-01-12T15:10:49.564Z
9145256 9145256 20260104031112_mC3ro DE0018 2026-01-05T14:20:22.050Z 2026-01-12T15:07:45.007Z
9145138 9145138 20260104030539_2ulTO DE0018 2026-01-05T14:20:13.785Z 2026-01-12T15:07:42.326Z
9145079 9145079 20260104030317_rHL8y DE0018 2026-01-05T14:20:09.239Z 2026-01-12T15:07:40.929Z
9144520 9144520 20260104024653_VdIsv DE0018 2026-01-05T14:19:21.228Z 2026-01-12T15:07:09.492Z
9144510 9144510 20260104024626_VDe2W DE0018 2026-01-05T14:19:12.545Z 2026-01-12T15:07:09.052Z
9143254 9143254 20260104020244_k9p7r DE0018 2026-01-05T14:17:19.577Z 2026-01-12T15:06:18.586Z
9143059 9143059 20260104015508_ym2dW DE0018 2026-01-05T14:16:53.013Z 2026-01-12T15:06:12.830Z
9114327 9114327 20251231041213_r2gdz DE0018 2026-01-01T14:22:08.953Z 2026-01-08T15:09:42.603Z
9113960 9113960 20251231035753_38MiH DE0018 2026-01-01T14:21:03.410Z 2026-01-08T15:09:18.147Z
9109729 9109729 20251230203431_4mriG DE0018 2026-01-01T14:03:15.159Z 2026-01-08T15:04:25.011Z
9103726 9103726 20251230045612_sKWzw DE0018 2025-12-31T14:18:59.817Z 2025-12-31T14:29:54.022Z
9102923 9102923 20251230034337_CCuYw DE0018 2025-12-31T14:15:51.261Z 2026-01-07T15:08:11.567Z
9102463 9102463 20251230030452_YGWP2 DE0018 2025-12-31T14:13:58.842Z 2026-01-07T15:07:40.495Z
9102461 9102461 20251230030441_JrjXG DE0018 2025-12-31T14:13:58.285Z 2026-01-07T15:07:40.267Z
9102371 9102371 20251230025544_Fxo5h DE0018 2025-12-31T14:13:37.233Z 2026-01-07T15:07:36.158Z
9102304 9102304 20251230024846_O3xXk DE0018 2025-12-31T14:13:16.731Z 2026-01-07T15:07:32.612Z
9101887 9101887 20251230015154_QltXu DE0018 2025-12-31T14:11:04.090Z 2026-01-07T15:07:00.344Z
9101866 9101866 20251230014951_ErSWX DE0018 2025-12-31T14:10:54.137Z 2026-01-07T15:06:57.224Z
9101850 9101850 20251230014646_1GslS DE0018 2025-12-31T14:10:49.593Z 2026-01-07T15:06:51.579Z
9098768 9098768 20251227200217_Eelat DE0018 2025-12-30T15:10:50.358Z 2026-01-04T15:35:26.682Z
9086418 9086418 20251228045452_Fny9h DE0018 2025-12-30T14:41:02.248Z 2026-01-05T15:10:18.110Z
9086180 9086180 20251228043354_JTJ3K DE0018 2025-12-30T14:40:27.743Z 2026-01-05T15:09:58.560Z
9086127 9086127 20251228042818_9gjRy DE0018 2025-12-30T14:40:21.621Z 2025-12-31T14:51:56.743Z
9086056 9086056 20251228042528_enJXt DE0018 2025-12-30T14:40:13.534Z 2026-01-05T15:09:53.462Z
9085744 9085744 20251228035815_XdjwK DE0018 2025-12-30T14:39:18.936Z 2025-12-31T14:51:32.606Z
9085567 9085567 20251228033824_gforG DE0018 2025-12-30T14:38:49.534Z 2026-01-05T15:09:37.827Z
9084891 9084891 20251228023128_ZfkjQ DE0018 2025-12-30T14:37:00.540Z 2026-01-05T15:09:06.915Z
9084486 9084486 20251228014850_tnV6l DE0018 2025-12-30T14:35:50.167Z 2026-01-05T15:08:44.808Z
9083382 9083382 20251227234852_zHkgd DE0018 2025-12-30T14:32:29.798Z 2026-01-05T15:07:46.738Z
9083338 9083338 20251227234022_lnEIr DE0018 2025-12-30T14:32:22.822Z 2026-01-05T15:07:44.932Z
9043784 9043784 20251224211806_nSQEx DE0018 2025-12-28T14:48:07.211Z 2026-01-01T15:57:22.859Z
9043689 9043689 20251224210520_QGLgv DE0018 2025-12-28T14:47:46.067Z 2026-01-01T15:57:21.610Z
9036278 9036278 20251224034340_XefEX DE0018 2025-12-28T14:34:43.431Z 2026-01-01T15:54:07.291Z
9036228 9036228 20251224033008_xH8ax DE0018 2025-12-28T14:34:38.806Z 2026-01-01T15:54:05.443Z
9036206 9036206 20251224032027_LEOtd DE0018 2025-12-28T14:34:23.612Z 2026-01-01T15:54:05.051Z
9036092 9036092 20251224023816_h05gD DE0018 2025-12-28T14:34:08.699Z 2026-01-01T15:54:03.328Z
9035986 9035986 20251224020127_3Euwb DE0018 2025-12-28T14:33:43.959Z 2026-01-01T15:54:01.792Z
9030654 9030654 20251225045208_34JOD DE0018 2025-12-28T14:19:14.712Z 2026-01-02T15:44:57.562Z
8994095 8994095 20251219001635_mLw2y DE0018 2025-12-26T14:54:04.335Z 2025-12-27T15:28:48.708Z
8993679 8993679 20251218231337_SIUGz DE0018 2025-12-26T14:53:25.953Z 2025-12-27T15:28:08.463Z
8993532 8993532 20251218223247_GV3bP DE0018 2025-12-26T14:53:11.953Z 2025-12-27T15:27:50.588Z
8993319 8993319 20251218212454_9d4Pn DE0018 2025-12-26T14:52:44.563Z 2025-12-27T15:27:28.586Z
8992893 8992893 20251218200605_vao9v DE0018 2025-12-26T14:51:51.188Z 2025-12-27T15:27:00.017Z
8992874 8992874 20251218200427_Wq23Y DE0018 2025-12-26T14:51:50.301Z 2025-12-27T15:26:58.066Z
8992687 8992687 20251218193846_qRGAR DE0018 2025-12-26T14:51:34.981Z 2025-12-26T14:51:34.981Z
8992586 8992586 20251218192748_ShKmb DE0018 2025-12-26T14:51:23.888Z 2025-12-27T15:26:24.030Z
8977716 8977716 20251219053648_H9MPf DE0018 2025-12-26T14:13:30.682Z 2025-12-28T15:17:35.025Z
8977669 8977669 20251219053451_oSGC8 DE0018 2025-12-26T14:13:24.596Z 2025-12-28T15:17:34.644Z
8977346 8977346 20251219045426_Y079t DE0018 2025-12-26T14:12:31.319Z 2025-12-26T14:32:01.270Z
8977330 8977330 20251219045021_OGgv9 DE0018 2025-12-26T14:12:28.417Z 2025-12-28T15:17:32.243Z
8976761 8976761 20251219033953_RFYvK DE0018 2025-12-26T14:10:42.195Z 2025-12-28T15:17:28.050Z
8975999 8975999 20251219022026_soxeI DE0018 2025-12-26T14:08:35.380Z 2025-12-28T15:17:22.256Z

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