coderholic

coderholic

{
  "range": "92.67.167.88/29",
  "id": "OTS210526",
  "name": "Acco Brands Benelux BV",
  "country": "NL",
  "status": "ASSIGNED PA",
  "maintainer": ["RIPE-NCC-HM-MNT", "KPN-MNT"],
  "source": "ripe",
  "created": "2008-05-15",
  "updated": "2008-05-15",

coderholic

coderholic

coderholic

109.150.2.59,London,England,GB,"51.5085,-0.1257",host109-150-2-59.range109-150.btcentralplus.com,EC1A,,pro,AS2856,British Telecommunications PLC,bt.com,109.144.0.0/12,isp,BT Infrastructure Layer,bt.com,isp,,,,TRUE,FALSE,FALSE,FALSE,FALSE,
147.147.249.148,Enfield Town,England,GB,"51.6515,-0.0850",148.249.147.147.dyn.plus.net,EN2,,pro,AS6871,Plusnet,plus.net,147.147.0.0/16,isp,Plusnet PLC,plus.net,isp,,,,TRUE,FALSE,FALSE,FALSE,FALSE,
151.228.16.78,Southampton,England,GB,"50.9040,-1.4043",97e4104e.skybroadband.com,SO15,,pro,AS5607,Sky UK Limited,sky.com,151.224.0.0/13,isp,Sky UK Limited,sky.com,isp,,,,TRUE,FALSE,FALSE,FALSE,FALSE,
185.192.69.119,London,England,GB,"51.5115,-0.0912",,EC4R,,pro,AS62240,Clouvider,clouvider.net,185.192.69.0/24,isp,Legaco Networks B.V.,legaconetworks.nl,business,,,,TRUE,FALSE,FALSE,FALSE,FALSE,
185.192.69.57,London,England,GB,"51.5115,-0.0912",,EC4R,,pro,AS62240,Clouvider,clouvider.net,185.192.69.0/24,isp,Legaco Networks B.V.,legaconetworks.nl,business,,,,TRUE,FALSE,FALSE,FALSE,FALSE,

coderholic

IP IpInfo Likely
151.47.243.138 HU IT
176.72.110.242 AX FI
178.138.32.27 IT RO
178.237.161.9 NL GB
181.55.47.73 US CO
185.141.119.177 JP CN
187.188.51.243 US MX
188.73.246.37 AL GR
191.156.42.183 US CO

coderholic

{"domain": "google.com", "rank": "1", "title": "Google", "a": ["142.251.33.110"], "mx": ["10 aspmx.l.google.com.", "20 alt1.aspmx.l.google.com.", "30 alt2.aspmx.l.google.com.", "40 alt3.aspmx.l.google.com.", "50 alt4.aspmx.l.google.com."], "ns": ["ns1.google.com.", "ns2.google.com.", "ns3.google.com.", "ns4.google.com."], "aaaa": ["2607:f8b0:400a:805::200e"], "redirects": ["googlevideo.com", "business.site", "ancientsend.com", "eggglove.com", "mastermilligram.com", "shiftintercoursebridge.com", "primevalsymphonymuttering.com", "exceedinglydiscovered.com", "immigrantarchipelagopoetic.com", "fsalfrwdr.com", "aroundmonth.com", "clevermillercooperation.com", "humourchapter.com", "highperformancecpm.com", "doubleclick.net", "facilitategovernor.com", "googlesyndication.com", "chrome.com", "nest.com", "gmail.com", "trafficmoon.com", "believersheet.com", "inspirationhistorical.com", "mommygravelyslime.com", "feedburner.com", "simcast.com", "terretemplari.it", "localsingles.club", "doubleclick.com", "quellaplentyresol

coderholic

df

coderholic

create or replace secure function IPINFO.PUBLIC.to_join_key(ip text) returns integer as
\$\$
AS_INTEGER(PARSE_IP(CONCAT(ip, '/16'), 'inet'):ipv4_range_start)
\$\$
;

create or replace secure function IPINFO.PUBLIC.to_int(ip text) returns integer as
\$\$
AS_INTEGER(PARSE_IP(ip, 'inet'):ipv4)
\$\$

coderholic