Historical data overview

Monthly historical Places Insights data is available starting from January 2024. This data is useful for performing trends analysis to understand how the places in an area have changed from month to month. By tracking how businesses and points of interest change over time, users can identify emerging economic clusters and shifts in local market dynamics.

Setup

Historical Places Insights data is available as part of Places Insights. See Set up Places Insights for instructions on how to subscribe to and set up Places Insights.

Schema

The schema for historical Places Insights data is the same as for the latest data (see Places Insights reference), with the following exceptions.

Excluded fields

The schema for historical Places Insights data does not include rating or user_rating_count.

Additional fields

The schema for historical Places Insights data includes the following field in addition to the core schema.

Example queries

As with the latest data, the SELECT statement when querying historical data must include WITH AGGREGATION_THRESHOLD. (See Write a Places Insights query). Additionally, you will likely want to GROUP BY snapshot_date. The following example shows how to query for the number of operational restaurants by month.

SELECT WITH AGGREGATION_THRESHOLD
  snapshot_date,
  COUNT(*) AS count
FROM
  `PROJECT_NAME.places_insights___us.places_historical`
WHERE
  'restaurant' IN UNNEST(types)
AND
  business_status = "OPERATIONAL"
GROUP BY snapshot_date
ORDER BY snapshot_date ASC;

Available listings

The historical Places Insights table is available in the respective Places Insights BigQuery listing by country.

To browse and subscribe to the data exchanges for your region, see the setup instructions in Set up Places Insights.