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,757 rows where station_code = "UK001Q" 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
6976939 6976939 20250626004650_WIRJg UK001Q 2025-06-27T12:09:52.732Z 2025-07-04T12:35:43.271Z
6976931 6976931 20250626004550_Nhl26 UK001Q 2025-06-27T12:09:51.624Z 2025-07-04T12:35:43.210Z
6976449 6976449 20250625224327_dOBLO UK001Q 2025-06-27T12:07:56.415Z 2025-07-04T12:35:29.994Z
6976397 6976397 20250625223626_LxQlt UK001Q 2025-06-27T12:07:49.240Z 2025-07-04T12:35:28.411Z
6948469 6948469 20250622014206_73Jve UK001Q 2025-06-23T12:25:38.271Z 2025-06-30T12:35:56.173Z
6947704 6947704 20250622002046_rRMnw UK001Q 2025-06-23T12:23:59.978Z 2025-06-30T12:35:49.138Z
6929707 6929707 20250620004542_n3uvb UK001Q 2025-06-21T12:18:45.482Z 2025-06-28T12:40:48.429Z
6909913 6909913 20250616223657_UNYXM UK001Q 2025-06-18T12:19:46.922Z 2025-06-25T12:36:37.493Z
6897334 6897334 20250616004827_4MWjh UK001Q 2025-06-16T12:10:36.190Z 2025-06-24T12:59:38.616Z
6885136 6885136 20250612233100_IlAgo UK001Q 2025-06-13T12:06:56.669Z 2025-06-21T12:37:01.371Z
6848643 6848643 20250602010700_xBv52 UK001Q 2025-06-03T12:11:35.180Z 2025-06-10T12:29:16.719Z
6842208 6842208 20250601020615_ZU9Ca UK001Q 2025-06-02T12:14:17.193Z 2025-06-09T12:45:53.342Z
6842194 6842194 20250601020323_KgPxC UK001Q 2025-06-02T12:14:16.268Z 2025-06-09T12:45:53.096Z
6842086 6842086 20250601013528_vH8gS UK001Q 2025-06-02T12:14:00.711Z 2025-06-09T12:45:48.083Z
6841983 6841983 20250601012007_g7kqH UK001Q 2025-06-02T12:13:45.659Z 2025-06-09T12:45:45.566Z
6841703 6841703 20250601003452_ZOdhS UK001Q 2025-06-02T12:12:55.326Z 2025-06-09T12:45:33.984Z
6841456 6841456 20250531234830_w2fBi UK001Q 2025-06-02T12:11:57.444Z 2025-06-09T12:45:17.881Z
6829318 6829318 20250530003347_TlCbY UK001Q 2025-05-31T12:18:07.901Z 2025-06-07T12:36:32.286Z
6813953 6813953 20250527002828_ZEl3e UK001Q 2025-05-28T12:15:23.603Z 2025-06-04T13:02:34.965Z
6813949 6813949 20250527002819_qZ0zG UK001Q 2025-05-28T12:15:21.879Z 2025-06-04T13:02:34.761Z
6780515 6780515 20250522002350_XOlnq UK001Q 2025-05-23T12:24:21.643Z 2025-05-30T13:09:21.713Z
6779714 6779714 20250521215950_BsQvZ UK001Q 2025-05-23T12:23:06.539Z 2025-05-30T13:08:50.307Z
6745845 6745845 20250517220113_7NtNF UK001Q 2025-05-19T12:14:38.935Z 2025-05-25T12:38:24.894Z
6731058 6731058 20250516000819_VG1Vo UK001Q 2025-05-17T12:01:38.323Z 2025-05-24T12:39:58.611Z
6723530 6723530 20250514224401_E3vo0 UK001Q 2025-05-16T12:00:49.749Z 2025-05-23T12:35:55.524Z
6723517 6723517 20250514224340_vTWGV UK001Q 2025-05-16T12:00:47.412Z 2025-05-23T12:35:55.495Z
6722578 6722578 20250514024134_YN3Sk UK001Q 2025-05-15T12:13:02.990Z 2025-05-22T12:36:23.268Z
6721450 6721450 20250514012831_626so UK001Q 2025-05-15T12:03:38.904Z 2025-05-15T12:03:38.904Z
6720858 6720858 20250513233637_E78vp UK001Q 2025-05-15T12:02:12.158Z 2025-05-22T12:36:06.832Z
6706302 6706302 20250510234043_2QutF UK001Q 2025-05-12T12:04:32.512Z 2025-05-19T12:36:11.855Z
6700373 6700373 20250510022015_7LUkc UK001Q 2025-05-11T12:09:35.505Z 2025-05-18T12:34:09.358Z
6699341 6699341 20250510005549_zloa1 UK001Q 2025-05-11T12:07:42.662Z 2025-05-18T12:33:51.807Z
6698989 6698989 20250510001058_JVlrz UK001Q 2025-05-11T12:06:58.394Z 2025-05-18T12:33:46.330Z
6669736 6669736 20250506013653_5s2EN UK001Q 2025-05-07T12:17:58.887Z 2025-05-14T12:41:16.883Z
6669512 6669512 20250506011851_Fl8Wx UK001Q 2025-05-07T12:17:45.771Z 2025-05-14T12:41:14.177Z
6669456 6669456 20250506011322_tWH5L UK001Q 2025-05-07T12:17:30.033Z 2025-05-14T12:41:12.699Z
6668956 6668956 20250506001527_Ayg15 UK001Q 2025-05-07T12:16:41.009Z 2025-05-14T12:40:56.467Z
6668474 6668474 20250505230505_oHhZu UK001Q 2025-05-07T12:15:37.595Z 2025-05-14T12:40:42.717Z
6668413 6668413 20250505224123_tZ2Zs UK001Q 2025-05-07T12:15:28.718Z 2025-05-14T12:40:40.513Z
6668103 6668103 20250505214914_gnpVw UK001Q 2025-05-07T12:14:56.712Z 2025-05-14T12:40:27.896Z
6658999 6658999 20250505003431_kbavs UK001Q 2025-05-06T12:18:06.433Z 2025-05-13T12:38:28.895Z
6639103 6639103 20250503025149_IsMyl UK001Q 2025-05-04T12:18:02.277Z 2025-05-11T12:37:17.003Z
6638953 6638953 20250503023527_VZAZR UK001Q 2025-05-04T12:17:38.460Z 2025-05-11T12:37:16.085Z
6628245 6628245 20250501222147_E11Pm UK001Q 2025-05-03T12:12:38.321Z 2025-05-10T12:37:18.120Z
6622709 6622709 20250501025119_XAnrw UK001Q 2025-05-02T12:18:19.152Z 2025-05-09T12:38:33.671Z
6622306 6622306 20250501022502_Q0K14 UK001Q 2025-05-02T12:17:34.206Z 2025-05-09T12:38:31.044Z
6622102 6622102 20250501021320_TlKdj UK001Q 2025-05-02T12:17:21.454Z 2025-05-09T12:38:28.898Z
6622047 6622047 20250501021112_cJqYU UK001Q 2025-05-02T12:17:18.819Z 2025-05-09T12:38:28.714Z
6621967 6621967 20250501020507_EBSDg UK001Q 2025-05-02T12:17:07.668Z 2025-05-09T12:38:28.118Z
6620928 6620928 20250501005444_Pooi2 UK001Q 2025-05-02T12:15:25.936Z 2025-05-09T12:38:16.920Z
6619916 6619916 20250430235428_XDOFo UK001Q 2025-05-02T12:13:41.811Z 2025-05-09T12:38:08.226Z
6619891 6619891 20250430235246_sx0Hw UK001Q 2025-05-02T12:13:40.317Z 2025-05-09T12:38:07.915Z
6619860 6619860 20250430235017_TPhQJ UK001Q 2025-05-02T12:13:34.778Z 2025-05-09T12:38:07.782Z
6614746 6614746 20250430030906_t3io5 UK001Q 2025-05-01T12:19:28.892Z 2025-05-08T12:35:16.305Z
6614172 6614172 20250430022324_U72Zj UK001Q 2025-05-01T12:18:46.242Z 2025-05-08T12:35:13.678Z
6613799 6613799 20250430020036_mhKLT UK001Q 2025-05-01T12:18:09.006Z 2025-05-08T12:35:11.862Z
6602092 6602092 20250428224747_mmwjj UK001Q 2025-04-30T12:16:21.460Z 2025-05-07T12:34:50.527Z
6602086 6602086 20250428224655_Uj2iJ UK001Q 2025-04-30T12:16:20.975Z 2025-05-07T12:34:50.474Z
6601980 6601980 20250428223828_KIgq3 UK001Q 2025-04-30T12:16:13.260Z 2025-05-07T12:34:49.273Z
6601124 6601124 20250428211826_ipYwM UK001Q 2025-04-30T12:14:40.390Z 2025-05-07T12:34:44.899Z
6594199 6594199 20250428004220_nB2iK UK001Q 2025-04-29T12:19:55.491Z 2025-05-06T12:36:43.174Z
6593880 6593880 20250428002024_XkbPc UK001Q 2025-04-29T12:19:22.717Z 2025-05-06T12:36:41.494Z
6592503 6592503 20250427220723_yJy4f UK001Q 2025-04-29T12:17:33.768Z 2025-05-06T12:36:32.749Z
6592386 6592386 20250427214836_FvqyZ UK001Q 2025-04-29T12:17:22.095Z 2025-05-06T12:36:31.685Z
6592122 6592122 20250427212156_F1rcu UK001Q 2025-04-29T12:16:52.617Z 2025-05-06T12:36:29.125Z
6586111 6586111 20250427025535_okSuO UK001Q 2025-04-28T12:23:10.410Z 2025-05-05T12:31:31.606Z
6586011 6586011 20250427024806_r2jOP UK001Q 2025-04-28T12:23:05.022Z 2025-05-05T12:31:31.398Z
6585444 6585444 20250427014627_HGHaS UK001Q 2025-04-28T12:21:57.446Z 2025-05-05T12:31:29.251Z
6585304 6585304 20250427013036_CCAIV UK001Q 2025-04-28T12:21:48.542Z 2025-05-05T12:31:28.776Z
6585088 6585088 20250427010755_4hjhS UK001Q 2025-04-28T12:21:14.725Z 2025-05-05T12:31:28.218Z
6584849 6584849 20250427004708_kunWm UK001Q 2025-04-28T12:20:56.433Z 2025-05-05T12:31:27.392Z
6584158 6584158 20250426230255_8S0kJ UK001Q 2025-04-28T12:19:24.244Z 2025-05-05T12:31:24.922Z
6584091 6584091 20250426225105_5QXTk UK001Q 2025-04-28T12:19:18.012Z 2025-05-05T12:31:24.558Z
6583954 6583954 20250426222317_T7c1K UK001Q 2025-04-28T12:19:02.124Z 2025-05-05T12:31:24.131Z
6583933 6583933 20250426221821_iuE13 UK001Q 2025-04-28T12:18:59.996Z 2025-05-05T12:31:24.027Z
6570271 6570271 20250425033032_VYNVq UK001Q 2025-04-26T12:24:09.393Z 2025-05-03T12:32:38.629Z
6570210 6570210 20250425031515_0tE3W UK001Q 2025-04-26T12:24:01.414Z 2025-05-03T12:32:38.535Z
6570125 6570125 20250425025525_4pujw UK001Q 2025-04-26T12:23:47.346Z 2025-05-03T12:32:38.152Z
6570065 6570065 20250425024719_5IjiW UK001Q 2025-04-26T12:23:45.641Z 2025-05-03T12:32:37.785Z
6570023 6570023 20250425023752_DWc0k UK001Q 2025-04-26T12:23:43.253Z 2025-05-03T12:32:37.432Z
6569820 6569820 20250425021303_21Rvw UK001Q 2025-04-26T12:23:27.128Z 2025-05-03T12:32:37.089Z
6569656 6569656 20250425013737_cBGqE UK001Q 2025-04-26T12:23:15.601Z 2025-05-03T12:32:36.788Z
6569637 6569637 20250425013626_qxek8 UK001Q 2025-04-26T12:23:14.367Z 2025-05-03T12:32:36.567Z
6569354 6569354 20250425004713_0iXOd UK001Q 2025-04-26T12:22:49.003Z 2025-05-03T12:32:35.602Z
6569193 6569193 20250425001248_d3q2u UK001Q 2025-04-26T12:22:33.005Z 2025-05-03T12:32:34.665Z
6569169 6569169 20250425000516_cAjfc UK001Q 2025-04-26T12:22:26.700Z 2025-05-03T12:32:34.641Z
6568968 6568968 20250424233058_OUMde UK001Q 2025-04-26T12:22:02.213Z 2025-05-03T12:32:32.974Z
6568920 6568920 20250424231841_SH8Mh UK001Q 2025-04-26T12:22:00.540Z 2025-05-03T12:32:32.906Z
6568667 6568667 20250424221312_OZBO3 UK001Q 2025-04-26T12:21:38.601Z 2025-05-03T12:32:32.027Z
6568462 6568462 20250424212802_BPNu7 UK001Q 2025-04-26T12:21:08.154Z 2025-05-03T12:32:31.491Z
6561154 6561154 20250424032109_66h3o UK001Q 2025-04-25T12:21:11.201Z 2025-05-02T12:35:01.922Z
6561090 6561090 20250424030108_bw2v5 UK001Q 2025-04-25T12:21:03.634Z 2025-05-02T12:35:01.642Z
6561042 6561042 20250424025034_4oW1s UK001Q 2025-04-25T12:20:59.726Z 2025-05-02T12:35:01.377Z
6560945 6560945 20250424021708_7Z2uk UK001Q 2025-04-25T12:20:53.922Z 2025-05-02T12:35:00.710Z
6560893 6560893 20250424020703_XNWsn UK001Q 2025-04-25T12:20:50.979Z 2025-05-02T12:35:00.532Z
6560768 6560768 20250424012246_ka4IZ UK001Q 2025-04-25T12:20:22.094Z 2025-05-02T12:34:59.344Z
6560670 6560670 20250424004419_4uXfc UK001Q 2025-04-25T12:20:15.936Z 2025-05-02T12:34:58.786Z
6560500 6560500 20250423233959_LYElt UK001Q 2025-04-25T12:19:36.297Z 2025-05-02T12:34:58.085Z
6560417 6560417 20250423225417_6fuP2 UK001Q 2025-04-25T12:19:21.034Z 2025-05-02T12:34:57.538Z
6531032 6531032 20250420034142_vWclA UK001Q 2025-04-21T12:17:10.532Z 2025-04-28T12:41:24.701Z

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