GeoIP2 Connection Type 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-Connection-Type-CSV_{YYYYMMDD}.zip. The downloaded zip file contains a single directory which in turn contains several files. That directory is named GeoIP2-Connection-Type-CSV_{YYYYMMDD}.

The files in this zip archive are:

Filename Description
LICENSE.txt End user license
COPYRIGHT.txt Copyright statement
GeoIP2-Connection-Type-Blocks-IPv4.csv CSV file containing data on IPv4 addresses
GeoIP2-Connection-Type-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-Connection-Type-Blocks-IPv4.csv and GeoIP2-Connection-Type-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.
connection_type string One of the following values: Dialup, Cable/DSL, Corporate, or Cellular. Additional values may be added in the future.

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.