Get information about a domain including WHOIS, popularity, DNS and more.
id (registered domain name) must be provided in all queries to this table.
Get domain information
select*fromvirustotal_domainwhereid = 'steampipe.io'
Information and analysis for a domain.
|categories||jsonb||Mapping that relates categorisation services with the category it assigns the domain to. These services are, among others: Alexa, BitDefender, TrendMicro, Websense ThreatSeeker, etc.|
|creation_date||timestamp without time zone||Creation date extracted from the Domain's whois.|
|favicon||jsonb||Dictionary including difference hash and md5 hash of the domain's favicon. Only available for premium users.|
|id||text||The domain name to retrieve.|
|jarm||text||JARM is an active Transport Layer Security (TLS) server fingerprint.|
|last_analysis_results||jsonb||Result from URL scanners. dict with scanner name as key and a dict with notes/result from that scanner as value.|
|last_analysis_stats||jsonb||Number of different results from this scans.|
|last_dns_records||jsonb||Domain's DNS records on its last scan.|
|last_dns_records_date||timestamp without time zone||Date when the dns records list was retrieved by VirusTotal.|
|last_https_certificate||jsonb||SSL Certificate object retrieved last time the domain was analysed.|
|last_https_certificate_date||timestamp without time zone||Date when the certificate was retrieved by VirusTotal.|
|last_modification_date||timestamp without time zone||Date when any of domain's information was last updated.|
|last_update_date||timestamp without time zone||Updated date extracted from whois.|
|popularity_ranks||jsonb||Domain's position in popularity ranks such as Alexa, Quantcast, Statvoo, etc.|
|registrar||text||Company that registered the domain.|
|reputation||jsonb||Domain's score calculated from the votes of the VirusTotal's community.|
|tags||jsonb||List of representative attributes.|
|total_votes||jsonb||Unweighted number of total votes from the community, divided into harmless and malicious.|
|whois||text||WHOIS information as returned from the pertinent whois server.|
|whois_date||timestamp without time zone||Date of the last update of the whois record in VirusTotal.|