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.
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.
Web Map Builder uses smartMapping module(s) from API throughout
Web Map Builder now has a new option to allow proportional symbols for count data (user option). This option is available from the ellipsis menu in the top right corner
Inspector now shows warning messages when Item_Order is missing for an Indicator in the master table
Web Map Builder now handles categoric data gracefully
The Data Catalog Manager pre-checks for new core layers in hosted tables to ensure that updates stay in sync
The Data Catalog Manager disables buttons in the UI that trigger an update whilst another update is still processing
Minor UI cleanup around dialogs and buttons
Bug fixes:
Web Map Builder will now exclude data where all values are null from the map – previously this was causing an error dialog to appear
Web Map Builder how handles Feature Collections properly when opening an existing web map – previously this was generating a JSON error
Metadata page now falls back to using the standard metadata table if there is not one defined within the targeted master table
If you are signed in to ArcGIS Online (i.e. you sign in via the Data Catalog app or the Data Explorer app is launched with a ?token=xxxxxx argument) you will see a View ArcGIS Online Item button displayed under the Data, Map, Time Series or Ranked Bar Chart tabs.
When clicked, the button takes you to the item in ArcGIS Online that contains the data for indicator you are viewing in the data explorer.
This button has been added in order to make it easy to obtain the endpoint of the ArcGIS feature layer containing an indicator from an InstantAtlas data catalog. There are a number of scenarios in which it might be useful to have the endpoint, one being that it enables the use of the data held in the data catalog in other third party systems, such as Microsoft Power BI for example.
Update to sharing/token behaviour
The Data Explorer has been updated so that when it is run in authorised mode (i.e. not shared with everyone) it will pass the token down to all of the feature services it uses. Furthermore, a public-shared Data Explorer will detect whether it needs a sign in for specific feature layers. If the data for the indicator searched for is stored in a feature layer that is protected, the user will be asked to sign in to ArcGIS Online in order to view the indicator in question.
Crime data updated 3 June. All affected reports updated by 4 June.
Claimant count
Claimant count data updated on day of publication 16 June. All affected reports updated by 18 June.
Population estimates
The finalised population estimates were released and checked. Only metadata changes were required – see update for May 2020.
Net Housing Additions
The Net Housing Additions data for 2018-19 was added on 15 June.
Notes
With the COVID response demands reducing and a new member of staff joining the Data team we will be aiming to catch up on non-API data sources over the next couple of months.
We are continuing to add processing improvements into the system. These will be rolling out behind the scenes aimed at improving the speed of data being available in the system and the outputs.
March data available in system from 1 May and all affected reports updated.
Claimant count
Claimant count data updated on day of publication 19 May. Reports followed with all affected reports updated by 25 May.
Population estimates
Provisional Population Estimates for large areas for 2019 were released on 6 May. Generally we avoid provisional data to avoid changing numbers. This was an unusual step on behalf of ONS as part of measures to support the COVID-19 response. We made the data available on the 13 May and updated the affected reports by 15 May. The metadata denoted the provisional nature of the figures. ONS released the final version of the figures on 24 June. The only change from the provisional data was additional data for Northern Ireland so the English National Data Service data was unaffected beyond an update to the metadata.
Version 2.0.1 adds powerful new filtering, user interface improvements and bug fixes.
Enhancements
New functionality to filter features in the active geography using one or more fields in the feature layer. This allows you to filter to the features contained in a larger area (see example given below)
Modal windows now have Apply, Clear and Cancel buttons
Search now launches when user clicks a Go button or hits Enter
Adjustments to size of modal windows and mobile layout
Title and description removed from the list when viewing the Metadata tab (as these are already displayed at the top of the page)
Bug fixes
Search not accepting a space in the search term
Search launching too quickly when typing a term
Filter screen showing incorrect content when the data explorer was set to be filtered to a single root theme in the data catalog (Root Theme ID setting)
Modal window display in Internet Explorer 11
New filtering
Setup
A new configuration setting (Field Filters) has been added that allows the owner of the app to supply a comma-delimited list of filter fields that will be displayed in the data explorer.
Display
The list of field filters is displayed when the user clicks the Filter Settings button in the data explorer. If multiple filter fields have been defined, these will be shown in a drop down menu. If only a single filter field has been defined, this will be shown as text. If a field filter contains the same value for all of the features in the active geography, that field will automatically be hidden from the user.
The end user can select a field to filter the features displayed in the active tab. In the Map tab, the map will automatically zoom to the bounding box of the filtered features. The filter is retained when switching between tabs. In the Time Series tab, the Limit Features button/checkbox will automatically disappear if the number of filtered features is less than 10. The user has the option to perform further filtering to select specific features within the field filter by clicking the Features button.
For example, the Map tab is showing Lower Super Output Areas (LSOAs) for Suffolk County.
The user can filter to the LSOAs in a particular district, for example Ipswich (District=Ipswich). The map automatically zooms to the filtered features.
Switching to the Data tab retains the filter and the table (and the data download) will contain only the LSOAs in Ipswich.
Modal windows
The modal windows in the data explorer have gained Apply, Clear and Cancel buttons to make them more user-friendly.
Claimant Counts for March 2020 with Feb 2020 revision: Released 21 April. On system 21 April. Reports updated.
Annual Population Survey
Annual Population Survey for Jan-19 to Dec-19: Released 21 April. On system 22 April. Reports updated.
Crime
February data released at start of month, March 2020 data released at end of month. March data available in system from 1 May. Reports updated.
Health
Fingertips data has been refreshed across a number of themes. We are aiming to include the Local Health dataset in the next month.
Apprenticeships
Apprenticeship data: Updated with 2018-19 data on 15 April.
Population Estimates
We added the number and percentage of over 70s on 30 March as this is a key COVID response age grouping.
Public Health Outcomes Framework:
The PHOF dataset was updated on 24 Feb with the February data. A change to the processing has led to a number of indicators being reorded. A number of indicators have now been deprecated. These are available in the system but will no longer be updated. We have adjusted the indicator names to include the term DEPRECATED. If you have used these indicators in your reports we advise amending your reports to use the new indicators that will continue to be updated.
Wards
Following discussion with affected customers we are in the process of updating Wards (and other geographies) to the latest boundaries. As there can be a significant delay between new boundaries being released and data being made available for them we will be calculating where possible estimated values for the new areas based on the best fit of smaller geographies. The metadata for affected data will be amended to reflect that the source may be a mixture of published and derived values.
Version 2.0.0 extends the functionality of the data explorer for searching and visualising data in an InstantAtlas data catalog still further by adding powerful charting capabilities and a new redesigned user interface.
Enhancements
Improved interface with tabs to switch between metadata, table, map, time series and ranked bar chart
New charts to visualize indicator data – time series and distribution/ranking
Options to view time series as line, bar or stacked bar chart
Improved mapping functionality – within the app rather than as a separate app – version 4 of JavaScript API replaces version 3
Full control over which features and dates are displayed in the charts and tables
Improved admin/author control over which functionality is available to end users (via ArcGIS Online configure app)
Options to view tabular data in “standard” or “flat” format
Improvements to download of data
Bug fixes
Fixes for bugs when using Internet Explorer 11
Fix for commas in area names breaking data downloads
Other minor bug fixes
Improved user interface
The data explorer has been updated so that all data visualisation options are integrated within the app. Once an indicator has been selected in the data explorer, a series of tabs provide access to the different views:
Metadata: view a description and the full set of metadata for the selected indicator
Table: view the selected indicator for all available features and dates, and download as a CSV file
Map: view the selected indicator as a thematic map with different classifications available including shaded areas and proportional circles
Time Series: view the time series for the selected indicator using a line, bar or stacked bar chart that can be downloaded
Ranked Bar Chart: view a bar chart ranking the features for the selected indicator
Controls
Each view can be customised by the end user via a series of controls located at the top of the tab. These controls are hidden by default but can be displayed by clicking the cog wheel icon.
Select geography menu: use this menu to select from the list of available geographies
Select dates: use these menus to select the range of dates you would like to view data for
Filter features: use this button to access the list of features belonging to the active geography and use the checkboxes to make your selection. Click X to apply the selection.
Table format: choose between Standard and Flat formats for the data
Download: download the data as a CSV file that can be opened in another package such as MS Excel for further analysis.
Table
The table by default will show data for all dates available for the selected indicator, for all of the features in the active geography. The end-user can filter the features and change the date range using the controls above the table. The table can be scrolled if there are too many features/dates to show on the screen. The download button will download the table as a CSV file; only the data showing in the table when the button is clicked will be downloaded.
Map
The map will show data for a single date for the selected indicator, for all of the features in the active geography. The end user can change the geography, select a different available date for the indicator and change the map classification. The map is interactive and can be dragged and zoomed. There are a number of options available from the map area:
Home: return to the default map extent
Export: export the map as an image or a PDF – there are various options to change the layout, or add a title and other text
Basemap: change the basemap for the thematic map
Search: type in the search box to search for a feature in the active geography or a place in the map area
Time Series
The chart will by default show data for all dates for the selected indicator, for up to 10 features in the active geography. The end user can change the date range and filter the features using the controls above the table. They may also click the checkbox to remove the 10 feature limit, although this may create a messy chart depending on the number of features in the active geography. There is a menu to change the type of chart:
Line: a separate line is shown for each feature
Bar: a separate bar is shown for each feature
Stacked bar: one bar is shown for each date and features are stacked
Ranked Bar Chart
The ranked bar chart shows the data for a single date for the selected indicator, with a bar for each feature in the active geography. The end user can change the selected geography, date, filter the features or download the chart as an image.
Metadata
The metadata tab displays the description and the full set of metadata for the selected indicator. This can be download as a CSV file using the download button.
Improved update process for indicators supplied by the InstantAtlas National Data Service but referenced in a customer-managed catalog/master table.
Improved (more fine-grained) error checking in the Inspector tool
New “Repair” functionality in the Inspector tool to allow repair of common errors
Minor UI updates
Bug fixes:
Fixes for issues in the Manager tool that prevented update of InstantAtlas National Data Service indicators and/or caused duplicate indicators and themes in the customer-managed table.