--- title: "IPGeolocation Databases Portfolio | Comprehensive Geolocation Data" slug: "/documentation/databases.html" description: "Explore IPGeolocation databases with detailed country, city, ISP, and proxy data. Includes database API system reader and relational geographic files." --- # IPGeolocation Databases Portfolio * * * ## Overview IPGeolocation provides following databases: * [IP Geolocation Database](https://ipgeolocation.io/ip-geolocation-database.html) Provides detailed geolocation data for IP addresses, including country, region, city, and more. * [IP Security Database](https://ipgeolocation.io/ip-security-database.html) Offers security-related information for IP addresses, such as threat intelligence and risk scores. * [IP to ASN Database](https://ipgeolocation.io/ip-asn-database.html) Identifies the Autonomous System Number (ASN) associated with an IP address, useful for network analysis. * [IP to Company Database](https://ipgeolocation.io/ip-company-database.html) Provides company information associated with IP addresses, including organization names and domains. * [IP Abuse Contact Database](https://ipgeolocation.io/ip-abuse-contact-database.html) Contains information about reported abuse and malicious activity associated with IP addresses. * [IP Whois Database](https://ipgeolocation.io/ip-whois-database.html) Provides WHOIS information for IP addresses, including registrant details and registration dates. * [ASN Whois Database](https://ipgeolocation.io/asn-whois-database.html) Offers WHOIS information for Autonomous System Numbers (ASNs), including organization details and registration data. * [IP to Hosting Database](https://ipgeolocation.io/ip-hosting-database.html) Provides hosting provider information associated with IP addresses, including organization names and domains. * [Residential Proxy Database](https://ipgeolocation.io/residential-proxy-database.html) Identifies residential proxy IP addresses, helping to distinguish between residential and non-residential traffic. > [!NOTE] > This documentation provides complete details of features and available options in the above DB Plans. For information related to our IP Geolocation APIs, please goto [APIs Documentation](https://ipgeolocation.io/documentation.html). * * * ## 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](https://ipgeolocation.io/contact.html) 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](https://app.ipgeolocation.io/signup) 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** ```json 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 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](https://ipgeolocation.io/contact.html) 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** ```json 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 ``` > [!IMPORTANT] > Utilize the power of our IP to location database to enhance your marketing strategies, improve location-based services, and gain deeper insights into your audience. Whether you're conducting demographic assessments or implementing city-level targeting for advertising, our database offers the accurate and detailed data you need to succeed. * * * ## 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: * [IP Geolocation API Java SDK](https://ipgeolocation.io/documentation/ip-geolocation-api-java-sdk.html) * [IP Geolocation API Python SDK](https://ipgeolocation.io/documentation/ip-geolocation-api-python-sdk.html) * [IP Geolocation API Go SDK](https://ipgeolocation.io/documentation/ip-geolocation-api-go-sdk.html) * [IP Geolocation API Ruby SDK](https://ipgeolocation.io/documentation/ip-geolocation-api-ruby-sdk.html) * [IP Geolocation API C-Sharp dotNet SDK](https://ipgeolocation.io/documentation/ip-geolocation-api-c-sharp-dotnet-sdk.html) * [IP Geolocation API Rust SDK](https://ipgeolocation.io/documentation/ip-geolocation-api-rust-sdk.html) * [IP Geolocation API Kotlin SDK](https://ipgeolocation.io/documentation/ip-geolocation-api-kotlin-sdk.html) * [IP Geolocation API Swift SDK](https://ipgeolocation.io/documentation/ip-geolocation-api-swift-sdk.html) * [IP Geolocation API C++ SDK](https://ipgeolocation.io/documentation/ip-geolocation-api-cpp-sdk.html) * [IP Geolocation API PHP SDK](https://ipgeolocation.io/documentation/ip-geolocation-api-php-sdk.html) * [IP Geolocation API Typescript SDK](https://ipgeolocation.io/documentation/ip-geolocation-api-typescript-sdk.html) * [IP Geolocation API Javascript SDK](https://ipgeolocation.io/documentation/ip-geolocation-api-javascript-sdk.html) * [IP Geolocation API JQuery SDK](https://ipgeolocation.io/documentation/ip-geolocation-api-jquery-sdk.html) * [Astronomy API Javascript SDK](https://ipgeolocation.io/documentation/astronomy-api-sdk.html)