🔗 Website: ip.js0.ch
This project covers all IPv4 and IPv6 addresses worldwide and outputs 23 different criteria over this IP. The database was kept as minimal as possible, so that it can be operated performantly even on servers without much computing power. The database is usually updated about once a month.
I also provide a free, unlimited API to test the database. It can be found on the project website ip.js0.ch.
Sample SQL Query (Used in API):
(Replace {{IP IN DECIMAL}} with your IP in decimal Format)
SELECT (ip.decimal_end-ip.decimal_start) AS ip_range,
ip.ip_start AS ip_rangeStart,
ip.ip_end AS ip_rangeEnd,
ip.lon AS loc_lon,
ip.lat AS loc_lat,
ip.region AS loc_region,
ip.city AS loc_city,
ip.zip AS loc_zip,
ip.asn AS asn_id,
asn.name AS asn_name,
asn.type AS asn_type,
asn.isp AS asn_isp,
ip.countryCode AS loc_countryCode,
country.countryCode3 AS loc_countryCode3,
country.countryCode AS loc_countryCodeDecimal,
country.region AS loc_countryRegion,
country.regionCode AS loc_countryRegionCode,
country.subregion AS loc_countrySubRegion,
country.subregionCode AS loc_countrySubRegionCode,
country.language AS loc_language,
country.currencies AS loc_currencies,
country.callingCode AS loc_callingCode,
country.name AS loc_countryName
FROM ip
LEFT JOIN asn ON ip.asn = asn.id
LEFT JOIN country ON ip.countryCode = country.id
WHERE ip.decimal_start {{IP IN DECIMAL}}
ORDER BY ip.decimal_start DESC
LIMIT 1
| File | Link 1 | Link 2 |
|---|---|---|
| SQL Database Dump | GitHub | RAW |
| CSV Combined | GitHub | RAW |
| CSV IP | GitHub | RAW |
| CSV ASN | GitHub | RAW |
| CSV Country | GitHub | RAW |
| TSV Combined | GitHub | RAW |
| TSV IP | GitHub | RAW |
| TSV ASN | GitHub | RAW |
| TSV Country | GitHub | RAW |