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,529 rows where station_code = "UK0089" 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
9273482 9273482 20260128062906_t2Ah6 UK0089 2026-01-29T14:29:56.245Z 2026-01-29T14:30:25.822Z
9273306 9273306 20260128053654_Z7VXr UK0089 2026-01-29T14:29:18.628Z 2026-01-29T14:30:25.785Z
9273159 9273159 20260128050029_YORwS UK0089 2026-01-29T14:28:52.753Z 2026-01-29T14:30:25.761Z
9273092 9273092 20260128044326_Ov4JN UK0089 2026-01-29T14:28:44.158Z 2026-01-29T14:30:25.748Z
9272822 9272822 20260128034222_0pT02 UK0089 2026-01-29T14:27:54.522Z 2026-01-29T14:30:25.577Z
9272576 9272576 20260128024006_2WYj3 UK0089 2026-01-29T14:27:11.422Z 2026-01-29T14:30:25.379Z
9272484 9272484 20260128021329_vLEln UK0089 2026-01-29T14:26:50.417Z 2026-01-29T14:30:25.354Z
9262758 9262758 20260126021537_mcaf1 UK0089 2026-01-27T14:15:08.965Z 2026-01-29T14:38:41.557Z
9262635 9262635 20260125221359_9UzQe UK0089 2026-01-27T14:14:31.720Z 2026-01-29T14:38:30.395Z
9262589 9262589 20260125203052_XZjIA UK0089 2026-01-27T14:13:53.620Z 2026-01-29T14:38:22.202Z
9262570 9262570 20260125201718_n3f8A UK0089 2026-01-27T14:13:38.139Z 2026-01-29T14:38:14.892Z
9262562 9262562 20260125201305_9YGDt UK0089 2026-01-27T14:13:36.204Z 2026-01-29T14:38:14.271Z
9262559 9262559 20260125201045_shG76 UK0089 2026-01-27T14:13:34.800Z 2026-01-29T14:38:13.970Z
9260676 9260676 20260125064234_MEoYn UK0089 2026-01-26T14:23:00.489Z 2026-01-29T14:44:35.051Z
9260670 9260670 20260125063852_8dWJe UK0089 2026-01-26T14:22:51.327Z 2026-01-29T14:44:34.599Z
9260596 9260596 20260125054559_bSX2V UK0089 2026-01-26T14:22:30.897Z 2026-01-29T14:44:29.673Z
9260557 9260557 20260125052752_7nruR UK0089 2026-01-26T14:22:23.474Z 2026-01-29T14:44:27.413Z
9260465 9260465 20260125043803_nR1uc UK0089 2026-01-26T14:21:54.416Z 2026-01-29T14:44:16.656Z
9260461 9260461 20260125043752_CGP5P UK0089 2026-01-26T14:21:53.986Z 2026-01-29T14:44:16.429Z
9260377 9260377 20260125040656_fYVvC UK0089 2026-01-26T14:21:27.528Z 2026-01-29T14:44:09.155Z
9260327 9260327 20260125034018_xZBp1 UK0089 2026-01-26T14:21:17.966Z 2026-01-29T14:44:05.865Z
9260183 9260183 20260125025908_3o1xR UK0089 2026-01-26T14:20:35.425Z 2026-01-29T14:43:53.818Z
9252705 9252705 20260123052832_h7NMQ UK0089 2026-01-24T14:16:52.036Z 2026-01-29T14:53:17.522Z
9252632 9252632 20260123045144_jp5Dl UK0089 2026-01-24T14:16:30.778Z 2026-01-29T14:53:12.741Z
9252481 9252481 20260123032715_q4b97 UK0089 2026-01-24T14:15:47.671Z 2026-01-29T14:53:03.216Z
9252384 9252384 20260123024350_ELPhi UK0089 2026-01-24T14:15:20.726Z 2026-01-29T14:52:48.239Z
9252370 9252370 20260123023336_HuOr3 UK0089 2026-01-24T14:15:16.605Z 2026-01-29T14:52:47.127Z
9252305 9252305 20260123020804_NDv3l UK0089 2026-01-24T14:15:00.429Z 2026-01-29T14:52:44.377Z
9252280 9252280 20260123020334_3vc0Y UK0089 2026-01-24T14:14:54.388Z 2026-01-29T14:52:43.327Z
9252073 9252073 20260123005151_bIOzL UK0089 2026-01-24T14:14:17.516Z 2026-01-29T14:52:27.290Z
9251958 9251958 20260123000706_2ix2C UK0089 2026-01-24T14:13:49.242Z 2026-01-29T14:52:18.820Z
9251914 9251914 20260122235937_KjQWt UK0089 2026-01-24T14:13:43.366Z 2026-01-29T14:52:17.067Z
9242008 9242008 20260121000033_aRHog UK0089 2026-01-22T14:15:50.597Z 2026-01-29T15:03:24.989Z
9241974 9241974 20260120234758_mwg2J UK0089 2026-01-22T14:15:37.224Z 2026-01-29T15:03:17.066Z
9237210 9237210 20260120045038_ykxiq UK0089 2026-01-21T14:25:41.609Z 2026-01-28T15:01:03.031Z
9237188 9237188 20260120044744_hM0fI UK0089 2026-01-21T14:25:30.134Z 2026-01-28T15:01:01.850Z
9237081 9237081 20260120043458_wRZSD UK0089 2026-01-21T14:25:14.769Z 2026-01-28T15:00:57.507Z
9236964 9236964 20260120042306_JknUO UK0089 2026-01-21T14:24:37.125Z 2026-01-28T15:00:51.123Z
9236092 9236092 20260120023348_yjijZ UK0089 2026-01-21T14:21:25.306Z 2026-01-28T14:59:44.411Z
9235146 9235146 20260120003645_SFfsY UK0089 2026-01-21T14:17:44.660Z 2026-01-28T14:58:32.902Z
9230321 9230321 20260119040036_0Ydky UK0089 2026-01-20T14:27:13.962Z 2026-01-27T15:04:48.535Z
9230294 9230294 20260119035340_jUjW1 UK0089 2026-01-20T14:27:05.936Z 2026-01-27T15:04:46.858Z
9230125 9230125 20260119033055_qtiww UK0089 2026-01-20T14:26:07.968Z 2026-01-27T15:04:28.802Z
9229849 9229849 20260119024430_c7FZu UK0089 2026-01-20T14:24:36.924Z 2026-01-27T15:04:00.670Z
9229098 9229098 20260119004810_3dczk UK0089 2026-01-20T14:21:02.263Z 2026-01-27T15:02:54.530Z
9228931 9228931 20260119002128_SB0Uq UK0089 2026-01-20T14:20:12.890Z 2026-01-27T15:02:43.711Z
9228881 9228881 20260119001253_Vx2bP UK0089 2026-01-20T14:19:55.770Z 2026-01-27T15:02:41.152Z
9228718 9228718 20260118234016_Ghzim UK0089 2026-01-20T14:19:12.183Z 2026-01-27T15:02:19.250Z
9228678 9228678 20260118232954_Wbm8w UK0089 2026-01-20T14:18:56.813Z 2026-01-27T15:02:16.701Z
9228636 9228636 20260118231957_A7Guh UK0089 2026-01-20T14:18:46.941Z 2026-01-27T15:02:12.460Z
9228585 9228585 20260118230219_MVec0 UK0089 2026-01-20T14:18:30.513Z 2026-01-27T15:02:09.307Z
9228422 9228422 20260118221446_En12N UK0089 2026-01-20T14:17:43.919Z 2026-01-27T15:02:00.226Z
9228398 9228398 20260118220935_fwS2q UK0089 2026-01-20T14:17:36.186Z 2026-01-27T15:01:58.893Z
9228371 9228371 20260118215722_xbgTd UK0089 2026-01-20T14:17:27.982Z 2026-01-27T15:01:56.979Z
9228035 9228035 20260118192034_WXIoq UK0089 2026-01-20T14:15:39.710Z 2026-01-27T15:01:22.004Z
9224537 9224537 20260118050941_qIbJ6 UK0089 2026-01-19T14:24:48.083Z 2026-01-26T15:03:23.044Z
9224009 9224009 20260118030805_9rTkI UK0089 2026-01-19T14:22:23.430Z 2026-01-26T15:02:47.823Z
9223949 9223949 20260118025851_wJT0h UK0089 2026-01-19T14:21:58.892Z 2026-01-26T15:02:43.712Z
9223943 9223943 20260118025807_ZJQGM UK0089 2026-01-19T14:21:56.937Z 2026-01-26T15:02:43.018Z
9223938 9223938 20260118025712_lbmiu UK0089 2026-01-19T14:21:55.928Z 2026-01-26T15:02:42.358Z
9223837 9223837 20260118023130_zwuYm UK0089 2026-01-19T14:21:21.659Z 2026-01-26T15:02:38.111Z
9223782 9223782 20260118022431_rS218 UK0089 2026-01-19T14:21:09.160Z 2026-01-26T15:02:35.884Z
9223779 9223779 20260118022405_hWG5F UK0089 2026-01-19T14:21:08.129Z 2026-01-26T15:02:35.767Z
9223670 9223670 20260118015928_RT3VL UK0089 2026-01-19T14:20:34.729Z 2026-01-26T15:02:31.596Z
9223650 9223650 20260118015551_JLfkf UK0089 2026-01-19T14:20:30.319Z 2026-01-26T15:02:30.794Z
9223607 9223607 20260118014220_7DAaB UK0089 2026-01-19T14:20:10.164Z 2026-01-26T15:02:29.212Z
9223587 9223587 20260118013349_q1eNZ UK0089 2026-01-19T14:20:04.562Z 2026-01-26T15:02:26.828Z
9223582 9223582 20260118013131_bINK3 UK0089 2026-01-19T14:20:03.302Z 2026-01-26T15:02:21.928Z
9223453 9223453 20260118004857_8Sjyk UK0089 2026-01-19T14:19:24.466Z 2026-01-26T15:02:07.485Z
9223360 9223360 20260118002417_tFbfU UK0089 2026-01-19T14:18:54.264Z 2026-01-26T15:02:03.828Z
9223266 9223266 20260118000253_UO2fz UK0089 2026-01-19T14:18:27.096Z 2026-01-26T15:02:00.351Z
9222855 9222855 20260117210603_IMVZ5 UK0089 2026-01-19T14:16:35.463Z 2026-01-26T15:01:23.538Z
9222795 9222795 20260117205259_Ie2LU UK0089 2026-01-19T14:16:16.606Z 2026-01-26T15:01:21.295Z
9222773 9222773 20260117204727_fJ13T UK0089 2026-01-19T14:16:10.862Z 2026-01-26T15:01:20.322Z
9222682 9222682 20260117201902_iUEj5 UK0089 2026-01-19T14:15:48.359Z 2026-01-26T15:01:17.150Z
9222099 9222099 20260117180710_clwpe UK0089 2026-01-19T14:13:17.536Z 2026-01-26T15:00:38.183Z
9219020 9219020 20260117070452_gQtha UK0089 2026-01-18T14:14:37.095Z 2026-01-25T14:58:58.582Z
9218940 9218940 20260117063916_vAWyx UK0089 2026-01-18T14:14:19.195Z 2026-01-25T14:58:56.242Z
9218887 9218887 20260117062154_j6OE9 UK0089 2026-01-18T14:14:05.723Z 2026-01-25T14:58:54.660Z
9218871 9218871 20260117061520_YWbOI UK0089 2026-01-18T14:14:02.660Z 2026-01-25T14:58:54.292Z
9218841 9218841 20260117060536_ZcY2S UK0089 2026-01-18T14:13:55.057Z 2026-01-25T14:58:52.978Z
9218836 9218836 20260117060420_IDJdv UK0089 2026-01-18T14:13:54.448Z 2026-01-25T14:58:52.875Z
9218791 9218791 20260117054845_EmbUq UK0089 2026-01-18T14:13:42.077Z 2026-01-25T14:58:51.377Z
9218644 9218644 20260117050249_LjOVR UK0089 2026-01-18T14:13:02.138Z 2026-01-25T14:58:33.977Z
9218634 9218634 20260117050108_a0eK3 UK0089 2026-01-18T14:13:00.165Z 2026-01-25T14:58:33.733Z
9218366 9218366 20260117031901_uFZgq UK0089 2026-01-18T14:11:49.227Z 2026-01-25T14:58:23.526Z
9218338 9218338 20260117030835_5yRIx UK0089 2026-01-18T14:11:42.301Z 2026-01-25T14:58:22.275Z
9218269 9218269 20260117021513_NqkiO UK0089 2026-01-18T14:11:20.964Z 2026-01-25T14:58:19.262Z
9218185 9218185 20260117013640_lH3y8 UK0089 2026-01-18T14:10:54.664Z 2026-01-25T14:58:03.541Z
9218157 9218157 20260117011455_0lzHL UK0089 2026-01-18T14:10:46.127Z 2026-01-25T14:58:02.380Z
9218153 9218153 20260117010618_ltfAG UK0089 2026-01-18T14:10:45.462Z 2026-01-25T14:58:02.278Z
9218065 9218065 20260116232656_dIsRP UK0089 2026-01-18T14:10:16.550Z 2026-01-25T14:57:57.292Z
9217985 9217985 20260116212442_wBQJL UK0089 2026-01-18T14:09:51.819Z 2026-01-25T14:57:54.067Z
9217944 9217944 20260116205316_zsdcb UK0089 2026-01-18T14:09:41.962Z 2026-01-25T14:57:52.795Z
9217758 9217758 20260116193347_i9gmG UK0089 2026-01-18T14:08:51.013Z 2026-01-25T14:57:46.664Z
9217726 9217726 20260116192423_NyB3G UK0089 2026-01-18T14:08:43.692Z 2026-01-25T14:57:45.968Z
9217665 9217665 20260116185700_XQ76p UK0089 2026-01-18T14:08:27.035Z 2026-01-25T14:57:38.211Z
9214458 9214458 20260116063849_jnD2Z UK0089 2026-01-17T14:21:36.992Z 2026-01-24T15:13:38.372Z
9214170 9214170 20260116054845_8e0eK UK0089 2026-01-17T14:20:26.257Z 2026-01-24T15:13:19.618Z
9214164 9214164 20260116054827_mQW5k UK0089 2026-01-17T14:20:24.989Z 2026-01-24T15:13:19.048Z

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