Broadband/Full Fibre Availability

Leicester City Council

@ukgov.broadband_full_fibre_availability

Table List

1 table(50.07 MB)

Table 1

@ukgov.broadband_full_fibre_availability.table_1

Broadband/Full Fibre Availability (csv)

50.07 MB
7728 rows
10 columns

census_area Census Area	all_premises All Premises	residential_premises Residential Premises	date Date	premises_unable_to_receive_above_30mbits_s_from_fixed_broadband Premises Unable To Receive Above 30mbits S From Fixed Broadband	geo_shape Geo Shape	geo_point_2d Geo Point 2d
E00068660	147	107	Wed Jan 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)		{"coordinates": [[[-1.140228117, 52.6578106556, 48.5536223324], [-1.1402171247, 52.6578055429, 48.5536045339], [-1.1399667045, 52.6576897664, 48.5531996153], [-1.1399621738, 52.6576908121, 48.5531949131], [-1.139919473, 52.6576678541, 48.5531231789], [-1.1398899972, 52.657654249, 48.5530755352], [-1…	52.6564487398, -1.14203929763
E00068661	276	249	Wed Jan 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)		{"coordinates": [[[-1.125455294, 52.6572380339, 48.5349552277], [-1.1253885867, 52.6571296032, 48.5347823827], [-1.1253881135, 52.6571288807, 48.5347811952], [-1.1253112515, 52.657004018, 48.534582098], [-1.1252522158, 52.6569082261, 48.5344292661], [-1.1252507981, 52.6569059688, 48.5344256302], [-1…	52.6551895013, -1.13063454982
E00068662	130	130	Wed Jan 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)		{"coordinates": [[[-1.1477111636, 52.6576197855, 48.5626690919], [-1.1477308802, 52.6574897002, 48.5625846544], [-1.1477459789, 52.6573902286, 48.5625201138], [-1.1476366584, 52.656875185, 48.5619552741], [-1.1477122221, 52.6568757283, 48.5620486727], [-1.1477607292, 52.656876077, 48.5621086285], [-…	52.6567124453, -1.15078915668
E00068664	155	137	Wed Jan 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	0.6	{"coordinates": [[[-1.1352803519, 52.6733295603, 48.5604761383], [-1.1352679293, 52.6731743479, 48.5603316668], [-1.1347038842, 52.6731781416, 48.5596407149], [-1.1345729045, 52.6731789831, 48.5594802303], [-1.1345577809, 52.6731791423, 48.559461752], [-1.1345338789, 52.6731792374, 48.5594324162], […	52.6705006995, -1.13683714313
E00068665	149	146	Wed Jan 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	3.9	{"coordinates": [[[-1.1467229332, 52.6688662985, 48.5708359741], [-1.1467332594, 52.6688619691, 48.5708450647], [-1.1467419605, 52.668859695, 48.5708538732], [-1.1467575534, 52.6688541452, 48.5708684251], [-1.1467585374, 52.6688537029, 48.570869267], [-1.1468484161, 52.6688214559, 48.5709529333], [-…	52.672180666, -1.14886699046
E00068666	128	128	Wed Jan 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)		{"coordinates": [[[-1.1449114181, 52.6663129691, 48.5664804168], [-1.144805692, 52.6662828179, 48.5663252436], [-1.144759496, 52.6662697226, 48.5662575075], [-1.1448558024, 52.6661328207, 48.5662618354], [-1.1448716047, 52.6660790105, 48.5662364122], [-1.144878675, 52.6660665691, 48.5662347376], [-1…	52.6665221943, -1.14924764273
E00068671	160	141	Wed Jan 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)		{"coordinates": [[[-1.126827744, 52.662933211, 48.5414042519], [-1.127598608, 52.6622217832, 48.5417595906], [-1.1281975402, 52.6614499491, 48.541852613], [-1.1282022484, 52.6613726023, 48.5417938102], [-1.1282035091, 52.6613521204, 48.541778258], [-1.1282082923, 52.6612709995, 48.5417163968], [-1.1…	52.6606798716, -1.12931471899
E00068672	122	121	Wed Jan 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)		{"coordinates": [[[-1.1468140831, 52.666232759, 48.5687536085], [-1.1468538578, 52.6661811882, 48.5687595364], [-1.1469266491, 52.6660869852, 48.5687705269], [-1.1469749297, 52.6660243311, 48.5687776729], [-1.1470178338, 52.6659685587, 48.5687839445], [-1.1470605091, 52.6659182669, 48.5687945019], […	52.6648497062, -1.14870345573
E00068673	128	128	Wed Jan 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)		{"coordinates": [[[-1.1343781252, 52.6616522491, 48.5496312324], [-1.1344203436, 52.6615515392, 48.549599112], [-1.1344240577, 52.6615424891, 48.549596129], [-1.1344357762, 52.6615293632, 48.5495995935], [-1.1344746188, 52.6614452553, 48.5495771784], [-1.1344967734, 52.6613975144, 48.5495645851], [-…	52.662576559, -1.13571660519
E00068674	128	128	Wed Jan 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)		{"coordinates": [[[-1.138522795, 52.663336027, 48.5561378337], [-1.1385423847, 52.6633441681, 48.5561687332], [-1.1386854381, 52.6634036254, 48.5563943842], [-1.1389108386, 52.6634974733, 48.5567500601], [-1.1389127748, 52.6634982063, 48.5567530533], [-1.139085678, 52.6632111471, 48.5567262815], [-1…	52.6641236523, -1.13845413759


CREATE TABLE table_1 (
  "census_area" VARCHAR,
  "all_premises" BIGINT,
  "residential_premises" BIGINT,
  "date" TIMESTAMP,
  "full_fibre_availability" DOUBLE,
  "residential_premises_with_full_fibre_availability" DOUBLE,
  "premises_unable_to_receive_above_30mbits_s_from_fixed_broadband" DOUBLE,
  "residential_premises_unable_to_receive_above_30mbits_s_dc8dcefc" DOUBLE,
  "geo_shape" VARCHAR,
  "geo_point_2d" VARCHAR
);