IA National Data Service – March 2021 Data Update

Crime

February 2021 monthly and 12 monthly rolling average data were uploaded on the 25th of March. All affected reports were last updated on the 26th of March.

Economy & Employment

Claimant Count (Feb 2021) was last updated on the 23rd of March. All affected reports were published by the 27th of March.

Education

Key Stage 4 Results for the academic year 2019/20 were released. This release has been uploaded as a new dataset in relation to the COVID-19 pandemic. During the pandemic, the exams were cancelled and the results were awarded by a centre assessment grade (based on what the school or college believed the student would most likely have achieved) or their calculated grade using a model developed by Ofqual – whichever was the higher of the two. The attainment statistics have increased as a result of this awarding method – more than would be expected in a typical year – between the 2018/19 and 2019/20 academic years. This reflects the change to the way GCSE grades were awarded rather than improvements in pupil performance. As a result, the 2019/20 data should not be directly compared to attainment data from previous years to measure changes in student performance. For these specific reasons, the measures for Key Stage 4 in 2018/19 e the same measures for 2019/20 are now two separate datasets. Please note that Progress 8 indicators are not available in 2019/20. These measures are calculated by a model that is based on national averages. Considering the awarding method, the estimated model would not measure the progress made by a pupil in a meaningful or accurate manner.

For additional information, please consult the website:

Key stage 4 performance, Academic Year 2019/20 – Explore education statistics – GOV.UK (explore-education-statistics.service.gov.uk)

IA National Data Service – February 2021 Data Update

Crime

January 2021 monthly and 12 monthly rolling average data were uploaded on the 26th of February. All affected reports were last updated on the 27th of February.

Economy & Employment

Claimant Count (Jan 2021) was last updated on the 23rd of February.

From the NOMIS release notes for January 2021 processing: A small number of Universal Credit claims may not be included in the January 2021 Claimant Count. This may affect up to 20,000 claims throughout the UK, but the actual number is expected to be substantially fewer. These claims are expected to be included in future Claimant Count releases.

Jobs density estimates for 2019 and revised figures for 2018 were corrected due to minor errors due to geographical changes.

All affected reports were published by the 24th of February.

Health

A PHOF update – Public Health Outcomes Framework – was carried out on the 19th of February. Related reports were published on the 20th of February.

For this release a total of 46 indicators have been updated:

    • Inequality in life expectancy at birth and at 65 years and over
    • 10 indicators from the wider determinants of health domain
    • 31 indicators from the health improvement domain
    • 2 indicators from the health protection domain
    • 1 indicator from the healthcare and premature mortality domain

Environment

Electricity and Gas consumption figures were updated on the 19th of February. Please note: for this update historical data was revised.

IA National Data Service – January 2021 Data Update

Crime

Crime data was updated twice during January 2021 following Christmas break.

November 2020 monthly and 12 monthly rolling average data were uploaded on the 8th of January. December 2020 data was uploaded on the 29th of January. All affected reports were last updated on the 03rd of February.

Please note: Humberside data for December 2020 was not provided and is therefore not currently available.

Economy & Employment

Claimant Count (Dec 2020) was last updated on the 26th of January.

APS – Annual Population Survey Indicators, with new figures for the Oct 2019 – Sep 2020 survey period, were uploaded on the 27th of January. Please note: country of birth estimates are not included in this release.

Job Density estimates for 2019 and revised figures for 2018 data were uploaded on the 26th of January.

Apprenticeships data (2019/20) was uploaded on the 22nd of January.

All affected reports concerning Economy & Employment were published by the 03rd of February.

Housing

Housing Pricing was updated on the 7th of January. Related reports were published on the 11th of January.

Population

A correction was applied to Population Projections on the 28th of January where the total male figures had been replaced by the total female figures.

IA National Data Service – December 2020 Data Update

Economy & Employment

Claimant Count (November 2020) updated on the 16th of December. All affected reports were updated by the 22nd of December.

Health

Indicators from the ASCOF – Adult Social Care Framework Outcomes – were published for the first time in December. This dataset includes 107 indicators measuring how well care and support services achieve the outcomes that matter most to people. These outcomes are used both locally and nationally to set priorities for care and support, measure progress and strengthen transparency and accountability.

Population

Population Projections (up till 2043) were updated with delay on the 23rd of November. Related reports were updated on the 24th of December. This dataset has now extended coverage reporting projections every year from 2020 to 2043, replacing previous quinquennial projections.

IA National Data Service – November 2020 Data Update

Crime

Crime data (Monthly – Oct 2020 – and 12 Monthly update – Nov 19 – Oct 20) updated on the 27th of November. All affected reports were updated on the 30th of November.

Economy & Employment

Claimant Count (October 2020) updated on the 10th of November. All affected reports were updated by the 19th of November.

ASHE – Annual Survey of Hours and Earnings – Indicators (2019) were updated on the 16th of November. This dataset includes information on weekly and annual pay for full and part-time workers. Disaggregation available by gender.

Business Register and Employment Survey (BRES) indicators were updated on the 16th of November. These indicators provide counts and rates on the type of employment by industry type.

Business Demographics (2019) were updated on the 26th of November. This includes data relative to birth and death of new enterprises, total count of active enterprises and survival rate within the last 5 years.

All Economy & Employment Reports were published on the 17th of November.

Health

Several indicators from the Public Health Outcomes Framework (PHOF) dataset have been updated on the 19th of November.

Please, find below an extract of the indicators included in this update:

      • Violent crime – violence offences per 1,000 population
      • Under 75 mortality rate from liver disease/respiratory disease/cancer/cardiovascular disease/
      • Infant mortality rate
      • Deaths from drug misuse
      • HIV late diagnosis
      • TB incidence
      • Excessive winter deaths index
      • Population vaccination coverage

Housing

Net Housing Additions (2019) were updated on the 30th of November.

IA National Data Service – October 2020 Data Update

Economy & Employment

Claimant Count (September 2020) updated on the 14th of September. All affected reports were updated on the 16th of September.

Annual Population Survey indicators (2019) were updated on the 16th of October. A selection of measures included in this release are listed below:

      • Qualifications (GCSE and NVQ)
      • Economically inactive
      • Occupation (SOC2010)
      • Economic activity rate
      • Unemployment rate
      • Ethnic group by economic activity
      • Hours worked weekly
      • Economic activity of those with health conditions or illnesses lasting more than 12 month

Business Counts (2020) were updated on the 8th of October.

Health

Several indicators from the Public Health Outcomes Framework (PHOF) dataset have been updated on the 14th of October.

Please, find below an extract of the indicators included in this update:

    • Violent crime – violence offences per 1,000 population
    • Under 18s conception rate / 1,000
    • Under 75 mortality rate from liver disease/respiratory disease/cancer/cardiovascular disease/
    • Infant mortality rate
    • Hip fractures in people aged 65 and over
    • TB incidence
    • Excessive winter deaths index

Wellbeing indicators (2020) have been updated on the 30th of September and affected reports published in the first week of October.

Housing

Household Projections (2018) were updated on the 1st of October. Council Tax Bands and affected reports have been updated on the 15th of October.

IA National Data Service – September 2020 Data Update

Crime

Crime data (August) updated on the 28th of September.

Population

Nationality & Country of Birth data updated on the 7th of September while latest Population Estimates were updated on the 14th of September.

Economy & Employment

Claimant Count (August) updated on the 15th of September. All affected reports were updated on the 19th of September.

Health

Several indicators from the Public Health Outcomes Framework (PHOF) dataset have been updated on the 24th of September.

Please, find below an extract of the indicators included in this update:

    • Adjusted antibiotic prescription in primary care
    • Smoking in early pregnancy
    • Population vaccination coverage – Flu/Hepatitis/HPV
    • Suicide Rate
    • Low birth weight of term babies
    • Average portions of fruit and vegetables
    • Cancer screening coverage
    • Killed and seriously injured (KSI) casualties on England’s roads
    • Statutory homelessness

 

 

InstantAtlas integration with Power BI

This article describes how to use data from the InstantAtlas National Data Service in Microsoft Power BI. The National Data Service is delivered as ArcGIS Online feature layers.

The steps for using data in ArcGIS in Power BI are described here. It is possible to use the steps in the Appendix to bring data from the National Data Service into Power BI.

However, when using data from the National Data Service specifically, a better result can be achieved using a custom query in the Power BI Advanced Editor. The steps for doing this are described below.

Sign in to the Data Catalog Hub and use the Data Explorer app to search for the indicator you are interested in. Click on any of the tabs and click the button to view the item in ArcGIS Online.

IA data explorer link to ArcGIS button

In ArcGIS Online, on the item overview page, click the layer corresponding to the geography you want to display data for in Power BI. Then click the Copy button on the right to copy the URL.

ArcGIS Online copy feature layer URL button

Amend this URL (e.g. in Notepad) to add this to the end:


query?where=1%3D1&outFields=*&returnGeometry=false&resultRecordCount=0&f=json

The URL should now look something like this:


https://services1.arcgis.com/HumUw0sDQHwJuboT/arcgis/rest/services/Suffolk_Pop_Est_Female/FeatureServer/0/query?where=1%3D1&outFields=*&returnGeometry=false&resultRecordCount=0&f=json

Open Power BI Desktop and click Get Data, Web. Paste your URL into the URL box and click OK.

Power BI URL box

You will get something like this:

Power BI data import

Click Transform Data. The Power Query Editor will open. Click Advanced Editor.

Power BI Advanced Editor

Replace the query in the Advanced Editor with the one below. Make sure you adjust the URL at the start of the query (shown in red) to the one you are actually using.


let
    Source = Table.FromColumns({Lines.FromBinary(Web.Contents("https://services1.arcgis.com/HumUw0sDQHwJuboT/arcgis/rest/services/Suffolk_Pop_Est_Female/FeatureServer/0/query?where=1%3D1&outFields=*&returnGeometry=false&resultRecordCount=0&f=json"), null, null, 65001)}),
    #"Parsed JSON" = Table.TransformColumns(Source,{},Json.Document),
    Column1 = #"Parsed JSON"{0}[Column1],
    fieldSet = Column1[fields],
    fieldNames = List.Transform(fieldSet, each Record.Field(_, "name")),
    fieldAliases = List.Transform(fieldSet, each Text.Combine({Text.Replace(Record.Field(_, "alias"), "|", " | "), " (", Record.Field(_, "name"),")"})),
    features = Column1[features],
    #"Converted to Table" = Table.FromList(features, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"attributes"}, {"Column1.attributes"}),
    #"Expanded Column1.attributes" = Table.ExpandRecordColumn(#"Expanded Column1", "Column1.attributes", fieldNames, fieldAliases)
in
    #"Expanded Column1.attributes"

Power BI Advanced Editor new query

Click Done.

National Data Service data in Power BI

Note that the data type for the columns is text. You should change this for the data you wish to use. Select the columns in question, right-click, Change Type and choose the appropriate type.

Change data type in Power BI

Then click Close & Apply in the ribbon.

You can then create your visualisation with the data from the feature layer.

Power BI visualisation with National Data Service data

IA National Data Service – August 2020 Data Update

Crime

Crime data (June) updated on the 30th of July. All affected reports updated by 7th of August.

Children & Education

NEET (2020) and Absence (2018-2019) data were last updated on the 12th of August and all affected reports on the 13th of the same month.

Deprivation

Fuel Poverty statistics (2018) were uploaded on the 18th of August.

Economy & Employment

Claimant Count (July) updated on the 11th of August. All affected reports were updated on the 13th.

Environment

Electricity and Gas Consumption and Carbon Emissions statistics (2018) were uploaded on the 19th and on the 24th of August, respectively. No reports affected.

Health

Several indicators from the Public Health Outcomes Framework (PHOF) dataset have been updated on the 20th of August.

Please, find below an extract of the indicators included in this update:

    • Low Birth Weight of Term Babies
    • Inequality in life expectancy at birth
    • Population vaccination coverage
    • Heart failure indicators
    • GP registered population
    • Several Cancer related indicators , including screenings and new cases
    • Breastfeeding, including initiation, first feed and prevalence
    • Fertility rates and Conception Rates for U18s and U16s

Housing

Stock of properties data (2019) and vacant dwellings data (2017-2019) were uploaded on the 4th of August. All affected reports were updated on the 13th of August.

IA National Data Service – July 2020 Data Update

Crime

Crime data (May) updated 1 July. All affected reports updated by 6 July.

Children & Education

The following education data was updated in July and relative reports updated by the 29th of July:

      • 2018/19 Key stage 2
      • 2018/19 Key Stage 4
      • 2018/19 Key Stage 5
      • 2018/19 Special Educational Needs (SEN)
      • 2018/19 Free School Meals (FSM)
      • 2018/19 Pupils Characteristics

Economy & Employment

Claimant Count (June) updated during July.

April 2019 to March 2020 Annual Population Survey (APS) updated during July. Reports updated by the 22nd of July.

A detailed breakdown of statistics included within the APS is listed below:

      • Disability (Equality Act) core level by economic activity
      • Economic activity of those with health conditions or illnesses lasting more than 12 months
      • Economic activity rate
      • Economically inactive
      • Employment rate
      • Ethnic group by economic activity
      • Full-time and part-time employment
      • Hours worked weekly
      • Industry of employment (SIC 2007)
      • Nationality by white/ethnic minority
      • Occupation (SOC2010) major group of employment
      • Public and private sector employment
      • Qualifications (GCSE/NVQ)
      • Self-employed, employees and non-permanent employment
      • Unemployment rate
      • White/ethnic minority by age
      • Estimates of unemployment (model-based)

Deprivation

HMRC and DWP’s previous statistics relative to children in low income families have been replaced and deprecated to provide a more coherent picture of this category for both Relative and Absolute Low Income.

Latest data for Children in Low Income Families Data has been updated on the 21st of July, from financial year 2014/15 to 2018/19.