Unified Data Labs Inc.: Restaurant Directory – Sample

Dataset of all open restaurants, updated monthly. Sample limited to San Jose, CA. Full version available.

Description:

This is a sample dataset limited to San Jose, CA and is available for free for demonstration purposes, please contact [email protected] 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

 

About the Provider:

Unified Data collects information on restaurants and menus of all North American restaurants that have a physical address and permanent location. Tracking over 1.1 million restaurant locations on a monthly basis along with pricing and descriptions of over 4 billion menu items, Unified Data Labs informs the decisions of foodservice industry leaders.

Get access to the Unified Data Labs Inc.: Restaurant Directory – Sample Listing in Snowflake

SIGN UP FOR A SNOWFLAKE FREE TRIAL

Already a Snowflake customer?
Access this listing directly from your Snowflake account.

LOGIN