text: CREATE TABLE subdivision_GB (id VARCHAR(6) NOT NULL, name VARCHAR(255) NOT NULL, level VARCHAR(64) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
  
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-ARD', 'Ard', 'district council area (northern ireland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-ABE', 'Aberdeen', 'council area (scotland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-ABD', 'Aberdeenshire', 'council area (scotland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-ANS', 'Angus', 'council area (scotland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-ANT', 'Antrim', 'district council area (northern ireland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-AGB', 'Argyll and Bute', 'council area (scotland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-ARM', 'Armagh', 'district council area (northern ireland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-BLA', 'Ballymena', 'district council area (northern ireland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-BNS', 'Barnsley', 'metropolitan district');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-BDF', 'Bedfordshire', 'unitary authority');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-BFS', 'Belfast', 'district council area (northern ireland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-BEX', 'Bexley', 'borough');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-BIR', 'Birmingham', 'metropolitan district');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-BPL', 'Blackpool', 'unitary authority');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-BGW', 'Blaenau Gwent', 'unitary authority (wales)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-BOL', 'Bolton', 'metropolitan district');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-BMH', 'Bournemouth', 'unitary authority');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-BRC', 'Bracknell Forest', 'unitary authority');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-BRD', 'Bradford', 'metropolitan district');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-BNH', 'Brighton e Hove', 'unitary authority');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-BST', 'Bristol', 'unitary authority');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-BKM', 'Buckinghamshire', 'two-tier county');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-BUR', 'Bury', 'metropolitan district');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-CAY', 'Caerphilly', 'unitary authority (wales)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-CAM', 'Cambridgeshire', 'two-tier county');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-CMD', 'Camden', 'borough');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-CRF', 'Cardiff', 'unitary authority (wales)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-CHS', 'Cheshire', '');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-CLK', 'Clackmannanshire', 'council area (scotland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-CON', 'Cornualha', 'unitary authority');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-COV', 'Coventry', 'metropolitan district');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-FER', 'Condado de Fermanagh', 'district council area (northern ireland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-CMA', 'Cúmbria', 'two-tier county');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-DAL', 'Darlington', 'unitary authority');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-DER', 'Derby', 'unitary authority');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-DBY', 'Derbyshire', 'two-tier county');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-DRY', 'Derry', 'district council area (northern ireland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-DEV', 'Devon', 'two-tier county');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-DOR', 'Dorset', 'two-tier county');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-DOW', 'Down', 'district council area (northern ireland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-DUD', 'Dudley', 'metropolitan district');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-DGY', 'Dumfries and Galloway', 'council area (scotland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-DND', 'Dundee', 'council area (scotland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-DUR', 'Durham', 'unitary authority');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-EAL', 'Ealing', 'borough');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-EAY', 'East Ayrshire', 'council area (scotland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-EDU', 'East Dunbartonshire', 'council area (scotland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-ELN', 'East Lothian', 'council area (scotland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-ERW', 'East Renfrewshire', 'council area (scotland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-ERY', 'East Riding of Yorkshire', 'unitary authority');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-ESX', 'East Sussex', 'two-tier county');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-EDH', 'Edimburgo', 'council area (scotland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-ENF', 'Enfield', 'borough');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-ESS', 'Essex', 'two-tier county');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-FAL', 'Falkirk', 'council area (scotland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-FIF', 'Fife', 'council area (scotland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-GAT', 'Gateshead', 'metropolitan district');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-GLG', 'Glasgow', 'council area (scotland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-GLS', 'Gloucestershire', 'two-tier county');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-GRE', 'Greenwich', 'borough');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-GWN', 'Gwynedd', 'unitary authority (wales)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-HCK', 'Hackney', 'borough');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-HAM', 'Hampshire', 'two-tier county');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-HRW', 'Harrow', 'borough');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-HPL', 'Hartlepool', 'unitary authority');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-HEF', 'Herefordshire', 'unitary authority');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-HRT', 'Hertfordshire', 'two-tier county');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-HNS', 'Hounslow', 'borough');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-IVC', 'Inverclyde', 'council area (scotland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-HMF', 'Hammersmith e Fulham', 'borough');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-ELS', 'Hébridas Exteriores', 'council area (scotland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-AGY', 'Anglesey', 'unitary authority (wales)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-LND', 'Cidade de Londres', 'city corporation');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-IOW', 'Ilha de Wight', 'unitary authority');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-IOS', 'Ilhas Scilly', '');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-KEN', 'Kent', 'two-tier county');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-KHL', 'Kingston upon Hull', 'unitary authority');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-LBH', 'Lambeth', 'borough');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-LAN', 'Lancashire', 'two-tier county');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-LDS', 'Leeds', 'metropolitan district');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-LCE', 'Leicester', 'unitary authority');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-LEC', 'Leicestershire', 'two-tier county');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-LMV', 'Limavady', 'district council area (northern ireland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-LIN', 'Lincolnshire', 'two-tier county');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-LSB', 'Lisburn', 'district council area (northern ireland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-LIV', 'Liverpool', 'metropolitan district');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-LUT', 'Luton', 'unitary authority');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-MAN', 'Manchester', 'metropolitan district');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-MTY', 'Merthyr Tydfil', 'unitary authority (wales)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-MDB', 'Middlesbrough', 'unitary authority');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-MLN', 'Midlothian', 'council area (scotland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-MIK', 'Milton Keynes', 'unitary authority');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-MON', 'Monmouthshire', 'unitary authority (wales)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-MRY', 'Moray', 'council area (scotland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-NTL', 'Neath Port Talbot', 'unitary authority (wales)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-NET', 'Newcastle upon Tyne', 'metropolitan district');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-NWP', 'Newport', 'unitary authority (wales)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-NFK', 'Norfolk', 'two-tier county');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-NAY', 'North Ayrshire', 'council area (scotland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-NLK', 'North Lanarkshire', 'council area (scotland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-NYK', 'North Yorkshire', 'two-tier county');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-NTH', 'Northamptonshire', 'two-tier county');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-NBL', 'Northumberland', 'unitary authority');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-RIC', 'Richmond upon Thames', 'borough');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-NGM', 'Nottingham', 'unitary authority');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-NTT', 'Nottinghamshire', 'two-tier county');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-OLD', 'Oldham', 'metropolitan district');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-OMH', 'Omagh', 'district council area (northern ireland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-ORK', 'Órcades', 'council area (scotland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-OXF', 'Oxfordshire', 'two-tier county');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-PEM', 'Pembrokeshire', 'unitary authority (wales)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-PKN', 'Perth and Kinross', 'council area (scotland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-PTE', 'Peterborough', 'unitary authority');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-PLY', 'Plymouth', 'unitary authority');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-POL', 'Poole', 'unitary authority');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-POR', 'Portsmouth', 'unitary authority');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-POW', 'Powys', 'unitary authority (wales)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-RDG', 'Reading', 'unitary authority');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-RFW', 'Renfrewshire', 'council area (scotland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-RCH', 'Rochdale', 'metropolitan district');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-RUT', 'Rutland', 'unitary authority');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-SCB', 'Scottish Borders', 'council area (scotland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-SFT', 'Sefton', 'metropolitan district');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-SHF', 'Sheffield', 'metropolitan district');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-ZET', 'Shetland', 'council area (scotland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-SHR', 'Shropshire', 'unitary authority');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-SLG', 'Slough', 'unitary authority');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-SOM', 'Somerset', 'two-tier county');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-SAY', 'South Ayrshire', 'council area (scotland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-SLK', 'South Lanarkshire', 'council area (scotland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-STH', 'Southampton', 'unitary authority');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-SWK', 'Southwark', 'borough');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-STS', 'Staffordshire', 'two-tier county');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-STG', 'Stirling', 'council area (scotland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-SKP', 'Stockport', 'metropolitan district');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-STT', 'Stockton-on-Tees', 'unitary authority');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-STE', 'Stoke-on-Trent', 'unitary authority');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-SFK', 'Suffolk', 'two-tier county');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-SRY', 'Surrey', 'two-tier county');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-STN', 'Sutton', 'borough');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('ENG', 'Inglaterra', 'country');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-TWH', 'Tower Hamlets', 'borough');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('NIR', 'Irlanda do Norte', 'country');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('SCT', 'Escócia', 'country');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-SWA', 'Swansea', 'unitary authority (wales)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-TOF', 'Torfaen', 'unitary authority (wales)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-TRF', 'Trafford', 'metropolitan district');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-WKF', 'Wakefield', 'metropolitan district');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('WLS', 'País de Gales', 'country');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-WLL', 'Walsall', 'metropolitan district');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-WAR', 'Warwickshire', 'two-tier county');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-WDU', 'West Dunbartonshire', 'council area (scotland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-WLN', 'West Lothian', 'council area (scotland)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-WSX', 'West Sussex', 'two-tier county');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-WSM', 'Westminster', 'borough');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-WGN', 'Wigan', 'metropolitan district');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-WIL', 'Wiltshire', 'unitary authority');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-WLV', 'Wolverhampton', 'metropolitan district');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-WOR', 'Worcestershire', 'two-tier county');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-WRX', 'Wrexham', 'unitary authority (wales)');
  INSERT INTO `subdivision_GB` (`id`, `name`, `level`) VALUES ('GB-YOR', 'York', 'unitary authority');
  