File (spreadsheet) contains a summary of data presented in the journal article titled "Effects of future hydroclimatic conditions on microbial water quality and management practices in two agricultural watersheds". This dataset is associated with the following publication: Coffey, R.P., J. Butcher, B. Benham, and T. Johnson. Modeling the Effects of Future Hydroclimatic Conditions on Microbial Water Quality and Management Practices in Two Agricultural Watersheds. Transactions of the ASABE. AMERICAN SOCIETY OF AGRICULTURAL AND BIOLOGICAL ENGINEERS, ST. JOSEPH, MI, USA, 63(3): 753-770, (2020).

This dataset provides detailed information on availability of model resources (including models and datasets) that support the modeling of six key water-quality constituents (or constituent categories) across the hydrologic system. In addition, resources associated with nine “cross-cutting” topics for modeling water quality are included, with “cross-cutting” defined herein as having relevance to more than one constituent. The model and data resources were generated as a companion product to a related publication (Lucas and others, 2025) that identifies gaps in water-quality modeling capabilities needed for assessments, projections, and evaluation of management alternatives to support ecosystem health and human beneficial use of water resources. Multiple spreadsheet tables include modeling resources for contemporary and representative models that represent an extensive but not exhaustive list; the models or datasets within each worksheet are presented in terms of the model or data source type, relevant hydrologic compartment(s), and software availability (defined at the bottom of each worksheet). Models originating in government, academia, non-governmental organizations, and private industry were considered. We emphasize models that are widely used, open source, and representative of the state of the art; additionally, models were included that are published in the literature and (or) for which documentation is easily available on the internet. This data release includes the metadata and the modeling capabilities workbook, “WQ_Models_Tables_1-14.xlsx” that includes a cross-cutting topics overview tab and the following cross-cutting topics worksheets: Table 1–Climate Forcing Datasets; Table 2–(Bio)geochemical Modeling; Table 3–Watershed Modeling; Table 4–River Modeling; Table 5–Lake and Reservoir Modeling; Table 6–Reservoir Operations and Outflow Modeling; Table 7–Estuary Modeling; Table 8–Groundwater Modeling; Table 9–Water Reuse Modeling; and a constituents tables overview tab and the following constituents worksheets: Table 10–Water Temperature; Table 11–Salinity; Table 12–Nutrients; Table 13–Sediment; Table 14–Geologically Sourced Constituents.

This USGS data release contains 2013 streamflow, baseflow, and precipitation data from three hydrologically-diverse streams in the United States used to develop a conceptual framework for effectively anticipating water-quality changes resulting from changes in agricultural activities. The framework combined generalized concepts on the movement of water, the environmental behavior of chemicals and eroded soil, and the designed functions of various agricultural activities. The framework addresses the impacts on water quality of a broad range of agricultural chemicals and sediment across a variety of hydrologic settings. • Chesterville Branch near Crumpton, Maryland, (USGS site ID - 01493112) had substantial baseflow throughout the year with increased streamflow within a day of rainfall. • Indian Creek at State Line RD, Leawood, Kansas (USGS site ID - 06893390) was a fastflow-dominated urban steam that was not well connected to shallow groundwater. • The watershed of Leary-Weber Ditch at Mohawk, Indiana (USGS site ID - 03361638) has an extensive subsurface drainage network within its watershed. These data support the following publication: Capel, P.D., Wolock, D.M., Coupe, R.H., and Roth, J.L., 2017, A conceptual framework for effectively anticipating water-quality changes resulting from changes in agricultural activities: U.S. Geological Survey Scientific Investigations Report 2017-5095, 35 p., https://doi.org/10.3133/sir20175095.

This USGS data release contains 2013 streamflow, baseflow, and precipitation data from three hydrologically-diverse streams in the United States used to develop a conceptual framework for effectively anticipating water-quality changes resulting from changes in agricultural activities. The framework combined generalized concepts on the movement of water, the environmental behavior of chemicals and eroded soil, and the designed functions of various agricultural activities. The framework addresses the impacts on water quality of a broad range of agricultural chemicals and sediment across a variety of hydrologic settings. • Chesterville Branch near Crumpton, Maryland, (USGS site ID - 01493112) had substantial baseflow throughout the year with increased streamflow within a day of rainfall. • Indian Creek at State Line RD, Leawood, Kansas (USGS site ID - 06893390) was a fastflow-dominated urban steam that was not well connected to shallow groundwater. • The watershed of Leary-Weber Ditch at Mohawk, Indiana (USGS site ID - 03361638) has an extensive subsurface drainage network within its watershed. These data support the following publication: Capel, P.D., Wolock, D.M., Coupe, R.H., and Roth, J.L., 2017, A conceptual framework for effectively anticipating water-quality changes resulting from changes in agricultural activities: U.S. Geological Survey Scientific Investigations Report 2017-5095, 35 p., https://doi.org/10.3133/sir20175095.

Water-quality and streamflow data are available at https://doi.org/10.5066/F7P55KJN. Calculated nutrient and sediment loads are available at https://doi.org/10.5066/P96H2BDO. Inputs to the Chesapeake Bay Program's watershed model are available at https://doi.org/10.5066/P93SVYQG. Estimated nutrient and sediment management-practice load reductions are available at https://doi.org/10.5066/P95WG7G0. Expected physical effects of agricultural conservation practices are available at https://doi.org/10.5066/P9VY95KT. This dataset is associated with the following publication: Webber, J., j. Chanat, J. Clune, O. Devereux, N. Hall, R. Sabo, and Q. Zhang. Evaluating water-quality trends in agricultural watersheds prioritized for management-practice implementation. JOURNAL OF ENVIRONMENTAL MANAGEMENT. Elsevier Science Ltd, New York, NY, USA, 305-330, (2024).

The U.S. Geological Survey (USGS), in cooperation with the Missouri Department of Natural Resources (MDNR), collects data pertaining to the surface-water resources of Missouri. These data are collected as part of the Missouri Ambient Water-Quality Monitoring Network (AWQMN) and are stored and maintained by the USGS National Water Information System (NWIS) database. These data constitute a valuable source of reliable, impartial, and timely information for developing an improved understanding of the water resources of the State. Water-quality data collected between water years 1993 and 2017 were analyzed for long term trends and the network was investigated to identify data gaps or redundant data to assist MDNR on how to optimize the network in the future. This is a companion data release product to the Scientific Investigation Report: Richards, J.M., and Barr, M.N., 2021, General water-quality conditions, long-term trends, and network analysis at selected sites within the Ambient Water-Quality Monitoring Network in Missouri, water years 1993–2017: U.S. Geological Survey Scientific Investigations Report 2021–5079, 75 p., https://doi.org/10.3133/sir20215079. The following selected tables are included in this data release in compressed (.zip) format: AWQMN_EGRET_data.xlsx -- Data retrieved from the USGS National Water Information System database that was quality assured and conditioned for network analysis of the Missouri Ambient Water-Quality Monitoring Network AWQMN_R-QWTREND_data.xlsx -- Data retrieved from the USGS National Water Information System database that was quality assured and conditioned for analysis of flow-weighted trends for selected sites in the Missouri Ambient Water-Quality Monitoring Network AWQMN_R-QWTREND_outliers.xlsx -- Data flagged as outliers during analysis of flow-weighted trends for selected sites in the Missouri Ambient Water-Quality Monitoring Network AWQMN_R-QWTREND_outliers_quarterly.xlsx -- Data flagged as outliers during analysis of flow-weighted trends using a simulated quarterly sampling frequency dataset for selected sites in the Missouri Ambient Water-Quality Monitoring Network AWQMN_descriptive_statistics_WY1993-2017.xlsx -- Descriptive statistics for selected water-quality parameters at selected sites in the Missouri Ambient Water-Quality Monitoring Network The following selected graphics are included in this data release in .pdf format. Also included in this data release are web pages accessible for people with disabilities provided in compressed .zip format. The web pages present the same information as the .pdf files: Annual and seasonal discharge trends.pdf -- Graphics of discharge trends produced from the EGRET software for selected sites in the Missouri Ambient Water-Quality Monitoring Network. Graphics provided to support the interpretations in the Scientific Investigations Report. Annual_and_seasonal_discharge_trends_htm.zip -- Compressed web page presenting graphics of discharge trends produced from the EGRET software for selected sites in the Missouri Ambient Water-Quality Monitoring Network. Graphics provided to support the interpretations in the Scientific Investigations Report. Graphics of simulated quarterly sampling frequency trends.pdf -- Graphics of results of simulated quarterly sampling frequency trends produced by the R-QWTREND software at selected sites in the Missouri Ambient Water-Quality Monitoring Network. Graphics provided to support the interpretations in the Scientific Investigations Report. Graphics_of_simulated_quarterly_sampling_frequency_trends_htm.zip -- Compressed web page presenting graphics of results of simulated quarterly sampling frequency trends produced by the R-QWTREND software at selected sites in the Missouri Ambient Water-Quality Monitoring Network. Graphics provided to support the interpretations in the Scientific Investigations Report. Graphics of median parameter values.pdf -- Graphics of median values for selected parameters at selected

The U.S. Geological Survey (USGS), in cooperation with the Missouri Department of Natural Resources (MDNR), collects data pertaining to the surface-water resources of Missouri. These data are collected as part of the Missouri Ambient Water-Quality Monitoring Network (AWQMN) and are stored and maintained by the USGS National Water Information System (NWIS) database. These data constitute a valuable source of reliable, impartial, and timely information for developing an improved understanding of the water resources of the State. Water-quality data collected between water years 1993 and 2017 were analyzed for long term trends and the network was investigated to identify data gaps or redundant data to assist MDNR on how to optimize the network in the future. This is a companion data release product to the Scientific Investigation Report: Richards, J.M., and Barr, M.N., 2021, General water-quality conditions, long-term trends, and network analysis at selected sites within the Ambient Water-Quality Monitoring Network in Missouri, water years 1993–2017: U.S. Geological Survey Scientific Investigations Report 2021–5079, 75 p., https://doi.org/10.3133/sir20215079. The following selected tables are included in this data release in compressed (.zip) format: AWQMN_EGRET_data.xlsx -- Data retrieved from the USGS National Water Information System database that was quality assured and conditioned for network analysis of the Missouri Ambient Water-Quality Monitoring Network AWQMN_R-QWTREND_data.xlsx -- Data retrieved from the USGS National Water Information System database that was quality assured and conditioned for analysis of flow-weighted trends for selected sites in the Missouri Ambient Water-Quality Monitoring Network AWQMN_R-QWTREND_outliers.xlsx -- Data flagged as outliers during analysis of flow-weighted trends for selected sites in the Missouri Ambient Water-Quality Monitoring Network AWQMN_R-QWTREND_outliers_quarterly.xlsx -- Data flagged as outliers during analysis of flow-weighted trends using a simulated quarterly sampling frequency dataset for selected sites in the Missouri Ambient Water-Quality Monitoring Network AWQMN_descriptive_statistics_WY1993-2017.xlsx -- Descriptive statistics for selected water-quality parameters at selected sites in the Missouri Ambient Water-Quality Monitoring Network The following selected graphics are included in this data release in .pdf format. Also included in this data release are web pages accessible for people with disabilities provided in compressed .zip format. The web pages present the same information as the .pdf files: Annual and seasonal discharge trends.pdf -- Graphics of discharge trends produced from the EGRET software for selected sites in the Missouri Ambient Water-Quality Monitoring Network. Graphics provided to support the interpretations in the Scientific Investigations Report. Annual_and_seasonal_discharge_trends_htm.zip -- Compressed web page presenting graphics of discharge trends produced from the EGRET software for selected sites in the Missouri Ambient Water-Quality Monitoring Network. Graphics provided to support the interpretations in the Scientific Investigations Report. Graphics of simulated quarterly sampling frequency trends.pdf -- Graphics of results of simulated quarterly sampling frequency trends produced by the R-QWTREND software at selected sites in the Missouri Ambient Water-Quality Monitoring Network. Graphics provided to support the interpretations in the Scientific Investigations Report. Graphics_of_simulated_quarterly_sampling_frequency_trends_htm.zip -- Compressed web page presenting graphics of results of simulated quarterly sampling frequency trends produced by the R-QWTREND software at selected sites in the Missouri Ambient Water-Quality Monitoring Network. Graphics provided to support the interpretations in the Scientific Investigations Report. Graphics of median parameter values.pdf -- Graphics of median values for selected parameters at selected

The U.S. Geological Survey (USGS), in cooperation with the Missouri Department of Natural Resources (MDNR), collects data pertaining to the surface-water resources of Missouri. These data are collected as part of the Missouri Ambient Water-Quality Monitoring Network (AWQMN) and are stored and maintained by the USGS National Water Information System (NWIS) database. These data constitute a valuable source of reliable, impartial, and timely information for developing an improved understanding of the water resources of the State. Water-quality data collected between 1993 and 2017 were analyzed for long term trends and the network was investigated to identify data gaps or redundant data to assist MDNR on how to optimize the network in the future. This is a companion data release product to the Scientific Investigation Report: Richards, J.M., and Barr, M.N., 2021, General water-quality conditions, long-term trends, and network analysis at selected sites within the Ambient Water-Quality Monitoring Network in Missouri, water years 1993–2017: U.S. Geological Survey Scientific Investigations Report 2021–5079, 75 p., https://doi.org/10.3133/sir20215079. The following selected tables are included in this data release in compressed (.zip) format: AWQMN_EGRET_data.xlsx -- Data retrieved from the USGS National Water Information System database that was quality assured and conditioned for network analysis of the Missouri AWQMN AWQMN_R-QWTREND_data.xlsx -- Data retrieved from the USGS National Water Information System database that was quality assured and conditioned for analysis of flow-weighted trends for selected sites in the Missouri AWQMN AWQMN_R-QWTREND_outliers.xlsx -- Data flagged as outliers during analysis of flow-weighted trends for selected sites in the Missouri AWQMN AWQMN_R-QWTREND_outliers_quarterly.xlsx -- Data flagged as outliers during analysis of flow-weighted trends using a simulated quarterly sampling frequency dataset for selected sites in the Missouri AWQMN AWQMN_descriptive_statistics_WY1993-2017.xlsx -- Descriptive statistics for selected water-quality parameters at selected sites in the Missouri AWQMN

The U.S. Geological Survey (USGS), in cooperation with the Missouri Department of Natural Resources (MDNR), collects data pertaining to the surface-water resources of Missouri. These data are collected as part of the Missouri Ambient Water-Quality Monitoring Network (AWQMN) and are stored and maintained by the USGS National Water Information System (NWIS) database. These data constitute a valuable source of reliable, impartial, and timely information for developing an improved understanding of the water resources of the State. Water-quality data collected between 1993 and 2017 were analyzed for long term trends and the network was investigated to identify data gaps or redundant data to assist MDNR on how to optimize the network in the future. This is a companion data release product to the Scientific Investigation Report: Richards, J.M., and Barr, M.N., 2021, General water-quality conditions, long-term trends, and network analysis at selected sites within the Ambient Water-Quality Monitoring Network in Missouri, water years 1993–2017: U.S. Geological Survey Scientific Investigations Report 2021–5079, 75 p., https://doi.org/10.3133/sir20215079. The following selected tables are included in this data release in compressed (.zip) format: AWQMN_EGRET_data.xlsx -- Data retrieved from the USGS National Water Information System database that was quality assured and conditioned for network analysis of the Missouri AWQMN AWQMN_R-QWTREND_data.xlsx -- Data retrieved from the USGS National Water Information System database that was quality assured and conditioned for analysis of flow-weighted trends for selected sites in the Missouri AWQMN AWQMN_R-QWTREND_outliers.xlsx -- Data flagged as outliers during analysis of flow-weighted trends for selected sites in the Missouri AWQMN AWQMN_R-QWTREND_outliers_quarterly.xlsx -- Data flagged as outliers during analysis of flow-weighted trends using a simulated quarterly sampling frequency dataset for selected sites in the Missouri AWQMN AWQMN_descriptive_statistics_WY1993-2017.xlsx -- Descriptive statistics for selected water-quality parameters at selected sites in the Missouri AWQMN

This data release presents truth data and benchmark results describing simulation of hydrologic drought events in the conterminous United States. This data release supports a publication (Simeone and others, 2024) which documents drought benchmarking methods and their application to the results of the National Water Model (NWM) version 2.1. Truth data used were observations at U.S. Geological Survey streamgages across the conterminous United States. These data include 4662 U.S. Geological Survey streamgages with a historical period from 1984-2016. The following files are included in this data release: 1) kappa_long_nwm.csv: Benchmark results for the Cohen's kappa evaluation metrics in long table format. 2) spear_bias_dist_long_nwm.csv: Benchmark results for the Spearman's, bias, and distributional evaluation metrics in long table format. 3) ann_eval_long_nwm.csv: Benchmark results for the annual drought evaluation metrics in long table format. 4) streamflow_percentiles_nwm.zip: A zip file containing individual streamflow percentile data files used in this analysis as truth data. 5) input_data_nwm.zip: A zip file with input data for individual streamgages used for our data analysis pipeline as truth data. 6) streamflow_gages_in_study.csv: Metadata information for the 4662 U.S. Geological Survey streamgages contained in the above datasets.