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

6,831 rows where station_code = "UK002X" 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
7189623 7189623 20250725002720_PMIIh UK002X 2025-07-26T12:34:20.141Z 2025-08-01T12:16:22.702Z
7189575 7189575 20250725002409_qPRRo UK002X 2025-07-26T12:34:16.285Z 2025-08-01T12:16:22.603Z
7188931 7188931 20250724233620_UWiYn UK002X 2025-07-26T12:33:23.681Z 2025-08-01T12:16:21.381Z
7188370 7188370 20250724224345_yNwR3 UK002X 2025-07-26T12:32:59.951Z 2025-08-01T12:16:20.045Z
7188289 7188289 20250724223816_kxYhY UK002X 2025-07-26T12:32:54.624Z 2025-08-01T12:16:19.910Z
7170692 7170692 20250723230540_cjcVW UK002X 2025-07-25T12:00:58.097Z 2025-07-31T12:23:47.146Z
7159299 7159299 20250723233342_uH0hi UK002X 2025-07-25T12:00:09.447Z 2025-08-01T12:15:34.785Z
7130667 7130667 20250721020851_yhuE7 UK002X 2025-07-22T12:00:57.270Z 2025-07-29T12:47:19.873Z
7130664 7130664 20250721020851_lu1Mh UK002X 2025-07-22T12:00:57.266Z 2025-07-29T12:47:19.872Z
7109380 7109380 20250718001621_G4Tyn UK002X 2025-07-20T12:14:29.365Z 2025-07-26T12:45:46.356Z
7109256 7109256 20250717235542_2sWy4 UK002X 2025-07-20T12:14:09.486Z 2025-07-26T12:45:45.448Z
7109107 7109107 20250717233720_UFwBD UK002X 2025-07-20T12:13:58.368Z 2025-07-26T12:45:43.386Z
7099114 7099114 20250717015416_Pr9oI UK002X 2025-07-18T12:10:23.215Z 2025-07-25T12:03:02.602Z
7099078 7099078 20250717014821_AC3Vy UK002X 2025-07-18T12:10:19.550Z 2025-07-25T12:03:02.539Z
7099024 7099024 20250717013736_prJEb UK002X 2025-07-18T12:10:15.559Z 2025-07-25T12:03:02.381Z
7098382 7098382 20250717000616_PyifA UK002X 2025-07-18T12:08:33.845Z 2025-07-25T12:03:00.613Z
7098170 7098170 20250716234200_lgjPc UK002X 2025-07-18T12:08:00.456Z 2025-07-25T12:03:00.222Z
7089734 7089734 20250715013510_sVEyh UK002X 2025-07-16T12:13:49.857Z 2025-07-23T12:05:02.662Z
7089362 7089362 20250715004812_IX4eu UK002X 2025-07-16T12:13:05.927Z 2025-07-23T12:05:01.891Z
7089351 7089351 20250715004749_6GBzp UK002X 2025-07-16T12:13:05.166Z 2025-07-23T12:05:01.888Z
7089251 7089251 20250715003414_umS9g UK002X 2025-07-16T12:12:55.180Z 2025-07-23T12:05:01.756Z
7088364 7088364 20250714222908_838yF UK002X 2025-07-16T12:10:41.678Z 2025-07-23T12:04:59.726Z
7080370 7080370 20250713011844_ss4Qc UK002X 2025-07-14T12:13:03.947Z 2025-07-21T12:03:03.966Z
7080037 7080037 20250713004253_ZqJiX UK002X 2025-07-14T12:12:13.192Z 2025-07-21T12:03:03.277Z
7080020 7080020 20250713004124_6dmtR UK002X 2025-07-14T12:12:11.245Z 2025-07-21T12:03:03.254Z
7079964 7079964 20250713003424_ydr1H UK002X 2025-07-14T12:12:05.551Z 2025-07-21T12:03:03.052Z
7079802 7079802 20250713001922_oaTf2 UK002X 2025-07-14T12:11:33.721Z 2025-07-21T12:03:02.490Z
7079084 7079084 20250712225512_X2dx9 UK002X 2025-07-14T12:09:29.391Z 2025-07-21T12:02:59.622Z
7076228 7076228 20250712012228_AbGEy UK002X 2025-07-13T12:12:06.310Z 2025-07-20T12:25:16.517Z
7075764 7075764 20250712003919_UF7c6 UK002X 2025-07-13T12:11:00.341Z 2025-07-20T12:25:12.344Z
7075728 7075728 20250712003709_iCzGL UK002X 2025-07-13T12:10:57.116Z 2025-07-20T12:25:12.156Z
7075621 7075621 20250712001719_olWJg UK002X 2025-07-13T12:10:38.080Z 2025-07-20T12:25:11.424Z
7075362 7075362 20250711235105_qA3Z2 UK002X 2025-07-13T12:09:55.304Z 2025-07-20T12:25:08.593Z
7075324 7075324 20250711234645_omm5w UK002X 2025-07-13T12:09:50.667Z 2025-07-20T12:25:08.481Z
7075256 7075256 20250711234125_dD79Z UK002X 2025-07-13T12:09:44.121Z 2025-07-20T12:25:07.813Z
7075197 7075197 20250711233406_9anUs UK002X 2025-07-13T12:09:29.251Z 2025-07-20T12:25:07.340Z
7075184 7075184 20250711233253_2IJVW UK002X 2025-07-13T12:09:28.671Z 2025-07-20T12:25:07.326Z
7072093 7072093 20250711005653_0adTP UK002X 2025-07-12T12:12:28.223Z 2025-07-18T12:36:11.571Z
7071259 7071259 20250710231529_wJmwl UK002X 2025-07-12T12:10:23.401Z 2025-07-18T12:35:45.811Z
7068208 7068208 20250710010509_amxAm UK002X 2025-07-11T12:14:38.712Z 2025-07-18T12:38:16.946Z
7058747 7058747 20250708004809_u6hNQ UK002X 2025-07-09T12:23:09.141Z 2025-07-16T12:46:13.667Z
7058669 7058669 20250708004158_uoabY UK002X 2025-07-09T12:22:45.508Z 2025-07-16T12:46:09.699Z
7058374 7058374 20250708001343_psbzR UK002X 2025-07-09T12:21:51.379Z 2025-07-16T12:45:55.754Z
7058306 7058306 20250708000510_bJgfr UK002X 2025-07-09T12:21:43.304Z 2025-07-16T12:45:53.625Z
7058228 7058228 20250707235744_P999X UK002X 2025-07-09T12:21:22.807Z 2025-07-16T12:45:50.297Z
7058054 7058054 20250707233308_1WGtw UK002X 2025-07-09T12:20:46.415Z 2025-07-16T12:45:39.981Z
7057846 7057846 20250707230035_YpFsp UK002X 2025-07-09T12:20:10.107Z 2025-07-16T12:45:28.987Z
7054456 7054456 20250706230451_LskS6 UK002X 2025-07-08T12:19:50.310Z 2025-07-15T12:49:02.448Z
7029620 7029620 20250703000627_eQ66k UK002X 2025-07-04T12:15:18.365Z 2025-07-10T12:26:02.987Z
7029566 7029566 20250703000350_DFZ7z UK002X 2025-07-04T12:15:15.496Z 2025-07-10T12:26:02.787Z
7028878 7028878 20250702233103_BTm3e UK002X 2025-07-04T12:14:24.106Z 2025-07-10T12:26:01.361Z
7028757 7028757 20250702232431_nmplE UK002X 2025-07-04T12:14:17.006Z 2025-07-10T12:26:01.002Z
7028752 7028752 20250702232406_2gzDj UK002X 2025-07-04T12:14:16.523Z 2025-07-10T12:26:00.968Z
7028714 7028714 20250702232307_ofvAn UK002X 2025-07-04T12:14:14.654Z 2025-07-10T12:26:00.807Z
7025688 7025688 20250703005348_UoPDh UK002X 2025-07-04T12:02:34.706Z 2025-07-12T12:55:59.392Z
7025149 7025149 20250703003302_qUN2G UK002X 2025-07-04T12:01:07.198Z 2025-07-12T12:55:44.015Z
7024941 7024941 20250703002129_GrNc8 UK002X 2025-07-04T12:00:31.493Z 2025-07-12T12:55:27.370Z
7001267 7001267 20250629231513_GHRxp UK002X 2025-07-01T12:04:21.894Z 2025-07-08T12:49:51.203Z
6993628 6993628 20250629005457_CO9qJ UK002X 2025-06-30T12:08:41.185Z 2025-07-07T12:30:21.774Z
6993538 6993538 20250629004608_Kn4Oc UK002X 2025-06-30T12:08:16.128Z 2025-07-07T12:30:20.910Z
6992926 6992926 20250628235638_qzwi7 UK002X 2025-06-30T12:06:01.309Z 2025-07-07T12:30:16.508Z
6992772 6992772 20250628234149_Q9h1i UK002X 2025-06-30T12:05:19.098Z 2025-07-07T12:30:15.064Z
6955031 6955031 20250622233224_CC2qi UK002X 2025-06-24T12:18:09.427Z 2025-07-01T12:53:02.119Z
6935815 6935815 20250621002405_942Eg UK002X 2025-06-22T12:13:07.097Z 2025-06-29T12:36:37.422Z
6935423 6935423 20250620234634_xHDBg UK002X 2025-06-22T12:12:06.027Z 2025-06-29T12:36:33.069Z
6920727 6920727 20250618235455_WZ3IY UK002X 2025-06-20T12:12:57.233Z 2025-06-27T12:39:43.080Z
6915555 6915555 20250618010639_q2I12 UK002X 2025-06-19T12:17:18.454Z 2025-06-26T12:36:44.465Z
6915406 6915406 20250618004906_6KMfY UK002X 2025-06-19T12:17:04.269Z 2025-06-26T12:36:43.999Z
6915295 6915295 20250618004259_DEbQq UK002X 2025-06-19T12:16:43.503Z 2025-06-26T12:36:43.482Z
6915144 6915144 20250618002637_kNlXo UK002X 2025-06-19T12:16:23.997Z 2025-06-26T12:36:42.910Z
6914649 6914649 20250617232456_62Wxy UK002X 2025-06-19T12:15:09.196Z 2025-06-26T12:36:40.597Z
6897148 6897148 20250615234653_UTS3p UK002X 2025-06-16T12:10:17.076Z 2025-06-24T12:59:21.348Z
6880825 6880825 20250610232338_dKpgj UK002X 2025-06-11T12:09:35.033Z 2025-06-18T12:42:03.577Z
6880774 6880774 20250610230006_2zm2h UK002X 2025-06-11T12:09:28.667Z 2025-06-18T12:42:00.302Z
6841997 6841997 20250601012345_2tfLf UK002X 2025-06-02T12:13:47.276Z 2025-06-09T12:45:46.049Z
6841418 6841418 20250531233132_C13s0 UK002X 2025-06-02T12:11:50.113Z 2025-06-09T12:45:16.062Z
6841261 6841261 20250531224854_dC3HK UK002X 2025-06-02T12:11:12.255Z 2025-06-09T12:44:55.400Z
6809498 6809498 20250526003030_Z2piJ UK002X 2025-05-27T12:16:40.473Z 2025-06-03T13:03:16.858Z
6809109 6809109 20250525232617_Mnd2Q UK002X 2025-05-27T12:15:55.373Z 2025-06-03T13:03:05.842Z
6808788 6808788 20250525222655_NBA4I UK002X 2025-05-27T12:15:00.710Z 2025-06-03T13:02:57.097Z
6787783 6787783 20250523005312_r9oia UK002X 2025-05-24T12:21:32.904Z 2025-05-31T13:14:45.299Z
6787493 6787493 20250523003006_j3vm3 UK002X 2025-05-24T12:20:57.192Z 2025-05-31T13:14:31.310Z
6787108 6787108 20250522234518_G3x6u UK002X 2025-05-24T12:20:07.272Z 2025-05-31T13:14:05.083Z
6786952 6786952 20250522232006_U4AVN UK002X 2025-05-24T12:19:54.621Z 2025-05-31T13:14:00.395Z
6786599 6786599 20250522220751_l3lxp UK002X 2025-05-24T12:19:01.851Z 2025-05-31T13:13:38.350Z
6780056 6780056 20250521230443_joTTR UK002X 2025-05-23T12:23:25.751Z 2025-05-30T13:09:07.146Z
6779986 6779986 20250521225634_QVzYR UK002X 2025-05-23T12:23:22.971Z 2025-05-30T13:09:05.606Z
6779967 6779967 20250521225120_MKnSG UK002X 2025-05-23T12:23:22.003Z 2025-05-30T13:09:04.988Z
6771021 6771021 20250521010654_DDKJ4 UK002X 2025-05-22T12:22:59.711Z 2025-05-29T13:09:28.227Z
6770935 6770935 20250521004717_XJDYk UK002X 2025-05-22T12:22:37.006Z 2025-05-29T13:09:25.650Z
6770806 6770806 20250521001430_BUDDO UK002X 2025-05-22T12:22:15.917Z 2025-05-29T13:09:19.112Z
6770658 6770658 20250520231251_5nMnr UK002X 2025-05-22T12:22:01.964Z 2025-05-29T13:09:12.111Z
6770565 6770565 20250520225104_L6w6a UK002X 2025-05-22T12:21:56.517Z 2025-05-29T13:09:08.891Z
6762711 6762711 20250520015322_pkyJV UK002X 2025-05-21T12:23:24.720Z 2025-05-28T13:14:07.871Z
6762692 6762692 20250520015252_PnTdS UK002X 2025-05-21T12:23:23.933Z 2025-05-28T13:14:07.565Z
6762381 6762381 20250520011725_7uBWK UK002X 2025-05-21T12:22:40.532Z 2025-05-28T13:13:56.746Z
6762284 6762284 20250520010125_wFwHe UK002X 2025-05-21T12:22:35.802Z 2025-05-28T13:13:54.902Z
6762209 6762209 20250520004943_276iu UK002X 2025-05-21T12:22:31.445Z 2025-05-28T13:13:52.767Z
6761684 6761684 20250519235801_28qLP UK002X 2025-05-21T12:21:45.684Z 2025-05-28T13:13:19.893Z
6761455 6761455 20250519233545_Yr4b3 UK002X 2025-05-21T12:21:34.602Z 2025-05-28T13:13:14.822Z

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