Geographies (geographies.csv)
Welcome to geographies.csv
When producing maps using software packages like Power BI, it is often useful to have a single file that combines different permutations of geographies. However, to achieve this using the files on the Open Geography Portal, it would require bringing together many different file types. To make life easier, we have created geographies.csv, which brings together different geographical types into one file. The file is supplied as a comma separated values (csv) file in a consistent location to make it possible for different software applications to all point at the same location.
Original 2019 version of geographies.csv
The original 2019 version of geographies.csv contains all the possible combination of statistical, administrative, health and bespoke geographies that we could think of, including postcodes, GP practices, NHS trusts, 2011 census output areas, 2011 census lower layer super output areas (LSOAs), 2011 census middle layer super output areas (MSOAs), electoral wards, family hubs, clinical commissioning group (CCG) primary care networks (PCNs), combined authorities, regions, and countries. This was developed to meet the needs of the Coventry Joint Strategic Needs Assessment, and powers the Coventry Citywide Intelligence Hub. Where possible, the geographies are mapped to each other so that users can choose any geography, such as a postcode, and see how it fits into any other geography, e.g., a family hub area or a primary care network.
Updated 2022 version of geographies.csv
The refreshed 2022 version is a version of geographies.csv that shows all of the 2021 census lower layer super output areas (LSOAs), 2021 census middle layer super output areas (MSOAs), electoral wards, local authority districts, upper tier local authorities, combined authorities, regions, and countries. It does not, however, contain custom geographies. This version was developed to best meet the needs of mapping following the release of data from the 2021 census.
Coventry postcodes 2024.csv
This is an updated list of Coventry postcodes as of August 2024, with the Coventry geographies / localities in which each are located. It was developed for the purpose of matching postcode areas to statistical and administrative geographies and for creating statistics for such areas using postcode data. It is less comprehensive than geographies.csv but a more up to date list of postcodes in Coventry. It includes all postcodes within Coventry local authority area as taken from the National Statistics Postcode Lookup August 2024, Office for National Statistics, and includes current 'live' postcode areas as well as terminated postcode areas. It includes the 2011 census lower layer super output areas (LSOAs), the 2021 census lower layer super output areas (LSOAs), the 2021 census middle layer super output areas (MSOAs), electoral wards, and Parliamentary Constituencies in which each postcode is located. This matching is done on a 'best-fit' basis. This does not contain custom geographies.
Information about the data in Coventry postcodes 2024.csv:Metadata
Data from Coventry City Council and the Open Geography Portal
Page maintained by Insight Team, Coventry City Council.
Find out more about Coventry information and statistics www.coventry.gov.uk/infoandstats
Privacy notice