IP2Proxy™ LITE IP-PROXYTYPE-COUNTRY-REGION-CITY-ISP Database

介紹 特徵 數據庫字段 代理類型 數據庫設置 示例數據庫 AMI和圖像 SDK和庫

介紹

IP2Proxy Database

此資料庫包含用作開放代理程式 (PUB) 的 IP 位址。 該數據庫包含所有公共IPv4和IPv6地址的代理類型，國家，地區，城市和ISP的記錄。 

匿名代理服務器是用於隱藏請求者的真實身份或IP地址的中間服務器。研究發現，大量匿名代理用戶通常負責在線信用卡欺詐，論壇和博客垃圾郵件。

它是免費的，但需註明出處並註明出處，如下所述，

如果您希望獲得更高的數據準確性，更多記錄和客戶支持，請獲取商業版。請訪問產品比較頁面以獲取更多信息。

讓我們現在來探索這個免費提供有價值的地理定位數據的數據庫吧！

免費註冊

特徵

當前版本 04 December 2025
下次更新 January 2026
IPv4 Database Size CSV: 128.52 MB (1,312,371 Rows)
CIDR: 127.4 MB (1,410,641 Rows)
IPv6 Database Size CSV: 142.52 MB (1,316,502 Rows)
CIDR: 138.59 MB (1,414,772 Rows)
IPv4 + IPv6 Binary Size BIN: 399.72 MB
大批 二進制 （BIN）
ASCII文本文件 （CSV）
CIDR

數據庫字段

名稱 類型 描述
ip_from INT (10)† / DECIMAL (39,0)†† 第一個IP地址顯示netblock。
ip_to INT (10)† / DECIMAL (39,0)†† 上一個IP地址顯示netblock。
proxy_type VARCHAR(3) 代理類型
country_code CHAR(2) 基於ISO 3166的兩個字符的國家/地區代碼。
country_name VARCHAR(64) 基於ISO 3166的國家/地區名稱。
region_name VARCHAR(128) 地區或州名稱。
city_name VARCHAR(128) 城市名。
isp VARCHAR(256) 互聯網服務提供商或公司名稱。

† IPv4
†† IPv6

代理類型

代理類型 描述 匿名
VPN 匿名VPN服務。這些服務為用戶提供了可公開訪問的VPN，目的是隱藏其IP地址。 高
TOR Tor出口節點。 Tor項目是一個開放網絡，供那些希望保持匿名的人使用。 高
DCH 託管提供商，數據中心或內容交付網絡。由於託管提供商和數據中心可以提供匿名服務，因此匿名IP數據庫會標記與之關聯的IP地址。 低
PUB* 高
WEB 高
SES 搜索引擎機器人。這些是執行對網站進行爬網或抓取的服務，例如搜索引擎蜘蛛或機器人引擎。 低
RES 住宅代理。這些服務為用戶提供了通過住宅ISP的代理連接，無論是否經過對等方的同意都可以共享其空閒資源。 高
CPN 消費者隱私網路。 這些服務透過中繼路由網際網路請求、隱藏 IP 位址、位置和瀏覽活動，確保來自使用者瀏覽器的加密流量。 低
EPN 企業專用網路。 SASE 或 SD-WAN 等服務將網路安全功能與廣域網路 (WAN) 功能結合，以滿足組織的安全遠端存取需求。 低

數據庫設置

以下是為IPv4和IPv6數據設置數據庫的步驟。

建立資料庫
CREATE DATABASE ip2location;
USE ip2location;
CREATE TABLE `ip2location_px4`(
	`ip_from` INT(10) UNSIGNED,
	`ip_to` INT(10) UNSIGNED,
	`proxy_type` VARCHAR(3),
	`country_code` CHAR(2),
	`country_name` VARCHAR(64),
	`region_name` VARCHAR(128),
	`city_name` VARCHAR(128),
	`isp` VARCHAR(256),
	PRIMARY KEY (`ip_to`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
導入數據庫
LOAD DATA LOCAL
	INFILE 'IP2PROXY-LITE-PX4.CSV'
INTO TABLE
	`ip2location_px4`
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
IGNORE 0 LINES;
建立資料庫
CREATE DATABASE ip2location
GO

USE ip2location
GO

CREATE TABLE [ip2location].[dbo].[ip2location_px4](
	[ip_from] bigint NOT NULL,
	[ip_to] bigint NOT NULL,
	[proxy_type] nvarchar(3) NOT NULL,
	[country_code] nvarchar(2) NOT NULL,
	[country_name] nvarchar(64) NOT NULL,
	[region_name] nvarchar(128) NOT NULL,
	[city_name] nvarchar(128) NOT NULL,
	[isp] nvarchar(256) NOT NULL
) ON [PRIMARY]
GO

CREATE CLUSTERED INDEX [ip_to] ON [ip2location].[dbo].[ip2location_px4]([ip_to]) ON [PRIMARY]
GO
導入數據庫
BULK INSERT [ip2location].[dbo].[ip2location_px4]
FROM '{PATH TO IP2PROXY-LITE-PX4.CSV}'
WITH
(
	FORMATFILE = '{PATH TO PX4.FMT}'
)
GO

注意：您將需要復制以下FMT代碼並將其保存為計算機上名為PX4.FMT的文件。 

12.0
9
1 SQLCHAR 0 1 "\"" 0 first_double_quote  Latin1_General_CI_AI
2 SQLCHAR 0 20 "\",\"" 1 ip_from "",
3 SQLCHAR 0 20 "\",\"" 2 ip_to "",
4 SQLCHAR 0 3 "\",\"" 3 proxy_type Latin1_General_CI_AI,
5 SQLCHAR 0 2 "\",\"" 4 country_code Latin1_General_CI_AI,
6 SQLCHAR 0 64 "\",\"" 5 country_name Latin1_General_CI_AI,
7 SQLCHAR 0 128 "\",\"" 6 region_name Latin1_General_CI_AI,
8 SQLCHAR 0 128 "\",\"" 7 city_name Latin1_General_CI_AI,
9 SQLCHAR 0 256 "\",\"" 8 isp Latin1_General_CI_AI

建立資料庫
CREATE DATABASE ip2location WITH ENCODING 'UTF8';
\c ip2location
CREATE TABLE ip2location_px4(
	ip_from bigint NOT NULL,
	ip_to bigint NOT NULL,
	proxy_type character varying(3) NOT NULL,
	country_code character(2) NOT NULL,
	country_name character varying(64) NOT NULL,
	region_name character varying(128) NOT NULL,
	city_name character varying(128) NOT NULL,
	isp character varying(256) NOT NULL,
	CONSTRAINT ip2location_db1_pkey PRIMARY KEY (ip_from, ip_to)
);
導入數據庫
COPY ip2location_px4 FROM 'IP2PROXY-LITE-PX4.CSV' WITH CSV QUOTE AS '"';
導入數據庫
mongoimport -u USERNAME -p PASSWORD --authenticationDatabase admin --drop --db ip2location --collection ip2location_px4_ipv6 --type csv --file "IP2PROXY-LITE-PX4.CSV" --fields ip_from,ip_to,proxy_type,country_code,country_name,region_name,city_name,isp
建立資料庫
CREATE DATABASE ip2location;
USE ip2location;
CREATE TABLE `ip2location_px4_ipv6`(
	`ip_from` DECIMAL(39,0) UNSIGNED,
	`ip_to` DECIMAL(39,0) UNSIGNED,
	`proxy_type` VARCHAR(3),
	`country_code` CHAR(2),
	`country_name` VARCHAR(64),
	`region_name` VARCHAR(128),
	`city_name` VARCHAR(128),
	`isp` VARCHAR(256),
	PRIMARY KEY (`ip_to`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
導入數據庫
LOAD DATA LOCAL
	INFILE 'IP2PROXY-LITE-PX4.IPV6.CSV'
INTO TABLE
	`ip2location_px4_ipv6`
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
IGNORE 0 LINES;
建立資料庫
CREATE DATABASE ip2location
GO

USE ip2location
GO

CREATE TABLE [ip2location].[dbo].[ip2location_px4_ipv6](
	[ip_from] char(39) NOT NULL,
	[ip_to] char(39) NOT NULL,
	[proxy_type] nvarchar(3) NOT NULL,
	[country_code] nvarchar(2) NOT NULL,
	[country_name] nvarchar(64) NOT NULL,
	[region_name] nvarchar(128) NOT NULL,
	[city_name] nvarchar(128) NOT NULL,
	[isp] nvarchar(256) NOT NULL
) ON [PRIMARY]
GO

CREATE CLUSTERED INDEX [ip_to] ON [ip2location].[dbo].[ip2location_px4_ipv6]([ip_to]) ON [PRIMARY]
GO
導入數據庫
BULK INSERT [ip2location].[dbo].[ip2location_px4_ipv6]
FROM '{PATH TO IP2PROXY-LITE-PX4.IPV6.CSV}'
WITH
(
	FORMATFILE = '{PATH TO PX4.FMT}'
)
GO

12.0
9
1 SQLCHAR 0 1 "\"" 0 first_double_quote  Latin1_General_CI_AI
2 SQLCHAR 0 39 "\",\"" 1 ip_from "",
3 SQLCHAR 0 39 "\",\"" 2 ip_to "",
4 SQLCHAR 0 3 "\",\"" 3 proxy_type Latin1_General_CI_AI,
5 SQLCHAR 0 2 "\",\"" 4 country_code Latin1_General_CI_AI,
6 SQLCHAR 0 64 "\",\"" 5 country_name Latin1_General_CI_AI,
7 SQLCHAR 0 128 "\",\"" 6 region_name Latin1_General_CI_AI,
8 SQLCHAR 0 128 "\",\"" 7 city_name Latin1_General_CI_AI,
9 SQLCHAR 0 256 "\",\"" 8 isp Latin1_General_CI_AI

建立資料庫
CREATE DATABASE ip2location WITH ENCODING 'UTF8';
\c ip2location
CREATE TABLE ip2location_px4_ipv6(
	ip_from decimal(39,0) NOT NULL,
	ip_to decimal(39,0) NOT NULL,
	proxy_type character varying(3) NOT NULL,
	country_code character(2) NOT NULL,
	country_name character varying(64) NOT NULL,
	region_name character varying(128) NOT NULL,
	city_name character varying(128) NOT NULL,
	isp character varying(256) NOT NULL,
	CONSTRAINT ip2location_db1_pkey PRIMARY KEY (ip_from, ip_to)
);
導入數據庫
COPY ip2location_px4_ipv6 FROM 'IP2PROXY-LITE-PX4.IPV6.CSV' WITH CSV QUOTE AS '"';
導入數據庫
mongoimport -u USERNAME -p PASSWORD --authenticationDatabase admin --drop --db ip2location --collection ip2location_px4_ipv6 --type csv --file "IP2PROXY-LITE-PX4.IPV6.CSV" --fields ip_from,ip_to,proxy_type,country_code,country_name,region_name,city_name,isp

示例數據庫

以下是為您提供參考的示例數據庫。 


"ip_from","ip_to","proxy_type","country_code","country_name","region_name","city_name","isp"
"16782178","16782178","PUB","JP","Japan","Tokyo","Tokyo","I2TS Inc."
"16782320","16782320","PUB","JP","Japan","Tokyo","Tokyo","I2TS Inc."
"16782350","16782350","PUB","JP","Japan","Tokyo","Tokyo","I2TS Inc."
"16783214","16783214","PUB","JP","Japan","Tokyo","Tokyo","I2TS Inc."
"16783399","16783399","PUB","JP","Japan","Tokyo","Tokyo","I2TS Inc."
"16783523","16783523","PUB","JP","Japan","Tokyo","Tokyo","I2TS Inc."
"16783571","16783571","PUB","JP","Japan","Tokyo","Tokyo","I2TS Inc."
"16783766","16783766","PUB","JP","Japan","Tokyo","Tokyo","I2TS Inc."
"16784030","16784030","PUB","JP","Japan","Tokyo","Tokyo","I2TS Inc."
"16784101","16784101","PUB","JP","Japan","Tokyo","Tokyo","I2TS Inc."
"16784241","16784241","PUB","JP","Japan","Tokyo","Tokyo","I2TS Inc."
"16784549","16784549","PUB","JP","Japan","Tokyo","Tokyo","I2TS Inc."
"16784584","16784584","PUB","JP","Japan","Tokyo","Tokyo","I2TS Inc."
"16811364","16811364","PUB","TH","Thailand","Krung Thep Maha Nakhon","Bangkok","TOT Public Company Limited"
"16812048","16812048","PUB","TH","Thailand","Prachuap Khiri Khan","Kui Buri","TOT Public Company Limited"
"16812131","16812131","PUB","TH","Thailand","Prachuap Khiri Khan","Kui Buri","TOT Public Company Limited"
"16812230","16812230","PUB","TH","Thailand","Prachuap Khiri Khan","Kui Buri","TOT Public Company Limited"
"16815399","16815399","PUB","TH","Thailand","Phangnga","Takua Pa","TOT Public Company Limited"
"16820741","16820741","PUB","TH","Thailand","Surat Thani","Ko Samui","TOT Public Company Limited"
"16820786","16820786","PUB","TH","Thailand","Surat Thani","Ko Samui","TOT Public Company Limited"
"16821205","16821205","PUB","TH","Thailand","Phra Nakhon Si Ayutthaya","Wang Noi","TOT Public Company Limited"
"16829783","16829783","PUB","TH","Thailand","Nakhon Sawan","Tha Tako","TOT Public Company Limited"
"16830637","16830637","PUB","TH","Thailand","Ratchaburi","Damnoen Saduak","TOT Public Company Limited"
"16830846","16830846","PUB","TH","Thailand","Phetchaburi","Cha-am","TOT Public Company Limited"
"16833601","16833601","PUB","TH","Thailand","Surat Thani","Koh Tao","TOT Public Company Limited"
"16841686","16841686","PUB","TH","Thailand","Narathiwat","Su-ngai Kolok","TOT Public Company Limited"
"16869383","16869383","PUB","JP","Japan","Tokyo","Tokyo","I2TS Inc."
"16869445","16869445","PUB","JP","Japan","Tokyo","Tokyo","I2TS Inc."
"16869446","16869446","PUB","JP","Japan","Tokyo","Tokyo","I2TS Inc."
"16869553","16869553","PUB","JP","Japan","Tokyo","Tokyo","I2TS Inc."
"16870797","16870797","PUB","JP","Japan","Tokyo","Tokyo","I2TS Inc."
"16873176","16873176","PUB","JP","Japan","Tokyo","Tokyo","I2TS Inc."
"16874612","16874612","PUB","JP","Japan","Tokyo","Tokyo","I2TS Inc."
"16876127","16876127","PUB","TH","Thailand","Nakhon Phanom","Renu Nakhon","TOT Public Company Limited"
"16885722","16885722","PUB","TH","Thailand","Chiang Rai","Wiang Pa Pao","TOT Public Company Limited"
"16899082","16899082","PUB","TH","Thailand","Nan","Nan","TOT Public Company Limited"
"16899135","16899135","PUB","TH","Thailand","Nan","Nan","TOT Public Company Limited"
"16899172","16899172","PUB","TH","Thailand","Nan","Nan","TOT Public Company Limited"
"16900112","16900112","PUB","TH","Thailand","Nakhon Ratchasima","Nakhon Ratchasima","TOT Public Company Limited"
"16900799","16900799","PUB","TH","Thailand","Maha Sarakham","Kantharawichai","TOT Public Company Limited"
"16901478","16901478","PUB","TH","Thailand","Nakhon Ratchasima","Nakhon Ratchasima","TOT Public Company Limited"
"16901728","16901728","PUB","TH","Thailand","Nakhon Ratchasima","Nakhon Ratchasima","TOT Public Company Limited"
"16903512","16903512","PUB","TH","Thailand","Kalasin","Kalasin","TOT Public Company Limited"
"16908801","16908801","PUB","CN","China","Beijing","Beijing","Knet Techonlogy (Beijing) Co. Ltd."
"16945305","16945305","PUB","TH","Thailand","Khon Kaen","Khon Kaen","TOT Public Company Limited"
"16951591","16951591","PUB","TH","Thailand","Udon Thani","Kut Chap","TOT Public Company Limited"
"16953428","16953428","PUB","TH","Thailand","Krung Thep Maha Nakhon","Bangkok","TOT Public Company Limited"
"16953453","16953453","PUB","TH","Thailand","Krung Thep Maha Nakhon","Bangkok","TOT Public Company Limited"
"16953455","16953455","PUB","TH","Thailand","Krung Thep Maha Nakhon","Bangkok","TOT Public Company Limited"
"16953513","16953513","PUB","TH","Thailand","Krung Thep Maha Nakhon","Bangkok","TOT Public Company Limited"
"16953541","16953541","PUB","TH","Thailand","Krung Thep Maha Nakhon","Bangkok","TOT Public Company Limited"
"16955781","16955781","PUB","TH","Thailand","Krung Thep Maha Nakhon","Bangkok","TOT Public Company Limited"
"16955862","16955862","PUB","TH","Thailand","Krung Thep Maha Nakhon","Bangkok","TOT Public Company Limited"
"16955888","16955888","PUB","TH","Thailand","Krung Thep Maha Nakhon","Bangkok","TOT Public Company Limited"
"16961926","16961926","PUB","TH","Thailand","Krung Thep Maha Nakhon","Bangkok","TOT Public Company Limited"
"16962595","16962595","PUB","TH","Thailand","Pathum Thani","Nong Suea","TOT Public Company Limited"
"16962757","16962757","PUB","TH","Thailand","Pathum Thani","Nong Suea","TOT Public Company Limited"
"16963420","16963420","PUB","TH","Thailand","Pathum Thani","Ban Lam Luk Ka","TOT Public Company Limited"
"16963757","16963757","PUB","TH","Thailand","Krung Thep Maha Nakhon","Bangkok","TOT Public Company Limited"
"16963811","16963811","PUB","TH","Thailand","Krung Thep Maha Nakhon","Bangkok","TOT Public Company Limited"
"16963942","16963942","PUB","TH","Thailand","Nonthaburi","Mueang Nonthaburi","TOT Public Company Limited"
"16964234","16964234","PUB","TH","Thailand","Krung Thep Maha Nakhon","Bangkok","TOT Public Company Limited"
"16964320","16964320","PUB","TH","Thailand","Krung Thep Maha Nakhon","Bangkok","TOT Public Company Limited"
"16964924","16964924","PUB","TH","Thailand","Krung Thep Maha Nakhon","Bangkok","TOT Public Company Limited"
"16965140","16965140","PUB","TH","Thailand","Nonthaburi","Bang Yai","TOT Public Company Limited"
"16965242","16965242","PUB","TH","Thailand","Nonthaburi","Bang Yai","TOT Public Company Limited"
"16965388","16965388","PUB","TH","Thailand","Krung Thep Maha Nakhon","Bangkok","TOT Public Company Limited"
"16965526","16965526","PUB","TH","Thailand","Krung Thep Maha Nakhon","Bangkok","TOT Public Company Limited"
"16970216","16970216","PUB","TH","Thailand","Nakhon Sawan","Nakhon Sawan","TOT Public Company Limited"
"16972865","16972865","PUB","TH","Thailand","Krung Thep Maha Nakhon","Bangkok","TOT Public Company Limited"
"17076457","17076457","PUB","TH","Thailand","Krung Thep Maha Nakhon","Bangkok","TOT Public Company Limited"
"17077163","17077163","PUB","TH","Thailand","Nakhon Nayok","Pak Phli","TOT Public Company Limited"
"17077258","17077258","PUB","TH","Thailand","Chiang Mai","San Pa Tong","TOT Public Company Limited"
"17077574","17077574","PUB","TH","Thailand","Nonthaburi","Mueang Nonthaburi","TOT Public Company Limited"
"17079587","17079587","PUB","TH","Thailand","Trat","Ko Kut","TOT Public Company Limited"
"17080712","17080712","PUB","TH","Thailand","Krung Thep Maha Nakhon","Bangkok","TOT Public Company Limited"
"17080960","17080960","PUB","TH","Thailand","Nonthaburi","Mueang Nonthaburi","TOT Public Company Limited"
"17081254","17081254","PUB","TH","Thailand","Krung Thep Maha Nakhon","Bangkok","TOT Public Company Limited"
"17081366","17081366","PUB","TH","Thailand","Krung Thep Maha Nakhon","Bangkok","TOT Public Company Limited"
"17082168","17082168","PUB","TH","Thailand","Krung Thep Maha Nakhon","Bangkok","TOT Public Company Limited"
"17082841","17082841","PUB","TH","Thailand","Krung Thep Maha Nakhon","Bangkok","TOT Public Company Limited"
"17083721","17083721","PUB","TH","Thailand","Nonthaburi","Mueang Nonthaburi","TOT Public Company Limited"
"17089394","17089394","PUB","TH","Thailand","Krung Thep Maha Nakhon","Bangkok","TOT Public Company Limited"
"17090067","17090067","PUB","TH","Thailand","Phangnga","Kapong","TOT Public Company Limited"
"17090133","17090133","PUB","TH","Thailand","Phangnga","Kapong","TOT Public Company Limited"
"17090182","17090182","PUB","TH","Thailand","Phangnga","Kapong","TOT Public Company Limited"
"17090254","17090254","PUB","TH","Thailand","Phangnga","Kapong","TOT Public Company Limited"
"17090269","17090269","PUB","TH","Thailand","Phangnga","Kapong","TOT Public Company Limited"
"17090275","17090275","PUB","TH","Thailand","Phangnga","Kapong","TOT Public Company Limited"
"17090663","17090663","PUB","TH","Thailand","Chon Buri","Pattaya","TOT Public Company Limited"
"17090798","17090798","PUB","TH","Thailand","Chon Buri","Pattaya","TOT Public Company Limited"
"17091520","17091520","PUB","TH","Thailand","Chon Buri","Pattaya","TOT Public Company Limited"
"17094322","17094322","PUB","TH","Thailand","Krung Thep Maha Nakhon","Bangkok","TOT Public Company Limited"
"17094788","17094788","PUB","TH","Thailand","Nakhon Ratchasima","Nakhon Ratchasima","TOT Public Company Limited"
"17103383","17103384","PUB","TH","Thailand","Trat","Ko Chang Tai","TOT Public Company Limited"
"17103430","17103430","PUB","TH","Thailand","Trat","Ko Chang Tai","TOT Public Company Limited"
"17103443","17103443","PUB","TH","Thailand","Trat","Ko Chang Tai","TOT Public Company Limited"
"17103516","17103516","PUB","TH","Thailand","Trat","Ko Chang Tai","TOT Public Company Limited"
"17103626","17103626","PUB","TH","Thailand","Chon Buri","Pattaya","TOT Public Company Limited"
"17103628","17103628","PUB","TH","Thailand","Chon Buri","Pattaya","TOT Public Company Limited"

AMI和圖像

IP2Location提供了一個免費的，預先配置且可立即運行的AMI和映像，可輕鬆設置數據庫。

Amazon Web Services
Docker Images

執照

請查看通用條款和條件中的數據庫許可。

同類產品

文章和教程

IP2Proxy IP地址地理位置數據庫

在商業版中，您將獲得的不僅僅是IP地址查找：

  • 更高的數據準確性
  • 訪問最新數據庫
  • 通過電子郵件獲得更多支持
現在升級
學到更多
Product Upgrade
Sign Up Pop Out

定位您的訪客位置

使用我們的免費數據庫來增強您的應用程序，獲取必需的地理定位數據。

Get Started For Free Now