Generate a list of UK authorities

list_counties.sh

rm counties.*
rm *csv

# England ######################################################################
curl -O -J -L https://www.registers.service.gov.uk/registers/local-authority-eng/download-csv

# https://www.datadictionary.nhs.uk/data_dictionary/nhs_business_definitions/l/local_authority_de.asp?
# A Local Authority, in relation to England is:
## a County Council
awk -F',' '$6=="CTY" {print $7}' local-authority-eng.csv >> counties.eng.ls

## a District Council
awk -F',' '$6=="DIS" {print $7}' local-authority-eng.csv >> counties.eng.ls

## a London Borough Council
awk -F',' '$6=="LBO" {print $7}' local-authority-eng.csv >> counties.eng.ls

## the Common Council of the City of London in its capacity as a Local Authority
awk -F',' '$6=="CC" {print $7}' local-authority-eng.csv >> counties.eng.ls

## the Council of the Isles of Scilly
# Included as UA

## a Unitary Authority
awk -F',' '$6=="UA" {print $7}' local-authority-eng.csv >> counties.eng.ls

## add the combined authorities i guess?
awk -F',' '$6=="COMB" {print $7}' local-authority-eng.csv >> counties.eng.ls

sed 's,",,g' counties.eng.ls | sort | uniq | sed 's,^,UK-ENG\t,' > counties.ls 


# Scotland ######################################################################
curl -O -J -L https://www.registers.service.gov.uk/registers/local-authority-sct/download-csv
# All Scottish council areas
awk -F',' '$6=="CA" {print $7}' local-authority-sct.csv >> counties.sct.ls
sed 's,",,g' counties.sct.ls | sort | sed 's,^,UK-SCT\t,' >> counties.ls 


# Wales ########################################################################
curl -O -J -L https://www.registers.service.gov.uk/registers/principal-local-authority/download-csv
# All Welsh PLA
tail -n+2 principal-local-authority.csv | cut -f6 -d',' >> counties.wls.ls
sed 's,",,g' counties.wls.ls | sort | sed 's,^,UK-WLS\t,' >> counties.ls 


# Northern Ireland ############################################################
curl -O -J -L https://www.registers.service.gov.uk/registers/local-authority-nir/download-csv
# 11 NIR districts
tail -n+2 local-authority-nir.csv | awk -F',' '$6 != "" { print $7 }' >> counties.nir.ls
sed 's,",,g' counties.nir.ls | sort | sed 's,^,UK-NIR\t,' >> counties.ls