Supported locations and table names

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_sample places_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.places places_insights___us.brands