ip-location-db/dbip-city

Download

Database	Type	License	Updated	IPv4	IPv6	IPv4-num	IPv6-num
DB-IP Lite	City	CC BY 4.0 by DB-IP	Monthly	CSV.gz CSV.7z MMDB	CSV.gz CSV.7z MMDB	CSV.gz CSV.7z	CSV.gz CSV.7z

CSV Format

ip_range_start, ip_range_end, country_code, city, state1, state2, latitude, longitude, postcode, timezone

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.