01 / Overview

Understand The Places Around Your Locations

Explore the mix of places in an area using Google’s structured place data in BigQuery. Combine categories, ratings, and opening hours with your own geography to answer location questions.

Place Data, Applied To Your Geography

Conceptual Overview
Source

Country Dataset

Structured attributes for places in a supported country.

+
Scope

Your Analysis Area

Define the geography relevant to your question.

Analysis

Aggregate Results

Explore counts, categories, and other supported attributes.

Use direct SQL or supported count functions. Output controls depend on the interface. Place attributes do not measure individual visits or foot traffic.

At A Glance

  • Provides: Structured place attributes for geographic analysis in BigQuery.
  • Not: Foot traffic, visit counts, or individual movement data.
50country datasets listed
14sample cities listed
5minimum SQL aggregation count
2query access patterns

02 / What's Included

What's Included — And What's Not

Each record describes a place. Countries share a core schema, with additional country-specific fields. Many attributes are nullable: missing parking, accessibility, or service information means unknown, not false.

Included

  • Hundreds of supported place types
  • 70+ attributes — price, ratings, hours, parking, accessibility
  • Brands table (US, Canada, UK, Australia)

Not Included

  • Visit counts
  • Dwell time
  • Busyness / foot traffic
  • Demographics
  • Individual-level data

primary_type is a single category; types can contain several. Type counts can overlap. Use business_status to select operational businesses and user_rating_count to contextualize ratings. brand_ids links to supported brand data; snapshot_date is available in historical views.

Sample Place Types

RestaurantHospital Auto repairGrocery store GymPharmacy

Sample Attributes

Price levelRating HoursParking Wheelchair accessibleDelivery
places_insights___us.placesCountry dataset
idSTRING
primary_typeSTRING
typesARRAY<STRING>
business_statusSTRING
pointGEOGRAPHY
ratingFLOAT64
price_levelSTRING
Selected fields; nullable values mean unknown

03 / Data Source

Country Datasets From Google’s Place Data

Places Insights is based on Google’s curated place information and is refreshed monthly. Country datasets contain the available records for that geography; a global Maps figure is not the row count of an individual subscribed table.

Key Facts

  • Country-specific BigQuery listings
  • Monthly refresh; historical snapshots are available as documented
  • Check the current schema, fields, and country coverage for each analysis

Combine permitted aggregate results with your own data in BigQuery. Query controls and applicable license terms govern access and export; subscription does not provide unrestricted raw-table extraction.

Data And Analysis
01
Google Place Information

Curated place attributes for the subscribed country.

02
Country Dataset

Monthly refresh and documented historical snapshots.

03
Governed Analysis

Combine permitted results with your own BigQuery data.

Use supported SQL or count functions. Downstream analysis can use Looker Studio or a separately validated model.

04 / Extend With Maps Platform

Connect Area Analysis To Place Details

Start with area-level counts, then inspect selected places using returned Place IDs. Places API adds individual details; each service has its own fields, access requirements, and billing.

Places API & Place DetailsUse Place IDs returned through supported count functions with Places API, subject to its billing and display requirements.
Geocoding API — building outlines & entrancesUse Geocoding v4 destination search for available building and entrance context; coverage and feature launch stages vary.

Pairs Well With

Places API Place Details Geocoding API Building outlines & entrances Looker Studio BigQuery ML / Vertex AI

05 / Example Queries

Use Queries That Match The Access Rules

Start with Places Count functions for counts and sample Place IDs. The direct SQL examples below show custom aggregations. Replace YOUR_PROJECT with your linked-dataset project; the US examples require country access. Missing direct-SQL groups cannot be read as zero.

Count Functions · Recommended Starting Point

Operational restaurants by H3 cell within a 2-mile circle

SELECT *
FROM `YOUR_PROJECT.places_insights___us.PLACES_COUNT_PER_H3`(
 JSON_OBJECT(
  'geography', ST_BUFFER(ST_GEOGPOINT(-97.7431, 30.2672), 3218),
  'h3_resolution', 8,
  'types', ['restaurant'],
  'business_status', ['OPERATIONAL']
 )
);

Example SQL · No request executed

Category Mix

Illustrative aggregates within a 2-mile circle

SELECT WITH AGGREGATION_THRESHOLD
 primary_type, COUNT(id) AS place_count
FROM `YOUR_PROJECT.places_insights___us.places`
WHERE ST_DWITHIN(point, ST_GEOGPOINT(-97.7431, 30.2672), 3218)
 AND business_status = 'OPERATIONAL'
 AND primary_type IN ('cafe', 'restaurant', 'fast_food_restaurant')
GROUP BY primary_type
ORDER BY place_count DESC

Illustrative output · No request executed

primary_typeplace_count
restaurant42
cafe18
fast_food_restaurant11
Ratings By Price Level

Price categories are grouped; AVG ignores missing ratings

SELECT WITH AGGREGATION_THRESHOLD
 price_level, COUNT(id) AS place_count,
 ROUND(AVG(rating), 2) AS avg_rating
FROM `YOUR_PROJECT.places_insights___us.places`
WHERE ST_DWITHIN(point, ST_GEOGPOINT(-97.7431, 30.2672), 3218)
 AND business_status = 'OPERATIONAL'
 AND primary_type = 'restaurant'
 AND price_level IS NOT NULL
GROUP BY price_level
ORDER BY place_count DESC

Illustrative output · No request executed

price_levelplace_countavg_rating
PRICE_LEVEL_MODERATE244.32
PRICE_LEVEL_INEXPENSIVE104.10
PRICE_LEVEL_EXPENSIVE84.41

06 / Use Cases And Industries

Where Places Insights Gets Used

Explore place mix, competitive context, and area attributes. Predictive uses require your own outcomes and validation; low competition alone does not establish demand.

Site Performance ModelingJoin your measured site outcomes to nearby amenity counts, then evaluate a BigQuery ML model before scoring candidates.
Sales Lead IdentificationMatch CRM customers to Place IDs, exclude existing accounts from returned samples, and inspect remaining prospects. A prospect is not evidence of buying intent.
Site Selection & WhitespaceCompare complementary businesses, relevant opening hours, and competitors. Document score weights; sparse competition alone does not establish demand.
Competitive BenchmarkingResolve supported brands through the brands table, then compare aggregate ratings, price levels, and hours within consistent areas.
Trade Area ProfilingSummarize the mix of businesses and amenities within a defined catchment.
Brand & Franchise AuditingCompare aggregate patterns and inspect selected locations using Place Details.
Real-Estate AnalysisCombine parcel prices with amenity counts to study local associations and test valuation models.
Accessibility ReportingSummarize available accessibility attributes; missing data is not a confirmed lack of accessibility.
Navagis Case Study · Japan
01
Property Prices + Amenities

The published Tokyo and Yokkaichi study combined parcel prices with amenity counts within 500 meters.

02
Local Relationships

The study reported different associations by city: subway access in Tokyo and universities in Yokkaichi featured among the positive relationships.

03
Test In Your Market

These findings describe correlation. They do not establish causation or transferable price premiums.

07 / Privacy And Delivery

Choose The Right Access Pattern

Direct SQL and count functions provide different outputs and enforce different controls. Choose the interface that fits the question; do not treat a suppressed SQL row as zero or assume raw place rows can be exported.

Direct Query

  • Use WITH AGGREGATION_THRESHOLD in direct SQL
  • Groups below five places are omitted; direct SQL does not return individual Place IDs

Count Functions

  • Recommended for exact counts, including zero; minimum search area is 1,600 m² (40 m × 40 m)
  • Return up to 250 sample Place IDs per response element, not an unrestricted directory
Two Governed Interfaces
01
Direct SQL

Aggregations over protected tables; threshold ≥ 5; individual Place IDs are not returned.

02
Count Functions

Exact counts, including zero; eligible functions can return limited Place IDs. Minimum area and other constraints apply.

Use PLACES_COUNT_PER_H3 for density maps. The get-started guide also lists PLACES_COUNT_V2 and PLACES_COUNT_PER_TYPE_V2 for batch geographies, and PLACES_COUNT_CHANGE for monthly comparisons. Check their launch stages and availability before adopting them.

08 / Evaluation

Evaluate The Dataset Against Your Needs

Use explicit questions to compare any candidate provider. Confirm the exact product, geography, access model, and date instead of assigning capability verdicts to an unnamed competitor.

Evaluation AreaPlaces InsightsAsk Of Another Offering
SourceGoogle place informationWhat are the source and coverage limits?
AccessBigQuery SQL and supported count functionsWhich interfaces and export controls apply?
RefreshMonthly dataset refreshWhat refresh and historical coverage are documented?
CostDataset access plus applicable BigQuery usageAre there subscription, query, or export charges?
SchemaDocumented fields and country availabilityHow consistent are fields across geographies?
BrandsSeparate supported brand dataWhich brand definitions and countries are covered?

This is an evaluation checklist, not a competitive ranking. Record dated sources before making provider-specific comparisons.

Validate A Shortlist

Map counts with PLACES_COUNT_PER_H3, select areas of interest, and inspect returned sample_place_ids with Place Details. Compare the mapped samples with your filters and record discrepancies. A sample check does not prove complete coverage.

Build A Site Score

Move from regional screening to local H3 cells. Combine complementary place types and opening hours with documented weights, then overlay competitors. A weighted suitability score expresses your criteria; validate the shortlist against access, lease costs, and local conditions.

Test A Performance Model

Join your measured outcomes to nearby POI counts, train a model, and evaluate held-out predictions before applying ML.PREDICT. Report MAE and R²: neither establishes causation, and MAE is an average error, not a prediction interval.

The linked notebook uses synthetic store scores. Its fit does not establish real-world accuracy. Our implementation recommendation: match training and scoring catchments, filters, and dates; 500-meter circles and H3 cell counts are not interchangeable. Test geographic or temporal holdouts and justify any outcome-based exclusions.

Qualify Sales Prospects

Normalize CRM accounts to Place IDs, exclude matches, and check unresolved or duplicate records. Count functions return at most 250 sample IDs per response element; a capped sample is not a complete territory list. Refine filters or geography within supported limits and deduplicate results.

Use Place IDs for recurring matching and fetch current details when needed. Apply the Places API storage, attribution, and billing requirements to those lookups.

09 / Coverage And Pricing

Choose Coverage Before Estimating Cost

The current supported-locations list contains 50 country datasets and 14 sample cities. Samples do not cover every country. Confirm the listing, access terms, and BigQuery costs for the geography you need.

Coverage

  • 50 country datasets in the current list
  • 14 listed sample cities; check the available city before planning a pilot

Cost

  • Request access and subscribe to an available BigQuery listing; evaluate a supported sample geography first
  • Confirm country access pricing, BigQuery analysis and ML costs, and any Maps API or visualization charges

50 separate country datasets make up the full paid catalog — each subscribed individually as its own BigQuery listing

Places Insights · Technical explainer · Reviewed September 14, 2026. Examples are illustrative. Availability, pricing, and feature coverage may change; linked official documentation governs.