UK Counties & Countries data files (CSV + MySQL)

The following files are data files that can be used in projects that require a list of UK Counties and/or all of the Countries in the world.

The following files are useful for web developers to use for their select drop downs or a lookup table in a database.

Countries

The Countries list comes in a CSV file and a MySQL dump.

CSV:

[download id="3"]

SQL:

[download id="4"]

Notes: Both files contain 2 columns, auto incrementing ids and the full Country name.

UK Counties

The Counties list comes in a CSV file and a MySQL dump.

CSV:

[download id="2"]

SQL:

[download id="1"]

Notes: Both files contain 2 columns, auto incrementing ids and the full County name.