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

775 rows where station_code = "UK003K" 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
9251672 9251672 20260122215129_QEvHe UK003K 2026-01-24T14:12:48.507Z 2026-01-29T14:51:58.226Z
9228421 9228421 20260118221446_En12N UK003K 2026-01-20T14:17:43.879Z 2026-01-27T15:02:00.226Z
9200548 9200548 20260114002243_AIer3 UK003K 2026-01-15T14:15:30.503Z 2026-01-22T15:08:18.070Z
9174692 9174692 20260109214309_iy7Nr UK003K 2026-01-11T14:04:03.840Z 2026-01-18T15:07:01.079Z
9158912 9158912 20260106005103_vCJAG UK003K 2026-01-07T14:07:37.796Z 2026-01-13T15:07:50.304Z
9158546 9158546 20260105230915_ucb2N UK003K 2026-01-07T14:06:29.122Z 2026-01-13T15:07:29.037Z
9158514 9158514 20260105225315_KFZaT UK003K 2026-01-07T14:06:22.084Z 2026-01-13T15:07:25.912Z
9158465 9158465 20260105223403_hthTe UK003K 2026-01-07T14:06:11.207Z 2026-01-13T15:07:23.665Z
9139955 9139955 20260103235157_tUYa7 UK003K 2026-01-05T14:12:18.618Z 2026-01-12T15:03:54.353Z
9139887 9139887 20260103235005_KhyV1 UK003K 2026-01-05T14:12:15.842Z 2026-01-12T15:03:52.873Z
9139661 9139661 20260103233841_GOSla UK003K 2026-01-05T14:11:54.696Z 2026-01-12T15:03:40.562Z
9139227 9139227 20260103232111_ZV0mC UK003K 2026-01-05T14:11:21.686Z 2026-01-12T15:03:23.884Z
9138784 9138784 20260103225343_7GnG2 UK003K 2026-01-05T14:10:38.586Z 2026-01-12T15:03:00.153Z
9138264 9138264 20260103221349_aHzTY UK003K 2026-01-05T14:09:45.138Z 2026-01-12T15:02:44.741Z
9137849 9137849 20260103213700_qtUCb UK003K 2026-01-05T14:08:59.734Z 2026-01-12T15:02:21.301Z
9137712 9137712 20260103212637_v3KxZ UK003K 2026-01-05T14:08:51.606Z 2026-01-12T15:02:17.245Z
9128113 9128113 20260102061653_BfL9G UK003K 2026-01-03T14:13:22.396Z 2026-01-09T14:50:25.340Z
9044177 9044177 20251222231634_CnQxm UK003K 2025-12-28T14:48:50.310Z 2025-12-31T15:42:05.999Z
9028142 9028142 20251225025016_akLte UK003K 2025-12-28T14:13:10.175Z 2025-12-29T14:55:14.168Z
9026856 9026856 20251225013746_Oo2F1 UK003K 2025-12-28T14:09:13.598Z 2026-01-02T15:43:03.498Z
9024913 9024913 20251224231545_ZHnTE UK003K 2025-12-28T14:02:44.090Z 2026-01-02T15:42:08.018Z
9024638 9024638 20251224224915_zWKif UK003K 2025-12-28T14:01:22.739Z 2026-01-02T15:42:02.477Z
9024562 9024562 20251224223536_GX6k3 UK003K 2025-12-28T14:01:03.372Z 2025-12-29T14:51:41.223Z
9024412 9024412 20251224221612_erjmY UK003K 2025-12-28T14:00:23.087Z 2026-01-02T15:41:57.182Z
8971057 8971057 20251216233728_nzoIO UK003K 2025-12-25T14:53:33.422Z 2025-12-25T14:53:33.422Z
8897366 8897366 20251214024828_K2oF8 UK003K 2025-12-22T14:12:23.277Z 2025-12-23T14:27:58.514Z
8889601 8889601 20251214014610_fzSWc UK003K 2025-12-22T14:11:37.868Z 2025-12-23T14:27:44.000Z
8888169 8888169 20251214013406_oLTm7 UK003K 2025-12-22T14:11:31.868Z 2025-12-23T14:27:41.332Z
8886453 8886453 20251214012018_nJPlb UK003K 2025-12-22T14:11:18.322Z 2025-12-23T14:27:38.823Z
8885761 8885761 20251214011455_wtXX2 UK003K 2025-12-22T14:11:13.409Z 2025-12-23T14:27:37.842Z
8873412 8873412 20251214010523_mvzUP UK003K 2025-12-21T14:11:01.432Z 2025-12-21T14:17:17.793Z
8871901 8871901 20251214005510_Z1rM3 UK003K 2025-12-21T14:10:48.667Z 2025-12-23T14:27:34.607Z
8871641 8871641 20251214005347_QaTKV UK003K 2025-12-21T14:10:45.736Z 2025-12-23T14:27:34.305Z
8871335 8871335 20251214005146_UFmBp UK003K 2025-12-21T14:10:43.704Z 2025-12-23T14:27:33.871Z
8871280 8871280 20251214005127_OWqqY UK003K 2025-12-21T14:10:43.262Z 2025-12-23T14:27:33.794Z
8871095 8871095 20251214005000_DeV6O UK003K 2025-12-21T14:10:41.357Z 2025-12-21T14:17:16.608Z
8870196 8870196 20251214004353_RsVgb UK003K 2025-12-21T14:10:30.944Z 2025-12-23T14:27:31.860Z
8869281 8869281 20251214003742_8Vi22 UK003K 2025-12-21T14:10:21.906Z 2025-12-23T14:27:31.001Z
8867945 8867945 20251214002831_SO1NM UK003K 2025-12-21T14:10:07.899Z 2025-12-23T14:27:29.267Z
8867373 8867373 20251214002232_TK1dR UK003K 2025-12-21T14:10:04.282Z 2025-12-23T14:27:25.468Z
8867152 8867152 20251214001951_8u9u3 UK003K 2025-12-21T14:10:02.869Z 2025-12-21T14:17:14.063Z
8866032 8866032 20251214000304_AZrQG UK003K 2025-12-21T14:09:54.804Z 2025-12-23T14:26:50.661Z
8865812 8865812 20251214000003_FFgY3 UK003K 2025-12-21T14:09:53.521Z 2025-12-23T14:26:42.999Z
8865380 8865380 20251213235138_kAdB2 UK003K 2025-12-21T14:09:49.397Z 2025-12-23T14:26:33.013Z
8865343 8865343 20251213235116_vVKWu UK003K 2025-12-21T14:09:48.924Z 2025-12-23T14:26:32.734Z
8864994 8864994 20251213234552_JELYO UK003K 2025-12-21T14:09:46.579Z 2025-12-23T14:26:25.007Z
8857803 8857803 20251213235138_6alrS UK003K 2025-12-20T14:13:34.915Z 2025-12-23T14:26:33.016Z
8857349 8857349 20251213234552_ivAKG UK003K 2025-12-20T14:13:20.749Z 2025-12-20T14:21:21.056Z
8854221 8854221 20251213031709_FG3Xc UK003K 2025-12-19T14:49:20.894Z 2025-12-21T14:17:38.388Z
8853591 8853591 20251214002232_DpkTK UK003K 2025-12-19T14:22:44.377Z 2025-12-23T14:27:25.472Z
8853515 8853515 20251214002146_I234a UK003K 2025-12-19T14:22:40.863Z 2025-12-23T14:27:23.733Z
8853280 8853280 20251214001939_seIjO UK003K 2025-12-19T14:22:37.674Z 2025-12-23T14:27:19.969Z
8852748 8852748 20251214001520_36Dfw UK003K 2025-12-19T14:22:25.363Z 2025-12-23T14:27:09.809Z
8851576 8851576 20251214000304_Jvdht UK003K 2025-12-19T14:21:15.698Z 2025-12-23T14:26:50.664Z
8851230 8851230 20251214000003_3f3fS UK003K 2025-12-19T14:20:59.506Z 2025-12-23T14:26:43.001Z
8850410 8850410 20251213235138_r0XLg UK003K 2025-12-19T14:20:21.234Z 2025-12-19T14:49:55.567Z
8850354 8850354 20251213235115_3TKNu UK003K 2025-12-19T14:20:11.537Z 2025-12-23T14:26:32.732Z
8849749 8849749 20251213234552_UyY6T UK003K 2025-12-19T14:19:52.431Z 2025-12-19T14:49:55.371Z
8790842 8790842 20251213033610_Jq7bE UK003K 2025-12-16T14:02:38.765Z 2025-12-23T14:16:22.220Z
8789184 8789184 20251213030745_y5koR UK003K 2025-12-15T14:39:34.562Z 2025-12-21T14:17:38.115Z
8788998 8788998 20251213030505_k0IgU UK003K 2025-12-15T14:39:30.839Z 2025-12-21T14:17:38.031Z
8787674 8787674 20251213024702_mSrqX UK003K 2025-12-15T14:38:24.192Z 2025-12-21T14:17:37.420Z
8786822 8786822 20251213023601_TyHmI UK003K 2025-12-15T14:37:44.794Z 2025-12-21T14:17:36.953Z
8786664 8786664 20251213023316_stWF3 UK003K 2025-12-15T14:37:41.822Z 2025-12-21T14:17:36.863Z
8786649 8786649 20251213023308_6q27i UK003K 2025-12-15T14:37:40.340Z 2025-12-21T14:17:36.851Z
8786486 8786486 20251213023114_Cs9O2 UK003K 2025-12-15T14:37:37.202Z 2025-12-21T14:17:36.761Z
8786363 8786363 20251213022911_MQ7bS UK003K 2025-12-15T14:37:33.853Z 2025-12-21T14:17:36.696Z
8785935 8785935 20251213022252_e3FJx UK003K 2025-12-15T14:37:08.487Z 2025-12-21T14:17:36.477Z
8785544 8785544 20251213021659_n3aPW UK003K 2025-12-15T14:36:56.677Z 2025-12-21T14:17:36.237Z
8785356 8785356 20251213021401_DE21K UK003K 2025-12-15T14:36:51.011Z 2025-12-21T14:17:36.120Z
8784944 8784944 20251213020641_nUvHy UK003K 2025-12-15T14:36:06.134Z 2025-12-21T14:17:35.882Z
8784916 8784916 20251213020616_xbXCz UK003K 2025-12-15T14:36:05.652Z 2025-12-21T14:17:35.862Z
8784710 8784710 20251213020311_dYZgR UK003K 2025-12-15T14:35:47.417Z 2025-12-21T14:17:35.723Z
8784005 8784005 20251213015409_TScjM UK003K 2025-12-15T14:35:34.239Z 2025-12-21T14:17:35.346Z
8783258 8783258 20251213013957_8NKkc UK003K 2025-12-15T14:34:34.577Z 2025-12-21T14:17:34.822Z
8782672 8782672 20251213013204_HcdAG UK003K 2025-12-15T14:34:20.177Z 2025-12-21T14:17:34.447Z
8782572 8782572 20251213013012_VSD3x UK003K 2025-12-15T14:34:18.470Z 2025-12-21T14:17:34.383Z
8782380 8782380 20251213012747_ydRPR UK003K 2025-12-15T14:34:15.840Z 2025-12-21T14:17:34.281Z
8778791 8778791 20251213003038_CLT2R UK003K 2025-12-15T14:31:16.695Z 2025-12-21T14:17:32.343Z
8778070 8778070 20251213001832_mB1uT UK003K 2025-12-15T14:30:58.622Z 2025-12-21T14:17:31.935Z
8777788 8777788 20251213001157_Oyt1a UK003K 2025-12-15T14:30:33.147Z 2025-12-21T14:17:31.741Z
8777470 8777470 20251213000600_7oUUE UK003K 2025-12-15T14:30:23.399Z 2025-12-21T14:17:31.522Z
8775477 8775477 20251212232746_WR24r UK003K 2025-12-15T14:28:10.134Z 2025-12-21T14:17:30.353Z
8775323 8775323 20251212232402_2728i UK003K 2025-12-15T14:27:59.790Z 2025-12-21T14:17:30.255Z
8774455 8774455 20251212230338_JzZ2s UK003K 2025-12-15T14:27:05.867Z 2025-12-21T14:17:29.737Z
8773792 8773792 20251212224733_9nkbk UK003K 2025-12-15T14:26:38.675Z 2025-12-21T14:17:29.287Z
8744836 8744836 20251211011236_H302r UK003K 2025-12-13T15:26:44.044Z 2025-12-19T15:15:12.033Z
8744792 8744792 20251211010922_X5O4e UK003K 2025-12-13T15:26:42.527Z 2025-12-19T15:15:11.164Z
8744564 8744564 20251211005348_RKq3B UK003K 2025-12-13T15:26:17.550Z 2025-12-19T15:14:47.271Z
8681255 8681255 20251203025126_E6gxu UK003K 2025-12-04T14:14:11.952Z 2025-12-11T14:46:26.218Z
8681093 8681093 20251203022219_LqeBF UK003K 2025-12-04T14:13:49.532Z 2025-12-11T14:46:22.245Z
8680949 8680949 20251203015742_G0dTy UK003K 2025-12-04T14:13:25.825Z 2025-12-11T14:45:55.562Z
8655150 8655150 20251130034624_vlJCt UK003K 2025-12-01T14:26:35.965Z 2025-12-08T14:55:54.318Z
8655042 8655042 20251130034144_dBgfQ UK003K 2025-12-01T14:26:17.893Z 2025-12-08T14:55:45.071Z
8652665 8652665 20251130012636_YX2YB UK003K 2025-12-01T14:21:56.823Z 2025-12-08T14:54:22.700Z
8652524 8652524 20251130011456_RlEc7 UK003K 2025-12-01T14:21:38.269Z 2025-12-08T14:54:20.444Z
8652450 8652450 20251130010938_YY7t1 UK003K 2025-12-01T14:21:24.853Z 2025-12-08T14:54:19.250Z
8652362 8652362 20251130010408_5KLjK UK003K 2025-12-01T14:21:18.301Z 2025-12-08T14:54:18.075Z
8613821 8613821 20251126033512_cKLXT UK003K 2025-11-27T14:26:49.188Z 2025-12-04T15:09:52.119Z
8611971 8611971 20251126021121_F2Jaq UK003K 2025-11-27T14:23:10.759Z 2025-12-04T15:09:26.416Z

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