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

5,390 rows where station_code = "ES000U" 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
9235910 9235910 20260120021704_C2sn4 ES000U 2026-01-21T14:20:44.512Z 2026-01-28T14:59:28.458Z
9235804 9235804 20260120020102_qP9Wt ES000U 2026-01-21T14:20:23.110Z 2026-01-28T14:59:21.514Z
9235593 9235593 20260120013719_AGfAe ES000U 2026-01-21T14:19:32.741Z 2026-01-28T14:59:08.998Z
9235535 9235535 20260120012946_2XlQp ES000U 2026-01-21T14:19:20.179Z 2026-01-28T14:59:01.042Z
9234954 9234954 20260119235532_rxT6X ES000U 2026-01-21T14:16:49.382Z 2026-01-28T14:58:22.059Z
9234670 9234670 20260119225415_V3FpO ES000U 2026-01-21T14:15:38.522Z 2026-01-28T14:57:59.232Z
9234072 9234072 20260119193152_Sihya ES000U 2026-01-21T14:12:10.136Z 2026-01-28T14:57:04.000Z
9230836 9230836 20260119051622_gsLys ES000U 2026-01-20T14:30:01.450Z 2026-01-27T15:05:29.690Z
9230752 9230752 20260119050059_SuckP ES000U 2026-01-20T14:29:36.219Z 2026-01-27T15:05:24.379Z
9230595 9230595 20260119043825_Exj6e ES000U 2026-01-20T14:28:49.116Z 2026-01-27T15:05:15.697Z
9230470 9230470 20260119042410_djL22 ES000U 2026-01-20T14:28:02.273Z 2026-01-27T15:04:56.622Z
9230350 9230350 20260119040604_2WprI ES000U 2026-01-20T14:27:21.846Z 2026-01-27T15:04:49.894Z
9230188 9230188 20260119033827_0UGgZ ES000U 2026-01-20T14:26:28.419Z 2026-01-27T15:04:32.085Z
9229996 9229996 20260119030738_U6urf ES000U 2026-01-20T14:25:23.196Z 2026-01-27T15:04:18.990Z
9229794 9229794 20260119023710_Zg4Q0 ES000U 2026-01-20T14:24:15.672Z 2026-01-27T15:03:57.143Z
9229706 9229706 20260119022238_m5EKq ES000U 2026-01-20T14:23:48.318Z 2026-01-27T15:03:50.690Z
9229590 9229590 20260119020457_3a49c ES000U 2026-01-20T14:23:15.799Z 2026-01-27T15:03:43.946Z
9229540 9229540 20260119015903_Unqx9 ES000U 2026-01-20T14:23:04.460Z 2026-01-27T15:03:41.389Z
9229455 9229455 20260119014933_moNLG ES000U 2026-01-20T14:22:40.512Z 2026-01-27T15:03:27.003Z
9229406 9229406 20260119014145_mHNwi ES000U 2026-01-20T14:22:23.717Z 2026-01-27T15:03:22.425Z
9229338 9229338 20260119013445_QT1UN ES000U 2026-01-20T14:22:09.397Z 2026-01-27T15:03:18.809Z
9229254 9229254 20260119011445_gf732 ES000U 2026-01-20T14:21:43.853Z 2026-01-27T15:03:14.130Z
9229238 9229238 20260119011126_po46o ES000U 2026-01-20T14:21:40.581Z 2026-01-27T15:03:13.358Z
9229216 9229216 20260119010742_vU28s ES000U 2026-01-20T14:21:35.466Z 2026-01-27T15:03:12.193Z
9229086 9229086 20260119004628_VDpZV ES000U 2026-01-20T14:20:55.105Z 2026-01-27T15:02:53.717Z
9229013 9229013 20260119003446_akzId ES000U 2026-01-20T14:20:37.428Z 2026-01-27T15:02:47.948Z
9228989 9228989 20260119003134_yjc2G ES000U 2026-01-20T14:20:30.758Z 2026-01-27T15:02:46.666Z
9228726 9228726 20260118234131_UzhAy ES000U 2026-01-20T14:19:14.123Z 2026-01-27T15:02:19.592Z
9228201 9228201 20260118203720_0P33M ES000U 2026-01-20T14:16:37.976Z 2026-01-27T15:01:33.523Z
9210283 9210283 20260114054156_yg8r6 ES000U 2026-01-16T14:28:44.560Z 2026-01-22T15:10:14.031Z
9210279 9210279 20260114052319_SeojJ ES000U 2026-01-16T14:28:30.544Z 2026-01-22T15:10:11.005Z
9210277 9210277 20260114052234_MWxds ES000U 2026-01-16T14:28:30.136Z 2026-01-22T15:10:10.912Z
9210275 9210275 20260114045845_FR2lX ES000U 2026-01-16T14:28:17.675Z 2026-01-22T15:10:08.185Z
9210271 9210271 20260114044253_3tYvu ES000U 2026-01-16T14:28:01.063Z 2026-01-22T15:10:03.894Z
9210265 9210265 20260114032530_k33mO ES000U 2026-01-16T14:26:52.954Z 2026-01-22T15:09:15.512Z
9208622 9208622 20260115061205_n12Ma ES000U 2026-01-16T14:13:21.630Z 2026-01-22T15:04:35.228Z
9208520 9208520 20260115055103_7AZDe ES000U 2026-01-16T14:13:01.221Z 2026-01-22T15:04:32.395Z
9194686 9194686 20260112220025_zDhIs ES000U 2026-01-14T14:10:16.966Z 2026-01-21T15:04:20.046Z
9189795 9189795 20260112062658_biTfC ES000U 2026-01-13T14:19:22.386Z 2026-01-20T15:23:40.479Z
9189689 9189689 20260112054911_2pqaw ES000U 2026-01-13T14:18:53.080Z 2026-01-20T15:23:35.288Z
9189547 9189547 20260112050420_KoODe ES000U 2026-01-13T14:18:09.817Z 2026-01-20T15:23:17.712Z
9189527 9189527 20260112045541_Mff3I ES000U 2026-01-13T14:18:05.189Z 2026-01-20T15:23:16.654Z
9189476 9189476 20260112043832_EHwL2 ES000U 2026-01-13T14:17:43.820Z 2026-01-20T15:23:12.509Z
9189368 9189368 20260112040942_MED3U ES000U 2026-01-13T14:17:14.188Z 2026-01-20T15:23:06.697Z
9189358 9189358 20260112040733_3SUJ0 ES000U 2026-01-13T14:17:11.466Z 2026-01-20T15:23:06.081Z
9188788 9188788 20260112015036_0vUEO ES000U 2026-01-13T14:14:17.230Z 2026-01-20T15:22:14.968Z
9188414 9188414 20260111232404_dyNu3 ES000U 2026-01-13T14:12:09.614Z 2026-01-20T15:21:40.889Z
9188389 9188389 20260111231313_uckfC ES000U 2026-01-13T14:12:02.086Z 2026-01-20T15:21:37.862Z
9188387 9188387 20260111231216_jzCkV ES000U 2026-01-13T14:12:01.383Z 2026-01-20T15:21:37.719Z
9188303 9188303 20260111222502_HwGxt ES000U 2026-01-13T14:11:33.059Z 2026-01-20T15:21:33.069Z
9188275 9188275 20260111215756_oP1wc ES000U 2026-01-13T14:11:23.127Z 2026-01-20T15:21:31.328Z
9182766 9182766 20260111063242_svurI ES000U 2026-01-12T14:15:43.926Z 2026-01-19T15:18:58.878Z
9182026 9182026 20260111040202_jqtp2 ES000U 2026-01-12T14:12:59.305Z 2026-01-19T15:18:00.991Z
9181807 9181807 20260111031708_UDks9 ES000U 2026-01-12T14:12:11.990Z 2026-01-19T15:17:49.545Z
9181694 9181694 20260111025110_bD6na ES000U 2026-01-12T14:11:46.744Z 2026-01-19T15:17:44.770Z
9181678 9181678 20260111024330_AYYc0 ES000U 2026-01-12T14:11:42.956Z 2026-01-19T15:17:43.988Z
9181451 9181451 20260111014849_gMbKY ES000U 2026-01-12T14:10:51.266Z 2026-01-19T15:17:20.028Z
9181391 9181391 20260111013659_GOM3q ES000U 2026-01-12T14:10:38.518Z 2026-01-19T15:17:16.059Z
9181151 9181151 20260111003527_Atlrw ES000U 2026-01-12T14:09:44.986Z 2026-01-19T15:17:05.559Z
9181025 9181025 20260110235624_qpuc2 ES000U 2026-01-12T14:09:17.926Z 2026-01-19T15:16:44.721Z
9180778 9180778 20260110222644_kaHnm ES000U 2026-01-12T14:08:19.648Z 2026-01-19T15:16:31.879Z
9180667 9180667 20260110212945_xQkOB ES000U 2026-01-12T14:07:56.379Z 2026-01-19T15:16:26.772Z
9175884 9175884 20260110040429_Ib32U ES000U 2026-01-11T14:07:39.833Z 2026-01-18T15:08:11.917Z
9175790 9175790 20260110034835_vdf23 ES000U 2026-01-11T14:07:23.174Z 2026-01-18T15:08:08.448Z
9175550 9175550 20260110025605_QmQuR ES000U 2026-01-11T14:06:43.129Z 2026-01-18T15:07:49.989Z
9175490 9175490 20260110023855_RTo05 ES000U 2026-01-11T14:06:33.188Z 2026-01-18T15:07:47.358Z
9175345 9175345 20260110020948_IlD3A ES000U 2026-01-11T14:06:08.610Z 2026-01-18T15:07:41.798Z
9175288 9175288 20260110015802_RRM3D ES000U 2026-01-11T14:05:57.878Z 2026-01-18T15:07:39.765Z
9175235 9175235 20260110014601_gT63P ES000U 2026-01-11T14:05:48.000Z 2026-01-18T15:07:38.164Z
9175217 9175217 20260110014455_5DxoP ES000U 2026-01-11T14:05:45.460Z 2026-01-18T15:07:37.425Z
9174828 9174828 20260109232127_qwvCB ES000U 2026-01-11T14:04:31.806Z 2026-01-18T15:07:12.657Z
9174785 9174785 20260109225226_e3v27 ES000U 2026-01-11T14:04:24.055Z 2026-01-18T15:07:10.928Z
9174653 9174653 20260109212855_e38AA ES000U 2026-01-11T14:03:56.892Z 2026-01-18T15:06:56.853Z
9167117 9167117 20260107224903_RLl2d ES000U 2026-01-09T14:06:20.366Z 2026-01-16T15:10:50.874Z
9160617 9160617 20260106063310_ncuFS ES000U 2026-01-07T14:13:12.299Z 2026-01-13T15:09:35.797Z
9160541 9160541 20260106061631_kvjpG ES000U 2026-01-07T14:12:57.824Z 2026-01-13T15:09:32.057Z
9159049 9159049 20260106013422_UE3z2 ES000U 2026-01-07T14:08:10.840Z 2026-01-13T15:07:58.803Z
9158054 9158054 20260105194808_BgdH2 ES000U 2026-01-07T14:04:38.200Z 2026-01-13T15:06:51.588Z
9157932 9157932 20260105192901_5gKnN ES000U 2026-01-07T14:04:13.416Z 2026-01-13T15:06:46.636Z
9109206 9109206 20251227022459_rYnxR ES000U 2025-12-31T15:06:03.041Z 2026-01-04T15:26:57.587Z
9109201 9109201 20251227012959_0Q0mB ES000U 2025-12-31T15:04:12.919Z 2026-01-04T15:25:59.155Z
9109199 9109199 20251227011930_c4n5g ES000U 2025-12-31T15:03:50.321Z 2026-01-04T15:25:50.547Z
9109186 9109186 20251226235652_b1Nqu ES000U 2025-12-31T15:01:43.505Z 2026-01-04T15:24:43.455Z
9104202 9104202 20251230053553_I0upC ES000U 2025-12-31T14:20:36.364Z 2026-01-07T15:09:34.245Z
9103656 9103656 20251230044950_RGUbr ES000U 2025-12-31T14:18:41.827Z 2026-01-07T15:09:02.438Z
9103578 9103578 20251230044107_vUgQo ES000U 2025-12-31T14:18:21.846Z 2026-01-07T15:08:50.730Z
9101871 9101871 20251230014956_8Ofeb ES000U 2025-12-31T14:10:55.699Z 2026-01-07T15:06:58.199Z
9101800 9101800 20251230013926_rnYes ES000U 2025-12-31T14:10:37.041Z 2026-01-07T15:06:49.120Z
9101307 9101307 20251229235604_Y7sOo ES000U 2025-12-31T14:07:46.369Z 2026-01-07T15:06:12.574Z
9065192 9065192 20251226045908_33jBr ES000U 2025-12-29T14:38:05.613Z 2026-01-03T15:36:47.540Z
9064905 9064905 20251226044120_7hp0C ES000U 2025-12-29T14:37:46.589Z 2026-01-03T15:36:30.563Z
9064903 9064903 20251226044114_boB9n ES000U 2025-12-29T14:37:46.218Z 2026-01-03T15:36:30.420Z
9064768 9064768 20251226043119_2y5TP ES000U 2025-12-29T14:37:25.722Z 2026-01-03T15:36:24.050Z
9064227 9064227 20251226035704_U8wUx ES000U 2025-12-29T14:36:37.438Z 2026-01-03T15:35:54.960Z
9064134 9064134 20251226035107_22hWm ES000U 2025-12-29T14:36:29.082Z 2026-01-03T15:35:50.984Z
9063311 9063311 20251226030526_6ezW3 ES000U 2025-12-29T14:34:59.611Z 2026-01-03T15:35:11.816Z
9047931 9047931 20251222025811_P1c2C ES000U 2025-12-28T14:58:12.431Z 2025-12-30T15:46:10.531Z
9047924 9047924 20251222024122_26cjM ES000U 2025-12-28T14:58:08.843Z 2025-12-30T15:45:53.008Z
8951583 8951583 20251215015019_Xd8VD ES000U 2025-12-24T15:09:08.351Z 2025-12-24T15:09:08.351Z
8951255 8951255 20251215013235_fTt9u ES000U 2025-12-24T15:08:01.443Z 2025-12-24T15:08:01.443Z

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