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,721 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
9610616 9610616 20260404205203_1BQff ES000H 2026-04-06T12:10:24.974Z 2026-04-06T12:16:14.620Z
9586110 9586110 20260327035910_uNKo3 ES000H 2026-03-28T12:02:12.948Z 2026-04-05T12:33:01.620Z
9581023 9581023 20260326021215_dBnR5 ES000H 2026-03-27T12:01:55.949Z 2026-04-04T12:38:39.918Z
9580809 9580809 20260326013643_2f7UZ ES000H 2026-03-27T12:01:27.965Z 2026-04-04T12:38:30.126Z
9577110 9577110 20260325035601_Lpk4E ES000H 2026-03-26T12:04:10.701Z 2026-04-03T12:36:34.896Z
9551874 9551874 20260320220200_6UmMO ES000H 2026-03-22T12:27:14.762Z 2026-03-28T12:37:03.437Z
9542607 9542607 20260321002347_jhoVF ES000H 2026-03-22T12:00:56.663Z 2026-03-29T12:18:46.366Z
9534780 9534780 20260320042224_7Cr6d ES000H 2026-03-21T12:08:51.859Z 2026-03-28T12:34:22.050Z
9532934 9532934 20260320013911_zPYte ES000H 2026-03-21T12:04:01.272Z 2026-03-28T12:33:46.654Z
9532362 9532362 20260320004912_kCk1q ES000H 2026-03-21T12:02:29.611Z 2026-03-28T12:33:28.472Z
9516378 9516378 20260317203906_AtUdx ES000H 2026-03-19T12:26:04.930Z 2026-03-25T12:42:55.056Z
9512253 9512253 20260318050035_AUIuu ES000H 2026-03-19T12:12:00.540Z 2026-03-26T12:37:43.346Z
9511008 9511008 20260318033209_8mexa ES000H 2026-03-19T12:09:14.670Z 2026-03-26T12:37:18.729Z
9508808 9508808 20260318011126_ZPO2v ES000H 2026-03-19T12:03:49.719Z 2026-03-26T12:37:00.950Z
9508363 9508363 20260318004904_NFXpW ES000H 2026-03-19T12:02:56.364Z 2026-03-26T12:36:58.003Z
9508347 9508347 20260318004603_PY2f1 ES000H 2026-03-19T12:02:54.950Z 2026-03-26T12:36:57.945Z
9507540 9507540 20260317231653_O82Um ES000H 2026-03-19T12:00:27.736Z 2026-03-26T12:36:39.343Z
9501293 9501293 20260315214752_T5yv3 ES000H 2026-03-17T12:24:47.707Z 2026-03-23T12:22:43.864Z
9495206 9495206 20260316044204_PtUhd ES000H 2026-03-17T12:06:25.503Z 2026-03-24T12:41:04.131Z
9493887 9493887 20260316005105_qG4Vj ES000H 2026-03-17T12:02:20.150Z 2026-03-24T12:40:42.887Z
9493431 9493431 20260315233008_2vZDI ES000H 2026-03-17T12:00:50.983Z 2026-03-24T12:40:39.643Z
9492710 9492710 20260314214346_UXHQQ ES000H 2026-03-16T12:28:57.855Z 2026-03-22T12:42:54.024Z
9492253 9492253 20260314195258_C97Gl ES000H 2026-03-16T12:28:13.447Z 2026-03-22T12:42:51.254Z
9486147 9486147 20260315050638_GkpJu ES000H 2026-03-16T12:08:50.734Z 2026-03-23T12:21:55.603Z
9484664 9484664 20260315012338_XqjRJ ES000H 2026-03-16T12:03:41.127Z 2026-03-23T12:21:47.764Z
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

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