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

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

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.224.216.0,2.224.216.255,FASTWEB-L3-PAT_NAT,IT,fastweb.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.224.216.0 - 2.224.216.255'

% Abuse contact for '2.224.216.0 - 2.224.216.255' is 'abuse@fastweb.it'

inetnum:        2.224.216.0 - 2.224.216.255
netname:        FASTWEB-L3-PAT_NAT
descr:          PAT/NAT IP addresses POP 4201 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-10-14T06:00:13Z
last-modified:  2011-10-14T06:00:13Z
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.121 (DEXTER)

",2011-10-14T06:00:13,2011-10-14T06:00:13
2.228.131.24,2.228.131.31,FASTWEB-ECLAIR_ITALY,IT,fastweb.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.228.131.24 - 2.228.131.31'

% Abuse contact for '2.228.131.24 - 2.228.131.31' is 'abuse@fastweb.it'

inetnum:        2.228.131.24 - 2.228.131.31
netname:        FASTWEB-ECLAIR_ITALY
descr:          ECLAIR ITALY public subnet
country:        IT
admin-c:        SA40562-RIPE
tech-c:         IRSN1-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
created:        2020-11-13T13:20:38Z
last-modified:  2020-11-13T13:20:38Z
source:         RIPE

person:         IP Registration Service NIS
address:        Via Caracciolo, 51
address:        20155 Milano MI
address:        Italy
phone:          +39 02 45451
fax-no:         +39 02 45451
nic-hdl:        IRSN1-RIPE
mnt-by:         FASTWEB-MNT
remarks:
remarks:        In case of improper use originating
remarks:        from our network,
remarks:        please mail customer or abuse@fastweb.it
remarks:
created:        2005-09-15T10:18:18Z
last-modified:  2008-02-29T14:12:48Z
source:         RIPE # Filtered

person:         STEFANO ANGELINI
address:        VIA ISAAC NEWTON 6
address:        MONTEROTONDO RM
address:        IT
phone:          +39 3346314314
nic-hdl:        SA40562-RIPE
mnt-by:         FASTWEB-MNT
created:        2020-11-13T13:20:35Z
last-modified:  2020-11-13T13:20:35Z
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.121 (BUSA)

",2020-11-13T13:20:38,2020-11-13T13:20:38
2.229.39.156,2.229.39.159,FASTWEB-HUMANGEST,IT,fastweb.it,ripencc,null,4,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.229.39.156 - 2.229.39.159'

% Abuse contact for '2.229.39.156 - 2.229.39.159' is 'abuse@fastweb.it'

inetnum:        2.229.39.156 - 2.229.39.159
netname:        FASTWEB-HUMANGEST
descr:          HUMANGEST public subnet
country:        IT
admin-c:        ADF747-RIPE
tech-c:         IRSN1-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
created:        2023-05-18T09:30:11Z
last-modified:  2023-05-18T09:30:11Z
source:         RIPE

person:         ANDREA DI FRANCESCO
address:        VIA PRIMO SAVANI 14
address:        PARMA PR
address:        IT
phone:          +39 085450891
nic-hdl:        ADF747-RIPE
mnt-by:         FASTWEB-MNT
created:        2023-05-18T09:30:08Z
last-modified:  2023-05-18T09:30:08Z
source:         RIPE # Filtered

person:         IP Registration Service NIS
address:        Via Caracciolo, 51
address:        20155 Milano MI
address:        Italy
phone:          +39 02 45451
fax-no:         +39 02 45451
nic-hdl:        IRSN1-RIPE
mnt-by:         FASTWEB-MNT
remarks:
remarks:        In case of improper use originating
remarks:        from our network,
remarks:        please mail customer or abuse@fastweb.it
remarks:
created:        2005-09-15T10:18:18Z
last-modified:  2008-02-29T14:12:48Z
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.121 (DEXTER)

",2023-05-18T09:30:11,2023-05-18T09:30:11
5.9.104.64,5.9.104.95,HETZNER-fsn1-dc7,DE,hetzner.com,ripencc,1,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 '5.9.104.64 - 5.9.104.95'

% Abuse contact for '5.9.104.64 - 5.9.104.95' is 'abuse@hetzner.com'

inetnum:        5.9.104.64 - 5.9.104.95
netname:        HETZNER-fsn1-dc7
descr:          Hetzner Online GmbH
descr:          Datacenter fsn1-dc7
country:        DE
admin-c:        HOAC1-RIPE
tech-c:         HOAC1-RIPE
status:         ASSIGNED PA
remarks:        INFRA-AW
mnt-by:         HOS-GUN
mnt-lower:      HOS-GUN
mnt-routes:     HOS-GUN
created:        2012-10-18T12:06:55Z
last-modified:  2018-03-15T14:13:54Z
source:         RIPE

role:           Hetzner Online GmbH - Contact Role
address:        Hetzner Online GmbH
address:        Industriestrasse 25
address:        D-91710 Gunzenhausen
address:        Germany
phone:          +49 9831 505-0
fax-no:         +49 9831 505-3
abuse-mailbox:  abuse@hetzner.com
remarks:        *************************************************
remarks:        * For spam/abuse/security issues please contact *
remarks:        * abuse@hetzner.com, or fill out the form at *
remarks:        * abuse.hetzner.com, thank you. *
remarks:        *************************************************
remarks:
remarks:        *************************************************
remarks:        * Any questions on Peering please send to *
remarks:        * peering@hetzner.com *
remarks:        *************************************************
org:            ORG-HOA1-RIPE
admin-c:        MH375-RIPE
tech-c:         GM834-RIPE
tech-c:         SK2374-RIPE
tech-c:         MF1400-RIPE
tech-c:         SK8441-RIPE
tech-c:         DD15478-RIPE
nic-hdl:        HOAC1-RIPE
mnt-by:         HOS-GUN
created:        2004-08-12T09:40:20Z
last-modified:  2022-11-22T18:33:55Z
source:         RIPE # Filtered

% Information related to '5.9.0.0/16AS24940'

route:          5.9.0.0/16
descr:          HETZNER-RZ-FKS-BLK5
origin:         AS24940
mnt-by:         HOS-GUN
created:        2012-04-26T10:30:12Z
last-modified:  2012-04-26T10:30:12Z
source:         RIPE

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


organisation:   ORG-HOA1-RIPE
org-name:       Hetzner Online GmbH
country:        DE
org-type:       LIR
address:        Industriestrasse 25
address:        D-91710
address:        Gunzenhausen
address:        GERMANY
phone:          +49 9831 5050
fax-no:         +49 9831 5053
admin-c:        MF1400-RIPE
admin-c:        GM834-RIPE
admin-c:        HOAC1-RIPE
admin-c:        MH375-RIPE
admin-c:        SK2374-RIPE
admin-c:        SK8441-RIPE
abuse-c:        HOAC1-RIPE
mnt-ref:        RIPE-NCC-HM-MNT
mnt-ref:        HOS-GUN
mnt-by:         RIPE-NCC-HM-MNT
mnt-by:         HOS-GUN
created:        2004-04-17T11:07:58Z
last-modified:  2022-11-22T18:32:44Z
source:         RIPE # Filtered

",2012-10-18T12:06:55,2018-03-15T14:13:54
5.45.219.10,5.45.219.11,YANDEX-5-45-219-10,RU,yandex.ru,ripencc,2,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 '5.45.219.10 - 5.45.219.11'

% Abuse contact for '5.45.219.10 - 5.45.219.11' is 'abuse@yandex.ru'

inetnum:        5.45.219.10 - 5.45.219.11
netname:        YANDEX-5-45-219-10
status:         ASSIGNED PA
country:        RU
descr:          Yandex enterprise network
mnt-by:         YANDEX-MNT
admin-c:        YNDX1-RIPE
tech-c:         YNDX1-RIPE
org:            ORG-YA1-RIPE
remarks:        INFRA-AW
created:        2025-04-03T07:39:59Z
last-modified:  2025-04-03T07:39:59Z
source:         RIPE

organisation:   ORG-YA1-RIPE
org-name:       YANDEX LLC
country:        RU
org-type:       LIR
address:        LVA TOLSTOY STREET, 16
address:        119021
address:        Moscow
address:        RUSSIAN FEDERATION
phone:          +74957397000
fax-no:         +74957397070
admin-c:        YNDX1-RIPE
tech-c:         YNDX1-RIPE
abuse-c:        YAH6-RIPE
mnt-ref:        RIPE-NCC-HM-MNT
mnt-ref:        YANDEX-MNT
mnt-by:         RIPE-NCC-HM-MNT
mnt-by:         YANDEX-MNT
created:        2004-04-22T14:39:02Z
last-modified:  2025-08-04T11:07:18Z
source:         RIPE # Filtered

role:           Yandex LLC Network Operations
address:        Yandex LLC
address:        16, Leo Tolstoy St.
address:        119021
address:        Moscow
address:        Russian Federation
phone:          +7 495 739 7000
fax-no:         +7 495 739 7070
remarks:        trouble: ------------------------------------------------------
remarks:        trouble: Points of contact for Yandex LLC Network Operations
remarks:        trouble: ------------------------------------------------------
remarks:        trouble: Routing and peering issues: noc@yandex.net
remarks:        trouble: SPAM issues:                abuse@yandex.ru
remarks:        trouble: Network security issues:    abuse@yandex.ru
remarks:        trouble: Mail issues:                postmaster@yandex.ru
remarks:        trouble: General information:        info@yandex.ru
remarks:        trouble: ------------------------------------------------------
admin-c:        MK24579-RIPE
tech-c:         EM3673-RIPE
tech-c:         AUR2-RIPE
nic-hdl:        YNDX1-RIPE
mnt-by:         YANDEX-MNT
created:        2002-06-07T05:35:50Z
last-modified:  2025-12-30T09:47:31Z
source:         RIPE # Filtered
abuse-mailbox:  abuse@yandex.ru

% Information related to '5.45.219.0/24AS44534'

route:          5.45.219.0/24
descr:          Yandex enterprise network
origin:         AS44534
mnt-by:         YANDEX-MNT
created:        2025-09-02T12:16:06Z
last-modified:  2025-09-02T12:16:06Z
source:         RIPE

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

",2025-04-03T07:39:59,2025-04-03T07:39:59
5.83.3.116,5.83.3.119,CIC-MEDIA-Customer-3315,NL,h4hosting.eu,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 '5.83.3.116 - 5.83.3.119'

% Abuse contact for '5.83.3.116 - 5.83.3.119' is 'abuse@h4hosting.eu'

inetnum:        5.83.3.116 - 5.83.3.119
netname:        CIC-MEDIA-Customer-3315
country:        NL
admin-c:        HM3927-RIPE
tech-c:         HM3927-RIPE
status:         ASSIGNED PA
mnt-by:         MNT-H4HOSTING
created:        2018-06-04T10:31:28Z
last-modified:  2018-06-04T10:31:28Z
source:         RIPE

person:         H4Hosting B.V. RIPE Maintainer
address:        Kweekgrasstraat 30
address:        1313BX Almere
address:        NL
phone:          +31367410710
nic-hdl:        HM3927-RIPE
mnt-by:         MNT-H4HOSTING
created:        2012-06-04T18:45:43Z
last-modified:  2024-11-27T21:51:26Z
source:         RIPE # Filtered

% Information related to '5.83.0.0/21AS51050'

route:          5.83.0.0/21
descr:          H4Hosting Network - Fiber / IP Transit and Colocation Customers
origin:         AS51050
mnt-by:         MNT-H4HOSTING
created:        2012-06-15T13:34:15Z
last-modified:  2025-03-11T11:39:40Z
source:         RIPE

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

",2018-06-04T10:31:28,2018-06-04T10:31:28
5.96.160.152,5.96.160.159,VEZZOLIGIUSEPPE,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.96.160.152 - 5.96.160.159'

% Abuse contact for '5.96.160.152 - 5.96.160.159' is 'abuse@business.telecomitalia.it'

inetnum:        5.96.160.152 - 5.96.160.159
netname:        VEZZOLIGIUSEPPE
descr:          VEZZOLI GIUSEPPE
country:        IT
admin-c:        EB14643-RIPE
tech-c:         EB14643-RIPE
status:         ASSIGNED PA
mnt-by:         INTERB-MNT
created:        2024-01-08T14:09:48Z
last-modified:  2024-01-08T14:09:48Z
source:         RIPE # Filtered

person:         EMILIA BERGAMASCHI
address:        VEZZOLI GIUSEPPE
address:        P.LE PARROCI TONOLETTI 7
address:        25036 PALAZZOLO SULL'OGLIO
address:        Italy
nic-hdl:        EB14643-RIPE
phone:          +39307402452
fax-no:         +39307402452
mnt-by:         INTERB-MNT
created:        2024-01-08T14:09:47Z
last-modified:  2024-01-08T14:09:47Z
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.121 (ABERDEEN)

",2024-01-08T14:09:48,2024-01-08T14:09:48
5.134.115.241,5.134.115.241,GINERNET,ES,ginernet.com,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.134.115.241 - 5.134.115.241'

% Abuse contact for '5.134.115.241 - 5.134.115.241' is 'abuse@ginernet.com'

inetnum:        5.134.115.241 - 5.134.115.241
netname:        GINERNET
descr:          GINERNET
country:        ES
admin-c:        GNR
tech-c:         GNR
status:         ASSIGNED PA
mnt-by:         GINERNET-MNT
created:        2018-11-30T12:19:17Z
last-modified:  2018-11-30T12:19:17Z
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.115.0/24AS59432'

route:          5.134.115.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.121 (BUSA)

",2018-11-30T12:19:17,2018-11-30T12:19:17
5.135.61.16,5.135.61.31,OVH_419037539,FR,docaposte.fr,ripencc,3,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.135.61.16 - 5.135.61.31'

% Abuse contact for '5.135.61.16 - 5.135.61.31' is 'gerald.deshayes@docaposte.fr'

inetnum:        5.135.61.16 - 5.135.61.31
netname:        OVH_419037539
country:        FR
descr:          Failover Ips
org:            ORG-SN253-RIPE
admin-c:        OTC2-RIPE
tech-c:         OTC2-RIPE
status:         ASSIGNED PA
mnt-by:         OVH-MNT
created:        2025-06-25T09:42:50Z
last-modified:  2025-06-25T09:42:50Z
source:         RIPE

organisation:   ORG-SN253-RIPE
org-name:       Smartpanda Network
org-type:       OTHER
address:        1 et 2, rue Antoine Lavoisier
address:        76300 Sotteville-Les-Rouen
address:        FR
phone:          +33.972326599
abuse-c:        ACRO59323-RIPE
mnt-ref:        OVH-MNT
mnt-by:         OVH-MNT
created:        2016-01-07T11:32:06Z
last-modified:  2025-02-14T09:54:12Z
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.121 (DEXTER)

",2025-06-25T09:42:50,2025-06-25T09:42:50
5.177.40.0,5.177.47.255,AVEA,TR,turktelekom.com.tr,ripencc,4,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.177.40.0 - 5.177.47.255'

% Abuse contact for '5.177.40.0 - 5.177.47.255' is 'abuse@turktelekom.com.tr'

inetnum:        5.177.40.0 - 5.177.47.255
netname:        AVEA
descr:          AVEA Iletisim Hizmetleri A.S.
country:        TR
org:            ORG-ITHA1-RIPE
admin-c:        Aa3018-RIPE
tech-c:         Aa3018-RIPE
status:         ASSIGNED PA
mnt-by:         AVEA-MNT
mnt-lower:      AVEA-MNT
mnt-routes:     AVEA-MNT
created:        2012-08-06T11:27:05Z
last-modified:  2012-08-06T11:27:05Z
source:         RIPE

organisation:   ORG-ITHA1-RIPE
org-name:       TT Mobil Iletisim Hizmetleri A.S
country:        TR
org-type:       LIR
address:        Gayrettepe Mah. Yildiz Posta Cad. 40 Bodrum Kat Oda 13
address:        34349
address:        Besiktas, ISTANBUL
address:        TURKEY
phone:          +903125550000
fax-no:         +902164606802
abuse-c:        AR17323-RIPE
admin-c:        NK1283-RIPE
admin-c:        NO638-RIPE
admin-c:        GA11360-RIPE
mnt-ref:        RIPE-NCC-HM-MNT
mnt-ref:        AVEA-MNT
mnt-by:         RIPE-NCC-HM-MNT
mnt-by:         AVEA-MNT
created:        2004-04-17T12:07:05Z
last-modified:  2020-12-16T13:06:54Z
source:         RIPE # Filtered

role:           AVEA admin
address:        Avea Iletisim Hizmetleri A.S.
address:        Abdi Ipek�i Cad. No.75 Ma�ka / Istanbul
phone:          +902124601500
fax-no:         +902164606802
admin-c:        TTBA1-RIPE
tech-c:         TTBA1-RIPE
nic-hdl:        Aa3018-RIPE
remarks:        ************************************************************************
remarks:        Please report abuse incidents ONLY to < abuse@turktelekom.com.tr>
remarks:        ************************************************************************
mnt-by:         AVEA-MNT
created:        2009-12-24T08:39:51Z
last-modified:  2021-10-05T14:32:31Z
source:         RIPE # Filtered

% Information related to '5.176.0.0/15AS20978'

route:          5.176.0.0/15
descr:          Avea Iletisim Hizmetleri A.S.
origin:         AS20978
mnt-lower:      AVEA-MNT
mnt-routes:     AVEA-MNT
mnt-by:         AVEA-MNT
created:        2012-08-06T12:15:42Z
last-modified:  2012-08-06T12:15:42Z
source:         RIPE

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

",2012-08-06T11:27:05,2012-08-06T11:27:05

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

I. Example Records

Example

id,handle,name,country,email,phone,fax,address,date_updated,source
6,yndx1-ripe,Yandex LLC Network Operations,,abuse@yandex.ru,+7 495 739 7000,+7 495 739 7070,"Yandex LLC, 16, Leo Tolstoy St., 119021, Moscow, Russian Federation",2025-12-30T09:47:31,RIPE
11,aa3018-ripe,AVEA admin,,,+902124601500,+902164606802,"Avea Iletisim Hizmetleri A.S., Abdi Ipek�i Cad. No.75 Ma�ka / Istanbul",2021-10-05T14:32:31,RIPE
3,irsn1-ripe,IP Registration Service NIS,,,+39 02 45451,+39 02 45451,"Via Caracciolo, 51, 20155 Milano MI, Italy",2008-02-29T14:12:48,RIPE
1,irs2-ripe,ip registration service,,,+39 02 45451,+39 02 45451,"Via Caracciolo, 51, 20155 Milano MI, Italy",2008-02-29T14:09:58,RIPE
5,hoac1-ripe,Hetzner Online GmbH - Contact Role,,abuse@hetzner.com,+49 9831 505-0,+49 9831 505-3,"Hetzner Online GmbH, Industriestrasse 25, D-91710 Gunzenhausen, Germany",2022-11-22T18:33:55,RIPE
7,hm3927-ripe,H4Hosting B.V. RIPE Maintainer,,,+31367410710,,"Kweekgrasstraat 30, 1313BX Almere, NL",2024-11-27T21:51:26,RIPE
8,eb14643-ripe,EMILIA BERGAMASCHI,,,+39307402452,+39307402452,"VEZZOLI GIUSEPPE, P.LE PARROCI TONOLETTI 7, 25036 PALAZZOLO SULL'OGLIO, Italy",2024-01-08T14:09:47,RIPE
10,otc2-ripe,OVH Technical Contact,,abuse@ovh.net,,,"OVH SAS, 2 rue Kellermann, 59100 Roubaix, France",2014-09-05T10:47:15,RIPE
9,gnr,GINERNET,,abuse@ginernet.com,+34.965064386,,"Albasanz 71, 28037, Madrid, SPAIN",2026-01-30T14:45:27,RIPE
4,adf747-ripe,ANDREA DI FRANCESCO,,,+39 085450891,,"VIA PRIMO SAVANI 14, PARMA PR, IT",2023-05-18T09:30:08,RIPE
2,sa40562-ripe,STEFANO ANGELINI,,,+39 3346314314,,"VIA ISAAC NEWTON 6, MONTEROTONDO RM, IT",2020-11-13T13:20:35,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

I. Example Records

Example

id,handle,name,type,address,country,email,phone,fax,date_updated,source
3,org-sn253-ripe,Smartpanda Network,other,"1 et 2, rue Antoine Lavoisier, 76300 Sotteville-Les-Rouen, FR",,,+33.972326599,,2025-02-14T09:54:12,ripencc
1,org-hoa1-ripe,Hetzner Online GmbH,lir,"Industriestrasse 25, D-91710, Gunzenhausen, GERMANY, Germany",DE,,+49 9831 5050,+49 9831 5053,2022-11-22T18:32:44,ripencc
4,org-itha1-ripe,TT Mobil Iletisim Hizmetleri A.S,lir,"Gayrettepe Mah. Yildiz Posta Cad. 40 Bodrum Kat Oda 13, 34349, Besiktas, ISTANBUL, TURKEY, Turkey",TR,,+903125550000,+902164606802,2020-12-16T13:06:54,ripencc
2,org-ya1-ripe,YANDEX LLC,lir,"LVA TOLSTOY STREET, 16, 119021, Moscow, RUSSIAN FEDERATION, Russia",RU,,+74957397000,+74957397070,2025-08-04T11:07:18,ripencc

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": "Via Caracciolo, 51, 20155 Milano MI, Italy",
        "country": "",
        "date_updated": "2008-02-29T14:09:58",
        "email": "",
        "fax": "+39 02 45451",
        "handle": "irs2-ripe",
        "name": "ip registration service",
        "phone": "+39 02 45451",
        "source": "RIPE"
      }
    ],
    "country": "IT",
    "date_created": "2011-10-14T06:00:13",
    "date_updated": "2011-10-14T06:00:13",
    "domain": "fastweb.it",
    "irt_handles": [],
    "name": "FASTWEB-L3-PAT_NAT",
    "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.224.216.0 - 2.224.216.255'\n\n% Abuse contact for '2.224.216.0 - 2.224.216.255' is 'abuse@fastweb.it'\n\ninetnum:        2.224.216.0 - 2.224.216.255\nnetname:        FASTWEB-L3-PAT_NAT\ndescr:          PAT/NAT IP addresses POP 4201 for\ndescr:          Static allocation to Residential/SoHo customer with L3 devices\ncountry:        IT\nadmin-c:        IRS2-RIPE\ntech-c:         IRS2-RIPE\nstatus:         ASSIGNED PA\nmnt-by:         FASTWEB-MNT\nremarks:        In case of improper use originating from our network,\nremarks:        please mail customer or abuse@fastweb.it\nremarks:        INFRA-AW\ncreated:        2011-10-14T06:00:13Z\nlast-modified:  2011-10-14T06:00:13Z\nsource:         RIPE\n\nperson:         ip registration service\naddress:        Via Caracciolo, 51\naddress:        20155 Milano MI\naddress:        Italy\nphone:          +39 02 45451\nfax-no:         +39 02 45451\nnic-hdl:        IRS2-RIPE\nmnt-by:         FASTWEB-MNT\nremarks:\nremarks:        In case of improper use originating from our network,\nremarks:        please mail customer or abuse@fastweb.it\nremarks:\ncreated:        2001-12-18T12:06:41Z\nlast-modified:  2008-02-29T14:09:58Z\nsource:         RIPE # Filtered\n\n% Information related to '2.224.0.0/13AS12874'\n\nroute:          2.224.0.0/13\ndescr:          Fastweb Networks block\norigin:         AS12874\nremarks:\nremarks:        In case of improper use originating from our network,\nremarks:        please mail customer or abuse@fastweb.it\nremarks:\nmnt-by:         FASTWEB-MNT\ncreated:        2011-02-07T10:33:03Z\nlast-modified:  2011-02-07T10:33:03Z\nsource:         RIPE\n\n% This query was served by the RIPE Database Query Service version 1.121 (DEXTER)\n\n",
    "rir": "ripencc",
    "tech_handles": [
      {
        "address": "Via Caracciolo, 51, 20155 Milano MI, Italy",
        "country": "",
        "date_updated": "2008-02-29T14:09:58",
        "email": "",
        "fax": "+39 02 45451",
        "handle": "irs2-ripe",
        "name": "ip registration service",
        "phone": "+39 02 45451",
        "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.

Tip

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.

Note

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.

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 to Our Newsletter