GeoLite on Snowflake
MaxMind offers our GeoLite data through the Snowflake Marketplace. If you do not have an existing Snowflake account, you will need to create one before requesting access to the GeoLite datasets. Once approved, you will be able to query GeoLite data within Snowflake.
The GeoLite Country and City datasets are updated twice weekly, every Tuesday and Friday. The GeoLite ASN dataset is updated daily.
IP geolocation accuracy
IP Geolocation Usage
IP geolocation is inherently imprecise. Locations are often near the center of the population. Any location provided by a GeoIP database should not be used to identify a particular address or household.
Use the Accuracy Radius as an indication of geolocation accuracy for the latitude and longitude coordinates we return for an IP address. The actual location of the IP address is likely within the area defined by this radius and the latitude and longitude coordinates.
GeoLite dataset
The GeoLite dataset contains geolocation and ASN data depending on the particular dataset you are querying:
Geolocation data
| Name | Type | Description | Included in... |
|---|---|---|---|
| network | IP network as a string | This is the IPv4 or IPv6 network in CIDR format such as "2.21.92.0/29" or "2001:4b0::/80". We offer a utility to convert this column to start/end IPs or start/end integers. See the conversion utility section for details. | Country City |
| geoname_id | integer | A unique identifier for the network's location as specified
by
GeoNames
. This ID can be
used to look up the location information in the Location file. Learn more about GeoNames IDs on our Knowledge Base. | Country City |
| registered_country_geoname_id | integer | The registered country is the country in which the ISP has
registered the network. This column contains a unique identifier
for the network's registered country as specified
by
GeoNames
. This ID can be
used to look up the location information in the Location file. Learn more about registered countries on our Knowledge Base. | Country City |
| represented_country_geoname_id | integer | The represented country is the country which is represented by
users of the IP address. For instance, the country represented by
an overseas military base. This column contains a unique
identifier for the network's represented country as specified
by
GeoNames
. This ID can be
used to look up the location information in the Location file. Learn more about represented countries on our Knowledge Base. | Country City |
| is_anonymous_proxy | boolean | Deprecated. Please see our GeoIP2 Anonymous IP database to determine whether the IP address is used by an anonymizing service. | Country City |
| is_satellite_provider | boolean | Deprecated. | Country City |
| postal_code | string | A postal code close to the user's location. For the following
countries, we return partial postal codes with the number of
characters indicated below:
| Country City |
| latitude* | decimal | The approximate
WGS84
latitude of the location associated with the network. Learn about the geolocation area defined by latitude, longitude, and accuracy radius, on our Knowledge Base. | Country City |
| longitude* | decimal | The approximate
WGS84
longitude of the location associated with the network. Learn about the geolocation area defined by latitude, longitude, and accuracy radius, on our Knowledge Base. | Country City |
| accuracy_radius | integer | The radius in kilometers around the specified location where the IP
address is likely to be. Learn about the geolocation area defined by latitude, longitude, and accuracy radius, on our Knowledge Base. | Country City |
| is_anycast | boolean | This is
1
if the network is an
anycast network
.This column will be empty in GeoLite2-Country and GeoLite2-City. | Country City |
accuracy_radius when displaying latitude and
longitude and make it clear that the coordinates refer to a larger
geographical area instead of a precise location.| Name | Type | Description | Included in... |
|---|---|---|---|
| geoname_id | integer | A unique identifier for the a location as specified
by
GeoNames
. This ID can be
used as a key for the Location file. Learn more about GeoNames IDs on our Knowledge Base. | Country City |
| locale_code | string | The locale that the names in this row are in. This will always correspond to the locale name of the file. | Country City |
| continent_code | string (2) | The continent code for this location. Possible codes are:
| Country City |
| continent_name | string | The continent name for this location in the file's locale. Learn more about localized names on our Knowledge Base. | Country City |
| country_iso_code | string (2) | A two-character ISO 3166-1 country code for the country associated with the location. | Country City |
| country_name | string | The country name for this location in the file's locale. Learn more about localized names on our Knowledge Base. | Country City |
| subdivision_1_iso_code | string (1-3) | A 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. Some countries have two levels of subdivisions, in which case this is the least specific. For example, in the United Kingdom this will be a country like "England", not a county like "Devon". | |
| subdivision_1_name | string | The subdivision name for this location in the file's locale.
As with the subdivision code, this is the least specific
subdivision for the location. Learn more about localized names on our Knowledge Base. | |
| subdivision_2_iso_code | string (1-3) | A 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. Some countries have two levels of subdivisions, in which case this is the most specific. For example, in the United Kingdom this will be a a county like "Devon", not a country like "England". | |
| subdivision_2_name | string | The subdivision name for this location in the file's locale.
As with the subdivision code, this is the most specific subdivision
for the location. Learn more about localized names on our Knowledge Base. | |
| city_name | string | The city name for this location in the file's locale. Learn more about localized names on our Knowledge Base. | |
| metro_code | integer | Metro code is a geolocation target code from Google. | |
| time_zone | string | The time zone associated with location, as specified by the IANA Time Zone Database , e.g., “America/New_York”. | |
| is_in_european_union | boolean | This is
1
if the country associated with the location is a member
state of the European Union. It is
0
otherwise. | Country City |
ASN data
| Name | Type | Description |
|---|---|---|
| network | IP network as a string | This is the IPv4 or IPv6 network in CIDR format such as “2.21.92.0/29” or “2001:4b0::/80”. We offer a utility to convert this column to start/end IPs or start/end integers. See the conversion utility section for details. |
| autonomous_system_number | integer | The autonomous system number associated with the IP address. Learn more about autonomous system data on our Knowledge Base. |
| autonomous_system_organization | string | The organization associated with the registered autonomous system
number for the IP address. Learn more about autonomous system data on our Knowledge Base. |
License
GeoLite data offered through the Snowflake Marketplace is subject to the MaxMind Services Terms of Use for the Snowflake Platform. Please note that this is different from the GeoLite2 End User License Agreement, which governs the use of GeoLite databases and web services served directly from MaxMind.
Support
MaxMind does not provide official support for our free GeoLite dataset, but the documentation for our data on Snowflake includes sample queries and important information about how to use GeoLite on Snowflake.
For general questions about how to interpret specific GeoLite data points beyond what is documented in Snowflake, please consult the appropriate section of the MaxMind Knowledge Base.