For the discerning health addict, biohacking enthusiast, or data scientist.
View Demo
·
Report Bug
·
Request Feature
Table of Contents
The USDA provides yearly and bi-annual support for the FoodData_Central database however access to their database is limited through an https limited and throttled API. This project has laid the groundwork to maintain the database yourself which cleans up some of the performance and schema accuracy mistakes in the original FDC. Invalid data with obvious typos causing parsing issues has been corrected. The schemas can be applied quickly by using the 2021 Access file here. And the migrations to make it current can be run quickly via the DDLs.
Here's why:
- This dataset is often used for practice problems at Ivy League universities for Data Scientists, but they typically run the solutions on data from 2021 which is effectively old and useless.
- If you are a health or biohacking enthusiast this data is invaluable, please pay it forward by contributing to the project.
This section should list any major frameworks/libraries used to bootstrap your project. Leave any add-ons/plugins for the acknowledgements section. Here are a few examples.
This is an example of how you may give instructions on setting up your project locally. To get a local copy up and running follow these simple example steps.
This is an example of how to list things you need to use the software and how to install them.
- download and install mssql 2016 https://www.microsoft.com/en-us/sql-server/sql-server-2016
- Complete migrations up until April 2024
- Complete database Schema updates
- Migration Performance Improvements
- Database Performance Improvements
- Multi-language Support
- Chinese
- Spanish
See the open issues for a full list of proposed features (and known issues).
Contributions are what make the open source community such an amazing place to learn, inspire, and create. Any contributions you make are greatly appreciated.
If you have a suggestion that would make this better, please fork the repo and create a pull request. You can also simply open an issue with the tag "enhancement". Don't forget to give the project a star! Thanks again!
- Fork the Project
- Create your Feature Branch (
git checkout -b feature/AmazingFeature) - Commit your Changes (
git commit -m 'Add some AmazingFeature') - Push to the Branch (
git push origin feature/AmazingFeature) - Open a Pull Request from the github site.
Distributed under the MIT License. See LICENSE.txt for more information.
Your Name - @kjr247 - [email protected]
Project Link: https://github.com/kjr247/food-data-central-db
Use this space to list resources you find helpful and would like to give credit to. I've included a few of my favorites to kick things off!