DB21

IP2Location IP-Country-Region-City-Latitude-Longitude-ZIPCode-TimeZone-AreaCode-Elevation Database

DB21 provides an IP geolocation solution to determine the country, region or state, city, latitude and longitude, ZIP/Postal code, time zone, area code, and elevation 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, ZIP/Postal code, time zone, area code, and elevation.
Current Version	2024-07-15
Update Frequency	Semi-monthly
Database Format	Binary (BIN) ASCII Text File (CSV)
IPv4 Database Size	BIN: 448.76 MB CSV: 1.34 GB (10,638,527 Rows)
IPv6 Database Size	BIN: 558.79 MB CSV: 1.81 GB (12,688,401 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.
zip_code	VARCHAR(30)	ZIP code or Postal code (173 countries supported).
time_zone	VARCHAR(8)	UTC time zone (with DST supported).
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).
elevation	INT(10)	Average height of city above sea level in meters (m).

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.
Olson TimeZone	Olson TimeZone value for cities.

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