ip-location-db/dbip-geo-whois-asn-country

Download

| Database | Type | License | Updated | IPv4 | IPv6 | IPv4-num | IPv6-num | |---|---|---|---|---|---|---|---| | DB-IP Lite + GeoFeed + Whois + ASN| Country | CC BY 4.0 by DB-IP | Monthly | CSVMMDB | CSVMMDB | CSV | CSV |

CSV Format

ip_range_start, ip_range_end, country_code

ip_range_start and ip_range_end are either IP addresses, or IP addresses in numeric format (depending upon which files you choose) and these two fields represent an inclusive range of IP addresses for that data row.

For example, in the -ipv4.csv files, the CSV line: 1.0.0.0,1.0.0.255,AU would mean that any IP addresses between 1.0.0.0 and 1.0.0.255 (inclusive) are AU. In -ipv4-num.csv files, the equivalent line would be: 16777216,16777471,AU.

For example, in the -ipv6.csv files, the CSV line: 2001:200::,2001:200:ffff:ffff:ffff:ffff:ffff:ffff,JP would mean that any IP addresses between 2001:200:: and 2001:200:ffff:ffff:ffff:ffff:ffff:ffff (inclusive) are JP. In -ipv6-num.csv files, the equivalent line would be: 42540528726795050063891204319802818560,42540528806023212578155541913346768895,JP.

Please be careful when using IPv6 and IPv6-num files in your program, the numerical value exceeds 32bit unsigned integers, and you would need to use a 128bit unsigned integer.

country_code

country_code is the two-letter code defined in ISO 3166-1 alpha-2. You can get the country name, capital, continent, currency, languages, etc. from the country_code by Countries Database in JSON, CSV, SQL format.

Referenced Database and License

DB-IP database [Update: Monthly]

You could download and read the license from ip-to-asn-lite or ip-to-country-lite or ip-to-city-lite. Most of the AS Organization name used in asn uses ip-to-asn-lite database. We also use ip-to-asn-lite to get AS Number from ip address as a supplemental.

These database are licensed under a CC BY 4.0, so, you must create attribution to DB-IP.com for using DB-IP database. In the case of a web application, you must include a link back to DB-IP.com on pages that display or use results from the database. You may do it by pasting the HTML code snippet into your code: <a href='https://db-ip.com/'>IP Geolocation by DB-IP</a>. If you need better accuracy or no attribution or daily updates, please use the Commercial Version of db-ip.

GeoFeed database [Update: Daily]

Created by merging GeoFeed database from OpenGeoFeed and Collections of provider geofeed and so on.

Whois dastabase [Update: Daily]

Created by merging 5 RIP (afrinic, apnic, arin, lacnic, ripe ncc) provided WHOIS database.

ASN database [Update: Daily]

Created by merging 5 RIP (afrinic, apnic, arin, lacnic, ripe ncc) IP-ASN-Country database. ASN (Autonomous System Number) is a unique number assigned to an Autonomous System (AS) by the IANA.

Merge rule for multiple database

When merging multiple database, set the front database above back one. For example, geo-whois-asn-country is created by merging 3 database with GeoFeed > Whois > ASN. In more detail, the geo-whois-asn database matches the GeoFeed results, for ip ranges not covered by GeoFeed it matches the Whois results, and for ip ranges not covered by either it matches the ASN results.

GeoFeed: 1.0.0.0, 2.0.0.0, AU
         3.0.0.1, 4.0.0.0, US
Whois:   1.0.0.0, 2.2.0.0, FR
         2.5.0.1, 4.0.0.0, IN
ASN:     1.0.0.0, 4.0.0.0, JP

is converted to

GeoFeed-Whois-ASN: 1.0.0.0, 2.0.0.0, AU
                   2.0.0.1, 2.2.0.0, FR
                   2.2.0.1, 2.5.0.0, JP
                   2.5.0.1, 3.0.0.0, IN
                   3.0.0.1, 4.0.0.0, US