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

830 rows where station_code = "DK0005" 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
9240739 9240739 20260120173808_3Go8x DK0005 2026-01-22T14:09:47.463Z 2026-01-29T15:01:52.547Z
9240670 9240670 20260120172039_xRq5A DK0005 2026-01-22T14:09:26.763Z 2026-01-29T15:01:37.886Z
9235912 9235912 20260120021753_4y2nQ DK0005 2026-01-21T14:20:44.937Z 2026-01-28T14:59:28.747Z
9235154 9235154 20260120003744_jVcbq DK0005 2026-01-21T14:17:46.862Z 2026-01-28T14:58:33.358Z
9234899 9234899 20260119234753_bKGWA DK0005 2026-01-21T14:16:37.258Z 2026-01-28T14:58:19.565Z
9234011 9234011 20260119191322_3otbH DK0005 2026-01-21T14:11:51.797Z 2026-01-28T14:56:58.397Z
9233955 9233955 20260119185521_6T3UE DK0005 2026-01-21T14:11:31.366Z 2026-01-28T14:56:55.299Z
9231086 9231086 20260119055925_4T6HL DK0005 2026-01-20T14:31:10.953Z 2026-01-27T15:05:57.297Z
9230997 9230997 20260119054143_MlHgY DK0005 2026-01-20T14:30:46.670Z 2026-01-27T15:05:52.064Z
9230809 9230809 20260119051229_OeUmd DK0005 2026-01-20T14:29:51.520Z 2026-01-27T15:05:28.015Z
9230658 9230658 20260119044657_hKPmC DK0005 2026-01-20T14:29:08.417Z 2026-01-27T15:05:19.202Z
9230498 9230498 20260119042733_VqyCf DK0005 2026-01-20T14:28:10.855Z 2026-01-27T15:04:59.681Z
9230425 9230425 20260119041722_g2vbX DK0005 2026-01-20T14:27:45.614Z 2026-01-27T15:04:54.005Z
9230218 9230218 20260119034030_3WRnl DK0005 2026-01-20T14:26:41.205Z 2026-01-27T15:04:42.784Z
9230194 9230194 20260119033850_DMMVb DK0005 2026-01-20T14:26:29.980Z 2026-01-27T15:04:32.332Z
9229818 9229818 20260119024137_LP2pK DK0005 2026-01-20T14:24:24.769Z 2026-01-27T15:03:58.577Z
9229393 9229393 20260119013925_bYk2s DK0005 2026-01-20T14:22:20.419Z 2026-01-27T15:03:21.724Z
9229315 9229315 20260119013020_m2Fqx DK0005 2026-01-20T14:22:02.751Z 2026-01-27T15:03:17.394Z
9229305 9229305 20260119012815_Lc2H0 DK0005 2026-01-20T14:21:55.751Z 2026-01-27T15:03:16.615Z
9228986 9228986 20260119003124_52J7P DK0005 2026-01-20T14:20:30.192Z 2026-01-27T15:02:46.578Z
9208199 9208199 20260115043232_zOMVf DK0005 2026-01-16T14:11:40.518Z 2026-01-22T15:04:03.901Z
9207251 9207251 20260115002026_onKM1 DK0005 2026-01-16T14:07:57.035Z 2026-01-22T15:03:16.213Z
9207070 9207070 20260114211938_BDw4p DK0005 2026-01-16T14:06:58.382Z 2026-01-22T15:03:06.837Z
9182447 9182447 20260111052513_SNafL DK0005 2026-01-12T14:14:36.321Z 2026-01-19T15:18:32.630Z
9182319 9182319 20260111045953_8MQgw DK0005 2026-01-12T14:14:08.942Z 2026-01-19T15:18:25.804Z
9182216 9182216 20260111044451_ojK03 DK0005 2026-01-12T14:13:45.389Z 2026-01-19T15:18:21.227Z
9181737 9181737 20260111030114_TVe0p DK0005 2026-01-12T14:11:56.263Z 2026-01-19T15:17:46.555Z
9181528 9181528 20260111020418_53vGs DK0005 2026-01-12T14:11:07.512Z 2026-01-19T15:17:23.181Z
9181164 9181164 20260111003940_DgDx3 DK0005 2026-01-12T14:09:48.754Z 2026-01-19T15:17:06.076Z
9181134 9181134 20260111003139_4JNa5 DK0005 2026-01-12T14:09:41.304Z 2026-01-19T15:17:04.878Z
9181049 9181049 20260111000416_jzz4U DK0005 2026-01-12T14:09:24.553Z 2026-01-19T15:16:45.749Z
9181047 9181047 20260111000346_pbpWW DK0005 2026-01-12T14:09:22.369Z 2026-01-19T15:16:45.619Z
9180505 9180505 20260110204321_GV9Nr DK0005 2026-01-12T14:07:22.025Z 2026-01-19T15:16:20.618Z
9180485 9180485 20260110203303_Gpo7f DK0005 2026-01-12T14:07:17.973Z 2026-01-19T15:16:15.740Z
9180016 9180016 20260110184512_zUoaX DK0005 2026-01-12T14:05:24.402Z 2026-01-19T15:15:41.680Z
9126411 9126411 20260101195950_Q9ZaI DK0005 2026-01-03T14:03:44.653Z 2026-01-09T14:48:24.780Z
9119478 9119478 20251230180458_rzZXO DK0005 2026-01-01T14:56:13.782Z 2026-01-07T15:12:46.873Z
9119104 9119104 20251230162632_x2FOz DK0005 2026-01-01T14:54:50.819Z 2026-01-07T15:12:04.755Z
9118736 9118736 20251230052805_OqCfS DK0005 2026-01-01T14:49:15.531Z 2026-01-07T15:09:20.446Z
9116525 9116525 20251231061939_eVJ02 DK0005 2026-01-01T14:28:19.086Z 2026-01-01T14:57:54.875Z
9104620 9104620 20251230061310_cAqvh DK0005 2025-12-31T14:21:50.041Z 2026-01-07T15:09:50.615Z
9104296 9104296 20251230054240_Sb1Yw DK0005 2025-12-31T14:20:56.052Z 2025-12-31T14:29:54.276Z
9104250 9104250 20251230053921_yiD4l DK0005 2025-12-31T14:20:46.084Z 2026-01-07T15:09:36.783Z
9104065 9104065 20251230052846_GwmqH DK0005 2025-12-31T14:20:08.569Z 2026-01-07T15:09:28.912Z
9103948 9103948 20251230052054_eajEc DK0005 2025-12-31T14:19:52.820Z 2025-12-31T14:29:54.135Z
9103557 9103557 20251230043913_lzIQa DK0005 2025-12-31T14:18:14.701Z 2025-12-31T14:29:53.933Z
9103507 9103507 20251230043510_DWp9r DK0005 2025-12-31T14:18:02.114Z 2025-12-31T14:29:53.902Z
9103303 9103303 20251230041517_1rYUA DK0005 2025-12-31T14:17:16.842Z 2026-01-07T15:08:37.251Z
9103176 9103176 20251230040421_w2GdO DK0005 2025-12-31T14:16:49.629Z 2025-12-31T14:29:53.679Z
9103049 9103049 20251230035253_xPBf8 DK0005 2025-12-31T14:16:17.210Z 2026-01-07T15:08:15.677Z
9103018 9103018 20251230035107_S9JWU DK0005 2025-12-31T14:16:09.398Z 2025-12-31T14:29:53.523Z
9102988 9102988 20251230034829_Tt73V DK0005 2025-12-31T14:16:03.029Z 2025-12-31T14:29:53.506Z
9102891 9102891 20251230034055_hln7c DK0005 2025-12-31T14:15:43.568Z 2026-01-07T15:08:10.380Z
9102760 9102760 20251230033227_3PL8P DK0005 2025-12-31T14:15:12.900Z 2026-01-07T15:08:04.707Z
9102608 9102608 20251230031612_3N4l2 DK0005 2025-12-31T14:14:34.807Z 2026-01-07T15:07:47.317Z
9102532 9102532 20251230031055_X4tzO DK0005 2025-12-31T14:14:20.183Z 2025-12-31T14:29:53.204Z
9102505 9102505 20251230030836_jDikS DK0005 2025-12-31T14:14:10.123Z 2025-12-31T14:29:53.194Z
9102499 9102499 20251230030824_K6RuX DK0005 2025-12-31T14:14:08.413Z 2025-12-31T14:29:53.192Z
9102491 9102491 20251230030800_3SF3E DK0005 2025-12-31T14:14:06.199Z 2025-12-31T14:29:53.188Z
9102438 9102438 20251230030148_p2TJn DK0005 2025-12-31T14:13:52.089Z 2026-01-07T15:07:39.046Z
9102422 9102422 20251230025939_0uuZ2 DK0005 2025-12-31T14:13:49.138Z 2026-01-07T15:07:38.412Z
9102168 9102168 20251230023147_UXThB DK0005 2025-12-31T14:12:31.738Z 2025-12-31T14:29:52.973Z
9102120 9102120 20251230022653_q68nm DK0005 2025-12-31T14:12:14.295Z 2025-12-31T14:29:52.925Z
9101897 9101897 20251230015416_ib2cE DK0005 2025-12-31T14:11:07.132Z 2025-12-31T14:29:52.810Z
9101660 9101660 20251230011359_3CKzc DK0005 2025-12-31T14:09:52.660Z 2026-01-07T15:06:40.315Z
9101651 9101651 20251230011314_ybEXp DK0005 2025-12-31T14:09:49.688Z 2026-01-07T15:06:39.808Z
9101649 9101649 20251230011239_PJ2nP DK0005 2025-12-31T14:09:46.579Z 2026-01-07T15:06:39.692Z
9101576 9101576 20251230005624_0HGbQ DK0005 2025-12-31T14:09:26.936Z 2026-01-07T15:06:35.933Z
9101512 9101512 20251230004401_MrWNf DK0005 2025-12-31T14:09:03.880Z 2025-12-31T14:29:52.569Z
9101268 9101268 20251229234459_9TN2L DK0005 2025-12-31T14:07:34.643Z 2026-01-07T15:06:10.348Z
9101227 9101227 20251229233043_vTfH5 DK0005 2025-12-31T14:07:21.707Z 2026-01-07T15:06:08.090Z
9101057 9101057 20251229222225_Ek0HY DK0005 2025-12-31T14:06:15.935Z 2026-01-07T15:05:50.575Z
9100750 9100750 20251229210552_S8xKt DK0005 2025-12-31T14:04:33.845Z 2026-01-07T15:05:36.854Z
9098984 9098984 20251227204004_H42JN DK0005 2025-12-30T15:11:20.414Z 2025-12-30T15:11:20.414Z
9098875 9098875 20251227201822_djWKq DK0005 2025-12-30T15:11:13.112Z 2025-12-30T15:11:13.112Z
9098444 9098444 20251227190805_XzeHY DK0005 2025-12-30T15:10:30.273Z 2025-12-30T15:10:30.273Z
9098218 9098218 20251227183021_P1Uoq DK0005 2025-12-30T15:09:58.294Z 2025-12-30T15:09:58.294Z
9097870 9097870 20251227174035_r5L6y DK0005 2025-12-30T15:09:22.730Z 2025-12-30T15:09:22.730Z
9097709 9097709 20251227172310_t5Wbw DK0005 2025-12-30T15:09:13.908Z 2025-12-30T15:09:13.908Z
9097476 9097476 20251227163953_sNR6j DK0005 2025-12-30T15:08:44.489Z 2026-01-04T15:33:56.569Z
9091782 9091782 20251228195627_K01SQ DK0005 2025-12-30T14:53:20.369Z 2026-01-05T15:14:26.492Z
9091462 9091462 20251228190236_Djat3 DK0005 2025-12-30T14:52:42.561Z 2026-01-05T15:14:13.818Z
9091403 9091403 20251228184916_levpy DK0005 2025-12-30T14:52:35.737Z 2026-01-05T15:14:11.830Z
9086913 9086913 20251228060548_4Qmxp DK0005 2025-12-30T14:42:27.843Z 2026-01-05T15:10:44.808Z
9086876 9086876 20251228055401_mdnJi DK0005 2025-12-30T14:42:23.358Z 2025-12-31T14:52:39.520Z
9086848 9086848 20251228054838_Sda5f DK0005 2025-12-30T14:42:19.958Z 2025-12-31T14:52:38.201Z
9086821 9086821 20251228054441_e3I6Y DK0005 2025-12-30T14:42:09.883Z 2025-12-31T14:52:36.715Z
9086788 9086788 20251228053654_5RVkW DK0005 2025-12-30T14:42:04.572Z 2026-01-05T15:10:31.929Z
9086664 9086664 20251228052428_5OSTs DK0005 2025-12-30T14:41:42.657Z 2026-01-05T15:10:26.353Z
9086502 9086502 20251228050804_hCFRJ DK0005 2025-12-30T14:41:22.309Z 2025-12-31T14:52:13.999Z
9086453 9086453 20251228050025_UxQH2 DK0005 2025-12-30T14:41:06.204Z 2025-12-31T14:52:11.317Z
9086322 9086322 20251228044741_ieXLG DK0005 2025-12-30T14:40:52.333Z 2026-01-05T15:10:15.575Z
9086169 9086169 20251228043128_CPt1l DK0005 2025-12-30T14:40:26.032Z 2026-01-05T15:09:58.026Z
9086120 9086120 20251228042805_5gICU DK0005 2025-12-30T14:40:20.581Z 2025-12-31T14:51:56.426Z
9085966 9085966 20251228041707_Am0CP DK0005 2025-12-30T14:39:55.787Z 2025-12-31T14:51:43.051Z
9085528 9085528 20251228033414_y7ObN DK0005 2025-12-30T14:38:45.411Z 2025-12-31T14:51:22.908Z
9085435 9085435 20251228032603_KD4sA DK0005 2025-12-30T14:38:32.965Z 2026-01-05T15:09:23.284Z
9085418 9085418 20251228032412_q8fHM DK0005 2025-12-30T14:38:30.324Z 2026-01-05T15:09:22.833Z
9085199 9085199 20251228030310_AAoNV DK0005 2025-12-30T14:37:56.701Z 2025-12-31T14:51:00.739Z
9085058 9085058 20251228024915_lMLYO DK0005 2025-12-30T14:37:30.144Z 2026-01-05T15:09:11.811Z

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