IP2Location™ IP-Country-Region-City-Latitude-Longitude-TimeZone-NetSpeed Database
IP2Location™ IP-Country-Region-City-Latitude-Longitude-TimeZone-NetSpeed Database [DB13] provides a solution to determine the country, region or state, city, latitude and longitude, time zone, 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 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 - IPv4 / IPv6
- Specifications
- Download
- Comparison
Request free sample database and source codes for PHP, ASP.NET, ASP, C#, VB.NET, Microsoft SQL, and MySQL.
| Features | Translates IP address (IPv4 or IPv6) to country, region or state, city, latitude and longitude, time zone, and net speed. |
|---|---|
| Current Version | December 2020 |
| Next Update | January 2021 |
| IPv4 Database Size |
BIN: 339.28 MB CSV: 1.19 GB (11,070,591 Rows) |
| IPv6 Database Size |
BIN: 373.04 MB CSV: 1.42 GB (11,863,138 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. Defaults to capital city latitude if city is unknown. |
| longitude | DOUBLE | City longitude. Defaults to capital city longitude if city is unknown. |
| time_zone | VARCHAR(8) | UTC time zone (with DST supported). |
| net_speed | VARCHAR(8) | Internet connection type. DIAL = dial up, DSL = broadband/cable/fiber/mobile, COMP = company/T1 |
† IPv4
†† IPv6
| Name | Description | |
|---|---|---|
| Continent Multilingual | Continent names in multiple languages. | More Info » |
| Country Multilingual | Country names in multiple languages. | 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 » |
| Country Information | Additional country information, such as capital, total area and so on. | More Info » |
| Region Multilingual | Region names in multiple languages. | More Info » |
| City Multilingual | City names in multiple languages. | More Info » |
| Olson TimeZone | Olson TimeZone value for cities. | More Info » |
License Agreement: General Terms and Conditions for the database licensing.
Server License: Comparison of Standard License, Site License and Redistribution License.
IP2Location™ and IP2Proxy™ are registered trademarks of HEXASOFT. All other trademarks are the properties of their respective owners.
Worldwide Coverage Map
