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,696 rows where station_code = "ES000H" 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
8027265 8027265 20250930221010_MJ4kp ES000H 2025-10-02T12:23:12.676Z 2025-10-02T12:23:12.676Z
8018179 8018179 20250930043331_6GwVB ES000H 2025-10-01T12:28:26.918Z 2025-10-08T12:44:02.818Z
8018071 8018071 20250930030614_BbDOo ES000H 2025-10-01T12:28:02.971Z 2025-10-08T12:43:39.628Z
8018011 8018011 20250930024538_P1XOP ES000H 2025-10-01T12:27:53.069Z 2025-10-08T12:43:34.440Z
8017981 8017981 20250930022709_BLYiJ ES000H 2025-10-01T12:27:39.696Z 2025-10-08T12:43:32.459Z
8017946 8017946 20250930021439_z8axK ES000H 2025-10-01T12:27:32.658Z 2025-10-08T12:43:26.882Z
8017852 8017852 20250930014027_fzcot ES000H 2025-10-01T12:27:19.558Z 2025-10-08T12:43:17.091Z
8017622 8017622 20250930001315_2DuXc ES000H 2025-10-01T12:26:33.434Z 2025-10-08T12:42:56.225Z
7989882 7989882 20250926042122_Ma3n9 ES000H 2025-09-28T12:36:54.235Z 2025-10-04T13:07:24.791Z
7989805 7989805 20250926041503_3qNDt ES000H 2025-09-28T12:36:52.377Z 2025-10-04T13:07:24.391Z
7985774 7985774 20250927035538_HuEMB ES000H 2025-09-28T12:26:55.008Z 2025-10-05T13:11:20.240Z
7985671 7985671 20250927034503_V9X3W ES000H 2025-09-28T12:26:44.468Z 2025-10-05T13:11:18.403Z
7985279 7985279 20250927030626_JI1jP ES000H 2025-09-28T12:26:00.213Z 2025-10-05T13:11:12.631Z
7984922 7984922 20250927023530_et11T ES000H 2025-09-28T12:25:16.372Z 2025-10-05T13:11:02.987Z
7984576 7984576 20250927015735_SFinC ES000H 2025-09-28T12:24:29.694Z 2025-10-05T13:10:54.528Z
7984085 7984085 20250927004444_3uIh7 ES000H 2025-09-28T12:23:35.178Z 2025-10-05T13:10:46.321Z
7983936 7983936 20250927001628_M6mqf ES000H 2025-09-28T12:23:06.943Z 2025-10-05T13:10:43.965Z
7983847 7983847 20250926235616_KnY9R ES000H 2025-09-28T12:23:00.866Z 2025-10-05T13:10:43.675Z
7983711 7983711 20250926231911_0Q2qY ES000H 2025-09-28T12:22:35.557Z 2025-10-05T13:10:42.803Z
7982965 7982965 20250926201518_GEHEI ES000H 2025-09-28T12:20:49.470Z 2025-10-05T13:10:27.410Z
7982335 7982335 20250926184350_gqmwI ES000H 2025-09-28T12:19:31.025Z 2025-10-05T13:10:16.129Z
7963836 7963836 20250925034015_Ml9X8 ES000H 2025-09-26T12:29:11.931Z 2025-09-26T12:30:00.191Z
7963680 7963680 20250925033125_3j7wQ ES000H 2025-09-26T12:29:03.038Z 2025-09-26T12:30:00.154Z
7963255 7963255 20250925030942_CPPP6 ES000H 2025-09-26T12:28:26.398Z 2025-09-26T12:30:00.056Z
7962848 7962848 20250925024816_HYSWn ES000H 2025-09-26T12:27:46.893Z 2025-09-26T12:29:59.953Z
7962678 7962678 20250925023709_zL576 ES000H 2025-09-26T12:27:38.509Z 2025-10-03T13:04:23.633Z
7959763 7959763 20250924235823_3DyXg ES000H 2025-09-26T12:23:35.247Z 2025-10-03T13:04:05.817Z
7958680 7958680 20250924224315_m3x58 ES000H 2025-09-26T12:21:43.759Z 2025-10-03T13:04:02.513Z
7957026 7957026 20250924200743_VtExN ES000H 2025-09-26T12:18:25.735Z 2025-10-03T13:03:56.708Z
7956963 7956963 20250924200146_O8Ab9 ES000H 2025-09-26T12:18:15.543Z 2025-10-03T13:03:56.380Z
7952093 7952093 20250925040428_s32j2 ES000H 2025-09-26T12:00:11.434Z 2025-10-04T13:05:13.496Z
7950238 7950238 20250924023621_2Xz3j ES000H 2025-09-25T12:34:49.057Z 2025-10-02T13:27:53.874Z
7947173 7947173 20250923235310_aIY1I ES000H 2025-09-25T12:30:04.380Z 2025-10-02T13:26:48.425Z
7938224 7938224 20250924043723_sq3bW ES000H 2025-09-25T12:02:48.320Z 2025-10-03T13:02:37.762Z
7938172 7938172 20250924043231_lan0h ES000H 2025-09-25T12:02:41.693Z 2025-10-03T13:02:35.564Z
7938158 7938158 20250924043025_uBw11 ES000H 2025-09-25T12:02:39.540Z 2025-10-03T13:02:35.316Z
7938077 7938077 20250924042000_dIREf ES000H 2025-09-25T12:02:30.351Z 2025-10-03T13:02:32.843Z
7937991 7937991 20250924041549_0TjHB ES000H 2025-09-25T12:02:11.569Z 2025-10-03T13:02:32.393Z
7937662 7937662 20250924035313_M2MKT ES000H 2025-09-25T12:01:04.635Z 2025-10-03T13:02:28.059Z
7937422 7937422 20250924033719_AdP9W ES000H 2025-09-25T12:00:20.897Z 2025-10-03T13:02:24.609Z
7922348 7922348 20250923024017_kbC78 ES000H 2025-09-24T12:31:13.061Z 2025-10-01T13:24:54.519Z
7922172 7922172 20250923023326_UU5NC ES000H 2025-09-24T12:31:06.584Z 2025-10-01T13:24:53.663Z
7922122 7922122 20250923023016_HHrdZ ES000H 2025-09-24T12:31:02.697Z 2025-10-01T13:24:52.643Z
7920625 7920625 20250923012546_vnMxs ES000H 2025-09-24T12:28:59.084Z 2025-10-01T13:24:28.879Z
7920434 7920434 20250923011048_UM3By ES000H 2025-09-24T12:28:49.065Z 2025-10-01T13:24:27.178Z
7919735 7919735 20250923003559_vfSga ES000H 2025-09-24T12:27:42.538Z 2025-10-01T13:24:21.270Z
7918832 7918832 20250922234919_Lkp3P ES000H 2025-09-24T12:26:22.850Z 2025-10-01T13:24:13.225Z
7918808 7918808 20250922234714_3USeI ES000H 2025-09-24T12:26:18.640Z 2025-10-01T13:24:12.928Z
7918288 7918288 20250922231611_m2sw3 ES000H 2025-09-24T12:25:29.224Z 2025-10-01T13:24:05.033Z
7917603 7917603 20250922223211_Mnwei ES000H 2025-09-24T12:24:13.038Z 2025-10-01T13:23:53.817Z
7917334 7917334 20250922221759_vW0nc ES000H 2025-09-24T12:23:42.122Z 2025-10-01T13:23:51.590Z
7916614 7916614 20250922212655_Cf4lO ES000H 2025-09-24T12:22:41.080Z 2025-10-01T13:23:42.291Z
7915237 7915237 20250922194729_qFC9j ES000H 2025-09-24T12:19:44.216Z 2025-10-01T13:23:14.455Z
7914652 7914652 20250922184844_vRt3a ES000H 2025-09-24T12:18:19.617Z 2025-10-01T13:23:01.391Z
7910833 7910833 20250923044251_5XGuD ES000H 2025-09-24T12:03:58.987Z 2025-10-02T13:22:46.741Z
7910391 7910391 20250923041439_Wbdzl ES000H 2025-09-24T12:03:10.722Z 2025-10-02T13:22:38.079Z
7909790 7909790 20250923033703_b2pQi ES000H 2025-09-24T12:01:47.452Z 2025-10-02T13:22:23.568Z
7909560 7909560 20250923032520_vzurH ES000H 2025-09-24T12:01:18.214Z 2025-10-02T13:22:20.366Z
7909462 7909462 20250923031955_beD0x ES000H 2025-09-24T12:01:02.680Z 2025-10-02T13:22:19.707Z
7894846 7894846 20250919230541_9HBlB ES000H 2025-09-21T12:37:48.387Z 2025-09-28T12:54:37.772Z
7893845 7893845 20250919215710_Lv21g ES000H 2025-09-21T12:36:12.543Z 2025-09-28T12:54:32.164Z
7883895 7883895 20250920014521_B1BQE ES000H 2025-09-21T12:01:19.864Z 2025-09-29T13:02:39.569Z
7883220 7883220 20250919004836_FW1c4 ES000H 2025-09-20T12:37:42.710Z 2025-09-27T12:48:00.147Z
7874796 7874796 20250919042158_oEdHX ES000H 2025-09-20T12:12:11.476Z 2025-09-28T12:53:21.485Z
7874709 7874709 20250919040936_52UYV ES000H 2025-09-20T12:11:53.465Z 2025-09-28T12:53:20.898Z
7874656 7874656 20250919040441_V3CrI ES000H 2025-09-20T12:11:38.861Z 2025-09-28T12:53:20.542Z
7874522 7874522 20250919035247_42jaA ES000H 2025-09-20T12:11:14.849Z 2025-09-28T12:53:19.425Z
7874301 7874301 20250919033517_wRBry ES000H 2025-09-20T12:10:18.123Z 2025-09-20T12:10:18.123Z
7874276 7874276 20250919033410_6uM4n ES000H 2025-09-20T12:10:06.833Z 2025-09-28T12:53:17.726Z
7873146 7873146 20250919021711_oSRul ES000H 2025-09-20T12:05:37.518Z 2025-09-28T12:53:08.666Z
7872470 7872470 20250919012910_RgdzJ ES000H 2025-09-20T12:02:29.810Z 2025-09-28T12:53:04.697Z
7872236 7872236 20250919011120_tt35n ES000H 2025-09-20T12:01:21.199Z 2025-09-28T12:53:03.657Z
7872217 7872217 20250919010934_xZyzX ES000H 2025-09-20T12:01:14.180Z 2025-09-28T12:53:03.569Z
7871836 7871836 20250918001215_DwWCT ES000H 2025-09-19T12:32:19.927Z 2025-09-25T13:13:16.207Z
7869511 7869511 20250917194650_OI2JB ES000H 2025-09-19T12:26:13.312Z 2025-09-25T13:12:43.475Z
7866662 7866662 20250918043619_JriHm ES000H 2025-09-19T12:11:19.193Z 2025-09-27T12:46:34.886Z
7866280 7866280 20250918033329_4md3M ES000H 2025-09-19T12:09:41.749Z 2025-09-27T12:46:28.464Z
7866276 7866276 20250918033305_f3Dvd ES000H 2025-09-19T12:09:40.755Z 2025-09-27T12:46:28.459Z
7865918 7865918 20250918025807_syjN7 ES000H 2025-09-19T12:08:13.466Z 2025-09-27T12:46:22.833Z
7865820 7865820 20250918025000_CIjFW ES000H 2025-09-19T12:07:47.190Z 2025-09-27T12:46:20.890Z
7865699 7865699 20250918023902_xcUAc ES000H 2025-09-19T12:07:12.159Z 2025-09-27T12:46:17.558Z
7864879 7864879 20250918012829_jNfa0 ES000H 2025-09-19T12:03:34.068Z 2025-09-27T12:46:00.525Z
7864282 7864282 20250918003353_jD38q ES000H 2025-09-19T12:01:00.002Z 2025-09-27T12:45:43.204Z
7864245 7864245 20250918002943_BCJuI ES000H 2025-09-19T12:00:49.776Z 2025-09-27T12:45:42.505Z
7864200 7864200 20250918002446_ggt6M ES000H 2025-09-19T12:00:38.947Z 2025-09-27T12:45:42.078Z
7832185 7832185 20250915030059_Yj9TF ES000H 2025-09-16T12:08:35.902Z 2025-09-22T13:02:36.021Z
7832179 7832179 20250915030051_Tfetf ES000H 2025-09-16T12:08:34.978Z 2025-09-22T13:02:35.930Z
7831489 7831489 20250915013115_xzNTZ ES000H 2025-09-16T12:05:39.881Z 2025-09-22T13:02:13.350Z
7804706 7804706 20250910232729_p778c ES000H 2025-09-12T12:03:19.351Z 2025-09-19T12:56:47.533Z
7804410 7804410 20250910223515_n0tYn ES000H 2025-09-12T12:02:35.939Z 2025-09-19T12:56:44.238Z
7742033 7742033 20250902015926_3CNfe ES000H 2025-09-03T12:21:32.326Z 2025-09-10T12:47:06.441Z
7741681 7741681 20250902014113_Gplvd ES000H 2025-09-03T12:20:49.437Z 2025-09-10T12:47:01.247Z
7741014 7741014 20250902010258_75kik ES000H 2025-09-03T12:19:23.407Z 2025-09-10T12:46:44.470Z
7741012 7741012 20250902010258_AsnJx ES000H 2025-09-03T12:19:23.203Z 2025-09-10T12:46:44.458Z
7740583 7740583 20250902003023_S6Y8w ES000H 2025-09-03T12:18:29.032Z 2025-09-10T12:46:34.832Z
7738915 7738915 20250901223004_yt1z3 ES000H 2025-09-03T12:14:04.777Z 2025-09-10T12:46:02.252Z
7738456 7738456 20250901215116_agj7W ES000H 2025-09-03T12:12:35.593Z 2025-09-10T12:45:48.528Z
7737990 7737990 20250901210554_14lvs ES000H 2025-09-03T12:11:12.858Z 2025-09-10T12:45:38.246Z
7716406 7716406 20250831034331_7X3qh ES000H 2025-09-01T12:22:47.854Z 2025-09-08T12:53:09.743Z
7715577 7715577 20250831025641_j8Dhb ES000H 2025-09-01T12:21:17.269Z 2025-09-08T12:52:53.955Z

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