Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

DOHMH MenuStat (Historical)

qgc5-ecnbHealth49 columns
MenuStat.org is an interactive online database of nutrition and menu information from top national restaurant chains. Each item is coded a mutually exclusive food category and descriptive information is coded into binary variables (e.g. on the kids menu). A new year of data is added annually and individual menu items are linked over time with a unique ID, allowing for trend analyses. On MenuStat.org, menu items that can be ordered together as part of a customizable or combination meal are linked together by a unique ID (Customizable_Build_ID) and all data can be exported for further analyses. NYC DOHMH developed and maintains MenuStat, but it is hosted externally
View on NYC Open Data↗

Quality

D65.8 / 100

From a 500-row sample across 35 columns.

completeness62/ 25% weight
consistency60/ 20% weight
accuracy97/ 20% weight
timeliness0/ 15% weight
usability95/ 20% weight

Related datasets

  • NYC Condom Availability Program - HIV condom distribution locations0.31
  • Self-Reported Drinking Water Tank Inspection Results0.30
  • DOHMH Community Mental Health Survey0.29
    joins onyear
  • New York City Work and Family Leave Survey (WFLS) 20140.29
  • DOHMH School Cafeteria Inspections (2020-Present)0.29
  • New York City Locations Providing Seasonal Flu Vaccinations0.29
  • Recognized Shop Healthy Stores0.28

Sample rows

menu_item_idyearrestaurant_item_namerestaurantrestaurant_iditem_nameitem_descriptionfood_categorykids_meallimited_time_offerregionalshareable
17004020187 Eleven 100% Colombian Coffee7 Eleven1100% Colombian Coffee100% Colombian Coffee, Coffee, Start My Day, Thirsty, At Participating LocationsBeverages0010

Columns

49 queryable · 49 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
menu_item_idtextA unique identifier for each item. When the same item is served by a restaurant over multiple years it has an identical Menu Item ID to allow for tracking.0%139601999716715
yearcategoricalMenuStat data are collected annually in January.0%20172018of 2
restaurant_item_nametextConcatenated variable of Restaurant and Item Name0%BJ's Restaurant & Brewho…Jack in the Box POWERade…Jack in the Box Fanta Ze…
restauranttextRestaurant name

Query this from your own app

GET /api/datasets/qgc5-ecnb
GET /api/datasets/qgc5-ecnb/quality
GET /api/datasets/qgc5-ecnb/related
GET /api/columns?dataset=qgc5-ecnb
  • Youth Behavior Risk Survey (High School)0.28
    joins onyear
    • 170093
    2018
    7 Eleven 10 For $2 Mini Tacos
    7 Eleven
    1
    10 For $2 Mini Tacos
    10 For $2 Mini Tacos, Late Night, Deals, Hot Snacks, Meals, Snacks; Choice of: Beef or Chicken Chile Verde
    Sandwiches
    0
    0
    0
    0
    15002320187 Eleven 2 for $1.69 Any Ring Donut7 Eleven12 for $1.69 Any Ring Donut2 for $1.69 Any Ring Donut, Bakery, Start My Day, SnacksBaked Goods0000
    17006720187 Eleven 5 For $4 Grill Mix N Match7 Eleven15 For $4 Grill Mix N Match5 For $4 Grill Mix N Match, Snacks, Hot Snacks, Late Night, Deals, MealsEntrees0000
    17011220187 Eleven 6 Mini Breakfast Sausage Empanadas7 Eleven16 Mini Breakfast Sausage Empanadas6 Mini Breakfast Sausage Empanadas w/ Sausage, Egg, Cheddar Cheese, Green Bell Peppers, Jalapenos & Dough, Start My DaySandwiches0000
    17002720187 Eleven 7-Select Cinnamon Roll Iced Cappuccino7 Eleven17-Select Cinnamon Roll Iced Cappuccino7-Select Cinnamon Roll Iced Cappuccino, 7-Select Snacks, Snacks, 7-Select Beverages, Late Night, Coffee, Start My Day, ThirstyBeverages0000
    11293520187 Eleven 7-Select GO!Smart Coconut Water7 Eleven17-Select GO!Smart Coconut Water7-Select GO!Smart Coconut Water, 7-Select Beverages, Late Night, Start My Day, Thirsty, 7-Select Snacks, Snacks; Choice of: Coconut or Pineapple CoconutBeverages0000
    17002920187 Eleven 7-Select Go!Smart Cold-Pressed Juices7 Eleven17-Select Go!Smart Cold-Pressed Juices7-Select Go!Smart Cold-Pressed Juices, 7-Select Snacks, Snacks, Late NightBeverages0000
    17001820187 Eleven All Butter Croissant7 Eleven1All Butter CroissantAll Butter Croissant, Bakery, Start My Day, SnacksBaked Goods0000
    17001920187 Eleven Apple Fritter7 Eleven1Apple FritterApple Fritter, Bakery, Start My Day, SnacksBaked Goods0000
    0%
    StarbucksDunkin' DonutsWawa
    restaurant_idintegerUnique Identifier for Restaurant0%803087
    item_nametextMenu item name0%Diet CokeSpriteCoffee
    item_descriptiontextMenu item name with additional menu information (e.g. menu item components)0%Chocolate Chip Cookie, D…Sausage Biscuit, Breakfa…Bottled Water, Drinks
    food_categorycategoricalEach menu item is coded into a mutually exclusive food category0%BeveragesToppings & IngredientsEntreesof 12
    serving_sizeintegerServing size in grams or ounces when reported by restaurants59%161224
    serving_size_textcategoricalServing size reported in a non-specific value100%14.00-56.00oz7.00-28.00of 15
    serving_size_unitcategoricalServing size in grams or ounces when reported by restaurants. For a limited number of items, serving size was converted to grams for foods and to ounces for beverages; these cases are marked by an asterisk.59%gfl ozozof 4
    serving_size_householdtextHousehold metric reported to describe serving size77%1 Slice1 SandwichLarge
    caloriesinteger—15%0170150
    total_fatinteger—16%069
    saturated_fatfloat—17%065
    trans_fatfloat—21%010.5
    cholesterolinteger—18%01020
    sodiuminteger—16%01015
    potassiumtext—98%05035
    carbohydratesinteger—17%012
    proteininteger—17%012
    sugarinteger—19%021
    dietary_fiberfloat—18%012
    calories_100gintegerNutrient density is calculated by standardizing the serving size to 100 g when serving size and nutrient information is reported by the restaurant.60%0441
    total_fat_100gintegerNutrient density is calculated by standardizing the serving size to 100 g when serving size and nutrient information is reported by the restaurant.61%012
    saturated_fat_100gintegerNutrient density is calculated by standardizing the serving size to 100 g when serving size and nutrient information is reported by the restaurant.61%012
    trans_fat_100gcategoricalNutrient density is calculated by standardizing the serving size to 100 g when serving size and nutrient information is reported by the restaurant.63%012of 16
    cholesterol_100gintegerNutrient density is calculated by standardizing the serving size to 100 g when serving size and nutrient information is reported by the restaurant.61%017
    sodium_100gintegerNutrient density is calculated by standardizing the serving size to 100 g when serving size and nutrient information is reported by the restaurant.60%023
    potassium_100gtextNutrient density is calculated by standardizing the serving size to 100 g when serving size and nutrient information is reported by the restaurant.99%0260
    carbohydrates_100gintegerNutrient density is calculated by standardizing the serving size to 100 g when serving size and nutrient information is reported by the restaurant.61%01213
    protein_100gintegerNutrient density is calculated by standardizing the serving size to 100 g when serving size and nutrient information is reported by the restaurant.61%012
    sugar_100gintegerNutrient density is calculated by standardizing the serving size to 100 g when serving size and nutrient information is reported by the restaurant.61%021
    dietary_fiber_100gintegerNutrient density is calculated by standardizing the serving size to 100 g when serving size and nutrient information is reported by the restaurant.61%012
    calories_texttextNutrient reported in a non-specific value100%<50-5110-550
    total_fat_texttextNutrient reported in a non-specific value100%68-70'1-565-68
    saturated_fat_texttextNutrient reported in a non-specific value100%'1-323-240-1
    trans_fat_textcategoricalNutrient reported in a non-specific value100%'1-30-1'1-6of 7
    cholesterol_texttextNutrient reported in a non-specific value99%<5'1-441.2-46.6
    sodium_texttextNutrient reported in a non-specific value100%'3-10'3-110-35
    potassium_textcategoricalNutrient reported in a non-specific value100%<1450-470of 2
    carbohydrates_texttextNutrient reported in a non-specific value99%<199-1050-1
    protein_texttextNutrient reported in a non-specific value99%<1'10-4059-60
    sugar_texttextNutrient reported in a non-specific value99%<1'9-11'6-25
    dietary_fiber_texttextNutrient reported in a non-specific value99%<1'8-9-1
    kids_mealcategoricalCoded as ‘1’ if the restaurant describes the item as being for kids. Items described as for kids and adults (e.g. kids fries = small fries) says ‘Kids and Adults Menu’ in the Item Description.0%01of 2
    limited_time_offercategoricalCoded as ‘1’ if the restaurant describes the item as a limited time offer or seasonal.0%01of 2
    regionalcategoricalCoded as ‘1’ if the restaurant describes the item as regional (e.g. Midwest states only or at participating locations only).0%01of 2
    shareablecategoricalCoded as ‘1’ if the restaurant describes the item as shareable and the nutrition cannot be divided in to a single serving (e.g. carafes, whole pies, quarts of ice cream, 2 liter drinks).0%01of 2