Dataset: DOHMH MenuStat (Historical)

About this Dataset

DOHMH MenuStat (Historical)

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
Organization: City of New York
Last updated: 2020-11-10T17:04:45.427865
Tags: chain, food, menustat, nutrition, restaurant

Tables

Table 1

@usgov.city_of_new_york_dohmh_menustat.table_1

5.83 MB
65219 rows
49 columns


CREATE TABLE table_1 (
  "menu_item_id" BIGINT,
  "year" BIGINT,
  "restaurant_item_name" VARCHAR,
  "restaurant" VARCHAR,
  "restaurant_id" BIGINT,
  "item_name" VARCHAR,
  "item_description" VARCHAR,
  "food_category" VARCHAR,
  "serving_size" DOUBLE,
  "serving_size_text" VARCHAR,
  "serving_size_unit" VARCHAR,
  "serving_size_household" VARCHAR,
  "calories" DOUBLE,
  "total_fat" DOUBLE,
  "saturated_fat" DOUBLE,
  "trans_fat" DOUBLE,
  "cholesterol" DOUBLE,
  "sodium" DOUBLE,
  "potassium" DOUBLE,
  "carbohydrates" DOUBLE,
  "protein" DOUBLE,
  "sugar" DOUBLE,
  "dietary_fiber" DOUBLE,
  "calories_100g" DOUBLE,
  "total_fat_100g" DOUBLE,
  "saturated_fat_100g" DOUBLE,
  "trans_fat_100g" DOUBLE,
  "cholesterol_100g" DOUBLE,
  "sodium_100g" DOUBLE,
  "potassium_100g" DOUBLE,
  "carbohydrates_100g" DOUBLE,
  "protein_100g" DOUBLE,
  "sugar_100g" DOUBLE,
  "dietary_fiber_100g" DOUBLE,
  "calories_text" VARCHAR,
  "total_fat_text" VARCHAR,
  "saturated_fat_text" VARCHAR,
  "trans_fat_text" VARCHAR,
  "cholesterol_text" VARCHAR,
  "sodium_text" VARCHAR,
  "potassium_text" VARCHAR,
  "carbohydrates_text" VARCHAR,
  "protein_text" VARCHAR,
  "sugar_text" VARCHAR,
  "dietary_fiber_text" VARCHAR,
  "kids_meal" BIGINT,
  "limited_time_offer" BIGINT,
  "regional" BIGINT,
  "shareable" BIGINT
);