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).

IA National Data Service – July 2022 Update

Population

Census 2021 headline data added – read more here.

Crime

May 2022 monthly and 12 monthly rolling average data were uploaded.

Economy & Employment

Claimant Count (June 2022) was updated.

People in Universal Credit (June 2022) was updated.

Environment

The Waste dataset was updated on the 12th of July.

Housing

The Household Projections dataset was updated on the 15th of July.

The House Prices dataset was updated on 23th of July.

Children and Young People

The Absences dataset was updated on the 29th of July.

IA National Data Service – June 2022 Update

Crime

April 2022 monthly and 12 monthly rolling average data were uploaded.

Economy & Employment

Claimant Count (May 2022) was updated.

People in Universal Credit (May 2022) was updated.

Deprivation

The Fuel Poverty dataset was updated on the 9th of June.

Environment

The Electricity and Gas consumption dataset was updated 9th of June.

IA National Data Service – Census 2021 first results

The first results of Census 2021 were added to the National Data Service on 4th July 2022 and are now available for viewing.

This brand new set of around 140 indicators can be found in the the Population theme, under a Census 2021 subtheme. This dataset combines the first release results for 2021 – available at local authority, region and country level for England and Wales – with the closest equivalent data selected from NOMIS for 2011, 2001 and 1991 to show change over time in the headline data. The population estimates are broken down by sex, broad age group and 5-year age groups.

Note that there may be some differences to the basis on how the values were generated. Note also that this first release data for 2021 gives figures rounded to the nearest 100 – later release will be unrounded and can be expected to show some differences to these figures.

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

1) Population reports for top and lower tier local authorities (updated 7th July 2022)

NDS report with Census 2021 data

2) Population Map Explorer (updated 4th July 2022)

Map Explorer with Census 2021 data

3) Data Explorer (updated 4th July 2022)

Data Explorer with Census 2021 data

We will add further data from Census 2021 to the National Data Service once these have been released. You can read the release plans from ONS for the data here.

IA Report Builder 2.4.0 – 30 June 2022 Release Notes

Overview

In version 2.4.0 of Report Builder we have continued to improve the behaviour of the chart widgets, following an upgrade of the charting library in the 2.3.0 update. We have also made changes to how Report Builder works with ArcGIS Enterprise as the data, storage and authentication platform instead of ArcGIS Online.

New features

Ability to add fixed lines and zones to bar and line charts

Bar and Line charts can now show fixed lines or zones additionally to the displayed indicator(s). You can add up to 4 lines and up to 4 zones to the chart. Each line has it’s own fixed value, label, colour, width and style. For each zone, the start and end value, label, colour and opacity can be defined. Lines and zones can be added to either the x or the y axis allowing for a wide rage of use cases.

Ability to add Mean and/or Median lines to bar charts

You can chose to display the mean and/or median line either superimposed over or behind the bars of your bar chart. The label, line style and colour can be adjusted.

Export/print options for web map widgets

The simple version of exporting a web map widget is by enabling the Export Snapshot Button which will appear at the bottom right of the map. It takes a simple screenshot of the map widget and saves it to your browser’s downloads folder.

The more advanced Print Button allows the user to print the web map into different file formats, providing a range of options for size and layout.

Both these export options are mutually exclusive, meaning the Export Snapshot Button will only show if the Print Button setting is toggled off. Please note that the Print Button is not available for 3D maps.

Improved support for using data in ArcGIS Enterprise

Report Builder already supported the use of ArcGIS Server services where these services have been referenced in ArcGIS Online to make them easier to access and discover. In this update however, we have taken further steps to make it possible to use ArcGIS Enterprise as the data, storage and authentication platform instead of ArcGIS Online.

If you are hosting your own data catalog, and this is the data source for a report, the catalog table (master table) can include URLs to services from ArcGIS Enterprise and Report Builder will request and handle the authentication to these services appropriately. If the items are (semi)private you will be prompted to sign in to see the data in the report, whether you are editing the report or viewing it as an end user. An example of this is shown below.

Report Builder Enterprise Sign In

Failure to sign in as a user with sufficient privileges will mean that any widgets in the report containing private data will not load.

Currently, the data catalog master table itself must be hosted in ArcGIS Online, but this is a step towards alternative deployments where the data catalog as well as the data services are hosted in ArcGIS Enterprise.

If you are interested in using Report Builder with data hosted in ArcGIS Enterprise we would like to know, so please get in touch with your Esri UK account manager.

Series Type of Pie Charts simplified

The setting Series Type for Pie Charts has been removed as it caused confusion. The rules now are:

  • include all areas = true => one “pie” per indicator and each segment corresponds to a feature
  • include all areas = false => one “pie” per feature (i.e. if you use show comparisons = true) and each segment corresponds to an indicator

Further enhancements

  • You can now use the Configure App button within ArcGIS Online to open the edit version of the report.
  • There is now an option to open the metadata pop-up when selecting indicators for text widgets.
  • It is now possible to configure if comparison bars are displayed at the right of all other bars or included in the core feature bar sorting.

Key bug fixes

  • Bar charts showing counts per value for a lower level comparison geography (for example the deprivation charts in our standard National Data Service reports) no longer show the x-axis labels in random order.
  • Bar charts showing one indicator for all areas can again display comparison values as horizontal lines.
  • It is again possible to create a pie chart showing only one percentage indicator value and filling the remaining pie to 100%.
  • Metadata pop-ups in the data selection dialogs as well as in the table now hide empty fields.
  • Time Series Table: Metadata icons are no longer hidden when group-rows-by-indicator is active.
  • Charts are no longer cut off at the bottom if Title Position is set to title-bar.
  • Width and Height settings of widgets are now rounded to full numbers when resizing the widget by dragging the handlers.
  • All infographic widgets now have setting to enable and disable comparison features.
  • Indicator search option within the widget’s Data & Settings dialog is working reliably even for indicators with special characters or multiple whitespaces in the indicator name.

We hope you will enjoy this new release of Report Builder!

If you have any questions relating to this release please contact Esri UK Technical Support. Customers outside of the UK and Ireland please email support@instantatlas.com.

IA National Data Service – May 2022 Update

Crime

March 2022 monthly and 12 monthly rolling average data were uploaded on the 12th of April.

Economy & Employment

Claimant Count (April2022) was last updated on the 17th of May.

People in Universal Credit data for April 2022 is now available on the Data Catalog. The latest release was published on AGOL on the 19th of May.

 

IA Data Explorer 2.1.0 – 10 May 2022 Release Notes

List of changes

Ordering of indicators

We have improved the order in which the Data Explorer will display indicators from the National Data Service on initial load and when it is filtered to a theme (with no search term). Prior to this change, indicators in different themes were ending up with an identical score for the purposes of ordering, which resulted in an illogical and confusing list of indicators from different sub-themes. Where an indicator has supporting indicators (e.g. numerator, denominator, confidence intervals), such as much of the health data in the National Data Service, the supporting indicators are now consistently listed immediately below the main indicator to make it easier to read the list. On initial load, the ONS mid-year population estimates appear first, with the total population at the top of the list.

Table sorting

It is now possible to sort the columns ascending/descending in the table view by clicking on a column heading. The sorting state is maintained even if you switch to view data for a different geography.

Mixed data sources

We have made improvements to the way the Data Explorer works with a data catalog that references ArcGIS Enterprise services as well as services in ArcGIS Online, whether these are public or restricted. This is important for customers that host their own data catalog and wish to incorporate data from a mix of sources.

Custom metadata fields

Again, for customers hosting their own data catalog, any custom/extra fields added to the data catalog metadata table will now be displayed in the Data Explorer (in the Metadata view).

Hiding indicators

There is now a configuration option to hide indicators that do not have an entry in the data catalog metadata table. This can be useful to exclude certain indicators that need to be part of the catalog, but do not need to be listed in the Data Explorer.

Bug fixes

  • Unable to backtrack after insufficient rights to view a restricted indicator
  • ArcGIS Online token included in Share link when viewing a restricted indicator

We hope you will enjoy the new version of Data Explorer!

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

IA National Data Service – April 2022 Update

Crime

February 2022 monthly and 12 monthly rolling average data were uploaded on the 3rd of March.

Economy & Employment

Claimant Count (March 2022) was last updated on the 12th of April.

People in Universal Credit data for March 2022 is now available on the Data Catalog. The latest release was published on AGOL on the 13th of April.

Annual Population Survey – APS – (Jan 2021-Dec 2021) were last updated on the 14th 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.

Health

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

Housing

ONS house pricing has been updated on the 5th of April.

Population

Minor adjustments have been applied to the GLA population estimates. Adjusted figures were made available from the 7th of April. GLA Demography produces a variety of different types of population projections for London area in order to meet the needs of a wide range of users.

 

IA National Data Service – March 2022 Update

Crime

January 2022 monthly and 12 monthly rolling average data were uploaded on the 10th of March. February 2022 data has been updated in the first days of April.

Economy & Employment

Claimant Count (February 2022) was last updated on the 22nd of March.

People in Universal Credit data for February 2022 is now available on the Data Catalog. The latest release was published on AGOL on the 18th of March.

IA National Data Service – February 2022 Update

Crime

January 2022 data was not published during the course of February 2022.

Economy & Employment

Claimant Count (January 2022) was last updated on the 16th of February.

People in Universal Credit data for January 2022 is now available on the Data Catalog. The latest release was published on AGOL on the 17th of February.

Education

Key Stage 4 Results for the academic year 20120/21 were released. This release has kept as the measure in relation to the COVID-19 pandemic as a separate dataset. For 2020/21, pupils were only assessed on the content they had been taught for each course. Schools were given flexibility to decide how to assess their pupils’ performance, for example, through mock exams, class tests, and non-exam assessment already completed. GCSE grades were then determined by teachers based on the range of evidence available and they are referred to as teacher-assessed grades, or TAGs. This is a different process to that of 2019/20 when pupils were awarded either a centre assessment grade (known as CAGs, based on what the school or college believed the pupil would most likely have achieved had exams gone ahead) or their calculated grade using a model developed by Ofqual – whichever was the higher of the two.

The changes to the way GCSE grades have been awarded over the last two years (with CAGs and TAGs replacing exams) mean 2020/21 pupil attainment data should not be directly compared to pupil attainment data from previous years for the purposes of measuring year on year changes in pupil performance.

For additional information, please consult the website:

https://explore-education-statistics.service.gov.uk/find-statistics/key-stage-4-performance-revised/2020-21