DB26

IP2Location IP-Country-Region-City-Latitude-Longitude-ZIPCode-TimeZone-ISP-Domain-NetSpeed-AreaCode-Weather-Mobile-Elevation-UsageType-AddressType-Category-District-ASN Database

DB26 provides an IP geolocation solution to determine the country, region or state, district, 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, usage type, address type, IAB category and ASN of IP address in 3 simple steps. Firstly, retrieve the IP address from the networking protocol or server-side variable of web server. Secondly, translate the IP address to an IP number in decimal format to speed up the database query. Finally, reverse lookup the IP number using geolocation database to pinpoint the exact geolocation information.

request a quote Request a Quote

Available in Site/SaaS Redistribution License only

Free Sample

View Sample Data

The IP address range covered by this demo is limited to a small range in the commercial database.

Download IPv4 / Download IPv6

Request Free Sample

Request free sample database and source codes for PHP, ASP.NET, ASP, C#, VB.NET, Microsoft SQL, and MySQL.

Product Features
Features Translates IP address (IPv4 or IPv6) to country, region or state, district, 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, usage type, address type, IAB category and ASN.
Current Version December 2023
Next Update January 2024
Database Format Binary (BIN)
ASCII Text File (CSV)
IPv4 Database Size BIN: 1.31 GB
CSV: 3.60 GB (13,242,818 Rows)
IPv6 Database Size BIN: 1.51 GB
CSV: 4.29 GB (15,005,029 Rows)
Total Cities >110,000 (See Worldwide Coverage)
Database Fields
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 (172 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
address_type CHAR(1) IP address types as defined in Internet Protocol version 4 (IPv4) and Internet Protocol version 6 (IPv6).
(A) Anycast - One to the closest
(U) Unicast - One to one
(M) Multicast - One to multiple
(B) Broadcast - One to all
category VARCHAR(10) The domain category is based on IAB Tech Lab Content Taxonomy. These categories are comprised of Tier-1 and Tier-2 (if available) level categories widely used in services like advertising, Internet security and filtering appliances.
district VARCHAR(128) District or county name.
asn VARCHAR(10) Autonomous system number (ASN).
as VARCHAR(256) Autonomous system (AS) name.
Free Add-Ons
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.
Started Guide
upload source codes

1. Retrieve

Retrieve the IP address from the networking protocol or server-side variable of web server.

create files

2. Convert

Convert the IP address to an IP number in decimal format to speed up the database query.

submit entry

3. Pinpoint

Reverse lookup the IP number using geolocation database to pinpoint the exact geographical location.

Miscellaneous

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.