# Database Downloads **URL:** https://community.ipinfo.io/c/docs/database-downloads/10.md [Latest](https://community.ipinfo.io/latest.md) · [Categories](https://community.ipinfo.io/categories.md) · [Tags](https://community.ipinfo.io/tags.md) --- ## [About the Database Downloads category](https://community.ipinfo.io/t/about-the-database-downloads-category/22)
**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\ **Replies:** 0
Documentation and technical guides on our downloadable database products --- ## [How to IP summarize an ASN using our free ASN database and IPinfo CLI](https://community.ipinfo.io/t/how-to-ip-summarize-an-asn-using-our-free-asn-database-and-ipinfo-cli/6514)
**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\ **Replies:** 4\ **Last updated:** [October 25, 2024, 7:09pm UTC](https://community.ipinfo.io/t/how-to-ip-summarize-an-asn-using-our-free-asn-database-and-ipinfo-cli/6514 "2024-10-25T19:09:53Z")
In my previous post, I described how I use our ASN API service to get the IP ranges of an ASN and then subsequently summarize those ranges to get an overview of the ASN. It is a super easy and powerful operation that … --- ## [Setting up a customer data upload to S3](https://community.ipinfo.io/t/setting-up-a-customer-data-upload-to-s3/1789)
**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\ **Replies:** 2\ **Last updated:** [July 26, 2024, 1:08pm UTC](https://community.ipinfo.io/t/setting-up-a-customer-data-upload-to-s3/1789 "2024-07-26T13:08:12Z")
There are two ways to set up an S3 data push from IPinfo to a customer, depending on whether the bucket is: Owned by IPinfo Owned by the customer The choice is left to the customer, based on their own preference. 1… --- ## [Lookup IP geolocation and ASN with ClickHouse and IPinfo's free database](https://community.ipinfo.io/t/lookup-ip-geolocation-and-asn-with-clickhouse-and-ipinfos-free-database/149)
**Author:** [@Max](https://community.ipinfo.io/u/Max)\ **Replies:** 2\ **Last updated:** [July 4, 2024, 12:09pm UTC](https://community.ipinfo.io/t/lookup-ip-geolocation-and-asn-with-clickhouse-and-ipinfos-free-database/149 "2024-07-04T12:09:09Z")
ClickHouse is a very fast columnar database which is well-suited to analytics use cases. For example, you might use ClickHouse to log requests made to a website. With IPinfo’s free databases you can enhance ClickHouse ab… --- ## [Getting all the ASNs of a country using our free IP to Country ASN database](https://community.ipinfo.io/t/getting-all-the-asns-of-a-country-using-our-free-ip-to-country-asn-database/5623)
**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\ **Replies:** 0\ **Last updated:** [May 7, 2024, 7:07am UTC](https://community.ipinfo.io/t/getting-all-the-asns-of-a-country-using-our-free-ip-to-country-asn-database/5623 "2024-05-07T07:07:02Z")
Downloading the CSV version of the IP to Country ASN database You can choose from many ways to download the IP to Country ASN database in CSV format. For example: Direct download from your account dashboard on our we… --- ## [Why do the numbers of columns not match between the CSV/JSON and MMDB files?](https://community.ipinfo.io/t/why-do-the-numbers-of-columns-not-match-between-the-csv-json-and-mmdb-files/5531)
**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\ **Replies:** 6\ **Last updated:** [March 19, 2024, 2:25am UTC](https://community.ipinfo.io/t/why-do-the-numbers-of-columns-not-match-between-the-csv-json-and-mmdb-files/5531 "2024-03-19T02:25:30Z")
Please read this blog first: How to choose the best file format for your IPinfo database? - IPinfo.io The MMDB file format is a special type of binary database, designed for efficient IP lookup and returning its IP … --- ## [IPinfo's join\_key column explained](https://community.ipinfo.io/t/ipinfos-join-key-column-explained/5526)
**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\ **Replies:** 0\ **Last updated:** [February 23, 2024, 10:44am UTC](https://community.ipinfo.io/t/ipinfos-join-key-column-explained/5526 "2024-02-23T10:44:21Z")
This was taken from an internal wiki. Feel free to drop a comment if you have specific questions or feedback. join\_key for IPv4 is /16 and for IPv6 is /34. The problem that join\_key tries to solve is to make joins … --- ## [Using IPinfo’s data downloads in PostgreSQL](https://community.ipinfo.io/t/using-ipinfo-s-data-downloads-in-postgresql/1000)
**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\ **Replies:** 0\ **Last updated:** [June 14, 2023, 2:27pm UTC](https://community.ipinfo.io/t/using-ipinfo-s-data-downloads-in-postgresql/1000 "2023-06-14T14:27:06Z")
Using our database in PostgreSQL involves the following steps: Using the IP4R extension for IP address lookups. Create a sample log table. Create the table for the IPinfo data ingestion and ingest the data there. Ru… --- ## [PostgreSQL: IP data lookup function](https://community.ipinfo.io/t/postgresql-ip-data-lookup-function/5000)
**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\ **Replies:** 2\ **Last updated:** [January 13, 2024, 11:30pm UTC](https://community.ipinfo.io/t/postgresql-ip-data-lookup-function/5000 "2024-01-13T23:30:16Z")
Our Snowflake listings package UDTF solutions facilitate an extremely fast IP lookup mechanism. These UDTFs consider the native functionalities offered by the Snowflake Database Platform. It is possible to create simila… --- ## [PostgreSQL: \`CREATE TABLE\` and \`CREATE FUNCTION\` (UDF) queries for IPinfo data downloads](https://community.ipinfo.io/t/postgresql-create-table-and-create-function-udf-queries-for-ipinfo-data-downloads/1003)
**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\ **Replies:** 0\ **Last updated:** [June 14, 2023, 3:16pm UTC](https://community.ipinfo.io/t/postgresql-create-table-and-create-function-udf-queries-for-ipinfo-data-downloads/1003 "2023-06-14T15:16:24Z")
Postgres CREATE TABLE queries for IPinfo data downloads We recommend you go through our Postgres doc first if you have not already: Using IPinfo’s data downloads in PostgreSQL You need to install the IP4R extension to u… --- ## [Querying IPinfo IP databases inside BigQuery](https://community.ipinfo.io/t/querying-ipinfo-ip-databases-inside-bigquery/4579)
**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\ **Replies:** 0\ **Last updated:** [December 20, 2023, 7:47pm UTC](https://community.ipinfo.io/t/querying-ipinfo-ip-databases-inside-bigquery/4579 "2023-12-20T19:47:17Z")
Querying IPinfo IP databases inside BigQuery We highly recommend that users not write their own code when querying our data inside BigQuery. These queries are often unoptimized and thus expensive. IP databases are speci… --- ## [Using IPinfo's MMDB data downloads with Golang](https://community.ipinfo.io/t/using-ipinfos-mmdb-data-downloads-with-golang/4415)
**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\ **Replies:** 0\ **Last updated:** [December 12, 2023, 1:36pm UTC](https://community.ipinfo.io/t/using-ipinfos-mmdb-data-downloads-with-golang/4415 "2023-12-12T13:36:47Z")
Using IPinfo’s MMDB data downloads with Golang The .mmdb file format is a special binary database type requiring specific packages/libraries to read. The .mmdb file format facilitates extremely fast IP lookup operations. … --- ## [Why the MMDB database does not include the IP range fields?](https://community.ipinfo.io/t/why-the-mmdb-database-does-not-include-the-ip-range-fields/3052)
**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\ **Replies:** 0\ **Last updated:** [September 26, 2023, 5:53pm UTC](https://community.ipinfo.io/t/why-the-mmdb-database-does-not-include-the-ip-range-fields/3052 "2023-09-26T17:53:11Z")
MMDB files are designed to provide IP information in a singular direction. If you take a look at our MMDB files, you might notice that we do not provide the start\_ip, end\_ip and the optional join\_key fields like we do… --- ## [Creating an ASN based IP bot traffic filterlist: Easily or for free](https://community.ipinfo.io/t/creating-an-asn-based-ip-bot-traffic-filterlist-easily-or-for-free/2271)
**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\ **Replies:** 4\ **Last updated:** [August 24, 2023, 5:28pm UTC](https://community.ipinfo.io/t/creating-an-asn-based-ip-bot-traffic-filterlist-easily-or-for-free/2271 "2023-08-24T17:28:05Z")
ASN-based bot/hosting IP detection is considered one of the most effective ways to prevent bot traffic from your site. ASN based bot detection ASN (Autonomous System Number) is a unique identifier for an organization … --- ## [Extracting specific fields from the MMDB database](https://community.ipinfo.io/t/extracting-specific-fields-from-the-mmdb-database/2395)
**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\ **Replies:** 0\ **Last updated:** [August 23, 2023, 7:54am UTC](https://community.ipinfo.io/t/extracting-specific-fields-from-the-mmdb-database/2395 "2023-08-23T07:54:02Z")
MMDB binary file format allows for efficient lookup, but it doesn’t provide the most versatility If you are using an MMDB reader library like: C C# Java Perl PHP Python Ruby Nodejs You can extract the specific fields … --- ## [IPinfo WHOIS data downloads offering](https://community.ipinfo.io/t/ipinfo-whois-data-downloads-offering/1961)
**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\ **Replies:** 0\ **Last updated:** [August 1, 2023, 5:35pm UTC](https://community.ipinfo.io/t/ipinfo-whois-data-downloads-offering/1961 "2023-08-01T17:35:09Z")
IPinfo offers a variety of WHOIS databases, all of which are structured, parsed and ready to be integrated into a data pipeline. IPinfo offers WHOIS data in two distinct categories: IPinfo WHOIS Summary data downloads: … --- ## [Checksum endpoint for data downloads](https://community.ipinfo.io/t/checksum-endpoint-for-data-downloads/1667)
**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\ **Replies:** 0\ **Last updated:** [July 18, 2023, 5:15pm UTC](https://community.ipinfo.io/t/checksum-endpoint-for-data-downloads/1667 "2023-07-18T17:15:41Z")
Verify the integrity of data downloads with our checksums API endpoint Checksum verification helps ensure the data download is complete and matches the available data hosted on IPinfo servers. Checksums support is helpf… --- ## [The radius field in the IP to Geolocation extended database explained](https://community.ipinfo.io/t/the-radius-field-in-the-ip-to-geolocation-extended-database-explained/694)
**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\ **Replies:** 0\ **Last updated:** [May 30, 2023, 7:19pm UTC](https://community.ipinfo.io/t/the-radius-field-in-the-ip-to-geolocation-extended-database-explained/694 "2023-05-30T19:19:36Z")
The radius field provides the accuracy confidence metric for IPinfo’s IP geolocation data The radius field is available in our IP to Geolocation Extended Database. The radius metric provides a metric for our confidenc… --- ## [IPinfo database in Postgres in under 1 minute](https://community.ipinfo.io/t/ipinfo-database-in-postgres-in-under-1-minute/998)
**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\ **Replies:** 0\ **Last updated:** [June 14, 2023, 2:10pm UTC](https://community.ipinfo.io/t/ipinfo-database-in-postgres-in-under-1-minute/998 "2023-06-14T14:10:17Z")
Using IPinfo’s IP to Country database in Postgres Preparation Open two terminal windows: One for standard bash or zsh Another one is for psql Get your access token ready. We will be using the free IP to Country databa… --- ## [How the domain field uniquely identifies organizations in the ASN and Company database](https://community.ipinfo.io/t/how-the-domain-field-uniquely-identifies-organizations-in-the-asn-and-company-database/401)
**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\ **Replies:** 0\ **Last updated:** [May 16, 2023, 12:17pm UTC](https://community.ipinfo.io/t/how-the-domain-field-uniquely-identifies-organizations-in-the-asn-and-company-database/401 "2023-05-16T12:17:38Z")
In the ASN and IP to Company database, the domain field is the unique identifier of organizations. We recommend users filter the ASN or the company database based on the domain field, as it is the most unique identifier … --- ## [Filter ASN database based on a single ASN](https://community.ipinfo.io/t/filter-asn-database-based-on-a-single-asn/393)
**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\ **Replies:** 0\ **Last updated:** [May 16, 2023, 9:18am UTC](https://community.ipinfo.io/t/filter-asn-database-based-on-a-single-asn/393 "2023-05-16T09:18:46Z")
Get IP addresses by looking up a single ASN from IP to ASN (Free) and the ASN database (Paid) If you want to filter the ASN database based on one ASN, follow the instructions below: Step 1: Download the CSV format of … --- ## [Filter ASN database based on multiple ASNs](https://community.ipinfo.io/t/filter-asn-database-based-on-multiple-asns/394)
**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\ **Replies:** 0\ **Last updated:** [May 16, 2023, 9:23am UTC](https://community.ipinfo.io/t/filter-asn-database-based-on-multiple-asns/394 "2023-05-16T09:23:21Z")
Get the IP addresses of multiple ASNs from the IP to ASN (Free) and the ASN database (Premium) If you want to create an AS-filtered database with a combination of multiple of ASes, follow the instructions below. Step … --- ## [Convert IPinfo’s CSV database to MMDB using mmdbctl](https://community.ipinfo.io/t/convert-ipinfo-s-csv-database-to-mmdb-using-mmdbctl/73)
**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\ **Replies:** 0\ **Last updated:** [April 20, 2023, 6:48pm UTC](https://community.ipinfo.io/t/convert-ipinfo-s-csv-database-to-mmdb-using-mmdbctl/73 "2023-04-20T18:48:54Z")
To convert an IPinfo CSV database to an MMDB database, you can use the mmdbctl utility tool. To convert a CSV file to an MMDB file use the import command: mmdbctl import --in data.csv --out data.mmdb Instructions, f… --- ## [How to get extract individual IP addresses from an IP range?](https://community.ipinfo.io/t/how-to-get-extract-individual-ip-addresses-from-an-ip-range/59)
**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\ **Replies:** 0\ **Last updated:** [April 4, 2023, 1:37pm UTC](https://community.ipinfo.io/t/how-to-get-extract-individual-ip-addresses-from-an-ip-range/59 "2023-04-04T13:37:53Z")
Disclaimer: Most IP operation does not involve expanding the IP address ranges to their individual IP address. You do not need de-aggregate the IP ranges to query them. To query IP address data your default choice should…