Explore city names, administrative divisions, populations and coordinates, with data provenance.
The free API exposes the 5,000 cities with the highest population values in this database release. This global selection is fixed: country filters never expand it.
Widgets displayed on AffectionPlus.com pages use the entire database, including for visitors without a subscription. On another site, the widget is limited to the free selection unless the site uses a token issued under an active eligible subscription.
Downloads
CSV files are generated on demand by filtering the database by country, region or second-level division (county, district). No CSV is stored in the database. The SQL export recreates all cities and their attributes without duplicating geographic extracts. Each selected file costs €1; the same files are included in Premium.
€1 including tax per file, paid once. A file purchase does not unlock the full API.
The existing AffectionPlus Premium subscription, used with the same account on CAPIT.NET, starts at €3 including tax per month. It includes CSV and SQL files, the full API and Pack Developer, with no second subscription.
Complete worldwide SQL export (.sql.gz, PostgreSQL)
Sources and licenses
- INSEE — Licence Ouverte 2.0 / Etalab
- GeoNames — CC BY
- OpenStreetMap — ODbL
- Wikidata — CC0
- Natural Earth — public domain
Population figures do not all refer to the same year or geographic area. Ranking uses population, not estimated urban population.
population_urban_source = gn_agglomeration means a heuristic estimate, not an official census. population_source = original_unverified means an uncorroborated historical value. Open licenses also apply to purchased data: attribution and, for a derivative database covered by ODbL, share-alike obligations. Payment covers the service and does not remove redistribution rights granted by those licenses.