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,708 rows where station_code = "UK00AQ" 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
8683265 8683265 20251203064756_81IUC UK00AQ 2025-12-04T14:19:01.487Z 2025-12-05T14:23:13.373Z
8683255 8683255 20251203064635_uWLTh UK00AQ 2025-12-04T14:19:00.415Z 2025-12-05T14:23:12.971Z
8683247 8683247 20251203064617_nTF1i UK00AQ 2025-12-04T14:18:59.738Z 2025-12-05T14:23:12.716Z
8683238 8683238 20251203064415_MOYcr UK00AQ 2025-12-04T14:18:58.637Z 2025-12-05T14:23:12.356Z
8683175 8683175 20251203063539_PuH6c UK00AQ 2025-12-04T14:18:43.987Z 2025-12-05T14:23:09.996Z
8682342 8682342 20251203051801_rnFSs UK00AQ 2025-12-04T14:16:50.066Z 2025-12-05T14:22:25.158Z
8681646 8681646 20251203033600_Fo25o UK00AQ 2025-12-04T14:15:11.294Z 2025-12-05T14:21:44.868Z
8681555 8681555 20251203032542_IhDcd UK00AQ 2025-12-04T14:15:03.217Z 2025-12-05T14:21:41.292Z
8681369 8681369 20251203025953_22of6 UK00AQ 2025-12-04T14:14:34.604Z 2025-12-05T14:21:34.192Z
8680574 8680574 20251203003108_Yw0kb UK00AQ 2025-12-04T14:12:22.909Z 2025-12-05T14:20:45.044Z
8680221 8680221 20251202223522_leIuZ UK00AQ 2025-12-04T14:11:26.287Z 2025-12-05T14:20:24.630Z
8680124 8680124 20251202214700_FRK2D UK00AQ 2025-12-04T14:11:08.649Z 2025-12-05T14:20:18.379Z
8680114 8680114 20251202214107_8tqR9 UK00AQ 2025-12-04T14:11:07.135Z 2025-12-05T14:20:17.820Z
8680106 8680106 20251202213858_YDO61 UK00AQ 2025-12-04T14:11:05.010Z 2025-12-05T14:20:17.664Z
8679984 8679984 20251202211345_CKdSa UK00AQ 2025-12-04T14:10:51.259Z 2025-12-05T14:20:12.343Z
8677033 8677033 20251202064152_71Oid UK00AQ 2025-12-03T14:26:13.009Z 2025-12-05T14:29:18.996Z
8676858 8676858 20251202062819_cXCQp UK00AQ 2025-12-03T14:25:53.586Z 2025-12-05T14:29:15.025Z
8676725 8676725 20251202061857_Gihpl UK00AQ 2025-12-03T14:25:31.037Z 2025-12-05T14:29:11.819Z
8675786 8675786 20251202051412_dSr97 UK00AQ 2025-12-03T14:24:15.116Z 2025-12-05T14:28:40.599Z
8675702 8675702 20251202051017_M951F UK00AQ 2025-12-03T14:24:11.182Z 2025-12-05T14:28:38.958Z
8675618 8675618 20251202050215_fgICz UK00AQ 2025-12-03T14:23:56.044Z 2025-12-05T14:28:36.885Z
8675550 8675550 20251202045610_OthRE UK00AQ 2025-12-03T14:23:51.194Z 2025-12-05T14:28:35.326Z
8675526 8675526 20251202045502_Hhe5v UK00AQ 2025-12-03T14:23:50.038Z 2025-12-05T14:28:34.794Z
8675331 8675331 20251202042845_MpkPe UK00AQ 2025-12-03T14:23:31.298Z 2025-12-05T14:28:19.793Z
8675255 8675255 20251202042334_s1H6e UK00AQ 2025-12-03T14:23:24.384Z 2025-12-05T14:28:18.108Z
8675063 8675063 20251202035716_lGUm7 UK00AQ 2025-12-03T14:22:55.231Z 2025-12-05T14:28:10.294Z
8674111 8674111 20251202012947_23E5h UK00AQ 2025-12-03T14:20:56.712Z 2025-12-05T14:27:29.034Z
8674093 8674093 20251202012803_dtxbC UK00AQ 2025-12-03T14:20:55.738Z 2025-12-05T14:27:28.593Z
8673981 8673981 20251202005444_JJCW2 UK00AQ 2025-12-03T14:20:35.120Z 2025-12-05T14:27:24.545Z
8673933 8673933 20251202004358_2DsWN UK00AQ 2025-12-03T14:20:24.060Z 2025-12-05T14:27:23.338Z
8673897 8673897 20251202002202_YAy3k UK00AQ 2025-12-03T14:20:16.282Z 2025-12-05T14:27:22.099Z
8673821 8673821 20251201234843_xe338 UK00AQ 2025-12-03T14:20:07.685Z 2025-12-05T14:27:18.512Z
8673792 8673792 20251201231623_K8YHW UK00AQ 2025-12-03T14:20:03.654Z 2025-12-05T14:27:16.747Z
8667561 8667561 20251130021628_ORtAr UK00AQ 2025-12-02T14:38:54.530Z 2025-12-05T14:43:31.756Z
8658125 8658125 20251130064455_7avO9 UK00AQ 2025-12-01T14:34:56.008Z 2025-12-05T14:46:03.149Z
8658012 8658012 20251130062726_aGlY7 UK00AQ 2025-12-01T14:34:49.877Z 2025-12-05T14:46:00.275Z
8657912 8657912 20251130061715_RAPRu UK00AQ 2025-12-01T14:34:45.649Z 2025-12-05T14:45:57.340Z
8657754 8657754 20251130060510_bE9Q2 UK00AQ 2025-12-01T14:34:40.196Z 2025-12-05T14:45:36.413Z
8653711 8653711 20251130023717_prTPi UK00AQ 2025-12-01T14:23:58.446Z 2025-12-05T14:43:38.281Z
8653652 8653652 20251130023317_5nbeo UK00AQ 2025-12-01T14:23:54.015Z 2025-12-05T14:43:37.108Z
8653450 8653450 20251130021628_PTnyP UK00AQ 2025-12-01T14:23:32.077Z 2025-12-05T14:43:31.680Z
8653150 8653150 20251130020029_s2Wup UK00AQ 2025-12-01T14:22:56.828Z 2025-12-05T14:43:04.669Z
8652844 8652844 20251130013739_i6Kfv UK00AQ 2025-12-01T14:22:13.831Z 2025-12-05T14:42:54.529Z
8652767 8652767 20251130013220_0Jyfw UK00AQ 2025-12-01T14:22:06.351Z 2025-12-05T14:42:52.007Z
8652672 8652672 20251130012638_rz8ke UK00AQ 2025-12-01T14:21:57.422Z 2025-12-05T14:42:49.775Z
8652557 8652557 20251130012105_MVqeH UK00AQ 2025-12-01T14:21:41.087Z 2025-12-05T14:42:47.888Z
8652091 8652091 20251130004525_bhiWo UK00AQ 2025-12-01T14:20:41.895Z 2025-12-05T14:42:19.260Z
8652040 8652040 20251130004255_EBx6X UK00AQ 2025-12-01T14:20:30.976Z 2025-12-05T14:42:14.119Z
8651509 8651509 20251129235113_JX9FE UK00AQ 2025-12-01T14:19:14.511Z 2025-12-05T14:41:59.436Z
8644933 8644933 20251128201652_YVnge UK00AQ 2025-11-30T14:22:53.284Z 2025-12-05T14:50:29.623Z
8634118 8634118 20251128002158_uf5l1 UK00AQ 2025-11-29T14:20:47.530Z 2025-12-05T14:58:16.517Z
8633885 8633885 20251128000109_Pciak UK00AQ 2025-11-29T14:20:28.682Z 2025-12-05T14:58:13.681Z
8633718 8633718 20251127234823_Bi6td UK00AQ 2025-11-29T14:20:07.358Z 2025-12-05T14:57:55.634Z
8633052 8633052 20251127223328_SdwI0 UK00AQ 2025-11-29T14:18:54.866Z 2025-12-05T14:57:05.324Z
8632620 8632620 20251127212621_pNAhp UK00AQ 2025-11-29T14:17:52.508Z 2025-12-05T14:56:27.676Z
8632539 8632539 20251127211750_K9l58 UK00AQ 2025-11-29T14:17:46.373Z 2025-12-05T14:56:22.518Z
8632534 8632534 20251127211733_kXJdc UK00AQ 2025-11-29T14:17:46.095Z 2025-12-05T14:56:22.463Z
8616423 8616423 20251126055824_IIvOc UK00AQ 2025-11-27T14:31:10.879Z 2025-12-04T15:11:39.352Z
8613580 8613580 20251126032431_jw3s0 UK00AQ 2025-11-27T14:26:15.608Z 2025-12-04T15:09:49.421Z
8613162 8613162 20251126030640_szCtx UK00AQ 2025-11-27T14:25:27.481Z 2025-12-04T15:09:38.018Z
8613042 8613042 20251126025956_JOEUY UK00AQ 2025-11-27T14:25:20.024Z 2025-12-04T15:09:36.683Z
8611944 8611944 20251126020956_33R24 UK00AQ 2025-11-27T14:23:06.431Z 2025-12-04T15:09:25.956Z
8611630 8611630 20251126015343_flc72 UK00AQ 2025-11-27T14:22:22.784Z 2025-12-04T15:09:22.962Z
8609172 8609172 20251125231718_3CTLq UK00AQ 2025-11-27T14:17:38.971Z 2025-12-04T15:07:52.331Z
8608661 8608661 20251125223508_hg6LT UK00AQ 2025-11-27T14:16:30.856Z 2025-12-04T15:07:47.637Z
8608464 8608464 20251125221918_gRGJN UK00AQ 2025-11-27T14:16:09.740Z 2025-12-04T15:07:45.506Z
8608307 8608307 20251125220650_K9nLh UK00AQ 2025-11-27T14:15:40.590Z 2025-12-04T15:07:43.412Z
8607670 8607670 20251125210946_PO0DZ UK00AQ 2025-11-27T14:14:10.307Z 2025-12-04T15:07:12.057Z
8607171 8607171 20251125202420_Qn2h5 UK00AQ 2025-11-27T14:12:37.307Z 2025-12-04T15:06:55.942Z
8607044 8607044 20251125200825_7xECP UK00AQ 2025-11-27T14:12:13.385Z 2025-12-04T15:06:54.118Z
8606044 8606044 20251125174059_Z40uY UK00AQ 2025-11-27T14:08:41.185Z 2025-12-04T15:05:59.723Z
8605877 8605877 20251125172556_UgVBN UK00AQ 2025-11-27T14:08:07.951Z 2025-12-04T15:05:47.835Z
8603784 8603784 20251125064005_YTNjf UK00AQ 2025-11-26T14:27:55.101Z 2025-12-02T15:09:37.407Z
8603418 8603418 20251125060739_EiIWe UK00AQ 2025-11-26T14:27:26.282Z 2025-12-02T15:09:35.742Z
8602739 8602739 20251125051935_nMjBd UK00AQ 2025-11-26T14:26:17.353Z 2025-12-02T15:09:32.534Z
8602545 8602545 20251125050347_JxsRq UK00AQ 2025-11-26T14:26:06.753Z 2025-12-02T15:09:31.438Z
8602361 8602361 20251125045048_jac2o UK00AQ 2025-11-26T14:25:35.535Z 2025-12-02T15:09:30.657Z
8602039 8602039 20251125043321_1pr8T UK00AQ 2025-11-26T14:25:18.209Z 2025-12-02T15:09:29.217Z
8602034 8602034 20251125043308_53pzb UK00AQ 2025-11-26T14:25:17.904Z 2025-12-02T15:09:29.199Z
8600843 8600843 20251125031920_8dG2v UK00AQ 2025-11-26T14:23:02.344Z 2025-12-02T15:08:51.713Z
8600687 8600687 20251125031255_4flFj UK00AQ 2025-11-26T14:22:53.243Z 2025-12-02T15:08:49.709Z
8600567 8600567 20251125030745_Th23n UK00AQ 2025-11-26T14:22:48.127Z 2025-12-02T15:08:47.006Z
8600176 8600176 20251125024639_UCw4a UK00AQ 2025-11-26T14:22:06.655Z 2025-12-02T15:08:37.558Z
8587493 8587493 20251123221015_gc74R UK00AQ 2025-11-25T14:15:24.284Z 2025-12-02T15:11:16.458Z
8587193 8587193 20251123213448_26eYM UK00AQ 2025-11-25T14:14:49.297Z 2025-12-02T15:11:09.219Z
8586721 8586721 20251123203608_3rYpc UK00AQ 2025-11-25T14:13:38.906Z 2025-12-02T15:11:01.776Z
8579623 8579623 20251123002812_JTohL UK00AQ 2025-11-24T14:14:51.929Z 2025-12-01T15:20:48.926Z
8579559 8579559 20251123001511_862M2 UK00AQ 2025-11-24T14:14:38.568Z 2025-12-01T15:20:43.049Z
8579527 8579527 20251123000646_RxV9T UK00AQ 2025-11-24T14:14:33.304Z 2025-12-01T15:20:38.322Z
8579351 8579351 20251122231622_T9j9p UK00AQ 2025-11-24T14:14:02.960Z 2025-12-01T15:20:14.708Z
8579201 8579201 20251122224009_52lJ0 UK00AQ 2025-11-24T14:13:47.012Z 2025-12-01T15:20:06.287Z
8578906 8578906 20251122214736_4YM2o UK00AQ 2025-11-24T14:12:59.475Z 2025-12-01T15:19:55.785Z
8578880 8578880 20251122214515_Ay0ZN UK00AQ 2025-11-24T14:12:55.130Z 2025-12-01T15:19:54.906Z
8578670 8578670 20251122211159_RM2sl UK00AQ 2025-11-24T14:12:18.104Z 2025-12-01T15:19:49.524Z
8578643 8578643 20251122210502_p2iDU UK00AQ 2025-11-24T14:12:15.402Z 2025-12-01T15:19:49.253Z
8578559 8578559 20251122205228_EySdz UK00AQ 2025-11-24T14:12:05.811Z 2025-12-01T15:19:48.247Z
8578047 8578047 20251122193233_T8prV UK00AQ 2025-11-24T14:10:36.850Z 2025-12-01T15:19:07.402Z
8569844 8569844 20251121061754_NaACz UK00AQ 2025-11-23T14:32:30.953Z 2025-11-29T14:54:49.097Z
8568301 8568301 20251121051115_c3an1 UK00AQ 2025-11-23T14:31:02.364Z 2025-11-29T14:54:46.456Z
8568135 8568135 20251121050247_OfPZh UK00AQ 2025-11-23T14:30:54.030Z 2025-11-29T14:54:46.119Z

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