Author

Steve Nolan

1 Background

For the CHerPP project it will be important to understand the demographics of the area around the dock redevelopment project and beyond. This is important to ensure that we can gain as close to a representative sample as possible.

Given the nature of the project ethnicity will be an important demographic factor. ## Preamble

We are using the NOMIS API to access this data so will need to load the nomisr package. Also load the other standard packages as well.

Code
# load libraries
library(ggplot2)
library(dplyr)
library(nomisr)
library(kableExtra)
library(sf)
library(raster)

2 Finding the correct data

First we have a look at all data available through NOMIS the includes population.

Code
  first <- nomis_search(name = '*population*')

  first[, c("id", "name.value")] %>%
    kable %>%
    kable_styling("striped", full_width = F) %>%
    scroll_box(height = "200px")
id name.value
NM_17_1 annual population survey
NM_17_5 annual population survey (variables (percentages))
NM_31_1 Population estimates - local authority based by five year age band
NM_100_1 annual population survey - workplace analysis
NM_136_1 annual population survey - households by combined economic activity status
NM_137_1 annual population survey - households with dependent children and type
NM_143_1 QS102EW - Population density
NM_144_1 KS101EW - Usual resident population
NM_150_1 ST102EWla - Population density
NM_151_1 WD102EW - Population density
NM_154_1 WD702EW - Distance travelled to work (Workday population)
NM_155_1 WP102EW - Population density (Workplace population)
NM_156_1 WP702EW - Distance travelled to work (Workplace population)
NM_157_1 OT102EW - Population density (Out of term-time population)
NM_158_1 KS101UK - Usual resident population
NM_160_1 QS102UK - Population density
NM_168_1 annual population survey - regional - employment by occupation (SOC2010)
NM_169_1 annual population survey - regional - nationality
NM_170_1 annual population survey - regional - labour market status by age
NM_179_1 annual population survey - regional - country of birth
NM_180_1 annual population survey - regional - ethnicity by industry
NM_181_1 annual population survey - regional - economic inactivity by reasons
NM_210_1 annual population survey - regional - occupation (SOC2010) by sex by employment type
NM_218_1 annual population survey - regional - occupation (SOC2020) by sex by employment type
NM_509_1 Population
NM_942_1 WD601EW - Economic activity (Workday population)
NM_943_1 WD604EW - Hours worked (Workday population)
NM_944_1 WD605EW - Industry (Workday population)
NM_945_1 WD606EW - Occupation (Workday population)
NM_946_1 WD607EW - NS-SeC (Workday population)
NM_947_1 WD613EW - Approximated Social Grade (Workday population)
NM_949_1 WD703EW - Method of travel to work (2001 specification) (Workday population)
NM_950_1 WD1101EW - Sex by Age (Workday population)
NM_1234_1 SH05a - Non-private population - Not hotels - Persons [1961 Census]
NM_1238_1 SH09 - Non-private population - hotels [1961 Census]
NM_1255_1 SH05b - Non-private population - Not hotels - Establishments [1961 Census]
NM_1300_1 WP101EW - Population (Workplace population)
NM_1302_1 WP201EW - Ethnic group (Workplace population)
NM_1303_1 WP203EW - Country of birth (Workplace population)
NM_1304_1 WP204EW - Main language (Workplace population)
NM_1305_1 WP206WA - Welsh language skills (Workplace population)
NM_1306_1 WP207WA - Welsh language skills (detailed) (Workplace population)
NM_1307_1 WP210EW - Religion (Workplace population)
NM_1308_1 WP212EW - Passports held (detailed) (Workplace population)
NM_1309_1 WP302EW - General Health (Workplace population)
NM_1310_1 WP403EW - Tenure - People (Workplace population)
NM_1311_1 WP501EW - Highest level of qualification (Workplace population)
NM_1312_1 WP601EW - Employment Status (Workplace population)
NM_1313_1 WP604EW - Hours worked (Workplace population)
NM_1314_1 WP605EW - Industry (Workplace population)
NM_1315_1 WP606EW - Occupation (Minor groups) (Workplace population)
NM_1316_1 WP607EW - NS-SeC (Workplace population)
NM_1317_1 WP613EW - Approximated social grade (Workplace population)
NM_1318_1 WP703EW - Method of travel to work (2001 specification) (Workplace population)
NM_1319_1 WP803EW - Length of residence in the UK (Workplace population)
NM_1320_1 WP1101EW - Sex by single year of age (Workplace population)
NM_1321_1 WP6110EW - Industry by age (Workplace population)
NM_1322_1 WP6112EW - Occupation by age (Workplace population)
NM_1323_1 WP6501EW - Occupation by highest level of qualification (Workplace population)
NM_1324_1 WP6503EW - Industry by highest level of qualification (Workplace population)
NM_1325_1 WP6604EW - Occupation by industry (Workplace population)
NM_1326_1 WP7101EW - Method of travel to work by age (Workplace population)
NM_1327_1 WP7102EW - Distance travelled to work by age (Workplace population)
NM_1328_1 WP7606EW - Distance travelled to work by industry (Workplace population)
NM_1329_1 WP7607EW - Distance travelled to work by occupation (Workplace population)
NM_1330_1 WP7701EW - Method of travel to work (2001 specification) by distance travelled to work (Workplace population)
NM_1331_1 WP7103EW - Workplace and usual residence by method of travel to work (2001 specification) (Workplace population)
NM_1351_1 OT107EW - Marital and civil partnership status (Out of term-time population)
NM_1352_1 OT1101EW - Sex by five-year age group (Out of term-time population)
NM_1353_1 OT1117EW - Sex by single year of age (Out of term-time population)
NM_1354_1 OT201EW - Ethnic group (Out of term-time population)
NM_1355_1 OT203EW - Country of birth (detailed) (Out of term-time population)
NM_1356_1 OT204EW - Main language (detailed) (Out of term-time population)
NM_1357_1 OT206WA - Welsh Language Skills (Out of term-time population)
NM_1358_1 OT207WA - Welsh Language Skills (Detailed) (Out of term-time population)
NM_1359_1 OT210EW - Religion (Out of term-time population)
NM_1360_1 OT212EW - Passports held (detailed) (Out of term-time population)
NM_1361_1 OT301EW - Provision of unpaid care (Out of term-time population)
NM_1362_1 OT302EW - General health (Out of term-time population)
NM_1363_1 OT501EW - Highest level of qualification (Out of term-time population)
NM_1364_1 OT601EW - Economic activity (Out of term-time population)
NM_1365_1 OT603EW - Economic activity - Full-time students (Out of term-time population)
NM_1366_1 OT604EW - Hours worked (Out of term-time population)
NM_1367_1 OT605EW - Industry (Out of term-time population)
NM_1368_1 OT606EW - Occupation (Minor groups) (Out of term-time population)
NM_1369_1 OT607EW - NS-SeC (Out of term-time population)
NM_1370_1 OT803EW - Length of residence in the UK (Out of term-time population)
NM_1420_1 CR03 - Acreage, population, private families and dwellings [1921 census]
NM_1423_1 CR12 - Institutions: Number, total population and inmates [1921 census]
NM_1428_1 CR21 - Birthplaces of the Population [1921 census]
NM_1429_1 CR22 - Foreign born population by country of birth and nationality [1921 census]
NM_1634_1 KS001 - Usual resident population
NM_1635_1 UV001 - Population
NM_1660_1 UV039 - Method of travel to work - resident population
NM_1689_1 UV075 - Age (workplace population)
NM_1690_1 UV076 - NS-SeC (workplace population)
NM_1691_1 UV078 - Approximated Social Grade (Workplace Population)
NM_1692_1 UV080 - Distance Travelled To Work (Workplace Population)
NM_1697_1 UV002 - Population density
NM_1897_1 ST129 - Sex and distance travelled to work by method of travel to work (workplace population)
NM_1898_1 ST130 - Sex and industry by distance travelled to work (workplace population; no ward data)
NM_1899_1 ST131 - Sex and industry by highest level of qualification (workplace population; no ward data)
NM_1900_1 ST132 - Sex and industry by occupation (workplace population; no ward data)
NM_1939_1 TT010 - Theme table on resident, workplace and daytime population
NM_2002_1 Population estimates - local authority based by single year of age
NM_2006_1 Population projections - local authority based by single year of age
NM_2009_1 National Population projections by single year of age
NM_2010_1 Population estimates - small area based by single year of age - England and Wales
NM_2026_1 TS006 - Population density
NM_2090_1 TS073 - Population who have previously served in UK armed forces in communal establishments and in households

Let’s stick with the Annual Population Survey for now. Lets get a list of all the ways the data breaks down filtering for different ethnic groups. For now we will focus in on “All ages” and no gender split.

Code
  first <- nomis_get_metadata(id = "NM_17_5", concept = "variable")
  first_filter <- first %>% 
    filter((grepl('Percentage of population aged 16+', description.en) & grepl('Black|White|Asian|mixed|Indian|Pakistani/Bangladeshi|other ethnic group', description.en)) | id == 557) 
  first_filter %>%
    kable %>%
    kable_styling("striped", full_width = F) %>%
    scroll_box(height = "200px")
id label.en description.en
557 % of white - aged 16+ % of white - aged 16+
794 Percentage of population aged 16+ who are mixed ethnic group Percentage of population aged 16+ who are mixed ethnic group
795 Percentage of population aged 16+ who are Indian Percentage of population aged 16+ who are Indian
796 Percentage of population aged 16+ who are Pakistani/Bangladeshi Percentage of population aged 16+ who are Pakistani/Bangladeshi
797 Percentage of population aged 16+ who are Black or Black British Percentage of population aged 16+ who are Black or Black British
798 Percentage of population aged 16+ who are of other ethnic group Percentage of population aged 16+ who are of other ethnic group
Code
  eth_id <- first_filter$id

Now we want to find the code for parliamentary constituency.

Code
first <- nomis_get_metadata(id = "NM_17_5", concept = "geography", type = "type")


first %>% 
  kable %>%
    kable_styling("striped", full_width = F) %>%
    scroll_box(height = "200px")
id label.en description.en
TYPE83 jobcentre plus group as of April 2019 jobcentre plus group as of April 2019
TYPE84 jobcentre plus district as of April 2019 jobcentre plus district as of April 2019
TYPE225 major towns and cities major towns and cities
TYPE231 2011 scottish datazones 2011 scottish datazones
TYPE232 2011 scottish intermediate zones 2011 scottish intermediate zones
TYPE241 scottish parliamentary regions scottish parliamentary regions
TYPE247 2011 output area classification group 2011 output area classification group
TYPE248 2011 output area classification sub group 2011 output area classification sub group
TYPE249 2011 output area classification super group 2011 output area classification super group
TYPE297 2011 super output areas - middle layer 2011 super output areas - middle layer
TYPE298 2011 super output areas - lower layer 2011 super output areas - lower layer
TYPE299 2011 output areas 2011 output areas
TYPE307 2001 scottish data zones 2001 scottish data zones
TYPE310 2001 output areas 2001 output areas
TYPE338 output area classification group output area classification group
TYPE339 output area classification sub group output area classification sub group
TYPE340 output area classification super group output area classification super group
TYPE342 english index of multiple deprivation 2010 - deciles english index of multiple deprivation 2010 - deciles
TYPE347 scottish index of multiple deprivation 2009 - deciles scottish index of multiple deprivation 2009 - deciles
TYPE349 welsh index of multiple deprivation 2008 - deciles welsh index of multiple deprivation 2008 - deciles
TYPE425 senedd cymru electoral regions (as of May 2016) senedd cymru electoral regions (as of May 2016)
TYPE426 senedd cymru constituencies (as of May 2016) senedd cymru constituencies (as of May 2016)
TYPE431 local authorities: county / unitary (as of April 2021) local authorities: county / unitary (as of April 2021)
TYPE432 local authorities: district / unitary (as of April 2021) local authorities: district / unitary (as of April 2021)
TYPE433 local authorities: county / unitary (as of April 2019) local authorities: county / unitary (as of April 2019)
TYPE434 local authorities: district / unitary (as of April 2019) local authorities: district / unitary (as of April 2019)
TYPE437 nuts 2016 level 3 nuts 2016 level 3
TYPE438 nuts 2016 level 2 nuts 2016 level 2
TYPE439 nuts 2016 level 1 nuts 2016 level 1
TYPE442 combined authorities combined authorities
TYPE444 travel to work areas 2001-based travel to work areas 2001-based
TYPE447 travel to work areas 2011-based travel to work areas 2011-based
TYPE449 nuts 2013 level 3 nuts 2013 level 3
TYPE450 nuts 2013 level 2 nuts 2013 level 2
TYPE451 nuts 2013 level 1 nuts 2013 level 1
TYPE454 nuts 2010 level 1 nuts 2010 level 1
TYPE455 nuts 2010 level 2 nuts 2010 level 2
TYPE456 nuts 2010 level 3 nuts 2010 level 3
TYPE458 scottish parliamentary constituencies 2011 revision scottish parliamentary constituencies 2011 revision
TYPE459 local enterprise partnerships (as of April 2021) local enterprise partnerships (as of April 2021)
TYPE460 parliamentary constituencies 2010 parliamentary constituencies 2010
TYPE462 former metropolitan counties former metropolitan counties
TYPE463 local authorities: county / unitary (prior to April 2015) local authorities: county / unitary (prior to April 2015)
TYPE464 local authorities: district / unitary (prior to April 2015) local authorities: district / unitary (prior to April 2015)
TYPE465 travel to work areas 2001-based travel to work areas 2001-based
TYPE468 parliamentary constituencies 2005 revision parliamentary constituencies 2005 revision
TYPE469 english counties english counties
TYPE477 nuts 2003 level 1 nuts 2003 level 1
TYPE478 nuts 2003 level 2 nuts 2003 level 2
TYPE479 nuts 2003 level 3 nuts 2003 level 3
TYPE480 regions regions
TYPE482 pre-2009 local authorities: county / unitary pre-2009 local authorities: county / unitary
TYPE484 parliamentary constituencies 1995 revision parliamentary constituencies 1995 revision
TYPE486 pre-2009 local authorities: district / unitary pre-2009 local authorities: district / unitary
TYPE499 countries countries

For now let’s look at Parliamentary constituency 2010. Time to get the most recent data.

Code
aps_recent <- nomis_get_data(id = "NM_17_5", time = "latest", variable = eth_id, geography = "TYPE460", measures = 20599)

There is a fair bit of missing or suppressed data due to small sample sizes. But here is the breakdown by constituency for the various ethnic groups.

Code
aps_recent_white <- aps_recent[order(aps_recent$OBS_VALUE, decreasing = FALSE),] %>% 
  filter(VARIABLE == 557)


aps_recent_white[, c("GEOGRAPHY_NAME", "OBS_VALUE")] %>%
  kable(, caption = "% Whites over 16 by Parliamentary constituency") %>%
    kable_styling("striped", full_width = F) %>%
    scroll_box(height = "200px")
% Whites over 16 by Parliamentary constituency
GEOGRAPHY_NAME OBS_VALUE
Ilford South 18.4
Edmonton 25.9
Leicester East 26.3
Bethnal Green and Bow 28.5
Brent North 28.9
East Ham 29.7
West Ham 32.6
Harrow West 33.6
Birmingham, Ladywood 35.1
Hayes and Harlington 36.6
Birmingham, Hodge Hill 37.3
Ealing North 37.7
Harrow East 37.7
Bradford West 38.3
Ilford North 38.8
Feltham and Heston 39.0
Poplar and Limehouse 40.7
Slough 41.8
Birmingham, Yardley 42.5
Brent Central 43.1
Birmingham, Perry Barr 44.3
Barking 44.4
Croydon North 47.7
Coventry North East 49.0
Tottenham 49.5
Dagenham and Rainham 49.6
Walthamstow 49.6
Leicester South 50.7
Birmingham, Hall Green 52.5
Erith and Thamesmead 52.5
Bermondsey and Old Southwark 52.6
Leyton and Wanstead 52.7
Manchester Central 53.4
Hendon 53.4
Blackburn 53.6
Bradford East 53.7
Crawley 53.7
Ealing, Southall 55.0
Blackley and Broughton 55.4
Luton North 55.4
Kensington 55.9
Warley 56.1
Croydon Central 56.1
Wolverhampton South East 57.3
Islington North 58.4
Chingford and Woodford Green 58.7
Birmingham, Edgbaston 59.0
Eltham 59.1
Birmingham, Erdington 59.6
Cities of London and Westminster 60.0
Manchester, Gorton 60.1
Uxbridge and South Ruislip 60.3
Walsall South 60.7
Hackney North and Stoke Newington 60.8
Camberwell and Peckham 60.9
Sutton and Cheam 61.4
Luton South 61.8
Derby South 61.9
Hammersmith 62.4
Hackney South and Shoreditch 62.5
Vauxhall 62.5
Lewisham, Deptford 62.6
Westminster North 62.9
Hampstead and Kilburn 63.2
Bradford South 63.5
Nottingham East 64.8
Milton Keynes South 64.9
Northampton North 65.1
Wycombe 65.7
Harborough 66.3
Carshalton and Wallington 66.3
Finchley and Golders Green 66.4
Hornsey and Wood Green 66.4
Leicester West 66.5
Rochdale 66.8
Wimbledon 67.2
Sheffield, Brightside and Hillsborough 67.3
Ruislip, Northwood and Pinner 67.3
Coventry South 67.8
Newcastle upon Tyne Central 68.0
Leeds East 68.2
West Bromwich East 68.2
Glasgow North 68.2
Oldham West and Royton 68.3
Greenwich and Woolwich 68.8
Bolton South East 69.0
Huddersfield 69.5
Leeds Central 69.6
Bexleyheath and Crayford 69.9
Dulwich and West Norwood 70.0
Croydon South 70.2
Wolverhampton South West 70.5
Reading West 70.5
Dartford 70.6
Chipping Barnet 70.9
Islington South and Finsbury 70.9
Streatham 71.0
Coventry North West 71.2
Worsley and Eccles South 71.5
Woking 71.6
Battersea 71.7
Chelsea and Fulham 72.0
Mitcham and Morden 72.3
Putney 72.7
Bedford 72.8
Oxford East 72.8
Enfield, Southgate 72.9
Ealing Central and Acton 73.4
Glasgow Central 73.7
Brentford and Isleworth 73.8
Nottingham South 74.1
Holborn and St Pancras 74.4
Birmingham, Selly Oak 74.5
Thurrock 74.7
Romford 74.9
Lewisham West and Penge 75.3
Salford and Eccles 75.8
Wolverhampton North East 76.1
Welwyn Hatfield 76.5
Nottingham North 76.7
Rugby 77.1
Tooting 77.2
Richmond Park 77.3
Liverpool, Riverside 77.4
Watford 77.4
Loughborough 77.7
Sheffield Central 77.9
Milton Keynes North 77.9
Pendle 78.5
Bromley and Chislehurst 79.2
Derby North 79.4
Bristol East 79.4
Kingston and Surbiton 79.5
Basildon and Billericay 79.6
Cambridge 79.6
Peterborough 79.7
Doncaster Central 79.8
South Swindon 79.8
Edinburgh North and Leith 79.8
Solihull 79.9
Manchester, Withington 80.1
Colchester 80.2
Ipswich 80.2
Leeds West 80.3
Orpington 80.3
Rotherham 80.7
Lewisham East 80.7
Spelthorne 81.3
Preston 81.6
Warwick and Leamington 81.7
St Albans 81.7
Leeds North East 81.8
Halesowen and Rowley Regis 81.8
Sheffield, Heeley 82.3
Dudley North 82.3
Hornchurch and Upminster 82.3
Edinburgh South West 82.3
Halifax 82.5
Middlesbrough 82.6
Harlow 82.6
Runnymede and Weybridge 82.6
Reading East 82.7
Epping Forest 82.8
Wythenshawe and Sale East 82.9
Enfield North 82.9
Epsom and Ewell 83.1
Sheffield, Hallam 83.2
Charnwood 83.4
Sutton Coldfield 83.6
Aberdeen North 83.6
Northampton South 83.8
Stretford and Urmston 83.9
Romsey and Southampton North 83.9
Stockport 84.3
Batley and Spen 84.3
Cardiff Central 84.3
Hemel Hempstead 84.4
Oldham East and Saddleworth 84.5
Wokingham 84.5
Bristol West 84.6
Liverpool, Wavertree 84.9
Newcastle upon Tyne East 85.3
Mid Sussex 85.4
Stoke-on-Trent North 85.5
Canterbury 85.6
Old Bexley and Sidcup 85.7
Dewsbury 85.8
Aberdeen South 85.9
Altrincham and Sale West 86.2
Mid Bedfordshire 86.2
Redditch 86.3
Bournemouth West 86.3
Hyndburn 86.4
Brighton, Kemptown 86.5
Esher and Walton 86.5
Broxtowe 86.6
South West Hertfordshire 86.6
Erewash 86.8
Aylesbury 86.8
Gloucester 86.8
Ashton-under-Lyne 86.9
Twickenham 86.9
Birkenhead 87.0
Chatham and Aylesford 87.0
Broxbourne 87.1
Worcester 87.2
Newport East 87.2
Beaconsfield 87.3
South Northamptonshire 87.4
Burnley 87.5
Bury South 87.5
Norwich South 87.5
Gedling 87.6
Kenilworth and Southam 87.7
Plymouth, Sutton and Devonport 87.8
South East Cambridgeshire 87.9
Basingstoke 87.9
Cardiff South and Penarth 87.9
Heywood and Middleton 88.0
Rushcliffe 88.0
Beckenham 88.0
Bristol North West 88.0
Leeds North West 88.3
Birmingham, Northfield 88.3
Gravesham 88.3
Windsor 88.3
Maidenhead 88.4
Bracknell 88.6
Cardiff West 88.6
Stoke-on-Trent Central 88.7
Rochford and Southend East 88.7
North Swindon 88.8
Swansea West 88.8
Hertsmere 89.0
Bolton West 89.1
Edinburgh East 89.1
Glasgow North West 89.1
Glasgow South 89.1
Nuneaton 89.2
Dundee West 89.2
Sunderland Central 89.3
Lincoln 89.4
Sherwood 89.4
West Bromwich West 89.4
Saffron Walden 89.4
Brighton, Pavilion 89.4
Bootle 89.5
Chesham and Amersham 89.5
Cheadle 89.7
Liverpool, West Derby 89.8
Tatton 89.9
Hitchin and Harpenden 89.9
Wakefield 90.0
Edinburgh South 90.0
Gillingham and Rainham 90.1
Walsall North 90.2
Swansea East 90.2
Portsmouth South 90.4
Warrington South 90.5
Garston and Halewood 90.6
Mid Derbyshire 90.6
Aldridge-Brownhills 90.6
Stourbridge 90.6
Stevenage 90.6
North Warwickshire 90.8
Newport West 90.9
City of Chester 91.0
Fylde 91.0
Southampton, Test 91.0
Kingston upon Hull West and Hessle 91.2
The Wrekin 91.2
Brentwood and Ongar 91.2
Reigate 91.2
Pudsey 91.3
Chelmsford 91.4
Filton and Bradley Stoke 91.4
Livingston 91.4
Meriden 91.5
North East Hampshire 91.5
Rother Valley 91.6
South West Bedfordshire 91.6
South Basildon and East Thurrock 91.7
Pontypridd 91.7
Doncaster North 91.8
Morley and Outwood 91.8
Kettering 91.8
Telford 91.8
East Hampshire 91.8
Maidstone and The Weald 91.8
Bournemouth East 91.8
Taunton Deane 91.8
Southampton, Itchen 91.9
Gateshead 92.0
Kingston upon Hull North 92.1
South Cambridgeshire 92.1
North East Hertfordshire 92.4
Bury North 92.5
Stalybridge and Hyde 92.5
Bolton North East 92.6
Lancaster and Fleetwood 92.6
Keighley 92.6
Buckingham 92.6
Oxford West and Abingdon 92.6
Makerfield 92.7
West Suffolk 92.8
Aldershot 92.8
Wantage 92.8
North East Bedfordshire 93.0
Rossendale and Darwen 93.1
Rochester and Strood 93.1
Witney 93.1
Knowsley 93.2
Dudley South 93.2
Central Suffolk and North Ipswich 93.2
Cardiff North 93.2
Stockton South 93.3
Hertford and Stortford 93.3
Maldon 93.3
Stockton North 93.4
Calder Valley 93.4
Cumbernauld, Kilsyth and Kirkintilloch East 93.4
Glasgow North East 93.4
Warrington North 93.6
Daventry 93.6
Wyre Forest 93.6
Portsmouth North 93.6
Coatbridge, Chryston and Bellshill 93.6
Newcastle-under-Lyme 93.7
Mansfield 93.8
Southend West 93.8
Wrexham 93.8
Weaver Vale 93.9
Normanton, Pontefract and Castleford 93.9
Burton 93.9
Leigh 94.0
Banbury 94.0
Hove 94.0
Wealden 94.0
Bristol South 94.0
Exeter 94.0
South Shields 94.1
St Helens South and Whiston 94.1
York Central 94.1
East Surrey 94.1
Bath 94.1
Elmet and Rothwell 94.2
Stoke-on-Trent South 94.2
Ashford 94.2
Wells 94.2
Sheffield South East 94.3
Horsham 94.3
Cheltenham 94.3
Macclesfield 94.4
South Staffordshire 94.4
Newbury 94.4
North Devon 94.4
Arfon 94.4
West Lancashire 94.5
Winchester 94.5
Falkirk 94.5
Motherwell and Wishaw 94.5
York Outer 94.6
Lichfield 94.6
Witham 94.7
North West Cambridgeshire 94.8
Southport 94.9
Wentworth and Dearne 94.9
East Worthing and Shoreham 94.9
Chippenham 94.9
Harrogate and Knaresborough 95.0
Scunthorpe 95.0
Great Yarmouth 95.0
Blackpool South 95.1
Liverpool, Walton 95.1
Richmond (Yorks) 95.1
West Worcestershire 95.1
Bexhill and Battle 95.1
Mole Valley 95.1
Salisbury 95.1
Ellesmere Port and Neston 95.2
Rayleigh and Wickford 95.2
Henley 95.2
New Forest West 95.2
Edinburgh West 95.2
North East Fife 95.2
Hemsworth 95.3
West Aberdeenshire and Kincardine 95.3
Crewe and Nantwich 95.4
Stone 95.4
Vale of Clwyd 95.4
Dumfries and Galloway 95.4
South Ribble 95.5
Ashfield 95.5
Tunbridge Wells 95.5
Sevenoaks 95.6
Tonbridge and Malling 95.6
Halton 95.7
Paisley and Renfrewshire South 95.7
Haltemprice and Howden 95.8
Hereford and South Herefordshire 95.8
North West Norfolk 95.8
Lanark and Hamilton East 95.8
Gainsborough 95.9
Wellingborough 95.9
South Norfolk 95.9
Gosport 95.9
Kingswood 95.9
East Renfrewshire 95.9
City of Durham 96.0
Blackpool North and Cleveleys 96.0
Colne Valley 96.0
Don Valley 96.0
Corby 96.0
South Derbyshire 96.0
Dover 96.0
North West Hampshire 96.0
Darlington 96.1
Barnsley Central 96.1
Thirsk and Malton 96.1
Ludlow 96.1
Aberavon 96.1
Bridgend 96.1
Newcastle upon Tyne North 96.2
Penistone and Stocksbridge 96.2
Bassetlaw 96.2
Derbyshire Dales 96.2
North East Cambridgeshire 96.2
Tewkesbury 96.2
Stirling 96.2
Stafford 96.3
North Somerset 96.3
Penrith and The Border 96.4
Bosworth 96.4
Glasgow East 96.4
Linlithgow and East Falkirk 96.4
Sedgefield 96.5
Eastbourne 96.5
Faversham and Mid Kent 96.6
Meon Valley 96.6
Surrey Heath 96.6
Stroud 96.6
Inverclyde 96.6
West Dunbartonshire 96.6
Huntingdon 96.7
Hastings and Rye 96.7
Tynemouth 96.8
Wirral South 96.8
Great Grimsby 96.8
Staffordshire Moorlands 96.8
Castle Point 96.8
Eastleigh 96.8
Grantham and Stamford 97.0
North West Leicestershire 97.0
Bognor Regis and Littlehampton 97.0
Isle of Wight 97.0
South Thanet 97.0
Christchurch 97.0
Poole 97.0
Tiverton and Honiton 97.0
Preseli Pembrokeshire 97.0
Banff and Buchan 97.0
Glasgow South West 97.0
East Devon 97.1
Mid Dorset and North Poole 97.1
Jarrow 97.2
Wirral West 97.2
Caerphilly 97.2
Blyth Valley 97.3
Redcar 97.3
Wyre and Preston North 97.3
High Peak 97.3
Weston-Super-Mare 97.3
Chorley 97.4
Sefton Central 97.4
Shipley 97.4
Bromsgrove 97.4
Stratford-on-Avon 97.4
The Cotswolds 97.4
East Dunbartonshire 97.4
Kirkcaldy and Cowdenbeath 97.4
Sleaford and North Hykeham 97.5
Norwich North 97.5
Bridgwater and West Somerset 97.5
St Ives 97.5
Neath 97.5
Gordon 97.5
Berwick-upon-Tweed 97.6
Houghton and Sunderland South 97.6
Middlesbrough South and East Cleveland 97.6
Denton and Reddish 97.6
Guildford 97.6
Havant 97.6
Thornbury and Yate 97.6
Dundee East 97.6
Midlothian 97.6
Ochil and South Perthshire 97.6
Westmorland and Lonsdale 97.7
Skipton and Ripon 97.7
Chesterfield 97.7
Devizes 97.7
Forest of Dean 97.7
Ynys Mon 97.7
Rutherglen and Hamilton West 97.7
North Durham 97.8
Rutland and Melton 97.8
Braintree 97.8
Lewes 97.8
Torbay 97.8
Alyn and Deeside 97.8
Gower 97.8
North Shropshire 97.9
North Norfolk 97.9
New Forest East 97.9
Moray 97.9
South Leicestershire 98.0
Mid Worcestershire 98.0
Harwich and North Essex 98.0
Central Devon 98.0
North East Somerset 98.0
Monmouth 98.0
Blaenau Gwent 98.0
St Helens North 98.1
Brigg and Goole 98.1
Tamworth 98.1
Central Ayrshire 98.1
Eddisbury 98.2
Ribble Valley 98.2
North Herefordshire 98.2
Worthing West 98.2
Plymouth, Moor View 98.2
Inverness, Nairn, Badenoch and Strathspey 98.2
Morecambe and Lunesdale 98.3
Llanelli 98.3
Airdrie and Shotts 98.3
Ceredigion 98.4
Vale of Glamorgan 98.4
East Kilbride, Strathaven and Lesmahagow 98.4
Wigan 98.5
Mid Norfolk 98.5
Waveney 98.5
Newton Abbot 98.5
Truro and Falmouth 98.5
Rhondda 98.5
Hexham 98.6
Hazel Grove 98.6
Yeovil 98.6
Torfaen 98.6
Montgomeryshire 98.6
Angus 98.6
Hartlepool 98.7
North West Durham 98.7
Scarborough and Whitby 98.7
South Holland and The Deepings 98.7
Caithness, Sutherland and Easter Ross 98.7
East Lothian 98.7
North Ayrshire and Arran 98.7
Paisley and Renfrewshire North 98.7
North Tyneside 98.8
North Thanet 98.8
Sittingbourne and Sheppey 98.8
South East Cornwall 98.8
Totnes 98.8
Islwyn 98.8
Ayr, Carrick and Cumnock 98.8
Shrewsbury and Atcham 98.9
Fareham 98.9
Clwyd South 98.9
Perth and North Perthshire 98.9
South West Wiltshire 99.0
Aberconwy 99.0
Clwyd West 99.0
Carmarthen West and South Pembrokeshire 99.1
Brecon and Radnorshire 99.1
Dunfermline and West Fife 99.1
Bishop Auckland 99.2
Wallasey 99.2
Beverley and Holderness 99.2
Cleethorpes 99.2
South Suffolk 99.2
Chichester 99.2
Torridge and West Devon 99.2
Barrow and Furness 99.3
Arundel and South Downs 99.3
North Wiltshire 99.3
Dwyfor Meirionnydd 99.3
Merthyr Tydfil and Rhymney 99.3
Ogmore 99.3
Blaydon 99.4
East Yorkshire 99.4
Bury St Edmunds 99.4
South West Norfolk 99.4
West Dorset 99.4
Delyn 99.4
Clacton 99.5
Cynon Valley 99.5
Copeland 99.6
Folkestone and Hythe 99.6
Somerton and Frome 99.6
St Austell and Newquay 99.6
Argyll and Bute 99.6
Berwickshire, Roxburgh and Selkirk 99.6
Dumfriesshire, Clydesdale and Tweeddale 99.6
Wansbeck 99.7
Workington 99.7
Barnsley East 99.7
Camborne and Redruth 99.7
North Dorset 99.7
Glenrothes 99.7
Kilmarnock and Loudoun 99.7
Washington and Sunderland West 99.8
Carmarthen East and Dinefwr 99.8
Boston and Skegness 99.9
Easington 100.0
Carlisle 100.0
Congleton 100.0
Kingston upon Hull East 100.0
Selby and Ainsty 100.0
Amber Valley 100.0
Bolsover 100.0
Louth and Horncastle 100.0
Newark 100.0
North East Derbyshire 100.0
Cannock Chase 100.0
Broadland 100.0
Suffolk Coastal 100.0
South West Surrey 100.0
North Cornwall 100.0
South Dorset 100.0
South West Devon 100.0
Na h-Eileanan An Iar 100.0
Orkney and Shetland 100.0
Ross, Skye and Lochaber 100.0
Code
aps_recent_white <- aps_recent[order(aps_recent$OBS_VALUE, decreasing = TRUE),] %>% 
  filter(VARIABLE == 797)


aps_recent_white[, c("GEOGRAPHY_NAME", "OBS_VALUE")] %>%
  kable( , caption = "% Black British over 16 by Parliamentary constituency") %>%
    kable_styling("striped", full_width = F) %>%
    scroll_box(height = "200px")
% Black British over 16 by Parliamentary constituency
GEOGRAPHY_NAME OBS_VALUE
Edmonton 46.4
Erith and Thamesmead 31.6
Hayes and Harlington 27.1
Tottenham 26.3
Vauxhall 25.5
Barking 25.1
Brent North 25.1
Northampton North 23.8
Manchester Central 23.6
Bermondsey and Old Southwark 23.6
Dulwich and West Norwood 23.1
Camberwell and Peckham 22.2
Birmingham, Ladywood 21.9
Coventry North East 20.9
Croydon Central 20.9
Birmingham, Erdington 20.1
Birmingham, Perry Barr 19.4
Crawley 19.4
Walthamstow 18.8
Lewisham, Deptford 18.0
Hampstead and Kilburn 16.6
Hackney South and Shoreditch 16.5
Streatham 16.4
Poplar and Limehouse 16.1
Birmingham, Hodge Hill 16.0
Croydon North 15.5
Chingford and Woodford Green 15.3
Basildon and Billericay 14.3
Nottingham East 14.0
Hackney North and Stoke Newington 13.9
West Ham 13.4
East Ham 13.3
Hornchurch and Upminster 13.2
Dagenham and Rainham 13.1
Bristol East 12.7
Ilford South 12.6
Nottingham North 12.4
Leeds Central 12.2
Islington North 11.9
Lewisham West and Penge 11.9
Worsley and Eccles South 11.8
Thurrock 11.6
Greenwich and Woolwich 10.5
Romford 10.1
Rochdale 9.9
Bethnal Green and Bow 9.3
Milton Keynes South 9.0
Leicester South 8.8
South Northamptonshire 8.8
Islington South and Finsbury 8.8
Leeds East 8.7
Coventry South 8.5
Leicester East 8.4
Coventry North West 8.4
Wolverhampton South East 8.4
Luton South 8.3
Leyton and Wanstead 8.0
Wolverhampton South West 7.9
Kensington 7.9
Milton Keynes North 7.8
Luton North 7.6
Warley 7.4
Hornsey and Wood Green 7.2
Chatham and Aylesford 7.2
Sutton and Cheam 7.1
Slough 6.6
Wycombe 6.3
Heywood and Middleton 6.2
Derby North 5.6
Derby South 5.5
Middlesbrough 5.2
Reading West 5.2
Newport East 4.7
Rochford and Southend East 3.1
Berwick-upon-Tweed NA
Bishop Auckland NA
Blaydon NA
Blyth Valley NA
City of Durham NA
Darlington NA
Easington NA
Gateshead NA
Hartlepool NA
Hexham NA
Houghton and Sunderland South NA
Jarrow NA
Middlesbrough South and East Cleveland NA
Newcastle upon Tyne Central NA
Newcastle upon Tyne East NA
Newcastle upon Tyne North NA
North Durham NA
North Tyneside NA
North West Durham NA
Redcar NA
Sedgefield NA
South Shields NA
Stockton North NA
Stockton South NA
Sunderland Central NA
Tynemouth NA
Wansbeck NA
Washington and Sunderland West NA
Altrincham and Sale West NA
Ashton-under-Lyne NA
Barrow and Furness NA
Birkenhead NA
Blackburn NA
Blackley and Broughton NA
Blackpool North and Cleveleys NA
Blackpool South NA
Bolton North East NA
Bolton South East NA
Bolton West NA
Bootle NA
Burnley NA
Bury North NA
Bury South NA
Carlisle NA
Cheadle NA
Chorley NA
City of Chester NA
Congleton NA
Copeland NA
Crewe and Nantwich NA
Denton and Reddish NA
Eddisbury NA
Ellesmere Port and Neston NA
Fylde NA
Garston and Halewood NA
Halton NA
Hazel Grove NA
Hyndburn NA
Knowsley NA
Lancaster and Fleetwood NA
Leigh NA
Liverpool, Riverside NA
Liverpool, Walton NA
Liverpool, Wavertree NA
Liverpool, West Derby NA
Macclesfield NA
Makerfield NA
Manchester, Gorton NA
Manchester, Withington NA
Morecambe and Lunesdale NA
Oldham East and Saddleworth NA
Oldham West and Royton NA
Pendle NA
Penrith and The Border NA
Preston NA
Ribble Valley NA
Rossendale and Darwen NA
Salford and Eccles NA
Sefton Central NA
South Ribble NA
Southport NA
St Helens North NA
St Helens South and Whiston NA
Stalybridge and Hyde NA
Stockport NA
Stretford and Urmston NA
Tatton NA
Wallasey NA
Warrington North NA
Warrington South NA
Weaver Vale NA
West Lancashire NA
Westmorland and Lonsdale NA
Wigan NA
Wirral South NA
Wirral West NA
Workington NA
Wyre and Preston North NA
Wythenshawe and Sale East NA
Barnsley Central NA
Barnsley East NA
Batley and Spen NA
Beverley and Holderness NA
Bradford East NA
Bradford South NA
Bradford West NA
Brigg and Goole NA
Calder Valley NA
Cleethorpes NA
Colne Valley NA
Dewsbury NA
Don Valley NA
Doncaster Central NA
Doncaster North NA
East Yorkshire NA
Elmet and Rothwell NA
Great Grimsby NA
Halifax NA
Haltemprice and Howden NA
Harrogate and Knaresborough NA
Hemsworth NA
Huddersfield NA
Keighley NA
Kingston upon Hull East NA
Kingston upon Hull North NA
Kingston upon Hull West and Hessle NA
Leeds North East NA
Leeds North West NA
Leeds West NA
Morley and Outwood NA
Normanton, Pontefract and Castleford NA
Penistone and Stocksbridge NA
Pudsey NA
Richmond (Yorks) NA
Rother Valley NA
Rotherham NA
Scarborough and Whitby NA
Scunthorpe NA
Selby and Ainsty NA
Sheffield Central NA
Sheffield South East NA
Sheffield, Brightside and Hillsborough NA
Sheffield, Hallam NA
Sheffield, Heeley NA
Shipley NA
Skipton and Ripon NA
Thirsk and Malton NA
Wakefield NA
Wentworth and Dearne NA
York Central NA
York Outer NA
Amber Valley NA
Ashfield NA
Bassetlaw NA
Bolsover NA
Boston and Skegness NA
Bosworth NA
Broxtowe NA
Charnwood NA
Chesterfield NA
Corby NA
Daventry NA
Derbyshire Dales NA
Erewash NA
Gainsborough NA
Gedling NA
Grantham and Stamford NA
Harborough NA
High Peak NA
Kettering NA
Leicester West NA
Lincoln NA
Loughborough NA
Louth and Horncastle NA
Mansfield NA
Mid Derbyshire NA
Newark NA
North East Derbyshire NA
North West Leicestershire NA
Northampton South NA
Nottingham South NA
Rushcliffe NA
Rutland and Melton NA
Sherwood NA
Sleaford and North Hykeham NA
South Derbyshire NA
South Holland and The Deepings NA
South Leicestershire NA
Wellingborough NA
Aldridge-Brownhills NA
Birmingham, Edgbaston NA
Birmingham, Hall Green NA
Birmingham, Northfield NA
Birmingham, Selly Oak NA
Birmingham, Yardley NA
Bromsgrove NA
Burton NA
Cannock Chase NA
Dudley North NA
Dudley South NA
Halesowen and Rowley Regis NA
Hereford and South Herefordshire NA
Kenilworth and Southam NA
Lichfield NA
Ludlow NA
Meriden NA
Mid Worcestershire NA
Newcastle-under-Lyme NA
North Herefordshire NA
North Shropshire NA
North Warwickshire NA
Nuneaton NA
Redditch NA
Rugby NA
Shrewsbury and Atcham NA
Solihull NA
South Staffordshire NA
Stafford NA
Staffordshire Moorlands NA
Stoke-on-Trent Central NA
Stoke-on-Trent North NA
Stoke-on-Trent South NA
Stone NA
Stourbridge NA
Stratford-on-Avon NA
Sutton Coldfield NA
Tamworth NA
Telford NA
The Wrekin NA
Walsall North NA
Walsall South NA
Warwick and Leamington NA
West Bromwich East NA
West Bromwich West NA
West Worcestershire NA
Wolverhampton North East NA
Worcester NA
Wyre Forest NA
Bedford NA
Braintree NA
Brentwood and Ongar NA
Broadland NA
Broxbourne NA
Bury St Edmunds NA
Cambridge NA
Castle Point NA
Central Suffolk and North Ipswich NA
Chelmsford NA
Clacton NA
Colchester NA
Epping Forest NA
Great Yarmouth NA
Harlow NA
Harwich and North Essex NA
Hemel Hempstead NA
Hertford and Stortford NA
Hertsmere NA
Hitchin and Harpenden NA
Huntingdon NA
Ipswich NA
Maldon NA
Mid Bedfordshire NA
Mid Norfolk NA
North East Bedfordshire NA
North East Cambridgeshire NA
North East Hertfordshire NA
North Norfolk NA
North West Cambridgeshire NA
North West Norfolk NA
Norwich North NA
Norwich South NA
Peterborough NA
Rayleigh and Wickford NA
Saffron Walden NA
South Basildon and East Thurrock NA
South Cambridgeshire NA
South East Cambridgeshire NA
South Norfolk NA
South Suffolk NA
South West Bedfordshire NA
South West Hertfordshire NA
South West Norfolk NA
Southend West NA
St Albans NA
Stevenage NA
Suffolk Coastal NA
Watford NA
Waveney NA
Welwyn Hatfield NA
West Suffolk NA
Witham NA
Battersea NA
Beckenham NA
Bexleyheath and Crayford NA
Brent Central NA
Brentford and Isleworth NA
Bromley and Chislehurst NA
Carshalton and Wallington NA
Chelsea and Fulham NA
Chipping Barnet NA
Cities of London and Westminster NA
Croydon South NA
Ealing Central and Acton NA
Ealing North NA
Ealing, Southall NA
Eltham NA
Enfield North NA
Enfield, Southgate NA
Feltham and Heston NA
Finchley and Golders Green NA
Hammersmith NA
Harrow East NA
Harrow West NA
Hendon NA
Holborn and St Pancras NA
Ilford North NA
Kingston and Surbiton NA
Lewisham East NA
Mitcham and Morden NA
Old Bexley and Sidcup NA
Orpington NA
Putney NA
Richmond Park NA
Ruislip, Northwood and Pinner NA
Tooting NA
Twickenham NA
Uxbridge and South Ruislip NA
Westminster North NA
Wimbledon NA
Aldershot NA
Arundel and South Downs NA
Ashford NA
Aylesbury NA
Banbury NA
Basingstoke NA
Beaconsfield NA
Bexhill and Battle NA
Bognor Regis and Littlehampton NA
Bracknell NA
Brighton, Kemptown NA
Brighton, Pavilion NA
Buckingham NA
Canterbury NA
Chesham and Amersham NA
Chichester NA
Dartford NA
Dover NA
East Hampshire NA
East Surrey NA
East Worthing and Shoreham NA
Eastbourne NA
Eastleigh NA
Epsom and Ewell NA
Esher and Walton NA
Fareham NA
Faversham and Mid Kent NA
Folkestone and Hythe NA
Gillingham and Rainham NA
Gosport NA
Gravesham NA
Guildford NA
Hastings and Rye NA
Havant NA
Henley NA
Horsham NA
Hove NA
Isle of Wight NA
Lewes NA
Maidenhead NA
Maidstone and The Weald NA
Meon Valley NA
Mid Sussex NA
Mole Valley NA
New Forest East NA
New Forest West NA
Newbury NA
North East Hampshire NA
North Thanet NA
North West Hampshire NA
Oxford East NA
Oxford West and Abingdon NA
Portsmouth North NA
Portsmouth South NA
Reading East NA
Reigate NA
Rochester and Strood NA
Romsey and Southampton North NA
Runnymede and Weybridge NA
Sevenoaks NA
Sittingbourne and Sheppey NA
South Thanet NA
South West Surrey NA
Southampton, Itchen NA
Southampton, Test NA
Spelthorne NA
Surrey Heath NA
Tonbridge and Malling NA
Tunbridge Wells NA
Wantage NA
Wealden NA
Winchester NA
Windsor NA
Witney NA
Woking NA
Wokingham NA
Worthing West NA
Bath NA
Bournemouth East NA
Bournemouth West NA
Bridgwater and West Somerset NA
Bristol North West NA
Bristol South NA
Bristol West NA
Camborne and Redruth NA
Central Devon NA
Cheltenham NA
Chippenham NA
Christchurch NA
Devizes NA
East Devon NA
Exeter NA
Filton and Bradley Stoke NA
Forest of Dean NA
Gloucester NA
Kingswood NA
Mid Dorset and North Poole NA
Newton Abbot NA
North Cornwall NA
North Devon NA
North Dorset NA
North East Somerset NA
North Somerset NA
North Swindon NA
North Wiltshire NA
Plymouth, Moor View NA
Plymouth, Sutton and Devonport NA
Poole NA
Salisbury NA
Somerton and Frome NA
South Dorset NA
South East Cornwall NA
South Swindon NA
South West Devon NA
South West Wiltshire NA
St Austell and Newquay NA
St Ives NA
Stroud NA
Taunton Deane NA
Tewkesbury NA
The Cotswolds NA
Thornbury and Yate NA
Tiverton and Honiton NA
Torbay NA
Torridge and West Devon NA
Totnes NA
Truro and Falmouth NA
Wells NA
West Dorset NA
Weston-Super-Mare NA
Yeovil NA
Ynys Mon NA
Delyn NA
Alyn and Deeside NA
Wrexham NA
Llanelli NA
Gower NA
Swansea West NA
Swansea East NA
Aberavon NA
Cardiff Central NA
Cardiff North NA
Rhondda NA
Torfaen NA
Monmouth NA
Newport West NA
Arfon NA
Aberconwy NA
Clwyd West NA
Vale of Clwyd NA
Dwyfor Meirionnydd NA
Clwyd South NA
Montgomeryshire NA
Ceredigion NA
Preseli Pembrokeshire NA
Carmarthen West and South Pembrokeshire NA
Carmarthen East and Dinefwr NA
Brecon and Radnorshire NA
Neath NA
Cynon Valley NA
Merthyr Tydfil and Rhymney NA
Blaenau Gwent NA
Bridgend NA
Ogmore NA
Pontypridd NA
Caerphilly NA
Islwyn NA
Vale of Glamorgan NA
Cardiff West NA
Cardiff South and Penarth NA
Aberdeen North NA
Aberdeen South NA
Airdrie and Shotts NA
Angus NA
Argyll and Bute NA
Ayr, Carrick and Cumnock NA
Banff and Buchan NA
Berwickshire, Roxburgh and Selkirk NA
Caithness, Sutherland and Easter Ross NA
Central Ayrshire NA
Coatbridge, Chryston and Bellshill NA
Cumbernauld, Kilsyth and Kirkintilloch East NA
Dumfries and Galloway NA
Dumfriesshire, Clydesdale and Tweeddale NA
Dundee East NA
Dundee West NA
Dunfermline and West Fife NA
East Dunbartonshire NA
East Kilbride, Strathaven and Lesmahagow NA
East Lothian NA
East Renfrewshire NA
Edinburgh East NA
Edinburgh North and Leith NA
Edinburgh South NA
Edinburgh South West NA
Edinburgh West NA
Falkirk NA
Glasgow Central NA
Glasgow East NA
Glasgow North NA
Glasgow North East NA
Glasgow North West NA
Glasgow South NA
Glasgow South West NA
Glenrothes NA
Gordon NA
Inverclyde NA
Inverness, Nairn, Badenoch and Strathspey NA
Kilmarnock and Loudoun NA
Kirkcaldy and Cowdenbeath NA
Lanark and Hamilton East NA
Linlithgow and East Falkirk NA
Livingston NA
Midlothian NA
Moray NA
Motherwell and Wishaw NA
Na h-Eileanan An Iar NA
North Ayrshire and Arran NA
North East Fife NA
Ochil and South Perthshire NA
Orkney and Shetland NA
Paisley and Renfrewshire North NA
Paisley and Renfrewshire South NA
Perth and North Perthshire NA
Ross, Skye and Lochaber NA
Rutherglen and Hamilton West NA
Stirling NA
West Aberdeenshire and Kincardine NA
West Dunbartonshire NA
Code
aps_recent_white <- aps_recent[order(aps_recent$OBS_VALUE, decreasing = TRUE),] %>% 
  filter(VARIABLE == 795)


aps_recent_white[, c("GEOGRAPHY_NAME", "OBS_VALUE")] %>%
  kable( , caption = "% Indian British over 16 by Parliamentary constituency") %>%
    kable_styling("striped", full_width = F) %>%
    scroll_box(height = "200px")
% Indian British over 16 by Parliamentary constituency
GEOGRAPHY_NAME OBS_VALUE
Leicester East 49.1
Feltham and Heston 47.3
Harrow East 46.7
Brent North 33.3
Leicester South 25.7
Slough 25.7
Wolverhampton South East 25.5
Harrow West 24.6
Walsall South 23.3
Coventry North East 18.8
Blackburn 17.3
Coventry South 17.3
Ilford South 16.3
Warley 16.2
Ilford North 16.2
Harborough 15.9
Milton Keynes South 14.6
South Swindon 14.5
Charnwood 14.3
Sutton and Cheam 13.7
West Bromwich East 13.4
Ruislip, Northwood and Pinner 12.8
Leicester West 12.5
Bolton South East 12.3
Wolverhampton North East 12.2
Wolverhampton South West 12.0
Croydon North 12.0
Mitcham and Morden 12.0
Birmingham, Perry Barr 11.6
Chipping Barnet 11.5
Warwick and Leamington 11.4
Croydon Central 11.4
Bradford South 11.3
Watford 10.6
Croydon South 10.6
Derby South 9.3
Nottingham South 9.3
Reading West 9.3
Barking 8.7
Dewsbury 8.5
Wokingham 8.5
Kingston and Surbiton 8.2
Birmingham, Ladywood 8.0
Ipswich 7.7
Bournemouth West 7.7
Nuneaton 7.4
Mid Derbyshire 7.2
West Ham 7.0
Solihull 6.7
Huddersfield 6.1
Derby North 6.1
Bedford 6.0
Reading East 5.9
Altrincham and Sale West 5.8
Peterborough 5.7
Cambridge 5.6
Spelthorne 5.5
Nottingham North 5.4
Coventry North West 5.3
Maidenhead 5.0
Luton South 4.9
Windsor 4.9
Epping Forest 3.6
Thurrock 3.6
Luton North 3.4
Meriden 3.2
Dundee West 3.2
Bracknell 2.7
Berwick-upon-Tweed NA
Bishop Auckland NA
Blaydon NA
Blyth Valley NA
City of Durham NA
Darlington NA
Easington NA
Gateshead NA
Hartlepool NA
Hexham NA
Houghton and Sunderland South NA
Jarrow NA
Middlesbrough NA
Middlesbrough South and East Cleveland NA
Newcastle upon Tyne Central NA
Newcastle upon Tyne East NA
Newcastle upon Tyne North NA
North Durham NA
North Tyneside NA
North West Durham NA
Redcar NA
Sedgefield NA
South Shields NA
Stockton North NA
Stockton South NA
Sunderland Central NA
Tynemouth NA
Wansbeck NA
Washington and Sunderland West NA
Ashton-under-Lyne NA
Barrow and Furness NA
Birkenhead NA
Blackley and Broughton NA
Blackpool North and Cleveleys NA
Blackpool South NA
Bolton North East NA
Bolton West NA
Bootle NA
Burnley NA
Bury North NA
Bury South NA
Carlisle NA
Cheadle NA
Chorley NA
City of Chester NA
Congleton NA
Copeland NA
Crewe and Nantwich NA
Denton and Reddish NA
Eddisbury NA
Ellesmere Port and Neston NA
Fylde NA
Garston and Halewood NA
Halton NA
Hazel Grove NA
Heywood and Middleton NA
Hyndburn NA
Knowsley NA
Lancaster and Fleetwood NA
Leigh NA
Liverpool, Riverside NA
Liverpool, Walton NA
Liverpool, Wavertree NA
Liverpool, West Derby NA
Macclesfield NA
Makerfield NA
Manchester Central NA
Manchester, Gorton NA
Manchester, Withington NA
Morecambe and Lunesdale NA
Oldham East and Saddleworth NA
Oldham West and Royton NA
Pendle NA
Penrith and The Border NA
Preston NA
Ribble Valley NA
Rochdale NA
Rossendale and Darwen NA
Salford and Eccles NA
Sefton Central NA
South Ribble NA
Southport NA
St Helens North NA
St Helens South and Whiston NA
Stalybridge and Hyde NA
Stockport NA
Stretford and Urmston NA
Tatton NA
Wallasey NA
Warrington North NA
Warrington South NA
Weaver Vale NA
West Lancashire NA
Westmorland and Lonsdale NA
Wigan NA
Wirral South NA
Wirral West NA
Workington NA
Worsley and Eccles South NA
Wyre and Preston North NA
Wythenshawe and Sale East NA
Barnsley Central NA
Barnsley East NA
Batley and Spen NA
Beverley and Holderness NA
Bradford East NA
Bradford West NA
Brigg and Goole NA
Calder Valley NA
Cleethorpes NA
Colne Valley NA
Don Valley NA
Doncaster Central NA
Doncaster North NA
East Yorkshire NA
Elmet and Rothwell NA
Great Grimsby NA
Halifax NA
Haltemprice and Howden NA
Harrogate and Knaresborough NA
Hemsworth NA
Keighley NA
Kingston upon Hull East NA
Kingston upon Hull North NA
Kingston upon Hull West and Hessle NA
Leeds Central NA
Leeds East NA
Leeds North East NA
Leeds North West NA
Leeds West NA
Morley and Outwood NA
Normanton, Pontefract and Castleford NA
Penistone and Stocksbridge NA
Pudsey NA
Richmond (Yorks) NA
Rother Valley NA
Rotherham NA
Scarborough and Whitby NA
Scunthorpe NA
Selby and Ainsty NA
Sheffield Central NA
Sheffield South East NA
Sheffield, Brightside and Hillsborough NA
Sheffield, Hallam NA
Sheffield, Heeley NA
Shipley NA
Skipton and Ripon NA
Thirsk and Malton NA
Wakefield NA
Wentworth and Dearne NA
York Central NA
York Outer NA
Amber Valley NA
Ashfield NA
Bassetlaw NA
Bolsover NA
Boston and Skegness NA
Bosworth NA
Broxtowe NA
Chesterfield NA
Corby NA
Daventry NA
Derbyshire Dales NA
Erewash NA
Gainsborough NA
Gedling NA
Grantham and Stamford NA
High Peak NA
Kettering NA
Lincoln NA
Loughborough NA
Louth and Horncastle NA
Mansfield NA
Newark NA
North East Derbyshire NA
North West Leicestershire NA
Northampton North NA
Northampton South NA
Nottingham East NA
Rushcliffe NA
Rutland and Melton NA
Sherwood NA
Sleaford and North Hykeham NA
South Derbyshire NA
South Holland and The Deepings NA
South Leicestershire NA
South Northamptonshire NA
Wellingborough NA
Aldridge-Brownhills NA
Birmingham, Edgbaston NA
Birmingham, Erdington NA
Birmingham, Hall Green NA
Birmingham, Hodge Hill NA
Birmingham, Northfield NA
Birmingham, Selly Oak NA
Birmingham, Yardley NA
Bromsgrove NA
Burton NA
Cannock Chase NA
Dudley North NA
Dudley South NA
Halesowen and Rowley Regis NA
Hereford and South Herefordshire NA
Kenilworth and Southam NA
Lichfield NA
Ludlow NA
Mid Worcestershire NA
Newcastle-under-Lyme NA
North Herefordshire NA
North Shropshire NA
North Warwickshire NA
Redditch NA
Rugby NA
Shrewsbury and Atcham NA
South Staffordshire NA
Stafford NA
Staffordshire Moorlands NA
Stoke-on-Trent Central NA
Stoke-on-Trent North NA
Stoke-on-Trent South NA
Stone NA
Stourbridge NA
Stratford-on-Avon NA
Sutton Coldfield NA
Tamworth NA
Telford NA
The Wrekin NA
Walsall North NA
West Bromwich West NA
West Worcestershire NA
Worcester NA
Wyre Forest NA
Basildon and Billericay NA
Braintree NA
Brentwood and Ongar NA
Broadland NA
Broxbourne NA
Bury St Edmunds NA
Castle Point NA
Central Suffolk and North Ipswich NA
Chelmsford NA
Clacton NA
Colchester NA
Great Yarmouth NA
Harlow NA
Harwich and North Essex NA
Hemel Hempstead NA
Hertford and Stortford NA
Hertsmere NA
Hitchin and Harpenden NA
Huntingdon NA
Maldon NA
Mid Bedfordshire NA
Mid Norfolk NA
North East Bedfordshire NA
North East Cambridgeshire NA
North East Hertfordshire NA
North Norfolk NA
North West Cambridgeshire NA
North West Norfolk NA
Norwich North NA
Norwich South NA
Rayleigh and Wickford NA
Rochford and Southend East NA
Saffron Walden NA
South Basildon and East Thurrock NA
South Cambridgeshire NA
South East Cambridgeshire NA
South Norfolk NA
South Suffolk NA
South West Bedfordshire NA
South West Hertfordshire NA
South West Norfolk NA
Southend West NA
St Albans NA
Stevenage NA
Suffolk Coastal NA
Waveney NA
Welwyn Hatfield NA
West Suffolk NA
Witham NA
Battersea NA
Beckenham NA
Bermondsey and Old Southwark NA
Bethnal Green and Bow NA
Bexleyheath and Crayford NA
Brent Central NA
Brentford and Isleworth NA
Bromley and Chislehurst NA
Camberwell and Peckham NA
Carshalton and Wallington NA
Chelsea and Fulham NA
Chingford and Woodford Green NA
Cities of London and Westminster NA
Dagenham and Rainham NA
Dulwich and West Norwood NA
Ealing Central and Acton NA
Ealing North NA
Ealing, Southall NA
East Ham NA
Edmonton NA
Eltham NA
Enfield North NA
Enfield, Southgate NA
Erith and Thamesmead NA
Finchley and Golders Green NA
Greenwich and Woolwich NA
Hackney North and Stoke Newington NA
Hackney South and Shoreditch NA
Hammersmith NA
Hampstead and Kilburn NA
Hayes and Harlington NA
Hendon NA
Holborn and St Pancras NA
Hornchurch and Upminster NA
Hornsey and Wood Green NA
Islington North NA
Islington South and Finsbury NA
Kensington NA
Lewisham East NA
Lewisham West and Penge NA
Lewisham, Deptford NA
Leyton and Wanstead NA
Old Bexley and Sidcup NA
Orpington NA
Poplar and Limehouse NA
Putney NA
Richmond Park NA
Romford NA
Streatham NA
Tooting NA
Tottenham NA
Twickenham NA
Uxbridge and South Ruislip NA
Vauxhall NA
Walthamstow NA
Westminster North NA
Wimbledon NA
Aldershot NA
Arundel and South Downs NA
Ashford NA
Aylesbury NA
Banbury NA
Basingstoke NA
Beaconsfield NA
Bexhill and Battle NA
Bognor Regis and Littlehampton NA
Brighton, Kemptown NA
Brighton, Pavilion NA
Buckingham NA
Canterbury NA
Chatham and Aylesford NA
Chesham and Amersham NA
Chichester NA
Crawley NA
Dartford NA
Dover NA
East Hampshire NA
East Surrey NA
East Worthing and Shoreham NA
Eastbourne NA
Eastleigh NA
Epsom and Ewell NA
Esher and Walton NA
Fareham NA
Faversham and Mid Kent NA
Folkestone and Hythe NA
Gillingham and Rainham NA
Gosport NA
Gravesham NA
Guildford NA
Hastings and Rye NA
Havant NA
Henley NA
Horsham NA
Hove NA
Isle of Wight NA
Lewes NA
Maidstone and The Weald NA
Meon Valley NA
Mid Sussex NA
Milton Keynes North NA
Mole Valley NA
New Forest East NA
New Forest West NA
Newbury NA
North East Hampshire NA
North Thanet NA
North West Hampshire NA
Oxford East NA
Oxford West and Abingdon NA
Portsmouth North NA
Portsmouth South NA
Reigate NA
Rochester and Strood NA
Romsey and Southampton North NA
Runnymede and Weybridge NA
Sevenoaks NA
Sittingbourne and Sheppey NA
South Thanet NA
South West Surrey NA
Southampton, Itchen NA
Southampton, Test NA
Surrey Heath NA
Tonbridge and Malling NA
Tunbridge Wells NA
Wantage NA
Wealden NA
Winchester NA
Witney NA
Woking NA
Worthing West NA
Wycombe NA
Bath NA
Bournemouth East NA
Bridgwater and West Somerset NA
Bristol East NA
Bristol North West NA
Bristol South NA
Bristol West NA
Camborne and Redruth NA
Central Devon NA
Cheltenham NA
Chippenham NA
Christchurch NA
Devizes NA
East Devon NA
Exeter NA
Filton and Bradley Stoke NA
Forest of Dean NA
Gloucester NA
Kingswood NA
Mid Dorset and North Poole NA
Newton Abbot NA
North Cornwall NA
North Devon NA
North Dorset NA
North East Somerset NA
North Somerset NA
North Swindon NA
North Wiltshire NA
Plymouth, Moor View NA
Plymouth, Sutton and Devonport NA
Poole NA
Salisbury NA
Somerton and Frome NA
South Dorset NA
South East Cornwall NA
South West Devon NA
South West Wiltshire NA
St Austell and Newquay NA
St Ives NA
Stroud NA
Taunton Deane NA
Tewkesbury NA
The Cotswolds NA
Thornbury and Yate NA
Tiverton and Honiton NA
Torbay NA
Torridge and West Devon NA
Totnes NA
Truro and Falmouth NA
Wells NA
West Dorset NA
Weston-Super-Mare NA
Yeovil NA
Ynys Mon NA
Delyn NA
Alyn and Deeside NA
Wrexham NA
Llanelli NA
Gower NA
Swansea West NA
Swansea East NA
Aberavon NA
Cardiff Central NA
Cardiff North NA
Rhondda NA
Torfaen NA
Monmouth NA
Newport East NA
Newport West NA
Arfon NA
Aberconwy NA
Clwyd West NA
Vale of Clwyd NA
Dwyfor Meirionnydd NA
Clwyd South NA
Montgomeryshire NA
Ceredigion NA
Preseli Pembrokeshire NA
Carmarthen West and South Pembrokeshire NA
Carmarthen East and Dinefwr NA
Brecon and Radnorshire NA
Neath NA
Cynon Valley NA
Merthyr Tydfil and Rhymney NA
Blaenau Gwent NA
Bridgend NA
Ogmore NA
Pontypridd NA
Caerphilly NA
Islwyn NA
Vale of Glamorgan NA
Cardiff West NA
Cardiff South and Penarth NA
Aberdeen North NA
Aberdeen South NA
Airdrie and Shotts NA
Angus NA
Argyll and Bute NA
Ayr, Carrick and Cumnock NA
Banff and Buchan NA
Berwickshire, Roxburgh and Selkirk NA
Caithness, Sutherland and Easter Ross NA
Central Ayrshire NA
Coatbridge, Chryston and Bellshill NA
Cumbernauld, Kilsyth and Kirkintilloch East NA
Dumfries and Galloway NA
Dumfriesshire, Clydesdale and Tweeddale NA
Dundee East NA
Dunfermline and West Fife NA
East Dunbartonshire NA
East Kilbride, Strathaven and Lesmahagow NA
East Lothian NA
East Renfrewshire NA
Edinburgh East NA
Edinburgh North and Leith NA
Edinburgh South NA
Edinburgh South West NA
Edinburgh West NA
Falkirk NA
Glasgow Central NA
Glasgow East NA
Glasgow North NA
Glasgow North East NA
Glasgow North West NA
Glasgow South NA
Glasgow South West NA
Glenrothes NA
Gordon NA
Inverclyde NA
Inverness, Nairn, Badenoch and Strathspey NA
Kilmarnock and Loudoun NA
Kirkcaldy and Cowdenbeath NA
Lanark and Hamilton East NA
Linlithgow and East Falkirk NA
Livingston NA
Midlothian NA
Moray NA
Motherwell and Wishaw NA
Na h-Eileanan An Iar NA
North Ayrshire and Arran NA
North East Fife NA
Ochil and South Perthshire NA
Orkney and Shetland NA
Paisley and Renfrewshire North NA
Paisley and Renfrewshire South NA
Perth and North Perthshire NA
Ross, Skye and Lochaber NA
Rutherglen and Hamilton West NA
Stirling NA
West Aberdeenshire and Kincardine NA
West Dunbartonshire NA
Code
aps_recent_white <- aps_recent[order(aps_recent$OBS_VALUE, decreasing = TRUE),] %>% 
  filter(VARIABLE == 796)


aps_recent_white[, c("GEOGRAPHY_NAME", "OBS_VALUE")] %>%
  kable( , caption = "% Pakistani/Bangladeshi over 16 by Parliamentary constituency") %>%
    kable_styling("striped", full_width = F) %>%
    scroll_box(height = "200px")
% Pakistani/Bangladeshi over 16 by Parliamentary constituency
GEOGRAPHY_NAME OBS_VALUE
Bradford West 48.6
East Ham 44.9
Birmingham, Yardley 43.3
Bethnal Green and Bow 42.6
Ilford South 35.9
Bradford East 33.8
Birmingham, Hall Green 31.7
Birmingham, Hodge Hill 29.7
Dagenham and Rainham 25.3
Oldham West and Royton 23.2
West Ham 22.9
Poplar and Limehouse 22.2
Blackburn 21.1
Luton North 21.1
Slough 20.2
Luton South 20.1
Rochdale 19.3
Birmingham, Ladywood 19.1
Sheffield, Brightside and Hillsborough 17.3
Birmingham, Perry Barr 16.8
Bradford South 16.6
Derby South 16.2
Pendle 15.6
Wycombe 15.4
Leeds East 12.9
Barking 11.8
Birmingham, Selly Oak 11.7
Oldham East and Saddleworth 11.3
Newcastle upon Tyne Central 9.5
Leicester East 9.2
Ilford North 9.1
Halifax 8.2
Nottingham South 8.1
Crawley 8.1
Peterborough 8.0
Warley 7.3
Leicester South 6.6
Bury South 6.5
Nottingham East 5.9
Coventry North East 5.6
Reading West 5.3
Solihull 4.9
Newport East 4.8
Middlesbrough 3.5
Heywood and Middleton 3.3
Thurrock 3.0
Berwick-upon-Tweed NA
Bishop Auckland NA
Blaydon NA
Blyth Valley NA
City of Durham NA
Darlington NA
Easington NA
Gateshead NA
Hartlepool NA
Hexham NA
Houghton and Sunderland South NA
Jarrow NA
Middlesbrough South and East Cleveland NA
Newcastle upon Tyne East NA
Newcastle upon Tyne North NA
North Durham NA
North Tyneside NA
North West Durham NA
Redcar NA
Sedgefield NA
South Shields NA
Stockton North NA
Stockton South NA
Sunderland Central NA
Tynemouth NA
Wansbeck NA
Washington and Sunderland West NA
Altrincham and Sale West NA
Ashton-under-Lyne NA
Barrow and Furness NA
Birkenhead NA
Blackley and Broughton NA
Blackpool North and Cleveleys NA
Blackpool South NA
Bolton North East NA
Bolton South East NA
Bolton West NA
Bootle NA
Burnley NA
Bury North NA
Carlisle NA
Cheadle NA
Chorley NA
City of Chester NA
Congleton NA
Copeland NA
Crewe and Nantwich NA
Denton and Reddish NA
Eddisbury NA
Ellesmere Port and Neston NA
Fylde NA
Garston and Halewood NA
Halton NA
Hazel Grove NA
Hyndburn NA
Knowsley NA
Lancaster and Fleetwood NA
Leigh NA
Liverpool, Riverside NA
Liverpool, Walton NA
Liverpool, Wavertree NA
Liverpool, West Derby NA
Macclesfield NA
Makerfield NA
Manchester Central NA
Manchester, Gorton NA
Manchester, Withington NA
Morecambe and Lunesdale NA
Penrith and The Border NA
Preston NA
Ribble Valley NA
Rossendale and Darwen NA
Salford and Eccles NA
Sefton Central NA
South Ribble NA
Southport NA
St Helens North NA
St Helens South and Whiston NA
Stalybridge and Hyde NA
Stockport NA
Stretford and Urmston NA
Tatton NA
Wallasey NA
Warrington North NA
Warrington South NA
Weaver Vale NA
West Lancashire NA
Westmorland and Lonsdale NA
Wigan NA
Wirral South NA
Wirral West NA
Workington NA
Worsley and Eccles South NA
Wyre and Preston North NA
Wythenshawe and Sale East NA
Barnsley Central NA
Barnsley East NA
Batley and Spen NA
Beverley and Holderness NA
Brigg and Goole NA
Calder Valley NA
Cleethorpes NA
Colne Valley NA
Dewsbury NA
Don Valley NA
Doncaster Central NA
Doncaster North NA
East Yorkshire NA
Elmet and Rothwell NA
Great Grimsby NA
Haltemprice and Howden NA
Harrogate and Knaresborough NA
Hemsworth NA
Huddersfield NA
Keighley NA
Kingston upon Hull East NA
Kingston upon Hull North NA
Kingston upon Hull West and Hessle NA
Leeds Central NA
Leeds North East NA
Leeds North West NA
Leeds West NA
Morley and Outwood NA
Normanton, Pontefract and Castleford NA
Penistone and Stocksbridge NA
Pudsey NA
Richmond (Yorks) NA
Rother Valley NA
Rotherham NA
Scarborough and Whitby NA
Scunthorpe NA
Selby and Ainsty NA
Sheffield Central NA
Sheffield South East NA
Sheffield, Hallam NA
Sheffield, Heeley NA
Shipley NA
Skipton and Ripon NA
Thirsk and Malton NA
Wakefield NA
Wentworth and Dearne NA
York Central NA
York Outer NA
Amber Valley NA
Ashfield NA
Bassetlaw NA
Bolsover NA
Boston and Skegness NA
Bosworth NA
Broxtowe NA
Charnwood NA
Chesterfield NA
Corby NA
Daventry NA
Derby North NA
Derbyshire Dales NA
Erewash NA
Gainsborough NA
Gedling NA
Grantham and Stamford NA
Harborough NA
High Peak NA
Kettering NA
Leicester West NA
Lincoln NA
Loughborough NA
Louth and Horncastle NA
Mansfield NA
Mid Derbyshire NA
Newark NA
North East Derbyshire NA
North West Leicestershire NA
Northampton North NA
Northampton South NA
Nottingham North NA
Rushcliffe NA
Rutland and Melton NA
Sherwood NA
Sleaford and North Hykeham NA
South Derbyshire NA
South Holland and The Deepings NA
South Leicestershire NA
South Northamptonshire NA
Wellingborough NA
Aldridge-Brownhills NA
Birmingham, Edgbaston NA
Birmingham, Erdington NA
Birmingham, Northfield NA
Bromsgrove NA
Burton NA
Cannock Chase NA
Coventry North West NA
Coventry South NA
Dudley North NA
Dudley South NA
Halesowen and Rowley Regis NA
Hereford and South Herefordshire NA
Kenilworth and Southam NA
Lichfield NA
Ludlow NA
Meriden NA
Mid Worcestershire NA
Newcastle-under-Lyme NA
North Herefordshire NA
North Shropshire NA
North Warwickshire NA
Nuneaton NA
Redditch NA
Rugby NA
Shrewsbury and Atcham NA
South Staffordshire NA
Stafford NA
Staffordshire Moorlands NA
Stoke-on-Trent Central NA
Stoke-on-Trent North NA
Stoke-on-Trent South NA
Stone NA
Stourbridge NA
Stratford-on-Avon NA
Sutton Coldfield NA
Tamworth NA
Telford NA
The Wrekin NA
Walsall North NA
Walsall South NA
Warwick and Leamington NA
West Bromwich East NA
West Bromwich West NA
West Worcestershire NA
Wolverhampton North East NA
Wolverhampton South East NA
Wolverhampton South West NA
Worcester NA
Wyre Forest NA
Basildon and Billericay NA
Bedford NA
Braintree NA
Brentwood and Ongar NA
Broadland NA
Broxbourne NA
Bury St Edmunds NA
Cambridge NA
Castle Point NA
Central Suffolk and North Ipswich NA
Chelmsford NA
Clacton NA
Colchester NA
Epping Forest NA
Great Yarmouth NA
Harlow NA
Harwich and North Essex NA
Hemel Hempstead NA
Hertford and Stortford NA
Hertsmere NA
Hitchin and Harpenden NA
Huntingdon NA
Ipswich NA
Maldon NA
Mid Bedfordshire NA
Mid Norfolk NA
North East Bedfordshire NA
North East Cambridgeshire NA
North East Hertfordshire NA
North Norfolk NA
North West Cambridgeshire NA
North West Norfolk NA
Norwich North NA
Norwich South NA
Rayleigh and Wickford NA
Rochford and Southend East NA
Saffron Walden NA
South Basildon and East Thurrock NA
South Cambridgeshire NA
South East Cambridgeshire NA
South Norfolk NA
South Suffolk NA
South West Bedfordshire NA
South West Hertfordshire NA
South West Norfolk NA
Southend West NA
St Albans NA
Stevenage NA
Suffolk Coastal NA
Watford NA
Waveney NA
Welwyn Hatfield NA
West Suffolk NA
Witham NA
Battersea NA
Beckenham NA
Bermondsey and Old Southwark NA
Bexleyheath and Crayford NA
Brent Central NA
Brent North NA
Brentford and Isleworth NA
Bromley and Chislehurst NA
Camberwell and Peckham NA
Carshalton and Wallington NA
Chelsea and Fulham NA
Chingford and Woodford Green NA
Chipping Barnet NA
Cities of London and Westminster NA
Croydon Central NA
Croydon North NA
Croydon South NA
Dulwich and West Norwood NA
Ealing Central and Acton NA
Ealing North NA
Ealing, Southall NA
Edmonton NA
Eltham NA
Enfield North NA
Enfield, Southgate NA
Erith and Thamesmead NA
Feltham and Heston NA
Finchley and Golders Green NA
Greenwich and Woolwich NA
Hackney North and Stoke Newington NA
Hackney South and Shoreditch NA
Hammersmith NA
Hampstead and Kilburn NA
Harrow East NA
Harrow West NA
Hayes and Harlington NA
Hendon NA
Holborn and St Pancras NA
Hornchurch and Upminster NA
Hornsey and Wood Green NA
Islington North NA
Islington South and Finsbury NA
Kensington NA
Kingston and Surbiton NA
Lewisham East NA
Lewisham West and Penge NA
Lewisham, Deptford NA
Leyton and Wanstead NA
Mitcham and Morden NA
Old Bexley and Sidcup NA
Orpington NA
Putney NA
Richmond Park NA
Romford NA
Ruislip, Northwood and Pinner NA
Streatham NA
Sutton and Cheam NA
Tooting NA
Tottenham NA
Twickenham NA
Uxbridge and South Ruislip NA
Vauxhall NA
Walthamstow NA
Westminster North NA
Wimbledon NA
Aldershot NA
Arundel and South Downs NA
Ashford NA
Aylesbury NA
Banbury NA
Basingstoke NA
Beaconsfield NA
Bexhill and Battle NA
Bognor Regis and Littlehampton NA
Bracknell NA
Brighton, Kemptown NA
Brighton, Pavilion NA
Buckingham NA
Canterbury NA
Chatham and Aylesford NA
Chesham and Amersham NA
Chichester NA
Dartford NA
Dover NA
East Hampshire NA
East Surrey NA
East Worthing and Shoreham NA
Eastbourne NA
Eastleigh NA
Epsom and Ewell NA
Esher and Walton NA
Fareham NA
Faversham and Mid Kent NA
Folkestone and Hythe NA
Gillingham and Rainham NA
Gosport NA
Gravesham NA
Guildford NA
Hastings and Rye NA
Havant NA
Henley NA
Horsham NA
Hove NA
Isle of Wight NA
Lewes NA
Maidenhead NA
Maidstone and The Weald NA
Meon Valley NA
Mid Sussex NA
Milton Keynes North NA
Milton Keynes South NA
Mole Valley NA
New Forest East NA
New Forest West NA
Newbury NA
North East Hampshire NA
North Thanet NA
North West Hampshire NA
Oxford East NA
Oxford West and Abingdon NA
Portsmouth North NA
Portsmouth South NA
Reading East NA
Reigate NA
Rochester and Strood NA
Romsey and Southampton North NA
Runnymede and Weybridge NA
Sevenoaks NA
Sittingbourne and Sheppey NA
South Thanet NA
South West Surrey NA
Southampton, Itchen NA
Southampton, Test NA
Spelthorne NA
Surrey Heath NA
Tonbridge and Malling NA
Tunbridge Wells NA
Wantage NA
Wealden NA
Winchester NA
Windsor NA
Witney NA
Woking NA
Wokingham NA
Worthing West NA
Bath NA
Bournemouth East NA
Bournemouth West NA
Bridgwater and West Somerset NA
Bristol East NA
Bristol North West NA
Bristol South NA
Bristol West NA
Camborne and Redruth NA
Central Devon NA
Cheltenham NA
Chippenham NA
Christchurch NA
Devizes NA
East Devon NA
Exeter NA
Filton and Bradley Stoke NA
Forest of Dean NA
Gloucester NA
Kingswood NA
Mid Dorset and North Poole NA
Newton Abbot NA
North Cornwall NA
North Devon NA
North Dorset NA
North East Somerset NA
North Somerset NA
North Swindon NA
North Wiltshire NA
Plymouth, Moor View NA
Plymouth, Sutton and Devonport NA
Poole NA
Salisbury NA
Somerton and Frome NA
South Dorset NA
South East Cornwall NA
South Swindon NA
South West Devon NA
South West Wiltshire NA
St Austell and Newquay NA
St Ives NA
Stroud NA
Taunton Deane NA
Tewkesbury NA
The Cotswolds NA
Thornbury and Yate NA
Tiverton and Honiton NA
Torbay NA
Torridge and West Devon NA
Totnes NA
Truro and Falmouth NA
Wells NA
West Dorset NA
Weston-Super-Mare NA
Yeovil NA
Ynys Mon NA
Delyn NA
Alyn and Deeside NA
Wrexham NA
Llanelli NA
Gower NA
Swansea West NA
Swansea East NA
Aberavon NA
Cardiff Central NA
Cardiff North NA
Rhondda NA
Torfaen NA
Monmouth NA
Newport West NA
Arfon NA
Aberconwy NA
Clwyd West NA
Vale of Clwyd NA
Dwyfor Meirionnydd NA
Clwyd South NA
Montgomeryshire NA
Ceredigion NA
Preseli Pembrokeshire NA
Carmarthen West and South Pembrokeshire NA
Carmarthen East and Dinefwr NA
Brecon and Radnorshire NA
Neath NA
Cynon Valley NA
Merthyr Tydfil and Rhymney NA
Blaenau Gwent NA
Bridgend NA
Ogmore NA
Pontypridd NA
Caerphilly NA
Islwyn NA
Vale of Glamorgan NA
Cardiff West NA
Cardiff South and Penarth NA
Aberdeen North NA
Aberdeen South NA
Airdrie and Shotts NA
Angus NA
Argyll and Bute NA
Ayr, Carrick and Cumnock NA
Banff and Buchan NA
Berwickshire, Roxburgh and Selkirk NA
Caithness, Sutherland and Easter Ross NA
Central Ayrshire NA
Coatbridge, Chryston and Bellshill NA
Cumbernauld, Kilsyth and Kirkintilloch East NA
Dumfries and Galloway NA
Dumfriesshire, Clydesdale and Tweeddale NA
Dundee East NA
Dundee West NA
Dunfermline and West Fife NA
East Dunbartonshire NA
East Kilbride, Strathaven and Lesmahagow NA
East Lothian NA
East Renfrewshire NA
Edinburgh East NA
Edinburgh North and Leith NA
Edinburgh South NA
Edinburgh South West NA
Edinburgh West NA
Falkirk NA
Glasgow Central NA
Glasgow East NA
Glasgow North NA
Glasgow North East NA
Glasgow North West NA
Glasgow South NA
Glasgow South West NA
Glenrothes NA
Gordon NA
Inverclyde NA
Inverness, Nairn, Badenoch and Strathspey NA
Kilmarnock and Loudoun NA
Kirkcaldy and Cowdenbeath NA
Lanark and Hamilton East NA
Linlithgow and East Falkirk NA
Livingston NA
Midlothian NA
Moray NA
Motherwell and Wishaw NA
Na h-Eileanan An Iar NA
North Ayrshire and Arran NA
North East Fife NA
Ochil and South Perthshire NA
Orkney and Shetland NA
Paisley and Renfrewshire North NA
Paisley and Renfrewshire South NA
Perth and North Perthshire NA
Ross, Skye and Lochaber NA
Rutherglen and Hamilton West NA
Stirling NA
West Aberdeenshire and Kincardine NA
West Dunbartonshire NA
Code
aps_recent_white <- aps_recent[order(aps_recent$OBS_VALUE, decreasing = TRUE),] %>% 
  filter(VARIABLE == 794)


aps_recent_white[, c("GEOGRAPHY_NAME", "OBS_VALUE")] %>%
  kable( , caption = "% Mixed ethicity over 16 by Parliamentary constituency") %>%
    kable_styling("striped", full_width = F) %>%
    scroll_box(height = "200px")
% Mixed ethicity over 16 by Parliamentary constituency
GEOGRAPHY_NAME OBS_VALUE
Islington North 9.5
Thurrock 4.0
Berwick-upon-Tweed NA
Bishop Auckland NA
Blaydon NA
Blyth Valley NA
City of Durham NA
Darlington NA
Easington NA
Gateshead NA
Hartlepool NA
Hexham NA
Houghton and Sunderland South NA
Jarrow NA
Middlesbrough NA
Middlesbrough South and East Cleveland NA
Newcastle upon Tyne Central NA
Newcastle upon Tyne East NA
Newcastle upon Tyne North NA
North Durham NA
North Tyneside NA
North West Durham NA
Redcar NA
Sedgefield NA
South Shields NA
Stockton North NA
Stockton South NA
Sunderland Central NA
Tynemouth NA
Wansbeck NA
Washington and Sunderland West NA
Altrincham and Sale West NA
Ashton-under-Lyne NA
Barrow and Furness NA
Birkenhead NA
Blackburn NA
Blackley and Broughton NA
Blackpool North and Cleveleys NA
Blackpool South NA
Bolton North East NA
Bolton South East NA
Bolton West NA
Bootle NA
Burnley NA
Bury North NA
Bury South NA
Carlisle NA
Cheadle NA
Chorley NA
City of Chester NA
Congleton NA
Copeland NA
Crewe and Nantwich NA
Denton and Reddish NA
Eddisbury NA
Ellesmere Port and Neston NA
Fylde NA
Garston and Halewood NA
Halton NA
Hazel Grove NA
Heywood and Middleton NA
Hyndburn NA
Knowsley NA
Lancaster and Fleetwood NA
Leigh NA
Liverpool, Riverside NA
Liverpool, Walton NA
Liverpool, Wavertree NA
Liverpool, West Derby NA
Macclesfield NA
Makerfield NA
Manchester Central NA
Manchester, Gorton NA
Manchester, Withington NA
Morecambe and Lunesdale NA
Oldham East and Saddleworth NA
Oldham West and Royton NA
Pendle NA
Penrith and The Border NA
Preston NA
Ribble Valley NA
Rochdale NA
Rossendale and Darwen NA
Salford and Eccles NA
Sefton Central NA
South Ribble NA
Southport NA
St Helens North NA
St Helens South and Whiston NA
Stalybridge and Hyde NA
Stockport NA
Stretford and Urmston NA
Tatton NA
Wallasey NA
Warrington North NA
Warrington South NA
Weaver Vale NA
West Lancashire NA
Westmorland and Lonsdale NA
Wigan NA
Wirral South NA
Wirral West NA
Workington NA
Worsley and Eccles South NA
Wyre and Preston North NA
Wythenshawe and Sale East NA
Barnsley Central NA
Barnsley East NA
Batley and Spen NA
Beverley and Holderness NA
Bradford East NA
Bradford South NA
Bradford West NA
Brigg and Goole NA
Calder Valley NA
Cleethorpes NA
Colne Valley NA
Dewsbury NA
Don Valley NA
Doncaster Central NA
Doncaster North NA
East Yorkshire NA
Elmet and Rothwell NA
Great Grimsby NA
Halifax NA
Haltemprice and Howden NA
Harrogate and Knaresborough NA
Hemsworth NA
Huddersfield NA
Keighley NA
Kingston upon Hull East NA
Kingston upon Hull North NA
Kingston upon Hull West and Hessle NA
Leeds Central NA
Leeds East NA
Leeds North East NA
Leeds North West NA
Leeds West NA
Morley and Outwood NA
Normanton, Pontefract and Castleford NA
Penistone and Stocksbridge NA
Pudsey NA
Richmond (Yorks) NA
Rother Valley NA
Rotherham NA
Scarborough and Whitby NA
Scunthorpe NA
Selby and Ainsty NA
Sheffield Central NA
Sheffield South East NA
Sheffield, Brightside and Hillsborough NA
Sheffield, Hallam NA
Sheffield, Heeley NA
Shipley NA
Skipton and Ripon NA
Thirsk and Malton NA
Wakefield NA
Wentworth and Dearne NA
York Central NA
York Outer NA
Amber Valley NA
Ashfield NA
Bassetlaw NA
Bolsover NA
Boston and Skegness NA
Bosworth NA
Broxtowe NA
Charnwood NA
Chesterfield NA
Corby NA
Daventry NA
Derby North NA
Derby South NA
Derbyshire Dales NA
Erewash NA
Gainsborough NA
Gedling NA
Grantham and Stamford NA
Harborough NA
High Peak NA
Kettering NA
Leicester East NA
Leicester South NA
Leicester West NA
Lincoln NA
Loughborough NA
Louth and Horncastle NA
Mansfield NA
Mid Derbyshire NA
Newark NA
North East Derbyshire NA
North West Leicestershire NA
Northampton North NA
Northampton South NA
Nottingham East NA
Nottingham North NA
Nottingham South NA
Rushcliffe NA
Rutland and Melton NA
Sherwood NA
Sleaford and North Hykeham NA
South Derbyshire NA
South Holland and The Deepings NA
South Leicestershire NA
South Northamptonshire NA
Wellingborough NA
Aldridge-Brownhills NA
Birmingham, Edgbaston NA
Birmingham, Erdington NA
Birmingham, Hall Green NA
Birmingham, Hodge Hill NA
Birmingham, Ladywood NA
Birmingham, Northfield NA
Birmingham, Perry Barr NA
Birmingham, Selly Oak NA
Birmingham, Yardley NA
Bromsgrove NA
Burton NA
Cannock Chase NA
Coventry North East NA
Coventry North West NA
Coventry South NA
Dudley North NA
Dudley South NA
Halesowen and Rowley Regis NA
Hereford and South Herefordshire NA
Kenilworth and Southam NA
Lichfield NA
Ludlow NA
Meriden NA
Mid Worcestershire NA
Newcastle-under-Lyme NA
North Herefordshire NA
North Shropshire NA
North Warwickshire NA
Nuneaton NA
Redditch NA
Rugby NA
Shrewsbury and Atcham NA
Solihull NA
South Staffordshire NA
Stafford NA
Staffordshire Moorlands NA
Stoke-on-Trent Central NA
Stoke-on-Trent North NA
Stoke-on-Trent South NA
Stone NA
Stourbridge NA
Stratford-on-Avon NA
Sutton Coldfield NA
Tamworth NA
Telford NA
The Wrekin NA
Walsall North NA
Walsall South NA
Warley NA
Warwick and Leamington NA
West Bromwich East NA
West Bromwich West NA
West Worcestershire NA
Wolverhampton North East NA
Wolverhampton South East NA
Wolverhampton South West NA
Worcester NA
Wyre Forest NA
Basildon and Billericay NA
Bedford NA
Braintree NA
Brentwood and Ongar NA
Broadland NA
Broxbourne NA
Bury St Edmunds NA
Cambridge NA
Castle Point NA
Central Suffolk and North Ipswich NA
Chelmsford NA
Clacton NA
Colchester NA
Epping Forest NA
Great Yarmouth NA
Harlow NA
Harwich and North Essex NA
Hemel Hempstead NA
Hertford and Stortford NA
Hertsmere NA
Hitchin and Harpenden NA
Huntingdon NA
Ipswich NA
Luton North NA
Luton South NA
Maldon NA
Mid Bedfordshire NA
Mid Norfolk NA
North East Bedfordshire NA
North East Cambridgeshire NA
North East Hertfordshire NA
North Norfolk NA
North West Cambridgeshire NA
North West Norfolk NA
Norwich North NA
Norwich South NA
Peterborough NA
Rayleigh and Wickford NA
Rochford and Southend East NA
Saffron Walden NA
South Basildon and East Thurrock NA
South Cambridgeshire NA
South East Cambridgeshire NA
South Norfolk NA
South Suffolk NA
South West Bedfordshire NA
South West Hertfordshire NA
South West Norfolk NA
Southend West NA
St Albans NA
Stevenage NA
Suffolk Coastal NA
Watford NA
Waveney NA
Welwyn Hatfield NA
West Suffolk NA
Witham NA
Barking NA
Battersea NA
Beckenham NA
Bermondsey and Old Southwark NA
Bethnal Green and Bow NA
Bexleyheath and Crayford NA
Brent Central NA
Brent North NA
Brentford and Isleworth NA
Bromley and Chislehurst NA
Camberwell and Peckham NA
Carshalton and Wallington NA
Chelsea and Fulham NA
Chingford and Woodford Green NA
Chipping Barnet NA
Cities of London and Westminster NA
Croydon Central NA
Croydon North NA
Croydon South NA
Dagenham and Rainham NA
Dulwich and West Norwood NA
Ealing Central and Acton NA
Ealing North NA
Ealing, Southall NA
East Ham NA
Edmonton NA
Eltham NA
Enfield North NA
Enfield, Southgate NA
Erith and Thamesmead NA
Feltham and Heston NA
Finchley and Golders Green NA
Greenwich and Woolwich NA
Hackney North and Stoke Newington NA
Hackney South and Shoreditch NA
Hammersmith NA
Hampstead and Kilburn NA
Harrow East NA
Harrow West NA
Hayes and Harlington NA
Hendon NA
Holborn and St Pancras NA
Hornchurch and Upminster NA
Hornsey and Wood Green NA
Ilford North NA
Ilford South NA
Islington South and Finsbury NA
Kensington NA
Kingston and Surbiton NA
Lewisham East NA
Lewisham West and Penge NA
Lewisham, Deptford NA
Leyton and Wanstead NA
Mitcham and Morden NA
Old Bexley and Sidcup NA
Orpington NA
Poplar and Limehouse NA
Putney NA
Richmond Park NA
Romford NA
Ruislip, Northwood and Pinner NA
Streatham NA
Sutton and Cheam NA
Tooting NA
Tottenham NA
Twickenham NA
Uxbridge and South Ruislip NA
Vauxhall NA
Walthamstow NA
West Ham NA
Westminster North NA
Wimbledon NA
Aldershot NA
Arundel and South Downs NA
Ashford NA
Aylesbury NA
Banbury NA
Basingstoke NA
Beaconsfield NA
Bexhill and Battle NA
Bognor Regis and Littlehampton NA
Bracknell NA
Brighton, Kemptown NA
Brighton, Pavilion NA
Buckingham NA
Canterbury NA
Chatham and Aylesford NA
Chesham and Amersham NA
Chichester NA
Crawley NA
Dartford NA
Dover NA
East Hampshire NA
East Surrey NA
East Worthing and Shoreham NA
Eastbourne NA
Eastleigh NA
Epsom and Ewell NA
Esher and Walton NA
Fareham NA
Faversham and Mid Kent NA
Folkestone and Hythe NA
Gillingham and Rainham NA
Gosport NA
Gravesham NA
Guildford NA
Hastings and Rye NA
Havant NA
Henley NA
Horsham NA
Hove NA
Isle of Wight NA
Lewes NA
Maidenhead NA
Maidstone and The Weald NA
Meon Valley NA
Mid Sussex NA
Milton Keynes North NA
Milton Keynes South NA
Mole Valley NA
New Forest East NA
New Forest West NA
Newbury NA
North East Hampshire NA
North Thanet NA
North West Hampshire NA
Oxford East NA
Oxford West and Abingdon NA
Portsmouth North NA
Portsmouth South NA
Reading East NA
Reading West NA
Reigate NA
Rochester and Strood NA
Romsey and Southampton North NA
Runnymede and Weybridge NA
Sevenoaks NA
Sittingbourne and Sheppey NA
Slough NA
South Thanet NA
South West Surrey NA
Southampton, Itchen NA
Southampton, Test NA
Spelthorne NA
Surrey Heath NA
Tonbridge and Malling NA
Tunbridge Wells NA
Wantage NA
Wealden NA
Winchester NA
Windsor NA
Witney NA
Woking NA
Wokingham NA
Worthing West NA
Wycombe NA
Bath NA
Bournemouth East NA
Bournemouth West NA
Bridgwater and West Somerset NA
Bristol East NA
Bristol North West NA
Bristol South NA
Bristol West NA
Camborne and Redruth NA
Central Devon NA
Cheltenham NA
Chippenham NA
Christchurch NA
Devizes NA
East Devon NA
Exeter NA
Filton and Bradley Stoke NA
Forest of Dean NA
Gloucester NA
Kingswood NA
Mid Dorset and North Poole NA
Newton Abbot NA
North Cornwall NA
North Devon NA
North Dorset NA
North East Somerset NA
North Somerset NA
North Swindon NA
North Wiltshire NA
Plymouth, Moor View NA
Plymouth, Sutton and Devonport NA
Poole NA
Salisbury NA
Somerton and Frome NA
South Dorset NA
South East Cornwall NA
South Swindon NA
South West Devon NA
South West Wiltshire NA
St Austell and Newquay NA
St Ives NA
Stroud NA
Taunton Deane NA
Tewkesbury NA
The Cotswolds NA
Thornbury and Yate NA
Tiverton and Honiton NA
Torbay NA
Torridge and West Devon NA
Totnes NA
Truro and Falmouth NA
Wells NA
West Dorset NA
Weston-Super-Mare NA
Yeovil NA
Ynys Mon NA
Delyn NA
Alyn and Deeside NA
Wrexham NA
Llanelli NA
Gower NA
Swansea West NA
Swansea East NA
Aberavon NA
Cardiff Central NA
Cardiff North NA
Rhondda NA
Torfaen NA
Monmouth NA
Newport East NA
Newport West NA
Arfon NA
Aberconwy NA
Clwyd West NA
Vale of Clwyd NA
Dwyfor Meirionnydd NA
Clwyd South NA
Montgomeryshire NA
Ceredigion NA
Preseli Pembrokeshire NA
Carmarthen West and South Pembrokeshire NA
Carmarthen East and Dinefwr NA
Brecon and Radnorshire NA
Neath NA
Cynon Valley NA
Merthyr Tydfil and Rhymney NA
Blaenau Gwent NA
Bridgend NA
Ogmore NA
Pontypridd NA
Caerphilly NA
Islwyn NA
Vale of Glamorgan NA
Cardiff West NA
Cardiff South and Penarth NA
Aberdeen North NA
Aberdeen South NA
Airdrie and Shotts NA
Angus NA
Argyll and Bute NA
Ayr, Carrick and Cumnock NA
Banff and Buchan NA
Berwickshire, Roxburgh and Selkirk NA
Caithness, Sutherland and Easter Ross NA
Central Ayrshire NA
Coatbridge, Chryston and Bellshill NA
Cumbernauld, Kilsyth and Kirkintilloch East NA
Dumfries and Galloway NA
Dumfriesshire, Clydesdale and Tweeddale NA
Dundee East NA
Dundee West NA
Dunfermline and West Fife NA
East Dunbartonshire NA
East Kilbride, Strathaven and Lesmahagow NA
East Lothian NA
East Renfrewshire NA
Edinburgh East NA
Edinburgh North and Leith NA
Edinburgh South NA
Edinburgh South West NA
Edinburgh West NA
Falkirk NA
Glasgow Central NA
Glasgow East NA
Glasgow North NA
Glasgow North East NA
Glasgow North West NA
Glasgow South NA
Glasgow South West NA
Glenrothes NA
Gordon NA
Inverclyde NA
Inverness, Nairn, Badenoch and Strathspey NA
Kilmarnock and Loudoun NA
Kirkcaldy and Cowdenbeath NA
Lanark and Hamilton East NA
Linlithgow and East Falkirk NA
Livingston NA
Midlothian NA
Moray NA
Motherwell and Wishaw NA
Na h-Eileanan An Iar NA
North Ayrshire and Arran NA
North East Fife NA
Ochil and South Perthshire NA
Orkney and Shetland NA
Paisley and Renfrewshire North NA
Paisley and Renfrewshire South NA
Perth and North Perthshire NA
Ross, Skye and Lochaber NA
Rutherglen and Hamilton West NA
Stirling NA
West Aberdeenshire and Kincardine NA
West Dunbartonshire NA
Code
aps_recent_white <- aps_recent[order(aps_recent$OBS_VALUE, decreasing = TRUE),] %>% 
  filter(VARIABLE == 798)


aps_recent_white[, c("GEOGRAPHY_NAME", "OBS_VALUE")] %>%
  kable(, caption = "% Other ethnicity over 16 by Parliamentary constituency") %>%
    kable_styling("striped", full_width = F) %>%
    scroll_box(height = "200px")
% Other ethnicity over 16 by Parliamentary constituency
GEOGRAPHY_NAME OBS_VALUE
Kensington 31.4
Hendon 29.1
Leyton and Wanstead 28.0
Ilford North 27.8
Ealing North 27.2
Hammersmith 25.2
Harrow West 22.2
Chelsea and Fulham 21.0
Tottenham 19.7
West Ham 19.6
Manchester Central 18.5
Westminster North 18.1
Chingford and Woodford Green 17.3
Woking 17.3
Ilford South 16.9
Greenwich and Woolwich 16.5
Bethnal Green and Bow 16.4
Cities of London and Westminster 16.4
Walthamstow 16.4
Hornsey and Wood Green 15.9
Edmonton 15.7
Eltham 15.4
Poplar and Limehouse 14.7
Wimbledon 14.7
Huddersfield 14.4
Croydon North 14.1
Liverpool, Riverside 13.7
Bexleyheath and Crayford 13.7
Sutton and Cheam 13.6
Broxtowe 13.4
Birmingham, Ladywood 13.2
Croydon South 13.2
Salford and Eccles 12.9
Richmond Park 12.7
Bermondsey and Old Southwark 12.5
Carshalton and Wallington 12.4
Newcastle upon Tyne Central 12.1
Hackney South and Shoreditch 11.6
Old Bexley and Sidcup 11.6
Holborn and St Pancras 11.5
Doncaster Central 11.2
Erith and Thamesmead 10.9
Sheffield Central 10.8
Islington North 10.8
Leicester West 10.4
Hampstead and Kilburn 10.3
Luton North 10.0
Loughborough 9.7
St Albans 9.3
Worsley and Eccles South 9.2
Milton Keynes South 8.6
Milton Keynes North 8.4
Coventry North West 8.3
Barking 8.1
Islington South and Finsbury 8.1
Croydon Central 8.0
South East Cambridgeshire 7.9
Reading West 7.8
Harborough 7.7
Leicester South 7.5
Rugby 7.5
Solihull 7.1
Romsey and Southampton North 7.1
Kingston and Surbiton 6.9
Twickenham 6.7
Newcastle upon Tyne East 6.6
Leicester East 6.4
Bristol West 6.4
Bedford 6.1
Cardiff South and Penarth 5.7
Wythenshawe and Sale East 5.5
Middlesbrough 5.4
Altrincham and Sale West 5.3
South Cambridgeshire 5.1
Derby North 5.0
Nottingham South 4.6
Luton South 4.6
Southampton, Itchen 4.6
Bournemouth West 4.6
York Outer 4.3
Maidenhead 4.3
Warrington South 4.2
Swansea West 4.2
Windsor 4.0
Blackpool South 3.9
Filton and Bradley Stoke 3.8
North Swindon 3.7
Vale of Clwyd 3.6
Newbury 3.3
Thurrock 3.1
Bracknell 3.1
Bournemouth East 3.1
Ynys Mon 1.9
Berwick-upon-Tweed NA
Bishop Auckland NA
Blaydon NA
Blyth Valley NA
City of Durham NA
Darlington NA
Easington NA
Gateshead NA
Hartlepool NA
Hexham NA
Houghton and Sunderland South NA
Jarrow NA
Middlesbrough South and East Cleveland NA
Newcastle upon Tyne North NA
North Durham NA
North Tyneside NA
North West Durham NA
Redcar NA
Sedgefield NA
South Shields NA
Stockton North NA
Stockton South NA
Sunderland Central NA
Tynemouth NA
Wansbeck NA
Washington and Sunderland West NA
Ashton-under-Lyne NA
Barrow and Furness NA
Birkenhead NA
Blackburn NA
Blackley and Broughton NA
Blackpool North and Cleveleys NA
Bolton North East NA
Bolton South East NA
Bolton West NA
Bootle NA
Burnley NA
Bury North NA
Bury South NA
Carlisle NA
Cheadle NA
Chorley NA
City of Chester NA
Congleton NA
Copeland NA
Crewe and Nantwich NA
Denton and Reddish NA
Eddisbury NA
Ellesmere Port and Neston NA
Fylde NA
Garston and Halewood NA
Halton NA
Hazel Grove NA
Heywood and Middleton NA
Hyndburn NA
Knowsley NA
Lancaster and Fleetwood NA
Leigh NA
Liverpool, Walton NA
Liverpool, Wavertree NA
Liverpool, West Derby NA
Macclesfield NA
Makerfield NA
Manchester, Gorton NA
Manchester, Withington NA
Morecambe and Lunesdale NA
Oldham East and Saddleworth NA
Oldham West and Royton NA
Pendle NA
Penrith and The Border NA
Preston NA
Ribble Valley NA
Rochdale NA
Rossendale and Darwen NA
Sefton Central NA
South Ribble NA
Southport NA
St Helens North NA
St Helens South and Whiston NA
Stalybridge and Hyde NA
Stockport NA
Stretford and Urmston NA
Tatton NA
Wallasey NA
Warrington North NA
Weaver Vale NA
West Lancashire NA
Westmorland and Lonsdale NA
Wigan NA
Wirral South NA
Wirral West NA
Workington NA
Wyre and Preston North NA
Barnsley Central NA
Barnsley East NA
Batley and Spen NA
Beverley and Holderness NA
Bradford East NA
Bradford South NA
Bradford West NA
Brigg and Goole NA
Calder Valley NA
Cleethorpes NA
Colne Valley NA
Dewsbury NA
Don Valley NA
Doncaster North NA
East Yorkshire NA
Elmet and Rothwell NA
Great Grimsby NA
Halifax NA
Haltemprice and Howden NA
Harrogate and Knaresborough NA
Hemsworth NA
Keighley NA
Kingston upon Hull East NA
Kingston upon Hull North NA
Kingston upon Hull West and Hessle NA
Leeds Central NA
Leeds East NA
Leeds North East NA
Leeds North West NA
Leeds West NA
Morley and Outwood NA
Normanton, Pontefract and Castleford NA
Penistone and Stocksbridge NA
Pudsey NA
Richmond (Yorks) NA
Rother Valley NA
Rotherham NA
Scarborough and Whitby NA
Scunthorpe NA
Selby and Ainsty NA
Sheffield South East NA
Sheffield, Brightside and Hillsborough NA
Sheffield, Hallam NA
Sheffield, Heeley NA
Shipley NA
Skipton and Ripon NA
Thirsk and Malton NA
Wakefield NA
Wentworth and Dearne NA
York Central NA
Amber Valley NA
Ashfield NA
Bassetlaw NA
Bolsover NA
Boston and Skegness NA
Bosworth NA
Charnwood NA
Chesterfield NA
Corby NA
Daventry NA
Derby South NA
Derbyshire Dales NA
Erewash NA
Gainsborough NA
Gedling NA
Grantham and Stamford NA
High Peak NA
Kettering NA
Lincoln NA
Louth and Horncastle NA
Mansfield NA
Mid Derbyshire NA
Newark NA
North East Derbyshire NA
North West Leicestershire NA
Northampton North NA
Northampton South NA
Nottingham East NA
Nottingham North NA
Rushcliffe NA
Rutland and Melton NA
Sherwood NA
Sleaford and North Hykeham NA
South Derbyshire NA
South Holland and The Deepings NA
South Leicestershire NA
South Northamptonshire NA
Wellingborough NA
Aldridge-Brownhills NA
Birmingham, Edgbaston NA
Birmingham, Erdington NA
Birmingham, Hall Green NA
Birmingham, Hodge Hill NA
Birmingham, Northfield NA
Birmingham, Perry Barr NA
Birmingham, Selly Oak NA
Birmingham, Yardley NA
Bromsgrove NA
Burton NA
Cannock Chase NA
Coventry North East NA
Coventry South NA
Dudley North NA
Dudley South NA
Halesowen and Rowley Regis NA
Hereford and South Herefordshire NA
Kenilworth and Southam NA
Lichfield NA
Ludlow NA
Meriden NA
Mid Worcestershire NA
Newcastle-under-Lyme NA
North Herefordshire NA
North Shropshire NA
North Warwickshire NA
Nuneaton NA
Redditch NA
Shrewsbury and Atcham NA
South Staffordshire NA
Stafford NA
Staffordshire Moorlands NA
Stoke-on-Trent Central NA
Stoke-on-Trent North NA
Stoke-on-Trent South NA
Stone NA
Stourbridge NA
Stratford-on-Avon NA
Sutton Coldfield NA
Tamworth NA
Telford NA
The Wrekin NA
Walsall North NA
Walsall South NA
Warley NA
Warwick and Leamington NA
West Bromwich East NA
West Bromwich West NA
West Worcestershire NA
Wolverhampton North East NA
Wolverhampton South East NA
Wolverhampton South West NA
Worcester NA
Wyre Forest NA
Basildon and Billericay NA
Braintree NA
Brentwood and Ongar NA
Broadland NA
Broxbourne NA
Bury St Edmunds NA
Cambridge NA
Castle Point NA
Central Suffolk and North Ipswich NA
Chelmsford NA
Clacton NA
Colchester NA
Epping Forest NA
Great Yarmouth NA
Harlow NA
Harwich and North Essex NA
Hemel Hempstead NA
Hertford and Stortford NA
Hertsmere NA
Hitchin and Harpenden NA
Huntingdon NA
Ipswich NA
Maldon NA
Mid Bedfordshire NA
Mid Norfolk NA
North East Bedfordshire NA
North East Cambridgeshire NA
North East Hertfordshire NA
North Norfolk NA
North West Cambridgeshire NA
North West Norfolk NA
Norwich North NA
Norwich South NA
Peterborough NA
Rayleigh and Wickford NA
Rochford and Southend East NA
Saffron Walden NA
South Basildon and East Thurrock NA
South Norfolk NA
South Suffolk NA
South West Bedfordshire NA
South West Hertfordshire NA
South West Norfolk NA
Southend West NA
Stevenage NA
Suffolk Coastal NA
Watford NA
Waveney NA
Welwyn Hatfield NA
West Suffolk NA
Witham NA
Battersea NA
Beckenham NA
Brent Central NA
Brent North NA
Brentford and Isleworth NA
Bromley and Chislehurst NA
Camberwell and Peckham NA
Chipping Barnet NA
Dagenham and Rainham NA
Dulwich and West Norwood NA
Ealing Central and Acton NA
Ealing, Southall NA
East Ham NA
Enfield North NA
Enfield, Southgate NA
Feltham and Heston NA
Finchley and Golders Green NA
Hackney North and Stoke Newington NA
Harrow East NA
Hayes and Harlington NA
Hornchurch and Upminster NA
Lewisham East NA
Lewisham West and Penge NA
Lewisham, Deptford NA
Mitcham and Morden NA
Orpington NA
Putney NA
Romford NA
Ruislip, Northwood and Pinner NA
Streatham NA
Tooting NA
Uxbridge and South Ruislip NA
Vauxhall NA
Aldershot NA
Arundel and South Downs NA
Ashford NA
Aylesbury NA
Banbury NA
Basingstoke NA
Beaconsfield NA
Bexhill and Battle NA
Bognor Regis and Littlehampton NA
Brighton, Kemptown NA
Brighton, Pavilion NA
Buckingham NA
Canterbury NA
Chatham and Aylesford NA
Chesham and Amersham NA
Chichester NA
Crawley NA
Dartford NA
Dover NA
East Hampshire NA
East Surrey NA
East Worthing and Shoreham NA
Eastbourne NA
Eastleigh NA
Epsom and Ewell NA
Esher and Walton NA
Fareham NA
Faversham and Mid Kent NA
Folkestone and Hythe NA
Gillingham and Rainham NA
Gosport NA
Gravesham NA
Guildford NA
Hastings and Rye NA
Havant NA
Henley NA
Horsham NA
Hove NA
Isle of Wight NA
Lewes NA
Maidstone and The Weald NA
Meon Valley NA
Mid Sussex NA
Mole Valley NA
New Forest East NA
New Forest West NA
North East Hampshire NA
North Thanet NA
North West Hampshire NA
Oxford East NA
Oxford West and Abingdon NA
Portsmouth North NA
Portsmouth South NA
Reading East NA
Reigate NA
Rochester and Strood NA
Runnymede and Weybridge NA
Sevenoaks NA
Sittingbourne and Sheppey NA
Slough NA
South Thanet NA
South West Surrey NA
Southampton, Test NA
Spelthorne NA
Surrey Heath NA
Tonbridge and Malling NA
Tunbridge Wells NA
Wantage NA
Wealden NA
Winchester NA
Witney NA
Wokingham NA
Worthing West NA
Wycombe NA
Bath NA
Bridgwater and West Somerset NA
Bristol East NA
Bristol North West NA
Bristol South NA
Camborne and Redruth NA
Central Devon NA
Cheltenham NA
Chippenham NA
Christchurch NA
Devizes NA
East Devon NA
Exeter NA
Forest of Dean NA
Gloucester NA
Kingswood NA
Mid Dorset and North Poole NA
Newton Abbot NA
North Cornwall NA
North Devon NA
North Dorset NA
North East Somerset NA
North Somerset NA
North Wiltshire NA
Plymouth, Moor View NA
Plymouth, Sutton and Devonport NA
Poole NA
Salisbury NA
Somerton and Frome NA
South Dorset NA
South East Cornwall NA
South Swindon NA
South West Devon NA
South West Wiltshire NA
St Austell and Newquay NA
St Ives NA
Stroud NA
Taunton Deane NA
Tewkesbury NA
The Cotswolds NA
Thornbury and Yate NA
Tiverton and Honiton NA
Torbay NA
Torridge and West Devon NA
Totnes NA
Truro and Falmouth NA
Wells NA
West Dorset NA
Weston-Super-Mare NA
Yeovil NA
Delyn NA
Alyn and Deeside NA
Wrexham NA
Llanelli NA
Gower NA
Swansea East NA
Aberavon NA
Cardiff Central NA
Cardiff North NA
Rhondda NA
Torfaen NA
Monmouth NA
Newport East NA
Newport West NA
Arfon NA
Aberconwy NA
Clwyd West NA
Dwyfor Meirionnydd NA
Clwyd South NA
Montgomeryshire NA
Ceredigion NA
Preseli Pembrokeshire NA
Carmarthen West and South Pembrokeshire NA
Carmarthen East and Dinefwr NA
Brecon and Radnorshire NA
Neath NA
Cynon Valley NA
Merthyr Tydfil and Rhymney NA
Blaenau Gwent NA
Bridgend NA
Ogmore NA
Pontypridd NA
Caerphilly NA
Islwyn NA
Vale of Glamorgan NA
Cardiff West NA
Aberdeen North NA
Aberdeen South NA
Airdrie and Shotts NA
Angus NA
Argyll and Bute NA
Ayr, Carrick and Cumnock NA
Banff and Buchan NA
Berwickshire, Roxburgh and Selkirk NA
Caithness, Sutherland and Easter Ross NA
Central Ayrshire NA
Coatbridge, Chryston and Bellshill NA
Cumbernauld, Kilsyth and Kirkintilloch East NA
Dumfries and Galloway NA
Dumfriesshire, Clydesdale and Tweeddale NA
Dundee East NA
Dundee West NA
Dunfermline and West Fife NA
East Dunbartonshire NA
East Kilbride, Strathaven and Lesmahagow NA
East Lothian NA
East Renfrewshire NA
Edinburgh East NA
Edinburgh North and Leith NA
Edinburgh South NA
Edinburgh South West NA
Edinburgh West NA
Falkirk NA
Glasgow Central NA
Glasgow East NA
Glasgow North NA
Glasgow North East NA
Glasgow North West NA
Glasgow South NA
Glasgow South West NA
Glenrothes NA
Gordon NA
Inverclyde NA
Inverness, Nairn, Badenoch and Strathspey NA
Kilmarnock and Loudoun NA
Kirkcaldy and Cowdenbeath NA
Lanark and Hamilton East NA
Linlithgow and East Falkirk NA
Livingston NA
Midlothian NA
Moray NA
Motherwell and Wishaw NA
Na h-Eileanan An Iar NA
North Ayrshire and Arran NA
North East Fife NA
Ochil and South Perthshire NA
Orkney and Shetland NA
Paisley and Renfrewshire North NA
Paisley and Renfrewshire South NA
Perth and North Perthshire NA
Ross, Skye and Lochaber NA
Rutherglen and Hamilton West NA
Stirling NA
West Aberdeenshire and Kincardine NA
West Dunbartonshire NA

Fairly uninspiring so let’s see if we can plot them with a little more excitement. I got a Hex Plot from arcgis.

Code
# import shapefile 
parliamentary_map <- st_read("/Users/stevenolan/Library/CloudStorage/OneDrive-LiverpoolJohnMooresUniversity/projects/social_value/nomis/r_script/GB_Hex_Cartogram_Const/GB_Hex_Cartogram_Const.shp")  
Reading layer `GB_Hex_Cartogram_Const' from data source 
  `/Users/stevenolan/Library/CloudStorage/OneDrive-LiverpoolJohnMooresUniversity/projects/social_value/nomis/r_script/GB_Hex_Cartogram_Const/GB_Hex_Cartogram_Const.shp' 
  using driver `ESRI Shapefile'
Simple feature collection with 650 features and 7 fields
Geometry type: POLYGON
Dimension:     XY
Bounding box:  xmin: -806879.7 ymin: 6448226 xmax: 257550.8 ymax: 7974243
Projected CRS: WGS 84 / Pseudo-Mercator
Code
# filter for Whites
aps_recent_white <- aps_recent[order(aps_recent$OBS_VALUE, decreasing = FALSE),] %>% 
  filter(VARIABLE == 557)

# Merge data
merged_data <- merge(parliamentary_map, aps_recent_white, by.x = "CODE", by.y = "GEOGRAPHY_CODE", all.x = TRUE)

# Plot heatmap
ggplot() +
  geom_sf(data = merged_data, aes(fill = OBS_VALUE)) +
  scale_fill_viridis_c(name=" ") +  # Adjust colors as needed
  labs(title = "% Whites by Parliamentary Constituency") +
  theme_minimal()