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

前書き 特徴 データベースフィールド プロキシタイプ データベースのセットアップ サンプルデータベース AMIと画像 SDKとライブラリ

前書き

IP2Proxy Database

 データベースには、すべてのパブリック IPv4 および IPv6 アドレスのプロキシ タイプ、国、地域、都市の記録が含まれています。 

このデータの使用について次のように言及することにより、帰属が必要となる個人的または商業的使用は無料です。

今すぐ無料で利用できる貴重なジオロケーションデータのリソースを提供するこのデータベースを探ってみましょう！

無料登録

特徴

現行版 02 November 2025
次回更新 December 2025
IPv4 Database Size CSV: 99.52 MB (1,319,035 Rows)
CIDR: 96.28 MB (1,418,959 Rows)
IPv6 Database Size CSV: 113.64 MB (1,324,453 Rows)
CIDR: 107.54 MB (1,424,378 Rows)
IPv4 + IPv6 Binary Size BIN: 385.4 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) ISO3166に基づく2文字の国コード。
country_name VARCHAR(64) ISO3166に基づく国名。
region_name VARCHAR(128) 地域または州の名前。
city_name VARCHAR(128) 市の名前。

† IPv4
†† IPv6

プロキシタイプ

プロキシタイプ 説明 匿名
VPN VPNサービスの匿名化。これらのサービスは、IPアドレスを隠す目的で、パブリックにアクセス可能なVPNをユーザーに提供します。 高い
TOR Tor出口ノード。 Torプロジェクトは、匿名性を維持したい人が使用するオープンネットワークです。 高い
DCH 低
PUB* 高い
WEB 高い
SES 低
RES 高い
CPN 低
EPN 低

データベースのセットアップ

以下は、IPv4データとIPv6データの両方のデータベースをセットアップする手順です。

データベースの作成
CREATE DATABASE ip2location;
USE ip2location;
CREATE TABLE `ip2location_px3`(
	`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),
	PRIMARY KEY (`ip_to`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
データベースのインポート
LOAD DATA LOCAL
	INFILE 'IP2PROXY-LITE-PX3.CSV'
INTO TABLE
	`ip2location_px3`
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_px3](
	[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
) ON [PRIMARY]
GO

CREATE CLUSTERED INDEX [ip_to] ON [ip2location].[dbo].[ip2location_px3]([ip_to]) ON [PRIMARY]
GO
データベースのインポート
BULK INSERT [ip2location].[dbo].[ip2location_px3]
FROM '{PATH TO IP2PROXY-LITE-PX3.CSV}'
WITH
(
	FORMATFILE = '{PATH TO PX3.FMT}'
)
GO

注：以下のFMTコードをコピーして、PX3.FMTという名前のファイルとしてコンピューターに保存する必要があります。 

12.0
8
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

データベースの作成
CREATE DATABASE ip2location WITH ENCODING 'UTF8';
\c ip2location
CREATE TABLE ip2location_px3(
	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,
	CONSTRAINT ip2location_db1_pkey PRIMARY KEY (ip_from, ip_to)
);
データベースのインポート
COPY ip2location_px3 FROM 'IP2PROXY-LITE-PX3.CSV' WITH CSV QUOTE AS '"';
データベースのインポート
mongoimport -u USERNAME -p PASSWORD --authenticationDatabase admin --drop --db ip2location --collection ip2location_px3_ipv6 --type csv --file "IP2PROXY-LITE-PX3.CSV" --fields ip_from,ip_to,proxy_type,country_code,country_name,region_name,city_name
データベースの作成
CREATE DATABASE ip2location;
USE ip2location;
CREATE TABLE `ip2location_px3_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),
	PRIMARY KEY (`ip_to`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
データベースのインポート
LOAD DATA LOCAL
	INFILE 'IP2PROXY-LITE-PX3.IPV6.CSV'
INTO TABLE
	`ip2location_px3_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_px3_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
) ON [PRIMARY]
GO

CREATE CLUSTERED INDEX [ip_to] ON [ip2location].[dbo].[ip2location_px3_ipv6]([ip_to]) ON [PRIMARY]
GO
データベースのインポート
BULK INSERT [ip2location].[dbo].[ip2location_px3_ipv6]
FROM '{PATH TO IP2PROXY-LITE-PX3.IPV6.CSV}'
WITH
(
	FORMATFILE = '{PATH TO PX3.FMT}'
)
GO

12.0
8
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

データベースの作成
CREATE DATABASE ip2location WITH ENCODING 'UTF8';
\c ip2location
CREATE TABLE ip2location_px3_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,
	CONSTRAINT ip2location_db1_pkey PRIMARY KEY (ip_from, ip_to)
);
データベースのインポート
COPY ip2location_px3_ipv6 FROM 'IP2PROXY-LITE-PX3.IPV6.CSV' WITH CSV QUOTE AS '"';
データベースのインポート
mongoimport -u USERNAME -p PASSWORD --authenticationDatabase admin --drop --db ip2location --collection ip2location_px3_ipv6 --type csv --file "IP2PROXY-LITE-PX3.IPV6.CSV" --fields ip_from,ip_to,proxy_type,country_code,country_name,region_name,city_name

サンプルデータベース

以下は参考用のサンプルデータベースです。 


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

AMIと画像

IP2Locationは、データベースを簡単にセットアップするための、無料の事前構成済みですぐに実行できるAMIとイメージを提供します。

Amazon Web Services
Docker Images

ライセンス

データベースのライセンスについては、の一般利用規約を確認してください。

その他

記事とチュートリアル

IP2ProxyIPアドレスジオロケーションデータベース

Commercial Editionでは、IPアドレスの検索だけではありません。

  • データ精度の向上
  • 最新のデータベースへのアクセス
  • 電子メールによる追加レベルのサポート
今すぐアップグレード
もっと詳しく知る
Product Upgrade
Sign Up Pop Out

訪問者の位置をジオロケートする

無料のデータベースを使用して、アプリケーションを必須のジオロケーションデータで強化しましょう。

Get Started For Free Now