Find IP Address, Locate IP Address, Lookup IP Address, IP Address to city, Geolocation.

IP geolocation database

IP to Country Database
IP Region Database
IP to City Database
IP-Country-ISP Database

Free tools

Target Country by IP Address
IP Location Lookup
ISO 3166 Country Codes
Flag images of the World

IP geolocation databaseHome
Online OrderPurchase

Target Country by IP Address IP-Country-Region-City Database

Frequently Asked Questions

How often is the IP to City Database updated?
The IP Location database is updated every month. About 1% of the database changes every month.

Are the monthly update a complete set of all entries or only a part of all IP-Addresses ?
The monthly update are a complete set of all entrie.

How do you dispatch the montly updates? By e-mail, regular mail,downloadable?
Download IP Address Database.

Would it be possible to receive the database as a mysql dump file instead of the CSV file?
You can receive the database as a mysql dump file instead of the CSV file.

How much of the IP Address space do you cover?
We cover all of the IPv4 space, including all publically available IP addresses.

How many IP addresses are in your IP-Country-Region-City mapping Database? How many countries are included?
Please see our Technical Details page.

How accurate is your IP Address database?
The database has over 98% of accuracy in country level, 75% in region level and 63% in city level.

What is the database format?
The database format is known as Comma Separated Values (CSV). All fields are separated by a comma and each individual line is a record by itself.

What is the definition of each column in the table?

Field Data Type Field Description
Start IP Number unsigned int First IP in netblock, IP Number
End IP Number unsigned int Last IP in netblock, IP Number
Country Code char(2) ISO 3166 Country Code
Country Name varchar(50) The name of the country
Region vchar(128) Region or state name.
City varchar(255) Name of City

What is the size of the database?
The March 2005 CSV file is 17.35 Megabytes.

How do I convert a IP Address to a IP Number?

IP address (IPV4) is divided into 4 sub-blocks. Each sub-block has a different weight number each powered by 256.
Beginning IP number and Ending IP Number are calcuated as follows:
IP Number = 16777216*w + 65536*x + 256*y + z
where IP Address = w.x.y.z

PHP Function To Convert IP Address to IP Number
function Dot2LongIP ($IPaddr)
if ($IPaddr == "") {
return 0;
} else {
$ips = split ("\.", "$IPaddr");
return ($ips[3] + $ips[2] * 256 + $ips[1] * 65536 + $ips[0]
*16777216); }

ASP Function To Convert IP Address to IP Number
Function Dot2LongIP (ByVal DottedIP)
Dim i, pos
Dim PrevPos, num
If DottedIP = "" Then
Dot2LongIP = 0
For i = 1 To 4
pos = InStr(PrevPos + 1, DottedIP, ".", 1)
If i = 4 Then
pos = Len(DottedIP) + 1
End If
num = Int(Mid(DottedIP, PrevPos + 1, pos - PrevPos - 1))
PrevPos = pos
Dot2LongIP = ((num Mod 256) * (256 ^ (4 - i))) + Dot2LongIP
End If
End Function

How do I use this database?
First, import this database into your MS-SQL, MS-ACCESS, PL/SQL, MySQL database and etc. Then, write a query to get a recordset.

Example of SQL Query

 If you have a question that is not answered here, please e-mail it to

Copyright ©2001-2017 All rights reserved.