Googlebot · SQL

SQL inserts to load Googlebot CIDRs into a database table. 315 CIDRs, refreshed daily.
// googlebot_ips.sql

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

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

INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('34.22.85.0/27', 'IPv4');
INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('34.64.82.64/28', 'IPv4');
INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('34.65.242.112/28', 'IPv4');
INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('34.80.50.80/28', 'IPv4');
INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('34.88.194.0/28', 'IPv4');
INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('34.89.10.80/28', 'IPv4');
INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('34.89.198.80/28', 'IPv4');
INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('34.96.162.48/28', 'IPv4');
INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('34.100.182.96/28', 'IPv4');
INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('34.101.50.144/28', 'IPv4');
INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('34.118.66.0/28', 'IPv4');
INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('34.118.254.0/28', 'IPv4');
INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('34.126.178.96/28', 'IPv4');
INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('34.146.150.144/28', 'IPv4');
INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('34.147.110.144/28', 'IPv4');
INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('34.151.74.144/28', 'IPv4');
INSERT INTO `googlebot_ips` (`ip_address`, `ip_type`) VALUES ('34.152.50.64/28', 'IPv4');
… (298 more lines)