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

1,798 rows where station_code = "DK0006" 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
8666092 8666092 20251201043527_3Y05f DK0006 2025-12-02T14:25:13.084Z 2025-12-06T14:42:11.450Z
8665949 8665949 20251201041220_pCVGl DK0006 2025-12-02T14:24:57.759Z 2025-12-06T14:42:07.437Z
8665891 8665891 20251201040626_AhZpi DK0006 2025-12-02T14:24:44.334Z 2025-12-06T14:42:06.172Z
8665655 8665655 20251201034746_dvu6Q DK0006 2025-12-02T14:24:16.711Z 2025-12-06T14:41:44.831Z
8665623 8665623 20251201034418_L5YZ2 DK0006 2025-12-02T14:24:13.447Z 2025-12-06T14:41:42.204Z
8665288 8665288 20251201030127_mkTDy DK0006 2025-12-02T14:23:17.743Z 2025-12-06T14:41:32.833Z
8665251 8665251 20251201025202_QjEPk DK0006 2025-12-02T14:23:12.255Z 2025-12-06T14:41:30.537Z
8665212 8665212 20251201024748_x6pRt DK0006 2025-12-02T14:23:08.307Z 2025-12-06T14:41:29.518Z
8665078 8665078 20251201022621_KcRNr DK0006 2025-12-02T14:22:53.298Z 2025-12-06T14:41:25.085Z
8665067 8665067 20251201022334_dIUbZ DK0006 2025-12-02T14:22:44.496Z 2025-12-06T14:41:24.412Z
8665063 8665063 20251201022240_Ew2cY DK0006 2025-12-02T14:22:44.258Z 2025-12-06T14:41:21.920Z
8665054 8665054 20251201022129_3VkdN DK0006 2025-12-02T14:22:43.197Z 2025-12-06T14:41:16.725Z
8664927 8664927 20251201020525_iiVlQ DK0006 2025-12-02T14:22:28.044Z 2025-12-06T14:41:03.280Z
8664912 8664912 20251201020317_FLbwK DK0006 2025-12-02T14:22:26.212Z 2025-12-06T14:41:02.803Z
8664824 8664824 20251201014542_IC7VD DK0006 2025-12-02T14:22:09.120Z 2025-12-06T14:40:58.936Z
8664188 8664188 20251130233734_wmEky DK0006 2025-12-02T14:20:17.607Z 2025-12-06T14:40:41.134Z
8647872 8647872 20251129054934_oXVFg DK0006 2025-11-30T14:29:20.050Z 2025-12-06T14:56:50.796Z
8647639 8647639 20251129045950_PWSBs DK0006 2025-11-30T14:28:40.706Z 2025-12-06T14:56:42.385Z
8646887 8646887 20251129030700_8pKcO DK0006 2025-11-30T14:27:04.889Z 2025-12-06T14:56:27.174Z
8646768 8646768 20251129025152_g9MyJ DK0006 2025-11-30T14:26:56.157Z 2025-12-06T14:56:24.870Z
8646206 8646206 20251129012412_zd8xh DK0006 2025-11-30T14:25:25.097Z 2025-12-06T14:55:44.850Z
8646072 8646072 20251129005801_QdH3P DK0006 2025-11-30T14:25:08.627Z 2025-12-06T14:55:29.432Z
8645613 8645613 20251128230522_yMyaC DK0006 2025-11-30T14:24:16.944Z 2025-12-06T14:55:00.981Z
8625783 8625783 20251126051807_kgvZ3 DK0006 2025-11-28T14:36:30.292Z 2025-12-04T15:11:32.066Z
8625682 8625682 20251126041449_vwFbQ DK0006 2025-11-28T14:36:06.129Z 2025-12-04T15:10:45.089Z
8622543 8622543 20251126195112_jYG1O DK0006 2025-11-28T14:19:08.274Z 2025-12-05T15:03:03.216Z
8622521 8622521 20251126194231_Kkgga DK0006 2025-11-28T14:19:04.673Z 2025-12-05T15:03:02.868Z
8622397 8622397 20251126190307_O82RK DK0006 2025-11-28T14:18:47.102Z 2025-12-05T15:02:56.387Z
8622356 8622356 20251126185529_i4SUQ DK0006 2025-11-28T14:18:30.470Z 2025-12-05T15:02:55.825Z
8616092 8616092 20251126053821_8t6J6 DK0006 2025-11-27T14:30:30.030Z 2025-12-04T15:11:35.613Z
8614333 8614333 20251126040556_FtzW1 DK0006 2025-11-27T14:27:47.470Z 2025-12-04T15:10:37.170Z
8612536 8612536 20251126023539_Am2NY DK0006 2025-11-27T14:24:18.795Z 2025-12-04T15:09:31.479Z
8612022 8612022 20251126021425_JAFz8 DK0006 2025-11-27T14:23:14.731Z 2025-12-04T15:09:26.925Z
8611881 8611881 20251126020530_T92ti DK0006 2025-11-27T14:23:01.109Z 2025-12-04T15:09:25.129Z
8611465 8611465 20251126014506_7JoYA DK0006 2025-11-27T14:22:10.691Z 2025-12-04T15:09:21.186Z
8574247 8574247 20251122053612_ZZkgQ DK0006 2025-11-23T14:43:02.336Z 2025-11-30T15:07:03.666Z
8574229 8574229 20251122053310_rgINe DK0006 2025-11-23T14:42:58.022Z 2025-11-30T15:07:03.226Z
8574180 8574180 20251122052203_NImgq DK0006 2025-11-23T14:42:43.708Z 2025-11-30T15:07:01.626Z
8574090 8574090 20251122050731_BXa82 DK0006 2025-11-23T14:42:16.599Z 2025-11-30T15:06:58.368Z
8574086 8574086 20251122050711_h6e2W DK0006 2025-11-23T14:42:16.261Z 2025-11-30T15:06:58.203Z
8574080 8574080 20251122050550_cw8GU DK0006 2025-11-23T14:42:15.307Z 2025-11-30T15:06:56.765Z
8573367 8573367 20251122030121_vz1u0 DK0006 2025-11-23T14:41:08.361Z 2025-11-30T15:06:19.457Z
8573307 8573307 20251122025520_2MqYJ DK0006 2025-11-23T14:41:05.563Z 2025-11-30T15:06:15.704Z
8573023 8573023 20251122021727_sWE82 DK0006 2025-11-23T14:40:40.191Z 2025-11-30T15:06:08.629Z
8572983 8572983 20251122021321_29thu DK0006 2025-11-23T14:40:30.715Z 2025-11-30T15:06:07.941Z
8572843 8572843 20251122014839_dSpOL DK0006 2025-11-23T14:39:46.343Z 2025-11-30T15:06:04.536Z
8572811 8572811 20251122014519_RXRin DK0006 2025-11-23T14:39:45.205Z 2025-11-30T15:06:02.565Z
8572651 8572651 20251122012344_29a45 DK0006 2025-11-23T14:39:36.681Z 2025-11-30T15:05:54.621Z
8572168 8572168 20251121235326_kcu9O DK0006 2025-11-23T14:38:04.232Z 2025-11-30T15:05:40.534Z
8572150 8572150 20251121234952_4WZTT DK0006 2025-11-23T14:38:03.391Z 2025-11-30T15:05:40.124Z
8572120 8572120 20251121234307_2K5hx DK0006 2025-11-23T14:38:01.748Z 2025-11-30T15:05:38.307Z
8571920 8571920 20251121225141_Q4VR1 DK0006 2025-11-23T14:37:50.048Z 2025-11-30T15:05:25.752Z
8571862 8571862 20251121223338_OAqAj DK0006 2025-11-23T14:37:47.310Z 2025-11-30T15:05:21.202Z
8571830 8571830 20251121221610_qu6FR DK0006 2025-11-23T14:37:45.680Z 2025-11-30T15:05:19.788Z
8571649 8571649 20251121214114_1UToW DK0006 2025-11-23T14:37:24.183Z 2025-11-30T15:05:11.712Z
8571393 8571393 20251121203209_3GHuB DK0006 2025-11-23T14:36:15.166Z 2025-11-30T15:05:02.985Z
8571243 8571243 20251121195221_Fm2rb DK0006 2025-11-23T14:36:06.323Z 2025-11-30T15:04:43.124Z
8571144 8571144 20251121192300_MRfxk DK0006 2025-11-23T14:36:00.198Z 2025-11-30T15:04:30.008Z
8571054 8571054 20251121184356_J5WfK DK0006 2025-11-23T14:35:55.428Z 2025-11-30T15:04:24.919Z
8570965 8570965 20251121181711_9pNow DK0006 2025-11-23T14:35:41.090Z 2025-11-30T15:04:12.295Z
8570858 8570858 20251121174110_STWOR DK0006 2025-11-23T14:35:02.417Z 2025-11-30T15:03:56.739Z
8569357 8569357 20251121055430_roBak DK0006 2025-11-23T14:32:12.164Z 2025-11-29T14:54:48.185Z
8569139 8569139 20251121054638_WZVlj DK0006 2025-11-23T14:31:55.459Z 2025-11-29T14:54:47.833Z
8569055 8569055 20251121054418_LTfwg DK0006 2025-11-23T14:31:52.689Z 2025-11-29T14:54:47.726Z
8568433 8568433 20251121051924_8Lv81 DK0006 2025-11-23T14:31:07.606Z 2025-11-29T14:54:46.742Z
8568210 8568210 20251121050635_ae8Xd DK0006 2025-11-23T14:30:58.479Z 2025-11-29T14:54:46.378Z
8568207 8568207 20251121050626_syGlJ DK0006 2025-11-23T14:30:58.237Z 2025-11-29T14:54:46.335Z
8560466 8560466 20251121045647_c38zJ DK0006 2025-11-22T14:42:52.988Z 2025-11-22T14:42:52.988Z
8560455 8560455 20251121045533_C9HHx DK0006 2025-11-22T14:42:52.802Z 2025-11-29T14:54:45.764Z
8560272 8560272 20251121044832_Ca3BY DK0006 2025-11-22T14:42:48.717Z 2025-11-29T14:54:45.501Z
8560119 8560119 20251121044223_iUElQ DK0006 2025-11-22T14:42:19.102Z 2025-11-29T14:54:45.054Z
8560009 8560009 20251121043458_GPVRJ DK0006 2025-11-22T14:42:09.456Z 2025-11-29T14:54:44.895Z
8559950 8559950 20251121043150_i2Nxn DK0006 2025-11-22T14:42:07.729Z 2025-11-29T14:54:44.752Z
8559703 8559703 20251121042253_j5pAy DK0006 2025-11-22T14:42:01.962Z 2025-11-29T14:54:43.315Z
8559625 8559625 20251121041920_uJlG8 DK0006 2025-11-22T14:42:00.177Z 2025-11-29T14:54:43.148Z
8559614 8559614 20251121041854_bLh9V DK0006 2025-11-22T14:41:59.924Z 2025-11-29T14:54:43.135Z
8559611 8559611 20251121041846_CHN7y DK0006 2025-11-22T14:41:59.727Z 2025-11-29T14:54:43.133Z
8559583 8559583 20251121041802_w4J6c DK0006 2025-11-22T14:41:59.265Z 2025-11-29T14:54:40.777Z
8559541 8559541 20251121041640_49gaK DK0006 2025-11-22T14:41:58.133Z 2025-11-29T14:54:40.741Z
8559514 8559514 20251121041447_4yGhB DK0006 2025-11-22T14:41:57.353Z 2025-11-29T14:54:39.306Z
8559450 8559450 20251121041131_r5hE5 DK0006 2025-11-22T14:41:56.122Z 2025-11-29T14:54:39.117Z
8559442 8559442 20251121041058_lG1Pq DK0006 2025-11-22T14:41:55.828Z 2025-11-29T14:54:38.562Z
8559281 8559281 20251121040325_JTnxs DK0006 2025-11-22T14:41:51.557Z 2025-11-29T14:54:37.758Z
8559197 8559197 20251121035817_TUEJN DK0006 2025-11-22T14:41:49.694Z 2025-11-29T14:54:37.561Z
8558623 8558623 20251121033511_iCvYC DK0006 2025-11-22T14:41:08.836Z 2025-11-29T14:54:36.391Z
8558618 8558618 20251121033455_kSXSP DK0006 2025-11-22T14:41:08.464Z 2025-11-29T14:54:36.370Z
8558360 8558360 20251121032625_dwagU DK0006 2025-11-22T14:41:03.918Z 2025-11-29T14:54:35.967Z
8558318 8558318 20251121032312_oxkTs DK0006 2025-11-22T14:41:03.245Z 2025-11-29T14:54:35.885Z
8558261 8558261 20251121032123_SRyfl DK0006 2025-11-22T14:41:01.775Z 2025-11-29T14:54:35.709Z
8557839 8557839 20251121030537_3JJMr DK0006 2025-11-22T14:40:50.159Z 2025-11-29T14:54:34.768Z
8557801 8557801 20251121030156_0xxeQ DK0006 2025-11-22T14:40:40.257Z 2025-11-29T14:54:34.743Z
8557775 8557775 20251121030007_uFB3b DK0006 2025-11-22T14:40:39.429Z 2025-11-29T14:54:34.700Z
8557636 8557636 20251121025452_3K5lR DK0006 2025-11-22T14:40:25.704Z 2025-11-29T14:54:34.415Z
8557527 8557527 20251121025121_pigct DK0006 2025-11-22T14:40:19.067Z 2025-11-29T14:54:34.358Z
8557392 8557392 20251121024809_4JBTo DK0006 2025-11-22T14:40:03.989Z 2025-11-29T14:54:34.122Z
8557280 8557280 20251121024243_MtDy9 DK0006 2025-11-22T14:39:55.927Z 2025-11-29T14:54:33.675Z
8557228 8557228 20251121024002_EVwYB DK0006 2025-11-22T14:39:54.437Z 2025-11-29T14:54:33.612Z
8557125 8557125 20251121023421_8rRSa DK0006 2025-11-22T14:39:52.397Z 2025-11-29T14:54:33.500Z
8556903 8556903 20251121022009_7ZstU DK0006 2025-11-22T14:39:46.589Z 2025-11-29T14:54:33.143Z
8556484 8556484 20251121015632_hvIbf DK0006 2025-11-22T14:39:34.429Z 2025-11-29T14:54:32.399Z

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