Database
![]() |
IP-Country-Region-City-Latitude-Longitude-ZIPCode-TimeZone DatabaseIP2Location™ IP-Country-Region-City-Latitude-Longitude-ZIPCode-TimeZone Database [DB11] provides a solution to determine the country, region or state, city, latitude and longitude, US ZIP code, and time zone 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. |
SAMPLE REQUEST
Request free sample database and source codes for PHP, ASP.NET, ASP, C#, VB.NET, MSSQL, and MySQL.
PRODUCT FEATURES| Features | Translates IP address to country, region or state, city, latitude and longitude, US ZIP code, and time zone. |
|---|---|
| Current Version | May 2013 |
| Next Update | June 2013 |
| Database Size | 71.55 MB (5,150,333 Rows) |
| Database Format | ASCII Text File (Comma Delimited) and BIN (API) |
| Total Cities | >50,000 (See Worldwide Coverage) |
DATABASE FIELDS| Name | Type | Description |
|---|---|---|
| ip_from | INT(10) | First IP address in netblock. |
| ip_to | INT(10) | 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 | Latitude of city. |
| longitude | DOUBLE | Longitude of city. |
| zip_code | VARCHAR(10) | ZIP code of United States city. |
| time_zone | VARCHAR(8) | UTC time zone. |
MISCELLANEOUSLicense 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.





