List of UK counties in SQL & CSV format

WEDNESDAY, SEPTEMBER 19, 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`)
);

Posted Sep 19, 2007 07:34 AM by Andy Crathorne | Permalink | Send to a Friend

Bookmark with:
Delicious Digg reddit Facebook StumbleUpon

Comments (11)

SmartFolio wrote:
I agree, well said. Very good website.
Posted on 24-Sep-07 at 4:34 pm | Permalink

Web Development wrote:
thanks.. this will really help us..
Posted on 05-Oct-07 at 7:07 am | Permalink

CountyChecker wrote:
Beware that the list is not comprehensive. Files have some ommissions which soon become apparent such as Berkshire and Herefordshire.
Posted on 27-Oct-07 at 8:54 pm | Permalink

Gavin wrote:
Also East Riding of Yorkshire is missing
Posted on 09-Nov-07 at 2:35 pm | Permalink

Manuel (DEA in Bath) wrote:
The list is incomplete.

Where is BANES (Bath and North East Somerset) formely know as AVON?
Posted on 26-Nov-07 at 6:21 pm | Permalink

Scott Dmaret wrote:
I have a better list, where do I upload it ?
Posted on 13-Dec-07 at 3:39 pm | Permalink

Managed Dedicated Servers wrote:
Thanks! This should def come in handy.
Posted on 19-Dec-07 at 6:32 pm | Permalink

Garry wrote:
You beauties
Posted on 08-Jan-08 at 1:45 pm | Permalink

Web Design Company wrote:
Great Thaks
Posted on 29-Jan-08 at 10:58 pm | Permalink

Chris wrote:
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.
Posted on 21-Mar-08 at 5:34 pm | Permalink

Paul @ Web Design Ireland wrote:
Many thanks for providing this guys. Super useful for something Im working on too.
Posted on 11-May-08 at 2:11 pm | Permalink

Have something to say?

Have some interesting comments or thoughts on this blog? Perhaps you have some questions? Maybe you want to share your knowledge? Either way, write it below.

Please note that all comments and URLs are subject to approval and may be amended to suit editorial style and subject matter. Website addresses will only be published after approval.