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

4,557 rows where station_code = "UK0082" 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
7024916 7024916 20250703001930_UU3Sv UK0082 2025-07-04T12:00:26.679Z 2025-07-12T12:55:25.694Z
6814124 6814124 20250527012653_rdLkk UK0082 2025-05-28T12:16:09.841Z 2025-06-04T13:02:53.481Z
6813958 6813958 20250527002842_CcVf5 UK0082 2025-05-28T12:15:24.276Z 2025-06-04T13:02:35.065Z
6809398 6809398 20250526001157_7bMj6 UK0082 2025-05-27T12:16:19.574Z 2025-06-03T13:03:12.026Z
6787932 6787932 20250523010539_l1FV2 UK0082 2025-05-24T12:21:42.041Z 2025-05-31T13:14:48.841Z
6786812 6786812 20250522225826_csn1u UK0082 2025-05-24T12:19:33.163Z 2025-05-31T13:13:47.673Z
6780307 6780307 20250521234405_MYi0G UK0082 2025-05-23T12:23:45.242Z 2025-05-30T13:09:13.470Z
6770859 6770859 20250521002519_hFhHs UK0082 2025-05-22T12:22:22.873Z 2025-05-29T13:09:21.115Z
6770798 6770798 20250521000833_YuItR UK0082 2025-05-22T12:22:14.961Z 2025-05-29T13:09:18.764Z
6770760 6770760 20250520235241_aH3Ue UK0082 2025-05-22T12:22:10.091Z 2025-05-29T13:09:17.028Z
6770649 6770649 20250520230928_TeF4r UK0082 2025-05-22T12:22:01.270Z 2025-05-29T13:09:11.639Z
6762101 6762101 20250520003911_EFggX UK0082 2025-05-21T12:22:26.529Z 2025-05-28T13:13:50.174Z
6754111 6754111 20250519011113_JNaUV UK0082 2025-05-20T12:20:09.096Z 2025-05-27T13:21:44.616Z
6753779 6753779 20250519002000_OPPkW UK0082 2025-05-20T12:19:33.183Z 2025-05-27T13:21:31.917Z
6753348 6753348 20250518233254_11EnK UK0082 2025-05-20T12:18:49.406Z 2025-05-27T13:21:09.961Z
6753250 6753250 20250518231337_8rOCy UK0082 2025-05-20T12:18:41.297Z 2025-05-27T13:21:07.980Z
6746800 6746800 20250518002133_xesGP UK0082 2025-05-19T12:16:17.340Z 2025-05-25T12:38:41.965Z
6746795 6746795 20250518002132_htWfA UK0082 2025-05-19T12:16:17.200Z 2025-05-25T12:38:41.908Z
6746570 6746570 20250517234902_u3oMy UK0082 2025-05-19T12:15:46.621Z 2025-05-25T12:38:38.144Z
6742320 6742320 20250518012508_mGZFU UK0082 2025-05-19T12:00:40.797Z 2025-05-27T13:15:43.700Z
6738562 6738562 20250517015747_toK3K UK0082 2025-05-18T12:02:07.045Z 2025-05-25T12:37:45.578Z
6738489 6738489 20250517014017_UpAk2 UK0082 2025-05-18T12:01:46.502Z 2025-05-25T12:37:44.379Z
6738332 6738332 20250517010806_n5Scd UK0082 2025-05-18T12:01:18.994Z 2025-05-25T12:37:42.347Z
6731714 6731714 20250516012536_3QOVI UK0082 2025-05-17T12:03:23.820Z 2025-05-24T12:40:05.945Z
6731433 6731433 20250516005429_bpuUJ UK0082 2025-05-17T12:02:36.516Z 2025-05-24T12:40:02.264Z
6731362 6731362 20250516004605_UdJa6 UK0082 2025-05-17T12:02:28.840Z 2025-05-24T12:40:01.526Z
6730947 6730947 20250515235453_hYh3x UK0082 2025-05-17T12:01:11.167Z 2025-05-24T12:39:57.601Z
6730755 6730755 20250515232621_hKaSJ UK0082 2025-05-17T12:00:35.709Z 2025-05-24T12:39:54.877Z
6724663 6724663 20250515013525_AGXaT UK0082 2025-05-16T12:04:19.566Z 2025-05-23T12:36:13.734Z
6724264 6724264 20250515002453_eNWLW UK0082 2025-05-16T12:02:55.757Z 2025-05-23T12:36:07.321Z
6724173 6724173 20250515000813_iQkOz UK0082 2025-05-16T12:02:31.517Z 2025-05-23T12:36:05.030Z
6724146 6724146 20250515000516_Y8GhD UK0082 2025-05-16T12:02:28.388Z 2025-05-23T12:36:04.669Z
6723930 6723930 20250514233647_ep71H UK0082 2025-05-16T12:01:55.144Z 2025-05-23T12:36:01.517Z
6723875 6723875 20250514232924_Tn0IS UK0082 2025-05-16T12:01:48.069Z 2025-05-23T12:35:59.706Z
6723801 6723801 20250514232135_jHnKf UK0082 2025-05-16T12:01:30.893Z 2025-05-23T12:35:59.077Z
6717854 6717854 20250513004426_VX0iG UK0082 2025-05-14T12:03:21.871Z 2025-05-21T12:32:06.978Z
6717800 6717800 20250513003243_LpAoN UK0082 2025-05-14T12:03:10.271Z 2025-05-21T12:32:06.482Z
6706801 6706801 20250511012035_PQols UK0082 2025-05-12T12:06:08.368Z 2025-05-19T12:36:25.448Z
6706684 6706684 20250511005511_885jX UK0082 2025-05-12T12:05:43.422Z 2025-05-19T12:36:22.448Z
6698917 6698917 20250510000013_ybVoF UK0082 2025-05-11T12:06:42.587Z 2025-05-18T12:33:45.444Z
6698443 6698443 20250509224440_7ltbl UK0082 2025-05-11T12:05:39.143Z 2025-05-18T12:33:37.723Z
6691934 6691934 20250509013739_QKlbv UK0082 2025-05-10T12:10:33.688Z 2025-05-17T12:35:52.698Z
6691635 6691635 20250509010829_3pFWK UK0082 2025-05-10T12:09:52.981Z 2025-05-17T12:35:45.432Z
6686966 6686966 20250508023941_Q7Xl6 UK0082 2025-05-09T12:12:57.855Z 2025-05-16T12:35:09.478Z
6686919 6686919 20250508022323_O7GcW UK0082 2025-05-09T12:12:42.395Z 2025-05-16T12:35:08.684Z
6686589 6686589 20250508011037_U2e9U UK0082 2025-05-09T12:11:53.884Z 2025-05-16T12:35:04.769Z
6686585 6686585 20250508010955_YnsHE UK0082 2025-05-09T12:11:53.372Z 2025-05-16T12:35:04.751Z
6686577 6686577 20250508010339_sMwd6 UK0082 2025-05-09T12:11:52.486Z 2025-05-16T12:35:04.460Z
6686382 6686382 20250507233640_BKmcA UK0082 2025-05-09T12:11:14.494Z 2025-05-16T12:35:00.516Z
6669186 6669186 20250506004432_V65o8 UK0082 2025-05-07T12:17:10.462Z 2025-05-14T12:41:06.970Z
6669095 6669095 20250506003504_KL57e UK0082 2025-05-07T12:17:04.651Z 2025-05-14T12:41:03.771Z
6669020 6669020 20250506002557_FNcHn UK0082 2025-05-07T12:16:54.043Z 2025-05-14T12:41:00.855Z
6668861 6668861 20250506000134_6c5KY UK0082 2025-05-07T12:16:30.591Z 2025-05-14T12:40:54.795Z
6668481 6668481 20250505230548_jUokK UK0082 2025-05-07T12:15:38.015Z 2025-05-14T12:40:43.086Z
6660057 6660057 20250505024503_J1U0p UK0082 2025-05-06T12:19:43.893Z 2025-05-13T12:38:48.942Z
6659782 6659782 20250505021313_7e91D UK0082 2025-05-06T12:19:14.476Z 2025-05-13T12:38:44.860Z
6659697 6659697 20250505020637_I5cXA UK0082 2025-05-06T12:19:08.038Z 2025-05-13T12:38:44.119Z
6659639 6659639 20250505015730_aIpNz UK0082 2025-05-06T12:19:03.914Z 2025-05-13T12:38:42.850Z
6659610 6659610 20250505015257_Z1hWe UK0082 2025-05-06T12:19:02.480Z 2025-05-13T12:38:42.546Z
6659532 6659532 20250505014704_ybO52 UK0082 2025-05-06T12:18:57.349Z 2025-05-13T12:38:40.784Z
6659515 6659515 20250505014415_nOF26 UK0082 2025-05-06T12:18:56.091Z 2025-05-13T12:38:40.577Z
6659439 6659439 20250505013007_dR9v4 UK0082 2025-05-06T12:18:51.011Z 2025-05-13T12:38:38.592Z
6659369 6659369 20250505012155_33AzK UK0082 2025-05-06T12:18:47.502Z 2025-05-13T12:38:37.349Z
6659288 6659288 20250505011058_Gg5S5 UK0082 2025-05-06T12:18:27.275Z 2025-05-13T12:38:35.879Z
6659232 6659232 20250505010218_dJJWI UK0082 2025-05-06T12:18:23.152Z 2025-05-13T12:38:33.890Z
6659160 6659160 20250505005230_KN1E5 UK0082 2025-05-06T12:18:15.614Z 2025-05-13T12:38:32.405Z
6658679 6658679 20250504233910_6aQvO UK0082 2025-05-06T12:17:20.335Z 2025-05-13T12:38:22.768Z
6658459 6658459 20250504225758_9r2jg UK0082 2025-05-06T12:16:58.822Z 2025-05-13T12:38:19.104Z
6658407 6658407 20250504225239_YUmIb UK0082 2025-05-06T12:16:55.541Z 2025-05-13T12:38:18.311Z
6658283 6658283 20250504221749_d2UCA UK0082 2025-05-06T12:16:32.527Z 2025-05-13T12:38:16.000Z
6647224 6647224 20250504022332_WOowf UK0082 2025-05-05T12:14:36.720Z 2025-05-12T12:35:08.788Z
6628623 6628623 20250501233157_RCg5D UK0082 2025-05-03T12:13:38.881Z 2025-05-10T12:37:21.099Z
6614677 6614677 20250430025816_pH2g6 UK0082 2025-05-01T12:19:13.515Z 2025-05-08T12:35:16.110Z
6614400 6614400 20250430023759_PGSvl UK0082 2025-05-01T12:18:59.734Z 2025-05-08T12:35:14.871Z
6614111 6614111 20250430021853_a4MX3 UK0082 2025-05-01T12:18:27.021Z 2025-05-08T12:35:13.367Z
6613077 6613077 20250430010915_YqMxL UK0082 2025-05-01T12:17:06.643Z 2025-05-08T12:35:08.095Z
6612058 6612058 20250430000302_WsJjT UK0082 2025-05-01T12:15:25.563Z 2025-05-08T12:35:03.362Z
6611623 6611623 20250429232716_agkOr UK0082 2025-05-01T12:14:41.935Z 2025-05-08T12:35:00.896Z
6611586 6611586 20250429232510_hmCLu UK0082 2025-05-01T12:14:39.613Z 2025-05-08T12:35:00.725Z
6611550 6611550 20250429232316_Kifcv UK0082 2025-05-01T12:14:37.478Z 2025-05-08T12:35:00.370Z
6570159 6570159 20250425030413_DRkWK UK0082 2025-04-26T12:23:51.623Z 2025-05-03T12:32:38.333Z
6569955 6569955 20250425023047_O78g2 UK0082 2025-04-26T12:23:40.991Z 2025-05-03T12:32:37.332Z
6569952 6569952 20250425023033_2tJto UK0082 2025-04-26T12:23:40.564Z 2025-05-03T12:32:37.302Z
6569704 6569704 20250425014653_92gkd UK0082 2025-04-26T12:23:20.936Z 2025-05-03T12:32:36.830Z
6569592 6569592 20250425013205_7fDWU UK0082 2025-04-26T12:23:10.109Z 2025-05-03T12:32:36.432Z
6569539 6569539 20250425011448_WKM3l UK0082 2025-04-26T12:23:03.993Z 2025-05-03T12:32:36.340Z
6569458 6569458 20250425005558_0CyAn UK0082 2025-04-26T12:22:54.172Z 2025-05-03T12:32:36.045Z
6569079 6569079 20250424235207_hBHKk UK0082 2025-04-26T12:22:10.736Z 2025-05-03T12:32:33.370Z
6569013 6569013 20250424233550_rARh4 UK0082 2025-04-26T12:22:07.305Z 2025-05-03T12:32:33.078Z
6568851 6568851 20250424230538_Cr8Qt UK0082 2025-04-26T12:21:55.478Z 2025-05-03T12:32:32.695Z
6568816 6568816 20250424225008_SGGlo UK0082 2025-04-26T12:21:52.882Z 2025-05-03T12:32:32.585Z
6568792 6568792 20250424224523_nGCNX UK0082 2025-04-26T12:21:51.612Z 2025-05-03T12:32:32.531Z
6568773 6568773 20250424223741_3oa38 UK0082 2025-04-26T12:21:50.181Z 2025-05-03T12:32:32.377Z
6561120 6561120 20250424031032_yQcT4 UK0082 2025-04-25T12:21:06.090Z 2025-05-02T12:35:01.718Z
6561081 6561081 20250424030042_TVaFz UK0082 2025-04-25T12:21:02.554Z 2025-05-02T12:35:01.428Z
6561055 6561055 20250424025414_eef1a UK0082 2025-04-25T12:21:00.436Z 2025-05-02T12:35:01.390Z
6561014 6561014 20250424023456_Wxp9l UK0082 2025-04-25T12:20:58.045Z 2025-05-02T12:35:01.209Z
6560983 6560983 20250424022529_4QzR0 UK0082 2025-04-25T12:20:56.529Z 2025-05-02T12:35:00.921Z
6560884 6560884 20250424020349_R53X0 UK0082 2025-04-25T12:20:44.973Z 2025-05-02T12:35:00.287Z
6560837 6560837 20250424014400_uGLvM UK0082 2025-04-25T12:20:29.792Z 2025-05-02T12:35:00.012Z

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