IPGeolocation Databases Portfolio

Overview

IPGeolocation 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

Field	Type	Description	Can be empty?	Example
id	integer	Unique internal identifier for each country record.	No	1
continent_code	string	Standard two-letter code representing the continent.	No	EU
continent_name_place_id	integer	Foreign key linking to `db-place.id` for multilingual continent names.	No	7
country_code2	string	ISO 3166-1 alpha-2 country code (two characters).	No	AD
country_code3	string	ISO 3166-1 alpha-3 country code (three characters).	No	AND
country_code_ioc	string	International Olympic Committee code (three characters).	No	AND
country_name_place_id	integer	Foreign key linking to `db-place.id` for multilingual country names.	No	174
country_name_official_place_id	integer	Foreign key linking to `db-place.id` for multilingual official names of countries.	No	239877
country_capital_place_id	integer	Foreign key linking to `db-place.id` for multilingual countries' capital names.	No	963
currency_code	string	ISO 4217 three-letter currency code.	No	EUR
currency_name	string	Full currency name.	No	Euro
currency_symbol	string	Currency symbol (UTF-8 encoded).	No	€
calling_code	string	International dialing prefix (including +).	No	+376
tld	string	The country's internet top-level domain.	No	.ad
languages	string	Comma-separated list of spoken languages using BCP-47/IETF tags.	No	ca

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
1,EU,7,AD,AND,AND,174,239877,963,EUR,Euro,€,+376,.ad,ca
2,AS,5,AE,ARE,UAE,58,58,420,AED,UAE Dirham,ﺩ.ﺇ,+971,.ae,"ar-AE,fa,en,hi,ur"
3,AS,5,AF,AFG,AFG,101,239878,767,AFN,Afghani,؋,+93,.af,"fa-AF,ps,uz-AF,tk"
4,NA,6,AG,ATG,ANT,125,125,28464,XCD,East Caribbean Dollar,$,+1,.ag,en-AG
5,EU,7,AL,ALB,ALB,238,239879,1025,ALL,Lek,Lek,+355,.al,"sq,el"
6,AS,5,AM,ARM,ARM,52,239880,392,AMD,Armenian Dram,֏,+374,.am,hy
7,AF,9,AO,AGO,ANG,111,239881,805,AOA,Angolan Kwanza,Kz,+244,.ao,pt-AO
8,SA,8,AR,ARG,ARG,54,239882,399,ARS,Argentine Peso,$,+54,.ar,"es-AR,en,it,de,fr,gn"

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

Field	Type	Description	Can be empty?	Example
id	integer	Unique identifier for the place.	No	394
place_english	string	Place name in English.	Yes	New York
place_german	string	Place name in German.	Yes	New York
place_russian	string	Place name in Russian.	Yes	Нью-Йорк
place_korean	string	Place name in Korean.	Yes	뉴욕주
place_portuguese	string	Place name in Portuguese.	Yes	Nova Iorque
place_japanese	string	Place name in Japanese.	Yes	ニューヨーク州
place_persian	string	Place name in Persian.	Yes	ﺎﯾﺎﻠﺗ ﻦﯾﻮﯾﻭﺮﮐ
place_french	string	Place name in French.	Yes	New York
place_chinese	string	Place name in Chinese (Simplified).	Yes	纽约州
place_spanish	string	Place name in Spanish.	Yes	Nueva York
place_czech	string	Place name in Czech.	Yes	New York (stát)
place_italian	string	Place name in Italian.	Yes	New York

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
1,Madrid,Madrid,Мадрид,마드리드 지방,,マドリッド,,Madrid,马德里,Madrid,Madrid,Madrid
2,Vacoas-Phoenix,Vacoas-Phoenix,Vacoas-Phoenix,,,Vacoas-Phoenix,,Vacoas-Phoenix,瓦科阿 - 菲尼克斯,Vacoas-Phoenix,Vacoas-Phoenix,Vacoas-Phoenix
3,New York City,New York City,Нью-Йорк,,,ニューヨーク,,New-York,紐約市,New York,New York,New York
4,Oceania,Ozeanien,Океания,Oceania,Oceania,オセアニア,ﺎﻘﯾﺎﻧﻮﺴﯿﻫ,Océanie,大洋洲,Oceanía,Oceánie,Oceania
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
9,Africa,Afrika,Африка,África,África,アフリカ,ﺎﻓﺮﯿﻗﺍ,Afrique,非洲,África,Afrika,Africa
10,Antarctica,Antarktis,Антарктида,Antártida,Antártida,南極, ﺞﻧﻮﺒﮔﺎﻧ,Antarctique,南极洲,Antártida,Antarktida,Antartide
11,Australia,Australien,Австралия,Austrália,Austrália,オーストラリア,ﺎﺴﺗﺭﺎﻠﯾﺍ,Australie,澳大利亚,Australia,Austrálie,Australia
12,China,China,Китай,China,China,中国,ﭻﯿﻧ,Chine,中国,China,Čína,Cina
13,Japan,Japan,Япония,Japão,Japão,日本,ﮊﺎﭙﻧ,Japon,日本,Japón,Japonsko,Giappone
14,Thailand,Thailand,Тайланд,Tailândia,Tailândia,タイ王国,ﺕﺎﯿﻠﻧﺩ,Thaïlande,泰国,Tailandia,Thajsko,Thailandia

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.

IPGeolocation Databases Portfolio

Overview

Database Archives

Geo DB Relational Files

1. DB Country File

I. Reference to DB Country Database File

II. Example Records

2. DB Places File

I. Reference to DB Place Database File

II. Example Records

API SDKs

Subscribe to Our Newsletter