Name: World Cities Database
Creator: Kaggle
License: https://creativecommons.org/licenses/by/4.0/

About this Dataset

World Cities Database

The data is from:

https://simplemaps.com/data/world-cities

We're proud to offer a simple, accurate and up-to-date database of the world's cities and towns. We've built it from the ground up using authoritative sources such as the NGIA, US Geological Survey, US Census Bureau, and NASA.

Our database is:

Up-to-date: It was last refreshed on March 19, 2024.
Comprehensive: Over 4 million unique cities and towns from every country in the world (about 47 thousand in basic database).
Accurate: Cleaned and aggregated from official sources. Includes latitude and longitude coordinates.
Simple: A single CSV file, concise field names, only one entry per city.

Tables

Worldcities

@kaggle.juanmah_world_cities.worldcities

2.5 MB
47868 rows
11 columns


CREATE TABLE worldcities (
  "city" VARCHAR,
  "city_ascii" VARCHAR,
  "lat" DOUBLE,
  "lng" DOUBLE,
  "country" VARCHAR,
  "iso2" VARCHAR,
  "iso3" VARCHAR,
  "admin_name" VARCHAR,
  "capital" VARCHAR,
  "population" DOUBLE,
  "id" BIGINT
);