IA National Data Service – November 2021 Data Update

Crime

October 2021 monthly and 12 monthly rolling average data was updated and published on AGOL with relative reports on the 29th of November.

Economy & Employment

Claimant Count (October 2021) was last updated on the 16th of November.

The Business Register and Employment Survey (BRES) is a collection of employee and employment estimates at detailed geographical and industrial levels. The provisional 2020 and revised 2019 estimates were released on the 9th of November and published to AGOL on the 11th of the month.

People in Universal Credit data for October 2021 is now available on the Data Catalog. The latest release was published on AGOL on the 17th of November.

Environment

The Environment theme got some brand new additions this last month! Besides updating the Carbon Emissions statistics (2019) on the 4th of November, the NDS now includes two brand new collections about renewable energy and waste management. The Renewables dataset includes information on capacity, generation, and the number of sites for different technologies based on renewable sources. These were published on the 4th of November. The Waste dataset includes information relative to waste collection and management by local authorities, this was uploaded on the 4th of November.

Health

Indicators from the ASCOF – Adult Social Care Framework Outcomes – were updated on the 15th of November. This dataset includes 107 indicators measuring how well care and support services achieve the outcomes that matter most to people. This collection of measures includes indicators coming from multiple sources:

    • Adult Social Care Survey (ASCS). Please note: the 2020-21 dataset was voluntary due to the COVID-19 pandemic. As only 18 CASSRs participated in the 2020-21 survey, aggregated ASCOF outcomes have not been calculated at regional, council type, and England level. Further details are available in the ASCS publication;
    • Short and Long Term Support (SALT);
    • Mental Health Services Data Set (MHSDS);
    • Delayed Transfer of care (DToC) – Due to the impact of coronavirus (COVID-19), the DToC collection has been paused for 2020-21;
    • Survey of Adult Carers in England (SACE). Due to the additional pressures that COVID-19 has brought on all services, the Survey of Adult Carers in England (SACE) 2020-21 was postponed by one full year. It will continue to run biennially and will be included in the 2021-22 ASCOF publication.

Wellbeing indicators (2021) have been updated on the 23rd of November.

Housing

ONS house pricing has been updated on the 24th of November. The latest release includes data for the financial year 2020/2021.

Population

Nationality & Country of Birth data was updated on the 25th of November.

IA National Data Service – October 2021 Data Update

Crime

September 2021 monthly and 12 monthly rolling average data was released at the beginning of October and updated and published on AGOL with relative reports on the 01st of October.

Economy & Employment

Claimant Count (September 2021) was last updated on the 12th of October. All affected reports were published by the 13th of October.

The Annual Population Survey (APS) for Jul 2020 – Jun 2021 was published on the 13th of October. The APS is a residence-based labour market survey that collects information on 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, this dataset is updated quarterly.

Topics covered in the APS dataset include:

    • Country of birth
    • Disability level
    • Economic activity (employment, unemployment and economic activity)
    • Ethnic group
    • Health problems
    • Hours worked weekly
    • Industry of employment
    • Job-related training
    • National identity and Welsh language
    • Nationality
    • Occupation of employment
    • Public and private sector employment
    • Qualifications

ASHE – Annual Survey of Hours and Earnings – Indicators (2020) were published on AGOL on the 28th of October. This dataset includes information on weekly and annual pay for full and part-time workers. Disaggregation available by gender.

People in Universal Credit data up till September 2021 is now available on the Data Catalog. Latest release was published on AGOL on the 25th of October.

Experimental Small Area Income Estimates have been published on the 15th of October. These indicators give an experimental measure of gross and net income using data from HM Revenue and Customs’ (HMRC) Pay As You Earn (PAYE), Self-Assessment and the Department for Work and Pensions’ (DWP) benefit systems.

Business Counts (2021) were updated on the 6th of October.

Housing

Council Tax Bands and affected reports have been updated on the 6th of October. Dwelling Types have been published on the 15th of October.

Public Health Outcomes Framework:

The PHOF latest release was updated on the 18th of October. A comprehensive list of all updates is available here.

IA Report Builder 2.2.0 – 15 October 2021 Release Notes

Overview

Report Builder version 2.2.0 fixes a number of bugs and also introduces functionality (beta) to import or link to other reports.

Bug fixes

  • Case sensitivity issue with feature ID field
  • Stacked bar chart with look-down comparison areas shhowing incorrect colours
  • Web map widget – visible layers not acting on raster layers
  • Text widget stripping text following a number (improvement to number formatting)
  • Editing table widget indicator aliases breaks widget height
  • Icon Chart widget height behaviour
  • “Fill to” settings missing from Icon Chart widget
  • Toggler widget not working on a phone screen
  • Report toolbar display issues on a phone screen
  • Commas missing between list of area names (#FNAMES) for aggregated reports

Importing/linking to other reports

It is now possible, for any page in a report, to specify another Report Builder report to import or to link to. This means that one report can be built from others, and that if linking is used, that any changes made to linked reports will automatically feed through to the parent report. This opens the door for a different approach to building and managing reports.

Note that this is beta functionality and we welcome any feedback on how we have implemented this in Report Builder. We created a help page and will be adding further information and examples to this.

To access the option to import or link, edit your report and click Pages > Current Page > Import or Link.

Report Builder option to import or link a report

You will be asked for browse in your ArcGIS Online organisation for a report design to import/link.

Report Builder choose report design option

We hope you will enjoy using this new functionality!

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

IA National Data Service – September 2021 Data Update

Crime

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

Economy & Employment

Claimant Count (August 2021) was last updated on the 14th of September. All affected reports were published by the 16th of September.

The Annual Population Survey (APS) for Apr 2020-Mar 2021 was published on the 17th of September. The APS is a residence-based labour market survey that collects information on 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, this dataset is updated quarterly.

Population

The Population estimates for small area based by single year of age have been updated on the 16th of September. The latest referral year is 2020.

Education

Data from the 2021 School Census was added to the National Data Service on the 7th of September. This release contains information on pupil characteristics including:

    • Free School Meals (FSM) eligibility
    • English as an additional language
    • Ethnicity
    • Special Educational Needs or Education, Health and Care Plan

IA National Data Service – August 2021 Data Update

Crime

June and July 2021 monthly and 12 monthly rolling average data was released both in July. The latest July data update was published on the 31st of August and related reports were published on the 1st of September.

Economy & Employment

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

Deprivation

Fuel Poverty Data for the year 2019/20 was last amended on the 13th of August introducing new Low-Income Low Energy Efficiency (LILEE) metric of fuel poverty that was adopted in the last year of publication.

The sub-regional estimates for 2019 are the first to be published using the LILEE metric. It should be noted these are not directly comparable with previous estimates made for sub-regional fuel poverty under the Low Income High Costs (LIHC) definition. The 2019 LILEE sub-regional fuel poverty model is based on the following seven variables, derived from public and commercial sources:

    • Tenure-owner-occupied, private rented, social rented (Experian)
    • Dwelling age – pre-1919, 1919 to 1944, 1945 to 1980, post-1980 (Experian)
    • Household composition (Experian)
    • Mosaic household classifications by postcode
    • 15 socio-economic groups as detailed in the Mosaic guide4 (Experian)
    • Dwelling type – terraced, detached, semi-detached, bungalow, flat (Experian)
    • Government office region (Experian)
    • Proportion of households with no qualifications per COA (2011 Census)

A household is considered to be fuel poor following the LILEE metric if it is living in a property with an energy efficiency rating of band D, E, F or G as determined by the most up-to-date Fuel Poverty Energy Efficiency Rating (FPEER) Methodology and its disposable income (income after housing costs (AHC) and energy needs) would be below the poverty line.

Please be reminded that fuel poverty is measured based on required energy bills rather than actual spending. This ensures that households that have low energy bills simply because they actively limit their use of energy at home, for example by not heating their home, are not overlooked.

 

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.