IP Country Database
Overview
Ever wonder what country a specific IP address comes from? Our IP to Country Database, which is part of our Geo Standard, helps you figure that out for any IPv4 or IPv6 address. We've packed it with all the details you'd want, not just the country name, but ISO codes, the continent, capital, dialing codes, currencies, languages, and TLDs. It even supports multiple languages, so you can get localized results right away, no extra steps needed.
We're pretty committed to having the most up-to-date information, which is why our databases are updated daily so that you're always working with the latest changes. We also make sure that the files are super light and easy to use. You can literally just drop them into your systems without a fuss.
You'll find everything you need to know in our documentation. We walk you through what's in the archives, the file structure, how to verify your downloads before you import them, just to be safe, and we’ve also included a few examples.
Available Database Formats
CSV Database Documentation
1. Overview
The CSV version is delivered as a ZIP archive that includes Gzip-compressed files with IP ranges, location details, and multilingual place names. It’s well-suited for bulk imports and easy integration into relational databases.
2. Archive Content
After downloading and extracting the IP to Country CSV database archive, you'll find the following files (with their types noted):
db-country.csv.gzStandardized country and continent metadata with codes, currency, calling codes, TLDs, and languages.
- File Size: 9.67 KB
- Entries: 254
- Fields: 15
db-place.csv.gzMultilingual place names for cities, districts, states, countries, and continents.
- File Size: 32.36 KB
- Entries: 690
- Fields: 13
db-ip-country.csv.gzIP ranges mapping to country IDs for linking each address block with standardized country details and metadata.
- File Size: 217.88 MB
- Entries: 38.5M
- Fields: 3
README.mdDocumentation for dataset contents, schema, usage, and support.
- File Size: 8.00 KB
checksum.txtSHA-256 checksums for verifying file integrity.
- File Size: 329 Bytes
Schema
This section describes the schema of each file included in the IP to Country Database archive. For every file, you'll find its purpose, field definitions, and examples to help with integration.
1. db-ip-country.csv.gz
This file contains standardized country and continent details and metadata. It includes various codes (ISO-2/ISO-3/IOC), place IDs for names and capitals, currency details, international calling codes, top-level domains (TLDs), and language tags.
| Field | Type | Description | Can be empty? | Example |
|---|---|---|---|---|
| start_ip | string | The starting IP address of the range in IPv4 or IPv6 format. | No | 192.168.0.1 |
| end_ip | string | The ending IP address of the range in IPv4 or IPv6 format. | No | 192.168.0.255 |
| country_id | number | The unique identifier for the country associated with the IP range. | No | 192 |
I. Example Records
start_ip,end_ip,country_id
1.231.218.30,1.231.218.30,193
86.169.117.13,86.169.117.13,58
67.241.203.146,67.241.203.146,172
39.191.20.22,39.191.20.22,35
76.175.106.42,76.175.106.42,172
217.154.81.46,217.154.82.209,41
167.116.213.160,167.116.213.160,173
24.11.110.238,24.11.110.238,172
64.228.181.26,64.228.181.26,29
90.92.152.144,90.92.152.144,562. db-place.csv.gz
This file contains multilingual names for countries, continents, states, districts, and cities worldwide. It serves as the reference dictionary for the IP Location Database, allowing you to resolve place IDs into multilingual responses across different regions and languages.
| Field | Type | Description | Can be empty? | Example |
|---|---|---|---|---|
| id | number | The unique identifier for the place. | No | 5375480 |
| place_english | string | The name of the place in English. | No | Mountain View |
| place_german | string | The name of the place in German. | Yes | Mountain View |
| place_russian | string | The name of the place in Russian. | Yes | Маунтин-Вью |
| place_korean | string | The name of the place in Korean. | Yes | 마운틴 뷰 |
| place_portuguese | string | The name of the place in Portuguese. | Yes | Mountain View |
| place_japanese | string | The name of the place in Japanese. | Yes | マウンテンビュー |
| place_persian | string | The name of the place in Farsi. | Yes | ماونتین ویو |
| place_french | string | The name of the place in French. | Yes | Mountain View |
| place_chinese | string | The name of the place in Chinese. | Yes | 山景城 |
| place_spanish | string | The name of the place in Spanish. | Yes | Mountain View |
| place_czech | string | The name of the place in Czech. | Yes | Mountain View |
| place_italian | string | The name of the place in Italian. | Yes | Mountain View |
I. Example Records
id,place_english,place_german,place_russian,place_korean,place_portuguese,place_japanese,place_persian,place_french,place_chinese,place_spanish,place_czech,place_italian
3949,Los Angeles County,Los Angeles,Лос-Анджелес,로스앤젤레스 군,Condado de Los Angeles,ロサンゼルス郡,شهرستان لسآنجلس، کالیفرنیا,Comté de Los Angeles,洛杉矶县,Лос-АнджеФорест,Los Angeles County,Contea di Los Angeles
5,Asia,Asien,Азия,Ásia,Ásia,アジア, آسیا,Asie,亚洲,Asia,Asie,Asia
6,North America,Nordamerika,Северная Америка,América do Norte,América Do Norte,北アメリカ, امریکای شمالی,Amérique du Nord,北美洲,Norteamérica,Severní Amerika,America del Nord
7,Europe,Europa,Европа,Europa,Europa,ヨーロッパ, اروپا,Europe,欧洲,Europa,Evropa,Europa
8,South America,Südamerika,Южная Америка,América do Sul,América Do Sul,南アメリカ,امریکای جنوبی,Amérique du Sud,南美洲,Sudamérica,Jižní Amerika,America del Sud
12,China,China,Китай,China,China,中国,چین,Chine,中国,China,Čína,Cina
62954,Paris 04 Hotel-de-Ville,Paris 04 Hotel,Париж 04 Отель де Виль,,,パリ 04 ホテルドヴィル,,Paris 04 Hôtel de Ville,巴黎 04 酒店-德维尔,Paris 04 Hotel de Ville,Paříž 04 Hotel-de-Ville,Parigi 04 Hotel-de-Ville
1275,Zhejiang,Zhejiang,Чжэцзян,,,浙江省,,Province de Zhejiang,浙江省,Zhejiang,Zhejiang,Zhejiang
240018,United States of America,,,,,,,,,,,
240020,Oriental Republic of Uruguay,,,,,,,,,,,
240019,"Washington, D.C.",,,,,,,,,,,
275,Beijing,Peking,Пекин,,,北京,,Municipalité de Pékin,北京,Peking,Peking,Pechino
24,South Korea,"Korea, Republik (Südkorea)",Республика Корея,대한민국,Coreia do Sul,大韓民国,کرهٔ جنوبی,"Corée, République de",韩国,Jižní Korea,Jižní Korea,Corea del Sud
283,Seoul,Seoul,Сеул,서울특별시,,ソウル特別市,,Séoul,首尔特别市,Soul,Soul,Seul
28,United States,USA,США,Estados Unidos,Estados Unidos,アメリカ合衆国,ایالات متحدهٔ امریکا,États-Unis,美国,Estados Unidos,Spojené státy americké,Stati Uniti d'America
239901,People’s Republic of China,,,,,,,,,,,
57697,Frankfurt,Frankfurt (Oder),Франкфурт-на-Одере,,Frankfurt an der Oder,フランクフルト,,Francfort-sur-l'Oder,法兰克福,Frankfurtu,Frankfurtu,Francoforte
31,France,Frankreich,Франция,França,França,フランス共和国,فرانسه,France,法国,Francia,Francie,Francia
33,Germany,Deutschland,Германия,Alemanha,Alemanha,ドイツ連邦共和国,آلمان,Allemagne,德国,Alemania,Německo,Germania
151541,Yongsan,Yongsan,Ёнсан,,,龍山,,Yongsan,龙山,Yongsan,Yongsan,Yongsan
3377,Toledo,Toledo,Толедо,,,トレド,,Tolède,托莱多,Toledo,Toledo,Toledo
239906,Federal Republic of Germany,,,,,,,,,,,
29433,Santa Clarita,Santa Clarita,Санта-Кларита,,,サンタクラリタ,,Santa Clarita,聖塔克拉利塔,Santa Clarita,Santa Clarita,Santa Clarita
240035,Republic of Korea,,,,,,,,,,,
36,United Kingdom,Vereinigtes Königreich,Великобритания,Reino Unido,Reino Unido,イギリス,بریتانیا,Royaume-Uni,英国,Reino Unido,Spojené království Velké Británie a Severního Irska,Regno Unito
43586,Zhoushan,Zhoushan,Чжоушань,,,舟山だ,,Zhoushan,周山,Zhoushan,Zhoushan,Zhoushan
227578,Dollard-des Ormeaux,Dollard-des Ormeaux,Доллард-де-Ормо,,,ドルラール・ド・オルモー,,Dollard-des Ormeaux,奧爾莫美元,Dollard-des Ormeaux,Dolard-des Ormeaux,Dollard-des Ormeaux
3630,Paris,Paris,Париж,,,パリだ,,Paris,巴黎,París,Paříž,Parigi
239920,Republic of France,,,,,,,,,,,
562,Berlin,Berlin,Берлин,베를린,Berlim,ベルリン,برلین,Berlin,柏林,Berlín,Berlín,Berlino
614,Maine,Maine,Мэн,메인 주,,メイン州,مین,Maine,缅因州,Maine,Maine,- Maine
239922,United Kingdom of Great Britain and Northern Ireland,,,,,,,,,,,
4758,Derby,Derby,Дерби,더비,,ダービー,داربی، انگلستان,Derby,德比,Derby,Derby,Derby
135056,Île-de-France,Île-de-France,Иль-де-Франс,,,イル ＝ ド ＝ フランス,,Île-de-France,法兰西岛,Isla de Francia,Île-de-France,Île-de-France
2200,Derbyshire,Derbyshire,Дербишир,더비셔 주,,ダービーシャー,دربیشر,Derbyshire,德比郡,Derbyshire,Derbyshire,- Derbyshire
3630,Paris,Paris,Париж,,,パリだ,,Paris,巴黎,París,Paříž,Parigi
4475,Salt Lake County,Salt Lake,Солт-Лейк,,Condado de Salt Lake,ソルトレイク郡,شهرستان سالتلیک، یوتا,Comté de Salt Lake,鹽湖縣,Comté de Salt Lake,Slané jezero,Contea di Salt Lake
240077,Empalme Sauce,,,,,,,,,,,
65,Canada,Kanada,Канада,Canadá,Canadá,カナダ,کانادا,Canada,加拿大,Canadá,Kanada,Canada
360,England,England,Англия,Inglaterra,Inglaterra,イングランド,انگلستان,Angleterre,英格兰,Inglaterra,Anglie,Inghilterra
37649,Cottonwood Heights,Cottonwood Heights,Коттонвуд Хайс,,,コットンウッドハイツ,کاتنوود هایتس، یوتا,Cottonwood Heights,卡顿高地,Cottonwood Heights,Cottonwood Heights,Cottonwood Heights
5830,Penobscot County,Penobscot,Пенобскот,,Condado de Penobscot,ペノブスコット郡,شهرستان پنوباسکات، مین,Comté de Penobscot,佩諾布斯科特縣,Пенобскот,Penobscot,Contea di Penobscot
362,California,Kalifornien,Калифорния,Califórnia,Califórnia,カリフォルニアだ,کالیفرنیا,Californie,加州,California,Kalifornie,California
586,Utah,Utah,Юта,Utá,Utá,ユタ州,یوتا,Utah,犹他州,Utah,Utahu,Utah
356,Hesse,Hessen,Гессен,헤센 주,,ヘッセン,,Hesse,黑森,Hessen,Hesensko,Assia
2081,Canelones,Canelones,Канелоны,Canelones,Canelones,カネロネス,,Canelones,卡内洛内斯省,Canelones,Canelones,Caneloni
91,Uruguay,Uruguay,Уругвай,Uruguai,Uruguai,ウルグアイ共和国,اوروگوئه,Uruguay,乌拉圭,Uruguay,Uruguay,Uruguay
137131,Montréal,Montréal,Монреаль,,,モントリオール,,Montréal,蒙特利尔,Montréal,Montréal,Montréal
744,Montevideo,Montevideo,Монтевидео,,,モンテビデオ,,Montevideo,蒙得维的亚,Montevideo,Montevideo,Montevideo
4588,Ottawa,Ottawa,Оттава,Otava,Condado de Ottawa,オタワ,شهرستان اتاوا، اکلاهما,Ottawa,渥太華縣,Ottawa,Ottawa,Ottawa
598,Quebec,Quebec,Квебек,Quebeque,Quebeque,ケベック州,,Québec,魁北克省,Quebec,Quebec,Quebec
1650,London,London,Лондон,London,,ロンドン,,London,伦敦,London,Londýn,Londra
33431,Bangor,Bangor,Бангор,,,バンガー,,Bangor,班戈尔,Bangor,Bangor,Bangor
283,Seoul,Seoul,Сеул,서울특별시,,ソウル特別市,,Séoul,首尔特别市,Soul,Soul,Seul3. db-country.csv.gz
This file contains standardized country metadata for the IP Location Database. It includes continent codes and names, ISO-2/ISO-3/IOC country codes, country and official names (as place IDs), capital (place ID), currency (code, name, symbol), international calling codes, top-level domains (TLDs), and supported language tags.
| Field | Type | Description | Can be empty? | Example |
|---|---|---|---|---|
| id | number | The unique identifier for the country. | No | 192 |
| continent_code | string | The continent code associated with the country. | No | NA |
| continent_name_place_id | number | The unique identifier for the continent place. | No | 6255148 |
| country_code2 | string | The ISO 3166-1 alpha-2 code of the country. | No | US |
| country_code3 | string | The ISO 3166-1 alpha-3 code of the country. | No | USA |
| country_code_ioc | string | The IOC country code. | No | USA |
| country_name_place_id | number | The unique identifier for the country place. | No | 6252001 |
| country_name_official_place_id | number | The unique identifier for the official country place. | No | 6252001 |
| country_capital_place_id | number | The unique identifier for the capital place. | No | 5375480 |
| currency_code | string | The ISO 4217 currency code of the country. | No | USD |
| currency_name | string | The name of the currency used in the country. | No | United States Dollar |
| currency_symbol | string | The symbol of the currency used in the country. | No | $ |
| calling_code | string | The international calling code of the country. | No | +1 |
| tld | string | The top-level domain (TLD) of the country. | No | .us |
| languages | string | The official languages spoken in the country, represented as a comma-separated list of ISO 639-1 codes. | No | en,es |
I. Example Records
id,continent_code,continent_name_place_id,country_code2,country_code3,country_code_ioc,country_name_place_id,country_name_official_place_id,country_capital_place_id,currency_code,currency_name,currency_symbol,calling_code,tld,languages
173,SA,8,UY,URY,URU,91,240020,744,UYU,Peso Uruguayo,$U,+598,.uy,es-UY
29,NA,6,CA,CAN,CAN,65,65,4588,CAD,Canadian Dollar,C$,+1,.ca,"en-CA,fr-CA,iu"
172,NA,6,US,USA,USA,28,240018,240019,USD,US Dollar,$,+1,.us,"en-US,es-US,haw,fr"
41,EU,7,DE,DEU,GER,33,239906,562,EUR,Euro,€,+49,.de,de
193,AS,5,KR,KOR,KOR,24,240035,283,KRW,Won,₩,+82,.kr,"ko-KR,en"
56,EU,7,FR,FRA,FRA,31,239920,3630,EUR,Euro,€,+33,.fr,"fr-FR,frp,br,co,ca,eu,oc"
58,EU,7,GB,GBR,GBR,36,239922,1650,GBP,Pound Sterling,£,+44,.uk,"en-GB,cy-GB,gd"
35,AS,5,CN,CHN,CHN,12,239901,275,CNY,Yuan Renminbi,¥,+86,.cn,"zh-CN,yue,wuu,dta,ug,za"4. File Relationship Diagram
The diagram below illustrates the relationships between the various files included in the CSV database package. It shows how the main CSV file connects to reference tables for countries, states, districts, and cities, ensuring consistent and accurate geolocation data across different regions and languages.
File Format & Encoding
All IP to Country CSV datasets are provided in UTF-8 encoding, comma-separated, and compressed with Gzip (.csv.gz). Each file includes a header row listing the field names for clarity and consistency.
Field values are unquoted by default, with quotes applied only in the following cases:
- Line breaks within text fields.
- Commas inside a value (e.g., addresses).
- Lists of values (e.g., languages).
- Spaces that may be auto-quoted by export tools.
MMDB Database Documentation
1. Overview
The MMDB version of our IP to Country is delivered as a ZIP archive that includes a single MMDB file with all geolocation data (including multilingual place fields), a README file, and a checksum file. It's optimized for fast lookups in applications and services, making it ideal for real-time queries and direct integration into your systems.
2. Archive Content
After downloading and extracting the IP to Country MMDB database archive, you'll find the following files (with their types noted):
db-ip-country.mmdbCountry-level geolocation database with IP ranges, multilingual country names, codes, capital, currency, languages, and related metadata.
- File Size: 22.68 MB
- Entries: 38.5M
README.mdDocumentation for dataset contents, schema, usage, and support.
- File Size: 8.48 KB
checksum.txtSHA-256 checksums for verifying file integrity.
- File Size: 161 Bytes
Response Schema
This section describes the structure of the data returned from the IP to Country MMDB file. Each field is detailed with its type, meaning, and example values to help you interpret responses and integrate them into your applications.
1. db-ip-country.mmdb
This file contains standardized country and continent details. It includes multilingual country and capital names, ISO codes (ISO-2/ISO-3/IOC), currency details, international calling codes, top-level domains (TLDs), and language tags.
2. Field Reference
The following reference lists all fields available in the MMDB response. Each entry includes the field path, its description, data type, and example value to help you understand how to parse and integrate the data.
| Field | Type | Description | Example |
|---|---|---|---|
location | object | ||
location.country | object | The name of the country in multiple languages. | |
location.country.continent | object | The name of the continent in multiple languages. | |
location.country.continent.name | object | The name of the continent in multiple languages (English, German, Russian, Korean, Portuguese, Japanese, Persian, French, Chinese, Spanish, Czech, Italian). | North America |
location.country.continent.code | string | The two-letter code representing the continent. | NA |
location.country.name | object | The name of the country in multiple languages (English, German, Russian, Korean, Portuguese, Japanese, Persian, French, Chinese, Spanish, Czech, Italian). | United States |
location.country.name_official | object | The official name of the country in multiple languages (English, German, Russian, Korean, Portuguese, Japanese, Persian, French, Chinese, Spanish, Czech, Italian). | United States of America |
location.country.code2 | string | The two-letter code representing the country. | US |
location.country.code3 | string | The three-letter code representing the country. | USA |
location.country.code_ioc | string | The International Olympic Committee (IOC) code representing the country. | USA |
location.country.capital | object | The capital city of the country in multiple languages (English, German, Russian, Korean, Portuguese, Japanese, Persian, French, Chinese, Spanish, Czech, Italian). | Washington, D.C. |
location.country.currency | object | The currency used in the country. | |
location.country.currency.code | string | The three-letter code representing the currency, following ISO 4217 standards. | USD |
location.country.currency.symbol | string | The symbol representing the currency. | $ |
location.country.currency.name | string | The name of the currency. | United States Dollar |
location.country.metadata | object | Additional metadata about the country. | |
location.country.metadata.calling_code | string | The international calling code for the country. | +1 |
location.country.metadata.tld | string | The top-level domain (TLD) for the country. | .us |
location.country.metadata.languages | string | The languages spoken in the country. | ru,en,es etc |
I. Example Records
{
"location": {
"country": {
"capital": {
"cs": "Soul",
"de": "Seoul",
"en": "Seoul",
"es": "Soul",
"fa": "",
"fr": "Séoul",
"it": "Seul",
"ja": "ソウル特別市",
"ko": "서울특별시",
"pt": "",
"ru": "Сеул",
"zh": "首尔特别市"
},
"code2": "KR",
"code3": "KOR",
"code_ioc": "KOR",
"continent": {
"code": "AS",
"name": {
"cs": "Asie",
"de": "Asien",
"en": "Asia",
"es": "Asia",
"fa": " آسیا",
"fr": "Asie",
"it": "Asia",
"ja": "アジア",
"ko": "Ásia",
"pt": "Ásia",
"ru": "Азия",
"zh": "亚洲"
}
},
"currency": {
"code": "KRW",
"name": {
"en": "Won"
},
"symbol": "₩"
},
"metadata": {
"calling_code": "+82",
"languages": "ko-KR,en",
"tld": ".kr"
},
"name": {
"cs": "Jižní Korea",
"de": "Korea, Republik (Südkorea)",
"en": "South Korea",
"es": "Jižní Korea",
"fa": "کرهٔ جنوبی",
"fr": "Corée, République de",
"it": "Corea del Sud",
"ja": "大韓民国",
"ko": "대한민국",
"pt": "Coreia do Sul",
"ru": "Республика Корея",
"zh": "韩国"
},
"name_official": {
"cs": "",
"de": "",
"en": "Republic of Korea",
"es": "",
"fa": "",
"fr": "",
"it": "",
"ja": "",
"ko": "",
"pt": "",
"ru": "",
"zh": ""
}
}
}
}Database Integrity & Authenticity Verification
There are two methods of verifying the integrity and authenticity of our Database:
1. Using the Signature File (Recommended)
IPGeolocation.io signs every database release to ensure its authenticity and integrity. This allows customers to verify that a downloaded IP to Country database file originates directly from IPGeolocation.io and has not been altered, corrupted, or tampered with during transfer or storage.
Each database update includes a corresponding signature file, generated using our private signing key. Customers can validate the database using the provided public verification key. To verify a database file, you need:
- Database file (the downloaded archive)
- Signature file (the matching signature for that archive)
- Public key (public-key.pem)
These files are available via official IPGeolocation.io download endpoints and are also shared in database update notifications.
2. Using the Checksum File (Legacy)
Each database archive includes a checksum.txt file containing the SHA-256 checksums for the files packaged in the archive. You can use this file to validate that the extracted contents are complete and unchanged.
Data Format & Constraints
- All fields defined in the schema are always present in the IP to Country MMDB response.
- Fields may contain empty strings (""), but never null, so null checks are not required.
- Place names such as countries, states, districts, and cities are available in multiple translations.
- All text values are encoded in UTF-8.
- Field names and response structure remain stable across updates for backward compatibility.
Database Updates & Delivery
When you subscribe to our IP to Country database, we'll send you static download links. These links never change, so you can use them both for your initial download and for all future updates. You will receive:
- Database Archive URL : downloads the latest release of your subscribed database (CSV, MMDB or requested formats).
- Signature File URL : downloads the matching signature file for the latest release (used for authenticity verification).
- Public Key URL : downloads the public verification key (used with the signature file).
- Status Endpoint URL : returns the database's most recent update timestamp.
Our databases are updated continuously and shipped on a daily or weekly cycle depending on your plan, ensuring you always have access to the most current data. Each time your subscribed dataset is updated, you'll also receive an email notification so you don't miss a release.
For automated workflows, you can check our status endpoint to see the last update timestamp. When the date changes, simply re-fetch the archive using your static download URL to pull the latest version into your system.
