IP2Location IP-Country-Region-City-Latitude-Longitude-ZIPCode-TimeZone-ISP-Domain-NetSpeed-AreaCode-Weather-Mobile-Elevation-UsageType Database
DB24 provides an IP geolocation solution to determine the country, region or state, city, latitude and longitude, ZIP/Postal code, time zone, Internet Service Provider (ISP) or company name, domain name, net speed, area code, weather station code, weather station name, mobile country code (MCC), mobile network code (MNC) and carrier brand, elevation, and usage type of IP address.
View Sample Data
The IP address range covered by this demo is limited to a small range in the commercial database.
Download IPv4 / Download IPv6Request Free Sample
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, ZIP/Postal code, time zone, Internet Service Provider (ISP) or company name, domain name, net speed, area code, weather station code, weather station name, mobile country code (MCC), mobile network code (MNC) and carrier brand, elevation, and usage type. |
---|---|
Current Version | 2024-11-01 |
Update Frequency | Semi-monthly |
Database Format |
Binary (BIN)
ASCII Text File (CSV) |
IPv4 Database Size |
BIN:
1.04 GB CSV: 2.75 GB (12,995,284 Rows) |
IPv6 Database Size |
BIN:
1.25 GB CSV: 3.49 GB (15,385,154 Rows) |
Total Cities | >110,000 (Coverage Map | Data Accuracy) |
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. |
zip_code | VARCHAR(30) | ZIP code or Postal code (173 countries supported). |
time_zone | VARCHAR(8) | UTC time zone (with DST supported). |
isp | VARCHAR(256) | Internet Service Provider or company's name. |
domain | VARCHAR(128) | Internet domain name associated with IP address range. |
net_speed | VARCHAR(8) | Internet connection type. DIAL = dial up, DSL = broadband/cable/fiber/mobile, COMP = corporate, T1 = data center/transit, SAT = satellite |
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 calls between cities (224 countries supported). |
weather_station_code | VARCHAR(10) | The special code to identify the nearest weather observation station. |
weather_station_name | VARCHAR(128) | The name of the nearest weather observation station. |
mcc | VARCHAR(256) | Mobile Country Codes (MCC) as defined in ITU E.212 for use in identifying mobile stations in wireless telephone networks, particularly GSM and UMTS networks. |
mnc | VARCHAR(256) | Mobile Network Code (MNC) is used in combination with a Mobile Country Code (MCC) to uniquely identify a mobile phone operator or carrier. |
mobile_brand | VARCHAR(128) | Commercial brand associated with the mobile carrier. You may click mobile carrier coverage to view the coverage report. |
elevation | INT(10) | Average height of city above sea level in meters (m). |
usage_type | VARCHAR(11) | Usage type classification of ISP or company (COM) Commercial (ORG) Organization (GOV) Government (MIL) Military (EDU) University/College/School (LIB) Library (CDN) Content Delivery Network (ISP) Fixed Line ISP (MOB) Mobile ISP (DCH) Data Center/Web Hosting/Transit (SES) Search Engine Spider (RSV) Reserved |
Name | Description |
---|---|
Continent Multilingual | Continent names in multiple languages. |
Country Multilingual | Country names in multiple languages. |
Country Flags | Countries flag icon in multiple sizes. |
World SVG Map | World border shape in SVG format. |
ISO 3166-2 Subdivision Code | ISO 3166-2 codes for the names of countries and their subdivisions. |
Country Information | Additional country information, such as capital, total area and so on. |
Region Multilingual | Region names in multiple languages. |
City Multilingual | City names in multiple languages. |
ZIP Code to Metro | ZIP code information to metro mapping data. |
Weather Station Code | IP2Location Weather Station Code to Yahoo! WOEID, ICAO airport code and IATA code mapping data. |
Olson TimeZone | Olson TimeZone value for cities. |
1. Retrieve
Retrieve the IP address from the networking protocol or server-side variable of web server.
2. Convert
Convert the IP address to an IP number in decimal format to speed up the database query.
3. Pinpoint
Reverse lookup the IP number using geolocation database to pinpoint the exact geographical location.
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.
- How to install and use IP2Trace on Linux for traceroute
- Importing IP2Location data into Oracle Database and querying with PHP (IPv6)
- Integrating IP2Location C Library With Go Programming Language
- How to automate downloading, unzipping & loading of IP2Location DB24 data into Linux MySQL
- Importing IP2Location data into MongoDB and querying with PHP (IPv6)
- Determine Web Visitors Country of Origin in the Drop Down List using PHP and MySQL Database