participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,445 rows where station_code = "UK00A1" 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 |
---|---|---|---|---|---|
5129583 | 5129583 | 20240917041110_SqkSJ | UK00A1 | 2024-09-19T12:11:50.357Z | 2024-09-19T12:11:50.357Z |
5129318 | 5129318 | 20240917034715_sBgNE | UK00A1 | 2024-09-19T12:11:27.198Z | 2024-09-19T12:11:27.198Z |
5128630 | 5128630 | 20240917021354_A0UF5 | UK00A1 | 2024-09-19T12:10:48.622Z | 2024-09-19T12:10:48.622Z |
5128527 | 5128527 | 20240917015702_3nlrT | UK00A1 | 2024-09-19T12:10:40.879Z | 2024-09-19T12:10:40.879Z |
5128327 | 5128327 | 20240917012654_Qx01F | UK00A1 | 2024-09-19T12:10:27.199Z | 2024-09-19T12:10:27.199Z |
5125097 | 5125097 | 20240918001410_6am9a | UK00A1 | 2024-09-19T12:02:18.523Z | 2024-09-19T12:06:41.976Z |
5124998 | 5124998 | 20240917232107_yIlo3 | UK00A1 | 2024-09-19T12:01:55.280Z | 2024-09-19T12:06:41.960Z |
5124939 | 5124939 | 20240917225511_Tb0W8 | UK00A1 | 2024-09-19T12:01:50.051Z | 2024-09-19T12:06:41.954Z |
5124450 | 5124450 | 20240917202122_3xUrK | UK00A1 | 2024-09-19T12:00:56.519Z | 2024-09-19T12:06:41.896Z |
5124353 | 5124353 | 20240917194126_M6B2U | UK00A1 | 2024-09-19T12:00:37.904Z | 2024-09-19T12:06:41.881Z |
5122056 | 5122056 | 20240914043056_0sCUs | UK00A1 | 2024-09-18T12:11:05.224Z | 2024-09-19T12:20:02.721Z |
5121932 | 5121932 | 20240914042122_nzVpm | UK00A1 | 2024-09-18T12:11:03.135Z | 2024-09-19T12:20:02.522Z |
5121907 | 5121907 | 20240914042049_SgPXm | UK00A1 | 2024-09-18T12:11:02.850Z | 2024-09-19T12:20:02.484Z |
5121803 | 5121803 | 20240914041444_X5k9h | UK00A1 | 2024-09-18T12:11:01.470Z | 2024-09-19T12:20:02.372Z |
5121647 | 5121647 | 20240914041046_BxDaJ | UK00A1 | 2024-09-18T12:10:59.013Z | 2024-09-19T12:20:02.204Z |
5121287 | 5121287 | 20240914035735_3ZFB2 | UK00A1 | 2024-09-18T12:10:54.066Z | 2024-09-19T12:20:01.587Z |
5121066 | 5121066 | 20240914035025_3qCc6 | UK00A1 | 2024-09-18T12:10:50.420Z | 2024-09-19T12:20:01.282Z |
5120994 | 5120994 | 20240914034522_uhIys | UK00A1 | 2024-09-18T12:10:49.129Z | 2024-09-19T12:20:01.091Z |
5120484 | 5120484 | 20240914032422_aFoEW | UK00A1 | 2024-09-18T12:10:42.049Z | 2024-09-19T12:20:00.493Z |
5119748 | 5119748 | 20240914024744_qKYry | UK00A1 | 2024-09-18T12:10:25.632Z | 2024-09-19T12:19:58.862Z |
5119318 | 5119318 | 20240914022258_gF0ug | UK00A1 | 2024-09-18T12:10:19.875Z | 2024-09-19T12:19:57.916Z |
5119181 | 5119181 | 20240914021544_K4t4E | UK00A1 | 2024-09-18T12:10:17.949Z | 2024-09-19T12:19:57.352Z |
5117430 | 5117430 | 20240915043301_lxCmY | UK00A1 | 2024-09-18T12:07:41.426Z | 2024-09-19T12:19:15.033Z |
5117424 | 5117424 | 20240915043237_MSlzq | UK00A1 | 2024-09-18T12:07:41.301Z | 2024-09-19T12:19:15.024Z |
5117106 | 5117106 | 20240915040250_U52LG | UK00A1 | 2024-09-18T12:07:32.803Z | 2024-09-19T12:19:13.386Z |
5116862 | 5116862 | 20240915034432_ESaip | UK00A1 | 2024-09-18T12:07:22.789Z | 2024-09-19T12:19:12.471Z |
5116648 | 5116648 | 20240915033414_U3Hq6 | UK00A1 | 2024-09-18T12:07:14.587Z | 2024-09-19T12:19:11.831Z |
5116529 | 5116529 | 20240915033058_N4Qn0 | UK00A1 | 2024-09-18T12:07:08.915Z | 2024-09-19T12:19:11.486Z |
5115959 | 5115959 | 20240915030148_7J6bj | UK00A1 | 2024-09-18T12:06:32.731Z | 2024-09-19T12:19:08.002Z |
5115850 | 5115850 | 20240915025616_2fhWJ | UK00A1 | 2024-09-18T12:06:28.053Z | 2024-09-19T12:19:07.522Z |
5115655 | 5115655 | 20240915024711_AbFZ5 | UK00A1 | 2024-09-18T12:06:20.400Z | 2024-09-19T12:19:06.031Z |
5114299 | 5114299 | 20240915013500_FRf7e | UK00A1 | 2024-09-18T12:05:09.545Z | 2024-09-19T12:18:57.389Z |
5114232 | 5114232 | 20240915013229_XxfcW | UK00A1 | 2024-09-18T12:05:07.995Z | 2024-09-19T12:18:57.090Z |
5114108 | 5114108 | 20240915012713_aniW3 | UK00A1 | 2024-09-18T12:05:02.374Z | 2024-09-19T12:18:56.084Z |
5113108 | 5113108 | 20240915002226_FdJ8u | UK00A1 | 2024-09-18T12:03:56.696Z | 2024-09-19T12:18:47.099Z |
5113023 | 5113023 | 20240915001539_dsvcZ | UK00A1 | 2024-09-18T12:03:51.257Z | 2024-09-19T12:18:46.481Z |
5112233 | 5112233 | 20240914223913_ZsAyp | UK00A1 | 2024-09-18T12:02:54.665Z | 2024-09-19T12:18:39.869Z |
5112106 | 5112106 | 20240914221447_3Nuyy | UK00A1 | 2024-09-18T12:02:48.002Z | 2024-09-19T12:18:38.324Z |
5111974 | 5111974 | 20240914214849_4oPa0 | UK00A1 | 2024-09-18T12:02:34.408Z | 2024-09-19T12:18:35.960Z |
5111942 | 5111942 | 20240914214431_3hy7d | UK00A1 | 2024-09-18T12:02:31.384Z | 2024-09-19T12:18:35.440Z |
5111880 | 5111880 | 20240914213012_Wk3ui | UK00A1 | 2024-09-18T12:02:28.267Z | 2024-09-19T12:18:34.845Z |
5111773 | 5111773 | 20240914211540_3Jfn3 | UK00A1 | 2024-09-18T12:02:16.119Z | 2024-09-19T12:18:33.917Z |
5111396 | 5111396 | 20240914203230_zzwlw | UK00A1 | 2024-09-18T12:01:54.100Z | 2024-09-19T12:18:29.880Z |
5111278 | 5111278 | 20240914201530_Q2eI8 | UK00A1 | 2024-09-18T12:01:46.885Z | 2024-09-19T12:18:28.344Z |
5111267 | 5111267 | 20240914201501_mYUKW | UK00A1 | 2024-09-18T12:01:46.082Z | 2024-09-19T12:18:28.220Z |
5108252 | 5108252 | 20240913043626_l4o2z | UK00A1 | 2024-09-17T12:13:34.163Z | 2024-09-19T12:20:47.975Z |
5108211 | 5108211 | 20240913043131_d3Xeq | UK00A1 | 2024-09-17T12:13:32.534Z | 2024-09-19T12:20:47.917Z |
5107846 | 5107846 | 20240913041201_u4w43 | UK00A1 | 2024-09-17T12:13:24.508Z | 2024-09-19T12:20:47.586Z |
5107789 | 5107789 | 20240913040941_D2MXS | UK00A1 | 2024-09-17T12:13:23.622Z | 2024-09-19T12:20:47.536Z |
5107610 | 5107610 | 20240913040428_u8c5x | UK00A1 | 2024-09-17T12:13:18.887Z | 2024-09-19T12:20:47.330Z |
5107586 | 5107586 | 20240913040240_2pVXe | UK00A1 | 2024-09-17T12:13:17.605Z | 2024-09-19T12:20:47.281Z |
5107566 | 5107566 | 20240913040104_HZK8i | UK00A1 | 2024-09-17T12:13:17.040Z | 2024-09-19T12:20:47.222Z |
5107213 | 5107213 | 20240913034703_eaT0T | UK00A1 | 2024-09-17T12:13:10.607Z | 2024-09-19T12:20:46.908Z |
5107173 | 5107173 | 20240913034542_kp3gY | UK00A1 | 2024-09-17T12:13:10.273Z | 2024-09-19T12:20:46.871Z |
5107025 | 5107025 | 20240913034216_HMLrn | UK00A1 | 2024-09-17T12:13:08.100Z | 2024-09-19T12:20:46.784Z |
5106837 | 5106837 | 20240913033650_EvQFQ | UK00A1 | 2024-09-17T12:13:02.691Z | 2024-09-19T12:20:46.478Z |
5106782 | 5106782 | 20240913033429_Vg6vb | UK00A1 | 2024-09-17T12:13:00.994Z | 2024-09-19T12:20:46.394Z |
5106078 | 5106078 | 20240913030931_7kNqX | UK00A1 | 2024-09-17T12:12:41.543Z | 2024-09-19T12:20:45.444Z |
5105906 | 5105906 | 20240913030246_y664z | UK00A1 | 2024-09-17T12:12:32.462Z | 2024-09-19T12:20:45.047Z |
5105449 | 5105449 | 20240913024656_Bg793 | UK00A1 | 2024-09-17T12:12:17.751Z | 2024-09-19T12:20:44.553Z |
5105274 | 5105274 | 20240913024028_UF3A3 | UK00A1 | 2024-09-17T12:12:08.089Z | 2024-09-19T12:20:44.235Z |
5104390 | 5104390 | 20240913020703_6fIhb | UK00A1 | 2024-09-17T12:11:34.292Z | 2024-09-19T12:20:41.438Z |
5104324 | 5104324 | 20240913020509_RlMJz | UK00A1 | 2024-09-17T12:11:33.182Z | 2024-09-19T12:20:41.364Z |
5104082 | 5104082 | 20240913015024_CbWxx | UK00A1 | 2024-09-17T12:11:24.196Z | 2024-09-19T12:20:40.948Z |
5103476 | 5103476 | 20240913013113_8DvbC | UK00A1 | 2024-09-17T12:10:59.110Z | 2024-09-19T12:20:40.202Z |
5103360 | 5103360 | 20240913012913_Dd5no | UK00A1 | 2024-09-17T12:10:55.186Z | 2024-09-19T12:20:40.114Z |
5103208 | 5103208 | 20240914020443_Pypv7 | UK00A1 | 2024-09-17T12:07:58.362Z | 2024-09-19T12:19:56.888Z |
5103116 | 5103116 | 20240914020105_Hh87J | UK00A1 | 2024-09-17T12:07:52.079Z | 2024-09-19T12:19:56.629Z |
5103059 | 5103059 | 20240914015951_ajB7v | UK00A1 | 2024-09-17T12:07:49.545Z | 2024-09-19T12:19:56.478Z |
5102934 | 5102934 | 20240914015534_23V06 | UK00A1 | 2024-09-17T12:07:44.735Z | 2024-09-19T12:19:56.191Z |
5102782 | 5102782 | 20240914014354_NfqZf | UK00A1 | 2024-09-17T12:07:36.148Z | 2024-09-19T12:19:55.638Z |
5102640 | 5102640 | 20240914013431_0oVmH | UK00A1 | 2024-09-17T12:07:28.786Z | 2024-09-19T12:19:55.289Z |
5102193 | 5102193 | 20240914011203_25q6r | UK00A1 | 2024-09-17T12:06:54.139Z | 2024-09-19T12:19:52.731Z |
5102020 | 5102020 | 20240914010029_d7sEe | UK00A1 | 2024-09-17T12:06:41.936Z | 2024-09-19T12:19:52.238Z |
5101021 | 5101021 | 20240913235607_w29XS | UK00A1 | 2024-09-17T12:05:14.509Z | 2024-09-19T12:19:49.490Z |
5100881 | 5100881 | 20240913235114_VBA3a | UK00A1 | 2024-09-17T12:05:07.764Z | 2024-09-19T12:19:49.256Z |
5100662 | 5100662 | 20240913234010_uXGd9 | UK00A1 | 2024-09-17T12:04:47.988Z | 2024-09-19T12:19:48.440Z |
5100450 | 5100450 | 20240913232702_XfWQZ | UK00A1 | 2024-09-17T12:04:34.421Z | 2024-09-19T12:19:47.988Z |
5100443 | 5100443 | 20240913232701_sSbP2 | UK00A1 | 2024-09-17T12:04:34.038Z | 2024-09-19T12:19:47.979Z |
5100267 | 5100267 | 20240913231225_nwlol | UK00A1 | 2024-09-17T12:04:22.894Z | 2024-09-19T12:19:47.577Z |
5099976 | 5099976 | 20240913222943_F9HlP | UK00A1 | 2024-09-17T12:03:47.544Z | 2024-09-19T12:19:46.633Z |
5099935 | 5099935 | 20240913222341_GN3zg | UK00A1 | 2024-09-17T12:03:43.885Z | 2024-09-19T12:19:46.379Z |
5099769 | 5099769 | 20240913215446_pC8Ki | UK00A1 | 2024-09-17T12:03:33.101Z | 2024-09-19T12:19:45.838Z |
5099452 | 5099452 | 20240913211635_hl7m7 | UK00A1 | 2024-09-17T12:02:58.622Z | 2024-09-19T12:19:44.977Z |
5099426 | 5099426 | 20240913211253_N7nj2 | UK00A1 | 2024-09-17T12:02:55.784Z | 2024-09-19T12:19:44.874Z |
5099374 | 5099374 | 20240913210606_iTXdO | UK00A1 | 2024-09-17T12:02:49.736Z | 2024-09-19T12:19:44.630Z |
5098202 | 5098202 | 20240913012201_Wm6P1 | UK00A1 | 2024-09-16T12:17:21.631Z | 2024-09-19T12:20:39.852Z |
5097967 | 5097967 | 20240913011033_axzhn | UK00A1 | 2024-09-16T12:17:17.379Z | 2024-09-19T12:20:39.229Z |
5094828 | 5094828 | 20240912042506_ScUv8 | UK00A1 | 2024-09-16T12:14:58.972Z | 2024-09-19T12:21:16.442Z |
5094790 | 5094790 | 20240912042312_KQfgV | UK00A1 | 2024-09-16T12:14:58.643Z | 2024-09-19T12:21:16.432Z |
5094767 | 5094767 | 20240912042215_Qydjv | UK00A1 | 2024-09-16T12:14:57.757Z | 2024-09-19T12:21:16.417Z |
5094716 | 5094716 | 20240912041732_3odKs | UK00A1 | 2024-09-16T12:14:56.696Z | 2024-09-19T12:21:16.400Z |
5094692 | 5094692 | 20240912041446_5Z3uM | UK00A1 | 2024-09-16T12:14:54.419Z | 2024-09-19T12:21:16.376Z |
5094275 | 5094275 | 20240912035448_IvS3R | UK00A1 | 2024-09-16T12:14:40.288Z | 2024-09-19T12:21:16.047Z |
5093626 | 5093626 | 20240912032920_0bllW | UK00A1 | 2024-09-16T12:14:22.808Z | 2024-09-19T12:21:15.533Z |
5093492 | 5093492 | 20240912032419_f002U | UK00A1 | 2024-09-16T12:14:18.903Z | 2024-09-19T12:21:15.382Z |
5093311 | 5093311 | 20240912031744_VVpfB | UK00A1 | 2024-09-16T12:14:15.163Z | 2024-09-19T12:21:15.219Z |
5092935 | 5092935 | 20240912030150_rOC3Q | UK00A1 | 2024-09-16T12:14:07.349Z | 2024-09-19T12:21:14.713Z |
5091122 | 5091122 | 20240912015810_EDa6H | UK00A1 | 2024-09-16T12:12:50.100Z | 2024-09-19T12:21:12.574Z |
5090899 | 5090899 | 20240912015005_RDmc0 | UK00A1 | 2024-09-16T12:12:40.781Z | 2024-09-19T12:21:12.279Z |
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);