Skip to content

Instantly share code, notes, and snippets.

View coderholic's full-sized avatar

Ben Dowling coderholic

260 followers · 24 following
View GitHub Profile
@coderholic
coderholic / continents.json
Created July 22, 2022 20:04 — forked from cmunns/continents.json
Continental GeoJson
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@coderholic
coderholic / example.json
Created April 28, 2022 22:04
{
"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 / gb_isp_vpn.csv
Created March 17, 2022 16:41
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
coderholic / foo.csv
Created March 17, 2022 16:40
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
coderholic / gist:79f9028f38d6dec26493d05290921485
Created March 17, 2022 16:39
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
coderholic / gist:14a3ca8d54a9c2d7b64bd157c25bd441
Created February 3, 2022 18:15
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
coderholic / top1000.json
Created January 5, 2022 03:17
This file has been truncated, but you can view the full file.
{"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
coderholic / gist:fd5de6a3dd65a2e60b0870d9af57329f
Created April 23, 2021 02:38
df
@coderholic
coderholic / udf.sql
Created March 18, 2021 03:42
IPinfo.io Snowflake UDFs
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
coderholic / neustar_proxy.csv
Created March 17, 2021 16:44
ip anonymizer_status proxy_level proxy_type proxy_last_detected
97 64.111.26.213 64.111.26.213 private elite service 10/18/18
132 199.115.114.74 199.115.114.74 private elite service 11/5/20
316 89.187.178.8 89.187.178.8 private elite service 11/5/20
807 198.255.45.131 198.255.45.131 private elite service 2/9/21
815 66.42.92.141 66.42.92.141 private elite service 12/6/20
816 198.134.107.197 198.134.107.197 private elite service 2/20/20
1773 185.220.21.28 185.220.21.28 private elite service 2/9/21
1831 45.92.9.20 45.92.9.20 private elite service 11/5/20
2108 185.59.223.0 185.59.223.0 private elite service 10/10/19