USA IP Addresses

General Discussion about IP Address Lookup caveats, technology, ideas, etc.

Moderator: Moderators

USA IP Addresses

Postby abogarin on Wed Jul 19, 2006 11:01 am

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.
abogarin
n00b
 
Posts: 1
Joined: Wed Jul 19, 2006 10:56 am

Postby robocoder on Tue Aug 01, 2006 11:23 am

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:
User avatar
robocoder
Veteran
 
Posts: 105
Joined: Sat Mar 25, 2006 8:10 pm
Location: Ontario, Canada


Return to IP Address Lookup

Who is online

Users browsing this forum: No registered users and 3 guests

cron