Countries - Capital Cities List

The Countries and Capital Cities Database is a structured worldwide reference covering 252 countries, dependencies, territories, and special areas as of August 28, 2...

Choose your licenseFree with a confirmed account. Download securely.
Secure checkout
Combined multi-format protected ZIP UTF-8 CSVJSONSQLiteREADMESchemaLicenseSigned manifest
Countries - Capital Cities List List

Countries - Capital Cities List v.2.0.0

252 Database Records

Countries - Capital Cities List catalog icon Countries - Capital Cities List Download
The Countries and Capital Cities Database is a structured worldwide reference covering 252 countries, dependencies, territories, and special areas as of August 28, 2026. Each row preserves identifiers compatible with Oddity's Countries and Abbreviations Database and distinguishes official capitals, seats of government, legislative and judicial capitals, de facto seats, disputed cases, and jurisdictions with no capital. The protected package includes UTF-8 CSV, JSON, SQLite, JSON and XML schema, representative samples, statistics, source rights, and integrity evidence.
252 Records
SAMPLE DATA TABLE STRUCTURE RECORD INFO

Table Schema Database Field Statistics

Release structure

Countries - Capital Cities List

Review the published tables, record coverage, and field names included with release 2.0.0.

Database
#735
Version
2.0.0
Format
XML schema

Data dictionary

Tables and fields

Release-defined structure
FieldTypeRequiredDescription
iso2textYesISO 3166-1 alpha-2 identifier, or the XK user-assigned compatibility code used by the coordinated Countries and Abbreviations release.
iso3textYesISO alpha-3 identifier; XKX is a compatibility value for Kosovo.
iso_numericintegerNoISO numeric identifier; blank for a user-assigned compatibility entry.
jurisdiction_nametextYesCountry, dependency, or special-area name used by the coordinated Countries and Abbreviations release.
entity_classtextYesSovereign state, dependency or territory, disputed or special case, or area without a permanent population.
sovereignty_notetextNoShort scope note where sovereignty or administration needs qualification.
official_capitaltextNoCapital formally designated or conventionally treated as the capital.
seat_of_governmenttextNoDifferent principal government seat when applicable.
legislative_capitaltextNoDifferent legislative capital or seat when applicable.
judicial_capitaltextNoDifferent judicial capital or seat when applicable.
other_capital_or_seattextNoAdditional capital function or established de facto seat.
capital_statustextYesConcise classification of the capital arrangement.
continent_codetextYesGeoNames two-character continent code.
geonames_country_idintegerYesGeoNames jurisdiction identifier retained for cross-database compatibility.
source_publishertextYesPublisher supporting the row.
source_urltextYesRow-level evidence URL.
source_licensetextYesReuse terms applicable to the source data.
evidence_notetextYesExplanation of normalization or a special-case decision.
as_of_datetextYesDate through which the release was reviewed.

Release at a glance

What is inside this database

Review verified record totals, geographic coverage, classifications, and field completeness for Countries - Capital Cities List.

252Records in this release
19Fields per record
0Duplicate records
0Rejected source rows
iso2ISO 3166-1 alpha-2 identifier, or the XK user-assigned compatibility code used by the coordinated Countries and Abbreviations release.
Distinct
252
Missing
0.0%
iso3ISO alpha-3 identifier; XKX is a compatibility value for Kosovo.
Distinct
252
Missing
0.0%
iso_numericISO numeric identifier; blank for a user-assigned compatibility entry.
Distinct
252
Missing
0.4%
jurisdiction_nameCountry, dependency, or special-area name used by the coordinated Countries and Abbreviations release.
Distinct
252
Missing
0.0%
entity_classSovereign state, dependency or territory, disputed or special case, or area without a permanent population.
Distinct
6
Missing
0.0%
sovereignty_noteShort scope note where sovereignty or administration needs qualification.
Distinct
6
Missing
98.0%
official_capitalCapital formally designated or conventionally treated as the capital.
Distinct
243
Missing
3.2%
seat_of_governmentDifferent principal government seat when applicable.
Distinct
10
Missing
96.4%
legislative_capitalDifferent legislative capital or seat when applicable.
Distinct
4
Missing
98.8%
judicial_capitalDifferent judicial capital or seat when applicable.
Distinct
2
Missing
99.6%
other_capital_or_seatAdditional capital function or established de facto seat.
Distinct
3
Missing
99.2%
capital_statusConcise classification of the capital arrangement.
Distinct
20
Missing
0.0%
continent_codeGeoNames two-character continent code.
Distinct
7
Missing
0.0%
geonames_country_idGeoNames jurisdiction identifier retained for cross-database compatibility.
Distinct
252
Missing
0.0%
source_publisherPublisher supporting the row.
Distinct
1
Missing
0.0%
source_urlRow-level evidence URL.
Distinct
1
Missing
0.0%
source_licenseReuse terms applicable to the source data.
Distinct
1
Missing
0.0%
evidence_noteExplanation of normalization or a special-case decision.
Distinct
6
Missing
0.0%
as_of_dateDate through which the release was reviewed.
Distinct
1
Missing
0.0%

Entity Class

  • Sovereign State195
  • Dependency Or Territory48
  • Disputed Or Special Case5
  • Area Without Permanent Population2
  • Dispersed Dependency Or Territory1
  • Sovereign Special Case1

Capital Status

Showing the 12 largest groups from 20 represented values.

  • Single Capital230
  • No Capital3
  • Constitutional Capital With A Separate Seat Of Government2
  • City - State Capital1
  • No Single Capital1
  • No Single Capital; Administration Rotates1
  • Special Political - Status Case1
  • Federal City Serving As De Facto Capital1
  • Legislative Capital With Major Executive Functions In Colombo1
  • Three - Function Capital Arrangement1
  • No Official Capital; De Facto Government Seat1
  • Claimed Capital With A Separate Administrative Seat1

Records Information

Each record represents one jurisdiction identifier coordinated with Countries and Abbreviations (#789). ISO2 is the primary key. Multiple capital functions occupy separate fields instead of being collapsed into one ambiguous value. Dependencies, disputed or special cases, areas without permanent population, and user-assigned Kosovo compatibility identifiers are explicitly labeled. CSV, JSON, and SQLite must contain the same 252 unique identifiers.

Designed for business research, directory applications, mapping, and market analysis. Review permitted uses.

Need a closer fit?

Data shaped around your project.

Tell us your topic, geography, and required fields. We can help find a match or scope a custom package.
Discuss your data needs Explore the catalog

Oddity Support

How can we help?

Browse all Help topics

Oddity Data Updates

Know when fresh data arrives.

Receive occasional notices about new and substantially updated database releases. No third-party mailing list.

Oddity Software

Details