Restaurant Directory - Sample

This is a sample dataset limited to San Jose, CA and is available for free for demonstration purposes, please contact [e-mail] for more information.

Unified data provides comprehensive and timely data on restaurant store locations and menus across North America.

Store Connect Restaurant Listings data tracks over 1 million restaurant locations across North America every month including chains and independents. Data are reported by segment, cuisine, and location identifying which locations that have opened and each month so you can monitor target markets and uncover sales opportunities. Additionally, we are tracking the delivery partners and reservation partners for each store location.

Table Name:
locations_sample - sample dataset for demonstration purposes limited to San Jose, CA

Fields Included:
>>locations_openclose_id -> Unique Identifier for each location and recorded update in open/close status
>> ->
>>location_id -> Unique Identifier for Location
>>location_name -> Name of restaurant location
>>location_full_address -> Full street address of restaurant
>>location_city -> City where the restaurant is located
>>location_state_province -> State/Province where the restaurant is located
>>location_zip_postal -> ZIP/Postal Code where the restaurant is located
>>location_country -> Country where the restaurant is located
>>location_cuisine -> Cuisine type of restaurant
>>location_segment -> Segment of restaurant
>>location_chain_name -> Chain name that restaurant is associated with (null if independent)
>>location_lat -> Latitude of the restaurant
>>location_lng -> Longitude of the restaurant
>>location_spotted_date -> When the location was first spotted by Unified Data
>>location_closed_date -> Month that the location was identified as closed (null if still open)
>> ->
>>location_status_change_type -> "newOpen", "permClosed", "reopened", "tempClosed"
>>location_status_change_month -> Status change month, in integer format (yyyymm).
>> ->
>>location_delivery_door_dash -> Location lists Door Dash as a delivery partner ( 0=false, 1=true)
>>location_delivery_foodora -> Location lists Foodora as a delivery partner ( 0=false, 1=true)
>>location_delivery_grub_hub -> Location lists Grub Hub as a delivery partner ( 0=false, 1=true)
>>location_delivery_post_mates -> Location lists Post Mates as a delivery partner ( 0=false, 1=true)
>>location_delivery_ritual -> Location lists Ritual as a delivery partner ( 0=false, 1=true)
>>location_delivery_seamless -> Location lists Seamless as a delivery partner ( 0=false, 1=true)
>>location_delivery_skip_the_dishes -> Location lists Skip the dishes as a delivery partner ( 0=false, 1=true)
>>location_delivery_uber_eats -> Location lists Uber Eats as a delivery partner ( 0=false, 1=true)
>> ->
>>location_reservation_google -> Location lists Google as a reservation platform ( 0=false, 1=true)
>>location_reservation_open_table -> Location lists Open Table as a reservation platform ( 0=false, 1=true)
>>location_reservation_resy -> Location lists Resy as a reservation platform ( 0=false, 1=true)
>> ->
>>location_access_drive_through -> Location lists "Drive-Through" as a access option ( 0=false, 1=true)
>>location_dining_outdoor_seating -> Location lists "Outdoor Seating" as a dining option ( 0=false, 1=true)
>> ->
>>location_dataset_lastupdate -> Latest update of the dataset

搜集汇总

背景与挑战

背景概述

该数据集是加州圣何塞地区的餐厅样本目录，包含餐厅位置、营业状态、菜系类型等详细信息，并记录了各餐厅合作的外送平台和预订平台情况。数据仅用于演示目的，完整版涵盖北美地区超过100万家餐厅。