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,119 rows where station_code = "UK009F" 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
9623871 9623871 20260407033721_kRkS6 UK009F 2026-04-08T12:24:45.008Z 2026-04-08T12:24:45.008Z
9623431 9623431 20260407030312_bYTNL UK009F 2026-04-08T12:23:34.800Z 2026-04-08T12:23:34.800Z
9623078 9623078 20260407023504_cmLEQ UK009F 2026-04-08T12:22:44.736Z 2026-04-08T12:22:44.736Z
9622999 9622999 20260407022939_J9pjt UK009F 2026-04-08T12:22:34.171Z 2026-04-08T12:22:34.171Z
9622236 9622236 20260407013051_sX5UG UK009F 2026-04-08T12:20:22.006Z 2026-04-08T12:20:22.006Z
9621722 9621722 20260407004855_62dM9 UK009F 2026-04-08T12:18:57.296Z 2026-04-08T12:18:57.296Z
9620282 9620282 20260406231848_FXpmI UK009F 2026-04-08T12:15:26.328Z 2026-04-08T12:15:26.328Z
9614856 9614856 20260406000118_Q9A37 UK009F 2026-04-07T12:09:29.965Z 2026-04-08T12:28:09.456Z
9614222 9614222 20260405223429_nFHFM UK009F 2026-04-07T12:08:15.056Z 2026-04-08T12:27:37.300Z
9595467 9595467 20260330041205_77e18 UK009F 2026-03-31T12:01:29.920Z 2026-04-08T12:42:03.678Z
9595254 9595254 20260330030912_MnFO7 UK009F 2026-03-31T12:00:54.307Z 2026-04-08T12:41:51.963Z
9595183 9595183 20260330025707_LcenR UK009F 2026-03-31T12:00:44.552Z 2026-04-08T12:41:48.267Z
9595175 9595175 20260330024858_vrv8C UK009F 2026-03-31T12:00:42.304Z 2026-04-08T12:41:47.826Z
9595113 9595113 20260330023008_Q7ibo UK009F 2026-03-31T12:00:31.109Z 2026-04-08T12:41:46.041Z
9591903 9591903 20260327230159_i4EvO UK009F 2026-03-29T12:06:57.591Z 2026-04-05T12:35:19.181Z
9591757 9591757 20260327202840_f0Yxt UK009F 2026-03-29T12:06:41.756Z 2026-04-05T12:35:12.310Z
9585225 9585225 20260325234325_YTqZH UK009F 2026-03-27T12:16:55.751Z 2026-04-03T12:39:51.797Z
9585159 9585159 20260325233732_hwQIb UK009F 2026-03-27T12:16:52.516Z 2026-04-03T12:39:50.867Z
9581874 9581874 20260326040630_oEqkr UK009F 2026-03-27T12:04:01.943Z 2026-04-04T12:39:24.005Z
9581505 9581505 20260326032040_4NeEr UK009F 2026-03-27T12:03:18.564Z 2026-04-04T12:39:09.099Z
9580893 9580893 20260326015130_22OtC UK009F 2026-03-27T12:01:39.081Z 2026-04-04T12:38:32.948Z
9576540 9576540 20260325022932_bsnBz UK009F 2026-03-26T12:02:33.879Z 2026-04-03T12:36:11.838Z
9576512 9576512 20260325022500_jnzIv UK009F 2026-03-26T12:02:29.931Z 2026-04-03T12:36:10.985Z
9575531 9575531 20260323230307_r8giH UK009F 2026-03-25T12:21:21.269Z 2026-03-31T12:29:01.326Z
9571748 9571748 20260324035316_73qDd UK009F 2026-03-25T12:02:33.407Z 2026-04-02T12:34:42.338Z
9571631 9571631 20260324031831_AbkW3 UK009F 2026-03-25T12:02:09.864Z 2026-04-02T12:34:35.563Z
9571469 9571469 20260324022722_F4vS5 UK009F 2026-03-25T12:01:36.882Z 2026-04-02T12:34:28.166Z
9562969 9562969 20260323041514_jQib6 UK009F 2026-03-24T12:04:36.136Z 2026-03-31T12:26:31.057Z
9541781 9541781 20260319214309_4OGP4 UK009F 2026-03-21T12:29:21.505Z 2026-03-27T12:42:41.653Z
9541705 9541705 20260319213122_MexhI UK009F 2026-03-21T12:29:17.644Z 2026-03-27T12:42:40.981Z
9541653 9541653 20260319211815_aZWfG UK009F 2026-03-21T12:29:14.755Z 2026-03-27T12:42:40.523Z
9541415 9541415 20260319203233_xl7vX UK009F 2026-03-21T12:28:54.977Z 2026-03-27T12:42:37.367Z
9534772 9534772 20260320041946_zwxxB UK009F 2026-03-21T12:08:50.129Z 2026-03-28T12:34:21.854Z
9534757 9534757 20260320041833_xNReX UK009F 2026-03-21T12:08:48.384Z 2026-03-28T12:34:21.696Z
9534624 9534624 20260320040605_2K3zM UK009F 2026-03-21T12:08:29.645Z 2026-03-28T12:34:20.248Z
9534148 9534148 20260320033042_b3MPl UK009F 2026-03-21T12:07:16.088Z 2026-03-28T12:34:14.843Z
9533665 9533665 20260320025005_TTN35 UK009F 2026-03-21T12:05:59.518Z 2026-03-28T12:33:58.091Z
9533507 9533507 20260320023512_1Q5CV UK009F 2026-03-21T12:05:32.782Z 2026-03-28T12:33:53.858Z
9533168 9533168 20260320020617_qor0u UK009F 2026-03-21T12:04:38.674Z 2026-03-28T12:33:49.549Z
9532061 9532061 20260320001507_LwMF4 UK009F 2026-03-21T12:01:36.727Z 2026-03-28T12:33:24.370Z
9531883 9531883 20260319235909_e5MUT UK009F 2026-03-21T12:01:08.066Z 2026-03-28T12:33:22.521Z
9531740 9531740 20260319234258_o2fpR UK009F 2026-03-21T12:00:43.566Z 2026-03-28T12:33:21.033Z
9521470 9521470 20260319041840_sGfvm UK009F 2026-03-20T12:08:03.204Z 2026-03-27T12:40:54.991Z
9520882 9520882 20260319034340_ropIf UK009F 2026-03-20T12:07:11.178Z 2026-03-27T12:40:48.589Z
9512080 9512080 20260318044100_2U9VX UK009F 2026-03-19T12:11:40.069Z 2026-03-26T12:37:42.160Z
9511598 9511598 20260318040333_eRb16 UK009F 2026-03-19T12:10:33.569Z 2026-03-26T12:37:38.162Z
9511376 9511376 20260318034817_4w3l3 UK009F 2026-03-19T12:10:03.898Z 2026-03-26T12:37:36.423Z
9511225 9511225 20260318034058_A3Tu6 UK009F 2026-03-19T12:09:43.592Z 2026-03-26T12:37:30.340Z
9510903 9510903 20260318032238_m7nY3 UK009F 2026-03-19T12:08:56.654Z 2026-03-26T12:37:17.650Z
9508478 9508478 20260318005818_wk0Oe UK009F 2026-03-19T12:03:12.362Z 2026-03-26T12:36:58.870Z
9508468 9508468 20260318005759_tAylV UK009F 2026-03-19T12:03:10.672Z 2026-03-26T12:36:58.733Z
9507919 9507919 20260317235628_0YyQ2 UK009F 2026-03-19T12:01:43.290Z 2026-03-26T12:36:54.529Z
9501131 9501131 20260315210905_3x1PU UK009F 2026-03-17T12:24:29.890Z 2026-03-23T12:22:43.242Z
9477443 9477443 20260314045721_fKsgr UK009F 2026-03-15T12:08:18.796Z 2026-03-22T12:42:02.810Z
9476889 9476889 20260314035335_Hn3qc UK009F 2026-03-15T12:07:09.707Z 2026-03-22T12:41:59.980Z
9475630 9475630 20260314015003_uHaYa UK009F 2026-03-15T12:03:39.618Z 2026-03-22T12:41:46.227Z
9474174 9474174 20260312212239_VlAx4 UK009F 2026-03-14T12:22:16.001Z 2026-03-20T12:37:16.572Z
9474050 9474050 20260312195530_inr2M UK009F 2026-03-14T12:21:51.638Z 2026-03-20T12:37:15.235Z
9474025 9474025 20260312193107_pzVKD UK009F 2026-03-14T12:21:45.876Z 2026-03-20T12:37:14.789Z
9469752 9469752 20260313033918_TLUSv UK009F 2026-03-14T12:05:24.559Z 2026-03-21T12:49:01.874Z
9469466 9469466 20260313025434_U5kYk UK009F 2026-03-14T12:04:21.578Z 2026-03-21T12:48:39.944Z
9469094 9469094 20260313014825_hZlKq UK009F 2026-03-14T12:02:58.140Z 2026-03-21T12:48:33.532Z
9468997 9468997 20260313012848_nIfBX UK009F 2026-03-14T12:02:36.885Z 2026-03-21T12:48:32.409Z
9468568 9468568 20260312233624_HKdBX UK009F 2026-03-14T12:00:45.817Z 2026-03-21T12:48:26.583Z
9457754 9457754 20260311051101_6Cxbi UK009F 2026-03-12T12:04:29.336Z 2026-03-19T12:44:51.674Z
9457526 9457526 20260311040943_XXZgm UK009F 2026-03-12T12:03:59.538Z 2026-03-19T12:44:46.043Z
9457329 9457329 20260311033518_E99ld UK009F 2026-03-12T12:03:35.132Z 2026-03-19T12:44:39.271Z
9446818 9446818 20260309030807_nOXI9 UK009F 2026-03-10T12:04:03.286Z 2026-03-17T12:41:43.329Z
9446549 9446549 20260309020933_rk7Lu UK009F 2026-03-10T12:02:52.350Z 2026-03-17T12:41:39.489Z
9446511 9446511 20260309015540_wur5M UK009F 2026-03-10T12:02:44.606Z 2026-03-17T12:41:39.221Z
9445779 9445779 20260307214437_Jghef UK009F 2026-03-09T12:20:46.785Z 2026-03-15T12:42:14.277Z
9442714 9442714 20260308051933_T3TtR UK009F 2026-03-09T12:05:12.432Z 2026-03-16T12:43:55.498Z
9442604 9442604 20260308043132_qblUy UK009F 2026-03-09T12:04:42.866Z 2026-03-16T12:43:54.062Z
9442526 9442526 20260308040926_FuVbh UK009F 2026-03-09T12:04:23.420Z 2026-03-16T12:43:52.837Z
9441744 9441744 20260307232559_0VrDj UK009F 2026-03-09T12:00:58.981Z 2026-03-16T12:43:30.450Z
9441508 9441508 20260306221826_61dr9 UK009F 2026-03-08T12:22:10.803Z 2026-03-14T12:40:53.157Z
9441377 9441377 20260306212410_Dbmia UK009F 2026-03-08T12:21:38.818Z 2026-03-14T12:40:51.528Z
9441174 9441174 20260306201649_TXdBt UK009F 2026-03-08T12:20:41.496Z 2026-03-14T12:40:46.365Z
9437634 9437634 20260307053111_ifh3X UK009F 2026-03-08T12:04:48.745Z 2026-03-15T12:41:23.949Z
9437528 9437528 20260307042938_1QFQQ UK009F 2026-03-08T12:04:24.414Z 2026-03-15T12:41:08.789Z
9437254 9437254 20260307024642_nc7Te UK009F 2026-03-08T12:03:13.637Z 2026-03-15T12:41:05.171Z
9437227 9437227 20260307024055_LXUg9 UK009F 2026-03-08T12:03:07.047Z 2026-03-15T12:41:04.855Z
9437208 9437208 20260307023143_wj5gs UK009F 2026-03-08T12:03:01.425Z 2026-03-15T12:41:04.436Z
9437171 9437171 20260307022347_v1y4q UK009F 2026-03-08T12:02:53.625Z 2026-03-15T12:41:03.194Z
9436790 9436790 20260306235431_SPUxt UK009F 2026-03-08T12:01:16.036Z 2026-03-15T12:40:57.777Z
9436754 9436754 20260306234141_Qygag UK009F 2026-03-08T12:01:05.490Z 2026-03-15T12:40:57.268Z
9436748 9436748 20260306233838_uSLSe UK009F 2026-03-08T12:01:03.800Z 2026-03-15T12:40:57.168Z
9436730 9436730 20260306233653_31ZVf UK009F 2026-03-08T12:01:01.230Z 2026-03-15T12:40:57.044Z
9436655 9436655 20260306231354_Rr3r5 UK009F 2026-03-08T12:00:36.708Z 2026-03-15T12:40:55.911Z
9436601 9436601 20260306224954_Dtl0N UK009F 2026-03-08T12:00:18.732Z 2026-03-15T12:40:55.223Z
9432156 9432156 20260306034730_b2xX2 UK009F 2026-03-07T14:03:40.707Z 2026-03-14T12:39:25.912Z
9430770 9430770 20260304205254_cDYn7 UK009F 2026-03-06T14:24:18.279Z 2026-03-12T12:33:41.717Z
9426228 9426228 20260305024529_sNvcH UK009F 2026-03-06T14:03:50.131Z 2026-03-13T12:34:43.793Z
9422951 9422951 20260304051338_l3ZBF UK009F 2026-03-05T14:03:19.399Z 2026-03-12T12:32:49.244Z
9422936 9422936 20260304050119_bE8mU UK009F 2026-03-05T14:03:14.226Z 2026-03-12T12:32:48.747Z
9422902 9422902 20260304045344_q4JgM UK009F 2026-03-05T14:03:05.355Z 2026-03-12T12:32:48.210Z
9422672 9422672 20260304032754_Ut3SW UK009F 2026-03-05T14:02:10.635Z 2026-03-12T12:32:33.669Z
9419389 9419389 20260303032218_gRP0x UK009F 2026-03-04T14:01:20.061Z 2026-03-11T12:27:59.622Z
9415331 9415331 20260228221019_OXv8I UK009F 2026-03-02T14:07:44.558Z 2026-03-08T12:43:10.372Z
9415304 9415304 20260228214242_FR12o UK009F 2026-03-02T14:07:42.172Z 2026-03-08T12:43:09.142Z

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