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 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.

Field Name Type Mode Description Example
snapshot_date DATE NULLABLE The snapshot date for the place. 2024-01-01

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 tables list the supported cities and countries and provide links to subscribe. You can subscribe to sample data and full data for each city and country.

Sample data

City, Country Subscribe link Table names
Sydney, AustraliaAU

places_insights_historical___au___sample.places_sample_historical

Sao Paulo, BrazilBR

places_insights_historical___br___sample.places_sample_historical

Toronto, CanadaCA

places_insights_historical___ca___sample.places_sample_historical

Paris, FranceFR

places_insights_historical___fr___sample.places_sample_historical

Berlin, GermanyDE

places_insights_historical___de___sample.places_sample_historical

London, Great BritianGB

places_insights_historical___gb___sample.places_sample_historical

Mumbai, IndiaIN

places_insights_historical___in___sample.places_sample_historical

Jakarta, IndonesiaID

places_insights_historical___id___sample.places_sample_historical

Rome, ItalyIT

places_insights_historical___it___sample.places_sample_historical

Tokyo, JapanJP

places_insights_historical___jp___sample.places_sample_historical

Mexico City, MexicoMX

places_insights_historical___mx___sample.places_sample_historical

Madrid, SpainES

places_insights_historical___es___sample.places_sample_historical

Zurich, SwitzerlandCH

places_insights_historical___ch___sample.places_sample_historical

New York City, United StatesUS

places_insights_historical___us___sample.places_sample_historical