Countries and Abbreviations v.2.0.0
252 Database Records
The Countries and Abbreviations Database provides a structured reference for countries and dependent territories worldwide. It combines standard ISO alpha-2, alpha-3, and numeric identifiers with country names, capitals, continents, currencies, international calling prefixes, top-level domains, languages, postal-code patterns, GeoNames identifiers, and neighboring-country relationships. Use the schema and sample to confirm field coverage before adding this free publication-licensed release to your account.
Table Schema Database Field Statistics
Release structure
Countries and Abbreviations
Review the published tables, record coverage, and field names included with release 2.0.0.
- Database
- #789
- Version
- 2.0.0
- Format
- XML schema
Data dictionary
Tables and fields
| Field | Type | Required | Description |
|---|---|---|---|
| iso2 | text | Yes | ISO 3166-1 alpha-2 country or territory code. |
| iso3 | text | Yes | ISO 3166-1 alpha-3 country or territory code. |
| iso_numeric | integer | Yes | ISO 3166-1 numeric code. |
| fips | text | No | FIPS country code when supplied by the source. |
| country | text | Yes | Country or dependent territory name. |
| capital | text | No | Capital city name. |
| area_sq_km | decimal | Yes | Land and water area in square kilometers as reported by the source. |
| population | integer | Yes | Population estimate supplied by the source. |
| continent | text | Yes | Two-character continent code. |
| tld | text | No | Country-code top-level domain. |
| currency_code | text | No | ISO 4217 currency code. |
| currency_name | text | No | Currency name. |
| phone_prefix | text | No | International calling prefix. |
| postal_code_format | text | No | Representative postal-code format pattern. |
| postal_code_regex | text | No | Regular expression supplied for postal-code validation. |
| languages | text | No | Comma-separated language and locale codes. |
| geoname_id | integer | Yes | GeoNames identifier for the country record. |
| neighbors | text | No | Comma-separated neighboring country codes. |
| equivalent_fips | text | No | Equivalent FIPS code when supplied. |
Release at a glance
What is inside this database
Worldwide coverage of countries and dependent territories, with standardized identifiers, geographic reference values, currencies, calling codes, languages, and related country attributes.
countryCountry or dependent territory name.
- Distinct
- 252
- Missing
- 0.0%
iso2ISO alpha-2 country or territory code.
- Distinct
- 252
- Missing
- 0.0%
iso3ISO alpha-3 country or territory code.
- Distinct
- 252
- Missing
- 0.0%
capitalCapital city name.
- Distinct
- 244
- Missing
- 2.4%
continentTwo-character continent code.
- Distinct
- 7
- Missing
- 0.0%
currency_codeISO 4217 currency code.
- Distinct
- 156
- Missing
- 0.4%
phone_prefixInternational calling prefix.
- Distinct
- 233
- Missing
- 2.4%
languagesLanguage and locale codes.
- Distinct
- 247
- Missing
- 1.2%
Records Information
This release contains one normalized record per ISO alpha-2 country or territory identifier accepted from the official GeoNames country information dataset. Records missing a valid two-character identifier or country name are rejected during the reproducible build. Duplicate identifiers are blocked, and CSV, JSON, and SQLite counts must agree before release review.
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.RECENT DATA UPDATES
Selected BC City Business Licences and Federal Corporation Details Database
117,926
v. 2.1.0
Updated 5 days ago
v. 2.1.0
Updated 5 days ago
Custom Data Solutions
Tell us the industry, geography, fields, and format you need. We can help assemble a practical dataset for your project.
Discuss your data needsLicense rights
Free Publication
Read the complete Oddity Software Free Publication License
Use, modify, analyze, publish and share the complete free dataset with all required source notices and the release version.
Downloads of an eligible purchased version are unlimited while it remains the current public version. A newer release does not automatically become part of the earlier order.
A clear path from download to project
Get more from your data
Understand the files, check the sample coverage, and choose the license that fits your use.