IP to ASN (Extended) Database Documentation
Overview
The IP to ASN (Extended) Database adds full routing context on top of standard ASN resolution, focusing on routes, peers, upstreams, and downstreams to model real-world topology. Built from live BGP collectors and route servers, it surfaces provider/customer relationships, peer sets, and active announcements to power peering strategy, leak/hijack detection, and path policy validation.
Designed for NetOps and security analytics, each record can include peer, upstream and downstream ASN lists, announced route prefixes, allocation status, and allocation date. If you only need basic ASN identity (IP range, AS number, organization, country, domain, and type), use the Lite dataset; this page documents the full Extended schema, including the Extended-only fields.
Available Database Formats
CSV Database Documentation
1. Overview
The CSV version is a set of Gzip-compressed CSV files containing IP ranges and their extended ASN information. Designed for bulk imports and integration into relational databases.
2. Archive Content
After downloading and extracting the IP to ASN (Extended) CSV database archive, you'll find the following files (with their types noted):
This Gzip-compressed CSV provides ASN info: number, organization, domain, type, and country.
- File Size: 17.68 MB
- Entries: 136.7K
- Fields: 14
Each start_ip–end_ip range links to an ASN details ID in db-asn-details.csv.gz.
- File Size: 233.86 MB
- Entries: 41.0M
- Fields: 3
Documentation for dataset contents, schema, usage, and support.
- File Size: 6.26 KB
SHA-256 checksums for verifying file integrity.
- File Size: 247 Bytes
Schema
This section describes the schema of each file included in the IP to ASN (Extended) Database archive. For every file, you'll find its purpose, field definitions, and examples to help with integration.
1. db-ip-asn.csv.gz
This file contains IP address ranges linked to ASN information. It maps each IP block to a unique asn_details_id, which in turn corresponds to the AS's organization, domain, type, routes, peers, upstreams, downstreams, and country.
| Field | Type | Description | Can Be Empty? | Example |
|---|---|---|---|---|
| start_ip | string | The starting IP address of the range in IPv4 or IPv6 format. | No | 192.168.0.1 |
| end_ip | string | The ending IP address of the range in IPv4 or IPv6 format. | No | 192.168.0.255 |
| asn_details_id | string | The unique identifier for the ASN Details. | No | 187 |
I. Example Records
start_ip,end_ip,asn_details_id
103.6.186.88,103.6.186.88,17501
191.215.86.233,191.215.86.233,70304
208.89.223.10,208.89.223.39,19324
2601:145:c200:3f5c:571f:945:644f:ca5d,2601:145:c200:3f5c:571f:945:644f:ca5d,67234
2.194.224.2,2.194.224.2,130025
201.132.155.130,201.132.155.130,85824
79.208.240.75,79.208.240.75,134796
180.169.104.144,180.169.105.27,17161
119.93.34.118,119.93.34.118,91089
61.227.45.1,61.227.45.1,1355482. db-asn-details.csv.gz
This file contains detailed Autonomous System Number (ASN) information. Each entry links a unique ID to an AS number, organization, domain, routes, peers, upstreams, downstreams, type, and country.
| Field | Type | Description | Can Be Empty? | Example |
|---|---|---|---|---|
| id | string | The unique identifier for the ASN details. | No | 1 |
| as_number | string | The Autonomous System Number (ASN), exported as a bare integer without the AS prefix. | No | 29355 |
| as_name | string | The name of the Autonomous System (AS). | No | |
| organization | string | The organization associated with the ASN. | No | Google LLC |
| country | string | The country where the ASN is registered. | No | US |
| type | string | The type of network associated with the ASN (e.g., ISP, BUSINESS, HOSTING, EDUCATION, GOVERNMENT). | No | BUSINESS |
| domain | string | The domain associated with the ASN. | Yes | google.com |
| allocation_status | string | The allocation status of the ASN. | Yes | ASSIGNED |
| whois_host | string | The WHOIS host for the ASN. | Yes | ARIN |
| peers | string | Comma-separated list of peer ASNs. | Yes | AS57950, AS58289, AS48502, AS9198 |
| upstreams | string | Comma-separated list of upstream ASNs. | Yes | AS9009, AS174, AS64073, AS212024 |
| downstreams | string | Comma-separated list of downstream ASNs. | Yes | AS9009, AS174, AS64073, AS212024 |
| routes | string | Comma-separated list of announced route prefixes in CIDR notation. | Yes | 164.40.102.0/24, 2.78.47.0/24, 164.0.212.0/24, 2.76.168.0/21 |
| date_allocated | string | The date when the ASN was allocated. | Yes | 1999-03-15 |
I. Example Records
id,as_number,as_name,organization,country,type,domain,allocation_status,whois_host,peers,upstreams,downstreams,routes,date_allocated
19324,62904,AS62904,Eonix Corporation,US,HOSTING,eonix.net,,ARIN,"AS36236, AS174, AS1299, AS23033","AS1299, AS174, AS23033, AS11403",,"2607:ff28::/32, 50.3.224.0/22, 50.3.139.0/24, 170.130.128.0/22",2013-11-13
17501,133720,ZESSNPL-AS-IN,Zess Networks Private Limited,IN,,irinn.in,,APNIC,"AS36236, AS150083, AS135229, AS153276","AS17762, AS18229, AS9498, AS17665","AS150083, AS135229, AS153276, AS150067","2403:3d00::/32, 139.5.25.0/24, 43.241.125.0/24, 103.25.171.0/24",2014-09-15
85824,262916,MX-MSCV17-LACNIC,"Mega Cable, S.A. de C.V.",MX,ISP,mega.mx,,lacnic,"AS174, AS13999, AS3257, AS286","AS174, AS13999, AS3257, AS286",,"200.92.129.0/24, 201.165.129.0/24, 201.132.61.0/24, 200.95.237.0/24",2010-03-17
130025,16232,ASN-TIM,Telecom Italia S.p.A.,IT,ISP,gruppotim.it,ASSIGNED,RIPE,"AS3269, AS6762",AS3269,,"62.18.0.0/15, 217.203.254.0/24, 217.203.0.0/16, 217.200.0.0/16",1970-01-01
70304,26667,RUBICONPROJECT,"Magnite, Inc.",US,BUSINESS,magnite.com,,ARIN,"AS5713, AS37721, AS265269, AS36994","AS132132, AS6204, AS3257, AS3214",,"216.109.160.0/20, 2602:803:c008::/48, 2602:803:c005::/48, 69.173.156.0/23",2007-11-08
17161,4812,CHINANET-SH-AP,China Telecom Group Corporation Shanghai Company,CN,ISP,chinatelecom.com.cn,,APNIC,"AS137746, AS63617, AS56000, AS59073","AS4134, AS4809","AS137746, AS63617, AS56000, AS59073","103.55.172.0/22, 180.168.1.0/24, 203.156.206.0/23, 103.228.228.0/24",1996-01-09
135548,3462,HINET,"Chunghwa Telecom Co., Ltd.",TW,ISP,cht.com.tw,,APNIC,"AS37721, AS36994, AS60068, AS10126","AS60068, AS132132, AS6204, AS1836","AS17716, AS36994, AS9916, AS10126","36.225.0.0/16, 36.227.0.0/16, 60.249.84.0/22, 2001:b030:a400::/38",2002-08-01
91089,9299,IPG-AS-AP,Philippine Long Distance Telephone Company,PH,ISP,main.pldt.com,,APNIC,"AS37721, AS132059, AS136777, AS149170","AS132132, AS6204, AS150000, AS1836","AS132059, AS1751, AS134996, AS136777","49.148.96.0/20, 122.52.224.0/19, 180.193.64.0/19, 112.207.96.0/19",1998-04-16
134796,3320,DTAG,Deutsche Telekom AG,DE,ISP,telekom.com,ASSIGNED,RIPE,"AS37721, AS34453, AS31186, AS12306","AS5511, AS3257, AS29222, AS5391","AS34453, AS37721, AS31186, AS12306","79.121.131.0/24, 195.143.230.0/23, 64.105.236.0/23, 195.66.83.0/24",1970-01-01
67234,7922,COMCAST-7922,"Comcast Cable Communications, LLC",US,ISP,xfinity.com,,ARIN,"AS22909, AS36236, AS395487, AS3778","AS1299, AS174, AS36498, AS3778","AS22909, AS36236, AS395487, AS60068","48.46.178.0/23, 48.47.40.0/23, 2001:55a:800::/40, 2001:558:fee0::/48",1997-02-143. File Relationship Diagram
The diagram below illustrates the relationships between the various files included in the CSV database package. It shows how the main CSV file connects to the reference table for ASN details, ensuring accurate data linkage and integrity.
File Format & Encoding
All IP to ASN (Extended) CSV datasets are provided in UTF-8 encoding, comma-separated, and compressed with Gzip (.csv.gz). Each file includes a header row listing the field names for clarity and consistency.
Field values are unquoted by default, with quotes applied only in the following cases:
- Line breaks within text fields.
- Commas inside a value.
- Lists of values.
- Spaces that may be auto-quoted by export tools.
MMDB Database Documentation
1. Overview
The MMDB version of the database consists of three files: one MMDB file containing all ASN information, a README file, and a checksum file, all compressed together in a ZIP file for easy delivery.
2. Archive Content
After downloading and extracting the IP to ASN (Extended) MMDB database archive, you'll find the following files (with their types noted):
Provides full ASN details for IP addresses: organization, domain, type, and country.
- File Size: 64.28 MB
- Entries: 41.0M
Documentation for dataset contents, schema, usage, and support.
- File Size: 4.92 KB
SHA-256 checksums for verifying file integrity.
- File Size: 157 Bytes
Response Schema
This section describes the structure of the data returned from the IP to ASN (Extended) MMDB file. Each field is detailed with its type, meaning, and example values to help you interpret responses and integrate them into your applications.
1. db-ip-asn.mmdb
This file contains Autonomous System Number (ASN) mappings for both IPv4 and IPv6 address ranges. Below is an example of the structure you will encounter in the response.
2. Field Reference
The following reference lists all fields available in the MMDB response. Each entry includes the field path, its description, data type, and example value to help you understand how to parse and integrate the data.
| Field | Type | Description | Example |
|---|---|---|---|
asn | object | ||
asn.as_number | string | The Autonomous System Number (ASN), exported as a bare integer without the AS prefix. | 29355 |
asn.as_name | string | The name of the Autonomous System (AS). | |
asn.organization | string | The organization associated with the ASN. | Google LLC |
asn.country_code | string | The country where the ASN is registered. | US |
asn.type | string | The type of network associated with the ASN (e.g., ISP, BUSINESS, HOSTING, EDUCATION, GOVERNMENT). | BUSINESS |
asn.domain | string | The domain associated with the ASN. | google.com |
asn.allocation_status | string | The allocation status of the ASN. | ASSIGNED |
asn.whois_host | string | The WHOIS host for the ASN. | ARIN |
asn.peers | string | Comma-separated list of peer ASNs. | AS57950, AS58289, AS48502, AS9198 |
asn.upstreams | string | Comma-separated list of upstream ASNs. | AS9009, AS174, AS64073, AS212024 |
asn.downstreams | string | Comma-separated list of downstream ASNs. | AS9009, AS174, AS64073, AS212024 |
asn.routes | string | Comma-separated list of announced route prefixes in CIDR notation. | 164.40.102.0/24, 2.78.47.0/24, 164.0.212.0/24, 2.76.168.0/21 |
asn.date_allocated | string | The date when the ASN was allocated. | 1999-03-15 |
I. Example Records
{
"asn": {
"allocation_status": "",
"as_name": "ZESSNPL-AS-IN",
"as_number": "133720",
"country_code": "IN",
"date_allocated": "2014-09-15",
"domain": "irinn.in",
"downstreams": "AS150083,AS135229,AS153276,AS150067",
"organization": "Zess Networks Private Limited",
"peers": "AS36236,AS150083,AS135229,AS153276",
"routes": "2403:3d00::/32,139.5.25.0/24,43.241.125.0/24,103.25.171.0/24",
"type": "",
"upstreams": "AS17762,AS18229,AS9498,AS17665",
"whois_host": "APNIC"
}
}Database Integrity & Authenticity Verification
There are two ways to verify the integrity and authenticity of our databases:
1. Using the Signature File (Recommended)
IPGeolocation.io signs every database release to ensure its authenticity and integrity. This allows customers to verify that a downloaded IP to ASN (Extended) database file originates directly from IPGeolocation.io and has not been altered, corrupted, or tampered with during transfer or storage.
Each database update includes a corresponding signature file, generated using our private signing key. Customers can validate the database using the provided public verification key. To verify a database file, you need:
- Database file (the downloaded archive)
- Signature file (the matching signature for that archive)
- Public key (public-key.pem)
These files are available via official IPGeolocation.io download endpoints and are also shared in database update notifications.
2. Using the Checksum File (Legacy)
Each database archive includes a checksum.txt file containing the SHA-256 checksums for the files packaged in the archive. You can use this file to validate that the extracted contents are complete and unchanged.
Data Format & Constraints
- All fields defined in the schema are always present in the IP to ASN (Extended) MMDB response.
- Fields may contain empty strings (""), but never null, so null checks are not required.
- Place names such as countries, states, districts, and cities are available in multiple translations.
- All text values are encoded in UTF-8.
- Field names and response structure remain stable across updates for backward compatibility.
Database Updates & Delivery
When you subscribe to our IP to ASN (Extended) database, we'll send you static download links. These links never change, so you can use them both for your initial download and for all future updates. You will receive:
- Database Archive URL: downloads the latest release of your subscribed database (CSV, MMDB or requested formats).
- Signature File URL: downloads the matching signature file for the latest release (used for authenticity verification).
- Public Key URL: downloads the public verification key (used with the signature file).
- Status Endpoint URL: returns the database's most recent update timestamp.
Our databases are updated continuously and shipped on a daily or weekly cycle depending on your plan. Each time your subscribed dataset is updated, you'll also receive an email notification so you don't miss a release.
For automated workflows, you can check our status endpoint to see the last update timestamp. When the date changes, simply re-fetch the archive using your static download URL to pull the latest version into your system.