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,311 rows where station_code = "DK000T" 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
9262634 9262634 20260125220802_YzgX8 DK000T 2026-01-27T14:14:31.021Z 2026-01-29T14:38:30.139Z
9244820 9244820 20260120010305_3z52T DK000T 2026-01-22T14:33:17.249Z 2026-01-28T14:58:51.485Z
9243838 9243838 20260121052432_UXCE0 DK000T 2026-01-22T14:23:20.084Z 2026-01-29T15:05:29.452Z
9243692 9243692 20260121050524_oxA35 DK000T 2026-01-22T14:22:45.496Z 2026-01-29T15:05:23.593Z
9243504 9243504 20260121044147_c7wky DK000T 2026-01-22T14:22:05.910Z 2026-01-29T15:05:15.967Z
9243419 9243419 20260121043014_uyM3C DK000T 2026-01-22T14:21:43.536Z 2026-01-29T15:05:01.595Z
9242982 9242982 20260121032429_OkQQK DK000T 2026-01-22T14:20:11.976Z 2026-01-29T15:04:41.830Z
9242965 9242965 20260121032250_dY41I DK000T 2026-01-22T14:20:08.197Z 2026-01-29T15:04:32.651Z
9242811 9242811 20260121024923_lXTnQ DK000T 2026-01-22T14:19:19.239Z 2026-01-29T15:04:21.989Z
9242762 9242762 20260121023927_Q1nTL DK000T 2026-01-22T14:19:08.784Z 2026-01-29T15:04:19.705Z
9242720 9242720 20260121023651_LP7lJ DK000T 2026-01-22T14:19:02.767Z 2026-01-29T15:04:18.223Z
9242393 9242393 20260121014415_8VE3j DK000T 2026-01-22T14:17:36.653Z 2026-01-29T15:03:56.816Z
9242175 9242175 20260121004941_ZQsf1 DK000T 2026-01-22T14:16:41.168Z 2026-01-29T15:03:34.785Z
9241964 9241964 20260120234624_THToL DK000T 2026-01-22T14:15:34.894Z 2026-01-29T15:03:15.177Z
9241929 9241929 20260120233552_Lbq30 DK000T 2026-01-22T14:15:25.292Z 2026-01-29T15:03:13.004Z
9241843 9241843 20260120230405_LRiv2 DK000T 2026-01-22T14:14:54.790Z 2026-01-29T15:03:05.611Z
9241507 9241507 20260120204909_ad20d DK000T 2026-01-22T14:13:24.533Z 2026-01-29T15:02:41.497Z
9241404 9241404 20260120202307_XI5sK DK000T 2026-01-22T14:12:57.389Z 2026-01-29T15:02:35.115Z
9241201 9241201 20260120192539_TAefL DK000T 2026-01-22T14:12:07.318Z 2026-01-29T15:02:26.507Z
9240591 9240591 20260120165602_9X1iV DK000T 2026-01-22T14:09:06.440Z 2026-01-29T15:01:31.741Z
9237648 9237648 20260120054656_T3iWT DK000T 2026-01-21T14:27:11.295Z 2026-01-28T15:01:34.426Z
9237554 9237554 20260120053522_yjViX DK000T 2026-01-21T14:26:59.777Z 2026-01-28T15:01:30.947Z
9237253 9237253 20260120045438_pQbZZ DK000T 2026-01-21T14:25:46.833Z 2026-01-28T15:01:06.058Z
9237231 9237231 20260120045244_qQWSS DK000T 2026-01-21T14:25:43.893Z 2026-01-28T15:01:04.951Z
9237175 9237175 20260120044648_V3Hhu DK000T 2026-01-21T14:25:28.159Z 2026-01-28T15:01:01.204Z
9237102 9237102 20260120043732_th0Tf DK000T 2026-01-21T14:25:16.703Z 2026-01-28T15:00:58.132Z
9237059 9237059 20260120043157_NdLhQ DK000T 2026-01-21T14:25:02.572Z 2026-01-28T15:00:55.964Z
9236866 9236866 20260120041222_FBmuI DK000T 2026-01-21T14:24:23.994Z 2026-01-28T15:00:39.879Z
9236838 9236838 20260120040515_bUSK0 DK000T 2026-01-21T14:24:19.788Z 2026-01-28T15:00:38.314Z
9236686 9236686 20260120034630_Rdyxc DK000T 2026-01-21T14:23:41.359Z 2026-01-28T15:00:29.421Z
9236678 9236678 20260120034537_mFQoe DK000T 2026-01-21T14:23:40.396Z 2026-01-28T15:00:28.896Z
9236567 9236567 20260120033400_LV8Z9 DK000T 2026-01-21T14:23:15.006Z 2026-01-28T15:00:21.135Z
9236532 9236532 20260120033113_sbp3x DK000T 2026-01-21T14:23:05.145Z 2026-01-28T15:00:07.679Z
9236364 9236364 20260120030549_PxJyv DK000T 2026-01-21T14:22:29.828Z 2026-01-28T14:59:57.194Z
9236332 9236332 20260120030131_X9lbm DK000T 2026-01-21T14:22:23.082Z 2026-01-28T14:59:55.756Z
9236068 9236068 20260120023159_s35LG DK000T 2026-01-21T14:21:21.584Z 2026-01-28T14:59:43.130Z
9235978 9235978 20260120022257_hvAZc DK000T 2026-01-21T14:21:08.066Z 2026-01-28T14:59:31.196Z
9235749 9235749 20260120015624_OLAxK DK000T 2026-01-21T14:20:08.294Z 2026-01-28T14:59:18.789Z
9235719 9235719 20260120015106_j5VS3 DK000T 2026-01-21T14:20:03.218Z 2026-01-28T14:59:17.242Z
9235320 9235320 20260120005520_FqFdd DK000T 2026-01-21T14:18:28.188Z 2026-01-28T14:58:49.148Z
9235141 9235141 20260120003541_KIoxa DK000T 2026-01-21T14:17:43.187Z 2026-01-28T14:58:32.636Z
9235018 9235018 20260120000655_meYq5 DK000T 2026-01-21T14:17:10.493Z 2026-01-28T14:58:25.092Z
9234943 9234943 20260119235345_JNMY0 DK000T 2026-01-21T14:16:47.102Z 2026-01-28T14:58:21.601Z
9234914 9234914 20260119234844_XxMl8 DK000T 2026-01-21T14:16:40.108Z 2026-01-28T14:58:20.608Z
9234900 9234900 20260119234753_bKGWA DK000T 2026-01-21T14:16:37.258Z 2026-01-28T14:58:19.565Z
9234846 9234846 20260119234014_NJTlf DK000T 2026-01-21T14:16:27.950Z 2026-01-28T14:58:16.756Z
9234836 9234836 20260119233758_LdqUH DK000T 2026-01-21T14:16:26.174Z 2026-01-28T14:58:16.114Z
9234334 9234334 20260119204919_vcOz3 DK000T 2026-01-21T14:13:44.805Z 2026-01-28T14:57:30.032Z
9234276 9234276 20260119203250_D7Mgv DK000T 2026-01-21T14:13:28.489Z 2026-01-28T14:57:26.345Z
9234250 9234250 20260119202222_ElUFn DK000T 2026-01-21T14:13:21.429Z 2026-01-28T14:57:24.814Z
9233911 9233911 20260119184428_OshS9 DK000T 2026-01-21T14:11:21.727Z 2026-01-28T14:56:52.357Z
9233833 9233833 20260119181052_cK7i4 DK000T 2026-01-21T14:10:47.584Z 2026-01-28T14:56:44.507Z
9233687 9233687 20260119165333_GLShZ DK000T 2026-01-21T14:09:48.064Z 2026-01-28T14:56:22.031Z
9231091 9231091 20260119060208_psjij DK000T 2026-01-20T14:31:11.533Z 2026-01-27T15:05:57.594Z
9231088 9231088 20260119055925_4T6HL DK000T 2026-01-20T14:31:10.953Z 2026-01-27T15:05:57.297Z
9231051 9231051 20260119055039_t7cET DK000T 2026-01-20T14:31:02.426Z 2026-01-27T15:05:54.976Z
9230999 9230999 20260119054143_KHuX3 DK000T 2026-01-20T14:30:50.898Z 2026-01-27T15:05:52.185Z
9230863 9230863 20260119051939_30iFm DK000T 2026-01-20T14:30:08.022Z 2026-01-27T15:05:33.444Z
9230792 9230792 20260119051017_MGpmD DK000T 2026-01-20T14:29:47.025Z 2026-01-27T15:05:26.825Z
9230612 9230612 20260119044004_TCNKK DK000T 2026-01-20T14:28:54.350Z 2026-01-27T15:05:16.784Z
9230528 9230528 20260119043020_Onk7Y DK000T 2026-01-20T14:28:22.942Z 2026-01-27T15:05:01.279Z
9230450 9230450 20260119042005_UryB3 DK000T 2026-01-20T14:27:55.754Z 2026-01-27T15:04:55.115Z
9230439 9230439 20260119041911_Z7tqT DK000T 2026-01-20T14:27:51.918Z 2026-01-27T15:04:54.525Z
9230434 9230434 20260119041845_9xM5O DK000T 2026-01-20T14:27:47.609Z 2026-01-27T15:04:54.351Z
9230141 9230141 20260119033334_KnLCf DK000T 2026-01-20T14:26:14.824Z 2026-01-27T15:04:29.588Z
9229879 9229879 20260119024728_h12EX DK000T 2026-01-20T14:24:44.637Z 2026-01-27T15:04:12.397Z
9229549 9229549 20260119015957_xOiXK DK000T 2026-01-20T14:23:05.948Z 2026-01-27T15:03:41.650Z
9229495 9229495 20260119015240_ufi33 DK000T 2026-01-20T14:22:48.381Z 2026-01-27T15:03:28.763Z
9229403 9229403 20260119014039_R1kgC DK000T 2026-01-20T14:22:22.661Z 2026-01-27T15:03:22.209Z
9229309 9229309 20260119012903_07Z2W DK000T 2026-01-20T14:21:56.148Z 2026-01-27T15:03:16.809Z
9229307 9229307 20260119012815_Lc2H0 DK000T 2026-01-20T14:21:55.751Z 2026-01-27T15:03:16.615Z
9229249 9229249 20260119011247_fyhep DK000T 2026-01-20T14:21:42.342Z 2026-01-27T15:03:13.756Z
9229233 9229233 20260119011111_90RZO DK000T 2026-01-20T14:21:39.061Z 2026-01-27T15:03:13.075Z
9229133 9229133 20260119005452_hKELL DK000T 2026-01-20T14:21:09.449Z 2026-01-27T15:03:04.872Z
9229027 9229027 20260119003616_aRrg5 DK000T 2026-01-20T14:20:39.043Z 2026-01-27T15:02:48.242Z
9229009 9229009 20260119003353_83PmT DK000T 2026-01-20T14:20:36.325Z 2026-01-27T15:02:47.665Z
9228988 9228988 20260119003124_52J7P DK000T 2026-01-20T14:20:30.192Z 2026-01-27T15:02:46.578Z
9228777 9228777 20260118234935_7VW2l DK000T 2026-01-20T14:19:26.544Z 2026-01-27T15:02:34.428Z
9228682 9228682 20260118233012_PQpEi DK000T 2026-01-20T14:18:57.366Z 2026-01-27T15:02:16.850Z
9228464 9228464 20260118222846_iAWDV DK000T 2026-01-20T14:17:54.769Z 2026-01-27T15:02:02.718Z
9228216 9228216 20260118204315_5lLEc DK000T 2026-01-20T14:16:41.274Z 2026-01-27T15:01:34.399Z
9227986 9227986 20260118190352_KBhfQ DK000T 2026-01-20T14:15:19.228Z 2026-01-27T15:01:09.639Z
9227774 9227774 20260118174004_v46nx DK000T 2026-01-20T14:13:56.156Z 2026-01-27T15:00:52.207Z
9227759 9227759 20260118173037_40v14 DK000T 2026-01-20T14:13:51.785Z 2026-01-27T15:00:51.537Z
9227747 9227747 20260118172205_fvKJd DK000T 2026-01-20T14:13:44.965Z 2026-01-27T15:00:50.338Z
9216399 9216399 20260111060256_ErcIE DK000T 2026-01-17T15:12:08.866Z 2026-01-19T15:18:54.107Z
9216397 9216397 20260111060037_qTTz4 DK000T 2026-01-17T15:12:08.144Z 2026-01-19T15:18:53.502Z
9216391 9216391 20260111030414_bFj8Z DK000T 2026-01-17T15:10:37.821Z 2026-01-19T15:17:47.513Z
9216380 9216380 20260110233930_SOY44 DK000T 2026-01-17T15:09:14.112Z 2026-01-19T15:16:42.909Z
9216371 9216371 20260110184741_Kt3k0 DK000T 2026-01-17T15:07:51.852Z 2026-01-19T15:15:42.200Z
9216369 9216369 20260110173334_KNkRo DK000T 2026-01-17T15:07:19.632Z 2026-01-19T15:15:13.172Z
9216365 9216365 20260110173054_YXyWX DK000T 2026-01-17T15:07:19.081Z 2026-01-19T15:15:12.937Z
9216355 9216355 20260112022324_rexyo DK000T 2026-01-17T15:00:11.297Z 2026-01-20T15:22:30.070Z
9208525 9208525 20260115055139_cGjte DK000T 2026-01-16T14:13:01.843Z 2026-01-22T15:04:32.457Z
9208462 9208462 20260115053359_JaSgA DK000T 2026-01-16T14:12:47.450Z 2026-01-22T15:04:15.108Z
9207900 9207900 20260115032955_0jFCF DK000T 2026-01-16T14:10:34.231Z 2026-01-22T15:03:56.009Z
9207416 9207416 20260115013332_3gUUb DK000T 2026-01-16T14:08:40.467Z 2026-01-22T15:03:21.352Z
9207231 9207231 20260115000323_VRn0m DK000T 2026-01-16T14:07:49.257Z 2026-01-22T15:03:15.369Z
9207082 9207082 20260114212931_o34zr DK000T 2026-01-16T14:07:01.434Z 2026-01-22T15:03:09.698Z
9207069 9207069 20260114211526_YMN1k DK000T 2026-01-16T14:06:57.714Z 2026-01-22T15:03:06.082Z

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