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
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.