Tor Exit Nodes · SQL

SQL inserts to load Tor Exit Nodes CIDRs into a database table. 1,218 CIDRs, refreshed daily.
// tor_ips.sql

DOWNLOAD ↓ ·
-- SQL script to create table `tor_ips` and insert IP addresses

CREATE TABLE IF NOT EXISTS `tor_ips` (
  `ip_address` VARCHAR(45) NOT NULL,
  `ip_type` VARCHAR(10) NOT NULL,
  PRIMARY KEY (`ip_address`)
);

INSERT INTO `tor_ips` (`ip_address`, `ip_type`) VALUES ('2.26.97.42/32', 'IPv4');
INSERT INTO `tor_ips` (`ip_address`, `ip_type`) VALUES ('2.56.10.36/32', 'IPv4');
INSERT INTO `tor_ips` (`ip_address`, `ip_type`) VALUES ('5.2.67.226/32', 'IPv4');
INSERT INTO `tor_ips` (`ip_address`, `ip_type`) VALUES ('5.2.79.190/32', 'IPv4');
INSERT INTO `tor_ips` (`ip_address`, `ip_type`) VALUES ('5.44.252.164/32', 'IPv4');
INSERT INTO `tor_ips` (`ip_address`, `ip_type`) VALUES ('5.104.86.6/32', 'IPv4');
INSERT INTO `tor_ips` (`ip_address`, `ip_type`) VALUES ('5.181.177.69/32', 'IPv4');
INSERT INTO `tor_ips` (`ip_address`, `ip_type`) VALUES ('5.230.249.72/32', 'IPv4');
INSERT INTO `tor_ips` (`ip_address`, `ip_type`) VALUES ('5.253.247.27/32', 'IPv4');
INSERT INTO `tor_ips` (`ip_address`, `ip_type`) VALUES ('5.255.101.10/32', 'IPv4');
INSERT INTO `tor_ips` (`ip_address`, `ip_type`) VALUES ('5.255.102.26/32', 'IPv4');
INSERT INTO `tor_ips` (`ip_address`, `ip_type`) VALUES ('5.255.104.202/32', 'IPv4');
INSERT INTO `tor_ips` (`ip_address`, `ip_type`) VALUES ('5.255.105.87/32', 'IPv4');
INSERT INTO `tor_ips` (`ip_address`, `ip_type`) VALUES ('5.255.108.145/32', 'IPv4');
INSERT INTO `tor_ips` (`ip_address`, `ip_type`) VALUES ('5.255.110.120/32', 'IPv4');
INSERT INTO `tor_ips` (`ip_address`, `ip_type`) VALUES ('5.255.111.52/32', 'IPv4');
INSERT INTO `tor_ips` (`ip_address`, `ip_type`) VALUES ('5.255.115.58/32', 'IPv4');
… (1201 more lines)