IP Location Database (Advance)

Overview

Our Advanced Tier IP to Geolocation Database provides you with precise city level geolocation data for both IPv4 and IPv6 addresses. Compared to our Standard Tier IP to Geolocation Database, it adds extra fields such as accuracy radius, confidence score, and DMA codes (DMA codes are available in the USA only) to give you the pinpoint accuracy you need to make tighter decisions.

Every IP range is linked to countries, states, districts, and cities, with multilingual place names resolved through reference tables for consistency. This structure makes it easy to join datasets and work with standardized metadata across different regions and languages. We update our databases every single day, and it's available in CSV, MMDB, or custom formats to fit your needs.

Below, you'll find full documentation of the archive contents, schema definitions, file specifications, and integration notes to help you get up and running quickly.

Available Database Formats

CSV

File Size: 464.28 MB

Entries: 30.3M

Fields: 16

Last Updated: Yesterday

Documentation

MMDB

File Size: 2.60 GB

Entries: 30.3M

Fields: 16

Last Updated: Yesterday

Documentation

CSV Database Documentation

1. Overview

The CSV version of our Advance IP to Location Database 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 Advance IP to Location CSV database archive, you'll find the following files (with their types noted):

db-country.csv.gz

Standardized country and continent metadata with codes, currency, calling codes, TLDs, and languages.

File Size: 9.67 KB

Entries: 254

Fields: 15

db-place.csv.gz

Multilingual place names for cities, districts, states, countries, and continents.

File Size: 13.07 MB

Entries: 343.5K

Fields: 13

db-ip-location.csv.gz

IP ranges mapped to locations with place IDs (for multilingual responses), ZIP codes, coordinates, time zone, and connection type.

File Size: 451.20 MB

Entries: 30.3M

Fields: 16

README.md

Documentation for dataset contents, schema, usage, and support.

File Size: 9.79 KB

checksum.txt

SHA-256 checksums for verifying file integrity.

File Size: 330 Bytes

Schema

This section describes the schema of each file included in the Advance IP to Location Database archive. For every file, you'll find its purpose, field definitions, and examples to help with integration.

1. db-ip-location.csv.gz

This file provides geolocation data for IPv4 and IPv6 ranges, mapped down to the city level. Each record links an IP block to country, state, district, and city (through place IDs for multilingual response), geographic coordinates, time zone, GeoNames ID, and connection type. It also includes accuracy radius, confidence level, and DMA codes (U.S. only) for finer and more granular details.

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
state_place_id	number	The unique identifier for the state or province associated with the IP range.	Yes	5332921
state_code	string	The two-letter code representing the state or province with country-code, following ISO 3166-2 standards.	Yes	CA
district_place_id	number	The unique identifier for the district associated with the IP range.	Yes	5332923
city_place_id	number	The unique identifier for the city associated with the IP range.	Yes	5375480
accuracy_radius	number	The accuracy radius in kilometers for the location associated with the IP range.	No	20
confidence	number	The confidence level (0-100) of the location data associated with the IP range.	No	95
dma_code	number	The Designated Market Area (DMA) code for the location associated with the IP range.	Yes	807
zip_code	string	The postal code for the location associated with the IP range.	Yes	94043
latitude	number	The latitude coordinate of the location associated with the IP range.	No	37.3861
longitude	number	The longitude coordinate of the location associated with the IP range.	No	-122.0838
geo_name_id	number	The GeoNames ID for the location associated with the IP range.	Yes	5375480
time_zone_name	string	The time zone name for the location associated with the IP range.	No	America/Los_Angeles
connection_type	string	The type of internet connection associated with the IP range (e.g., dialup, cable, DSL, fiber, etc.).	Yes	cable

1. Example Records

Example

start_ip,end_ip,country_id,state_place_id,state_code,district_place_id,city_place_id,accuracy_radius,confidence,dma_code,zip_code,latitude,longitude,geo_name_id,time_zone_name,connection_type
155.254.24.4,155.254.24.7,172,589,US-NC,5711,2352,5.313,high,517,28208,35.21297,-80.90971,4485262,America/New_York,Leased Line
97.116.142.120,97.116.142.120,172,377,US-MN,3974,2855,7.24,high,613,55101,44.9537,-93.08996,7214022,America/Chicago,Leased Line
141.95.9.80,141.95.9.95,41,356,DE-HE,57697,57697,9.968,medium,,60311,50.11208,8.68341,6463469,Europe/Berlin,Leased Line
192.99.237.0,192.99.237.255,29,598,CA-QC,209767,52037,9.126,medium,,J6N,45.31396,-73.87629,5896496,America/Toronto,Leased Line
166.70.44.35,166.70.44.35,172,586,US-UT,7690,38275,9.249,high,770,84302,41.51021,-112.0155,5771960,America/Denver,DSL
195.201.248.143,195.201.248.143,41,364,DE-BY,28682,28755,13.065,medium,,93167,49.09745,12.48637,2927917,Europe/Berlin,Wireless
196.210.61.2,196.210.61.2,180,405,ZA-GP,9097,45753,3.495,high,,1600,-26.06915,28.19228,11467764,Africa/Johannesburg,DSL
222.154.246.166,222.154.246.166,128,1225,NZ-AUK,1225,1225,3.626,high,,1010,-36.85088,174.76449,6496059,Pacific/Auckland,DSL
150.195.8.246,150.195.8.246,172,587,US-MO,7246,28374,6.788,high,619,65706,37.33726,-92.90241,9685291,America/Chicago,Broadband
200.175.147.0,200.175.147.255,23,1848,BR-MT,11146,11146,4.901,high,,78005,-15.59546,-56.09258,9884284,America/Cuiaba,Dial-Up/ISDN

2. 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

2. Example Records

Example

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
4,Oceania,Ozeanien,Океания,Oceania,Oceania,オセアニア,اقیانوسیه,Océanie,大洋洲,Oceanía,Oceánie,Oceania
405,Gauteng,Gauteng,Гаутенг,하우텡 주,,ハウテン州,خاوتنگ,Gauteng,豪登省,Gauteng,Gauteng,Gauteng
6,North America,Nordamerika,Северная Америка,América do Norte,América Do Norte,北アメリカ, امریکای شمالی,Amérique du Nord,北美洲,Norteamérica,Severní Amerika,America del Nord
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
598,Quebec,Quebec,Квебек,Quebeque,Quebeque,ケベック州,,Québec,魁北克省,Quebec,Quebec,Quebec
9,Africa,Afrika,Африка,África,África,アフリカ,افریقا,Afrique,非洲,África,Afrika,Africa
7,Europe,Europa,Европа,Europa,Europa,ヨーロッパ, اروپا,Europe,欧洲,Europa,Evropa,Europa
3974,Ramsey County,Ramsey,Рамси,,Condado de Ramsey,ラムゼー郡,شهرستان رامسی، مینه‌سوتا,Comté de Ramsey,拉姆西縣,Рамси,Ramsey County,Contea di Ramsey
240018,United States of America,,,,,,,,,,,
240019,"Washington, D.C.",,,,,,,,,,,
239894,Federative Republic of Brazil,,,,,,,,,,,
240026,Republic of South Africa,,,,,,,,,,,
356,Hesse,Hessen,Гессен,헤센 주,,ヘッセン,,Hesse,黑森,Hessen,Hesensko,Assia
28,United States,USA,США,Estados Unidos,Estados Unidos,アメリカ合衆国,ایالات متحدهٔ امریکا,États-Unis,美国,Estados Unidos,Spojené státy americké,Stati Uniti d'America
209767,Beauharnois-Salaberry,Beauharnois-Salaberry,Бохарнуа-Салаберри,,,ボアルノワ ＝ サラベリ,,Beauharnois-Salaberry,博哈诺瓦-萨拉贝里,Beauharnois-Salaberry,Beauharnois-Salaberry,Beauharnois-Salaberry
33,Germany,Deutschland,Германия,Alemanha,Alemanha,ドイツ連邦共和国,آلمان,Allemagne,德国,Alemania,Německo,Germania
239906,Federal Republic of Germany,,,,,,,,,,,
28374,Marshfield,Marshfield,Маршалфилд,,,マーシュフィールド,مارشفیلد، ویسکانسین,Marshfield,马什菲尔德,Marshfield,Marshfield,Marshfield
5163,Brasilia,Brasilia,Бразилиа,,,ブラジリア,,Brasilia,巴西利亚,Brasilia,Brasília,Brasilia
45,Brazil,Brasilien,Бразилия,Brasil,Brasil,ブラジル連邦共和国,برزیل,Brésil,巴西,Brasil,Brazílie,Brasile
57697,Frankfurt,Frankfurt (Oder),Франкфурт-на-Одере,,Frankfurt an der Oder,フランクフルト,,Francfort-sur-l'Oder,法兰克福,Frankfurtu,Frankfurtu,Francoforte
562,Berlin,Berlin,Берлин,베를린,Berlim,ベルリン,برلین,Berlin,柏林,Berlín,Berlín,Berlino
53,South Africa,Südafrika,ЮАР,África do Sul,África do Sul,南アフリカ,افریقای جنوبی,Afrique du Sud,南非,Sudáfrica,Jihoafrická republika,Africa del Sud
7690,Box Elder County,Box Elder,Бокс-Элдер,,Condado de Box Elder,ボックスエルダー郡,شهرستان باکس الدر، یوتا,Comté de Box Elder,博克斯埃爾德縣,Бокс-Элдер,Okres Box starší,Contea di Box Elder
1225,Auckland,Auckland,Окленд,Auckland,Auckland,オークランド,اوکلند,Auckland,奧克蘭,Auckland,Auckland,Auckland
38275,Brigham City,Brigham City,Бригам Сити,,,ブリガムシティ,بریگهم سیتی، یوتا,Brigham City,布里格姆城,Brigham City,Brigham City,Brigham Città
13883,Pretoria,Pretoria,Претория,Pretória,,プレトリア,,Pretoria,比勒陀利亚,Pretoria,Pretorii,Pretoria
65,Canada,Kanada,Канада,Canadá,Canadá,カナダ,کانادا,Canada,加拿大,Canadá,Kanada,Canada
589,North Carolina,North Carolina,Северная Каролина,Carolina do Norte,Carolina do Norte,ノースカロライナ州,کارولینای شمالی,Caroline du Nord,北卡罗来纳州,Carolina del Norte,Severní Karolína,Carolina del Nord
5711,Mecklenburg County,Powiat Mecklenburg,Мекленберг,,Condado de Mecklenburg,メクレンバーグ郡,شهرستان مکلنبرگ، کارولینای شمالی,Comté de Mecklenburg,梅克倫堡縣,Мекленберг,Meklenbursko,Distretto di Meclemburgo
586,Utah,Utah,Юта,Utá,Utá,ユタ州,یوتا,Utah,犹他州,Utah,Utahu,Utah
1848,Mato Grosso,Mato Grosso,Мату-Гросу,마투그로수 주,,マットグロッソ州,ماتو گروسو,Mato Grosso,马托格罗索州,Mato Grosso,Mato Grosso,Mato Grosso
89,New Zealand,Neuseeland,Нью Зеландия,Nova Zelândia,Nova Zelândia,ニュージーランド,زلاند نو,Nouvelle-Zélande,新西兰,Nueva Zelanda,Nový Zéland,Nuova Zelanda
28682,Cham,Cham ZG,Хам,,,チャム,شم، سوئیس,cham,卡姆,Cham,Cham,- Cam
587,Missouri,Missouri,Миссури,Missúri,Missúri,ミズーリ州,میزوری,Missouri,密苏里州,Missouri,Missouri,Missouri
9097,Ekurhuleni Metropolitan Municipality,Ekirhuleni (Metropolitan Municipality),Сити муниципалитет Экурхулени,,,エクルレニ都市圏,,Municipalité métropolitaine d'Ekurhuleni,埃库胡莱尼,Metropolitní obec Ekurhuleni,Metropolitní obec Ekurhuleni,Municipalità Metropolitana di Ekurhuleni
739,Wellington,Wellington,Веллингтон,Wellington,Wellington,ウェリントン,,Wellington,惠灵顿,Wellington,Wellington,Wellington
377,Minnesota,Minnesota,Миннесота,Minesota,Minesota,ミネソタ州,مینه‌سوتا,Minnesota,明尼苏达州,Minnesota,Minnesota,Minnesota
2855,Saint Paul,Saint Paul,Сент-Пол,,,聖パウロ,,Saint-Paul,聖保羅,sv. Pavla,sv. Pavla,San Paolo
45753,Edenvale,Edenvale,Эденвейл,,,エデンベール,,Edenvale,埃登维尔,Edenvale,Edenvale,Edenvale
4588,Ottawa,Ottawa,Оттава,Otava,Condado de Ottawa,オタワ,شهرستان اتاوا، اکلاهما,Ottawa,渥太華縣,Ottawa,Ottawa,Ottawa
28755,Falkenstein,Falkenstein,Фалькенштайн,,,ファルケンシュタインだ,,Falkenstein,法尔肯斯坦,Falkenstein,Falkenstein,Falkenstein
52037,Beauharnois,Beauharnois,Бохарнуа,,,ボーアルノワ,بوآرنوآ، کبک,Beauharnois,博哈诺瓦人,Beauharnois,Beauharnois,Beauharnois
11146,Cuiaba,Cuiabá,Куяба,Cuiabá,,クイアバ,,Cuiabá,库亚巴,Cuiaba,Cuiaba,Cuiaba
7246,Webster County,Webster,Уэбстер,,Condado de Webster,ウェブスター郡,شهرستان وبستر، میزوری,Comté de Webster,韋伯斯特縣,Уэбстер,Webster County,Contea di Webster
364,Bavaria,Bayern,Бавария,Baviera,Baviera,バイエルン州,بایرن,Bavière,巴伐利亚,Baviera,Bavorsko,Baviera
2352,Charlotte,Charlotte,Шарлотт,,,シャーロット,,Charlotte,夏洛特,Šarlota,Šarlota,Carlotta

3. 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

3. Example Records

Example

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
172,NA,6,US,USA,USA,28,240018,240019,USD,US Dollar,$,+1,.us,"en-US,es-US,haw,fr"
180,AF,9,ZA,ZAF,RSA,53,240026,13883,ZAR,Rand,R,+27,.za,"zu,xh,af,nso,en-ZA,tn,st,ts,ss,ve,nr"
29,NA,6,CA,CAN,CAN,65,65,4588,CAD,Canadian Dollar,C$,+1,.ca,"en-CA,fr-CA,iu"
23,SA,8,BR,BRA,BRA,45,239894,5163,BRL,Brazilian Real,R$,+55,.br,"pt-BR,es,en,fr"
41,EU,7,DE,DEU,GER,33,239906,562,EUR,Euro,€,+49,.de,de
128,OC,4,NZ,NZL,NZL,89,89,739,NZD,New Zealand Dollar,$,+64,.nz,"en-NZ,mi"

4. File Relationship Diagram

File Format & Encoding

All Advance IP to Location 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 Advance IP to Location 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 Advance IP to Location MMDB database archive, you'll find the following files (with their types noted):

db-ip-location.mmdb

File Size: 2.60 GB

Entries: 30.3M

README.md

Documentation for dataset contents, schema, usage, and support.

File Size: 11.10 KB

checksum.txt

SHA-256 checksums for verifying file integrity.

File Size: 162 Bytes

Response Schema

This section describes the structure of the data returned from the Advance IP to Location 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-geolocation.mmdb

This file provides geolocation data for IPv4 and IPv6 ranges at the city level. Each response includes multilingual country, state, district, and city details, geographic coordinates, time zone, GeoNames ID, and connection type. It also includes accuracy radius, confidence level, and U.S.-only DMA codes for finer, more granular detail.

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.

Showing 2 of 35

Select a field to view details

2. Example Records

Example

{
  "connection_type": "Leased Line",
  "location": {
    "accuracy_radius": "5.313",
    "city": {
      "name": {
        "cs": "Šarlota",
        "de": "Charlotte",
        "en": "Charlotte",
        "es": "Šarlota",
        "fa": "",
        "fr": "Charlotte",
        "it": "Carlotta",
        "ja": "シャーロット",
        "ko": "",
        "pt": "",
        "ru": "Шарлотт",
        "zh": "夏洛特"
      }
    },
    "confidence": "high",
    "coordinates": {
      "latitude": "35.21297",
      "longitude": "-80.90971"
    },
    "country": {
      "capital": {
        "cs": "",
        "de": "",
        "en": "Washington, D.C.",
        "es": "",
        "fa": "",
        "fr": "",
        "it": "",
        "ja": "",
        "ko": "",
        "pt": "",
        "ru": "",
        "zh": ""
      },
      "code2": "US",
      "code3": "USA",
      "code_ioc": "USA",
      "continent": {
        "code": "NA",
        "name": {
          "cs": "Severní Amerika",
          "de": "Nordamerika",
          "en": "North America",
          "es": "Norteamérica",
          "fa": " امریکای شمالی",
          "fr": "Amérique du Nord",
          "it": "America del Nord",
          "ja": "北アメリカ",
          "ko": "América do Norte",
          "pt": "América Do Norte",
          "ru": "Северная Америка",
          "zh": "北美洲"
        }
      },
      "currency": {
        "code": "USD",
        "name": {
          "en": "US Dollar"
        },
        "symbol": "$"
      },
      "metadata": {
        "calling_code": "+1",
        "languages": "en-US,es-US,haw,fr",
        "tld": ".us"
      },
      "name": {
        "cs": "Spojené státy americké",
        "de": "USA",
        "en": "United States",
        "es": "Estados Unidos",
        "fa": "ایالات متحدهٔ امریکا",
        "fr": "États-Unis",
        "it": "Stati Uniti d'America",
        "ja": "アメリカ合衆国",
        "ko": "Estados Unidos",
        "pt": "Estados Unidos",
        "ru": "США",
        "zh": "美国"
      },
      "name_official": {
        "cs": "",
        "de": "",
        "en": "United States of America",
        "es": "",
        "fa": "",
        "fr": "",
        "it": "",
        "ja": "",
        "ko": "",
        "pt": "",
        "ru": "",
        "zh": ""
      }
    },
    "district": {
      "name": {
        "cs": "Meklenbursko",
        "de": "Powiat Mecklenburg",
        "en": "Mecklenburg County",
        "es": "Мекленберг",
        "fa": "شهرستان مکلنبرگ، کارولینای شمالی",
        "fr": "Comté de Mecklenburg",
        "it": "Distretto di Meclemburgo",
        "ja": "メクレンバーグ郡",
        "ko": "",
        "pt": "Condado de Mecklenburg",
        "ru": "Мекленберг",
        "zh": "梅克倫堡縣"
      }
    },
    "dma_code": "517",
    "geoname_id": "4485262",
    "state": {
      "code": "US-NC",
      "name": {
        "cs": "Severní Karolína",
        "de": "North Carolina",
        "en": "North Carolina",
        "es": "Carolina del Norte",
        "fa": "کارولینای شمالی",
        "fr": "Caroline du Nord",
        "it": "Carolina del Nord",
        "ja": "ノースカロライナ州",
        "ko": "Carolina do Norte",
        "pt": "Carolina do Norte",
        "ru": "Северная Каролина",
        "zh": "北卡罗来纳州"
      }
    },
    "zipcode": "28208"
  },
  "time_zone": "America/New_York"
}

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 Advance IP to Location 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.

Note

The public key may be provided as PEM-encoded text. Save it to a file named public-key.pem

Ensure OpenSSL is installed on your system. If not, install it using the following commands

On Linux, if openssl is not installed

sudo apt install openssl

Verify OpenSSL installation:

openssl version

To verify the database file, run the following command, replacing the placeholders with your actual file paths:

openssl dgst -sha256 -verify <path-to-public-key.pem> -signature <path-to-signature-file.sig> <path-to-database-file.zip>

Example output:

Verified OK

if verification FAILED do not use the file, re-download the database and signature from official IPGeolocation endpoints. If the issue persists, please contact our support team.

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.

Tip

Always verify downloaded files with the provided checksum before importing.

On Linux, if sha256sum is not installed, first run:

sudo apt-get install coreutils

Then check the archive files against the checksum file with:

sha256sum -c checksum.txt

Example output:

db-country.csv.gz: OK
db-place.csv.gz: OK
db-ip-location.csv.gz: OK
README.md: OK

*your output may differ depending on the specific database archive you downloaded.

If a file's checksum does not match, FAILED will be shown instead of OK . If verification fails, first confirm that the download completed correctly; if the issue persists, please contact our support team.

Data Format & Constraints

All fields defined in the schema are always present in the Advance IP to Location 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 Advance IP to Location 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 refreshed daily and weekly, 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.

IP Location Database (Advance)

Overview

Available Database Formats

CSV Database Documentation

1. Overview

2. Archive Content

Schema

1. db-ip-location.csv.gz

1. Example Records

2. db-place.csv.gz

2. Example Records

3. db-country.csv.gz

3. Example Records

4. File Relationship Diagram

File Format & Encoding

MMDB Database Documentation

1. Overview

2. Archive Content

Response Schema

1. db-ip-geolocation.mmdb

2. Field Reference

2. Example Records

Database Integrity & Authenticity Verification

1. Using the Signature File (Recommended)

2. Using the Checksum File (Legacy)

Data Format & Constraints

Database Updates & Delivery

Subscribe to Our Newsletter