BGP Routing Tables and Prefix Announcements
This dataset provides detailed BGP routing table snapshots, including advertised IP prefixes, AS paths, route origins, BGP communities, and route selection metrics such as local preference and MED. It enables analysis of global internet routing dynamics, prefix aggregation, and network policy propagation, making it valuable for network operators, researchers, and security analysts.
Sample rows
preview · 8 of 700 rows · all 11 columns| prefixstring | route_origin_typestring | local_prefinteger | aggregatedboolean | collector_idstring | as_pathstring | origin_asinteger | next_hopstring | medinteger | bgp_communitiesstring | timestampdatetime |
|---|---|---|---|---|---|---|---|---|---|---|
| 8.8.8.0/24 | EGP | 120 | false | COLL-GLOBAL | 15169 3356 64512 | 64512 | 8.8.8.1 | 10 | 64512:100 3356:200 | 2024-06-21T08:15:32Z |
| 10.0.0.0/8 | IGP | 80 | true | COLL-A1 | 65001 | 65001 | 10.0.0.1 | 0 | blank | 2024-06-13T14:22:05Z |
| 185.25.60.0/22 | EGP | 150 | false | COLL-EUROPE | 6939 64500 | 64500 | 185.25.60.1 | 50 | 64500:220 | 2024-06-19T12:01:37Z |
| 0.0.0.0/0 | INCOMPLETE | 32767 | true | COLL-ROOT | 65535 | 65535 | 0.0.0.1 | 0 | blank | 2024-06-22T01:09:45Z |
| 192.168.100.0/24 | IGP | 90 | false | COLL-ENTERPRISE | 65010 65020 | 65020 | 192.168.100.1 | 2 | blank | 2024-06-16T15:27:12Z |
| 2.2.2.0/23 | EGP | 110 | false | COLL-ASIA | 6939 12345 67890 | 67890 | 2.2.2.2 | 15 | 67890:300 | 2024-06-10T09:53:28Z |
| 224.0.0.0/4 | INCOMPLETE | blank | true | COLL-MULTICAST | 65500 | 65500 | 224.0.0.1 | blank | blank | 2024-06-18T05:44:11Z |
| 172.16.0.0/12 | IGP | 0 | true | COLL-ENTERPRISE | 65000 65001 | 65001 | 172.16.0.1 | 0 | blank | 2024-06-22T13:10:19Z |
| 100.64.0.0/10 | INCOMPLETE | blank | true | COLL-ISOLATED | 64513 64514 | 64514 | 100.64.0.1 | 0 | blank | 2024-06-21T19:13:08Z |
| 240.0.0.0/5 | INCOMPLETE | blank | true | COLL-EXPERIMENTAL | 64599 | 64599 | 240.0.0.1 | blank | blank | 2024-06-17T23:05:38Z |
| 169.254.0.0/16 | IGP | 2 | true | COLL-APIPA | 65534 | 65534 | 169.254.0.1 | 2 | blank | 2024-06-15T11:30:41Z |
| 203.0.113.0/24 | EGP | 150 | false | COLL-GLOBAL | 3356 15169 | 15169 | 203.0.113.1 | 10 | 15169:80 | 2024-06-12T10:22:59Z |
| 172.20.0.0/14 | IGP | 50 | true | COLL-ENTERPRISE | 65000 | 65000 | 172.20.0.1 | 5 | blank | 2024-06-18T17:47:26Z |
| 192.0.2.0/24 | EGP | 100 | false | COLL-GLOBAL | 3356 64512 | 64512 | 192.0.2.2 | 20 | 64512:110 | 2024-06-11T16:39:51Z |
| 172.31.0.0/16 | IGP | 80 | true | COLL-ENTERPRISE | 65000 65002 | 65002 | 172.31.0.1 | 10 | blank | 2024-06-22T07:21:06Z |
| 45.33.32.0/20 | EGP | 150 | false | COLL-USA | 63949 64599 | 64599 | 45.33.32.1 | 15 | 63949:120 64599:140 | 2024-06-20T03:45:23Z |
| 103.21.244.0/22 | EGP | 100 | false | COLL-ASIA | 64599 13335 | 13335 | 103.21.244.1 | 20 | 13335:200 | 2024-06-22T04:19:28Z |
| 10.10.10.0/24 | IGP | 0 | true | COLL-A1 | 65011 | 65011 | 10.10.10.1 | 0 | blank | 2024-06-18T20:55:18Z |
| 192.0.0.0/29 | EGP | 255 | false | COLL-EDGE | 3356 54000 54001 54002 | 54002 | 192.0.0.7 | 4294967295 | 54000:400 54002:405 | 2024-06-21T11:44:15Z |
| 172.19.0.0/16 | IGP | 100 | true | COLL-ENTERPRISE | 65000 65022 | 65022 | 172.19.0.254 | 2 | blank | 2024-06-16T18:33:22Z |
What the 700 rows show
from the 700-row sampleINCOMPLETE (route origin type) stands out: mean local_
- 51%aggregated = true
- 100median local_
pref - 64,538median origin_
as - 10median med
Median 100, from 0 to 2,147,483,647.
- string 6
- integer 3
- datetime 1
- boolean 1
Columns
11 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 6 columns | |||
prefix | string | Advertised IP prefix in CIDR notation (e.g., 192.0.2.0/24) | 8.8.8.0/24 |
as_path | string | Sequence of AS numbers traversed to reach the prefix, separated by spaces (e.g., '64512 64513 64514') | 15169 3356 64512 |
next_hop | string | IP address of the next-hop router for the route | 8.8.8.1 |
bgp_communities | string | Space-separated list of BGP community values associated with the route (e.g., '64512:100 64513:200')optional | 64512:100 3356:200 |
route_origin_type | string | Type of route origin (e.g., 'IGP', 'EGP', 'INCOMPLETE')IGP · EGP · INCOMPLETE · optional | EGP |
collector_id | string | Identifier for the BGP collector or monitoring point where the route was observed | COLL-GLOBAL |
| Numbers 3 columns | |||
origin_as | integer | Autonomous System Number (ASN) that originated the prefix announcement1 or more | 64512 |
local_pref | integer | Local preference value used to select preferred routes within an AS0 or more · optional | 120 |
med | integer | Multi-Exit Discriminator value indicating preferred entry points between ASes0 or more · optional | 10 |
| Dates and times 1 column | |||
timestamp | datetime | Date and time when the prefix announcement was observed | 2024-06-21T08:15:32Z |
| True or false 1 column | |||
aggregated | boolean | Indicates whether the prefix is the result of aggregation (true) or a specific announcement (false) | false |
Use it for
A telecommunications dashboard
The aggregated rate, local_
pref by route_ origin_ type and a breakdown of collector_ id. Excel, Power BI or Tableau. Why do the 60 INCOMPLETE rows have a mean local_
pref of 501,093,722? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Prefixes7008.8.8.0/24120EGP10.0.0.0/880IGP0.0.0.0/032767INCOMPLE…
A software demo
Believable prefixes with as_
path, origin_ as and next_ hop to fill a screen in front of a buyer.
blueprint · bgp-routing-tables-and-prefix-announcements
Behind this dataset
Same schema. As many rows as you need.
These 700 rows came out of a blueprint — 11 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
- Prefix announced: IPv4 CIDR (e.g., 203.0.113.0/24) or IPv6
- AS number: autonomous system number of originating network
- AS path: sequence of AS numbers from origin to destination
- BGP communities: tags for route policy (no-export, prepending, etc.)
- Route origin: IGP (interior gateway protocol), EGP, incomplete
- Next-hop: router IP address for forwarding traffic
- Local preference: route preference within AS (higher is better)
- MED (Multi-Exit Discriminator): prefer certain paths for inbound traffic
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- bgp-routing-tables-and-prefix-announcements