cityofnewyork-us/dohmh-menustat-historical-qgc5-ecnb
Icon for Socrata external plugin
 
Readme
Updated 7 months ago
Indexed 5 hours ago

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

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofnewyork-us/dohmh-menustat-historical-qgc5-ecnb\".\"dohmh_menustat_historical\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • dohmh_menustat_historical
     
Upstream Metadata