United Kingdom Gazetteer, UK Place Names (Cities) Database by Region, County and District City

Database Description:

This UK Gazetteer (cities) database is a complete compilation of United Kingdom local place names, categorized in regional level, county level and district (city) level. Britain Gazetteer including England Gazetteer, Scotland Gazetteer and Wales Gazetteer as well as Northern Irish Gazetteer are all part of this UK local place names list database.

Database Meta:

• Size: 0.4 MB
• Last updated: Sep. 24th, 2010
• 3 Formats Included: MySQL 5 SQL dump text file, CSV, MS Excel
• Tables: 3

Buy Now & Download: $19.95 (USD)

phpMyAdmin Screenshots:

Table Details (Data Structure / Schema):

• location

  Records:14

  UK regions. More than 9 as an attempt to include some of the surrounding islands separately.

  Data fields

  1. id: smallint(6)
  2. title: varchar(255)
  3. slug: varchar(255)

• sublocation

  Records:142

  UK counties.

  Data fields

  1. id: smallint(6)
  2. title: varchar(255)
  3. slug: varchar(255)
  4. location: smallint(6)

• subsublocation

  Records:7,571

  UK local districts, cities and towns.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. slug: varchar(255)
  4. sublocation: mediumint(9)

Buy Now & Download: $19.95 (USD)

Prospective Applications / Implementations:

• UK local sites and directories
• UK county and city information sites, weather sites etc.
• UK travel or tourism sites
• UK local yellowpages sites
• Online UK county and city local classifieds
• ...Order a custom build

Other Available Formats:

After purchase, please contact us for any of the specific data formats listed below and we will send it right away.

• Plain CSV
• CSV for Microsoft Excel
• Microsoft Excel .XLS file (2008, 2007, 2003, 2000)
• Microsoft Word .DOC file (2008, 2007, 2003, 2000)
• LaTeX
• Open Document Spreadsheet
• Open Document Text
• PDF
• XML
• YAML
• WordPress Category / Post Database (Extra $175)
• Single Table Format (Extra $100)