In the Preview release, Places Insights provides a sample dataset in a BigQuery data clean room which 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).
Each sample dataset is intended to allow you to try out Places Insights so that you can assess the usability and value of the product.
Each sample dataset has its own data clean room that you must subscribe to separately. For more information on subscribing to a clean room, 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.
Sample dataset region location
In BigQuery, datasets are stored in a specific region or multi-region location. A region is a collection of data centers within a geographical area, and a multi-region is a large geographic area that contains two or more geographic regions.
For the Preview release of Places Insights, the sample datasets are stored in
the US multi-region.
To perform a join, you can create a replica of your data in the US
multi-region. For more information on dataset replication, see Cross-region
dataset replication.
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".
Sample data for Preview
For the Preview release, the dataset for each country contains information for a top city. Even though the data is for a single city, the dataset schema is the same for the entire country.
The dataset only contains data for the city itself. It does not contain data for the surrounding metropolitan area.
Additional notes
The rating and user_rating_count data are statistics calculated using user
reviews. User reviews are not verified by Google, but Google checks for and
removes fake content when it's identified.
The dataset may not be accurate and is refreshed monthly.
Attribution requirements
When displaying Places Insights data, you must display the required attributions. For attribution requirements, see Policies for Places Insights.