IA National Data Service – July 2021 Data Update

Crime

June 2021 monthly and 12 monthly rolling average data was released only at the beginning of July. Data updates will figure in the August blog update.

Economy & Employment

Claimant Count (June 2021) was last updated on the 15th of July. All affected reports were published by the 17th of July.

Gross Value Added (GVA) for the year 2019 was updated on the 6th of July.

In the economic accounts, the economy is split into institutional sectors, that is, units broadly grouped according to their role in the economy. The GVA measures the increase in the value of the economy due to the production of goods and services. It is measured at current basic prices, which include the effect of inflation, excluding taxes (less subsidies) on products. GVA plus taxes (less subsidies) on products is equivalent to Gross Domestic Product (GDP) [Source ONS: UK Regional Accounts Methodology Guide].

Health

Data from the latest PHOF (Public Health Outcome Framework) update, specifically July 2021, was published on the 22nd of July.

This update concerns 4 indicators. In detail:

    • C26a – Cumulative percentage of the eligible population aged 40 to 74 offered an NHS Health Check
    • C26b – Cumulative percentage of the eligible population aged 40 to 74 offered an NHS Health check who received an NHS Health Check
    • C26c – Cumulative percentage of the eligible population aged 40 to 74 who received an NHS Health Check
    • E15 – Estimated dementia diagnosis rate (aged 65 and over)

On the 22nd of July, a new set of indicators was also added to the National Data Service in relation to Child and Maternal Health. This edition includes a series of measures that can be grouped into the following main categories:

    • Breastfeeding
    • Early Years
    • Early Years supplementary indicators
    • Health behaviours in 15 years old
    • Long term conditions and complex health needs
    • Mortality
    • Oral Health
    • Pregnancy and birth
    • School-age Children
    • School-Age Children supplementary indicators
    • Unintentional injuries
    • Vulnerable children and young people
    • Young people supplementary indicators

    IA Report Builder 2.1.0 – 19 July 2021 Release Notes

    Overview

    Report Builder version 2.1.0 introduces a new widget, the Toggle Content widget. This has been added in order to enable content sections in a report to be expanded/collapsed by the end user. Prior to the addition of this widget, the same “accordion” effect had to be achieved using styling in the website that the report was embedded into.

    Toggle Content Widget

    In the example below, the end user can click the button next to the Safeguarding heading to collapse the content below it (this is just an image, the toggle won’t do anything here!).

    InstantAtlas Report Builder Toggle Content Widget

    The different settings available for this widget are described on the widget help page.

    Number Formatting

    It is now possible to specify a percentage number format (P) for your widget to show data as percentages. For example, for a Data Table widget, locate the Number Format setting under Numbers & Values and replace this with P. For a Bar Chart widget, locate the Axis Label Format setting under Axes and type in P. Visit this page for more on the number formats supported in Report Builder.

    If you have any questions relating to this release please contact support@instantatlas.com.

    IA National Data Service – June 2021 Data Update

    Crime

    May 2021 monthly and 12 monthly rolling average data were uploaded on the 30th of June. All affected reports for May 2021 were published by the 05th of July.

    Economy & Employment

    Claimant Count (May 2021) was last updated on the 18th of June. All affected reports were published by the 21st of June.

    Population

    Population estimates for the UK, England, mid-2020 were last updated on the 25th of June. All affected reports were published by the 26th of June.

    Health

    The PHOF (Public Health Outcome Framework) update from May 2021 was published on the 5th of June. Reports were updated on the 27th of June.

    This update concerns 17 indicators. In detail:

      • Overarching Indicators domain: 5 indicators including healthy life expectancy at birth, disability-free life expectancy at birth and inequality in healthy life expectancy for England;
      • Wider determinants of health domain: 1 indicator -: first-time entrants to the youth justice system;
      • Health improvement domain: 5 indicators including the percentage of looked after children whose emotional wellbeing is a cause for concern, proportion of the population meeting the recommended ‘5-a-day’ on a ‘usual day’ (adults) and percentage of physically active adults;
      • Healthcare and premature mortality domain: 5 indicators covering emergency readmissions within 30 days of discharge from hospital and preventable sight loss.
      • Health protection domain: 2 indicators including population vaccination coverage – HPV vaccination coverage for two doses (females 13-14 years old) and population vaccination coverage – Meningococcal ACWY conjugate vaccine (MenACWY) (14-15 years)

    The data for the indicator ‘C27 – Percentage reporting a long term Musculoskeletal (MSK) problem’ has been revised to reflect changes in the GPPS questionnaire, which changed the base population from 18+ to 16+.

    Indicator ‘D04e – Population vaccination coverage – HPV vaccination coverage for one dose (12-13 years old)’ has been split by gender, due to changes in vaccination coverage.

     

    IA Report Builder 2.0.2 – 14 June 2021 Release Notes

    Overview

    Report Builder version 2.0.2 addresses a number of bugs, several of which will  ensure a smoother migration from version 1 to version 2 reports. We have also added some of the functionality of Report Builder 1 that had not yet been implemented in version 2, as well as performance, accessibility and error handling improvements.

    Bug fixes

    • Bar Charts set to horizontal orientation now also work when the selected data contains upper and lower confidence limits.
    • The Scatter/Bubble Chart widget has gained the setting X Axis Range which allows the x-axis to be constrained between two defined values.
    • The Scatter/Bubble Chart widget can now be configured to show all points in the same colour without having to define a separate colour for each feature. This is done by switching Constrain Palette Colors on:
    • The Filled Icon widget now shows the icon filled in the selected Highlight Color if Highlight Selected Feature is enabled.
    • Copying widgets from one report to another now works more reliably. In version 2.0.1 and when copying multiple widgets in succession, a browser refresh was required between pasting different widgets.
    • In the Edit Chart Colors… dialog (main menu – StylingChart Colors) the Toggle direct edit buttons now work by providing a text field to insert colour values in hexadecimal or RBG format.
    • Exiting a report now takes the user back to the same folder view with the same sorting retained.
    • Fix for an issue with hash/anchor links that occurred when using the # symbol in the browser address bar . This allows users e.g. to jump to a particular section of a report by providing the URL to the anchor tag.
    • Fix for certain font families (those containing spaces in the name) not being applied in view mode of a report.

    Improved migration

    • Pie Charts in migrated reports no longer group small segments together into one category.
    • Titles of Table widgets are now migrated correctly.
    • The content of the Table Footer settings from Report Builder 1 is now migrated to the setting Caption in Report Builder 2.
      Please note: Any tables in reports that have been migrated and saved before the release of Report Builder version 2.0.2 will have lost the Table Footer text. You can re-add the text by entering it into the Caption setting manually. Alternatively, if the equivalent version 1 report still exists, you can migrate it again.

    Additional functionality

    • It is now possible to change the font colour of text in a Text widget through the editor toolbar. You have the option to choose one of the predefined colours or use the palette icon to open the Color Picker dialog
    • The Advanced Settings dialog in the Pages menu has gained options to customise the index page of the report.
    • Any changes to the Pages|Advanced Settings dialog now turns the Save button of the report editor orange, indicating that there are unsaved changes.
    • Line and scatterplot widget point styles have been extended and some of the less obvious options have been subtly renamed.
    • Web accessibility has been improved by adding the option to show unique point markers in chart series lines and index options to chart labels – please see this blog post to find out more about accessibility for reports created using Report Builder. 
    • The Data Catalog data model is cached in the browser whilst the editor page is open, which means the widget settings dialog opens faster.
    • Improved error messaging when/if connections fail.
    • Widgets have become more robust to temporary data connection errors. If a connection fails, the widget will attempt to reconnect to the data after a few seconds, up to 3 times before giving up.

    If you have any questions relating to this release or migration of reports from version 1 to version 2 please contact support@instantatlas.com.

    IA National Data Service – May 2021 Data Update

    Crime

    April 2021 monthly and 12 monthly rolling average data were uploaded on the 5th of May. Data relative to May 2021 was published on the 26th of May. All affected reports for May 2021 were published by the 29th of May.

    Economy & Employment

    Claimant Count (Apr 2021) was last updated on the 18th of May. All affected reports were published by the 21st of May.

    Deprivation

    Fuel Poverty Data for the year 2019/20 was last updated on the 15th of May.

    Children in Absolute and Relative Low-Income Families (2019/20) was last updated on the 17th of May.

    IA National Data Service – April 2021 Data Update

    Economy & Employment

    Claimant Count (Mar 2021) and Annual Population Survey – APS – (Jan 2020-Dec 2020) were last updated on the 20th of April. All affected reports were published by the 29th of April.

    As a quick reminder, the Annual Population Survey is a residence-based labour market survey encompassing population, economic activity (employment and unemployment), economic inactivity and qualifications. These are broken down where possible by gender, age, ethnicity, industry and occupation. Available at Local Authority level and above. The APS is updated quarterly.

    Education

    Key Stage 5 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 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 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 5 in 2018/19 e the same measures for 2019/20 are now two separate datasets. Furthermore, the department decided to not publish value-added measures, as 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. However, for consistency and transparency, the remaining headline measures were reported in this statistical release (amongst others):

    • Attainment in terms of Average Point Score (APS) per entry for A level (subset of Academic), Applied General, Tech Level, and Technical Certificate exam cohorts

    • English and maths progress

    For additional information, please consult the website:

    A level and other 16 to 18 results, Academic Year 2019/20 – Explore education statistics – GOV.UK (explore-education-statistics.service.gov.uk)

    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.