Discovery
€0
5 000 results
1 000 / day / IP · 60 / minute
Fixed worldwide selection: filtering by country does not expand it. No API key needed.
Explore the data
ISO 3166-1 : BI1,566 cities135 CSV filesRegions : 15Districts : 119
€1 per file, or included with a subscription.
The free API covers the global top 5,000 cities, even when filtered by country. CSV files cover the entire stated selection.
Public access: 5,000 cities worldwide
Fixed worldwide selection: filtering by country does not expand it. No API key needed.
Show results
Explorer exports are batches of up to 1,000 rows. For an entire country, select its CSV file in the catalogue.
CAPIT · API & DATA
Every subscription includes CAPIT benefits, CSV and SQL files, all 109 properties and API keys.
€0
5 000 results
1 000 / day / IP · 60 / minute
Fixed worldwide selection: filtering by country does not expand it. No API key needed.
Explore the data€3 / month
Tax included, monthly renewal
10,000 / dayAPI requests per account120 / minute
Full database, advanced filters, field selection and integration on your websites.
Exports per account : 50 batches / day · 5 / minute
Choose Essential€8 / month
Tax included, monthly renewal
50,000 / dayAPI requests per account240 / minute
Full database, advanced filters, field selection and integration on your websites.
Exports per account : 100 batches / day · 10 / minute
Choose Developer€12 / month
Tax included, monthly renewal
100,000 / dayAPI requests per account360 / minute
Full database, advanced filters, field selection and integration on your websites.
Exports per account : 200 batches / day · 15 / minute
Choose ProChoose — €1 or subscription
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.
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)
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.