Send feedback
Supported locations and table names
Stay organized with collections
Save and categorize content based on your preferences.
The following tables list the cities available as sample data, the countries
available as full data, and their corresponding table names. This data can be
queried directly as well as
queried using Places Count
functions .
Sample data
City, Country
Table name (Places Count function query)
Table name (direct query)
Sydney, Australia
places_insights___au___sample.FUNCTION_NAME places_insights___au___sample.places_sample
Sao Paulo, Brazil
places_insights___br___sample.FUNCTION_NAME places_insights___br___sample.places_sample
Toronto, Canada
places_insights___ca___sample.FUNCTION_NAME places_insights___ca___sample.places_sample
Paris, France
places_insights___fr___sample.FUNCTION_NAME places_insights___fr___sample.places_sample
Berlin, Germany
places_insights___de___sample.FUNCTION_NAME places_insights___de___sample.places_sample
Mumbai, India
places_insights___in___sample.FUNCTION_NAME places_insights___in___sample.places_sample
Jakarta, Indonesia
places_insights___id___sample.FUNCTION_NAME places_insights___id___sample.places_sample
Rome, Italy
places_insights___it___sample.FUNCTION_NAME places_insights___it___sample.places_sample
Tokyo, Japan
places_insights___jp___sample.FUNCTION_NAME places_insights___jp___sample.places_sample
Mexico City, Mexico
places_insights___mx___sample.FUNCTION_NAME places_insights___mx___sample.places_sample
Madrid, Spain
places_insights___es___sample.FUNCTION_NAME places_insights___es___sample.places_sample
Zurich, Switzerland
places_insights___ch___sample.FUNCTION_NAME places_insights___ch___sample.places_sample
London, United Kingdom
places_insights___gb___sample.FUNCTION_NAME places_insights___gb___sample.places_sample
New York City, United States
places_insights___us___sample.FUNCTION_NAME places_insights___us___sample.places_sampleplaces_insights___us___sample.brands
Full data
Country
Table name (Places Count function query)
Table name (direct query or brands data query)
Australia
places_insights___au.FUNCTION_NAME places_insights___au.places
Brazil
places_insights___br.FUNCTION_NAME places_insights___br.places
Canada
places_insights___ca.FUNCTION_NAME places_insights___ca.places
France
places_insights___fr.FUNCTION_NAME places_insights___fr.places
Germany
places_insights___de.FUNCTION_NAME places_insights___de.places
India
places_insights___in.FUNCTION_NAME places_insights___in.places
Indonesia
places_insights___id.FUNCTION_NAME places_insights___id.places
Italy
places_insights___it.FUNCTION_NAME places_insights___it.places
Japan
places_insights___jp.FUNCTION_NAME places_insights___jp.places
Mexico
places_insights___mx.FUNCTION_NAME places_insights___mx.places
Spain
places_insights___es.FUNCTION_NAME places_insights___es.places
Switzerland
places_insights___ch.FUNCTION_NAME places_insights___ch.places
United Kingdom
places_insights___gb.FUNCTION_NAME places_insights___gb.places
United States
places_insights___us.FUNCTION_NAME places_insights___us.placesplaces_insights___us.brands
Send feedback
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License , and code samples are licensed under the Apache 2.0 License . For details, see the Google Developers Site Policies . Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2026-01-16 UTC.
Need to tell us more?
[[["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 2026-01-16 UTC."],[],[]]
