UK Local Authorities (past and current)

Version: 0.1.3. This is not the latest version of this document. See all versions.

Description

A dataset that include current and some past local authorities

Contributors

Licences

Download options

Individual tables

Table: UK Local Authorities (past/current)

Description:

Table of information about local authorities, and mapping between different ID schemes. Includes current and some past authorities.

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
local-authority-code string Fixed ID for council, not linked to boundary changes. Based on old local authorities register. Yes
official-name string Official long name for council (may not *always* be legal name) Yes
nice-name string A shorter name for the council. Yes
gss-code string The code for the statistical geography of the boundaries of the authority No
start-date string The date the authority came into existance (YYYY-MM-DD). Can be blank. No
end-date string The date the authority was abolished (YYYY-MM-DD). Can be blank. No
replaced-by string If the council was abolished a comma seperated list of successor bodies. Comma seperated when there are multiple (rare - when a county council area is divided into two unitaries). No
nation string Nation of the UK (England, Scotland, Wales, Northern Ireland) No Northern Ireland, Scotland, England, Wales
region string English region, but using the nation for non-English authorities. No
local-authority-type string The short-code for type of local authority. No NID, SCO, NMD, WPA, UA, LBO, MD, CTY, COMB, SRA, CC
local-authority-type-name string The name of the type of local authority. No NI district, Scottish unitary authority, Non-metropolitan district, Welsh unitary authority, Unitary authority, London borough, Metropolitan district, County, Combined authority, Strategic Regional Authority, City corporation
county-la string If this council overlaps with a county council, the local-authority-code of this council. Can be none. No
combined-authority string If the council overlaps with a combined authority, the local-authority-code of this council. Can be done. No
alt-names string Comma seperated list of alternative names for a local authority. Yes
former-gss-codes string A list of any gss codes for an area that apply to the former boundaries of a local authority. No
notes string Any notes on columns or values that require special interpretation. No
current-authority boolean a boolean saying if the authority is currently a legal authority (not a past or future authority) No true, false
BS-6879 string A 3-4 letter code for the authority. Substancially the same as local-authority-code, but local-authority-code is now assigned seperately and there may be drift. No
ecode string A code for local authorities used in financial documents. No
even-older-register-and-code string A combination of register and code used in the former official registers. No
gov-uk-slug string A url slug for an authority used by gov.uk No
area number The area of the boundaries of a local authority, in km squared. No
pop-2020 number The estimated number of people living in the local authority in 2020. No
x number X coordinate for the center of the local authority. No
y number Y coordinate for the center of the local authority. No
long number Longitude of the center of the local authority No
lat number Latitude of the center of the local authority No
powers string A grouping of local authority type based on the actual powers of an area (merges several effective 'unitary' categories) No ni district, unitary, lower tier, upper tier, combined
lower-or-unitary boolean Boolean stating if the council is a district (lower tier) or unitary council No true, false
mapit-area-code string Where avaliable, the kind of geography this authority is in mapit. No
ofcom string Variant on snac authority code used in coding survey responses No
old-ons-la-code string Old ONS code for local authorities. No
old-register-and-code string A lookup to the paired register and code on the former register project. No
open-council-data-id number The id used for the council on opencouncildata.co.uk/ No
os-file string Form of name used in some ordnance survey datasets. No
os number Numeric ID assigned by ordnance survey No
snac string Old ONS Standard Names and Codes code No
wdtk-id number ID of authority in WhatDoTheyKnow No

Table: GSS to local authority code lookup

Description:

Dataset that maps current and past gss codes (e.g. E07000239) for an area to the ID for the council.

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
gss-code string Code for the statistical geography of a council. A council may have multiple codes (past and present) as a result of boundary changes. No
local-authority-code string Fixed ID for council, not linked to boundary changes. No

Table: LSOA to local authority code lookup

Description:

Dataset that maps LSOA the ID for the council.

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
lsoa string Small Area - Lower Super Outputer Area (England and Wales), DataZone (Scotland), Super Output Area (NI) Yes
local-authority-code string Fixed ID for council, not linked to boundary changes. No

Table: Name to local authority code lookup

Description:

Dataset that maps variations on a name to the the ID for the council.

Download CSV

Download PARQUET

Data description

Column name Data type Description Unique Required values
la-name string Variations in format and spelling of local authority names. No
local-authority-code string Fixed ID for council, not linked to boundary changes. No

Change log

0.1.3

Mispelled mySociety

0.1.2

Fix item descriptions

0.1.1

description changed from 'A basic description of this dataset ' to 'A dataset that include current and some past local authorities'

0.1.0

Initial commit of new data