turbot/ipstack

steampipe plugin install ipstacksteampipe plugin install ipstack

Table: ipstack_my_ip

Query location, currency, timezone and security information about your public IP address.

Examples

Get information about your current IP

select * from ipstack_my_ip;

.inspect ipstack_my_ip

IP and geolocation information about your public IP.

NameTypeDescription
asnbigintAutonomous System Number associated with the IP.
citytextName of the city associated with the IP.
continent_codetext2-letter continent code associated with the IP.
continent_nametextName of the continent associated with the IP.
country_codetext2-letter country code associated with the IP.
country_nametextname of the country associated with the IP.
crawler_nametextName of the crawler the IP is associated with.
crawler_typetextType of crawler the IP is associated with.
currency_codetext3-letter code of the main currency associated with the IP.
currency_nametextName of the given currency.
currency_pluraltextPlural name of the given currency.
currency_symboltextSymbol letter of the given currency.
currency_symbol_nativetextNative symbol letter of the given currency.
hostnametextHostname associated with the IP address, if available.
ipinetRequested IP address.
is_crawlerbooleanTrue or false depending on whether or not the given IP is associated with a crawler.
is_proxybooleanTrue or false depending on whether or not the given IP is associated with a proxy.
is_torbooleanTrue or false depending on whether or not the given IP is associated with the anonymous Tor system.
isptextName of the ISP associated with the IP.
latitudedouble precisionLatitude value associated with the IP.
location_calling_codetextCalling / dial code of the country associated with the IP. (e.g. 351) for Portugal.
location_capitaltextCapital city of the country associated with the IP.
location_country_flag_emojitextEmoji icon for the flag of the country associated with the IP.
location_country_flag_emoji_unicodetextUnicode value of the emoji icon for the flag of the country associated with the IP (e.g. U+1F1F5 U+1F1F9 for the Portuguese flag).
location_country_flag_linktextHTTP URL leading to an SVG-flag icon for the country associated with the IP.
location_geoname_idbigintUnique geoname identifier in accordance with the Geonames Registry.
location_is_eubooleanTrue or false depending on whether or not the county associated with the IP is in the European Union.
location_languagesjsonbObject containing one or multiple sub-objects per language spoken in the country associated with the IP.
longitudedouble precisionLongitude value associated with the IP.
proxy_typetextType of proxy the IP is associated with.
region_codetextRegion code of the region associated with the IP (e.g. CA for California).
region_nametextName of the region associated with the IP.
threat_leveltextType of threat level the IP is associated with.
threat_typesjsonbObject containing all threat types associated with the IP.
timezone_codetextUniversal code of the given time zone.
timezone_current_timetimestamp without time zoneCurrent date and time in the location associated with the IP (e.g. 2018-03-29T22:31:27-07:00).
timezone_gmt_offsetbigintGMT offset of the given time zone in seconds (e.g. -25200 for PST's -7h GMT offset).
timezone_idtextID of the time zone associated with the IP (e.g. America/Los_Angeles for PST).
timezone_is_daylight_savingbooleanTrue or false depending on whether or not the given time zone is considered daylight saving time.
typetextIP address type IPv4 or IPv6.
ziptextZIP code associated with the IP.