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

4,990 rows where station_code = "DE000X" 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
8690552 8690552 20251205002449_DQCbF DE000X 2025-12-06T14:14:40.550Z 2025-12-06T14:18:00.906Z
8690550 8690550 20251205002222_RwZcX DE000X 2025-12-06T14:14:40.067Z 2025-12-06T14:18:00.905Z
8690519 8690519 20251205000932_ipcg8 DE000X 2025-12-06T14:14:36.119Z 2025-12-06T14:18:00.898Z
8690417 8690417 20251204233151_hNvDc DE000X 2025-12-06T14:14:14.976Z 2025-12-06T14:18:00.877Z
8690304 8690304 20251204224314_OCooD DE000X 2025-12-06T14:13:59.325Z 2025-12-06T14:18:00.857Z
8690253 8690253 20251204222519_9hjV2 DE000X 2025-12-06T14:13:53.211Z 2025-12-06T14:18:00.850Z
8690239 8690239 20251204222244_9Y6wL DE000X 2025-12-06T14:13:51.890Z 2025-12-06T14:18:00.847Z
8690154 8690154 20251204212259_3UH3w DE000X 2025-12-06T14:13:30.703Z 2025-12-06T14:18:00.826Z
8690099 8690099 20251204203302_C422Q DE000X 2025-12-06T14:13:19.339Z 2025-12-06T14:18:00.807Z
8666529 8666529 20251201060718_r3p3p DE000X 2025-12-02T14:26:23.703Z 2025-12-06T14:42:31.475Z
8666445 8666445 20251201054206_birNH DE000X 2025-12-02T14:26:14.195Z 2025-12-06T14:42:22.459Z
8666055 8666055 20251201042813_GOky4 DE000X 2025-12-02T14:25:09.340Z 2025-12-06T14:42:10.607Z
8665434 8665434 20251201032053_YAj93 DE000X 2025-12-02T14:23:41.359Z 2025-12-06T14:41:37.582Z
8665320 8665320 20251201030739_IZ4CH DE000X 2025-12-02T14:23:31.300Z 2025-12-06T14:41:34.796Z
8665260 8665260 20251201025649_UlPwD DE000X 2025-12-02T14:23:13.850Z 2025-12-06T14:41:31.150Z
8665216 8665216 20251201024751_8CMd3 DE000X 2025-12-02T14:23:08.660Z 2025-12-06T14:41:29.619Z
8665202 8665202 20251201024640_GynJk DE000X 2025-12-02T14:23:07.458Z 2025-12-06T14:41:29.287Z
8665172 8665172 20251201024142_ICPRs DE000X 2025-12-02T14:23:04.436Z 2025-12-06T14:41:28.707Z
8665059 8665059 20251201022204_WlFWu DE000X 2025-12-02T14:22:43.973Z 2025-12-06T14:41:19.447Z
8665038 8665038 20251201022014_uorC0 DE000X 2025-12-02T14:22:39.276Z 2025-12-06T14:41:09.163Z
8664889 8664889 20251201015804_1ScRh DE000X 2025-12-02T14:22:17.743Z 2025-12-06T14:41:02.003Z
8664887 8664887 20251201015709_NBfEF DE000X 2025-12-02T14:22:17.237Z 2025-12-06T14:41:01.899Z
8664821 8664821 20251201014542_IC7VD DE000X 2025-12-02T14:22:09.120Z 2025-12-06T14:40:58.936Z
8664668 8664668 20251201012040_aRbRe DE000X 2025-12-02T14:21:46.396Z 2025-12-06T14:40:54.336Z
8664540 8664540 20251201005444_vADkC DE000X 2025-12-02T14:21:18.379Z 2025-12-06T14:40:49.971Z
8664468 8664468 20251201003725_OBF95 DE000X 2025-12-02T14:21:09.063Z 2025-12-06T14:40:47.873Z
8664337 8664337 20251201000501_frkeP DE000X 2025-12-02T14:20:44.400Z 2025-12-06T14:40:44.572Z
8664311 8664311 20251201000132_sQdro DE000X 2025-12-02T14:20:41.221Z 2025-12-06T14:40:43.926Z
8664225 8664225 20251130234443_oKF9R DE000X 2025-12-02T14:20:31.533Z 2025-12-06T14:40:41.813Z
8663919 8663919 20251130223348_4u4Ml DE000X 2025-12-02T14:19:35.323Z 2025-12-06T14:40:16.352Z
8663899 8663899 20251130223040_U8OM3 DE000X 2025-12-02T14:19:32.803Z 2025-12-06T14:40:15.587Z
8663809 8663809 20251130220856_dS89j DE000X 2025-12-02T14:19:13.301Z 2025-12-06T14:40:12.264Z
8663770 8663770 20251130215459_yhn3S DE000X 2025-12-02T14:19:04.399Z 2025-12-06T14:40:10.714Z
8663741 8663741 20251130214548_NoLBi DE000X 2025-12-02T14:19:00.887Z 2025-12-06T14:40:09.657Z
8663654 8663654 20251130211618_LJnZD DE000X 2025-12-02T14:18:47.729Z 2025-12-06T14:40:05.968Z
8663179 8663179 20251130201836_D2QlR DE000X 2025-12-02T14:17:35.650Z 2025-12-06T14:39:55.305Z
8662014 8662014 20251130174156_iCgz1 DE000X 2025-12-02T14:13:58.378Z 2025-12-06T14:38:46.628Z
8647325 8647325 20251129042251_OBXn0 DE000X 2025-11-30T14:27:59.796Z 2025-12-06T14:56:36.799Z
8647305 8647305 20251129041818_A87U5 DE000X 2025-11-30T14:27:58.494Z 2025-12-06T14:56:36.258Z
8647092 8647092 20251129034243_L2zSD DE000X 2025-11-30T14:27:31.452Z 2025-12-06T14:56:31.734Z
8623148 8623148 20251126230452_PXn6e DE000X 2025-11-28T14:20:58.028Z 2025-12-05T15:03:32.915Z
8622842 8622842 20251126214451_f84Pn DE000X 2025-11-28T14:20:09.908Z 2025-12-05T15:03:16.248Z
8622350 8622350 20251126185346_nMtfl DE000X 2025-11-28T14:18:29.335Z 2025-12-05T15:02:55.726Z
8622143 8622143 20251126175928_GeLv8 DE000X 2025-11-28T14:17:49.093Z 2025-12-05T15:02:52.767Z
8582339 8582339 20251123054143_hjT3i DE000X 2025-11-24T14:33:30.377Z 2025-12-01T15:22:22.327Z
8582280 8582280 20251123051014_w9pKq DE000X 2025-11-24T14:33:27.138Z 2025-12-01T15:22:20.949Z
8582202 8582202 20251123044354_3g9rY DE000X 2025-11-24T14:33:22.526Z 2025-12-01T15:22:18.726Z
8582160 8582160 20251123042607_iA2CK DE000X 2025-11-24T14:33:20.120Z 2025-12-01T15:22:17.611Z
8582079 8582079 20251123040227_eSyX2 DE000X 2025-11-24T14:33:15.601Z 2025-12-01T15:22:15.687Z
8582077 8582077 20251123040120_qAVbu DE000X 2025-11-24T14:33:15.359Z 2025-12-01T15:22:15.591Z
8582061 8582061 20251123035702_8Dw7q DE000X 2025-11-24T14:33:14.185Z 2025-12-01T15:22:15.132Z
8581935 8581935 20251123031113_TC3bC DE000X 2025-11-24T14:32:48.157Z 2025-12-01T15:22:01.820Z
8581857 8581857 20251123024903_VWugM DE000X 2025-11-24T14:32:41.881Z 2025-12-01T15:21:49.335Z
8581828 8581828 20251123024239_PYBU6 DE000X 2025-11-24T14:32:40.591Z 2025-12-01T15:21:44.186Z
8581814 8581814 20251123023804_SOXOh DE000X 2025-11-24T14:32:39.701Z 2025-12-01T15:21:42.840Z
8581773 8581773 20251123021722_V4rFO DE000X 2025-11-24T14:32:37.169Z 2025-12-01T15:21:33.888Z
8581770 8581770 20251123021353_4GXAJ DE000X 2025-11-24T14:32:37.084Z 2025-12-01T15:21:31.503Z
8581761 8581761 20251123021150_xz8cF DE000X 2025-11-24T14:32:36.624Z 2025-12-01T15:21:30.356Z
8581758 8581758 20251123021104_N7dVF DE000X 2025-11-24T14:32:36.243Z 2025-12-01T15:21:30.294Z
8581722 8581722 20251123015405_Sg0cx DE000X 2025-11-24T14:32:34.157Z 2025-12-01T15:21:20.057Z
8581688 8581688 20251123014059_XCknD DE000X 2025-11-24T14:32:32.088Z 2025-12-01T15:21:14.668Z
8581588 8581588 20251123010542_O2t2z DE000X 2025-11-24T14:32:09.254Z 2025-12-01T15:21:00.206Z
8581585 8581585 20251123010420_glcXj DE000X 2025-11-24T14:32:08.028Z 2025-12-01T15:21:00.142Z
8581576 8581576 20251123005850_wTXwu DE000X 2025-11-24T14:32:02.573Z 2025-12-01T15:20:58.981Z
8581555 8581555 20251123005307_bJbf2 DE000X 2025-11-24T14:31:49.356Z 2025-12-01T15:20:57.342Z
8581528 8581528 20251123004417_uKTjf DE000X 2025-11-24T14:31:43.684Z 2025-12-01T15:20:52.915Z
8581445 8581445 20251122235627_UB4v4 DE000X 2025-11-24T14:31:35.126Z 2025-12-01T15:20:29.353Z
8581432 8581432 20251122235257_Xed5f DE000X 2025-11-24T14:31:34.228Z 2025-12-01T15:20:28.903Z
8581409 8581409 20251122234441_RS5cK DE000X 2025-11-24T14:31:32.572Z 2025-12-01T15:20:24.023Z
8581370 8581370 20251122232347_9rxfA DE000X 2025-11-24T14:31:29.469Z 2025-12-01T15:20:15.876Z
8581354 8581354 20251122231527_2kyIx DE000X 2025-11-24T14:31:28.029Z 2025-12-01T15:20:14.587Z
8581337 8581337 20251122231251_9EepR DE000X 2025-11-24T14:31:27.266Z 2025-12-01T15:20:14.226Z
8581257 8581257 20251122223254_ORP2c DE000X 2025-11-24T14:31:22.264Z 2025-12-01T15:20:05.330Z
8579032 8579032 20251122221034_THBgo DE000X 2025-11-24T14:13:21.250Z 2025-11-24T14:13:21.250Z
8579010 8579010 20251122220507_BONzL DE000X 2025-11-24T14:13:17.396Z 2025-12-01T15:19:58.181Z
8578932 8578932 20251122215242_PO6Gl DE000X 2025-11-24T14:13:07.738Z 2025-12-01T15:19:56.091Z
8578832 8578832 20251122213347_Q2O3j DE000X 2025-11-24T14:12:48.135Z 2025-12-01T15:19:53.723Z
8578741 8578741 20251122212133_H1Kxv DE000X 2025-11-24T14:12:36.474Z 2025-12-01T15:19:51.156Z
8578732 8578732 20251122212103_Uh1gI DE000X 2025-11-24T14:12:35.129Z 2025-12-01T15:19:51.012Z
8578723 8578723 20251122212003_I4rFo DE000X 2025-11-24T14:12:33.016Z 2025-12-01T15:19:50.745Z
8578706 8578706 20251122211840_o6XVe DE000X 2025-11-24T14:12:23.831Z 2025-12-01T15:19:50.400Z
8578703 8578703 20251122211821_RHBzn DE000X 2025-11-24T14:12:23.145Z 2025-12-01T15:19:50.326Z
8578458 8578458 20251122203805_mLKPG DE000X 2025-11-24T14:11:47.075Z 2025-12-01T15:19:38.271Z
8578296 8578296 20251122202358_USlkD DE000X 2025-11-24T14:11:21.712Z 2025-11-24T14:11:21.712Z
8578244 8578244 20251122201147_7i33B DE000X 2025-11-24T14:11:11.486Z 2025-12-01T15:19:25.655Z
8578207 8578207 20251122200035_JtJNd DE000X 2025-11-24T14:11:05.968Z 2025-11-24T14:11:05.968Z
8578118 8578118 20251122194506_PPCg5 DE000X 2025-11-24T14:10:48.347Z 2025-12-01T15:19:11.490Z
8578002 8578002 20251122192711_CBSoc DE000X 2025-11-24T14:10:29.989Z 2025-12-01T15:19:06.115Z
8577928 8577928 20251122191216_bmVgO DE000X 2025-11-24T14:10:11.605Z 2025-12-01T15:19:03.390Z
8577717 8577717 20251122185020_2T122 DE000X 2025-11-24T14:09:30.658Z 2025-12-01T15:18:56.845Z
8577684 8577684 20251122184619_XQ27T DE000X 2025-11-24T14:09:26.183Z 2025-12-01T15:18:56.418Z
8577444 8577444 20251122180947_8hlGH DE000X 2025-11-24T14:08:37.127Z 2025-12-01T15:18:50.281Z
8577241 8577241 20251122174015_Cb1lV DE000X 2025-11-24T14:08:04.090Z 2025-12-01T15:18:45.319Z
8574117 8574117 20251122051404_R4ZHj DE000X 2025-11-23T14:42:19.792Z 2025-11-30T15:06:59.050Z
8574102 8574102 20251122051103_FEL0U DE000X 2025-11-23T14:42:18.754Z 2025-11-30T15:06:58.542Z
8574071 8574071 20251122050510_rXmDC DE000X 2025-11-23T14:42:14.866Z 2025-11-30T15:06:56.652Z
8574050 8574050 20251122050406_HlvTw DE000X 2025-11-23T14:42:13.555Z 2025-11-30T15:06:56.415Z
8573996 8573996 20251122045608_NbOWY DE000X 2025-11-23T14:42:11.073Z 2025-11-30T15:06:55.338Z
8573883 8573883 20251122043213_CdL2a DE000X 2025-11-23T14:42:05.136Z 2025-11-30T15:06:48.021Z
8573878 8573878 20251122043126_ciL1Z DE000X 2025-11-23T14:42:04.926Z 2025-11-30T15:06:47.971Z

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