## Use Cases

This data set provides you with the most comprehensive and up-to-date listing of restaurant menus in North America, allowing you to uncover reliable and high-quality insights to drive the performance of models and marketing solutions.

* _**Pricing Analysis**_ - Analyze pricing differences of menu items across different restaurants and within the same restaurant by state/province. Optimize prizing strategy based on brand positioning and competitive analysis.

* _**Market Analysis**_ - Identify under or over developed menu items and ingredients by style of restaurant, location, and restaurant cuisine.

* _**Customer Acquisition**_ - Foodservice providers can search through menu items to identify opporunities for their product. Search terms like "plant-based", "Pepsi", "cold brew", and "pretzel bun".

 

 

## Metadata

Description | Value

----|-----

Geographic Coverage | Canada & USA

Data Set(s) Format(s) | TSV (Available upon request in JSON, XML or Pipe-Delimited)

Raw or scraped data | Raw data

Key Fields | Menu Item Label, Menu Item Description, Menu Item Price, Location Name, Address, Latitude, Longitude, Cuisine Type, Restaurant Segment, Chain Name, Spotted Date, Closed Date

 

 

## Fields Available

Attribute | Type | Description

----|-----

menu_item_label | String | Name or label of the menu item

menu_item_description | String | Long description of the menu item

menu_item_price | Double | Price

menu_item_lastseen | Date | When item was last seen

| |

location_id | Integer | Unique Identifier for Location

location_chain_name | String | Chain name that restaurant is associated with (null if independent)

location_name | String | Name of restaurant location

location_full_address | String | Full street address of restaurant

location_city | String | City where the restaurant is located

location_state_province | String | State/Province where the restaurant is located

location_zip_postal | String | ZIP/Postal Code where the restaurant is located

location_country | String | Country where the restaurant is located

location_cuisine | String | Cuisine type of restaurant

location_segment | String | Segment of restaurant

location_lat | Double | Latitude of the restaurant

location_lng | Double | Longitude of the restaurant

location_closed_date | Date | Month that the location was identified as closed (null if still open)

| |

menu_table_update | Date | Timestamp

## SQL Snippets

List all menu items that contain the word "Pepsi" in the United States.

```

--Locations selling "Pepsi" in the US

SELECT

'PEPSI' AS BRAND_GROUP,

LOCATION_CHAIN_NAME,

MENU_ITEM_LABEL,

MENU_ITEM_DESCRIPTION

FROM

UNIFIED_SCHEMA.MENU_ITEMS_SAMPLE

WHERE

MENU_ITEM_PRICE != 0.00 AND

(LOWER(MENU_ITEM_DESCRIPTION) ILIKE '%pepsi%' OR

LOWER(MENU_ITEM_LABEL) ILIKE '%pepsi%') AND

LOCATION_COUNTRY = 'United States'

GROUP BY

LOCATION_CHAIN_NAME,

MENU_ITEM_LABEL,

MENU_ITEM_DESCRIPTION

ORDER BY

LOCATION_CHAIN_NAME,

MENU_ITEM_LABEL

;

```

 

 

List the items and prices on the menu at "Waffle House" chain in Georgia, USA.

```

--Waffle House Menu in Georgia

SELECT

LOCATION_CHAIN_NAME,

MENU_ITEM_LABEL,

MENU_ITEM_DESCRIPTION,

MENU_ITEM_PRICE

FROM

UNIFIED_SCHEMA.MENU_ITEMS_SAMPLE

WHERE

MENU_ITEM_PRICE != 0.00 AND

LOCATION_CHAIN_NAME = 'Waffle House' AND

LOCATION_STATE_PROVINCE = 'Georgia' AND

LOCATION_COUNTRY = 'United States'

GROUP BY

LOCATION_CHAIN_NAME,

MENU_ITEM_LABEL,

MENU_ITEM_DESCRIPTION,

MENU_ITEM_PRICE

ORDER BY

LOCATION_CHAIN_NAME,

MENU_ITEM_LABEL

;

```

 

 

Show the name, address, lat/long, or restaurants selling "Wings" in Buckhead neighborhood of Atlanta, GA.

```

--Locations selling "Wings" in Buckhead neighborhood of Atlanta

SELECT

'Wings' AS ON_THE_MENU,

LOCATION_CHAIN_NAME,

LOCATION_FULL_ADDRESS,

LOCATION_LAT,

LOCATION_LNG

FROM

UNIFIED_SCHEMA.MENU_ITEMS_SAMPLE

WHERE

MENU_ITEM_PRICE != 0.00 AND

(LOWER(MENU_ITEM_DESCRIPTION) ILIKE '%wings%' OR

LOWER(MENU_ITEM_LABEL) ILIKE '%wings%') AND

LOCATION_COUNTRY = 'United States' AND

(LOCATION_ZIP_POSTAL = '30305' OR

LOCATION_ZIP_POSTAL = '30326' OR

LOCATION_ZIP_POSTAL = '30327' OR

LOCATION_ZIP_POSTAL = '30309' OR

LOCATION_ZIP_POSTAL = '30342' )

GROUP BY

LOCATION_CHAIN_NAME,

LOCATION_FULL_ADDRESS,

LOCATION_LAT,

LOCATION_LNG

ORDER BY

LOCATION_CHAIN_NAME,

LOCATION_FULL_ADDRESS

;

```