Database
![]() |
IP-Country-Region-City-Latitude-Longitude-ZIPCode-TimeZone-AreaCode DatabaseIP2Location™ IP-Country-Region-City-Latitude-Longitude-ZIPCode-TimeZone-AreaCode Database [DB15] provides a solution to determine the country, region or state, city, latitude and longitude, ZIP/Postal code (159 countries supported), time zone, and area code of origin for any IP address in a few simple steps. First, retrieve the IP address from the networking protocol or server-side variable of the Web server. Next, translate the IP address to an IP number in decimal format to speed up the database query. Lastly, reverse lookup the IP number from the IP2Location™ database to pinpoint the exact geographical location. This is a database subscription service. You can download all monthly updates for free if subscription is active. IPv4 and IPv6 supported.
|

Request free sample database and source codes for PHP, ASP.NET, ASP, C#, VB.NET, MSSQL, and MySQL.

Features | Translates IP address (IPv4 or IPv6) to country, region or state, city, latitude and longitude, ZIP/Postal code (159 countries supported), time zone, and area code. |
---|---|
Current Version | April 2018 |
Next Update | May 2018 |
IPv4 Database Size |
BIN: 352.08 MB CSV: 1.04 GB (9,163,600 Rows) |
IPv6 Database Size |
BIN: 370.62 MB CSV: 1.19 GB (9,526,985 Rows) |
Database Format | ASCII Text File (Comma Delimited) and BIN (API) |
Total Cities | >110,000 (See Worldwide Coverage) |

Name | Type | Description |
---|---|---|
ip_from | INT(10)† / Decimal(39,0)†† | First IP address in netblock. |
ip_to | INT(10)† / Decimal(39,0)†† | Last IP address in netblock. |
country_code | CHAR(2) | Two-character country code based on ISO 3166. |
country_name | VARCHAR(64) | Country name based on ISO 3166. |
region_name | VARCHAR(128) | Region or state name. |
city_name | VARCHAR(128) | City name. |
latitude | DOUBLE | City latitude. Default to capital city latitude if city is unknown. |
longitude | DOUBLE | City longitude. Default to capital city longitude if city is unknown. |
zip_code | VARCHAR(30) | ZIP/Postal code (159 countries supported). |
time_zone | VARCHAR(8) | UTC time zone (with DST supported). |
idd_code | VARCHAR(5) | The IDD prefix to call the city from another country. |
area_code | VARCHAR(30) | A varying length number assigned to geographic areas for call between cities (186 countries supported). |
† IPv4
†† IPv6
†† IPv6

Name | Description | |
---|---|---|
Continent Multilingual | Continent name in multiple languages. | More Info |
Country Multilingual | Country name in multiple languages. | More Info |
City Multilingual | City name in multiple languages. | More Info |
ZIP Code to Metro | ZIP code information to metro mapping data. | More Info |
Country Flags | Countries flag icon in multiple sizes. | More Info |
World SVG Map | World border shape in SVG format. | More Info |
ISO 3166-2 Subdivision Code | ISO 3166-2 codes for the names of countries and their subdivisions. | More Info |
Olson TimeZone | Olson TimeZone value for cities. | More Info |

License Agreement: General Terms and Conditions for the database licensing.
Server License: The number of license required for server installation.
IP2Location™ is a registered trademark of HEXASOFT. All other trademarks are the property of their respective owners.

Sample Request
Please send me free sample database, binary and source codes of IP2Location products.