insert-counties.sql

INSERT INTO counties(name) VALUES ('Avon');
INSERT INTO counties(name) VALUES ('Bedfordshire');
INSERT INTO counties(name) VALUES ('Berkshire');
INSERT INTO counties(name) VALUES ('Buckinghamshire');
INSERT INTO counties(name) VALUES ('Cambridgeshire');
INSERT INTO counties(name) VALUES ('Cheshire');
INSERT INTO counties(name) VALUES ('Cleveland');
INSERT INTO counties(name) VALUES ('Cornwall');
INSERT INTO counties(name) VALUES ('Cumberland');
INSERT INTO counties(name) VALUES ('Derbyshire');
INSERT INTO counties(name) VALUES ('Devon');
INSERT INTO counties(name) VALUES ('Dorset');
INSERT INTO counties(name) VALUES ('Durham');
INSERT INTO counties(name) VALUES ('Essex');
INSERT INTO counties(name) VALUES ('Gloucestershire');
INSERT INTO counties(name) VALUES ('Greater London');
INSERT INTO counties(name) VALUES ('Greater Manchester');
INSERT INTO counties(name) VALUES ('Hampshire');
INSERT INTO counties(name) VALUES ('Herefordshire');
INSERT INTO counties(name) VALUES ('Hertfordshire');
INSERT INTO counties(name) VALUES ('Huntingdonshire');
INSERT INTO counties(name) VALUES ('Kent');
INSERT INTO counties(name) VALUES ('Lancashire');
INSERT INTO counties(name) VALUES ('Leicestershire');
INSERT INTO counties(name) VALUES ('Lincolnshire');
INSERT INTO counties(name) VALUES ('Middlesex');
INSERT INTO counties(name) VALUES ('Norfolk');
INSERT INTO counties(name) VALUES ('Northamptonshire');
INSERT INTO counties(name) VALUES ('Northumberland');
INSERT INTO counties(name) VALUES ('Nottinghamshire');
INSERT INTO counties(name) VALUES ('Oxfordshire');
INSERT INTO counties(name) VALUES ('Rutland');
INSERT INTO counties(name) VALUES ('Shropshire');
INSERT INTO counties(name) VALUES ('Somerset');
INSERT INTO counties(name) VALUES ('Staffordshire');
INSERT INTO counties(name) VALUES ('Suffolk');
INSERT INTO counties(name) VALUES ('Surrey');
INSERT INTO counties(name) VALUES ('Sussex');
INSERT INTO counties(name) VALUES ('Warwickshire');
INSERT INTO counties(name) VALUES ('Westmorland');
INSERT INTO counties(name) VALUES ('Wiltshire');
INSERT INTO counties(name) VALUES ('Worcestershire');
INSERT INTO counties(name) VALUES ('Yorkshire');
INSERT INTO counties(name) VALUES ('Anglesey');
INSERT INTO counties(name) VALUES ('Brecknockshire');
INSERT INTO counties(name) VALUES ('Caernarfonshire');
INSERT INTO counties(name) VALUES ('Carmarthenshire');
INSERT INTO counties(name) VALUES ('Cardiganshire');
INSERT INTO counties(name) VALUES ('Denbighshire');
INSERT INTO counties(name) VALUES ('Flintshire');
INSERT INTO counties(name) VALUES ('Glamorgan');
INSERT INTO counties(name) VALUES ('Merioneth');
INSERT INTO counties(name) VALUES ('Monmouthshire');
INSERT INTO counties(name) VALUES ('Montgomeryshire');
INSERT INTO counties(name) VALUES ('Pembrokeshire');
INSERT INTO counties(name) VALUES ('Radnorshire');
INSERT INTO counties(name) VALUES ('Aberdeenshire');
INSERT INTO counties(name) VALUES ('Angus');
INSERT INTO counties(name) VALUES ('Argyllshire');
INSERT INTO counties(name) VALUES ('Ayrshire');
INSERT INTO counties(name) VALUES ('Banffshire');
INSERT INTO counties(name) VALUES ('Berwickshire');
INSERT INTO counties(name) VALUES ('Buteshire');
INSERT INTO counties(name) VALUES ('Cromartyshire');
INSERT INTO counties(name) VALUES ('Caithness');
INSERT INTO counties(name) VALUES ('Clackmannanshire');
INSERT INTO counties(name) VALUES ('Dumfriesshire');
INSERT INTO counties(name) VALUES ('Dunbartonshire');
INSERT INTO counties(name) VALUES ('East Lothian');
INSERT INTO counties(name) VALUES ('Fife');
INSERT INTO counties(name) VALUES ('Inverness-shire');
INSERT INTO counties(name) VALUES ('Kincardineshire');
INSERT INTO counties(name) VALUES ('Kinross-shire');
INSERT INTO counties(name) VALUES ('Kirkcudbrightshire');
INSERT INTO counties(name) VALUES ('Lanarkshire');
INSERT INTO counties(name) VALUES ('Midlothian');
INSERT INTO counties(name) VALUES ('Morayshire');
INSERT INTO counties(name) VALUES ('Nairnshire');
INSERT INTO counties(name) VALUES ('Orkney');
INSERT INTO counties(name) VALUES ('Peeblesshire');
INSERT INTO counties(name) VALUES ('Perthshire');
INSERT INTO counties(name) VALUES ('Renfrewshire');
INSERT INTO counties(name) VALUES ('Ross-shire');
INSERT INTO counties(name) VALUES ('Roxburghshire');
INSERT INTO counties(name) VALUES ('Selkirkshire');
INSERT INTO counties(name) VALUES ('Shetland');
INSERT INTO counties(name) VALUES ('Stirlingshire');
INSERT INTO counties(name) VALUES ('Sutherland');
INSERT INTO counties(name) VALUES ('West Lothian');
INSERT INTO counties(name) VALUES ('West Midlands');
INSERT INTO counties(name) VALUES ('Wigtownshire');