Data Share Usage Example Q1: Show me all the branded locations by City and Zip Code in the state of California –Show me all branded locations by City and Zip Code in the state of California SELECT BRANDS, CITY, POSTAL_CODE AS ZIP FROM PUBLIC.CORE_POI WHERE REGION=’CA’;
Core Places is a dataset containing business listing information about points-of-interest (POI) such as location name, street address, industry, lat/long and brand. Covers locations for major retail chains, local businesses, convenience stores, hotels, airports, schools, hospitals & more. Dataset contains more than 5.5MM United States POI across all categories and over 5,500 recognized brands. All SafeGraph POI-based datasets utilize Placekey (https://www.placekey.io/) as the primary key and are formatted as delimited CSVs. SafeGraph updates the Places dataset every month with the past month’s openings and closings and maintains a persistent Placekey across releases. Our detailed Core Places Schema* is available online. Additionally please refer to Places Data Manual* for more detailed field definitions and methodologies. Our Places Summary Statistics* is updated with every monthly release to reflect data coverage. For any questions about this dataset or any other, please contact snowflake@safegraph.com. DATA DICTIONARY Our documentation site includes detailed information for all of our products, but this product listing specifically only includes the Core Places data set and does not include Geometry or Patterns data. *Core Places Schema: https://docs.safegraph.com/docs#section-core-places *Places Data Manual: https://docs.safegraph.com/docs/places-manual *Places Summary Statistics: https://docs.safegraph.com/docs/places-summary-statistics