1. 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.
IP2Location is also available in binary format which works together with the IP2Location API in several programming languages. [ Back to Top ]
2. What is the definition of each column in the table?
Column
Number |
Column
Descriptions |
1 |
Beginning IP Number
|
2 |
Ending IP Number |
3 |
ISO 3166 Country
Code (2 Characters) |
4 |
Full Country Name |
5 |
Region |
6 |
City |
|
| |
For example:
"IPFROM","IPTO","COUNTRYSHORT","COUNTRYLONG","REGION","CITY","ISP"
"67297904","67297911","US","UNITED
STATES","MASSACHUSETTS","BEDFORD","PROGRESS
SOFTWARE CORP"
"67297912","67297919","US","UNITED
STATES","TEXAS","FLOWER
MOUND","B&TENTERPRISES"
"67297920","67297927","US","UNITED
STATES","TENNESSEE","MEMPHIS","TRI-STATE
BANK OF MEMPHIS" |
|
| |
Column
Number |
Column
Descriptions |
Column
Values |
1 |
Beginning IP Number
|
67297904 |
2 |
Ending IP Number |
67297911 |
3 |
ISO 3166 Country
Code (2 Characters) |
US |
4 |
Full Country Name |
UNITED STATES |
5 |
Region |
MASSACHUSETTS |
6 |
City |
BEDFORD |
|
[ Back to Top ]
3. 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.
IP number is being used in the database because
it is more efficient to search between a range of numbers
in a database.
The Beginning IP number and Ending IP Number are calculated
based on the following formula:
IP Number = 16777216*w
+ 65536*x + 256*y + z
(1)
where
IP Address = w.x.y.z
For example, if the IP address is "202.186.13.4",
then its IP Number will be "3401190660", based on the
formula (1).
IP Address = 202.186.13.4
So, w = 202, x = 186, y = 13 and z = 4
IP Number = 16777216*202 + 65536*186 + 256*13
+ 4
= 3388997632 + 12189696 + 3328 + 4
= 3401190660
To reverse IP number to IP address,
w = int ( IP Number / 16777216 ) % 256
x = int ( IP Number / 65536
) % 256
y = int ( IP Number / 256
) % 256
z = int ( IP Number
) % 256
where %
is the modulus operator and int
returns the integer part of the division.
Example ASP Function To Convert IP Address
to IP Number
Function Dot2LongIP (ByVal DottedIP)
Dim i, pos
Dim PrevPos, num
If DottedIP = "" Then
Dot2LongIP = 0
Else
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
Next
End If
End Function
Example 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] * 256 * 256
+ $ips[0] * 256 * 256 * 256);
}
}
Example ColdFusion Function To Convert IP Address
to IP Number
<cfscript>
function Dot2LongIP(ipAddress)
{
if(arguments.ipAddress EQ "")
{
return 0;
}
else
{
ips = ListToArray( arguments.ipAddress, "." );
return( ( 16777216 * ips[1] ) + ( 65536 * ips[2] ) + ( 256 * ips[3] ) + ips[4] );
}
}
</cfscript>
Example C# Function To Convert IP Address to
IP Number
public double Dot2LongIP(string DottedIP)
{
int i;
string [] arrDec;
double num = 0;
if (DottedIP == "")
{
return 0;
}
else
{
arrDec =
DottedIP.Split('.');
for(i = arrDec.Length
- 1; i >= 0 ; i --)
{
num += ((int.Parse(arrDec[i])%256) * Math.Pow(256
,(3 - i )));
}
return num;
}
}
Example VB.NET Function To Convert IP Address
to IP Number
Public Function Dot2LongIP(ByVal DottedIP As String)
As Double
Dim arrDec() As String
Dim i As Integer
Dim intResult As Long
If DottedIP = "" then
Dot2LongIP
= 0
Else
arrDec =
DottedIP.Split(".")
For i = arrDec.Length
- 1 To 0 Step -1
intResult = intResult + ((Int(arrDec(i)) Mod 256)
* Math.Pow(256, 3 -i))
Next
Dot2LongIP
= intResult
End If
End function
Example MS SQL Function To Convert IP Address to IP Number
Create FUNCTION [dbo].[Dot2LongIP]( @IP VarChar(15) )
RETURNS BigInt
AS
BEGIN
DECLARE @ipA BigInt,
@ipB Int,
@ipC Int,
@ipD Int,
@ipI BigInt
SELECT @ipA = LEFT(@ip, PATINDEX('%.%', @ip) - 1 )
SELECT @ip = RIGHT(@ip, LEN(@ip) - LEN(@ipA) - 1 )
SELECT @ipB = LEFT(@ip, PATINDEX('%.%', @ip) - 1 )
SELECT @ip = RIGHT(@ip, LEN(@ip) - LEN(@ipB) - 1 )
SELECT @ipC = LEFT(@ip, PATINDEX('%.%', @ip) - 1 )
SELECT @ip = RIGHT(@ip, LEN(@ip) - LEN(@ipC) - 1 )
SELECT @ipD = @ip
RETURN ( @ipA * 256*256*256 ) + ( @ipB * 256*256 ) + ( @ipC * 256 ) + @ipD
END
RETURN @ipI
END
[ Back to Top ]
4. How do I retrieve the Country/Region/City name from the IP Number?Firstly, convert the IP address to IP number format (see question 3). Search
the IP-Country-Region-City database using IP number to match a record that has
the IP Number between the Beginning IP Number and the Ending IP Number.
For
example, IP Address "4.2.226.113" is "67297905" in IP Number. It matched the
following record in the database.
"67297904","67297911","US","UNITED
STATES","MASSACHUSETTS","BEDFORD"
Therefore, from the recordset, we know
that the Country Name is "UNITED STATES", Country Code is "US", Region/State is
"MASSACHUSETTS" and City is "BEDFORD". [ Back to Top ]
5. How do I use this database?First, import this database into your MSSQL, MS-ACCESS, PL/SQL, MYSQL or
other RDMS. Use an SQL query to get the matching recordset.
Example of
SQL Query
SELECT [COUNTRY NAME
COLUMN], [REGION NAME COLUMN], [CITY NAME COLUMN] FROM [IP-COUNTRY-REGION-CITY
TABLE] WHERE
[SEARCH IP NO] BETWEEN [IP FROM COLUMN] AND [IP TO
COLUMN] [ Back to Top ]
6. Can I automate the database update download process?Our subscribers can automate the download process using the free command-line script written in Perl which can be downloaded from our Web site. Please visit the following Web page for more information such as command syntax.
http://www.ip2location.com/downloader.aspx
Since the database is being updated every month at the beginning of the month, please download the database only once a month. [ Back to Top ]
7. How do I retrieve visitor's IP address using ASP, ASP.NET, C#, VB.NET, PHP, JSP & ColdFusion?The IP address is available from the web server variable "REMOTE_ADDR".
ASP without Proxy
detection
<%
ipaddress =
Request.ServerVariables("REMOTE_ADDR")
%>
ASP with Proxy
detection
<%
ipaddress =
Request.ServerVariables("HTTP_X_FORWARDED_FOR")
if
ipaddress = "" then
ipaddress =
Request.ServerVariables("REMOTE_ADDR")
end
if
%>
PHP without Proxy
detection
<?
$ipaddress =
getenv(REMOTE_ADDR);
?>
PHP with Proxy
detection
<?
if
(getenv(HTTP_X_FORWARDED_FOR)) {
$ipaddress = getenv(HTTP_X_FORWARDED_FOR);
} else {
$ipaddress =
getenv(REMOTE_ADDR);
}
?>
JSP without Proxy
detection
<%
String ipaddress =
request.getRemoteAddr();
%>
JSP with Proxy
detection
<%
if
(request.getHeader("X_FORWARDED_FOR") == null)
{
String ipaddress =
request.getRemoteAddr();
} else
{
String ipaddress =
request.getHeader("X_FORWARDED_FOR");
}
%>
ColdFusion without Proxy
detection
<CFCOMPONENT>
<CFSET
ipaddress="#CGI.Remote_Addr#">
</CFCOMPONENT>
ColdFusion
with Proxy detection
<CFCOMPONENT>
<CFIF
#CGI.HTTP_X_Forwarded_For# EQ "">
<CFSET
ipaddress="#CGI.Remote_Addr#">
<CFELSE>
<CFSET
ipaddress="#CGI.HTTP_X_Forwarded_For#">
</CFIF>
</CFCOMPONENT>
ASP.NET (C#) without Proxy
detection
public string IpAddress()
{
return
Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
}
ASP.NET (C#)
with Proxy detection
public string
IpAddress()
{
string strIp;
strIp
= Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
if
(strIp == null)
{
strIp = Request.ServerVariables["REMOTE_ADDR"];
}
return strIp;
}
ASP.NET (VB.NET) without Proxy
detection
Public Function IpAddress()
IpAddress
= Request.ServerVariables("HTTP_X_FORWARDED_FOR")
End
Function
ASP.NET (VB.NET) with Proxy detection
Public
Function IpAddress()
Dim strIp As
String
strIp =
Request.ServerVariables("HTTP_X_FORWARDED_FOR")
If strIp =
"" Then
strIp =
Request.ServerVariables("REMOTE_ADDR")
End
If
IpAddress = strIp
End Function
[ Back to Top ]
8. How do I create the SQL table?MSSQL
CREATE DATABASE IP2Location
GO
CREATE TABLE [IP2Location].[dbo].[IPREGIONCITY] (
[ipFROM] [float] NOT NULL
,
[ipTO] [float] NOT NULL ,
[countrySHORT] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
,
[countryLONG] [nvarchar] (64) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[ipREGION] [nvarchar]
(128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ipCITY]
[nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON
[PRIMARY]
GO
CREATE INDEX [ipFROM] ON [IP2Location].[dbo].[IPREGIONCITY]([ipFROM]) ON [PRIMARY]
GO
CREATE INDEX [ipTO] ON [IP2Location].[dbo].[IPREGIONCITY]([ipTO]) ON [PRIMARY]
GO
MYSQL
CREATE DATABASE IP2Location CHARACTER SET LATIN1;
CREATE TABLE IPREGIONCITY
(
ipFROM INT(10) UNSIGNED ZEROFILL NOT NULL
DEFAULT '0000000000',
ipTO INT(10) UNSIGNED ZEROFILL NOT
NULL DEFAULT '0000000000',
countrySHORT CHAR(2) NOT
NULL,
countryLONG VARCHAR(64) NOT
NULL,
ipREGION VARCHAR(128) NOT
NULL,
ipCITY VARCHAR(128) NOT NULL,
PRIMARY KEY(ipFROM, ipTO)
);
POSTGRESQL
CREATE DATABASE IP2Location WITH ENCODING 'LATIN1';
CREATE TABLE IPREGIONCITY
(
ipfrom integer NOT NULL DEFAULT 0,
ipto integer NOT NULL DEFAULT 0,
countryshort character(2) NOT NULL,
countrylong character varying(64) NOT NULL,
ipregion character varying(128) NOT NULL,
ipcity character varying(128) NOT NULL,
CONSTRAINT IPREGIONCITY_pkey PRIMARY KEY (ipfrom,ipto)
);
Please take note that the data
types of the ipFROM and the ipTO columns must be at least 4 bytes to store integer
number range from 0 - 4294967296. [ Back to Top ]
9. How do I import the database into MSSQL or MYSQL database?MSSQL
i. Create Format File
9.0
7
1 SQLCHAR 0 0 "\"" 0 Quote ""
2 SQLCHAR 0 10 "\",\"" 1 ipFROM ""
3 SQLCHAR 0 10 "\",\"" 2 ipTO ""
4 SQLCHAR 0 2 "\",\"" 3 countrySHORT SQL_Latin1_General_CP1_CI_AS
5 SQLCHAR 0 64 "\",\"" 4 countryLONG SQL_Latin1_General_CP1_CI_AS
6 SQLCHAR 0 128 "\",\"" 5 ipREGION SQL_Latin1_General_CP1_CI_AS
7 SQLCHAR 0 128 "\"\r\n" 6 ipCITY SQL_Latin1_General_CP1_CI_AS
ii. Save as DB3.fmt
iii. Open Query Analyzer. Paste the following script.
BULK INSERT IPREGIONCITY
FROM '<path>\IPREGIONCITY.CSV'
WITH
(
FORMATFILE = '<path>\DB3.fmt'
)
GO
Note 1: You may download DB3.fmt here.
Note 2: If you are using MS SQL Server 2000. Please replace 9.0 with 8.0 at the top of DB3.fmt.
MYSQL (PC)
MYSQL> LOAD DATA INFILE
"<path>/IPREGIONCITY.CSV" INTO TABLE IPREGIONCITY FIELDS TERMINATED BY ','
ENCLOSED BY '"' LINES TERMINATED BY '\n';
MYSQL (Linux/Unix)
MYSQL> LOAD DATA INFILE
"<path>/IPREGIONCITY.CSV" INTO TABLE IPREGIONCITY FIELDS TERMINATED BY ','
ENCLOSED BY '"' LINES TERMINATED BY '\r\n';
POSTGRESQL
COPY IPREGIONCITY FROM '<path>/IPREGIONCITY.CSV' WITH CSV QUOTE AS '"'; [ Back to Top ]
10. How many records are available in this demo version?There are only 100 records in the demo version for evaluation purpose. The
full version of the database has more than 3,000,000 records. [ Back to Top ]
11. Will I receive monthly notification when the update is available?Yes, we will deliver the notification via email when the update is available in
the download area. We usually release the update on the first day of the calendar month. [ Back to Top ]
12. Where can I test the demo version for free?You can subscribe to any free 3rd party web-hosting that supports server-side
scripting. One example is Brinkster.com. If you do not want to install this demo,
you can visit our pre-installed demo at http://www.ip2location.com/demo.aspx. [ Back to Top ]
13. Why do we need to update this database periodically?Ownership of IP addresses change hands from time to time. Therefore, a
small percentage of IP address blocks needs to be updated every year. Our database
is updated monthly to make sure it is always accurate. [ Back to Top ]
14. How do I perform monthly database update?You need to download the latest monthly database from our server using the subscription account and password. The database is available in complete format. Therefore, you just need to drop the old database and replace it with the new one. [ Back to Top ]
15. I want to download the full version. What should I do now?a) Fill-up the online purchase form at http://www.ip2location.com/Shoppingcart.aspx?productid=3&quantity=1.
b)
We will generate an unique login/password to allow you to download the database
for one year after we have processed your order. [ Back to Top ]
16. What do I get if I purchase the full version?You will receive your login and password through email immediately after payment is
authorized. You can use your credentials to download the database from our website at
anytime. The database is in a ZIP compressed format to save your bandwidth and
downloading time. [ Back to Top ]
17. How much is the cost of the database license for multiple servers?
| A license is required for every physical
server. Multiple licenses are available in
bulk at a discounted price. |
| |
Number
of License |
Price |
1 |
US$199 |
2 |
US$349 |
5 |
US$699 |
10 |
US$1299 |
| Corporate (20) |
US$1999 |
|
Note: For corporate license purchase, please add "20" units to any subscriptions and the shopping cart will process it as "Corporate License" for online checkout.
[ Back to Top ]
18. Can I resell or reuse the database in my client application?You can resell our databases provided you purchase a separate license for
each client. For example, if you are a developer and purchase a license for your
client, you can make whatever changes you need and deliver it to your client -
provided you transfer the license to your client (as easy as notification
through email). In other words, one copy cannot be sold to multiple parties. You
can resell the database for whatever price you wish. [ Back to Top ]
19. How do I upgrade from other package to IP-COUNTRY-REGION-CITY database?If you are an existing subscriber of an IP2Location database, you can upgrade to a higher package to download this database. You just need to pay for the difference in price instead of the full amount again. The subscription period will remain unchanged based on the old subscription package. Please login and click on the upgrade button inside the customer account area. [ Back to Top ]
20. How many countries are included in the database? What is the accuracy?
| The
IP-Country database has over 99% accuracy,
which is higher than any of our competitors. The small number of
inaccuracy is due to the dynamic IP address allocation
by large ISPs such as AOL and MSN TV. Due to the fact that
AOL uses a network that routes all of the company's
Internet traffic through Reston, Virginia, all
IP-based geo-location services, including IP2Location,
are unable to determine the state and city for
people who dial into the AOL network.
|
| |
Country Code |
Country Name |
Number of IP Address |
| AD |
ANDORRA |
26435 |
| AE |
UNITED ARAB EMIRATES |
2310569 |
| AF |
AFGHANISTAN |
58588 |
| AG |
ANTIGUA AND BARBUDA |
34912 |
| AI |
ANGUILLA |
10080 |
| AL |
ALBANIA |
153529 |
| AM |
ARMENIA |
155048 |
| AN |
NETHERLANDS ANTILLES |
232551 |
| AO |
ANGOLA |
61130 |
| AQ |
ANTARCTICA |
13279 |
| AR |
ARGENTINA |
7256468 |
| AS |
AMERICAN SAMOA |
10329 |
| AT |
AUSTRIA |
10066634 |
| AU |
AUSTRALIA |
37282264 |
| AW |
ARUBA |
36616 |
| AX |
ALAND ISLANDS |
21541 |
| AZ |
AZERBAIJAN |
246580 |
| BA |
BOSNIA AND HERZEGOVINA |
406658 |
| BB |
BARBADOS |
101780 |
| BD |
BANGLADESH |
642332 |
| BE |
BELGIUM |
9054245 |
| BF |
BURKINA FASO |
22912 |
| BG |
BULGARIA |
3482720 |
| BH |
BAHRAIN |
239038 |
| BI |
BURUNDI |
2897 |
| BJ |
BENIN |
18260 |
| BM |
BERMUDA |
107581 |
| BN |
BRUNEI DARUSSALAM |
191313 |
| BO |
BOLIVIA |
439527 |
| BR |
BRAZIL |
29783590 |
| BS |
BAHAMAS |
84739 |
| BT |
BHUTAN |
22656 |
| BV |
BOUVET ISLAND |
192 |
| BW |
BOTSWANA |
76728 |
| BY |
BELARUS |
345425 |
| BZ |
BELIZE |
127059 |
| CA |
CANADA |
76416420 |
| CD |
CONGO, THE DEMOCRATIC REPUBLIC OF THE |
13682 |
| CF |
CENTRAL AFRICAN REPUBLIC |
6204 |
| CG |
CONGO |
5110 |
| CH |
SWITZERLAND |
20094158 |
| CI |
COTE D'IVOIRE |
131822 |
| CK |
COOK ISLANDS |
8224 |
| CL |
CHILE |
4874533 |
| CM |
CAMEROON |
72788 |
| CN |
CHINA |
191185969 |
| CO |
COLOMBIA |
4593483 |
| CR |
COSTA RICA |
1535103 |
| CS |
SERBIA AND MONTENEGRO |
691596 |
| CU |
CUBA |
113653 |
| CV |
CAPE VERDE |
11528 |
| CY |
CYPRUS |
443853 |
| CZ |
CZECH REPUBLIC |
6709604 |
| DE |
GERMANY |
107200741 |
| DJ |
DJIBOUTI |
4688 |
| DK |
DENMARK |
10446314 |
| DM |
DOMINICA |
4131 |
| DO |
DOMINICAN REPUBLIC |
415741 |
| DZ |
ALGERIA |
277679 |
| EC |
ECUADOR |
906120 |
| EE |
ESTONIA |
1060391 |
| EG |
EGYPT |
2864461 |
| ER |
ERITREA |
4464 |
| ES |
SPAIN |
23974320 |
| ET |
ETHIOPIA |
16856 |
| FI |
FINLAND |
12775472 |
| FJ |
FIJI |
124945 |
| FK |
FALKLAND ISLANDS (MALVINAS) |
1664 |
| FM |
MICRONESIA, FEDERATED STATES OF |
3072 |
| FO |
FAROE ISLANDS |
34040 |
| FR |
FRANCE |
82593544 |
| GA |
GABON |
160402 |
| GD |
GRENADA |
13208 |
| GE |
GEORGIA |
565990 |
| GF |
FRENCH GUIANA |
2304 |
| GG |
GUERNSEY |
264 |
| GH |
GHANA |
172854 |
| GI |
GIBRALTAR |
59560 |
| GL |
GREENLAND |
16400 |
| GM |
GAMBIA |
11431 |
| GN |
GUINEA |
69892 |
| GP |
GUADELOUPE |
9524 |
| GQ |
EQUATORIAL GUINEA |
3576 |
| GR |
GREECE |
4639231 |
| GS |
SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS |
8 |
| GT |
GUATEMALA |
532560 |
| GU |
GUAM |
110865 |
| GW |
GUINEA-BISSAU |
3336 |
| GY |
GUYANA |
18088 |
| HK |
HONG KONG |
8228643 |
| HM |
HEARD ISLAND AND MCDONALD ISLANDS |
20 |
| HN |
HONDURAS |
220128 |
| HR |
CROATIA |
1640998 |
| HT |
HAITI |
78449 |
| HU |
HUNGARY |
4395408 |
| ID |
INDONESIA |
8522218 |
| IE |
IRELAND |
5350819 |
| IL |
ISRAEL |
6146868 |
| IM |
ISLE OF MAN |
5640 |
| IN |
INDIA |
18355996 |
| IO |
BRITISH INDIAN OCEAN TERRITORY |
3072 |
| IQ |
IRAQ |
72893 |
| IR |
IRAN, ISLAMIC REPUBLIC OF |
1938684 |
| IS |
ICELAND |
743201 |
| IT |
ITALY |
42541683 |
| JE |
JERSEY |
4080 |
| JM |
JAMAICA |
184565 |
| JO |
JORDAN |
295158 |
| JP |
JAPAN |
169340040 |
| KE |
KENYA |
337434 |
| KG |
KYRGYZSTAN |
134455 |
| KH |
CAMBODIA |
129344 |
| KI |
KIRIBATI |
3072 |
| KM |
COMOROS |
584 |
| KN |
SAINT KITTS AND NEVIS |
15804 |
| KP |
KOREA, DEMOCRATIC PEOPLE'S REPUBLIC OF |
40 |
| KR |
KOREA, REPUBLIC OF |
72195958 |
| KW |
KUWAIT |
1019135 |
| KY |
CAYMAN ISLANDS |
40299 |
| KZ |
KAZAKHSTAN |
892492 |
| LA |
LAO PEOPLE'S DEMOCRATIC REPUBLIC |
42280 |
| LB |
LEBANON |
320321 |
| LC |
SAINT LUCIA |
7240 |
| LI |
LIECHTENSTEIN |
70373 |
| LK |
SRI LANKA |
450470 |
| LR |
LIBERIA |
4904 |
| LS |
LESOTHO |
14984 |
| LT |
LITHUANIA |
2038550 |
| LU |
LUXEMBOURG |
1189618 |
| LV |
LATVIA |
1462329 |
| LY |
LIBYAN ARAB JAMAHIRIYA |
299628 |
| MA |
MOROCCO |
896979 |
| MC |
MONACO |
57061 |
| MD |
MOLDOVA, REPUBLIC OF |
610354 |
| ME |
MONTENEGRO |
88268 |
| MG |
MADAGASCAR |
48554 |
| MH |
MARSHALL ISLANDS |
2840 |
| MK |
MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF |
530690 |
| ML |
MALI |
24904 |
| MM |
MYANMAR |
12544 |
| MN |
MONGOLIA |
112008 |
| MO |
MACAO |
195822 |
| MP |
NORTHERN MARIANA ISLANDS |
14344 |
| MQ |
MARTINIQUE |
10778 |
| MR |
MAURITANIA |
27489 |
| MS |
MONTSERRAT |
2176 |
| MT |
MALTA |
418160 |
| MU |
MAURITIUS |
448556 |
| MV |
MALDIVES |
41592 |
| MW |
MALAWI |
26560 |
| MX |
MEXICO |
21564850 |
| MY |
MALAYSIA |
4163124 |
| MZ |
MOZAMBIQUE |
65911 |
| NA |
NAMIBIA |
143410 |
| NC |
NEW CALEDONIA |
84016 |
| NE |
NIGER |
13087 |
| NF |
NORFOLK ISLAND |
1536 |
| NG |
NIGERIA |
548856 |
| NI |
NICARAGUA |
192832 |
| NL |
NETHERLANDS |
41829014 |
| NO |
NORWAY |
13845477 |
| NP |
NEPAL |
155064 |
| NR |
NAURU |
8248 |
| NU |
NIUE |
3072 |
| NZ |
NEW ZEALAND |
6303521 |
| OM |
OMAN |
233800 |
| PA |
PANAMA |
1138393 |
| PE |
PERU |
1791471 |
| PF |
FRENCH POLYNESIA |
40704 |
| PG |
PAPUA NEW GUINEA |
51180 |
| PH |
PHILIPPINES |
4150035 |
| PK |
PAKISTAN |
1686363 |
| PL |
POLAND |
14482094 |
| PM |
SAINT PIERRE AND MIQUELON |
8192 |
| PN |
PITCAIRN |
8 |
| PR |
PUERTO RICO |
821645 |
| PT |
PORTUGAL |
4874353 |
| PW |
PALAU |
5160 |
| PY |
PARAGUAY |
189328 |
| QA |
QATAR |
386225 |
| RE |
REUNION |
34192 |
| RO |
ROMANIA |
8372088 |
| RS |
SERBIA |
576724 |
| RU |
RUSSIAN FEDERATION |
25504914 |
| RW |
RWANDA |
155072 |
| SA |
SAUDI ARABIA |
2855785 |
| SB |
SOLOMON ISLANDS |
8704 |
| SC |
SEYCHELLES |
29864 |
| SD |
SUDAN |
77000 |
| SE |
SWEDEN |
24032742 |
| SG |
SINGAPORE |
4385842 |
| SI |
SLOVENIA |
1524786 |
| SK |
SLOVAKIA |
2056456 |
| SL |
SIERRA LEONE |
19361 |
| SM |
SAN MARINO |
21493 |
| SN |
SENEGAL |
93731 |
| SO |
SOMALIA |
4412 |
| SR |
SURINAME |
49197 |
| ST |
SAO TOME AND PRINCIPE |
920 |
| SV |
EL SALVADOR |
407876 |
| SY |
SYRIAN ARAB REPUBLIC |
202942 |
| SZ |
SWAZILAND |
28986 |
| TC |
TURKS AND CAICOS ISLANDS |
8044 |
| TD |
CHAD |
1064 |
| TF |
FRENCH SOUTHERN TERRITORIES |
16 |
| TG |
TOGO |
13976 |
| TH |
THAILAND |
4823122 |
| TJ |
TAJIKISTAN |
40416 |
| TK |
TOKELAU |
112 |
| TL |
TIMOR-LESTE |
1032 |
| TM |
TURKMENISTAN |
9108 |
| TN |
TUNISIA |
632292 |
| TO |
TONGA |
4352 |
| TR |
TURKEY |
10821985 |
| TT |
TRINIDAD AND TOBAGO |
333807 |
| TV |
TUVALU |
8192 |
| TW |
TAIWAN |
24720930 |
| TZ |
TANZANIA, UNITED REPUBLIC OF |
132416 |
| UA |
UKRAINE |
5375207 |
| UG |
UGANDA |
153936 |
| UK |
UNITED KINGDOM |
242195366 |
| UM |
UNITED STATES MINOR OUTLYING ISLANDS |
666 |
| US |
UNITED STATES |
1471982863 |
| UY |
URUGUAY |
697488 |
| UZ |
UZBEKISTAN |
196416 |
| VA |
HOLY SEE (VATICAN CITY STATE) |
10504 |
| VC |
SAINT VINCENT AND THE GRENADINES |
15896 |
| VE |
VENEZUELA |
3770298 |
| VG |
VIRGIN ISLANDS, BRITISH |
19708 |
| VI |
VIRGIN ISLANDS, U.S. |
104346 |
| VN |
VIET NAM |
6712451 |
| VU |
VANUATU |
8464 |
| WF |
WALLIS AND FUTUNA |
2048 |
| WS |
SAMOA |
14394 |
| YE |
YEMEN |
29056 |
| YT |
MAYOTTE |
278 |
| ZA |
SOUTH AFRICA |
13973821 |
| ZM |
ZAMBIA |
45640 |
| ZW |
ZIMBABWE |
45439 |
|
Data Source: IP2Location™ IP-COUNTRY [DB1] May 2009 Edition Database
[ Back to Top ]
21. What is the subscription rate for renewal orders?All IP2Location database subscribers are entitled to a 10% discount for renewal orders that are received with payment on or before actual expiration date.
For example, the subscription rate for IP2Location IP-COUNTRY (DB1) is US$49.00 for first year. So the renewal rate for this account is US$44.10 (US$49.00 - 10%) if payment is received before the download account expires. We will send out reminder emails 30-day and 14-day before account expiration. Customers can renew expired subscription at standard pricing. [ Back to Top ]
22. What is the IP2Location updates schedule for year 2009-2012?The IP2Location database will be released on the 1st day of the calendar month and uploaded to the customer download area for immediate download.
| 2009 |
2010 |
2011 |
2012 |
| 1st January 2009 |
1st January 2010 |
1st January 2011 |
1st January 2012 |
| 1st February 2009 |
1st February 2010 |
1st February 2011 |
1st February 2012 |
| 1st March 2009 |
1st March 2010 |
1st March 2011 |
1st March 2012 |
| 1st April 2009 |
1st April 2010 |
1st April 2011 |
1st April 2012 |
| 1st May 2009 |
1st May 2010 |
1st May 2011 |
1st May 2012 |
| 1st June 2009 |
1st June 2010 |
1st June 2011 |
1st June 2012 |
| 1st July 2009 |
1st July 2010 |
1st July 2011 |
1st July 2012 |
| 1st August 2009 |
1st August 2010 |
1st August 2011 |
1st August 2012 |
| 1st September 2009 |
1st September 2010 |
1st September 2011 |
1st September 2012 |
| 1st October 2009 |
1st October 2010 |
1st October 2011 |
1st October 2012 |
| 1st November 2009 |
1st November 2010 |
1st November 2011 |
1st November 2012 |
| 1st December 2009 |
1st December 2010 |
1st December 2011 |
1st December 2012 |
[ Back to Top ]
23. How many unique cities/points are there in the IP2Location database?IP2Location supports >20,000 cities from 220+ countries. The distribution of unique points by country is as follows:
 [ Back to Top ]
24. How can I get world cities or postal code database?If you are looking for world cities database or postal code database without IP geolocation technology, you can get it from the following Web site. GeoDataSource.com - World Cities Database
ZIPCodeWorld.com - United States, Canada and Mexico Postal Code Database
[ Back to Top ]
25. How can I get real-time Web browser detection?You can get real-time Web browser detection using BrowserObject™ component at http://www.browserobject.com. It is a server component that detects browser types and many other parameters. Free and Trial Edition is available online. [ Back to Top ]
26. Who is using IP2Location products?IP2Location is a trusted brand in the field of Internet geolocation. It has been used by many different organizations such as large corporations, small and medium businesses as well as not-for-profit organizations in a wide range of purposes. You can view the list of customers here. Meanwhile, you can also find IP2Location in many academic researches which you can view here. [ Back to Top ]
|