Water-quality and streamflow data for United States and Canadian sites in the Red River Basin and scripts for trend analysis - Data supporting water-quality trend analysis in the Red River of the North basin, 1970-2017

A comprehensive study to evaluate water-quality trends in the international Red River of the North basin and to assess water-quality conditions for Red River of the North crossing the international boundary near Emerson, Manitoba was completed by the U.S. Geological Survey (USGS) in cooperation with the International Joint Commission, North Dakota Department of Environmental Quality (NDDEQ) and Minnesota Pollution Control Agency (MPCA), and in collaboration with Manitoba Sustainable Development (MSD) and Environment and Climate Change Canada (ECCC). In this dataset a zipped folder is provided which contains all files necessary to run models and produce results published in U.S. Geological Scientific Investigations Report 2020-5079 [Nustad, R.A., and Vecchia, A.V., 2020, Water-quality trends for selected sites and constituents in the international Red River of the North Basin, Minnesota and North Dakota, United States, and Manitoba, Canada, 1970-2017: U.S. Geological Survey Scientific Investigations Report 2020-5079, 75 p., https://doi.org/10.3133/sir20205079]. In addition, this dataset contains data for streamflow, and water-quality by site contained in three core types of comma separated values (csv) files (site_flow, site_qw_ions, and site_qw_nuts) for 34 sites used in trend analysis of the Red River of the North Basin. Streamflow data for the 24 U.S. sites were gathered from the National Water Information System (https://nwis.waterdata.usgs.gov/nwis). Streamflow data for the 10 Canadian sites were provided to the USGS in excel spreadsheets through email communication and were collected by Water Survey of Canada. Water-quality data for the 24 U.S. sites were gathered from the National Water Quality Monitoring Council Water Quality Portal (https://www.waterqualitydata.us/) and collected by four U.S. government agencies: MPCA; Minnesota Department of Agriculture (MNDA), NDDEQ (NDHD, formerly North Dakota Department of Health); and USGS. Water-quality data for the 10 Canadian sites were provided to the USGS in excel spreadsheets through email communication and were collected by two Canadian government agencies: ECCC and MSD. Data for sites, RREmerson_2 and PemRWindygates_38, were provided by ECCC. Data for sites, BoRCarman_32, CCrSpringfield_36, LaSRLaBarrierePark_33, RoRDominionCity_30, RatROtterburne_31, RRfloodway_1, RRSelkirk_3, SRSouthPerimeterHwy_34, were provided by MSD. Each child page contains 34 csv files containing data for each site.