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,585 rows where station_code = "UK0021" 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
9188223 9188223 20260111212957_hiPgR UK0021 2026-01-13T14:11:03.734Z 2026-01-20T15:21:28.078Z
9176537 9176537 20260110054113_pw1Ml UK0021 2026-01-11T14:09:17.086Z 2026-01-18T15:08:43.128Z
9176429 9176429 20260110052921_tFHri UK0021 2026-01-11T14:08:59.881Z 2026-01-18T15:08:38.893Z
9175919 9175919 20260110041611_45U33 UK0021 2026-01-11T14:07:48.430Z 2026-01-18T15:08:13.418Z
9174685 9174685 20260109214308_hyDhy UK0021 2026-01-11T14:04:03.434Z 2026-01-18T15:06:58.158Z
9174462 9174462 20260109193721_txodj UK0021 2026-01-11T14:03:18.382Z 2026-01-18T15:06:47.115Z
9158910 9158910 20260106005103_vCJAG UK0021 2026-01-07T14:07:37.796Z 2026-01-13T15:07:50.304Z
9158545 9158545 20260105230915_ucb2N UK0021 2026-01-07T14:06:29.122Z 2026-01-13T15:07:29.037Z
9158306 9158306 20260105215355_ehzMD UK0021 2026-01-07T14:05:43.828Z 2026-01-13T15:07:17.792Z
9157577 9157577 20260105175924_REOxs UK0021 2026-01-07T14:02:42.632Z 2026-01-13T15:06:18.369Z
9153134 9153134 20260103205220_UQ2Ju UK0021 2026-01-06T14:23:12.103Z 2026-01-12T15:01:53.429Z
9139952 9139952 20260103235157_tUYa7 UK0021 2026-01-05T14:12:18.618Z 2026-01-12T15:03:54.353Z
9139885 9139885 20260103235005_KhyV1 UK0021 2026-01-05T14:12:15.842Z 2026-01-12T15:03:52.873Z
9139687 9139687 20260103233946_5CAUe UK0021 2026-01-05T14:11:57.127Z 2026-01-12T15:03:43.239Z
9139660 9139660 20260103233841_GOSla UK0021 2026-01-05T14:11:54.696Z 2026-01-12T15:03:40.562Z
9139353 9139353 20260103233011_Vf627 UK0021 2026-01-05T14:11:32.149Z 2026-01-12T15:03:26.538Z
9139225 9139225 20260103232111_ZV0mC UK0021 2026-01-05T14:11:21.686Z 2026-01-12T15:03:23.884Z
9139120 9139120 20260103231404_EV9Ba UK0021 2026-01-05T14:11:15.688Z 2026-01-12T15:03:21.211Z
9139016 9139016 20260103230706_k5eCo UK0021 2026-01-05T14:11:03.838Z 2026-01-12T15:03:18.295Z
9138783 9138783 20260103225343_7GnG2 UK0021 2026-01-05T14:10:38.586Z 2026-01-12T15:03:00.153Z
9138774 9138774 20260103225305_oAW90 UK0021 2026-01-05T14:10:36.216Z 2026-01-12T15:02:59.653Z
9138262 9138262 20260103221349_aHzTY UK0021 2026-01-05T14:09:45.138Z 2026-01-12T15:02:44.741Z
9137848 9137848 20260103213700_qtUCb UK0021 2026-01-05T14:08:59.734Z 2026-01-12T15:02:21.301Z
9137840 9137840 20260103213700_y3W1B UK0021 2026-01-05T14:08:59.471Z 2026-01-12T15:02:21.192Z
9137710 9137710 20260103212637_v3KxZ UK0021 2026-01-05T14:08:51.606Z 2026-01-12T15:02:17.245Z
9137659 9137659 20260103212334_4BmcX UK0021 2026-01-05T14:08:48.101Z 2026-01-12T15:02:15.766Z
9137211 9137211 20260103205220_2EOmg UK0021 2026-01-05T14:08:02.714Z 2026-01-05T14:30:32.180Z
9137128 9137128 20260103204328_37aqM UK0021 2026-01-05T14:07:55.442Z 2026-01-12T15:01:49.572Z
9136645 9136645 20260103200936_IYkMU UK0021 2026-01-05T14:07:08.358Z 2026-01-12T15:01:35.841Z
9135867 9135867 20260103191730_pGNc7 UK0021 2026-01-05T14:05:31.536Z 2026-01-05T14:30:31.823Z
9134990 9134990 20260103183453_8jAng UK0021 2026-01-05T14:03:24.618Z 2026-01-12T14:59:59.385Z
9134835 9134835 20260103182443_UL3tR UK0021 2026-01-05T14:03:00.677Z 2026-01-12T14:59:52.230Z
9134523 9134523 20260103181101_KBqWv UK0021 2026-01-05T14:02:11.876Z 2026-01-12T14:59:35.896Z
9128730 9128730 20260101180902_2Hg0n UK0021 2026-01-03T14:23:18.754Z 2026-01-09T14:54:25.298Z
9127745 9127745 20260102050710_xp7S1 UK0021 2026-01-03T14:11:43.437Z 2026-01-09T14:50:10.571Z
9125751 9125751 20251231184318_vWoCq UK0021 2026-01-02T14:56:02.354Z 2026-01-08T15:15:57.431Z
9124454 9124454 20251231065148_Q64gP UK0021 2026-01-02T14:46:10.407Z 2026-01-08T15:12:11.995Z
9124373 9124373 20251231060759_QH05M UK0021 2026-01-02T14:45:01.861Z 2026-01-08T15:11:46.707Z
9123874 9123874 20251231035356_V3ELd UK0021 2026-01-02T14:37:21.673Z 2026-01-08T15:09:14.300Z
9119792 9119792 20251230190213_TLL7y UK0021 2026-01-01T14:57:19.488Z 2026-01-07T15:13:19.161Z
9116802 9116802 20251231065148_jEWEk UK0021 2026-01-01T14:28:58.302Z 2026-01-08T15:12:11.861Z
9116667 9116667 20251231063501_r7v8k UK0021 2026-01-01T14:28:38.999Z 2026-01-01T14:57:54.929Z
9116634 9116634 20251231062913_ACDC2 UK0021 2026-01-01T14:28:31.595Z 2026-01-08T15:11:57.352Z
9115940 9115940 20251231053503_yKg9z UK0021 2026-01-01T14:26:47.200Z 2026-01-01T14:57:54.508Z
9115590 9115590 20251231051650_uvwDr UK0021 2026-01-01T14:25:52.048Z 2026-01-01T14:57:54.325Z
9115275 9115275 20251231045617_sxTbZ UK0021 2026-01-01T14:24:54.925Z 2026-01-08T15:10:39.928Z
9114675 9114675 20251231042542_d9Q3f UK0021 2026-01-01T14:23:13.940Z 2026-01-08T15:09:59.254Z
9113890 9113890 20251231035356_fc2GG UK0021 2026-01-01T14:20:45.717Z 2026-01-08T15:09:14.252Z
9073884 9073884 20251225183904_iXY2N UK0021 2025-12-29T14:59:56.948Z 2025-12-29T14:59:56.948Z
9043923 9043923 20251224213923_Aq8Pl UK0021 2025-12-28T14:48:14.164Z 2026-01-01T15:57:24.860Z
9043810 9043810 20251224212429_nNYrl UK0021 2025-12-28T14:48:08.697Z 2025-12-29T15:08:02.313Z
9043804 9043804 20251224212418_0y6Cq UK0021 2025-12-28T14:48:08.509Z 2026-01-01T15:57:23.235Z
9043419 9043419 20251224202623_9Q1wd UK0021 2025-12-28T14:47:29.955Z 2025-12-29T15:07:57.762Z
9043346 9043346 20251224201757_d3EyA UK0021 2025-12-28T14:47:27.348Z 2026-01-01T15:57:17.916Z
9032255 9032255 20251225061241_33PCe UK0021 2025-12-28T14:22:25.704Z 2025-12-29T14:56:53.815Z
9031960 9031960 20251225055349_Z1u1D UK0021 2025-12-28T14:21:51.667Z 2026-01-02T15:45:37.089Z
9030808 9030808 20251225050101_93Tb0 UK0021 2025-12-28T14:19:26.199Z 2026-01-02T15:44:59.277Z
9030161 9030161 20251225043406_3Rg7b UK0021 2025-12-28T14:18:10.515Z 2026-01-02T15:44:51.611Z
9029854 9029854 20251225041908_sJGHk UK0021 2025-12-28T14:17:25.322Z 2025-12-29T14:56:04.390Z
9029559 9029559 20251225035948_4SJ2k UK0021 2025-12-28T14:16:36.948Z 2026-01-02T15:44:26.058Z
9029503 9029503 20251225035429_vmXG3 UK0021 2025-12-28T14:16:30.903Z 2025-12-29T14:55:59.899Z
9029448 9029448 20251225035233_SYNVl UK0021 2025-12-28T14:16:25.894Z 2026-01-02T15:44:22.729Z
9029151 9029151 20251225033838_Z4woh UK0021 2025-12-28T14:15:44.958Z 2026-01-02T15:44:17.521Z
9029005 9029005 20251225032945_3MFrY UK0021 2025-12-28T14:15:21.079Z 2026-01-02T15:44:15.117Z
9028948 9028948 20251225032748_2jcv3 UK0021 2025-12-28T14:15:15.355Z 2026-01-02T15:44:14.450Z
9028914 9028914 20251225032629_H4LfU UK0021 2025-12-28T14:15:10.845Z 2025-12-29T14:55:25.896Z
9028209 9028209 20251225025311_Ag2UH UK0021 2025-12-28T14:13:25.934Z 2026-01-02T15:43:47.584Z
9028141 9028141 20251225025016_akLte UK0021 2025-12-28T14:13:10.175Z 2025-12-29T14:55:14.168Z
9027965 9027965 20251225024156_VWsGT UK0021 2025-12-28T14:12:32.892Z 2025-12-29T14:55:11.461Z
9027624 9027624 20251225022457_BCszi UK0021 2025-12-28T14:11:46.183Z 2026-01-02T15:43:35.999Z
9026855 9026855 20251225013746_Oo2F1 UK0021 2025-12-28T14:09:13.598Z 2026-01-02T15:43:03.498Z
9026848 9026848 20251225013724_Tdhw9 UK0021 2025-12-28T14:09:12.830Z 2026-01-02T15:43:03.384Z
9026760 9026760 20251225013249_WevoF UK0021 2025-12-28T14:08:55.634Z 2025-12-29T14:54:25.062Z
9026536 9026536 20251225011459_Y238e UK0021 2025-12-28T14:08:10.094Z 2025-12-29T14:54:21.002Z
9025797 9025797 20251225002726_q8wkN UK0021 2025-12-28T14:05:44.366Z 2025-12-29T14:54:09.980Z
9025773 9025773 20251225002610_iz1sP UK0021 2025-12-28T14:05:41.192Z 2025-12-29T14:54:09.464Z
9024912 9024912 20251224231545_ZHnTE UK0021 2025-12-28T14:02:44.061Z 2026-01-02T15:42:08.018Z
9018072 9018072 20251220061355_xcE9x UK0021 2025-12-27T15:02:23.704Z 2025-12-27T15:02:23.704Z
9018000 9018000 20251220060855_EC8eY UK0021 2025-12-27T15:01:56.732Z 2025-12-29T15:23:36.712Z
9017997 9017997 20251220060855_Yh3HW UK0021 2025-12-27T15:01:56.695Z 2025-12-27T15:01:56.695Z
9017915 9017915 20251220055950_F6fsv UK0021 2025-12-27T15:01:46.856Z 2025-12-27T15:01:46.856Z
9017621 9017621 20251220053345_bsxdJ UK0021 2025-12-27T15:01:26.754Z 2025-12-29T15:23:32.572Z
9017453 9017453 20251220052146_kzKPq UK0021 2025-12-27T15:01:21.775Z 2025-12-27T15:01:21.775Z
9016915 9016915 20251220044046_rBwA2 UK0021 2025-12-27T15:00:53.481Z 2025-12-29T15:23:27.004Z
9016866 9016866 20251220043732_bqGdw UK0021 2025-12-27T15:00:40.521Z 2025-12-29T15:23:26.632Z
9016828 9016828 20251220043503_bQJY3 UK0021 2025-12-27T15:00:30.689Z 2025-12-29T15:23:26.283Z
9016649 9016649 20251220042051_KidC0 UK0021 2025-12-27T14:59:52.466Z 2025-12-29T15:23:24.776Z
8985070 8985070 20251220002204_ZW07D UK0021 2025-12-26T14:31:45.325Z 2025-12-28T15:23:58.427Z
8985042 8985042 20251220001917_JCawj UK0021 2025-12-26T14:31:44.128Z 2025-12-27T15:18:49.756Z
8983910 8983910 20251219224023_3VQFF UK0021 2025-12-26T14:29:57.509Z 2025-12-27T15:18:10.351Z
8983808 8983808 20251219223158_gF5LW UK0021 2025-12-26T14:29:43.481Z 2025-12-28T15:23:44.267Z
8983155 8983155 20251219212018_Aes2Q UK0021 2025-12-26T14:28:37.870Z 2025-12-28T15:23:34.054Z
8982249 8982249 20251219191536_D5Dsn UK0021 2025-12-26T14:26:36.318Z 2025-12-28T15:22:06.831Z
8981480 8981480 20251219174001_QU300 UK0021 2025-12-26T14:24:50.561Z 2025-12-27T15:16:23.395Z
8978349 8978349 20251219063903_7UxS2 UK0021 2025-12-26T14:14:59.480Z 2025-12-28T15:17:39.059Z
8978008 8978008 20251219060539_xpm9O UK0021 2025-12-26T14:14:06.784Z 2025-12-26T14:32:01.526Z
8977939 8977939 20251219060016_ilwAS UK0021 2025-12-26T14:14:01.077Z 2025-12-28T15:17:36.202Z
8977892 8977892 20251219055645_iNuln UK0021 2025-12-26T14:13:50.411Z 2025-12-26T14:32:01.482Z
8977283 8977283 20251219044445_UOhSz UK0021 2025-12-26T14:12:19.042Z 2025-12-26T14:32:01.244Z
8977130 8977130 20251219042535_MVDj3 UK0021 2025-12-26T14:11:57.754Z 2025-12-26T14:32:01.199Z

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