List of UK counties in SQL & CSV format
September 19th, 2007
During a recent project, we had to compile a definitive list of counties within the UK (excluding Northern Ireland). This proved harder than we’d anticipated so we thought we’d publish the list in both CSV and SQL formats. Aren’t we lovely?
CSV for List of UK Counties
Download CSV: uk-counties.csv (2KB)
SQL for List of UK Counties
Download SQL: uk-counties.sql (13KB)
The SQL creates a new table in the following format:
CREATE TABLE `tblCounty` ( `fldCountyID` int(10) unsigned NOT NULL auto_increment, `fldCountry` varchar(100) NOT NULL default '0', `fldCounty` varchar(100) NOT NULL default '', `fldDateAdded` int(10) NOT NULL default '0', `fldDateModified` int(10) NOT NULL default '0', PRIMARY KEY (`fldCountyID`) );
For more information on web development please contact us on +44(0)1202 315285 or info@acmultimedia.co.uk. Learn more about AC Multimedia.
I agree, well said. Very good website.
thanks.. this will really help us..
Beware that the list is not comprehensive. Files have some ommissions which soon become apparent such as Berkshire and Herefordshire.
Also East Riding of Yorkshire is missing
The list is incomplete.
Where is BANES (Bath and North East Somerset) formely know as AVON?
I have a better list, where do I upload it ?
Thanks! This should def come in handy.
You beauties
Great Thaks
Nice idea, but what are these supposed to be? Postal counties? Administrative counties? Traditional (pre 1974) counties? Not your fault that due to insessant government meddling the UK county structure is a total shambles, but it is not clear what your list is supposed to represent.
Many thanks for providing this guys. Super useful for something Im working on too.
Indeed you are lovely. Many thanks
Really helpful for a project I’m working on…
not an easy task but I found this and thought it useful…
http://www.abcounties.co.uk/counties/list.htm
Saved me a pile of work. Thanks Very.
Thanks a million. You just saved me a ton of work!
@Archive
Even with a cursory glance, this link is full of errors - Bristol apparently is in Gloucestershire, St Ives apparently is in Huntingdonshire.
Why spend your time doing all this work when it’s available in places that needed and need it updated on a regular basis. One such place is any only shop and so a simple visit to http://www.oscommerce.com –> look for the contributions link and when there look for ZONES.
In their you will find all the postage place you could ever want for any part of the world. You just need to do a bit of editing because it’ll be in SQL form.
Handyman.