IPGeolocation Databases Portfolio
Overview
IPGeolocation provides 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
Contains information about reported abuse and malicious activity associated with IP addresses.
- 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 database archives include a comprehensive set of CSV files designed to work together as a relational database. These files are structured to reference one another, enabling powerful data retrieval and geolocation queries.
Additionally, The IP Geolocation Database archive also include 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.
Geo DB Relational Files
The db-country and db-places files are integral components of a relational database system designed to streamline geographic and cultural data management. These files are embedded within the full database to provide efficient access to multilingual and reference data through unique id values.
DB Places holds place names in various languages, allowing seamless multilingual support for geographic locations. The id in this file is referenced by other database files to retrieve place names across different languages while DB Country contains comprehensive country specific information.
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 | 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 | No | 174 |
| country_name_official_place_id | integer | Foreign key linking to | No | 239877 |
| country_capital_place_id | integer | Foreign key linking to | 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 |
Example Records
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 languages such as English, German, Russian, Japanese, 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 |
Example Records
API SDKs
To facilitate the developers, we have added some SDKs for various programming languages. The detailed documentation on how to use these SDKs is available in the respective SDK's documentation page linked below.
Our SDKs are also available on Github. Feel free to help us improve them. Following are the available SDKs:
