IP Location Database (Advance)

Overview

Our Geo Advance IP to Geolocation Database provides you with precise city level geolocation data for both IPv4 and IPv6 addresses. Compared to our Geo Standard 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. Our collection pipelines run nonstop, around the clock, with database updates delivered on a daily or weekly cadence depending on your subscription plan. The dataset is available in CSV and MMDB, with JSON, Parquet, or any custom format on request at no extra cost, all backed by stable schemas and changelogs.

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: 578.30 MB

Entries: 39.2M

Fields: 16

Last Updated: Yesterday

Documentation

MMDB

File Size: 784.26 MB

Entries: 39.2M

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):

checksum.txt

SHA-256 checksums for verifying file integrity.

File Size: 330 Bytes

db-place.csv.gz

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

File Size: 28.00 MB

Entries: 415.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: 550.28 MB

Entries: 39.2M

Fields: 16

db-country.csv.gz

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

File Size: 9.68 KB

Entries: 254

Fields: 15

README.md

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

File Size: 9.79 KB

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	ISO 3166-2 subdivision code, including the country prefix	Yes	US-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	string	The accuracy radius in kilometers for the location associated with the IP range.	No	4.691
confidence	string	The confidence level (high, medium, low) of the location data associated with the IP range.	No	high
dma_code	string	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	string	The latitude coordinate of the location associated with the IP range.	No	37.3861
longitude	string	The longitude coordinate of the location associated with the IP range.	No	-122.0838
geo_name_id	string	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., DSL, Cable, Fiber, Fixed Broadband, Mobile).	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
222.169.161.23,222.169.161.31,35,1386,CN-JL,12923,52771,7.328,medium,,134300,41.9425,126.42784,12167705,Asia/Shanghai,Fixed Broadband
76.214.70.111,76.214.70.111,172,363,US-CA,3948,3965,9.711,high,803,91403,34.14239,-118.4572,5395249,America/Los_Angeles,DSL
190.29.175.59,190.29.175.59,36,1298,CO-ANT,143178,8783,4.2,high,,050015,6.24861,-75.57425,11887465,America/Bogota,DSL
151.177.52.85,151.177.52.85,148,367,SE-AB,241715,367,9.718,high,,111 52,59.32932,18.06858,2673730,Europe/Stockholm,Fixed Broadband
97.113.24.153,97.113.24.153,172,401,US-WA,4501,24100,13.288,medium,819,98164,47.60614,-122.33285,7200219,America/Los_Angeles,Fixed Broadband
73.232.3.121,73.232.3.121,172,374,US-TX,4523,4485,4.247,high,618,77064,29.922905,-95.565753,4741966,America/Chicago,Cable
183.129.173.136,183.129.173.151,35,1276,CN-ZJ,39465,39465,14.873,medium,,310015,30.31968,120.14209,7735247,Asia/Shanghai,Fixed Broadband
79.30.90.8,79.30.90.8,80,368,IT-62,277716,30357,2.947,high,,00187,41.89671,12.4822,6487803,Europe/Rome,DSL
46.52.55.1,46.52.55.1,143,390180,SA-03,241882,222236,8.916,high,,42311,24.46721,39.60245,10063556,Asia/Riyadh,Fixed Broadband
71.63.141.243,71.63.141.243,172,600,US-OR,4997,28342,5.664,high,820,97204,45.51523,-122.67839,7534069,America/Los_Angeles,Cable

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
240003,Kingdom of Saudi Arabia,Saudi-Arabien,Саудовская Аравия,사우디아라비아,Arábia Saudita,サウジアラビア,پادشاهی عربستان سعودی,Arabie saoudite,沙特阿拉伯,Arabia Saudita,Saúdská Arábie,Arabia Saudita
4485,Houston,Houston,Хьюстон,휴스턴,Houston,ヒューストン,هیوستون,Houston,休斯顿,Houston,Houston,Houston
6,Asia,Asien,Азия,아시아,Ásia,アジア,آسیا,Asie,亚洲,Asia,Asie,Asia
240006,Kingdom of Sweden,Schweden,Швеция,스웨덴,Suécia,スウェーデン,پادشاهی سوئد,Suède,瑞典,Suecia,Švédsko,Svezia
8,Europe,Europa,Европа,유럽,Europa,ヨーロッパ,اروپا,Europe,欧洲,Europa,Evropa,Europa
9,South America,Südamerika,Южная Америка,남아메리카,América do Sul,南アメリカ,آمریکای جنوبی,Amérique du Sud,南美洲,América del Sur,Jižní Amerika,America del Sud
266,Beijing,Peking,Пекин,베이징,Pequim,北京,پکن,Pékin,北京,Pekín,Peking,Pechino
7,North America,Nordamerika,Северная Америка,북아메리카,América do Norte,北アメリカ,آمریکای شمالی,Amérique du Nord,北美洲,América del Norte,Severní Amerika,America del Nord
4997,Multnomah County,Multnomah County,Округ Малтнома,멀트노마 카운티,Condado de Multnomah,マルチノマ郡,شهرستان مالتنوم,Comté de Multnomah,穆尔特诺马县,Condado de Multnomah,Okres Multnomah,Contea di Multnomah
13,China,China,Китай,중국,China,中国,چین,Chine,中国,China,Čína,Cina
401,Washington,Washington,Вашингтон,워싱턴,Washington,ワシントン,واشنگتن,Washington,华盛顿,Washington,Washington,Washington
1298,Antioquia,Antioquia,Антьокия,안티오키아,Antioquia,アンティオキア,آنتیوکیا,Antioquia,安蒂奥基亚,Antioquia,Antioquia,Antioquia
4501,King County,King County,Округ Кинг,킹 카운티,Condado de King,キング郡,شهرستان کینگ,Comté de King,金县,Condado de King,King County,King County
30357,Pigna,Pigna,Пинья,피냐,Pigna,ピニャ,پینیا,Pigna,皮尼亚,Pigna,Pigna,Pigna
26,Italy,Italien,Италия,이탈리아,Itália,イタリア,ایتالیا,Italie,意大利,Italia,Itálie,Italia
240027,United States of America,Vereinigte Staaten von Amerika,Соединённые Штаты Америки,미국,Estados Unidos da América,アメリカ合衆国,ایالات متحده آمریکا,États-Unis d'Amérique,美利坚合众国,Estados Unidos de América,Spojené státy americké,Stati Uniti d'America
240028,"Washington, D.C.","Washington, D.C.",Вашингтон,워싱턴 D.C.,"Washington, D.C.",ワシントンD.C.,واشنگتن دی.سی.,"Washington, D.C.",华盛顿哥伦比亚特区,"Washington, D.C.","Washington, D.C.","Washington, D.C."
222236,Madinah,Medina,Медина,메디나,Medina,マディーナ,مدینه,Médine,麦地那,Medina,Medína,Medina
31,Sweden,Schweden,Швеция,스웨덴,Suécia,スウェーデン,سوئد,Suède,瑞典,Suecia,Švédsko,Svezia
52771,Baishan,Baishan,Байшань,바이산,Baishan,白山,بایشان,Baishan,白山,Baishan,Baishan,Baishan
24100,Seattle,Seattle,Сиэтл,시애틀,Seattle,シアトル,سیتل,Seattle,西雅图,Seattle,Seattle,Seattle
390180,Medina Region,Region Medina,Регион Медина,메디나 지역,Região de Medina,メディナ地方,منطقه مدینه,Région de Médine,麦地那地区,Región de Medina,Region Medina,Regione di Medina
239910,People’s Republic of China,Volksrepublik China,Китайская Народная Республика,중화인민공화국,República Popular da China,中華人民共和国,جمهوری خلق چین,République populaire de Chine,中华人民共和国,República Popular China,Čínská lidová republika,Repubblica Popolare Cinese
239911,Republic of Colombia,Republik Kolumbien,Республика Колумбия,콜롬비아 공화국,República da Colômbia,コロンビア共和国,جمهوری کلمبیا,République de Colombie,哥伦比亚共和国,República de Colombia,Kolumbijská republika,Repubblica di Colombia
39,United States,Vereinigte Staaten,Соединенные Штаты,미국,Estados Unidos,アメリカ合衆国,ایالات متحده آمریکا,États-Unis,美国,Estados Unidos,Spojené státy americké,Stati Uniti
39465,Hangzhou,Hangzhou,Ханчжоу,항저우,Hangzhou,杭州,هانگژو,Hangzhou,杭州,Hangzhou,Hangzhou,Hangzhou
4523,Harris County,Harris County,Округ Харрис,해리스 카운티,Condado de Harris,ハリス郡,شهرستان هریس,Comté de Harris,哈里斯县,Condado de Harris,Okres Harris,Contea di Harris
2091,Riyadh,Riad,Рияд,리야드,Riade,リヤド,ریاض,Riyadh,利雅得,Riad,Rijád,Riyadh
241715,Stockholms Kommun,Stockholmer Kommune,Стокгольмская коммуна,스톡홀름 시,Município de Estocolmo,ストックホルム市,شهرداری استکهلم,Commune de Stockholm,斯德哥尔摩市,Municipio de Estocolmo,Stockholmská obec,Comune di Stoccolma
28342,Portland,Portland,Портленд,포틀랜드,Portland,ポートランド,پورتلند,Portland,波特兰,Portland,Portland,Portland
61,Saudi Arabia,Saudi-Arabien,Саудовская Аравия,사우디아라비아,Arábia Saudita,サウジアラビア,عربستان سعودی,Arabie saoudite,沙特阿拉伯,Arabia Saudita,Saúdská Arábie,Arabia Saudita
28740,Bogota,Bogotá,Богота,보고타,Bogotá,ボゴタ,بوگوتا,Bogota,波哥大,Bogotá,Bogota,Bogotá
143178,Medellín,Medellín,Медельин,메데인,Medellín,メデジン,مدئین,Medellín,麦德林,Medellín,Medellín,Medellín
239948,Republic of Italy,Republik Italien,Итальянская Республика,이탈리아 공화국,República Italiana,イタリア共和国,جمهوری ایتالیا,République italienne,意大利共和国,República Italiana,Italská republika,Repubblica Italiana
8783,Medellin,Medellín,Медельин,메데인,Medellín,メデジン,مدئین,Medellín,麦德林,Medellín,Medellín,Medellín
82,Colombia,Kolumbien,Колумбия,콜롬비아,Colômbia,コロンビア,کلمبیا,Colombie,哥伦比亚,Colombia,Kolumbie,Colombia
277716,Città metropolitana di Roma Capitale,Metropolstadt Rom,Столичный город Рим,로마 수도권,Cidade metropolitana de Roma,ローマ首都圏,شهر متروپولیتن رم,Ville métropolitaine de Rome,罗马首都区,Ciudad metropolitana de Roma,Metropolitní město Řím,Città metropolitana di Roma Capitale
600,Oregon,Oregon,Орегон,오리건,Oregon,オレゴン,اورگان,Oregon,俄勒冈,Oregón,Oregon,Oregon
241882,Madinah Principality,Fürstentum Medina,Эмират Медина,메디나 공국,Principado de Medina,マディーナ公国,امارت مدینه,Principauté de Médine,麦地那公国,Principado de Medina,Medinské knížectví,Principato di Medina
1386,Jilin,Jilin,Цзилинь,지린,Jilin,吉林,جیلین,Jilin,吉林,Jilin,Jilin,Jilin
363,California,Kalifornien,Калифорния,캘리포니아,Califórnia,カリフォルニア,کالیفرنیا,Californie,加利福尼亚,California,Kalifornie,California
3948,Los Angeles County,Los Angeles County,Округ Лос-Анджелес,로스앤젤레스 카운티,Condado de Los Angeles,ロサンゼルス郡,شهرستان لس‌آنجلس,Comté de Los Angeles,洛杉矶县,Condado de Los Ángeles,Okres Los Angeles,Contea di Los Angeles
367,Stockholm,Stockholm,Стокгольм,스톡홀름,Estocolmo,ストックホルム,استکهلم,Stockholm,斯德哥尔摩,Estocolmo,Stockholm,Stoccolma
3951,Rome,Rom,Рим,로마,Roma,ローマ,رم,Rome,罗马,Roma,Řím,Roma
368,Lazio,Latium,Лацио,라치오,Lácio,ラツィオ,لازیو,Latium,拉齐奥,Lacio,Lazio,Lazio
374,Texas,Texas,Техас,텍사스,Texas,テキサス州,تگزاس,Texas,德克萨斯州,Texas,Texas,Texas
12923,Baishan Shi,Baishan Shi,Байшань,바이산시,Baishan Shi,白山市,بایشان,Baishan Shi,白山市,Baishan Shi,Baishan Shi,Baishan Shi
1276,Zhejiang,Zhejiang,Чжэцзян,저장,Zhejiang,浙江,ژجیانگ,Zhejiang,浙江,Zhejiang,Zhejiang,Zhejiang
3965,Los Angeles,Los Angeles,Лос-Анджелес,로스앤젤레스,Los Angeles,ロサンゼルス,لس آنجلس,Los Angeles,洛杉矶,Los Ángeles,Los Angeles,Los Angeles

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	string	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	US 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	Languages spoken in the country, represented as a comma-separated list of BCP 47 / IETF language tags	No	en-US,es-US,haw,fr

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
148,EU,8,SE,SWE,SWE,31,240006,367,SEK,Swedish Krona,kr,+46,.se,"sv-SE,se,sma,fi-SE"
36,SA,9,CO,COL,COL,82,239911,28740,COP,Colombian Peso,$,+57,.co,es-CO
35,AS,6,CN,CHN,CHN,13,239910,266,CNY,Yuan Renminbi,¥,+86,.cn,"zh-CN,yue,wuu,dta,ug,za"
143,AS,6,SA,SAU,KSA,61,240003,2091,SAR,Saudi Riyal,﷼,+966,.sa,ar-SA
80,EU,8,IT,ITA,ITA,26,239948,3951,EUR,Euro,€,+39,.it,"it-IT,de-IT,fr-IT,sc,ca,co,sl"
172,NA,7,US,USA,USA,39,240027,240028,USD,US Dollar,$,+1,.us,"en-US,es-US,haw,fr"

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):

checksum.txt

SHA-256 checksums for verifying file integrity.

File Size: 162 Bytes

db-ip-location.mmdb

The database includes IP ranges, location, multilingual names, country data, coordinates, confidence, time zone, and network details.

File Size: 2.99 GB

Entries: 39.2M

README.md

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

File Size: 11.10 KB

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

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).	{"en":"North America","de":"Nordamerika","ru":"Северная Америка","ko":"북아메리카","pt":"América do Norte","ja":"北アメリカ","fa":"شمال آمریکا","fr":"Amérique du Nord","zh":"北美洲","es":"América del Norte","cs":"Severní Amerika","it":"America del Nord"}
`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).	{"en":"United States","de":"Vereinigte Staaten","ru":"Соединенные Штаты","ko":"미국","pt":"Estados Unidos","ja":"アメリカ合衆国","fa":"ایالات متحده آمریکا","fr":"États-Unis","zh":"美国","es":"Estados Unidos","cs":"Spojené státy","it":"Stati Uniti"}
`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).	{"en":"United States of America","de":"Vereinigte Staaten von Amerika","ru":"Соединенные Штаты Америки","ko":"미국","pt":"Estados Unidos da América","ja":"アメリカ合衆国","fa":"ایالات متحده آمریکا","fr":"États-Unis d'Amérique","zh":"美利坚合众国","es":"Estados Unidos de América","cs":"Spojené státy americké","it":"Stati Uniti d'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).	{"en":"Washington, D.C.","de":"Washington, D.C.","ru":"Вашингтон, округ Колумбия","ko":"워싱턴 D.C.","pt":"Washington, D.C.","ja":"ワシントンD.C.","fa":"واشنگتن دی سی","fr":"Washington, D.C.","zh":"华盛顿特区","es":"Washington D.C.","cs":"Washington, D.C.","it":"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`	object	The name of the currency.	{"en":"US 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.	en-US,es-US,haw,fr
`location.state`	object	The name of the state in multiple languages.
`location.state.name`	object	The name of the state in multiple languages (English, German, Russian, Korean, Portuguese, Japanese, Persian, French, Chinese, Spanish, Czech, Italian).	{"en":"California","de":"Kalifornien","ru":"Калифорния","ko":"캘리포니아","pt":"Califórnia","ja":"カリフォルニア","fa":"کالیفرنیا","fr":"Californie","zh":"加利福尼亚","es":"California","cs":"Kalifornie","it":"California"}
`location.state.code`	string	ISO 3166-2 subdivision code, including the country prefix	US-CA
`location.district`	object	The name of the district in multiple languages.
`location.district.name`	object	The name of the district in multiple languages (English, German, Russian, Korean, Portuguese, Japanese, Persian, French, Chinese, Spanish, Czech, Italian).	{"en":"Santa Clara County","de":"Santa Clara County","ru":"Округ Санта-Клара","ko":"산타클라라 카운티","pt":"Condado de Santa Clara","ja":"サンタクララ郡","fa":"شهرستان سانتا کلارا","fr":"Comté de Santa Clara","zh":"圣克拉拉县","es":"Condado de Santa Clara","cs":"Okres Santa Clara","it":"Contea di Santa Clara"}
`location.city`	object	The name of the city in multiple languages.
`location.city.name`	object	The name of the city in multiple languages (English, German, Russian, Korean, Portuguese, Japanese, Persian, French, Chinese, Spanish, Czech, Italian).	{"en":"Mountain View","de":"Mountain View","ru":"Маунтин-Вью","ko":"마운틴 뷰","pt":"Mountain View","ja":"マウンテンビュー","fa":"مونتین ویو","fr":"Mountain View","zh":"山景","es":"Mountain View","cs":"Mountain View","it":"Mountain View"}
`location.coordinates`	object	The geographical coordinates of the location associated with the IP range.
`location.coordinates.latitude`	string	The latitude coordinate of the location associated with the IP range.	37.3861
`location.coordinates.longitude`	string	The longitude coordinate of the location associated with the IP range.	-122.0838
`location.zipcode`	string	The postal code for the location associated with the IP range.	94043
`location.geoname_id`	string	The GeoNames ID for the location associated with the IP range.	5375480
`location.accuracy_radius`	string	The accuracy radius in kilometers for the location associated with the IP range.	4.691
`location.confidence`	string	The confidence level (high, medium, low) of the location data associated with the IP range.	high
`location.dma_code`	string	The Designated Market Area (DMA) code for the location associated with the IP range.	807
`time_zone`	string	The time zone name for the location associated with the IP range.	America/Los_Angeles
`connection_type`	string	The type of internet connection associated with the IP range (e.g., DSL, Cable, Fiber, Fixed Broadband, Mobile).	Cable

2. Example Records

Example

{
  "connection_type": "Fixed Broadband",
  "location": {
    "accuracy_radius": "7.328",
    "city": {
      "name": {
        "cs": "Baishan",
        "de": "Baishan",
        "en": "Baishan",
        "es": "Baishan",
        "fa": "بایشان",
        "fr": "Baishan",
        "it": "Baishan",
        "ja": "白山",
        "ko": "바이산",
        "pt": "Baishan",
        "ru": "Байшань",
        "zh": "白山"
      }
    },
    "confidence": "medium",
    "coordinates": {
      "latitude": "41.9425",
      "longitude": "126.42784"
    },
    "country": {
      "capital": {
        "cs": "Peking",
        "de": "Peking",
        "en": "Beijing",
        "es": "Pekín",
        "fa": "پکن",
        "fr": "Pékin",
        "it": "Pechino",
        "ja": "北京",
        "ko": "베이징",
        "pt": "Pequim",
        "ru": "Пекин",
        "zh": "北京"
      },
      "code2": "CN",
      "code3": "CHN",
      "code_ioc": "CHN",
      "continent": {
        "code": "AS",
        "name": {
          "cs": "Asie",
          "de": "Asien",
          "en": "Asia",
          "es": "Asia",
          "fa": "آسیا",
          "fr": "Asie",
          "it": "Asia",
          "ja": "アジア",
          "ko": "아시아",
          "pt": "Ásia",
          "ru": "Азия",
          "zh": "亚洲"
        }
      },
      "currency": {
        "code": "CNY",
        "name": {
          "en": "Yuan Renminbi"
        },
        "symbol": "¥"
      },
      "metadata": {
        "calling_code": "+86",
        "languages": "zh-CN,yue,wuu,dta,ug,za",
        "tld": ".cn"
      },
      "name": {
        "cs": "Čína",
        "de": "China",
        "en": "China",
        "es": "China",
        "fa": "چین",
        "fr": "Chine",
        "it": "Cina",
        "ja": "中国",
        "ko": "중국",
        "pt": "China",
        "ru": "Китай",
        "zh": "中国"
      },
      "name_official": {
        "cs": "Čínská lidová republika",
        "de": "Volksrepublik China",
        "en": "People’s Republic of China",
        "es": "República Popular China",
        "fa": "جمهوری خلق چین",
        "fr": "République populaire de Chine",
        "it": "Repubblica Popolare Cinese",
        "ja": "中華人民共和国",
        "ko": "중화인민공화국",
        "pt": "República Popular da China",
        "ru": "Китайская Народная Республика",
        "zh": "中华人民共和国"
      }
    },
    "district": {
      "name": {
        "cs": "Baishan Shi",
        "de": "Baishan Shi",
        "en": "Baishan Shi",
        "es": "Baishan Shi",
        "fa": "بایشان",
        "fr": "Baishan Shi",
        "it": "Baishan Shi",
        "ja": "白山市",
        "ko": "바이산시",
        "pt": "Baishan Shi",
        "ru": "Байшань",
        "zh": "白山市"
      }
    },
    "dma_code": "",
    "geoname_id": "12167705",
    "state": {
      "code": "CN-JL",
      "name": {
        "cs": "Jilin",
        "de": "Jilin",
        "en": "Jilin",
        "es": "Jilin",
        "fa": "جیلین",
        "fr": "Jilin",
        "it": "Jilin",
        "ja": "吉林",
        "ko": "지린",
        "pt": "Jilin",
        "ru": "Цзилинь",
        "zh": "吉林"
      }
    },
    "zipcode": "134300"
  },
  "time_zone": "Asia/Shanghai"
}

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.io 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-place.csv.gz: OK
db-ip-location.csv.gz: OK
db-country.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 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.

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