[data updated as of August, 2022]
The following database schema represents the CSV database. We also provide JSON and MMDB format data.
| Field Name | Example | Data Type | Notes |
|---|---|---|---|
start_ip |
1.253.242.0 | TEXT | Starting IP address of an IP address range |
end_ip |
1.253.242.255 | TEXT | Ending IP address of an IP address range |
join_key |
1.253.0.0 | TEXT | Special variable to facilitate join operation |
city |
Yangsan | TEXT | City of the location |
region |
Gyeongsangnam-do | TEXT | Region of the location |
country |
KR | TEXT | ISO 3166 country code |
latitude |
35.34199 | FLOAT | Latitude value of the location |
longitude |
129.03358 | FLOAT | Longitude value of the location |
postal_code |
50593 | TEXT | Postal code of the location |
timezone |
Asia/Seoul | TEXT | Local time zone |
join_key→ This key represents the Class C network each IP address is part of, allowing you to filter the result set significantly before filtering to the exact IP address you want. [Source]
IP address data like start_ip, end_ip and join_key should be assigned inet data type if you are ingesting the data in PostgreSQL.
As well as the database product, IPinfo also provides a robust API service. Please visit the IPinfo Documentation portal to learn more.
$ curl ipinfo.io/IP_ADDRESS?token=TOKEN
- [CSV Database] IP Geolocation Database Sample
- [JSON Database] IP Geolocation Database Sample
- [MMDB Database] IP Geolocation Database Sample
- [API] IP Geolocation API Response Sample
🔗 IP Geolocation Database Page
🔗 IP Geolocation Data Type Documentation
- Top ways to use IP geolocation data
- How to develop a mobile app with a geolocation feature
- How to use IP address data for digital media and entertainment
- Breaking Down Geographic Market Segmentation and How to Utilize it
- How many IPs changed geolocation over a year
- How to use IP address data for better PPC geotargeting
- How the travel industry can use IP address data to save money
- How to prevent localized pricing policy abuse
- 6 common geolocation marketing mistakes & how to solve them
Currently, we are limiting the sample datasets to only 100 rows. If you would like to request a larger sample or would like to get a quote on the database products, feel free to reach to us.
Follow us on Twitter and LinkedIn to learn more about IP Address data and it’s fascinating potential.
Founded in 2013, IPinfo prides itself on being the most reliable, accurate, and in-depth source of IP address data available anywhere. We process terabytes of data to produce our custom IP geolocation, company, carrier, VPN detection, hosted domains, and IP type data sets. Our API handles over 40 billion requests a month for 100,000 businesses and developers.
