IA National Data Service – December 2023 Update

This update covers multiple months:

August

Datasets that received updates:

  • Low Income Families
  • Health – fixes
  • Crime

Note on Crime – there have been some issues with the source data requiring additional processing checks. We aim to bring this dataset up to date in December.

September

Datasets that received updates:

  • Universal Credit (August + July update)
  • Claimant Count (August + July update)
  • Waste Data ( minor fix)
  • Dwellings data ( might just have been a fix too)

October / November

We have experienced some issues with changes to geographies used in the service that have led to data not passing our quality assurance checks. We expect to get the updates back on track through December and January.

 

Population Estimates

We are aware that the mid-2022 national and subnational population estimates for England were published last month. Our target is to add these to the National Data service by the end of December.

 

IA National Data Service – July 2023 Update

Crime

Crime data (May 2023) was updated on 14th of July.

Economy & Employment

Claimant Count for May (updated) and June (new) was updated on 11th of July.

Universal Credit for May (updated) and June (new) was updated on 11th of July. Except for the employment status based indicators which are available until May (new) as these are released in arrears.

Business Demographics (2016 to 2021) was updated on 24th of July.

Health

Public Health Outcomes Framework (as at 19th of June) was updated on 24th of July.

Housing

House Prices (Jan – Dec 2022) was updated on 24th of July.

IA National Data Service – June 2023 Update

Crime

Crime data (Apr 2023) was updated on 14th of June.

Economy & Employment

Claimant Count (May 2023) was updated on 14th of June.

Universal Credit (May 2023) was updated on 14th of June.

Housing

The Household vacant dwelling data was updated on 19th of June.

IA National Data Service – May 2023 Update

Crime

Crime data (Mar 2023) was updated on 16th of May. A further update was then made the following week to resolve a numerator/denominator issue that was causing problems in reports with data aggregations used in the Custom Area Reporter.

Economy & Employment

Claimant Count (April 2023) was updated on 18th of May.

Universal Credit (April 2023) was updated on 18th of May.

Health

The Wellbeing dataset (2021-2022) was updated on 22nd of May.

Wellbeing data in the National Data Service

IA National Data Service – April 2023 Update

Crime

Crime data (Feb 2023) was updated on 5th of April.

Economy & Employment

Claimant Count (March 2023) was updated on 22nd of April.

Universal Credit (March 2023) was updated on 24th of April.

Annual Population Survey (Jan-Dec 2022) was updated on 24th of April (still no occupation or industry data update, annual qualification data not included).

A correction to the NEET data was applied on 24th of April.

Environment

Waste Management data was updated on 26th of April.

Health

PHOF and CMH data from Fingertips as at 31 March was updated on 20th of April with some fixes applied on 24th of April.

IA National Data Service – March 2023 Update

Wards 2022

The core ward geography in the National Data Service was updated to the 2022 definition of wards on 21st of March.

Crime

Monthly update to Crime data.

Economy & Employment

Monthly update to People in Universal Credit and Claimant Count.

Education

KS2 was updated on 10th of March.
KS4 was updated on 10th of March.
KS5 was updated on 27th of March.
Early Years was on updated 27th of March.

NEET data released (approx.)2023-03-27 (may have been missing in AGOL correction applied 2023-04-24)

Environment

Gas and Electricity: data for 2021 was updated on 31st of March.

Housing

Housing Net Additions: 2021-22 data was updated on 31st of March.

IA National Data Service – 2022 Wards

Last updated: 23rd of March 2023

The ward geography in the National Data Service has been updated to 2022 wards and we have started progressively rolling this change out to customers’ data catalogs. We expect this process to be completed by the end of this month.

For InstantAtlas Data Observatory customers, this means that it will be possible to view Census 2021 data in ward-level standard outputs within the observatory website, wherever data was published at ward level (not all of the phase 1 datasets were published by ONS at this level).

The process of updating the designs of ward-level reports to replace Census 2011 data with Census 2021 data has begun, and will be ongoing until the end of the month.

Ward-level report showing data from Census 2021

This includes the ward-level reports used in the Custom Area Reporter app to show aggregated data for a custom selection of wards.

Custom area reporter showing 2022 wards

IA National Data Service – January 2023 Update

Census 2021

The data from the UK armed forces veterans topic was published on 14th of January. Please read this post for more information.

Economy & Employment

People in Universal Credit (September 2022) was updated on 13th of January.

Claimant Count (September 2022) was updated on 30th of January.

Annual Population Survey, ASHE, Business Counts, Job Density were updated on 30th of January.

Note that NOMIS has since issued a warning that there were errors in the published APS data, which have now been rectified. As a consequence, we will have to re-run the update in order to correct the figures.

The speed of non-census updates has been impacted by the ongoing processing and loading of new Census 2021 data. However, we expect these updates to return to normal as the census data processing reduces from February onwards.

IA National Data Service – Census 2021 – All Phase 1 Data

Last updated: 22nd of February 2023

The National Data Service has been updated with the remaining Phase 1 univariate data from Census 2021.

Supplementing the first results, demography and migration and UK armed forces veterans data that had already been added, this update integrates data for the following topic summaries:

  • Ethnic group, national identity, language and religion
  • Labour market and travel to work
  • Housing
  • Sexual orientation and gender identity
  • Education
  • Health, disability and unpaid care

To give an idea of the scale of the undertaking, for Census 2021 we have now added about 3,800 indicators, 70 census tables and over 100,000 instances to the National Data Service.

These new indictors are located under different themes depending on the topic summary. The table below shows the top level theme in the National Data Service in each case.

Census 2021 topic summary NDS top level theme Sub-themes
Ethnic group, national identity, language and religion Population Ethnicity, Identity, Language and Religion
Labour market and travel to work Economy Economic Activity Status; Travel to Work; Industry and Occupation
Housing Housing Households; People with second address; Communal establishments
Sexual orientation and gender identity Population Sexual orientation; Gender identity
Education Children and Young People Qualifications; Population and Pupil Characteristics
Health, disability and unpaid care Health Disability; General Health; Unpaid Care

As with the previous updates, we have retained the structure the data were published in, and have also retained the name of the census table in the theme names and indicator names. This is helpful for users that are familiar with the way the census data is organised and/or the names of the tables.

Under each top level theme in the National Data Service, the old data from Census 2011 have been moved into a subtheme labeled Census 2011, to avoid confusion with the 2021 data.

Note that it is not the case that all data is available at all geographic levels. For example, the ‘detailed’ tables for Ethnicity, Identity and Religion do not contain data at LSOA 2021, nor do the tables for Sexual Orientation and Gender Identity.

Data is generally not currently available for the Ward geography. We are in the process of updating the ward definition in the National Data Service to the latest (2022) wards and as part of that process, Census 2021 indicator will gain data that level wherever it has been published by ONS.

We will also be adding descriptive metadata for the Census 2021 indicators held in the service.

For customers with a managed Data Observatory website, the data are displayed in the following places:

1) Map Explorers (updated 3rd Feb 2023)

Map Explorer showing new Census 2021 phase 1 data

 

2) Data Explorer (updated 3rd Feb 2023)

Data Explorer showing new Census 2021 phase 1 data

 

3) Reports (updated 3rd– 14th Feb 2023)

Health report showing Census 2021 data

 

The reports for upper and lower tier local authorities have been updated to replace 2011 census data with 2021 data. New reports for the LSOA 2021 geography have been added for the Population, Health and Environment themes (the other themes retain reports at the old LSOA geography for now as there is more relevant data available at this level for the time being).

Reports for custom geographies will show Census 2021 data wherever we have been able to aggregate data to these geographies from 2021 OA or LSOA levels. If any of your reports are still showing data for 2011, it may be that you need to send us an updated lookup for your custom geography in order for us to apply the aggregations.

Note that LSOA 2021 reports have also been made available in the Custom Area Reporter app (for relevant themes), if your observatory website is using this app.

Customer Area Reporter app showing reports for Census 2021 data

 

IA National Data Service – Census 2021 – UK Armed Forces Veterans Topic

Last updated: 17th of January 2023

The National Data Service has been updated with the data from the UK armed forces veterans topic summary from Census 2021.

This adds around 30 new indicators to the service, with data available at the geographies it has been published for by ONS:

  • Country
  • Region
  • Upper Tier Local Authority
  • Lower Tier Local Authority

These new indictors are all located under the Population, Veterans theme.

For customers with a managed Data Observatory website, the data are displayed in the following places:

1) Population Map Explorer (updated 14th Jan 2023)

2) Data Explorer (updated 14th Jan 2023)

3) Upper and lower tier local authority Population reports (updated 17th Jan 2023)

We aim to add the data from the remaining topic summaries (phase 1) by the end of the January, and update our reports with these new indicators.