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

8,196 rows where station_code = "UK000P" 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
9255327 9255327 20260124025149_8aL0P UK000P 2026-01-25T14:12:55.404Z 2026-01-29T14:47:23.668Z
9231019 9231019 20260119054449_roLO1 UK000P 2026-01-20T14:30:55.917Z 2026-01-27T15:05:53.192Z
9230784 9230784 20260119050847_7730g UK000P 2026-01-20T14:29:44.894Z 2026-01-27T15:05:26.442Z
9230756 9230756 20260119050158_lLr0J UK000P 2026-01-20T14:29:37.118Z 2026-01-27T15:05:24.629Z
9230014 9230014 20260119030937_3R9YA UK000P 2026-01-20T14:25:27.871Z 2026-01-27T15:04:20.371Z
9229975 9229975 20260119030302_guO7y UK000P 2026-01-20T14:25:15.046Z 2026-01-27T15:04:17.729Z
9229906 9229906 20260119025517_yQhLa UK000P 2026-01-20T14:24:57.254Z 2026-01-27T15:04:14.389Z
9229873 9229873 20260119024652_2AlxF UK000P 2026-01-20T14:24:43.508Z 2026-01-27T15:04:12.117Z
9229513 9229513 20260119015612_tJf3A UK000P 2026-01-20T14:22:54.313Z 2026-01-27T15:03:39.748Z
9213202 9213202 20260116023358_oIXjG UK000P 2026-01-17T14:15:52.896Z 2026-01-24T15:11:48.886Z
9213099 9213099 20260116021208_qH32H UK000P 2026-01-17T14:15:26.196Z 2026-01-24T15:11:41.032Z
9212405 9212405 20260115210800_ajvoe UK000P 2026-01-17T14:11:39.603Z 2026-01-24T15:10:51.457Z
9212028 9212028 20260115184709_OPeFc UK000P 2026-01-17T14:09:33.959Z 2026-01-24T15:10:19.500Z
9211887 9211887 20260115181632_6MH39 UK000P 2026-01-17T14:08:56.087Z 2026-01-24T15:10:08.910Z
9211740 9211740 20260115173425_l6MMJ UK000P 2026-01-17T14:08:09.544Z 2026-01-24T15:09:50.310Z
9208696 9208696 20260115063259_93oNs UK000P 2026-01-16T14:13:42.384Z 2026-01-22T15:04:37.621Z
9208646 9208646 20260115062007_v8WvE UK000P 2026-01-16T14:13:29.765Z 2026-01-22T15:04:36.123Z
9208632 9208632 20260115061423_AX4X7 UK000P 2026-01-16T14:13:23.819Z 2026-01-22T15:04:35.568Z
9208528 9208528 20260115055427_O0KOg UK000P 2026-01-16T14:13:05.252Z 2026-01-22T15:04:32.869Z
9208432 9208432 20260115051953_bEi5x UK000P 2026-01-16T14:12:38.943Z 2026-01-22T15:04:13.575Z
9208420 9208420 20260115051848_2Thav UK000P 2026-01-16T14:12:36.612Z 2026-01-22T15:04:13.369Z
9208220 9208220 20260115043853_21ucW UK000P 2026-01-16T14:11:46.048Z 2026-01-22T15:04:04.718Z
9203859 9203859 20260114054519_EW2O6 UK000P 2026-01-15T14:25:42.344Z 2026-01-22T15:10:14.490Z
9203838 9203838 20260114054359_GkrKS UK000P 2026-01-15T14:25:39.908Z 2026-01-22T15:10:14.263Z
9202894 9202894 20260114041602_ecYDx UK000P 2026-01-15T14:22:43.906Z 2026-01-22T15:09:58.904Z
9202830 9202830 20260114041101_RoXSI UK000P 2026-01-15T14:22:28.951Z 2026-01-22T15:09:53.319Z
9202635 9202635 20260114035632_YfHQ2 UK000P 2026-01-15T14:21:53.255Z 2026-01-22T15:09:23.954Z
9200829 9200829 20260114010840_cMqfw UK000P 2026-01-15T14:16:36.859Z 2026-01-22T15:08:30.104Z
9200435 9200435 20260114001005_oBrBA UK000P 2026-01-15T14:15:13.008Z 2026-01-22T15:08:16.076Z
9200289 9200289 20260113233643_vJHVi UK000P 2026-01-15T14:14:38.233Z 2026-01-22T15:08:13.370Z
9200287 9200287 20260113233510_vVHi2 UK000P 2026-01-15T14:14:37.679Z 2026-01-22T15:08:13.314Z
9200280 9200280 20260113233329_IAXOK UK000P 2026-01-15T14:14:36.130Z 2026-01-22T15:08:13.145Z
9199916 9199916 20260113215531_fSZ9j UK000P 2026-01-15T14:13:03.073Z 2026-01-22T15:08:05.363Z
9199792 9199792 20260113211856_hWO4C UK000P 2026-01-15T14:12:31.344Z 2026-01-22T15:08:02.112Z
9199615 9199615 20260113203703_9KeQg UK000P 2026-01-15T14:11:41.181Z 2026-01-22T15:07:48.660Z
9198940 9198940 20260113183745_N2c4b UK000P 2026-01-15T14:08:27.111Z 2026-01-22T15:07:09.856Z
9176905 9176905 20260110063825_5FP3G UK000P 2026-01-11T14:10:19.180Z 2026-01-18T15:09:07.088Z
9176708 9176708 20260110061102_vHInd UK000P 2026-01-11T14:09:47.245Z 2026-01-18T15:08:51.448Z
9163499 9163499 20260107070328_wjqia UK000P 2026-01-08T14:09:20.111Z 2026-01-13T15:03:17.900Z
9163405 9163405 20260107063227_CzZIk UK000P 2026-01-08T14:09:03.879Z 2026-01-13T15:03:14.201Z
9163233 9163233 20260107061021_I41iz UK000P 2026-01-08T14:08:35.446Z 2026-01-13T15:03:06.820Z
9163142 9163142 20260107055400_6fqLy UK000P 2026-01-08T14:08:14.470Z 2026-01-13T15:03:02.953Z
9162957 9162957 20260107050956_EJLtN UK000P 2026-01-08T14:07:31.751Z 2026-01-13T15:02:48.887Z
9162817 9162817 20260107043936_7XdeJ UK000P 2026-01-08T14:06:59.542Z 2026-01-13T15:02:40.821Z
9162682 9162682 20260107040510_EPJsb UK000P 2026-01-08T14:06:26.287Z 2026-01-13T15:02:33.871Z
9162641 9162641 20260107035138_LZdNQ UK000P 2026-01-08T14:06:07.015Z 2026-01-13T15:02:30.648Z
9162624 9162624 20260107034848_EDxMi UK000P 2026-01-08T14:06:02.698Z 2026-01-13T15:02:28.842Z
9162547 9162547 20260107032411_0W2nD UK000P 2026-01-08T14:05:39.118Z 2026-01-13T15:02:17.840Z
9162363 9162363 20260107023222_8xsx8 UK000P 2026-01-08T14:04:47.023Z 2026-01-13T15:02:04.474Z
9162353 9162353 20260107022914_wpQoo UK000P 2026-01-08T14:04:44.647Z 2026-01-13T15:02:03.913Z
9162345 9162345 20260107021903_c1tf1 UK000P 2026-01-08T14:04:40.004Z 2026-01-13T15:02:03.303Z
9162336 9162336 20260107021241_Qh7pI UK000P 2026-01-08T14:04:37.701Z 2026-01-13T15:02:02.593Z
9162332 9162332 20260107021008_3uolk UK000P 2026-01-08T14:04:36.023Z 2026-01-13T15:02:02.203Z
9162229 9162229 20260107005650_VVxSV UK000P 2026-01-08T14:03:45.523Z 2026-01-13T15:01:47.900Z
9162212 9162212 20260107003947_3pQjO UK000P 2026-01-08T14:03:36.960Z 2026-01-13T15:01:46.248Z
9162120 9162120 20260106215627_Q7p3U UK000P 2026-01-08T14:03:03.323Z 2026-01-13T15:01:37.887Z
9162111 9162111 20260106213837_rGGuu UK000P 2026-01-08T14:03:00.872Z 2026-01-13T15:01:36.836Z
9162104 9162104 20260106212459_F8oI1 UK000P 2026-01-08T14:02:58.785Z 2026-01-13T15:01:36.279Z
9158353 9158353 20260105220011_ysJ4c UK000P 2026-01-07T14:05:48.649Z 2026-01-13T15:07:19.073Z
9158150 9158150 20260105203105_DAQAt UK000P 2026-01-07T14:05:03.326Z 2026-01-13T15:06:58.598Z
9158129 9158129 20260105201615_Ydl1J UK000P 2026-01-07T14:04:58.140Z 2026-01-13T15:06:56.905Z
9158025 9158025 20260105193936_R7h8K UK000P 2026-01-07T14:04:30.120Z 2026-01-13T15:06:49.825Z
9157762 9157762 20260105184440_1ZoZh UK000P 2026-01-07T14:03:29.956Z 2026-01-13T15:06:28.362Z
9157749 9157749 20260105184333_L9kkC UK000P 2026-01-07T14:03:25.481Z 2026-01-13T15:06:27.518Z
9156181 9156181 20260104071252_8lUnP UK000P 2026-01-06T14:38:44.527Z 2026-01-12T15:11:43.061Z
9156177 9156177 20260104071229_2OF9M UK000P 2026-01-06T14:38:44.227Z 2026-01-12T15:11:42.924Z
9156050 9156050 20260104064007_MWLlZ UK000P 2026-01-06T14:38:28.641Z 2026-01-12T15:11:35.936Z
9155927 9155927 20260104063134_q6D49 UK000P 2026-01-06T14:38:11.977Z 2026-01-12T15:11:32.447Z
9155591 9155591 20260104060708_qVVGY UK000P 2026-01-06T14:37:43.502Z 2026-01-12T15:11:20.656Z
9155569 9155569 20260104060558_sk4Xr UK000P 2026-01-06T14:37:42.303Z 2026-01-12T15:11:19.991Z
9155567 9155567 20260104060548_Pw5RA UK000P 2026-01-06T14:37:42.049Z 2026-01-12T15:11:19.789Z
9155559 9155559 20260104060422_MsWSq UK000P 2026-01-06T14:37:40.700Z 2026-01-12T15:11:07.433Z
9155144 9155144 20260104053736_wULCx UK000P 2026-01-06T14:36:51.317Z 2026-01-12T15:10:50.635Z
9154906 9154906 20260104052328_RKLp1 UK000P 2026-01-06T14:36:21.660Z 2026-01-12T15:10:26.157Z
9154723 9154723 20260104051121_F1Bms UK000P 2026-01-06T14:36:06.631Z 2026-01-12T15:10:17.792Z
9154631 9154631 20260104050443_7xm59 UK000P 2026-01-06T14:35:47.147Z 2026-01-12T15:10:12.875Z
9154543 9154543 20260104050144_tYPWT UK000P 2026-01-06T14:35:41.704Z 2026-01-12T15:10:09.491Z
9154510 9154510 20260104045946_4dZDU UK000P 2026-01-06T14:35:38.919Z 2026-01-12T15:10:08.311Z
9153844 9153844 20260104041704_uEGeg UK000P 2026-01-06T14:34:12.635Z 2026-01-12T15:09:08.734Z
9153746 9153746 20260104041154_sr36c UK000P 2026-01-06T14:33:56.021Z 2026-01-12T15:09:03.858Z
9153560 9153560 20260104040109_6ZpRQ UK000P 2026-01-06T14:33:39.546Z 2026-01-12T15:08:56.252Z
9153525 9153525 20260104040006_mwW6h UK000P 2026-01-06T14:33:28.878Z 2026-01-12T15:08:54.781Z
9153162 9153162 20260103231735_LaIsO UK000P 2026-01-06T14:24:49.506Z 2026-01-12T15:03:23.043Z
9151918 9151918 20260105071701_OMBzn UK000P 2026-01-06T14:15:09.233Z 2026-01-13T15:15:14.437Z
9151898 9151898 20260105070241_HK4c1 UK000P 2026-01-06T14:15:04.040Z 2026-01-13T15:15:11.919Z
9151860 9151860 20260105064459_wOLFK UK000P 2026-01-06T14:14:56.128Z 2026-01-13T15:15:09.736Z
9151824 9151824 20260105063759_IIqz3 UK000P 2026-01-06T14:14:49.960Z 2026-01-13T15:15:07.790Z
9151806 9151806 20260105063307_NpOpU UK000P 2026-01-06T14:14:46.074Z 2026-01-13T15:15:06.574Z
9151770 9151770 20260105063035_SMDvu UK000P 2026-01-06T14:14:37.988Z 2026-01-13T15:15:05.018Z
9151749 9151749 20260105062348_bkp5V UK000P 2026-01-06T14:14:32.549Z 2026-01-13T15:15:03.913Z
9151667 9151667 20260105061152_uBn6p UK000P 2026-01-06T14:14:21.036Z 2026-01-13T15:15:00.456Z
9151556 9151556 20260105055446_jcfOW UK000P 2026-01-06T14:14:01.880Z 2026-01-13T15:14:49.305Z
9151378 9151378 20260105052607_IOKUn UK000P 2026-01-06T14:13:32.408Z 2026-01-13T15:14:40.525Z
9150986 9150986 20260105041205_tZFre UK000P 2026-01-06T14:12:15.341Z 2026-01-13T15:14:12.564Z
9150971 9150971 20260105040933_DUHuO UK000P 2026-01-06T14:12:11.409Z 2026-01-13T15:14:11.580Z
9150938 9150938 20260105040216_oV8tW UK000P 2026-01-06T14:12:03.872Z 2026-01-13T15:14:09.603Z
9150933 9150933 20260105040215_br9iU UK000P 2026-01-06T14:12:01.708Z 2026-01-13T15:14:09.253Z
9150809 9150809 20260105033434_4wvrF UK000P 2026-01-06T14:11:30.360Z 2026-01-13T15:14:02.169Z
9150680 9150680 20260105030820_cFKHr UK000P 2026-01-06T14:10:57.351Z 2026-01-13T15:13:48.592Z
9150656 9150656 20260105030417_3rAPi UK000P 2026-01-06T14:10:53.696Z 2026-01-13T15:13:46.281Z

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