World City Names Database with Latitude and Longitude – Sample Data

The World City Names Database with Latitude and Longitude  record count is given below in thousands.
Download World City Names Database with Latitude and Longitude

  • Africa – 430K
  • Arctic Region – 2K
  • Asia – 590K
  • Central America and the Caribbean – 75K
  • Commonwealth of Independent States – 110K
  • Europe – 617K
  • Middle East – 248K
  • North America – 209K
  • Oceania – 37K
  • South America – 149K
  • South East Asia – 322K
  • World Others – 1K

TOTAL – 2.79 Million

The data is available as sql dump file. You can download a sample database for the world city names from the download link above. The sql dump file is readily executable on MySQL query browser. The sample sql dump file code is given below.

INSERT INTO `Cities` VALUES (1, ‘AD’, ’06’, ‘aixas’, ‘Aixàs’, 42.4833333, 1.4666667);
INSERT INTO `Cities` VALUES (2, ‘AD’, ’06’, ‘aixirivali’, ‘Aixirivali’, 42.4666667, 1.5);
INSERT INTO `Cities` VALUES (3, ‘AD’, ’06’, ‘aixirivall’, ‘Aixirivall’, 42.4666667, 1.5);
INSERT INTO `Cities` VALUES (4, ‘AD’, ’06’, ‘aixirvall’, ‘Aixirvall’, 42.4666667, 1.5);
INSERT INTO `Cities` VALUES (5, ‘AD’, ’06’, ‘aixovall’, ‘Aixovall’, 42.4666667, 1.4833333);
INSERT INTO `Cities` VALUES (6, ‘AD’, ’07’, ‘andorra’, ‘Andorra’, 42.5, 1.5166667);
INSERT INTO `Cities` VALUES (7, ‘AD’, ’07’, ‘andorra la vella’, ‘Andorra la Vella’, 42.5, 1.5166667);
INSERT INTO `Cities` VALUES (8, ‘AD’, ’07’, ‘andorra-vieille’, ‘Andorra-Vieille’, 42.5, 1.5166667);
INSERT INTO `Cities` VALUES (9, ‘AD’, ’07’, ‘andorre’, ‘Andorre’, 42.5, 1.5166667);
INSERT INTO `Cities` VALUES (10, ‘AD’, ’07’, ‘andorre-la-vieille’, ‘Andorre-la-Vieille’, 42.5, 1.5166667);
INSERT INTO `Cities` VALUES (11, ‘AD’, ’07’, ‘andorre-vieille’, ‘Andorre-Vieille’, 42.5, 1.5166667);
INSERT INTO `Cities` VALUES (12, ‘AD’, ’04’, ‘ansalonga’, ‘Ansalonga’, 42.5666667, 1.5166667);
INSERT INTO `Cities` VALUES (13, ‘AD’, ’05’, ‘anyos’, ‘Anyós’, 42.5333333, 1.5333333);
INSERT INTO `Cities` VALUES (14, ‘AD’, ’04’, ‘arans’, ‘Arans’, 42.5833333, 1.5166667);
INSERT INTO `Cities` VALUES (15, ‘AD’, ’04’, ‘arinsal’, ‘Arinsal’, 42.5666667, 1.4833333);
INSERT INTO `Cities` VALUES (16, ‘AD’, ’06’, ‘aubinya’, ‘Aubinyà’, 42.45, 1.5);
INSERT INTO `Cities` VALUES (17, ‘AD’, ’06’, ‘auvinya’, ‘Auvinya’, 42.45, 1.5);
INSERT INTO `Cities` VALUES (18, ‘AD’, ’06’, ‘bicisarri’, ‘Biçisarri’, 42.4833333, 1.4666667);
INSERT INTO `Cities` VALUES (19, ‘AD’, ’06’, ‘bixessarri’, ‘Bixessarri’, 42.4833333, 1.4666667);
INSERT INTO `Cities` VALUES (20, ‘AD’, ’06’, ‘bixisarri’, ‘Bixisarri’, 42.4833333, 1.4666667);
INSERT INTO `Cities` VALUES (21, ‘AD’, ’02’, ‘canillo’, ‘Canillo’, 42.5666667, 1.6);
INSERT INTO `Cities` VALUES (22, ‘AD’, ’03’, ‘casas vila’, ‘Casas Vila’, 42.5333333, 1.5666667);
INSERT INTO `Cities` VALUES (23, ‘AD’, ’06’, ‘certers’, ‘Certers’, 42.4666667, 1.5);
INSERT INTO `Cities` VALUES (24, ‘AD’, ’06’, ‘certes’, ‘Certés’, 42.4666667, 1.5);
INSERT INTO `Cities` VALUES (25, ‘AD’, ’06’, ‘eixirivall’, ‘Eixirivall’, 42.4666667, 1.5);
INSERT INTO `Cities` VALUES (26, ‘AD’, ’04’, ‘el pui’, ‘El Pui’, 42.55, 1.5166667);
INSERT INTO `Cities` VALUES (27, ‘AD’, ’03’, ‘els bons’, ‘Els Bons’, 42.5333333, 1.5833333);

Data in the sample file is for demonstration only. Complete database is available in the full package. Please Download full package from the link below: world-city-names-database-with-latitude-longitude-p-117.html