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

3,453 rows where station_code = "DK0007" 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
8666518 8666518 20251201060305_3pdHQ DK0007 2025-12-02T14:26:22.508Z 2025-12-06T14:42:24.616Z
8666474 8666474 20251201054510_VT2X6 DK0007 2025-12-02T14:26:17.179Z 2025-12-06T14:42:23.196Z
8666422 8666422 20251201053823_ME2xQ DK0007 2025-12-02T14:26:00.925Z 2025-12-06T14:42:21.919Z
8666398 8666398 20251201053459_DM2If DK0007 2025-12-02T14:25:57.639Z 2025-12-06T14:42:21.008Z
8666325 8666325 20251201051419_eqFaO DK0007 2025-12-02T14:25:47.169Z 2025-12-06T14:42:17.162Z
8666293 8666293 20251201050912_3tvJX DK0007 2025-12-02T14:25:43.450Z 2025-12-06T14:42:16.623Z
8666201 8666201 20251201045121_ENKTB DK0007 2025-12-02T14:25:35.631Z 2025-12-06T14:42:14.570Z
8666195 8666195 20251201045036_pB0nP DK0007 2025-12-02T14:25:35.113Z 2025-12-06T14:42:14.441Z
8666192 8666192 20251201045021_tjBLc DK0007 2025-12-02T14:25:34.902Z 2025-12-06T14:42:14.408Z
8666167 8666167 20251201044518_IAcnn DK0007 2025-12-02T14:25:32.435Z 2025-12-06T14:42:13.957Z
8666109 8666109 20251201043850_hltcO DK0007 2025-12-02T14:25:15.336Z 2025-12-06T14:42:11.889Z
8666107 8666107 20251201043820_xEDIL DK0007 2025-12-02T14:25:15.016Z 2025-12-06T14:42:11.836Z
8666070 8666070 20251201042959_zt0Ug DK0007 2025-12-02T14:25:11.483Z 2025-12-06T14:42:11.089Z
8666058 8666058 20251201042847_U5hd7 DK0007 2025-12-02T14:25:10.120Z 2025-12-06T14:42:10.816Z
8665802 8665802 20251201035946_e8Dj2 DK0007 2025-12-02T14:24:30.511Z 2025-12-06T14:42:03.807Z
8665767 8665767 20251201035652_orVxy DK0007 2025-12-02T14:24:27.115Z 2025-12-06T14:42:02.052Z
8665676 8665676 20251201035008_5qKa9 DK0007 2025-12-02T14:24:19.098Z 2025-12-06T14:41:45.692Z
8665599 8665599 20251201034142_dn65Z DK0007 2025-12-02T14:24:00.624Z 2025-12-06T14:41:41.457Z
8665588 8665588 20251201033955_6kVq2 DK0007 2025-12-02T14:23:57.322Z 2025-12-06T14:41:41.178Z
8665584 8665584 20251201033946_Og7F2 DK0007 2025-12-02T14:23:56.941Z 2025-12-06T14:41:41.091Z
8665515 8665515 20251201033054_n1CKN DK0007 2025-12-02T14:23:48.683Z 2025-12-06T14:41:39.587Z
8665310 8665310 20251201030622_rplbQ DK0007 2025-12-02T14:23:20.935Z 2025-12-06T14:41:34.075Z
8665274 8665274 20251201025854_iaN33 DK0007 2025-12-02T14:23:16.372Z 2025-12-06T14:41:31.704Z
8665164 8665164 20251201023938_feysA DK0007 2025-12-02T14:23:03.093Z 2025-12-06T14:41:28.427Z
8665125 8665125 20251201023418_RyPrU DK0007 2025-12-02T14:22:58.879Z 2025-12-06T14:41:27.632Z
8665109 8665109 20251201023153_COLx7 DK0007 2025-12-02T14:22:56.518Z 2025-12-06T14:41:27.119Z
8665093 8665093 20251201022810_o2u5r DK0007 2025-12-02T14:22:55.104Z 2025-12-06T14:41:25.951Z
8665004 8665004 20251201021612_Tp2hB DK0007 2025-12-02T14:22:35.814Z 2025-12-06T14:41:05.733Z
8664998 8664998 20251201021515_cWVUC DK0007 2025-12-02T14:22:35.045Z 2025-12-06T14:41:05.059Z
8664988 8664988 20251201021255_kr1DT DK0007 2025-12-02T14:22:33.973Z 2025-12-06T14:41:04.741Z
8664924 8664924 20251201020522_Zof7c DK0007 2025-12-02T14:22:27.852Z 2025-12-06T14:41:03.236Z
8664872 8664872 20251201015438_USLql DK0007 2025-12-02T14:22:15.455Z 2025-12-06T14:41:01.585Z
8664828 8664828 20251201014550_RTuf7 DK0007 2025-12-02T14:22:09.619Z 2025-12-06T14:40:58.997Z
8664818 8664818 20251201014433_ZMj2M DK0007 2025-12-02T14:22:08.861Z 2025-12-06T14:40:58.780Z
8664803 8664803 20251201014245_fX3Zr DK0007 2025-12-02T14:22:06.970Z 2025-12-06T14:40:58.236Z
8664789 8664789 20251201013809_CHtUp DK0007 2025-12-02T14:22:05.003Z 2025-12-06T14:40:57.680Z
8664766 8664766 20251201013504_k72vg DK0007 2025-12-02T14:22:02.654Z 2025-12-06T14:40:56.840Z
8664760 8664760 20251201013434_bPECw DK0007 2025-12-02T14:22:02.135Z 2025-12-06T14:40:56.721Z
8664728 8664728 20251201013133_bzzmr DK0007 2025-12-02T14:21:59.263Z 2025-12-06T14:40:55.906Z
8664650 8664650 20251201011757_OjBSl DK0007 2025-12-02T14:21:43.694Z 2025-12-06T14:40:53.930Z
8664641 8664641 20251201011540_pBq6t DK0007 2025-12-02T14:21:41.580Z 2025-12-06T14:40:53.547Z
8664637 8664637 20251201011514_q94jg DK0007 2025-12-02T14:21:40.891Z 2025-12-06T14:40:53.451Z
8664571 8664571 20251201005824_2CWYf DK0007 2025-12-02T14:21:24.024Z 2025-12-06T14:40:51.217Z
8663849 8663849 20251130221830_LMp2p DK0007 2025-12-02T14:19:25.342Z 2025-12-06T14:40:12.991Z
8663795 8663795 20251130220643_zSBaq DK0007 2025-12-02T14:19:11.047Z 2025-12-06T14:40:11.716Z
8663792 8663792 20251130220611_K1p2A DK0007 2025-12-02T14:19:10.349Z 2025-12-06T14:40:11.532Z
8647906 8647906 20251129060044_OO7DU DK0007 2025-11-30T14:29:22.588Z 2025-12-06T14:56:55.253Z
8647877 8647877 20251129055040_lsMUC DK0007 2025-11-30T14:29:20.412Z 2025-12-06T14:56:51.111Z
8647839 8647839 20251129054248_tWCh0 DK0007 2025-11-30T14:29:13.122Z 2025-12-06T14:56:48.959Z
8647809 8647809 20251129053548_BL3Ef DK0007 2025-11-30T14:29:00.615Z 2025-12-06T14:56:48.374Z
8647775 8647775 20251129052724_CCgyC DK0007 2025-11-30T14:28:53.069Z 2025-12-06T14:56:47.272Z
8647681 8647681 20251129050746_2qPgY DK0007 2025-11-30T14:28:44.710Z 2025-12-06T14:56:43.980Z
8647648 8647648 20251129050047_r68b2 DK0007 2025-11-30T14:28:41.257Z 2025-12-06T14:56:42.481Z
8647605 8647605 20251129045601_xviEI DK0007 2025-11-30T14:28:38.624Z 2025-12-06T14:56:41.995Z
8647540 8647540 20251129044833_hAi5F DK0007 2025-11-30T14:28:34.128Z 2025-12-06T14:56:40.878Z
8647193 8647193 20251129035937_H27Tx DK0007 2025-11-30T14:27:49.113Z 2025-12-06T14:56:33.594Z
8647158 8647158 20251129035340_kAAap DK0007 2025-11-30T14:27:45.993Z 2025-12-06T14:56:33.012Z
8647156 8647156 20251129035302_W50Nq DK0007 2025-11-30T14:27:45.813Z 2025-12-06T14:56:32.942Z
8647119 8647119 20251129034514_wVlw0 DK0007 2025-11-30T14:27:42.728Z 2025-12-06T14:56:32.356Z
8647116 8647116 20251129034500_cNsjV DK0007 2025-11-30T14:27:42.444Z 2025-12-06T14:56:32.287Z
8647055 8647055 20251129033415_6cpHO DK0007 2025-11-30T14:27:23.087Z 2025-12-06T14:56:30.994Z
8647040 8647040 20251129033050_GXxTd DK0007 2025-11-30T14:27:21.871Z 2025-12-06T14:56:30.723Z
8646901 8646901 20251129030903_ftDof DK0007 2025-11-30T14:27:06.206Z 2025-12-06T14:56:27.511Z
8646780 8646780 20251129025246_cDBR1 DK0007 2025-11-30T14:26:57.183Z 2025-12-06T14:56:25.041Z
8646712 8646712 20251129024127_9AFbd DK0007 2025-11-30T14:26:41.730Z 2025-12-06T14:56:23.834Z
8646529 8646529 20251129021610_qbmiC DK0007 2025-11-30T14:26:07.326Z 2025-12-06T14:56:12.897Z
8646508 8646508 20251129021257_P3C7d DK0007 2025-11-30T14:26:05.849Z 2025-12-06T14:56:11.548Z
8646478 8646478 20251129021006_5BJRl DK0007 2025-11-30T14:26:03.572Z 2025-12-06T14:56:09.751Z
8646469 8646469 20251129020918_i237A DK0007 2025-11-30T14:26:02.614Z 2025-12-06T14:56:09.224Z
8646442 8646442 20251129020648_vO1FZ DK0007 2025-11-30T14:25:59.711Z 2025-12-06T14:56:07.798Z
8646389 8646389 20251129015731_2K2ty DK0007 2025-11-30T14:25:55.995Z 2025-12-06T14:56:03.880Z
8646362 8646362 20251129015255_qV4QD DK0007 2025-11-30T14:25:53.832Z 2025-12-06T14:56:01.940Z
8646355 8646355 20251129015031_ehSwa DK0007 2025-11-30T14:25:53.340Z 2025-12-06T14:56:01.737Z
8646278 8646278 20251129013925_76rsm DK0007 2025-11-30T14:25:46.985Z 2025-12-06T14:55:55.172Z
8646273 8646273 20251129013814_RnMKf DK0007 2025-11-30T14:25:46.581Z 2025-12-06T14:55:54.571Z
8645881 8645881 20251129001443_LZK52 DK0007 2025-11-30T14:24:39.885Z 2025-12-06T14:55:13.366Z
8622993 8622993 20251126222453_tY1Xg DK0007 2025-11-28T14:20:26.347Z 2025-12-05T15:03:24.641Z
8622920 8622920 20251126220605_FjS21 DK0007 2025-11-28T14:20:18.752Z 2025-12-05T15:03:19.952Z
8622884 8622884 20251126215835_Rsjba DK0007 2025-11-28T14:20:15.609Z 2025-12-05T15:03:17.440Z
8622852 8622852 20251126215026_BVucN DK0007 2025-11-28T14:20:11.378Z 2025-12-05T15:03:16.623Z
8622821 8622821 20251126214032_mQb8j DK0007 2025-11-28T14:20:08.066Z 2025-12-05T15:03:15.354Z
8622811 8622811 20251126213607_9TCoT DK0007 2025-11-28T14:20:03.981Z 2025-12-05T15:03:14.165Z
8622807 8622807 20251126213530_IfzDg DK0007 2025-11-28T14:19:55.479Z 2025-12-05T15:03:11.726Z
8622719 8622719 20251126205059_iSK18 DK0007 2025-11-28T14:19:44.403Z 2025-12-05T15:03:05.453Z
8622709 8622709 20251126204952_jd86c DK0007 2025-11-28T14:19:43.875Z 2025-12-05T15:03:05.375Z
8622673 8622673 20251126204052_9i4pM DK0007 2025-11-28T14:19:40.557Z 2025-12-05T15:03:04.872Z
8622670 8622670 20251126203610_DTVih DK0007 2025-11-28T14:19:40.229Z 2025-12-05T15:03:04.807Z
8622654 8622654 20251126203140_YYxSW DK0007 2025-11-28T14:19:38.452Z 2025-12-05T15:03:04.643Z
8622641 8622641 20251126202814_678MZ DK0007 2025-11-28T14:19:36.916Z 2025-12-05T15:03:04.508Z
8622628 8622628 20251126202234_bZpzG DK0007 2025-11-28T14:19:35.290Z 2025-12-05T15:03:04.288Z
8622626 8622626 20251126202141_HpN8x DK0007 2025-11-28T14:19:35.005Z 2025-12-05T15:03:04.214Z
8622618 8622618 20251126201701_TqhPN DK0007 2025-11-28T14:19:34.374Z 2025-12-05T15:03:04.150Z
8622597 8622597 20251126201415_IdoXl DK0007 2025-11-28T14:19:27.744Z 2025-12-05T15:03:03.922Z
8622566 8622566 20251126200005_nQHGs DK0007 2025-11-28T14:19:23.826Z 2025-12-05T15:03:03.598Z
8622553 8622553 20251126195451_QQ9Fj DK0007 2025-11-28T14:19:21.194Z 2025-12-05T15:03:03.447Z
8622439 8622439 20251126192138_adIMe DK0007 2025-11-28T14:18:52.652Z 2025-12-05T15:02:56.937Z
8622347 8622347 20251126185342_B6WZ2 DK0007 2025-11-28T14:18:28.850Z 2025-12-05T15:02:55.675Z
8622295 8622295 20251126183733_XO6Wo DK0007 2025-11-28T14:18:20.113Z 2025-12-05T15:02:55.011Z
8622138 8622138 20251126175858_Qvm2e DK0007 2025-11-28T14:17:48.477Z 2025-12-05T15:02:52.724Z
8621800 8621800 20251126162748_e636E DK0007 2025-11-28T14:16:38.608Z 2025-12-05T15:02:48.007Z

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