IPGeolocation.io Databases Portfolio


Overview

IPGeolocation.io provides the following databases:

  • IP Geolocation Database

    Provides detailed geolocation data for IP addresses, including country, region, city, and more.

  • IP Security Database

    Offers security-related information for IP addresses, such as threat intelligence and risk scores.

  • IP to ASN Database

    Identifies the Autonomous System Number (ASN) associated with an IP address, useful for network analysis.

  • IP to Company Database

    Provides company information associated with IP addresses, including organization names and domains.

  • IP Abuse Contact Database

    Maps IP ranges to the responsible network’s abuse-reporting contacts, including email, phone and address.

  • IP WHOIS Database

    Provides WHOIS information for IP addresses, including registrant details and registration dates.

  • ASN WHOIS Database

    Offers WHOIS information for Autonomous System Numbers (ASNs), including organization details and registration data.

  • IP to Hosting Database

    Provides hosting provider information associated with IP addresses, including organization names and domains.

  • Residential Proxy Database

    Identifies residential proxy IP addresses, helping to distinguish between residential and non-residential traffic.


Database Archives

Our location, ASN, company, abuse contact, and security databases are available in CSV and MMDB as standard. The IP WHOIS and ASN WHOIS databases are delivered as Gzip-compressed newline-delimited JSON (NDJSON) as standard. Other formats such as JSON or Parquet, or a custom format, are available on request depending on the dataset, all backed by stable schemas and changelogs. The CSV archives contain several files that reference one another by id, so you can load them as relational tables and join them in queries.

The IP Geolocation Database archive also includes relational database files, like db-places and db-country, which facilitate effective management of geographic and cultural datasets, offering access to multilingual and reference information through unique identifiers.

All databases are delivered on daily and weekly cycles depending on your subscription plan. See each database page for current file sizes and sample data.


Geo DB Relational Files

The db-country and db-places files are part of this relational structure. They ship inside the full database and hold country reference data and multilingual place names, each keyed by a unique id.

DB Places holds place names in 12 languages. Other database files reference its id to look up a place name in any of those languages. DB Country holds country-level details such as continent codes, country codes, currency, and languages.

Together, these relational files enable a highly efficient structure for referencing and managing geographic data, simplifying database queries through the use of ids and providing flexibility in handling multilingual and cross-referenced information across the entire system. For information related to our IP Geolocation API Database, please contact our support.


1. DB Country File

The db-country file provides detailed information about countries, including continent codes, country codes, currency details, and languages. Each country is uniquely identified by an id, and fields such as place IDs for continent name, country name, and country capital reference the db-places file for multilingual support. This relational structure enables efficient access to country-specific data, enhancing geographic and cultural data representation across systems.

You need a valid IPGeolocation API key to download and use this Database. Sign up here and get your free API key if you don’t have one.

I. Reference to DB Country Database File

FieldTypeDescriptionCan Be Empty?Example
idstringThe unique identifier for the country.No192
continent_codestringThe continent code associated with the country.NoNA
continent_name_place_idnumberThe unique identifier for the continent place.No6255148
country_code2stringThe ISO 3166-1 alpha-2 code of the country.NoUS
country_code3stringThe ISO 3166-1 alpha-3 code of the country.NoUSA
country_code_iocstringThe IOC country code.NoUSA
country_name_place_idnumberThe unique identifier for the country place.No6252001
country_name_official_place_idnumberThe unique identifier for the official country place.No6252001
country_capital_place_idnumberThe unique identifier for the capital place.No5375480
currency_codestringThe ISO 4217 currency code of the country.NoUSD
currency_namestringThe name of the currency used in the country.NoUS Dollar
currency_symbolstringThe symbol of the currency used in the country.No$
calling_codestringThe international calling code of the country.No+1
tldstringThe top-level domain (TLD) of the country.No.us
languagesstringLanguages spoken in the country, represented as a comma-separated list of BCP 47 / IETF language tagsNoen-US,es-US,haw,fr

II. 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"

2. DB Places File

The db-places file serves as a relational database, providing place names translated into multiple languages. Each entry is uniquely identified by an id, which is referenced by other database files to retrieve place names in English, German, Russian, Korean, Portuguese, Japanese, Persian, French, Chinese, Spanish, Czech, and Italian. This file facilitates multilingual support and enhances the relational structure of geographic data across various systems.

You need a valid IPGeolocation API key to download and use this Database. Sign up here and get your free API key if you don’t have one.

I. Reference to DB Place Database File

FieldTypeDescriptionCan Be Empty?Example
idnumberThe unique identifier for the place.No5375480
place_englishstringThe name of the place in English.NoMountain View
place_germanstringThe name of the place in German.YesMountain View
place_russianstringThe name of the place in Russian.YesМаунтин-Вью
place_koreanstringThe name of the place in Korean.Yes마운틴 뷰
place_portuguesestringThe name of the place in Portuguese.YesMountain View
place_japanesestringThe name of the place in Japanese.Yesマウンテンビュー
place_persianstringThe name of the place in Farsi.Yesماونتین ویو
place_frenchstringThe name of the place in French.YesMountain View
place_chinesestringThe name of the place in Chinese.Yes山景城
place_spanishstringThe name of the place in Spanish.YesMountain View
place_czechstringThe name of the place in Czech.YesMountain View
place_italianstringThe name of the place in Italian.YesMountain View

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

API SDKs

To facilitate developers, we have added SDKs for various programming languages. Our SDKs are also available on GitHub. Feel free to help us improve them.

Detailed instructions are available on each SDK’s documentation page linked below.

Subscribe to Our Newsletter

Get the latest in geolocation tech, straight to your inbox.