Electorate

Cambridgeshire Insight

@ukgov.electorate1

Table List

1 table(19.53 KB)

South Cambridgeshire District Electorate

@ukgov.electorate1.south_cambridgeshire_district_electorate

19.53 KB
110 rows
11 columns

pollingdistrict PollingDistrict	pollingdistrictreference PollingDistrictReference	properties Properties	propertiespercentoftotal PropertiesPercentofTotal	electors Electors	electorspercentoftotal ElectorsPercentofTotal	electorsother ElectorsOther	ward Ward	pollingstation PollingStation	locationlatitude LocationLatitude	locationlongitude LocationLongitude
Balsham	ZA1	681	1.0493	1286	1.1165	2	Balsham	Church Hall, Church Lane, Balsham, Cambridge, CB21 4DS	52.133223	0.317283
Great Wilbraham	RF1	279	0.4298	498	0.4323		The Wilbrahams	Memorial Hall, Angle End, Great Wilbraham, Cambridge, CB21 5JG	52.195623	0.266253
Sawston	YE1	3087	4.7565	5504	4.7788	7	Sawston	Free Church Community Centre, 1 High Street, Sawston, Cambridge, CB22 3BG	52.124835	0.169188
Little Abington	YB1	243	0.3744	435	0.3776		The Abingtons	Abington Institute, 66 High Street, Great Abington, Cambridge, CB21 6AE	52.119782	0.237953
Whittlesford	WH1	669	1.0308	1247	1.0827	5	Whittlesford	Memorial Hall, Mill Lane, Whittlesford, Cambridge, CB22 4NE	52.111676	0.153696
Babraham	YC1	135	0.208	202	0.1753		The Abingtons	The George Inn, High Street, Babraham, Cambridge, CB22 3AG	52.130681	0.209843
Pampisford	YD1	149	0.2295	265	0.23		The Abingtons	The Village Hall, Church Lane, Pampisford, Cambridge, CB22 3ET	52.112596	0.185332
Rampton	SC1	199	0.3066	377	0.3273	1	Cottenham	Rampton Village Hall, 4 Church End, Rampton, Cambridge, CB24 8QA	52.29129	0.091893
Landbeach	OB1	402	0.6194	686	0.5956	2	Waterbeach	Village Hall, 1 Green End, Landbeach, Cambridge, CB25 9FD	52.264627	0.161834
Histon	OA1	1973	3.04	3593	3.1196	12	Histon and Impington	Baptist Church Hall, Station Road, Histon, Cambridge, CB24 9LQ	52.247262	0.108237


CREATE TABLE south_cambridgeshire_district_electorate (
  "pollingdistrict" VARCHAR,
  "pollingdistrictreference" VARCHAR,
  "properties" BIGINT,
  "propertiespercentoftotal" DOUBLE,
  "electors" BIGINT,
  "electorspercentoftotal" DOUBLE,
  "electorsother" BIGINT,
  "ward" VARCHAR,
  "pollingstation" VARCHAR,
  "locationlatitude" DOUBLE,
  "locationlongitude" DOUBLE
);