A best-fit lookup between postcodes, frozen 2011 Census Output Areas (OA), Lower Layer Super Output Areas (LSOA), Middle Layer Super Output Areas (MSOA) and current local authority districts (LAD) as at May 2022 in the UK. Postcodes are best-fitted by plotting the location of the postcode's mean address into the areas of the output geographies. (File size 24 MB).Field Names - PCD7, PCD8, PCDS, DOINTR, DOTERM, USERTYPE, OA11CD, LSOA11CD, MSOA11CD, LADCD, LSOA11NM, MSOA11NM, LADNM, LADNMWField Types - All TextField Lengths - 7, 8, 8, 8, 8, 1, 9, 9, 9, 9, 55, 65, 45, 45

Introduction Volume of Domestic Low Carbon Technologies (LCT) for both generation and demand (under 1MW) connected.

Methodological ApproachLCT application data (which captures, amongst other things, the location, LCT type, and capacity) is taken from our Smart Connect portal at https://www.ukpowernetworks.co.uk/smart-connect;

Using the Postcode of the MPAN (Meter Point Administration Number), we map the data to LSOA using Office for National Statistics datasets which are updated annuallyContains lower layer super output area (LSOA) codes and name data sourced from the Office for National Statistics licensed under the Open Government Licence v.3.0

Quality Control Statement Quality Control Measures include a manual review and correction of data inconsistencies.

Assurance Statement The Open Data Team has checked to ensure data accuracy and consistency.

Other Download dataset information: Metadata (JSON) Definitions of key terms related to this dataset can be found in the Open Data Portal Glossary: Open Data Portal GlossaryTo view this data please register and login.

This file contains the names and codes for 2021 Census Lower layer Super Output Areas (LSOA) in England and Wales as at 31 December 2021 (File Size 3.2 MB).Field Names - LSOA21CD, LSOA21NM, LSOA21NMWField Types - Text, Text, TextField Lengths - 9, 40, 29

A lookup between the 2011 Lower Layer Super Output Areas (LSOAs) and travel to work areas (TTWAs) in the UK as at 31 December 2011 (File Size 7MB).NBFile updated to include corrected LSOA11 names - the LSOA codes unaffectedREST URL of Feature Access Service – https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/LSOA11_TTWA11_UK_LU_04a063122da94a2c9bc94bcef63866aa/FeatureServer

A lookup between the 2011 Lower Layer Super Output Areas (LSOAs) and Travel to Work Areas (TTWAs) in the UK as at 31 December 2011 (File Size 7MB).NBFile updated to include corrected LSOA11 names - the LSOA codes unaffected

Proportion of households within each Lower layer Super Output Area (LSOA) that responded to the census online along with the LSOA codes and names, local authority codes and names, country name, paper first flag .

This layer explores the spatial relationship between accessibility of green spaces (measured as % LSOA covered by the respective green spaces and their ANGSt buffer) across the range of ANGSt Benchmarks and compares with one other variable.

          Attribute information in this layer can be found on
            Deprivation – as measured by the Index of Multiple Deprivation (MHCLG 2019)
            Population Density – Derived from ONS Census 2011In this system L, M and H refer to low, medium and high for the 

percentage of the LSOA that is covered by the green spaces and their respective buffers. The thresholds used are:

            L = Less than 5% coverage
            M = 5% to under 50%
            H = 50 % and over


            Codes 1, 2 and 3 are the relative bands for the other assessment variable.

          For IMD the thresholds are:

            1 = IMD decile 1 and 2 (Most deprived)
            2 = IMD deciles 3 to 8
            3 = IMD deciles 9 and 10 (least deprived)

          For population density the thresholds are:

            1 = Population 10,000 people per square kilometre and above
            2 – Population between 2500 and 10,000 people per square kilometre
            3 = Population under 2500 people per square kilometre


            The "Access to Natural Green Space 

Inequalities" maps only look at those green spaces that were used to run the England ANGSt analysis and were done only at LSOA level.

          LSOA may contain other green spaces whose presence will not be picked up

in this assessment. Refer to Natural England's user guide for more information on how this layer has been constructed https://designatedsites.naturalengland.org.uk/GreenInfrastructure/UserGuide/Section03.aspx#inequalities-angs

This file contains the names and codes for 2011 Census Lower Layer Super Output Areas (LSOA) in England and Wales as at 31 December 2011 (File Size 1MB).REST URL of Feature Access Service – https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/LSOA_2011_EW_NC_6fe4968cc083413988b2c5d643e1d248/FeatureServer

Data OriginSamples were taken from customer taps. They were then analysed, and the results were uploaded to a sampling system. Sample results are then validated and submitted to the DWI each month. This is a yearly rolled up version of these extracts. Data TriageWe discussed:Whether to use individual samples or averagesWhat date range would be appropriate for MVPHow best to anonymise the data geographicallyPreferred: Geospatial to LSOADo geospatial join to find the LSOA that each customer sample location (within whatever coordinate system you have them as) is found withinAcceptable for MVP: Postcode to LSOAJoin ONS dataset on postcode, keep LSOA code fieldWhy is Geospatial to LSOA preferred? Because it is more accurate since the postcode mapping is best fitted by plotting the location of the postcode's mean address rather than sample point’s specific location.Supplementary information Below is a curated selection of links for additional reading, which provide a deeper understanding of this dataset. Drinking Water Inspectorate Standards and Regulations: https://www.dwi.gov.uk/drinking-water-standards-and-regulations/ LSOA (England and Wales) and Data Zone (Scotland): https://www.nrscotland.gov.uk/files/geography/2011-census/geography-bckground-info-comparison-of-thresholds.pdfDescription for LSOA boundaries by the ONS: https://www.ons.gov.uk/methodology/geography/ukgeographies/censusgeographies/census2021geographiesPostcode to LSOA lookup tables: https://geoportal.statistics.gov.uk/datasets/postcode-to-2021-census-output-area-to-lower-layer-super-output-area-to-middle-layer-super-output-area-to-local-authority-district-august-2023-lookup-in-the-uk/aboutLegislation history:https://www.dwi.gov.uk/water-companies/legislation/Check My Area Tool:Northumbrian Water - https://www.nwl.co.uk/check-your-area/Essex and Suffolk Water - https://www.eswater.co.uk/check-your-area/Example Water Quality Info Sheet

A best fit lookup between lower layer super output areas as at December 2001 and lower layer super output areas and local authority districts as at December 2011 in England and Wales. This product has been provided with a 'change indicator' field, that define the lookup between 2001 and 2011 LSOA. This field indicates which output areas / super output areas have changed between 2001 and 2011. There are four designated categories to describe the changes, and these are as follows: - U - No Change from 2001 to 2011. This means that direct comparisons can be made between these 2001 and 2011 LSOA. - S - Split. This means that the 2001 LSOA has been split into two or more 2011 LSOA. There will be one record for each of the 2011 LSOA that the 2001 LSOA has been split into. This means direct comparisons can be made between estimates for the single 2001 LSOA and the estimates from the aggregated 2011 LSOA. - M - Merged. 2001 LSOA have been merged with another one or more 2001 LSOA to form a single 2011 LSOA. This means direct comparisons can be made between the aggregated 2001 LSOAs’ estimates and the single 2011 LSOA’s estimates. - X - The relationship between 2001 and 2011 LSOA is irregular and fragmented. This has occurred where 2001 LSOA have been redesigned because of local authority district boundary changes, or to improve their social homogeneity. These can’t be easily mapped to equivalent 2011 LSOA like the regular splits (S) and merges (M), and therefore like for like comparisons of estimates for 2001 LSOA and 2011 LSOA are not possible. Each 2001 LSOA with an ‘X’ code is best-fitted to a 2011 LSOA by plotting the 2001 LSOA’s centroid into a 2011 LSOA boundary. However, this does not imply an exclusive 1:1 relationship with a 2011 LSOA, as it will also have a relationship with fragments of other 2011 LSOA; the lookup is provided here so that all 2001 LSOA are included in the lookup (File Size 2.7MB). For more information and an overview of best-fitting follow this link - https://geoportal.statistics.gov.uk/datasets/f0aac7ccbfd04cda9eb03e353c613faa/about REST URL of Feature Access Service – https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/LSOA01_LSOA11_LAD11_EW_LU_ddfe1cd1c2784c9b991cded95bc915a9/FeatureServer

Mid-year (30 June) estimates of the usual resident population for Lower layer Super Output Areas (LSOAs) in England and Wales by single year of age and sex.

This file contains the names and codes for 2001 Census Lower Layer Super Output Areas (LSOA) in Northern Ireland as at 31 December 2001 (File Size 20KB).REST URL of Feature Access Service – https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/LSOA_2001_names_and_codes_NI_as_at_02_05/FeatureServer

Office for National Statistics' national and subnational Census 2021. OccupationThis dataset provides Census 2021 estimates that classify usual residents aged 16 years and over in employment the week before the census in England and Wales by occupation. The estimates are as at Census Day, 21 March 2021. Occupation (current) definition: Classifies what people aged 16 years and over do as their main job. Their job title or details of activities they do in their job and any supervisory or management responsibilities form this classification. This information is used to code responses to an occupation using the Standard Occupational Classification (SOC) 2020.It classifies people who were in employment between 15 March and 21 March 2021, by the SOC code that represents their current occupation.The lowest level of detail available is the four-digit SOC code which includes all codes in three, two and one digit SOC code levels.Quality information: As Census 2021 was during a unique period of rapid change, take care when using this data for planning purposes.Comparability with 2011: Not comparableWe changed the classification for Census 2021 and combined the categories previously available in the 2011 Census data. This data is issued at (BGC) Generalised (20m) boundary type for:Country - England and WalesRegion - EnglandUTLA - England and WalesLTLA - England and WalesWard - England and WalesMSOA - England and WalesLSOA - England and WalesOA - England and WalesIf you require the data at full resolution boundaries, or if you are interested in the range of statistical data that Esri UK make available in ArcGIS Online please enquire at content@esriuk.com.The data services available from this page are derived from the National Data Service. The NDS delivers thousands of open national statistical indicators for the UK as data-as-a-service. Data are sourced from major providers such as the Office for National Statistics, Public Health England and Police UK and made available for your area at standard geographies such as counties, districts and wards and census output areas. This premium service can be consumed as online web services or on-premise for use throughout the ArcGIS system.Read more about the NDS.

A lookup between Output Areas (OA), Lower Layer Super Output Areas (LSOA), Middle Layer Super Output Areas (MSOA), local authority districts (LAD) and Regions as at 31 December 2020 in England and Wales. (File Size 15.3MB).Field Names – OA11CD, LSOA11CD, LSOA11NM, MSOA11CD, MSOA11NM, LAD20CD, LAD20NM, RGN20CD, RGN20NMField Types – Text, Text, Text, Text, Text, Text, Text, Text, Text, TextField Lengths – 9, 9, 33, 9, 32, 9, 36, 9, 24FID = The FID, or Feature ID is created by the publication process when the names and codes / lookup products are published to the Open Geography portal. REST URL of Feature Access Service – https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/OA11_LSOA11_MSOA11_LAD20_RGN20_EW_LU_a1cf695c9b074c708921b2a7555f808a/FeatureServer

Context

London is the capital and most populous city of England and the United Kingdom. Standing on the River Thames in the south east of the island of Great Britain, London has been a major settlement for two millennia. Source: https://en.wikipedia.org/wiki/London

Content

This data counts the number of crimes at two different geographic levels of London (LSOA and borough) by year, according to crime type. Includes data from 2008 to present. Crime categories are included in the BigQuery table description.

Fork this kernel to get started with this dataset.

Acknowledgements

https://data.london.gov.uk/

https://bigquery.cloud.google.com/dataset/bigquery-public-data:london_crime?_ga=2.189454959.-577194880.1523455401

https://console.cloud.google.com/marketplace/details/greater-london-authority/london-crime?filter=category:public-safety

This dataset is publicly available for anyone to use under the following terms provided by the Dataset Source — http://www.data.gov/privacy-policy#data_policy — and is provided "AS IS" without any warranty, express or implied, from Google. Google disclaims all liability for any damages, direct or indirect, resulting from the use of the dataset.

Banner Photo by Luca Micheli from Unplash.

Inspiration

What is the change in the number of crime incidents from 2011 to 2016?

What were the top 3 crimes per borough in 2016?

A lookup between Output Areas (OA), Lower Layer Super Output Areas (LSOA), Middle Layer Super Output Areas (MSOA) and local authority districts (LAD) including OA and LAD classifications as at 31 December 2017 in Great Britain. (File size - 142 MB). Field Names - OA11CD, OAC11CD, OAC11NM, LSOA11CD, LSOA11NM, SOAC11CD, SOAC11NM, MSOA11CD, MSOA11NM, LAD17CD, LAD17NM, LAC11CD, LAC11NM, RGN11CD, RGN11NM, CTRY11CD, CTRY11NMField Types - Text, Text, Text, Text, Text, Text, Text, Text, Text, Text, Text, Text, Text, Text, Text, Text, TextField Lengths - 9, 3, 44, 9, 62, 2, 35, 9, 58, 9, 36, 4, 36, 9, 24, 9, 17This file has been updated to include the SOA classification name and code.REST URL of Feature Access Service – https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/OA11_LSOA11_MSOA11_LAD_GB_LU_classificationv2_d592d853d7394d268aa7c8ecf8854704/FeatureServer

A best fit lookup of output areas, local authority districts, lower layer super output areas, middle layer super output areas to the non-overlapping parts of only those local enterprise partnerships that overlap each other in England as at 1 April 2021. (File size - 3MB)So please be aware that this is not a full coverage lookup. Field Names – OA11CD, LAD21CD, LAD21NM, LSOA11CD, LSOA11NM, MSOA11CD, MSOA11NM, LEPNOP21CD, LEPNOP21NM, FIDField Types – Text, Text, Text, Text, Text, Text, Text, Text, Text, NumberField Lengths – 9, 9, 28, 9, 33, 9, 32, 9, 51FID = The FID, or Feature ID is created by the publication process when the names and codes / lookup products are published to the Open Geography portal. REST URL of Feature Access Service – https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/OA11_LAD21_LSOA11_MSOA11_LEPNOP21_EN_LU_12dd62fe55a04f608e8e7537e5c56c67/FeatureServer

For more information and an overview of best-fitting follow this link - https://geoportal.statistics.gov.uk/datasets/f0aac7ccbfd04cda9eb03e353c613faa/about

The data contains a long-form summary of the number of cars, average age, and average CO2 emissions per km for each year broken down by year, fuel type, and Lower Super Output Area (LSOA). The data covers the years 2001 to 2018 and all LSOAs in England and Wales and Data Zones in Scotland.

Columns

year - integer (2001 - 2018) LSOA - 2011 LSOA Code (England and Wales) or 2011 Data Zone Code (Scotland) or zBetween Keepers or zUnknown or M99999999 (Isle of Mann) fuel - fuel type (DIESEL, PETROL, HYBRID ELECTRIC, OTHER, ELECTRIC DIESEL) AllCars - integer, count of the number of cars (values less than 4 repalced with NA) AvgCO2 - average grammes of CO2 emissions per km AveAge - average age in years

The English Indices of Deprivation 2025 use 54 separate indicators, organised across seven distinct domains of deprivation which can be combined, using appropriate weights, to calculate the Index of Multiple Deprivation 2025 (IMD 2025). This is an overall measure of multiple deprivation experienced by people living in an area and is calculated for every Lower layer Super Output Area (LSOA) in England. The IMD 2025 can be used to rank every LSOA in England according to their relative level of deprivation. It can be calculated to differing geographic boundaries, such as Local Authorities and Health Boards.The data in this file is structured for easier use within a GIS System. Columns in this file are as follows:LSOA21CD (Lower Level Super Output Area Code)LSOA21NM (Lower Level Super Output Area Name)IMDRank (Index of Multiple Deprivation Rank)IMDDecil (Index of Multiple Deprivation Decile)For a more detailed understanding of the value of each of these variables, please visit https://www.gov.uk/government/statistics/english-indices-of-deprivation-2025 for further guidance.