science This product or feature is in Experimental (pre-GA). Pre-GA products and features might have limited support, and changes to pre-GA products and features might not be compatible with other pre-GA versions. Pre-GA Offerings are covered by the Google Maps Platform Service Specific Terms. For more information, see the launch stage descriptions. Sign up to test Places Insights!
Stay organized with collections
Save and categorize content based on your preferences.
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 BYsnapshot_date. The following example shows how to
query for the number of operational restaurants by month.
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.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-10-02 UTC."],[],[],null,[]]