participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,923 rows where station_code = "UK009D" sorted by created_at descending
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 |
---|---|---|---|---|---|
5454805 | 5454805 | 20241031052205_JIlLt | UK009D | 2024-11-02T12:23:23.808Z | 2024-11-08T14:23:25.710Z |
5454786 | 5454786 | 20241031051641_voIyP | UK009D | 2024-11-02T12:23:23.145Z | 2024-11-08T14:23:25.649Z |
5454701 | 5454701 | 20241031045640_7NiVI | UK009D | 2024-11-02T12:23:17.136Z | 2024-11-08T14:23:24.775Z |
5454629 | 5454629 | 20241031044726_r5oo3 | UK009D | 2024-11-02T12:23:14.830Z | 2024-11-08T14:23:24.494Z |
5454490 | 5454490 | 20241031042951_5e20c | UK009D | 2024-11-02T12:23:07.644Z | 2024-11-08T14:23:23.366Z |
5454432 | 5454432 | 20241031042124_kcvkD | UK009D | 2024-11-02T12:23:06.223Z | 2024-11-08T14:23:22.962Z |
5454353 | 5454353 | 20241031041153_nz3u5 | UK009D | 2024-11-02T12:23:03.450Z | 2024-11-08T14:23:22.472Z |
5454298 | 5454298 | 20241031040629_135U2 | UK009D | 2024-11-02T12:22:59.134Z | 2024-11-08T14:23:22.053Z |
5454202 | 5454202 | 20241031035545_lYDGS | UK009D | 2024-11-02T12:22:54.431Z | 2024-11-08T14:23:21.340Z |
5454179 | 5454179 | 20241031035318_t8OWR | UK009D | 2024-11-02T12:22:53.876Z | 2024-11-08T14:23:20.978Z |
5454087 | 5454087 | 20241031034058_92XpZ | UK009D | 2024-11-02T12:22:50.489Z | 2024-11-08T14:23:20.310Z |
5453897 | 5453897 | 20241031031334_8gypc | UK009D | 2024-11-02T12:22:44.494Z | 2024-11-08T14:23:19.644Z |
5453855 | 5453855 | 20241031031012_yDb94 | UK009D | 2024-11-02T12:22:43.823Z | 2024-11-08T14:23:19.585Z |
5453778 | 5453778 | 20241031025835_68J4T | UK009D | 2024-11-02T12:22:42.472Z | 2024-11-08T14:23:19.036Z |
5453758 | 5453758 | 20241031025706_ga8U4 | UK009D | 2024-11-02T12:22:42.045Z | 2024-11-08T14:23:18.990Z |
5453756 | 5453756 | 20241031025647_ldDz8 | UK009D | 2024-11-02T12:22:41.985Z | 2024-11-08T14:23:18.989Z |
5453594 | 5453594 | 20241031022824_5Eolw | UK009D | 2024-11-02T12:22:36.686Z | 2024-11-08T14:23:18.170Z |
5453486 | 5453486 | 20241031021533_suTNg | UK009D | 2024-11-02T12:22:34.496Z | 2024-11-08T14:23:17.588Z |
5453476 | 5453476 | 20241031021532_ZYF4X | UK009D | 2024-11-02T12:22:34.408Z | 2024-11-08T14:23:17.584Z |
5453466 | 5453466 | 20241031021433_C3sav | UK009D | 2024-11-02T12:22:34.207Z | 2024-11-08T14:23:17.537Z |
5453411 | 5453411 | 20241031020958_T3SLL | UK009D | 2024-11-02T12:22:33.187Z | 2024-11-08T14:23:17.307Z |
5453372 | 5453372 | 20241031020641_vwfG0 | UK009D | 2024-11-02T12:22:32.794Z | 2024-11-08T14:23:17.225Z |
5453328 | 5453328 | 20241031020301_PjpLB | UK009D | 2024-11-02T12:22:31.868Z | 2024-11-08T14:23:16.735Z |
5453315 | 5453315 | 20241031020151_O3cL5 | UK009D | 2024-11-02T12:22:31.753Z | 2024-11-08T14:23:16.590Z |
5453285 | 5453285 | 20241031015652_K7bYT | UK009D | 2024-11-02T12:22:31.144Z | 2024-11-08T14:23:16.512Z |
5453277 | 5453277 | 20241031015617_QfTxY | UK009D | 2024-11-02T12:22:30.862Z | 2024-11-08T14:23:16.289Z |
5453253 | 5453253 | 20241031015350_Le1BT | UK009D | 2024-11-02T12:22:30.428Z | 2024-11-08T14:23:16.230Z |
5453241 | 5453241 | 20241031015324_KqijA | UK009D | 2024-11-02T12:22:30.218Z | 2024-11-08T14:23:16.209Z |
5453221 | 5453221 | 20241031015201_UuaOJ | UK009D | 2024-11-02T12:22:30.017Z | 2024-11-08T14:23:16.184Z |
5453069 | 5453069 | 20241031013303_Ny1pg | UK009D | 2024-11-02T12:22:25.550Z | 2024-11-08T14:23:15.854Z |
5453049 | 5453049 | 20241031013102_nc4av | UK009D | 2024-11-02T12:22:24.860Z | 2024-11-08T14:23:15.792Z |
5452884 | 5452884 | 20241101051524_N6Ojg | UK009D | 2024-11-02T12:19:31.740Z | 2024-11-09T14:24:35.601Z |
5452881 | 5452881 | 20241101051429_Hv5of | UK009D | 2024-11-02T12:19:31.569Z | 2024-11-09T14:24:35.473Z |
5452867 | 5452867 | 20241101050832_ncjNz | UK009D | 2024-11-02T12:19:30.691Z | 2024-11-09T14:24:35.150Z |
5452848 | 5452848 | 20241101050417_bFtS2 | UK009D | 2024-11-02T12:19:29.414Z | 2024-11-09T14:24:34.676Z |
5452837 | 5452837 | 20241101050110_SF9oD | UK009D | 2024-11-02T12:19:28.475Z | 2024-11-09T14:24:34.483Z |
5452827 | 5452827 | 20241101045726_toVX3 | UK009D | 2024-11-02T12:19:26.336Z | 2024-11-09T14:24:34.346Z |
5452571 | 5452571 | 20241101034306_XH2eP | UK009D | 2024-11-02T12:19:01.702Z | 2024-11-09T14:24:31.710Z |
5444493 | 5444493 | 20241031012558_2yC02 | UK009D | 2024-11-01T12:21:19.968Z | 2024-11-08T14:23:15.737Z |
5444479 | 5444479 | 20241031012455_BVFLH | UK009D | 2024-11-01T12:21:19.676Z | 2024-11-08T14:23:15.710Z |
5444401 | 5444401 | 20241031011652_8TAcL | UK009D | 2024-11-01T12:21:16.087Z | 2024-11-08T14:23:15.335Z |
5444391 | 5444391 | 20241031011553_zYtgX | UK009D | 2024-11-01T12:21:15.440Z | 2024-11-08T14:23:15.299Z |
5444366 | 5444366 | 20241031011222_WcKVh | UK009D | 2024-11-01T12:21:14.013Z | 2024-11-08T14:23:14.718Z |
5444325 | 5444325 | 20241031010828_TfB38 | UK009D | 2024-11-01T12:21:12.733Z | 2024-11-08T14:23:14.348Z |
5444315 | 5444315 | 20241031010744_mp9u2 | UK009D | 2024-11-01T12:21:12.473Z | 2024-11-08T14:23:14.325Z |
5444300 | 5444300 | 20241031010540_vvAxm | UK009D | 2024-11-01T12:21:12.258Z | 2024-11-08T14:23:14.289Z |
5444293 | 5444293 | 20241031010528_ZzFGc | UK009D | 2024-11-01T12:21:12.158Z | 2024-11-08T14:23:14.282Z |
5444284 | 5444284 | 20241031010507_wd3n4 | UK009D | 2024-11-01T12:21:12.105Z | 2024-11-08T14:23:14.279Z |
5444272 | 5444272 | 20241031010430_QV9mi | UK009D | 2024-11-01T12:21:11.976Z | 2024-11-08T14:23:14.270Z |
5444209 | 5444209 | 20241031005937_HXc0G | UK009D | 2024-11-01T12:21:10.099Z | 2024-11-08T14:23:14.114Z |
5444141 | 5444141 | 20241031005205_KUDsg | UK009D | 2024-11-01T12:21:07.767Z | 2024-11-08T14:23:14.019Z |
5444100 | 5444100 | 20241031004824_WynZy | UK009D | 2024-11-01T12:21:06.090Z | 2024-11-08T14:23:13.972Z |
5444094 | 5444094 | 20241031004703_i0231 | UK009D | 2024-11-01T12:21:05.843Z | 2024-11-08T14:23:13.914Z |
5444085 | 5444085 | 20241031004703_07GZP | UK009D | 2024-11-01T12:21:05.537Z | 2024-11-08T14:23:13.815Z |
5444078 | 5444078 | 20241031004701_eejQs | UK009D | 2024-11-01T12:21:05.517Z | 2024-11-08T14:23:13.805Z |
5444055 | 5444055 | 20241031004152_Huvtu | UK009D | 2024-11-01T12:21:03.779Z | 2024-11-08T14:23:13.767Z |
5444019 | 5444019 | 20241031003829_xy2xj | UK009D | 2024-11-01T12:21:01.792Z | 2024-11-08T14:23:13.547Z |
5444001 | 5444001 | 20241031003657_h09cj | UK009D | 2024-11-01T12:21:01.146Z | 2024-11-08T14:23:13.454Z |
5443923 | 5443923 | 20241031002938_eF623 | UK009D | 2024-11-01T12:20:57.366Z | 2024-11-08T14:23:13.237Z |
5443906 | 5443906 | 20241031002713_TZ28n | UK009D | 2024-11-01T12:20:56.258Z | 2024-11-08T14:23:13.067Z |
5443876 | 5443876 | 20241031002311_fZnmk | UK009D | 2024-11-01T12:20:55.240Z | 2024-11-08T14:23:12.960Z |
5443868 | 5443868 | 20241031002233_6iFui | UK009D | 2024-11-01T12:20:55.117Z | 2024-11-08T14:23:12.954Z |
5443852 | 5443852 | 20241031002028_bRhO6 | UK009D | 2024-11-01T12:20:54.411Z | 2024-11-08T14:23:12.731Z |
5443844 | 5443844 | 20241031002027_qulJ4 | UK009D | 2024-11-01T12:20:54.046Z | 2024-11-08T14:23:12.726Z |
5443793 | 5443793 | 20241031001542_P31Ct | UK009D | 2024-11-01T12:20:51.767Z | 2024-11-08T14:23:12.476Z |
5443752 | 5443752 | 20241031001103_GDQlG | UK009D | 2024-11-01T12:20:48.758Z | 2024-11-08T14:23:12.135Z |
5443719 | 5443719 | 20241031000803_OGizp | UK009D | 2024-11-01T12:20:47.636Z | 2024-11-08T14:23:12.049Z |
5443706 | 5443706 | 20241031000722_uL24G | UK009D | 2024-11-01T12:20:47.164Z | 2024-11-08T14:23:12.015Z |
5443630 | 5443630 | 20241030235603_BHI3e | UK009D | 2024-11-01T12:20:43.068Z | 2024-11-08T14:23:11.808Z |
5443604 | 5443604 | 20241030235042_kaeMR | UK009D | 2024-11-01T12:20:41.334Z | 2024-11-08T14:23:11.711Z |
5440902 | 5440902 | 20241030232203_YJQtQ | UK009D | 2024-11-01T12:15:58.710Z | 2024-11-08T14:23:11.004Z |
5440858 | 5440858 | 20241030231617_rOR0p | UK009D | 2024-11-01T12:15:55.201Z | 2024-11-08T14:23:10.835Z |
5440754 | 5440754 | 20241030230054_aZZ9M | UK009D | 2024-11-01T12:15:48.823Z | 2024-11-08T14:23:10.611Z |
5440721 | 5440721 | 20241030225441_VoZyV | UK009D | 2024-11-01T12:15:47.352Z | 2024-11-08T14:23:10.508Z |
5440611 | 5440611 | 20241030223312_rdKXI | UK009D | 2024-11-01T12:15:39.028Z | 2024-11-08T14:23:10.014Z |
5440597 | 5440597 | 20241030223112_2scyg | UK009D | 2024-11-01T12:15:38.649Z | 2024-11-08T14:23:09.976Z |
5440553 | 5440553 | 20241030222650_d3eYq | UK009D | 2024-11-01T12:15:36.599Z | 2024-11-08T14:23:09.899Z |
5440505 | 5440505 | 20241030222117_IjmIG | UK009D | 2024-11-01T12:15:33.764Z | 2024-11-08T14:23:09.743Z |
5440319 | 5440319 | 20241030215617_TNViU | UK009D | 2024-11-01T12:15:22.173Z | 2024-11-08T14:23:08.954Z |
5440315 | 5440315 | 20241030215554_ZwxHj | UK009D | 2024-11-01T12:15:21.835Z | 2024-11-08T14:23:08.939Z |
5440221 | 5440221 | 20241030214412_Q2xZa | UK009D | 2024-11-01T12:15:01.716Z | 2024-11-08T14:23:07.979Z |
5440186 | 5440186 | 20241030213846_GVFSz | UK009D | 2024-11-01T12:14:56.183Z | 2024-11-08T14:23:07.676Z |
5440107 | 5440107 | 20241030212312_cPqJP | UK009D | 2024-11-01T12:14:50.416Z | 2024-11-08T14:23:07.350Z |
5439999 | 5439999 | 20241030210438_SsIqy | UK009D | 2024-11-01T12:14:43.623Z | 2024-11-08T14:23:06.692Z |
5431394 | 5431394 | 20241029010442_Q7I7x | UK009D | 2024-10-31T12:20:04.698Z | 2024-11-06T14:27:23.402Z |
5431306 | 5431306 | 20241029005343_qcx7Y | UK009D | 2024-10-31T12:19:52.928Z | 2024-11-06T14:27:23.247Z |
5431121 | 5431121 | 20241029003021_88r8e | UK009D | 2024-10-31T12:19:36.948Z | 2024-11-06T14:27:22.820Z |
5431106 | 5431106 | 20241029002807_3O2z4 | UK009D | 2024-10-31T12:19:35.557Z | 2024-11-06T14:27:22.784Z |
5430769 | 5430769 | 20241028233559_vs1hb | UK009D | 2024-10-31T12:19:00.088Z | 2024-11-06T14:27:21.493Z |
5430688 | 5430688 | 20241028232227_LVVEF | UK009D | 2024-10-31T12:18:51.586Z | 2024-11-06T14:27:21.069Z |
5429648 | 5429648 | 20241028194426_iUJ1c | UK009D | 2024-10-31T12:16:51.457Z | 2024-11-06T14:27:16.700Z |
5421238 | 5421238 | 20241028051540_rnaTw | UK009D | 2024-10-30T12:19:45.038Z | 2024-11-05T14:27:17.870Z |
5408769 | 5408769 | 20241027034250_M3BSv | UK009D | 2024-10-29T12:16:49.334Z | 2024-11-04T14:29:00.465Z |
5408601 | 5408601 | 20241027033122_UIF1P | UK009D | 2024-10-29T12:16:38.868Z | 2024-11-04T14:28:59.671Z |
5408441 | 5408441 | 20241027032712_IWPFD | UK009D | 2024-10-29T12:16:29.522Z | 2024-11-04T14:28:59.407Z |
5408360 | 5408360 | 20241027032326_g33z3 | UK009D | 2024-10-29T12:16:24.794Z | 2024-11-04T14:28:59.284Z |
5406790 | 5406790 | 20241027015948_VWc9O | UK009D | 2024-10-29T12:14:42.191Z | 2024-11-04T14:28:56.383Z |
5406751 | 5406751 | 20241027015752_AmhKr | UK009D | 2024-10-29T12:14:38.965Z | 2024-11-04T14:28:56.335Z |
5406736 | 5406736 | 20241027015728_KpCWV | UK009D | 2024-10-29T12:14:36.903Z | 2024-11-04T14:28:56.326Z |
5406469 | 5406469 | 20241027013929_eAP5T | UK009D | 2024-10-29T12:14:11.950Z | 2024-11-04T14:28:55.735Z |
Advanced export
JSON shape: default, array, newline-delimited
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);