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

2,784 rows where station_code = "DK0004" 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
9606718 9606718 20260402193106_MLMse DK0004 2026-04-04T12:11:10.930Z 2026-04-06T12:23:32.922Z
9604684 9604684 20260401234409_HcrBp DK0004 2026-04-03T12:11:13.387Z 2026-04-06T12:26:11.515Z
9604614 9604614 20260401222315_qUVuR DK0004 2026-04-03T12:10:52.534Z 2026-04-06T12:26:07.075Z
9604613 9604613 20260401222307_hynnJ DK0004 2026-04-03T12:10:52.016Z 2026-04-06T12:26:06.868Z
9602602 9602602 20260401001147_emmEg DK0004 2026-04-02T12:09:30.596Z 2026-04-06T12:29:25.566Z
9602516 9602516 20260331222352_ROnQh DK0004 2026-04-02T12:09:10.549Z 2026-04-06T12:29:16.273Z
9602501 9602501 20260331220112_Fa7S3 DK0004 2026-04-02T12:09:06.394Z 2026-04-06T12:29:15.046Z
9594974 9594974 20260329011205_4WBdi DK0004 2026-03-30T12:10:42.737Z 2026-04-06T12:40:22.083Z
9594813 9594813 20260329003506_70Tye DK0004 2026-03-30T12:10:22.079Z 2026-04-06T12:40:16.718Z
9594279 9594279 20260328205910_wuqxp DK0004 2026-03-30T12:09:11.966Z 2026-04-06T12:39:46.268Z
9588658 9588658 20260327002005_MSN7c DK0004 2026-03-28T12:11:33.171Z 2026-04-04T12:42:25.107Z
9588622 9588622 20260327000917_2UGQS DK0004 2026-03-28T12:11:28.763Z 2026-04-04T12:42:22.284Z
9585986 9585986 20260327032511_sjB2M DK0004 2026-03-28T12:01:55.436Z 2026-04-05T12:32:55.719Z
9585970 9585970 20260327032133_JZlyt DK0004 2026-03-28T12:01:53.758Z 2026-04-05T12:32:55.243Z
9585911 9585911 20260327030823_Qt3FV DK0004 2026-03-28T12:01:43.640Z 2026-04-05T12:32:52.498Z
9585900 9585900 20260327030325_yU7nS DK0004 2026-03-28T12:01:40.794Z 2026-04-05T12:32:51.968Z
9585619 9585619 20260327015754_4G5RV DK0004 2026-03-28T12:00:49.032Z 2026-04-05T12:32:30.744Z
9585596 9585596 20260327015112_R2YCa DK0004 2026-03-28T12:00:45.347Z 2026-04-05T12:32:29.638Z
9585475 9585475 20260327011230_ZvHFB DK0004 2026-03-28T12:00:28.742Z 2026-04-05T12:32:23.416Z
9571070 9571070 20260322234303_k3ij3 DK0004 2026-03-24T12:24:18.325Z 2026-03-30T12:30:54.737Z
9570982 9570982 20260322232634_3j1zc DK0004 2026-03-24T12:24:07.294Z 2026-03-30T12:30:53.246Z
9570867 9570867 20260322230312_U8N1c DK0004 2026-03-24T12:23:56.967Z 2026-03-30T12:30:50.797Z
9570820 9570820 20260322225540_sv5yS DK0004 2026-03-24T12:23:51.945Z 2026-03-30T12:30:49.966Z
9570778 9570778 20260322224440_PXRMv DK0004 2026-03-24T12:23:48.324Z 2026-03-30T12:30:49.230Z
9570482 9570482 20260322213832_wKA23 DK0004 2026-03-24T12:23:21.071Z 2026-03-30T12:30:44.006Z
9570381 9570381 20260322205646_TTIR4 DK0004 2026-03-24T12:23:07.287Z 2026-03-30T12:30:41.390Z
9570376 9570376 20260322205640_Zn3Az DK0004 2026-03-24T12:23:06.984Z 2026-03-30T12:30:41.325Z
9570322 9570322 20260322203509_DmkRM DK0004 2026-03-24T12:23:00.196Z 2026-03-30T12:30:39.890Z
9570228 9570228 20260322200711_ncsTP DK0004 2026-03-24T12:22:50.390Z 2026-03-30T12:30:37.492Z
9570115 9570115 20260322191606_yMMB7 DK0004 2026-03-24T12:22:36.348Z 2026-03-30T12:30:27.964Z
9570056 9570056 20260322190329_eCu40 DK0004 2026-03-24T12:22:31.743Z 2026-03-30T12:30:27.110Z
9570022 9570022 20260322185503_xfyg3 DK0004 2026-03-24T12:22:28.781Z 2026-03-30T12:30:26.529Z
9562921 9562921 20260323034841_bbwnG DK0004 2026-03-24T12:04:26.858Z 2026-03-31T12:26:29.376Z
9562246 9562246 20260323015325_NYoeL DK0004 2026-03-24T12:02:35.163Z 2026-03-31T12:26:05.061Z
9562228 9562228 20260323015143_kEovB DK0004 2026-03-24T12:02:31.639Z 2026-03-31T12:26:04.467Z
9562030 9562030 20260323011901_wUsGG DK0004 2026-03-24T12:01:58.139Z 2026-03-31T12:25:59.871Z
9562016 9562016 20260323011608_DzI24 DK0004 2026-03-24T12:01:54.961Z 2026-03-31T12:25:59.477Z
9561896 9561896 20260323005329_1VwTj DK0004 2026-03-24T12:01:33.134Z 2026-03-31T12:25:55.947Z
9561759 9561759 20260323003857_XvRTW DK0004 2026-03-24T12:01:12.625Z 2026-03-31T12:25:53.003Z
9561579 9561579 20260323000612_mErR8 DK0004 2026-03-24T12:00:31.858Z 2026-03-31T12:25:47.521Z
9561076 9561076 20260321225414_3E9Mp DK0004 2026-03-23T12:12:11.215Z 2026-03-29T12:21:05.078Z
9560177 9560177 20260321204024_Qh9Fd DK0004 2026-03-23T12:11:39.516Z 2026-03-29T12:20:58.380Z
9559988 9559988 20260321201845_EgGQz DK0004 2026-03-23T12:11:35.756Z 2026-03-29T12:20:57.219Z
9559648 9559648 20260321185620_SqAnC DK0004 2026-03-23T12:11:20.146Z 2026-03-29T12:20:42.314Z
9559638 9559638 20260321185537_OBXBM DK0004 2026-03-23T12:11:17.099Z 2026-03-29T12:20:42.281Z
9554953 9554953 20260322034640_QGSRU DK0004 2026-03-23T12:02:58.504Z 2026-03-30T12:28:11.999Z
9554915 9554915 20260322034507_7Exar DK0004 2026-03-23T12:02:56.526Z 2026-03-30T12:28:11.519Z
9554592 9554592 20260322031921_WjMOZ DK0004 2026-03-23T12:02:42.322Z 2026-03-30T12:28:06.093Z
9554303 9554303 20260322025655_LbmpG DK0004 2026-03-23T12:02:25.424Z 2026-03-30T12:28:02.023Z
9554211 9554211 20260322024952_Enf5j DK0004 2026-03-23T12:02:20.542Z 2026-03-30T12:28:00.590Z
9553978 9553978 20260322022950_c38nA DK0004 2026-03-23T12:02:04.700Z 2026-03-30T12:27:56.343Z
9553883 9553883 20260322022304_RvRrE DK0004 2026-03-23T12:01:57.343Z 2026-03-30T12:27:54.120Z
9553866 9553866 20260322022142_0tLrw DK0004 2026-03-23T12:01:56.385Z 2026-03-30T12:27:53.842Z
9553375 9553375 20260322013457_8CHUQ DK0004 2026-03-23T12:01:26.149Z 2026-03-30T12:27:40.001Z
9553368 9553368 20260322013333_eILk9 DK0004 2026-03-23T12:01:25.604Z 2026-03-30T12:27:39.771Z
9553042 9553042 20260322010714_HEviP DK0004 2026-03-23T12:01:10.417Z 2026-03-30T12:27:34.017Z
9552912 9552912 20260322005428_tSOJm DK0004 2026-03-23T12:00:59.863Z 2026-03-30T12:27:32.174Z
9552586 9552586 20260322002300_RjfI1 DK0004 2026-03-23T12:00:36.036Z 2026-03-30T12:27:26.601Z
9552523 9552523 20260322001558_5gbzJ DK0004 2026-03-23T12:00:30.156Z 2026-03-30T12:27:25.473Z
9552407 9552407 20260322000357_3z3kt DK0004 2026-03-23T12:00:22.091Z 2026-03-30T12:27:23.564Z
9542153 9542153 20260319225424_kAo6d DK0004 2026-03-21T12:29:45.136Z 2026-03-27T12:42:46.035Z
9542123 9542123 20260319224835_2NodU DK0004 2026-03-21T12:29:40.670Z 2026-03-27T12:42:45.265Z
9542069 9542069 20260319224702_OUKv1 DK0004 2026-03-21T12:29:38.937Z 2026-03-27T12:42:44.981Z
9541941 9541941 20260319220753_yXWFd DK0004 2026-03-21T12:29:30.126Z 2026-03-27T12:42:43.043Z
9541384 9541384 20260319202839_RMSBH DK0004 2026-03-21T12:28:53.157Z 2026-03-27T12:42:37.110Z
9534111 9534111 20260320032523_fAgso DK0004 2026-03-21T12:07:09.822Z 2026-03-28T12:34:13.904Z
9533798 9533798 20260320025941_gBSdP DK0004 2026-03-21T12:06:19.618Z 2026-03-28T12:34:00.726Z
9530869 9530869 20260318215501_tOm2P DK0004 2026-03-20T12:24:50.116Z 2026-03-26T12:39:16.302Z
9530687 9530687 20260318212535_kF2s6 DK0004 2026-03-20T12:24:35.793Z 2026-03-26T12:39:14.807Z
9530326 9530326 20260318203914_20Au9 DK0004 2026-03-20T12:24:18.406Z 2026-03-26T12:39:11.360Z
9530268 9530268 20260318203407_JNcKL DK0004 2026-03-20T12:24:16.059Z 2026-03-26T12:39:10.902Z
9530179 9530179 20260318202012_xaKrW DK0004 2026-03-20T12:24:05.204Z 2026-03-26T12:39:10.104Z
9530158 9530158 20260318201845_Qejrv DK0004 2026-03-20T12:24:04.442Z 2026-03-26T12:39:09.941Z
9530129 9530129 20260318201217_2sjJP DK0004 2026-03-20T12:24:02.199Z 2026-03-26T12:39:09.517Z
9530027 9530027 20260318195609_AFHEK DK0004 2026-03-20T12:23:55.320Z 2026-03-26T12:39:08.464Z
9529849 9529849 20260318193734_87efm DK0004 2026-03-20T12:23:46.347Z 2026-03-26T12:39:07.019Z
9529572 9529572 20260318185520_4QjoK DK0004 2026-03-20T12:23:19.388Z 2026-03-26T12:39:04.489Z
9521286 9521286 20260319040254_a0y2m DK0004 2026-03-20T12:07:48.425Z 2026-03-27T12:40:53.498Z
9520859 9520859 20260319034158_2Lgyi DK0004 2026-03-20T12:07:05.832Z 2026-03-27T12:40:48.229Z
9520681 9520681 20260319033127_l7iG6 DK0004 2026-03-20T12:06:47.770Z 2026-03-27T12:40:46.256Z
9519596 9519596 20260319022025_Q0lzH DK0004 2026-03-20T12:04:42.498Z 2026-03-27T12:40:32.944Z
9519226 9519226 20260319015536_uaAzN DK0004 2026-03-20T12:04:07.348Z 2026-03-27T12:40:19.194Z
9519084 9519084 20260319014636_I3REc DK0004 2026-03-20T12:03:52.876Z 2026-03-27T12:40:17.960Z
9518389 9518389 20260319005531_e9w9k DK0004 2026-03-20T12:02:26.114Z 2026-03-27T12:40:09.122Z
9518303 9518303 20260319004750_a5o4L DK0004 2026-03-20T12:02:16.891Z 2026-03-27T12:40:08.273Z
9518051 9518051 20260319002606_f3F1l DK0004 2026-03-20T12:01:49.837Z 2026-03-27T12:40:06.031Z
9517967 9517967 20260319001618_QQkWO DK0004 2026-03-20T12:01:37.600Z 2026-03-27T12:40:05.018Z
9517827 9517827 20260319000550_r5MJ3 DK0004 2026-03-20T12:01:22.185Z 2026-03-27T12:40:03.780Z
9517778 9517778 20260319000126_129lT DK0004 2026-03-20T12:01:14.712Z 2026-03-27T12:40:03.175Z
9517756 9517756 20260319000052_LsrLk DK0004 2026-03-20T12:01:12.817Z 2026-03-27T12:40:03.021Z
9517537 9517537 20260318233716_BtPsP DK0004 2026-03-20T12:00:40.083Z 2026-03-27T12:40:00.724Z
9517516 9517516 20260318233527_itXUP DK0004 2026-03-20T12:00:36.010Z 2026-03-27T12:40:00.457Z
9517192 9517192 20260317225223_syYj5 DK0004 2026-03-19T12:27:18.166Z 2026-03-25T12:43:09.194Z
9517095 9517095 20260317224137_kjnVD DK0004 2026-03-19T12:27:10.733Z 2026-03-25T12:43:08.665Z
9517091 9517091 20260317224137_LSGdr DK0004 2026-03-19T12:27:10.390Z 2026-03-25T12:43:08.567Z
9516860 9516860 20260317220657_spVHz DK0004 2026-03-19T12:26:51.441Z 2026-03-25T12:43:07.379Z
9516785 9516785 20260317215755_kT0N1 DK0004 2026-03-19T12:26:47.137Z 2026-03-25T12:43:06.930Z
9516252 9516252 20260317202034_Hk3dA DK0004 2026-03-19T12:25:50.270Z 2026-03-25T12:42:52.259Z
9516250 9516250 20260317202034_hOW45 DK0004 2026-03-19T12:25:49.946Z 2026-03-25T12:42:52.072Z
9511368 9511368 20260318034801_kleM0 DK0004 2026-03-19T12:10:02.754Z 2026-03-26T12:37:36.390Z

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