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,422 rows where station_code = "UK00CH" 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
9255183 9255183 20260124013248_wVgI7 UK00CH 2026-01-25T14:12:12.618Z 2026-01-29T14:47:06.622Z
9252687 9252687 20260123051802_i3VYo UK00CH 2026-01-24T14:16:43.762Z 2026-01-29T14:53:16.113Z
9252640 9252640 20260123045245_kP0cH UK00CH 2026-01-24T14:16:31.799Z 2026-01-29T14:53:13.002Z
9244157 9244157 20260121062715_dc69X UK00CH 2026-01-22T14:24:27.061Z 2026-01-29T15:05:54.187Z
9243113 9243113 20260121034323_ZR1WR UK00CH 2026-01-22T14:20:35.567Z 2026-01-29T15:04:46.812Z
9222085 9222085 20260117180254_6bt8B UK00CH 2026-01-19T14:13:09.762Z 2026-01-26T15:00:37.446Z
9212119 9212119 20260115191614_cLb3h UK00CH 2026-01-17T14:10:02.653Z 2026-01-24T15:10:24.719Z
9208800 9208800 20260115065305_G4oT2 UK00CH 2026-01-16T14:14:02.195Z 2026-01-22T15:04:40.256Z
9208794 9208794 20260115065253_GTXOO UK00CH 2026-01-16T14:14:01.613Z 2026-01-22T15:04:40.203Z
9208768 9208768 20260115064405_PJvQq UK00CH 2026-01-16T14:13:54.114Z 2026-01-22T15:04:39.330Z
9208734 9208734 20260115063929_3Mxm4 UK00CH 2026-01-16T14:13:47.186Z 2026-01-22T15:04:38.428Z
9208163 9208163 20260115042237_aQUxK UK00CH 2026-01-16T14:11:33.819Z 2026-01-22T15:04:02.688Z
9207946 9207946 20260115033847_0fPcb UK00CH 2026-01-16T14:10:46.546Z 2026-01-22T15:03:57.131Z
9207465 9207465 20260115014357_An0LJ UK00CH 2026-01-16T14:08:51.313Z 2026-01-22T15:03:22.510Z
9207430 9207430 20260115013843_UBaVo UK00CH 2026-01-16T14:08:44.038Z 2026-01-22T15:03:21.805Z
9207389 9207389 20260115012116_wtM3b UK00CH 2026-01-16T14:08:33.690Z 2026-01-22T15:03:20.571Z
9207372 9207372 20260115011602_jC28n UK00CH 2026-01-16T14:08:27.947Z 2026-01-22T15:03:20.155Z
9207274 9207274 20260115003323_gorVx UK00CH 2026-01-16T14:08:02.696Z 2026-01-22T15:03:17.058Z
9203226 9203226 20260114044353_SIZ3A UK00CH 2026-01-15T14:23:51.498Z 2026-01-22T15:10:04.098Z
9203057 9203057 20260114043113_ohQeS UK00CH 2026-01-15T14:23:14.090Z 2026-01-22T15:10:01.125Z
9202933 9202933 20260114041838_LaDLJ UK00CH 2026-01-15T14:22:49.012Z 2026-01-22T15:09:59.472Z
9202787 9202787 20260114040825_c6inM UK00CH 2026-01-15T14:22:21.420Z 2026-01-22T15:09:41.093Z
9202156 9202156 20260114032139_S0m2B UK00CH 2026-01-15T14:20:36.130Z 2026-01-22T15:09:14.201Z
9202043 9202043 20260114031230_qz3FI UK00CH 2026-01-15T14:20:16.816Z 2026-01-22T15:09:12.317Z
9201971 9201971 20260114030809_RcxP9 UK00CH 2026-01-15T14:20:12.532Z 2026-01-22T15:09:11.888Z
9201802 9201802 20260114025316_aaDIf UK00CH 2026-01-15T14:19:45.743Z 2026-01-22T15:09:09.903Z
9201758 9201758 20260114024811_UZzPQ UK00CH 2026-01-15T14:19:39.604Z 2026-01-22T15:09:09.043Z
9201111 9201111 20260114014247_ydBzl UK00CH 2026-01-15T14:17:33.949Z 2026-01-22T15:08:57.782Z
9200971 9200971 20260114012554_kOdIv UK00CH 2026-01-15T14:17:06.611Z 2026-01-22T15:08:40.840Z
9200564 9200564 20260114002415_yVWEx UK00CH 2026-01-15T14:15:37.230Z 2026-01-22T15:08:18.304Z
9200540 9200540 20260114002153_CuP7z UK00CH 2026-01-15T14:15:29.310Z 2026-01-22T15:08:17.954Z
9200463 9200463 20260114001239_5MW3U UK00CH 2026-01-15T14:15:15.665Z 2026-01-22T15:08:16.346Z
9200425 9200425 20260114000624_x1VEn UK00CH 2026-01-15T14:15:10.540Z 2026-01-22T15:08:15.738Z
9200297 9200297 20260113233756_0VpWX UK00CH 2026-01-15T14:14:38.840Z 2026-01-22T15:08:13.402Z
9200188 9200188 20260113230741_t8N0h UK00CH 2026-01-15T14:14:08.245Z 2026-01-22T15:08:10.992Z
9200068 9200068 20260113224721_8g23B UK00CH 2026-01-15T14:13:41.943Z 2026-01-22T15:08:09.063Z
9200023 9200023 20260113222608_WEaTR UK00CH 2026-01-15T14:13:33.962Z 2026-01-22T15:08:07.908Z
9199705 9199705 20260113210448_2qm6X UK00CH 2026-01-15T14:12:05.802Z 2026-01-22T15:08:00.216Z
9199273 9199273 20260113193640_jmweB UK00CH 2026-01-15T14:10:11.942Z 2026-01-22T15:07:18.385Z
9198991 9198991 20260113184701_1OmjL UK00CH 2026-01-15T14:08:42.910Z 2026-01-22T15:07:11.082Z
9195653 9195653 20260113021057_OPhUI UK00CH 2026-01-14T14:14:16.455Z 2026-01-21T15:04:44.986Z
9195212 9195212 20260113003847_IRcrD UK00CH 2026-01-14T14:12:24.006Z 2026-01-21T15:04:37.551Z
9194998 9194998 20260112235654_yaSgK UK00CH 2026-01-14T14:11:38.674Z 2026-01-21T15:04:34.854Z
9175433 9175433 20260110022747_remBP UK00CH 2026-01-11T14:06:25.292Z 2026-01-18T15:07:45.511Z
9175396 9175396 20260110021929_HPGVc UK00CH 2026-01-11T14:06:19.774Z 2026-01-18T15:07:44.110Z
9175392 9175392 20260110021929_32PN2 UK00CH 2026-01-11T14:06:19.299Z 2026-01-18T15:07:43.991Z
9175363 9175363 20260110021414_qhwIk UK00CH 2026-01-11T14:06:11.735Z 2026-01-18T15:07:42.618Z
9175058 9175058 20260110005303_E42pZ UK00CH 2026-01-11T14:05:17.586Z 2026-01-18T15:07:24.527Z
9159124 9159124 20260106014647_BNUg2 UK00CH 2026-01-07T14:08:21.934Z 2026-01-13T15:08:09.007Z
9159046 9159046 20260106013326_f5KQ4 UK00CH 2026-01-07T14:08:10.111Z 2026-01-13T15:07:58.650Z
9159021 9159021 20260106012241_on04X UK00CH 2026-01-07T14:08:01.867Z 2026-01-13T15:07:57.339Z
9158977 9158977 20260106011250_ROhTq UK00CH 2026-01-07T14:07:50.723Z 2026-01-13T15:07:53.484Z
9158772 9158772 20260106002334_SLuGf UK00CH 2026-01-07T14:07:15.049Z 2026-01-13T15:07:45.794Z
9158382 9158382 20260105220633_Wxwh3 UK00CH 2026-01-07T14:05:53.211Z 2026-01-13T15:07:19.813Z
9157841 9157841 20260105185854_ZcSiH UK00CH 2026-01-07T14:03:48.655Z 2026-01-13T15:06:33.932Z
9153175 9153175 20260103233459_XJUg3 UK00CH 2026-01-06T14:25:04.890Z 2026-01-12T15:03:34.260Z
9153157 9153157 20260103222718_aQk35 UK00CH 2026-01-06T14:24:17.768Z 2026-01-12T15:02:50.260Z
9153119 9153119 20260103192346_mdSJk UK00CH 2026-01-06T14:22:04.195Z 2026-01-12T15:00:51.511Z
9150157 9150157 20260105011614_3HymE UK00CH 2026-01-06T14:08:49.234Z 2026-01-13T15:13:08.304Z
9149967 9149967 20260105001957_fKLBQ UK00CH 2026-01-06T14:07:59.553Z 2026-01-13T15:12:47.754Z
9149943 9149943 20260105001622_R9PJ7 UK00CH 2026-01-06T14:07:55.498Z 2026-01-13T15:12:46.799Z
9149929 9149929 20260105001306_1nuB8 UK00CH 2026-01-06T14:07:51.673Z 2026-01-13T15:12:45.979Z
9149795 9149795 20260104233748_zI94t UK00CH 2026-01-06T14:07:12.249Z 2026-01-13T15:12:39.729Z
9149758 9149758 20260104232359_9vLNq UK00CH 2026-01-06T14:07:02.156Z 2026-01-13T15:12:37.197Z
9148409 9148409 20260103174431_9I15g UK00CH 2026-01-05T14:30:29.071Z 2026-01-10T15:04:29.482Z
9148362 9148362 20260103174023_KgpjI UK00CH 2026-01-05T14:30:26.488Z 2026-01-10T15:04:27.705Z
9148257 9148257 20260103173807_ZlGIO UK00CH 2026-01-05T14:30:23.491Z 2026-01-10T15:04:24.057Z
9142303 9142303 20260104013029_7M3Dv UK00CH 2026-01-05T14:15:58.058Z 2026-01-12T15:05:39.784Z
9141535 9141535 20260104005822_lSXVA UK00CH 2026-01-05T14:14:44.964Z 2026-01-12T15:05:03.467Z
9141454 9141454 20260104005459_ildcY UK00CH 2026-01-05T14:14:37.047Z 2026-01-12T15:05:01.357Z
9141096 9141096 20260104004226_tJNvm UK00CH 2026-01-05T14:14:10.118Z 2026-01-12T15:04:40.051Z
9140791 9140791 20260104003052_xH2OO UK00CH 2026-01-05T14:13:37.015Z 2026-01-12T15:04:30.474Z
9140699 9140699 20260104002609_nFqxe UK00CH 2026-01-05T14:13:30.629Z 2026-01-12T15:04:27.553Z
9140631 9140631 20260104002349_gdfQ0 UK00CH 2026-01-05T14:13:29.130Z 2026-01-12T15:04:26.786Z
9140604 9140604 20260104002300_N227r UK00CH 2026-01-05T14:13:27.186Z 2026-01-12T15:04:25.950Z
9140558 9140558 20260104002150_2bgi7 UK00CH 2026-01-05T14:13:20.746Z 2026-01-12T15:04:24.483Z
9140268 9140268 20260104000803_BxAK6 UK00CH 2026-01-05T14:12:57.581Z 2026-01-12T15:04:03.784Z
9140151 9140151 20260104000117_JPOve UK00CH 2026-01-05T14:12:33.882Z 2026-01-12T15:03:59.912Z
9139998 9139998 20260103235356_LDjac UK00CH 2026-01-05T14:12:22.018Z 2026-01-12T15:03:55.653Z
9139731 9139731 20260103234142_TNYyY UK00CH 2026-01-05T14:11:59.353Z 2026-01-12T15:03:49.329Z
9139615 9139615 20260103233551_QTJar UK00CH 2026-01-05T14:11:51.257Z 2026-01-12T15:03:34.880Z
9139597 9139597 20260103233459_6VdWK UK00CH 2026-01-05T14:11:50.216Z 2026-01-05T14:30:32.670Z
9139349 9139349 20260103232919_vZPAM UK00CH 2026-01-05T14:11:31.263Z 2026-01-12T15:03:26.438Z
9139111 9139111 20260103231225_ZDZOU UK00CH 2026-01-05T14:11:15.298Z 2026-01-12T15:03:20.987Z
9139023 9139023 20260103230743_e0fuK UK00CH 2026-01-05T14:11:04.030Z 2026-01-12T15:03:18.415Z
9138938 9138938 20260103230242_rUs2t UK00CH 2026-01-05T14:10:49.839Z 2026-01-12T15:03:16.120Z
9138934 9138934 20260103230127_BtNY3 UK00CH 2026-01-05T14:10:49.032Z 2026-01-12T15:03:15.918Z
9138917 9138917 20260103230034_qvUXu UK00CH 2026-01-05T14:10:48.065Z 2026-01-12T15:03:15.631Z
9138666 9138666 20260103224005_xZXa6 UK00CH 2026-01-05T14:10:26.817Z 2026-01-12T15:02:56.496Z
9138606 9138606 20260103223419_00SCs UK00CH 2026-01-05T14:10:23.603Z 2026-01-12T15:02:54.002Z
9138472 9138472 20260103222717_mR6UV UK00CH 2026-01-05T14:09:57.961Z 2026-01-12T15:02:50.159Z
9138183 9138183 20260103220657_rX4bQ UK00CH 2026-01-05T14:09:29.462Z 2026-01-12T15:02:42.388Z
9138144 9138144 20260103220306_iyfKf UK00CH 2026-01-05T14:09:25.685Z 2026-01-12T15:02:41.044Z
9137382 9137382 20260103210839_eHHzp UK00CH 2026-01-05T14:08:24.057Z 2026-01-12T15:02:08.943Z
9137297 9137297 20260103210012_Dnmyo UK00CH 2026-01-05T14:08:17.661Z 2026-01-12T15:01:56.060Z
9137145 9137145 20260103204522_di0n8 UK00CH 2026-01-05T14:07:56.204Z 2026-01-12T15:01:49.888Z
9137055 9137055 20260103203544_s7gJW UK00CH 2026-01-05T14:07:47.358Z 2026-01-12T15:01:46.745Z
9136951 9136951 20260103202708_tYI94 UK00CH 2026-01-05T14:07:36.575Z 2026-01-12T15:01:44.097Z
9136935 9136935 20260103202637_WBUFQ UK00CH 2026-01-05T14:07:35.209Z 2026-01-12T15:01:43.585Z
9136884 9136884 20260103202320_FQd75 UK00CH 2026-01-05T14:07:25.235Z 2026-01-12T15:01:42.090Z

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