Extended item reference table covering all CBS items, including their process and commodity codes, feed type classifications, and default material flow destinations.
Format
A tibble where each row corresponds to one CBS item. It contains the following columns:
item_cbs: Name of the CBS item.item_cbs_code: Numeric CBS item code.comm_code: Commodity code used in process-based modelling (may contain"#N/A"when not applicable).proc_code: Process code (may contain"#N/A"when not applicable).proc: Process name (may contain"#N/A"when not applicable).unit: Measurement unit (typically"tonnes").group: Broad item group. Common values include"Additives","Crop products","Crop residues","Draught","Fish","Forestry","Grass","Livestock", and others.feedtype_graniv: Feed type classification for granivores (e.g.,"additives","concentrates","roughages").feedtype_grazers: Feed type classification for grazers.comm_group: Sub-group of the commodity (e.g.,"Additives","Alcohol","Ethanol","Oil cakes","Other processing residues").Cat_1: Primary category label used in material flow accounting.Name_biomass: Corresponding item name inbiomass_coefs, enabling joins with the biomass coefficient table; every non-missing value resolves.NAmeans the item has no biomass counterpart: the 22 live-animal items, which are heads rather than biomass, 4000 Animal draught, which is measured in work hours, and 2899 Miscellaneous, a residual aggregate. Upstream, the last two and 2775 Aquatic Plants carry the literal placeholder"0"; here 2775 bridges to theAquatic Plantsrow of biomass_coefs instead (whep#970).dbMFA_items: Item identifier used in the material flow analysis database.FEDNA: Name of the FEDNA feed-composition table entry (https://fundacionfedna.org/ingredientes-para-piensos) paired with the item. It is a stand-in, not a product identity: it says which feed-table row the item was given, not which substance the item is, and must not be read as evidence of what a row represents (whep#1131). Why each entry was chosen is not recorded upstream. On the 28Additivesrows, 4008 Enzimes and 4016 Phytase share PROTEINA DE PATATA (potato protein), 4005 Calcium carbonate and 4013 Minerals share CARBONATO CALCICO, and several name a different substance outright: 4018 Potassium carbonate is CARBONATO SODIO, 4027 Vitamins AC. CITRICO, 4015 Pesticides AC. FORMICO, 4017 Pigment AC. COLZA, 4009 Flavours PROPIONATO SODICO, 4003 Anionic salts MET HIDROXI SAL CALCICA and 4011 Methionine HIDROXI-ANAL MET, a nitrogen-free analogue. Nor does the named entry fix thebiomass_coefsnitrogen: Methionine and Lysine carry their dry commercial forms (DL-Metionina, L-Lisina HCl), not the entries named here, and the FEDNA entry each additive's nitrogen was actually read from is recorded ininst/extdata/harmonization/biomass_coefs_additive_sources.csv(whep#1074). No WHEP function reads this column.default_destiny: Default CBS use category for this item. One of"Feed","Food","Other_uses","Processing", orNA. It is where the final balance books the domestic supply a row's reported destinies leave unexplained. The values come from theitems_fullsheet of afsetools'Codes_coefs.xlsx, which records no derivation for them. All nine oilseed cakes (comm_group == "Oil cakes") are"Feed": five of them (2591, 2592, 2594, 2595, 2596) were"Food"until whep#1066, unlike the other four.
Source
Derived from FAOSTAT data and internal commodity classification work.
Examples
head(items_full)
#> # A tibble: 6 × 15
#> item_cbs item_cbs_code comm_code proc_code proc unit group feedtype_graniv
#> <chr> <dbl> <chr> <chr> <chr> <chr> <chr> <chr>
#> 1 Choline c… 4007 NA NA NA tonn… Addi… additives
#> 2 Lysine 4010 NA NA NA tonn… Addi… additives
#> 3 MgO 4012 NA NA NA tonn… Addi… additives
#> 4 Minerals 4013 NA NA NA tonn… Addi… additives
#> 5 Pesticides 4015 NA NA NA tonn… Addi… additives
#> 6 SSP 4021 NA NA NA tonn… Addi… additives
#> # ℹ 7 more variables: feedtype_grazers <chr>, comm_group <chr>, Cat_1 <chr>,
#> # Name_biomass <chr>, dbMFA_items <chr>, FEDNA <chr>, default_destiny <chr>