Set up Places Insights

Places Insights lets you enhance your own data with statistical insights about points of interest data to make more informed business decisions.

Before you can query Places Insights data, you must first sign up to get access to the Places Insights product. Once your account has been onboarded, you will be able to subscribe to the Places Insights dataset for your target country.

Prerequisites

To access the Places Insights data, you must:

1. Sign up to request access to Places Insights.

2. Have a Google Cloud account.

   If you don't have an account, click the Get Started button that links to an interactive setup experience in the Cloud console for new users:

   Get Started

3. Enable the BigQuery API. For instructions on enabling BigQuery and for a tutorial on using BigQuery, see Query a public dataset with the Google Cloud console.

4. Enable the Analytics Hub API.

5. Ensure that your account has the Analytics Hub Subscription Owner (roles/analyticshub.subscriptionOwner) role to perform subscriber tasks.

6. Ensure that your account has the BigQuery User (roles/bigquery.user) role to create datasets.

7. Ensure that your account has the BigQuery Data Viewer ( roles/bigquery.dataViewer ) role to view and query linked datasets.

   For more information, see View and subscribe to listings.

Subscribe to the Places Insights dataset

Places Insights data is available for the cities and countries listed in the table below. Each city and country has its own data listing that you must subscribe to individually.

To subscribe to a listing:

1. Select the subscribe link for the city of interest from the table below.

2. A dialog opens for that country in the Google Cloud console. For example for the New York City, United States (US) listing:

   

3. Select the Subscribe button in the dialog.

4. Confirm or edit the Project, Linked dataset name, Primary region, and Replica regions in the dialog. You can choose to use the default listing name or you can optionally set the name to use your own naming convention.

   

5. Select Save.

6. When complete, the table subscription appears in the BigQuery Explorer panel in the Google Cloud console. In your SQL queries, use the table name shown below to access the data.

   

Available listings

The following tables list the supported cities and countries and provide links to subscribe. You can subscribe to sample data and full data for each city and country.

Tip: To bypass privacy thresholds and retrieve exact counts and Place IDs, we highly recommend using Places Count functions instead of querying the dataset directly. To use a function, replace FUNCTION_NAME in the table references with your chosen function (for example, PLACES_COUNT_V2 or PLACES_COUNT_PER_H3).

Once you have subscribed to one or more listings, run the following notebook to see the data in action within an interactive environment.

Run in Google Colab

View source on GitHub

Note: If you changed the linked dataset name when setting up Places Insights, use your custom name instead of these default table names.

Sample data

City, Country	Subscribe link	Table names
Buenos Aires, Argentina	AR	places_insights___ar___sample.places_sample places_insights___ar___sample.places_sample_historical places_insights___ar___sample.types places_insights___ar___sample.FUNCTION_NAME
Sydney, Australia	AU	places_insights___au___sample.places_sample places_insights___au___sample.places_sample_historical places_insights___au___sample.brands places_insights___au___sample.types places_insights___au___sample.FUNCTION_NAME
Bad Gastein, Austria	AT	places_insights___at___sample.places_sample places_insights___at___sample.places_sample_historical places_insights___at___sample.types places_insights___at___sample.FUNCTION_NAME
Riffa, Bahrain	BH	places_insights___bh___sample.places_sample places_insights___bh___sample.places_sample_historical places_insights___bh___sample.types places_insights___bh___sample.FUNCTION_NAME
Brussels, Belgium	BE	places_insights___be___sample.places_sample places_insights___be___sample.places_sample_historical places_insights___be___sample.types places_insights___be___sample.FUNCTION_NAME
Sao Paulo, Brazil	BR	places_insights___br___sample.places_sample places_insights___br___sample.places_sample_historical places_insights___br___sample.types places_insights___br___sample.FUNCTION_NAME
Plovdiv, Bulgaria	BG	places_insights___bg___sample.places_sample places_insights___bg___sample.places_sample_historical places_insights___bg___sample.types places_insights___bg___sample.FUNCTION_NAME
Toronto, Canada	CA	places_insights___ca___sample.places_sample places_insights___ca___sample.places_sample_historical places_insights___ca___sample.brands places_insights___ca___sample.types places_insights___ca___sample.FUNCTION_NAME
Santiago, Chile	CL	places_insights___cl___sample.places_sample places_insights___cl___sample.places_sample_historical places_insights___cl___sample.types places_insights___cl___sample.FUNCTION_NAME
Medellín, Colombia	CO	places_insights___co___sample.places_sample places_insights___co___sample.places_sample_historical places_insights___co___sample.types places_insights___co___sample.FUNCTION_NAME
Brno, Czechia	CZ	places_insights___cz___sample.places_sample places_insights___cz___sample.places_sample_historical places_insights___cz___sample.types places_insights___cz___sample.FUNCTION_NAME
Copenhagen, Denmark	DK	places_insights___dk___sample.places_sample places_insights___dk___sample.places_sample_historical places_insights___dk___sample.types places_insights___dk___sample.FUNCTION_NAME
Cairo, Egypt	EG	places_insights___eg___sample.places_sample places_insights___eg___sample.places_sample_historical places_insights___eg___sample.types places_insights___eg___sample.FUNCTION_NAME
Helsinki, Finland	FI	places_insights___fi___sample.places_sample places_insights___fi___sample.places_sample_historical places_insights___fi___sample.types places_insights___fi___sample.FUNCTION_NAME
Paris, France	FR	places_insights___fr___sample.places_sample places_insights___fr___sample.places_sample_historical places_insights___fr___sample.types places_insights___fr___sample.FUNCTION_NAME
Berlin, Germany	DE	places_insights___de___sample.places_sample places_insights___de___sample.places_sample_historical places_insights___de___sample.types places_insights___de___sample.FUNCTION_NAME
Athens, Greece	GR	places_insights___gr___sample.places_sample places_insights___gr___sample.places_sample_historical places_insights___gr___sample.types places_insights___gr___sample.FUNCTION_NAME
Hong Kong, Hong Kong	HK	places_insights___hk___sample.places_sample places_insights___hk___sample.places_sample_historical places_insights___hk___sample.types places_insights___hk___sample.FUNCTION_NAME
Debrecen, Hungary	HU	places_insights___hu___sample.places_sample places_insights___hu___sample.places_sample_historical places_insights___hu___sample.types places_insights___hu___sample.FUNCTION_NAME
Mumbai, India	IN	places_insights___in___sample.places_sample places_insights___in___sample.places_sample_historical places_insights___in___sample.types places_insights___in___sample.FUNCTION_NAME
Jakarta, Indonesia	ID	places_insights___id___sample.places_sample places_insights___id___sample.places_sample_historical places_insights___id___sample.types places_insights___id___sample.FUNCTION_NAME
Cork, Ireland	IE	places_insights___ie___sample.places_sample places_insights___ie___sample.places_sample_historical places_insights___ie___sample.types places_insights___ie___sample.FUNCTION_NAME
Tel Aviv-Yafo, Israel	IL	places_insights___il___sample.places_sample places_insights___il___sample.places_sample_historical places_insights___il___sample.types places_insights___il___sample.FUNCTION_NAME
Rome, Italy	IT	places_insights___it___sample.places_sample places_insights___it___sample.places_sample_historical places_insights___it___sample.types places_insights___it___sample.FUNCTION_NAME
Tokyo, Japan	JP	places_insights___jp___sample.places_sample places_insights___jp___sample.places_sample_historical places_insights___jp___sample.types places_insights___jp___sample.FUNCTION_NAME
Busan, South Korea	KR	places_insights___kr___sample.places_sample places_insights___kr___sample.places_sample_historical places_insights___kr___sample.types places_insights___kr___sample.FUNCTION_NAME
Kuala Lumpur, Malaysia	MY	places_insights___my___sample.places_sample places_insights___my___sample.places_sample_historical places_insights___my___sample.types places_insights___my___sample.FUNCTION_NAME
Mexico City, Mexico	MX	places_insights___mx___sample.places_sample places_insights___mx___sample.places_sample_historical places_insights___mx___sample.types places_insights___mx___sample.FUNCTION_NAME
Amsterdam, Netherlands	NL	places_insights___nl___sample.places_sample places_insights___nl___sample.places_sample_historical places_insights___nl___sample.types places_insights___nl___sample.FUNCTION_NAME
Wellington, New Zealand	NZ	places_insights___nz___sample.places_sample places_insights___nz___sample.places_sample_historical places_insights___nz___sample.types places_insights___nz___sample.FUNCTION_NAME
Oslo, Norway	NO	places_insights___no___sample.places_sample places_insights___no___sample.places_sample_historical places_insights___no___sample.types places_insights___no___sample.FUNCTION_NAME
Arequipa, Peru	PE	places_insights___pe___sample.places_sample places_insights___pe___sample.places_sample_historical places_insights___pe___sample.types places_insights___pe___sample.FUNCTION_NAME
Manila, Philippines	PH	places_insights___ph___sample.places_sample places_insights___ph___sample.places_sample_historical places_insights___ph___sample.types places_insights___ph___sample.FUNCTION_NAME
Warsaw, Poland	PL	places_insights___pl___sample.places_sample places_insights___pl___sample.places_sample_historical places_insights___pl___sample.types places_insights___pl___sample.FUNCTION_NAME
Lisbon, Portugal	PT	places_insights___pt___sample.places_sample places_insights___pt___sample.places_sample_historical places_insights___pt___sample.types places_insights___pt___sample.FUNCTION_NAME
Lusail, Qatar	QA	places_insights___qa___sample.places_sample places_insights___qa___sample.places_sample_historical places_insights___qa___sample.types places_insights___qa___sample.FUNCTION_NAME
Bucharest, Romania	RO	places_insights___ro___sample.places_sample places_insights___ro___sample.places_sample_historical places_insights___ro___sample.types places_insights___ro___sample.FUNCTION_NAME
Jeddah, Saudi Arabia	SA	places_insights___sa___sample.places_sample places_insights___sa___sample.places_sample_historical places_insights___sa___sample.types places_insights___sa___sample.FUNCTION_NAME
Downtown Core, Singapore	SG	places_insights___sg___sample.places_sample places_insights___sg___sample.places_sample_historical places_insights___sg___sample.types places_insights___sg___sample.FUNCTION_NAME
Johannesburg, South Africa	ZA	places_insights___za___sample.places_sample places_insights___za___sample.places_sample_historical places_insights___za___sample.types places_insights___za___sample.FUNCTION_NAME
Madrid, Spain	ES	places_insights___es___sample.places_sample places_insights___es___sample.places_sample_historical places_insights___es___sample.types places_insights___es___sample.FUNCTION_NAME
Stockholm, Sweden	SE	places_insights___se___sample.places_sample places_insights___se___sample.places_sample_historical places_insights___se___sample.types places_insights___se___sample.FUNCTION_NAME
Zurich, Switzerland	CH	places_insights___ch___sample.places_sample places_insights___ch___sample.places_sample_historical places_insights___ch___sample.types places_insights___ch___sample.FUNCTION_NAME
Taipei, Taiwan	TW	places_insights___tw___sample.places_sample places_insights___tw___sample.places_sample_historical places_insights___tw___sample.types places_insights___tw___sample.FUNCTION_NAME
Chiang Mai, Thailand	TH	places_insights___th___sample.places_sample places_insights___th___sample.places_sample_historical places_insights___th___sample.types places_insights___th___sample.FUNCTION_NAME
Ankara, Turkey	TR	places_insights___tr___sample.places_sample places_insights___tr___sample.places_sample_historical places_insights___tr___sample.types places_insights___tr___sample.FUNCTION_NAME
Sharjah, United Arab Emirates	AE	places_insights___ae___sample.places_sample places_insights___ae___sample.places_sample_historical places_insights___ae___sample.types places_insights___ae___sample.FUNCTION_NAME
London, United Kingdom	GB	places_insights___gb___sample.places_sample places_insights___gb___sample.places_sample_historical places_insights___gb___sample.brands places_insights___gb___sample.types places_insights___gb___sample.FUNCTION_NAME
New York City, United States	US	places_insights___us___sample.places_sample places_insights___us___sample.places_sample_historical places_insights___us___sample.brands places_insights___us___sample.types places_insights___us___sample.FUNCTION_NAME
Hanoi, Vietnam	VN	places_insights___vn___sample.places_sample places_insights___vn___sample.places_sample_historical places_insights___vn___sample.types places_insights___vn___sample.FUNCTION_NAME

Full data

Country	Subscribe link	Table names
Argentina	AR	places_insights___ar.places places_insights___ar.places_historical places_insights___ar.types places_insights___ar.FUNCTION_NAME
Australia	AU	places_insights___au.places places_insights___au.places_historical places_insights___au.brands places_insights___au.types places_insights___au.FUNCTION_NAME
Austria	AT	places_insights___at.places places_insights___at.places_historical places_insights___at.types places_insights___at.FUNCTION_NAME
Bahrain	BH	places_insights___bh.places places_insights___bh.places_historical places_insights___bh.types places_insights___bh.FUNCTION_NAME
Belgium	BE	places_insights___be.places places_insights___be.places_historical places_insights___be.types places_insights___be.FUNCTION_NAME
Brazil	BR	places_insights___br.places places_insights___br.places_historical places_insights___br.types places_insights___br.FUNCTION_NAME
Bulgaria	BG	places_insights___bg.places places_insights___bg.places_historical places_insights___bg.types places_insights___bg.FUNCTION_NAME
Canada	CA	places_insights___ca.places places_insights___ca.places_historical places_insights___ca.brands places_insights___ca.types places_insights___ca.FUNCTION_NAME
Chile	CL	places_insights___cl.places places_insights___cl.places_historical places_insights___cl.types places_insights___cl.FUNCTION_NAME
Colombia	CO	places_insights___co.places places_insights___co.places_historical places_insights___co.types places_insights___co.FUNCTION_NAME
Czechia	CZ	places_insights___cz.places places_insights___cz.places_historical places_insights___cz.types places_insights___cz.FUNCTION_NAME
Denmark	DK	places_insights___dk.places places_insights___dk.places_historical places_insights___dk.types places_insights___dk.FUNCTION_NAME
Egypt	EG	places_insights___eg.places places_insights___eg.places_historical places_insights___eg.types places_insights___eg.FUNCTION_NAME
Finland	FI	places_insights___fi.places places_insights___fi.places_historical places_insights___fi.types places_insights___fi.FUNCTION_NAME
France	FR	places_insights___fr.places places_insights___fr.places_historical places_insights___fr.types places_insights___fr.FUNCTION_NAME
Germany	DE	places_insights___de.places places_insights___de.places_historical places_insights___de.types places_insights___de.FUNCTION_NAME
Greece	GR	places_insights___gr.places places_insights___gr.places_historical places_insights___gr.types places_insights___gr.FUNCTION_NAME
Hong Kong	HK	places_insights___hk.places places_insights___hk.places_historical places_insights___hk.types places_insights___hk.FUNCTION_NAME
Hungary	HU	places_insights___hu.places places_insights___hu.places_historical places_insights___hu.types places_insights___hu.FUNCTION_NAME
India	IN	places_insights___in.places places_insights___in.places_historical places_insights___in.types places_insights___in.FUNCTION_NAME
Indonesia	ID	places_insights___id.places places_insights___id.places_historical places_insights___id.types places_insights___id.FUNCTION_NAME
Ireland	IE	places_insights___ie.places places_insights___ie.places_historical places_insights___ie.types places_insights___ie.FUNCTION_NAME
Israel	IL	places_insights___il.places places_insights___il.places_historical places_insights___il.types places_insights___il.FUNCTION_NAME
Italy	IT	places_insights___it.places places_insights___it.places_historical places_insights___it.types places_insights___it.FUNCTION_NAME
Japan	JP	places_insights___jp.places places_insights___jp.places_historical places_insights___jp.types places_insights___jp.FUNCTION_NAME
Malaysia	MY	places_insights___my.places places_insights___my.places_historical places_insights___my.types places_insights___my.FUNCTION_NAME
Mexico	MX	places_insights___mx.places places_insights___mx.places_historical places_insights___mx.types places_insights___mx.FUNCTION_NAME
Netherlands	NL	places_insights___nl.places places_insights___nl.places_historical places_insights___nl.types places_insights___nl.FUNCTION_NAME
New Zealand	NZ	places_insights___nz.places places_insights___nz.places_historical places_insights___nz.types places_insights___nz.FUNCTION_NAME
Norway	NO	places_insights___no.places places_insights___no.places_historical places_insights___no.types places_insights___no.FUNCTION_NAME
Peru	PE	places_insights___pe.places places_insights___pe.places_historical places_insights___pe.types places_insights___pe.FUNCTION_NAME
Philippines	PH	places_insights___ph.places places_insights___ph.places_historical places_insights___ph.types places_insights___ph.FUNCTION_NAME
Poland	PL	places_insights___pl.places places_insights___pl.places_historical places_insights___pl.types places_insights___pl.FUNCTION_NAME
Portugal	PT	places_insights___pt.places places_insights___pt.places_historical places_insights___pt.types places_insights___pt.FUNCTION_NAME
Qatar	QA	places_insights___qa.places places_insights___qa.places_historical places_insights___qa.types places_insights___qa.FUNCTION_NAME
Romania	RO	places_insights___ro.places places_insights___ro.places_historical places_insights___ro.types places_insights___ro.FUNCTION_NAME
Saudi Arabia	SA	places_insights___sa.places places_insights___sa.places_historical places_insights___sa.types places_insights___sa.FUNCTION_NAME
Singapore	SG	places_insights___sg.places places_insights___sg.places_historical places_insights___sg.types places_insights___sg.FUNCTION_NAME
South Africa	ZA	places_insights___za.places places_insights___za.places_historical places_insights___za.types places_insights___za.FUNCTION_NAME
South Korea	KR	places_insights___kr.places places_insights___kr.places_historical places_insights___kr.types places_insights___kr.FUNCTION_NAME
Spain	ES	places_insights___es.places places_insights___es.places_historical places_insights___es.types places_insights___es.FUNCTION_NAME
Sweden	SE	places_insights___se.places places_insights___se.places_historical places_insights___se.types places_insights___se.FUNCTION_NAME
Switzerland	CH	places_insights___ch.places places_insights___ch.places_historical places_insights___ch.types places_insights___ch.FUNCTION_NAME
Taiwan	TW	places_insights___tw.places places_insights___tw.places_historical places_insights___tw.types places_insights___tw.FUNCTION_NAME
Thailand	TH	places_insights___th.places places_insights___th.places_historical places_insights___th.types places_insights___th.FUNCTION_NAME
Turkey	TR	places_insights___tr.places places_insights___tr.places_historical places_insights___tr.types places_insights___tr.FUNCTION_NAME
United Arab Emirates	AE	places_insights___ae.places places_insights___ae.places_historical places_insights___ae.types places_insights___ae.FUNCTION_NAME
United Kingdom	GB	places_insights___gb.places places_insights___gb.places_historical places_insights___gb.brands places_insights___gb.types places_insights___gb.FUNCTION_NAME
United States	US	places_insights___us.places places_insights___us.places_historical places_insights___us.brands places_insights___us.types places_insights___us.FUNCTION_NAME
Vietnam	VN	places_insights___vn.places places_insights___vn.places_historical places_insights___vn.types places_insights___vn.FUNCTION_NAME