It is 0 otherwise.This article describes how to get country and city information using MaxMind‘s GeoIP technology. This is 1 if the country associated with the location is a member state of the European Union. The time zone associated with location, as specified by the IANA Time Zone Database, e.g., “America/New_York”. These are only available for networks in the US.
The metro code associated with the IP address. The city name for this location in the file's locale. As with the subdivision code, this is the most specific subdivision for the location. The subdivision name for this location in the file's locale. For example, in the United Kingdom this will be a a county like "Devon", not a country like "England". Some countries have two levels of subdivisions, in which case this is the most specific.
As with the subdivision code, this is the least specific subdivision for the location.Ī string of up to three characters containing the region-portion of the ISO 3166-2 code for the second level region associated with the IP address. For example, in the United Kingdom this will be a country like "England", not a county like "Devon". Some countries have two levels of subdivisions, in which case this is the least specific. The country name for this location in the file's locale.Ī string of up to three characters containing the region-portion of the ISO 3166-2 code for the first level region associated with the IP address. The continent name for this location in the file's locale.Ī two-character ISO 3166-1 country code for the country associated with the location. This will always correspond to the locale name of the file. The locale that the names in this row are in. This ID can be used as a key for the Location file. Learn more about accuracy on our knowledge base.Ī unique identifier for the a location as specified by GeoNames. The radius in kilometers around the specified location where the IP address is likely to be. The approximate WGS84 longitude of the location associated with the network. The approximate WGS84 latitude of the location associated with the network.
We offer a utility to convert this column to start/end IPs or start/end integers. Terms and pricing for the GeoIP2 City and GeoIP2 Country databases may be
Returned Values as Database, Map, Dict, or Hash Keysĭetermine the country, subdivisions (regions), city, and postal code associated.GeoIP2 and GeoLite City and Country Databases On this Page