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.
RECENT DATA UPDATES
U.S. Jewelers and Jewelry Store Locations Database
38,557 Jewelry retail locations
v. 2.0.0
Updated 18 hours ago
v. 2.0.0
Updated 18 hours ago
U.S. Pet Boarding and Kennel Locations Database
6,859 Pet boarding locations
v. 2.0.0
Updated 18 hours ago
v. 2.0.0
Updated 18 hours ago
U.S. Animal Hospital Locations Database
2,990 Animal hospital locations
v. 2.0.0
Updated 18 hours ago
v. 2.0.0
Updated 18 hours ago
U.S. Veterinarian Practice Locations Database
39,007 Veterinarian practice locations
v. 2.0.0
Updated 18 hours ago
v. 2.0.0
Updated 18 hours 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 needs