Published May 21, 2025 | Version v.1
Dataset Open

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

Description

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 production
trase_id - municipality geocodes
two_digit_code - state geocodes
mun_name - municipality name
state - state name
sigla_uf - two-letter state name
region - region of production 
meso_basin - meso river basin of production
macro_basin - macro river basin of production
yield - yield (tonnes/ha) from IBGE
tonnes - tonnes produced (tonnes) from IBGE
planted_ha - planted area (ha) from IBGE
harvest_ha - harvested area (ha) from IBGE
area_soy_pivot_mapb_ha - irrigated area (ha) from Mapbiomas Água
soy_def_5y_tot - area of soy deforestation (ha) from trase
soy_ghg_g_5y_tot - greenhouse gas emissions (gross) from soy deforestation (tCO2-eq) from trase
soy_def_5y_tot_per_tonne - soy deforestation footprint (ha/t) derived
soy_ghg_g_5y_tot_per_tonne - soy carbon footprint from deforestation (tCO2-eq/t) derived
soy_wf_rock - soy total water footprint (m3/t) from the study
soy_gwf_rock - soy green water footprint (m3/t) from the study
soy_bwf_rock - soy blue water footprint (m3/t) from the study
soy_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 production
trase_id
- municipality geocodes
two_digit_code
- state geocodes
mun_name
- municipality name
state
- state name
sigla_uf
- two-letter state name
region
- region of production 
meso_basin
- meso river basin of production
macro_basin
- macro river basin of production
cattle_stock_2017 - cattle stocking rate for 2017 from IBGE
total_beef_dairy_anualpec_lw_touros - total cattle liveweight (kg LW) from the study
pasture_ha_db - pasture area (ha) from Mapbiomas (collection 6)
pasture_def_5y_tot - area of pasture deforestation (ha) from trase
pasture_ghg_g_5y_tot greenhouse gas emissions (gross) from pasture deforestation (tCO2-eq) from trase
water_area_ha - total area of small reservoirs for cattle (ha) from the study
e_imp_m3_y - total evaporation from small reservoirs for cattle (m3/y) from the study
pasture_m3_gw - pasture total green water consumption (m3/y) from the study
total_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 study
total_beef_dairy_anualpec_ch4_ent_h - total animal enteric methane emissions (kg CH4/y) considering Ca = 0.36, from the study
total_beef_dairy_anualpec_ch4_man - total animal manure methane emissions (kg CH4/y) from the study
total_beef_dairy_anualpec_n2o_man - total animal manure nitrogen oxide emissions (kg N2O/y) from the study
total_beef_dairy_anualpec_ch4_l_ent_co2eq - total animal enteric methane emissions (kg CO2eq/y) considering Ca = 0.17, from the study
total_beef_dairy_anualpec_ch4_h_ent_co2eq - total animal enteric methane emissions (kg CO2-eq/y) considering Ca = 0.36, from the study
total_beef_dairy_anualpec_tot_man_co2eq - total animal manure emissions (kg CO2-eq/y) from the study
total_beef_dairy_anualpec_tot_co2eq_animal_l - total animal greenhouse gas emissions (kg CO2-eq/y) considering Ca = 0.17, from the study
total_beef_dairy_anualpec_tot_co2eq_animal_h - total animal greenhouse gas emissions (kg CO2-eq/y) considering Ca = 0.36, from the study
def_per_tonlw_beef_dairy_anualpec - cattle deforestation footprint (ha per tonne LW) from the study
tco2eq_per_tonlw_beef_dairy_anualpec_def - cattle carbon footprint from deforestation (gross) (tCO2-eq per tonne LW) from the study
pasture_m3_per_tonlw_beef_dairy_anualpec - cattle green water footprint from pasture (m3 per tonne LW) from the study
imp_m3_per_tonlw_beef_dairy_anualpec - water footprint from cattle reservoir evaporation (m3 per tonne LW) from the study
m3_per_tonlw_beef_dairy_anualpec_zanetti - animal water footprint (m3 per tonne LW) from the study
tot_m3_per_tonlw_beef_dairy_anualpec_zanetti - total cattle water footprint (animal + reservoirs) (m3 per tonne LW) from the study
wsf_tot_m3_per_tonlw_beef_dairy_anualpec_zanetti - total cattle water scarcity footprint (m3 per tonne LW) from the study
tco2eq_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 production
trase_id
- municipality geocodes
two_digit_code
- state geocodes
mun_name
- municipality name
state
- state name
sigla_uf
- two-letter state name
region
- region of production 
meso_basin
- meso river basin of production
macro_basin
- macro river basin of production
cattle_stock_2017
- cattle stocking rate for 2017 from IBGE
cw_production_beef_dairy_anualpec_no_touros_ton - total carcass weight (tonnes) without the bull population, from the study
cw_production_beef_dairy_anualpec_no_touros_ton_5y - total 5-year sum of carcass weight (tonnes) without the bull population, from the study
def_ha_5y_sum - area of pasture deforestation summed over the past 5 years (ha) from trase
ghg_g_5y_sum - greenhouse gas emissions (gross) from pasture deforestation summed over the past 5 years (tCO2-eq) from trase
e_imp_m3_5y_sum - total evaporation from small reservoirs for cattle summed over the past 5 years (m3) from the study
pasture_m3_5y_sum - pasture total green water consumption summed over the past 5 years (m3) from the study
total_beef_dairy_anualpec_no_bulls_m2_zanetti_5y - total animal water use summed over the past 5 years (m3) from the study
total_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 study
total_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 study
total_beef_dairy_anualpec_no_touros_ch4_man_5y - total animal manure methane emissions summed over the past 5 tears (kg CH4) from the study
total_beef_dairy_anualpec_no_touros_n2o_man_5y - total animal manure nitrogen oxide emissions summed over the past 5 years (kg N2O) from the study
total_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 study
total_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 study
total_beef_dairy_anualpec_no_touros_tot_man_co2eq_5y - total animal manure emissions summed over the past 5 years (kg CO2-eq) from the study
total_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 study
total_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 study
def_per_toncw_beef_dairy_anualpec - beef deforestation footprint (ha per tonne CW) from the study
tco2eq_per_toncw_beef_dairy_anualpec_def - beef carbon footprint from deforestation (gross) (tCO2-eq per tonne CW) from the study
pasture_m3_gw_per_toncw_beef_dairy_anualpec - beef green water footprint from pasture (m3 per tonne CW) from the study
imp_m3_per_toncw_beef_dairy_anualpec - water footprint from cattle reservoir evaporation (m3 per tonne CW) from the study
m3_per_toncw_beef_dairy_anualpec_zanetti - animal water footprint (m3 per tonne CW) from the study
tot_m3_per_toncw_beef_dairy_anualpec_zanetti - total beef water footprint (animal + reservoirs) (m3 per tonne CW) from the study
wsf_tot_m3_per_toncw_beef_dairy_anualpec_zanetti - total beef water scarcity footprint (m3 per tonne CW) from the study
tco2eq_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 production
trase_id
- municipality geocodes
name - municipality name
state - state name
sigla_uf - two-letter state name
region
- 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) derived
tonnes - tonnes produced (tonnes) from IBGE
tag_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 study
soy_bwf_rock - soy blue water footprint (m3/t) from the study
tag_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 production
trase_id
- municipality geocodes
mun_name
- municipality name
state
- state name
sigla_uf
- two-letter state name
region
- 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 study
total_beef_dairy_anualpec_lw_touros - total cattle liveweight (kg LW) from the study
tag_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 study
tag_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 study
tag_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 production
trase_id
- municipality geocodes
mun_name
- municipality name
state
- state name
sigla_uf
- two-letter state name
region
- 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 study
cw_production_beef_dairy_anualpec_no_touros_ton - beef carcass weight (t CW) from the study
tag_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 study
tag_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 study
tag_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 export
product_type
- product as per HS code and grouped into soy oil, cake and beans
exporter
- trading companies including subsidiaries of larger companies
exporter_group
- subsidiary trader groups
importer
- trading companies including subsidiaries of larger companies
importer_group
- subsidiary trader groups
country_of_import
- country importing the product
economic_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 name
state
- state name
sigla_uf
- two-letter state name
region 
- region of production 
meso_basin
- meso river basin of production
macro_basin
- macro river basin of production
yield
- yield (tonnes/ha) from IBGE
soy_def_5y_tot_per_tonne_trase 
- soy deforestation footprint (ha/t) derived
soy_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 study
soy_gwf_rock 
- soy green water footprint (m3/t) from the study
soy_bwf_rock
- soy blue water footprint (m3/t) from the study
soy_bwsf_rock
- soy blue water scarcity footprint (in m3/t) from the study
ha_def
- total deforestation (ha) associated with soy trade
t_co2_g_def
- total greenhouse gas emissions from deforestation (gross) (tCO2-eq) associated with soy trade
m3_w_rock
- total water use (m3) associated with soy trade
m3_gw_rock
- total green water (m3) associated with soy trade
m3_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 export
product_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 companies
exporter_group
- subsidiary trader groups
importer
- trading companies including subsidiaries of larger companies
importer_group
- subsidiary trader groups
country_of_import
- country importing the product
economic_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 data
trase_id
- municipality geocodes 
two_digit_code
- state geocodes 
name
- municipality name
state
- state name
sigla_uf
- two-letter state name
region 
- region of production 
meso_basin
- meso river basin of production
macro_basin
- macro river basin of production
cattle_stock_2017 - cattle stocking rate for 2017 from IBGE
def_per_toncw_beef_dairy_anualpec - - beef deforestation footprint (ha per tonne CW) from the study
tco2eq_per_toncw_beef_dairy_anualpec_def - - beef carbon footprint from deforestation (gross) (tCO2-eq per tonne CW) from the study
pasture_m3_gw_per_toncw_beef_dairy_anualpec
- beef green water footprint pasture (m3 per tonne CW) from the study
tot_m3_per_toncw_beef_dairy_anualpec_zanetti
- total beef water footprint (animal + reservoirs) (m3 per tonne CW) from the study
wsf_m3_per_toncw_beef_dairy_anualpec_zanetti
- total beef water scarcity footprint (m3 per tonne CW) from the study
tco2eq_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 study
t_co2_def
- total greenhouse gas emissions from deforestation (gross) (tCO2-eq) associated with beef trade, from the study
tco2_l
- total animal greenhouse gas emissions (tCO2-eq) assciated with beef trade considering Ca = 0.17, from the study
tco2_h
- total animal greenhouse gas emissions (tCO2-eq) assciated with beef trade considering Ca = 0.36, from the study
pasture_gw_m3
- pasture total green water consumption (m3) associated with beef trade, from the study
tot_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

 

 

Notes (En)

This research was supported by Formas – a Swedish Research Council for Sustainable Development (2020-00688, to MJL) for the project entitled “Water use and impacts of Brazilian agricultural production and consumption: from global supply chains to regional rainfall”. Additional support was provided through the Trase initiative (trase.earth) which is funded by the Gordon and Betty Moore Foundation (7703.01), Norway’s International Climate and Forest Initiative (QZA-21/0156) and Quadrature Climate Foundation (01-21-000098).

Other (En)

Link to Github repository: https://github.com/mlathuilliere/Lathuilliere_etal_2025.git

Files

Lathuilliere_beef_consumption_2015_2017.csv

Files (770.6 MB)

Name Size Download all
md5:09a2761c632ab6a961d6a324c903ad37
617.7 MB Preview Download
md5:f82bdda42c01b1f842d2bd9950cbaf53
4.6 MB Preview Download
md5:04fdd85b5a7b8a58f1f2b819fba686be
2.3 MB Preview Download
md5:674cc77f220a87e78638efbdcd72f20f
12.2 MB Preview Download
md5:8a167b889723e393126c3ae8aacc4c4c
33.8 kB Download
md5:f551bd8378ac8c5516211caeb1551927
867.0 kB Preview Download
md5:2cc25c4a130485ba2a87700b7afcc5e6
3.4 MB Preview Download
md5:ad7b6588b8b44a90dc471aaa98a22ee2
104.0 MB Download
md5:2585e64dec2a2bcfd2b4da973d1c6acb
25.5 MB Download

Additional details

Software

Repository URL
https://github.com/mlathuilliere/Lathuilliere_etal_2025.git
Programming language
R
Development Status
Active