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)
Argentina	places_insights___ar.FUNCTION_NAME	places_insights___ar.places
Australia	places_insights___au.FUNCTION_NAME	places_insights___au.places
Austria	places_insights___at.FUNCTION_NAME	places_insights___at.places
Bahrain	places_insights___bh.FUNCTION_NAME	places_insights___bh.places
Belgium	places_insights___be.FUNCTION_NAME	places_insights___be.places
Brazil	places_insights___br.FUNCTION_NAME	places_insights___br.places
Bulgaria	places_insights___bg.FUNCTION_NAME	places_insights___bg.places
Canada	places_insights___ca.FUNCTION_NAME	places_insights___ca.places
Chile	places_insights___cl.FUNCTION_NAME	places_insights___cl.places
Colombia	places_insights___co.FUNCTION_NAME	places_insights___co.places
Czechia	places_insights___cz.FUNCTION_NAME	places_insights___cz.places
Denmark	places_insights___dk.FUNCTION_NAME	places_insights___dk.places
Egypt	places_insights___eg.FUNCTION_NAME	places_insights___eg.places
Finland	places_insights___fi.FUNCTION_NAME	places_insights___fi.places
France	places_insights___fr.FUNCTION_NAME	places_insights___fr.places
Germany	places_insights___de.FUNCTION_NAME	places_insights___de.places
Greece	places_insights___gr.FUNCTION_NAME	places_insights___gr.places
Hong Kong	places_insights___hk.FUNCTION_NAME	places_insights___hk.places
Hungary	places_insights___hu.FUNCTION_NAME	places_insights___hu.places
India	places_insights___in.FUNCTION_NAME	places_insights___in.places
Indonesia	places_insights___id.FUNCTION_NAME	places_insights___id.places
Ireland	places_insights___ie.FUNCTION_NAME	places_insights___ie.places
Israel	places_insights___il.FUNCTION_NAME	places_insights___il.places
Italy	places_insights___it.FUNCTION_NAME	places_insights___it.places
Japan	places_insights___jp.FUNCTION_NAME	places_insights___jp.places
Malaysia	places_insights___my.FUNCTION_NAME	places_insights___my.places
Mexico	places_insights___mx.FUNCTION_NAME	places_insights___mx.places
Netherlands	places_insights___nl.FUNCTION_NAME	places_insights___nl.places
New Zealand	places_insights___nz.FUNCTION_NAME	places_insights___nz.places
Norway	places_insights___no.FUNCTION_NAME	places_insights___no.places
Peru	places_insights___pe.FUNCTION_NAME	places_insights___pe.places
Philippines	places_insights___ph.FUNCTION_NAME	places_insights___ph.places
Poland	places_insights___pl.FUNCTION_NAME	places_insights___pl.places
Portugal	places_insights___pt.FUNCTION_NAME	places_insights___pt.places
Qatar	places_insights___qa.FUNCTION_NAME	places_insights___qa.places
Romania	places_insights___ro.FUNCTION_NAME	places_insights___ro.places
Saudi Arabia	places_insights___sa.FUNCTION_NAME	places_insights___sa.places
Singapore	places_insights___sg.FUNCTION_NAME	places_insights___sg.places
South Africa	places_insights___za.FUNCTION_NAME	places_insights___za.places
South Korea	places_insights___kr.FUNCTION_NAME	places_insights___kr.places
Spain	places_insights___es.FUNCTION_NAME	places_insights___es.places
Sweden	places_insights___se.FUNCTION_NAME	places_insights___se.places
Switzerland	places_insights___ch.FUNCTION_NAME	places_insights___ch.places
Taiwan	places_insights___tw.FUNCTION_NAME	places_insights___tw.places
Thailand	places_insights___th.FUNCTION_NAME	places_insights___th.places
Turkey	places_insights___tr.FUNCTION_NAME	places_insights___tr.places
United Arab Emirates	places_insights___ae.FUNCTION_NAME	places_insights___ae.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
Vietnam	places_insights___vn.FUNCTION_NAME	places_insights___vn.places