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

مقدمة سمات حقول قاعدة البيانات نوع الوكيل إعداد قاعدة البيانات قاعدة بيانات نموذجية AMI والصور SDK والمكتبات

مقدمة

IP2Proxy Database

  

سجل للحصول على حساب مجاني

سمات

النسخة الحالية 06 December 2025
التحديث القادم January 2026
IPv4 Database Size CSV: 99.21 MB (1,312,371 Rows)
CIDR: 95.94 MB (1,410,641 Rows)
IPv6 Database Size CSV: 113.12 MB (1,316,502 Rows)
CIDR: 107.03 MB (1,414,772 Rows)
IPv4 + IPv6 Binary Size BIN: 334.79 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) اسم المدينة.

† IPv4
†† IPv6

نوع الوكيل

نوع الوكيل وصف عدم الكشف عن هويته
VPN عالي
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

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"

رخصة

الرجاء مراجعة الشروط والأحكام العامة لترخيص قاعدة البيانات.

منتجات مماثلة

المقالات والبرامج التعليمية

IP2Proxy IP عنوان قاعدة بيانات تحديد الموقع الجغرافي

في الإصدار التجاري ، ستحصل على أكثر بكثير من مجرد البحث عن عنوان IP:

  • دقة أفضل للبيانات
  • الوصول إلى قاعدة بيانات محدثة
  • مستوى إضافي من الدعم عبر البريد الإلكتروني
تحديث الآن
يتعلم أكثر
Product Upgrade
Sign Up Pop Out

تحديد موقع زوارك

Get Started For Free Now