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

6,232 rows where station_code = "DE000Q" 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
9604962 9604962 20260402021936_NvteE DE000Q 2026-04-03T12:12:26.880Z 2026-04-06T12:26:35.231Z
9604790 9604790 20260402004120_8WHdf DE000Q 2026-04-03T12:11:33.212Z 2026-04-06T12:26:19.337Z
9604736 9604736 20260402001151_8Nr3L DE000Q 2026-04-03T12:11:23.601Z 2026-04-06T12:26:14.774Z
9604636 9604636 20260401225036_RdvV8 DE000Q 2026-04-03T12:10:56.812Z 2026-04-06T12:26:08.484Z
9602876 9602876 20260402034514_NVrRJ DE000Q 2026-04-03T12:01:02.053Z 2026-04-06T12:21:18.227Z
9602579 9602579 20260331235720_N3GX7 DE000Q 2026-04-02T12:09:25.246Z 2026-04-06T12:29:24.296Z
9602563 9602563 20260331232703_04I1r DE000Q 2026-04-02T12:09:21.856Z 2026-04-06T12:29:23.243Z
9602479 9602479 20260331213425_GVTyl DE000Q 2026-04-02T12:09:01.941Z 2026-04-06T12:29:13.528Z
9600822 9600822 20260401032325_RD0RH DE000Q 2026-04-02T12:00:28.213Z 2026-04-06T12:24:11.773Z
9600711 9600711 20260331012341_kBjF5 DE000Q 2026-04-01T12:11:37.170Z 2026-04-06T12:33:47.357Z
9600535 9600535 20260330231508_dUFr2 DE000Q 2026-04-01T12:11:06.768Z 2026-04-06T12:33:33.105Z
9600532 9600532 20260330231507_dyALT DE000Q 2026-04-01T12:11:06.412Z 2026-04-06T12:33:32.933Z
9600288 9600288 20260330193400_DxuBV DE000Q 2026-04-01T12:10:08.118Z 2026-04-06T12:33:13.670Z
9598687 9598687 20260331025343_R193N DE000Q 2026-04-01T12:00:33.358Z 2026-04-06T12:26:47.096Z
9588704 9588704 20260327003606_g14u1 DE000Q 2026-03-28T12:11:40.938Z 2026-04-04T12:42:28.089Z
9588638 9588638 20260327001518_4WhTd DE000Q 2026-03-28T12:11:30.379Z 2026-04-04T12:42:23.505Z
9588442 9588442 20260326230205_812xx DE000Q 2026-03-28T12:11:10.890Z 2026-04-04T12:42:08.718Z
9588221 9588221 20260326190127_pR1R5 DE000Q 2026-03-28T12:10:29.673Z 2026-04-04T12:41:40.734Z
9575563 9575563 20260323232119_zZbI2 DE000Q 2026-03-25T12:21:24.523Z 2026-03-31T12:29:01.939Z
9571422 9571422 20260324015946_MGXIc DE000Q 2026-03-25T12:01:24.303Z 2026-04-02T12:34:25.878Z
9571344 9571344 20260324012949_F2iJz DE000Q 2026-03-25T12:01:07.925Z 2026-04-02T12:34:22.069Z
9561132 9561132 20260321230314_z5Q4W DE000Q 2026-03-23T12:12:12.053Z 2026-03-29T12:21:05.274Z
9560251 9560251 20260321205343_Me3eg DE000Q 2026-03-23T12:11:40.750Z 2026-03-29T12:20:58.798Z
9555041 9555041 20260322035836_nitRs DE000Q 2026-03-23T12:03:06.555Z 2026-03-30T12:28:13.571Z
9555006 9555006 20260322035340_bs3aL DE000Q 2026-03-23T12:03:02.061Z 2026-03-30T12:28:13.071Z
9553422 9553422 20260322014117_GVgdj DE000Q 2026-03-23T12:01:29.152Z 2026-03-30T12:27:40.795Z
9552708 9552708 20260322003312_B2mGR DE000Q 2026-03-23T12:00:44.848Z 2026-03-30T12:27:28.712Z
9552477 9552477 20260322001403_rxqrC DE000Q 2026-03-23T12:00:28.234Z 2026-03-30T12:27:24.925Z
9551721 9551721 20260320211046_pykTV DE000Q 2026-03-22T12:26:58.593Z 2026-03-28T12:37:00.988Z
9543420 9543420 20260321035000_ZtJca DE000Q 2026-03-22T12:03:46.311Z 2026-03-29T12:19:07.334Z
9541730 9541730 20260319213436_U8R38 DE000Q 2026-03-21T12:29:18.731Z 2026-03-27T12:42:41.115Z
9541523 9541523 20260319205154_xNib2 DE000Q 2026-03-21T12:29:02.487Z 2026-03-27T12:42:38.496Z
9541343 9541343 20260319201844_eBros DE000Q 2026-03-21T12:28:50.691Z 2026-03-27T12:42:36.664Z
9534721 9534721 20260320041502_IsFSl DE000Q 2026-03-21T12:08:42.986Z 2026-03-28T12:34:21.343Z
9534238 9534238 20260320033803_Lho3R DE000Q 2026-03-21T12:07:30.511Z 2026-03-28T12:34:16.414Z
9534199 9534199 20260320033520_XrUDi DE000Q 2026-03-21T12:07:25.806Z 2026-03-28T12:34:15.969Z
9534173 9534173 20260320033338_Qgydh DE000Q 2026-03-21T12:07:21.226Z 2026-03-28T12:34:15.429Z
9533786 9533786 20260320025822_WGqox DE000Q 2026-03-21T12:06:16.977Z 2026-03-28T12:34:00.503Z
9532996 9532996 20260320014444_hvQii DE000Q 2026-03-21T12:04:10.385Z 2026-03-28T12:33:47.312Z
9529990 9529990 20260318195139_88MN3 DE000Q 2026-03-20T12:23:53.622Z 2026-03-26T12:39:08.170Z
9521292 9521292 20260319040321_kylfx DE000Q 2026-03-20T12:07:49.150Z 2026-03-27T12:40:53.616Z
9521018 9521018 20260319034903_20KJP DE000Q 2026-03-20T12:07:22.821Z 2026-03-27T12:40:50.145Z
9519998 9519998 20260319024731_bMMgO DE000Q 2026-03-20T12:05:31.091Z 2026-03-27T12:40:37.835Z
9519627 9519627 20260319022313_MgIZE DE000Q 2026-03-20T12:04:47.454Z 2026-03-27T12:40:33.464Z
9519013 9519013 20260319014102_Rat3B DE000Q 2026-03-20T12:03:46.734Z 2026-03-27T12:40:17.293Z
9518625 9518625 20260319011406_Swupa DE000Q 2026-03-20T12:03:01.012Z 2026-03-27T12:40:12.076Z
9518454 9518454 20260319010227_3XrHd DE000Q 2026-03-20T12:02:37.224Z 2026-03-27T12:40:10.028Z
9517613 9517613 20260318234749_MpQgb DE000Q 2026-03-20T12:00:51.759Z 2026-03-27T12:40:01.591Z
9516073 9516073 20260317195105_arGJo DE000Q 2026-03-19T12:25:36.802Z 2026-03-25T12:42:47.703Z
9512024 9512024 20260318043517_38kfs DE000Q 2026-03-19T12:11:30.461Z 2026-03-26T12:37:41.611Z
9511121 9511121 20260318033706_fXOYT DE000Q 2026-03-19T12:09:30.685Z 2026-03-26T12:37:21.642Z
9511113 9511113 20260318033706_4KEKc DE000Q 2026-03-19T12:09:30.523Z 2026-03-26T12:37:21.002Z
9510448 9510448 20260318025321_CCvNP DE000Q 2026-03-19T12:07:40.911Z 2026-03-26T12:37:12.552Z
9510081 9510081 20260318023210_Dt3x3 DE000Q 2026-03-19T12:06:51.911Z 2026-03-26T12:37:09.813Z
9509957 9509957 20260318022326_2W527 DE000Q 2026-03-19T12:06:32.533Z 2026-03-26T12:37:08.815Z
9509680 9509680 20260318020653_w0e0A DE000Q 2026-03-19T12:05:57.660Z 2026-03-26T12:37:07.022Z
9509675 9509675 20260318020652_fpcnw DE000Q 2026-03-19T12:05:57.358Z 2026-03-26T12:37:07.020Z
9507526 9507526 20260317231356_XMS3p DE000Q 2026-03-19T12:00:22.905Z 2026-03-26T12:36:37.711Z
9507343 9507343 20260316211640_ID1S3 DE000Q 2026-03-18T12:20:18.969Z 2026-03-24T12:41:45.798Z
9500743 9500743 20260315190026_O3bGS DE000Q 2026-03-17T12:23:45.770Z 2026-03-23T12:22:41.170Z
9474348 9474348 20260312224316_A0pJZ DE000Q 2026-03-14T12:22:40.165Z 2026-03-20T12:37:18.503Z
9474061 9474061 20260312200151_ufHqB DE000Q 2026-03-14T12:21:52.790Z 2026-03-20T12:37:15.311Z
9474013 9474013 20260312192452_V4MjO DE000Q 2026-03-14T12:21:44.354Z 2026-03-20T12:37:14.597Z
9469493 9469493 20260313025804_CwsuR DE000Q 2026-03-14T12:04:28.099Z 2026-03-21T12:48:40.321Z
9469374 9469374 20260313023928_xHmQC DE000Q 2026-03-14T12:04:02.781Z 2026-03-21T12:48:38.277Z
9468843 9468843 20260313005352_DDjvZ DE000Q 2026-03-14T12:01:59.529Z 2026-03-21T12:48:30.035Z
9468779 9468779 20260313004000_NiWdP DE000Q 2026-03-14T12:01:45.251Z 2026-03-21T12:48:28.986Z
9467266 9467266 20260311210947_q8YVy DE000Q 2026-03-13T12:18:54.511Z 2026-03-19T12:45:51.156Z
9460798 9460798 20260310222743_OP0NN DE000Q 2026-03-12T12:15:08.612Z 2026-03-18T12:40:19.609Z
9456729 9456729 20260311003632_G4Iw6 DE000Q 2026-03-12T12:01:36.245Z 2026-03-19T12:44:21.263Z
9450285 9450285 20260308195400_5nIcL DE000Q 2026-03-10T12:19:09.287Z 2026-03-16T12:44:39.423Z
9447090 9447090 20260309044312_2SZ1m DE000Q 2026-03-10T12:05:08.876Z 2026-03-17T12:41:47.405Z
9446610 9446610 20260309022132_9WdMt DE000Q 2026-03-10T12:03:07.707Z 2026-03-17T12:41:40.208Z
9446599 9446599 20260309021939_LR6SC DE000Q 2026-03-10T12:03:06.312Z 2026-03-17T12:41:40.145Z
9446541 9446541 20260309020649_hjgYJ DE000Q 2026-03-10T12:02:51.652Z 2026-03-17T12:41:39.472Z
9446226 9446226 20260309003023_6vojr DE000Q 2026-03-10T12:01:33.703Z 2026-03-17T12:41:34.867Z
9445701 9445701 20260307211327_eUuPj DE000Q 2026-03-09T12:20:26.709Z 2026-03-15T12:42:13.439Z
9442654 9442654 20260308044321_FfTpg DE000Q 2026-03-09T12:04:53.340Z 2026-03-16T12:43:54.523Z
9441371 9441371 20260306212205_ucpZu DE000Q 2026-03-08T12:21:37.226Z 2026-03-14T12:40:51.464Z
9436525 9436525 20260303040026_ebAdP DE000Q 2026-03-07T14:31:34.082Z 2026-03-11T12:28:01.361Z
9436523 9436523 20260303025625_28TxK DE000Q 2026-03-07T14:31:21.302Z 2026-03-11T12:27:58.027Z
9436519 9436519 20260303005447_Wxphr DE000Q 2026-03-07T14:30:58.562Z 2026-03-11T12:27:44.295Z
9436502 9436502 20260305223919_UNcVs DE000Q 2026-03-07T14:26:10.565Z 2026-03-13T12:36:00.639Z
9436377 9436377 20260305211441_UUILP DE000Q 2026-03-07T14:25:42.603Z 2026-03-13T12:35:59.242Z
9436319 9436319 20260305205030_fqmHK DE000Q 2026-03-07T14:25:27.247Z 2026-03-13T12:35:58.266Z
9436261 9436261 20260305202148_kLOPh DE000Q 2026-03-07T14:25:12.548Z 2026-03-13T12:35:54.209Z
9436096 9436096 20260305191122_9MOf5 DE000Q 2026-03-07T14:24:28.648Z 2026-03-13T12:35:40.691Z
9431772 9431772 20260306015315_w2gzY DE000Q 2026-03-07T14:01:58.224Z 2026-03-14T12:39:17.291Z
9431613 9431613 20260306005244_3xHbz DE000Q 2026-03-07T14:01:21.280Z 2026-03-14T12:39:15.290Z
9431569 9431569 20260306003005_YLvhO DE000Q 2026-03-07T14:01:09.730Z 2026-03-14T12:39:14.628Z
9430821 9430821 20260304211153_xMr4v DE000Q 2026-03-06T14:24:31.008Z 2026-03-12T12:33:42.481Z
9430634 9430634 20260304202107_f3tqK DE000Q 2026-03-06T14:23:48.891Z 2026-03-12T12:33:39.309Z
9430465 9430465 20260304190800_OJzNN DE000Q 2026-03-06T14:23:04.314Z 2026-03-12T12:33:31.354Z
9426820 9426820 20260305045440_KBIB2 DE000Q 2026-03-06T14:06:29.708Z 2026-03-13T12:34:51.510Z
9426579 9426579 20260305035533_Ey2hy DE000Q 2026-03-06T14:05:28.798Z 2026-03-13T12:34:48.151Z
9426526 9426526 20260305034422_IHtDk DE000Q 2026-03-06T14:05:15.585Z 2026-03-13T12:34:47.536Z
9426330 9426330 20260305030959_R3fZU DE000Q 2026-03-06T14:04:21.272Z 2026-03-13T12:34:45.156Z
9426221 9426221 20260305024328_9TjaS DE000Q 2026-03-06T14:03:49.183Z 2026-03-13T12:34:43.757Z
9425890 9425890 20260305011318_4Cdsr DE000Q 2026-03-06T14:02:17.053Z 2026-03-13T12:34:39.466Z
9425847 9425847 20260305005243_7BSQK DE000Q 2026-03-06T14:02:00.946Z 2026-03-13T12:34:29.024Z

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