Data for "International reliance on Brazil's water through soy and beef supply chains"

The Supplemental Data for the publication entitled "International reliance of Brazil's water through soy and beef supply chains". It contains: File name Description Description of column (csv's only) Lathuilliere_factors.xlsx Brazilian state-level water use and greenhouse gas emission factors for cattle Lathuilliere_soy_production_2015_2017.csv Brazilian municipal-level soy production information for the 2015-2017 period year - year of productiontrase_id - municipality geocodestwo_digit_code - state geocodesmun_name - municipality namestate - state namesigla_uf - two-letter state nameregion - region of production meso_basin - meso river basin of productionmacro_basin - macro river basin of productionyield - yield (tonnes/ha) from IBGEtonnes - tonnes produced (tonnes) from IBGEplanted_ha - planted area (ha) from IBGEharvest_ha - harvested area (ha) from IBGEarea_soy_pivot_mapb_ha - irrigated area (ha) from Mapbiomas Águasoy_def_5y_tot - area of soy deforestation (ha) from trasesoy_ghg_g_5y_tot - greenhouse gas emissions (gross) from soy deforestation (tCO2-eq) from trasesoy_def_5y_tot_per_tonne - soy deforestation footprint (ha/t) derivedsoy_ghg_g_5y_tot_per_tonne - soy carbon footprint from deforestation (tCO2-eq/t) derivedsoy_wf_rock - soy total water footprint (m3/t) from the studysoy_gwf_rock - soy green water footprint (m3/t) from the studysoy_bwf_rock - soy blue water footprint (m3/t) from the studysoy_bwsf_rock - soy blue water scarcity footprint (in m3/t) from the study Lathuilliere_cattle_production_2010_2017.csv Brazilian municipal-level cattle production information (as the cattle living herd (LW)) for the 2010-2017 period year - year of productiontrase_id - municipality geocodestwo_digit_code - state geocodesmun_name - municipality namestate - state namesigla_uf - two-letter state nameregion - region of production meso_basin - meso river basin of productionmacro_basin - macro river basin of productioncattle_stock_2017 - cattle stocking rate for 2017 from IBGEtotal_beef_dairy_anualpec_lw_touros - total cattle liveweight (kg LW) from the studypasture_ha_db - pasture area (ha) from Mapbiomas (collection 6)pasture_def_5y_tot - area of pasture deforestation (ha) from trasepasture_ghg_g_5y_tot - greenhouse gas emissions (gross) from pasture deforestation (tCO2-eq) from trasewater_area_ha - total area of small reservoirs for cattle (ha) from the studye_imp_m3_y - total evaporation from small reservoirs for cattle (m3/y) from the studypasture_m3_gw - pasture total green water consumption (m3/y) from the studytotal_beef_dairy_anualpec_m3_zanetti - total animal water use (m3/y)total_beef_dairy_anualpec_ch4_ent_l - total animal enteric methane emissions (kg CH4/y) considering Ca = 0.17, from the studytotal_beef_dairy_anualpec_ch4_ent_h - total animal enteric methane emissions (kg CH4/y) considering Ca = 0.36, from the studytotal_beef_dairy_anualpec_ch4_man - total animal manure methane emissions (kg CH4/y) from the studytotal_beef_dairy_anualpec_n2o_man - total animal manure nitrogen oxide emissions (kg N2O/y) from the studytotal_beef_dairy_anualpec_ch4_l_ent_co2eq - total animal enteric methane emissions (kg CO2eq/y) considering Ca = 0.17, from the studytotal_beef_dairy_anualpec_ch4_h_ent_co2eq - total animal enteric methane emissions (kg CO2-eq/y) considering Ca = 0.36, from the studytotal_beef_dairy_anualpec_tot_man_co2eq - total animal manure emissions (kg CO2-eq/y) from the studytotal_beef_dairy_anualpec_tot_co2eq_animal_l - total animal greenhouse gas emissions (kg CO2-eq/y) considering Ca = 0.17, from the studytotal_beef_dairy_anualpec_tot_co2eq_animal_h - total animal greenhouse gas emissions (kg CO2-eq/y) considering Ca = 0.36, from the studydef_per_tonlw_beef_dairy_anualpec - cattle deforestation footprint (ha per tonne LW) from the studytco2eq_per_tonlw_beef_dairy_anualpec_def - cattle carbon footprint from deforestation (gross) (tCO2-eq per tonne LW) from the studypasture_m3_per_tonlw_beef_dairy_anualpec - cattle green water footprint from pasture (m3 per tonne LW) from the studyimp_m3_per_tonlw_beef_dairy_anualpec - water footprint from cattle reservoir evaporation (m3 per tonne LW) from the studym3_per_tonlw_beef_dairy_anualpec_zanetti - animal water footprint (m3 per tonne LW) from the studytot_m3_per_tonlw_beef_dairy_anualpec_zanetti - total cattle water footprint (animal + reservoirs) (m3 per tonne LW) from the studywsf_tot_m3_per_tonlw_beef_dairy_anualpec_zanetti - total cattle water scarcity footprint (m3 per tonne LW) from the studytco2eq_per_tonlw_beef_dairy_anualpec_animal_l - total animal carbon footprint (tCO2-eq per tonne LW) considering Ca = 0.17, from the study tco2eq_per_tonlw_beef_dairy_anualpec_animal_h - total animal carbon footprint (tCO2-eq per tonne LW) considering Ca = 0.36, from the study Lathuilliere_beef_production_2015_2017.csv Brazilian municipal-level beef production information (as carcass weight (CW)) for the 2015-2017 period year - year of productiontrase_id - municipality geocodestwo_digit_code - state geocodesmun_name - municipality namestate - state namesigla_uf - two-letter state nameregion - region of production meso_basin - meso river basin of productionmacro_basin - macro river basin of productioncattle_stock_2017 - cattle stocking rate for 2017 from IBGEcw_production_beef_dairy_anualpec_no_touros_ton - total carcass weight (tonnes) without the bull population, from the studycw_production_beef_dairy_anualpec_no_touros_ton_5y - total 5-year sum of carcass weight (tonnes) without the bull population, from the studydef_ha_5y_sum - area of pasture deforestation summed over the past 5 years (ha) from traseghg_g_5y_sum - greenhouse gas emissions (gross) from pasture deforestation summed over the past 5 years (tCO2-eq) from trasee_imp_m3_5y_sum - total evaporation from small reservoirs for cattle summed over the past 5 years (m3) from the studypasture_m3_5y_sum - pasture total green water consumption summed over the past 5 years (m3) from the studytotal_beef_dairy_anualpec_no_bulls_m2_zanetti_5y - total animal water use summed over the past 5 years (m3) from the studytotal_beef_dairy_anualpec_no_touros_ch4_ent_l_5y - total animal enteric methane emissions summed over the past 5 years (kg CH4) considering Ca = 0.17, from the studytotal_beef_dairy_anualpec_no_touros_ch4_ent_h_5y - total animal enteric methane emissions summed over the past 5 years (kg CH4/y) considering Ca = 0.36, from the studytotal_beef_dairy_anualpec_no_touros_ch4_man_5y - total animal manure methane emissions summed over the past 5 tears (kg CH4) from the studytotal_beef_dairy_anualpec_no_touros_n2o_man_5y - total animal manure nitrogen oxide emissions summed over the past 5 years (kg N2O) from the studytotal_beef_dairy_anualpec_no_touros_ch4_ent_l_co2eq_5y - total animal enteric methane emissions summed over the past 5 years (kg CO2eq) considering Ca = 0.17, from the studytotal_beef_dairy_anualpec_no_touros_ch4_ent_h_co2eq_5y - total animal enteric methane emissions summed over the past 5 years (kg CO2eq) considering Ca = 0.36, from the studytotal_beef_dairy_anualpec_no_touros_tot_man_co2eq_5y - total animal manure emissions summed over the past 5 years (kg CO2-eq) from the studytotal_beef_dairy_anualpec_no_touros_tot_co2eq_animal_l_5y - total animal greenhouse gas emissions summed over the past 5 years (kg CO2-eq) considering Ca = 0.17, from the studytotal_beef_dairy_anualpec_no_touros_tot_co2eq_animal_h_5y - total animal greenhouse gas emissions summed over the past 5 years (kg CO2-eq) considering Ca = 0.36, from the studydef_per_toncw_beef_dairy_anualpec - beef deforestation footprint (ha per tonne CW) from the studytco2eq_per_toncw_beef_dairy_anualpec_def - beef carbon footprint from deforestation (gross) (tCO2-eq per tonne CW) from the studypasture_m3_gw_per_toncw_beef_dairy_anualpec - beef green water footprint from pasture (m3 per tonne CW) from the studyimp_m3_per_toncw_beef_dairy_anualpec - water footprint from cattle reservoir evaporation (m3 per tonne CW) from the studym3_per_toncw_beef_dairy_anualpec_zanetti - animal water footprint (m3 per tonne CW) from the studytot_m3_per_toncw_beef_dairy_anualpec_zanetti - total beef water footprint (animal + reservoirs) (m3 per tonne CW) from the studywsf_tot_m3_per_toncw_beef_dairy_anualpec_zanetti - total beef water scarcity footprint (m3 per tonne CW) from the studytco2eq_per_toncw_beef_dairy_anualpec_animal_l - total animal carbon footprint (tCO2-eq per tonne CW) considering Ca = 0.17, from the study tco2eq_per_toncw_beef_dairy_anualpec_animal_h - total animal carbon footprint (tCO2-eq per tonne CW) considering Ca = 0.36, from the study Lathuilliere_soy_benchmark_2015_2017.csv Brazilian municipal-level benchmarks for soy production for the 2015-2017 period year - year of productiontrase_id - municipality geocodesname - municipality namestate - state namesigla_uf - two-letter state nameregion - region of production cutoff_used - benchmark cutoff used (0.80 in the study)soy_def_5y_tot_per_tonne_trase - soy deforestation footprint (ha/t) derivedtonnes - tonnes produced (tonnes) from IBGEtag_def - label whether the municipality is above (> cutoff def) or below (< cutoff def) the 80th percentile soy deforestation footprint cutoff soy_wf_rock - soy total water footprint (m3/t) from the studysoy_bwf_rock - soy blue water footprint (m3/t) from the studytag_wf - label whether the municipality is above (> cutoff WF) or below (< cutoff WF) the 80th percentile soy total water footprint cutoff tag_irr - label whether the municipality has (irr) or does not have (no irr) irrigation for soy production Lathuilliere_cattle_benchmark_2015_2017.csv Brazilian municipal-level benchmarks for cattle production (as the cattle living herd (LW)) for the 2015-2017 period year - year of productiontrase_id - municipality geocodesmun_name - municipality namestate - state namesigla_uf - two-letter state nameregion - region of production cutoff_used - benchmark cutoff used (0.80 in the study)def_per_tonlw_beef_dairy_anualpec - cattle deforestation footprint (ha per tonne LW) from the studytotal_beef_dairy_anualpec_lw_touros - total cattle liveweight (kg LW) from the studytag_def - label whether the municipality is above (> cutoff def) or below (< cutoff def) the 80th percentile cattle deforestation footprint cutoff tot_m3_per_tonlw_beef_dairy_anualpec_zanetti - total cattle water footprint (animal + reservoirs) (m3 per tonne LW) from the studytag_wf - label whether the municipality is above (> cutoff WF) or below (< cutoff WF) the 80th percentile cattle total water footprint cutoff wsf_tot_m3_per_tonlw_beef_dairy_anualpec_zanetti - total cattle water scarcity footprint (m3 per tonne LW) from the studytag_wsf - label whether the municipality is above (> cutoff WSF) or below (< cutoff WSF) the 80th percentile cattle water scarcity footprint cutoff Lathuilliere_beef_benchmark_2015_2017.csv Brazilan municipal-level benchmarks for beef production (as carcass weight (CW)) for the 2015-2017 period year - year of productiontrase_id - municipality geocodesmun_name - municipality namestate - state namesigla_uf - two-letter state nameregion - region of production cutoff_used - benchmark cutoff used (0.80 in the study)def_per_toncw_beef_dairy_anualpec - beef deforestation footprint (ha per tonne CW) from the studycw_production_beef_dairy_anualpec_no_touros_ton - beef carcass weight (t CW) from the studytag_def - label whether the municipality is above (> cutoff def) or below (< cutoff def) the 80th percentile beef deforestation footprint cutoff tot_m3_per_toncw_beef_dairy_anualpec_zanetti - total beef water footprint (animal + reservoirs) (m3 per tonne CW) from the studytag_wf - label whether the municipality is above (> cutoff WF) or below (< cutoff WF) the 80th percentile beef total water footprint cutoff wsf_tot_m3_per_toncw_beef_dairy_anualpec_zanetti - total beef water scarcity footprint (m3 per tonne CW) from the studytag_wsf - label whether the municipality is above (> cutoff WSF) or below (< cutoff WSF) the 80th percentile beef water scarcity footprint cutoff Lathuilliere_soy_consumption_2015_2017.csv Brazilian municipal-level soy supply from trase (v.2.6.1) with deforestation, water and greenhouse gas emissions for the 2015-2017 period year - year of exportproduct_type - product as per HS code and grouped into soy oil, cake and beansexporter - trading companies including subsidiaries of larger companiesexporter_group - subsidiary trader groupsimporter - trading companies including subsidiaries of larger companiesimporter_group - subsidiary trader groupscountry_of_import - country importing the producteconomic_bloc - economic bloc of the country_of_import (EU, China)volume - product exported/imported (in tonnes soy equivalent)fob - value of trade ($US)is_domestic - flag whether the trade was domestic (Brazil) or not trase_id - municipality geocodes two_digit_code - state geocodes name - municipality namestate - state namesigla_uf - two-letter state nameregion - region of production meso_basin - meso river basin of productionmacro_basin - macro river basin of productionyield - yield (tonnes/ha) from IBGEsoy_def_5y_tot_per_tonne_trase - soy deforestation footprint (ha/t) derivedsoy_ghg_g_5y_per_tonne_trase - soy carbon footprint from deforestation (gross) (tCO2-eq/t)soy_wf_rock - soy total water footprint (m3/t) from the studysoy_gwf_rock - soy green water footprint (m3/t) from the studysoy_bwf_rock - soy blue water footprint (m3/t) from the studysoy_bwsf_rock - soy blue water scarcity footprint (in m3/t) from the studyha_def - total deforestation (ha) associated with soy tradet_co2_g_def - total greenhouse gas emissions from deforestation (gross) (tCO2-eq) associated with soy tradem3_w_rock - total water use (m3) associated with soy tradem3_gw_rock - total green water (m3) associated with soy tradem3_bw_rock - total blue water (m3) associated with soy trade Lathuilliere_beef_consumption_2015_2017.csv Brazilian municipal-level beef supply from trase (v.2.2.0) with deforestation, water and greenhouse gas emissions for the 2015-2017 period year - year of exportproduct_type - product as per HS code and grouped into beef (boneless, offals, dried salted smoked), meat preparations or live cattle exporter - trading companies including subsidiaries of larger companiesexporter_group - subsidiary trader groupsimporter - trading companies including subsidiaries of larger companiesimporter_group - subsidiary trader groupscountry_of_import - country importing the producteconomic_bloc - economic bloc of the country_of_import (EU, China)volume - product exported/imported (in tonnes carcass weight equivalent)fob - value of trade ($US)is_domestic - flag whether the trade was domestic (Brazil). There is no domestic beef information in the datatrase_id - municipality geocodes two_digit_code - state geocodes name - municipality namestate - state namesigla_uf - two-letter state nameregion - region of production meso_basin - meso river basin of productionmacro_basin - macro river basin of productioncattle_stock_2017 - cattle stocking rate for 2017 from IBGEdef_per_toncw_beef_dairy_anualpec - - beef deforestation footprint (ha per tonne CW) from the studytco2eq_per_toncw_beef_dairy_anualpec_def - - beef carbon footprint from deforestation (gross) (tCO2-eq per tonne CW) from the studypasture_m3_gw_per_toncw_beef_dairy_anualpec - beef green water footprint pasture (m3 per tonne CW) from the studytot_m3_per_toncw_beef_dairy_anualpec_zanetti - total beef water footprint (animal + reservoirs) (m3 per tonne CW) from the studywsf_m3_per_toncw_beef_dairy_anualpec_zanetti - total beef water scarcity footprint (m3 per tonne CW) from the studytco2eq_per_toncw_beef_dairy_anualpec_animal_l - total animal carbon footprint (tCO2-eq per tonne CW) considering Ca = 0.17, from the study tco2eq_per_toncw_beef_dairy_anualpec_animal_h - total animal carbon footprint (tCO2-eq per tonne CW) considering Ca = 0.36, from the study ha_def - total deforestation (ha) associated with beef trade, from the studyt_co2_def - total greenhouse gas emissions from deforestation (gross) (tCO2-eq) associated with beef trade, from the studytco2_l - total animal greenhouse gas emissions (tCO2-eq) assciated with beef trade considering Ca = 0.17, from the studytco2_h - total animal greenhouse gas emissions (tCO2-eq) assciated with beef trade considering Ca = 0.36, from the studypasture_gw_m3 - pasture total green water consumption (m3) associated with beef trade, from the studytot_m3_zanetti - total beef water consumption (animal + reservoirs) (m3) associated with beef trade, from the study soy_cattle_production.RData Source data on soy and cattle production to run scripts used to generate analysis for the research soy_beef_consumption.RData Source data on soy and beef consumption to run scripts used to generate analysis for the research