Property talk:P1978

Documentation

USDA NDB number
identifier for a food item in the United States Department of Agriculture National Nutrient Database

Associated item

United States Department of Agriculture (Q501542)

Applicable "stated in" value

USDA National Nutrient Database (Q7866379)

Data type

External identifier

Domain

food items (note: this should be moved to the property statements)

Allowed values

\d{5}

Example

apple (Q89) → 09003
buttermilk (Q106612) → 1088
oyster (Q107411) → 15167

Source

https://fdc.nal.usda.gov/index.html

Formatter URL

https://fdc.nal.usda.gov/fdc-app.html#/?query=$1

Tracking: usage

Category:Pages using Wikidata property P1978 (Q47455112)

Related to country

United States of America (Q30) (See 762 others) (United States of America (Q30))

Lists

Proposal discussion

Current uses

Total	1,442
Main statement	1,437	99.7% of uses
Qualifier	3	0.2% of uses
Reference	2	0.1% of uses

Search for values

[create Create a translatable help page (preferably in English) for this property to be included here]

Format “\d+”: value must be formatted using this pattern (PCRE syntax). (Help)

List of violations of this constraint: Database reports/Constraint violations/P1978#Format, hourly updated report, SPARQL

Distinct values: this property likely contains a value that is different from all other items. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P1978#Unique value, SPARQL (every item), SPARQL (by value)

Single value: this property generally contains a single value. (Help)

Allowed entity types are Wikibase item (Q29934200): the property may only be used on a certain entity type (Help)

Scope is as main value (Q54828448), as reference (Q54828450): the property must be used by specified way only (Help)

This property is being used by:

Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.)

v t e United States of America (Q30)-related properties

Art & culture	NRHP reference number DPLA ID Library of Congress Control Number (LCCN) (bibliographic) CLARA-ID MPA film rating Smithsonian American Art Museum person/institution ID Cooper-Hewitt person ID Museum of Modern Art work ID Library of Congress JukeBox ID (former scheme) Museum of Modern Art artist ID National Gallery of Art artist ID J. Paul Getty Museum agent DOR ID (old) J. Paul Getty Museum object ID Smithsonian trinomial AFI Catalog of Feature Films ID The Met object ID Carnegie Hall agent ID YCBA agent ID DPLA subject term DAHR artist ID LACMA ID Museum of Fine Arts, Boston object ID Philadelphia Museum of Art work ID Museum of Fine Arts, Houston object ID Indianapolis Museum of Art artwork ID National Gallery of Art artwork ID American Art Collaborative object ID Smithsonian American Art Museum artwork ID Walters Art Museum artwork ID Solomon R. Guggenheim Foundation artwork ID Yale Center for British Art artwork ID Brooklyn Museum artwork ID Inventories of American Painting and Sculpture control number BMI work ID ACE Repertory work ID Brooklyn Museum Exhibition ID SFMOMA artist ID Carnegie Hall event ID Carnegie Hall work ID American Film Institute person ID Poetry Foundation ID Poets.org poet ID Poetry Archive poet ID Poets & Writers author ID The Paris Review interviewee ID NYRB contributor ID Poetry Society of America poet ID MAPS poet ID LOA ID Marvel character ID National Cartoonists Society member ID LARB contributor ID Fandango film ID Los Angeles Review of Books author ID Tor.com author ID National Medal of Arts winner ID Pacific Coast Architecture Database person ID Museum Universe Data File ID California Office of Historic Preservation ID Encyclopedia of Appalachia ID Academy Awards Database film ID Academy Awards Database nominee ID National Portrait Gallery (United States) object ID NMSRCP reference number Pacific Coast Architecture Database building ID Pacific Coast Architecture Database firm ID National Book Foundation author ID National Book Foundation book ID Salvador Dali Museum artwork ID Whitney Museum of American Art artist ID Whitney Museum of American Art artwork ID SAH Archipedia architect ID SAH Archipedia building ID TCLF ID The Living New Deal ID NYARC Discovery ID Wisconsin National or State Registers Record ID National Park Service place ID LoC HABS/HAER/HALS place ID American Heritage place ID DC Historic Sites place ID Museum Day ID Georgia Museum of Art ID National Gallery of Art Library Bibliographic ID Smithsonian ARK ID Smithsonian trinomial format regex DC character ID George Eastman Museum people ID Pipe Organ Database organ ID HarperCollins product ID Met Constituent ID Cleveland Museum of Art ID Kress Collection Digital Archive ID Kress Collection Digital Archive ID Moviefone movie ID ‎The Criterion Collection spine number

Economy	SOC Code (2010) IRS Employer Identification Number NAICS code FRED time-series ID Charity Navigator ID Central Index Key Recreation.gov campground ID AAA campground ID DCinemaToday company ID ACE Repertory publisher ID

Education	Integrated Postsecondary Education Data System ID Classification of Instructional Programs code NCES district ID NCES school ID Carnegie Classification of Institutions of Higher Education Litchfield Ledger ID SEVIS school ID

Food & health	MedlinePlus ID NCI Thesaurus ID USDA PLANTS ID USDA NDB number NALT ID NIOSHTIC-2 ID National Drug Code NIOSH Numbered Publication ID National Provider Identifier Lambic.Info ID CVX vaccine code

Geography	GNIS Feature ID FIPS 55-3 (locations in the US) FIPS 6-4 USGS earthquake ID Wilderness Connect ID Bivouac.com mountain ID U.S. National Geodetic Survey ID NPCA ID National Park Foundation ID Recreation.gov gateway ID Recreation.gov point of interest ID Bivouac.com pass ID LoJ peak ID Park Alpha Code National Forest Foundation ID National Natural Landmarks site ID Rivers.gov protected area ID FIPS 5-2 alpha code (US states) FIPS 5-2 numeric code (US states) ISC event ID Geolex ID National Inventory of Dams ID ODOT county code

Military	military designation United States Navy aircraft designation United States Army and Air Force aircraft designation Hall of Valor ID United States Armed Forces service number Joint Electronics Type Designation Automated System designation Cullum number Atomic Heritage Foundation ID ABMC person ID Arlington Cemetery person ID American Battlefield Trust battlefield ID American Battlefield Trust ID (person)

Politics	US Congress Bio ID Federal Register Document Number US Federal Election Commission ID C-SPAN person numeric ID PolitiFact people and groups ID Ballotpedia ID OpenSecrets people ID United States Reports ID Minnesota legislator ID South Dakota legislator ID Vote Smart candidate ID United States Statutes at Large citation United States Public Law OpenSecrets organization ID C-SPAN organization ID National Governors Association biography URL SPLC individual ID Our Campaigns race ID Michigan Legislative Bio ID SPLC group ID United States House of Representatives ID

Sports & leisure	ESRB rating USCG MIC USOPC Hall of Fame ID Sports in the United States

Transportation	FAA airport code COSPAR ID lostbridges.org ID BridgeReports.com ID bridgehunter.com ID NASA biographical ID National Recreation Trails Database ID NGA lighthouse ID National Bridge Inventory Number USCG lighthouse ID America's Byways road ID Amtrak station code Smithsonian ARK ID SFMTA ID AARoads Wiki article ID

Nature	NCBI taxonomy ID Calflora ID National Forest Foundation ID CNPS ID Harvard botanical journal ID Center for Biological Diversity ID ECOS ID C.V. Starr Virtual Herbarium ID FEIS ID NOAA Fisheries Species Directory ID Alabama Plant Atlas ID Invasive Plant Atlas of the United States ID NAS ID Cal-IPC ID SEINet ID Harvard Index of Botanists ID ODNR Division of Wildlife ID Index to American Botanical Literature ID InciWeb ID Smithsonian ARK ID Washington Native Plant Society Plant Directory ID New York Flora Atlas ID Madrean Discovery Expeditions Flora Database ID Madrean Discovery Expeditions Fauna Database ID PLOS Thesaurus ID UConn Plant Database ID Flora of the Southeastern United States ID Go Botany taxon ID The Plant List ID (Arizona Native Plant Society) Flora of the Hawaiian Islands URL Montana Plant Life URL Mid-Atlantic Herbaria Consortium taxon ID Native Plants Hawaii ID SERNEC taxon ID TORCH taxon ID Penstemon Database ID CalPhotos taxon ID

Others	Library of Congress authority ID Mathematical Reviews ID Biographical Directory of Federal Judges alpha ID Library of Congress Format Description Document ID NCMEC person ID USHMM Holocaust Encyclopedia ID OSTI article ID American National Biography ID Chronicling America newspaper ID Library of Congress Demographic Group Terms ID Library of Congress Genre/Form Terms ID Thesaurus for Graphic Materials ID National Academy of Sciences member ID USNPL ID CSDE Lynching Database ID National Humanities Medal winner ID Historic Hotels of America ID CMI person ID Encyclopedia of Alabama ID Handbook of Texas ID Caselaw Access Project case ID Newseum newspaper front page ID Archives of Maryland Biographical Series ID US Quaternary Fault ID Library of Congress Medium of Performance Thesaurus ID Library of Congress Children's Subject Headings ID National Park Service people ID AAA attraction ID AAA hotel ID AAA restaurant ID Oxford African American Studies Center ID Archives West finding aid ID Smithsonian ARK ID Editorial Freelancers Association member ID U.S. trademark serial number Game Informer ID EIA plant ID Time.com author ID Archives West repository ID The Counted person ID Stage 32 profile ID Podbay ID ‎Biographical Directory of Federal Judges numeric ID Substack profile ID Fansly ID Metacritic game ID ‎Gematsu game ID Metacritic numeric game ID Metacritic publication ID Metacritic company ID Steam Workshop mod ID ‎Gematsu company ID Hugging Face user or organization ID ‎IGN wiki article ID ‎TouchArcade game ID IFTTT service ID HistoryMakers Maker Directory ID ‎Oyez Project ID ‎Gematsu event ID Amazon Luna game ID

Food properties

All

Mix N'Match edit

You can now help match the NDB to Wikidata on http://tools.wmflabs.org/mix-n-match/?mode=catalog&catalog=74&offset=0&show_noq=1&show_autoq=0&show_userq=0&show_na=0

FDC ID edit

Latest comment: 1 year ago2 comments2 people in discussion

@Teolemon, Elf_Pavlik, Kolja21, Pigsonthewing:

Notified participants of WikiProject Food

FoodData Central is the successor of USDA Standard Reference (NDB). You can see this at the website referenced by this prop: https://fdc.nal.usda.gov/fdc-app.html

We need a new prop "FDC ID".

Eg "Apples, raw, gala, with skin" has FDC ID 168204, NDB Number 9503
You can search at https://fdc.nal.usda.gov/fdc-app.html for either
But you can get to the detailed food nutrients page of that food only using the FDC ID: https://fdc.nal.usda.gov/fdc-app.html#/food-details/168204/nutrients

If anyone is willing to make a prop proposal, I'll help flesh it out. --Vladimir Alexiev (talk) 17:06, 19 March 2023 (UTC)Reply