IP WHOIS Database
Overview
Our IP WHOIS Database delivers clean, consistently parsed ownership data for any IPv4/IPv6 range, so you can verify who controls an address block, identify the right contacts, and act with confidence. Use it to harden security, speed up network troubleshooting, validate IP ownership during onboarding or investigations, and enrich tooling with reliable WHOIS insights across the global internet.
Raw WHOIS text is preserved for auditability. Available as CSV and MMDB, with JSON, Parquet, or any custom format on request at no extra cost, backed by stable schemas and changelogs. Below, you'll find full documentation of the archive contents, schema definitions, file specifications, and integration notes to help you get up and running quickly.
Available Database Formats
CSV Database Documentation
1. Overview
The CSV version is a set of Gzip-compressed CSV files containing IP ranges and detailed IP WHOIS information. These files are designed for bulk imports and integration into relational databases.
2. Archive Content
After downloading and extracting the IP WHOIS CSV database archive, you'll find the following files (with their types noted):
IP range links to WHOIS details: name, country, domain, RIR, and raw WHOIS record.
- File Size: 1.13 GB
- Entries: 11.2M
- Fields: 14
Links an organization ID to its handle, name, type, and contact details.
- File Size: 93.02 MB
- Entries: 2.7M
- Fields: 11
Links the network handle ID to its name, country, address, and contact details.
- File Size: 3.81 MB
- Entries: 104.6K
- Fields: 10
Documentation for dataset contents, schema, usage, and support.
- File Size: 7.97 KB
- File Size: 213 Bytes
Schema
This section describes the schema of each file included in the IP WHOIS Database archive. For every file, you'll find its purpose, field definitions, and examples to help with integration.
1. db-ip-whois.csv.gz
This file contains detailed WHOIS information for IP address ranges. It maps each IP block to the name, country, domain, and RIR, as well as various contact handle IDs and the full raw_whois record.
| 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 |
| name | string | The name associated with the IP range in the WHOIS record. | Yes | Example Network |
| country | string | The country code associated with the IP range in the WHOIS record. | Yes | US |
| domain | string | The domain name associated with the IP range in the WHOIS record. | Yes | example.com |
| rir | string | The Regional Internet Registry (RIR) that manages the IP range. | Yes | ARIN |
| org_id | number | The unique identifier for the organization associated with the IP range. | Yes | 1 |
| admin_handles_id | number | The unique identifier for the administrative contact handle associated with the IP range. | Yes | 1 |
| tech_handles_id | number | The unique identifier for the technical contact handle associated with the IP range. | Yes | 1 |
| abuse_handles_id | number | The unique identifier for the abuse contact handle associated with the IP range. | Yes | 1 |
| irt_handles_id | number | The unique identifier for the Incident Response Team (IRT) contact handle associated, with the IP range. | Yes | 1 |
| raw_whois | string | The raw WHOIS record data associated with the IP range. | Yes | Raw WHOIS data string... |
| date_created | string | The date when the WHOIS record for the IP range was created. | Yes | 2020-01-01T12:00:00 |
| date_updated | string | The date when the WHOIS record for the IP range was last updated. | Yes | 2023-01-15T12:00:00 |
I. Example Records
start_ip,end_ip,name,country,domain,rir,org_id,admin_handles_id,tech_handles_id,abuse_handles_id,irt_handles_id,raw_whois,date_created,date_updated
2.112.86.44,2.112.86.47,MOVIDAVIAGGIVACANZESRL,IT,business.telecomitalia.it,ripencc,null,1,1,,,"% This is the RIPE Database query service.
% The objects are in RPSL format.
%
% The RIPE Database is subject to Terms and Conditions.
% See https://docs.db.ripe.net/terms-conditions.html
% Note: this output has been filtered.
% To receive output for a database update, use the -B flag.
% Information related to '2.112.86.44 - 2.112.86.47'
% Abuse contact for '2.112.86.44 - 2.112.86.47' is 'abuse@business.telecomitalia.it'
inetnum: 2.112.86.44 - 2.112.86.47
netname: MOVIDAVIAGGIVACANZESRL
descr: MOVIDA VIAGGI VACANZE S.R.L.
country: IT
admin-c: DM20033-RIPE
tech-c: DM20033-RIPE
status: ASSIGNED PA
mnt-by: INTERB-MNT
created: 2024-03-13T14:58:00Z
last-modified: 2024-03-13T14:58:00Z
source: RIPE # Filtered
person: DAVIDE MENSALI
address: MOVIDA VIAGGI VACANZE S.R.L.
address: VIA DALMAZIA 7
address: 31044 MONTEBELLUNA
address: Italy
nic-hdl: DM20033-RIPE
phone: +39423293401
fax-no: +39423293401
mnt-by: INTERB-MNT
created: 2024-03-13T14:58:00Z
last-modified: 2024-03-13T14:58:00Z
source: RIPE
% Information related to '2.112.0.0/15AS3269'
route: 2.112.0.0/15
descr: INTERBUSINESS
origin: AS3269
remarks: ************************************************
remarks: * Pay attention *
remarks: * Any communication sent to email different *
remarks: * from the following will be ignored! *
remarks: * Any abuse reports, please send them to *
remarks: * abuse@business.telecomitalia.it *
remarks: ************************************************
mnt-by: INTERB-MNT
created: 2010-04-30T09:24:32Z
last-modified: 2017-07-17T12:18:11Z
source: RIPE # Filtered
% This query was served by the RIPE Database Query Service version 1.123 (BUSA)
",2024-03-13T14:58:00,2024-03-13T14:58:00
2.112.90.104,2.112.90.111,AUTOTRASPORTIFLLIFRANCHINDIANGELOMAURIZIOCSNC,IT,business.telecomitalia.it,ripencc,null,2,3,,,"% This is the RIPE Database query service.
% The objects are in RPSL format.
%
% The RIPE Database is subject to Terms and Conditions.
% See https://docs.db.ripe.net/terms-conditions.html
% Note: this output has been filtered.
% To receive output for a database update, use the -B flag.
% Information related to '2.112.90.104 - 2.112.90.111'
% Abuse contact for '2.112.90.104 - 2.112.90.111' is 'abuse@business.telecomitalia.it'
inetnum: 2.112.90.104 - 2.112.90.111
netname: AUTOTRASPORTIFLLIFRANCHINDIANGELOMAURIZIOCSNC
descr: AUTOTRASPORTI F LLI FRANCHIN DI ANGELO MAURIZIO C SNC
country: IT
admin-c: EF2780-RIPE
tech-c: EF2781-RIPE
status: ASSIGNED PA
mnt-by: INTERB-MNT
created: 2010-09-29T12:08:59Z
last-modified: 2020-04-09T14:51:50Z
source: RIPE # Filtered
person: EDUARDO FRANCHIN
address: AUTOTRASPORTI F LLI FRANCHIN DI ANGELO MAURIZIO C SNC
address: VIA DOSSI 5
address: 35045 OSPEDALETTO EUGANEO
address: Italy
phone: +39357548348
fax-no: +39429679075
nic-hdl: EF2780-RIPE
created: 2010-09-29T12:08:59Z
last-modified: 2020-06-03T15:53:44Z
source: RIPE
mnt-by: INTERB-MNT
person: EDUARDO FRANCHIN
address: AUTOTRASPORTI F LLI FRANCHIN DI ANGELO MAURIZIO C SNC
address: VIA DOSSI 5
address: 35045 OSPEDALETTO EUGANEO
address: Italy
phone: +39357548348
fax-no: +39429679075
nic-hdl: EF2781-RIPE
created: 2010-09-29T12:08:59Z
last-modified: 2020-06-04T02:00:41Z
source: RIPE
mnt-by: INTERB-MNT
% Information related to '2.112.0.0/15AS3269'
route: 2.112.0.0/15
descr: INTERBUSINESS
origin: AS3269
remarks: ************************************************
remarks: * Pay attention *
remarks: * Any communication sent to email different *
remarks: * from the following will be ignored! *
remarks: * Any abuse reports, please send them to *
remarks: * abuse@business.telecomitalia.it *
remarks: ************************************************
mnt-by: INTERB-MNT
created: 2010-04-30T09:24:32Z
last-modified: 2017-07-17T12:18:11Z
source: RIPE # Filtered
% This query was served by the RIPE Database Query Service version 1.123 (BUSA)
",2010-09-29T12:08:59,2020-04-09T14:51:50
2.113.225.84,2.113.225.87,ORTHOHOSPITALSRL,IT,business.telecomitalia.it,ripencc,null,4,4,,,"% This is the RIPE Database query service.
% The objects are in RPSL format.
%
% The RIPE Database is subject to Terms and Conditions.
% See https://docs.db.ripe.net/terms-conditions.html
% Note: this output has been filtered.
% To receive output for a database update, use the -B flag.
% Information related to '2.113.225.84 - 2.113.225.87'
% Abuse contact for '2.113.225.84 - 2.113.225.87' is 'abuse@business.telecomitalia.it'
inetnum: 2.113.225.84 - 2.113.225.87
netname: ORTHOHOSPITALSRL
descr: ORTHO HOSPITAL S.R.L.
country: IT
admin-c: MP36106-RIPE
tech-c: MP36106-RIPE
status: ASSIGNED PA
mnt-by: INTERB-MNT
created: 2021-04-22T17:23:40Z
last-modified: 2021-04-22T17:23:40Z
source: RIPE # Filtered
person: MARZIA PRUDEL
address: ORTHO HOSPITAL S.R.L.
address: VIALE VERONA 190/1
address: 38123 TRENTO
address: Italy
nic-hdl: MP36106-RIPE
phone: +39461932590
fax-no: +39461932590
mnt-by: INTERB-MNT
created: 2021-04-22T17:23:39Z
last-modified: 2021-04-22T17:23:39Z
source: RIPE
% Information related to '2.112.0.0/15AS3269'
route: 2.112.0.0/15
descr: INTERBUSINESS
origin: AS3269
remarks: ************************************************
remarks: * Pay attention *
remarks: * Any communication sent to email different *
remarks: * from the following will be ignored! *
remarks: * Any abuse reports, please send them to *
remarks: * abuse@business.telecomitalia.it *
remarks: ************************************************
mnt-by: INTERB-MNT
created: 2010-04-30T09:24:32Z
last-modified: 2017-07-17T12:18:11Z
source: RIPE # Filtered
% This query was served by the RIPE Database Query Service version 1.123 (BUSA)
",2021-04-22T17:23:40,2021-04-22T17:23:40
2.116.180.40,2.116.180.43,PRATAVIERAGIANFRANCO,IT,business.telecomitalia.it,ripencc,null,5,5,,,"% This is the RIPE Database query service.
% The objects are in RPSL format.
%
% The RIPE Database is subject to Terms and Conditions.
% See https://docs.db.ripe.net/terms-conditions.html
% Note: this output has been filtered.
% To receive output for a database update, use the -B flag.
% Information related to '2.116.180.40 - 2.116.180.43'
% Abuse contact for '2.116.180.40 - 2.116.180.43' is 'abuse@business.telecomitalia.it'
inetnum: 2.116.180.40 - 2.116.180.43
netname: PRATAVIERAGIANFRANCO
descr: PRATAVIERA GIANFRANCO
country: IT
admin-c: GP23849-RIPE
tech-c: GP23849-RIPE
status: ASSIGNED PA
mnt-by: INTERB-MNT
created: 2025-06-25T07:19:05Z
last-modified: 2025-06-25T07:19:05Z
source: RIPE # Filtered
person: GIANFRANCO PRATAVIERA
address: PRATAVIERA GIANFRANCO
address: CORSO DEL SOLE 175
address: 30020 SAN MICHELE AL TAGLIAMENTO
address: Italy
nic-hdl: GP23849-RIPE
phone: +3943143284
fax-no: +3943143284
mnt-by: INTERB-MNT
created: 2025-06-25T07:19:05Z
last-modified: 2025-06-25T07:19:05Z
source: RIPE
% This query was served by the RIPE Database Query Service version 1.123 (DEXTER)
",2025-06-25T07:19:05,2025-06-25T07:19:05
2.118.71.16,2.118.71.19,AMANZONICSPA,IT,business.telecomitalia.it,ripencc,null,6,6,,,"% This is the RIPE Database query service.
% The objects are in RPSL format.
%
% The RIPE Database is subject to Terms and Conditions.
% See https://docs.db.ripe.net/terms-conditions.html
% Note: this output has been filtered.
% To receive output for a database update, use the -B flag.
% Information related to '2.118.71.16 - 2.118.71.19'
% Abuse contact for '2.118.71.16 - 2.118.71.19' is 'abuse@business.telecomitalia.it'
inetnum: 2.118.71.16 - 2.118.71.19
netname: AMANZONICSPA
descr: A. MANZONI & C. SPA
country: IT
admin-c: MB52468-RIPE
tech-c: MB52468-RIPE
status: ASSIGNED PA
mnt-by: INTERB-MNT
created: 2021-10-06T05:35:10Z
last-modified: 2021-10-06T05:35:10Z
source: RIPE # Filtered
person: MASSIMILIANO BOCCHETTA
address: A. MANZONI & C. SPA
address: VIALE NERVESA 11
address: 20100 MILANO
address: Italy
nic-hdl: MB52468-RIPE
phone: +39257494672
fax-no: +39257494672
mnt-by: INTERB-MNT
created: 2021-10-06T05:35:10Z
last-modified: 2021-10-06T05:35:10Z
source: RIPE
% Information related to '2.118.0.0/15AS3269'
route: 2.118.0.0/15
descr: INTERBUSINESS
origin: AS3269
remarks: ************************************************
remarks: * Pay attention *
remarks: * Any communication sent to email different *
remarks: * from the following will be ignored! *
remarks: * Any abuse reports, please send them to *
remarks: * abuse@business.telecomitalia.it *
remarks: ************************************************
mnt-by: INTERB-MNT
created: 2010-08-05T08:21:53Z
last-modified: 2017-07-17T12:18:58Z
source: RIPE # Filtered
% This query was served by the RIPE Database Query Service version 1.123 (ABERDEEN)
",2021-10-06T05:35:10,2021-10-06T05:35:10
2.232.45.0,2.232.45.255,FASTWEB-L3-PAT_NAT,IT,fastweb.it,ripencc,null,7,7,,,"% This is the RIPE Database query service.
% The objects are in RPSL format.
%
% The RIPE Database is subject to Terms and Conditions.
% See https://docs.db.ripe.net/terms-conditions.html
% Note: this output has been filtered.
% To receive output for a database update, use the -B flag.
% Information related to '2.232.45.0 - 2.232.45.255'
% Abuse contact for '2.232.45.0 - 2.232.45.255' is 'abuse@fastweb.it'
inetnum: 2.232.45.0 - 2.232.45.255
netname: FASTWEB-L3-PAT_NAT
descr: PAT/NAT IP addresses POP 3901 for
descr: Static allocation to Residential/SoHo customer with L3 devices
country: IT
admin-c: IRS2-RIPE
tech-c: IRS2-RIPE
status: ASSIGNED PA
mnt-by: FASTWEB-MNT
remarks: In case of improper use originating from our network,
remarks: please mail customer or abuse@fastweb.it
remarks: INFRA-AW
created: 2011-11-22T07:00:31Z
last-modified: 2011-11-22T07:00:31Z
source: RIPE
person: ip registration service
address: Via Caracciolo, 51
address: 20155 Milano MI
address: Italy
phone: +39 02 45451
fax-no: +39 02 45451
nic-hdl: IRS2-RIPE
mnt-by: FASTWEB-MNT
remarks:
remarks: In case of improper use originating from our network,
remarks: please mail customer or abuse@fastweb.it
remarks:
created: 2001-12-18T12:06:41Z
last-modified: 2008-02-29T14:09:58Z
source: RIPE # Filtered
% Information related to '2.232.0.0/17AS12874'
route: 2.232.0.0/17
descr: Fastweb Networks block
origin: AS12874
remarks:
remarks: In case of improper use originating from our network,
remarks: please mail customer or abuse@fastweb.it
mnt-by: FASTWEB-MNT
created: 2018-02-12T10:02:36Z
last-modified: 2018-02-12T10:02:36Z
source: RIPE
% This query was served by the RIPE Database Query Service version 1.123 (DEXTER)
",2011-11-22T07:00:31,2011-11-22T07:00:31
5.97.98.232,5.97.98.239,MARCHEMULTISFALCONARASRL,IT,business.telecomitalia.it,ripencc,null,8,8,,,"% This is the RIPE Database query service.
% The objects are in RPSL format.
%
% The RIPE Database is subject to Terms and Conditions.
% See https://docs.db.ripe.net/terms-conditions.html
% Note: this output has been filtered.
% To receive output for a database update, use the -B flag.
% Information related to '5.97.98.232 - 5.97.98.239'
% Abuse contact for '5.97.98.232 - 5.97.98.239' is 'abuse@business.telecomitalia.it'
inetnum: 5.97.98.232 - 5.97.98.239
netname: MARCHEMULTISFALCONARASRL
descr: MARCHE MULTIS. FALCONARA S.R.L.
country: IT
admin-c: MP39534-RIPE
tech-c: MP39534-RIPE
status: ASSIGNED PA
mnt-by: INTERB-MNT
created: 2024-08-13T10:49:04Z
last-modified: 2024-08-13T10:49:04Z
source: RIPE # Filtered
person: MAURO PIRAZZOLI
address: MARCHE MULTIS. FALCONARA S.R.L.
address: VIA MARCONI 14E
address: 60020 FALCONARA MARITTIMA
address: Italy
nic-hdl: MP39534-RIPE
phone: +3959332211
fax-no: +3959332211
mnt-by: INTERB-MNT
created: 2024-08-13T10:49:04Z
last-modified: 2024-08-13T10:49:04Z
source: RIPE
% Information related to '5.96.0.0/15AS3269'
route: 5.96.0.0/15
descr: INTERBUSINESS
origin: AS3269
remarks: ************************************************
remarks: * Pay attention *
remarks: * Any communication sent to email different *
remarks: * from the following will be ignored! *
remarks: * Any abuse reports, please send them to *
remarks: * abuse@business.telecomitalia.it *
remarks: ************************************************
mnt-by: INTERB-MNT
created: 2012-06-20T09:30:01Z
last-modified: 2017-07-17T12:19:18Z
source: RIPE # Filtered
% This query was served by the RIPE Database Query Service version 1.123 (SHETLAND)
",2024-08-13T10:49:04,2024-08-13T10:49:04
5.133.198.100,5.133.198.103,FI-ETTNET-20200729,FI,internetvikings.com,ripencc,1,9,9,,,"% This is the RIPE Database query service.
% The objects are in RPSL format.
%
% The RIPE Database is subject to Terms and Conditions.
% See https://docs.db.ripe.net/terms-conditions.html
% Note: this output has been filtered.
% To receive output for a database update, use the -B flag.
% Information related to '5.133.198.100 - 5.133.198.103'
% Abuse contact for '5.133.198.100 - 5.133.198.103' is 'abuse@internetvikings.com'
inetnum: 5.133.198.100 - 5.133.198.103
netname: FI-ETTNET-20200729
country: FI
org: ORG-EA45-RIPE
admin-c: FB9451-RIPE
tech-c: FB9451-RIPE
status: ASSIGNED PA
mnt-by: ETTNET-LIR
created: 2020-07-29T08:12:10Z
last-modified: 2020-07-29T08:12:10Z
source: RIPE
organisation: ORG-EA45-RIPE
org-name: Internet Vikings International AB
country: SE
reg-nr: 556545-8907
org-type: LIR
address: Roslagsgatan 26 A
address: 11355
address: Stockholm
address: SWEDEN
phone: +4684414499
fax-no: +4684414498
abuse-c: AR17147-RIPE
mnt-ref: ETTNET-LIR
mnt-ref: RIPE-NCC-HM-MNT
mnt-by: RIPE-NCC-HM-MNT
mnt-by: ETTNET-LIR
created: 2004-04-17T12:03:12Z
last-modified: 2026-05-13T07:21:10Z
source: RIPE # Filtered
admin-c: FB9451-RIPE
person: Fredik Berglund
address: Internetbolaget Sweden AB
address: Birkagatan 28
address: SE 100 31 Stockholm
address: SWEDEN
phone: +46 8 4414499
fax-no: +46 8 4414498
nic-hdl: FB9451-RIPE
mnt-by: ETTNET-LIR
created: 2011-04-12T09:21:26Z
last-modified: 2011-04-12T09:21:26Z
source: RIPE # Filtered
% Information related to '5.133.192.0/19AS51747'
route: 5.133.192.0/19
origin: AS51747
mnt-by: ETTNET-LIR
created: 2020-07-15T15:36:08Z
last-modified: 2020-07-15T15:36:08Z
source: RIPE
% This query was served by the RIPE Database Query Service version 1.123 (DEXTER)
",2020-07-29T08:12:10,2020-07-29T08:12:10
5.134.118.226,5.134.118.226,GINERNET,ES,ginernet.com,ripencc,null,10,10,,,"% This is the RIPE Database query service.
% The objects are in RPSL format.
%
% The RIPE Database is subject to Terms and Conditions.
% See https://docs.db.ripe.net/terms-conditions.html
% Note: this output has been filtered.
% To receive output for a database update, use the -B flag.
% Information related to '5.134.118.226 - 5.134.118.226'
% Abuse contact for '5.134.118.226 - 5.134.118.226' is 'abuse@ginernet.com'
inetnum: 5.134.118.226 - 5.134.118.226
netname: GINERNET
descr: GINERNET
country: ES
admin-c: GNR
tech-c: GNR
status: ASSIGNED PA
mnt-by: GINERNET-MNT
created: 2022-10-13T21:25:39Z
last-modified: 2022-10-13T21:25:39Z
source: RIPE
role: GINERNET
remarks: ------------------------
remarks: https://ginernet.com
remarks: ------------------------
address: Albasanz 71
address: 28037
address: Madrid
address: SPAIN
abuse-mailbox: abuse@ginernet.com
phone: +34.965064386
nic-hdl: GNR
admin-c: GNR-RIPE
mnt-by: GINERNET-MNT
created: 2017-12-27T17:49:43Z
last-modified: 2026-01-30T14:45:27Z
source: RIPE # Filtered
% Information related to '5.134.118.0/24AS59432'
route: 5.134.118.0/24
descr: GINERNET
origin: AS59432
mnt-by: GINERNET-MNT
created: 2020-02-24T13:14:59Z
last-modified: 2020-02-24T13:14:59Z
source: RIPE
% This query was served by the RIPE Database Query Service version 1.123 (SHETLAND)
",2022-10-13T21:25:39,2022-10-13T21:25:39
5.135.78.64,5.135.78.95,OVH_503280295,FR,haruko.io,ripencc,2,11,11,,,"% This is the RIPE Database query service.
% The objects are in RPSL format.
%
% The RIPE Database is subject to Terms and Conditions.
% See https://docs.db.ripe.net/terms-conditions.html
% Note: this output has been filtered.
% To receive output for a database update, use the -B flag.
% Information related to '5.135.78.64 - 5.135.78.95'
% Abuse contact for '5.135.78.64 - 5.135.78.95' is 'adam@haruko.io'
inetnum: 5.135.78.64 - 5.135.78.95
netname: OVH_503280295
country: FR
descr: Failover Ips
org: ORG-CA2663-RIPE
admin-c: OTC2-RIPE
tech-c: OTC2-RIPE
status: ASSIGNED PA
mnt-by: OVH-MNT
created: 2026-05-26T13:38:51Z
last-modified: 2026-05-26T13:38:51Z
source: RIPE
organisation: ORG-CA2663-RIPE
org-name: Carlile Adam
org-type: OTHER
address: 40 Leadenhall Street
address: EC3A 2AA London
address: GB
phone: +44.7540844697
abuse-c: ACRO63405-RIPE
mnt-ref: OVH-MNT
mnt-by: OVH-MNT
created: 2025-03-24T12:24:12Z
last-modified: 2026-02-03T17:13:13Z
source: RIPE # Filtered
role: OVH Technical Contact
address: OVH SAS
address: 2 rue Kellermann
address: 59100 Roubaix
address: France
admin-c: OK217-RIPE
tech-c: GM84-RIPE
tech-c: SL10162-RIPE
nic-hdl: OTC2-RIPE
abuse-mailbox: abuse@ovh.net
mnt-by: OVH-MNT
created: 2004-01-28T17:42:29Z
last-modified: 2014-09-05T10:47:15Z
source: RIPE # Filtered
% Information related to '5.135.0.0/16AS16276'
route: 5.135.0.0/16
descr: OVH
origin: AS16276
mnt-by: OVH-MNT
created: 2012-07-06T13:00:08Z
last-modified: 2012-07-06T13:00:08Z
source: RIPE # Filtered
% This query was served by the RIPE Database Query Service version 1.123 (ABERDEEN)
",2026-05-26T13:38:51,2026-05-26T13:38:512. db-handles-details.csv.gz
This file contains detailed information on various network handles. It links a unique ID to a specific handle, name, country, address, and contact details such as email, phone, and fax.
| Field | Type | Description | Can be empty? | Example |
|---|---|---|---|---|
| id | number | The unique identifier for the WHOIS handle. | No | 1 |
| handle | string | The WHOIS handle. | No | EXAMPLE-HANDLE |
| name | string | The name associated with the WHOIS handle. | No | John Doe |
| country | string | The country associated with the WHOIS handle. | Yes | US |
| string | The email address associated with the WHOIS handle. | Yes | contact@example.org | |
| phone | string | The phone number associated with the WHOIS handle. | Yes | +1-800-555-0123 |
| fax | string | The fax number associated with the WHOIS handle. | Yes | +1-800-555-0456 |
| address | string | The physical address associated with the WHOIS handle. | Yes | 123 Example St, Example City, EX 12345, Country |
| date_updated | string | The date when the WHOIS handle information was last updated. | Yes | 2023-01-15T12:00:00 |
| source | string | The source of the WHOIS handle information. | Yes | ARIN |
I. Example Records
id,handle,name,country,email,phone,fax,address,date_updated,source
6,mb52468-ripe,MASSIMILIANO BOCCHETTA,,,+39257494672,+39257494672,"A. MANZONI & C. SPA, VIALE NERVESA 11, 20100 MILANO, Italy",2021-10-06T05:35:10,RIPE
2,ef2780-ripe,EDUARDO FRANCHIN,,,+39357548348,+39429679075,"AUTOTRASPORTI F LLI FRANCHIN DI ANGELO MAURIZIO C SNC, VIA DOSSI 5, 35045 OSPEDALETTO EUGANEO, Italy",2020-06-03T15:53:44,RIPE
10,gnr,GINERNET,,abuse@ginernet.com,+34.965064386,,"Albasanz 71, 28037, Madrid, SPAIN",2026-01-30T14:45:27,RIPE
4,mp36106-ripe,MARZIA PRUDEL,,,+39461932590,+39461932590,"ORTHO HOSPITAL S.R.L., VIALE VERONA 190/1, 38123 TRENTO, Italy",2021-04-22T17:23:39,RIPE
5,gp23849-ripe,GIANFRANCO PRATAVIERA,,,+3943143284,+3943143284,"PRATAVIERA GIANFRANCO, CORSO DEL SOLE 175, 30020 SAN MICHELE AL TAGLIAMENTO, Italy",2025-06-25T07:19:05,RIPE
9,fb9451-ripe,Fredik Berglund,,,+46 8 4414499,+46 8 4414498,"Internetbolaget Sweden AB, Birkagatan 28, SE 100 31 Stockholm, SWEDEN",2011-04-12T09:21:26,RIPE
3,ef2781-ripe,EDUARDO FRANCHIN,,,+39357548348,+39429679075,"AUTOTRASPORTI F LLI FRANCHIN DI ANGELO MAURIZIO C SNC, VIA DOSSI 5, 35045 OSPEDALETTO EUGANEO, Italy",2020-06-04T02:00:41,RIPE
8,mp39534-ripe,MAURO PIRAZZOLI,,,+3959332211,+3959332211,"MARCHE MULTIS. FALCONARA S.R.L., VIA MARCONI 14E, 60020 FALCONARA MARITTIMA, Italy",2024-08-13T10:49:04,RIPE
11,otc2-ripe,OVH Technical Contact,,abuse@ovh.net,,,"OVH SAS, 2 rue Kellermann, 59100 Roubaix, France",2014-09-05T10:47:15,RIPE
7,irs2-ripe,ip registration service,,,+39 02 45451,+39 02 45451,"Via Caracciolo, 51, 20155 Milano MI, Italy",2008-02-29T14:09:58,RIPE
1,dm20033-ripe,DAVIDE MENSALI,,,+39423293401,+39423293401,"MOVIDA VIAGGI VACANZE S.R.L., VIA DALMAZIA 7, 31044 MONTEBELLUNA, Italy",2024-03-13T14:58,RIPE3. db-org-details.csv.gz
This file provides detailed organization information. It links a unique ID to an organization's handle, name, type, address, country, and various contact details including email, phone, and fax.
| Field | Type | Description | Can be empty? | Example |
|---|---|---|---|---|
| id | number | The unique identifier for the WHOIS organization. | No | 1 |
| handle | string | The handle of the WHOIS organization. | Yes | EXAMPLE-ORG |
| name | string | The name of the WHOIS organization. | No | Example Organization |
| type | string | The type of the WHOIS organization. | Yes | organization |
| address | string | The address of the WHOIS organization. | Yes | 123 Example St, Example City, EX 12345, Country |
| country | string | The country of the WHOIS organization. | Yes | US |
| string | The email address of the WHOIS organization. | Yes | contact@example.org | |
| phone | string | The phone number of the WHOIS organization. | Yes | +1-800-555-0123 |
| fax | string | The fax number of the WHOIS organization. | Yes | +1-800-555-0456 |
| date_updated | string | The date when the WHOIS organization information was last updated. | Yes | 2023-01-15T12:00:00 |
| source | string | The source of the WHOIS organization information. | Yes | ARIN |
I. Example Records
id,handle,name,type,address,country,email,phone,fax,date_updated,source
2,org-ca2663-ripe,Carlile Adam,other,"40 Leadenhall Street, EC3A 2AA London, GB",,,+44.7540844697,,2026-02-03T17:13:13,ripencc
1,org-ea45-ripe,Internet Vikings International AB,lir,"Roslagsgatan 26 A, 11355, Stockholm, SWEDEN, Sweden",SE,,+4684414499,+4684414498,2026-05-13T07:21:10,ripencc4. 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 reference tables for person and organization handle files, ensuring consistent and accurate data across for all the records.
File Format & Encoding
All IP WHOIS 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 (e.g., addresses).
- Lists of values (e.g., languages).
- Spaces that may be auto-quoted by export tools.
MMDB Database Documentation
1. Overview
MMDB version of the database consists of two files: one MMDB file containing all the data (organization and contact handle details), a README file, and a checksum file, and one checksum file, all compressed together in a ZIP file for easy delivery.
2. Archive Content
After downloading and extracting the IP WHOIS MMDB database archive, you'll find the following files (with their types noted):
Full WHOIS details for IP addresses: name, country, domain, RIR, contact IDs, and raw WHOIS record.
- File Size: 22.00 MB
- Entries: 11.2M
Documentation for dataset contents, schema, usage, and support.
- File Size: 7.97 KB
- File Size: 95 Bytes
Response Schema
This section describes the structure of the data returned from the IP WHOIS 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-whois.mmdb
This file contains detailed WHOIS mappings for both IPv4 and IPv6 address ranges. Below is an example of the structure you'll find 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.
I. Example Records
{
"whois": {
"abuse_handles": [],
"admin_handles": [
{
"address": "MOVIDA VIAGGI VACANZE S.R.L., VIA DALMAZIA 7, 31044 MONTEBELLUNA, Italy",
"country": "",
"date_updated": "2024-03-13T14:58",
"email": "",
"fax": "+39423293401",
"handle": "dm20033-ripe",
"name": "DAVIDE MENSALI",
"phone": "+39423293401",
"source": "RIPE"
}
],
"country": "IT",
"date_created": "2024-03-13T14:58:00",
"date_updated": "2024-03-13T14:58:00",
"domain": "business.telecomitalia.it",
"irt_handles": [],
"name": "MOVIDAVIAGGIVACANZESRL",
"organization": {},
"raw_whois": "% This is the RIPE Database query service.\n% The objects are in RPSL format.\n%\n% The RIPE Database is subject to Terms and Conditions.\n% See https://docs.db.ripe.net/terms-conditions.html\n\n% Note: this output has been filtered.\n% To receive output for a database update, use the -B flag.\n\n% Information related to '2.112.86.44 - 2.112.86.47'\n\n% Abuse contact for '2.112.86.44 - 2.112.86.47' is 'abuse@business.telecomitalia.it'\n\ninetnum: 2.112.86.44 - 2.112.86.47\nnetname: MOVIDAVIAGGIVACANZESRL\ndescr: MOVIDA VIAGGI VACANZE S.R.L.\ncountry: IT\nadmin-c: DM20033-RIPE\ntech-c: DM20033-RIPE\nstatus: ASSIGNED PA\nmnt-by: INTERB-MNT\ncreated: 2024-03-13T14:58:00Z\nlast-modified: 2024-03-13T14:58:00Z\nsource: RIPE # Filtered\n\nperson: DAVIDE MENSALI\naddress: MOVIDA VIAGGI VACANZE S.R.L.\naddress: VIA DALMAZIA 7\naddress: 31044 MONTEBELLUNA\naddress: Italy\nnic-hdl: DM20033-RIPE\nphone: +39423293401\nfax-no: +39423293401\nmnt-by: INTERB-MNT\ncreated: 2024-03-13T14:58:00Z\nlast-modified: 2024-03-13T14:58:00Z\nsource: RIPE\n\n% Information related to '2.112.0.0/15AS3269'\n\nroute: 2.112.0.0/15\ndescr: INTERBUSINESS\norigin: AS3269\nremarks: ************************************************\nremarks: * Pay attention *\nremarks: * Any communication sent to email different *\nremarks: * from the following will be ignored! *\nremarks: * Any abuse reports, please send them to *\nremarks: * abuse@business.telecomitalia.it *\nremarks: ************************************************\nmnt-by: INTERB-MNT\ncreated: 2010-04-30T09:24:32Z\nlast-modified: 2017-07-17T12:18:11Z\nsource: RIPE # Filtered\n\n% This query was served by the RIPE Database Query Service version 1.123 (BUSA)\n\n",
"rir": "ripencc",
"tech_handles": [
{
"address": "MOVIDA VIAGGI VACANZE S.R.L., VIA DALMAZIA 7, 31044 MONTEBELLUNA, Italy",
"country": "",
"date_updated": "2024-03-13T14:58",
"email": "",
"fax": "+39423293401",
"handle": "dm20033-ripe",
"name": "DAVIDE MENSALI",
"phone": "+39423293401",
"source": "RIPE"
}
]
}
}Database Integrity & Authenticity Verification
There are two methods of verifying the integrity and authenticity of our Database:
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 WHOIS 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 WHOIS 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 WHOIS 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, ensuring you always have access to the most current data. 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.