Amazonbot · SQL

SQL inserts to load Amazonbot CIDRs into a database table. 3,131 CIDRs, refreshed daily.
// amazonbot_ips.sql

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

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

INSERT INTO `amazonbot_ips` (`ip_address`, `ip_type`) VALUES ('3.81.194.188/32', 'IPv4');
INSERT INTO `amazonbot_ips` (`ip_address`, `ip_type`) VALUES ('3.81.245.78/32', 'IPv4');
INSERT INTO `amazonbot_ips` (`ip_address`, `ip_type`) VALUES ('3.81.253.151/32', 'IPv4');
INSERT INTO `amazonbot_ips` (`ip_address`, `ip_type`) VALUES ('3.81.253.213/32', 'IPv4');
INSERT INTO `amazonbot_ips` (`ip_address`, `ip_type`) VALUES ('3.82.29.30/32', 'IPv4');
INSERT INTO `amazonbot_ips` (`ip_address`, `ip_type`) VALUES ('3.82.67.224/32', 'IPv4');
INSERT INTO `amazonbot_ips` (`ip_address`, `ip_type`) VALUES ('3.82.90.168/32', 'IPv4');
INSERT INTO `amazonbot_ips` (`ip_address`, `ip_type`) VALUES ('3.82.135.179/32', 'IPv4');
INSERT INTO `amazonbot_ips` (`ip_address`, `ip_type`) VALUES ('3.83.75.212/32', 'IPv4');
INSERT INTO `amazonbot_ips` (`ip_address`, `ip_type`) VALUES ('3.84.64.201/32', 'IPv4');
INSERT INTO `amazonbot_ips` (`ip_address`, `ip_type`) VALUES ('3.85.116.107/32', 'IPv4');
INSERT INTO `amazonbot_ips` (`ip_address`, `ip_type`) VALUES ('3.85.141.163/32', 'IPv4');
INSERT INTO `amazonbot_ips` (`ip_address`, `ip_type`) VALUES ('3.85.182.19/32', 'IPv4');
INSERT INTO `amazonbot_ips` (`ip_address`, `ip_type`) VALUES ('3.86.74.89/32', 'IPv4');
INSERT INTO `amazonbot_ips` (`ip_address`, `ip_type`) VALUES ('3.86.129.126/32', 'IPv4');
INSERT INTO `amazonbot_ips` (`ip_address`, `ip_type`) VALUES ('3.86.137.101/32', 'IPv4');
INSERT INTO `amazonbot_ips` (`ip_address`, `ip_type`) VALUES ('3.87.104.37/32', 'IPv4');
… (3114 more lines)