Database
![]() |
IP-Country-Region-City-Latitude-Longitude-ZIPCode-TimeZone-ISP-Domain-NetSpeed-AreaCode DatabaseIP2Location™ IP-Country-Region-City-Latitude-Longitude-ZIPCode-TimeZone-ISP-Domain-NetSpeed-AreaCode Database [DB16] 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, net speed, 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. |
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, net speed, and area code. |
|---|---|
| Current Version | May 2013 |
| Next Update | June 2013 |
| Database Size | 171.46 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 |
| 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. |
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.





