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 in CSV, JSON and MMDB formats. 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

File Size: 1.22 GB

Entries: 11.2M

Fields: 55

Last Updated: Yesterday

Documentation

MMDB

File Size: 22.00 MB

Entries: 11.2M

Fields: 55

Last Updated: Yesterday

Documentation

Important

If you require our IP Whois Database in a different format, such as Parquet or any custom structure, please feel free to reach out to us via our contact form. We are happy to accommodate specific format requests to meet your needs.

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):

db-ip-whois.csv.gz

IP range links to WHOIS details: name, country, domain, RIR, and raw WHOIS record.

File Size: 1.13 GB

Entries: 11.2M

Fields: 14

db-org-details.csv.gz

Links an organization ID to its handle, name, type, and contact details.

File Size: 93.02 MB

Entries: 2.7M

Fields: 11

db-handles-details.csv.gz

Links the network handle ID to its name, country, address, and contact details.

File Size: 3.81 MB

Entries: 104.6K

Fields: 10

README.md

Documentation for dataset contents, schema, usage, and support.

File Size: 7.97 KB

db-ip-whois.md5

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:00Z
date_updated	string	The date when the WHOIS record for the IP range was last updated.	Yes	2023-01-15T12:00:00Z

Tip

org_id joins to db-org-details.id to get organization details for IP, and *handles_id keys join to db-handles-details.id to get contact handles details.

I.Example Records

Example

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.109.83.52,2.109.83.55,TDC-CUSTOMER-NET,DK,abuse.mail.dk,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.109.83.52 - 2.109.83.55'

% Abuse contact for '2.109.83.52 - 2.109.83.55' is 'postmaster@abuse.mail.dk'

inetnum:        2.109.83.52 - 2.109.83.55
netname:        TDC-CUSTOMER-NET
descr:          TDC IP Customers
country:        DK
remarks:        +---------------------------------------+
remarks:        | For abuse and security issues please  |
remarks:        | see http://postmaster.tdc.dk or       |
remarks:        | contact postmaster@abuse.mail.dk      |
remarks:        +---------------------------------------+
admin-c:        AS5071-RIPE
tech-c:         AS5071-RIPE
status:         ASSIGNED PA
mnt-by:         TDK-MNT
created:        2025-11-18T12:07:12Z
last-modified:  2025-11-18T12:07:12Z
source:         RIPE

role:           AS3292 Staff
address:        TDC A/S
address:        Sletvej 30, 8-062
address:        DK-8310 Tranbjerg
address:        Denmark
remarks:        contact info: http://as3292.peeringdb.com
admin-c:        NCB1-RIPE
admin-c:        MBP137-RIPE
tech-c:         NCB1-RIPE
tech-c:         CP11490-RIPE
tech-c:         MBP137-RIPE
nic-hdl:        AS5071-RIPE
mnt-by:         AS3292-MNT
created:        2002-07-02T13:36:00Z
last-modified:  2024-05-21T09:07:14Z
source:         RIPE # Filtered

% Information related to '2.108.0.0/15AS3292'

route:          2.108.0.0/15
descr:          TDC
origin:         AS3292
remarks:        +---------------------------------------+
remarks:        | For abuse and security issues please  |
remarks:        | see http://postmaster.tdc.dk or       |
remarks:        | contact postmaster@abuse.mail.dk      |
remarks:        +---------------------------------------+
mnt-by:         AS3292-MNT
created:        2023-10-19T13:06:17Z
last-modified:  2023-10-19T13:06:17Z
source:         RIPE # Filtered

% This query was served by the RIPE Database Query Service version 1.120 (BUSA)

",2025-11-18T12:07:12,2025-11-18T12:07:12
2.113.128.112,2.113.128.115,COMUNEDIBERTINORO,IT,business.telecomitalia.it,ripencc,null,2,2,,,"% 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.128.112 - 2.113.128.115'

% Abuse contact for '2.113.128.112 - 2.113.128.115' is 'abuse@business.telecomitalia.it'

inetnum:        2.113.128.112 - 2.113.128.115
netname:        COMUNEDIBERTINORO
descr:          COMUNE DI BERTINORO
country:        IT
admin-c:        SS32461-RIPE
tech-c:         SS32461-RIPE
status:         ASSIGNED PA
mnt-by:         INTERB-MNT
created:        2018-02-16T07:22:42Z
last-modified:  2020-04-09T14:32:54Z
source:         RIPE # Filtered

person:         STEFANIA SAMA
address:        COMUNE DI BERTINORO
address:        PIAZZA DELLA LIBERTA' 1
address:        47032 BERTINORO
address:        Italy
nic-hdl:        SS32461-RIPE
phone:          +39543469211
fax-no:         +39543469211
mnt-by:         INTERB-MNT
created:        2018-02-16T07:22:42Z
last-modified:  2018-02-16T07:22:42Z
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.120 (BUSA)

",2018-02-16T07:22:42,2020-04-09T14:32:54
2.115.129.88,2.115.129.91,INRESISTITUTONAZIONALECONSULENZAPROGETTAZIONEINGEGNERIA,IT,business.telecomitalia.it,ripencc,null,3,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.115.129.88 - 2.115.129.91'

% Abuse contact for '2.115.129.88 - 2.115.129.91' is 'abuse@business.telecomitalia.it'

inetnum:        2.115.129.88 - 2.115.129.91
netname:        INRESISTITUTONAZIONALECONSULENZAPROGETTAZIONEINGEGNERIA
descr:          INRES ISTITUTO NAZIONALE CONSULENZA PROGETTAZIONE INGEGNERIA
country:        IT
admin-c:        AB44003-RIPE
tech-c:         AB44003-RIPE
status:         ASSIGNED PA
mnt-by:         INTERB-MNT
created:        2023-01-11T12:48:05Z
last-modified:  2023-01-11T12:48:05Z
source:         RIPE # Filtered

person:         ALESSANDRO BILLERI
address:        INRES ISTITUTO NAZIONALE CONSULENZA PROGETTAZIONE INGEGNERIA
address:        VIA S. REPARATA 43
address:        50100 FIRENZE
address:        Italy
nic-hdl:        AB44003-RIPE
phone:          +395547801
fax-no:         +395547801
mnt-by:         INTERB-MNT
created:        2023-01-11T12:48:04Z
last-modified:  2023-01-11T12:48:04Z
source:         RIPE

% Information related to '2.114.0.0/15AS3269'

route:          2.114.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:25:19Z
last-modified:  2017-07-17T12:18:26Z
source:         RIPE # Filtered

% This query was served by the RIPE Database Query Service version 1.120 (SHETLAND)

",2023-01-11T12:48:05,2023-01-11T12:48:05
2.116.209.128,2.116.209.131,EGEITALIASRL,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.116.209.128 - 2.116.209.131'

% Abuse contact for '2.116.209.128 - 2.116.209.131' is 'abuse@business.telecomitalia.it'

inetnum:        2.116.209.128 - 2.116.209.131
netname:        EGEITALIASRL
descr:          EGE ITALIA S.R.L.
country:        IT
admin-c:        AM48531-RIPE
tech-c:         AM48531-RIPE
status:         ASSIGNED PA
mnt-by:         INTERB-MNT
created:        2021-09-22T07:43:49Z
last-modified:  2021-09-22T07:43:49Z
source:         RIPE # Filtered

person:         ALESSANDRO MAGGIONI
address:        EGE ITALIA S.R.L
address:        VIA GIUSEPPE VERDI 88/B
address:        23807 MERATE
address:        Italy
nic-hdl:        AM48531-RIPE
phone:          +39399907035
fax-no:         +39399907035
mnt-by:         INTERB-MNT
created:        2021-09-22T07:43:49Z
last-modified:  2021-09-22T07:43:49Z
source:         RIPE

% This query was served by the RIPE Database Query Service version 1.120 (SHETLAND)

",2021-09-22T07:43:49,2021-09-22T07:43:49
2.226.106.0,2.226.106.255,FASTWEB-L3-PAT_NAT,IT,fastweb.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.226.106.0 - 2.226.106.255'

% Abuse contact for '2.226.106.0 - 2.226.106.255' is 'abuse@fastweb.it'

inetnum:        2.226.106.0 - 2.226.106.255
netname:        FASTWEB-L3-PAT_NAT
descr:          PAT/NAT IP addresses POP 2101 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-06-22T06:00:30Z
last-modified:  2011-06-22T06:00:30Z
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.224.0.0/13AS12874'

route:          2.224.0.0/13
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
remarks:
mnt-by:         FASTWEB-MNT
created:        2011-02-07T10:33:03Z
last-modified:  2011-02-07T10:33:03Z
source:         RIPE

% This query was served by the RIPE Database Query Service version 1.120 (ABERDEEN)

",2011-06-22T06:00:30,2011-06-22T06:00:30
5.1.50.0,5.1.50.255,RUSCOMP-NET,RU,t72.ru,ripencc,null,6,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 '5.1.50.0 - 5.1.50.255'

% Abuse contact for '5.1.50.0 - 5.1.50.255' is 'lir@t72.ru'

inetnum:        5.1.50.0 - 5.1.50.255
netname:        RUSCOMP-NET
descr:          JSC Russian Company. Internet service provider in Tyumen
descr:          Clients with fixed IP addresses
country:        RU
admin-c:        AMAX1-RIPE
tech-c:         DZ12-RIPE
status:         ASSIGNED PA
mnt-by:         RUSCOMP-MNT
created:        2012-11-14T10:25:41Z
last-modified:  2018-12-07T06:43:32Z
source:         RIPE

person:         Andrew Maximov
nic-hdl:        AMAX1-RIPE
address:        Join Stock Company Russian Company
address:        Tyumen, Russia, 625000
address:        Respublic str, 53
phone:          +7-3452-390001
phone:          +7-3452-390011
mnt-by:         RUSCOMP-MNT
created:        2003-01-25T20:17:30Z
last-modified:  2003-01-25T20:17:30Z
source:         RIPE # Filtered

person:         Dmitriy Zamuraev
address:        Russia, Tyumen, Respubliki street, 53
phone:          +7 3452 390007
nic-hdl:        DZ12-RIPE
created:        2008-04-03T04:40:58Z
last-modified:  2017-10-30T22:00:03Z
source:         RIPE # Filtered
mnt-by:         MNT-NETLINE-NSP
mnt-by:         RUSCOMP-MNT

% Information related to '5.1.50.0/24AS15493'

route:          5.1.50.0/24
descr:          Russian company LLC
descr:          Internet and Telephony service provider in Russia, Tyumen
origin:         AS15493
mnt-by:         RUSCOMP-MNT
created:        2019-10-02T09:14:30Z
last-modified:  2019-10-02T09:14:30Z
source:         RIPE

% This query was served by the RIPE Database Query Service version 1.120 (ABERDEEN)

",2012-11-14T10:25:41,2018-12-07T06:43:32
5.56.151.192,5.56.151.223,Contentor-NET-1,DK,globalconnect.dk,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.56.151.192 - 5.56.151.223'

% Abuse contact for '5.56.151.192 - 5.56.151.223' is 'abuse@globalconnect.dk'

inetnum:        5.56.151.192 - 5.56.151.223
netname:        Contentor-NET-1
descr:          Contentor ApS
country:        DK
admin-c:        CBW4-RIPE
tech-c:         CBW4-RIPE
remarks:        NKA-021722
status:         ASSIGNED PA
mnt-by:         nia-mnt
created:        2017-10-09T11:58:15Z
last-modified:  2017-10-09T11:58:15Z
source:         RIPE

person:         Christian Bonde Wejergang
address:        Contentor ApS Kochsgade 31C 1. DK-5000 Odense C. Denmark
phone:          +45 25665609
nic-hdl:        CBW4-RIPE
mnt-by:         nia-mnt
created:        2017-10-09T11:57:29Z
last-modified:  2017-10-09T11:57:29Z
source:         RIPE

% Information related to '5.56.144.0/20AS31027'

route:          5.56.144.0/20
descr:          Nianet A/S
origin:         AS31027
mnt-by:         nia-mnt
created:        2012-05-30T14:09:38Z
last-modified:  2012-05-30T14:09:38Z
source:         RIPE

% This query was served by the RIPE Database Query Service version 1.120 (BUSA)

",2017-10-09T11:58:15,2017-10-09T11:58:15
5.96.76.176,5.96.76.183,CAMONSRL,IT,business.telecomitalia.it,ripencc,null,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.96.76.176 - 5.96.76.183'

% Abuse contact for '5.96.76.176 - 5.96.76.183' is 'abuse@business.telecomitalia.it'

inetnum:        5.96.76.176 - 5.96.76.183
netname:        CAMONSRL
descr:          CA.MON SRL
country:        IT
admin-c:        RL13934-RIPE
tech-c:         RL13934-RIPE
status:         ASSIGNED PA
mnt-by:         INTERB-MNT
created:        2022-09-26T09:18:24Z
last-modified:  2022-09-26T09:18:24Z
source:         RIPE # Filtered

person:         RAFFAELE LONGO
address:        CA.MON SRL
address:        VIA ZAGARIA 2
address:        31055 QUINTO DI TREVISO
address:        Italy
nic-hdl:        RL13934-RIPE
phone:          +39422471065
fax-no:         +39422471065
mnt-by:         INTERB-MNT
created:        2022-09-26T09:18:24Z
last-modified:  2022-09-26T09:18:24Z
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.120 (DEXTER)

",2022-09-26T09:18:24,2022-09-26T09:18:24
5.102.88.236,5.102.88.239,TVA002-393649,GB,pxc.co.uk,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.102.88.236 - 5.102.88.239'

% Abuse contact for '5.102.88.236 - 5.102.88.239' is 'abuse-reports@pxc.co.uk'

inetnum:        5.102.88.236 - 5.102.88.239
netname:        TVA002-393649
descr:          TV and Video Direct Ltd - WN7 4NP
country:        GB
admin-c:        IPA-RIPE
tech-c:         IPA-RIPE
status:         ASSIGNED PA
mnt-by:         OBSL-MNT
created:        2012-12-11T13:20:03Z
last-modified:  2012-12-11T13:20:03Z
source:         RIPE

role:           IP Administration
address:        Breckland, Linford Wood, Milton Keynes, Buckinghamshire, MK14 6LB
mnt-by:         OBSL-MNT
admin-c:        RF9514-RIPE
tech-c:         WC1893-RIPE
abuse-mailbox:  abuse-reports@pxc.co.uk
nic-hdl:        IPA-RIPE
created:        2007-03-26T08:56:28Z
last-modified:  2025-02-20T12:18:29Z
source:         RIPE # Filtered

% Information related to '5.102.80.0/20as8586'

route:          5.102.80.0/20
descr:          TTB core/customer route
origin:         as8586
mnt-by:         OBSL-MNT
created:        2012-07-09T14:32:36Z
last-modified:  2025-02-21T11:32:23Z
source:         RIPE

% This query was served by the RIPE Database Query Service version 1.120 (SHETLAND)

",2012-12-11T13:20:03,2012-12-11T13:20:03
5.159.250.0,5.159.250.255,ABH-EXT01,TR,anadolugrubu.com.tr,ripencc,null,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.159.250.0 - 5.159.250.255'

% Abuse contact for '5.159.250.0 - 5.159.250.255' is 'abuse@anadolugrubu.com.tr'

inetnum:        5.159.250.0 - 5.159.250.255
netname:        ABH-EXT01
descr:          Anadolu Bilisim Hizmetleri A.S Server Farm 02
country:        TR
admin-c:        BA7457-RIPE
tech-c:         BA7457-RIPE
status:         ASSIGNED PA
mnt-by:         MNT-ABH-MNT
created:        2012-08-01T22:42:51Z
last-modified:  2020-02-10T13:29:53Z
source:         RIPE # Filtered

person:         Batu AKALIN
address:        Fatih Sultan Mehmet Mah. Balkan Cad. No:58, Buyaka E Blok 34771 Tepe�st� Umraniye Istanbul
phone:          +905303263318
nic-hdl:        BA7457-RIPE
mnt-by:         tr-bntpro-1-mnt
mnt-by:         MNT-ABH-MNT
created:        2020-01-27T12:23:30Z
last-modified:  2020-02-10T14:23:27Z
source:         RIPE

% Information related to '5.159.248.0/21AS34984'

route:          5.159.248.0/21
origin:         AS34984
mnt-by:         MNT-ABH-MNT
created:        2026-01-06T11:22:37Z
last-modified:  2026-01-06T11:22:37Z
source:         RIPE

% This query was served by the RIPE Database Query Service version 1.120 (DEXTER)

",2012-08-01T22:42:51,2020-02-10T13:29:53

2.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
email	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:00Z
source	string	The source of the WHOIS handle information.	Yes	ARIN

Tip

id in the db-handles-details.csv.gz file joins to the *_handles_id fields in db-ip-whois.csv.gz (e.g., admin_handles_id,tech_handles_id,abuse_handles_id,irt_handles_id).

I.Example Records

Example

id,handle,name,country,email,phone,fax,address,date_updated,source
5,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,as5071-ripe,AS3292 Staff,,,,,"TDC A/S, Sletvej 30, 8-062, DK-8310 Tranbjerg, Denmark",2024-05-21T09:07:14,RIPE
8,cbw4-ripe,Christian Bonde Wejergang,,,+45 25665609,,Contentor ApS Kochsgade 31C 1. DK-5000 Odense C. Denmark,2017-10-09T11:57:29,RIPE
4,am48531-ripe,ALESSANDRO MAGGIONI,,,+39399907035,+39399907035,"EGE ITALIA S.R.L, VIA GIUSEPPE VERDI 88/B, 23807 MERATE, Italy",2021-09-22T07:43:49,RIPE
3,ab44003-ripe,ALESSANDRO BILLERI,,,+395547801,+395547801,"INRES ISTITUTO NAZIONALE CONSULENZA PROGETTAZIONE INGEGNERIA, VIA S. REPARATA 43, 50100 FIRENZE, Italy",2023-01-11T12:48:04,RIPE
6,amax1-ripe,Andrew Maximov,,,+7-3452-390011,,"Join Stock Company Russian Company, Tyumen, Russia, 625000, Respublic str, 53",2003-01-25T20:17:30,RIPE
11,ba7457-ripe,Batu AKALIN,,,+905303263318,,"Fatih Sultan Mehmet Mah. Balkan Cad. No:58, Buyaka E Blok 34771 Tepe�st� Umraniye Istanbul",2020-02-10T14:23:27,RIPE
10,ipa-ripe,IP Administration,,abuse-reports@pxc.co.uk,,,"Breckland, Linford Wood, Milton Keynes, Buckinghamshire, MK14 6LB",2025-02-20T12:18:29,RIPE
7,dz12-ripe,Dmitriy Zamuraev,,,+7 3452 390007,,"Russia, Tyumen, Respubliki street, 53",2017-10-30T22:00:03,RIPE
2,ss32461-ripe,STEFANIA SAMA,,,+39543469211,+39543469211,"COMUNE DI BERTINORO, PIAZZA DELLA LIBERTA' 1, 47032 BERTINORO, Italy",2018-02-16T07:22:42,RIPE
9,rl13934-ripe,RAFFAELE LONGO,,,+39422471065,+39422471065,"CA.MON SRL, VIA ZAGARIA 2, 31055 QUINTO DI TREVISO, Italy",2022-09-26T09:18:24,RIPE

3.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
email	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:00Z
source	string	The source of the WHOIS organization information.	Yes	ARIN

Tip

id in the db-org-details.csv.gz file joins to the org_id field in db-ip-whois.csv.gz (linking each IP range to its organization details).

I.Example Records

Example

id,handle,name,type,address,country,email,phone,fax,date_updated,source

4.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):

db-ip-whois.mmdb

Full WHOIS details for IP addresses: name, country, domain, RIR, contact IDs, and raw WHOIS record.

File Size: 22.00 MB

Entries: 11.2M

README.md

Documentation for dataset contents, schema, usage, and support.

File Size: 7.97 KB

db-ip-whois.md5

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.

Showing 7 of 53

Select a field to view details

I.Example Records

Example

{
  "whois": {
    "abuse_handles": [],
    "admin_handles": [
      {
        "address": "TDC A/S, Sletvej 30, 8-062, DK-8310 Tranbjerg, Denmark",
        "country": "",
        "date_updated": "2024-05-21T09:07:14",
        "email": "",
        "fax": "",
        "handle": "as5071-ripe",
        "name": "AS3292 Staff",
        "phone": "",
        "source": "RIPE"
      }
    ],
    "country": "DK",
    "date_created": "2025-11-18T12:07:12",
    "date_updated": "2025-11-18T12:07:12",
    "domain": "abuse.mail.dk",
    "irt_handles": [],
    "name": "TDC-CUSTOMER-NET",
    "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.109.83.52 - 2.109.83.55'\n\n% Abuse contact for '2.109.83.52 - 2.109.83.55' is 'postmaster@abuse.mail.dk'\n\ninetnum:        2.109.83.52 - 2.109.83.55\nnetname:        TDC-CUSTOMER-NET\ndescr:          TDC IP Customers\ncountry:        DK\nremarks:        +---------------------------------------+\nremarks:        | For abuse and security issues please  |\nremarks:        | see http://postmaster.tdc.dk or       |\nremarks:        | contact postmaster@abuse.mail.dk      |\nremarks:        +---------------------------------------+\nadmin-c:        AS5071-RIPE\ntech-c:         AS5071-RIPE\nstatus:         ASSIGNED PA\nmnt-by:         TDK-MNT\ncreated:        2025-11-18T12:07:12Z\nlast-modified:  2025-11-18T12:07:12Z\nsource:         RIPE\n\nrole:           AS3292 Staff\naddress:        TDC A/S\naddress:        Sletvej 30, 8-062\naddress:        DK-8310 Tranbjerg\naddress:        Denmark\nremarks:        contact info: http://as3292.peeringdb.com\nadmin-c:        NCB1-RIPE\nadmin-c:        MBP137-RIPE\ntech-c:         NCB1-RIPE\ntech-c:         CP11490-RIPE\ntech-c:         MBP137-RIPE\nnic-hdl:        AS5071-RIPE\nmnt-by:         AS3292-MNT\ncreated:        2002-07-02T13:36:00Z\nlast-modified:  2024-05-21T09:07:14Z\nsource:         RIPE # Filtered\n\n% Information related to '2.108.0.0/15AS3292'\n\nroute:          2.108.0.0/15\ndescr:          TDC\norigin:         AS3292\nremarks:        +---------------------------------------+\nremarks:        | For abuse and security issues please  |\nremarks:        | see http://postmaster.tdc.dk or       |\nremarks:        | contact postmaster@abuse.mail.dk      |\nremarks:        +---------------------------------------+\nmnt-by:         AS3292-MNT\ncreated:        2023-10-19T13:06:17Z\nlast-modified:  2023-10-19T13:06:17Z\nsource:         RIPE # Filtered\n\n% This query was served by the RIPE Database Query Service version 1.120 (BUSA)\n\n",
    "rir": "ripencc",
    "tech_handles": [
      {
        "address": "TDC A/S, Sletvej 30, 8-062, DK-8310 Tranbjerg, Denmark",
        "country": "",
        "date_updated": "2024-05-21T09:07:14",
        "email": "",
        "fax": "",
        "handle": "as5071-ripe",
        "name": "AS3292 Staff",
        "phone": "",
        "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.

Note

The public key may be provided as PEM-encoded text. Save it to a file named public-key.pem

Ensure OpenSSL is installed on your system. If not, install it using the following commands

On Linux, if openssl is not installed

sudo apt install openssl

Verify OpenSSL installation:

openssl version

To verify the database file, run the following command, replacing the placeholders with your actual file paths:

openssl dgst -sha256 -verify <path-to-public-key.pem> -signature <path-to-signature-file.sig> <path-to-database-file.zip>

Example output:

Verified OK

if verification FAILED do not use the file, re-download the database and signature from official IPGeolocation endpoints. If the issue persists, please contact our support team.

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.

Tip

Always verify downloaded files with the provided checksum before importing.

On Linux, if sha256sum is not installed, first run:

sudo apt-get install coreutils

Then check the archive files against the checksum file with:

sha256sum -c checksum.txt

Example output:

db-ip-whois.csv.gz: OK
db-org-details.csv.gz: OK
db-handles-details.csv.gz: OK
README.md: OK
db-ip-whois.md5: OK

*your output may differ depending on the specific database archive you downloaded.

If a file's checksum does not match, FAILED will be shown instead of OK . If verification fails, first confirm that the download completed correctly; if the issue persists, please contact our support team.

Important

Signature verification confirms both authenticity and integrity. Checksum verification confirms integrity only (it detects corruption/modification, but does not independently prove who produced the file).

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 refreshed daily and weekly, 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.

IP Whois Database

Overview

Available Database Formats

CSV Database Documentation

1.Overview

2.Archive Content

Schema

1.db-ip-whois.csv.gz

I.Example Records

2.db-handles-details.csv.gz

I.Example Records

3.db-org-details.csv.gz

I.Example Records

4.File Relationship Diagram

File Format & Encoding

MMDB Database Documentation

1.Overview

2.Archive Content

Response Schema

1.db-ip-whois.mmdb

2.Field Reference

I.Example Records

Database Integrity & Authenticity Verification

1.Using the Signature File (Recommended)

2.Using the Checksum File (Legacy)

Data Format & Constraints

Database Updates & Delivery

Subscribe Our Newsletter