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.

IA National Data Service – Census 2021 – Demography and Migration Topic

Last updated: 21st of December 2022

The National Data Service has been updated with the data from the Demography and migration topic summary from Census 2021.

This adds nearly 1,500 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
  • Middle Layer Super Output Area
  • Lower Layer Super Output Area

To display the LSOA level data we have added a new core geography to the National Data Service called LSOA 2021.

Although ONS did not publish data at ward level, where possible we have generated values at this level by aggregating values from OA area using a population weighted centroids best fit method.

These new indictors are all located under the Population theme, and organised into subthemes that reflect the census table that they were sourced from. 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.

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

1) Population Map Explorer (updated 6th Dec 2022)

Map explorer with census 2021 data

2) Data Explorer (updated 6th Dec 2022)

Data explorer with census 2021 data

3) Upper and lower tier local authority Population reports (updated 7th and 9th Dec 2022)

Report with Census 2021 data from Demography and migration topic

In January we will be adding data for the further topic summaries that have been released by ONS and updating our ward level reports in addition to the reports at local authority level.

IA National Data Service – October 2022 Update

Education

Pupil characteristics data was updated on 18th of October. Fixes were applied on 27th of October.

Crime

August 2022 monthly and 12 monthly rolling average data were uploaded on 8th of October.

Economy & Employment

Claimant Count (September 2022) was updated on 11th of October.

People in Universal Credit (September 2022) was updated on 15th of October.

BRES data was updated on 15th of October.

Annual Population Survey data was updated on 16th of October. Minor fixes were applied on 19th of October.

Deprivation

Children in low income families data was updated on 13th of October. Fixes were applied on 22nd of November.

IA National Data Service – September 2022 Update

Housing

Household dwelling data was updated on 5th of September.

House prices data was updated on 27th of September.

Education

Pupil characteristics – first language data was updated on 29th of September.

Crime

July 2022 monthly and 12 monthly rolling average data were uploaded on 8th of September.

Economy & Employment

Claimant Count (August 2022) was updated on 13th of September.

People in Universal Credit (August 2022) was updated on 14th of September.

IA National Data Service – August 2022 Update

Crime

June 2022 monthly and 12 monthly rolling average data were uploaded on 5th of August.

Economy & Employment

The Apprenticeships dataset was updated on 5th of August.

Claimant Count (July 2022) was updated on 16th of August.

People in Universal Credit (July 2022) was updated on 17th of August.

Environment

The Emissions dataset was updated on the 10th of August. The figures for carbon dioxide were updated and new figures included for methane and nitrous oxide.

Annual Population Survey

The data for Apr 2021- Mar 2022 was added on 16th of August (out of cycle).