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

489 rows where station_code = "DK000E" 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
8665457 8665457 20251201032150_HEoP2 DK000E 2025-12-02T14:23:42.950Z 2025-12-06T14:41:37.912Z
8665244 8665244 20251201025050_d358y DK000E 2025-12-02T14:23:11.688Z 2025-12-06T14:41:30.396Z
8646368 8646368 20251129015425_SU4kF DK000E 2025-11-30T14:25:54.192Z 2025-12-06T14:56:02.532Z
8580165 8580165 20251123024343_1oab2 DK000E 2025-11-24T14:16:16.777Z 2025-12-01T15:21:44.538Z
8580138 8580138 20251123023720_dRnc3 DK000E 2025-11-24T14:16:13.484Z 2025-12-01T15:21:42.758Z
8567049 8567049 20251122035031_2sSd4 DK000E 2025-11-23T14:18:36.835Z 2025-11-30T15:06:34.917Z
8567045 8567045 20251122035021_sC9B2 DK000E 2025-11-23T14:18:36.387Z 2025-11-30T15:06:34.898Z
8566796 8566796 20251122022631_hcu9o DK000E 2025-11-23T14:17:33.655Z 2025-11-30T15:06:09.305Z
8566745 8566745 20251122020820_3kGqE DK000E 2025-11-23T14:17:15.022Z 2025-11-30T15:06:07.126Z
8565993 8565993 20251121222008_4ga7A DK000E 2025-11-23T14:14:48.952Z 2025-11-30T15:05:19.979Z
8565937 8565937 20251121220522_D5627 DK000E 2025-11-23T14:14:34.307Z 2025-11-30T15:05:18.429Z
8565874 8565874 20251121214704_7PEFf DK000E 2025-11-23T14:14:25.043Z 2025-11-30T15:05:13.250Z
8565839 8565839 20251121213800_uTVYK DK000E 2025-11-23T14:14:22.055Z 2025-11-30T15:05:11.520Z
8560056 8560056 20251121043734_FH3YX DK000E 2025-11-22T14:42:12.067Z 2025-11-29T14:54:44.947Z
8559952 8559952 20251121043150_i2Nxn DK000E 2025-11-22T14:42:07.729Z 2025-11-29T14:54:44.752Z
8559704 8559704 20251121042253_j5pAy DK000E 2025-11-22T14:42:01.962Z 2025-11-29T14:54:43.315Z
8559584 8559584 20251121041802_w4J6c DK000E 2025-11-22T14:41:59.265Z 2025-11-29T14:54:40.777Z
8559452 8559452 20251121041131_r5hE5 DK000E 2025-11-22T14:41:56.122Z 2025-11-29T14:54:39.117Z
8556854 8556854 20251121021635_VaBET DK000E 2025-11-22T14:39:45.674Z 2025-11-29T14:54:33.060Z
8555754 8555754 20251121011917_iSox4 DK000E 2025-11-22T14:38:50.663Z 2025-11-29T14:54:30.962Z
8550588 8550588 20251120235403_cg26W DK000E 2025-11-22T14:21:15.978Z 2025-11-29T14:54:27.163Z
8550358 8550358 20251120233823_s23Qj DK000E 2025-11-22T14:20:47.235Z 2025-11-29T14:54:26.739Z
8550106 8550106 20251120232217_UkgOK DK000E 2025-11-22T14:20:16.324Z 2025-11-29T14:54:26.269Z
8549228 8549228 20251120220843_52v8n DK000E 2025-11-22T14:18:34.135Z 2025-11-29T14:54:24.336Z
8549063 8549063 20251120214720_weGZx DK000E 2025-11-22T14:18:11.909Z 2025-11-29T14:54:23.896Z
8528188 8528188 20251119033403_fbF30 DK000E 2025-11-20T14:42:10.310Z 2025-11-27T15:12:49.993Z
8524634 8524634 20251119040410_HASua DK000E 2025-11-20T14:21:09.931Z 2025-11-27T15:13:02.482Z
8524601 8524601 20251119040028_mrLAv DK000E 2025-11-20T14:21:05.904Z 2025-11-27T15:12:59.430Z
8524478 8524478 20251119035022_bLFI9 DK000E 2025-11-20T14:20:54.602Z 2025-11-27T15:12:56.316Z
8524308 8524308 20251119033403_HbEe2 DK000E 2025-11-20T14:20:27.132Z 2025-11-20T14:20:27.132Z
8524246 8524246 20251119032735_9Jx38 DK000E 2025-11-20T14:20:20.854Z 2025-11-27T15:12:48.378Z
8524227 8524227 20251119032556_qzsB2 DK000E 2025-11-20T14:20:19.101Z 2025-11-27T15:12:47.831Z
8507706 8507706 20251117235101_YyALw DK000E 2025-11-19T14:15:57.020Z 2025-11-26T15:07:47.658Z
8496828 8496828 20251117045821_2yZSC DK000E 2025-11-18T14:28:03.085Z 2025-11-25T15:10:21.399Z
8496264 8496264 20251117043012_At5F4 DK000E 2025-11-18T14:27:24.195Z 2025-11-25T15:10:12.847Z
8495426 8495426 20251117034909_5IJ2l DK000E 2025-11-18T14:26:11.405Z 2025-11-25T15:09:53.900Z
8495405 8495405 20251117034600_tMqOS DK000E 2025-11-18T14:26:09.584Z 2025-11-25T15:09:52.995Z
8495225 8495225 20251117033604_l3n5k DK000E 2025-11-18T14:25:41.208Z 2025-11-25T15:09:49.012Z
8494101 8494101 20251117022802_5QdQO DK000E 2025-11-18T14:23:35.576Z 2025-11-25T15:09:28.392Z
8493805 8493805 20251117020855_Vv1FT DK000E 2025-11-18T14:23:05.865Z 2025-11-25T15:09:22.196Z
8493567 8493567 20251117015120_5w4Uz DK000E 2025-11-18T14:22:29.576Z 2025-11-25T15:09:19.955Z
8493076 8493076 20251117011646_7jHPk DK000E 2025-11-18T14:21:11.832Z 2025-11-25T15:09:01.775Z
8492872 8492872 20251117005659_38IPa DK000E 2025-11-18T14:20:52.835Z 2025-11-25T15:08:57.196Z
8492618 8492618 20251117004142_NjhbR DK000E 2025-11-18T14:20:18.768Z 2025-11-25T15:08:53.129Z
8492451 8492451 20251117002630_zVnho DK000E 2025-11-18T14:19:46.397Z 2025-11-25T15:08:51.926Z
8492057 8492057 20251116234949_JavLn DK000E 2025-11-18T14:18:56.657Z 2025-11-25T15:08:45.281Z
8491905 8491905 20251116232841_9Huhd DK000E 2025-11-18T14:18:36.860Z 2025-11-25T15:08:43.037Z
8491874 8491874 20251116232334_7jvRN DK000E 2025-11-18T14:18:27.733Z 2025-11-25T15:08:42.957Z
8491407 8491407 20251116222753_v1X6q DK000E 2025-11-18T14:17:18.182Z 2025-11-25T15:08:37.324Z
8491387 8491387 20251116222548_rrmIz DK000E 2025-11-18T14:17:16.230Z 2025-11-25T15:08:37.237Z
8491287 8491287 20251116221037_klL0C DK000E 2025-11-18T14:17:00.438Z 2025-11-25T15:08:36.399Z
8491156 8491156 20251116214226_MMFEZ DK000E 2025-11-18T14:16:28.589Z 2025-11-25T15:08:33.288Z
8490961 8490961 20251116210702_J7UwY DK000E 2025-11-18T14:15:52.369Z 2025-11-25T15:08:29.667Z
8481493 8481493 20251116031806_YzEo3 DK000E 2025-11-17T14:21:05.110Z 2025-11-24T15:05:03.939Z
8470194 8470194 20251115043236_h9JPv DK000E 2025-11-16T14:22:09.696Z 2025-11-23T15:18:01.086Z
8469913 8469913 20251115035015_OTs5d DK000E 2025-11-16T14:21:29.584Z 2025-11-23T15:17:58.736Z
8469674 8469674 20251115031648_EyZqs DK000E 2025-11-16T14:20:49.251Z 2025-11-23T15:17:54.024Z
8469300 8469300 20251115022833_cexa0 DK000E 2025-11-16T14:19:54.670Z 2025-11-23T15:17:38.113Z
8469255 8469255 20251115022300_CSG2l DK000E 2025-11-16T14:19:50.566Z 2025-11-23T15:17:37.771Z
8468351 8468351 20251114235108_Ob2U7 DK000E 2025-11-16T14:17:17.951Z 2025-11-23T15:17:15.747Z
8468233 8468233 20251114232156_fi5TN DK000E 2025-11-16T14:17:00.834Z 2025-11-23T15:17:14.842Z
8467973 8467973 20251114222306_zCgpY DK000E 2025-11-16T14:16:09.155Z 2025-11-23T15:17:13.408Z
8458084 8458084 20251113222810_nNXHe DK000E 2025-11-15T14:15:27.317Z 2025-11-22T15:20:58.795Z
8458008 8458008 20251113220823_mBZWB DK000E 2025-11-15T14:15:16.976Z 2025-11-22T15:20:57.800Z
8457893 8457893 20251113214055_3HEMJ DK000E 2025-11-15T14:14:52.548Z 2025-11-22T15:20:56.028Z
8333429 8333429 20251031001340_azZDD DK000E 2025-11-02T14:22:39.746Z 2025-11-08T15:12:53.997Z
8333012 8333012 20251030232351_gnwXb DK000E 2025-11-02T14:21:40.148Z 2025-11-08T15:12:46.677Z
8332890 8332890 20251030230950_LTqyw DK000E 2025-11-02T14:21:11.900Z 2025-11-08T15:12:44.380Z
8332781 8332781 20251030225630_UJkp5 DK000E 2025-11-02T14:21:02.928Z 2025-11-08T15:12:43.237Z
8332468 8332468 20251030220813_ZvQhP DK000E 2025-11-02T14:20:13.239Z 2025-11-08T15:12:32.953Z
8331636 8331636 20251101024022_cIC8y DK000E 2025-11-02T14:11:02.357Z 2025-11-02T14:11:02.357Z
8331195 8331195 20251101012917_QrP6L DK000E 2025-11-02T14:09:19.578Z 2025-11-09T15:01:23.434Z
8331090 8331090 20251101011128_xRqVR DK000E 2025-11-02T14:08:54.671Z 2025-11-09T15:01:00.738Z
8284395 8284395 20251028044014_n1Ich DK000E 2025-10-29T12:45:31.922Z 2025-11-05T15:22:46.102Z
8284373 8284373 20251028043901_lSiG7 DK000E 2025-10-29T12:45:31.021Z 2025-10-29T12:45:31.021Z
8284321 8284321 20251028043450_ve4Rq DK000E 2025-10-29T12:45:29.598Z 2025-10-29T12:45:29.598Z
8283824 8283824 20251028040259_CnkrT DK000E 2025-10-29T12:45:09.798Z 2025-11-05T15:22:33.310Z
8283463 8283463 20251028034154_hVua6 DK000E 2025-10-29T12:44:25.792Z 2025-11-05T15:22:16.740Z
8282716 8282716 20251028024259_pnq90 DK000E 2025-10-29T12:43:25.438Z 2025-11-05T15:21:47.457Z
8260498 8260498 20251026032423_E3bmP DK000E 2025-10-28T12:33:52.591Z 2025-11-03T15:16:31.933Z
8259481 8259481 20251026025057_nJMOf DK000E 2025-10-28T12:32:49.720Z 2025-11-03T15:16:26.386Z
8259166 8259166 20251026024154_QeAM5 DK000E 2025-10-28T12:32:15.669Z 2025-11-03T15:16:24.687Z
8258962 8258962 20251026023431_0WPuQ DK000E 2025-10-28T12:31:56.382Z 2025-11-03T15:16:24.039Z
8258774 8258774 20251026023012_iflaE DK000E 2025-10-28T12:31:51.762Z 2025-11-03T15:16:23.729Z
8257404 8257404 20251026015345_6zTfu DK000E 2025-10-28T12:30:39.368Z 2025-11-03T15:16:18.677Z
8257085 8257085 20251026014534_2ut2U DK000E 2025-10-28T12:30:11.747Z 2025-10-28T12:42:15.039Z
8256447 8256447 20251026013007_TMgwS DK000E 2025-10-28T12:29:32.867Z 2025-11-03T15:16:15.888Z
8256227 8256227 20251026012325_1bIyd DK000E 2025-10-28T12:29:24.124Z 2025-11-03T15:16:14.413Z
8256011 8256011 20251026011624_0i4Fx DK000E 2025-10-28T12:29:15.171Z 2025-11-03T15:16:13.123Z
8228901 8228901 20251023040557_QxVA1 DK000E 2025-10-26T12:52:08.437Z 2025-10-31T13:08:47.014Z
8228892 8228892 20251022210222_KJxi1 DK000E 2025-10-26T12:50:03.787Z 2025-10-31T13:08:17.925Z
8214521 8214521 20251024005151_kGkiz DK000E 2025-10-26T12:29:11.505Z 2025-11-01T13:10:21.199Z
8212143 8212143 20251023223711_5EwLC DK000E 2025-10-26T12:25:16.457Z 2025-11-01T13:10:11.533Z
8201401 8201401 20251023034936_oUTgu DK000E 2025-10-25T12:16:55.720Z 2025-10-31T13:08:45.542Z
8200728 8200728 20251023013228_U6Xwm DK000E 2025-10-25T12:13:38.245Z 2025-10-31T13:08:36.013Z
8200703 8200703 20251023012512_gkY20 DK000E 2025-10-25T12:13:34.034Z 2025-10-31T13:08:35.641Z
8200653 8200653 20251023011452_mH21U DK000E 2025-10-25T12:13:22.407Z 2025-10-31T13:08:35.055Z
8200642 8200642 20251023011334_Lk80k DK000E 2025-10-25T12:13:20.632Z 2025-10-31T13:08:35.050Z
8200637 8200637 20251023011313_rkVCl DK000E 2025-10-25T12:13:20.125Z 2025-10-31T13:08:35.018Z
8200582 8200582 20251023005945_A8BS3 DK000E 2025-10-25T12:13:01.119Z 2025-10-31T13:08:33.212Z

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