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,551 rows where station_code = "DE0004" 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
8666486 8666486 20251201054928_qRjO6 DE0004 2025-12-02T14:26:19.090Z 2025-12-06T14:42:23.577Z
8666460 8666460 20251201054432_5agFB DE0004 2025-12-02T14:26:16.046Z 2025-12-06T14:42:22.980Z
8666458 8666458 20251201054347_Sl92G DE0004 2025-12-02T14:26:15.878Z 2025-12-06T14:42:22.903Z
8666360 8666360 20251201052153_o7jkH DE0004 2025-12-02T14:25:52.836Z 2025-12-06T14:42:17.978Z
8666313 8666313 20251201051106_3N4mL DE0004 2025-12-02T14:25:45.671Z 2025-12-06T14:42:16.907Z
8666240 8666240 20251201045919_Tk5xu DE0004 2025-12-02T14:25:39.108Z 2025-12-06T14:42:15.329Z
8666213 8666213 20251201045306_mqBOS DE0004 2025-12-02T14:25:36.424Z 2025-12-06T14:42:14.716Z
8666206 8666206 20251201045246_st2Rc DE0004 2025-12-02T14:25:36.301Z 2025-12-06T14:42:14.692Z
8666081 8666081 20251201043043_f0OAZ DE0004 2025-12-02T14:25:12.262Z 2025-12-06T14:42:11.213Z
8666029 8666029 20251201042504_n5Fkj DE0004 2025-12-02T14:25:07.028Z 2025-12-06T14:42:09.905Z
8665822 8665822 20251201040200_x5K2d DE0004 2025-12-02T14:24:32.377Z 2025-12-06T14:42:04.439Z
8665723 8665723 20251201035153_EA0V6 DE0004 2025-12-02T14:24:22.288Z 2025-12-06T14:41:47.361Z
8664231 8664231 20251130234923_NAdgx DE0004 2025-12-02T14:20:32.771Z 2025-12-06T14:40:41.994Z
8663903 8663903 20251130223126_2n6nv DE0004 2025-12-02T14:19:33.782Z 2025-12-06T14:40:15.869Z
8663869 8663869 20251130222158_bjCq7 DE0004 2025-12-02T14:19:28.883Z 2025-12-06T14:40:13.571Z
8663668 8663668 20251130212133_a3WI1 DE0004 2025-12-02T14:18:50.008Z 2025-12-06T14:40:06.693Z
8663177 8663177 20251130201811_iWZRj DE0004 2025-12-02T14:17:34.998Z 2025-12-06T14:39:55.123Z
8613475 8613475 20251126031929_UWxGC DE0004 2025-11-27T14:26:07.947Z 2025-12-04T15:09:41.169Z
8578102 8578102 20251122194058_LjgPa DE0004 2025-11-24T14:10:44.876Z 2025-12-01T15:19:08.797Z
8577825 8577825 20251122185945_EX8oE DE0004 2025-11-24T14:09:49.764Z 2025-12-01T15:18:59.537Z
8577412 8577412 20251122180340_cAtDm DE0004 2025-11-24T14:08:33.252Z 2025-12-01T15:18:49.145Z
8577323 8577323 20251122175441_3dt5j DE0004 2025-11-24T14:08:22.842Z 2025-12-01T15:18:47.393Z
8577079 8577079 20251122171704_q4Muv DE0004 2025-11-24T14:07:29.170Z 2025-11-24T14:07:29.170Z
8574024 8574024 20251122050020_100Mq DE0004 2025-11-23T14:42:12.302Z 2025-11-30T15:06:55.772Z
8573830 8573830 20251122041917_GF2Ac DE0004 2025-11-23T14:42:02.413Z 2025-11-30T15:06:41.563Z
8573762 8573762 20251122040644_XsJLU DE0004 2025-11-23T14:41:58.368Z 2025-11-30T15:06:37.052Z
8573730 8573730 20251122040005_tqaoE DE0004 2025-11-23T14:41:56.702Z 2025-11-30T15:06:36.577Z
8573700 8573700 20251122035600_35qkR DE0004 2025-11-23T14:41:55.307Z 2025-11-30T15:06:36.120Z
8573613 8573613 20251122034359_E2fBd DE0004 2025-11-23T14:41:26.364Z 2025-11-30T15:06:32.850Z
8573574 8573574 20251122033511_Exxj6 DE0004 2025-11-23T14:41:19.451Z 2025-11-30T15:06:31.738Z
8573397 8573397 20251122030602_MYjCp DE0004 2025-11-23T14:41:09.566Z 2025-11-30T15:06:19.940Z
8573396 8573396 20251122030548_iINum DE0004 2025-11-23T14:41:09.471Z 2025-11-30T15:06:19.924Z
8573326 8573326 20251122025615_4DhkJ DE0004 2025-11-23T14:41:06.267Z 2025-11-30T15:06:16.128Z
8573321 8573321 20251122025615_X63U3 DE0004 2025-11-23T14:41:06.239Z 2025-11-30T15:06:16.122Z
8573317 8573317 20251122025612_1tTta DE0004 2025-11-23T14:41:06.150Z 2025-11-30T15:06:16.096Z
8573254 8573254 20251122024817_EowV6 DE0004 2025-11-23T14:41:02.618Z 2025-11-30T15:06:12.997Z
8573153 8573153 20251122023607_9ig0J DE0004 2025-11-23T14:40:54.828Z 2025-11-30T15:06:11.358Z
8573113 8573113 20251122023039_wJRdp DE0004 2025-11-23T14:40:44.908Z 2025-11-30T15:06:10.084Z
8573087 8573087 20251122022652_Sh1MF DE0004 2025-11-23T14:40:43.401Z 2025-11-30T15:06:09.521Z
8572973 8572973 20251122021239_2Cusg DE0004 2025-11-23T14:40:29.194Z 2025-11-30T15:06:07.498Z
8572753 8572753 20251122013639_25mR8 DE0004 2025-11-23T14:39:41.528Z 2025-11-30T15:05:57.563Z
8572645 8572645 20251122012319_xGOLS DE0004 2025-11-23T14:39:36.335Z 2025-11-30T15:05:54.467Z
8572509 8572509 20251122010322_vDXGR DE0004 2025-11-23T14:39:29.547Z 2025-11-30T15:05:51.466Z
8572225 8572225 20251122000528_H8NSg DE0004 2025-11-23T14:38:09.969Z 2025-11-30T15:05:41.805Z
8572065 8572065 20251121233041_lpSX1 DE0004 2025-11-23T14:37:57.404Z 2025-11-30T15:05:36.499Z
8572038 8572038 20251121232118_BgK9w DE0004 2025-11-23T14:37:56.078Z 2025-11-30T15:05:34.042Z
8572012 8572012 20251121231627_Tvxln DE0004 2025-11-23T14:37:55.246Z 2025-11-30T15:05:31.543Z
8572005 8572005 20251121231255_YhZU9 DE0004 2025-11-23T14:37:54.782Z 2025-11-30T15:05:31.159Z
8571778 8571778 20251121220708_DSQT6 DE0004 2025-11-23T14:37:43.700Z 2025-11-30T15:05:18.889Z
8571605 8571605 20251121213054_5y46N DE0004 2025-11-23T14:37:08.347Z 2025-11-30T15:05:11.034Z
8571593 8571593 20251121212752_C7pA2 DE0004 2025-11-23T14:37:06.691Z 2025-11-30T15:05:10.718Z
8571554 8571554 20251121211608_0fVjl DE0004 2025-11-23T14:36:54.127Z 2025-11-30T15:05:10.039Z
8571486 8571486 20251121205454_djgmr DE0004 2025-11-23T14:36:35.808Z 2025-11-30T15:05:06.740Z
8571220 8571220 20251121194300_lrOj5 DE0004 2025-11-23T14:36:04.463Z 2025-11-30T15:04:39.809Z
8571173 8571173 20251121193221_XN9Xs DE0004 2025-11-23T14:36:01.818Z 2025-11-30T15:04:34.276Z
8571068 8571068 20251121185026_tj7rb DE0004 2025-11-23T14:35:56.271Z 2025-11-30T15:04:25.523Z
8570977 8570977 20251121181929_UqT3y DE0004 2025-11-23T14:35:50.156Z 2025-11-30T15:04:12.984Z
8570941 8570941 20251121180919_2PDY4 DE0004 2025-11-23T14:35:28.793Z 2025-11-30T15:04:10.509Z
8570885 8570885 20251121174545_xfGWy DE0004 2025-11-23T14:35:06.277Z 2025-11-30T15:03:57.378Z
8568411 8568411 20251121051646_lWKWd DE0004 2025-11-23T14:31:06.889Z 2025-11-29T14:54:46.711Z
8555273 8555273 20251121010126_1QqfQ DE0004 2025-11-22T14:38:20.470Z 2025-11-29T14:54:30.260Z
8550233 8550233 20251120232931_k1dlq DE0004 2025-11-22T14:20:27.335Z 2025-11-29T14:54:26.508Z
8548936 8548936 20251120213226_EgaLO DE0004 2025-11-22T14:17:57.235Z 2025-11-29T14:54:23.631Z
8548668 8548668 20251120210719_NI3ox DE0004 2025-11-22T14:17:24.435Z 2025-11-29T14:54:23.030Z
8548299 8548299 20251120204808_nXvel DE0004 2025-11-22T14:16:43.316Z 2025-11-29T14:54:22.337Z
8547890 8547890 20251120202006_3NvyR DE0004 2025-11-22T14:15:51.357Z 2025-11-29T14:54:21.215Z
8547486 8547486 20251120195521_m3xYx DE0004 2025-11-22T14:15:13.321Z 2025-11-29T14:54:20.196Z
8547437 8547437 20251120195043_s2B2k DE0004 2025-11-22T14:15:08.849Z 2025-11-29T14:54:19.948Z
8513950 8513950 20251118012129_zJZvq DE0004 2025-11-19T14:36:42.574Z 2025-11-26T15:07:51.610Z
8513611 8513611 20251118004726_1lnFF DE0004 2025-11-19T14:36:23.499Z 2025-11-26T15:07:50.090Z
8512658 8512658 20251117224847_AKbaX DE0004 2025-11-19T14:34:48.476Z 2025-11-26T15:07:45.083Z
8511813 8511813 20251117202214_sDYrS DE0004 2025-11-19T14:34:06.320Z 2025-11-26T15:07:38.792Z
8509016 8509016 20251118015835_kp5yA DE0004 2025-11-19T14:18:40.343Z 2025-11-26T15:07:53.569Z
8508493 8508493 20251118010836_5CH04 DE0004 2025-11-19T14:17:51.280Z 2025-11-26T15:07:51.048Z
8508462 8508462 20251118010429_qJVUh DE0004 2025-11-19T14:17:45.832Z 2025-11-26T15:07:50.935Z
8508232 8508232 20251118004409_v5U96 DE0004 2025-11-19T14:17:13.966Z 2025-11-26T15:07:49.883Z
8508102 8508102 20251118002935_tnE85 DE0004 2025-11-19T14:16:48.611Z 2025-11-26T15:07:49.303Z
8508076 8508076 20251118002629_U1QVr DE0004 2025-11-19T14:16:45.851Z 2025-11-26T15:07:49.220Z
8507990 8507990 20251118001641_0rpGe DE0004 2025-11-19T14:16:37.070Z 2025-11-26T15:07:48.811Z
8507901 8507901 20251118000940_s5vFG DE0004 2025-11-19T14:16:18.870Z 2025-11-26T15:07:48.310Z
8507680 8507680 20251117234848_Nf0lD DE0004 2025-11-19T14:15:45.534Z 2025-11-26T15:07:47.495Z
8507545 8507545 20251117233346_AZLlN DE0004 2025-11-19T14:15:28.023Z 2025-11-26T15:07:46.902Z
8507476 8507476 20251117232502_UQPwt DE0004 2025-11-19T14:15:22.360Z 2025-11-26T15:07:46.682Z
8507438 8507438 20251117231903_ILZMl DE0004 2025-11-19T14:15:16.816Z 2025-11-26T15:07:46.401Z
8507374 8507374 20251117231144_9VDiH DE0004 2025-11-19T14:15:03.733Z 2025-11-26T15:07:46.180Z
8507262 8507262 20251117230243_xPJkW DE0004 2025-11-19T14:14:49.849Z 2025-11-26T15:07:45.536Z
8507138 8507138 20251117224847_iYBW8 DE0004 2025-11-19T14:14:29.312Z 2025-11-26T15:07:45.086Z
8507073 8507073 20251117224105_6NDju DE0004 2025-11-19T14:14:20.502Z 2025-11-26T15:07:44.821Z
8506750 8506750 20251117220754_lNCSh DE0004 2025-11-19T14:13:35.850Z 2025-11-26T15:07:43.158Z
8506724 8506724 20251117220633_dAVXd DE0004 2025-11-19T14:13:34.168Z 2025-11-26T15:07:43.032Z
8506030 8506030 20251117210055_1VEhL DE0004 2025-11-19T14:11:56.150Z 2025-11-26T15:07:40.530Z
8505684 8505684 20251117203600_az6Vy DE0004 2025-11-19T14:11:04.753Z 2025-11-26T15:07:39.394Z
8505509 8505509 20251117202213_ozYnN DE0004 2025-11-19T14:10:34.863Z 2025-11-26T15:07:38.729Z
8505452 8505452 20251117201753_JFSh5 DE0004 2025-11-19T14:10:26.291Z 2025-11-26T15:07:38.482Z
8505258 8505258 20251117195939_hnfqg DE0004 2025-11-19T14:09:49.296Z 2025-11-26T15:07:37.641Z
8504677 8504677 20251117191509_c06MT DE0004 2025-11-19T14:08:29.216Z 2025-11-26T15:07:29.813Z
8504358 8504358 20251117185238_T0Me3 DE0004 2025-11-19T14:07:50.711Z 2025-11-26T15:07:18.863Z
8504274 8504274 20251117184431_jRlQC DE0004 2025-11-19T14:07:40.275Z 2025-11-26T15:07:15.820Z
8450352 8450352 20251113041908_XqNTZ DE0004 2025-11-14T14:23:17.053Z 2025-11-21T15:12:35.708Z
8450342 8450342 20251113041635_2WR6r DE0004 2025-11-14T14:23:15.464Z 2025-11-21T15:12:34.690Z

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