Skip to content

Instantly share code, notes, and snippets.

@eddturtle
Last active June 14, 2017 08:32
Show Gist options
  • Save eddturtle/0e92845f26c5b9d57cfd to your computer and use it in GitHub Desktop.
Save eddturtle/0e92845f26c5b9d57cfd to your computer and use it in GitHub Desktop.
uk + ireland postal counties list (in json, csv, xml)
1 Aberdeenshire
2 Angus
3 Argyll and Bute
4 Bath and North East Somerset
5 Bedfordshire
6 Berkshire
7 Blaenau Gwent
8 Bridgend
9 Buckinghamshire
10 Caerphilly
11 Cambridgeshire
12 Cardiff
13 Carmarthenshire
14 Ceredigion
15 Cheshire
16 City of Bristol
17 Clackmannanshire
18 Cleveland
19 Conwy
20 Cornwall
21 County Antrim
22 County Armagh
23 County Cavan
24 County Cork
25 County Derry
26 County Donegal
27 County Down
28 County Dublin
29 County Durham
30 County Fermanagh
31 County Galway
32 County Kerry
33 County Kildare
34 County Limerick
35 County Londonderry
36 County Louth
37 County Mayo
38 County Meath
39 County Tipperary
40 County Tyrone
41 County Waterford
42 County Wexford
43 County Wicklow
44 Cumbria
45 Denbighshire
46 Derbyshire
47 Devon
48 Dorset
49 Dumfries and Galloway
50 Dundee City
51 Durham
52 East Ayrshire
53 East Dunbartonshire
54 East Lothian
55 East Renfrewshire
56 East Sussex
57 East Yorkshire
58 Edinburgh City
59 Essex
60 Falkirk
61 Fife
62 Flintshire
63 Glasgow City
64 Gloucestershire
65 Greater London
66 Greater Manchester
67 Guernsey
68 Gwynedd
69 Hampshire
70 Herefordshire
71 Hertfordshire
72 Highland
73 Huntingdonshire
74 Inverclyde
75 Inverness Shire
76 Isle of Anglesey
77 Isle of Man
78 Isle of Scilly
79 Isle of Wight
80 Jersey
81 Kent
82 Kinross Shire
83 Lancashire
84 Leicestershire
85 Lincolnshire
86 Merseyside
87 Merthyr Tydfil
88 Middlesex
89 Midlothian
90 Monmouthshire
91 Moray
92 Neath Port Talbot
143 Newcastle upon Tyne
93 Newport
94 Norfolk
95 North Ayrshire
96 North Lanarkshire
97 North Somerset
98 North Yorkshire
99 Northamptonshire
100 Northumberland
101 Nottinghamshire
102 Orkney
103 Orkney Islands
104 Oxfordshire
105 Pembrokeshire
106 Perth & Kinross
107 Powys
108 Renfrewshire
109 Rhondda Cynon Taff
110 Ross Shire
111 Rutland
112 Scottish Borders
113 Shetland
114 Shetland Islands
115 Shropshire
116 Somerset
117 South Ayrshire
118 South Gloucestershire
119 South Humberside
120 South Lanarkshire
121 South Yorkshire
122 Staffordshire
123 Stirling
124 Stirlingshire
125 Suffolk
126 Surrey
127 Swansea
128 Torfaen
129 Tyne and Wear
130 Vale of Glamorgan
131 Warwickshire
132 West Dunbartonshire
133 West Lothian
134 West Midlands
135 West Sussex
136 West Yorkshire
137 Western Isles
138 Wiltshire
139 Wirral
140 Worcestershire
141 Wrexham
142 Yorkshire
[
{
"id": 1,
"name": "Aberdeenshire"
},
{
"id": 2,
"name": "Angus"
},
{
"id": 3,
"name": "Argyll and Bute"
},
{
"id": 4,
"name": "Bath and North East Somerset"
},
{
"id": 5,
"name": "Bedfordshire"
},
{
"id": 6,
"name": "Berkshire"
},
{
"id": 7,
"name": "Blaenau Gwent"
},
{
"id": 8,
"name": "Bridgend"
},
{
"id": 9,
"name": "Buckinghamshire"
},
{
"id": 10,
"name": "Caerphilly"
},
{
"id": 11,
"name": "Cambridgeshire"
},
{
"id": 12,
"name": "Cardiff"
},
{
"id": 13,
"name": "Carmarthenshire"
},
{
"id": 14,
"name": "Ceredigion"
},
{
"id": 15,
"name": "Cheshire"
},
{
"id": 16,
"name": "City of Bristol"
},
{
"id": 17,
"name": "Clackmannanshire"
},
{
"id": 18,
"name": "Cleveland"
},
{
"id": 19,
"name": "Conwy"
},
{
"id": 20,
"name": "Cornwall"
},
{
"id": 21,
"name": "County Antrim"
},
{
"id": 22,
"name": "County Armagh"
},
{
"id": 23,
"name": "County Cavan"
},
{
"id": 24,
"name": "County Cork"
},
{
"id": 25,
"name": "County Derry"
},
{
"id": 26,
"name": "County Donegal"
},
{
"id": 27,
"name": "County Down"
},
{
"id": 28,
"name": "County Dublin"
},
{
"id": 29,
"name": "County Durham"
},
{
"id": 30,
"name": "County Fermanagh"
},
{
"id": 31,
"name": "County Galway"
},
{
"id": 32,
"name": "County Kerry"
},
{
"id": 33,
"name": "County Kildare"
},
{
"id": 34,
"name": "County Limerick"
},
{
"id": 35,
"name": "County Londonderry"
},
{
"id": 36,
"name": "County Louth"
},
{
"id": 37,
"name": "County Mayo"
},
{
"id": 38,
"name": "County Meath"
},
{
"id": 39,
"name": "County Tipperary"
},
{
"id": 40,
"name": "County Tyrone"
},
{
"id": 41,
"name": "County Waterford"
},
{
"id": 42,
"name": "County Wexford"
},
{
"id": 43,
"name": "County Wicklow"
},
{
"id": 44,
"name": "Cumbria"
},
{
"id": 45,
"name": "Denbighshire"
},
{
"id": 46,
"name": "Derbyshire"
},
{
"id": 47,
"name": "Devon"
},
{
"id": 48,
"name": "Dorset"
},
{
"id": 49,
"name": "Dumfries and Galloway"
},
{
"id": 50,
"name": "Dundee City"
},
{
"id": 51,
"name": "Durham"
},
{
"id": 52,
"name": "East Ayrshire"
},
{
"id": 53,
"name": "East Dunbartonshire"
},
{
"id": 54,
"name": "East Lothian"
},
{
"id": 55,
"name": "East Renfrewshire"
},
{
"id": 56,
"name": "East Sussex"
},
{
"id": 57,
"name": "East Yorkshire"
},
{
"id": 58,
"name": "Edinburgh City"
},
{
"id": 59,
"name": "Essex"
},
{
"id": 60,
"name": "Falkirk"
},
{
"id": 61,
"name": "Fife"
},
{
"id": 62,
"name": "Flintshire"
},
{
"id": 63,
"name": "Glasgow City"
},
{
"id": 64,
"name": "Gloucestershire"
},
{
"id": 65,
"name": "Greater London"
},
{
"id": 66,
"name": "Greater Manchester"
},
{
"id": 67,
"name": "Guernsey"
},
{
"id": 68,
"name": "Gwynedd"
},
{
"id": 69,
"name": "Hampshire"
},
{
"id": 70,
"name": "Herefordshire"
},
{
"id": 71,
"name": "Hertfordshire"
},
{
"id": 72,
"name": "Highland"
},
{
"id": 73,
"name": "Huntingdonshire"
},
{
"id": 74,
"name": "Inverclyde"
},
{
"id": 75,
"name": "Inverness Shire"
},
{
"id": 76,
"name": "Isle of Anglesey"
},
{
"id": 77,
"name": "Isle of Man"
},
{
"id": 78,
"name": "Isle of Scilly"
},
{
"id": 79,
"name": "Isle of Wight"
},
{
"id": 80,
"name": "Jersey"
},
{
"id": 81,
"name": "Kent"
},
{
"id": 82,
"name": "Kinross Shire"
},
{
"id": 83,
"name": "Lancashire"
},
{
"id": 84,
"name": "Leicestershire"
},
{
"id": 85,
"name": "Lincolnshire"
},
{
"id": 86,
"name": "Merseyside"
},
{
"id": 87,
"name": "Merthyr Tydfil"
},
{
"id": 88,
"name": "Middlesex"
},
{
"id": 89,
"name": "Midlothian"
},
{
"id": 90,
"name": "Monmouthshire"
},
{
"id": 91,
"name": "Moray"
},
{
"id": 92,
"name": "Neath Port Talbot"
},
{
"id": 143,
"name": "Newcastle upon Tyne"
},
{
"id": 93,
"name": "Newport"
},
{
"id": 94,
"name": "Norfolk"
},
{
"id": 95,
"name": "North Ayrshire"
},
{
"id": 96,
"name": "North Lanarkshire"
},
{
"id": 97,
"name": "North Somerset"
},
{
"id": 98,
"name": "North Yorkshire"
},
{
"id": 99,
"name": "Northamptonshire"
},
{
"id": 100,
"name": "Northumberland"
},
{
"id": 101,
"name": "Nottinghamshire"
},
{
"id": 102,
"name": "Orkney"
},
{
"id": 103,
"name": "Orkney Islands"
},
{
"id": 104,
"name": "Oxfordshire"
},
{
"id": 105,
"name": "Pembrokeshire"
},
{
"id": 106,
"name": "Perth & Kinross"
},
{
"id": 107,
"name": "Powys"
},
{
"id": 108,
"name": "Renfrewshire"
},
{
"id": 109,
"name": "Rhondda Cynon Taff"
},
{
"id": 110,
"name": "Ross Shire"
},
{
"id": 111,
"name": "Rutland"
},
{
"id": 112,
"name": "Scottish Borders"
},
{
"id": 113,
"name": "Shetland"
},
{
"id": 114,
"name": "Shetland Islands"
},
{
"id": 115,
"name": "Shropshire"
},
{
"id": 116,
"name": "Somerset"
},
{
"id": 117,
"name": "South Ayrshire"
},
{
"id": 118,
"name": "South Gloucestershire"
},
{
"id": 119,
"name": "South Humberside"
},
{
"id": 120,
"name": "South Lanarkshire"
},
{
"id": 121,
"name": "South Yorkshire"
},
{
"id": 122,
"name": "Staffordshire"
},
{
"id": 123,
"name": "Stirling"
},
{
"id": 124,
"name": "Stirlingshire"
},
{
"id": 125,
"name": "Suffolk"
},
{
"id": 126,
"name": "Surrey"
},
{
"id": 127,
"name": "Swansea"
},
{
"id": 128,
"name": "Torfaen"
},
{
"id": 129,
"name": "Tyne and Wear"
},
{
"id": 130,
"name": "Vale of Glamorgan"
},
{
"id": 131,
"name": "Warwickshire"
},
{
"id": 132,
"name": "West Dunbartonshire"
},
{
"id": 133,
"name": "West Lothian"
},
{
"id": 134,
"name": "West Midlands"
},
{
"id": 135,
"name": "West Sussex"
},
{
"id": 136,
"name": "West Yorkshire"
},
{
"id": 137,
"name": "Western Isles"
},
{
"id": 138,
"name": "Wiltshire"
},
{
"id": 139,
"name": "Wirral"
},
{
"id": 140,
"name": "Worcestershire"
},
{
"id": 141,
"name": "Wrexham"
},
{
"id": 142,
"name": "Yorkshire"
}
]
$counties = array(
array('id' => '1','name' => 'Aberdeenshire'),
array('id' => '2','name' => 'Angus'),
array('id' => '3','name' => 'Argyll and Bute'),
array('id' => '4','name' => 'Bath and North East Somerset'),
array('id' => '5','name' => 'Bedfordshire'),
array('id' => '6','name' => 'Berkshire'),
array('id' => '7','name' => 'Blaenau Gwent'),
array('id' => '8','name' => 'Bridgend'),
array('id' => '9','name' => 'Buckinghamshire'),
array('id' => '10','name' => 'Caerphilly'),
array('id' => '11','name' => 'Cambridgeshire'),
array('id' => '12','name' => 'Cardiff'),
array('id' => '13','name' => 'Carmarthenshire'),
array('id' => '14','name' => 'Ceredigion'),
array('id' => '15','name' => 'Cheshire'),
array('id' => '16','name' => 'City of Bristol'),
array('id' => '17','name' => 'Clackmannanshire'),
array('id' => '18','name' => 'Cleveland'),
array('id' => '19','name' => 'Conwy'),
array('id' => '20','name' => 'Cornwall'),
array('id' => '21','name' => 'County Antrim'),
array('id' => '22','name' => 'County Armagh'),
array('id' => '23','name' => 'County Cavan'),
array('id' => '24','name' => 'County Cork'),
array('id' => '25','name' => 'County Derry'),
array('id' => '26','name' => 'County Donegal'),
array('id' => '27','name' => 'County Down'),
array('id' => '28','name' => 'County Dublin'),
array('id' => '29','name' => 'County Durham'),
array('id' => '30','name' => 'County Fermanagh'),
array('id' => '31','name' => 'County Galway'),
array('id' => '32','name' => 'County Kerry'),
array('id' => '33','name' => 'County Kildare'),
array('id' => '34','name' => 'County Limerick'),
array('id' => '35','name' => 'County Londonderry'),
array('id' => '36','name' => 'County Louth'),
array('id' => '37','name' => 'County Mayo'),
array('id' => '38','name' => 'County Meath'),
array('id' => '39','name' => 'County Tipperary'),
array('id' => '40','name' => 'County Tyrone'),
array('id' => '41','name' => 'County Waterford'),
array('id' => '42','name' => 'County Wexford'),
array('id' => '43','name' => 'County Wicklow'),
array('id' => '44','name' => 'Cumbria'),
array('id' => '45','name' => 'Denbighshire'),
array('id' => '46','name' => 'Derbyshire'),
array('id' => '47','name' => 'Devon'),
array('id' => '48','name' => 'Dorset'),
array('id' => '49','name' => 'Dumfries and Galloway'),
array('id' => '50','name' => 'Dundee City'),
array('id' => '51','name' => 'Durham'),
array('id' => '52','name' => 'East Ayrshire'),
array('id' => '53','name' => 'East Dunbartonshire'),
array('id' => '54','name' => 'East Lothian'),
array('id' => '55','name' => 'East Renfrewshire'),
array('id' => '56','name' => 'East Sussex'),
array('id' => '57','name' => 'East Yorkshire'),
array('id' => '58','name' => 'Edinburgh City'),
array('id' => '59','name' => 'Essex'),
array('id' => '60','name' => 'Falkirk'),
array('id' => '61','name' => 'Fife'),
array('id' => '62','name' => 'Flintshire'),
array('id' => '63','name' => 'Glasgow City'),
array('id' => '64','name' => 'Gloucestershire'),
array('id' => '65','name' => 'Greater London'),
array('id' => '66','name' => 'Greater Manchester'),
array('id' => '67','name' => 'Guernsey'),
array('id' => '68','name' => 'Gwynedd'),
array('id' => '69','name' => 'Hampshire'),
array('id' => '70','name' => 'Herefordshire'),
array('id' => '71','name' => 'Hertfordshire'),
array('id' => '72','name' => 'Highland'),
array('id' => '73','name' => 'Huntingdonshire'),
array('id' => '74','name' => 'Inverclyde'),
array('id' => '75','name' => 'Inverness Shire'),
array('id' => '76','name' => 'Isle of Anglesey'),
array('id' => '77','name' => 'Isle of Man'),
array('id' => '78','name' => 'Isle of Scilly'),
array('id' => '79','name' => 'Isle of Wight'),
array('id' => '80','name' => 'Jersey'),
array('id' => '81','name' => 'Kent'),
array('id' => '82','name' => 'Kinross Shire'),
array('id' => '83','name' => 'Lancashire'),
array('id' => '84','name' => 'Leicestershire'),
array('id' => '85','name' => 'Lincolnshire'),
array('id' => '86','name' => 'Merseyside'),
array('id' => '87','name' => 'Merthyr Tydfil'),
array('id' => '88','name' => 'Middlesex'),
array('id' => '89','name' => 'Midlothian'),
array('id' => '90','name' => 'Monmouthshire'),
array('id' => '91','name' => 'Moray'),
array('id' => '92','name' => 'Neath Port Talbot'),
array('id' => '143','name' => 'Newcastle upon Tyne'),
array('id' => '93','name' => 'Newport'),
array('id' => '94','name' => 'Norfolk'),
array('id' => '95','name' => 'North Ayrshire'),
array('id' => '96','name' => 'North Lanarkshire'),
array('id' => '97','name' => 'North Somerset'),
array('id' => '98','name' => 'North Yorkshire'),
array('id' => '99','name' => 'Northamptonshire'),
array('id' => '100','name' => 'Northumberland'),
array('id' => '101','name' => 'Nottinghamshire'),
array('id' => '102','name' => 'Orkney'),
array('id' => '103','name' => 'Orkney Islands'),
array('id' => '104','name' => 'Oxfordshire'),
array('id' => '105','name' => 'Pembrokeshire'),
array('id' => '106','name' => 'Perth & Kinross'),
array('id' => '107','name' => 'Powys'),
array('id' => '108','name' => 'Renfrewshire'),
array('id' => '109','name' => 'Rhondda Cynon Taff'),
array('id' => '110','name' => 'Ross Shire'),
array('id' => '111','name' => 'Rutland'),
array('id' => '112','name' => 'Scottish Borders'),
array('id' => '113','name' => 'Shetland'),
array('id' => '114','name' => 'Shetland Islands'),
array('id' => '115','name' => 'Shropshire'),
array('id' => '116','name' => 'Somerset'),
array('id' => '117','name' => 'South Ayrshire'),
array('id' => '118','name' => 'South Gloucestershire'),
array('id' => '119','name' => 'South Humberside'),
array('id' => '120','name' => 'South Lanarkshire'),
array('id' => '121','name' => 'South Yorkshire'),
array('id' => '122','name' => 'Staffordshire'),
array('id' => '123','name' => 'Stirling'),
array('id' => '124','name' => 'Stirlingshire'),
array('id' => '125','name' => 'Suffolk'),
array('id' => '126','name' => 'Surrey'),
array('id' => '127','name' => 'Swansea'),
array('id' => '128','name' => 'Torfaen'),
array('id' => '129','name' => 'Tyne and Wear'),
array('id' => '130','name' => 'Vale of Glamorgan'),
array('id' => '131','name' => 'Warwickshire'),
array('id' => '132','name' => 'West Dunbartonshire'),
array('id' => '133','name' => 'West Lothian'),
array('id' => '134','name' => 'West Midlands'),
array('id' => '135','name' => 'West Sussex'),
array('id' => '136','name' => 'West Yorkshire'),
array('id' => '137','name' => 'Western Isles'),
array('id' => '138','name' => 'Wiltshire'),
array('id' => '139','name' => 'Wirral'),
array('id' => '140','name' => 'Worcestershire'),
array('id' => '141','name' => 'Wrexham'),
array('id' => '142','name' => 'Yorkshire')
);
INSERT INTO `counties` (`id`, `name`) VALUES
(1, 'Aberdeenshire'),
(2, 'Angus'),
(3, 'Argyll and Bute'),
(4, 'Bath and North East Somerset'),
(5, 'Bedfordshire'),
(6, 'Berkshire'),
(7, 'Blaenau Gwent'),
(8, 'Bridgend'),
(9, 'Buckinghamshire'),
(10, 'Caerphilly'),
(11, 'Cambridgeshire'),
(12, 'Cardiff'),
(13, 'Carmarthenshire'),
(14, 'Ceredigion'),
(15, 'Cheshire'),
(16, 'City of Bristol'),
(17, 'Clackmannanshire'),
(18, 'Cleveland'),
(19, 'Conwy'),
(20, 'Cornwall'),
(21, 'County Antrim'),
(22, 'County Armagh'),
(23, 'County Cavan'),
(24, 'County Cork'),
(25, 'County Derry'),
(26, 'County Donegal'),
(27, 'County Down'),
(28, 'County Dublin'),
(29, 'County Durham'),
(30, 'County Fermanagh'),
(31, 'County Galway'),
(32, 'County Kerry'),
(33, 'County Kildare'),
(34, 'County Limerick'),
(35, 'County Londonderry'),
(36, 'County Louth'),
(37, 'County Mayo'),
(38, 'County Meath'),
(39, 'County Tipperary'),
(40, 'County Tyrone'),
(41, 'County Waterford'),
(42, 'County Wexford'),
(43, 'County Wicklow'),
(44, 'Cumbria'),
(45, 'Denbighshire'),
(46, 'Derbyshire'),
(47, 'Devon'),
(48, 'Dorset'),
(49, 'Dumfries and Galloway'),
(50, 'Dundee City'),
(51, 'Durham'),
(52, 'East Ayrshire'),
(53, 'East Dunbartonshire'),
(54, 'East Lothian'),
(55, 'East Renfrewshire'),
(56, 'East Sussex'),
(57, 'East Yorkshire'),
(58, 'Edinburgh City'),
(59, 'Essex'),
(60, 'Falkirk'),
(61, 'Fife'),
(62, 'Flintshire'),
(63, 'Glasgow City'),
(64, 'Gloucestershire'),
(65, 'Greater London'),
(66, 'Greater Manchester'),
(67, 'Guernsey'),
(68, 'Gwynedd'),
(69, 'Hampshire'),
(70, 'Herefordshire'),
(71, 'Hertfordshire'),
(72, 'Highland'),
(73, 'Huntingdonshire'),
(74, 'Inverclyde'),
(75, 'Inverness Shire'),
(76, 'Isle of Anglesey'),
(77, 'Isle of Man'),
(78, 'Isle of Scilly'),
(79, 'Isle of Wight'),
(80, 'Jersey'),
(81, 'Kent'),
(82, 'Kinross Shire'),
(83, 'Lancashire'),
(84, 'Leicestershire'),
(85, 'Lincolnshire'),
(86, 'Merseyside'),
(87, 'Merthyr Tydfil'),
(88, 'Middlesex'),
(89, 'Midlothian'),
(90, 'Monmouthshire'),
(91, 'Moray'),
(92, 'Neath Port Talbot'),
(143, 'Newcastle upon Tyne'),
(93, 'Newport'),
(94, 'Norfolk'),
(95, 'North Ayrshire'),
(96, 'North Lanarkshire'),
(97, 'North Somerset'),
(98, 'North Yorkshire'),
(99, 'Northamptonshire'),
(100, 'Northumberland'),
(101, 'Nottinghamshire'),
(102, 'Orkney'),
(103, 'Orkney Islands'),
(104, 'Oxfordshire'),
(105, 'Pembrokeshire'),
(106, 'Perth & Kinross'),
(107, 'Powys'),
(108, 'Renfrewshire'),
(109, 'Rhondda Cynon Taff'),
(110, 'Ross Shire'),
(111, 'Rutland'),
(112, 'Scottish Borders'),
(113, 'Shetland'),
(114, 'Shetland Islands'),
(115, 'Shropshire'),
(116, 'Somerset'),
(117, 'South Ayrshire'),
(118, 'South Gloucestershire'),
(119, 'South Humberside'),
(120, 'South Lanarkshire'),
(121, 'South Yorkshire'),
(122, 'Staffordshire'),
(123, 'Stirling'),
(124, 'Stirlingshire'),
(125, 'Suffolk'),
(126, 'Surrey'),
(127, 'Swansea'),
(128, 'Torfaen'),
(129, 'Tyne and Wear'),
(130, 'Vale of Glamorgan'),
(131, 'Warwickshire'),
(132, 'West Dunbartonshire'),
(133, 'West Lothian'),
(134, 'West Midlands'),
(135, 'West Sussex'),
(136, 'West Yorkshire'),
(137, 'Western Isles'),
(138, 'Wiltshire'),
(139, 'Wirral'),
(140, 'Worcestershire'),
(141, 'Wrexham'),
(142, 'Yorkshire');
<?xml version="1.0" encoding="utf-8"?>
<pma_xml_export version="1.0" xmlns:pma="http://www.phpmyadmin.net/some_doc_url/">
<!--
- Structure schemas
-->
<pma:structure_schemas>
<pma:database name="pts-watervoles" collation="latin1_swedish_ci" charset="latin1">
<pma:table name="counties">
CREATE TABLE `counties` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=144 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
</pma:table>
</pma:database>
</pma:structure_schemas>
<!--
- Database: 'pts-watervoles'
-->
<database name="pts-watervoles">
<!-- Table counties -->
<table name="counties">
<column name="id">1</column>
<column name="name">Aberdeenshire</column>
</table>
<table name="counties">
<column name="id">2</column>
<column name="name">Angus</column>
</table>
<table name="counties">
<column name="id">3</column>
<column name="name">Argyll and Bute</column>
</table>
<table name="counties">
<column name="id">4</column>
<column name="name">Bath and North East Somerset</column>
</table>
<table name="counties">
<column name="id">5</column>
<column name="name">Bedfordshire</column>
</table>
<table name="counties">
<column name="id">6</column>
<column name="name">Berkshire</column>
</table>
<table name="counties">
<column name="id">7</column>
<column name="name">Blaenau Gwent</column>
</table>
<table name="counties">
<column name="id">8</column>
<column name="name">Bridgend</column>
</table>
<table name="counties">
<column name="id">9</column>
<column name="name">Buckinghamshire</column>
</table>
<table name="counties">
<column name="id">10</column>
<column name="name">Caerphilly</column>
</table>
<table name="counties">
<column name="id">11</column>
<column name="name">Cambridgeshire</column>
</table>
<table name="counties">
<column name="id">12</column>
<column name="name">Cardiff</column>
</table>
<table name="counties">
<column name="id">13</column>
<column name="name">Carmarthenshire</column>
</table>
<table name="counties">
<column name="id">14</column>
<column name="name">Ceredigion</column>
</table>
<table name="counties">
<column name="id">15</column>
<column name="name">Cheshire</column>
</table>
<table name="counties">
<column name="id">16</column>
<column name="name">City of Bristol</column>
</table>
<table name="counties">
<column name="id">17</column>
<column name="name">Clackmannanshire</column>
</table>
<table name="counties">
<column name="id">18</column>
<column name="name">Cleveland</column>
</table>
<table name="counties">
<column name="id">19</column>
<column name="name">Conwy</column>
</table>
<table name="counties">
<column name="id">20</column>
<column name="name">Cornwall</column>
</table>
<table name="counties">
<column name="id">21</column>
<column name="name">County Antrim</column>
</table>
<table name="counties">
<column name="id">22</column>
<column name="name">County Armagh</column>
</table>
<table name="counties">
<column name="id">23</column>
<column name="name">County Cavan</column>
</table>
<table name="counties">
<column name="id">24</column>
<column name="name">County Cork</column>
</table>
<table name="counties">
<column name="id">25</column>
<column name="name">County Derry</column>
</table>
<table name="counties">
<column name="id">26</column>
<column name="name">County Donegal</column>
</table>
<table name="counties">
<column name="id">27</column>
<column name="name">County Down</column>
</table>
<table name="counties">
<column name="id">28</column>
<column name="name">County Dublin</column>
</table>
<table name="counties">
<column name="id">29</column>
<column name="name">County Durham</column>
</table>
<table name="counties">
<column name="id">30</column>
<column name="name">County Fermanagh</column>
</table>
<table name="counties">
<column name="id">31</column>
<column name="name">County Galway</column>
</table>
<table name="counties">
<column name="id">32</column>
<column name="name">County Kerry</column>
</table>
<table name="counties">
<column name="id">33</column>
<column name="name">County Kildare</column>
</table>
<table name="counties">
<column name="id">34</column>
<column name="name">County Limerick</column>
</table>
<table name="counties">
<column name="id">35</column>
<column name="name">County Londonderry</column>
</table>
<table name="counties">
<column name="id">36</column>
<column name="name">County Louth</column>
</table>
<table name="counties">
<column name="id">37</column>
<column name="name">County Mayo</column>
</table>
<table name="counties">
<column name="id">38</column>
<column name="name">County Meath</column>
</table>
<table name="counties">
<column name="id">39</column>
<column name="name">County Tipperary</column>
</table>
<table name="counties">
<column name="id">40</column>
<column name="name">County Tyrone</column>
</table>
<table name="counties">
<column name="id">41</column>
<column name="name">County Waterford</column>
</table>
<table name="counties">
<column name="id">42</column>
<column name="name">County Wexford</column>
</table>
<table name="counties">
<column name="id">43</column>
<column name="name">County Wicklow</column>
</table>
<table name="counties">
<column name="id">44</column>
<column name="name">Cumbria</column>
</table>
<table name="counties">
<column name="id">45</column>
<column name="name">Denbighshire</column>
</table>
<table name="counties">
<column name="id">46</column>
<column name="name">Derbyshire</column>
</table>
<table name="counties">
<column name="id">47</column>
<column name="name">Devon</column>
</table>
<table name="counties">
<column name="id">48</column>
<column name="name">Dorset</column>
</table>
<table name="counties">
<column name="id">49</column>
<column name="name">Dumfries and Galloway</column>
</table>
<table name="counties">
<column name="id">50</column>
<column name="name">Dundee City</column>
</table>
<table name="counties">
<column name="id">51</column>
<column name="name">Durham</column>
</table>
<table name="counties">
<column name="id">52</column>
<column name="name">East Ayrshire</column>
</table>
<table name="counties">
<column name="id">53</column>
<column name="name">East Dunbartonshire</column>
</table>
<table name="counties">
<column name="id">54</column>
<column name="name">East Lothian</column>
</table>
<table name="counties">
<column name="id">55</column>
<column name="name">East Renfrewshire</column>
</table>
<table name="counties">
<column name="id">56</column>
<column name="name">East Sussex</column>
</table>
<table name="counties">
<column name="id">57</column>
<column name="name">East Yorkshire</column>
</table>
<table name="counties">
<column name="id">58</column>
<column name="name">Edinburgh City</column>
</table>
<table name="counties">
<column name="id">59</column>
<column name="name">Essex</column>
</table>
<table name="counties">
<column name="id">60</column>
<column name="name">Falkirk</column>
</table>
<table name="counties">
<column name="id">61</column>
<column name="name">Fife</column>
</table>
<table name="counties">
<column name="id">62</column>
<column name="name">Flintshire</column>
</table>
<table name="counties">
<column name="id">63</column>
<column name="name">Glasgow City</column>
</table>
<table name="counties">
<column name="id">64</column>
<column name="name">Gloucestershire</column>
</table>
<table name="counties">
<column name="id">65</column>
<column name="name">Greater London</column>
</table>
<table name="counties">
<column name="id">66</column>
<column name="name">Greater Manchester</column>
</table>
<table name="counties">
<column name="id">67</column>
<column name="name">Guernsey</column>
</table>
<table name="counties">
<column name="id">68</column>
<column name="name">Gwynedd</column>
</table>
<table name="counties">
<column name="id">69</column>
<column name="name">Hampshire</column>
</table>
<table name="counties">
<column name="id">70</column>
<column name="name">Herefordshire</column>
</table>
<table name="counties">
<column name="id">71</column>
<column name="name">Hertfordshire</column>
</table>
<table name="counties">
<column name="id">72</column>
<column name="name">Highland</column>
</table>
<table name="counties">
<column name="id">73</column>
<column name="name">Huntingdonshire</column>
</table>
<table name="counties">
<column name="id">74</column>
<column name="name">Inverclyde</column>
</table>
<table name="counties">
<column name="id">75</column>
<column name="name">Inverness Shire</column>
</table>
<table name="counties">
<column name="id">76</column>
<column name="name">Isle of Anglesey</column>
</table>
<table name="counties">
<column name="id">77</column>
<column name="name">Isle of Man</column>
</table>
<table name="counties">
<column name="id">78</column>
<column name="name">Isle of Scilly</column>
</table>
<table name="counties">
<column name="id">79</column>
<column name="name">Isle of Wight</column>
</table>
<table name="counties">
<column name="id">80</column>
<column name="name">Jersey</column>
</table>
<table name="counties">
<column name="id">81</column>
<column name="name">Kent</column>
</table>
<table name="counties">
<column name="id">82</column>
<column name="name">Kinross Shire</column>
</table>
<table name="counties">
<column name="id">83</column>
<column name="name">Lancashire</column>
</table>
<table name="counties">
<column name="id">84</column>
<column name="name">Leicestershire</column>
</table>
<table name="counties">
<column name="id">85</column>
<column name="name">Lincolnshire</column>
</table>
<table name="counties">
<column name="id">86</column>
<column name="name">Merseyside</column>
</table>
<table name="counties">
<column name="id">87</column>
<column name="name">Merthyr Tydfil</column>
</table>
<table name="counties">
<column name="id">88</column>
<column name="name">Middlesex</column>
</table>
<table name="counties">
<column name="id">89</column>
<column name="name">Midlothian</column>
</table>
<table name="counties">
<column name="id">90</column>
<column name="name">Monmouthshire</column>
</table>
<table name="counties">
<column name="id">91</column>
<column name="name">Moray</column>
</table>
<table name="counties">
<column name="id">92</column>
<column name="name">Neath Port Talbot</column>
</table>
<table name="counties">
<column name="id">143</column>
<column name="name">Newcastle upon Tyne</column>
</table>
<table name="counties">
<column name="id">93</column>
<column name="name">Newport</column>
</table>
<table name="counties">
<column name="id">94</column>
<column name="name">Norfolk</column>
</table>
<table name="counties">
<column name="id">95</column>
<column name="name">North Ayrshire</column>
</table>
<table name="counties">
<column name="id">96</column>
<column name="name">North Lanarkshire</column>
</table>
<table name="counties">
<column name="id">97</column>
<column name="name">North Somerset</column>
</table>
<table name="counties">
<column name="id">98</column>
<column name="name">North Yorkshire</column>
</table>
<table name="counties">
<column name="id">99</column>
<column name="name">Northamptonshire</column>
</table>
<table name="counties">
<column name="id">100</column>
<column name="name">Northumberland</column>
</table>
<table name="counties">
<column name="id">101</column>
<column name="name">Nottinghamshire</column>
</table>
<table name="counties">
<column name="id">102</column>
<column name="name">Orkney</column>
</table>
<table name="counties">
<column name="id">103</column>
<column name="name">Orkney Islands</column>
</table>
<table name="counties">
<column name="id">104</column>
<column name="name">Oxfordshire</column>
</table>
<table name="counties">
<column name="id">105</column>
<column name="name">Pembrokeshire</column>
</table>
<table name="counties">
<column name="id">106</column>
<column name="name">Perth &amp; Kinross</column>
</table>
<table name="counties">
<column name="id">107</column>
<column name="name">Powys</column>
</table>
<table name="counties">
<column name="id">108</column>
<column name="name">Renfrewshire</column>
</table>
<table name="counties">
<column name="id">109</column>
<column name="name">Rhondda Cynon Taff</column>
</table>
<table name="counties">
<column name="id">110</column>
<column name="name">Ross Shire</column>
</table>
<table name="counties">
<column name="id">111</column>
<column name="name">Rutland</column>
</table>
<table name="counties">
<column name="id">112</column>
<column name="name">Scottish Borders</column>
</table>
<table name="counties">
<column name="id">113</column>
<column name="name">Shetland</column>
</table>
<table name="counties">
<column name="id">114</column>
<column name="name">Shetland Islands</column>
</table>
<table name="counties">
<column name="id">115</column>
<column name="name">Shropshire</column>
</table>
<table name="counties">
<column name="id">116</column>
<column name="name">Somerset</column>
</table>
<table name="counties">
<column name="id">117</column>
<column name="name">South Ayrshire</column>
</table>
<table name="counties">
<column name="id">118</column>
<column name="name">South Gloucestershire</column>
</table>
<table name="counties">
<column name="id">119</column>
<column name="name">South Humberside</column>
</table>
<table name="counties">
<column name="id">120</column>
<column name="name">South Lanarkshire</column>
</table>
<table name="counties">
<column name="id">121</column>
<column name="name">South Yorkshire</column>
</table>
<table name="counties">
<column name="id">122</column>
<column name="name">Staffordshire</column>
</table>
<table name="counties">
<column name="id">123</column>
<column name="name">Stirling</column>
</table>
<table name="counties">
<column name="id">124</column>
<column name="name">Stirlingshire</column>
</table>
<table name="counties">
<column name="id">125</column>
<column name="name">Suffolk</column>
</table>
<table name="counties">
<column name="id">126</column>
<column name="name">Surrey</column>
</table>
<table name="counties">
<column name="id">127</column>
<column name="name">Swansea</column>
</table>
<table name="counties">
<column name="id">128</column>
<column name="name">Torfaen</column>
</table>
<table name="counties">
<column name="id">129</column>
<column name="name">Tyne and Wear</column>
</table>
<table name="counties">
<column name="id">130</column>
<column name="name">Vale of Glamorgan</column>
</table>
<table name="counties">
<column name="id">131</column>
<column name="name">Warwickshire</column>
</table>
<table name="counties">
<column name="id">132</column>
<column name="name">West Dunbartonshire</column>
</table>
<table name="counties">
<column name="id">133</column>
<column name="name">West Lothian</column>
</table>
<table name="counties">
<column name="id">134</column>
<column name="name">West Midlands</column>
</table>
<table name="counties">
<column name="id">135</column>
<column name="name">West Sussex</column>
</table>
<table name="counties">
<column name="id">136</column>
<column name="name">West Yorkshire</column>
</table>
<table name="counties">
<column name="id">137</column>
<column name="name">Western Isles</column>
</table>
<table name="counties">
<column name="id">138</column>
<column name="name">Wiltshire</column>
</table>
<table name="counties">
<column name="id">139</column>
<column name="name">Wirral</column>
</table>
<table name="counties">
<column name="id">140</column>
<column name="name">Worcestershire</column>
</table>
<table name="counties">
<column name="id">141</column>
<column name="name">Wrexham</column>
</table>
<table name="counties">
<column name="id">142</column>
<column name="name">Yorkshire</column>
</table>
</database>
</pma_xml_export>
@elliotwms
Copy link

Where's the JSON Edd?!

@eddturtle
Copy link
Author

Json as requested 😃

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment