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

919 rows where station_code = "UK0039" 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
9271973 9271973 20260127224305_lyPpi UK0039 2026-01-29T14:25:12.021Z 2026-01-29T14:30:25.257Z
9254863 9254863 20260123220918_ihy0m UK0039 2026-01-25T14:10:57.965Z 2026-01-29T14:46:52.807Z
9251937 9251937 20260123000248_tJk9D UK0039 2026-01-24T14:13:45.958Z 2026-01-29T14:52:17.822Z
9251737 9251737 20260122222033_Ed660 UK0039 2026-01-24T14:13:03.532Z 2026-01-29T14:52:06.983Z
9243147 9243147 20260121034910_nOcg3 UK0039 2026-01-22T14:20:47.094Z 2026-01-29T15:04:48.335Z
9212643 9212643 20260116000305_W8PyU UK0039 2026-01-17T14:13:06.158Z 2026-01-24T15:11:08.380Z
9207631 9207631 20260115023242_TszoG UK0039 2026-01-16T14:09:27.904Z 2026-01-22T15:03:28.503Z
9194430 9194430 20260112204300_Oj1Ws UK0039 2026-01-14T14:09:11.529Z 2026-01-21T15:04:01.235Z
9181924 9181924 20260111034318_gH098 UK0039 2026-01-12T14:12:36.377Z 2026-01-19T15:17:54.381Z
9181879 9181879 20260111033550_xuibb UK0039 2026-01-12T14:12:27.917Z 2026-01-19T15:17:52.151Z
9149181 9149181 20260104191543_5i71I UK0039 2026-01-06T14:04:11.952Z 2026-01-13T15:11:47.108Z
9148324 9148324 20260103173927_UQsYA UK0039 2026-01-05T14:30:24.387Z 2026-01-10T15:04:25.653Z
9147631 9147631 20260104062025_cI21q UK0039 2026-01-05T14:24:38.914Z 2026-01-12T15:11:26.880Z
9147367 9147367 20260104054046_2PF8n UK0039 2026-01-05T14:24:06.375Z 2026-01-12T15:10:51.918Z
9147258 9147258 20260104052453_GF1dq UK0039 2026-01-05T14:23:57.805Z 2026-01-12T15:10:26.852Z
9147245 9147245 20260104052244_m602K UK0039 2026-01-05T14:23:56.344Z 2026-01-12T15:10:25.804Z
9146788 9146788 20260104042712_rk3PB UK0039 2026-01-05T14:22:50.363Z 2026-01-12T15:09:29.796Z
9146688 9146688 20260104041513_7Fybu UK0039 2026-01-05T14:22:41.896Z 2026-01-12T15:09:06.445Z
9146659 9146659 20260104041239_xCcF3 UK0039 2026-01-05T14:22:40.222Z 2026-01-12T15:09:04.490Z
9146582 9146582 20260104040315_kNe01 UK0039 2026-01-05T14:22:32.661Z 2026-01-12T15:08:57.340Z
9136604 9136604 20260103200734_HBY36 UK0039 2026-01-05T14:07:02.858Z 2026-01-12T15:01:24.367Z
9136550 9136550 20260103200212_yeWGD UK0039 2026-01-05T14:06:55.338Z 2026-01-12T15:01:22.806Z
9136429 9136429 20260103195355_bZvzx UK0039 2026-01-05T14:06:39.686Z 2026-01-12T15:01:17.103Z
9136305 9136305 20260103194559_YbsNO UK0039 2026-01-05T14:06:32.383Z 2026-01-12T15:01:14.319Z
9135337 9135337 20260103185245_3Ja2C UK0039 2026-01-05T14:04:20.630Z 2026-01-12T15:00:27.137Z
9131898 9131898 20260103060455_Ml6xn UK0039 2026-01-04T14:15:13.625Z 2026-01-10T15:01:00.597Z
9131823 9131823 20260103055913_E6Cle UK0039 2026-01-04T14:15:00.106Z 2026-01-10T15:00:55.704Z
9131793 9131793 20260103055620_N1jY1 UK0039 2026-01-04T14:14:57.146Z 2026-01-10T15:00:53.982Z
9131629 9131629 20260103054019_vAHYg UK0039 2026-01-04T14:14:30.248Z 2026-01-10T15:00:44.740Z
9131126 9131126 20260103045128_A67tx UK0039 2026-01-04T14:12:44.242Z 2026-01-10T15:00:01.859Z
9130618 9130618 20260103034932_U6Us7 UK0039 2026-01-04T14:10:59.710Z 2026-01-10T14:59:26.253Z
9130590 9130590 20260103034504_2j8aD UK0039 2026-01-04T14:10:51.649Z 2026-01-10T14:59:24.613Z
9111290 9111290 20251231010002_RisJ7 UK0039 2026-01-01T14:10:53.454Z 2026-01-08T15:06:27.746Z
9110364 9110364 20251230225731_r93cs UK0039 2026-01-01T14:06:59.107Z 2026-01-08T15:05:20.255Z
9104576 9104576 20251230060954_ah3PE UK0039 2025-12-31T14:21:41.717Z 2026-01-07T15:09:48.578Z
9057490 9057490 20251227050452_fBRiz UK0039 2025-12-29T14:23:05.402Z 2026-01-04T15:29:47.461Z
9056934 9056934 20251227043950_bocXk UK0039 2025-12-29T14:21:57.529Z 2026-01-04T15:29:17.159Z
9043357 9043357 20251224201856_5bAmY UK0039 2025-12-28T14:47:28.110Z 2026-01-01T15:57:18.029Z
9030387 9030387 20251225044224_hEF5b UK0039 2025-12-28T14:18:46.800Z 2026-01-02T15:44:54.485Z
9027271 9027271 20251225021058_RomHq UK0039 2025-12-28T14:10:38.358Z 2026-01-02T15:43:30.776Z
8904473 8904473 20251214051838_ph36p UK0039 2025-12-23T14:07:23.095Z 2025-12-24T14:20:27.705Z
8900114 8900114 20251214043222_FNsvE UK0039 2025-12-23T14:04:45.663Z 2025-12-24T14:17:57.887Z
8899945 8899945 20251214042947_HgUvV UK0039 2025-12-23T14:04:37.710Z 2025-12-24T14:17:53.977Z
8899419 8899419 20251214042453_DDvWz UK0039 2025-12-23T14:04:10.414Z 2025-12-24T14:17:45.345Z
8899339 8899339 20251214042431_Lj6rl UK0039 2025-12-23T14:04:09.349Z 2025-12-24T14:17:43.394Z
8899041 8899041 20251214042130_0Nve3 UK0039 2025-12-23T14:04:04.559Z 2025-12-24T14:17:34.760Z
8899023 8899023 20251214042117_OG9X9 UK0039 2025-12-23T14:04:04.457Z 2025-12-24T14:17:33.899Z
8898943 8898943 20251214042013_BnmyU UK0039 2025-12-23T14:04:03.869Z 2025-12-24T14:17:26.343Z
8898892 8898892 20251214041946_JbeWL UK0039 2025-12-23T14:04:03.589Z 2025-12-24T14:17:25.493Z
8898769 8898769 20251214041837_Y4o9T UK0039 2025-12-23T14:04:02.708Z 2025-12-24T14:17:13.553Z
8898627 8898627 20251214041657_2qM45 UK0039 2025-12-23T14:04:01.883Z 2025-12-24T14:17:07.374Z
8898143 8898143 20251214041330_2ZoIj UK0039 2025-12-23T14:03:58.057Z 2025-12-24T14:16:58.946Z
8898133 8898133 20251214041330_K4u6H UK0039 2025-12-23T14:03:57.996Z 2025-12-24T14:16:58.887Z
8897132 8897132 20251214024611_UJO6v UK0039 2025-12-22T14:12:21.077Z 2025-12-23T14:27:57.230Z
8896796 8896796 20251214024401_e45hu UK0039 2025-12-22T14:12:19.393Z 2025-12-23T14:27:55.725Z
8896416 8896416 20251214024106_1u1ct UK0039 2025-12-22T14:12:16.534Z 2025-12-23T14:27:55.261Z
8896189 8896189 20251214023842_wnHKV UK0039 2025-12-22T14:12:14.939Z 2025-12-23T14:27:55.011Z
8894233 8894233 20251214022235_YxwRp UK0039 2025-12-22T14:12:01.994Z 2025-12-23T14:27:52.440Z
8893865 8893865 20251214021915_bJd2p UK0039 2025-12-22T14:11:59.875Z 2025-12-23T14:27:51.949Z
8893458 8893458 20251214021617_DEW4t UK0039 2025-12-22T14:11:56.989Z 2025-12-23T14:27:50.161Z
8893040 8893040 20251214021307_c32Pz UK0039 2025-12-22T14:11:53.058Z 2025-12-23T14:27:49.029Z
8892756 8892756 20251214021112_ZqEEl UK0039 2025-12-22T14:11:52.181Z 2025-12-23T14:27:48.705Z
8892595 8892595 20251214020950_I07y3 UK0039 2025-12-22T14:11:51.715Z 2025-12-23T14:27:48.428Z
8892439 8892439 20251214020832_MzYkI UK0039 2025-12-22T14:11:50.931Z 2025-12-23T14:27:48.208Z
8892202 8892202 20251214020648_nXM7t UK0039 2025-12-22T14:11:49.738Z 2025-12-23T14:27:47.881Z
8891566 8891566 20251214020218_MCmV4 UK0039 2025-12-22T14:11:45.777Z 2025-12-23T14:27:46.921Z
8890562 8890562 20251214015414_JLkW5 UK0039 2025-12-22T14:11:41.980Z 2025-12-23T14:27:45.665Z
8889583 8889583 20251214014604_mMW2n UK0039 2025-12-22T14:11:37.715Z 2025-12-23T14:27:43.962Z
8889482 8889482 20251214014512_F6PmA UK0039 2025-12-22T14:11:37.188Z 2025-12-23T14:27:43.790Z
8888979 8888979 20251214014101_62yhl UK0039 2025-12-22T14:11:34.777Z 2025-12-23T14:27:42.758Z
8887201 8887201 20251214012639_k5wBw UK0039 2025-12-22T14:11:23.944Z 2025-12-23T14:27:39.980Z
8886319 8886319 20251214011923_4HTzu UK0039 2025-12-22T14:11:16.928Z 2025-12-23T14:27:38.577Z
8885981 8885981 20251214011649_p0dvG UK0039 2025-12-22T14:11:14.362Z 2025-12-23T14:27:38.117Z
8885493 8885493 20251214011315_yKBqz UK0039 2025-12-22T14:11:10.359Z 2025-12-23T14:27:37.458Z
8884937 8884937 20251214040727_D2yc3 UK0039 2025-12-22T14:03:27.876Z 2025-12-24T14:16:48.203Z
8884366 8884366 20251214040335_LfQTW UK0039 2025-12-22T14:03:24.258Z 2025-12-24T14:16:18.646Z
8883930 8883930 20251214035957_VCTXS UK0039 2025-12-22T14:03:21.710Z 2025-12-24T14:16:13.164Z
8881699 8881699 20251214034246_ZgYYK UK0039 2025-12-22T14:02:49.220Z 2025-12-24T14:15:22.647Z
8880787 8880787 20251214033658_29F2P UK0039 2025-12-22T14:02:25.622Z 2025-12-24T14:14:55.387Z
8880725 8880725 20251214033637_sfcN7 UK0039 2025-12-22T14:02:23.483Z 2025-12-24T14:14:53.879Z
8880400 8880400 20251214033419_mbXNu UK0039 2025-12-22T14:02:17.426Z 2025-12-24T14:14:47.488Z
8878732 8878732 20251214032224_tDkws UK0039 2025-12-22T14:01:57.804Z 2025-12-24T14:14:06.667Z
8878567 8878567 20251214032111_uV1XE UK0039 2025-12-22T14:01:56.378Z 2025-12-24T14:13:58.571Z
8878383 8878383 20251214032010_iBlQp UK0039 2025-12-22T14:01:54.236Z 2025-12-24T14:13:48.957Z
8876344 8876344 20251214030643_7EBle UK0039 2025-12-22T14:00:47.805Z 2025-12-24T14:12:58.685Z
8876312 8876312 20251214030630_K6jmi UK0039 2025-12-22T14:00:47.592Z 2025-12-24T14:12:58.123Z
8876098 8876098 20251214030515_3hY38 UK0039 2025-12-22T14:00:45.573Z 2025-12-24T14:12:53.318Z
8875485 8875485 20251214030129_VVz1D UK0039 2025-12-22T14:00:32.825Z 2025-12-24T14:12:44.467Z
8875068 8875068 20251214025849_M50Vy UK0039 2025-12-22T14:00:17.870Z 2025-12-24T14:12:38.436Z
8874467 8874467 20251214011250_p7Ysc UK0039 2025-12-21T14:11:10.992Z 2025-12-23T14:27:37.360Z
8874417 8874417 20251214011226_TMnM6 UK0039 2025-12-21T14:11:10.702Z 2025-12-23T14:27:37.296Z
8873385 8873385 20251214010519_y3ST6 UK0039 2025-12-21T14:11:01.135Z 2025-12-23T14:27:36.134Z
8872971 8872971 20251214010230_WbXHf UK0039 2025-12-21T14:10:57.617Z 2025-12-23T14:27:35.714Z
8872488 8872488 20251214005932_hETGN UK0039 2025-12-21T14:10:53.202Z 2025-12-23T14:27:35.202Z
8871778 8871778 20251214005438_FNfdJ UK0039 2025-12-21T14:10:46.329Z 2025-12-23T14:27:34.530Z
8871548 8871548 20251214005300_y2O81 UK0039 2025-12-21T14:10:44.953Z 2025-12-23T14:27:34.146Z
8870923 8870923 20251214004848_vgsgr UK0039 2025-12-21T14:10:39.272Z 2025-12-23T14:27:33.263Z
8870356 8870356 20251214004504_rYJja UK0039 2025-12-21T14:10:34.313Z 2025-12-23T14:27:32.085Z
8795504 8795504 20251213043806_I1Saw UK0039 2025-12-16T14:08:08.128Z 2025-12-23T14:17:31.054Z
8795492 8795492 20251213043806_X9u5e UK0039 2025-12-16T14:08:08.076Z 2025-12-23T14:17:31.052Z

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