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,161 rows where station_code = "UK0090" 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
8683284 8683284 20251203065114_JU8xK UK0090 2025-12-04T14:19:04.431Z 2025-12-06T14:29:49.356Z
8683272 8683272 20251203064853_1u66r UK0090 2025-12-04T14:19:02.917Z 2025-12-06T14:29:48.859Z
8683261 8683261 20251203064710_kTU05 UK0090 2025-12-04T14:19:01.122Z 2025-12-06T14:29:48.475Z
8683236 8683236 20251203064415_MOYcr UK0090 2025-12-04T14:18:58.637Z 2025-12-06T14:29:47.033Z
8683211 8683211 20251203064042_Eqjg6 UK0090 2025-12-04T14:18:56.757Z 2025-12-06T14:29:46.216Z
8683118 8683118 20251203062811_Si9IK UK0090 2025-12-04T14:18:35.205Z 2025-12-06T14:29:41.809Z
8683100 8683100 20251203062758_uq4if UK0090 2025-12-04T14:18:34.878Z 2025-12-06T14:29:41.691Z
8682936 8682936 20251203061642_2fjWY UK0090 2025-12-04T14:18:22.461Z 2025-12-06T14:29:32.752Z
8682903 8682903 20251203061549_HKz8r UK0090 2025-12-04T14:18:19.780Z 2025-12-06T14:29:31.172Z
8682891 8682891 20251203061533_woNmB UK0090 2025-12-04T14:18:13.555Z 2025-12-06T14:29:30.910Z
8682839 8682839 20251203060931_2KzRb UK0090 2025-12-04T14:18:05.593Z 2025-12-06T14:29:27.217Z
8682576 8682576 20251203054630_dtMS3 UK0090 2025-12-04T14:17:28.500Z 2025-12-06T14:29:15.863Z
8680399 8680399 20251202234917_TBvLP UK0090 2025-12-04T14:11:55.803Z 2025-12-06T14:27:10.784Z
8680219 8680219 20251202223522_leIuZ UK0090 2025-12-04T14:11:26.286Z 2025-12-06T14:26:56.867Z
8676965 8676965 20251202063529_Xfr8P UK0090 2025-12-03T14:25:58.213Z 2025-12-06T14:35:31.903Z
8676955 8676955 20251202063438_2Pqjs UK0090 2025-12-03T14:25:57.935Z 2025-12-06T14:35:31.776Z
8676857 8676857 20251202062819_cXCQp UK0090 2025-12-03T14:25:53.586Z 2025-12-06T14:35:29.833Z
8676723 8676723 20251202061857_Gihpl UK0090 2025-12-03T14:25:31.037Z 2025-12-06T14:35:27.721Z
8676679 8676679 20251202061146_hjmEM UK0090 2025-12-03T14:25:25.849Z 2025-12-06T14:35:26.959Z
8676345 8676345 20251202054739_2BFSM UK0090 2025-12-03T14:25:07.293Z 2025-12-06T14:35:20.437Z
8676292 8676292 20251202054442_6oaPE UK0090 2025-12-03T14:24:57.050Z 2025-12-06T14:35:19.637Z
8675984 8675984 20251202052834_5X6sK UK0090 2025-12-03T14:24:34.937Z 2025-12-06T14:35:06.200Z
8675854 8675854 20251202051854_2wpXN UK0090 2025-12-03T14:24:26.186Z 2025-12-06T14:35:03.420Z
8675785 8675785 20251202051412_dSr97 UK0090 2025-12-03T14:24:15.116Z 2025-12-06T14:35:00.156Z
8675709 8675709 20251202051034_RQ5uj UK0090 2025-12-03T14:24:11.856Z 2025-12-06T14:34:59.144Z
8675615 8675615 20251202050215_fgICz UK0090 2025-12-03T14:23:56.044Z 2025-12-06T14:34:57.250Z
8675597 8675597 20251202050055_6Dvll UK0090 2025-12-03T14:23:54.310Z 2025-12-06T14:34:57.069Z
8675534 8675534 20251202045507_Lbzry UK0090 2025-12-03T14:23:50.385Z 2025-12-06T14:34:55.835Z
8675523 8675523 20251202045502_Hhe5v UK0090 2025-12-03T14:23:50.038Z 2025-12-06T14:34:55.702Z
8675456 8675456 20251202044345_NH7pB UK0090 2025-12-03T14:23:44.911Z 2025-12-06T14:34:53.628Z
8675330 8675330 20251202042845_MpkPe UK0090 2025-12-03T14:23:31.298Z 2025-12-06T14:34:49.534Z
8675263 8675263 20251202042435_Ih9Ow UK0090 2025-12-03T14:23:25.078Z 2025-12-06T14:34:48.448Z
8675254 8675254 20251202042334_s1H6e UK0090 2025-12-03T14:23:24.384Z 2025-12-06T14:34:48.244Z
8674943 8674943 20251202034221_W5IpE UK0090 2025-12-03T14:22:44.936Z 2025-12-06T14:34:23.978Z
8674653 8674653 20251202030352_gWsbT UK0090 2025-12-03T14:22:10.971Z 2025-12-06T14:34:14.798Z
8674574 8674574 20251202025126_I9vb1 UK0090 2025-12-03T14:22:03.234Z 2025-12-06T14:34:12.517Z
8674557 8674557 20251202024751_6uxkr UK0090 2025-12-03T14:22:00.498Z 2025-12-06T14:34:11.984Z
8674486 8674486 20251202023306_d0ZQJ UK0090 2025-12-03T14:21:41.830Z 2025-12-06T14:34:10.273Z
8674407 8674407 20251202021711_s36PP UK0090 2025-12-03T14:21:35.917Z 2025-12-06T14:34:08.216Z
8674296 8674296 20251202015717_ESaE0 UK0090 2025-12-03T14:21:22.344Z 2025-12-06T14:34:03.278Z
8661882 8661882 20251130172913_l3Hxl UK0090 2025-12-02T14:13:31.092Z 2025-12-06T14:38:40.830Z
8657891 8657891 20251130061417_O8PyF UK0090 2025-12-01T14:34:44.661Z 2025-12-06T14:50:23.473Z
8657683 8657683 20251130055922_zmZVu UK0090 2025-12-01T14:34:37.895Z 2025-12-06T14:50:19.554Z
8656075 8656075 20251130043513_7te73 UK0090 2025-12-01T14:28:01.105Z 2025-12-06T14:49:30.298Z
8655868 8655868 20251130042122_4iK7M UK0090 2025-12-01T14:27:33.669Z 2025-12-06T14:49:28.604Z
8655526 8655526 20251130040628_6jytl UK0090 2025-12-01T14:27:02.138Z 2025-12-06T14:49:24.928Z
8655246 8655246 20251130035011_RS3JE UK0090 2025-12-01T14:26:41.323Z 2025-12-01T14:26:41.323Z
8655239 8655239 20251130035002_brxYT UK0090 2025-12-01T14:26:41.013Z 2025-12-06T14:48:56.575Z
8655230 8655230 20251130034929_9fRqr UK0090 2025-12-01T14:26:40.302Z 2025-12-06T14:48:54.878Z
8654666 8654666 20251130032455_hrwcX UK0090 2025-12-01T14:25:42.517Z 2025-12-06T14:48:45.491Z
8654198 8654198 20251130030237_TlqLz UK0090 2025-12-01T14:24:57.176Z 2025-12-06T14:48:38.661Z
8653821 8653821 20251130024310_Cp2g2 UK0090 2025-12-01T14:24:19.145Z 2025-12-06T14:48:32.847Z
8653794 8653794 20251130024030_jleXC UK0090 2025-12-01T14:24:15.027Z 2025-12-06T14:48:32.170Z
8653648 8653648 20251130023317_5nbeo UK0090 2025-12-01T14:23:54.015Z 2025-12-06T14:48:24.331Z
8653609 8653609 20251130022911_LHJK2 UK0090 2025-12-01T14:23:47.106Z 2025-12-06T14:48:20.070Z
8653449 8653449 20251130021628_PTnyP UK0090 2025-12-01T14:23:32.077Z 2025-12-06T14:47:58.280Z
8653420 8653420 20251130021507_VJrBr UK0090 2025-12-01T14:23:22.170Z 2025-12-06T14:47:57.842Z
8653107 8653107 20251130015616_m3yDB UK0090 2025-12-01T14:22:49.354Z 2025-12-06T14:47:50.176Z
8652863 8652863 20251130014015_SSu3k UK0090 2025-12-01T14:22:16.328Z 2025-12-06T14:47:43.770Z
8652803 8652803 20251130013459_cjUBZ UK0090 2025-12-01T14:22:08.444Z 2025-12-06T14:47:42.718Z
8652765 8652765 20251130013220_0Jyfw UK0090 2025-12-01T14:22:06.351Z 2025-12-06T14:47:42.248Z
8652760 8652760 20251130013216_qw0gc UK0090 2025-12-01T14:22:05.887Z 2025-12-06T14:47:42.225Z
8652556 8652556 20251130012105_MVqeH UK0090 2025-12-01T14:21:41.087Z 2025-12-06T14:47:39.399Z
8652438 8652438 20251130010923_CsMTu UK0090 2025-12-01T14:21:23.718Z 2025-12-06T14:47:37.110Z
8652090 8652090 20251130004525_bhiWo UK0090 2025-12-01T14:20:41.895Z 2025-12-06T14:47:13.440Z
8652038 8652038 20251130004255_EBx6X UK0090 2025-12-01T14:20:30.976Z 2025-12-06T14:47:06.227Z
8651824 8651824 20251130002431_NGX61 UK0090 2025-12-01T14:20:05.648Z 2025-12-06T14:46:54.769Z
8651754 8651754 20251130001635_FDdU7 UK0090 2025-12-01T14:19:49.199Z 2025-12-06T14:46:53.384Z
8651578 8651578 20251129235738_j0XV4 UK0090 2025-12-01T14:19:23.659Z 2025-12-06T14:46:48.732Z
8644937 8644937 20251128201653_S5A2w UK0090 2025-11-30T14:22:53.394Z 2025-12-06T14:54:49.207Z
8644932 8644932 20251128201652_YVnge UK0090 2025-11-30T14:22:53.284Z 2025-12-06T14:54:49.157Z
8644115 8644115 20251128185931_XCOFs UK0090 2025-11-30T14:21:21.560Z 2025-12-06T14:54:38.381Z
8643586 8643586 20251128180802_8crWN UK0090 2025-11-30T14:20:14.849Z 2025-12-06T14:53:51.696Z
8642984 8642984 20251128170924_xQG2f UK0090 2025-11-30T14:19:11.337Z 2025-12-06T14:53:38.963Z
8637738 8637738 20251128062841_P3ig0 UK0090 2025-11-29T14:27:47.122Z 2025-12-06T15:04:03.644Z
8637432 8637432 20251128054001_CUn6G UK0090 2025-11-29T14:27:14.680Z 2025-12-06T15:04:00.087Z
8637219 8637219 20251128051634_2GqEc UK0090 2025-11-29T14:26:58.600Z 2025-12-06T15:03:57.756Z
8637077 8637077 20251128045747_gimOj UK0090 2025-11-29T14:26:49.054Z 2025-12-06T15:03:56.251Z
8636598 8636598 20251128040813_cA8rU UK0090 2025-11-29T14:25:44.400Z 2025-12-06T15:03:32.054Z
8636517 8636517 20251128035515_39ifw UK0090 2025-11-29T14:25:36.713Z 2025-12-06T15:03:22.992Z
8636480 8636480 20251128035008_I8Zkr UK0090 2025-11-29T14:25:33.257Z 2025-12-06T15:03:20.068Z
8636355 8636355 20251128033833_4Q2iC UK0090 2025-11-29T14:25:24.537Z 2025-12-06T15:03:09.352Z
8636330 8636330 20251128033722_TWEYv UK0090 2025-11-29T14:25:23.249Z 2025-12-06T15:03:07.429Z
8636203 8636203 20251128032753_X1jun UK0090 2025-11-29T14:25:04.593Z 2025-12-06T15:02:59.402Z
8636170 8636170 20251128032601_nV5z9 UK0090 2025-11-29T14:24:59.488Z 2025-12-06T15:02:56.999Z
8635979 8635979 20251128030353_wZsdA UK0090 2025-11-29T14:24:43.218Z 2025-12-06T15:02:54.737Z
8635420 8635420 20251128021237_lfVy6 UK0090 2025-11-29T14:23:22.774Z 2025-12-06T15:02:44.371Z
8635416 8635416 20251128021107_fqdHM UK0090 2025-11-29T14:23:22.603Z 2025-12-06T15:02:44.312Z
8635414 8635414 20251128021049_pENuY UK0090 2025-11-29T14:23:22.138Z 2025-12-06T15:02:44.287Z
8635316 8635316 20251128020327_2w7Wq UK0090 2025-11-29T14:23:03.233Z 2025-12-06T15:02:43.359Z
8635290 8635290 20251128020039_tfP20 UK0090 2025-11-29T14:23:00.945Z 2025-12-06T15:02:43.019Z
8635234 8635234 20251128015601_ZZJup UK0090 2025-11-29T14:22:52.731Z 2025-12-06T15:02:42.150Z
8634274 8634274 20251128003348_nihnO UK0090 2025-11-29T14:21:09.231Z 2025-12-06T15:01:57.573Z
8634197 8634197 20251128003023_HX8Ht UK0090 2025-11-29T14:20:54.590Z 2025-12-06T15:01:52.049Z
8633716 8633716 20251127234823_Bi6td UK0090 2025-11-29T14:20:07.358Z 2025-12-06T15:01:48.060Z
8633697 8633697 20251127234622_QdQnL UK0090 2025-11-29T14:20:06.723Z 2025-12-06T15:01:47.996Z
8633614 8633614 20251127233952_PwfEQ UK0090 2025-11-29T14:19:58.780Z 2025-12-06T15:01:46.113Z
8633596 8633596 20251127233659_HbSNR UK0090 2025-11-29T14:19:57.428Z 2025-12-06T15:01:46.020Z
8632757 8632757 20251127215037_Kt0TE UK0090 2025-11-29T14:18:19.355Z 2025-12-06T15:01:33.110Z
8632733 8632733 20251127214527_xLkUq UK0090 2025-11-29T14:18:08.941Z 2025-12-06T15:01:32.888Z

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