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

2,074 rows where station_code = "UK00CT" 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
8635277 8635277 20251128015942_kzAFa UK00CT 2025-11-29T14:22:59.427Z 2025-12-06T15:02:42.901Z
8569705 8569705 20251121060932_9rpJY UK00CT 2025-11-23T14:32:25.111Z 2025-11-29T14:54:48.800Z
8569410 8569410 20251121055626_l6Me1 UK00CT 2025-11-23T14:32:14.465Z 2025-11-29T14:54:48.257Z
8569245 8569245 20251121054951_sK6gX UK00CT 2025-11-23T14:32:06.482Z 2025-11-29T14:54:47.945Z
8569197 8569197 20251121054838_1tkGW UK00CT 2025-11-23T14:32:02.705Z 2025-11-29T14:54:47.924Z
8569130 8569130 20251121054631_sz2q7 UK00CT 2025-11-23T14:31:55.065Z 2025-11-29T14:54:47.828Z
8568974 8568974 20251121054214_2hNmf UK00CT 2025-11-23T14:31:49.821Z 2025-11-29T14:54:47.652Z
8568308 8568308 20251121051202_Prsyq UK00CT 2025-11-23T14:31:02.680Z 2025-11-29T14:54:46.470Z
8560465 8560465 20251121045558_3Qd1K UK00CT 2025-11-22T14:42:52.944Z 2025-11-29T14:54:45.788Z
8560275 8560275 20251121044833_rgIlv UK00CT 2025-11-22T14:42:49.008Z 2025-11-22T14:42:49.008Z
8559420 8559420 20251121041026_f7TBt UK00CT 2025-11-22T14:41:55.322Z 2025-11-29T14:54:38.501Z
8558786 8558786 20251121034219_h188A UK00CT 2025-11-22T14:41:15.627Z 2025-11-29T14:54:36.655Z
8558344 8558344 20251121032550_ddVBX UK00CT 2025-11-22T14:41:03.786Z 2025-11-29T14:54:35.958Z
8558014 8558014 20251121031046_2Qbor UK00CT 2025-11-22T14:40:55.540Z 2025-11-29T14:54:35.037Z
8556480 8556480 20251121015630_3U85f UK00CT 2025-11-22T14:39:34.335Z 2025-11-29T14:54:32.396Z
8555967 8555967 20251121013134_iv4AL UK00CT 2025-11-22T14:38:56.915Z 2025-11-29T14:54:31.588Z
8554934 8554934 20251121004700_dmzFb UK00CT 2025-11-22T14:37:39.755Z 2025-11-29T14:54:29.361Z
8553873 8553873 20251120061307_eZD2X UK00CT 2025-11-22T14:34:31.370Z 2025-11-28T14:58:35.786Z
8553767 8553767 20251120060232_rcyfO UK00CT 2025-11-22T14:34:24.753Z 2025-11-28T14:58:34.249Z
8553718 8553718 20251120055914_T9ppF UK00CT 2025-11-22T14:34:10.407Z 2025-11-28T14:58:33.559Z
8553573 8553573 20251120054809_ee6lp UK00CT 2025-11-22T14:34:04.749Z 2025-11-28T14:58:28.252Z
8553553 8553553 20251120054633_6UKCI UK00CT 2025-11-22T14:34:03.734Z 2025-11-28T14:58:23.237Z
8551156 8551156 20251121002554_1N52a UK00CT 2025-11-22T14:22:09.311Z 2025-11-22T14:22:09.311Z
8550865 8550865 20251121000736_wKQsC UK00CT 2025-11-22T14:21:45.979Z 2025-11-29T14:54:27.765Z
8550660 8550660 20251120235748_nKUUt UK00CT 2025-11-22T14:21:21.802Z 2025-11-22T14:21:21.802Z
8550623 8550623 20251120235653_z1yc9 UK00CT 2025-11-22T14:21:20.298Z 2025-11-29T14:54:27.222Z
8550503 8550503 20251120234930_eEmkn UK00CT 2025-11-22T14:21:02.692Z 2025-11-29T14:54:27.063Z
8550334 8550334 20251120233726_slg3M UK00CT 2025-11-22T14:20:45.718Z 2025-11-22T14:20:45.718Z
8550138 8550138 20251120232457_EUPph UK00CT 2025-11-22T14:20:19.748Z 2025-11-29T14:54:26.328Z
8549843 8549843 20251120225910_l35mx UK00CT 2025-11-22T14:19:41.019Z 2025-11-29T14:54:25.754Z
8549732 8549732 20251120225318_s0Xd2 UK00CT 2025-11-22T14:19:31.860Z 2025-11-29T14:54:25.420Z
8549551 8549551 20251120223732_Ds9Ec UK00CT 2025-11-22T14:19:05.907Z 2025-11-29T14:54:24.970Z
8549206 8549206 20251120220604_Fqsl5 UK00CT 2025-11-22T14:18:31.522Z 2025-11-29T14:54:24.261Z
8549163 8549163 20251120220021_3WwBN UK00CT 2025-11-22T14:18:26.624Z 2025-11-29T14:54:24.137Z
8548966 8548966 20251120213923_NIqla UK00CT 2025-11-22T14:18:01.619Z 2025-11-29T14:54:23.787Z
8548948 8548948 20251120213442_jhCys UK00CT 2025-11-22T14:17:58.700Z 2025-11-29T14:54:23.673Z
8548920 8548920 20251120213051_qCHqq UK00CT 2025-11-22T14:17:56.298Z 2025-11-29T14:54:23.625Z
8548842 8548842 20251120212350_qI7i3 UK00CT 2025-11-22T14:17:49.188Z 2025-11-29T14:54:23.481Z
8548350 8548350 20251120205049_kfMeN UK00CT 2025-11-22T14:16:46.686Z 2025-11-29T14:54:22.465Z
8548124 8548124 20251120203802_jQYhG UK00CT 2025-11-22T14:16:20.390Z 2025-11-29T14:54:22.020Z
8546253 8546253 20251120181036_Vk7KB UK00CT 2025-11-22T14:12:13.380Z 2025-11-29T14:54:10.089Z
8539983 8539983 20251120002449_FIhDc UK00CT 2025-11-21T14:35:48.586Z 2025-11-28T14:56:02.738Z
8539822 8539822 20251120000844_eMhse UK00CT 2025-11-21T14:35:43.082Z 2025-11-28T14:55:58.095Z
8539646 8539646 20251119235401_hU4ub UK00CT 2025-11-21T14:35:37.594Z 2025-11-28T14:55:51.676Z
8539497 8539497 20251119234136_3bvqa UK00CT 2025-11-21T14:35:20.159Z 2025-11-28T14:55:49.025Z
8539440 8539440 20251119233811_Nun8z UK00CT 2025-11-21T14:35:05.096Z 2025-11-28T14:55:48.190Z
8539388 8539388 20251119233110_HAcaB UK00CT 2025-11-21T14:34:54.922Z 2025-11-28T14:55:47.778Z
8539100 8539100 20251119230153_OKWFM UK00CT 2025-11-21T14:34:45.653Z 2025-11-28T14:55:41.644Z
8538640 8538640 20251119215928_B49TO UK00CT 2025-11-21T14:34:30.174Z 2025-11-28T14:55:35.659Z
8538412 8538412 20251119212443_wFH0W UK00CT 2025-11-21T14:33:54.725Z 2025-11-28T14:55:27.761Z
8537788 8537788 20251119185318_jCAXh UK00CT 2025-11-21T14:33:07.600Z 2025-11-28T14:54:45.543Z
8537767 8537767 20251119184634_HtOyE UK00CT 2025-11-21T14:33:06.777Z 2025-11-28T14:54:44.958Z
8529987 8529987 20251117060704_Ajm1m UK00CT 2025-11-20T14:54:39.029Z 2025-11-25T15:10:58.199Z
8529985 8529985 20251117055916_yI0cc UK00CT 2025-11-20T14:54:33.453Z 2025-11-25T15:10:56.742Z
8529962 8529962 20251117014813_haO8K UK00CT 2025-11-20T14:52:10.345Z 2025-11-25T15:09:19.583Z
8529955 8529955 20251117010603_P3Rxc UK00CT 2025-11-20T14:51:43.857Z 2025-11-25T15:09:00.481Z
8529941 8529941 20251116220906_z7f8V UK00CT 2025-11-20T14:50:38.696Z 2025-11-25T15:08:35.694Z
8529937 8529937 20251116214051_9dIO8 UK00CT 2025-11-20T14:50:36.750Z 2025-11-25T15:08:33.284Z
8529934 8529934 20251116211607_cMz9J UK00CT 2025-11-20T14:50:34.220Z 2025-11-25T15:08:31.700Z
8529266 8529266 20251119062858_E5VDZ UK00CT 2025-11-20T14:44:47.902Z 2025-11-27T15:13:24.530Z
8529248 8529248 20251119062236_zlC73 UK00CT 2025-11-20T14:44:47.231Z 2025-11-27T15:13:24.073Z
8529225 8529225 20251119061208_aFWbe UK00CT 2025-11-20T14:44:45.870Z 2025-11-27T15:13:23.268Z
8529219 8529219 20251119061052_RaBDr UK00CT 2025-11-20T14:44:45.775Z 2025-11-27T15:13:23.263Z
8529094 8529094 20251119055040_MlYtJ UK00CT 2025-11-20T14:44:41.054Z 2025-11-27T15:13:21.852Z
8528946 8528946 20251119052949_l6D2G UK00CT 2025-11-20T14:44:23.729Z 2025-11-27T15:13:16.485Z
8528943 8528943 20251119052935_u1hlN UK00CT 2025-11-20T14:44:23.440Z 2025-11-20T14:44:23.440Z
8528881 8528881 20251119051903_NwRSz UK00CT 2025-11-20T14:44:05.482Z 2025-11-27T15:13:15.827Z
8528679 8528679 20251119044948_Tjq3A UK00CT 2025-11-20T14:43:39.273Z 2025-11-27T15:13:10.600Z
8528557 8528557 20251119043419_NTRZA UK00CT 2025-11-20T14:43:17.379Z 2025-11-27T15:13:07.167Z
8528517 8528517 20251119042920_hxMmm UK00CT 2025-11-20T14:43:12.225Z 2025-11-27T15:13:06.616Z
8528486 8528486 20251119042150_Vfm8q UK00CT 2025-11-20T14:43:01.875Z 2025-11-27T15:13:03.990Z
8528439 8528439 20251119041630_xiYUQ UK00CT 2025-11-20T14:42:52.534Z 2025-11-27T15:13:03.742Z
8528268 8528268 20251119035425_H3OtT UK00CT 2025-11-20T14:42:22.015Z 2025-11-27T15:12:57.445Z
8528224 8528224 20251119034321_LL6Yg UK00CT 2025-11-20T14:42:11.619Z 2025-11-20T14:42:11.619Z
8528082 8528082 20251119032228_IQKR6 UK00CT 2025-11-20T14:42:05.629Z 2025-11-27T15:12:47.284Z
8527664 8527664 20251119023327_W3X3e UK00CT 2025-11-20T14:41:53.613Z 2025-11-27T15:12:25.768Z
8527601 8527601 20251119022755_Y3h2t UK00CT 2025-11-20T14:41:51.921Z 2025-11-27T15:12:24.217Z
8527561 8527561 20251119022307_o2yFs UK00CT 2025-11-20T14:41:50.800Z 2025-11-27T15:12:23.104Z
8527391 8527391 20251119015255_DeM3U UK00CT 2025-11-20T14:41:34.675Z 2025-11-27T15:12:11.856Z
8527280 8527280 20251119013935_4xw1M UK00CT 2025-11-20T14:41:15.474Z 2025-11-27T15:12:10.120Z
8527220 8527220 20251119012958_Ml0HS UK00CT 2025-11-20T14:41:10.548Z 2025-11-27T15:12:09.129Z
8527153 8527153 20251119011142_wMWcI UK00CT 2025-11-20T14:40:55.871Z 2025-11-27T15:12:08.132Z
8498983 8498983 20251117042859_IKoiW UK00CT 2025-11-18T14:32:32.130Z 2025-11-25T15:10:12.816Z
8498782 8498782 20251116194345_N4l7G UK00CT 2025-11-18T14:31:33.681Z 2025-11-25T15:08:20.674Z
8498417 8498417 20251117063207_3uLvY UK00CT 2025-11-18T14:30:21.151Z 2025-11-25T15:11:03.854Z
8498338 8498338 20251117061955_4PoCb UK00CT 2025-11-18T14:30:05.032Z 2025-11-25T15:11:01.088Z
8498158 8498158 20251117060931_cMZ5C UK00CT 2025-11-18T14:29:49.335Z 2025-11-25T15:10:58.384Z
8498115 8498115 20251117060649_rQBFj UK00CT 2025-11-18T14:29:45.891Z 2025-11-18T14:29:45.891Z
8497789 8497789 20251117054910_b4rJx UK00CT 2025-11-18T14:29:30.853Z 2025-11-25T15:10:52.818Z
8497565 8497565 20251117053551_JWqP3 UK00CT 2025-11-18T14:29:06.057Z 2025-11-25T15:10:50.635Z
8497286 8497286 20251117052207_9XcMC UK00CT 2025-11-18T14:28:44.991Z 2025-11-25T15:10:40.631Z
8497097 8497097 20251117051214_ji7MY UK00CT 2025-11-18T14:28:37.601Z 2025-11-25T15:10:31.052Z
8496310 8496310 20251117043351_VMj7G UK00CT 2025-11-18T14:27:36.766Z 2025-11-25T15:10:12.947Z
8495562 8495562 20251117035632_sJL2l UK00CT 2025-11-18T14:26:20.381Z 2025-11-25T15:09:55.466Z
8494667 8494667 20251117030105_F3zUQ UK00CT 2025-11-18T14:24:42.881Z 2025-11-25T15:09:38.261Z
8494664 8494664 20251117030105_Yi2GA UK00CT 2025-11-18T14:24:42.620Z 2025-11-25T15:09:38.139Z
8494356 8494356 20251117024046_VPbGl UK00CT 2025-11-18T14:24:06.730Z 2025-11-25T15:09:35.058Z
8494062 8494062 20251117022522_DWwAD UK00CT 2025-11-18T14:23:32.880Z 2025-11-25T15:09:28.185Z
8493506 8493506 20251117014653_KhHbK UK00CT 2025-11-18T14:22:23.123Z 2025-11-25T15:09:19.370Z
8493140 8493140 20251117012143_tFmuu UK00CT 2025-11-18T14:21:23.529Z 2025-11-19T14:43:07.595Z

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