ASN Extended is out: every column of ASN, and fifteen more on each AS number. It's licensed and downloaded on its own, as CSV, rebuilt daily.
Fifteen more columns
| Column | What it holds |
|---|---|
upstreams, num_upstreams | The AS numbers it gets transit from, pipe-separated in ascending order, and how many |
peers, num_peers | The AS numbers it exchanges its own and its customers' routes with, and how many |
downstreams, num_downstreams | The AS numbers it provides transit to, and how many |
customer_cone_asns | Its customer cone: itself, its customers, their customers and so on down |
customer_cone_ips, customer_cone_prefixes4, customer_cone_prefixes6 | The IPv4 addresses the networks in its cone originate, and the prefixes they announce |
rank | Its place among the AS numbers in global routing by the size of its cone, 1 the largest |
transit_degree | How many distinct networks it's seen carrying routes between |
tier1 | 1 for the transit-free networks at the top, which get transit from no one and peer with each other |
siblings, num_siblings | The other AS numbers registered to the same organization, routed or not, and how many |
A relationship is how two networks route each other's traffic, which isn't always what either one pays the other.
Five AS numbers from the October 13 build:
| AS | Name | Rank | Tier 1 | Cone ASNs | Upstreams | Peers | Downstreams | Siblings |
|---|---|---|---|---|---|---|---|---|
| 3356 | Level 3 Parent, LLC | 2 | 1 | 43576 | 0 | 155 | 6371 | 39 |
| 9121 | Turk Telekomunikasyon Anonim Sirketi | 121 | 502 | 5 | 75 | 303 | 0 | |
| 5089 | Virgin Media Limited | 714 | 62 | 2 | 14 | 57 | 6 | |
| 786 | Jisc Services Limited | 1157 | 32 | 5 | 67 | 25 | 2 | |
| 12322 | Free SAS | 4902 | 4 | 2 | 80 | 3 | 1 |
Turk Telekom's upstreams is 1299|2914|3257|3320|3356, all five of them Tier 1 networks, and Virgin Media's siblings is 5462|13076|42987|43629|50534|62016.
What's in it
The October 13 build holds 123,192 AS numbers, the same rows as ASN. 80,395 of them are in global routing and ranked; the rest keep their rows, with no rank and zeros. Between the routed ones, it records 167,459 transit relationships and 478,012 peerings, from public BGP routing data.
15 networks are Tier 1. 12,183 provide transit to at least one other network, and 32,152 get transit from a single upstream. 27,280 AS numbers have a sibling, in 7,967 organizations that hold two or more.
What the columns are for
customer_cone_ips sizes a network by the address space it carries, not the addresses it originates: Lumen's AS3356 originates 27,414,024 IPv4 addresses itself; the networks in its cone originate 1,611,203,529.
upstreams says which networks an AS depends on for transit, and a num_upstreams of 1 says it depends on one. A transit provider reads it the other way round: the networks that get transit from its competitors.
siblings puts an organization's AS numbers together. Comcast's AS7922 lists 55, its regional networks among them, so traffic from any of them reads as Comcast's.
Getting access
ASN Extended ships as CSV, rebuilt daily, and its docs page has the schema. Sign up to evaluate it from its sample. A license is per database and never metered: see licensing, or talk to us about what you need. With a license, it's in BigQuery too.
