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

411 rows where station_code = "ES001H" 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
9249259 9249259 20260122043024_khihV ES001H 2026-01-23T14:15:04.186Z 2026-01-29T14:58:20.155Z
9249230 9249230 20260122041753_pUb70 ES001H 2026-01-23T14:15:01.497Z 2026-01-29T14:58:18.619Z
9230189 9230189 20260119033827_0UGgZ ES001H 2026-01-20T14:26:28.419Z 2026-01-27T15:04:32.085Z
9229424 9229424 20260119014405_KNqy4 ES001H 2026-01-20T14:22:28.674Z 2026-01-27T15:03:24.860Z
9210268 9210268 20260114040403_4r3Dh ES001H 2026-01-16T14:27:24.590Z 2026-01-22T15:09:28.883Z
9208446 9208446 20260115052614_WOIrl ES001H 2026-01-16T14:12:43.242Z 2026-01-22T15:04:14.170Z
9208439 9208439 20260115052521_b5G1q ES001H 2026-01-16T14:12:42.049Z 2026-01-22T15:04:13.980Z
9208148 9208148 20260115042006_CLHhi ES001H 2026-01-16T14:11:29.302Z 2026-01-22T15:04:02.247Z
9207549 9207549 20260115021500_yT4tj ES001H 2026-01-16T14:09:13.112Z 2026-01-22T15:03:24.781Z
9196072 9196072 20260113042419_HLZCe ES001H 2026-01-14T14:16:26.146Z 2026-01-21T15:05:22.063Z
9195974 9195974 20260113034423_F9F6X ES001H 2026-01-14T14:15:53.464Z 2026-01-21T15:04:59.614Z
9189628 9189628 20260112053026_3686x ES001H 2026-01-13T14:18:35.726Z 2026-01-20T15:23:32.188Z
9167751 9167751 20260108044815_MRJKE ES001H 2026-01-09T14:09:05.511Z 2026-01-16T15:11:48.413Z
9163136 9163136 20260107055052_saVio ES001H 2026-01-08T14:08:12.905Z 2026-01-13T15:03:02.592Z
9163047 9163047 20260107053514_CXgS3 ES001H 2026-01-08T14:08:01.061Z 2026-01-13T15:02:59.641Z
9163024 9163024 20260107052757_4Q0uJ ES001H 2026-01-08T14:07:45.444Z 2026-01-13T15:02:57.817Z
9162979 9162979 20260107051903_34Pdp ES001H 2026-01-08T14:07:37.158Z 2026-01-13T15:02:50.231Z
9109211 9109211 20251227030712_tl65s ES001H 2025-12-31T15:07:24.493Z 2026-01-04T15:27:43.805Z
9029207 9029207 20251225034045_SRL7m ES001H 2025-12-28T14:15:51.758Z 2026-01-02T15:44:18.678Z
8977896 8977896 20251219055828_xntxQ ES001H 2025-12-26T14:13:50.958Z 2025-12-28T15:17:35.924Z
8943595 8943595 20251214195554_dO39I ES001H 2025-12-24T14:59:57.662Z 2025-12-24T14:59:57.662Z
8755564 8755564 20251210032614_TeTXz ES001H 2025-12-13T15:44:15.411Z 2025-12-17T15:29:22.320Z
8754628 8754628 20251210021049_zsQPP ES001H 2025-12-13T15:43:14.225Z 2025-12-17T15:29:09.280Z
8713323 8713323 20251209032444_oR2vB ES001H 2025-12-10T14:16:06.728Z 2025-12-17T15:34:29.128Z
8712719 8712719 20251209005813_N7CRB ES001H 2025-12-10T14:14:38.309Z 2025-12-17T15:34:21.194Z
8708042 8708042 20251208030613_7IgtY ES001H 2025-12-09T14:28:38.914Z 2025-12-16T15:13:15.608Z
8708022 8708022 20251208030413_idPA7 ES001H 2025-12-09T14:28:29.062Z 2025-12-16T15:13:15.121Z
8707973 8707973 20251208025430_BHFmk ES001H 2025-12-09T14:28:24.282Z 2025-12-16T15:13:14.146Z
8707501 8707501 20251208012133_1wI0d ES001H 2025-12-09T14:27:16.139Z 2025-12-16T15:13:05.347Z
8707234 8707234 20251208004238_HIWWf ES001H 2025-12-09T14:26:26.083Z 2025-12-16T15:12:59.987Z
8706936 8706936 20251207235406_KFirm ES001H 2025-12-09T14:25:37.227Z 2025-12-16T15:12:38.333Z
8699645 8699645 20251207012332_pttBd ES001H 2025-12-08T14:21:49.523Z 2025-12-15T15:30:15.361Z
8694630 8694630 20251207060135_3nac3 ES001H 2025-12-08T14:00:34.792Z 2025-12-16T15:09:29.958Z
8687125 8687125 20251204045333_sVnci ES001H 2025-12-05T14:13:56.923Z 2025-12-11T14:42:02.310Z
8680349 8680349 20251202233124_8m2a3 ES001H 2025-12-04T14:11:49.509Z 2025-12-11T14:45:38.647Z
8674771 8674771 20251202032049_yOIuZ ES001H 2025-12-03T14:22:19.767Z 2025-12-10T14:39:11.277Z
8647469 8647469 20251129043948_lADjR ES001H 2025-11-30T14:28:28.235Z 2025-12-07T14:59:08.980Z
8646971 8646971 20251129032131_adYbn ES001H 2025-11-30T14:27:12.272Z 2025-12-07T14:58:24.309Z
8646873 8646873 20251129030456_LWuw3 ES001H 2025-11-30T14:27:03.721Z 2025-12-07T14:58:21.717Z
8646329 8646329 20251129014622_Ieatv ES001H 2025-11-30T14:25:51.084Z 2025-12-07T14:58:07.773Z
8646150 8646150 20251129011321_wx2hM ES001H 2025-11-30T14:25:17.022Z 2025-12-07T14:57:36.232Z
8645919 8645919 20251129002726_KczA5 ES001H 2025-11-30T14:24:54.862Z 2025-12-07T14:57:21.038Z
8637408 8637408 20251128053752_nQu9p ES001H 2025-11-29T14:27:12.851Z 2025-12-06T15:03:59.780Z
8637406 8637406 20251128053747_7HNvT ES001H 2025-11-29T14:27:12.736Z 2025-12-06T15:03:59.751Z
8637237 8637237 20251128051753_KcD5D ES001H 2025-11-29T14:26:59.774Z 2025-12-06T15:03:57.914Z
8637133 8637133 20251128050519_U4iJ3 ES001H 2025-11-29T14:26:52.654Z 2025-12-06T15:03:56.800Z
8636712 8636712 20251128041917_S9iP9 ES001H 2025-11-29T14:26:07.072Z 2025-12-06T15:03:38.401Z
8636691 8636691 20251128041716_W2Yqx ES001H 2025-11-29T14:26:05.430Z 2025-12-06T15:03:37.257Z
8635526 8635526 20251128022241_jion5 ES001H 2025-11-29T14:23:35.480Z 2025-12-06T15:02:45.989Z
8635084 8635084 20251128014007_Ujubh ES001H 2025-11-29T14:22:39.335Z 2025-12-06T15:02:40.483Z
8635004 8635004 20251128013312_zZWeY ES001H 2025-11-29T14:22:21.684Z 2025-12-06T15:02:39.334Z
8634788 8634788 20251128011757_Kzbau ES001H 2025-11-29T14:22:03.515Z 2025-12-06T15:02:35.952Z
8634649 8634649 20251128010720_2XU7L ES001H 2025-11-29T14:21:44.929Z 2025-12-06T15:02:26.577Z
8624535 8624535 20251127052116_m3CSt ES001H 2025-11-28T14:25:06.886Z 2025-12-05T15:05:11.574Z
8624407 8624407 20251127043649_7ZJsM ES001H 2025-11-28T14:24:37.461Z 2025-12-05T15:05:04.350Z
8624303 8624303 20251127040441_JGQeh ES001H 2025-11-28T14:24:25.487Z 2025-12-05T15:04:58.093Z
8624262 8624262 20251127035030_DfnXE ES001H 2025-11-28T14:24:22.493Z 2025-12-05T15:04:56.850Z
8624172 8624172 20251127032538_IC4mP ES001H 2025-11-28T14:23:55.793Z 2025-12-05T15:04:49.401Z
8624129 8624129 20251127031430_kpHlI ES001H 2025-11-28T14:23:50.300Z 2025-12-05T15:04:46.279Z
8623985 8623985 20251127023818_m3cp0 ES001H 2025-11-28T14:23:22.887Z 2025-12-05T15:04:32.091Z
8623455 8623455 20251127004354_6wCJd ES001H 2025-11-28T14:21:46.511Z 2025-12-05T15:03:54.367Z
8615481 8615481 20251126050435_tdW4x ES001H 2025-11-27T14:29:35.512Z 2025-12-04T15:11:29.307Z
8610422 8610422 20251126004422_d5bOB ES001H 2025-11-27T14:20:06.228Z 2025-12-04T15:08:05.346Z
8610253 8610253 20251126003205_c3GIQ ES001H 2025-11-27T14:19:39.665Z 2025-12-04T15:08:03.710Z
8609650 8609650 20251125235818_D2plu ES001H 2025-11-27T14:18:46.901Z 2025-12-04T15:07:56.389Z
8572439 8572439 20251122004537_gN9rj ES001H 2025-11-23T14:39:20.407Z 2025-11-30T15:05:49.714Z
8567122 8567122 20251122041505_2pPd2 ES001H 2025-11-23T14:18:57.191Z 2025-11-30T15:06:40.540Z
8536105 8536105 20251120033605_2Q3FG ES001H 2025-11-21T14:17:35.832Z 2025-11-28T14:57:25.379Z
8535400 8535400 20251120020127_TlDWt ES001H 2025-11-21T14:15:57.918Z 2025-11-28T14:56:39.230Z
8525080 8525080 20251119050155_5y1N5 ES001H 2025-11-20T14:22:15.149Z 2025-11-27T15:13:12.172Z
8524506 8524506 20251119035302_Ls5S4 ES001H 2025-11-20T14:20:58.088Z 2025-11-27T15:12:57.164Z
8523551 8523551 20251119021904_umAOQ ES001H 2025-11-20T14:18:46.542Z 2025-11-27T15:12:22.495Z
8523316 8523316 20251119015323_40p5q ES001H 2025-11-20T14:18:07.646Z 2025-11-27T15:12:11.894Z
8523087 8523087 20251119012700_6KVoT ES001H 2025-11-20T14:17:30.449Z 2025-11-27T15:12:08.931Z
8523060 8523060 20251119012502_msAuo ES001H 2025-11-20T14:17:28.316Z 2025-11-27T15:12:08.797Z
8522208 8522208 20251118233355_0S6Qn ES001H 2025-11-20T14:14:47.854Z 2025-11-27T15:11:56.923Z
8521570 8521570 20251118212102_9HdGu ES001H 2025-11-20T14:12:44.294Z 2025-11-27T15:11:39.876Z
8490327 8490327 20251116191155_6GQQf ES001H 2025-11-18T14:13:40.981Z 2025-11-25T15:08:13.294Z
8470447 8470447 20251115050132_yuphZ ES001H 2025-11-16T14:22:52.400Z 2025-11-23T15:18:10.024Z
8467596 8467596 20251114204039_Jt2Dx ES001H 2025-11-16T14:15:05.947Z 2025-11-23T15:17:10.240Z
8459970 8459970 20251114052114_xi9L2 ES001H 2025-11-15T14:21:03.365Z 2025-11-22T15:22:20.638Z
8452802 8452802 20251112022620_dmDbE ES001H 2025-11-14T14:37:18.035Z 2025-11-20T15:24:45.161Z
8452783 8452783 20251111235609_C0Da2 ES001H 2025-11-14T14:36:04.536Z 2025-11-20T15:23:29.475Z
8449152 8449152 20251113012324_XBS3m ES001H 2025-11-14T14:19:35.860Z 2025-11-21T15:11:53.531Z
8448497 8448497 20251112231858_cF0HG ES001H 2025-11-14T14:17:30.541Z 2025-11-21T15:11:30.366Z
8439528 8439528 20251112040156_Dl1M5 ES001H 2025-11-13T14:26:42.455Z 2025-11-20T15:25:27.682Z
8439480 8439480 20251112035532_UtsUd ES001H 2025-11-13T14:26:37.915Z 2025-11-20T15:25:25.479Z
8438588 8438588 20251112021631_a0fy1 ES001H 2025-11-13T14:24:17.981Z 2025-11-20T15:24:41.677Z
8438484 8438484 20251112020345_V3Ty5 ES001H 2025-11-13T14:23:52.570Z 2025-11-20T15:24:36.766Z
8426154 8426154 20251111024040_zrWJu ES001H 2025-11-12T14:24:30.633Z 2025-11-19T15:16:58.507Z
8425513 8425513 20251111015248_NtAQl ES001H 2025-11-12T14:22:57.278Z 2025-11-19T15:16:42.829Z
8423608 8423608 20251110232037_QSHl9 ES001H 2025-11-12T14:18:34.984Z 2025-11-19T15:15:57.263Z
8421031 8421031 20251110200017_ZW8i3 ES001H 2025-11-12T14:12:51.334Z 2025-11-19T15:14:19.139Z
8405975 8405975 20251109045402_vR6Iu ES001H 2025-11-10T14:15:28.144Z 2025-11-17T14:59:06.345Z
8404002 8404002 20251109004925_cXFnr ES001H 2025-11-10T14:10:33.446Z 2025-11-17T14:58:40.895Z
8403830 8403830 20251109002338_R2CdV ES001H 2025-11-10T14:10:03.714Z 2025-11-17T14:58:39.759Z
8403722 8403722 20251109000318_zSIgk ES001H 2025-11-10T14:09:43.823Z 2025-11-17T14:58:38.352Z
8403668 8403668 20251108235507_JZn0K ES001H 2025-11-10T14:09:38.428Z 2025-11-17T14:58:37.800Z
8403251 8403251 20251108225039_yuaqD ES001H 2025-11-10T14:08:48.920Z 2025-11-17T14:58:34.441Z
8403078 8403078 20251108222154_MYs7r ES001H 2025-11-10T14:08:16.299Z 2025-11-17T14:58:31.418Z

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