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

3,751 rows where station_code = "UK00CS" 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
9237274 9237274 20260120045635_1wTQN UK00CS 2026-01-21T14:25:49.682Z 2026-01-28T15:01:07.293Z
9234223 9234223 20260119200950_tA6P7 UK00CS 2026-01-21T14:13:04.416Z 2026-01-28T14:57:22.818Z
9233978 9233978 20260119190613_3l5Ni UK00CS 2026-01-21T14:11:36.354Z 2026-01-28T14:56:56.830Z
9231251 9231251 20260119065245_Z3SVy UK00CS 2026-01-20T14:32:01.457Z 2026-01-27T15:06:09.720Z
9231230 9231230 20260119064049_aVo7M UK00CS 2026-01-20T14:31:56.092Z 2026-01-27T15:06:08.098Z
9231202 9231202 20260119063004_LDlXF UK00CS 2026-01-20T14:31:50.776Z 2026-01-27T15:06:05.105Z
9231140 9231140 20260119061058_ZK8Wa UK00CS 2026-01-20T14:31:31.074Z 2026-01-27T15:06:00.969Z
9231083 9231083 20260119055852_aEAIV UK00CS 2026-01-20T14:31:09.836Z 2026-01-27T15:05:56.974Z
9231020 9231020 20260119054449_roLO1 UK00CS 2026-01-20T14:30:55.917Z 2026-01-27T15:05:53.192Z
9230932 9230932 20260119052957_WobDL UK00CS 2026-01-20T14:30:30.647Z 2026-01-27T15:05:37.178Z
9230524 9230524 20260119042945_zgLj5 UK00CS 2026-01-20T14:28:21.978Z 2026-01-27T15:05:01.112Z
9230503 9230503 20260119042739_gdrex UK00CS 2026-01-20T14:28:12.008Z 2026-01-27T15:04:59.887Z
9230364 9230364 20260119040738_hAa6v UK00CS 2026-01-20T14:27:27.626Z 2026-01-27T15:04:50.551Z
9230289 9230289 20260119035314_4Upm3 UK00CS 2026-01-20T14:27:04.383Z 2026-01-27T15:04:46.506Z
9230016 9230016 20260119030937_3R9YA UK00CS 2026-01-20T14:25:27.871Z 2026-01-27T15:04:20.371Z
9229978 9229978 20260119030302_guO7y UK00CS 2026-01-20T14:25:15.058Z 2026-01-27T15:04:17.729Z
9229908 9229908 20260119025517_yQhLa UK00CS 2026-01-20T14:24:57.254Z 2026-01-27T15:04:14.389Z
9229514 9229514 20260119015612_tJf3A UK00CS 2026-01-20T14:22:54.325Z 2026-01-27T15:03:39.748Z
9228541 9228541 20260118224543_gFUp2 UK00CS 2026-01-20T14:18:13.085Z 2026-01-27T15:02:06.471Z
9228454 9228454 20260118222556_CcbsF UK00CS 2026-01-20T14:17:53.092Z 2026-01-27T15:02:02.195Z
9224825 9224825 20260118060950_h09EQ UK00CS 2026-01-19T14:26:17.778Z 2026-01-26T15:03:50.368Z
9224817 9224817 20260118060839_BfyBR UK00CS 2026-01-19T14:26:15.316Z 2026-01-26T15:03:49.943Z
9224609 9224609 20260118052025_BXgFr UK00CS 2026-01-19T14:25:10.511Z 2026-01-26T15:03:39.408Z
9224566 9224566 20260118051348_bzC0y UK00CS 2026-01-19T14:24:59.194Z 2026-01-26T15:03:23.982Z
9224548 9224548 20260118051108_3gkn1 UK00CS 2026-01-19T14:24:51.974Z 2026-01-26T15:03:23.240Z
9224458 9224458 20260118044945_xGiR3 UK00CS 2026-01-19T14:24:31.493Z 2026-01-26T15:03:19.809Z
9224426 9224426 20260118044222_hs1EX UK00CS 2026-01-19T14:24:20.839Z 2026-01-26T15:03:18.471Z
9224415 9224415 20260118043752_aHq14 UK00CS 2026-01-19T14:24:15.618Z 2026-01-26T15:03:17.959Z
9224374 9224374 20260118042811_8qlDJ UK00CS 2026-01-19T14:24:07.332Z 2026-01-26T15:03:16.195Z
9224199 9224199 20260118035116_yDMd8 UK00CS 2026-01-19T14:23:18.442Z 2026-01-26T15:03:08.637Z
9224094 9224094 20260118032350_6zkJ3 UK00CS 2026-01-19T14:22:48.379Z 2026-01-26T15:02:55.492Z
9223994 9223994 20260118030620_260qN UK00CS 2026-01-19T14:22:20.131Z 2026-01-26T15:02:47.291Z
9223990 9223990 20260118030537_385Vn UK00CS 2026-01-19T14:22:13.671Z 2026-01-26T15:02:47.085Z
9223988 9223988 20260118030536_3zKni UK00CS 2026-01-19T14:22:13.127Z 2026-01-26T15:02:46.978Z
9223909 9223909 20260118024758_3JrDu UK00CS 2026-01-19T14:21:48.110Z 2026-01-26T15:02:41.173Z
9223632 9223632 20260118015033_iX7pX UK00CS 2026-01-19T14:20:19.888Z 2026-01-26T15:02:30.048Z
9223602 9223602 20260118013850_xJPmS UK00CS 2026-01-19T14:20:08.257Z 2026-01-26T15:02:28.815Z
9223233 9223233 20260117235016_dOWPB UK00CS 2026-01-19T14:18:19.928Z 2026-01-26T15:01:58.814Z
9223203 9223203 20260117234456_D0NvW UK00CS 2026-01-19T14:18:13.887Z 2026-01-26T15:01:57.803Z
9213457 9213457 20260116034019_SDEjU UK00CS 2026-01-17T14:17:00.435Z 2026-01-24T15:12:15.345Z
9213425 9213425 20260116033004_HV16Z UK00CS 2026-01-17T14:16:51.213Z 2026-01-24T15:12:13.271Z
9213347 9213347 20260116031634_GB3VG UK00CS 2026-01-17T14:16:32.029Z 2026-01-24T15:12:10.309Z
9213060 9213060 20260116020424_T3EiC UK00CS 2026-01-17T14:15:12.818Z 2026-01-24T15:11:38.940Z
9212745 9212745 20260116004544_wVXv3 UK00CS 2026-01-17T14:13:36.170Z 2026-01-24T15:11:24.652Z
9212687 9212687 20260116002304_9bd7D UK00CS 2026-01-17T14:13:18.894Z 2026-01-24T15:11:10.045Z
9212556 9212556 20260115231226_Vnet1 UK00CS 2026-01-17T14:12:41.639Z 2026-01-24T15:11:02.959Z
9212510 9212510 20260115222424_oVBU0 UK00CS 2026-01-17T14:12:20.159Z 2026-01-24T15:10:59.194Z
9212459 9212459 20260115213334_ostw3 UK00CS 2026-01-17T14:11:58.456Z 2026-01-24T15:10:55.542Z
9211743 9211743 20260115173443_Mi1ok UK00CS 2026-01-17T14:08:10.415Z 2026-01-24T15:09:50.477Z
9208698 9208698 20260115063259_93oNs UK00CS 2026-01-16T14:13:42.384Z 2026-01-22T15:04:37.621Z
9208643 9208643 20260115061835_IVEei UK00CS 2026-01-16T14:13:28.519Z 2026-01-22T15:04:35.970Z
9208589 9208589 20260115060501_JqKCJ UK00CS 2026-01-16T14:13:15.674Z 2026-01-22T15:04:34.519Z
9208542 9208542 20260115055625_4raTw UK00CS 2026-01-16T14:13:07.496Z 2026-01-22T15:04:33.497Z
9208529 9208529 20260115055427_O0KOg UK00CS 2026-01-16T14:13:05.252Z 2026-01-22T15:04:32.869Z
9208443 9208443 20260115052558_ZYEqu UK00CS 2026-01-16T14:12:42.685Z 2026-01-22T15:04:14.041Z
9208433 9208433 20260115051953_bEi5x UK00CS 2026-01-16T14:12:38.943Z 2026-01-22T15:04:13.575Z
9208421 9208421 20260115051848_2Thav UK00CS 2026-01-16T14:12:36.616Z 2026-01-22T15:04:13.369Z
9208407 9208407 20260115051650_QIbHI UK00CS 2026-01-16T14:12:33.443Z 2026-01-22T15:04:12.884Z
9203840 9203840 20260114054359_GkrKS UK00CS 2026-01-15T14:25:39.908Z 2026-01-22T15:10:14.263Z
9203452 9203452 20260114045822_DIWzN UK00CS 2026-01-15T14:24:28.082Z 2026-01-22T15:10:08.066Z
9203281 9203281 20260114044743_2eNaK UK00CS 2026-01-15T14:23:56.538Z 2026-01-22T15:10:04.877Z
9203104 9203104 20260114043254_04qEB UK00CS 2026-01-15T14:23:18.535Z 2026-01-22T15:10:01.554Z
9202831 9202831 20260114041101_RoXSI UK00CS 2026-01-15T14:22:28.951Z 2026-01-22T15:09:53.319Z
9202284 9202284 20260114032604_P4EEE UK00CS 2026-01-15T14:20:52.698Z 2026-01-22T15:09:15.758Z
9201406 9201406 20260114021430_8yR7D UK00CS 2026-01-15T14:18:34.151Z 2026-01-22T15:09:03.102Z
9200932 9200932 20260114012308_McWSE UK00CS 2026-01-15T14:17:02.296Z 2026-01-22T15:08:39.429Z
9199809 9199809 20260113212209_sswT7 UK00CS 2026-01-15T14:12:34.981Z 2026-01-22T15:08:02.456Z
9199799 9199799 20260113211907_oDsEw UK00CS 2026-01-15T14:12:32.381Z 2026-01-22T15:08:02.148Z
9199617 9199617 20260113203703_9KeQg UK00CS 2026-01-15T14:11:41.181Z 2026-01-22T15:07:48.660Z
9199151 9199151 20260113191143_ZFHDc UK00CS 2026-01-15T14:09:31.798Z 2026-01-22T15:07:15.139Z
9174869 9174869 20260109233936_wwe3F UK00CS 2026-01-11T14:04:39.543Z 2026-01-18T15:07:14.601Z
9162983 9162983 20260107052023_5vhqs UK00CS 2026-01-08T14:07:38.734Z 2026-01-13T15:02:50.526Z
9162818 9162818 20260107043936_7XdeJ UK00CS 2026-01-08T14:06:59.542Z 2026-01-13T15:02:40.821Z
9162404 9162404 20260107024027_WuFJb UK00CS 2026-01-08T14:04:59.448Z 2026-01-13T15:02:07.324Z
9162346 9162346 20260107021903_c1tf1 UK00CS 2026-01-08T14:04:40.004Z 2026-01-13T15:02:03.303Z
9162333 9162333 20260107021008_3uolk UK00CS 2026-01-08T14:04:36.023Z 2026-01-13T15:02:02.203Z
9162108 9162108 20260106212459_F8oI1 UK00CS 2026-01-08T14:02:58.799Z 2026-01-13T15:01:36.279Z
9162097 9162097 20260106210642_dLMNF UK00CS 2026-01-08T14:02:53.003Z 2026-01-13T15:01:35.599Z
9162095 9162095 20260106210542_ltEsV UK00CS 2026-01-08T14:02:51.774Z 2026-01-13T15:01:35.454Z
9153163 9153163 20260103231735_LaIsO UK00CS 2026-01-06T14:24:49.506Z 2026-01-12T15:03:23.043Z
9151379 9151379 20260105052607_IOKUn UK00CS 2026-01-06T14:13:32.408Z 2026-01-13T15:14:40.525Z
9150990 9150990 20260105041205_pFIU5 UK00CS 2026-01-06T14:12:15.997Z 2026-01-13T15:14:12.726Z
9150979 9150979 20260105041013_50OTl UK00CS 2026-01-06T14:12:13.222Z 2026-01-13T15:14:12.121Z
9150974 9150974 20260105040933_DUHuO UK00CS 2026-01-06T14:12:11.409Z 2026-01-13T15:14:11.580Z
9150935 9150935 20260105040215_br9iU UK00CS 2026-01-06T14:12:01.708Z 2026-01-13T15:14:09.253Z
9150919 9150919 20260105035904_YGzGZ UK00CS 2026-01-06T14:11:56.860Z 2026-01-13T15:14:08.336Z
9150810 9150810 20260105033434_4wvrF UK00CS 2026-01-06T14:11:30.360Z 2026-01-13T15:14:02.169Z
9150674 9150674 20260105030512_39B27 UK00CS 2026-01-06T14:10:56.235Z 2026-01-13T15:13:48.254Z
9150480 9150480 20260105022155_S27Rw UK00CS 2026-01-06T14:10:11.675Z 2026-01-13T15:13:35.036Z
9150435 9150435 20260105021248_6qsae UK00CS 2026-01-06T14:10:01.583Z 2026-01-13T15:13:32.671Z
9150406 9150406 20260105020701_kZrBo UK00CS 2026-01-06T14:09:53.530Z 2026-01-13T15:13:23.707Z
9150398 9150398 20260105020403_2q885 UK00CS 2026-01-06T14:09:51.349Z 2026-01-13T15:13:23.076Z
9150350 9150350 20260105015346_ZtQRg UK00CS 2026-01-06T14:09:42.162Z 2026-01-13T15:13:19.798Z
9150260 9150260 20260105014124_t2fKc UK00CS 2026-01-06T14:09:20.062Z 2026-01-13T15:13:13.800Z
9149909 9149909 20260105001019_Cyemi UK00CS 2026-01-06T14:07:47.406Z 2026-01-13T15:12:45.299Z
9149820 9149820 20260104234308_eZC8H UK00CS 2026-01-06T14:07:19.217Z 2026-01-13T15:12:40.984Z
9149721 9149721 20260104231044_gGKLY UK00CS 2026-01-06T14:06:52.596Z 2026-01-13T15:12:35.628Z
9149614 9149614 20260104223305_2H4WU UK00CS 2026-01-06T14:06:18.160Z 2026-01-13T15:12:22.437Z
9149596 9149596 20260104221819_3EljM UK00CS 2026-01-06T14:06:14.847Z 2026-01-13T15:12:21.573Z
9149555 9149555 20260104214943_pS3R3 UK00CS 2026-01-06T14:05:59.655Z 2026-01-13T15:12:17.652Z

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