CSV file UK cities (locations)

CSV file of UK Cities (locations)

Below is a nice list of UK cities which you can import straight into your database. I hope this helps someone out there. And for all you MySQL people, scroll down and I’ll give you the insert statement that you can put straight into your database to create the table. Don’t say I’m not good to you! (David www.dcradionetwork.com)

1,”Aberdeen”
2,”Bath”
3,”Belfast”
4,”Birmingham”
5,”Bournemouth”
6,”Bradford”
7,”Brighton”
8,”Bristol”
9,”Cambridge”
10,”Cardiff”
11,”Chester”
12,”Coventry and Warks”
13,”Derby”
14,”Derry”
15,”Dundee”
16,”Edinburgh”
17,”Essex”
18,”Exeter”
19,”Falkirk and Stirling”
20,”Gateshead”
21,”Glasgow”
22,”Gloucestershire”
23,”Hull”
24,”Ipswich”
25,”Jersey”
26,”Leeds”
27,”Leicester”
28,”Lincolnshire”
29,”Liverpool”
30,”London North”
31,”London West”
32,”London South”
33,”London East”
34,”Kent”
35,”Manchester”
36,”Milton Keynes”
37,”Newcastle”
38,”Northampton”
39,”Norwich”
40,”Nottingham”
41,”Oxford”
42,”Peterborough”
43,”Plymouth”
44,”Portsmouth”
45,”Lancashire”
46,”Reading”
47,”Sheffield”
48,”Southampton”
49,”Stoke-on-Trent”
50,”Surrey”
51,”Swansea”
52,”Swindon”
53,”Teesside”
54,”Watford”
55,”Wolverhampton”
56,”Worcestershire”
57,”York”

CREATE TABLE IF NOT EXISTS `uk_cities` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`city` varchar(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=58 ;


— Dumping data for table `uk_cities`

INSERT INTO `uk_cities` (`id`, `city`) VALUES
(1, ‘Aberdeen’),
(2, ‘Bath’),
(3, ‘Belfast’),
(4, ‘Birmingham’),
(5, ‘Bournemouth’),
(6, ‘Bradford’),
(7, ‘Brighton’),
(8, ‘Bristol’),
(9, ‘Cambridge’),
(10, ‘Cardiff’),
(11, ‘Chester’),
(12, ‘Coventry and Warks’),
(13, ‘Derby’),
(14, ‘Derry’),
(15, ‘Dundee’),
(16, ‘Edinburgh’),
(17, ‘Essex’),
(18, ‘Exeter’),
(19, ‘Falkirk and Stirling’),
(20, ‘Gateshead’),
(21, ‘Glasgow’),
(22, ‘Gloucestershire’),
(23, ‘Hull’),
(24, ‘Ipswich’),
(25, ‘Jersey’),
(26, ‘Leeds’),
(27, ‘Leicester’),
(28, ‘Lincolnshire’),
(29, ‘Liverpool’),
(30, ‘London North’),
(31, ‘London West’),
(32, ‘London South’),
(33, ‘London East’),
(34, ‘Kent’),
(35, ‘Manchester’),
(36, ‘Milton Keynes’),
(37, ‘Newcastle’),
(38, ‘Northampton’),
(39, ‘Norwich’),
(40, ‘Nottingham’),
(41, ‘Oxford’),
(42, ‘Peterborough’),
(43, ‘Plymouth’),
(44, ‘Portsmouth’),
(45, ‘Lancashire’),
(46, ‘Reading’),
(47, ‘Sheffield’),
(48, ‘Southampton’),
(49, ‘Stoke-on-Trent’),
(50, ‘Surrey’),
(51, ‘Swansea’),
(52, ‘Swindon’),
(53, ‘Teesside’),
(54, ‘Watford’),
(55, ‘Wolverhampton’),
(56, ‘Worcestershire’),
(57, ‘York’);

Advertisements

2 comments

  1. Just what I was looking for. Thankyou!

  2. I have loaded your website in Several completely different internet browsers
    and I must say this website loads a lot faster then most.
    Would you mind e-mailing me the company name of your hosting company?
    I’ll sign up through your own affiliate link if you would like. Appreciate it

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: