Last active
June 14, 2017 08:32
-
-
Save eddturtle/0e92845f26c5b9d57cfd to your computer and use it in GitHub Desktop.
uk + ireland postal counties list (in json, csv, xml)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[ | |
{ | |
"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" | |
} | |
] |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$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') | |
); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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'); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?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 & 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> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Where's the JSON Edd?!