Show HN: Free IP to Country and ASN Downloads from Ipinfo.io

24 points by coderholic 3 years ago | 4 comments

Free IP to Country and ASN Data downloads:

  - MMDB, CSV and JSON format
  - Full accuracy (not degraded quality compared to our paid downloads)
  - IPv4 and IPv6 data
  - A single file that includes both country and ASN details
  - Daily updated
  - CC Attribution license (no usage restrictions, only requirement is a link back to ipinfo.io)

Here's an example of querying the MMDB file using our mmdbctl tool:

    $ echo "1.1.1.1" | mmdbctl read country_asn.mmdb | jq .
    {
      "as_domain": "cloudflare.com",
      "as_name": "Cloudflare, Inc.",
      "asn": "AS13335",
      "continent": "NA",
      "continent_name": "North America",
      "country": "US",
      "country_name": "United States"
    }

Almost 8 years ago I launched the free IPinfo.io free geolocation API, but until now our data downloads have only been available to our enterprise customers. I'm really happy to be able to offer a subset of our data for free, and excited to see what projects this gets used in! Read more about this on our blog: https://ipinfo.io/blog/meet-free-ip-address-database/

Any feedback please shoot me an email: ben@ipinfo.io

anyfactor 3 years ago |

I would really love some feedback and queries from HN.

I have been in HN for a while now, and through absolute wild luck Ben hired me because, get this.... he liked a comment I made on HN. But that is another story....

I am the first DevRel hire of IPinfo and this is the first product launch that we did that celebrates the developer experience.

So, any feedback you have in regard to documentation, technical resources and using this boatload of data, please, let me know. Thank you.

chatmasta 3 years ago | |

This is really cool! I've always found IP data to be a compelling example of a data product, especially when talking about Splitgraph, a company of which I'm a co-founder (and btw - I also met my co-founder on HN!).

So, I exported the CSV files for country and asn data, and then uploaded them to Splitgraph. You can see some sample queries in the readme of the repository [0]. Since Splitgraph is built on Postgres, it's possible to use all the `inet` and `cidr` tools available from Postgres, so you can make range queries easily. One sample query also demonstrates a join between the two tables, resulting in the equivalent of your combined country_asn.csv.

Another idea: We have a newer project called Seafowl [1], which is an open-source analytical database optimized for running "at the edge," with cache-friendly semantics making it ideal for querying from Web applications. We don't have a SaaS version of this yet, so you'll need to host it yourself, but perhaps the next thing to try would be loading this data into Seafowl and querying it "at the edge" - I've been thinking about ways that we could package Seafowl along as an OpenResty module, which could allow for true "at the edge" use cases like querying IP data in your reverse proxy. (Although the .mmdb format already solves this particular problem pretty efficiently and interoperably, although I'd be curious to measure the difference).

[0] https://www.splitgraph.com/miles/ipinfo-country-asn

[1] https://seafowl.io/

anyfactor 3 years ago | | |

Really appreciate the support you have shown us. Splitgraph was the very first platform to adopt our free IP database. That means a lot. Hoping that it would be super helpful Splitgraph users. Thank you :)

roberdam 3 years ago |

This is awesome, thanks!!