ReadMe file for “data table_leaching_dissolved organic carbon and nitrogen.xls”, which includes data in: Hussain et al (2020). Leaching losses of dissolved organic carbon and nitrogen from agricultural soils in the upper US Midwest. Science of the Total Environment. This file describe the individual spreadsheet contained within the “data table_leaching_dissolved organic carbon and nitrogen.xls” for the publication in the STOTEN. For further enquiries, please contact Steve Hamilton (hamilton@msu.edu). Individual spreadsheets in “data table_leaching_dissolved organic carbon and nitrogen.xls” 1. annual precip_drainage 2. biomass_corn, perennial grasses 3. biomass_poplar 4. annual N leaching _vol-wtd conc 5. Summary_N leached 6. annual DOC leachin_vol-wtd conc 7. growing season length 8. correlation_nh4 VS no3 9. correlations_don VS no3_doc VS don Each spreadsheet is described below along with an explanation of variates. Note that ‘nan’ indicate data are missing or not available. First row indicates header; second row indicates units 1. Spreadsheet: annual precip_drainage Description: Precipitation measured from nearby Kellogg Biological Station (KBS) Long Term Ecological Research (LTER) Weather station, over 2009-2016 study period. Data shown in Figure 1; original data source for precipitation (https://lter.kbs.msu.edu/datatables/7). Drainage estimated from SALUS crop model. Note that drainage is percolation out of the root zone (0-125 cm). Annual precipitation and drainage values shown here are calculated for growing and non-growing crop periods. Variate Description year year of the observation crop “corn” “switchgrass” “miscanthus” “nativegrass” “restored prairie” “poplar” precip_G precipitation during growing period (milliMeter) precip_NG precipitation during non-growing period (milliMeter) drainage_G drainage during growing period (milliMeter) drainage_NG drainage during non-growing period (milliMeter) 2. Spreadsheet: biomass_corn, perennial grasses Description: Maximum aboveground biomass measurements from corn, switchgrass, miscanthus, native grass and restored prairie plots in Great Lakes Bioenergy Research Center (GLBRC) Biomass Cropping System Experiment (BCSE) during 2009-2015. Data shown in Figure 2. Variate Description year year of the observation date day of the observation (mm/dd/yyyy) crop “corn” “switchgrass” “miscanthus” “nativegrass” “restored prairie” “poplar” replicate each crop has four replicated plots, R1, R2, R3 and R4 station stations (S1, S2 and S3) of samplings within the plot. For more details, refer to link (https://data.sustainability.glbrc.org/protocols/156) species plant species that are rooted within the quadrat during the time of maximum biomass harvest. See protocol for more information, refer to link (http://lter.kbs.msu.edu/datatables/36) For maize biomass, grain and whole biomass reported in the paper (weed biomass or surface litter are excluded). Surface litter biomass not included in any crops; weed biomass not included in switchgrass and miscanthus, but included in grass mixture and prairie. fraction Fraction of biomass biomass_plot biomass per plot on dry-weight basis (Grams_Per_SquareMeter) biomass_ha biomass (megaGrams_Per_Hectare) by multiplying column biomass per plot with 0.01 3. Spreadsheet: biomass_poplar Description: Maximum aboveground biomass measurements from poplar plots in Great Lakes Bioenergy Research Center (GLBRC) Biomass Cropping System Experiment (BCSE) during 2009-2015. Data shown in Figure 2. Note that poplar biomass was estimated from crop growth curves until the poplar was harvested in the winter of 2013-14. Variate Description year year of the observation method methods of poplar biomass sampling date day of the observation (mm/dd/yyyy) replicate each crop has four replicated plots, R1, R2, R3 and R4 diameter_at_ground poplar diameter (milliMeter) at the ground diameter_at_15cm poplar diameter (milliMeter) at 15 cm height biomass_tree biomass per plot (Grams_Per_Tree) biomass_ha biomass (megaGrams_Per_Hectare) by multiplying biomass per tree with 0.01 4. Spreadsheet: annual N leaching_vol-wtd conc Description: Annual leaching rate (kiloGrams_N_Per_Hectare) and volume-weighted mean N concentrations (milliGrams_N_Per_Liter) of nitrate (no3) and dissolved organic nitrogen (don) in the leachate samples collected from corn, switchgrass, miscanthus, native grass, restored prairie and poplar plots in Great Lakes Bioenergy Research Center (GLBRC) Biomass Cropping System Experiment (BCSE) during 2009-2016. Data for nitrogen leached and volume-wtd mean N concentration shown in Figure 3a and Figure 3b, respectively. Note that ammonium (nh4) concentration were much lower and often undetectable (<0.07 milliGrams_N_Per_Liter). Also note that in 2009 and 2010 crop-years, data from some replicates are missing. Variate Description crop “corn” “switchgrass” “miscanthus” “nativegrass” “restored prairie” “poplar” crop-year year of the observation replicate each crop has four replicated plots, R1, R2, R3 and R4 no3 leached annual leaching rates of nitrate (kiloGrams_N_Per_Hectare) don leached annual leaching rates of don (kiloGrams_N_Per_Hectare) vol-wtd no3 conc. Volume-weighted mean no3 concentration (milliGrams_N_Per_Liter) vol-wtd don conc. Volume-weighted mean don concentration (milliGrams_N_Per_Liter) 5. Spreadsheet: summary_N leached Description: Summary of total amount and forms of N leached (kiloGrams_N_Per_Hectare) and the percent of applied N lost to leaching over the seven years for corn, switchgrass, miscanthus, native grass, restored prairie and poplar plots in Great Lakes Bioenergy Research Center (GLBRC) Biomass Cropping System Experiment (BCSE) during 2009-2016. Data for nitrogen amount leached shown in Figure 4a and percent of applied N lost shown in Figure 4b. Note the fraction of unleached N includes in harvest, accumulation in root biomass, soil organic matter or gaseous N emissions were not measured in the study. Variate Description crop “corn” “switchgrass” “miscanthus” “nativegrass” “restored prairie” “poplar” no3 leached annual leaching rates of nitrate (kiloGrams_N_Per_Hectare) don leached annual leaching rates of don (kiloGrams_N_Per_Hectare) N unleached N unleached (kiloGrams_N_Per_Hectare) in other sources are not studied % of N applied N lost to leaching % of N applied N lost to leaching 6. Spreadsheet: annual DOC leachin_vol-wtd conc Description: Annual leaching rate (kiloGrams_Per_Hectare) and volume-weighted mean N concentrations (milliGrams_Per_Liter) of dissolved organic carbon (DOC) in the leachate samples collected from corn, switchgrass, miscanthus, native grass, restored prairie and poplar plots in Great Lakes Bioenergy Research Center (GLBRC) Biomass Cropping System Experiment (BCSE) during 2009-2016. Data for DOC leached and volume-wtd mean DOC concentration shown in Figure 5a and Figure 5b, respectively. Note that in 2009 and 2010 crop-years, water samples were not available for DOC measurements. Variate Description crop “corn” “switchgrass” “miscanthus” “nativegrass” “restored prairie” “poplar” crop-year year of the observation replicate each crop has four replicated plots, R1, R2, R3 and R4 doc leached annual leaching rates of nitrate (kiloGrams_Per_Hectare) vol-wtd doc conc. volume-weighted mean doc concentration (milliGrams_Per_Liter) 7. Spreadsheet: growing season length Description: Growing season length (days) of corn, switchgrass, miscanthus, native grass, restored prairie and poplar plots in the Great Lakes Bioenergy Research Center (GLBRC) Biomass Cropping System Experiment (BCSE) during 2009-2015. Date shown in Figure S2. Note that growing season is from the date of planting or emergence to the date of harvest (or leaf senescence in case of poplar). Variate Description crop “corn” “switchgrass” “miscanthus” “nativegrass” “restored prairie” “poplar” year year of the observation growing season length growing season length (days) 8. Spreadsheet: correlation_nh4 VS no3 Description: Correlation of ammonium (nh4+) and nitrate (no3-) concentrations (milliGrams_N_Per_Liter) in the leachate samples from corn, switchgrass, miscanthus, native grass, restored prairie and poplar plots in Great Lakes Bioenergy Research Center (GLBRC) Biomass Cropping System Experiment (BCSE) during 2013-2015. Data shown in Figure S3. Note that nh4+ concentration in the leachates was very low compared to no3- and don concentration and often undetectable in three crop-years (2013-2015) when measurements are available. Variate Description crop “corn” “switchgrass” “miscanthus” “nativegrass” “restored prairie” “poplar” date date of the observation (mm/dd/yyyy) replicate each crop has four replicated plots, R1, R2, R3 and R4 nh4 conc nh4 concentration (milliGrams_N_Per_Liter) no3 conc no3 concentration (milliGrams_N_Per_Liter) 9. Spreadsheet: correlations_don VS no3_doc VS don Description: Correlations of don and nitrate concentrations (milliGrams_N_Per_Liter); and doc (milliGrams_Per_Liter) and don concentrations (milliGrams_N_Per_Liter) in the leachate samples of corn, switchgrass, miscanthus, native grass, restored prairie and poplar plots in Great Lakes Bioenergy Research Center (GLBRC) Biomass Cropping System Experiment (BCSE) during 2013-2015. Data of correlation of don and nitrate concentrations shown in Figure S4 a and doc and don concentrations shown in Figure S4 b. Variate Description crop “corn” “switchgrass” “miscanthus” “nativegrass” “restored prairie” “poplar” year year of the observation don don concentration (milliGrams_N_Per_Liter) no3 no3 concentration (milliGrams_N_Per_Liter) doc doc concentration (milliGrams_Per_Liter)