City Data Lookup
Population, latitude and longitude, and the IANA time zone for 34,135 cities in 244 countries. Type a name, copy the row. Free, no account, and the source is named.
The dataset loads the first time you type — about half a megabyte, then everything is instant and offline.
How it works
Start typing a city
The dataset — about half a megabyte — downloads once, the first time you type.
Pick it out of the matches
Same names in different countries are shown with their country, so you take the right Springfield.
Copy the row
As CSV or as JSON, with the fields already named the way you would want them in code.
Where the data comes from
GeoNames, CC BY 4.0. Public data, and we say so on the page
rather than in a footer. What we did to it is the boring part that takes an
afternoon: kept the cities of 15,000 people and up, dropped the nineteen columns
nobody uses, and put the time zone in the format software actually expects —
Europe/Rome, not GMT+1.
That last one is the difference between a join that works and an evening lost.
A UTC offset is not a time zone: it does not know about daylight saving, so a
booking system built on GMT+1 is wrong for half the year in half of
Europe.
What the same number costs elsewhere
| Service | What you get | Price |
|---|---|---|
| GeoNames (the source) | The raw dump: every place, nineteen columns, CC BY 4.0 | not published |
| This page | The qualified referring-domain count, computed from the public Common Crawl web graph | Free |
Prices read from each vendor's own pricing page on 2026-09-07. We link the page so you can check it yourself; they change them without telling us, and a price we cannot show you the source for is a price we do not print.
What this page cannot do
It looks up one city at a time. It will not join 40,000 rows against your customer table, it has no administrative boundaries or polygons — these are points — and it starts at 15,000 inhabitants, so villages are not in here. If you need the whole set in a file, that is what the workbook below is, and if you are happy to build it yourself from the GeoNames dump, the source is free and named above.
Free page, or the file
The tool above is free and stays free. The file is the same work done already, laid out, and yours offline — buy it if that is worth 12 euro of your time, not because the page held anything back.
This page
- Search any of the 34,135 cities
- Population, latitude, longitude, IANA time zone
- Copy one row as CSV or JSON
- Same data as the file, one city at a time
World Cities Database — 34.135 città, 244 paesi
- All 34,135 rows as one CSV, no lookups
- JSON as well, same fields, ready to import
- Country and admin codes for joining
- One download, no rate limit, no API key
One payment, no account on this site, no renewal. Gumroad handles the checkout and the VAT; we never see your card.
Questions
Is the lookup free without limits?
Yes. The whole dataset is downloaded to your browser once and searched there, so there is no per-query cost to us and no meter to run. After the first search the page works with the network off.
Can I use this data commercially?
Yes, under CC BY 4.0 — keep the attribution to GeoNames. That applies to the data whether you take it from here or from the source.
Why is my town missing?
The set starts at 15,000 inhabitants. Below that it would be several times larger and far noisier, and for the things this is used for — dropdowns, maps, market lists — the tail is rarely what you needed.
How current is it?
It is a snapshot with an extraction date, rebuilt from GeoNames. Population figures move slowly and inconsistently between national censuses; treat them as an order of magnitude, not a measurement of this month.
Is there an API I can call?
Not from us. The whole point of the design is that the data goes to your browser and the searching happens there, which means there is no endpoint to rate limit and no key to lose. If you need it inside your own program, take the file and search it locally — that is faster than any API call.
Which fields do I get?
City name, country, administrative region code, population, latitude, longitude and the IANA time zone. Seven fields, chosen because they are the ones people actually join on — not the thirty the raw dump ships with.
Where do I find other free datasets like this?
GeoNames itself, for the full geographic dump; Natural Earth for boundaries and shapes; and your own national statistics office, which is usually the best source for anything within one country. We only did the part that was tedious: trimming, cleaning and putting the time zones in a usable format.
The other free tools
Same rules: no account, nothing stored, and the working shown.
A free dataset of world cities, and how to check one before you download it
Searching for free datasets is easy; the hard part is finding out what is actually inside one before you commit an afternoon to it. That is what this page is for. It holds exactly the same 34,135 rows as the downloadable file, one lookup at a time, so you can check the fields, the population figures and the time zone format against a city you know well before deciding whether the whole set is worth having.
What is in it
Every city of 15,000 inhabitants or more, in 244 countries: name, country, region code, population, latitude, longitude, and the IANA time zone identifier. Seven fields. The raw GeoNames dump has far more columns, and in years of using this data these are the ones anybody joins on.
Why the time zone format matters more than it sounds
A UTC offset like GMT+1 is not a time zone. It does not know when
daylight saving starts, so anything built on it is quietly wrong for several
months of the year across most of Europe and North America. Every row here
carries the IANA identifier instead, which is what date libraries in every
language expect.
Free datasets in CSV, and where to get more
The paid file is CSV and JSON in one download, with no lookups and no rate limit. The underlying data stays free and openly licensed at GeoNames — the attribution requirement travels with it, from us or from them, and we would rather tell you that here than bury it. Other tools on this site are on the free tools page.