MaxMind offers our GeoLite data through the [Snowflake Marketplace](https://app.snowflake.com/marketplace/providers/GZ2FTZ5POF7/MaxMind). 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 > **⚠️ Warning** > **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 | Data field name | Type | Data field 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::/64". | Country, City | | geoname_id | integer | A unique identifier for the network's location as specified by [GeoNames](https://www.geonames.org/). This ID can be used to look up the location information in the Location file. [Learn more about GeoNames IDs on our Knowledge Base.](https://support.maxmind.com/knowledge-base/articles/maxmind-ip-geolocation-data#geonames-ids) | 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](https://www.geonames.org/). This ID can be used to look up the location information in the Location file. [Learn more about registered countries on our Knowledge Base.](https://support.maxmind.com/knowledge-base/articles/country-level-and-city-level-geolocation-maxmind) | 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](https://www.geonames.org/). This ID can be used to look up the location information in the Location file. [Learn more about represented countries on our Knowledge Base.](https://support.maxmind.com/knowledge-base/articles/country-level-and-city-level-geolocation-maxmind) | Country, City | | is_anonymous_proxy | boolean | **Deprecated.** Please see our [GeoIP Anonymous IP database](https://www.maxmind.com/en/geoip-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: United States: 5, Canada: 3, United Kingdom: 2-4, Brazil: 5, Ireland: 3, Japan: 7 (specified for the first 6. The last digit defaults to 1), Netherlands: 4, Portugal: 7 (accurate for the first 4. The last 3 often defaults to `-001`), Singapore: 2 | City only | | latitude* | decimal | The approximate [WGS84](https://en.wikipedia.org/wiki/World_Geodetic_System) latitude of the location associated with the network. [Learn about the geolocation area defined by latitude, longitude, and accuracy radius, on our Knowledge Base.](https://support.maxmind.com/knowledge-base/articles/maxmind-ip-geolocation-data#geolocation-area) | City only | | longitude* | decimal | The approximate [WGS84](https://en.wikipedia.org/wiki/World_Geodetic_System) longitude of the location associated with the network. [Learn about the geolocation area defined by latitude, longitude, and accuracy radius, on our Knowledge Base.](https://support.maxmind.com/knowledge-base/articles/maxmind-ip-geolocation-data#geolocation-area) | City only | | 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.](https://support.maxmind.com/knowledge-base/articles/maxmind-ip-geolocation-data#geolocation-area) | City only | | is_anycast | boolean | This is `1` if the network is an [anycast network](https://en.wikipedia.org/wiki/Anycast). This column will be empty in GeoLite2-Country and GeoLite2-City. | Country, City | _\* The coordinates are not precise and should not be used to identify a particular street address or household. To better represent a level of accuracy, please include the `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._ | Data field name | Type | Data field description | Included in... | |------|------|-------------|-------------| | geoname_id | integer | A unique identifier for the location as specified by [GeoNames](https://www.geonames.org/). This ID can be used as a key for the Location file. [Learn more about GeoNames IDs on our Knowledge Base.](https://support.maxmind.com/knowledge-base/articles/maxmind-ip-geolocation-data#geonames-ids) | 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: **AF** - Africa, **AN** - Antarctica, **AS** - Asia, **EU** - Europe, **NA** - North America, **OC** - Oceania, **SA** - South America | 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.](https://support.maxmind.com/knowledge-base/articles/maxmind-ip-geolocation-data#names) | Country, City | | country_iso_code | string (2) | A two-character [ISO 3166-1](https://en.wikipedia.org/wiki/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.](https://support.maxmind.com/knowledge-base/articles/maxmind-ip-geolocation-data#names) | 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](https://en.wikipedia.org/wiki/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". | City only | | 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.](https://support.maxmind.com/knowledge-base/articles/maxmind-ip-geolocation-data#names) | City only | | subdivision_2_iso_code | string (1-3) | A string of up to three characters containing the region-portion of the [ISO 3166-2](https://en.wikipedia.org/wiki/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". | City only | | 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.](https://support.maxmind.com/knowledge-base/articles/maxmind-ip-geolocation-data#names) | City only | | city_name | string | The city name for this location in the file's locale. [Learn more about localized names on our Knowledge Base.](https://support.maxmind.com/knowledge-base/articles/maxmind-ip-geolocation-data#names) | City only | | metro_code | integer | **Deprecated.** This is a no-longer-maintained code for targeting advertisements in Google. | City only | | time_zone | string | The time zone associated with location, as specified by the [IANA Time Zone Database](https://www.iana.org/time-zones), e.g., "America/New_York". | City only | | 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::/64”.
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](https://www.maxmind.com/en/snowflake-geolite-terms-of-use). Please note that this is different from the GeoLite 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](https://support.maxmind.com/knowledge-base/articles/maxmind-ip-geolocation-data).