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,657 rows where station_code = "DK0002" 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
9262823 9262823 20260126032808_swjz1 DK0002 2026-01-27T14:15:35.155Z 2026-01-29T14:38:50.761Z
9262771 9262771 20260126022909_8Zi3o DK0002 2026-01-27T14:15:14.093Z 2026-01-29T14:38:45.917Z
9262725 9262725 20260126013954_XIZDf DK0002 2026-01-27T14:15:02.206Z 2026-01-29T14:38:39.354Z
9237663 9237663 20260120054905_c23uz DK0002 2026-01-21T14:27:15.872Z 2026-01-28T15:01:35.330Z
9237511 9237511 20260120052657_Cf6OZ DK0002 2026-01-21T14:26:50.405Z 2026-01-28T15:01:29.023Z
9237435 9237435 20260120051806_qoMIT DK0002 2026-01-21T14:26:30.385Z 2026-01-28T15:01:25.634Z
9237304 9237304 20260120050104_KeMs6 DK0002 2026-01-21T14:25:53.378Z 2026-01-28T15:01:08.686Z
9237165 9237165 20260120044530_1zBTS DK0002 2026-01-21T14:25:25.530Z 2026-01-28T15:01:00.998Z
9237134 9237134 20260120044115_k0l1l DK0002 2026-01-21T14:25:20.758Z 2026-01-28T15:00:59.449Z
9237093 9237093 20260120043616_f9QhS DK0002 2026-01-21T14:25:16.149Z 2026-01-28T15:00:57.909Z
9236852 9236852 20260120040652_OyyAB DK0002 2026-01-21T14:24:22.031Z 2026-01-28T15:00:39.207Z
9236827 9236827 20260120040434_t2dEh DK0002 2026-01-21T14:24:19.014Z 2026-01-28T15:00:38.080Z
9236798 9236798 20260120040008_GvR6O DK0002 2026-01-21T14:24:14.869Z 2026-01-28T15:00:36.646Z
9236428 9236428 20260120031511_ErwII DK0002 2026-01-21T14:22:47.795Z 2026-01-28T14:59:59.682Z
9235886 9235886 20260120021430_LeEYR DK0002 2026-01-21T14:20:39.862Z 2026-01-28T14:59:26.090Z
9235057 9235057 20260120002044_U8M3d DK0002 2026-01-21T14:17:19.915Z 2026-01-28T14:58:27.297Z
9235043 9235043 20260120001743_lns2e DK0002 2026-01-21T14:17:16.428Z 2026-01-28T14:58:26.422Z
9234546 9234546 20260119221552_2RX2r DK0002 2026-01-21T14:15:06.132Z 2026-01-28T14:57:53.386Z
9234268 9234268 20260119203215_rBetM DK0002 2026-01-21T14:13:27.939Z 2026-01-28T14:57:26.242Z
9234010 9234010 20260119191322_3otbH DK0002 2026-01-21T14:11:51.797Z 2026-01-28T14:56:58.397Z
9233811 9233811 20260119180413_YeJ8c DK0002 2026-01-21T14:10:43.189Z 2026-01-28T14:56:43.256Z
9231066 9231066 20260119055244_9jd2i DK0002 2026-01-20T14:31:05.939Z 2026-01-27T15:05:56.138Z
9231045 9231045 20260119055010_DN5kY DK0002 2026-01-20T14:31:01.230Z 2026-01-27T15:05:54.696Z
9230975 9230975 20260119053637_3JdMr DK0002 2026-01-20T14:30:40.674Z 2026-01-27T15:05:50.928Z
9230936 9230936 20260119053056_ePLUo DK0002 2026-01-20T14:30:31.927Z 2026-01-27T15:05:37.532Z
9230830 9230830 20260119051604_29mfF DK0002 2026-01-20T14:30:00.069Z 2026-01-27T15:05:29.350Z
9230422 9230422 20260119041706_L6ZcV DK0002 2026-01-20T14:27:44.968Z 2026-01-27T15:04:53.872Z
9230182 9230182 20260119033752_Pe1bY DK0002 2026-01-20T14:26:26.405Z 2026-01-27T15:04:31.898Z
9230022 9230022 20260119031140_9FmBG DK0002 2026-01-20T14:25:30.264Z 2026-01-27T15:04:20.836Z
9229803 9229803 20260119023800_b7NGQ DK0002 2026-01-20T14:24:17.964Z 2026-01-27T15:03:57.460Z
9208585 9208585 20260115060324_iPWBd DK0002 2026-01-16T14:13:14.575Z 2026-01-22T15:04:34.429Z
9208500 9208500 20260115054514_UuREz DK0002 2026-01-16T14:12:55.528Z 2026-01-22T15:04:31.800Z
9207103 9207103 20260114215409_77IoZ DK0002 2026-01-16T14:07:07.944Z 2026-01-22T15:03:10.441Z
9207086 9207086 20260114213022_Byyze DK0002 2026-01-16T14:07:03.849Z 2026-01-22T15:03:09.996Z
9206982 9206982 20260114201315_riG36 DK0002 2026-01-16T14:06:29.662Z 2026-01-22T15:02:45.394Z
9182568 9182568 20260111054422_5RSrF DK0002 2026-01-12T14:15:01.537Z 2026-01-19T15:18:49.629Z
9182542 9182542 20260111053949_VrOQC DK0002 2026-01-12T14:14:56.913Z 2026-01-19T15:18:48.758Z
9182394 9182394 20260111051719_apqLn DK0002 2026-01-12T14:14:23.437Z 2026-01-19T15:18:30.657Z
9182361 9182361 20260111051029_Fkd0K DK0002 2026-01-12T14:14:15.963Z 2026-01-19T15:18:29.391Z
9182324 9182324 20260111050121_c3b3R DK0002 2026-01-12T14:14:09.889Z 2026-01-19T15:18:26.201Z
9182218 9182218 20260111044520_ITyPE DK0002 2026-01-12T14:13:45.946Z 2026-01-19T15:18:21.361Z
9182206 9182206 20260111044348_NDURq DK0002 2026-01-12T14:13:43.467Z 2026-01-19T15:18:20.909Z
9182177 9182177 20260111043510_FXhyP DK0002 2026-01-12T14:13:37.040Z 2026-01-19T15:18:18.942Z
9182150 9182150 20260111043005_65wg6 DK0002 2026-01-12T14:13:29.840Z 2026-01-19T15:18:17.585Z
9181859 9181859 20260111033126_noyx7 DK0002 2026-01-12T14:12:21.675Z 2026-01-19T15:17:51.489Z
9181854 9181854 20260111033110_IVGCx DK0002 2026-01-12T14:12:21.200Z 2026-01-19T15:17:51.354Z
9181756 9181756 20260111030358_bgVA1 DK0002 2026-01-12T14:12:03.594Z 2026-01-19T15:17:47.429Z
9181751 9181751 20260111030316_3sLoQ DK0002 2026-01-12T14:12:02.521Z 2026-01-19T15:17:47.203Z
9181446 9181446 20260111014711_4oR35 DK0002 2026-01-12T14:10:50.489Z 2026-01-19T15:17:18.635Z
9181353 9181353 20260111012836_2TUWi DK0002 2026-01-12T14:10:30.955Z 2026-01-19T15:17:14.213Z
9181199 9181199 20260111005043_FNqOz DK0002 2026-01-12T14:09:55.962Z 2026-01-19T15:17:07.556Z
9181131 9181131 20260111003139_4JNa5 DK0002 2026-01-12T14:09:41.304Z 2026-01-19T15:17:04.878Z
9181100 9181100 20260111002038_Jcejd DK0002 2026-01-12T14:09:34.213Z 2026-01-19T15:17:03.578Z
9181069 9181069 20260111001031_rb33C DK0002 2026-01-12T14:09:28.871Z 2026-01-19T15:16:46.712Z
9180771 9180771 20260110222431_d384K DK0002 2026-01-12T14:08:18.571Z 2026-01-19T15:16:31.613Z
9180759 9180759 20260110222145_X7S8E DK0002 2026-01-12T14:08:16.819Z 2026-01-19T15:16:31.258Z
9180696 9180696 20260110213933_E6OWV DK0002 2026-01-12T14:08:03.270Z 2026-01-19T15:16:28.311Z
9180504 9180504 20260110204321_GV9Nr DK0002 2026-01-12T14:07:22.025Z 2026-01-19T15:16:20.618Z
9179845 9179845 20260110175311_Jem3Y DK0002 2026-01-12T14:04:34.869Z 2026-01-19T15:15:19.804Z
9149481 9149481 20260104212338_pJaFW DK0002 2026-01-06T14:05:41.058Z 2026-01-13T15:12:13.799Z
9149399 9149399 20260104204912_grbEK DK0002 2026-01-06T14:05:18.591Z 2026-01-13T15:12:09.006Z
9148216 9148216 20260103173503_jIKnv DK0002 2026-01-05T14:30:22.052Z 2026-01-10T15:04:21.744Z
9148169 9148169 20260103173303_38X4X DK0002 2026-01-05T14:30:19.599Z 2026-01-10T15:04:18.851Z
9147956 9147956 20260103172406_pW9Vr DK0002 2026-01-05T14:30:01.974Z 2026-01-10T15:04:09.797Z
9147893 9147893 20260103171150_bXqbe DK0002 2026-01-05T14:29:55.118Z 2026-01-10T15:04:00.771Z
9147882 9147882 20260103170835_omptN DK0002 2026-01-05T14:29:53.022Z 2026-01-10T15:03:59.077Z
9147879 9147879 20260103170808_RPMSx DK0002 2026-01-05T14:29:52.897Z 2026-01-10T15:03:59.003Z
9147873 9147873 20260103165750_lMpW2 DK0002 2026-01-05T14:29:52.170Z 2026-01-10T15:03:56.411Z
9147846 9147846 20260103164056_2Yqq6 DK0002 2026-01-05T14:29:48.425Z 2026-01-10T15:03:51.918Z
9138341 9138341 20260103222037_60eVw DK0002 2026-01-05T14:09:51.585Z 2026-01-12T15:02:47.079Z
9137098 9137098 20260103204010_iFsBo DK0002 2026-01-05T14:07:51.980Z 2026-01-12T15:01:48.512Z
9135329 9135329 20260103185203_PybdT DK0002 2026-01-05T14:04:19.334Z 2026-01-12T15:00:26.681Z
9135161 9135161 20260103184429_zbz3f DK0002 2026-01-05T14:03:52.053Z 2026-01-12T15:00:13.813Z
9135018 9135018 20260103183536_FN3sM DK0002 2026-01-05T14:03:28.985Z 2026-01-12T15:00:00.330Z
9134297 9134297 20260103175833_2Bitd DK0002 2026-01-05T14:01:29.309Z 2026-01-12T14:59:18.657Z
9134223 9134223 20260103175646_cM0o7 DK0002 2026-01-05T14:01:13.936Z 2026-01-12T14:59:13.282Z
9134216 9134216 20260103175630_gxDBp DK0002 2026-01-05T14:01:12.045Z 2026-01-12T14:59:12.979Z
9134136 9134136 20260103175257_rvUJx DK0002 2026-01-05T14:00:55.804Z 2026-01-12T14:59:10.061Z
9134108 9134108 20260103175142_ZH6Ll DK0002 2026-01-05T14:00:45.544Z 2026-01-12T14:59:08.708Z
9134035 9134035 20260103174735_z4Wv9 DK0002 2026-01-05T14:00:23.460Z 2026-01-12T14:59:06.038Z
9134026 9134026 20260103174622_dzAJs DK0002 2026-01-05T14:00:19.947Z 2026-01-12T14:59:05.156Z
9127747 9127747 20260102050842_W1CqU DK0002 2026-01-03T14:11:44.714Z 2026-01-09T14:50:10.719Z
9127710 9127710 20260102045445_mt7vZ DK0002 2026-01-03T14:11:33.179Z 2026-01-09T14:50:09.303Z
9126410 9126410 20260101195950_Q9ZaI DK0002 2026-01-03T14:03:44.642Z 2026-01-09T14:48:24.780Z
9119476 9119476 20251230180458_rzZXO DK0002 2026-01-01T14:56:13.782Z 2026-01-07T15:12:46.873Z
9119103 9119103 20251230162632_x2FOz DK0002 2026-01-01T14:54:50.819Z 2026-01-07T15:12:04.755Z
9116679 9116679 20251231063634_3fHmP DK0002 2026-01-01T14:28:45.379Z 2026-01-08T15:12:07.125Z
9116642 9116642 20251231062931_9zNk3 DK0002 2026-01-01T14:28:32.343Z 2026-01-08T15:11:57.419Z
9116524 9116524 20251231061939_eVJ02 DK0002 2026-01-01T14:28:19.086Z 2026-01-01T14:57:54.875Z
9114003 9114003 20251231035938_ZrsRM DK0002 2026-01-01T14:21:11.512Z 2026-01-08T15:09:20.074Z
9106945 9106945 20251229043733_N3Zcy DK0002 2025-12-31T14:36:34.356Z 2026-01-06T15:18:15.748Z
9104092 9104092 20251230053016_9AJUG DK0002 2025-12-31T14:20:15.636Z 2026-01-07T15:09:30.317Z
9103983 9103983 20251230052400_ESwA3 DK0002 2025-12-31T14:19:57.067Z 2026-01-07T15:09:18.006Z
9103872 9103872 20251230051221_yOZgZ DK0002 2025-12-31T14:19:35.044Z 2026-01-07T15:09:13.196Z
9103640 9103640 20251230044824_g9Nze DK0002 2025-12-31T14:18:35.445Z 2026-01-07T15:09:01.561Z
9102965 9102965 20251230034652_6jb1L DK0002 2025-12-31T14:15:59.474Z 2026-01-07T15:08:13.366Z
9102871 9102871 20251230034005_dRY1j DK0002 2025-12-31T14:15:38.053Z 2026-01-07T15:08:09.518Z
9102789 9102789 20251230033449_MyEm1 DK0002 2025-12-31T14:15:22.970Z 2026-01-07T15:08:06.250Z
9102716 9102716 20251230032817_nILHH DK0002 2025-12-31T14:15:03.063Z 2026-01-07T15:08:02.288Z
9102708 9102708 20251230032804_Yxq63 DK0002 2025-12-31T14:15:02.025Z 2026-01-07T15:08:01.967Z

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