This short report describes how ethnicity can be identified in the OpenSAFELY-TPP database, and the strengths and weaknesses of the methods. This is a living document that will be updated to reflect changes to the OpenSAFELY-TPP database and the patient records within.
OpenSAFELY is an analytics platform for conducting analyses on Electronic Health Records inside the secure environment where the records are held. This has multiple benefits:
A key feature of OpenSAFELY is the use of study definitions, which are formal specifications of the datasets to be generated from the OpenSAFELY database. This takes care of much of the complex EHR data wrangling required to create a dataset in an analysis-ready format. It also creates a library of standardised and validated variable definitions that can be deployed consistently across multiple projects.
The purpose of this report is to describe all such variables that relate to BMI, their relative strengths and weaknesses, in what scenarios they are best deployed. It will also describe potential future definitions that have not yet been implemented.
OpenSAFELY-TPP runs inside TPP’s data centre which contains the primary care records for all patients registered at practices using TPP’s SystmOne Clinical Information System. This data centre also imports external datasets from other sources, including A&E attendances and hospital admissions from NHS Digital’s Secondary Use Service, and death registrations from the ONS. More information on available data sources can be found within the OpenSAFELY documentation.
ethnicity_16 | ethnicity_new_16 | ethnicity_primis_16 | all_filled | population | ||
---|---|---|---|---|---|---|
group | subgroup | |||||
all | with records | 24474735.0 (74.6) | 24129590.0 (73.5) | 19159630.0 (58.4) | 18943015.0 (57.7) | 32807505.0 |
age_band | 0-19 | 3948960.0 (62.5) | 3892720.0 (61.6) | 2988370.0 (47.3) | 2956815.0 (46.8) | 6314700.0 |
20-29 | 3014255.0 (72.1) | 2971670.0 (71.1) | 2406685.0 (57.6) | 2380180.0 (56.9) | 4181455.0 | |
30-39 | 3967180.0 (81.4) | 3903095.0 (80.0) | 3193225.0 (65.5) | 3152280.0 (64.7) | 4875825.0 | |
40-49 | 3242920.0 (81.4) | 3188675.0 (80.0) | 2585550.0 (64.9) | 2551215.0 (64.0) | 3985390.0 | |
50-59 | 3169745.0 (79.5) | 3126855.0 (78.4) | 2506200.0 (62.8) | 2478290.0 (62.1) | 3988210.0 | |
60-69 | 2578365.0 (79.5) | 2547130.0 (78.6) | 2025760.0 (62.5) | 2005025.0 (61.8) | 3242295.0 | |
70-79 | 2230210.0 (78.9) | 2204475.0 (78.0) | 1734190.0 (61.4) | 1716875.0 (60.8) | 2825395.0 | |
80+ | 2310790.0 (68.9) | 2282770.0 (68.1) | 1713295.0 (51.1) | 1695985.0 (50.6) | 3352430.0 | |
missing | 12310.0 (29.4) | 12200.0 (29.2) | 6360.0 (15.2) | 6350.0 (15.2) | 41810.0 | |
sex | F | 12567380.0 (76.2) | 12390885.0 (75.2) | 9900805.0 (60.1) | 9788470.0 (59.4) | 16485060.0 |
M | 11907360.0 (73.0) | 11738705.0 (71.9) | 9258825.0 (56.7) | 9154545.0 (56.1) | 16322445.0 | |
region | East | 4354510.0 (75.6) | 4294100.0 (74.6) | 3380420.0 (58.7) | 3344085.0 (58.1) | 5758535.0 |
East Midlands | 3262875.0 (76.6) | 3208865.0 (75.3) | 2507680.0 (58.9) | 2472405.0 (58.0) | 4260350.0 | |
London | 1436215.0 (80.0) | 1409285.0 (78.5) | 1262330.0 (70.4) | 1243690.0 (69.3) | 1794330.0 | |
North East | 888240.0 (76.1) | 881040.0 (75.5) | 739970.0 (63.4) | 734745.0 (63.0) | 1166440.0 | |
North West | 1621780.0 (76.0) | 1603115.0 (75.1) | 1193320.0 (55.9) | 1183135.0 (55.4) | 2134525.0 | |
South East | 1216550.0 (74.0) | 1199055.0 (72.9) | 939735.0 (57.2) | 928370.0 (56.5) | 1643790.0 | |
South West | 2481280.0 (73.0) | 2454175.0 (72.2) | 1886215.0 (55.5) | 1868945.0 (55.0) | 3399525.0 | |
West Midlands | 811275.0 (80.2) | 794275.0 (78.6) | 616410.0 (61.0) | 605155.0 (59.9) | 1010960.0 | |
Yorkshire and The Humber | 2688860.0 (75.7) | 2658015.0 (74.8) | 2170395.0 (61.1) | 2148670.0 (60.5) | 3552510.0 | |
imd | 1 Most deprived | 4918965.0 (76.3) | 4836790.0 (75.0) | 3899640.0 (60.5) | 3850080.0 (59.7) | 6450350.0 |
2 | 4889880.0 (75.6) | 4817165.0 (74.5) | 3872780.0 (59.9) | 3826505.0 (59.2) | 6467650.0 | |
3 | 5122765.0 (75.2) | 5054475.0 (74.2) | 4007860.0 (58.8) | 3963295.0 (58.2) | 6811855.0 | |
4 | 4647340.0 (74.1) | 4585355.0 (73.1) | 3618525.0 (57.7) | 3578945.0 (57.1) | 6270250.0 | |
5 Least deprived | 4127870.0 (73.0) | 4077950.0 (72.1) | 3165520.0 (56.0) | 3134720.0 (55.4) | 5656380.0 | |
Unknown | 767920.0 (66.7) | 757855.0 (65.8) | 595310.0 (51.7) | 589475.0 (51.2) | 1151025.0 | |
dementia | False | 24333695.0 (74.6) | 23990845.0 (73.6) | 19052375.0 (58.4) | 18837280.0 (57.8) | 32614480.0 |
True | 141040.0 (73.1) | 138745.0 (71.9) | 107255.0 (55.6) | 105740.0 (54.8) | 193025.0 | |
diabetes | False | 21870490.0 (73.9) | 21562400.0 (72.9) | 17102235.0 (57.8) | 16910840.0 (57.2) | 29576355.0 |
True | 2604250.0 (80.6) | 2567190.0 (79.5) | 2057395.0 (63.7) | 2032175.0 (62.9) | 3231150.0 | |
hypertension | False | 22878575.0 (74.1) | 22551810.0 (73.0) | 17912060.0 (58.0) | 17707690.0 (57.3) | 30881665.0 |
True | 1596160.0 (82.9) | 1577785.0 (81.9) | 1247570.0 (64.8) | 1235325.0 (64.1) | 1925840.0 | |
learning_disability | False | 24332055.0 (74.6) | 23989775.0 (73.5) | 19043695.0 (58.4) | 18829235.0 (57.7) | 32632255.0 |
True | 142680.0 (81.4) | 139815.0 (79.8) | 115935.0 (66.2) | 113780.0 (64.9) | 175250.0 |
ethnicity_16 | ethnicity_new_16 | ethnicity_primis_16 | all_missing | population | ||
---|---|---|---|---|---|---|
group | subgroup | |||||
all | missing records | 8332770.0 (25.4) | 8677915.0 (26.5) | 13647875.0 (41.6) | 8332770.0 (25.4) | 32807505.0 |
age_band | 0-19 | 2365740.0 (37.5) | 2421980.0 (38.4) | 3326330.0 (52.7) | 2365740.0 (37.5) | 6314700.0 |
20-29 | 1167200.0 (27.9) | 1209785.0 (28.9) | 1774775.0 (42.4) | 1167200.0 (27.9) | 4181455.0 | |
30-39 | 908640.0 (18.6) | 972730.0 (20.0) | 1682600.0 (34.5) | 908640.0 (18.6) | 4875825.0 | |
40-49 | 742465.0 (18.6) | 796715.0 (20.0) | 1399835.0 (35.1) | 742465.0 (18.6) | 3985390.0 | |
50-59 | 818470.0 (20.5) | 861355.0 (21.6) | 1482010.0 (37.2) | 818470.0 (20.5) | 3988210.0 | |
60-69 | 663930.0 (20.5) | 695165.0 (21.4) | 1216535.0 (37.5) | 663930.0 (20.5) | 3242295.0 | |
70-79 | 595185.0 (21.1) | 620920.0 (22.0) | 1091205.0 (38.6) | 595185.0 (21.1) | 2825395.0 | |
80+ | 1041640.0 (31.1) | 1069660.0 (31.9) | 1639135.0 (48.9) | 1041640.0 (31.1) | 3352430.0 | |
missing | 29495.0 (70.5) | 29610.0 (70.8) | 35450.0 (84.8) | 29495.0 (70.5) | 41810.0 | |
sex | F | 3917680.0 (23.8) | 4094175.0 (24.8) | 6584255.0 (39.9) | 3917680.0 (23.8) | 16485060.0 |
M | 4415090.0 (27.0) | 4583740.0 (28.1) | 7063620.0 (43.3) | 4415090.0 (27.0) | 16322445.0 | |
region | East | 1404020.0 (24.4) | 1464430.0 (25.4) | 2378115.0 (41.3) | 1404020.0 (24.4) | 5758535.0 |
East Midlands | 997470.0 (23.4) | 1051485.0 (24.7) | 1752665.0 (41.1) | 997470.0 (23.4) | 4260350.0 | |
London | 358115.0 (20.0) | 385045.0 (21.5) | 532005.0 (29.6) | 358115.0 (20.0) | 1794330.0 | |
North East | 278200.0 (23.9) | 285400.0 (24.5) | 426475.0 (36.6) | 278200.0 (23.9) | 1166440.0 | |
North West | 512745.0 (24.0) | 531410.0 (24.9) | 941205.0 (44.1) | 512745.0 (24.0) | 2134525.0 | |
South East | 427245.0 (26.0) | 444735.0 (27.1) | 704060.0 (42.8) | 427245.0 (26.0) | 1643790.0 | |
South West | 918245.0 (27.0) | 945350.0 (27.8) | 1513310.0 (44.5) | 918245.0 (27.0) | 3399525.0 | |
West Midlands | 199685.0 (19.8) | 216685.0 (21.4) | 394550.0 (39.0) | 199685.0 (19.8) | 1010960.0 | |
Yorkshire and The Humber | 863655.0 (24.3) | 894500.0 (25.2) | 1382115.0 (38.9) | 863655.0 (24.3) | 3552510.0 | |
imd | 1 Most deprived | 1531390.0 (23.7) | 1613560.0 (25.0) | 2550710.0 (39.5) | 1531390.0 (23.7) | 6450350.0 |
2 | 1577770.0 (24.4) | 1650485.0 (25.5) | 2594870.0 (40.1) | 1577770.0 (24.4) | 6467650.0 | |
3 | 1689090.0 (24.8) | 1757380.0 (25.8) | 2804000.0 (41.2) | 1689090.0 (24.8) | 6811855.0 | |
4 | 1622910.0 (25.9) | 1684890.0 (26.9) | 2651725.0 (42.3) | 1622910.0 (25.9) | 6270250.0 | |
5 Least deprived | 1528510.0 (27.0) | 1578430.0 (27.9) | 2490860.0 (44.0) | 1528510.0 (27.0) | 5656380.0 | |
Unknown | 383105.0 (33.3) | 393170.0 (34.2) | 555715.0 (48.3) | 383105.0 (33.3) | 1151025.0 | |
dementia | False | 8280780.0 (25.4) | 8623630.0 (26.4) | 13562105.0 (41.6) | 8280780.0 (25.4) | 32614480.0 |
True | 51985.0 (26.9) | 54280.0 (28.1) | 85770.0 (44.4) | 51985.0 (26.9) | 193025.0 | |
diabetes | False | 7705865.0 (26.1) | 8013955.0 (27.1) | 12474120.0 (42.2) | 7705865.0 (26.1) | 29576355.0 |
True | 626905.0 (19.4) | 663960.0 (20.5) | 1173755.0 (36.3) | 626905.0 (19.4) | 3231150.0 | |
hypertension | False | 8003090.0 (25.9) | 8329855.0 (27.0) | 12969605.0 (42.0) | 8003090.0 (25.9) | 30881665.0 |
True | 329680.0 (17.1) | 348060.0 (18.1) | 678270.0 (35.2) | 329680.0 (17.1) | 1925840.0 | |
learning_disability | False | 8300200.0 (25.4) | 8642480.0 (26.5) | 13588560.0 (41.6) | 8300200.0 (25.4) | 32632255.0 |
True | 32570.0 (18.6) | 35435.0 (20.2) | 59315.0 (33.8) | 32570.0 (18.6) | 175250.0 |
ethnicity_16_African | ethnicity_new_16_African | ethnicity_primis_16_African | ethnicity_16_Any_other_ethnic_group | ethnicity_new_16_Any_other_ethnic_group | ethnicity_primis_16_Any_other_ethnic_group | ethnicity_16_Bangladeshi | ethnicity_new_16_Bangladeshi | ethnicity_primis_16_Bangladeshi | ethnicity_16_Caribbean | ethnicity_new_16_Caribbean | ethnicity_primis_16_Caribbean | ethnicity_16_Chinese | ethnicity_new_16_Chinese | ethnicity_primis_16_Chinese | ethnicity_16_Indian | ethnicity_new_16_Indian | ethnicity_primis_16_Indian | ethnicity_16_Other_Asian | ethnicity_new_16_Other_Asian | ethnicity_primis_16_Other_Asian | ethnicity_16_Other_Black | ethnicity_new_16_Other_Black | ethnicity_primis_16_Other_Black | ethnicity_16_Other_Mixed | ethnicity_new_16_Other_Mixed | ethnicity_primis_16_Other_Mixed | ethnicity_16_Other_White | ethnicity_new_16_Other_White | ethnicity_primis_16_Other_White | ethnicity_16_Pakistani | ethnicity_new_16_Pakistani | ethnicity_primis_16_Pakistani | ethnicity_16_White_British | ethnicity_new_16_White_British | ethnicity_primis_16_White_British | ethnicity_16_White_Irish | ethnicity_new_16_White_Irish | ethnicity_primis_16_White_Irish | ethnicity_16_White_and_Asian | ethnicity_new_16_White_and_Asian | ethnicity_primis_16_White_and_Asian | ethnicity_16_White_and_Black_African | ethnicity_new_16_White_and_Black_African | ethnicity_primis_16_White_and_Black_African | ethnicity_16_White_and_Black_Caribbean | ethnicity_new_16_White_and_Black_Caribbean | ethnicity_primis_16_White_and_Black_Caribbean | all_filled | population | ||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
group | subgroup | ||||||||||||||||||||||||||||||||||||||||||||||||||
all | with records | 462975.0 (1.4) | 495065.0 (1.5) | 400755.0 (1.2) | 547375.0 (1.7) | 411605.0 (1.3) | 426520.0 (1.3) | 147920.0 (0.5) | 146470.0 (0.4) | 126265.0 (0.4) | 143395.0 (0.4) | 144930.0 (0.4) | 112850.0 (0.3) | 286085.0 (0.9) | 285040.0 (0.9) | 250100.0 (0.8) | 903480.0 (2.8) | 901870.0 (2.7) | 773030.0 (2.4) | 510855.0 (1.6) | 532905.0 (1.6) | 441730.0 (1.3) | 171320.0 (0.5) | 128510.0 (0.4) | 93390.0 (0.3) | 178655.0 (0.5) | 174875.0 (0.5) | 149975.0 (0.5) | 2806585.0 (8.6) | 3103285.0 (9.5) | 2162505.0 (6.6) | 597280.0 (1.8) | 592250.0 (1.8) | 533330.0 (1.6) | 17269720.0 (52.6) | 16768685.0 (51.1) | 13283385.0 (40.5) | 156470.0 (0.5) | 153715.0 (0.5) | 127640.0 (0.4) | 100350.0 (0.3) | 99165.0 (0.3) | 93255.0 (0.3) | 92720.0 (0.3) | 91635.0 (0.3) | 92855.0 (0.3) | 99555.0 (0.3) | 99585.0 (0.3) | 92040.0 (0.3) | 18943015.0 (57.7) | 32807505.0 |
age_band | 0-19 | 107205.0 (1.7) | 115980.0 (1.8) | 90005.0 (1.4) | 111980.0 (1.8) | 86160.0 (1.4) | 87070.0 (1.4) | 38360.0 (0.6) | 38075.0 (0.6) | 32600.0 (0.5) | 17940.0 (0.3) | 18135.0 (0.3) | 13415.0 (0.2) | 30985.0 (0.5) | 30910.0 (0.5) | 25885.0 (0.4) | 150800.0 (2.4) | 150280.0 (2.4) | 126235.0 (2.0) | 97685.0 (1.5) | 101495.0 (1.6) | 82680.0 (1.3) | 43920.0 (0.7) | 33115.0 (0.5) | 23485.0 (0.4) | 60120.0 (1.0) | 58880.0 (0.9) | 48255.0 (0.8) | 424090.0 (6.7) | 459405.0 (7.3) | 322280.0 (5.1) | 160180.0 (2.5) | 159015.0 (2.5) | 141465.0 (2.2) | 2596240.0 (41.1) | 2532700.0 (40.1) | 1897705.0 (30.1) | 10620.0 (0.2) | 10355.0 (0.2) | 8515.0 (0.1) | 36225.0 (0.6) | 35835.0 (0.6) | 32140.0 (0.5) | 28815.0 (0.5) | 28480.0 (0.5) | 27010.0 (0.4) | 33800.0 (0.5) | 33900.0 (0.5) | 29615.0 (0.5) | 2956815.0 (46.8) | 6314700.0 |
20-29 | 79605.0 (1.9) | 85155.0 (2.0) | 69445.0 (1.7) | 94650.0 (2.3) | 72270.0 (1.7) | 74915.0 (1.8) | 24015.0 (0.6) | 23800.0 (0.6) | 20290.0 (0.5) | 17970.0 (0.4) | 18070.0 (0.4) | 13820.0 (0.3) | 102125.0 (2.4) | 102115.0 (2.4) | 92595.0 (2.2) | 131480.0 (3.1) | 131140.0 (3.1) | 109720.0 (2.6) | 84895.0 (2.0) | 89030.0 (2.1) | 73155.0 (1.7) | 29030.0 (0.7) | 21930.0 (0.5) | 16105.0 (0.4) | 32415.0 (0.8) | 31730.0 (0.8) | 27295.0 (0.7) | 437480.0 (10.5) | 469250.0 (11.2) | 357750.0 (8.6) | 88715.0 (2.1) | 87855.0 (2.1) | 78290.0 (1.9) | 1819840.0 (43.5) | 1767865.0 (42.3) | 1406870.0 (33.6) | 16440.0 (0.4) | 16160.0 (0.4) | 13860.0 (0.3) | 19815.0 (0.5) | 19625.0 (0.5) | 18780.0 (0.4) | 16000.0 (0.4) | 15855.0 (0.4) | 15760.0 (0.4) | 19780.0 (0.5) | 19820.0 (0.5) | 18025.0 (0.4) | 2380180.0 (56.9) | 4181455.0 | |
30-39 | 97075.0 (2.0) | 102915.0 (2.1) | 84590.0 (1.7) | 133345.0 (2.7) | 100275.0 (2.1) | 106015.0 (2.2) | 32165.0 (0.7) | 31815.0 (0.7) | 27675.0 (0.6) | 21125.0 (0.4) | 21255.0 (0.4) | 16315.0 (0.3) | 75840.0 (1.6) | 75280.0 (1.5) | 66760.0 (1.4) | 222890.0 (4.6) | 222465.0 (4.6) | 191370.0 (3.9) | 122265.0 (2.5) | 126895.0 (2.6) | 103880.0 (2.1) | 30140.0 (0.6) | 22470.0 (0.5) | 16140.0 (0.3) | 36655.0 (0.8) | 35905.0 (0.7) | 31795.0 (0.7) | 756375.0 (15.5) | 809400.0 (16.6) | 645110.0 (13.2) | 123635.0 (2.5) | 122530.0 (2.5) | 110770.0 (2.3) | 2233910.0 (45.8) | 2151115.0 (44.1) | 1716920.0 (35.2) | 27775.0 (0.6) | 27250.0 (0.6) | 23470.0 (0.5) | 18580.0 (0.4) | 18365.0 (0.4) | 17765.0 (0.4) | 17255.0 (0.4) | 17060.0 (0.3) | 17795.0 (0.4) | 18145.0 (0.4) | 18110.0 (0.4) | 16860.0 (0.3) | 3152280.0 (64.7) | 4875825.0 | |
40-49 | 90760.0 (2.3) | 96425.0 (2.4) | 78805.0 (2.0) | 100745.0 (2.5) | 74385.0 (1.9) | 78755.0 (2.0) | 27970.0 (0.7) | 27650.0 (0.7) | 24045.0 (0.6) | 18930.0 (0.5) | 19240.0 (0.5) | 15015.0 (0.4) | 35680.0 (0.9) | 35460.0 (0.9) | 30125.0 (0.8) | 169530.0 (4.3) | 168855.0 (4.2) | 146560.0 (3.7) | 97915.0 (2.5) | 103035.0 (2.6) | 87100.0 (2.2) | 27780.0 (0.7) | 20025.0 (0.5) | 14900.0 (0.4) | 23845.0 (0.6) | 23295.0 (0.6) | 20740.0 (0.5) | 509040.0 (12.8) | 547910.0 (13.7) | 414995.0 (10.4) | 101745.0 (2.6) | 100860.0 (2.5) | 91520.0 (2.3) | 1981245.0 (49.7) | 1914615.0 (48.0) | 1529180.0 (38.4) | 21065.0 (0.5) | 20650.0 (0.5) | 17210.0 (0.4) | 11990.0 (0.3) | 11790.0 (0.3) | 11405.0 (0.3) | 15040.0 (0.4) | 14830.0 (0.4) | 15960.0 (0.4) | 9640.0 (0.2) | 9650.0 (0.2) | 9235.0 (0.2) | 2551215.0 (64.0) | 3985390.0 | |
50-59 | 53950.0 (1.4) | 57880.0 (1.5) | 47885.0 (1.2) | 53995.0 (1.4) | 39545.0 (1.0) | 40665.0 (1.0) | 12820.0 (0.3) | 12685.0 (0.3) | 11090.0 (0.3) | 25855.0 (0.6) | 26390.0 (0.7) | 21080.0 (0.5) | 20220.0 (0.5) | 20130.0 (0.5) | 17200.0 (0.4) | 87425.0 (2.2) | 87455.0 (2.2) | 76400.0 (1.9) | 53620.0 (1.3) | 56760.0 (1.4) | 48115.0 (1.2) | 23555.0 (0.6) | 17830.0 (0.4) | 13350.0 (0.3) | 13440.0 (0.3) | 13125.0 (0.3) | 11450.0 (0.3) | 282895.0 (7.1) | 314785.0 (7.9) | 201215.0 (5.0) | 54695.0 (1.4) | 54220.0 (1.4) | 49940.0 (1.3) | 2441885.0 (61.2) | 2381240.0 (59.7) | 1926330.0 (48.3) | 20230.0 (0.5) | 19875.0 (0.5) | 16275.0 (0.4) | 7235.0 (0.2) | 7135.0 (0.2) | 6885.0 (0.2) | 8965.0 (0.2) | 8860.0 (0.2) | 9500.0 (0.2) | 8960.0 (0.2) | 8940.0 (0.2) | 8825.0 (0.2) | 2478290.0 (62.1) | 3988210.0 | |
60-69 | 21235.0 (0.7) | 22625.0 (0.7) | 18705.0 (0.6) | 27875.0 (0.9) | 20640.0 (0.6) | 20965.0 (0.6) | 6395.0 (0.2) | 6335.0 (0.2) | 5410.0 (0.2) | 17655.0 (0.5) | 17935.0 (0.6) | 14430.0 (0.4) | 12125.0 (0.4) | 12065.0 (0.4) | 10145.0 (0.3) | 67820.0 (2.1) | 67925.0 (2.1) | 59420.0 (1.8) | 28940.0 (0.9) | 29810.0 (0.9) | 24950.0 (0.8) | 10340.0 (0.3) | 8055.0 (0.2) | 5840.0 (0.2) | 6805.0 (0.2) | 6675.0 (0.2) | 5895.0 (0.2) | 175985.0 (5.4) | 202850.0 (6.3) | 112195.0 (3.5) | 33765.0 (1.0) | 33490.0 (1.0) | 30630.0 (0.9) | 2139750.0 (66.0) | 2089465.0 (64.4) | 1690980.0 (52.2) | 17715.0 (0.5) | 17440.0 (0.5) | 14070.0 (0.4) | 3470.0 (0.1) | 3430.0 (0.1) | 3385.0 (0.1) | 3940.0 (0.1) | 3880.0 (0.1) | 4095.0 (0.1) | 4550.0 (0.1) | 4515.0 (0.1) | 4645.0 (0.1) | 2005025.0 (61.8) | 3242295.0 | |
70-79 | 8220.0 (0.3) | 8750.0 (0.3) | 7115.0 (0.3) | 14480.0 (0.5) | 10615.0 (0.4) | 10630.0 (0.4) | 2845.0 (0.1) | 2805.0 (0.1) | 2425.0 (0.1) | 8325.0 (0.3) | 8355.0 (0.3) | 6660.0 (0.2) | 5600.0 (0.2) | 5585.0 (0.2) | 4600.0 (0.2) | 40565.0 (1.4) | 40640.0 (1.4) | 35420.0 (1.3) | 15710.0 (0.6) | 16180.0 (0.6) | 13550.0 (0.5) | 3645.0 (0.1) | 2845.0 (0.1) | 2045.0 (0.1) | 3040.0 (0.1) | 2975.0 (0.1) | 2620.0 (0.1) | 111530.0 (3.9) | 139945.0 (5.0) | 56765.0 (2.0) | 17085.0 (0.6) | 16945.0 (0.6) | 15380.0 (0.5) | 1974390.0 (69.9) | 1924395.0 (68.1) | 1555990.0 (55.1) | 19480.0 (0.7) | 19200.0 (0.7) | 15685.0 (0.6) | 1745.0 (0.1) | 1720.0 (0.1) | 1655.0 (0.1) | 1690.0 (0.1) | 1665.0 (0.1) | 1720.0 (0.1) | 1860.0 (0.1) | 1850.0 (0.1) | 1935.0 (0.1) | 1716875.0 (60.8) | 2825395.0 | |
80+ | 4665.0 (0.1) | 5045.0 (0.2) | 4050.0 (0.1) | 9980.0 (0.3) | 7490.0 (0.2) | 7310.0 (0.2) | 3225.0 (0.1) | 3185.0 (0.1) | 2665.0 (0.1) | 15560.0 (0.5) | 15505.0 (0.5) | 12095.0 (0.4) | 3475.0 (0.1) | 3460.0 (0.1) | 2765.0 (0.1) | 32600.0 (1.0) | 32745.0 (1.0) | 27685.0 (0.8) | 9600.0 (0.3) | 9460.0 (0.3) | 8145.0 (0.2) | 2785.0 (0.1) | 2150.0 (0.1) | 1475.0 (0.0) | 2115.0 (0.1) | 2075.0 (0.1) | 1770.0 (0.1) | 108240.0 (3.2) | 158665.0 (4.7) | 51605.0 (1.5) | 17000.0 (0.5) | 16880.0 (0.5) | 15010.0 (0.4) | 2073705.0 (61.9) | 1998690.0 (59.6) | 1555315.0 (46.4) | 23115.0 (0.7) | 22760.0 (0.7) | 18540.0 (0.6) | 1140.0 (0.0) | 1120.0 (0.0) | 1135.0 (0.0) | 925.0 (0.0) | 915.0 (0.0) | 950.0 (0.0) | 2650.0 (0.1) | 2635.0 (0.1) | 2780.0 (0.1) | 1695985.0 (50.6) | 3352430.0 | |
missing | 265.0 (0.6) | 290.0 (0.7) | 155.0 (0.4) | 325.0 (0.8) | 220.0 (0.5) | 200.0 (0.5) | 115.0 (0.3) | 115.0 (0.3) | 70.0 (0.2) | 40.0 (0.1) | 45.0 (0.1) | 20.0 (0.0) | 40.0 (0.1) | 40.0 (0.1) | 25.0 (0.1) | 360.0 (0.9) | 360.0 (0.9) | 215.0 (0.5) | 230.0 (0.6) | 235.0 (0.6) | 155.0 (0.4) | 120.0 (0.3) | 90.0 (0.2) | 50.0 (0.1) | 215.0 (0.5) | 215.0 (0.5) | 160.0 (0.4) | 950.0 (2.3) | 1075.0 (2.6) | 590.0 (1.4) | 455.0 (1.1) | 455.0 (1.1) | 315.0 (0.8) | 8750.0 (20.9) | 8610.0 (20.6) | 4095.0 (9.8) | 25.0 (0.1) | 25.0 (0.1) | 15.0 (0.0) | 150.0 (0.4) | 150.0 (0.4) | 110.0 (0.3) | 95.0 (0.2) | 95.0 (0.2) | 75.0 (0.2) | 165.0 (0.4) | 170.0 (0.4) | 110.0 (0.3) | 6350.0 (15.2) | 41810.0 | |
sex | F | 232365.0 (1.4) | 248755.0 (1.5) | 202295.0 (1.2) | 269230.0 (1.6) | 198175.0 (1.2) | 205745.0 (1.2) | 69995.0 (0.4) | 69270.0 (0.4) | 59780.0 (0.4) | 74645.0 (0.5) | 75480.0 (0.5) | 59420.0 (0.4) | 163200.0 (1.0) | 162605.0 (1.0) | 143575.0 (0.9) | 430070.0 (2.6) | 429255.0 (2.6) | 369460.0 (2.2) | 258835.0 (1.6) | 273680.0 (1.7) | 227630.0 (1.4) | 86615.0 (0.5) | 64750.0 (0.4) | 47395.0 (0.3) | 92030.0 (0.6) | 90095.0 (0.5) | 77875.0 (0.5) | 1468735.0 (8.9) | 1619535.0 (9.8) | 1146910.0 (7.0) | 287640.0 (1.7) | 285105.0 (1.7) | 257470.0 (1.6) | 8903275.0 (54.0) | 8645955.0 (52.4) | 6893755.0 (41.8) | 79905.0 (0.5) | 78510.0 (0.5) | 65530.0 (0.4) | 51545.0 (0.3) | 50965.0 (0.3) | 48155.0 (0.3) | 47050.0 (0.3) | 46515.0 (0.3) | 47290.0 (0.3) | 52250.0 (0.3) | 52245.0 (0.3) | 48520.0 (0.3) | 9788470.0 (59.4) | 16485060.0 |
M | 230615.0 (1.4) | 246310.0 (1.5) | 198460.0 (1.2) | 278145.0 (1.7) | 213430.0 (1.3) | 220775.0 (1.4) | 77925.0 (0.5) | 77200.0 (0.5) | 66485.0 (0.4) | 68750.0 (0.4) | 69450.0 (0.4) | 53425.0 (0.3) | 122885.0 (0.8) | 122435.0 (0.8) | 106525.0 (0.7) | 473410.0 (2.9) | 472615.0 (2.9) | 403570.0 (2.5) | 252020.0 (1.5) | 259225.0 (1.6) | 214100.0 (1.3) | 84705.0 (0.5) | 63760.0 (0.4) | 45995.0 (0.3) | 86625.0 (0.5) | 84785.0 (0.5) | 72100.0 (0.4) | 1337845.0 (8.2) | 1483750.0 (9.1) | 1015595.0 (6.2) | 309645.0 (1.9) | 307145.0 (1.9) | 275855.0 (1.7) | 8366445.0 (51.3) | 8122730.0 (49.8) | 6389630.0 (39.1) | 76565.0 (0.5) | 75200.0 (0.5) | 62115.0 (0.4) | 48805.0 (0.3) | 48200.0 (0.3) | 45100.0 (0.3) | 45670.0 (0.3) | 45125.0 (0.3) | 45570.0 (0.3) | 47305.0 (0.3) | 47340.0 (0.3) | 43520.0 (0.3) | 9154545.0 (56.1) | 16322445.0 | |
region | East | 88840.0 (1.5) | 92820.0 (1.6) | 72255.0 (1.3) | 73005.0 (1.3) | 50945.0 (0.9) | 54870.0 (1.0) | 35960.0 (0.6) | 35620.0 (0.6) | 30155.0 (0.5) | 22385.0 (0.4) | 22660.0 (0.4) | 16945.0 (0.3) | 35620.0 (0.6) | 35455.0 (0.6) | 30220.0 (0.5) | 105110.0 (1.8) | 104470.0 (1.8) | 88265.0 (1.5) | 67810.0 (1.2) | 71000.0 (1.2) | 59025.0 (1.0) | 31995.0 (0.6) | 26055.0 (0.5) | 18165.0 (0.3) | 31935.0 (0.6) | 31320.0 (0.5) | 26470.0 (0.5) | 533995.0 (9.3) | 608455.0 (10.6) | 411130.0 (7.1) | 78650.0 (1.4) | 77945.0 (1.4) | 68385.0 (1.2) | 3166320.0 (55.0) | 3055345.0 (53.1) | 2428950.0 (42.2) | 27550.0 (0.5) | 27095.0 (0.5) | 22145.0 (0.4) | 17100.0 (0.3) | 16890.0 (0.3) | 16055.0 (0.3) | 20025.0 (0.3) | 19805.0 (0.3) | 20525.0 (0.4) | 18220.0 (0.3) | 18225.0 (0.3) | 16855.0 (0.3) | 3344085.0 (58.1) | 5758535.0 |
East Midlands | 56860.0 (1.3) | 61945.0 (1.5) | 49455.0 (1.2) | 54195.0 (1.3) | 40145.0 (0.9) | 41130.0 (1.0) | 13115.0 (0.3) | 13025.0 (0.3) | 11245.0 (0.3) | 17020.0 (0.4) | 17450.0 (0.4) | 13055.0 (0.3) | 23960.0 (0.6) | 23830.0 (0.6) | 21160.0 (0.5) | 195040.0 (4.6) | 194650.0 (4.6) | 165700.0 (3.9) | 51525.0 (1.2) | 52605.0 (1.2) | 38530.0 (0.9) | 20785.0 (0.5) | 14335.0 (0.3) | 10080.0 (0.2) | 18095.0 (0.4) | 17650.0 (0.4) | 13885.0 (0.3) | 330765.0 (7.8) | 349300.0 (8.2) | 237835.0 (5.6) | 49030.0 (1.2) | 48460.0 (1.1) | 42610.0 (1.0) | 2378710.0 (55.8) | 2322300.0 (54.5) | 1814725.0 (42.6) | 13600.0 (0.3) | 13290.0 (0.3) | 10795.0 (0.3) | 12285.0 (0.3) | 12120.0 (0.3) | 11290.0 (0.3) | 10475.0 (0.2) | 10355.0 (0.2) | 10520.0 (0.2) | 17425.0 (0.4) | 17410.0 (0.4) | 15670.0 (0.4) | 2472405.0 (58.0) | 4260350.0 | |
London | 65025.0 (3.6) | 71625.0 (4.0) | 62175.0 (3.5) | 106405.0 (5.9) | 84645.0 (4.7) | 87605.0 (4.9) | 17440.0 (1.0) | 17290.0 (1.0) | 15730.0 (0.9) | 27065.0 (1.5) | 26945.0 (1.5) | 22660.0 (1.3) | 41940.0 (2.3) | 41935.0 (2.3) | 37445.0 (2.1) | 167190.0 (9.3) | 168045.0 (9.4) | 148740.0 (8.3) | 117040.0 (6.5) | 122165.0 (6.8) | 109160.0 (6.1) | 28455.0 (1.6) | 20290.0 (1.1) | 16295.0 (0.9) | 30685.0 (1.7) | 30100.0 (1.7) | 28155.0 (1.6) | 386540.0 (21.5) | 390470.0 (21.8) | 341305.0 (19.0) | 50210.0 (2.8) | 49790.0 (2.8) | 44420.0 (2.5) | 348315.0 (19.4) | 336760.0 (18.8) | 302790.0 (16.9) | 21850.0 (1.2) | 21445.0 (1.2) | 19230.0 (1.1) | 10875.0 (0.6) | 10745.0 (0.6) | 10020.0 (0.6) | 8510.0 (0.5) | 8390.0 (0.5) | 8330.0 (0.5) | 8660.0 (0.5) | 8645.0 (0.5) | 8265.0 (0.5) | 1243690.0 (69.3) | 1794330.0 | |
North East | 13365.0 (1.1) | 14340.0 (1.2) | 12545.0 (1.1) | 16080.0 (1.4) | 13270.0 (1.1) | 14215.0 (1.2) | 2500.0 (0.2) | 2490.0 (0.2) | 2215.0 (0.2) | 2495.0 (0.2) | 2560.0 (0.2) | 2095.0 (0.2) | 6430.0 (0.6) | 6420.0 (0.6) | 5920.0 (0.5) | 8415.0 (0.7) | 8395.0 (0.7) | 7325.0 (0.6) | 11145.0 (1.0) | 11330.0 (1.0) | 9945.0 (0.9) | 3580.0 (0.3) | 2415.0 (0.2) | 1940.0 (0.2) | 4110.0 (0.4) | 3965.0 (0.3) | 3335.0 (0.3) | 63530.0 (5.4) | 64670.0 (5.5) | 43010.0 (3.7) | 24850.0 (2.1) | 24760.0 (2.1) | 22460.0 (1.9) | 720380.0 (61.8) | 715065.0 (61.3) | 604275.0 (51.8) | 2580.0 (0.2) | 2545.0 (0.2) | 2180.0 (0.2) | 2900.0 (0.2) | 2880.0 (0.2) | 2955.0 (0.3) | 2685.0 (0.2) | 2665.0 (0.2) | 2675.0 (0.2) | 3205.0 (0.3) | 3280.0 (0.3) | 2875.0 (0.2) | 734745.0 (63.0) | 1166440.0 | |
North West | 12035.0 (0.6) | 12725.0 (0.6) | 9770.0 (0.5) | 17060.0 (0.8) | 12795.0 (0.6) | 12915.0 (0.6) | 6625.0 (0.3) | 6575.0 (0.3) | 5100.0 (0.2) | 1065.0 (0.0) | 1095.0 (0.1) | 745.0 (0.0) | 9250.0 (0.4) | 9265.0 (0.4) | 7255.0 (0.3) | 22110.0 (1.0) | 21965.0 (1.0) | 17730.0 (0.8) | 15790.0 (0.7) | 16480.0 (0.8) | 12110.0 (0.6) | 3665.0 (0.2) | 2775.0 (0.1) | 1770.0 (0.1) | 5485.0 (0.3) | 5385.0 (0.3) | 4645.0 (0.2) | 85410.0 (4.0) | 98260.0 (4.6) | 42355.0 (2.0) | 20490.0 (1.0) | 20325.0 (1.0) | 15915.0 (0.7) | 1409500.0 (66.0) | 1382310.0 (64.8) | 1051830.0 (49.3) | 5075.0 (0.2) | 5025.0 (0.2) | 3475.0 (0.2) | 3850.0 (0.2) | 3795.0 (0.2) | 3505.0 (0.2) | 2915.0 (0.1) | 2885.0 (0.1) | 2895.0 (0.1) | 1445.0 (0.1) | 1460.0 (0.1) | 1305.0 (0.1) | 1183135.0 (55.4) | 2134525.0 | |
South East | 14735.0 (0.9) | 15425.0 (0.9) | 12225.0 (0.7) | 25480.0 (1.6) | 18950.0 (1.2) | 19360.0 (1.2) | 7250.0 (0.4) | 7195.0 (0.4) | 6220.0 (0.4) | 2510.0 (0.2) | 2645.0 (0.2) | 1975.0 (0.1) | 9800.0 (0.6) | 9690.0 (0.6) | 8350.0 (0.5) | 20980.0 (1.3) | 20855.0 (1.3) | 17275.0 (1.1) | 18340.0 (1.1) | 19850.0 (1.2) | 16310.0 (1.0) | 5630.0 (0.3) | 4455.0 (0.3) | 3340.0 (0.2) | 9545.0 (0.6) | 9355.0 (0.6) | 7525.0 (0.5) | 125500.0 (7.6) | 152960.0 (9.3) | 101070.0 (6.1) | 9080.0 (0.6) | 9025.0 (0.5) | 7640.0 (0.5) | 947040.0 (57.6) | 908205.0 (55.3) | 720010.0 (43.8) | 7360.0 (0.4) | 7235.0 (0.4) | 5870.0 (0.4) | 5565.0 (0.3) | 5510.0 (0.3) | 5125.0 (0.3) | 4545.0 (0.3) | 4495.0 (0.3) | 4560.0 (0.3) | 3185.0 (0.2) | 3190.0 (0.2) | 2880.0 (0.2) | 928370.0 (56.5) | 1643790.0 | |
South West | 13330.0 (0.4) | 14085.0 (0.4) | 11395.0 (0.3) | 27380.0 (0.8) | 19295.0 (0.6) | 20290.0 (0.6) | 4765.0 (0.1) | 4720.0 (0.1) | 3970.0 (0.1) | 3975.0 (0.1) | 4130.0 (0.1) | 3005.0 (0.1) | 14300.0 (0.4) | 14230.0 (0.4) | 12050.0 (0.4) | 31575.0 (0.9) | 31385.0 (0.9) | 27275.0 (0.8) | 23940.0 (0.7) | 25470.0 (0.7) | 20090.0 (0.6) | 6230.0 (0.2) | 5020.0 (0.1) | 3655.0 (0.1) | 11660.0 (0.3) | 11380.0 (0.3) | 9800.0 (0.3) | 199180.0 (5.9) | 245650.0 (7.2) | 144315.0 (4.2) | 4555.0 (0.1) | 4515.0 (0.1) | 3865.0 (0.1) | 2110845.0 (62.1) | 2045130.0 (60.2) | 1600355.0 (47.1) | 10375.0 (0.3) | 10180.0 (0.3) | 8180.0 (0.2) | 7770.0 (0.2) | 7645.0 (0.2) | 7300.0 (0.2) | 5385.0 (0.2) | 5335.0 (0.2) | 5155.0 (0.2) | 6020.0 (0.2) | 6000.0 (0.2) | 5520.0 (0.2) | 1868945.0 (55.0) | 3399525.0 | |
West Midlands | 25810.0 (2.6) | 29885.0 (3.0) | 24630.0 (2.4) | 19950.0 (2.0) | 15025.0 (1.5) | 13700.0 (1.4) | 14720.0 (1.5) | 14420.0 (1.4) | 12235.0 (1.2) | 21340.0 (2.1) | 21960.0 (2.2) | 16890.0 (1.7) | 10475.0 (1.0) | 10280.0 (1.0) | 9550.0 (0.9) | 62175.0 (6.2) | 61745.0 (6.1) | 50465.0 (5.0) | 22180.0 (2.2) | 22055.0 (2.2) | 18495.0 (1.8) | 16455.0 (1.6) | 10615.0 (1.0) | 7145.0 (0.7) | 8245.0 (0.8) | 7995.0 (0.8) | 6310.0 (0.6) | 72925.0 (7.2) | 68705.0 (6.8) | 44795.0 (4.4) | 67370.0 (6.7) | 66275.0 (6.6) | 58460.0 (5.8) | 443530.0 (43.9) | 439580.0 (43.5) | 330865.0 (32.7) | 6335.0 (0.6) | 6155.0 (0.6) | 4745.0 (0.5) | 5115.0 (0.5) | 5035.0 (0.5) | 4545.0 (0.4) | 3675.0 (0.4) | 3620.0 (0.4) | 3705.0 (0.4) | 10975.0 (1.1) | 10930.0 (1.1) | 9875.0 (1.0) | 605155.0 (59.9) | 1010960.0 | |
Yorkshire and The Humber | 39375.0 (1.1) | 40910.0 (1.2) | 33685.0 (0.9) | 42860.0 (1.2) | 32325.0 (0.9) | 35020.0 (1.0) | 14915.0 (0.4) | 14775.0 (0.4) | 13420.0 (0.4) | 8815.0 (0.2) | 8890.0 (0.3) | 7370.0 (0.2) | 14150.0 (0.4) | 14095.0 (0.4) | 12325.0 (0.3) | 52815.0 (1.5) | 52605.0 (1.5) | 49485.0 (1.4) | 34755.0 (1.0) | 36170.0 (1.0) | 28480.0 (0.8) | 12085.0 (0.3) | 9980.0 (0.3) | 7670.0 (0.2) | 11805.0 (0.3) | 11600.0 (0.3) | 9835.0 (0.3) | 205055.0 (5.8) | 224445.0 (6.3) | 156645.0 (4.4) | 183740.0 (5.2) | 182705.0 (5.1) | 174365.0 (4.9) | 2032585.0 (57.2) | 1994020.0 (56.1) | 1609085.0 (45.3) | 9465.0 (0.3) | 9305.0 (0.3) | 7765.0 (0.2) | 9230.0 (0.3) | 9135.0 (0.3) | 8465.0 (0.2) | 8640.0 (0.2) | 8510.0 (0.2) | 8705.0 (0.2) | 8570.0 (0.2) | 8545.0 (0.2) | 8080.0 (0.2) | 2148670.0 (60.5) | 3552510.0 | |
imd | 1 Most deprived | 178950.0 (2.8) | 194275.0 (3.0) | 158750.0 (2.5) | 159515.0 (2.5) | 120560.0 (1.9) | 126815.0 (2.0) | 64170.0 (1.0) | 63460.0 (1.0) | 55160.0 (0.9) | 54825.0 (0.8) | 55405.0 (0.9) | 43655.0 (0.7) | 40735.0 (0.6) | 40425.0 (0.6) | 35265.0 (0.5) | 177355.0 (2.7) | 176825.0 (2.7) | 151900.0 (2.4) | 126030.0 (2.0) | 130240.0 (2.0) | 103690.0 (1.6) | 64095.0 (1.0) | 44675.0 (0.7) | 32250.0 (0.5) | 43010.0 (0.7) | 42000.0 (0.7) | 35530.0 (0.6) | 667430.0 (10.3) | 705455.0 (10.9) | 514685.0 (8.0) | 297515.0 (4.6) | 294990.0 (4.6) | 270560.0 (4.2) | 2936095.0 (45.5) | 2860300.0 (44.3) | 2270930.0 (35.2) | 27245.0 (0.4) | 26710.0 (0.4) | 22245.0 (0.3) | 21385.0 (0.3) | 21105.0 (0.3) | 19765.0 (0.3) | 28745.0 (0.4) | 28460.0 (0.4) | 29055.0 (0.5) | 31855.0 (0.5) | 31905.0 (0.5) | 29390.0 (0.5) | 3850080.0 (59.7) | 6450350.0 |
2 | 112825.0 (1.7) | 120925.0 (1.9) | 98700.0 (1.5) | 129145.0 (2.0) | 97260.0 (1.5) | 101595.0 (1.6) | 38325.0 (0.6) | 37995.0 (0.6) | 32670.0 (0.5) | 36035.0 (0.6) | 36400.0 (0.6) | 28485.0 (0.4) | 66390.0 (1.0) | 66100.0 (1.0) | 59015.0 (0.9) | 272730.0 (4.2) | 273090.0 (4.2) | 235805.0 (3.6) | 134005.0 (2.1) | 138810.0 (2.1) | 117250.0 (1.8) | 42785.0 (0.7) | 32050.0 (0.5) | 23165.0 (0.4) | 40125.0 (0.6) | 39260.0 (0.6) | 34170.0 (0.5) | 664945.0 (10.3) | 703085.0 (10.9) | 518635.0 (8.0) | 138965.0 (2.1) | 137875.0 (2.1) | 123585.0 (1.9) | 3117795.0 (48.2) | 3039585.0 (47.0) | 2411960.0 (37.3) | 32340.0 (0.5) | 31725.0 (0.5) | 26770.0 (0.4) | 19950.0 (0.3) | 19725.0 (0.3) | 18815.0 (0.3) | 21045.0 (0.3) | 20810.0 (0.3) | 21185.0 (0.3) | 22475.0 (0.3) | 22470.0 (0.3) | 20980.0 (0.3) | 3826505.0 (59.2) | 6467650.0 | |
3 | 71870.0 (1.1) | 75280.0 (1.1) | 60905.0 (0.9) | 100985.0 (1.5) | 76700.0 (1.1) | 78915.0 (1.2) | 23025.0 (0.3) | 22815.0 (0.3) | 19540.0 (0.3) | 25685.0 (0.4) | 25920.0 (0.4) | 20055.0 (0.3) | 63075.0 (0.9) | 62885.0 (0.9) | 55795.0 (0.8) | 199020.0 (2.9) | 198975.0 (2.9) | 172880.0 (2.5) | 109070.0 (1.6) | 113105.0 (1.7) | 96325.0 (1.4) | 26950.0 (0.4) | 21920.0 (0.3) | 16375.0 (0.2) | 35825.0 (0.5) | 35070.0 (0.5) | 30220.0 (0.4) | 592470.0 (8.7) | 662085.0 (9.7) | 462635.0 (6.8) | 78385.0 (1.2) | 77750.0 (1.1) | 67900.0 (1.0) | 3705820.0 (54.4) | 3592435.0 (52.7) | 2845195.0 (41.8) | 35200.0 (0.5) | 34645.0 (0.5) | 28740.0 (0.4) | 20130.0 (0.3) | 19885.0 (0.3) | 18575.0 (0.3) | 16745.0 (0.2) | 16520.0 (0.2) | 16650.0 (0.2) | 18505.0 (0.3) | 18500.0 (0.3) | 17155.0 (0.3) | 3963295.0 (58.2) | 6811855.0 | |
4 | 45000.0 (0.7) | 46660.0 (0.7) | 37395.0 (0.6) | 79415.0 (1.3) | 59850.0 (1.0) | 61325.0 (1.0) | 10835.0 (0.2) | 10725.0 (0.2) | 9265.0 (0.1) | 14455.0 (0.2) | 14600.0 (0.2) | 11205.0 (0.2) | 54070.0 (0.9) | 53935.0 (0.9) | 47255.0 (0.8) | 119280.0 (1.9) | 118660.0 (1.9) | 100885.0 (1.6) | 71240.0 (1.1) | 75600.0 (1.2) | 63630.0 (1.0) | 17460.0 (0.3) | 14605.0 (0.2) | 10800.0 (0.2) | 29540.0 (0.5) | 28970.0 (0.5) | 25145.0 (0.4) | 478570.0 (7.6) | 541335.0 (8.6) | 363600.0 (5.8) | 40230.0 (0.6) | 39795.0 (0.6) | 34895.0 (0.6) | 3611195.0 (57.6) | 3505565.0 (55.9) | 2785270.0 (44.4) | 32145.0 (0.5) | 31555.0 (0.5) | 26065.0 (0.4) | 18265.0 (0.3) | 18040.0 (0.3) | 17045.0 (0.3) | 12460.0 (0.2) | 12290.0 (0.2) | 12490.0 (0.2) | 13180.0 (0.2) | 13175.0 (0.2) | 12245.0 (0.2) | 3578945.0 (57.1) | 6270250.0 | |
5 Least deprived | 28210.0 (0.5) | 29260.0 (0.5) | 23110.0 (0.4) | 54475.0 (1.0) | 39140.0 (0.7) | 39410.0 (0.7) | 6305.0 (0.1) | 6245.0 (0.1) | 5295.0 (0.1) | 8595.0 (0.2) | 8720.0 (0.2) | 6465.0 (0.1) | 44660.0 (0.8) | 44520.0 (0.8) | 37860.0 (0.7) | 92560.0 (1.6) | 91865.0 (1.6) | 76755.0 (1.4) | 49450.0 (0.9) | 52935.0 (0.9) | 43780.0 (0.8) | 11575.0 (0.2) | 9730.0 (0.2) | 6970.0 (0.1) | 23310.0 (0.4) | 22855.0 (0.4) | 19230.0 (0.3) | 318700.0 (5.6) | 400120.0 (7.1) | 237065.0 (4.2) | 24260.0 (0.4) | 24000.0 (0.4) | 20780.0 (0.4) | 3404930.0 (60.2) | 3288410.0 (58.1) | 2595155.0 (45.9) | 25460.0 (0.5) | 25080.0 (0.4) | 20455.0 (0.4) | 16580.0 (0.3) | 16395.0 (0.3) | 15355.0 (0.3) | 9035.0 (0.2) | 8920.0 (0.2) | 8875.0 (0.2) | 9765.0 (0.2) | 9755.0 (0.2) | 8955.0 (0.2) | 3134720.0 (55.4) | 5656380.0 | |
Unknown | 26125.0 (2.3) | 28665.0 (2.5) | 21895.0 (1.9) | 23840.0 (2.1) | 18095.0 (1.6) | 18460.0 (1.6) | 5260.0 (0.5) | 5230.0 (0.5) | 4335.0 (0.4) | 3795.0 (0.3) | 3885.0 (0.3) | 2975.0 (0.3) | 17150.0 (1.5) | 17180.0 (1.5) | 14915.0 (1.3) | 42540.0 (3.7) | 42455.0 (3.7) | 34805.0 (3.0) | 21060.0 (1.8) | 22220.0 (1.9) | 17055.0 (1.5) | 8450.0 (0.7) | 5530.0 (0.5) | 3830.0 (0.3) | 6840.0 (0.6) | 6725.0 (0.6) | 5680.0 (0.5) | 84470.0 (7.3) | 91205.0 (7.9) | 65880.0 (5.7) | 17925.0 (1.6) | 17840.0 (1.5) | 15615.0 (1.4) | 493885.0 (42.9) | 482390.0 (41.9) | 374875.0 (32.6) | 4075.0 (0.4) | 4000.0 (0.3) | 3365.0 (0.3) | 4040.0 (0.4) | 4015.0 (0.3) | 3710.0 (0.3) | 4685.0 (0.4) | 4640.0 (0.4) | 4595.0 (0.4) | 3775.0 (0.3) | 3780.0 (0.3) | 3320.0 (0.3) | 589475.0 (51.2) | 1151025.0 | |
dementia | False | 462675.0 (1.4) | 494750.0 (1.5) | 400495.0 (1.2) | 546795.0 (1.7) | 411190.0 (1.3) | 426080.0 (1.3) | 147670.0 (0.5) | 146220.0 (0.4) | 126035.0 (0.4) | 142150.0 (0.4) | 143695.0 (0.4) | 111835.0 (0.3) | 285950.0 (0.9) | 284910.0 (0.9) | 249995.0 (0.8) | 901885.0 (2.8) | 900270.0 (2.8) | 771620.0 (2.4) | 510370.0 (1.6) | 532440.0 (1.6) | 441320.0 (1.4) | 171095.0 (0.5) | 128325.0 (0.4) | 93265.0 (0.3) | 178550.0 (0.5) | 174775.0 (0.5) | 149880.0 (0.5) | 2800205.0 (8.6) | 3094215.0 (9.5) | 2159400.0 (6.6) | 596320.0 (1.8) | 591295.0 (1.8) | 532465.0 (1.6) | 17142895.0 (52.6) | 16646585.0 (51.0) | 13185870.0 (40.4) | 154830.0 (0.5) | 152115.0 (0.5) | 126290.0 (0.4) | 100280.0 (0.3) | 99095.0 (0.3) | 93185.0 (0.3) | 92660.0 (0.3) | 91580.0 (0.3) | 92800.0 (0.3) | 99355.0 (0.3) | 99390.0 (0.3) | 91835.0 (0.3) | 18837280.0 (57.8) | 32614480.0 |
True | 300.0 (0.2) | 315.0 (0.2) | 260.0 (0.1) | 580.0 (0.3) | 415.0 (0.2) | 435.0 (0.2) | 250.0 (0.1) | 250.0 (0.1) | 225.0 (0.1) | 1245.0 (0.6) | 1230.0 (0.6) | 1010.0 (0.5) | 135.0 (0.1) | 130.0 (0.1) | 110.0 (0.1) | 1595.0 (0.8) | 1600.0 (0.8) | 1410.0 (0.7) | 480.0 (0.2) | 465.0 (0.2) | 410.0 (0.2) | 225.0 (0.1) | 185.0 (0.1) | 125.0 (0.1) | 105.0 (0.1) | 100.0 (0.1) | 95.0 (0.0) | 6380.0 (3.3) | 9070.0 (4.7) | 3105.0 (1.6) | 960.0 (0.5) | 955.0 (0.5) | 865.0 (0.4) | 126825.0 (65.7) | 122100.0 (63.3) | 97510.0 (50.5) | 1640.0 (0.8) | 1600.0 (0.8) | 1350.0 (0.7) | 70.0 (0.0) | 70.0 (0.0) | 70.0 (0.0) | 55.0 (0.0) | 55.0 (0.0) | 60.0 (0.0) | 200.0 (0.1) | 200.0 (0.1) | 205.0 (0.1) | 105740.0 (54.8) | 193025.0 | |
diabetes | False | 420630.0 (1.4) | 449440.0 (1.5) | 361485.0 (1.2) | 507710.0 (1.7) | 382770.0 (1.3) | 396320.0 (1.3) | 121650.0 (0.4) | 120495.0 (0.4) | 103470.0 (0.3) | 112965.0 (0.4) | 114295.0 (0.4) | 87855.0 (0.3) | 275300.0 (0.9) | 274330.0 (0.9) | 241000.0 (0.8) | 761615.0 (2.6) | 759800.0 (2.6) | 647125.0 (2.2) | 449680.0 (1.5) | 470830.0 (1.6) | 388520.0 (1.3) | 154360.0 (0.5) | 116155.0 (0.4) | 84615.0 (0.3) | 168980.0 (0.6) | 165425.0 (0.6) | 141495.0 (0.5) | 2649005.0 (9.0) | 2908735.0 (9.8) | 2061510.0 (7.0) | 502650.0 (1.7) | 498460.0 (1.7) | 446835.0 (1.5) | 15334110.0 (51.8) | 14894335.0 (50.4) | 11770570.0 (39.8) | 138450.0 (0.5) | 135990.0 (0.5) | 112760.0 (0.4) | 94760.0 (0.3) | 93655.0 (0.3) | 87880.0 (0.3) | 86630.0 (0.3) | 85615.0 (0.3) | 86415.0 (0.3) | 92000.0 (0.3) | 92065.0 (0.3) | 84375.0 (0.3) | 16910840.0 (57.2) | 29576355.0 |
True | 42345.0 (1.3) | 45625.0 (1.4) | 39270.0 (1.2) | 39665.0 (1.2) | 28830.0 (0.9) | 30200.0 (0.9) | 26270.0 (0.8) | 25975.0 (0.8) | 22795.0 (0.7) | 30430.0 (0.9) | 30630.0 (0.9) | 24995.0 (0.8) | 10785.0 (0.3) | 10715.0 (0.3) | 9105.0 (0.3) | 141865.0 (4.4) | 142070.0 (4.4) | 125905.0 (3.9) | 61175.0 (1.9) | 62075.0 (1.9) | 53210.0 (1.6) | 16960.0 (0.5) | 12355.0 (0.4) | 8775.0 (0.3) | 9680.0 (0.3) | 9455.0 (0.3) | 8480.0 (0.3) | 157580.0 (4.9) | 194550.0 (6.0) | 100995.0 (3.1) | 94635.0 (2.9) | 93790.0 (2.9) | 86490.0 (2.7) | 1935610.0 (59.9) | 1874350.0 (58.0) | 1512815.0 (46.8) | 18020.0 (0.6) | 17720.0 (0.5) | 14880.0 (0.5) | 5590.0 (0.2) | 5510.0 (0.2) | 5375.0 (0.2) | 6090.0 (0.2) | 6020.0 (0.2) | 6440.0 (0.2) | 7555.0 (0.2) | 7520.0 (0.2) | 7665.0 (0.2) | 2032175.0 (62.9) | 3231150.0 | |
hypertension | False | 445355.0 (1.4) | 476270.0 (1.5) | 385260.0 (1.2) | 534665.0 (1.7) | 402675.0 (1.3) | 417185.0 (1.4) | 142500.0 (0.5) | 141115.0 (0.5) | 121590.0 (0.4) | 132085.0 (0.4) | 133470.0 (0.4) | 103670.0 (0.3) | 281905.0 (0.9) | 280885.0 (0.9) | 246645.0 (0.8) | 869820.0 (2.8) | 868175.0 (2.8) | 743460.0 (2.4) | 495320.0 (1.6) | 516740.0 (1.7) | 428415.0 (1.4) | 163950.0 (0.5) | 122940.0 (0.4) | 89365.0 (0.3) | 175230.0 (0.6) | 171530.0 (0.6) | 147025.0 (0.5) | 2713640.0 (8.8) | 2996170.0 (9.7) | 2107680.0 (6.8) | 575395.0 (1.9) | 570555.0 (1.8) | 513240.0 (1.7) | 15917310.0 (51.5) | 15444680.0 (50.0) | 12218460.0 (39.6) | 146435.0 (0.5) | 143815.0 (0.5) | 119835.0 (0.4) | 98525.0 (0.3) | 97355.0 (0.3) | 91510.0 (0.3) | 89940.0 (0.3) | 88890.0 (0.3) | 89805.0 (0.3) | 96500.0 (0.3) | 96550.0 (0.3) | 88925.0 (0.3) | 17707690.0 (57.3) | 30881665.0 |
True | 17620.0 (0.9) | 18795.0 (1.0) | 15500.0 (0.8) | 12710.0 (0.7) | 8930.0 (0.5) | 9335.0 (0.5) | 5420.0 (0.3) | 5355.0 (0.3) | 4675.0 (0.2) | 11310.0 (0.6) | 11455.0 (0.6) | 9175.0 (0.5) | 4175.0 (0.2) | 4160.0 (0.2) | 3460.0 (0.2) | 33660.0 (1.7) | 33700.0 (1.7) | 29570.0 (1.5) | 15535.0 (0.8) | 16170.0 (0.8) | 13315.0 (0.7) | 7370.0 (0.4) | 5570.0 (0.3) | 4025.0 (0.2) | 3430.0 (0.2) | 3345.0 (0.2) | 2950.0 (0.2) | 92940.0 (4.8) | 107115.0 (5.6) | 54825.0 (2.8) | 21890.0 (1.1) | 21700.0 (1.1) | 20090.0 (1.0) | 1352410.0 (70.2) | 1324005.0 (68.7) | 1064920.0 (55.3) | 10035.0 (0.5) | 9895.0 (0.5) | 7810.0 (0.4) | 1825.0 (0.1) | 1810.0 (0.1) | 1745.0 (0.1) | 2775.0 (0.1) | 2750.0 (0.1) | 3055.0 (0.2) | 3055.0 (0.2) | 3035.0 (0.2) | 3115.0 (0.2) | 1235325.0 (64.1) | 1925840.0 | |
learning_disability | False | 461705.0 (1.4) | 493665.0 (1.5) | 399580.0 (1.2) | 546115.0 (1.7) | 410690.0 (1.3) | 425565.0 (1.3) | 147150.0 (0.5) | 145710.0 (0.4) | 125590.0 (0.4) | 142420.0 (0.4) | 143950.0 (0.4) | 112010.0 (0.3) | 285850.0 (0.9) | 284815.0 (0.9) | 249905.0 (0.8) | 900995.0 (2.8) | 899420.0 (2.8) | 770760.0 (2.4) | 509330.0 (1.6) | 531380.0 (1.6) | 440555.0 (1.4) | 170340.0 (0.5) | 127715.0 (0.4) | 92860.0 (0.3) | 177855.0 (0.5) | 174100.0 (0.5) | 149295.0 (0.5) | 2800495.0 (8.6) | 3095245.0 (9.5) | 2159160.0 (6.6) | 592820.0 (1.8) | 587845.0 (1.8) | 529180.0 (1.6) | 17149840.0 (52.6) | 16653065.0 (51.0) | 13185210.0 (40.4) | 155955.0 (0.5) | 153210.0 (0.5) | 127220.0 (0.4) | 99955.0 (0.3) | 98780.0 (0.3) | 92895.0 (0.3) | 92385.0 (0.3) | 91310.0 (0.3) | 92535.0 (0.3) | 98850.0 (0.3) | 98885.0 (0.3) | 91370.0 (0.3) | 18829235.0 (57.7) | 32632255.0 |
True | 1275.0 (0.7) | 1400.0 (0.8) | 1180.0 (0.7) | 1260.0 (0.7) | 910.0 (0.5) | 950.0 (0.5) | 770.0 (0.4) | 760.0 (0.4) | 675.0 (0.4) | 970.0 (0.6) | 980.0 (0.6) | 840.0 (0.5) | 230.0 (0.1) | 230.0 (0.1) | 195.0 (0.1) | 2485.0 (1.4) | 2450.0 (1.4) | 2270.0 (1.3) | 1520.0 (0.9) | 1525.0 (0.9) | 1175.0 (0.7) | 980.0 (0.6) | 795.0 (0.5) | 530.0 (0.3) | 805.0 (0.5) | 780.0 (0.4) | 680.0 (0.4) | 6090.0 (3.5) | 8040.0 (4.6) | 3345.0 (1.9) | 4465.0 (2.5) | 4405.0 (2.5) | 4150.0 (2.4) | 119880.0 (68.4) | 115620.0 (66.0) | 98170.0 (56.0) | 515.0 (0.3) | 505.0 (0.3) | 420.0 (0.2) | 395.0 (0.2) | 385.0 (0.2) | 360.0 (0.2) | 335.0 (0.2) | 330.0 (0.2) | 320.0 (0.2) | 705.0 (0.4) | 705.0 (0.4) | 670.0 (0.4) | 113780.0 (64.9) | 175250.0 |
Idea: Use an upset plot
matching (n=24093590.0) | not_matching (n=1396310.0) | |
---|---|---|
ethnicity_16 | ||
African | 453220.0 | 55365.0 |
Any_other_ethnic_group | 504845.0 | 147830.0 |
Bangladeshi | 146340.0 | 8590.0 |
Caribbean | 137775.0 | 25465.0 |
Chinese | 284485.0 | 9055.0 |
Indian | 894075.0 | 47405.0 |
Other_Asian | 477225.0 | 112910.0 |
Other_Black | 152000.0 | 62760.0 |
Other_Mixed | 162955.0 | 58010.0 |
Other_White | 2684930.0 | 360110.0 |
Pakistani | 591150.0 | 30340.0 |
White_British | 17194385.0 | 349440.0 |
White_Irish | 143990.0 | 34000.0 |
White_and_Asian | 91930.0 | 31020.0 |
White_and_Black_African | 83350.0 | 32555.0 |
White_and_Black_Caribbean | 90935.0 | 31455.0 |
African (n=522990.0) | Any_other_ethnic_group (n=635060.0) | Bangladeshi (n=156620.0) | Caribbean (n=167705.0) | Chinese (n=300100.0) | Indian (n=956460.0) | Other_Asian (n=572265.0) | Other_Black (n=198670.0) | Other_Mixed (n=219305.0) | Other_White (n=3023260.0) | Pakistani (n=626285.0) | White_British (n=17603600.0) | White_Irish (n=169155.0) | White_and_Asian (n=117285.0) | White_and_Black_African (n=108845.0) | White_and_Black_Caribbean (n=112295.0) | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ethnicity_16 | ||||||||||||||||
African | 453220 | 6465 | 70 | 2790 | 55 | 895 | 1645 | 19800 | 2410 | 3215 | 335 | 5880 | 190 | 160 | 10690 | 765.0 |
Any_other_ethnic_group | 6550 | 504845 | 805 | 1210 | 3080 | 6105 | 29165 | 3250 | 9120 | 56040 | 3205 | 22255 | 395 | 3775 | 1845 | 1030.0 |
Bangladeshi | 75 | 735 | 146340 | 15 | 40 | 1140 | 2490 | 90 | 195 | 270 | 1960 | 1325 | 10 | 235 | 10 | - |
Caribbean | 2650 | 960 | 15 | 137775 | 30 | 255 | 265 | 7415 | 1345 | 715 | 30 | 6405 | 20 | 30 | 455 | 4875.0 |
Chinese | 40 | 2055 | 20 | 20 | 284485 | 65 | 3125 | 50 | 875 | 585 | 30 | 1695 | 15 | 455 | 15 | 10.0 |
Indian | 780 | 4390 | 1215 | 240 | 125 | 894075 | 22430 | 550 | 1510 | 1345 | 5610 | 6820 | 90 | 2120 | 110 | 70.0 |
Other_Asian | 1785 | 28910 | 3750 | 400 | 6050 | 33335 | 477225 | 1435 | 4500 | 5770 | 14905 | 6535 | 60 | 5075 | 280 | 120.0 |
Other_Black | 29135 | 3545 | 105 | 9455 | 90 | 595 | 1300 | 152000 | 2445 | 1845 | 270 | 8060 | 90 | 130 | 3400 | 2295.0 |
Other_Mixed | 2100 | 8750 | 255 | 1145 | 2085 | 1570 | 4735 | 1750 | 162955 | 12725 | 870 | 14095 | 190 | 2935 | 1920 | 2885.0 |
Other_White | 3160 | 45575 | 525 | 710 | 840 | 2165 | 5630 | 1520 | 11395 | 2684930 | 1315 | 277275 | 3700 | 3110 | 1905 | 1285.0 |
Pakistani | 280 | 2660 | 1720 | 45 | 155 | 5745 | 12040 | 380 | 930 | 890 | 591150 | 4255 | 35 | 1120 | 55 | 30.0 |
White_British | 6540 | 18945 | 1450 | 5720 | 2120 | 7340 | 5985 | 4795 | 11715 | 243250 | 4895 | 17194385 | 20225 | 5920 | 3640 | 6900.0 |
White_Irish | 140 | 345 | 10 | 30 | 15 | 80 | 60 | 75 | 125 | 4210 | 35 | 28740 | 143990 | 50 | 55 | 30.0 |
White_and_Asian | 185 | 3940 | 310 | 45 | 900 | 2860 | 5695 | 170 | 3010 | 3305 | 1590 | 8745 | 50 | 91930 | 150 | 65.0 |
White_and_Black_African | 15200 | 1900 | 20 | 715 | 10 | 150 | 335 | 3015 | 2475 | 2490 | 60 | 4980 | 60 | 145 | 83350 | 1000.0 |
White_and_Black_Caribbean | 1150 | 1040 | 10 | 7390 | 20 | 85 | 140 | 2375 | 4300 | 1675 | 25 | 12150 | 35 | 95 | 965 | 90935.0 |
matching (n=23753730.0) | not_matching (n=1452240.0) | |
---|---|---|
ethnicity_new_16 | ||
African | 486800.0 | 50760.0 |
Any_other_ethnic_group | 380790.0 | 107335.0 |
Bangladeshi | 144965.0 | 8280.0 |
Caribbean | 139385.0 | 25880.0 |
Chinese | 283195.0 | 10650.0 |
Indian | 892985.0 | 44080.0 |
Other_Asian | 503520.0 | 104510.0 |
Other_Black | 114425.0 | 48030.0 |
Other_Mixed | 159575.0 | 57570.0 |
Other_White | 2985505.0 | 352220.0 |
Pakistani | 586420.0 | 29110.0 |
White_British | 16668420.0 | 487235.0 |
White_Irish | 142135.0 | 33710.0 |
White_and_Asian | 91245.0 | 30045.0 |
White_and_Black_African | 82650.0 | 31780.0 |
White_and_Black_Caribbean | 91715.0 | 31045.0 |
African (n=546945.0) | Any_other_ethnic_group (n=477530.0) | Bangladeshi (n=154795.0) | Caribbean (n=168365.0) | Chinese (n=297270.0) | Indian (n=950015.0) | Other_Asian (n=591270.0) | Other_Black (n=154335.0) | Other_Mixed (n=211480.0) | Other_White (n=3465125.0) | Pakistani (n=619600.0) | White_British (n=17065430.0) | White_Irish (n=167355.0) | White_and_Asian (n=115700.0) | White_and_Black_African (n=107450.0) | White_and_Black_Caribbean (n=113305.0) | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ethnicity_new_16 | ||||||||||||||||
African | 486800 | 5550 | 70 | 3095 | 45 | 925 | 1770 | 15020 | 2285 | 3345 | 375 | 5960 | 185 | 165 | 11085 | 885.0 |
Any_other_ethnic_group | 5480 | 380790 | 430 | 885 | 1480 | 2195 | 20830 | 2335 | 6695 | 45290 | 1470 | 15330 | 255 | 2585 | 1420 | 655.0 |
Bangladeshi | 80 | 480 | 144965 | 15 | 35 | 1130 | 2485 | 80 | 185 | 285 | 1945 | 1305 | 10 | 235 | 10 | - |
Caribbean | 3070 | 730 | 15 | 139385 | 25 | 270 | 275 | 7415 | 1215 | 765 | 30 | 6525 | 25 | 30 | 500 | 4990.0 |
Chinese | 45 | 1340 | 25 | 25 | 283195 | 80 | 4480 | 85 | 1130 | 745 | 35 | 2000 | 15 | 615 | 15 | 15.0 |
Indian | 800 | 2305 | 1205 | 240 | 105 | 892985 | 21255 | 505 | 1465 | 1435 | 5685 | 6690 | 90 | 2115 | 110 | 75.0 |
Other_Asian | 1865 | 20950 | 3735 | 410 | 6385 | 31885 | 503520 | 1365 | 4685 | 6355 | 14700 | 6435 | 65 | 5250 | 285 | 140.0 |
Other_Black | 19105 | 2415 | 95 | 8395 | 80 | 545 | 1155 | 114425 | 2010 | 1775 | 210 | 7455 | 75 | 125 | 2540 | 2050.0 |
Other_Mixed | 2375 | 6840 | 250 | 1230 | 2055 | 1595 | 5045 | 1855 | 159575 | 13465 | 880 | 13610 | 180 | 2950 | 2060 | 3180.0 |
Other_White | 3185 | 37410 | 500 | 630 | 870 | 2070 | 5940 | 1370 | 11470 | 2985505 | 1160 | 276640 | 4510 | 3165 | 2015 | 1285.0 |
Pakistani | 305 | 1640 | 1710 | 45 | 120 | 5800 | 11920 | 345 | 885 | 860 | 586420 | 4245 | 35 | 1115 | 55 | 30.0 |
White_British | 6690 | 11750 | 1450 | 5785 | 1950 | 7350 | 6075 | 4570 | 10650 | 389885 | 4985 | 16668420 | 19635 | 5815 | 3520 | 7125.0 |
White_Irish | 145 | 235 | 10 | 30 | 15 | 80 | 60 | 55 | 110 | 7425 | 30 | 25390 | 142135 | 50 | 50 | 25.0 |
White_and_Asian | 190 | 2885 | 305 | 45 | 880 | 2860 | 5970 | 155 | 2965 | 3610 | 1580 | 8330 | 50 | 91245 | 150 | 70.0 |
White_and_Black_African | 15605 | 1470 | 20 | 725 | 5 | 150 | 335 | 2410 | 2280 | 2625 | 60 | 4830 | 55 | 145 | 82650 | 1065.0 |
White_and_Black_Caribbean | 1205 | 740 | 10 | 7425 | 25 | 95 | 155 | 2345 | 3875 | 1755 | 35 | 12265 | 35 | 95 | 985 | 91715.0 |
matching (n=18998375.0) | not_matching (n=706220.0) | |
---|---|---|
ethnicity_primis_16 | ||
African | 395210.0 | 35335.0 |
Any_other_ethnic_group | 404685.0 | 82725.0 |
Bangladeshi | 125270.0 | 6180.0 |
Caribbean | 109445.0 | 16915.0 |
Chinese | 248915.0 | 8060.0 |
Indian | 766740.0 | 32995.0 |
Other_Asian | 427010.0 | 59625.0 |
Other_Black | 87025.0 | 25055.0 |
Other_Mixed | 140385.0 | 39620.0 |
Other_White | 2132065.0 | 127605.0 |
Pakistani | 529710.0 | 20635.0 |
White_British | 13248420.0 | 164175.0 |
White_Irish | 121475.0 | 19385.0 |
White_and_Asian | 88000.0 | 22540.0 |
White_and_Black_African | 86995.0 | 23865.0 |
White_and_Black_Caribbean | 87025.0 | 21505.0 |
African (n=432790.0) | Any_other_ethnic_group (n=480705.0) | Bangladeshi (n=131935.0) | Caribbean (n=125960.0) | Chinese (n=258390.0) | Indian (n=799970.0) | Other_Asian (n=491200.0) | Other_Black (n=111205.0) | Other_Mixed (n=176145.0) | Other_White (n=2281215.0) | Pakistani (n=550970.0) | White_British (n=13409380.0) | White_Irish (n=137635.0) | White_and_Asian (n=106305.0) | White_and_Black_African (n=107045.0) | White_and_Black_Caribbean (n=103745.0) | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ethnicity_primis_16 | ||||||||||||||||
African | 395210 | 4385 | 45 | 1530 | 20.0 | 660 | 1300 | 8815 | 1420 | 2100 | 285 | 4575 | 120.0 | 115 | 9270 | 695.0 |
Any_other_ethnic_group | 4365 | 404685 | 350 | 640 | 1135.0 | 1660 | 17235 | 1720 | 5755 | 33255 | 1305 | 10795 | 225.0 | 2280 | 1420 | 585.0 |
Bangladeshi | 45 | 390 | 125270 | 10 | 10.0 | 820 | 1620 | 40 | 160 | 215 | 1520 | 1145 | - | 195 | 10 | - |
Caribbean | 1465 | 580 | 10 | 109445 | 15.0 | 120 | 215 | 4095 | 700 | 360 | 25 | 4780 | 15.0 | 15 | 345 | 4175.0 |
Chinese | 30 | 990 | 20 | 20 | 248915.0 | 50 | 3285 | 40 | 1000 | 525 | 25 | 1555 | 15.0 | 485 | 15 | 5.0 |
Indian | 680 | 1685 | 840 | 130 | 45.0 | 766740 | 15760 | 195 | 1020 | 865 | 4035 | 5745 | 75.0 | 1755 | 110 | 55.0 |
Other_Asian | 1180 | 14410 | 1940 | 260 | 3725.0 | 15145 | 427010 | 685 | 3160 | 3980 | 6900 | 4545 | 40.0 | 3340 | 220 | 95.0 |
Other_Black | 8675 | 1465 | 40 | 3855 | 60.0 | 140 | 595 | 87025 | 965 | 935 | 95 | 5185 | 45.0 | 75 | 1590 | 1335.0 |
Other_Mixed | 1380 | 5385 | 195 | 695 | 1815.0 | 1095 | 3745 | 1030 | 140385 | 8505 | 670 | 9430 | 110.0 | 2195 | 1375 | 1995.0 |
Other_White | 1910 | 30355 | 325 | 325 | 495.0 | 1125 | 4020 | 830 | 8160 | 2132065 | 725 | 72795 | 2140.0 | 2080 | 1490 | 830.0 |
Pakistani | 220 | 1385 | 1310 | 20 | 25.0 | 4170 | 7145 | 80 | 705 | 640 | 529710 | 3920 | 40.0 | 905 | 45 | 25.0 |
White_British | 5155 | 10400 | 1305 | 3895 | 1415.0 | 5840 | 4605 | 3175 | 7070 | 90075 | 4300 | 13248420 | 13215.0 | 4635 | 3100 | 5990.0 |
White_Irish | 115 | 200 | 10 | 25 | 10.0 | 65 | 45 | 35 | 70 | 2415 | 25 | 16275 | 121475.0 | 35 | 40 | 20.0 |
White_and_Asian | 140 | 2380 | 250 | 25 | 695.0 | 2190 | 4245 | 105 | 2055 | 2320 | 1295 | 6620 | 45.0 | 88000 | 125 | 50.0 |
White_and_Black_African | 11435 | 1405 | 20 | 400 | - | 85 | 265 | 1860 | 1445 | 1905 | 40 | 3970 | 50.0 | 120 | 86995 | 865.0 |
White_and_Black_Caribbean | 785 | 605 | 5 | 4685 | 10.0 | 65 | 110 | 1475 | 2075 | 1055 | 15 | 9625 | 25.0 | 75 | 895 | 87025.0 |
African | Any_other_ethnic_group | Bangladeshi | Caribbean | Chinese | Indian | Other_Asian | Other_Black | Other_Mixed | Other_White | Pakistani | White_British | White_Irish | White_and_Asian | White_and_Black_African | White_and_Black_Caribbean | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ethnicity_16 | ||||||||||||||||
African (n = 462975) | 462975.0 | 10780.0 | 105.0 | 4685.0 | 85.0 | 1200.0 | 2780.0 | 36610.0 | 3890.0 | 4945.0 | 535.0 | 9845.0 | 265.0 | 295.0 | 21205.0 | 1600.0 |
Any_other_ethnic_group (n = 547375) | 8660.0 | 547375.0 | 935.0 | 1500.0 | 3560.0 | 6960.0 | 39425.0 | 4890.0 | 13635.0 | 66220.0 | 3830.0 | 27470.0 | 510.0 | 5795.0 | 2605.0 | 1350.0 |
Bangladeshi (n = 147920) | 110.0 | 1480.0 | 147920.0 | 30.0 | 45.0 | 2140.0 | 5475.0 | 180.0 | 395.0 | 685.0 | 3455.0 | 2315.0 | 20.0 | 455.0 | 25.0 | 10.0 |
Caribbean (n = 143395) | 4125.0 | 1670.0 | 30.0 | 143395.0 | 35.0 | 435.0 | 485.0 | 12795.0 | 2010.0 | 1235.0 | 55.0 | 10230.0 | 45.0 | 55.0 | 830.0 | 9390.0 |
Chinese (n = 286085) | 50.0 | 4685.0 | 40.0 | 50.0 | 286085.0 | 100.0 | 6915.0 | 135.0 | 2355.0 | 1320.0 | 45.0 | 3705.0 | 25.0 | 1135.0 | 30.0 | 15.0 |
Indian (n = 903480) | 1820.0 | 9710.0 | 1815.0 | 425.0 | 210.0 | 903480.0 | 46860.0 | 1315.0 | 3010.0 | 2770.0 | 9140.0 | 13925.0 | 170.0 | 4560.0 | 250.0 | 115.0 |
Other_Asian (n = 510855) | 2585.0 | 44400.0 | 4420.0 | 565.0 | 7110.0 | 41860.0 | 510855.0 | 2465.0 | 8195.0 | 8870.0 | 17940.0 | 10090.0 | 125.0 | 8535.0 | 450.0 | 200.0 |
Other_Black (n = 171320) | 34825.0 | 4870.0 | 120.0 | 11955.0 | 110.0 | 725.0 | 1720.0 | 171320.0 | 3185.0 | 2530.0 | 335.0 | 10530.0 | 125.0 | 200.0 | 5065.0 | 3395.0 |
Other_Mixed (n = 178655) | 2860.0 | 11895.0 | 295.0 | 1635.0 | 2230.0 | 1930.0 | 5975.0 | 2820.0 | 178655.0 | 15375.0 | 1050.0 | 18265.0 | 245.0 | 3925.0 | 2800.0 | 4050.0 |
Other_White (n = 2806585) | 4385.0 | 83270.0 | 620.0 | 915.0 | 1070.0 | 2660.0 | 8120.0 | 2495.0 | 20795.0 | 2806585.0 | 1600.0 | 356300.0 | 5620.0 | 4840.0 | 2890.0 | 1875.0 |
Pakistani (n = 597280) | 455.0 | 5950.0 | 2625.0 | 80.0 | 205.0 | 10175.0 | 26215.0 | 665.0 | 1825.0 | 1990.0 | 597280.0 | 8900.0 | 80.0 | 2465.0 | 105.0 | 45.0 |
White_British (n = 17269720) | 8830.0 | 36980.0 | 2180.0 | 8490.0 | 2865.0 | 9475.0 | 8505.0 | 7940.0 | 19500.0 | 509375.0 | 6000.0 | 17269720.0 | 40795.0 | 10020.0 | 6205.0 | 11055.0 |
White_Irish (n = 156470) | 170.0 | 590.0 | 15.0 | 50.0 | 20.0 | 110.0 | 90.0 | 95.0 | 210.0 | 7045.0 | 50.0 | 38360.0 | 156470.0 | 80.0 | 80.0 | 40.0 |
White_and_Asian (n = 100350) | 245.0 | 5135.0 | 355.0 | 65.0 | 1035.0 | 3300.0 | 7150.0 | 250.0 | 4315.0 | 4345.0 | 1910.0 | 11235.0 | 90.0 | 100350.0 | 195.0 | 100.0 |
White_and_Black_African (n = 92720) | 17530.0 | 2600.0 | 20.0 | 955.0 | 10.0 | 175.0 | 460.0 | 4330.0 | 3400.0 | 3195.0 | 75.0 | 6420.0 | 80.0 | 195.0 | 92720.0 | 1460.0 |
White_and_Black_Caribbean (n = 99555) | 1420.0 | 1640.0 | 10.0 | 9660.0 | 30.0 | 125.0 | 190.0 | 3445.0 | 6225.0 | 2400.0 | 35.0 | 16330.0 | 60.0 | 140.0 | 1535.0 | 99555.0 |
African | Any_other_ethnic_group | Bangladeshi | Caribbean | Chinese | Indian | Other_Asian | Other_Black | Other_Mixed | Other_White | Pakistani | White_British | White_Irish | White_and_Asian | White_and_Black_African | White_and_Black_Caribbean | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ethnicity_new_16 | ||||||||||||||||
African (n = 495065) | 495065.0 | 9370.0 | 115.0 | 5180.0 | 95.0 | 1260.0 | 3020.0 | 28635.0 | 4050.0 | 5125.0 | 610.0 | 10115.0 | 280.0 | 310.0 | 22350.0 | 1810.0 |
Any_other_ethnic_group (n = 411605) | 7060.0 | 411605.0 | 500.0 | 1075.0 | 1720.0 | 2595.0 | 27320.0 | 3435.0 | 9835.0 | 51980.0 | 1835.0 | 17845.0 | 330.0 | 3910.0 | 1945.0 | 865.0 |
Bangladeshi (n = 146470) | 120.0 | 870.0 | 146470.0 | 30.0 | 45.0 | 2120.0 | 5445.0 | 155.0 | 390.0 | 625.0 | 3425.0 | 2355.0 | 20.0 | 450.0 | 25.0 | 10.0 |
Caribbean (n = 144930) | 4630.0 | 1270.0 | 30.0 | 144930.0 | 35.0 | 445.0 | 500.0 | 12760.0 | 1995.0 | 1335.0 | 55.0 | 10330.0 | 45.0 | 55.0 | 895.0 | 9570.0 |
Chinese (n = 285040) | 50.0 | 2300.0 | 40.0 | 55.0 | 285040.0 | 105.0 | 7615.0 | 130.0 | 2340.0 | 1435.0 | 45.0 | 3560.0 | 20.0 | 1130.0 | 25.0 | 20.0 |
Indian (n = 901870) | 1845.0 | 4345.0 | 1805.0 | 430.0 | 210.0 | 901870.0 | 44120.0 | 1250.0 | 3015.0 | 2980.0 | 9220.0 | 13650.0 | 170.0 | 4555.0 | 250.0 | 120.0 |
Other_Asian (n = 532905) | 2670.0 | 33525.0 | 4400.0 | 570.0 | 7940.0 | 40240.0 | 532905.0 | 2365.0 | 8525.0 | 9770.0 | 17675.0 | 9830.0 | 125.0 | 8895.0 | 450.0 | 235.0 |
Other_Black (n = 128510) | 22125.0 | 3180.0 | 110.0 | 10570.0 | 100.0 | 635.0 | 1445.0 | 128510.0 | 2800.0 | 2365.0 | 245.0 | 9610.0 | 100.0 | 185.0 | 3665.0 | 3030.0 |
Other_Mixed (n = 174875) | 2900.0 | 9140.0 | 290.0 | 1605.0 | 2230.0 | 1905.0 | 6115.0 | 2580.0 | 174875.0 | 16000.0 | 1030.0 | 16800.0 | 225.0 | 3880.0 | 2735.0 | 4120.0 |
Other_White (n = 3103285) | 4450.0 | 70050.0 | 590.0 | 855.0 | 1160.0 | 2580.0 | 8465.0 | 2310.0 | 21240.0 | 3103285.0 | 1435.0 | 336075.0 | 6620.0 | 4950.0 | 3060.0 | 1905.0 |
Pakistani (n = 592250) | 495.0 | 3170.0 | 2610.0 | 80.0 | 205.0 | 10330.0 | 25845.0 | 615.0 | 1810.0 | 1805.0 | 592250.0 | 8995.0 | 80.0 | 2445.0 | 100.0 | 50.0 |
White_British (n = 16768685) | 8905.0 | 24565.0 | 2175.0 | 8480.0 | 2750.0 | 9430.0 | 8510.0 | 7520.0 | 18265.0 | 830775.0 | 6080.0 | 16768685.0 | 39115.0 | 9765.0 | 5955.0 | 11235.0 |
White_Irish (n = 153715) | 175.0 | 395.0 | 15.0 | 50.0 | 15.0 | 110.0 | 85.0 | 75.0 | 185.0 | 12855.0 | 50.0 | 33675.0 | 153715.0 | 75.0 | 75.0 | 35.0 |
White_and_Asian (n = 99165) | 245.0 | 3770.0 | 350.0 | 65.0 | 1030.0 | 3290.0 | 7355.0 | 230.0 | 4260.0 | 4725.0 | 1895.0 | 10735.0 | 80.0 | 99165.0 | 195.0 | 110.0 |
White_and_Black_African (n = 91635) | 17855.0 | 2040.0 | 20.0 | 965.0 | 10.0 | 180.0 | 460.0 | 3465.0 | 3315.0 | 3295.0 | 75.0 | 6175.0 | 70.0 | 190.0 | 91635.0 | 1530.0 |
White_and_Black_Caribbean (n = 99585) | 1480.0 | 1125.0 | 15.0 | 9640.0 | 30.0 | 140.0 | 215.0 | 3340.0 | 6050.0 | 2505.0 | 45.0 | 16320.0 | 60.0 | 140.0 | 1550.0 | 99585.0 |
African | Any_other_ethnic_group | Bangladeshi | Caribbean | Chinese | Indian | Other_Asian | Other_Black | Other_Mixed | Other_White | Pakistani | White_British | White_Irish | White_and_Asian | White_and_Black_African | White_and_Black_Caribbean | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ethnicity_primis_16 | ||||||||||||||||
African (n = 400755) | 400755.0 | 6825.0 | 70.0 | 2255.0 | 30.0 | 865.0 | 2010.0 | 14200.0 | 2165.0 | 2925.0 | 405.0 | 6970.0 | 170.0 | 185.0 | 15650.0 | 1235.0 |
Any_other_ethnic_group (n = 426520) | 5470.0 | 426520.0 | 410.0 | 775.0 | 1280.0 | 1915.0 | 21975.0 | 2425.0 | 7950.0 | 38315.0 | 1565.0 | 12630.0 | 275.0 | 3220.0 | 1880.0 | 735.0 |
Bangladeshi (n = 126265) | 65.0 | 640.0 | 126265.0 | 15.0 | 15.0 | 1300.0 | 2970.0 | 65.0 | 260.0 | 415.0 | 2395.0 | 1805.0 | 15.0 | 320.0 | 20.0 | NaN |
Caribbean (n = 112850) | 2080.0 | 875.0 | 15.0 | 112850.0 | 15.0 | 205.0 | 355.0 | 6355.0 | 990.0 | 560.0 | 35.0 | 6910.0 | 30.0 | 30.0 | 595.0 | 6885.0 |
Chinese (n = 250100) | 35.0 | 1515.0 | 25.0 | 40.0 | 250100.0 | 55.0 | 4900.0 | 60.0 | 1740.0 | 855.0 | 30.0 | 2465.0 | 15.0 | 800.0 | 20.0 | 10.0 |
Indian (n = 773030) | 1260.0 | 2720.0 | 1200.0 | 185.0 | 60.0 | 773030.0 | 27860.0 | 345.0 | 1700.0 | 1455.0 | 6105.0 | 10385.0 | 125.0 | 3320.0 | 205.0 | 95.0 |
Other_Asian (n = 441730) | 1575.0 | 21325.0 | 2275.0 | 345.0 | 4660.0 | 18335.0 | 441730.0 | 1075.0 | 5180.0 | 5760.0 | 8135.0 | 6670.0 | 75.0 | 5285.0 | 310.0 | 135.0 |
Other_Black (n = 93390) | 9895.0 | 1845.0 | 45.0 | 4660.0 | 65.0 | 170.0 | 705.0 | 93390.0 | 1225.0 | 1155.0 | 105.0 | 6165.0 | 50.0 | 90.0 | 2055.0 | 1770.0 |
Other_Mixed (n = 149975) | 1640.0 | 6775.0 | 220.0 | 855.0 | 1955.0 | 1245.0 | 4410.0 | 1335.0 | 149975.0 | 9980.0 | 770.0 | 11385.0 | 135.0 | 2755.0 | 1760.0 | 2450.0 |
Other_White (n = 2162505) | 2575.0 | 50135.0 | 375.0 | 415.0 | 625.0 | 1400.0 | 5480.0 | 1265.0 | 12845.0 | 2162505.0 | 860.0 | 95685.0 | 3055.0 | 3115.0 | 2085.0 | 1155.0 |
Pakistani (n = 533330) | 335.0 | 2370.0 | 1850.0 | 35.0 | 45.0 | 6575.0 | 13180.0 | 160.0 | 1215.0 | 1140.0 | 533330.0 | 7425.0 | 65.0 | 1810.0 | 75.0 | 35.0 |
White_British (n = 13283385) | 6475.0 | 18170.0 | 1815.0 | 5155.0 | 1850.0 | 7170.0 | 6060.0 | 4605.0 | 11010.0 | 152665.0 | 5095.0 | 13283385.0 | 23600.0 | 7190.0 | 4715.0 | 8770.0 |
White_Irish (n = 127640) | 130.0 | 300.0 | 15.0 | 35.0 | 10.0 | 85.0 | 60.0 | 45.0 | 110.0 | 3675.0 | 35.0 | 20900.0 | 127640.0 | 55.0 | 55.0 | 30.0 |
White_and_Asian (n = 93255) | 170.0 | 2915.0 | 280.0 | 35.0 | 805.0 | 2480.0 | 5070.0 | 135.0 | 2795.0 | 2875.0 | 1505.0 | 8335.0 | 65.0 | 93255.0 | 150.0 | 70.0 |
White_and_Black_African (n = 92855) | 12995.0 | 1825.0 | 20.0 | 500.0 | NaN | 105.0 | 330.0 | 2380.0 | 1955.0 | 2315.0 | 50.0 | 4915.0 | 60.0 | 150.0 | 92855.0 | 1205.0 |
White_and_Black_Caribbean (n = 92040) | 905.0 | 830.0 | 10.0 | 5890.0 | 15.0 | 90.0 | 145.0 | 1920.0 | 3015.0 | 1350.0 | 25.0 | 12320.0 | 40.0 | 100.0 | 1270.0 | 92040.0 |