Skip to Content
[CAIDA - Center for Applied Internet Data Analysis logo]
Center for Applied Internet Data Analysis
www.caida.org > data : peeringdb
PeeringDB

Description

PeeringDB, an online database of peering policies, traffic volumes and geographic presence of participating networks. PeeringDB, a non-profit member-based organization, has been established to support practical needs of network operators. However, it is also a valuable source of information for researchers. The first version of PeeringDB resided in a MySQL database, which was not scalable and lacked security features and data validation mechanisms. It presented potential risks of exposing contact information to spammers, and contained typos. Starting at the end of March 2016, PeeringDB switched to a new data schema and API.

CAIDA manages the only repository of daily snapshots of historic PeeringDB data. The repository consists of two parts, version 1 and version 2. Daily snapshots of version 1 are available as sql and sqlite files covering July 29, 2010, to March 13, 2016. In 2016 peeringDB switched to a new format. These new version 2 data are available as sql files from May 27, 2016, to March 10, 2018; and as json files from March 11, 2018, onwards.

Format

The daily snapshots are in both sql, sqlite and/or json formats. The schemas of the snapshots are not uniform; we suggest users to explore the data structure.

Example:

  sqlite3 peeringdb_dump_2016_03_14.sqlite 
  sqlite> .table 
  sqlite> .schema mgmtFacilities 

Funding

Collection of this dataset was funded under "The economics of transit and peering interconnections in the Internet" grant

Acceptable Use Agreement

Access to these data is subject to the terms of the following CAIDA Acceptable Use Agreement (printable version in PDF format)

When referencing this data (as required by the AUA), please use:

The CAIDA UCSD PeeringDB Dataset, <date range used>
https://www.caida.org/data/peeringdb.xml
Also, please, report your publication to CAIDA.

Data Access

Access the public CAIDA UCSD PeeringDB Dataset

Related Work

References

[LODHI]A. Lodhi, Larson N., Dhamdhere A., Dovrolis C., Claffy K.,Using PeeringDB to Understand the Peering Ecosystem, ACM SIGCOMM Computer Communication Review (CCR), 2014.

  Last Modified: Fri Feb-21-2020 15:35:18 PST
  Page URL: https://www.caida.org/data/peeringdb/index.xml