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,731 rows where station_code = "DE000K" 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
8690416 8690416 20251204233151_hNvDc DE000K 2025-12-06T14:14:14.976Z 2025-12-06T14:18:00.877Z
8690268 8690268 20251204222652_sDlaP DE000K 2025-12-06T14:13:55.469Z 2025-12-06T14:18:00.852Z
8690252 8690252 20251204222519_9hjV2 DE000K 2025-12-06T14:13:53.211Z 2025-12-06T14:18:00.850Z
8690238 8690238 20251204222244_9Y6wL DE000K 2025-12-06T14:13:51.890Z 2025-12-06T14:18:00.847Z
8690230 8690230 20251204221959_rtGus DE000K 2025-12-06T14:13:50.431Z 2025-12-06T14:18:00.844Z
8690153 8690153 20251204212259_3UH3w DE000K 2025-12-06T14:13:30.703Z 2025-12-06T14:18:00.826Z
8689877 8689877 20251204174329_9wbDX DE000K 2025-12-06T14:12:24.920Z 2025-12-06T14:18:00.744Z
8666528 8666528 20251201060718_r3p3p DE000K 2025-12-02T14:26:23.702Z 2025-12-06T14:42:31.475Z
8666444 8666444 20251201054206_birNH DE000K 2025-12-02T14:26:14.195Z 2025-12-06T14:42:22.459Z
8666090 8666090 20251201043527_3Y05f DE000K 2025-12-02T14:25:13.083Z 2025-12-06T14:42:11.450Z
8666054 8666054 20251201042813_GOky4 DE000K 2025-12-02T14:25:09.340Z 2025-12-06T14:42:10.607Z
8665907 8665907 20251201040925_uQ3du DE000K 2025-12-02T14:24:54.351Z 2025-12-06T14:42:06.758Z
8665804 8665804 20251201040044_mk0l4 DE000K 2025-12-02T14:24:30.734Z 2025-12-06T14:42:03.908Z
8665781 8665781 20251201035740_X3dEK DE000K 2025-12-02T14:24:28.618Z 2025-12-06T14:42:03.297Z
8665649 8665649 20251201034713_Oo1gK DE000K 2025-12-02T14:24:16.444Z 2025-12-06T14:41:44.710Z
8665501 8665501 20251201032844_hmuQ4 DE000K 2025-12-02T14:23:47.597Z 2025-12-06T14:41:39.004Z
8665326 8665326 20251201030753_71wBl DE000K 2025-12-02T14:23:32.016Z 2025-12-06T14:41:34.885Z
8665319 8665319 20251201030739_IZ4CH DE000K 2025-12-02T14:23:31.300Z 2025-12-06T14:41:34.796Z
8665259 8665259 20251201025649_UlPwD DE000K 2025-12-02T14:23:13.850Z 2025-12-06T14:41:31.150Z
8665215 8665215 20251201024751_8CMd3 DE000K 2025-12-02T14:23:08.660Z 2025-12-06T14:41:29.619Z
8665201 8665201 20251201024640_GynJk DE000K 2025-12-02T14:23:07.458Z 2025-12-06T14:41:29.287Z
8665152 8665152 20251201023719_G3DDr DE000K 2025-12-02T14:23:02.132Z 2025-12-06T14:41:28.227Z
8664926 8664926 20251201020525_iiVlQ DE000K 2025-12-02T14:22:28.044Z 2025-12-06T14:41:03.280Z
8664908 8664908 20251201020317_FLbwK DE000K 2025-12-02T14:22:26.212Z 2025-12-06T14:41:02.803Z
8664820 8664820 20251201014542_IC7VD DE000K 2025-12-02T14:22:09.120Z 2025-12-06T14:40:58.936Z
8664763 8664763 20251201013437_GpbhW DE000K 2025-12-02T14:22:02.414Z 2025-12-06T14:40:56.799Z
8664734 8664734 20251201013340_aY3jH DE000K 2025-12-02T14:22:00.032Z 2025-12-06T14:40:56.071Z
8664539 8664539 20251201005444_vADkC DE000K 2025-12-02T14:21:18.379Z 2025-12-06T14:40:49.971Z
8664444 8664444 20251201002822_JbM73 DE000K 2025-12-02T14:21:05.226Z 2025-12-06T14:40:47.084Z
8664426 8664426 20251201002532_ZMt5v DE000K 2025-12-02T14:21:03.102Z 2025-12-06T14:40:46.518Z
8664209 8664209 20251130234250_HXPcH DE000K 2025-12-02T14:20:29.701Z 2025-12-06T14:40:41.533Z
8663904 8663904 20251130223126_2n6nv DE000K 2025-12-02T14:19:33.782Z 2025-12-06T14:40:15.869Z
8663178 8663178 20251130201836_D2QlR DE000K 2025-12-02T14:17:35.650Z 2025-12-06T14:39:55.305Z
8662762 8662762 20251130192831_hYp2C DE000K 2025-12-02T14:16:30.732Z 2025-12-06T14:39:28.392Z
8661984 8661984 20251130173945_ZnF9Z DE000K 2025-12-02T14:13:47.873Z 2025-12-06T14:38:45.149Z
8661963 8661963 20251130173627_qFQhs DE000K 2025-12-02T14:13:43.894Z 2025-12-06T14:38:44.238Z
8656109 8656109 20251130043810_nEilS DE000K 2025-12-01T14:28:04.066Z 2025-12-01T14:28:04.066Z
8654943 8654943 20251130033915_Y3omr DE000K 2025-12-01T14:26:12.436Z 2025-12-06T14:48:50.331Z
8647324 8647324 20251129042251_OBXn0 DE000K 2025-11-30T14:27:59.765Z 2025-12-06T14:56:36.799Z
8598961 8598961 20251125013759_EZv3M DE000K 2025-11-26T14:20:07.360Z 2025-12-02T15:08:15.088Z
8598144 8598144 20251125003756_aWMMQ DE000K 2025-11-26T14:18:21.709Z 2025-12-02T15:07:46.927Z
8597712 8597712 20251125000318_uo5xh DE000K 2025-11-26T14:17:25.524Z 2025-12-02T15:07:40.103Z
8591350 8591350 20251124040704_HmhMb DE000K 2025-11-25T14:23:58.270Z 2025-12-02T15:12:58.138Z
8581772 8581772 20251123021722_V4rFO DE000K 2025-11-24T14:32:37.169Z 2025-12-01T15:21:33.888Z
8580342 8580342 20251123035702_2l2Sw DE000K 2025-11-24T14:16:48.645Z 2025-12-01T15:22:15.174Z
8580308 8580308 20251123034802_2TUxX DE000K 2025-11-24T14:16:44.413Z 2025-12-01T15:22:14.455Z
8580273 8580273 20251123032921_eMliM DE000K 2025-11-24T14:16:39.792Z 2025-12-01T15:22:09.156Z
8580271 8580271 20251123032900_ymspb DE000K 2025-11-24T14:16:39.436Z 2025-12-01T15:22:08.751Z
8579946 8579946 20251123015654_LGqP2 DE000K 2025-11-24T14:15:41.221Z 2025-12-01T15:21:20.958Z
8579699 8579699 20251123005305_icoP1 DE000K 2025-11-24T14:14:59.926Z 2025-12-01T15:20:57.044Z
8579534 8579534 20251123001021_sIyyw DE000K 2025-11-24T14:14:34.443Z 2025-12-01T15:20:39.165Z
8579530 8579530 20251123000719_pLjO2 DE000K 2025-11-24T14:14:33.810Z 2025-12-01T15:20:38.569Z
8579140 8579140 20251122222818_JqC0R DE000K 2025-11-24T14:13:41.347Z 2025-12-01T15:20:04.711Z
8578704 8578704 20251122211839_Kcjl1 DE000K 2025-11-24T14:12:23.518Z 2025-12-01T15:19:50.345Z
8578435 8578435 20251122203702_KWsiI DE000K 2025-11-24T14:11:44.493Z 2025-12-01T15:19:37.330Z
8578136 8578136 20251122194828_zWeEl DE000K 2025-11-24T14:10:51.337Z 2025-12-01T15:19:16.241Z
8577264 8577264 20251122174739_VvnrC DE000K 2025-11-24T14:08:09.333Z 2025-12-01T15:18:45.931Z
8577198 8577198 20251122173005_rl2rJ DE000K 2025-11-24T14:07:56.071Z 2025-12-01T15:18:44.664Z
8577130 8577130 20251122172342_PRHPw DE000K 2025-11-24T14:07:39.496Z 2025-12-01T15:18:43.857Z
8574170 8574170 20251122052130_3k13c DE000K 2025-11-23T14:42:37.666Z 2025-11-30T15:07:01.502Z
8574110 8574110 20251122051319_2HnP7 DE000K 2025-11-23T14:42:19.612Z 2025-11-30T15:06:58.979Z
8574088 8574088 20251122050731_BXa82 DE000K 2025-11-23T14:42:16.599Z 2025-11-30T15:06:58.368Z
8574076 8574076 20251122050550_cw8GU DE000K 2025-11-23T14:42:15.307Z 2025-11-30T15:06:56.765Z
8573781 8573781 20251122040916_r6M4u DE000K 2025-11-23T14:41:59.404Z 2025-11-30T15:06:37.609Z
8573590 8573590 20251122033802_LEMAt DE000K 2025-11-23T14:41:20.898Z 2025-11-30T15:06:31.936Z
8573533 8573533 20251122032635_CE7YI DE000K 2025-11-23T14:41:15.808Z 2025-11-30T15:06:30.145Z
8573312 8573312 20251122025534_DH6OA DE000K 2025-11-23T14:41:05.943Z 2025-11-30T15:06:16.070Z
8573196 8573196 20251122024247_bGTmo DE000K 2025-11-23T14:40:59.984Z 2025-11-30T15:06:12.431Z
8573155 8573155 20251122023607_9ig0J DE000K 2025-11-23T14:40:54.829Z 2025-11-30T15:06:11.358Z
8573017 8573017 20251122021727_sWE82 DE000K 2025-11-23T14:40:40.191Z 2025-11-30T15:06:08.629Z
8572991 8572991 20251122021505_QOdV0 DE000K 2025-11-23T14:40:32.882Z 2025-11-30T15:06:08.163Z
8572974 8572974 20251122021239_2Cusg DE000K 2025-11-23T14:40:29.195Z 2025-11-30T15:06:07.498Z
8572925 8572925 20251122020359_Z3tuq DE000K 2025-11-23T14:40:07.929Z 2025-11-30T15:06:06.815Z
8572767 8572767 20251122014024_33yyH DE000K 2025-11-23T14:39:42.924Z 2025-11-30T15:05:57.819Z
8572589 8572589 20251122011355_3KabE DE000K 2025-11-23T14:39:33.064Z 2025-11-30T15:05:52.385Z
8572451 8572451 20251122004816_U5c5d DE000K 2025-11-23T14:39:23.271Z 2025-11-30T15:05:50.311Z
8572443 8572443 20251122004612_XwF3b DE000K 2025-11-23T14:39:22.252Z 2025-11-30T15:05:49.833Z
8572193 8572193 20251122000058_ZrEJK DE000K 2025-11-23T14:38:05.332Z 2025-11-30T15:05:41.186Z
8572091 8572091 20251121233540_vQOSS DE000K 2025-11-23T14:37:58.575Z 2025-11-30T15:05:37.508Z
8571923 8571923 20251121225247_EU23P DE000K 2025-11-23T14:37:50.377Z 2025-11-30T15:05:25.814Z
8571568 8571568 20251121211924_m2pJW DE000K 2025-11-23T14:36:55.147Z 2025-11-30T15:05:10.377Z
8571283 8571283 20251121200533_i2fB0 DE000K 2025-11-23T14:36:08.695Z 2025-11-30T15:04:53.085Z
8571203 8571203 20251121193946_rfOMB DE000K 2025-11-23T14:36:03.254Z 2025-11-30T15:04:39.491Z
8571160 8571160 20251121192738_KGJfu DE000K 2025-11-23T14:36:01.109Z 2025-11-30T15:04:31.406Z
8571121 8571121 20251121191746_ShgaA DE000K 2025-11-23T14:35:59.582Z 2025-11-30T15:04:29.357Z
8570962 8570962 20251121181711_9pNow DE000K 2025-11-23T14:35:41.090Z 2025-11-30T15:04:12.295Z
8570952 8570952 20251121181508_7GwiJ DE000K 2025-11-23T14:35:33.287Z 2025-11-30T15:04:11.096Z
8570913 8570913 20251121175102_lt14O DE000K 2025-11-23T14:35:13.316Z 2025-11-30T15:04:05.316Z
8570845 8570845 20251121173512_7dSTF DE000K 2025-11-23T14:34:56.961Z 2025-11-30T15:03:49.943Z
8570824 8570824 20251121172046_scqJI DE000K 2025-11-23T14:34:46.292Z 2025-11-30T15:03:46.022Z
8568661 8568661 20251121052901_t7s75 DE000K 2025-11-23T14:31:18.300Z 2025-11-29T14:54:47.182Z
8568208 8568208 20251121050635_ae8Xd DE000K 2025-11-23T14:30:58.461Z 2025-11-29T14:54:46.378Z
8560469 8560469 20251121045740_NDihL DE000K 2025-11-22T14:42:53.062Z 2025-11-29T14:54:45.789Z
8560453 8560453 20251121045533_C9HHx DE000K 2025-11-22T14:42:52.802Z 2025-11-29T14:54:45.764Z
8560049 8560049 20251121043712_hJPex DE000K 2025-11-22T14:42:11.959Z 2025-11-29T14:54:44.942Z
8559612 8559612 20251121041854_bLh9V DE000K 2025-11-22T14:41:59.923Z 2025-11-29T14:54:43.135Z
8559414 8559414 20251121040952_0jB1Q DE000K 2025-11-22T14:41:55.141Z 2025-11-29T14:54:38.435Z
8559278 8559278 20251121040325_JTnxs DE000K 2025-11-22T14:41:51.557Z 2025-11-29T14:54:37.758Z
8559032 8559032 20251121035047_QELEI DE000K 2025-11-22T14:41:44.387Z 2025-11-29T14:54:37.004Z
8558505 8558505 20251121033031_63J2w DE000K 2025-11-22T14:41:06.675Z 2025-11-29T14:54:36.124Z

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