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,024 rows where station_code = "DK000G" 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
8666452 8666452 20251201054322_e3yQf DK000G 2025-12-02T14:26:15.174Z 2025-12-06T14:42:22.670Z
8666438 8666438 20251201054005_BhmyJ DK000G 2025-12-02T14:26:11.846Z 2025-12-06T14:42:22.267Z
8666426 8666426 20251201053827_xERGJ DK000G 2025-12-02T14:26:01.453Z 2025-12-02T14:26:01.453Z
8666415 8666415 20251201053644_IqkcJ DK000G 2025-12-02T14:25:59.380Z 2025-12-06T14:42:21.546Z
8666384 8666384 20251201053000_Kl39v DK000G 2025-12-02T14:25:55.398Z 2025-12-06T14:42:20.527Z
8666364 8666364 20251201052233_30LxQ DK000G 2025-12-02T14:25:53.124Z 2025-12-06T14:42:18.129Z
8666337 8666337 20251201051640_ARnhh DK000G 2025-12-02T14:25:48.291Z 2025-12-02T14:25:48.291Z
8666332 8666332 20251201051602_5yJQS DK000G 2025-12-02T14:25:47.682Z 2025-12-02T14:25:47.682Z
8666311 8666311 20251201051042_lNyP2 DK000G 2025-12-02T14:25:45.375Z 2025-12-06T14:42:16.859Z
8666306 8666306 20251201051012_IxQHg DK000G 2025-12-02T14:25:44.658Z 2025-12-06T14:42:16.790Z
8666275 8666275 20251201050706_agbKN DK000G 2025-12-02T14:25:42.021Z 2025-12-06T14:42:16.267Z
8666268 8666268 20251201050522_2kE2E DK000G 2025-12-02T14:25:41.462Z 2025-12-06T14:42:16.107Z
8666252 8666252 20251201050115_gPJtJ DK000G 2025-12-02T14:25:39.724Z 2025-12-06T14:42:15.452Z
8666194 8666194 20251201045021_tjBLc DK000G 2025-12-02T14:25:34.902Z 2025-12-06T14:42:14.408Z
8666183 8666183 20251201044820_W9aWO DK000G 2025-12-02T14:25:33.821Z 2025-12-02T14:25:33.821Z
8666176 8666176 20251201044740_qnUG2 DK000G 2025-12-02T14:25:33.142Z 2025-12-02T14:25:33.142Z
8666140 8666140 20251201044128_Ii2Nt DK000G 2025-12-02T14:25:18.877Z 2025-12-06T14:42:13.010Z
8666137 8666137 20251201044102_M0Bwf DK000G 2025-12-02T14:25:18.512Z 2025-12-06T14:42:12.959Z
8666134 8666134 20251201044047_zgmxS DK000G 2025-12-02T14:25:18.126Z 2025-12-06T14:42:12.739Z
8666017 8666017 20251201042455_IEJ2V DK000G 2025-12-02T14:25:06.419Z 2025-12-06T14:42:09.741Z
8665873 8665873 20251201040417_2x3g2 DK000G 2025-12-02T14:24:37.668Z 2025-12-06T14:42:05.808Z
8665864 8665864 20251201040323_ynce4 DK000G 2025-12-02T14:24:36.193Z 2025-12-06T14:42:05.287Z
8665856 8665856 20251201040310_FhAs1 DK000G 2025-12-02T14:24:35.382Z 2025-12-06T14:42:05.132Z
8665770 8665770 20251201035652_orVxy DK000G 2025-12-02T14:24:27.115Z 2025-12-06T14:42:02.053Z
8665718 8665718 20251201035143_D8YaQ DK000G 2025-12-02T14:24:21.950Z 2025-12-06T14:41:47.116Z
8665673 8665673 20251201034950_hbXG9 DK000G 2025-12-02T14:24:18.813Z 2025-12-06T14:41:45.594Z
8665600 8665600 20251201034142_dn65Z DK000G 2025-12-02T14:24:00.624Z 2025-12-06T14:41:41.457Z
8665565 8665565 20251201033518_oSwjC DK000G 2025-12-02T14:23:55.225Z 2025-12-06T14:41:40.795Z
8665410 8665410 20251201031741_3NEQE DK000G 2025-12-02T14:23:39.317Z 2025-12-06T14:41:37.170Z
8665391 8665391 20251201031525_Qy1Tq DK000G 2025-12-02T14:23:37.024Z 2025-12-06T14:41:36.731Z
8665364 8665364 20251201031115_1zj0r DK000G 2025-12-02T14:23:34.848Z 2025-12-06T14:41:35.724Z
8665357 8665357 20251201031100_nbF0V DK000G 2025-12-02T14:23:34.187Z 2025-12-06T14:41:35.625Z
8665338 8665338 20251201030857_vRV6Q DK000G 2025-12-02T14:23:32.707Z 2025-12-06T14:41:35.117Z
8665289 8665289 20251201030127_mkTDy DK000G 2025-12-02T14:23:17.743Z 2025-12-06T14:41:32.833Z
8665266 8665266 20251201025715_df7DG DK000G 2025-12-02T14:23:15.132Z 2025-12-06T14:41:31.407Z
8665206 8665206 20251201024743_GvVAZ DK000G 2025-12-02T14:23:08.047Z 2025-12-06T14:41:29.481Z
8665171 8665171 20251201024135_GDSCU DK000G 2025-12-02T14:23:04.113Z 2025-12-06T14:41:28.628Z
8664938 8664938 20251201020606_GXdHJ DK000G 2025-12-02T14:22:29.068Z 2025-12-06T14:41:03.440Z
8664859 8664859 20251201015157_ClDd9 DK000G 2025-12-02T14:22:13.778Z 2025-12-06T14:41:01.199Z
8664846 8664846 20251201014921_ZcwKW DK000G 2025-12-02T14:22:11.438Z 2025-12-06T14:41:00.781Z
8664832 8664832 20251201014613_lVRdM DK000G 2025-12-02T14:22:09.998Z 2025-12-06T14:40:59.074Z
8664826 8664826 20251201014542_IC7VD DK000G 2025-12-02T14:22:09.120Z 2025-12-06T14:40:58.936Z
8664762 8664762 20251201013434_bPECw DK000G 2025-12-02T14:22:02.135Z 2025-12-06T14:40:56.721Z
8664745 8664745 20251201013402_Dbp1K DK000G 2025-12-02T14:22:00.600Z 2025-12-06T14:40:56.223Z
8664730 8664730 20251201013133_bzzmr DK000G 2025-12-02T14:21:59.263Z 2025-12-06T14:40:55.906Z
8664709 8664709 20251201013018_cxyRN DK000G 2025-12-02T14:21:56.338Z 2025-12-06T14:40:55.512Z
8664642 8664642 20251201011540_pBq6t DK000G 2025-12-02T14:21:41.580Z 2025-12-06T14:40:53.547Z
8664593 8664593 20251201010435_E2QKQ DK000G 2025-12-02T14:21:35.562Z 2025-12-06T14:40:52.138Z
8664440 8664440 20251201002749_x3b34 DK000G 2025-12-02T14:21:04.865Z 2025-12-06T14:40:46.861Z
8664352 8664352 20251201000645_mRt4y DK000G 2025-12-02T14:20:46.685Z 2025-12-06T14:40:45.094Z
8664344 8664344 20251201000602_kfvDS DK000G 2025-12-02T14:20:45.042Z 2025-12-06T14:40:44.680Z
8664282 8664282 20251130235813_HleSf DK000G 2025-12-02T14:20:38.868Z 2025-12-06T14:40:43.427Z
8664180 8664180 20251130233312_GldwO DK000G 2025-12-02T14:20:16.017Z 2025-12-06T14:40:40.858Z
8664175 8664175 20251130233132_Rk0UD DK000G 2025-12-02T14:20:14.830Z 2025-12-06T14:40:40.345Z
8664154 8664154 20251130232700_AU2yP DK000G 2025-12-02T14:20:12.278Z 2025-12-06T14:40:39.545Z
8664110 8664110 20251130231832_7sa06 DK000G 2025-12-02T14:20:06.257Z 2025-12-06T14:40:35.551Z
8664064 8664064 20251130231356_1wSDL DK000G 2025-12-02T14:20:02.577Z 2025-12-06T14:40:25.398Z
8664059 8664059 20251130231252_SffMr DK000G 2025-12-02T14:20:01.882Z 2025-12-06T14:40:25.026Z
8663957 8663957 20251130224952_5NifN DK000G 2025-12-02T14:19:41.371Z 2025-12-06T14:40:17.559Z
8663907 8663907 20251130223126_2n6nv DK000G 2025-12-02T14:19:33.813Z 2025-12-06T14:40:15.870Z
8663854 8663854 20251130222015_NLtQC DK000G 2025-12-02T14:19:26.212Z 2025-12-06T14:40:13.132Z
8647892 8647892 20251129055537_CmKZs DK000G 2025-11-30T14:29:21.382Z 2025-12-06T14:56:51.986Z
8647878 8647878 20251129055040_lsMUC DK000G 2025-11-30T14:29:20.412Z 2025-12-06T14:56:51.111Z
8647873 8647873 20251129054934_oXVFg DK000G 2025-11-30T14:29:20.050Z 2025-12-06T14:56:50.796Z
8647759 8647759 20251129052041_8VSxp DK000G 2025-11-30T14:28:51.914Z 2025-12-06T14:56:46.572Z
8647739 8647739 20251129051630_V9t8J DK000G 2025-11-30T14:28:50.083Z 2025-12-06T14:56:46.056Z
8647640 8647640 20251129045950_PWSBs DK000G 2025-11-30T14:28:40.706Z 2025-12-06T14:56:42.385Z
8647617 8647617 20251129045828_GBhR7 DK000G 2025-11-30T14:28:39.553Z 2025-12-06T14:56:42.136Z
8647537 8647537 20251129044831_a13Bx DK000G 2025-11-30T14:28:33.671Z 2025-12-06T14:56:40.788Z
8647503 8647503 20251129044545_cuSaA DK000G 2025-11-30T14:28:30.668Z 2025-12-06T14:56:40.058Z
8647481 8647481 20251129044200_BwecN DK000G 2025-11-30T14:28:29.109Z 2025-12-06T14:56:39.709Z
8647362 8647362 20251129042736_r00S7 DK000G 2025-11-30T14:28:03.282Z 2025-12-06T14:56:37.464Z
8647159 8647159 20251129035340_kAAap DK000G 2025-11-30T14:27:45.993Z 2025-12-06T14:56:33.012Z
8647149 8647149 20251129035214_gfKYZ DK000G 2025-11-30T14:27:45.434Z 2025-12-06T14:56:32.848Z
8647120 8647120 20251129034514_wVlw0 DK000G 2025-11-30T14:27:42.728Z 2025-12-06T14:56:32.356Z
8646864 8646864 20251129030436_sReka DK000G 2025-11-30T14:27:02.696Z 2025-12-06T14:56:26.706Z
8646838 8646838 20251129030018_3BwCr DK000G 2025-11-30T14:27:01.197Z 2025-12-06T14:56:26.187Z
8646785 8646785 20251129025348_xMceE DK000G 2025-11-30T14:26:57.523Z 2025-12-06T14:56:25.093Z
8625731 8625731 20251126044026_fQlrG DK000G 2025-11-28T14:36:16.334Z 2025-12-04T15:11:24.677Z
8625678 8625678 20251126041246_3dHP5 DK000G 2025-11-28T14:36:05.530Z 2025-12-04T15:10:42.114Z
8623243 8623243 20251126233023_d25GV DK000G 2025-11-28T14:21:22.822Z 2025-12-05T15:03:40.343Z
8623150 8623150 20251126230522_uJ18X DK000G 2025-11-28T14:20:58.397Z 2025-12-05T15:03:32.917Z
8623135 8623135 20251126225818_vHK62 DK000G 2025-11-28T14:20:56.060Z 2025-12-05T15:03:30.706Z
8623114 8623114 20251126225526_XZARV DK000G 2025-11-28T14:20:54.510Z 2025-12-05T15:03:30.318Z
8623011 8623011 20251126222757_GYpE7 DK000G 2025-11-28T14:20:28.864Z 2025-12-05T15:03:25.124Z
8622933 8622933 20251126220929_WmzRw DK000G 2025-11-28T14:20:20.254Z 2025-12-05T15:03:20.198Z
8622922 8622922 20251126220605_FjS21 DK000G 2025-11-28T14:20:18.752Z 2025-12-05T15:03:19.952Z
8622904 8622904 20251126220259_7ZSvV DK000G 2025-11-28T14:20:17.213Z 2025-12-05T15:03:19.267Z
8622819 8622819 20251126213943_NgM41 DK000G 2025-11-28T14:20:07.574Z 2025-12-05T15:03:14.347Z
8622785 8622785 20251126212220_B7X3B DK000G 2025-11-28T14:19:53.460Z 2025-12-05T15:03:08.837Z
8622716 8622716 20251126204954_RM8Tu DK000G 2025-11-28T14:19:44.142Z 2025-12-05T15:03:05.434Z
8622650 8622650 20251126203100_TCJQI DK000G 2025-11-28T14:19:38.009Z 2025-12-05T15:03:04.604Z
8622613 8622613 20251126201531_41Nl5 DK000G 2025-11-28T14:19:33.306Z 2025-12-05T15:03:04.067Z
8622607 8622607 20251126201503_g2NSZ DK000G 2025-11-28T14:19:28.813Z 2025-12-05T15:03:03.999Z
8622555 8622555 20251126195451_QQ9Fj DK000G 2025-11-28T14:19:21.194Z 2025-12-05T15:03:03.447Z
8622548 8622548 20251126195147_GY7i4 DK000G 2025-11-28T14:19:08.554Z 2025-12-05T15:03:03.274Z
8622544 8622544 20251126195112_jYG1O DK000G 2025-11-28T14:19:08.274Z 2025-12-05T15:03:03.216Z
8622481 8622481 20251126193242_W9ijB DK000G 2025-11-28T14:18:57.152Z 2025-12-05T15:03:02.298Z
8614874 8614874 20251126043334_ykBzr DK000G 2025-11-27T14:28:39.949Z 2025-12-04T15:11:16.830Z
8614334 8614334 20251126040556_FtzW1 DK000G 2025-11-27T14:27:47.470Z 2025-12-04T15:10:37.170Z

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