tsterbak/data-mcdonalds-nutritionfacts

Free, open source data set describing McDonalds Nutrition Facts for popular menu items in SQL, SQLite, JSON, Excel, OpenOffice Spreadsheet, Google Sheets, TSV, etc. Updated November 2015. :hamburger: :fries: :cookie: :cake:

McDonalds Nutrition Facts

• Free, libre and open source data set describing McDonald's Nutrition Facts.
• Use the latest stable release for research.
• November 2015 Refresh.
• Used in CalorieCat for McDonalds app.

PROJECT SCOPE

• This project only demonstrates extraction, transformation and loading of McDonald's Nutrition Facts data.
• See documentation for ETL process details specific to this project.

DATA FORMATS

VERSION 29 (STABLE)

• November 2015 Refresh (Update 3)
• Source data from November 5, 2015.
• Formats Available:
  • Textfiles
  • Spreadsheet Workbooks
  • Android XML
  • JSON

VERSION 26 (STABLE)

• November 2015 Refresh (Update 1).
• Source data from October 29, 2015.
• Uses new menu structure introduced by addition of All Day Breakfast menu.
• Formats Available:
  • Textfiles
  • Spreadsheet Workbooks
  • Android XML
  • JSON

VERSION 23 (STABLE)

• November 2015 Refresh.
• Source data from October 29, 2015.
• New Menu Category Structure
• Formats Available:
  • Textfiles
  • Spreadsheet Workbooks

NOTE: Table generated in Google Spreadsheets with the MarkdownTableMaker Add-On.

CATEGORY	CODE
Burgers & Sandwiches	BURGERSANDWICH
Chicken & Fish	CHICKENFISH
Breakfast	BREAKFAST
Salads	SALAD
Snacks and Sides	SNACKSIDE
Beverages	BEVERAGE
McCafe	MCCAFE
Dessert & Shakes	DESSERTSHAKE
Condiments	CONDIMENT
All Day Breakfast	ALLDAYBREAKFAST

VERSION 22 (pre-release)

• Source data from October 29, 2015.
• Partial ETL solution available for this release.
• No item categories for this release.

VERSION 21 (pre-release)

• Source data from October 13, 2015.
• No ETL solution available for this release.
• No item categories for this release.

VERSION 3

• Data from May 2015.
• 412 menu items processed.

VERSION 2

• Data from March 2015.
• 433 menu items processed.

VERSION 1

• Data from June 2014.
• 393 menu items processed.

POSSIBLE FORMATS

• Oracle, MariaDB, SQLite, SQL Server

MCDONALDS MENU STRUCTURE

• McDonald's is a quick service restaurant concept designed to provide a fast, convenient and rewarding guest experience.

• McDonald's has optimized its supply chain to offer several healthy items for breakfast, lunch and dinner. Many locations are open 24 hours.

• Some menu items are in more than one category.

FORMATS

Android XML

• Provides a safe, portable data format for Android apps.
• Does not require special permissions for read access.

JSON

• Stable, serialized data transport.
• JSON: JavaScript Object Notation.
• Very portable and processed by most modern languages.

SQLITE

• Flexible, self-containted, serverless, zero-config, transactional SQL database engine.

TEXTFILES

• Most compatible format.
• TSV: tab-separated value files.
• CSV: comma-separated value files.
• Nicely-formatted on GitHub. You can even search within the file on GitHub.

WORKBOOKS

• Spreadsheet workbooks organize data into a single file.
• Spreadsheets usually require viewers or editors.
• You can import XLSX or ODS spreadsheets into Google Drive Sheets.
• You can also import the spreadsheets into Zoho Docs Spreadsheets.
• Open XLSX in Microsoft Excel.
• Open ODS in LibreOffice.

REFERENCE

• McDonald's USA Nutrition Facts for Popular Menu Items

DISCLAIMER

This project is neither endorsed by nor affliated with any McDonald's®, McDonald's® stores, McDonald's Corporation, McDonald's franchisees or any other affliated brands or entities. Nutrition information is subject to change without prior notice. Please contact McDonald's® for the latest information.