@ip-location-db/dbip-city

ip-location-db/dbip-city

Database	Type	License	Update	ipv4	ipv6	ipv4-num	ipv6-num
ASN	Country	CC0	Daily	asn-country-ipv4.csv	asn-country-ipv6.csv	asn-country-ipv4-num.csv	asn-country-ipv6-num.csv
GeoFeed + ASN	Country	CC0	Daily	geo-asn-country-ipv4.csv	geo-asn-country-ipv6.csv	geo-asn-country-ipv4-num.csv	geo-asn-country-ipv6-num.csv
GeoFeed + Whois + ASN	Country	CC0	Daily	geo-whois-asn-country-ipv4.csv	geo-whois-asn-country-ipv6.csv	geo-whois-asn-country-ipv4-num.csv	geo-whois-asn-country-ipv6-num.csv
IPtoASN	Country	PDDL by IPtoASN♣	Daily	iptoasn-country-ipv4.csv	iptoasn-country-ipv6.csv	iptoasn-country-ipv4-num.csv	iptoasn-country-ipv6-num.csv
DB-IP Lite	Country	CC BY 4.0 by DB-IP★	Monthly	dbip-country-ipv4.csv	dbip-country-ipv6.csv	dbip-country-ipv4-num.csv	dbip-country-ipv6-num.csv
DB-IP Lite	City	CC BY 4.0 by DB-IP★	Monthly	dbip-city-ipv4.csv.gz dbip-city-ipv4.csv.7z	dbip-city-ipv6.csv.gz dbip-city-ipv6.csv.7z	dbip-city-ipv4-num.csv.gz dbip-city-ipv4-num.csv.7z	dbip-city-ipv6-num.csv.gz dbip-city-ipv6-num.csv.7z
GeoLite2	Country	GeoLite2 License by MaxMind♥	Weekly	geolite2-country-ipv4.csv	geolite2-country-ipv6.csv	geolite2-country-ipv4-num.csv	geolite2-country-ipv6-num.csv
GeoLite2	City	GeoLite2 License by MaxMind♥	Weekly	geolite2-city-ipv4.csv.gz geolite2-city-ipv4.csv.7z	geolite2-city-ipv6.csv.gz geolite2-city-ipv6.csv.7z	geolite2-city-ipv4-num.csv.gz geolite2-city-ipv4-num.csv.7z	geolite2-city-ipv6-num.csv.gz geolite2-city-ipv6-num.csv.7z

CSV format

This project provides ip to location database in csv format.

Country csv format

ip_range_start, ip_range_end, country_code

City csv format

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

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.

ip address format

ip_range_start and ip_range_end is ip address.

• ipv4: The csv line 1.0.0.0,1.0.0.255,AU means that ip addresses between 1.0.0.0 and 1.0.0.255 inclusive are AU country_code.
• ipv4-num: The csv line 16777216,16777471,AU means that ip addresses between 1.0.0.0 and 1.0.0.255 inclusive are AU country_code. (16777216 is the number format of the ip address 1.0.0.0)
• ipv6: The csv line 2001:200::,2001:200:ffff:ffff:ffff:ffff:ffff:ffff,JP means that ip addresses between 2001:200:: and 2001:200:ffff:ffff:ffff:ffff:ffff:ffff inclusive are JP country_code.
• ipv6-num: The csv line 42540528726795050063891204319802818560,42540528806023212578155541913346768895,JP means that ip addresses between 2001:200:: and 2001:200:ffff:ffff:ffff:ffff:ffff:ffff inclusive are JP country_code. (42540528726795050063891204319802818560 is the number format of the ip address 2001:200::)

Please be careful when using ipv6 and ipv6-num in your program. The numerical value exceeds 32bit unsigned integer, so you need to use 64bit unsigned integer.

Databases referenced in this project

When merging multiple database, set the front database above back one. (ex. geo-whois-asn-...csv is created by merging 3 database with GeoFeed > Whois > ASN.)

ASN database [Update: Daily]

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

GeoFeed database [Update: Daily]

Created by merging GeoFeed database from OpenGeoFeed.

Whois database [Update: Daily]

Created by merging 5 RIP provided WHOIS database. There are some inconsistencies between 5 RIP.

IPtoASN^♣ database [Update: Hourly]

You can download hourly updated database in tsv format from original site. This is licensed under a Public Domain Dedication and Licence v1.0. There are some differences from above ASN database.

DB-IP^★ database [Update: Monthly]

You could download and read the license from ip-to-country-lite or ip-to-city-lite. These database are licensed under a Creative Commons Attribution 4.0 International License, so, you must create attribution to DB-IP.com for using this 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.

GeoLite2^♥ database [Update: Weekly]

GeoLite2 is created by MaxMind. The license of GeoLite2 is written in GEOLITE2_LICENSE and End User License Agreement (EULA) is written in GEOLITE2_EULA. Please carefully read the GEOLITE2_LICENSE and GEOLITE2_EULA files, if you use these database. This package comes with certain restrictions and obligations, most notably:

• You cannot prevent the library from updating the databases.
• You cannot use the GeoLite2 data:
  • for FCRA purposes,
  • to identify specific households or individuals.

If you need better accuracy, please use the commercial version GeoIp2.

Which database is recommended to use?

Of course, it depends on your use case. But the above list is too long, thus, we write down the recommendation.

• If you need postcode or timezone, geolite2-city is the one.
• If you need city data with CC-BY License, dbip-city is the one.
• If you need country database with Public Domain, we recommend geo-whois-asn-country database.

License

License depends on the database which you use. Please read carefully each database license. You can use PDDL (ODC Public Domain Dedication and Licence) or CC0 (Creative Commons Zero) licensed database without attribution for any purpose.

We are glad if you make a link to sapics/ip-location-db, or give us a star to the github repository.