Skip to main content

Table 1 Distribution of harmonised key and auxiliary imputation variables in census and survey datasets

From: Standard multiple imputation of survey data didn’t perform better than simple substitution in enhancing an administrative dataset: the example of self-rated health in England

  Census data (n (%))
N = 1,390,094
Survey data (n (%))
N = 134,083
Key variables
 Sex
  Male 687,812 (49.5) 64,166 (47.9)
  Female 702,282 (50.5) 69,817 (52.1)
 Age group
  25–29 179,770 (12.9) 14,742 (11.0)
  30–34 173,146 (12.5) 15,674 (11.7)
  35–39 176,241 (12.7) 16,107 (12.0)
  40–44 193,181 (13.9) 18,178 (13.6)
  45–49 192,828 (13.9) 18,596 (13.9)
  50–54 169,063 (12.2) 17,300 (12.9)
  55–59 148,525 (10.7) 15,998 (11.9)
  60–64 157,340 (11.3) 17,488 (13.0)
 Housing tenure
  Owns home outright 297,630 (21.4) 30,938 (23.1)
  Mortgage/shared ownership 637,581 (45.9) 62,250 (46.4)
  Private rent 256,592 (18.5) 21,518 (16.1)
  Social rent 198,291 (14.3) 19,377 (14.5)
 English region
  North east 67,752 (4.9) 10,994 (8.2)
  North west 183,198 (13.2) 21,460 (16.0)
  Yorkshire and the Humber 136,179 (9.8) 14,438 (10.8)
  East Midlands 117,676 (8.5) 9,064 (6.8)
  West Midlands 143,120 (10.3) 14,076 (10.5)
  East of England 152,850 (11.0) 11,856 (8.8)
  London 230,677 (15.6) 17,830 (13.3)
  South east 223,883 (16.1) 20,509 (15.3)
  South west 134,759 (9.7) 13,856 (10.3)
Auxiliary variables
 Highest educational qualificationa
  Higher education 467,010 (33.6) 43,244 (32.3)
  School (advanced) 165,525 (11.9) 26,421 (19.7)
  School (standard) 413,096 (29.7) 36,913 (27.5)
  Other qualifications 128,137 (9.2) 10,417 (7.8)
  No formal qualifications 216,326 (15.6) 17,088 (12.7)
 Marital status
  Single 410,131 (29.5) 35,650 (26.6)
  Married 747,394 (53.8) 77,440 (57.8)
  Civil partnership 4327 (0.3) 486 ( 0.4)
  Divorced 153,731 (11.1) 13,559 (10.1)
  Widowed 24,058 (1.7) 2412 (1.8)
  Separated 50,453 (3.6) 4536 (3.4)
 Country of birth
  UK 1,141,684 (82.1) 112,135 (83.6)
  European Union 74,891 (5.4) 6434 (4.8)
  Other 173,519 (12.5) 15,514 (11.6)
 Ethnicity
  White 1,196,262 (86.1) 117,832 (87.9)
  Mixed race 19,874 (1.4) 973 (0.7)
  Asian 110,598 (8.0) 9729 (7.3)
  Black 47,930 (3.5) 3757 (2.8)
  Other 15,430 (1.1) 1792 (1.3)
  1. aHigher education: Degree level qualification (or equivalent)/Higher education qualification below degree level; School (advanced): A Level/Higher/Advanced Diploma/Progression Diploma/ONC/National Level BTEC; School (standard): O Level or GCSE equivalent/O Grade or CSE equivalent/Standard Grade/Higher or Foundation diploma; Other qualifications: including foreign qualifications below degree level