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

5,712 rows where station_code = "DE0007" 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
9259977 9259977 20260125014102_xp8ng DE0007 2026-01-26T14:19:38.598Z 2026-01-29T14:43:38.697Z
9252599 9252599 20260123043609_y8TOM DE0007 2026-01-24T14:16:24.908Z 2026-01-29T14:53:10.767Z
9249543 9249543 20260122053921_6VE3Y DE0007 2026-01-23T14:15:40.730Z 2026-01-29T14:58:43.825Z
9249367 9249367 20260122050308_zaaij DE0007 2026-01-23T14:15:14.180Z 2026-01-29T14:58:27.437Z
9249276 9249276 20260122043530_u9Z2n DE0007 2026-01-23T14:15:06.363Z 2026-01-29T14:58:21.433Z
9249226 9249226 20260122041708_mmld4 DE0007 2026-01-23T14:15:00.913Z 2026-01-29T14:58:18.454Z
9249101 9249101 20260122033633_130Gh DE0007 2026-01-23T14:14:34.898Z 2026-01-29T14:58:12.599Z
9249057 9249057 20260122032352_PJjr6 DE0007 2026-01-23T14:14:31.141Z 2026-01-29T14:58:10.987Z
9248986 9248986 20260122030436_kKZ2g DE0007 2026-01-23T14:14:16.248Z 2026-01-29T14:58:06.917Z
9248914 9248914 20260122024204_y1Aea DE0007 2026-01-23T14:14:06.263Z 2026-01-29T14:57:54.494Z
9248884 9248884 20260122023547_3IIm5 DE0007 2026-01-23T14:14:02.865Z 2026-01-29T14:57:52.942Z
9248670 9248670 20260122013746_9lOGV DE0007 2026-01-23T14:13:23.591Z 2026-01-29T14:57:39.916Z
9248659 9248659 20260122013401_cTNhp DE0007 2026-01-23T14:13:22.285Z 2026-01-29T14:57:39.161Z
9248593 9248593 20260122005848_37j9o DE0007 2026-01-23T14:13:13.607Z 2026-01-29T14:57:36.003Z
9248566 9248566 20260122004233_DIqf8 DE0007 2026-01-23T14:13:05.183Z 2026-01-29T14:57:26.741Z
9248244 9248244 20260121222905_SXr2A DE0007 2026-01-23T14:12:18.626Z 2026-01-29T14:57:09.759Z
9248151 9248151 20260121215304_P0VAG DE0007 2026-01-23T14:12:08.562Z 2026-01-29T14:57:05.436Z
9247471 9247471 20260121184044_V2UzF DE0007 2026-01-23T14:10:09.408Z 2026-01-29T14:56:10.811Z
9247301 9247301 20260121175536_GiC0o DE0007 2026-01-23T14:09:38.133Z 2026-01-29T14:56:02.908Z
9237841 9237841 20260120061120_usFOF DE0007 2026-01-21T14:27:45.223Z 2026-01-28T15:01:44.295Z
9237756 9237756 20260120060056_Qb2X2 DE0007 2026-01-21T14:27:35.229Z 2026-01-28T15:01:39.552Z
9236771 9236771 20260120035805_URTaV DE0007 2026-01-21T14:24:03.349Z 2026-01-28T15:00:34.122Z
9235898 9235898 20260120021539_cWLsm DE0007 2026-01-21T14:20:42.258Z 2026-01-28T14:59:26.878Z
9234745 9234745 20260119231418_DzTv3 DE0007 2026-01-21T14:15:57.549Z 2026-01-28T14:58:04.065Z
9234377 9234377 20260119210645_HDuob DE0007 2026-01-21T14:14:03.900Z 2026-01-28T14:57:34.757Z
9228356 9228356 20260118214826_DcuGV DE0007 2026-01-20T14:17:24.413Z 2026-01-27T15:01:55.730Z
9217707 9217707 20260116191704_ii2UC DE0007 2026-01-18T14:08:37.910Z 2026-01-25T14:57:45.064Z
9181747 9181747 20260111030153_AetFa DE0007 2026-01-12T14:12:00.270Z 2026-01-19T15:17:46.959Z
9181597 9181597 20260111022343_S0643 DE0007 2026-01-12T14:11:24.128Z 2026-01-19T15:17:39.357Z
9151042 9151042 20260105042934_MbIiS DE0007 2026-01-06T14:12:26.347Z 2026-01-13T15:14:16.268Z
9147444 9147444 20260104055039_AJEjQ DE0007 2026-01-05T14:24:10.882Z 2026-01-12T15:10:57.139Z
9145240 9145240 20260104030920_Bphld DE0007 2026-01-05T14:20:20.233Z 2026-01-12T15:07:44.729Z
9128071 9128071 20260102061022_KwupT DE0007 2026-01-03T14:13:10.103Z 2026-01-09T14:50:22.578Z
9123555 9123555 20251231020423_4vlJr DE0007 2026-01-02T14:30:59.144Z 2026-01-08T15:07:18.149Z
9112350 9112350 20251231022036_w8G6F DE0007 2026-01-01T14:14:47.710Z 2026-01-08T15:07:38.594Z
9112305 9112305 20251231021832_R13Jb DE0007 2026-01-01T14:14:39.720Z 2026-01-08T15:07:37.444Z
9112078 9112078 20251231020421_E9XWt DE0007 2026-01-01T14:13:55.435Z 2026-01-08T15:07:17.944Z
9111236 9111236 20251231005159_RhhfJ DE0007 2026-01-01T14:10:41.357Z 2026-01-08T15:06:24.160Z
9111162 9111162 20251231004340_eird1 DE0007 2026-01-01T14:10:20.324Z 2026-01-08T15:06:18.670Z
9110854 9110854 20251231000935_da8BZ DE0007 2026-01-01T14:09:03.451Z 2026-01-08T15:05:56.821Z
9110815 9110815 20251231000401_vTU4m DE0007 2026-01-01T14:08:53.438Z 2026-01-08T15:05:52.640Z
9110698 9110698 20251230235129_SxFYs DE0007 2026-01-01T14:08:27.031Z 2026-01-08T15:05:45.907Z
9110091 9110091 20251230221647_Mmttr DE0007 2026-01-01T14:05:47.038Z 2026-01-08T15:05:00.623Z
9109577 9109577 20251230195945_WlBXO DE0007 2026-01-01T14:01:53.208Z 2026-01-08T15:04:03.993Z
9099745 9099745 20251225055918_IYkeD DE0007 2025-12-30T15:31:12.635Z 2026-01-02T15:45:38.482Z
9099735 9099735 20251225054118_rSmEC DE0007 2025-12-30T15:31:02.803Z 2026-01-02T15:45:33.413Z
9099531 9099531 20251225021933_Erq3t DE0007 2025-12-30T15:27:01.817Z 2026-01-02T15:43:34.370Z
9098854 9098854 20251227201218_a3G91 DE0007 2025-12-30T15:11:11.549Z 2026-01-04T15:35:29.261Z
9091443 9091443 20251228185850_f17ZG DE0007 2025-12-30T14:52:40.282Z 2026-01-05T15:14:13.129Z
9091066 9091066 20251228174745_MYSDk DE0007 2025-12-30T14:51:41.956Z 2026-01-05T15:14:00.829Z
9086884 9086884 20251228055756_6l7p8 DE0007 2025-12-30T14:42:24.339Z 2026-01-05T15:10:35.140Z
9083141 9083141 20251227230349_DDuzU DE0007 2025-12-30T14:31:46.524Z 2026-01-05T15:07:38.503Z
9082701 9082701 20251227213044_RopPF DE0007 2025-12-30T14:30:17.608Z 2026-01-05T15:07:13.905Z
9081198 9081198 20251229060014_uy3X3 DE0007 2025-12-30T14:24:06.022Z 2026-01-06T15:18:54.062Z
9081069 9081069 20251229053837_uRrGX DE0007 2025-12-30T14:23:45.075Z 2026-01-06T15:18:50.116Z
9080985 9080985 20251229052604_WVOGX DE0007 2025-12-30T14:23:22.299Z 2026-01-06T15:18:47.067Z
9080676 9080676 20251229050008_vZ3Qa DE0007 2025-12-30T14:22:11.106Z 2026-01-06T15:18:24.594Z
9080362 9080362 20251229043352_InqDL DE0007 2025-12-30T14:20:52.187Z 2026-01-06T15:18:14.030Z
9080071 9080071 20251229041125_NvnjT DE0007 2025-12-30T14:19:45.323Z 2026-01-06T15:17:51.030Z
9080019 9080019 20251229040705_mZn2F DE0007 2025-12-30T14:19:26.112Z 2026-01-06T15:17:48.542Z
9079989 9079989 20251229040420_TIXES DE0007 2025-12-30T14:19:18.215Z 2026-01-06T15:17:47.386Z
9079129 9079129 20251229025624_2uI3I DE0007 2025-12-30T14:15:53.981Z 2026-01-06T15:17:01.786Z
9078926 9078926 20251229024035_QEzCK DE0007 2025-12-30T14:15:00.819Z 2026-01-06T15:16:45.788Z
9078796 9078796 20251229023003_l0pgC DE0007 2025-12-30T14:14:31.615Z 2026-01-06T15:16:41.936Z
9078581 9078581 20251229021305_rh0Zq DE0007 2025-12-30T14:13:38.074Z 2026-01-06T15:16:32.900Z
9076815 9076815 20251228231425_RlbLR DE0007 2025-12-30T14:05:10.141Z 2026-01-06T15:14:55.682Z
9076618 9076618 20251228223951_KMJws DE0007 2025-12-30T14:04:22.278Z 2025-12-31T14:31:41.707Z
9076362 9076362 20251228215736_iSjnD DE0007 2025-12-30T14:03:12.909Z 2026-01-06T15:14:25.663Z
9075965 9075965 20251228204046_CIUta DE0007 2025-12-30T14:00:44.583Z 2026-01-06T15:14:08.355Z
9075133 9075133 20251225210842_lhXfp DE0007 2025-12-29T15:01:30.264Z 2026-01-02T15:48:44.860Z
9074600 9074600 20251225201459_OX7Zj DE0007 2025-12-29T15:01:11.373Z 2026-01-02T15:48:34.302Z
9072944 9072944 20251225055918_7RXbw DE0007 2025-12-29T14:56:51.858Z 2026-01-02T15:45:38.435Z
9072182 9072182 20251226203424_RTiTA DE0007 2025-12-29T14:50:28.020Z 2026-01-03T15:43:44.556Z
9072164 9072164 20251226203337_r3e07 DE0007 2025-12-29T14:50:26.986Z 2025-12-30T15:23:21.196Z
9071476 9071476 20251226184346_Y1bj0 DE0007 2025-12-29T14:49:31.331Z 2026-01-03T15:42:56.533Z
9071338 9071338 20251226182854_cabu9 DE0007 2025-12-29T14:49:24.621Z 2026-01-03T15:42:48.900Z
9066485 9066485 20251226061835_6PXFb DE0007 2025-12-29T14:40:04.237Z 2026-01-03T15:37:51.009Z
9066065 9066065 20251226054829_7HSH2 DE0007 2025-12-29T14:39:29.437Z 2026-01-03T15:37:30.135Z
9065842 9065842 20251226053512_AAa0O DE0007 2025-12-29T14:39:07.409Z 2026-01-03T15:37:21.589Z
9065792 9065792 20251226053111_W0SBf DE0007 2025-12-29T14:39:04.308Z 2026-01-03T15:37:19.669Z
9063137 9063137 20251226025620_Co5cx DE0007 2025-12-29T14:34:44.433Z 2026-01-03T15:35:05.661Z
9062769 9062769 20251226023749_2Rx39 DE0007 2025-12-29T14:34:06.293Z 2026-01-03T15:34:41.256Z
9062588 9062588 20251226022536_9KtL2 DE0007 2025-12-29T14:33:39.813Z 2026-01-03T15:34:35.979Z
9061590 9061590 20251226011216_9IAok DE0007 2025-12-29T14:31:37.870Z 2026-01-03T15:33:43.410Z
9061434 9061434 20251226010132_MIscW DE0007 2025-12-29T14:31:19.533Z 2026-01-03T15:33:36.737Z
9061181 9061181 20251226004123_ik2Uf DE0007 2025-12-29T14:30:50.939Z 2026-01-03T15:33:29.255Z
9061103 9061103 20251226003311_hCDXV DE0007 2025-12-29T14:30:38.911Z 2026-01-03T15:33:26.640Z
9058224 9058224 20251227054008_LjhBS DE0007 2025-12-29T14:24:28.560Z 2026-01-04T15:30:17.203Z
9058084 9058084 20251227053341_OszfM DE0007 2025-12-29T14:24:13.780Z 2026-01-04T15:30:14.044Z
9057636 9057636 20251227051249_cu9wf DE0007 2025-12-29T14:23:19.392Z 2026-01-04T15:29:51.413Z
9056976 9056976 20251227044116_VsIGp DE0007 2025-12-29T14:22:00.824Z 2026-01-04T15:29:18.317Z
9056777 9056777 20251227043228_1MlOZ DE0007 2025-12-29T14:21:32.286Z 2026-01-04T15:29:11.458Z
9055731 9055731 20251227033606_vFbjM DE0007 2025-12-29T14:18:53.694Z 2026-01-04T15:28:15.749Z
9055685 9055685 20251227033352_tbMKx DE0007 2025-12-29T14:18:41.163Z 2026-01-04T15:28:12.434Z
9055193 9055193 20251227031105_TaGhI DE0007 2025-12-29T14:17:24.915Z 2026-01-04T15:27:45.918Z
9055085 9055085 20251227030545_uS5Q2 DE0007 2025-12-29T14:17:05.642Z 2026-01-04T15:27:41.462Z
9053805 9053805 20251227020258_hnZAl DE0007 2025-12-29T14:13:38.202Z 2026-01-04T15:26:31.605Z
9053370 9053370 20251227014102_8e2Dm DE0007 2025-12-29T14:12:28.685Z 2026-01-04T15:26:16.763Z
9053149 9053149 20251227012954_bqReA DE0007 2025-12-29T14:11:54.530Z 2026-01-04T15:25:58.036Z
9053000 9053000 20251227012249_cM5QW DE0007 2025-12-29T14:11:33.856Z 2026-01-04T15:25:53.576Z

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