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,137 rows where station_code = "DK000F" 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
8666519 8666519 20251201060305_3pdHQ DK000F 2025-12-02T14:26:22.508Z 2025-12-05T14:37:01.078Z
8666475 8666475 20251201054510_VT2X6 DK000F 2025-12-02T14:26:17.179Z 2025-12-05T14:36:59.381Z
8666456 8666456 20251201054344_37vy4 DK000F 2025-12-02T14:26:15.507Z 2025-12-05T14:36:58.952Z
8666451 8666451 20251201054322_e3yQf DK000F 2025-12-02T14:26:15.174Z 2025-12-05T14:36:58.878Z
8666432 8666432 20251201053858_wrs7Z DK000F 2025-12-02T14:26:08.606Z 2025-12-05T14:36:58.129Z
8666400 8666400 20251201053459_DM2If DK000F 2025-12-02T14:25:57.639Z 2025-12-05T14:36:57.237Z
8666349 8666349 20251201051819_uQb0v DK000F 2025-12-02T14:25:50.602Z 2025-12-05T14:36:55.094Z
8666310 8666310 20251201051042_lNyP2 DK000F 2025-12-02T14:25:45.374Z 2025-12-05T14:36:53.879Z
8666038 8666038 20251201042622_Z2Rnb DK000F 2025-12-02T14:25:07.669Z 2025-12-05T14:36:27.822Z
8665855 8665855 20251201040310_FhAs1 DK000F 2025-12-02T14:24:35.382Z 2025-12-05T14:36:21.558Z
8665769 8665769 20251201035652_orVxy DK000F 2025-12-02T14:24:27.115Z 2025-12-05T14:36:18.648Z
8665717 8665717 20251201035143_D8YaQ DK000F 2025-12-02T14:24:21.930Z 2025-12-05T14:36:17.168Z
8647072 8647072 20251129033657_gNrLZ DK000F 2025-11-30T14:27:24.230Z 2025-12-05T14:52:32.225Z
8646863 8646863 20251129030436_sReka DK000F 2025-11-30T14:27:02.696Z 2025-12-05T14:51:55.573Z
8646750 8646750 20251129024851_kDnF2 DK000F 2025-11-30T14:26:47.603Z 2025-12-05T14:51:53.256Z
8646535 8646535 20251129021832_EfhYx DK000F 2025-11-30T14:26:07.926Z 2025-12-05T14:51:44.024Z
8646530 8646530 20251129021610_qbmiC DK000F 2025-11-30T14:26:07.326Z 2025-12-05T14:51:43.877Z
8646509 8646509 20251129021257_P3C7d DK000F 2025-11-30T14:26:05.849Z 2025-12-05T14:51:43.548Z
8646479 8646479 20251129021006_5BJRl DK000F 2025-11-30T14:26:03.572Z 2025-12-05T14:51:42.995Z
8646470 8646470 20251129020918_i237A DK000F 2025-11-30T14:26:02.614Z 2025-12-05T14:51:42.745Z
8646390 8646390 20251129015731_2K2ty DK000F 2025-11-30T14:25:55.995Z 2025-12-05T14:51:40.960Z
8646357 8646357 20251129015031_ehSwa DK000F 2025-11-30T14:25:53.361Z 2025-12-05T14:51:40.172Z
8646279 8646279 20251129013925_76rsm DK000F 2025-11-30T14:25:46.985Z 2025-12-05T14:51:38.055Z
8645893 8645893 20251129001723_PkzbZ DK000F 2025-11-30T14:24:47.423Z 2025-12-05T14:51:27.730Z
8645882 8645882 20251129001443_LZK52 DK000F 2025-11-30T14:24:39.922Z 2025-12-05T14:51:27.477Z
8645785 8645785 20251128234943_DN3ku DK000F 2025-11-30T14:24:31.684Z 2025-12-05T14:51:12.857Z
8645778 8645778 20251128234828_cAwXm DK000F 2025-11-30T14:24:31.203Z 2025-12-05T14:51:12.488Z
8622649 8622649 20251126203100_TCJQI DK000F 2025-11-28T14:19:38.009Z 2025-12-05T15:03:04.604Z
8622633 8622633 20251126202338_zEFM3 DK000F 2025-11-28T14:19:35.623Z 2025-12-05T15:03:04.310Z
8622460 8622460 20251126192602_FyH5i DK000F 2025-11-28T14:18:54.665Z 2025-12-05T15:03:00.525Z
8622139 8622139 20251126175858_Qvm2e DK000F 2025-11-28T14:17:48.477Z 2025-12-05T15:02:52.724Z
8622044 8622044 20251126173729_ujOGV DK000F 2025-11-28T14:17:32.821Z 2025-12-05T15:02:50.961Z
8621801 8621801 20251126162748_e636E DK000F 2025-11-28T14:16:38.623Z 2025-12-05T15:02:48.007Z
8614873 8614873 20251126043334_ykBzr DK000F 2025-11-27T14:28:39.949Z 2025-12-04T15:11:16.830Z
8614227 8614227 20251126035939_GeMKr DK000F 2025-11-27T14:27:41.293Z 2025-12-04T15:10:32.885Z
8613890 8613890 20251126033824_2n2bN DK000F 2025-11-27T14:26:54.054Z 2025-12-04T15:09:53.140Z
8613631 8613631 20251126032654_32Byu DK000F 2025-11-27T14:26:19.755Z 2025-12-04T15:09:50.012Z
8613545 8613545 20251126032206_HOk0q DK000F 2025-11-27T14:26:12.013Z 2025-12-04T15:09:44.912Z
8612870 8612870 20251126025313_GZX4Y DK000F 2025-11-27T14:24:56.781Z 2025-12-04T15:09:35.350Z
8612421 8612421 20251126023058_7bnDY DK000F 2025-11-27T14:24:08.752Z 2025-12-04T15:09:30.573Z
8611990 8611990 20251126021243_U3xnX DK000F 2025-11-27T14:23:11.982Z 2025-12-04T15:09:26.569Z
8611875 8611875 20251126020443_1p1rt DK000F 2025-11-27T14:23:00.673Z 2025-12-04T15:09:25.077Z
8611206 8611206 20251126013057_v3jD2 DK000F 2025-11-27T14:21:38.767Z 2025-12-04T15:08:57.086Z
8611204 8611204 20251126013041_fvMW0 DK000F 2025-11-27T14:21:38.308Z 2025-12-04T15:08:57.079Z
8611131 8611131 20251126012242_1E9Ki DK000F 2025-11-27T14:21:18.037Z 2025-12-04T15:08:51.744Z
8610406 8610406 20251126004218_JZgQV DK000F 2025-11-27T14:20:04.606Z 2025-12-04T15:08:05.107Z
8610016 8610016 20251126001819_AMVNx DK000F 2025-11-27T14:19:22.604Z 2025-12-04T15:07:59.101Z
8574335 8574335 20251122055229_JtqVc DK000F 2025-11-23T14:43:06.875Z 2025-11-30T15:07:05.057Z
8574281 8574281 20251122054237_q0knC DK000F 2025-11-23T14:43:03.965Z 2025-11-23T14:43:03.965Z
8573077 8573077 20251122022557_wJRoY DK000F 2025-11-23T14:40:43.038Z 2025-11-30T15:06:09.251Z
8572640 8572640 20251122012310_MsnFy DK000F 2025-11-23T14:39:35.796Z 2025-11-30T15:05:54.434Z
8571953 8571953 20251121225958_8e6YS DK000F 2025-11-23T14:37:52.070Z 2025-11-30T15:05:26.733Z
8571946 8571946 20251121225834_DlL04 DK000F 2025-11-23T14:37:51.458Z 2025-11-30T15:05:26.453Z
8571876 8571876 20251121223518_XRbs9 DK000F 2025-11-23T14:37:48.188Z 2025-11-30T15:05:24.250Z
8570809 8570809 20251121170642_GKYxp DK000F 2025-11-23T14:34:43.241Z 2025-11-30T15:03:43.614Z
8570806 8570806 20251121170642_ZZNP9 DK000F 2025-11-23T14:34:42.492Z 2025-11-30T15:03:43.602Z
8570786 8570786 20251121163132_I5bnC DK000F 2025-11-23T14:34:28.888Z 2025-11-30T15:03:40.402Z
8569302 8569302 20251121055215_02H3f DK000F 2025-11-23T14:32:09.713Z 2025-11-29T14:54:48.033Z
8569010 8569010 20251121054304_hmDVh DK000F 2025-11-23T14:31:51.313Z 2025-11-29T14:54:47.667Z
8568564 8568564 20251121052505_Ge2MX DK000F 2025-11-23T14:31:13.584Z 2025-11-29T14:54:47.001Z
8568535 8568535 20251121052239_9YlHS DK000F 2025-11-23T14:31:11.524Z 2025-11-29T14:54:46.920Z
8568481 8568481 20251121052119_UkY23 DK000F 2025-11-23T14:31:09.742Z 2025-11-29T14:54:46.841Z
8568322 8568322 20251121051355_SRFGs DK000F 2025-11-23T14:31:03.982Z 2025-11-29T14:54:46.520Z
8568201 8568201 20251121050606_uGEAI DK000F 2025-11-23T14:30:57.715Z 2025-11-29T14:54:46.326Z
8560462 8560462 20251121045543_vka3l DK000F 2025-11-22T14:42:52.887Z 2025-11-29T14:54:45.785Z
8560213 8560213 20251121044611_8Kuxx DK000F 2025-11-22T14:42:37.016Z 2025-11-22T14:42:37.016Z
8560125 8560125 20251121044231_plcfb DK000F 2025-11-22T14:42:22.026Z 2025-11-29T14:54:45.057Z
8560121 8560121 20251121044223_DErWy DK000F 2025-11-22T14:42:22.018Z 2025-11-22T14:42:22.018Z
8560029 8560029 20251121043617_yjckp DK000F 2025-11-22T14:42:10.890Z 2025-11-29T14:54:44.928Z
8559978 8559978 20251121043345_3akS2 DK000F 2025-11-22T14:42:08.333Z 2025-11-29T14:54:44.849Z
8559916 8559916 20251121043032_5go7l DK000F 2025-11-22T14:42:07.148Z 2025-11-29T14:54:44.560Z
8559609 8559609 20251121041842_7VV03 DK000F 2025-11-22T14:41:59.712Z 2025-11-29T14:54:43.127Z
8559347 8559347 20251121040743_dtf0E DK000F 2025-11-22T14:41:53.785Z 2025-11-29T14:54:37.907Z
8559198 8559198 20251121035826_nguEM DK000F 2025-11-22T14:41:49.786Z 2025-11-29T14:54:37.565Z
8559160 8559160 20251121035553_u0TfH DK000F 2025-11-22T14:41:48.782Z 2025-11-29T14:54:37.383Z
8559077 8559077 20251121035252_DelCj DK000F 2025-11-22T14:41:46.673Z 2025-11-29T14:54:37.108Z
8559038 8559038 20251121035047_7uqDV DK000F 2025-11-22T14:41:44.890Z 2025-11-29T14:54:37.013Z
8558882 8558882 20251121034423_s7VX4 DK000F 2025-11-22T14:41:24.203Z 2025-11-29T14:54:36.804Z
8558615 8558615 20251121033454_SiXN2 DK000F 2025-11-22T14:41:08.305Z 2025-11-29T14:54:36.334Z
8558510 8558510 20251121033103_6b8X1 DK000F 2025-11-22T14:41:06.762Z 2025-11-29T14:54:36.155Z
8558433 8558433 20251121032835_qzEwh DK000F 2025-11-22T14:41:05.105Z 2025-11-29T14:54:36.047Z
8558346 8558346 20251121032555_1FEib DK000F 2025-11-22T14:41:03.868Z 2025-11-29T14:54:35.962Z
8558268 8558268 20251121032142_pRjj7 DK000F 2025-11-22T14:41:02.043Z 2025-11-29T14:54:35.714Z
8558146 8558146 20251121031730_H4D2Q DK000F 2025-11-22T14:40:59.824Z 2025-11-29T14:54:35.378Z
8558127 8558127 20251121031628_WcG36 DK000F 2025-11-22T14:40:59.269Z 2025-11-29T14:54:35.298Z
8558022 8558022 20251121031116_kOhy0 DK000F 2025-11-22T14:40:55.925Z 2025-11-29T14:54:35.060Z
8557909 8557909 20251121030904_8KMqz DK000F 2025-11-22T14:40:53.229Z 2025-11-29T14:54:34.929Z
8557792 8557792 20251121030104_wYM3r DK000F 2025-11-22T14:40:39.857Z 2025-11-29T14:54:34.724Z
8557632 8557632 20251121025439_Hml3x DK000F 2025-11-22T14:40:25.563Z 2025-11-29T14:54:34.414Z
8557546 8557546 20251121025221_d8WXh DK000F 2025-11-22T14:40:21.389Z 2025-11-29T14:54:34.368Z
8557062 8557062 20251121023012_YVxzf DK000F 2025-11-22T14:39:50.640Z 2025-11-29T14:54:33.388Z
8556885 8556885 20251121021743_mwB9S DK000F 2025-11-22T14:39:46.225Z 2025-11-29T14:54:33.093Z
8556776 8556776 20251121021226_Y0MAp DK000F 2025-11-22T14:39:43.665Z 2025-11-29T14:54:32.993Z
8556703 8556703 20251121020757_w13VQ DK000F 2025-11-22T14:39:41.082Z 2025-11-29T14:54:32.809Z
8556589 8556589 20251121020335_sELzI DK000F 2025-11-22T14:39:37.701Z 2025-11-29T14:54:32.606Z
8556112 8556112 20251121013802_xTApR DK000F 2025-11-22T14:39:02.271Z 2025-11-29T14:54:31.838Z
8556109 8556109 20251121013746_XME36 DK000F 2025-11-22T14:39:02.119Z 2025-11-29T14:54:31.828Z
8555902 8555902 20251121012946_5DLqK DK000F 2025-11-22T14:38:55.122Z 2025-11-29T14:54:31.474Z
8555555 8555555 20251121011139_VjMo2 DK000F 2025-11-22T14:38:46.961Z 2025-11-29T14:54:30.667Z
8555434 8555434 20251121010647_l14ui DK000F 2025-11-22T14:38:44.406Z 2025-11-29T14:54:30.498Z

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