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,636 rows where station_code = "UK009V" 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
8691267 8691267 20251205041819_JUpI4 UK009V 2025-12-06T14:17:04.543Z 2025-12-06T14:18:01.073Z
8691263 8691263 20251205041819_6MtF5 UK009V 2025-12-06T14:17:04.196Z 2025-12-06T14:18:01.072Z
8691235 8691235 20251205041044_vFC2I UK009V 2025-12-06T14:16:57.706Z 2025-12-06T14:18:01.065Z
8691211 8691211 20251205040717_n39tM UK009V 2025-12-06T14:16:54.007Z 2025-12-06T14:18:01.060Z
8691203 8691203 20251205040708_y22qo UK009V 2025-12-06T14:16:52.971Z 2025-12-06T14:18:01.058Z
8691146 8691146 20251205034405_ah7cb UK009V 2025-12-06T14:16:43.626Z 2025-12-06T14:18:01.042Z
8691036 8691036 20251205025735_5UHbX UK009V 2025-12-06T14:16:19.363Z 2025-12-06T14:18:01.016Z
8676969 8676969 20251202063540_xC8EZ UK009V 2025-12-03T14:25:58.671Z 2025-12-06T14:35:32.015Z
8676118 8676118 20251202053729_sV63r UK009V 2025-12-03T14:24:43.531Z 2025-12-06T14:35:10.736Z
8658105 8658105 20251130063823_OCP6r UK009V 2025-12-01T14:34:55.034Z 2025-12-06T14:50:26.495Z
8657946 8657946 20251130062133_CaprW UK009V 2025-12-01T14:34:47.224Z 2025-12-06T14:50:24.697Z
8657175 8657175 20251130053228_1aNV2 UK009V 2025-12-01T14:33:58.847Z 2025-12-06T14:49:45.426Z
8657168 8657168 20251130053213_jVUGf UK009V 2025-12-01T14:33:57.214Z 2025-12-06T14:49:45.360Z
8657000 8657000 20251130052359_ST4xC UK009V 2025-12-01T14:33:51.656Z 2025-12-06T14:49:43.978Z
8656895 8656895 20251130051533_Nlcsd UK009V 2025-12-01T14:33:48.357Z 2025-12-06T14:49:42.736Z
8656650 8656650 20251130050439_oVnh2 UK009V 2025-12-01T14:28:51.585Z 2025-12-06T14:49:38.092Z
8656631 8656631 20251130050240_tTjCx UK009V 2025-12-01T14:28:49.294Z 2025-12-06T14:49:37.258Z
8656545 8656545 20251130045851_ON0Gc UK009V 2025-12-01T14:28:44.075Z 2025-12-06T14:49:35.787Z
8656459 8656459 20251130045632_iB93j UK009V 2025-12-01T14:28:39.579Z 2025-12-06T14:49:34.930Z
8656374 8656374 20251130045203_PoTpK UK009V 2025-12-01T14:28:33.863Z 2025-12-06T14:49:34.153Z
8656100 8656100 20251130043649_9rZbv UK009V 2025-12-01T14:28:03.028Z 2025-12-06T14:49:30.665Z
8655694 8655694 20251130041152_4eH3J UK009V 2025-12-01T14:27:21.460Z 2025-12-06T14:49:26.576Z
8655647 8655647 20251130041032_qzGAS UK009V 2025-12-01T14:27:19.708Z 2025-12-06T14:49:26.186Z
8654997 8654997 20251130034036_yj4AN UK009V 2025-12-01T14:26:14.785Z 2025-12-06T14:48:50.693Z
8654955 8654955 20251130033941_XW6tZ UK009V 2025-12-01T14:26:12.727Z 2025-12-06T14:48:50.439Z
8654866 8654866 20251130033610_3kN7Y UK009V 2025-12-01T14:26:07.574Z 2025-12-06T14:48:49.216Z
8654605 8654605 20251130032225_KFfD3 UK009V 2025-12-01T14:25:37.061Z 2025-12-06T14:48:44.687Z
8654442 8654442 20251130031706_EAIuC UK009V 2025-12-01T14:25:26.050Z 2025-12-06T14:48:42.711Z
8654036 8654036 20251130025353_9u0BD UK009V 2025-12-01T14:24:45.926Z 2025-12-06T14:48:36.270Z
8653966 8653966 20251130024934_8KXez UK009V 2025-12-01T14:24:33.344Z 2025-12-06T14:48:35.130Z
8653641 8653641 20251130023240_y0O9Z UK009V 2025-12-01T14:23:53.567Z 2025-12-06T14:48:23.951Z
8653386 8653386 20251130021333_oGvAD UK009V 2025-12-01T14:23:19.746Z 2025-12-06T14:47:57.074Z
8653135 8653135 20251130015926_rTlnS UK009V 2025-12-01T14:22:52.043Z 2025-12-06T14:47:50.616Z
8653055 8653055 20251130015329_GtUyH UK009V 2025-12-01T14:22:42.775Z 2025-12-06T14:47:48.888Z
8652944 8652944 20251130014610_D3wQI UK009V 2025-12-01T14:22:33.903Z 2025-12-06T14:47:46.543Z
8652913 8652913 20251130014512_xoj6p UK009V 2025-12-01T14:22:30.451Z 2025-12-06T14:47:45.643Z
8652893 8652893 20251130014419_Ln2oV UK009V 2025-12-01T14:22:29.172Z 2025-12-06T14:47:44.995Z
8652688 8652688 20251130012713_7hhQX UK009V 2025-12-01T14:21:58.801Z 2025-12-06T14:47:40.992Z
8652474 8652474 20251130011218_UmldL UK009V 2025-12-01T14:21:29.034Z 2025-12-06T14:47:37.582Z
8652377 8652377 20251130010542_c0JuA UK009V 2025-12-01T14:21:19.093Z 2025-12-06T14:47:36.369Z
8652215 8652215 20251130005520_2a072 UK009V 2025-12-01T14:20:55.747Z 2025-12-06T14:47:31.435Z
8643435 8643435 20251128175527_TyO7q UK009V 2025-11-30T14:20:01.472Z 2025-12-06T14:53:49.539Z
8637397 8637397 20251128053631_JFG0X UK009V 2025-11-29T14:27:12.256Z 2025-12-06T15:03:59.688Z
8637383 8637383 20251128053447_348mr UK009V 2025-11-29T14:27:11.272Z 2025-12-06T15:03:59.482Z
8636638 8636638 20251128041133_y3PVD UK009V 2025-11-29T14:25:46.698Z 2025-12-06T15:03:33.624Z
8636633 8636633 20251128041132_S2DGN UK009V 2025-11-29T14:25:46.601Z 2025-12-06T15:03:33.562Z
8636586 8636586 20251128040629_CyJVG UK009V 2025-11-29T14:25:43.833Z 2025-12-06T15:03:31.505Z
8635173 8635173 20251128014733_XdyRt UK009V 2025-11-29T14:22:46.380Z 2025-12-06T15:02:41.401Z
8634573 8634573 20251128005951_c1TOJ UK009V 2025-11-29T14:21:34.446Z 2025-12-06T15:02:21.720Z
8634014 8634014 20251128001505_8MGlm UK009V 2025-11-29T14:20:37.811Z 2025-12-06T15:01:50.588Z
8634001 8634001 20251128001336_Kh4x8 UK009V 2025-11-29T14:20:36.923Z 2025-12-06T15:01:50.504Z
8633790 8633790 20251127235453_VwQft UK009V 2025-11-29T14:20:23.661Z 2025-12-06T15:01:48.674Z
8633530 8633530 20251127233002_eSqpX UK009V 2025-11-29T14:19:50.889Z 2025-12-06T15:01:45.240Z
8633402 8633402 20251127231236_qUIdX UK009V 2025-11-29T14:19:40.903Z 2025-12-06T15:01:43.545Z
8633176 8633176 20251127224915_2xKdh UK009V 2025-11-29T14:19:11.858Z 2025-12-06T15:01:40.810Z
8632968 8632968 20251127222324_laX8p UK009V 2025-11-29T14:18:37.055Z 2025-12-06T15:01:36.268Z
8632687 8632687 20251127213704_yjEt9 UK009V 2025-11-29T14:18:00.640Z 2025-12-06T15:01:32.433Z
8616665 8616665 20251126061504_CFq55 UK009V 2025-11-27T14:31:25.253Z 2025-12-04T15:11:41.675Z
8616663 8616663 20251126061416_l4KB2 UK009V 2025-11-27T14:31:24.946Z 2025-12-04T15:11:41.646Z
8616587 8616587 20251126061327_c0LVc UK009V 2025-11-27T14:31:20.398Z 2025-12-04T15:11:41.181Z
8616367 8616367 20251126055304_kvlTP UK009V 2025-11-27T14:31:06.918Z 2025-12-04T15:11:38.380Z
8616178 8616178 20251126054407_UjJFF UK009V 2025-11-27T14:30:40.777Z 2025-12-04T15:11:36.527Z
8616153 8616153 20251126054332_qqu4S UK009V 2025-11-27T14:30:37.830Z 2025-12-04T15:11:36.467Z
8616047 8616047 20251126053351_7LOyI UK009V 2025-11-27T14:30:23.169Z 2025-12-04T15:11:34.828Z
8616002 8616002 20251126053127_ddSVN UK009V 2025-11-27T14:30:20.761Z 2025-12-04T15:11:34.439Z
8615985 8615985 20251126053039_f2Wl9 UK009V 2025-11-27T14:30:19.849Z 2025-12-04T15:11:34.212Z
8615783 8615783 20251126051904_VjE3p UK009V 2025-11-27T14:30:10.451Z 2025-12-04T15:11:32.304Z
8615675 8615675 20251126051245_cv8ct UK009V 2025-11-27T14:30:04.593Z 2025-12-04T15:11:31.152Z
8615477 8615477 20251126050434_paoy0 UK009V 2025-11-27T14:29:35.187Z 2025-12-04T15:11:29.304Z
8615423 8615423 20251126050300_DtwXt UK009V 2025-11-27T14:29:31.555Z 2025-12-04T15:11:28.741Z
8615408 8615408 20251126050146_qjh82 UK009V 2025-11-27T14:29:30.665Z 2025-12-04T15:11:28.411Z
8614579 8614579 20251126041816_7fcMS UK009V 2025-11-27T14:28:03.187Z 2025-12-04T15:10:51.741Z
8614494 8614494 20251126041518_ksZHw UK009V 2025-11-27T14:27:55.460Z 2025-12-04T15:10:45.761Z
8614436 8614436 20251126040850_IkmD2 UK009V 2025-11-27T14:27:52.263Z 2025-12-04T15:10:40.799Z
8613497 8613497 20251126031947_l7o7F UK009V 2025-11-27T14:26:08.906Z 2025-12-04T15:09:41.284Z
8613345 8613345 20251126031415_djwQO UK009V 2025-11-27T14:25:39.096Z 2025-12-04T15:09:39.803Z
8613090 8613090 20251126030101_lyW1k UK009V 2025-11-27T14:25:22.359Z 2025-12-04T15:09:37.066Z
8613056 8613056 20251126030024_eEftU UK009V 2025-11-27T14:25:21.016Z 2025-12-04T15:09:36.794Z
8612834 8612834 20251126025006_TPfc7 UK009V 2025-11-27T14:24:53.764Z 2025-12-04T15:09:34.726Z
8612823 8612823 20251126024946_tFwVA UK009V 2025-11-27T14:24:52.869Z 2025-12-04T15:09:34.542Z
8612774 8612774 20251126024535_gz7cs UK009V 2025-11-27T14:24:38.389Z 2025-12-04T15:09:33.965Z
8612606 8612606 20251126023902_0l3CJ UK009V 2025-11-27T14:24:24.199Z 2025-12-04T15:09:32.198Z
8612572 8612572 20251126023804_nmVKI UK009V 2025-11-27T14:24:22.620Z 2025-12-04T15:09:32.070Z
8612435 8612435 20251126023143_LVl2V UK009V 2025-11-27T14:24:13.012Z 2025-12-04T15:09:30.720Z
8612385 8612385 20251126022910_ZEeF0 UK009V 2025-11-27T14:23:53.841Z 2025-12-04T15:09:30.299Z
8612280 8612280 20251126022428_eJVrf UK009V 2025-11-27T14:23:43.250Z 2025-12-04T15:09:28.964Z
8612136 8612136 20251126021923_4Ig3x UK009V 2025-11-27T14:23:32.592Z 2025-12-04T15:09:27.867Z
8611989 8611989 20251126021237_yaQIW UK009V 2025-11-27T14:23:11.613Z 2025-12-04T15:09:26.544Z
8611853 8611853 20251126020246_8mpj0 UK009V 2025-11-27T14:22:58.748Z 2025-12-04T15:09:24.842Z
8611807 8611807 20251126020104_mqQsL UK009V 2025-11-27T14:22:54.947Z 2025-12-04T15:09:24.358Z
8611356 8611356 20251126013748_2PbIR UK009V 2025-11-27T14:21:56.981Z 2025-12-04T15:09:10.543Z
8611232 8611232 20251126013240_1qUv3 UK009V 2025-11-27T14:21:42.065Z 2025-12-04T15:08:59.317Z
8610929 8610929 20251126011413_zreiV UK009V 2025-11-27T14:20:57.856Z 2025-12-04T15:08:45.239Z
8610798 8610798 20251126010818_Cv7E0 UK009V 2025-11-27T14:20:50.983Z 2025-12-04T15:08:40.760Z
8610708 8610708 20251126010338_fV9w6 UK009V 2025-11-27T14:20:45.579Z 2025-12-04T15:08:38.266Z
8610223 8610223 20251126003100_8YP8D UK009V 2025-11-27T14:19:37.894Z 2025-12-04T15:08:03.434Z
8609757 8609757 20251126000323_i2cHk UK009V 2025-11-27T14:18:55.456Z 2025-12-04T15:07:57.162Z
8609532 8609532 20251125234644_ET5ya UK009V 2025-11-27T14:18:19.344Z 2025-12-04T15:07:54.981Z
8609480 8609480 20251125234536_sjpnc UK009V 2025-11-27T14:18:15.767Z 2025-12-04T15:07:54.700Z
8608579 8608579 20251125223036_DnAzf UK009V 2025-11-27T14:16:21.088Z 2025-12-04T15:07:46.710Z

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