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

4,622 rows where station_code = "UK002J" 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
9260385 9260385 20260125041059_HPCIJ UK002J 2026-01-26T14:21:29.163Z 2026-01-29T14:44:09.698Z
9260349 9260349 20260125035406_6A9NO UK002J 2026-01-26T14:21:21.859Z 2026-01-29T14:44:07.263Z
9251957 9251957 20260123000706_2ix2C UK002J 2026-01-24T14:13:49.242Z 2026-01-29T14:52:18.820Z
9251867 9251867 20260122233659_Ia29L UK002J 2026-01-24T14:13:26.976Z 2026-01-29T14:52:14.266Z
9251699 9251699 20260122220923_2qxCh UK002J 2026-01-24T14:12:58.182Z 2026-01-29T14:52:01.531Z
9242904 9242904 20260121031311_y2qfB UK002J 2026-01-22T14:19:43.382Z 2026-01-29T15:04:29.088Z
9242881 9242881 20260121030753_24OuR UK002J 2026-01-22T14:19:38.994Z 2026-01-29T15:04:26.720Z
9242848 9242848 20260121025900_1CLpm UK002J 2026-01-22T14:19:32.645Z 2026-01-29T15:04:24.196Z
9242360 9242360 20260121013817_QFyKL UK002J 2026-01-22T14:17:28.128Z 2026-01-29T15:03:46.003Z
9242334 9242334 20260121013241_eb1QW UK002J 2026-01-22T14:17:23.185Z 2026-01-29T15:03:44.890Z
9234428 9234428 20260119212708_tbACC UK002J 2026-01-21T14:14:26.376Z 2026-01-28T14:57:45.684Z
9214548 9214548 20260116065258_9njTW UK002J 2026-01-17T14:22:03.341Z 2026-01-24T15:13:51.145Z
9214455 9214455 20260116063849_jnD2Z UK002J 2026-01-17T14:21:36.992Z 2026-01-24T15:13:38.372Z
9214370 9214370 20260116062325_Mw7r4 UK002J 2026-01-17T14:21:13.736Z 2026-01-24T15:13:31.763Z
9214330 9214330 20260116061853_IDrmO UK002J 2026-01-17T14:21:07.206Z 2026-01-24T15:13:30.479Z
9214168 9214168 20260116054845_8e0eK UK002J 2026-01-17T14:20:26.257Z 2026-01-24T15:13:19.618Z
9214162 9214162 20260116054827_mQW5k UK002J 2026-01-17T14:20:24.989Z 2026-01-24T15:13:19.048Z
9212548 9212548 20260115230451_onhSZ UK002J 2026-01-17T14:12:38.663Z 2026-01-24T15:11:02.365Z
9204367 9204367 20260114063334_FgJlE UK002J 2026-01-15T14:27:09.129Z 2026-01-22T15:10:25.517Z
9204297 9204297 20260114062546_9s9xM UK002J 2026-01-15T14:27:01.496Z 2026-01-22T15:10:24.569Z
9204258 9204258 20260114062101_BcVJE UK002J 2026-01-15T14:26:54.970Z 2026-01-22T15:10:23.317Z
9203014 9203014 20260114042612_kQhkc UK002J 2026-01-15T14:23:02.312Z 2026-01-22T15:10:00.572Z
9202912 9202912 20260114041736_9yjII UK002J 2026-01-15T14:22:46.622Z 2026-01-22T15:09:59.300Z
9202909 9202909 20260114041736_IxrVt UK002J 2026-01-15T14:22:45.975Z 2026-01-22T15:09:59.164Z
9202778 9202778 20260114040815_MORpK UK002J 2026-01-15T14:22:20.918Z 2026-01-22T15:09:41.005Z
9202704 9202704 20260114040412_8Qgul UK002J 2026-01-15T14:22:11.425Z 2026-01-22T15:09:30.071Z
9202562 9202562 20260114034928_Dm3pi UK002J 2026-01-15T14:21:41.022Z 2026-01-22T15:09:22.994Z
9201284 9201284 20260114020526_NC9uQ UK002J 2026-01-15T14:18:10.469Z 2026-01-22T15:09:01.180Z
9200583 9200583 20260114002902_upvX2 UK002J 2026-01-15T14:15:41.361Z 2026-01-22T15:08:19.992Z
9200316 9200316 20260113234200_ckRZO UK002J 2026-01-15T14:14:43.262Z 2026-01-22T15:08:13.760Z
9194907 9194907 20260112232343_XiK5s UK002J 2026-01-14T14:11:15.359Z 2026-01-21T15:04:33.923Z
9194212 9194212 20260112185652_TiHo1 UK002J 2026-01-14T14:08:04.248Z 2026-01-21T15:03:40.976Z
9180643 9180643 20260110212040_Nnhzh UK002J 2026-01-12T14:07:50.908Z 2026-01-19T15:16:25.977Z
9176735 9176735 20260110061306_gx2Lw UK002J 2026-01-11T14:09:49.814Z 2026-01-18T15:08:52.107Z
9176505 9176505 20260110053809_O7tGK UK002J 2026-01-11T14:09:12.398Z 2026-01-18T15:08:41.733Z
9176119 9176119 20260110044838_PQq31 UK002J 2026-01-11T14:08:12.782Z 2026-01-18T15:08:19.540Z
9175154 9175154 20260110012520_Nw1a0 UK002J 2026-01-11T14:05:33.193Z 2026-01-18T15:07:29.659Z
9175099 9175099 20260110010559_schvV UK002J 2026-01-11T14:05:22.760Z 2026-01-18T15:07:25.729Z
9174723 9174723 20260109215803_9pPCF UK002J 2026-01-11T14:04:09.810Z 2026-01-18T15:07:07.636Z
9174708 9174708 20260109215424_bg0X2 UK002J 2026-01-11T14:04:07.080Z 2026-01-18T15:07:06.923Z
9158828 9158828 20260106003648_vXD5b UK002J 2026-01-07T14:07:23.658Z 2026-01-13T15:07:47.742Z
9158634 9158634 20260105235228_gabgc UK002J 2026-01-07T14:06:49.563Z 2026-01-13T15:07:39.543Z
9158224 9158224 20260105210524_0SPAf UK002J 2026-01-07T14:05:25.242Z 2026-01-13T15:07:12.117Z
9151769 9151769 20260105062933_S9KTL UK002J 2026-01-06T14:14:37.457Z 2026-01-13T15:15:04.830Z
9149736 9149736 20260104231811_cNLOm UK002J 2026-01-06T14:06:55.850Z 2026-01-13T15:12:36.261Z
9147775 9147775 20260104065257_imJXF UK002J 2026-01-05T14:24:50.791Z 2026-01-12T15:11:40.008Z
9147765 9147765 20260104064931_3RpSu UK002J 2026-01-05T14:24:49.840Z 2026-01-12T15:11:38.905Z
9147751 9147751 20260104064311_wNGd0 UK002J 2026-01-05T14:24:48.016Z 2026-01-12T15:11:37.045Z
9147739 9147739 20260104063850_kcKiN UK002J 2026-01-05T14:24:46.863Z 2026-01-12T15:11:35.613Z
9147725 9147725 20260104063658_MfYi3 UK002J 2026-01-05T14:24:45.765Z 2026-01-12T15:11:34.629Z
9147710 9147710 20260104063402_3hlta UK002J 2026-01-05T14:24:45.445Z 2026-01-12T15:11:33.644Z
9147685 9147685 20260104063017_2s8iR UK002J 2026-01-05T14:24:43.122Z 2026-01-12T15:11:31.848Z
9147682 9147682 20260104063011_3jc02 UK002J 2026-01-05T14:24:42.597Z 2026-01-12T15:11:31.547Z
9147596 9147596 20260104061304_v0u2n UK002J 2026-01-05T14:24:36.373Z 2026-01-12T15:11:23.741Z
9147538 9147538 20260104060402_vT4Z6 UK002J 2026-01-05T14:24:21.309Z 2026-01-12T15:11:07.029Z
9147439 9147439 20260104054948_yVDC4 UK002J 2026-01-05T14:24:10.686Z 2026-01-12T15:10:56.873Z
9147299 9147299 20260104052859_Tw2Gb UK002J 2026-01-05T14:24:01.335Z 2026-01-12T15:10:40.365Z
9138060 9138060 20260103215712_lVlo9 UK002J 2026-01-05T14:09:20.474Z 2026-01-12T15:02:28.875Z
9137626 9137626 20260103212207_y7B2A UK002J 2026-01-05T14:08:45.687Z 2026-01-12T15:02:14.997Z
9137602 9137602 20260103212140_kmK2e UK002J 2026-01-05T14:08:42.699Z 2026-01-12T15:02:14.744Z
9137583 9137583 20260103211952_pT2ZB UK002J 2026-01-05T14:08:38.297Z 2026-01-12T15:02:14.538Z
9137547 9137547 20260103211755_BNJE3 UK002J 2026-01-05T14:08:36.324Z 2026-01-12T15:02:13.692Z
9137528 9137528 20260103211755_iqWnf UK002J 2026-01-05T14:08:36.136Z 2026-01-12T15:02:13.612Z
9137260 9137260 20260103205702_ic5MX UK002J 2026-01-05T14:08:13.741Z 2026-01-12T15:01:54.610Z
9137059 9137059 20260103203547_ZVOpE UK002J 2026-01-05T14:07:47.933Z 2026-01-12T15:01:46.856Z
9136965 9136965 20260103202821_5Au7U UK002J 2026-01-05T14:07:37.241Z 2026-01-12T15:01:44.331Z
9136847 9136847 20260103202201_OdlVC UK002J 2026-01-05T14:07:21.475Z 2026-01-12T15:01:41.217Z
9136670 9136670 20260103201032_ti2LU UK002J 2026-01-05T14:07:09.837Z 2026-01-12T15:01:36.365Z
9136541 9136541 20260103200127_v2vfr UK002J 2026-01-05T14:06:54.025Z 2026-01-12T15:01:22.482Z
9136398 9136398 20260103195311_W5E4q UK002J 2026-01-05T14:06:38.360Z 2026-01-12T15:01:16.644Z
9136274 9136274 20260103194428_Siyv5 UK002J 2026-01-05T14:06:29.850Z 2026-01-12T15:01:13.618Z
9136263 9136263 20260103194407_mvaj1 UK002J 2026-01-05T14:06:24.177Z 2026-01-12T15:01:13.363Z
9136145 9136145 20260103193948_8VEEp UK002J 2026-01-05T14:06:13.685Z 2026-01-12T15:01:10.791Z
9136009 9136009 20260103192928_SSvur UK002J 2026-01-05T14:05:56.122Z 2026-01-12T15:01:04.345Z
9136006 9136006 20260103192927_9AJsX UK002J 2026-01-05T14:05:53.418Z 2026-01-12T15:01:04.247Z
9132514 9132514 20260103064923_7t1EV UK002J 2026-01-04T14:16:55.105Z 2026-01-10T15:01:33.267Z
9131882 9131882 20260103060327_3NH8o UK002J 2026-01-04T14:15:11.341Z 2026-01-10T15:01:00.045Z
9131685 9131685 20260103054351_uO3fn UK002J 2026-01-04T14:14:41.571Z 2026-01-10T15:00:46.254Z
9129205 9129205 20260102194324_myWAg UK002J 2026-01-04T14:02:30.917Z 2026-01-10T14:57:15.553Z
9129172 9129172 20260102191403_ckNIk UK002J 2026-01-04T14:02:03.905Z 2026-01-10T14:57:10.861Z
9129164 9129164 20260102191057_Fl2Uq UK002J 2026-01-04T14:01:57.962Z 2026-01-10T14:57:09.659Z
9127714 9127714 20260102045659_kyGCf UK002J 2026-01-03T14:11:33.780Z 2026-01-09T14:50:09.437Z
9127706 9127706 20260102045408_Dhxoe UK002J 2026-01-03T14:11:31.547Z 2026-01-09T14:50:08.996Z
9127685 9127685 20260102044957_icLUX UK002J 2026-01-03T14:11:25.559Z 2026-01-09T14:50:07.687Z
9127636 9127636 20260102044256_Kqbk5 UK002J 2026-01-03T14:11:11.620Z 2026-01-09T14:50:01.564Z
9127486 9127486 20260102041502_4WvDD UK002J 2026-01-03T14:10:33.428Z 2026-01-09T14:49:55.844Z
9127375 9127375 20260102035224_fFyz5 UK002J 2026-01-03T14:10:02.079Z 2026-01-09T14:49:42.096Z
9127250 9127250 20260102031506_2BU21 UK002J 2026-01-03T14:09:23.455Z 2026-01-09T14:49:34.949Z
9125651 9125651 20251231182800_u3q9b UK002J 2026-01-02T14:55:44.085Z 2026-01-08T15:15:51.259Z
9122466 9122466 20260101065409_NYky9 UK002J 2026-01-02T14:13:09.401Z 2026-01-09T14:53:27.589Z
9122402 9122402 20260101062339_ykKda UK002J 2026-01-02T14:12:51.879Z 2026-01-09T14:53:24.762Z
9122390 9122390 20260101061015_DW8xJ UK002J 2026-01-02T14:12:46.968Z 2026-01-09T14:53:23.864Z
9075662 9075662 20251224203049_7TU8j UK002J 2025-12-29T15:07:58.010Z 2026-01-01T15:57:18.610Z
9075645 9075645 20251224192136_un4wf UK002J 2025-12-29T15:07:51.824Z 2025-12-29T15:07:51.824Z
9072839 9072839 20251225045042_3UTdd UK002J 2025-12-29T14:56:14.730Z 2026-01-02T15:44:57.199Z
9072673 9072673 20251225014418_cd4fq UK002J 2025-12-29T14:54:27.803Z 2026-01-02T15:43:06.983Z
9072579 9072579 20251224233708_sr1bw UK002J 2025-12-29T14:53:05.274Z 2026-01-02T15:42:11.999Z
9043438 9043438 20251224203049_JJKPy UK002J 2025-12-28T14:47:31.198Z 2025-12-28T14:48:38.641Z
9042819 9042819 20251224190741_xJh4v UK002J 2025-12-28T14:46:30.080Z 2026-01-01T15:57:10.830Z
9042584 9042584 20251224183139_U3FyR UK002J 2025-12-28T14:45:58.923Z 2026-01-01T15:57:07.094Z

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