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

5,067 rows where station_code = "UK00CE" 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
9608347 9608347 20260403221730_dovyh UK00CE 2026-04-05T12:10:08.874Z 2026-04-06T12:20:07.056Z
9608242 9608242 20260403211132_4muJh UK00CE 2026-04-05T12:09:41.442Z 2026-04-06T12:20:00.058Z
9595540 9595540 20260330043910_b0Qxp UK00CE 2026-03-31T12:01:40.661Z 2026-04-06T12:30:08.344Z
9595414 9595414 20260330035528_NCv3v UK00CE 2026-03-31T12:01:20.441Z 2026-04-06T12:30:02.184Z
9595261 9595261 20260330031159_Now5w UK00CE 2026-03-31T12:00:55.426Z 2026-04-06T12:29:50.460Z
9594986 9594986 20260329011237_FS0a6 UK00CE 2026-03-30T12:10:43.435Z 2026-04-06T12:40:22.323Z
9594603 9594603 20260328232859_sgzMr UK00CE 2026-03-30T12:09:56.985Z 2026-04-06T12:40:01.227Z
9592942 9592942 20260329035922_7mnFd UK00CE 2026-03-30T12:02:22.981Z 2026-04-06T12:34:41.591Z
9592919 9592919 20260329035627_TPPei UK00CE 2026-03-30T12:02:20.122Z 2026-04-06T12:34:40.699Z
9592802 9592802 20260329032311_2MOkw UK00CE 2026-03-30T12:01:56.662Z 2026-04-06T12:34:28.457Z
9592797 9592797 20260329032309_QDQok UK00CE 2026-03-30T12:01:56.355Z 2026-04-06T12:34:28.364Z
9592735 9592735 20260329031105_QGzLk UK00CE 2026-03-30T12:01:47.331Z 2026-04-06T12:34:25.494Z
9592405 9592405 20260329020411_MWjre UK00CE 2026-03-30T12:00:54.254Z 2026-04-06T12:34:09.417Z
9592162 9592162 20260329011404_FMhYR UK00CE 2026-03-30T12:00:15.077Z 2026-04-06T12:33:51.920Z
9590019 9590019 20260328042847_Ada8V UK00CE 2026-03-29T12:01:52.246Z 2026-04-06T12:37:47.184Z
9589852 9589852 20260328041101_YOI3V UK00CE 2026-03-29T12:01:40.038Z 2026-04-06T12:37:36.053Z
9589656 9589656 20260328035622_MGBN7 UK00CE 2026-03-29T12:01:32.252Z 2026-04-06T12:37:30.568Z
9589533 9589533 20260328034437_kkO0x UK00CE 2026-03-29T12:01:24.428Z 2026-04-06T12:37:27.018Z
9589528 9589528 20260328034406_3TCTx UK00CE 2026-03-29T12:01:23.987Z 2026-04-06T12:37:26.884Z
9589388 9589388 20260328032219_p9Za3 UK00CE 2026-03-29T12:01:10.700Z 2026-04-06T12:37:21.760Z
9589300 9589300 20260328031252_NPzs1 UK00CE 2026-03-29T12:01:04.303Z 2026-04-06T12:37:19.252Z
9588795 9588795 20260328011822_Qkp2M UK00CE 2026-03-29T12:00:16.355Z 2026-04-06T12:36:51.724Z
9585237 9585237 20260325234937_PIZhQ UK00CE 2026-03-27T12:16:57.131Z 2026-04-03T12:39:52.141Z
9585181 9585181 20260325233828_KMhiA UK00CE 2026-03-27T12:16:53.539Z 2026-04-03T12:39:51.151Z
9585170 9585170 20260325233750_ai2lA UK00CE 2026-03-27T12:16:52.858Z 2026-04-03T12:39:50.946Z
9584798 9584798 20260325221604_zLrA2 UK00CE 2026-03-27T12:16:08.912Z 2026-04-03T12:39:41.289Z
9584681 9584681 20260325213516_RH9Lh UK00CE 2026-03-27T12:15:57.282Z 2026-04-03T12:39:26.294Z
9584655 9584655 20260325212810_SuSmQ UK00CE 2026-03-27T12:15:54.637Z 2026-04-03T12:39:25.512Z
9584568 9584568 20260325204407_ICdr5 UK00CE 2026-03-27T12:15:40.612Z 2026-04-03T12:39:22.072Z
9582186 9582186 20260326044930_mRbtV UK00CE 2026-03-27T12:04:51.082Z 2026-04-04T12:39:40.774Z
9581968 9581968 20260326041617_B5tBl UK00CE 2026-03-27T12:04:16.607Z 2026-04-04T12:39:33.011Z
9581865 9581865 20260326040338_79ILT UK00CE 2026-03-27T12:03:59.415Z 2026-04-04T12:39:23.062Z
9581708 9581708 20260326034648_I3GDI UK00CE 2026-03-27T12:03:43.251Z 2026-04-04T12:39:16.071Z
9581600 9581600 20260326033403_dtOb6 UK00CE 2026-03-27T12:03:28.469Z 2026-04-04T12:39:11.702Z
9581316 9581316 20260326024808_9Epol UK00CE 2026-03-27T12:02:41.041Z 2026-04-04T12:38:52.162Z
9581276 9581276 20260326024528_SocHO UK00CE 2026-03-27T12:02:36.395Z 2026-04-04T12:38:51.307Z
9581119 9581119 20260326022650_hXDVE UK00CE 2026-03-27T12:02:10.938Z 2026-04-04T12:38:43.282Z
9580509 9580509 20260326005712_yqcNF UK00CE 2026-03-27T12:00:40.053Z 2026-04-04T12:38:12.553Z
9576957 9576957 20260325032935_akEy7 UK00CE 2026-03-26T12:03:45.139Z 2026-04-03T12:36:26.887Z
9576015 9576015 20260325005835_OiIcc UK00CE 2026-03-26T12:00:58.478Z 2026-04-03T12:35:40.856Z
9575847 9575847 20260325002813_hlt9m UK00CE 2026-03-26T12:00:24.558Z 2026-04-03T12:35:26.359Z
9562878 9562878 20260323033042_2nqij UK00CE 2026-03-24T12:04:19.272Z 2026-03-31T12:26:28.292Z
9562670 9562670 20260323025839_c1PCH UK00CE 2026-03-24T12:03:43.276Z 2026-03-31T12:26:16.976Z
9562356 9562356 20260323021328_1xCHG UK00CE 2026-03-24T12:02:54.405Z 2026-03-31T12:26:08.510Z
9562343 9562343 20260323021051_xcyyb UK00CE 2026-03-24T12:02:52.609Z 2026-03-31T12:26:08.141Z
9562154 9562154 20260323013745_5sBi6 UK00CE 2026-03-24T12:02:18.640Z 2026-03-31T12:26:02.395Z
9561465 9561465 20260321233614_EOD3o UK00CE 2026-03-23T12:12:19.843Z 2026-03-29T12:21:07.434Z
9561421 9561421 20260321233128_SP63y UK00CE 2026-03-23T12:12:18.619Z 2026-03-29T12:21:07.126Z
9561021 9561021 20260321224658_dqYwF UK00CE 2026-03-23T12:12:09.639Z 2026-03-29T12:21:04.654Z
9560537 9560537 20260321213731_L6Ylh UK00CE 2026-03-23T12:11:51.037Z 2026-03-29T12:21:01.092Z
9560149 9560149 20260321203526_yU7o7 UK00CE 2026-03-23T12:11:39.011Z 2026-03-29T12:20:58.204Z
9560081 9560081 20260321203119_mYzA2 UK00CE 2026-03-23T12:11:37.565Z 2026-03-29T12:20:57.819Z
9555436 9555436 20260322045620_55Q4l UK00CE 2026-03-23T12:03:25.793Z 2026-03-30T12:28:26.543Z
9555312 9555312 20260322043915_EWkl0 UK00CE 2026-03-23T12:03:20.005Z 2026-03-30T12:28:24.626Z
9555291 9555291 20260322043712_tiXTu UK00CE 2026-03-23T12:03:19.442Z 2026-03-30T12:28:24.409Z
9555282 9555282 20260322043629_hOzkU UK00CE 2026-03-23T12:03:18.987Z 2026-03-30T12:28:24.206Z
9555156 9555156 20260322041013_CqVEV UK00CE 2026-03-23T12:03:11.790Z 2026-03-30T12:28:15.003Z
9555038 9555038 20260322035730_oz84h UK00CE 2026-03-23T12:03:05.881Z 2026-03-30T12:28:13.502Z
9554660 9554660 20260322032353_ydj8E UK00CE 2026-03-23T12:02:44.659Z 2026-03-30T12:28:06.845Z
9554575 9554575 20260322031834_0slq3 UK00CE 2026-03-23T12:02:41.370Z 2026-03-30T12:28:05.826Z
9554572 9554572 20260322031759_3yktZ UK00CE 2026-03-23T12:02:41.129Z 2026-03-30T12:28:05.760Z
9554236 9554236 20260322025057_E2rLN UK00CE 2026-03-23T12:02:21.724Z 2026-03-30T12:28:01.016Z
9553094 9553094 20260322011032_SrhGI UK00CE 2026-03-23T12:01:12.759Z 2026-03-30T12:27:34.773Z
9552927 9552927 20260322005617_aTSgu UK00CE 2026-03-23T12:01:00.725Z 2026-03-30T12:27:32.290Z
9552806 9552806 20260322004441_OaShs UK00CE 2026-03-23T12:00:52.873Z 2026-03-30T12:27:30.607Z
9552596 9552596 20260322002310_vBtOJ UK00CE 2026-03-23T12:00:36.345Z 2026-03-30T12:27:26.756Z
9552449 9552449 20260322001013_eLcmm UK00CE 2026-03-23T12:00:25.511Z 2026-03-30T12:27:24.287Z
9541552 9541552 20260319210125_cSqJv UK00CE 2026-03-21T12:29:09.783Z 2026-03-27T12:42:38.649Z
9534741 9534741 20260320041648_dgcOj UK00CE 2026-03-21T12:08:44.970Z 2026-03-28T12:34:21.505Z
9533332 9533332 20260320022427_19dRJ UK00CE 2026-03-21T12:05:10.724Z 2026-03-28T12:33:52.020Z
9533189 9533189 20260320021025_ukNmV UK00CE 2026-03-21T12:04:44.576Z 2026-03-28T12:33:50.021Z
9532903 9532903 20260320013608_dHc2o UK00CE 2026-03-21T12:03:55.254Z 2026-03-28T12:33:46.093Z
9531960 9531960 20260320000540_YzVsu UK00CE 2026-03-21T12:01:17.080Z 2026-03-28T12:33:23.162Z
9531811 9531811 20260319235216_F0LZa UK00CE 2026-03-21T12:00:54.370Z 2026-03-28T12:33:21.755Z
9531372 9531372 20260318230117_R3MQu UK00CE 2026-03-20T12:25:08.515Z 2026-03-26T12:39:19.053Z
9531132 9531132 20260318223230_L2Y74 UK00CE 2026-03-20T12:24:58.640Z 2026-03-26T12:39:17.624Z
9531129 9531129 20260318223229_V5Xjj UK00CE 2026-03-20T12:24:58.482Z 2026-03-26T12:39:17.609Z
9530954 9530954 20260318220514_ZntYU UK00CE 2026-03-20T12:24:52.548Z 2026-03-26T12:39:16.691Z
9530950 9530950 20260318220514_SleAW UK00CE 2026-03-20T12:24:52.416Z 2026-03-26T12:39:16.689Z
9530311 9530311 20260318203820_dvsXO UK00CE 2026-03-20T12:24:17.902Z 2026-03-26T12:39:11.302Z
9521769 9521769 20260319044236_RQJ3N UK00CE 2026-03-20T12:08:30.705Z 2026-03-27T12:41:10.573Z
9521581 9521581 20260319042719_cRp5W UK00CE 2026-03-20T12:08:14.412Z 2026-03-27T12:40:55.899Z
9521407 9521407 20260319041123_YjX0R UK00CE 2026-03-20T12:07:56.939Z 2026-03-27T12:40:54.456Z
9521398 9521398 20260319041123_7462E UK00CE 2026-03-20T12:07:56.494Z 2026-03-27T12:40:54.423Z
9521315 9521315 20260319040638_4ATIR UK00CE 2026-03-20T12:07:50.535Z 2026-03-27T12:40:53.790Z
9520968 9520968 20260319034605_ujrGJ UK00CE 2026-03-20T12:07:17.673Z 2026-03-27T12:40:49.404Z
9520391 9520391 20260319031248_z2Q62 UK00CE 2026-03-20T12:06:18.896Z 2026-03-27T12:40:42.553Z
9519728 9519728 20260319023242_IyrT6 UK00CE 2026-03-20T12:04:59.390Z 2026-03-27T12:40:34.822Z
9519540 9519540 20260319021555_9A85N UK00CE 2026-03-20T12:04:36.911Z 2026-03-27T12:40:32.210Z
9519063 9519063 20260319014243_oJ2yx UK00CE 2026-03-20T12:03:49.748Z 2026-03-27T12:40:17.592Z
9517557 9517557 20260318233841_MyBAk UK00CE 2026-03-20T12:00:42.360Z 2026-03-27T12:40:00.847Z
9517161 9517161 20260317224837_BepuI UK00CE 2026-03-19T12:27:16.029Z 2026-03-25T12:43:09.073Z
9517065 9517065 20260317223530_LN9Kq UK00CE 2026-03-19T12:27:09.068Z 2026-03-25T12:43:08.415Z
9511534 9511534 20260318035854_nMHpY UK00CE 2026-03-19T12:10:24.478Z 2026-03-26T12:37:37.710Z
9511514 9511514 20260318035739_li0fv UK00CE 2026-03-19T12:10:22.463Z 2026-03-26T12:37:37.553Z
9510984 9510984 20260318032902_ixXDH UK00CE 2026-03-19T12:09:08.571Z 2026-03-26T12:37:18.431Z
9509561 9509561 20260318015817_dirEs UK00CE 2026-03-19T12:05:39.737Z 2026-03-26T12:37:06.421Z
9508013 9508013 20260318000352_7956i UK00CE 2026-03-19T12:01:54.255Z 2026-03-26T12:36:54.998Z
9507968 9507968 20260317235817_YPkJ4 UK00CE 2026-03-19T12:01:48.055Z 2026-03-26T12:36:54.735Z
9507948 9507948 20260317235752_tSbZN UK00CE 2026-03-19T12:01:46.349Z 2026-03-26T12:36:54.629Z

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