This tool gives you direct access to the metrics data powering LG Inform and LG Inform Plus reports. You can construct a custom view of data using any combination of metric types, areas and time periods. To begin, start typing the name of your chosen metric type(s) in the box below, then choose your area(s) and time period(s). Your data view will appear dynamically. You can then download it, insert it into a report or set up a live connection to a Business Information tool. There are many advanced options detailed in our help section.
View detailed helpThis tool lets you construct authorised queries to our API. It will also attempt to render or download (depending on your browser settings) the result of that query. To use it, simply enter the web method name (e.g. metricTypes) and any parameters into the query box. You can see the full list of available methods on the 'Documentation' tab above. You need to be signed in or have a public-private key to use this tool.
View detailed helpOur data tools can help anyone view and download all sorts of local open data and apply some calculated analysis too. It’s ideal if you want to take a deeper look at the data behind LG Inform Plus and use it in your own way.
Before you can use the tools, you’ll need to sign in to your account (local authority staff) or request a security key (developers).
Search our knowledge base to find the help you need.
Download and save this data
Create a permanent url to the data source using a public private key
This links to the data in HTML table format.
This links to the data in JSON table format. This can be used in Power BI.
This link provides a JSON response in an LGA format.
Use these samples in your web applications. Click here for help using the code
jQuery code snippet
To see data you must:
You need to be signed in or to have previously registered and obtained an API key to use the data tool. The image below shows the page using an API key with metrics for working age unemployment for each English local authority for the latest three years.
You can use the links to an HTML table, JSON and CSV downloads to see the live data which can be used your programs and business intelligence tools.
You need to be signed in or to have previously registered and obtained an API key to use the data tool. The image below shows the page using an API key with metrics for the population of each ward in Greater Manchester.
You can use the links to an HTML table, JSON and CSV downloads to see the live data which can be used your programs and business intelligence tools.
You need to be signed in or to have previously registered and obtained an API key to use the data tool. The image below shows the page using an API key with metrics for National Insurance registrations by Medium Super Output Area for Leeds.
You can use the links to an HTML table, JSON and CSV downloads to see the live data which can be used your programs and business intelligence tools.
Returns area types, including detailed area types such as MBC and London borough.
Current user's area type. Requires a call using OAuth to retrieve data.
Area types which have data for a particular metric type and time period.
List of all details for all area types.
Details about a particular area type.
Geographical areas used by LG Inform. Due to the large number of areas an empty call returns no results. Results are limited to first 500 - subsequent results can be found using the "pageNumber" attribute.
The identifier is a GSS code, or comparison group identifier, used to find details about a particular geographical area
Co-ordinates for the minimum and maxim longitude and latitudes for a particular area or group of areas.
The identifier is either a GSS code, or comparison group identifier, and is used to retrieve KML data for the corresponding geographical area(s)
Co-ordinates for the minimum and maxim longitude and latitudes for a particular area or group of areas.
Show all available calculation methods.
Show all properties of available calculation methods.
Show properties of a specified calculation methods.
Show match type for different combinations of numerator and denominator period type.
Show available client applications.
Show available client applications.
Show details of specific client application.
Show types of comparison group available
Show full details of comparison group types available
Show details of a specified comparison group.
Comparison groups are area groupings of different types, such as all district local authorities, or all fire organisations in England. Without parameters, all groups, excluding custom groups, are returned.
Shows comparison groups visible to the current user, including all main groups, non-main groups owned by user's area (e.g. Near neighbours) and custom comparison groups.
A user can create groups of areas that they are interested in. These are called custom comparison groups. The call with no parameters returns the groups for the signed in user.
Create a custom comparison group for a user.
Get a custom comparison groups details.
Delete a users custom comparison group.
Update a specified custom comparison group for a user.
Returns the details for a particular comparison group.
Co-ordinates for the minimum and maxim longitude and latitudes for a particular comparison group.
Returns KML shapes of all areas in a comparison group
Returns table or values to populate a user specified table component. At minimum, 'area', 'metricType' and 'period' parameters are required.
Note that when the denominator metric type uses a different period type from the numerator. The first denominator period that has a "end date" less than the chosen numerator period is used with the denominator metric type.
Returns table or values to populate a user specified table component and includes a regression x1, y1, x2, y2 coordinate for the regression line between each pair of columns. As with /data, at minimum 'area', 'metricType' and 'period' are required. The regression values appear at the end of the data results.
Returns data method results in comma separated values format, compatible with spreadsheet packages such as Excel. This accepts the same parameters as the /data method.
Returns data method results in plain HTML table format. This accepts the same parameters as the /data method.
Returns data method results in JSONP format. This accepts the same parameters as the /data method.
Returns data method results in JSON table format with a different row for each parameter. This accepts the same parameters as the /data method.
The source from which the data used by any related datasets was obtained.
Full details of all sources used by datasets.
Full details of a particular source, using its identifier.
Returns a list of datasets. Only basic details are provided including identifier, label and some others.
Full details of all datasets.
Details about a particular dataset, using its identifier.
Shows the source and calculation steps (if applicable) for a specified metric value.
List of all dimension members. Dimension members are synonymous with circumstances, and dimensions with cirumstance collections, as listed on the standards site. Dimension members may apply to multiple metric types, and each metric type can be related to multiple dimension members. For example the metric type for males aged 0-17 has the dimension members of both male in the gender dimension and 0-17 in the social aervices age bands dimension.
Full details for all dimension members.
Full details for a single dimension member, selected via the identifier.
Groups of related dimension members. Dimensions are synonymous with circumstance collections, as listed on the standards site.
List of all dimensions, giving their full details.
Full details of a single dimension, selected by its identifier.
Default configuration for the text token editor.
List of fields and their default labels.
List of functions available, and associated metadata.
Gives properties of lists and list subsets available through LG Inform Plus standards.
Shows mappings between the specified lists.
Gives full properties of a single list and lists all its items.
Full details of the given list and all its items, including mappings.
Gives full properties of a single list item.
Show details and content of marker groups.
Shows different marker types used in LG Inform, including amenities, service incidents and other miscellaneous markers.
Shows different markers used in LG Inform, including amenities, service incidents and other miscellaneous markers.
Shows marker-related metadata for a given area.
Provides KML map data for the marker points specified.
Provides data for the marker points specified in JSON format.
Provides data for a specific marker.
Returns a list of all measurement units which are used for defining the units used in measures.
Full details of all measurement units.
Returns all details of one measurement unit using the idenitifer of the specified measurement unit.
Returns all measures as they relate to a particular dataset. These are usually split into fairly simple measurement types, such as count, or percentage of population, but can be more complex.
Returns full details of all dataset measures.
Returns all details of one measure, as selected by the identifier.
Show metadata for current version of database.
Metric dimension is a group of metric types having the same dataset, measure and all dimension members except for one dimension. Examples: "Employees - males, permanent by age (count)" "Employees - males, permanent by age (percentage)" ""Employees - by sex (percentage)". A dataset without dimensions has no metric dimensions.
Returns metric dimensions for a particular search term.
Full details of all metric dimensions.
Returns all details of one metric dimension using the identifier of the specified dimension.
Show details of calcuation methods used by a specific metric.
Returns a list of metric types. Only basic details are provided including identifier and label.
Shows metrics used as denominators for a specified area type.
Gives metric descriptions and basic metadata.
Gives description and basic metadata for a single metric.
Show metric types applicable to area types within a given area.
Returns a list of all metric types plus "pseudo" metric types to represent datasets where there is no metric type to represent 100% of the data. Pseudo metric types will be created for e.g. % of population by ethnicity where there is no metric type representing 100%. This method will return for each metric type (real and pseudo):identifier, label, indicator if the metric type is real or pseudo, flag to denote if there is a breakdown.
Search through the metric types.
A feed of metric types with new and changed metric type definitions and/or metric values. Without any parameters, metric types updated last night will be shown
Returns details of a virtual metric type.
Returns details of a specified metric type. Including the latest and earliest period for each area type applicable to the metric type.
Returns basic details of organisations. With no parameters - will return a full list of organisations
Full details of all organisations.
Returns all details of one organisation, using the organisations metacode as an identifier.
Returns all metric types whose value is 2 or more standard deviations from the mean for all English local authorities.
Returns time period types used by the system.
Full details of all time period types used by the system.
Full details of a single specified time period type.
Returns time periods. No parameters returns all available time periods.
Filters time periods by data availability specified in parameters. At minimum a metricType parameter is required.
Full details for all time periods.
Full details of a particular time period.
Extra metrics created to provide totals for dimensions without one
List of full details of available pseudo-metric types.
Details of a single pseudo-metric type.
A generic search for different types of data. As such a type parameter is required to return any results.
Returns a single KML file containing all of the shapes listed.
Shows available marker sources.
Subjects which have associated metric types.
Full details for all subjects, including associated metric types.
Returns subject details, including a flat list of descendant subjects at any level (not just direct children). Every subject in a list includes information about its direct parent/parents. Metric types associated with the specified subject are given. Descandants and parents are sorted in alphabetical order of subject label.
This web method should not be used on its own. Text token web methods retrieve small strings of text which are used to be inserted into reports based on the variables in the parameters.
Returns the number of areas within a selected band.
Text describing if one value is greater than, equal to or less than another. The text is user-defined meaning that synonyms can be used, e.g. higher, identical, lower, etc. Most useful for comparing means, medians, percentages, etc., rather than absolute values or totals, for example, the percentage of pensioners within a ward that live alone compared to those in the country.
A count of the area types in a given bounding area. For example, the number of wards within an authority.
A method for extracting derived values (for example sums, and averages) for a metric type.
The equivalent value in a chosen area of the predominant circumstance collection in the area covered by the report. For example, if the predominant gender in a lower-level area is male, this token can return the equivalent value for males in the region.
Evaluates a text token. The "eval" parameter is the token you want evaluated, and the "area" parameter is the area you are interested in.
Details about a selected metric type. Returns the metric type's title (label) by default but can be configured to return a short title, data source, metric collection, a description of the metric type, its polarity rule or the data it was last updated.
The value of an area's metric displayed as a percentage of another area's value.
The rank of an area within a bounding area for a specified metric type. Defaults to show child area's rank in parent area.
The nth ranked area within a bounding area for a specified metric type. Defaults to show child area's rank in parent area.
The nth ranked label or value of a metric dimension for an area. Most useful for displaying predominant groups. It's easiest to build these tokens using the text token editor.
The nth ranked time period for a specific metric type. Defaults to show child area's rank in parent area.
Chart showing how a metric breaks down within a users area
Map showing how a metric breaks down within a users area
Table showing how a metric breaks down within a users area
The summary value of a metric type for an area type within a bounding area. For example, the mean number of houses in a ward within a chosen region.
Returns the value of a metric type for an area and period. Defaults to the latest figures for the ward.
Full list of all users
Returns details of current user, as identified by OAuth parameters
Return full details from all users.
Returns all details for user as included by user identifier
Returns a grouping of summary or derived value types, such as sum, average, maximum, minimum, and median. Needs at least a group parameter.
Full list of the available summary or derived types.
Details for a specified value type.
