Skip to main content

fooddata

Download, build, and query the USDA food database.

Do you know what you are putting in your body?

Installation

$ pip install fooddata --upgrade

Usage

$ fooddata build
$ fooddata query "SELECT * from foods WHERE category_id IS NOT NULL LIMIT 100;" --json | jq .
$ fooddata query "SELECT * from foods WHERE category_id IS NOT NULL LIMIT 100;" --json > output2.json
$ fooddata query "SELECT * from food_nutrients_v WHERE food_type IS NOT NULL AND food_category IS NOT NULL LIMIT 1000;" --json | jq .

Update Database

To update the database, just run the first command again:

$ fooddata build

Note

The data comes from the USDA website: https://fdc.nal.usda.gov/download-datasets.html

Metadata

Release files for fooddata 0.1.1

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for fooddata 0.1.1
File Size Uploaded Provenance Actions
fooddata-0.1.1.tar.gz 4.3 kB Without provenance Details for fooddata-0.1.1.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for fooddata 0.1.1
File Interpreter ABI Platform Actions
fooddata-0.1.1-py3-none-any.whl Python 3 none any Details for fooddata-0.1.1-py3-none-any.whl

Total release size: 9.4 kB

Release files / fooddata-0.1.1.tar.gz

Download URL fooddata-0.1.1.tar.gz
Size 4.3 kB
Tags Source
SHA-256 checksum
How to use checksums
d540581072b1c6d25585e633dd90ea5c75bb8f021772a78fdc4e282ae181a767
BLAKE2b-256 checksum
How to use checksums
512cba230a243598476c1b11bfce95c9bb1f808f0c7ae65cd67499c2f1c4cc68
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via poetry/1.0.10 CPython/3.8.5 Darwin/19.6.0

Release files / fooddata-0.1.1-py3-none-any.whl

Download URL fooddata-0.1.1-py3-none-any.whl
Size 5.1 kB
Tags Python 3
SHA-256 checksum
How to use checksums
d979a490840af788be2d0cd13ab5c9af6344ea2bff60fd7807dac19c2666a196
BLAKE2b-256 checksum
How to use checksums
37c6562b99acf71154450f4a7f6ee3230aeeb0033f8e841ffb0be79711011049
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via poetry/1.0.10 CPython/3.8.5 Darwin/19.6.0

Security for fooddata 0.1.1

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Release history Release notifications | RSS feed

This release

0.1.1 This release

2 release files No provenance

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page