Wikidata cities database
7,622 cities and 255 countries in one 1.2 MB SQLite file, fetched from this site's own origin and never a third party. Your browser keeps the file afterward, so later visits start it straight from the cache, and nothing you query here leaves this tab.
Related tools
- Airport Code LookupLook up an airport by IATA or ICAO code, name, or city, or enter two to get the great circle distance and bearing.
- Country Code LookupLook up a country by ISO code, name, calling code, or top level domain and see its full profile.
- Distance and Bearing CalculatorGreat circle and WGS84 distance, initial and final bearing, midpoint, and magnetic declination between coordinates.
- Sun & Golden Hour CalculatorSunrise, sunset, twilight, golden hour and shadow angles for any spot on any date.
- GPX Track ViewerView GPX, KML and GeoJSON tracks with distance, elevation profile, speed stats and trimming, all in your browser.
- Coordinate ConverterConvert between decimal degrees, DMS, UTM, MGRS, Plus Codes and geohashes in any direction.
What it does
A 1.2 MB SQLite database with every settlement over 100,000 people that Wikidata records (7,622 cities) joined to a 255 row countries table, plus ten curated queries covering the largest cities overall and by country, the most city-dense countries, elevation and latitude extremes, population by continent, repeated city names, capitals, and a nearest-city bounding box search. The whole file downloads once and every query then runs locally against it.
How to use it
Open the tool to load the bundled database, pick a curated query to run it as-is or edit it, or write your own SQL against the cities, countries, and meta tables. Results render as a table you can page through, and the query itself lives in the URL so a link reproduces exactly what you ran.
Why this one
Getting a queryable cities dataset usually means signing up for an API with a request quota, or scraping a table out of a Wikipedia page yourself. This ships the whole database as one file, answers instantly with no request limit, works offline after the first load, and never sends a query anywhere.
FAQ
- Where does the data come from, and can I trust the population figures?
- Wikidata, released under CC0 1.0. This is a dated snapshot rebuilt on 2026-08-23, not a live feed; that date is also recorded in the database's own meta table. Population figures come from whatever source Wikidata's editors most recently recorded for that settlement, which varies in age and methodology from city to city.
- Why do some cities show no time zone?
- Wikidata records a time zone for only a share of settlements. A city in a country with exactly one time zone inherits that zone; a city in a multi zone country such as the United States is left blank rather than guessed.
- Why does a metro area like Greater Tokyo Area outrank the city it contains?
- Metropolitan areas are included as their own rows alongside the cities within them, and a metro area's population is naturally larger than any single city inside it. A "largest cities" query mixes both by design; filter on admin1 or the name if you want cities only.
Keyboard shortcuts: press ? anywhere on this page to see them.