CREATE TABLE IF NOT EXISTS counties (
  county_id int(11) NOT NULL auto_increment,
  county_code varchar(32) NOT NULL,
  county_name varchar(32) NOT NULL,
  PRIMARY KEY  (county_id),
  KEY idx_zone_code_zen (county_code)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=91 ;


INSERT INTO counties (county_id, county_code, county_name) VALUES
(1, 'Bedfordshire', 'Bedfordshire'),
(2, 'Berkshire', 'Berkshire'),
(3, 'Buckinghamshire', 'Buckinghamshire'),
(4, 'Cambridgeshire', 'Cambridgeshire'),
(5, 'Cheshire', 'Cheshire'),
(6, 'Cleveland', 'Cleveland'),
(7, 'Cornwall', 'Cornwall'),
(8, 'Cumberland', 'Cumberland'),
(9, 'Derbyshire', 'Derbyshire'),
(10, 'Devon', 'Devon'),
(11, 'Dorset', 'Dorset'),
(12, 'Durham', 'Durham'),
(13, 'Essex', 'Essex'),
(14, 'Gloucestershire', 'Gloucestershire'),
(15, 'Greater London', 'Greater London'),
(16, 'Greater Manchester', 'Greater Manchester'),
(17, 'Hampshire', 'Hampshire'),
(18, 'Herefordshire', 'Herefordshire'),
(19, 'Hertfordshire', 'Hertfordshire'),
(20, 'Huntingdonshire', 'Huntingdonshire'),
(21, 'Kent', 'Kent'),
(22, 'Lancashire', 'Lancashire'),
(23, 'Leicestershire', 'Leicestershire'),
(24, 'Lincolnshire', 'Lincolnshire'),
(25, 'Middlesex', 'Middlesex'),
(26, 'Norfolk', 'Norfolk'),
(27, 'Northamptonshire', 'Northamptonshire'),
(28, 'Northumberland', 'Northumberland'),
(29, 'Nottinghamshire', 'Nottinghamshire'),
(30, 'Oxfordshire', 'Oxfordshire'),
(31, 'Rutland', 'Rutland'),
(32, 'Shropshire', 'Shropshire'),
(33, 'Somerset', 'Somerset'),
(34, 'Staffordshire', 'Staffordshire'),
(35, 'Suffolk', 'Suffolk'),
(36, 'Surrey', 'Surrey'),
(37, 'Sussex', 'Sussex'),
(38, 'Warwickshire', 'Warwickshire'),
(39, 'Westmorland', 'Westmorland'),
(40, 'Wiltshire', 'Wiltshire'),
(41, 'Worcestershire', 'Worcestershire'),
(42, 'Yorkshire', 'Yorkshire'),
(43, 'Anglesey', 'Anglesey'),
(44, 'Brecknockshire', 'Brecknockshire'),
(45, 'Caernarfonshire', 'Caernarfonshire'),
(46, 'Carmarthenshire', 'Carmarthenshire'),
(47, 'Cardiganshire', 'Cardiganshire'),
(48, 'Denbighshire', 'Denbighshire'),
(49, 'Flintshire', 'Flintshire'),
(50, 'Glamorgan', 'Glamorgan'),
(51, 'Merioneth', 'Merioneth'),
(52, 'Monmouthshire', 'Monmouthshire'),
(53, 'Montgomeryshire', 'Montgomeryshire'),
(54, 'Pembrokeshire', 'Pembrokeshire'),
(55, 'Radnorshire', 'Radnorshire'),
(56, 'Aberdeenshire', 'Aberdeenshire'),
(57, 'Angus', 'Angus'),
(58, 'Argyllshire', 'Argyllshire'),
(59, 'Ayrshire', 'Ayrshire'),
(60, 'Banffshire', 'Banffshire'),
(61, 'Berwickshire', 'Berwickshire'),
(62, 'Buteshire', 'Buteshire'),
(63, 'Cromartyshire', 'Cromartyshire'),
(64, 'Caithness', 'Caithness'),
(65, 'Clackmannanshire', 'Clackmannanshire'),
(66, 'Dumfriesshire', 'Dumfriesshire'),
(67, 'Dunbartonshire', 'Dunbartonshire'),
(68, 'East Lothian', 'East Lothian'),
(69, 'Fife', 'Fife'),
(70, 'Inverness-shire', 'Inverness-shire'),
(71, 'Kincardineshire', 'Kincardineshire'),
(72, 'Kinross-shire', 'Kinross-shire'),
(73, 'Kirkcudbrightshire', 'Kirkcudbrightshire'),
(74, 'Lanarkshire', 'Lanarkshire'),
(75, 'Midlothian', 'Midlothian'),
(76, 'Morayshire', 'Morayshire'),
(77, 'Nairnshire', 'Nairnshire'),
(78, 'Orkney', 'Orkney'),
(79, 'Peeblesshire', 'Peeblesshire'),
(80, 'Perthshire', 'Perthshire'),
(81, 'Renfrewshire', 'Renfrewshire'),
(82, 'Ross-shire', 'Ross-shire'),
(83, 'Roxburghshire', 'Roxburghshire'),
(84, 'Selkirkshire', 'Selkirkshire'),
(85, 'Shetland', 'Shetland'),
(86, 'Stirlingshire', 'Stirlingshire'),
(87, 'Sutherland', 'Sutherland'),
(88, 'West Lothian', 'West Lothian'),
(89, 'West Midlands', 'West Midlands'),
(90, 'Wigtownshire', 'Wigtownshire');