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

4,618 rows where station_code = "DK0003" 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
8666424 8666424 20251201053827_xERGJ DK0003 2025-12-02T14:26:01.453Z 2025-12-02T14:26:01.453Z
8666413 8666413 20251201053644_IqkcJ DK0003 2025-12-02T14:25:59.380Z 2025-12-06T14:42:21.546Z
8666371 8666371 20251201052532_BOZyR DK0003 2025-12-02T14:25:54.196Z 2025-12-06T14:42:19.925Z
8666353 8666353 20251201052055_8uHxa DK0003 2025-12-02T14:25:52.112Z 2025-12-06T14:42:17.757Z
8666329 8666329 20251201051602_5yJQS DK0003 2025-12-02T14:25:47.682Z 2025-12-02T14:25:47.682Z
8666273 8666273 20251201050706_agbKN DK0003 2025-12-02T14:25:42.021Z 2025-12-06T14:42:16.267Z
8666266 8666266 20251201050522_2kE2E DK0003 2025-12-02T14:25:41.462Z 2025-12-06T14:42:16.107Z
8666254 8666254 20251201050120_2rDM6 DK0003 2025-12-02T14:25:39.937Z 2025-12-02T14:25:39.937Z
8666190 8666190 20251201045021_tjBLc DK0003 2025-12-02T14:25:34.902Z 2025-12-06T14:42:14.408Z
8666181 8666181 20251201044820_W9aWO DK0003 2025-12-02T14:25:33.821Z 2025-12-02T14:25:33.821Z
8666132 8666132 20251201044047_zgmxS DK0003 2025-12-02T14:25:18.126Z 2025-12-06T14:42:12.739Z
8665989 8665989 20251201041711_A9sDB DK0003 2025-12-02T14:25:02.884Z 2025-12-06T14:42:08.878Z
8665890 8665890 20251201040626_AhZpi DK0003 2025-12-02T14:24:44.334Z 2025-12-06T14:42:06.172Z
8665861 8665861 20251201040323_ynce4 DK0003 2025-12-02T14:24:36.193Z 2025-12-06T14:42:05.287Z
8665813 8665813 20251201040104_nqo61 DK0003 2025-12-02T14:24:31.452Z 2025-12-06T14:42:04.101Z
8665806 8665806 20251201040044_mk0l4 DK0003 2025-12-02T14:24:30.734Z 2025-12-06T14:42:03.908Z
8665799 8665799 20251201035924_27oLB DK0003 2025-12-02T14:24:30.235Z 2025-12-06T14:42:03.725Z
8665675 8665675 20251201035008_5qKa9 DK0003 2025-12-02T14:24:19.098Z 2025-12-06T14:41:45.692Z
8665670 8665670 20251201034950_hbXG9 DK0003 2025-12-02T14:24:18.813Z 2025-12-06T14:41:45.594Z
8665651 8665651 20251201034713_Oo1gK DK0003 2025-12-02T14:24:16.444Z 2025-12-06T14:41:44.710Z
8665537 8665537 20251201033257_iGAuP DK0003 2025-12-02T14:23:50.997Z 2025-12-06T14:41:40.111Z
8665437 8665437 20251201032056_sln2G DK0003 2025-12-02T14:23:41.662Z 2025-12-06T14:41:37.656Z
8665400 8665400 20251201031546_0l7Xo DK0003 2025-12-02T14:23:37.945Z 2025-12-06T14:41:36.860Z
8665359 8665359 20251201031100_cYQUr DK0003 2025-12-02T14:23:34.517Z 2025-12-06T14:41:35.686Z
8665322 8665322 20251201030739_IZ4CH DK0003 2025-12-02T14:23:31.301Z 2025-12-06T14:41:34.796Z
8665286 8665286 20251201030127_mkTDy DK0003 2025-12-02T14:23:17.743Z 2025-12-06T14:41:32.833Z
8665242 8665242 20251201025050_d358y DK0003 2025-12-02T14:23:11.688Z 2025-12-06T14:41:30.396Z
8665210 8665210 20251201024748_x6pRt DK0003 2025-12-02T14:23:08.307Z 2025-12-06T14:41:29.518Z
8665174 8665174 20251201024142_ICPRs DK0003 2025-12-02T14:23:04.437Z 2025-12-06T14:41:28.707Z
8665154 8665154 20251201023719_G3DDr DK0003 2025-12-02T14:23:02.132Z 2025-12-06T14:41:28.227Z
8665124 8665124 20251201023418_RyPrU DK0003 2025-12-02T14:22:58.879Z 2025-12-06T14:41:27.632Z
8665066 8665066 20251201022334_dIUbZ DK0003 2025-12-02T14:22:44.496Z 2025-12-06T14:41:24.412Z
8665061 8665061 20251201022240_Ew2cY DK0003 2025-12-02T14:22:44.258Z 2025-12-06T14:41:21.920Z
8664971 8664971 20251201020922_8ua31 DK0003 2025-12-02T14:22:31.949Z 2025-12-06T14:41:04.183Z
8664910 8664910 20251201020317_FLbwK DK0003 2025-12-02T14:22:26.212Z 2025-12-06T14:41:02.803Z
8664862 8664862 20251201015227_uZ7Cj DK0003 2025-12-02T14:22:13.942Z 2025-12-06T14:41:01.222Z
8664844 8664844 20251201014921_ZcwKW DK0003 2025-12-02T14:22:11.438Z 2025-12-06T14:41:00.781Z
8664737 8664737 20251201013340_aY3jH DK0003 2025-12-02T14:22:00.032Z 2025-12-06T14:40:56.071Z
8664726 8664726 20251201013133_bzzmr DK0003 2025-12-02T14:21:59.263Z 2025-12-06T14:40:55.906Z
8664707 8664707 20251201013018_cxyRN DK0003 2025-12-02T14:21:56.338Z 2025-12-06T14:40:55.512Z
8664653 8664653 20251201011859_Jg8Fs DK0003 2025-12-02T14:21:44.078Z 2025-12-06T14:40:54.026Z
8664630 8664630 20251201011508_PpvTf DK0003 2025-12-02T14:21:40.375Z 2025-12-06T14:40:53.374Z
8647889 8647889 20251129055534_cERfW DK0003 2025-11-30T14:29:21.212Z 2025-12-06T14:56:51.957Z
8647774 8647774 20251129052724_CCgyC DK0003 2025-11-30T14:28:53.068Z 2025-12-06T14:56:47.272Z
8647737 8647737 20251129051630_V9t8J DK0003 2025-11-30T14:28:50.083Z 2025-12-06T14:56:46.056Z
8647637 8647637 20251129045950_PWSBs DK0003 2025-11-30T14:28:40.706Z 2025-12-06T14:56:42.384Z
8647498 8647498 20251129044544_KSbjt DK0003 2025-11-30T14:28:30.513Z 2025-12-06T14:56:39.996Z
8647482 8647482 20251129044200_j7G3F DK0003 2025-11-30T14:28:29.283Z 2025-12-06T14:56:39.741Z
8647416 8647416 20251129043239_4m7On DK0003 2025-11-30T14:28:09.113Z 2025-12-06T14:56:38.451Z
8647363 8647363 20251129042736_0WQrM DK0003 2025-11-30T14:28:03.371Z 2025-12-06T14:56:37.477Z
8647314 8647314 20251129042021_X6VZF DK0003 2025-11-30T14:27:59.342Z 2025-12-06T14:56:36.699Z
8623250 8623250 20251126233525_W2KyH DK0003 2025-11-28T14:21:23.820Z 2025-12-05T15:03:40.879Z
8623052 8623052 20251126223932_FtMCq DK0003 2025-11-28T14:20:37.222Z 2025-12-05T15:03:27.020Z
8622932 8622932 20251126220929_WmzRw DK0003 2025-11-28T14:20:20.254Z 2025-12-05T15:03:20.198Z
8622902 8622902 20251126220259_7ZSvV DK0003 2025-11-28T14:20:17.213Z 2025-12-05T15:03:19.267Z
8622818 8622818 20251126213943_NgM41 DK0003 2025-11-28T14:20:07.574Z 2025-12-05T15:03:14.347Z
8622715 8622715 20251126204954_RM8Tu DK0003 2025-11-28T14:19:44.142Z 2025-12-05T15:03:05.434Z
8622653 8622653 20251126203140_YYxSW DK0003 2025-11-28T14:19:38.452Z 2025-12-05T15:03:04.643Z
8622612 8622612 20251126201531_41Nl5 DK0003 2025-11-28T14:19:33.306Z 2025-12-05T15:03:04.067Z
8622606 8622606 20251126201503_g2NSZ DK0003 2025-11-28T14:19:28.813Z 2025-12-05T15:03:03.999Z
8622542 8622542 20251126195112_jYG1O DK0003 2025-11-28T14:19:08.274Z 2025-12-05T15:03:03.216Z
8622520 8622520 20251126194231_Kkgga DK0003 2025-11-28T14:19:04.673Z 2025-12-05T15:03:02.868Z
8622480 8622480 20251126193242_W9ijB DK0003 2025-11-28T14:18:57.152Z 2025-12-05T15:03:02.298Z
8622396 8622396 20251126190307_O82RK DK0003 2025-11-28T14:18:47.101Z 2025-12-05T15:02:56.387Z
8622355 8622355 20251126185529_i4SUQ DK0003 2025-11-28T14:18:30.453Z 2025-12-05T15:02:55.825Z
8582203 8582203 20251123044354_3g9rY DK0003 2025-11-24T14:33:22.526Z 2025-12-01T15:22:18.726Z
8582066 8582066 20251123035935_rVe9T DK0003 2025-11-24T14:33:14.632Z 2025-12-01T15:22:15.358Z
8582062 8582062 20251123035702_8Dw7q DK0003 2025-11-24T14:33:14.185Z 2025-12-01T15:22:15.132Z
8581833 8581833 20251123024342_g7Srl DK0003 2025-11-24T14:32:40.735Z 2025-12-01T15:21:44.532Z
8580050 8580050 20251123022101_6aKC3 DK0003 2025-11-24T14:15:55.311Z 2025-12-01T15:21:36.642Z
8578851 8578851 20251122213906_tltKF DK0003 2025-11-24T14:12:50.843Z 2025-12-01T15:19:53.901Z
8578720 8578720 20251122211957_KaGE1 DK0003 2025-11-24T14:12:32.451Z 2025-12-01T15:19:50.694Z
8578707 8578707 20251122211840_o6XVe DK0003 2025-11-24T14:12:23.832Z 2025-12-01T15:19:50.400Z
8574001 8574001 20251122045732_8mSd2 DK0003 2025-11-23T14:42:11.330Z 2025-11-30T15:06:55.465Z
8573978 8573978 20251122045341_HlH05 DK0003 2025-11-23T14:42:09.955Z 2025-11-30T15:06:54.354Z
8573690 8573690 20251122035434_KKRwu DK0003 2025-11-23T14:41:54.879Z 2025-11-30T15:06:35.688Z
8573060 8573060 20251122022334_dVSDT DK0003 2025-11-23T14:40:42.266Z 2025-11-30T15:06:09.021Z
8573021 8573021 20251122021727_sWE82 DK0003 2025-11-23T14:40:40.191Z 2025-11-30T15:06:08.629Z
8572842 8572842 20251122014839_dSpOL DK0003 2025-11-23T14:39:46.343Z 2025-11-30T15:06:04.536Z
8572809 8572809 20251122014519_RXRin DK0003 2025-11-23T14:39:45.205Z 2025-11-30T15:06:02.565Z
8572769 8572769 20251122014024_33yyH DK0003 2025-11-23T14:39:42.924Z 2025-11-30T15:05:57.819Z
8572648 8572648 20251122012326_VlR1o DK0003 2025-11-23T14:39:36.427Z 2025-11-30T15:05:54.485Z
8572614 8572614 20251122011949_zcQSC DK0003 2025-11-23T14:39:34.584Z 2025-11-23T14:39:34.584Z
8572526 8572526 20251122010605_tePjc DK0003 2025-11-23T14:39:30.201Z 2025-11-30T15:05:51.526Z
8572369 8572369 20251122003226_PuyKB DK0003 2025-11-23T14:39:02.806Z 2025-11-23T14:39:02.806Z
8572148 8572148 20251121234952_4WZTT DK0003 2025-11-23T14:38:03.391Z 2025-11-30T15:05:40.123Z
8572047 8572047 20251121232249_jxmHo DK0003 2025-11-23T14:37:56.562Z 2025-11-30T15:05:34.856Z
8571000 8571000 20251121182947_H3Zi2 DK0003 2025-11-23T14:35:52.478Z 2025-11-30T15:04:18.909Z
8570964 8570964 20251121181711_9pNow DK0003 2025-11-23T14:35:41.090Z 2025-11-30T15:04:12.295Z
8570881 8570881 20251121174336_zyW2j DK0003 2025-11-23T14:35:05.651Z 2025-11-30T15:03:57.293Z
8570856 8570856 20251121174110_STWOR DK0003 2025-11-23T14:35:02.417Z 2025-11-30T15:03:56.739Z
8568672 8568672 20251121053004_ABQV7 DK0003 2025-11-23T14:31:19.088Z 2025-11-29T14:54:47.190Z
8568431 8568431 20251121051924_8Lv81 DK0003 2025-11-23T14:31:07.606Z 2025-11-29T14:54:46.742Z
8568317 8568317 20251121051340_HBGnf DK0003 2025-11-23T14:31:03.745Z 2025-11-29T14:54:46.496Z
8568206 8568206 20251121050626_syGlJ DK0003 2025-11-23T14:30:58.237Z 2025-11-29T14:54:46.335Z
8567314 8567314 20251122052554_ZgwAY DK0003 2025-11-23T14:19:29.413Z 2025-11-30T15:07:02.546Z
8567270 8567270 20251122050406_g6hUy DK0003 2025-11-23T14:19:23.785Z 2025-11-30T15:06:56.442Z
8567181 8567181 20251122043126_vDODF DK0003 2025-11-23T14:19:05.222Z 2025-11-30T15:06:47.928Z
8567158 8567158 20251122042458_l3LeU DK0003 2025-11-23T14:19:02.423Z 2025-11-30T15:06:44.691Z
8567048 8567048 20251122035031_2sSd4 DK0003 2025-11-23T14:18:36.835Z 2025-11-30T15:06:34.917Z

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