Amazonbot · SQL

SQL inserts to load Amazonbot CIDRs into a database table. 2,059 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.253.213/32', 'IPv4');
INSERT INTO `amazonbot_ips` (`ip_address`, `ip_type`) VALUES ('3.89.170.186/32', 'IPv4');
INSERT INTO `amazonbot_ips` (`ip_address`, `ip_type`) VALUES ('3.89.176.255/32', 'IPv4');
INSERT INTO `amazonbot_ips` (`ip_address`, `ip_type`) VALUES ('3.90.73.206/32', 'IPv4');
INSERT INTO `amazonbot_ips` (`ip_address`, `ip_type`) VALUES ('3.91.138.117/32', 'IPv4');
INSERT INTO `amazonbot_ips` (`ip_address`, `ip_type`) VALUES ('3.92.253.216/32', 'IPv4');
INSERT INTO `amazonbot_ips` (`ip_address`, `ip_type`) VALUES ('3.93.98.99/32', 'IPv4');
INSERT INTO `amazonbot_ips` (`ip_address`, `ip_type`) VALUES ('3.93.211.16/32', 'IPv4');
INSERT INTO `amazonbot_ips` (`ip_address`, `ip_type`) VALUES ('3.93.253.174/32', 'IPv4');
INSERT INTO `amazonbot_ips` (`ip_address`, `ip_type`) VALUES ('3.94.40.182/32', 'IPv4');
INSERT INTO `amazonbot_ips` (`ip_address`, `ip_type`) VALUES ('3.94.46.239/32', 'IPv4');
INSERT INTO `amazonbot_ips` (`ip_address`, `ip_type`) VALUES ('3.94.156.104/32', 'IPv4');
INSERT INTO `amazonbot_ips` (`ip_address`, `ip_type`) VALUES ('3.94.157.25/32', 'IPv4');
INSERT INTO `amazonbot_ips` (`ip_address`, `ip_type`) VALUES ('3.94.199.128/32', 'IPv4');
INSERT INTO `amazonbot_ips` (`ip_address`, `ip_type`) VALUES ('3.208.47.73/32', 'IPv4');
INSERT INTO `amazonbot_ips` (`ip_address`, `ip_type`) VALUES ('3.208.146.193/32', 'IPv4');
INSERT INTO `amazonbot_ips` (`ip_address`, `ip_type`) VALUES ('3.208.156.9/32', 'IPv4');
… (2042 more lines)