In 2013, the first of several Regional Stream Quality Assessments (RSQA) was done in the Midwest United States. The Midwest Stream Quality Assessment (MSQA) was a collaborative study by the U.S. Geological Survey National Water Quality Assessment and the U.S. Environmental Protection Agency National Rivers and Streams Assessment. One of the objectives of the RSQA, and thus the MSQA, is to characterize relations between stream ecology and water-quality stressors to determine the relative effects of these stressors on aquatic biota in streams. Data required to meet this objective included fish species and abundance data and physical and chemical water-quality characteristics of the ecological reaches of the sites that were sampled. This dataset comprises 135 fish species, 39,920 fish, 10 selected water-quality stressor metrics, and six selected fish community stressor response variables for 98 sites sampled for the MSQA.

In 2013, the first of several Regional Stream Quality Assessments (RSQA) was done in the Midwest United States. The Midwest Stream Quality Assessment (MSQA) was a collaborative study by the U.S. Geological Survey National Water Quality Assessment and the U.S. Environmental Protection Agency National Rivers and Streams Assessment. One of the objectives of the RSQA, and thus the MSQA, is to characterize relations between stream ecology and water-quality stressors to determine the relative effects of these stressors on aquatic biota in streams. Data required to meet this objective included fish species and abundance data and physical and chemical water-quality characteristics of the ecological reaches of the sites that were sampled. This dataset comprises 135 fish species, 39,920 fish, 10 selected water-quality stressor metrics, and six selected fish community stressor response variables for 98 sites sampled for the MSQA.

We deployed a sampler to characterize water quality from a household well tapping a shallow fractured dolomite aquifer in northeast Wisconsin. The sampler was deployed from January to May 2017, and monitored temperature, nitrate, chloride, specific conductance, and fluorescent dissolved organic matter on a minute time step; water was directed to sequential microbial filters during three recharge periods that ranged from 5 to 20 days. Results from the automated sampler demonstrate the dynamic nature of the household water quality, especially with regard to microbial targets, which were shown to vary 1 to 2 orders of magnitude during a single sampling event. We believe assessments of pathogen occurrence and concentration, and related assessments of drinking well vulnerability, would be improved by the time-integrated characterization provided by this sampler. This data release provides the data collected during this study and use for analyses described by Owens et al., 2018.

We deployed a sampler to characterize water quality from a household well tapping a shallow fractured dolomite aquifer in northeast Wisconsin. The sampler was deployed from January to May 2017, and monitored temperature, nitrate, chloride, specific conductance, and fluorescent dissolved organic matter on a minute time step; water was directed to sequential microbial filters during three recharge periods that ranged from 5 to 20 days. Results from the automated sampler demonstrate the dynamic nature of the household water quality, especially with regard to microbial targets, which were shown to vary 1 to 2 orders of magnitude during a single sampling event. We believe assessments of pathogen occurrence and concentration, and related assessments of drinking well vulnerability, would be improved by the time-integrated characterization provided by this sampler. This data release provides the data collected during this study and use for analyses described by Owens et al., 2018.

This dataset is a compilation of data obtained from the Idaho Department of Water Quality, the Idaho Department of Water Resources, and the Water Quality Portal. The 'Samples' table stores information about individual groundwater samples, including what was being sampled, when it was sampled, the results of the sample, etc. This table is related to the 'MonitoringLocation' table (which contains information about the well being sampled).

Water-quality data were collected by the Providence Water Supply Board (PWSB) from tributaries in the Scituate Reservoir drainage area, October 1, 2017 through September 30, 2022 (water years 2018 through 2022). Water-quality samples were collected by the PWSB either monthly or quarterly at fixed stations on 38 tributaries in the Scituate Reservoir drainage area, Rhode Island. These data were used to calculate instantaneous loads and yields of constituents in reports by the U.S. Geological Survey. Water-quality samples were collected following a strict sampling schedule so that water-quality samples would be representative of various weather conditions. Samples were analyzed at the PWSB water-quality laboratory at the P.J. Holton Water Purification Plant in Scituate, Rhode Island. Water-quality properties and constituent concentrations were measured by using unfiltered water samples. These water-quality properties included pH, alkalinity, color, turbidity, and concentrations of chloride, nitrite, nitrate, orthophosphate, and bacteria (Escherichia coli [E. coli] and total coliform). This data release will be updated annually to append additional water-quality data collected by the PWSB.