Places Insights provides full and sample datasets in BigQuery.
The sample listing includes the data for a top city for each of the supported countries: Sydney (AU), Sao Paulo (BR), Toronto (CA), Zurich (CH), Berlin (DE), Madrid (ES), Paris (FR), London (UK), Jakarta (ID), Mumbai (IN), Rome (IT), Tokyo (JP), Mexico City (MX), New York City (US).
The sample datasets are intended to allow you to try out Places Insights so that you can assess the usability and value of the product. The dataset only contains data for the city itself. It does not contain data for the surrounding metropolitan area.
The full datasets include data for each supported country.
Each dataset has its own listing that you must subscribe to separately. For more information on subscribing to a listing, see Set up Places Insights.
The datasets are designed for you to derive aggregated insights about places data based on a variety of attributes such as place types, ratings, store hours, wheelchair accessibility, and more. See the Schema reference.
Dataset schemas
The places dataset schema for each country is comprised of two parts:
- The core schema that is common to the datasets for all countries.
- A country-specific schema that defines schema components specific to that country.
For example, if you are working with the dataset for Spain (ES), reference both the core schema and the ES-specific schema.
The schema for the brands dataset defines three fields:
id: The brand ID.name: The name of the brand, such as "Hertz" or "Chase".category: The high-level category of the brand, such as "Gas Station", "Food and Drink", or "Lodging".
Attribution requirements
When displaying Places Insights data, you must display the required attributions. For attribution requirements, see Policies for Places Insights.