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 / ipinfo_proxy.csv
Created March 17, 2021 16:44
ip as_prefix vpn
69.210.66.236 TRUE
130.52.192.4 130.52.192.0/21 TRUE
202.146.25.38 202.146.25.0/24 TRUE
63.236.68.4 63.236.68.0/24 TRUE
63.118.77.254 63.118.77.0/24 TRUE
68.235.221.231 68.235.221.0/24 TRUE
129.41.87.6 129.41.87.0/24 TRUE
129.41.87.3 129.41.87.0/24 TRUE
129.33.198.166 129.33.198.0/24 TRUE
@coderholic
coderholic / maxmind_proxy.csv
Created March 17, 2021 16:44
ip_address network is_anonymous_vpn is_tor_exit_node is_hosting_provider is_public_proxy is_residential_proxy
18.188.251.165 18.188.224.0/19 1 1
93.120.126.106 93.120.96.0/19 1
185.220.21.28 185.220.21.0/24 1 1
192.223.27.147 192.223.27.0/24 1
54.236.1.13 54.236.1.0/24 1 1
193.56.117.20 193.56.117.0/24 1 1
184.170.246.176 184.170.246.0/24 1
162.255.233.21 162.255.233.0/24 1
181.215.65.187 181.215.64.0/22 1 1
@coderholic
coderholic / -
Created March 12, 2021 02:01
{"country":"US","is_org":"t","name":"internet ar12-13.dnvrcoet","network":"208.187.182.0/23","input":"208.187.183.218"}
{"country":"US","is_org":"t","name":"AR12/13.TKWLWAZS INTERNET AGGREGATE NETBLOCK","network":"209.210.220.0/22","input":"209.210.222.236"}
{"country":"US","is_org":"t","name":"CITY OF CHARLESTON - CHS","network":"209.215.118.128/27","input":"209.215.118.130"}
{"country":"US","is_org":"t","name":"Secure Information Management Inc","network":"209.217.203.136/29","input":"209.217.203.139"}
{"country":"US","is_org":"t","name":"HermeTek Network Solutions","network":"216.172.102.64/26","input":"216.172.102.122"}
{"country":"IN","is_org":"t","name":"Curacy Telecom Ltd","network":"220.158.140.0/22","input":"220.158.143.126"}
{"country":"US","is_org":"t","name":"San Francisco Cloud","network":"209.209.238.0/24","input":"209.209.238.164"}
{"country":"JP","is_org":"t","name":"Azbil Corpration","network":"210.162.143.192/26","input":"210.162.143.227"}
{"country":"US","is_org":"t","name":"Sanborn Telepho
@coderholic
coderholic / -
Created March 12, 2021 02:00
{"country":"CH","is_org":"","name":"SITA, Chemin de Joinville 26, 1216 Cointrin","network":"57.188.8.0/24","input":"57.188.8.21"}
{"country":"CH","is_org":"","name":"SITA, Chemin de Joinville 26, 1216 Cointrin","network":"57.188.8.0/24","input":"57.188.8.33"}
{"country":"CH","is_org":"","name":"SITA, Chemin de Joinville 26, 1216 Cointrin","network":"57.188.8.0/24","input":"57.188.8.58"}
{"country":"DE","is_org":"t","name":"Vereinte Nationen Der Hohe Fluchtlingskommissar","network":"62.96.12.88/29","input":"62.96.12.90"}
{"country":"DE","is_org":"t","name":"Libelle AG","network":"62.96.90.32/29","input":"62.96.90.34"}
{"country":"ES","is_org":"t","name":"INVISALIGN SA","network":"62.97.88.80/29","input":"62.97.88.84"}
{"country":"SE","is_org":"t","name":"Enterprise Customer","network":"77.244.8.0/23","input":"77.244.8.45"}
{"country":"ES","is_org":"t","name":"TELE CAUDAL S.L.","network":"77.83.96.0/22","input":"77.83.99.25"}
@coderholic
coderholic / -
Created February 24, 2021 05:19
test
@coderholic
coderholic / test_maxmind.js
Created October 7, 2020 03:23
const mmap = require('mmap-io')
const { noop } = require('lodash')
const fs = require('fs')
const maxmind = require('maxmind')
const fake_cache = {
get: noop,
set: noop
}
@coderholic
coderholic / ipinfo_resolv.sh
Created September 30, 2020 00:03
Bulk hostname resolution with the IPinfo.io bulk endpoint
#!/bin/bash
sed 's/$/\/hostname/' | parallel --jobs=12 --pipe -N1000 \
"curl -s -XPOST -H 'Content-Type: text/plain' --data-binary @- 'ipinfo.io/batch?token=$TOKEN&filter=1'" | \
grep '"' | sed 's|/hostname||' | cut -d'"' -f2,4 | tr '"' '\t'
@coderholic
coderholic / coords.tsv
Created September 2, 2020 02:46
102.88.1.128 6.4541,3.3947 3.3211,6.5821
103.108.228.24 -37.8140,144.9633 -37.82301,144.915351
103.113.56.151 35.6330,139.4997 35.68628,139.7679
103.121.34.125 -46.1500,168.3333 -36.849310,174.765470
103.202.216.11 35.6895,139.6917 35.686,139.689
103.216.221.19 22.2783,114.1747 22.365560,114.119325
103.216.223.22 1.2897,103.8501 1.336920,103.893158
103.219.7.241 -37.8140,144.9633 -37.822500,144.931944
103.25.56.18 -34.9287,138.5986 -34.926537,138.594216
103.25.58.11 -33.8678,151.2073 -33.911790,151.193252
@coderholic
coderholic / example.md
Created July 22, 2020 04:50
Host.io Example API Output
@coderholic
coderholic / snowflake_examples.md
Last active June 4, 2020 20:55
Snowflake IP geolocation query examples

Location table (IP geolocation)

Get the country for an IP address in a log table using the free location_lite table:

select a.*, b.country from log a 
join location_lite b on PARSE_IP(a.ip, 'INET'):ipv4 
between b.start_ip_int AND b.end_ip_int
+--------------+------------------+---------+
| IP           | LOG              | COUNTRY |