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
|
