Page 1 of 1

USA IP Addresses

PostPosted: Wed Jul 19, 2006 11:01 am
by abogarin
Is there a way to obtain the public IP addresses of USA.

I looked at the IP addresses listed by the ARIN, but they include other countries like Canada.

I need only the public IPs from USA.

PostPosted: Tue Aug 01, 2006 11:23 am
by robocoder
Once you've loaded the database (e.g., from mysql/hip_all.sql), this query should return the starting ip (of each /24) assigned to the US:
Code: Select all
SELECT ip FROM ip4 WHERE country = 226;
Converting from a long to a dotted IP address is shown here: