ip2location/ip2locationio
steampipe plugin install ip2location/ip2locationio

Table: ip2locationio_whois

Get WHOIS domain information about a domain name. The ip2locationio_whois table requires the domain field to be specified in all queries, defining the domain name to lookup.

Examples

Info for a specific domain name

select
domain,
domain_id,
status,
create_date
from
ip2locationio_whois
where
domain = 'google.com';

Nested info for a specific domain name

select
domain,
domain_id,
registrar ->> 'name' as registrar_name,
nameservers
from
ip2locationio_whois
where
domain = 'google.com';

Schema for ip2locationio_whois

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
adminjsonbAdmin details.
billingjsonbBilling details.
create_datetimestamp with time zoneDomain name creation date.
domaintext=Domain name to query.
domain_agebigintDomain name age in day(s).
domain_idtextDomain name ID.
expire_datetimestamp with time zoneDomain name expiration date.
nameserversjsonbName servers.
registrantjsonbRegistrant details.
registrarjsonbRegistrar details.
statustextDomain name status.
techjsonbTech details.
update_datetimestamp with time zoneDomain name updated date.
whois_servertextWHOIS server name.