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,638 rows where station_code = "ES000E" 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
9606994 9606994 20260403021924_EzKAz ES000E 2026-04-04T12:12:41.865Z 2026-04-06T12:24:01.744Z
9606947 9606947 20260403004206_xUJ9L ES000E 2026-04-04T12:12:26.250Z 2026-04-06T12:23:58.222Z
9604699 9604699 20260401235140_uADQG ES000E 2026-04-03T12:11:16.688Z 2026-04-06T12:26:12.346Z
9602866 9602866 20260402034028_9V2F7 ES000E 2026-04-03T12:00:59.173Z 2026-04-06T12:21:17.168Z
9600851 9600851 20260401040001_7HjyN ES000E 2026-04-02T12:00:37.135Z 2026-04-06T12:24:16.941Z
9598696 9598696 20260331030103_X1O1o ES000E 2026-04-01T12:00:36.014Z 2026-04-06T12:26:47.800Z
9598401 9598401 20260329234708_oOUzZ ES000E 2026-03-31T12:10:32.319Z 2026-04-06T12:36:29.740Z
9595313 9595313 20260330032425_Xm12r ES000E 2026-03-31T12:01:04.912Z 2026-04-06T12:29:57.014Z
9595007 9595007 20260330013337_TIOk2 ES000E 2026-03-31T12:00:09.472Z 2026-04-06T12:29:34.279Z
9594638 9594638 20260328233833_5T2Lt ES000E 2026-03-30T12:10:01.516Z 2026-04-06T12:40:02.146Z
9585798 9585798 20260327023414_3H430 ES000E 2026-03-28T12:01:22.331Z 2026-04-05T12:32:46.135Z
9584865 9584865 20260325223158_JpZgb ES000E 2026-03-27T12:16:17.476Z 2026-04-03T12:39:42.916Z
9581822 9581822 20260326040142_O6w3Q ES000E 2026-03-27T12:03:54.488Z 2026-04-04T12:39:21.508Z
9581664 9581664 20260326034133_2G3uy ES000E 2026-03-27T12:03:37.055Z 2026-04-04T12:39:13.971Z
9580602 9580602 20260326010614_byWj4 ES000E 2026-03-27T12:00:54.696Z 2026-04-04T12:38:17.222Z
9579728 9579728 20260324223017_kCUjf ES000E 2026-03-26T12:14:17.134Z 2026-04-02T12:37:27.446Z
9576038 9576038 20260325010253_iOjXj ES000E 2026-03-26T12:01:03.838Z 2026-04-03T12:35:41.840Z
9575785 9575785 20260325001754_vtBJ4 ES000E 2026-03-26T12:00:12.879Z 2026-04-03T12:35:22.221Z
9571706 9571706 20260324033851_C51Vq ES000E 2026-03-25T12:02:25.878Z 2026-04-02T12:34:40.284Z
9571397 9571397 20260324015149_YV3pT ES000E 2026-03-25T12:01:18.636Z 2026-04-02T12:34:24.557Z
9561224 9561224 20260321230952_NjQov ES000E 2026-03-23T12:12:14.257Z 2026-03-29T12:21:05.834Z
9561197 9561197 20260321230725_AX2MA ES000E 2026-03-23T12:12:13.382Z 2026-03-29T12:21:05.580Z
9555177 9555177 20260322041351_CxZBX ES000E 2026-03-23T12:03:13.505Z 2026-03-30T12:28:22.315Z
9554991 9554991 20260322035205_hRC22 ES000E 2026-03-23T12:03:00.880Z 2026-03-30T12:28:12.773Z
9554333 9554333 20260322030029_DadFF ES000E 2026-03-23T12:02:27.192Z 2026-03-30T12:28:02.511Z
9552575 9552575 20260322002104_sHmyG ES000E 2026-03-23T12:00:34.551Z 2026-03-30T12:27:26.196Z
9552184 9552184 20260320231014_V1TJy ES000E 2026-03-22T12:27:31.156Z 2026-03-28T12:37:07.647Z
9542927 9542927 20260321015350_qLOJL ES000E 2026-03-22T12:02:06.096Z 2026-03-29T12:19:00.351Z
9533844 9533844 20260320030603_odqJj ES000E 2026-03-21T12:06:28.779Z 2026-03-28T12:34:01.534Z
9532780 9532780 20260320012704_6Mte6 ES000E 2026-03-21T12:03:37.524Z 2026-03-28T12:33:43.903Z
9516429 9516429 20260317204741_N9HXY ES000E 2026-03-19T12:26:10.846Z 2026-03-25T12:42:58.497Z
9512205 9512205 20260318045540_oBC4v ES000E 2026-03-19T12:11:55.702Z 2026-03-26T12:37:42.978Z
9511550 9511550 20260318040114_UlutD ES000E 2026-03-19T12:10:26.920Z 2026-03-26T12:37:37.797Z
9510910 9510910 20260318032256_ry4H1 ES000E 2026-03-19T12:08:58.108Z 2026-03-26T12:37:17.790Z
9510752 9510752 20260318031152_IxBf7 ES000E 2026-03-19T12:08:34.487Z 2026-03-26T12:37:16.401Z
9501161 9501161 20260315212145_zLfug ES000E 2026-03-17T12:24:33.318Z 2026-03-23T12:22:43.429Z
9495224 9495224 20260316045749_tfnT3 ES000E 2026-03-17T12:06:29.688Z 2026-03-24T12:41:05.541Z
9494659 9494659 20260316024340_k2WGM ES000E 2026-03-17T12:04:33.118Z 2026-03-24T12:40:49.133Z
9485722 9485722 20260315034435_xq8rc ES000E 2026-03-16T12:07:24.135Z 2026-03-23T12:21:53.623Z
9485439 9485439 20260315030531_6mM79 ES000E 2026-03-16T12:06:26.597Z 2026-03-23T12:21:52.270Z
9485089 9485089 20260315022603_LN1KM ES000E 2026-03-16T12:05:14.580Z 2026-03-23T12:21:49.987Z
9474267 9474267 20260312220655_XZUQI ES000E 2026-03-14T12:22:25.797Z 2026-03-20T12:37:17.136Z
9468487 9468487 20260312230102_8wCcv ES000E 2026-03-14T12:00:21.989Z 2026-03-21T12:48:25.231Z
9467700 9467700 20260311223516_pmHek ES000E 2026-03-13T12:19:42.318Z 2026-03-19T12:45:54.302Z
9467557 9467557 20260311221138_jFyX4 ES000E 2026-03-13T12:19:26.457Z 2026-03-19T12:45:53.250Z
9462673 9462673 20260311235819_hAMbG ES000E 2026-03-13T12:01:48.495Z 2026-03-20T12:36:17.489Z
9457609 9457609 20260311043420_IIv2Y ES000E 2026-03-12T12:04:09.857Z 2026-03-19T12:44:48.228Z
9457297 9457297 20260311032419_d9E12 ES000E 2026-03-12T12:03:30.177Z 2026-03-19T12:44:36.962Z
9451479 9451479 20260310022047_kgTk9 ES000E 2026-03-11T12:02:54.696Z 2026-03-18T12:38:47.073Z
9451234 9451234 20260310012321_2EgHL ES000E 2026-03-11T12:02:11.727Z 2026-03-18T12:38:43.471Z
8028250 8028250 20250930234628_dwisr ES000E 2025-10-02T12:25:54.359Z 2025-10-09T12:38:43.199Z
8027274 8027274 20250930221318_QnfsD ES000E 2025-10-02T12:23:14.279Z 2025-10-09T12:38:13.038Z
8018170 8018170 20250930035730_Cfs3y ES000E 2025-10-01T12:28:17.890Z 2025-10-08T12:43:58.326Z
8018141 8018141 20250930034149_Ze4cc ES000E 2025-10-01T12:28:13.984Z 2025-10-08T12:43:53.078Z
8018116 8018116 20250930032748_4cvBc ES000E 2025-10-01T12:28:09.559Z 2025-10-08T12:43:49.215Z
8018086 8018086 20250930031217_mjsoA ES000E 2025-10-01T12:28:05.329Z 2025-10-08T12:43:44.530Z
8017988 8017988 20250930023438_faj2p ES000E 2025-10-01T12:27:42.177Z 2025-10-08T12:43:33.342Z
8017983 8017983 20250930022746_QU8aF ES000E 2025-10-01T12:27:40.451Z 2025-10-08T12:43:32.461Z
8017957 8017957 20250930021713_luFPH ES000E 2025-10-01T12:27:35.754Z 2025-10-08T12:43:27.536Z
8017818 8017818 20250930012747_Nvy5I ES000E 2025-10-01T12:27:13.685Z 2025-10-08T12:43:15.757Z
8016663 8016663 20250929222723_wjDPs ES000E 2025-10-01T12:24:19.556Z 2025-10-08T12:42:34.586Z
8016544 8016544 20250929221029_WrdDt ES000E 2025-10-01T12:23:53.343Z 2025-10-08T12:42:31.426Z
8015648 8015648 20250929191222_J98gP ES000E 2025-10-01T12:20:47.630Z 2025-10-08T12:42:10.449Z
8009824 8009824 20250929033357_DHmGx ES000E 2025-09-30T12:32:07.404Z 2025-10-07T13:01:20.439Z
8004466 8004466 20250928235353_HJ6RE ES000E 2025-09-30T12:22:42.261Z 2025-10-07T13:00:47.231Z
7989767 7989767 20250926041116_Dup8e ES000E 2025-09-28T12:36:51.654Z 2025-10-04T13:07:24.039Z
7985635 7985635 20250927034017_KgQ24 ES000E 2025-09-28T12:26:41.625Z 2025-10-05T13:11:17.495Z
7985490 7985490 20250927032820_SaLmb ES000E 2025-09-28T12:26:29.702Z 2025-10-05T13:11:16.577Z
7985152 7985152 20250927025513_0P27m ES000E 2025-09-28T12:25:51.043Z 2025-10-05T13:11:08.156Z
7984440 7984440 20250927013923_WjzfW ES000E 2025-09-28T12:24:18.687Z 2025-10-05T13:10:51.793Z
7984437 7984437 20250927013920_6msVy ES000E 2025-09-28T12:24:18.517Z 2025-10-05T13:10:51.561Z
7984182 7984182 20250927005802_f5yLF ES000E 2025-09-28T12:23:43.197Z 2025-10-05T13:10:48.206Z
7984087 7984087 20250927004457_4IczG ES000E 2025-09-28T12:23:35.411Z 2025-10-05T13:10:46.349Z
7983994 7983994 20250927002634_Bsk33 ES000E 2025-09-28T12:23:11.005Z 2025-10-05T13:10:44.421Z
7983934 7983934 20250927001557_4gMS3 ES000E 2025-09-28T12:23:06.484Z 2025-10-05T13:10:43.904Z
7983839 7983839 20250926235458_1N024 ES000E 2025-09-28T12:22:59.917Z 2025-10-05T13:10:43.658Z
7983781 7983781 20250926233705_I5382 ES000E 2025-09-28T12:22:54.745Z 2025-10-05T13:10:43.192Z
7983691 7983691 20250926231356_3qITv ES000E 2025-09-28T12:22:33.842Z 2025-10-05T13:10:42.658Z
7983518 7983518 20250926223109_kQRue ES000E 2025-09-28T12:22:16.970Z 2025-10-05T13:10:41.045Z
7982993 7982993 20250926202103_5UDjI ES000E 2025-09-28T12:21:03.169Z 2025-10-05T13:10:28.272Z
7982462 7982462 20250926190608_vv8bK ES000E 2025-09-28T12:19:52.044Z 2025-10-05T13:10:18.243Z
7976671 7976671 20250926043248_dqfkg ES000E 2025-09-28T12:06:02.294Z 2025-10-05T13:08:06.908Z
7960355 7960355 20250925003256_x50sQ ES000E 2025-09-26T12:24:30.173Z 2025-10-03T13:04:12.074Z
7957173 7957173 20250924202039_be6vD ES000E 2025-09-26T12:18:48.679Z 2025-10-03T13:03:57.391Z
7951143 7951143 20250924032427_fwLpH ES000E 2025-09-25T12:35:56.959Z 2025-10-02T13:28:09.261Z
7950898 7950898 20250924031124_3g79a ES000E 2025-09-25T12:35:33.742Z 2025-10-02T13:28:03.415Z
7950713 7950713 20250924030216_U8lri ES000E 2025-09-25T12:35:26.481Z 2025-10-02T13:28:01.144Z
7950541 7950541 20250924025216_f2F2b ES000E 2025-09-25T12:35:18.451Z 2025-09-25T12:36:35.033Z
7949928 7949928 20250924022145_dzJMj ES000E 2025-09-25T12:34:34.324Z 2025-10-02T13:27:41.811Z
7949106 7949106 20250924013408_MItRw ES000E 2025-09-25T12:33:19.821Z 2025-10-02T13:27:19.795Z
7948071 7948071 20250924003950_xC8pe ES000E 2025-09-25T12:31:33.353Z 2025-10-02T13:26:57.037Z
7946616 7946616 20250923231752_Ojajf ES000E 2025-09-25T12:29:11.752Z 2025-10-02T13:26:41.666Z
7937910 7937910 20250924040821_3Xea3 ES000E 2025-09-25T12:01:56.566Z 2025-10-03T13:02:31.279Z
7922218 7922218 20250923023500_XKn9O ES000E 2025-09-24T12:31:08.307Z 2025-10-01T13:24:53.951Z
7918678 7918678 20250922234105_3XFjN ES000E 2025-09-24T12:26:10.823Z 2025-10-01T13:24:10.164Z
7917528 7917528 20250922222547_AsXRM ES000E 2025-09-24T12:24:06.329Z 2025-10-01T13:23:52.759Z
7909363 7909363 20250923031347_BlsqP ES000E 2025-09-24T12:00:48.909Z 2025-10-02T13:22:18.504Z
7909333 7909333 20250923031230_3EiGs ES000E 2025-09-24T12:00:41.386Z 2025-10-02T13:22:18.026Z
7896200 7896200 20250920003909_uZ3I0 ES000E 2025-09-21T12:39:40.503Z 2025-09-28T12:54:47.771Z
7895236 7895236 20250919233610_DoPIl ES000E 2025-09-21T12:38:27.990Z 2025-09-28T12:54:39.964Z

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