USDA FNDDS Ingredient-Nutrient Matrix avatar

USDA FNDDS Ingredient-Nutrient Matrix

Pricing

from $13.40 / 1,000 fndds nutrient records

Go to Apify Store
USDA FNDDS Ingredient-Nutrient Matrix

USDA FNDDS Ingredient-Nutrient Matrix

One fndds_nutrient_record per row of USDA FoodData Central's fndds_ingredient_nutrient_value table β€” a single nutrient value for an FNDDS ingredient in a given survey cycle β€” carried source-native and verbatim.

Pricing

from $13.40 / 1,000 fndds nutrient records

Rating

0.0

(0)

Developer

NexGen Watch

NexGen Watch

Maintained by Community

Actor stats

0

Bookmarked

2

Total users

1

Monthly active users

11 hours ago

Last modified

Share

πŸ”” USDA FNDDS Ingredient-Nutrient Matrix

One fndds_nutrient_record per row of USDA FoodData Central's fndds_ingredient_nutrient_value table β€” a single nutrient value for an FNDDS ingredient in a given survey cycle β€” carried source-native and verbatim, with the survey-cycle provenance on every record and the ingredient's FDC ID linkage preserved.

Differentiation: the filtered, provenance-complete FNDDS ingredientΓ—nutrient matrix straight from the official FDC dump β€” every value tagged with its source, SR AddMod year, and survey start/end dates, so you always know which cycle a number came from. Filter by ingredient, nutrient, or FDC ID; pay per delivered value.

Output is one fndds_nutrient_record row per result; billing is pay-per-event, the value event being one fndds nutrient record (a $0.02 start fee per run, then $0.02 per fndds nutrient record). Source: fdc.nal.usda.gov.

No login, no API key and no CAPTCHA solving are involved: the source is read logged-out with an identified contact User-Agent.

πŸ“Š Sample Output

USDA FNDDS Ingredient-Nutrient Matrix sample output β€” a table of real fndds nutrient record rows (ingredient_description, nutrient_value_source, start_date, end_date) from run Ht85335qaPwnxRRW1 on build 0.1.5

Real rows from run Ht85335qaPwnxRRW1 on build 0.1.5 (2026-09-19), the same input as the Quick start below β€” every value is as the source published it (emails masked, long text shortened):

ingredient_descriptionnutrient_value_sourcestart_dateend_datesurvey_cyclerelease_date
Butter, saltedSR Legacy2017-01-012018-12-312017-01-01-2018-12-312026-04-30
Butter, saltedSR Legacy2017-01-012018-12-312017-01-01-2018-12-312026-04-30
Butter, saltedSR Legacy2017-01-012018-12-312017-01-01-2018-12-312026-04-30
Butter, saltedSR Legacy2017-01-012018-12-312017-01-01-2018-12-312026-04-30
Butter, saltedSR Legacy2017-01-012018-12-312017-01-01-2018-12-312026-04-30
Butter, saltedSR Legacy2017-01-012018-12-312017-01-01-2018-12-312026-04-30
Butter, saltedSR Legacy2017-01-012018-12-312017-01-01-2018-12-312026-04-30
Butter, saltedSR Legacy2017-01-012018-12-312017-01-01-2018-12-312026-04-30

The run finished with the status message: NORMAL: 50 unique rows (0 duplicates collapsed) from 2026-04-30. billable=50

βœ… What you get

Each row is flat JSON with these fields (from the dataset schema and the sample run; a field the source does not publish for a given row is null):

  • record_type (string/null) β€” e.g. fndds_nutrient_record
  • ingredient_code (string/null) β€” e.g. 1001
  • ingredient_description (string/null) β€” e.g. Butter, salted
  • nutrient_code (string/null) β€” e.g. 203
  • nutrient_value (string/null) β€” e.g. 0.85
  • nutrient_value_source (string/null) β€” e.g. SR Legacy
  • fdc_id (string/null) β€” e.g. 173410
  • derivation_code (string/null) β€” e.g. NC
  • sr_addmod_year (string/null) β€” e.g. 1976
  • foundation_year_acquired (string/null) β€” e.g. 0
  • start_date (string/null) β€” e.g. 2017-01-01
  • end_date (string/null) β€” e.g. 2018-12-31
  • survey_cycle (string/null) β€” e.g. 2017-01-01-2018-12-31
  • source_url (string/null) β€” e.g. https://fdc.nal.usda.gov/food-details/173410/nutrients
  • source (string/null) β€” e.g. usda-fndds-ingredient-nutrient-matrix
  • release_date (string/null) β€” e.g. 2026-04-30
  • observed_at (string/null) β€” e.g. 2026-09-19T02:10:59Z
  • release_checksum (string/null) β€” e.g. 6a860d85-1cb35fb7
  • license (string/null) β€” e.g. USDA FoodData Central β€” CC0 1.0 (public domain dedication). Cite: U.S. Departmen
  • attribution (string/null) β€” e.g. USDA Agricultural Research Service β€” FoodData Central (https://fdc.nal.usda.gov)
  • terminal (string/null) β€” null in every sample row
  • scope (string/null) β€” null in every sample row
  • note (string/null) β€” null in every sample row
  • reported_total (string/integer/null) β€” null in every sample row
  • raw_seen (string/integer/null) β€” null in every sample row
  • duplicates (string/integer/null) β€” null in every sample row
  • unique_found (string/integer/null) β€” null in every sample row
  • delivered (string/integer/null) β€” null in every sample row

βœ… What you get

  • record_type (string/null) β€” e.g. fndds_nutrient_record
  • ingredient_code (string/null) β€” e.g. 1001
  • ingredient_description (string/null) β€” e.g. Butter, salted
  • nutrient_code (string/null) β€” e.g. 203
  • nutrient_value (string/null) β€” e.g. 0.85
  • nutrient_value_source (string/null) β€” e.g. SR Legacy
  • fdc_id (string/null) β€” e.g. 173410
  • derivation_code (string/null) β€” e.g. NC
  • sr_addmod_year (string/null) β€” e.g. 1976
  • foundation_year_acquired (string/null) β€” e.g. 0
  • start_date (string/null) β€” e.g. 2017-01-01
  • end_date (string/null) β€” e.g. 2018-12-31
  • survey_cycle (string/null) β€” e.g. 2017-01-01-2018-12-31
  • source_url (string/null) β€” e.g. https://fdc.nal.usda.gov/food-details/173410/nutrients
  • source (string/null) β€” e.g. usda-fndds-ingredient-nutrient-matrix
  • release_date (string/null) β€” e.g. 2026-04-30
  • observed_at (string/null) β€” e.g. 2026-09-19T01:24:34Z
  • release_checksum (string/null) β€” e.g. 6a860d85-1cb35fb7
  • license (string/null) β€” e.g. USDA FoodData Central β€” CC0 1.0 (public domain dedication). Cite: U.S. Departmen
  • attribution (string/null) β€” e.g. USDA Agricultural Research Service β€” FoodData Central (https://fdc.nal.usda.gov)
  • terminal (string/null) β€” null in every sample row
  • scope (string/null) β€” null in every sample row
  • note (string/null) β€” null in every sample row
  • reported_total (string/integer/null) β€” null in every sample row
  • raw_seen (string/integer/null) β€” null in every sample row
  • duplicates (string/integer/null) β€” null in every sample row
  • unique_found (string/integer/null) β€” null in every sample row
  • delivered (string/integer/null) β€” null in every sample row

Survey-cycle provenance (on every record)

nutrient_value_source, sr_addmod_year, foundation_year_acquired, start_date, end_date, and a composite survey_cycle (start–end) β€” all carried verbatim, so each nutrient value is anchored to its survey cycle. fdc_id preserves the ingredient's FoodData Central linkage.

βš™οΈ Sample inputs

1. Quick start β€” the Store example (this is what the sample above came from)

{
"ingredientCodes": [
"1001"
],
"maxRecords": 10,
"maxScanRows": 40000
}

The sample run charged exactly: 1 Γ— $0.02 apify-actor-start + 50 Γ— $0.02 fndds_nutrient_record = $1.02 on the Free tier β€” every delivered row was billed.

2. A smaller, narrowed run

{
"ingredientCodes": [
"1001"
],
"maxRecords": 5,
"maxScanRows": 40000
}

Caps the run at 5 rows β€” about $0.12 on the Free tier ($0.02 start + 5 Γ— $0.02).

3. A full-size run

{
"ingredientCodes": [
"1001"
],
"maxRecords": 2500,
"maxScanRows": 40000
}

Up to 2500 rows (the schema default for maxRecords) β€” about $50.02 on the Free tier ($0.02 start + 2500 Γ— $0.02) if the source has that many.

4. A filtered run

{
"ingredientCodes": [
"1001"
],
"maxRecords": 10,
"maxScanRows": 40000,
"fieldMatch": {
"ingredient_description": "Butter, salted"
}
}

Keeps only rows whose ingredient_description contains Butter, salted (a value from the sample run above), matched case-insensitively after the source is read and before the maxRecords cap, so the cap counts matches and only delivered matches are billed. searchText does the same across every column. Zero matches end the run as EMPTY_SELECTION with no row charged β€” if the source has moved on since that sample run, pick a value you see in your own first run. The source is still read in full β€” this narrows what you receive and pay for, not what the source serves.

🧾 JSON sample record

One real record from run Ht85335qaPwnxRRW1, exactly as it lands in the dataset (emails masked, long text shortened):

{
"record_type": "fndds_nutrient_record",
"ingredient_code": "1001",
"ingredient_description": "Butter, salted",
"nutrient_code": "203",
"nutrient_value": "0.85",
"nutrient_value_source": "SR Legacy",
"fdc_id": "173410",
"derivation_code": null,
"sr_addmod_year": "1976",
"foundation_year_acquired": "0",
"start_date": "2017-01-01",
"end_date": "2018-12-31",
"survey_cycle": "2017-01-01-2018-12-31",
"source_url": "https://fdc.nal.usda.gov/food-details/173410/nutrients",
"source": "usda-fndds-ingredient-nutrient-matrix",
"release_date": "2026-04-30",
"observed_at": "2026-09-19T02:10:59Z",
"release_checksum": "6a860d85-1cb35fb7",
"license": "USDA FoodData Central β€” CC0 1.0 (public domain dedication). Cite: U.S. Department of Agriculture, Agricultural Research Service, FoodData Central.",
"attribution": "USDA Agricultural Research Service β€” FoodData Central (https://fdc.nal.usda.gov)"
}

πŸ”§ How it works

Source. The actor reads fdc.nal.usda.gov β€” endpoints: https://fdc.nal.usda.gov, https://fdc.nal.usda.gov/fdc-datasets/FoodData_Central_csv_. Public pages and feeds only; nothing behind a login.

Transport. Plain HTTPS from the Apify platform, no proxy. robots.txt is read first and a disallowed path is never fetched. Every request carries an identified contact User-Agent. Pacing: CRAWL_DELAY=0.0.

Terminal states. A run ends NORMAL, CAPPED (your cap was reached), PARTIAL (something was withheld and the message says what), GENUINE_EMPTY (the source was read and truly had nothing in scope) or BLOCKED (the source refused or changed shape β€” the run FAILS loud and bills nothing). A zero-row run is never reported as a silent success.

Charging. Each fndds nutrient record is charged at the moment it is pushed (fndds_nutrient_record); a row that fails to charge is not delivered, so the dataset count always equals the charged count.

πŸ”§ How it works

Source

The official USDA FoodData Central full-CSV dump only β€” https://fdc.nal.usda.gov/fdc-datasets/FoodData_Central_csv_<release>.zip (newest release auto-resolved; fndds_ingredient_nutrient_value.csv member). robots.txt is User-agent: * / Disallow: (nothing disallowed). The FDC API and search routes are never touched. Release date + archive checksum (ETag) ride on every record.

Filters (at least one required)

ingredientCodes Β· nutrientCodes Β· fdcIds. No filter β†’ a loud, unbilled Block. Output is capped by maxRecords (default 2500, max 5000) and bounded by maxScanRows.

What it does NOT do

No diet or health verdict of any kind. Values are USDA's own survey figures, carried verbatim; this actor makes no nutritional determination.

Licence

USDA FoodData Central β€” CC0 1.0 (public domain dedication); the dumps add no new rights. Cite: U.S. Department of Agriculture, Agricultural Research Service, FoodData Central (https://fdc.nal.usda.gov).

Billing

Pay-per-event. fndds_nutrient_record is charged once per delivered record ($0.02), GOLD-floored βˆ’10 / βˆ’20 / βˆ’33% volume ladder. apify-actor-start ($0.02) is platform-reserved, never charged in code.

What is not done. No login, no cookie or CAPTCHA bypass, no private or personal-account data, no browser automation.

πŸ’° Pricing example

EventFreeBronzeSilverGold
Actor Start (apify-actor-start)$0.02$0.02$0.02$0.02
Fndds Nutrient Record (fndds_nutrient_record)$0.02$0.018$0.016$0.0134

Worked at the live Free-tier price:

  • 8 fndds nutrient records: $0.02 start + 8 Γ— $0.02 = $0.18
  • 25 fndds nutrient records: $0.02 start + 25 Γ— $0.02 = $0.52
  • 2500 fndds nutrient records: $0.02 start + 2500 Γ— $0.02 = $50.02

A run that delivers zero rows charges the $0.02 start fee only. A BLOCKED run (source refused) fails loud and charges no value event. The start fee is charged once per GB of run memory; the default run memory is 4096 MB.

Yield on the sample run: NORMAL: 50 unique rows (0 duplicates collapsed) from 2026-04-30. billable=50. maxRecords is a hard ceiling on what is delivered and billed, never a target.

This actor reads public, logged-out pages and feeds published by fdc.nal.usda.gov. It collects only what the source publishes to any visitor, keeps to the source's robots rules (checked on every run), identifies itself with a contact User-Agent, and does not access accounts, private data or anything behind authentication. Use the output in line with the source's terms and your local law; the intended use is B2B research and monitoring.

❓ FAQ

Q: Do I need an API key or a login?
A: No. The source (fdc.nal.usda.gov) is read logged-out; the input schema has no key field and the actor carries no secrets.

Q: Why did my run return 0 rows?
A: Read the run's status message. GENUINE_EMPTY means the source was read and had nothing in scope for your input; BLOCKED means the source refused and the run failed without billing a value event β€” retry later or narrow the input. A zero-row run bills the start fee only.

Q: How many rows can one run return?
A: Up to maxRecords (default 2500). Raise the cap for a bigger run; you pay per delivered row.

Q: How fresh is the data?
A: Every run reads the source live at run time; nothing is cached between runs. Put it on a schedule for a continuous feed.

Q: What formats can I export?
A: The dataset downloads as JSON, CSV, Excel, XML or RSS from the run's Dataset tab or the Apify API, and any run can push to a webhook or integration.

Q: How is this different from the other NexGen Watch actors actors?
A: Same output shape and billing model; this one covers fdc.nal.usda.gov. The siblings under Related Actors cover the other sources or slices β€” run several on one schedule for a combined feed.

Q: Are there rate limits?
A: The actor paces itself against the source (CRAWL_DELAY=0.0) and honours its robots rules; there is no per-buyer limit beyond your Apify plan's concurrency.

πŸ†˜ Troubleshooting

  • Run FAILED with BLOCKED β†’ the source refused the request or changed its page shape β†’ nothing was billed beyond the start fee; retry after a while, and if it persists open an Issue with the run id.
  • Status says CAPPED β†’ your cap (maxRecords) was reached β†’ raise it for a bigger run.
  • Input validation error on start β†’ a field is outside the schema's allowed values β†’ start from the Quick start block and change one field at a time.
  • Run TIMED-OUT β†’ a very wide request on a slow day β†’ raise the run timeout in Run options or narrow the input; what was delivered before the timeout is still in the dataset.
  • USDA FDC Nutrient Observation Matrix β€” One nutrient_observation per row of USDA FoodData Central's food_nutrient table β€” the analytical observation as USDA records it: amount, data_points,…
  • USDA FDC Portion / Serving Weight Master β€” One food_portion_record per row of USDA FoodData Central's food_portion table β€” a food's serving/portion definition: portion ID, food FDC ID, serving…
  • USDA FDC Product Update Ledger β€” One food_update_record per entry in USDA FoodData Central's own product update log β€” the FDC id, the product description, and the last_updated date,…
  • USGS Earthquake Events Scraper β€” Scrape USGS earthquake events (FDSN): magnitude, location, depth, time and event ID. One record per result. Pay per result
  • USGS MRDS Mineral Occurrence Master β€” One structured occurrence record per USGS Mineral Resource Data System (MRDS) deposit β€” the source-native dep_id, deposit name, commodities, coordina…
  • Washington Contractor License Registry β€” One record per Washington L&I contractor licence/registration (number, type, effective/expiry, licence status + suspension date, UBI, principal) from…
  • 🏒 About NexGenData β€” NexGen Watch is NexGenData's fleet of more than 300 public data actors built on official sources, pay-per-result. Browse the catalog at apify.com/nexgenwatch.

⭐ Found this useful?

If this actor saved you a manual check, a quick review on the Apify Store helps other teams find it. Feature request or a source that changed? Open it from the Issues tab β€” every one is read.