GeoIP2 Anonymous IP CSV Database

In addition to our MaxMind DB binary format, we also offer GeoIP2 databases in a CSV format suitable for importing into a SQL database. This documentation details the format of those CSV files. The CSV files are shipped as a single zip file.

Zip File

The zip file itself is named GeoIP2-Anonymous-IP-CSV_{YYYYMMDD}.zip. The downloaded zip file contains a single directory which in turn contains several files. That directory is named GeoIP2-Anonymous-IP-CSV_{YYYYMMDD}.

The files in this zip archive are:

Filename Description
LICENSE.txt End user license
COPYRIGHT.txt Copyright statement
GeoIP2-Anonymous-IP-Blocks-IPv4.csv CSV file containing data on IPv4 addresses
GeoIP2-Anonymous-IP-Blocks-IPv6.csv CSV file containing data on IPv6 addresses

CSV File Format

All the CSV files start with a single header row containing column names. The specific column names and their contents are detailed below. The files are encoded as UTF-8.

Blocks Files

There are two CSV files for network blocks, one each for IPv4 and IPv6 blocks. These are named GeoIP2-Anonymous-IP-Blocks-IPv4.csv and GeoIP2-Anonymous-IP-Blocks-IPv6.csv respectively.

Name Type Description
network IP network as a string This is the IPv4 or IPv6 network in CIDR format such as “2.21.92.0/29” or “2001:4b0::/80”. We offer a utility to convert this column to start/end IPs or start/end integers. See the conversion utility section for details.
is_anonymous boolean 1 if the IP address belongs to any sort of anonymous network. Blank if not.
is_anonymous_vpn boolean 1 if the IP address belongs to an anonymous VPN system. Blank if not.
is_hosting_provider boolean 1 if the IP address belongs to a hosting provider. Blank if not.
is_public_proxy boolean 1 if the IP address belongs to a public proxy. Blank if not.
is_tor_exit_node boolean 1 if the IP address is a Tor exit node. Blank if not.

Conversion Utility

We’ve created a small utility program to allow you to convert a GeoIP2 CSV file’s representation of IP addresses to another format. You can choose between start/end IP addresses, with the addresses represented as strings or integers.

The program is available from our geoip2-csv-converter GitHub project releases tab.

Product Information

To learn more about the GeoIP2 Anonymous IP database, please visit the GeoIP2 Anonymous IP Database page. If you are interested in purchasing the database, please contact our Enterprise Business team for assistance.