Posted By

ChazUK on 02/10/10


Tagged

codes iso area 3166 3166-2 geocodes


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

markgivens


MySQL Table - ISO 3166-2 UK Area Codes and Names


 / Published in: MySQL
 

URL: http://en.allexperts.com/e/i/is/iso_3166-2:gb.htm

It's not exactly the standard table, but it is a direct copy from the 3166-2 GB spec found here http://en.allexperts.com/e/i/is/iso_3166-2:gb.htm

  1. CREATE TABLE IF NOT EXISTS area (
  2. iso CHAR(6) NOT NULL PRIMARY KEY,
  3. name VARCHAR(80) NOT NULL,
  4. );
  5.  
  6. INSERT INTO area VALUES ('GB-ABD','Aberdeenshire');
  7. INSERT INTO area VALUES ('GB-ABE','Aberdeen');
  8. INSERT INTO area VALUES ('GB-AGB','Argyll and Bute');
  9. INSERT INTO area VALUES ('GB-AGY','Isle of Anglesey');
  10. INSERT INTO area VALUES ('GB-ANS','Angus');
  11. INSERT INTO area VALUES ('GB-ANT','Antrim');
  12. INSERT INTO area VALUES ('GB-ARD','Ards');
  13. INSERT INTO area VALUES ('GB-ARM','Armagh');
  14. INSERT INTO area VALUES ('GB-BAS','Bath and North East Somerset (unitary authority)');
  15. INSERT INTO area VALUES ('GB-BBD','Blackburn with Darwen (unitary authority)');
  16. INSERT INTO area VALUES ('GB-BDF','Bedfordshire (county)');
  17. INSERT INTO area VALUES ('GB-BDG','Barking and Dagenham (London borough)');
  18. INSERT INTO area VALUES ('GB-BEN','Brent (London borough)');
  19. INSERT INTO area VALUES ('GB-BEX','Bexley (London borough)');
  20. INSERT INTO area VALUES ('GB-BFS','Belfast');
  21. INSERT INTO area VALUES ('GB-BGE','Bridgend');
  22. INSERT INTO area VALUES ('GB-BGW','Blaenau Gwent');
  23. INSERT INTO area VALUES ('GB-BIR','Birmingham (West Midlands district)');
  24. INSERT INTO area VALUES ('GB-BKM','Buckinghamshire (county)');
  25. INSERT INTO area VALUES ('GB-BLA','Ballymena');
  26. INSERT INTO area VALUES ('GB-BLY','Ballymoney');
  27. INSERT INTO area VALUES ('GB-BMH','Bournemouth (unitary authority)');
  28. INSERT INTO area VALUES ('GB-BNB','Banbridge');
  29. INSERT INTO area VALUES ('GB-BNE','Barnet (London borough)');
  30. INSERT INTO area VALUES ('GB-BNH','Brighton and Hove (unitary authority)');
  31. INSERT INTO area VALUES ('GB-BNS','Barnsley (South Yorkshire district)');
  32. INSERT INTO area VALUES ('GB-BOL','Bolton (Greater Manchester district)');
  33. INSERT INTO area VALUES ('GB-BPL','Blackpool (unitary authority)');
  34. INSERT INTO area VALUES ('GB-BRC','Bracknell Forest (unitary authority)');
  35. INSERT INTO area VALUES ('GB-BRD','Bradford (West Yorkshire district)');
  36. INSERT INTO area VALUES ('GB-BRY','Bromley (London borough)');
  37. INSERT INTO area VALUES ('GB-BST','Bristol, City of (unitary authority)');
  38. INSERT INTO area VALUES ('GB-BUR','Bury (Greater Manchester district)');
  39. INSERT INTO area VALUES ('GB-CAM','Cambridgeshire (county)');
  40. INSERT INTO area VALUES ('GB-CAY','Caerphilly');
  41. INSERT INTO area VALUES ('GB-CGN','Ceredigion');
  42. INSERT INTO area VALUES ('GB-CGV','Craigavon');
  43. INSERT INTO area VALUES ('GB-CHS','Cheshire (county)');
  44. INSERT INTO area VALUES ('GB-CKF','Carrickfergus');
  45. INSERT INTO area VALUES ('GB-CKT','Cookstown');
  46. INSERT INTO area VALUES ('GB-CLD','Calderdale (West Yorkshire district)');
  47. INSERT INTO area VALUES ('GB-CLK','Clackmannanshire');
  48. INSERT INTO area VALUES ('GB-CLR','Coleraine');
  49. INSERT INTO area VALUES ('GB-CMA','Cumbria (county)');
  50. INSERT INTO area VALUES ('GB-CMD','Camden (London borough)');
  51. INSERT INTO area VALUES ('GB-CMN','Carmarthenshire');
  52. INSERT INTO area VALUES ('GB-CON','Cornwall (county)');
  53. INSERT INTO area VALUES ('GB-COV','Coventry (West Midlands district)');
  54. INSERT INTO area VALUES ('GB-CRF','Cardiff');
  55. INSERT INTO area VALUES ('GB-CRY','Croydon (London borough)');
  56. INSERT INTO area VALUES ('GB-CSR','Castlereagh');
  57. INSERT INTO area VALUES ('GB-CWY','Conwy');
  58. INSERT INTO area VALUES ('GB-DAL','Darlington (unitary authority)');
  59. INSERT INTO area VALUES ('GB-DBY','Derbyshire (county)');
  60. INSERT INTO area VALUES ('GB-DEN','Denbighshire');
  61. INSERT INTO area VALUES ('GB-DER','Derby (unitary authority)');
  62. INSERT INTO area VALUES ('GB-DEV','Devon (county)');
  63. INSERT INTO area VALUES ('GB-DGN','Dungannon and South Tyrone');
  64. INSERT INTO area VALUES ('GB-DGY','Dumfries and Galloway');
  65. INSERT INTO area VALUES ('GB-DNC','Doncaster (South Yorkshire district)');
  66. INSERT INTO area VALUES ('GB-DND','Dundee');
  67. INSERT INTO area VALUES ('GB-DOR','Dorset (county)');
  68. INSERT INTO area VALUES ('GB-DOW','Down');
  69. INSERT INTO area VALUES ('GB-DRY','Derry');
  70. INSERT INTO area VALUES ('GB-DUD','Dudley (West Midlands district)');
  71. INSERT INTO area VALUES ('GB-DUR','Durham (county)');
  72. INSERT INTO area VALUES ('GB-EAL','Ealing (London borough)');
  73. INSERT INTO area VALUES ('GB-EAY','East Ayrshire');
  74. INSERT INTO area VALUES ('GB-EDH','Edinburgh');
  75. INSERT INTO area VALUES ('GB-EDU','East Dunbartonshire');
  76. INSERT INTO area VALUES ('GB-ELN','East Lothian');
  77. INSERT INTO area VALUES ('GB-ELS','Eilean Siar');
  78. INSERT INTO area VALUES ('GB-ENF','Enfield (London borough)');
  79. INSERT INTO area VALUES ('GB-ERW','East Renfrewshire');
  80. INSERT INTO area VALUES ('GB-ERY','East Riding of Yorkshire (unitary authority)');
  81. INSERT INTO area VALUES ('GB-ESS','Essex (county)');
  82. INSERT INTO area VALUES ('GB-ESX','East Sussex (county)');
  83. INSERT INTO area VALUES ('GB-FAL','Falkirk');
  84. INSERT INTO area VALUES ('GB-FER','Fermanagh');
  85. INSERT INTO area VALUES ('GB-FIF','Fife');
  86. INSERT INTO area VALUES ('GB-FLN','Flintshire');
  87. INSERT INTO area VALUES ('GB-GAT','Gateshead (Tyne & Wear district)');
  88. INSERT INTO area VALUES ('GB-GLG','Glasgow');
  89. INSERT INTO area VALUES ('GB-GLS','Gloucestershire (county)');
  90. INSERT INTO area VALUES ('GB-GRE','Greenwich (London borough)');
  91. INSERT INTO area VALUES ('GB-GSY','Guernsey');
  92. INSERT INTO area VALUES ('GB-GWN','Gwynedd');
  93. INSERT INTO area VALUES ('GB-HAL','Halton (unitary authority)');
  94. INSERT INTO area VALUES ('GB-HAM','Hampshire (county)');
  95. INSERT INTO area VALUES ('GB-HAV','Havering (London borough)');
  96. INSERT INTO area VALUES ('GB-HCK','Hackney (London borough)');
  97. INSERT INTO area VALUES ('GB-HEF','Herefordshire, County of (unitary authority)');
  98. INSERT INTO area VALUES ('GB-HIL','Hillingdon (London borough)');
  99. INSERT INTO area VALUES ('GB-HLD','Highland');
  100. INSERT INTO area VALUES ('GB-HMF','Hammersmith and Fulham (London borough)');
  101. INSERT INTO area VALUES ('GB-HNS','Hounslow (London borough)');
  102. INSERT INTO area VALUES ('GB-HPL','Hartlepool (unitary authority)');
  103. INSERT INTO area VALUES ('GB-HRT','Hertfordshire (county)');
  104. INSERT INTO area VALUES ('GB-HRW','Harrow (London borough)');
  105. INSERT INTO area VALUES ('GB-HRY','Haringey (London borough)');
  106. INSERT INTO area VALUES ('GB-IOS','Isles of Scilly (special area)');
  107. INSERT INTO area VALUES ('GB-IOW','Isle of Wight (unitary authority)');
  108. INSERT INTO area VALUES ('GB-ISL','Islington (London borough)');
  109. INSERT INTO area VALUES ('GB-IVC','Inverclyde');
  110. INSERT INTO area VALUES ('GB-JSY','Jersey');
  111. INSERT INTO area VALUES ('GB-KEC','Kensington and Chelsea (London borough)');
  112. INSERT INTO area VALUES ('GB-KEN','Kent (county)');
  113. INSERT INTO area VALUES ('GB-KHL','Kingston upon Hull, City of (unitary authority)');
  114. INSERT INTO area VALUES ('GB-KIR','Kirklees (West Yorkshire district)');
  115. INSERT INTO area VALUES ('GB-KTT','Kingston upon Thames (London borough)');
  116. INSERT INTO area VALUES ('GB-KWL','Knowsley (Merseyside district)');
  117. INSERT INTO area VALUES ('GB-LAN','Lancashire (county)');
  118. INSERT INTO area VALUES ('GB-LBH','Lambeth (London borough)');
  119. INSERT INTO area VALUES ('GB-LCE','Leicester (unitary authority)');
  120. INSERT INTO area VALUES ('GB-LDS','Leeds (West Yorkshire district)');
  121. INSERT INTO area VALUES ('GB-LEC','Leicestershire (county)');
  122. INSERT INTO area VALUES ('GB-LEW','Lewisham (London borough)');
  123. INSERT INTO area VALUES ('GB-LIN','Lincolnshire (county)');
  124. INSERT INTO area VALUES ('GB-LIV','Liverpool (Merseyside district)');
  125. INSERT INTO area VALUES ('GB-LMV','Limavady');
  126. INSERT INTO area VALUES ('GB-LND','London, City of (london borough)');
  127. INSERT INTO area VALUES ('GB-LRN','Larne');
  128. INSERT INTO area VALUES ('GB-LSB','Lisburn');
  129. INSERT INTO area VALUES ('GB-LUT','Luton (unitary authority)');
  130. INSERT INTO area VALUES ('GB-MAN','Manchester (Greater Manchester district)');
  131. INSERT INTO area VALUES ('GB-MDB','Middlesbrough (unitary authority)');
  132. INSERT INTO area VALUES ('GB-MDW','Medway (unitary authority)');
  133. INSERT INTO area VALUES ('GB-MFT','Magherafelt');
  134. INSERT INTO area VALUES ('GB-MIK','Milton Keynes (unitary authority)');
  135. INSERT INTO area VALUES ('GB-MLN','Midlothian');
  136. INSERT INTO area VALUES ('GB-MON','Monmouthshire');
  137. INSERT INTO area VALUES ('GB-MRT','Merton (London borough)');
  138. INSERT INTO area VALUES ('GB-MRY','Moray');
  139. INSERT INTO area VALUES ('GB-MTY','Merthyr Tydfil');
  140. INSERT INTO area VALUES ('GB-MYL','Moyle');
  141. INSERT INTO area VALUES ('GB-NAY','North Ayrshire');
  142. INSERT INTO area VALUES ('GB-NBL','Northumberland (county)');
  143. INSERT INTO area VALUES ('GB-NDN','North Down');
  144. INSERT INTO area VALUES ('GB-NEL','North East Lincolnshire (unitary authority)');
  145. INSERT INTO area VALUES ('GB-NET','Newcastle upon Tyne (Tyne & Wear district)');
  146. INSERT INTO area VALUES ('GB-NFK','Norfolk (county)');
  147. INSERT INTO area VALUES ('GB-NGM','Nottingham (unitary authority)');
  148. INSERT INTO area VALUES ('GB-NLK','North Lanarkshire');
  149. INSERT INTO area VALUES ('GB-NLN','North Lincolnshire (unitary authority)');
  150. INSERT INTO area VALUES ('GB-NSM','North Somerset (unitary authority)');
  151. INSERT INTO area VALUES ('GB-NTA','Newtownabbey');
  152. INSERT INTO area VALUES ('GB-NTH','Northamptonshire (county)');
  153. INSERT INTO area VALUES ('GB-NTL','Neath Port Talbot');
  154. INSERT INTO area VALUES ('GB-NTT','Nottinghamshire (county)');
  155. INSERT INTO area VALUES ('GB-NTY','North Tyneside (Tyne & Wear district)');
  156. INSERT INTO area VALUES ('GB-NWM','Newham (London borough)');
  157. INSERT INTO area VALUES ('GB-NWP','Newport');
  158. INSERT INTO area VALUES ('GB-NYK','North Yorkshire (county)');
  159. INSERT INTO area VALUES ('GB-NYM','Newry and Mourne');
  160. INSERT INTO area VALUES ('GB-OLD','Oldham (Greater Manchester district)');
  161. INSERT INTO area VALUES ('GB-OMH','Omagh');
  162. INSERT INTO area VALUES ('GB-ORK','Orkney Islands');
  163. INSERT INTO area VALUES ('GB-OXF','Oxfordshire (county)');
  164. INSERT INTO area VALUES ('GB-PEM','Pembrokeshire');
  165. INSERT INTO area VALUES ('GB-PKN','Perth and Kinross');
  166. INSERT INTO area VALUES ('GB-PLY','Plymouth (unitary authority)');
  167. INSERT INTO area VALUES ('GB-POL','Poole (unitary authority)');
  168. INSERT INTO area VALUES ('GB-POR','Portsmouth (unitary authority)');
  169. INSERT INTO area VALUES ('GB-POW','Powys');
  170. INSERT INTO area VALUES ('GB-PTE','Peterborough (unitary authority)');
  171. INSERT INTO area VALUES ('GB-RCC','Redcar and Cleveland (unitary authority)');
  172. INSERT INTO area VALUES ('GB-RCH','Rochdale (Greater Manchester district)');
  173. INSERT INTO area VALUES ('GB-RCT','Rhondda Cynon Taf');
  174. INSERT INTO area VALUES ('GB-RDB','Redbridge (London borough)');
  175. INSERT INTO area VALUES ('GB-RDG','Reading (unitary authority)');
  176. INSERT INTO area VALUES ('GB-RFW','Renfrewshire');
  177. INSERT INTO area VALUES ('GB-RIC','Richmond upon Thames (London borough)');
  178. INSERT INTO area VALUES ('GB-ROT','Rotherham (South Yorkshire district)');
  179. INSERT INTO area VALUES ('GB-RUT','Rutland (unitary authority)');
  180. INSERT INTO area VALUES ('GB-SAW','Sandwell (West Midlands district)');
  181. INSERT INTO area VALUES ('GB-SAY','South Ayrshire');
  182. INSERT INTO area VALUES ('GB-SCB','Scottish Borders, The');
  183. INSERT INTO area VALUES ('GB-SFK','Suffolk (county)');
  184. INSERT INTO area VALUES ('GB-SFT','Sefton (Merseyside district)');
  185. INSERT INTO area VALUES ('GB-SGC','South Gloucestershire (unitary authority)');
  186. INSERT INTO area VALUES ('GB-SHF','Sheffield (South Yorkshire district)');
  187. INSERT INTO area VALUES ('GB-SHN','St Helens (Merseyside district)');
  188. INSERT INTO area VALUES ('GB-SHR','Shropshire (county)');
  189. INSERT INTO area VALUES ('GB-SKP','Stockport (Greater Manchester district)');
  190. INSERT INTO area VALUES ('GB-SLF','Salford (Greater Manchester district)');
  191. INSERT INTO area VALUES ('GB-SLG','Slough (unitary authority)');
  192. INSERT INTO area VALUES ('GB-SLK','South Lanarkshire');
  193. INSERT INTO area VALUES ('GB-SND','Sunderland (Tyne & Wear district)');
  194. INSERT INTO area VALUES ('GB-SOL','Solihull (West Midlands district)');
  195. INSERT INTO area VALUES ('GB-SOM','Somerset (county)');
  196. INSERT INTO area VALUES ('GB-SOS','Southend-on-Sea (unitary authority)');
  197. INSERT INTO area VALUES ('GB-SRY','Surrey (county)');
  198. INSERT INTO area VALUES ('GB-STB','Strabane');
  199. INSERT INTO area VALUES ('GB-STE','Stoke-on-Trent (unitary authority)');
  200. INSERT INTO area VALUES ('GB-STG','Stirling');
  201. INSERT INTO area VALUES ('GB-STH','Southampton (unitary authority)');
  202. INSERT INTO area VALUES ('GB-STN','Sutton (London borough)');
  203. INSERT INTO area VALUES ('GB-STS','Staffordshire (county)');
  204. INSERT INTO area VALUES ('GB-STT','Stockton-on-Tees (unitary authority)');
  205. INSERT INTO area VALUES ('GB-STY','South Tyneside (Tyne & Wear district)');
  206. INSERT INTO area VALUES ('GB-SWA','Swansea');
  207. INSERT INTO area VALUES ('GB-SWD','Swindon (unitary authority)');
  208. INSERT INTO area VALUES ('GB-SWK','Southwark (London borough)');
  209. INSERT INTO area VALUES ('GB-TAM','Tameside (Greater Manchester district)');
  210. INSERT INTO area VALUES ('GB-TFW','Telford and Wrekin (unitary authority)');
  211. INSERT INTO area VALUES ('GB-THR','Thurrock (unitary authority)');
  212. INSERT INTO area VALUES ('GB-TOB','Torbay (unitary authority)');
  213. INSERT INTO area VALUES ('GB-TOF','Torfaen');
  214. INSERT INTO area VALUES ('GB-TRF','Trafford (Greater Manchester district)');
  215. INSERT INTO area VALUES ('GB-TWH','Tower Hamlets (London borough)');
  216. INSERT INTO area VALUES ('GB-VGL','Vale of Glamorgan');
  217. INSERT INTO area VALUES ('GB-WAR','Warwickshire (county)');
  218. INSERT INTO area VALUES ('GB-WBK','West Berkshire (unitary authority)');
  219. INSERT INTO area VALUES ('GB-WDU','West Dunbartonshire');
  220. INSERT INTO area VALUES ('GB-WFT','Waltham Forest (London borough)');
  221. INSERT INTO area VALUES ('GB-WGN','Wigan (Greater Manchester district)');
  222. INSERT INTO area VALUES ('GB-WIL','Wiltshire (county)');
  223. INSERT INTO area VALUES ('GB-WKF','Wakefield (West Yorkshire district)');
  224. INSERT INTO area VALUES ('GB-WLL','Walsall (West Midlands district)');
  225. INSERT INTO area VALUES ('GB-WLN','West Lothian');
  226. INSERT INTO area VALUES ('GB-WLV','Wolverhampton (West Midlands district)');
  227. INSERT INTO area VALUES ('GB-WND','Wandsworth (London borough)');
  228. INSERT INTO area VALUES ('GB-WNM','Windsor and Maidenhead (unitary authority)');
  229. INSERT INTO area VALUES ('GB-WOK','Wokingham (unitary authority)');
  230. INSERT INTO area VALUES ('GB-WOR','Worcestershire (county)');
  231. INSERT INTO area VALUES ('GB-WRL','Wirral (Merseyside district)');
  232. INSERT INTO area VALUES ('GB-WRT','Warrington (unitary authority)');
  233. INSERT INTO area VALUES ('GB-WRX','Wrexham');
  234. INSERT INTO area VALUES ('GB-WSM','Westminster (London borough)');
  235. INSERT INTO area VALUES ('GB-WSX','West Sussex (county)');
  236. INSERT INTO area VALUES ('GB-YOR','York (unitary authority)');
  237. INSERT INTO area VALUES ('GB-ZET','Shetland Islands');

Report this snippet  

You need to login to post a comment.