DB23

IP2Location IP-Country-Region-City-Latitude-Longitude-ISP-Domain-Mobile-UsageType Database

DB23 provides an IP geolocation solution to determine the country, region or state, city, latitude and longitude, Internet Service Provider (ISP) or company name, domain name, mobile country code (MCC), mobile network code (MNC), carrier brand, and usage type of IP address.

Subscription License Type (1 Year)

Available in Site/SaaS Redistribution License only

Request a Quote

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, city, latitude and longitude, Internet Service Provider (ISP) or company name, domain name, mobile country code (MCC), mobile network code (MNC), carrier brand, and usage type.
Current Version	2024-07-15
Update Frequency	Semi-monthly
Database Format	Binary (BIN) ASCII Text File (CSV)
IPv4 Database Size	BIN: 690.54 MB CSV: 2.06 GB (13,444,962 Rows)
IPv6 Database Size	BIN: 823.13 MB CSV: 2.65 GB (15,722,609 Rows)
Total Cities	>110,000 (Coverage Map \| Data Accuracy)

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.
isp	VARCHAR(256)	Internet Service Provider or company's name.
domain	VARCHAR(128)	Internet domain name associated with IP address range.
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.
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

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.

Started Guide

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.

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.

Articles & Tutorials