Database
![]() |
IP-Country-Region-City-Latitude-Longitude-ZIPCode-TimeZone-ISP-Domain-NetSpeed DatabaseIP2Location™ IP-Country-Region-City-Latitude-Longitude-ZIPCode-TimeZone-ISP-Domain-NetSpeed Database [DB14] provides a solution to determine the country, region or state, city, latitude and longitude, US ZIP code, time zone, Internet Service Provider (ISP) or company name, domain name, and net speed 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, time zone, Internet Service Provider (ISP) or company name, domain name, and net speed. |
|---|---|
| Current Version | May 2013 |
| Next Update | June 2013 |
| Database Size | 166.67 MB (8,787,476 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. |
| isp | VARCHAR(255) | Internet Service Provider or company's name. |
| domain | VARCHAR(128) | Internet domain name associated to IP address range. |
| net_speed | VARCHAR(8) | Internet connection type. DIAL = dial up, DSL = broadband/cable, COMP = company/T1 |
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.





