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](https://developers.google.com/maps/documentation/placesinsights/queries.md.txt) as well as
queried using [Places Count
functions](https://developers.google.com/maps/documentation/placesinsights/place-count-functions/function-queries).

## 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` |