IP Geolocation Database

IPnews-IP geolocation database provides you with accurate data insights to meet your various business needs. Data services provided to product architects, developers, etc., including IP geolocation data such as countries, cities, regions, latitude and longitude, time zones, operators, etc.

Database Schema

The database contains the following fields:

Name
Data Type
Description

country

TEXT

Country name.

country_code

TEXT

Two-character country code based on ISO 3166.

region

TEXT

Region or state name.

city

TEXT

City name.

latitude

FLOAT

City latitude. Defaults to capital city latitude if city is unknown.

longitude

FLOAT

City longitude. Defaults to capital city longitude if city is unknown.

isp

TEXT

Internet Service Provider or company's name.

time_zone

TEXT

Current region's time zone.

area_code

TEXT

A varying length number assigned to geographic areas for calls between cities.

postal

TEXT

ZIP/Postal code.

weather_station_code

TEXT

The special code to identify the nearest weather observation station.

elevation

TEXT

Average height of city above sea level in meters (m).

currency

TEXT

Currency of the country.

eu_member

BOOLEAN

Whether it belongs to the European Union.

country_capital

TEXT

The name of the current country's capital.

radius

TEXT

The current query positioning radius.

Last updated