Google Services · SQL

SQL inserts to load Google Services CIDRs into a database table. 340 CIDRs, refreshed daily.
// googleservices_ips.sql

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

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

INSERT INTO `googleservices_ips` (`ip_address`, `ip_type`) VALUES ('8.8.4.0/24', 'IPv4');
INSERT INTO `googleservices_ips` (`ip_address`, `ip_type`) VALUES ('8.8.8.0/24', 'IPv4');
INSERT INTO `googleservices_ips` (`ip_address`, `ip_type`) VALUES ('8.35.200.0/21', 'IPv4');
INSERT INTO `googleservices_ips` (`ip_address`, `ip_type`) VALUES ('8.230.128.0/17', 'IPv4');
INSERT INTO `googleservices_ips` (`ip_address`, `ip_type`) VALUES ('8.231.0.0/19', 'IPv4');
INSERT INTO `googleservices_ips` (`ip_address`, `ip_type`) VALUES ('8.234.0.0/23', 'IPv4');
INSERT INTO `googleservices_ips` (`ip_address`, `ip_type`) VALUES ('8.234.18.0/23', 'IPv4');
INSERT INTO `googleservices_ips` (`ip_address`, `ip_type`) VALUES ('8.234.20.0/22', 'IPv4');
INSERT INTO `googleservices_ips` (`ip_address`, `ip_type`) VALUES ('8.234.24.0/21', 'IPv4');
INSERT INTO `googleservices_ips` (`ip_address`, `ip_type`) VALUES ('8.236.0.0/15', 'IPv4');
INSERT INTO `googleservices_ips` (`ip_address`, `ip_type`) VALUES ('34.0.228.0/22', 'IPv4');
INSERT INTO `googleservices_ips` (`ip_address`, `ip_type`) VALUES ('34.0.232.0/21', 'IPv4');
INSERT INTO `googleservices_ips` (`ip_address`, `ip_type`) VALUES ('34.1.64.0/18', 'IPv4');
INSERT INTO `googleservices_ips` (`ip_address`, `ip_type`) VALUES ('34.2.64.0/21', 'IPv4');
INSERT INTO `googleservices_ips` (`ip_address`, `ip_type`) VALUES ('34.2.72.0/22', 'IPv4');
INSERT INTO `googleservices_ips` (`ip_address`, `ip_type`) VALUES ('34.2.78.0/23', 'IPv4');
INSERT INTO `googleservices_ips` (`ip_address`, `ip_type`) VALUES ('34.2.80.0/20', 'IPv4');
… (323 more lines)