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.

Setup

Historical Places Insights data is available for the cities listed in the table below . See Set up Places Insights for additional instructions on how to subscribe to these data exchanges.

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 notinclude 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_historical___us.places_historical` 
 WHERE 
  
 'restaurant' 
  
 IN 
  
 UNNEST 
 ( 
 types 
 ) 
 AND 
  
 business_status 
  
 = 
  
 "OPERATIONAL" 
 GROUP 
  
 BY 
  
 snapshot_date 
 ORDER 
  
 BY 
  
 snapshot_date 
  
 ASC 
 ; 

Available listings

The following table lists the supported cities and provides links to subscribe.

Sample data