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

3,137 rows where station_code = "ES0019" 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
9236585 9236585 20260120033645_6WDHG ES0019 2026-01-21T14:23:27.205Z 2026-01-28T15:00:22.488Z
9236562 9236562 20260120033330_gOmt3 ES0019 2026-01-21T14:23:14.342Z 2026-01-28T15:00:20.542Z
9236324 9236324 20260120030056_ODM4C ES0019 2026-01-21T14:22:22.208Z 2026-01-28T14:59:55.393Z
9236291 9236291 20260120025706_3LdZo ES0019 2026-01-21T14:22:16.836Z 2026-01-28T14:59:53.781Z
9235622 9235622 20260120013952_HpsGe ES0019 2026-01-21T14:19:41.628Z 2026-01-28T14:59:12.918Z
9235618 9235618 20260120013858_5V0Gs ES0019 2026-01-21T14:19:36.416Z 2026-01-28T14:59:12.719Z
9235515 9235515 20260120012525_5NN8n ES0019 2026-01-21T14:19:16.781Z 2026-01-28T14:59:00.231Z
9235415 9235415 20260120010740_m3z0B ES0019 2026-01-21T14:18:50.197Z 2026-01-28T14:58:53.833Z
9235333 9235333 20260120005739_KGXeh ES0019 2026-01-21T14:18:30.354Z 2026-01-28T14:58:49.728Z
9235137 9235137 20260120003531_C7D2S ES0019 2026-01-21T14:17:42.717Z 2026-01-28T14:58:32.444Z
9234956 9234956 20260119235554_aALrr ES0019 2026-01-21T14:16:49.841Z 2026-01-28T14:58:22.194Z
9234911 9234911 20260119234844_l3G3w ES0019 2026-01-21T14:16:39.714Z 2026-01-28T14:58:20.462Z
9234858 9234858 20260119234214_ut79V ES0019 2026-01-21T14:16:30.161Z 2026-01-28T14:58:17.550Z
9234652 9234652 20260119224715_DWMCG ES0019 2026-01-21T14:15:34.633Z 2026-01-28T14:57:58.387Z
9234378 9234378 20260119210851_SU6Vd ES0019 2026-01-21T14:14:04.748Z 2026-01-28T14:57:35.043Z
9234336 9234336 20260119205047_3y3d9 ES0019 2026-01-21T14:13:50.057Z 2026-01-28T14:57:30.354Z
9234153 9234153 20260119194937_J4TT2 ES0019 2026-01-21T14:12:35.378Z 2026-01-28T14:57:18.032Z
9234065 9234065 20260119192806_w9E0p ES0019 2026-01-21T14:12:05.276Z 2026-01-28T14:57:03.108Z
9230957 9230957 20260119053316_BDYGs ES0019 2026-01-20T14:30:36.880Z 2026-01-27T15:05:49.996Z
9230869 9230869 20260119052022_P22gZ ES0019 2026-01-20T14:30:09.520Z 2026-01-27T15:05:33.914Z
9230834 9230834 20260119051608_NB3K5 ES0019 2026-01-20T14:30:00.697Z 2026-01-27T15:05:29.516Z
9230471 9230471 20260119042410_djL22 ES0019 2026-01-20T14:28:02.273Z 2026-01-27T15:04:56.622Z
9230444 9230444 20260119041926_PATNG ES0019 2026-01-20T14:27:54.395Z 2026-01-27T15:04:54.836Z
9230313 9230313 20260119035827_3T8c8 ES0019 2026-01-20T14:27:12.198Z 2026-01-27T15:04:48.143Z
9230210 9230210 20260119034018_Wj0Ar ES0019 2026-01-20T14:26:39.479Z 2026-01-27T15:04:42.496Z
9230116 9230116 20260119032840_e1vlH ES0019 2026-01-20T14:26:02.854Z 2026-01-27T15:04:26.226Z
9230060 9230060 20260119032051_PNX7t ES0019 2026-01-20T14:25:44.494Z 2026-01-27T15:04:23.033Z
9230017 9230017 20260119030949_7FJfz ES0019 2026-01-20T14:25:28.821Z 2026-01-27T15:04:20.522Z
9229895 9229895 20260119025247_MeD31 ES0019 2026-01-20T14:24:52.019Z 2026-01-27T15:04:13.756Z
9229858 9229858 20260119024604_0JHy0 ES0019 2026-01-20T14:24:38.850Z 2026-01-27T15:04:01.218Z
9229695 9229695 20260119022027_raq4U ES0019 2026-01-20T14:23:45.201Z 2026-01-27T15:03:50.052Z
9229687 9229687 20260119021728_CTwau ES0019 2026-01-20T14:23:43.174Z 2026-01-27T15:03:49.534Z
9229666 9229666 20260119021510_8WHn6 ES0019 2026-01-20T14:23:38.509Z 2026-01-27T15:03:48.099Z
9229640 9229640 20260119020940_7n7nO ES0019 2026-01-20T14:23:31.580Z 2026-01-27T15:03:46.224Z
9229591 9229591 20260119020457_3a49c ES0019 2026-01-20T14:23:15.799Z 2026-01-27T15:03:43.946Z
9229541 9229541 20260119015903_Unqx9 ES0019 2026-01-20T14:23:04.460Z 2026-01-27T15:03:41.389Z
9229423 9229423 20260119014405_KNqy4 ES0019 2026-01-20T14:22:28.674Z 2026-01-27T15:03:24.860Z
9229329 9229329 20260119013320_iiwcR ES0019 2026-01-20T14:22:07.401Z 2026-01-27T15:03:18.228Z
9229317 9229317 20260119013035_f5qnP ES0019 2026-01-20T14:22:04.754Z 2026-01-27T15:03:17.595Z
9229242 9229242 20260119011214_fkAGd ES0019 2026-01-20T14:21:41.252Z 2026-01-27T15:03:13.494Z
9229087 9229087 20260119004628_VDpZV ES0019 2026-01-20T14:20:55.105Z 2026-01-27T15:02:53.717Z
9229039 9229039 20260119003827_2VbCQ ES0019 2026-01-20T14:20:41.934Z 2026-01-27T15:02:48.935Z
9229028 9229028 20260119003617_5nCfy ES0019 2026-01-20T14:20:39.547Z 2026-01-27T15:02:48.391Z
9228833 9228833 20260119000301_8X5C8 ES0019 2026-01-20T14:19:44.718Z 2026-01-27T15:02:38.291Z
9228724 9228724 20260118234127_5ciQZ ES0019 2026-01-20T14:19:13.444Z 2026-01-27T15:02:19.456Z
9228044 9228044 20260118192748_DhfcS ES0019 2026-01-20T14:15:43.352Z 2026-01-27T15:01:22.603Z
9210281 9210281 20260114052835_0sJw2 ES0019 2026-01-16T14:28:36.279Z 2026-01-22T15:10:12.065Z
9210267 9210267 20260114040403_4r3Dh ES0019 2026-01-16T14:27:24.590Z 2026-01-22T15:09:28.882Z
9208644 9208644 20260115061859_BJEUR ES0019 2026-01-16T14:13:29.251Z 2026-01-22T15:04:36.031Z
9208521 9208521 20260115055103_7AZDe ES0019 2026-01-16T14:13:01.221Z 2026-01-22T15:04:32.395Z
9193254 9193254 20260111044258_bZ3zh ES0019 2026-01-13T14:38:11.247Z 2026-01-19T15:18:20.639Z
9193248 9193248 20260111003204_ECJO1 ES0019 2026-01-13T14:36:28.353Z 2026-01-19T15:17:04.963Z
9189711 9189711 20260112055838_4tApS ES0019 2026-01-13T14:18:58.107Z 2026-01-20T15:23:36.603Z
9189641 9189641 20260112053359_Uaoin ES0019 2026-01-13T14:18:39.680Z 2026-01-20T15:23:32.923Z
9189627 9189627 20260112053026_3686x ES0019 2026-01-13T14:18:35.726Z 2026-01-20T15:23:32.188Z
9189528 9189528 20260112045541_Mff3I ES0019 2026-01-13T14:18:05.189Z 2026-01-20T15:23:16.654Z
9189342 9189342 20260112040219_8TXtL ES0019 2026-01-13T14:17:07.399Z 2026-01-20T15:23:05.399Z
9188745 9188745 20260112013852_AGPpG ES0019 2026-01-13T14:14:01.348Z 2026-01-20T15:22:11.521Z
9188376 9188376 20260111230814_Cn9Iy ES0019 2026-01-13T14:11:58.825Z 2026-01-20T15:21:37.256Z
9188139 9188139 20260111205227_U4hBq ES0019 2026-01-13T14:10:38.076Z 2026-01-20T15:21:23.182Z
9187957 9187957 20260111194054_MMvKb ES0019 2026-01-13T14:09:44.230Z 2026-01-20T15:21:03.188Z
9182678 9182678 20260111060710_BMeSx ES0019 2026-01-12T14:15:23.129Z 2026-01-19T15:18:54.783Z
9182474 9182474 20260111052721_QX3Y5 ES0019 2026-01-12T14:14:41.408Z 2026-01-19T15:18:33.761Z
9182266 9182266 20260111045337_3AaKt ES0019 2026-01-12T14:13:56.535Z 2026-01-19T15:18:23.322Z
9182256 9182256 20260111045201_kIeSR ES0019 2026-01-12T14:13:54.975Z 2026-01-19T15:18:22.994Z
9181999 9181999 20260111035847_IT9cz ES0019 2026-01-12T14:12:54.414Z 2026-01-19T15:17:59.629Z
9181915 9181915 20260111034052_qkIVf ES0019 2026-01-12T14:12:35.027Z 2026-01-19T15:17:53.948Z
9181754 9181754 20260111030332_aYtr2 ES0019 2026-01-12T14:12:03.044Z 2026-01-19T15:17:47.327Z
9181460 9181460 20260111015042_D33Xo ES0019 2026-01-12T14:10:52.433Z 2026-01-19T15:17:20.404Z
9181452 9181452 20260111014849_gMbKY ES0019 2026-01-12T14:10:51.266Z 2026-01-19T15:17:20.028Z
9181362 9181362 20260111012947_ithY4 ES0019 2026-01-12T14:10:32.189Z 2026-01-19T15:17:14.490Z
9181246 9181246 20260111010710_j1PJV ES0019 2026-01-12T14:10:06.350Z 2026-01-19T15:17:09.475Z
9181197 9181197 20260111005025_VwkMz ES0019 2026-01-12T14:09:55.404Z 2026-01-19T15:17:07.519Z
9180886 9180886 20260110231046_x27bq ES0019 2026-01-12T14:08:46.174Z 2026-01-19T15:16:37.527Z
9180871 9180871 20260110230410_vKP7J ES0019 2026-01-12T14:08:41.751Z 2026-01-19T15:16:36.289Z
9180785 9180785 20260110223033_dJmN1 ES0019 2026-01-12T14:08:21.260Z 2026-01-19T15:16:32.432Z
9180692 9180692 20260110213558_nsz4z ES0019 2026-01-12T14:08:01.926Z 2026-01-19T15:16:27.970Z
9175491 9175491 20260110023855_RTo05 ES0019 2026-01-11T14:06:33.188Z 2026-01-18T15:07:47.358Z
9175407 9175407 20260110022454_dhJLu ES0019 2026-01-11T14:06:21.477Z 2026-01-18T15:07:44.494Z
9167044 9167044 20260107220233_3ywGQ ES0019 2026-01-09T14:05:59.281Z 2026-01-16T15:10:38.069Z
9163135 9163135 20260107055052_saVio ES0019 2026-01-08T14:08:12.905Z 2026-01-13T15:03:02.592Z
9163046 9163046 20260107053514_CXgS3 ES0019 2026-01-08T14:08:01.061Z 2026-01-13T15:02:59.641Z
9163023 9163023 20260107052757_4Q0uJ ES0019 2026-01-08T14:07:45.444Z 2026-01-13T15:02:57.817Z
9160293 9160293 20260106052431_YNG2h ES0019 2026-01-07T14:12:08.856Z 2026-01-13T15:09:18.830Z
9160077 9160077 20260106044629_AG33K ES0019 2026-01-07T14:11:20.168Z 2026-01-13T15:08:59.813Z
9158069 9158069 20260105195124_tefeG ES0019 2026-01-07T14:04:42.443Z 2026-01-13T15:06:52.806Z
9109393 9109393 20251226193635_IoSJk ES0019 2025-12-31T15:32:06.875Z 2026-01-03T15:43:29.087Z
9109210 9109210 20251227030712_tl65s ES0019 2025-12-31T15:07:24.493Z 2026-01-04T15:27:43.805Z
9109208 9109208 20251227022919_WO4Ew ES0019 2025-12-31T15:06:10.454Z 2026-01-04T15:27:01.170Z
9104255 9104255 20251230054021_wGY7n ES0019 2025-12-31T14:20:47.170Z 2026-01-07T15:09:37.116Z
9103674 9103674 20251230045145_JeqC3 ES0019 2025-12-31T14:18:49.561Z 2026-01-07T15:09:03.601Z
9102291 9102291 20251230024511_7bQz5 ES0019 2025-12-31T14:13:09.240Z 2026-01-07T15:07:31.560Z
9101971 9101971 20251230020932_cnE9f ES0019 2025-12-31T14:11:32.325Z 2026-01-07T15:07:05.256Z
9101340 9101340 20251230000605_wqhJH ES0019 2025-12-31T14:08:01.615Z 2026-01-07T15:06:14.634Z
9063830 9063830 20251226033505_VuMMm ES0019 2025-12-29T14:35:57.479Z 2026-01-03T15:35:40.535Z
8951139 8951139 20251215012659_pcspJ ES0019 2025-12-24T15:07:47.484Z 2025-12-24T15:07:47.484Z
8951084 8951084 20251215012413_K4NFH ES0019 2025-12-24T15:07:46.295Z 2025-12-24T15:07:46.295Z
8951014 8951014 20251215012100_ZPDZ6 ES0019 2025-12-24T15:07:44.231Z 2025-12-24T15:07:44.231Z
8949931 8949931 20251215003057_sQX9c ES0019 2025-12-24T15:06:25.753Z 2025-12-24T15:06:25.753Z
8949911 8949911 20251215002940_XFcjw ES0019 2025-12-24T15:06:23.386Z 2025-12-24T15:06:23.386Z

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