unique row identity
unique publication identity
primary author of the publication
the year of publication
abbreviation of the journal name
doi (or url if no doi available) of article. DOI = digital object identifier
the elevation in meters (m). Provide the mid-point if a range is given
country name
Standardized country name using ISO.3166-1.alpha-3. This field should be auto filled using the country selected and data in the Levels Tab
one of the following: Farm, Station, Greenhouse, Survey, or Lab. Farm research is conducted in a farmers field and can be managed by the farmer or researcher. Station research is conducted in a controlled setting of research station, university or school. Survey research is conducted via interviews that yields quantitative data based on testimonial. Greenhouse is conducted in a greenhouse and is only relevant for studies of greenhouse gas emissions data. Lab studies can include fisheries feeding trials conducted at a small scale in university research labs
free text name to identify the site. Include institution/station name and location or village/town in county/district, but not the country
reported mean annual temperature in degrees C. If a range is given, average the values and enter the average. If mean highs and lows are given, they can be averaged to estimate the mean annual temperature
mean annual precipitation (mm) for the location. This should be a long-term average for more than 10 years of data
total annual precipitation (mm) for the location in the year corresponding to the outcome data
mean seasonal precipitation (mm) for the location in the season corresponding to the outcome data. This should be a long-term average from more than 10 years of data
total seasonal precipitation (mm) for the location in the season corresponding to the outcome data
list the given soil classification/name in lowercase letters. If more than one soil type is given (within the same taxonomic system) enter both separated by a period
list the taxonomic system used to classify the soil. Choose from (FAO, USDA, other)
list the soil texture provided in the text or in tables in lowercase letters. If no texture is named, but % of sand, silt and clay are given, use the soil texture triangle to estimate soil texture (https://www.nrcs.usda.gov/wps/portal/nrcs/detail/soils/survey/?cid=nrcs142p2_054167)
soil organic carbon value derived during site characterization
units provided for soil organic carbon. Usually either g/kg or % (also can be density kg/m3 or stocks t/ha)
concatenate min (top) and max (bottom) depths user entered with a "-", e.g. 0-10
soil pH value derived during site characterization
method used to calculate soil pH
starting of planting period (dd.mm.yyyy)
end of planting period (dd.mm.yyyy)
starting of harvest period (dd.mm.yyyy)
end of harvest period (dd.mm.yyyy)
the number of replicates for the treatments
the size of the smallest treatment plot unit in m2
a unique identifier (within study) describing a set of management practices that occurred in the control which is used to identify the treatment combinations tested, to allow comparison across outcomes in a paper. A default system of T1, T2, T3, etc. can be used. CID should describe the treatment used as the control for this observation
(superceded by C.Descrip.Clean column) Free text description of the control treatment
amount of inorganic (chemical) nitrogen applied to control plots in kg/ha
amount of nitrogen in organic materials (manures or compost, but not residues) applied to control plots, preferably in kg/ha
a unique identifier (within study) describing a set of management practices that occurred in treatment which is used to identify the treatment combinations tested, to allow comparison across outcomes in a paper. A default system of T1, T2, T3, etc. can be used. TID should describe the treatment used as the control for this observation
(superceded by T.Descrip.Clean column) Free text description of the CSA treatment
amount of inorganic (chemical) nitrogen (N) applied to CSA treatment in kg/ha
amount of nitrogen (N) in organic materials (manures or compost) applied to CSA treatment, preferably in kg/ha
name of species in intercrop or rotations including the crop. Dash(-) indicates intercrop and slash (/) indicates a rotation
commercial name of the crop or animal variety
Name of tree species used in agroforestry experiments, can be both as an intercrop or as an agroforestry mulch
length of time the experiment has been ongoing up to the date the data are being reported for in years. In bimodal rainfall systems with multiple growing seasons, seasons are identified by fractions of the year, 0.5, etc. If outcomes are reported in a unimodal rainfall system with one growing season per year, the duration can be equivalent to one year
the calendar year the measurement was taken. Seasons in multi-season systems are identified by decimals .1 or .2 for the first and second season respectively. When the measurements are average values for more than one year create a decimal for the years covered
first year the measurement was taken (YYYY). For yield or similar outcomes this should relate to the harvest year (rather than the planting year)
this only required for temporally aggregated observations (e.g. a result that has been averaged from crop yields reported from 2000,2001 and 2002)
this only required in areas where there are mutiple growing seasons in a year (e.g., areas with bimodal rainfall or irrigated cropping in dry seasons of a unimodal system)
this only required for temporally aggregated observations in areas with more than one growing season (e.g. a result that has been averaged from crop yields reported from 2000 season 1,2001 season 1 and 2002 season 1)
the experimental unit (EU) for which experiment outcomes are reported. This usually a crop or animal product. For cookstove papers it may be a cookstove. The EU for soil outcomes should be the crop(s) grown on the soil unless no crops are grown at all. Letters in the code should be lowercase. If the outcome refers to multiple experimental units (e.g. soil outcomes during an intercropping experiment) select all experimental units separated by a period (see EU2 tab)
the productivity, resilience, or mitigation outcome indicator that data are being reported on (see OUTCOMES2 tab)
free text description of the units of the data being reported without special characters or formatting
the value that corresponds to the control treatment and outcome. Please standard yields to t/ha where appropropriate, keeping as many decimal places as there is data for
the value that corresponds to the CSA treatment and outcome. Please standard yields to kg/ha where appropropriate, keeping as many decimal places as there is data for
the depth for which the MeanC and MeanT correspond for soil properties in cm (lowest depth value = upper, so if you have a depth of 0-20 cm the lowest value = 20)
the depth for which the MeanC and MeanT correspond for soil properties in cm (highest depth value = lower, so if you have a depth of 0-20 cm the highest value = 0)
the location in the paper where the data can be found. This should be three letters (fig, tab, or txt) in lowercase and a number (for figures and tables) to signify figure, table or text, respectively
monetary outcomes converted to international USD in 2010 using World Bank CPI, PPP and exchange rates. There are no data for Zimbabwe.
monetary outcomes converted to international USD in 2010 using World Bank CPI, PPP and exchange rates. There are no data for Zimbabwe.
is a negative result considered better than a positive result (i.e. MeanT/MeanC <1 = good)? This is indexed in using the Outcode field in the compednium and the Negative Values
field in the OUTCOMES tab
where were livestock diets in the treatment practice(s) sourced from?
Where were livestock diets in the control practice(s) sourced from?
the tree species for which the experiment outcome are reported
free text to describe the partial outcome
ERA practice codes that correspond to the partial outcome
Describes the logical process used to compare control to treatment (for developers)
year in which the ERA data entry took place. Either 2018 or 2020
ERA mulch code based on the nitrogen fixing properties specified in Nfix. NA for animal products
indicates the presence of irrigation in the control treatment
indicates the presence of irrigation in the experimental treatment
method of irrigation used in the control treatment. Cell will be blank if Irrigation.C is FALSE
method of irrigation used in the experimental treatment. Cell will be blank if Irrigation.T is FALSE
codes corresponding to all practices used on the control treatment described in C.Descrip. Only one code is placed in each column (see subpractices column of PRACTICES2 tab)
codes corresponding to all practices used on the CSA treatment described in T.Descrip. Only one code is placed in each column (see subpractices column of PRACTICES2 tab)
study number
number of observations
number of outcomes reported per study
latitude of study location in degrees or decimal degrees, the latter recorded to same accuracy as in publication (or estimated from googlemaps where locations were found from site names/descriptions). For decimal degrees the sign is not recorded here, but in the LatH column instead (all values should be positive)
longitude of study location in decimal degrees, recorded to same accuracy as in publication (or estimated from googlemaps where locations were found from site names or descriptions). For decimal degrees the sign is not recorded here, but in the LatH column instead. All values should be positive.
the natural log of the response ratio log(MeanT/MeanC)
pc=proportional change.It is a measure of the ratio of experimental to control outcomes
experimental ERA practices that are in the experimental, but not the control treatment
base practices that are shared between experimental and control treatments
the product code OutcomeCodes$Code for the observation using a - delim for multiple products
outcome pillar name
outcome subpillar name
outcome indicator name
outcome subindicator name
outcome subindicator name simplified
experimental subpractice name (note that this corresponds to the Subpractice.S field in the PracticeCodes)
experimental practice name
experimental practice theme name
base practice name (note that this corresponds to the Subpractice.S field in the PracticeCodes)
base practice name
base practice theme name
the full name of the product, including aspect of the component such as grain, meat or milk
product type name
product subtype name
simplified product name, excluding any aspects of component
latitude of study location in degrees or decimal degrees
longitude of study location in degrees or decimal degrees
manual estimation (e.g. from measuring on google earth) in m of the spatial uncertainty for a point location. The site should within an X m radius (the buffer.manual amount) of the point location specified. Unit is meters
longitude, latitude and buffer for the site
simplified version of AEZ16 removing the tropic/subtropic classification
AEZs for Africa South of the Sahara (SSA) based on the methodology developed by FAO and IIASA, using the scheme with 16 classes
AEZs Africa South of the Sahara (SSA) based on the methodology developed by FAO and IIASA, using the scheme with 5 classes
mean annual precipitation (mm) derived from the CHIRPS 2.0 dataset API at 0.05° resolution
mean annual temperature (C) derived from the NASA POWER dataset API at 0.5° resolution
weight percentage of clay particles (<0.0002 mm)
weight percentage of silt particles (0.0002-0.05 mm)
weight percentage of the sand particles (0.05-2 mm)
ERA.Compiled.Rd
The compiled ERA dataset (version = Comb 2023.04.26 2023.06.27)
unique row identity
unique publication identity
primary author of the publication
the year of publication
abbreviation of the journal name
doi (or url if no doi available) of article. DOI = digital object identifier
the elevation in meters (m). Provide the mid-point if a range is given
country name
Standardized country name using ISO.3166-1.alpha-3. This field should be auto filled using the country selected and data in the Levels Tab
one of the following: Farm, Station, Greenhouse, Survey, or Lab. Farm research is conducted in a farmers field and can be managed by the farmer or researcher. Station research is conducted in a controlled setting of research station, university or school. Survey research is conducted via interviews that yields quantitative data based on testimonial. Greenhouse is conducted in a greenhouse and is only relevant for studies of greenhouse gas emissions data. Lab studies can include fisheries feeding trials conducted at a small scale in university research labs
free text name to identify the site. Include institution/station name and location or village/town in county/district, but not the country
reported mean annual temperature in degrees C. If a range is given, average the values and enter the average. If mean highs and lows are given, they can be averaged to estimate the mean annual temperature
mean annual precipitation (mm) for the location. This should be a long-term average for more than 10 years of data
total annual precipitation (mm) for the location in the year corresponding to the outcome data
mean seasonal precipitation (mm) for the location in the season corresponding to the outcome data. This should be a long-term average from more than 10 years of data
total seasonal precipitation (mm) for the location in the season corresponding to the outcome data
list the given soil classification/name in lowercase letters. If more than one soil type is given (within the same taxonomic system) enter both separated by a period
list the taxonomic system used to classify the soil. Choose from (FAO, USDA, other)
list the soil texture provided in the text or in tables in lowercase letters. If no texture is named, but % of sand, silt and clay are given, use the soil texture triangle to estimate soil texture (https://www.nrcs.usda.gov/wps/portal/nrcs/detail/soils/survey/?cid=nrcs142p2_054167)
soil organic carbon value derived during site characterization
units provided for soil organic carbon. Usually either g/kg or % (also can be density kg/m3 or stocks t/ha)
concatenate min (top) and max (bottom) depths user entered with a "-", e.g. 0-10
soil pH value derived during site characterization
method used to calculate soil pH
starting of planting period (dd.mm.yyyy)
end of planting period (dd.mm.yyyy)
starting of harvest period (dd.mm.yyyy)
end of harvest period (dd.mm.yyyy)
the number of replicates for the treatments
the size of the smallest treatment plot unit in m2
a unique identifier (within study) describing a set of management practices that occurred in the control which is used to identify the treatment combinations tested, to allow comparison across outcomes in a paper. A default system of T1, T2, T3, etc. can be used. CID should describe the treatment used as the control for this observation
(superceded by C.Descrip.Clean column) Free text description of the control treatment
amount of inorganic (chemical) nitrogen applied to control plots in kg/ha
amount of nitrogen in organic materials (manures or compost, but not residues) applied to control plots, preferably in kg/ha
a unique identifier (within study) describing a set of management practices that occurred in treatment which is used to identify the treatment combinations tested, to allow comparison across outcomes in a paper. A default system of T1, T2, T3, etc. can be used. TID should describe the treatment used as the control for this observation
(superceded by T.Descrip.Clean column) Free text description of the CSA treatment
amount of inorganic (chemical) nitrogen (N) applied to CSA treatment in kg/ha
amount of nitrogen (N) in organic materials (manures or compost) applied to CSA treatment, preferably in kg/ha
name of species in intercrop or rotations including the crop. Dash(-) indicates intercrop and slash (/) indicates a rotation
commercial name of the crop or animal variety
Name of tree species used in agroforestry experiments, can be both as an intercrop or as an agroforestry mulch
length of time the experiment has been ongoing up to the date the data are being reported for in years. In bimodal rainfall systems with multiple growing seasons, seasons are identified by fractions of the year, 0.5, etc. If outcomes are reported in a unimodal rainfall system with one growing season per year, the duration can be equivalent to one year
the calendar year the measurement was taken. Seasons in multi-season systems are identified by decimals .1 or .2 for the first and second season respectively. When the measurements are average values for more than one year create a decimal for the years covered
first year the measurement was taken (YYYY). For yield or similar outcomes this should relate to the harvest year (rather than the planting year)
this only required for temporally aggregated observations (e.g. a result that has been averaged from crop yields reported from 2000,2001 and 2002)
this only required in areas where there are mutiple growing seasons in a year (e.g., areas with bimodal rainfall or irrigated cropping in dry seasons of a unimodal system)
this only required for temporally aggregated observations in areas with more than one growing season (e.g. a result that has been averaged from crop yields reported from 2000 season 1,2001 season 1 and 2002 season 1)
the experimental unit (EU) for which experiment outcomes are reported. This usually a crop or animal product. For cookstove papers it may be a cookstove. The EU for soil outcomes should be the crop(s) grown on the soil unless no crops are grown at all. Letters in the code should be lowercase. If the outcome refers to multiple experimental units (e.g. soil outcomes during an intercropping experiment) select all experimental units separated by a period (see EU2 tab)
the productivity, resilience, or mitigation outcome indicator that data are being reported on (see OUTCOMES2 tab)
free text description of the units of the data being reported without special characters or formatting
the value that corresponds to the control treatment and outcome. Please standard yields to t/ha where appropropriate, keeping as many decimal places as there is data for
the value that corresponds to the CSA treatment and outcome. Please standard yields to kg/ha where appropropriate, keeping as many decimal places as there is data for
the depth for which the MeanC and MeanT correspond for soil properties in cm (lowest depth value = upper, so if you have a depth of 0-20 cm the lowest value = 20)
the depth for which the MeanC and MeanT correspond for soil properties in cm (highest depth value = lower, so if you have a depth of 0-20 cm the highest value = 0)
the location in the paper where the data can be found. This should be three letters (fig, tab, or txt) in lowercase and a number (for figures and tables) to signify figure, table or text, respectively
monetary outcomes converted to international USD in 2010 using World Bank CPI, PPP and exchange rates. There are no data for Zimbabwe.
monetary outcomes converted to international USD in 2010 using World Bank CPI, PPP and exchange rates. There are no data for Zimbabwe.
is a negative result considered better than a positive result (i.e. MeanT/MeanC <1 = good)? This is indexed in using the Outcode field in the compednium and the Negative Values
field in the OUTCOMES tab
where were livestock diets in the treatment practice(s) sourced from?
Where were livestock diets in the control practice(s) sourced from?
the tree species for which the experiment outcome are reported
free text to describe the partial outcome
ERA practice codes that correspond to the partial outcome
Describes the logical process used to compare control to treatment (for developers)
year in which the ERA data entry took place. Either 2018 or 2020
ERA mulch code based on the nitrogen fixing properties specified in Nfix. NA for animal products
indicates the presence of irrigation in the control treatment
indicates the presence of irrigation in the experimental treatment
method of irrigation used in the control treatment. Cell will be blank if Irrigation.C is FALSE
method of irrigation used in the experimental treatment. Cell will be blank if Irrigation.T is FALSE
codes corresponding to all practices used on the control treatment described in C.Descrip. Only one code is placed in each column (see subpractices column of PRACTICES2 tab)
codes corresponding to all practices used on the CSA treatment described in T.Descrip. Only one code is placed in each column (see subpractices column of PRACTICES2 tab)
study number
number of observations
number of outcomes reported per study
latitude of study location in degrees or decimal degrees, the latter recorded to same accuracy as in publication (or estimated from googlemaps where locations were found from site names/descriptions). For decimal degrees the sign is not recorded here, but in the LatH column instead (all values should be positive)
longitude of study location in decimal degrees, recorded to same accuracy as in publication (or estimated from googlemaps where locations were found from site names or descriptions). For decimal degrees the sign is not recorded here, but in the LatH column instead. All values should be positive.
the natural log of the response ratio log(MeanT/MeanC)
pc=proportional change.It is a measure of the ratio of experimental to control outcomes
experimental ERA practices that are in the experimental, but not the control treatment
base practices that are shared between experimental and control treatments
the product code OutcomeCodes$Code for the observation using a - delim for multiple products
outcome pillar name
outcome subpillar name
outcome indicator name
outcome subindicator name
outcome subindicator name simplified
experimental subpractice name (note that this corresponds to the Subpractice.S field in the PracticeCodes)
experimental practice name
experimental practice theme name
base practice name (note that this corresponds to the Subpractice.S field in the PracticeCodes)
base practice name
base practice theme name
the full name of the product, including aspect of the component such as grain, meat or milk
product type name
product subtype name
simplified product name, excluding any aspects of component
latitude of study location in degrees or decimal degrees
longitude of study location in degrees or decimal degrees
manual estimation (e.g. from measuring on google earth) in m of the spatial uncertainty for a point location. The site should within an X m radius (the buffer.manual amount) of the point location specified. Unit is meters
longitude, latitude and buffer for the site
simplified version of AEZ16 removing the tropic/subtropic classification
AEZs for Africa South of the Sahara (SSA) based on the methodology developed by FAO and IIASA, using the scheme with 16 classes
AEZs Africa South of the Sahara (SSA) based on the methodology developed by FAO and IIASA, using the scheme with 5 classes
mean annual precipitation (mm) derived from the CHIRPS 2.0 dataset API at 0.05° resolution
mean annual temperature (C) derived from the NASA POWER dataset API at 0.5° resolution
weight percentage of clay particles (<0.0002 mm)
weight percentage of silt particles (0.0002-0.05 mm)
weight percentage of the sand particles (0.05-2 mm)
ERA.Compiled
An object of class data.table
(inherits from data.frame
) with 112859 rows and 135 columns.
ERA Project Team (2021)