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 places_insights___au___sample.places_sample_historical places_insights___au___sample.brands
Sao Paulo, Brazil	places_insights___br___sample.FUNCTION_NAME	places_insights___br___sample.places_sample places_insights___br___sample.places_sample_historical
Toronto, Canada	places_insights___ca___sample.FUNCTION_NAME	places_insights___ca___sample.places_sample places_insights___ca___sample.places_sample_historical places_insights___ca___sample.brands
Paris, France	places_insights___fr___sample.FUNCTION_NAME	places_insights___fr___sample.places_sample places_insights___fr___sample.places_sample_historical
Berlin, Germany	places_insights___de___sample.FUNCTION_NAME	places_insights___de___sample.places_sample places_insights___de___sample.places_sample_historical
Mumbai, India	places_insights___in___sample.FUNCTION_NAME	places_insights___in___sample.places_sample places_insights___in___sample.places_sample_historical
Jakarta, Indonesia	places_insights___id___sample.FUNCTION_NAME	places_insights___id___sample.places_sample places_insights___id___sample.places_sample_historical
Rome, Italy	places_insights___it___sample.FUNCTION_NAME	places_insights___it___sample.places_sample places_insights___it___sample.places_sample_historical
Tokyo, Japan	places_insights___jp___sample.FUNCTION_NAME	places_insights___jp___sample.places_sample places_insights___jp___sample.places_sample_historical
Mexico City, Mexico	places_insights___mx___sample.FUNCTION_NAME	places_insights___mx___sample.places_sample places_insights___mx___sample.places_sample_historical
Madrid, Spain	places_insights___es___sample.FUNCTION_NAME	places_insights___es___sample.places_sample places_insights___es___sample.places_sample_historical
Zurich, Switzerland	places_insights___ch___sample.FUNCTION_NAME	places_insights___ch___sample.places_sample places_insights___ch___sample.places_sample_historical
London, United Kingdom	places_insights___gb___sample.FUNCTION_NAME	places_insights___gb___sample.places_sample places_insights___gb___sample.places_sample_historical places_insights___gb___sample.brands
New York City, United States	places_insights___us___sample.FUNCTION_NAME	places_insights___us___sample.places_sample places_insights___us___sample.places_sample_historical 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 places_insights___ar.places_historical
Australia	places_insights___au.FUNCTION_NAME	places_insights___au.places places_insights___au.places_historical places_insights___au.brands
Austria	places_insights___at.FUNCTION_NAME	places_insights___at.places places_insights___at.places_historical
Bahrain	places_insights___bh.FUNCTION_NAME	places_insights___bh.places places_insights___bh.places_historical
Belgium	places_insights___be.FUNCTION_NAME	places_insights___be.places places_insights___be.places_historical
Brazil	places_insights___br.FUNCTION_NAME	places_insights___br.places places_insights___br.places_historical
Bulgaria	places_insights___bg.FUNCTION_NAME	places_insights___bg.places places_insights___bg.places_historical
Canada	places_insights___ca.FUNCTION_NAME	places_insights___ca.places places_insights___ca.places_historical places_insights___ca.brands
Chile	places_insights___cl.FUNCTION_NAME	places_insights___cl.places places_insights___cl.places_historical
Colombia	places_insights___co.FUNCTION_NAME	places_insights___co.places places_insights___co.places_historical
Czechia	places_insights___cz.FUNCTION_NAME	places_insights___cz.places places_insights___cz.places_historical
Denmark	places_insights___dk.FUNCTION_NAME	places_insights___dk.places places_insights___dk.places_historical
Egypt	places_insights___eg.FUNCTION_NAME	places_insights___eg.places places_insights___eg.places_historical
Finland	places_insights___fi.FUNCTION_NAME	places_insights___fi.places places_insights___fi.places_historical
France	places_insights___fr.FUNCTION_NAME	places_insights___fr.places places_insights___fr.places_historical
Germany	places_insights___de.FUNCTION_NAME	places_insights___de.places places_insights___de.places_historical
Greece	places_insights___gr.FUNCTION_NAME	places_insights___gr.places places_insights___gr.places_historical
Hong Kong	places_insights___hk.FUNCTION_NAME	places_insights___hk.places places_insights___hk.places_historical
Hungary	places_insights___hu.FUNCTION_NAME	places_insights___hu.places places_insights___hu.places_historical
India	places_insights___in.FUNCTION_NAME	places_insights___in.places places_insights___in.places_historical
Indonesia	places_insights___id.FUNCTION_NAME	places_insights___id.places places_insights___id.places_historical
Ireland	places_insights___ie.FUNCTION_NAME	places_insights___ie.places places_insights___ie.places_historical
Israel	places_insights___il.FUNCTION_NAME	places_insights___il.places places_insights___il.places_historical
Italy	places_insights___it.FUNCTION_NAME	places_insights___it.places places_insights___it.places_historical
Japan	places_insights___jp.FUNCTION_NAME	places_insights___jp.places places_insights___jp.places_historical
Malaysia	places_insights___my.FUNCTION_NAME	places_insights___my.places places_insights___my.places_historical
Mexico	places_insights___mx.FUNCTION_NAME	places_insights___mx.places places_insights___mx.places_historical
Netherlands	places_insights___nl.FUNCTION_NAME	places_insights___nl.places places_insights___nl.places_historical
New Zealand	places_insights___nz.FUNCTION_NAME	places_insights___nz.places places_insights___nz.places_historical
Norway	places_insights___no.FUNCTION_NAME	places_insights___no.places places_insights___no.places_historical
Peru	places_insights___pe.FUNCTION_NAME	places_insights___pe.places places_insights___pe.places_historical
Philippines	places_insights___ph.FUNCTION_NAME	places_insights___ph.places places_insights___ph.places_historical
Poland	places_insights___pl.FUNCTION_NAME	places_insights___pl.places places_insights___pl.places_historical
Portugal	places_insights___pt.FUNCTION_NAME	places_insights___pt.places places_insights___pt.places_historical
Qatar	places_insights___qa.FUNCTION_NAME	places_insights___qa.places places_insights___qa.places_historical
Romania	places_insights___ro.FUNCTION_NAME	places_insights___ro.places places_insights___ro.places_historical
Saudi Arabia	places_insights___sa.FUNCTION_NAME	places_insights___sa.places places_insights___sa.places_historical
Singapore	places_insights___sg.FUNCTION_NAME	places_insights___sg.places places_insights___sg.places_historical
South Africa	places_insights___za.FUNCTION_NAME	places_insights___za.places places_insights___za.places_historical
South Korea	places_insights___kr.FUNCTION_NAME	places_insights___kr.places places_insights___kr.places_historical
Spain	places_insights___es.FUNCTION_NAME	places_insights___es.places places_insights___es.places_historical
Sweden	places_insights___se.FUNCTION_NAME	places_insights___se.places places_insights___se.places_historical
Switzerland	places_insights___ch.FUNCTION_NAME	places_insights___ch.places places_insights___ch.places_historical
Taiwan	places_insights___tw.FUNCTION_NAME	places_insights___tw.places places_insights___tw.places_historical
Thailand	places_insights___th.FUNCTION_NAME	places_insights___th.places places_insights___th.places_historical
Turkey	places_insights___tr.FUNCTION_NAME	places_insights___tr.places places_insights___tr.places_historical
United Arab Emirates	places_insights___ae.FUNCTION_NAME	places_insights___ae.places places_insights___ae.places_historical
United Kingdom	places_insights___gb.FUNCTION_NAME	places_insights___gb.places places_insights___gb.places_historical places_insights___gb.brands
United States	places_insights___us.FUNCTION_NAME	places_insights___us.places places_insights___us.places_historical places_insights___us.brands
Vietnam	places_insights___vn.FUNCTION_NAME	places_insights___vn.places places_insights___vn.places_historical