Project

General

Profile

Support #1935

Missing data on MSOA codes

Added by Fiona Steele 10 months ago. Updated 6 months ago.

Status:
Resolved
Priority:
Normal
Assignee:
-
Category:
Data linkage and consents
Start date:
07/07/2023
% Done:

100%

Description

Hello,

I have been using the 2011 census LSOA and MSOA codes and the LAD codes from the Special License Access datasets (SN 7248, 7249 and 6666).

When I merge the datasets for waves 1-11, matching on hidp and wave, to create a dataset with all three area identifiers, I find that there is much more missing data on MSOA. For LSOA and LAD there is only 1 observation with a code of -9, compared to 17,903 observations for MSOA.

Could you explain why this is?

Thanks very much.

Fiona

#1

Updated by Understanding Society User Support Team 10 months ago

  • Category set to Data linkage and consents
  • Status changed from New to In Progress
  • Private changed from Yes to No

Many thanks for your enquiry. The Understanding Society team is looking into it and we will get back to you as soon as we can. We aim to respond to simple queries within 48 hours and more complex issues within 7 working days.

Best wishes,
Understanding Society User Support Team

#2

Updated by Understanding Society User Support Team 10 months ago

  • Status changed from In Progress to Feedback
  • % Done changed from 0 to 80

Dear Fiona,

You are right about the high number of -9 for MSOA11. We checked this and it seems that for MSOA11 for waves 1 to 4 ONSPD_MAY_2013 was used, ONSPD_MAY_2013 includes only England and Wales but not Scotland. Scotland is not included until ONSPD_MAY_2015. So all of those -9’s are due to Scotland MSOAs being missing from Waves 1 to 5. However, for LSOA11 for waves 1 to 6 ONSPD_MAY_2015 for waves 1 to 6 which therefore does included Scotland.

Thank you for highlighting the issue, we will try to address it in the November data release. In the meantime, you can try to derive the Scottish MSOAs from LSOAs using a look table, e.g. https://statistics.gov.scot/downloads/file?id=13360f3a-ca68-4f3e-8b7f-caffed8712eb%2FDataZone2011lookup_2022-05-31.csv (please not that the Scottish equivalents of LSOA and MSOA are, respectively, datazone and intermediate Zone).

Best wishes,
Piotr Marzec
UKHLS User Support

#3

Updated by Fiona Steele 10 months ago

Thanks, Piotr. That's very helpful.

Best wishes,
Fiona

#4

Updated by Understanding Society User Support Team 6 months ago

  • Status changed from Feedback to Resolved
  • % Done changed from 80 to 100

Also available in: Atom PDF