#
# File created on 2024-05-19 07:28:55 EDT
#
# U.S. Geological Survey
# 
# This file contains selected water-quality data for stations in the National Water 
# Information System water-quality database.  Explanation of codes found in this file are 
# followed by the retrieved data. 
#
# The data you have secured from the USGS NWISWeb database may include data that have 
# not received Director's approval and as such are provisional and subject to revision. 
# The data are released on the condition that neither the USGS nor the United States 
# Government may be held liable for any damages resulting from its authorized or 
# unauthorized use.
#
# To view additional data-quality attributes, output the results using these options:  
# one result per row, expanded attributes.  Additional precautions are at:
# https://help.waterdata.usgs.gov/tutorials/water-quality-data/help-using-the-water-quality-data-retrieval-system#Data_retrievals_precautions
#
#  agency_cd                  - Agency Code
#  site_no                    - USGS site number
#  sample_dt                  - Begin date
#  sample_tm                  - Begin time
#  sample_end_dt              - End date
#  sample_end_tm              - End time
#  sample_start_time_datum_cd - Time datum
#  tm_datum_rlbty_cd          - Time datum reliability code
#  coll_ent_cd                - Agency Collecting Sample Code
#  medium_cd                  - Sample Medium Code
#  tu_id                      - Taxonomic unit code
#  body_part_id               - Body part code
#  parm_cd                    - Parameter code
#  remark_cd                  - Remark code
#  result_va                  - Parameter value
#  val_qual_tx                - Result value qualifier code
#  meth_cd                    - Method code
#  dqi_cd                     - Data-quality indicator code
#  rpt_lev_va                 - Reporting level
#  rpt_lev_cd                 - Reporting level type
#  lab_std_va                 - Lab standard deviation
#  anl_ent_cd                 - Analyzing entity code
#
# The following parameters are included:
#  01046  - Iron, water, filtered, micrograms per liter
#  01056  - Manganese, water, filtered, micrograms per liter
#  04064  - Thallium, bed sediment smaller than 62.5 microns, dry sieved, total digestion, dry weight, milligrams per kilogram
#  34790  - Aluminum, bed sediment smaller than 62.5 microns, wet sieved, field, total digestion, dry weight, percent
#  34805  - Barium, bed sediment smaller than 62.5 microns, wet sieved, field, total digestion, dry weight, milligrams per kilogram
#  34810  - Beryllium, bed sediment smaller than 62.5 microns, wet sieved, field, total digestion, dry weight, milligrams per kilogram
#  34816  - Bismuth, bed sediment smaller than 177 microns, wet sieved, field, total digestion, dry weight, milligrams per kilogram
#  34825  - Cadmium, bed sediment smaller than 62.5 microns, wet sieved, field, total digestion, dry weight, milligrams per kilogram
#  34835  - Cerium, bed sediment smaller than 62.5 microns, wet sieved, field, total digestion, dry weight, milligrams per kilogram
#  34840  - Chromium, bed sediment smaller than 62.5 microns, wet sieved, field, total digestion, dry weight, milligrams per kilogram
#  34845  - Cobalt, bed sediment smaller than 62.5 microns, wet sieved, field, total digestion, dry weight, milligrams per kilogram
#  34850  - Copper, bed sediment smaller than 62.5 microns, wet sieved, field, total digestion, dry weight, milligrams per kilogram
#  34855  - Europium, bed sediment smaller than 62.5 microns, wet sieved, field, total digestion, dry weight, milligrams per kilogram
#  34860  - Gallium, bed sediment smaller than 62.5 microns, wet sieved, field, total digestion, dry weight, milligrams per kilogram
#  34870  - Gold, bed sediment smaller than 62.5 microns, wet sieved, field, total digestion, dry weight, milligrams per kilogram
#  34875  - Holmium, bed sediment smaller than 62.5 microns, wet sieved, field, total digestion, dry weight, milligrams per kilogram
#  34880  - Iron, bed sediment smaller than 62.5 microns, wet sieved, field, total digestion, dry weight, percent
#  34885  - Lanthanum, bed sediment smaller than 62.5 microns, wet sieved, field, total digestion, dry weight, milligrams per kilogram
#  34890  - Lead, bed sediment smaller than 62.5 microns, wet sieved, field, total digestion, dry weight, milligrams per kilogram
#  34895  - Lithium, bed sediment smaller than 62.5 microns, wet sieved, field, total digestion, dry weight, milligrams per kilogram
#  34905  - Manganese, bed sediment smaller than 62.5 microns, wet sieved, field, total digestion, dry weight, milligrams per kilogram
#  34910  - Mercury, bed sediment smaller than 62.5 microns, wet sieved, field, total digestion, dry weight, milligrams per kilogram
#  34915  - Molybdenum, bed sediment smaller than 62.5 microns, wet sieved, field, total digestion, dry weight, milligrams per kilogram
#  34920  - Neodymium, bed sediment smaller than 62.5 microns, wet sieved, field, total digestion, dry weight, milligrams per kilogram
#  34925  - Nickel, bed sediment smaller than 62.5 microns, wet sieved, field, total digestion, dry weight, milligrams per kilogram
#  34930  - Niobium, bed sediment smaller than 62.5 microns, wet sieved, field, total digestion, dry weight, milligrams per kilogram
#  34945  - Scandium, bed sediment smaller than 62.5 microns, wet sieved, field, total digestion, dry weight, milligrams per kilogram
#  34955  - Silver, bed sediment smaller than 62.5 microns, wet sieved, field, total digestion, dry weight, milligrams per kilogram
#  34965  - Strontium, bed sediment smaller than 62.5 microns, wet sieved, field, total digestion, dry weight, milligrams per kilogram
#  34975  - Tantalum, bed sediment smaller than 62.5 microns, wet sieved, field, total digestion, dry weight, milligrams per kilogram
#  34985  - Tin, bed sediment smaller than 62.5 microns, wet sieved, field, total digestion, dry weight, milligrams per kilogram
#  35005  - Vanadium, bed sediment smaller than 62.5 microns, wet sieved, field, total digestion, dry weight, milligrams per kilogram
#  35010  - Yttrium, bed sediment smaller than 62.5 microns, wet sieved, field, total digestion, dry weight, milligrams per kilogram
#  35015  - Ytterbium, bed sediment smaller than 62.5 microns, wet sieved, field, total digestion, dry weight, milligrams per kilogram
#  35020  - Zinc, bed sediment smaller than 62.5 microns, wet sieved, field, total digestion, dry weight, milligrams per kilogram
#  49274  - Titanium, bed sediment smaller than 62.5 microns, wet sieved (native water), field, recoverable, dry weight, percent
#
# Description of sample_start_time_datum_cd:
# EDT  - Eastern Daylight Time
#
# Description of tm_datum_rlbty_cd:
# T  - Transferred
#
# Description of coll_ent_cd and anl_ent_cd:
# USGS-WRD  - U.S. Geological Survey-Water Resources Discipline
#
# Description of medium_cd:
# SB  - Bottom material
# WS  - Surface water
#
# Description of tu_id:
# https://www.itis.gov/
#
# Description of body_part_id:
#
# Description of remark_cd:
# <  - Less than
#
# Description of val_qual_tx:
#
# Description of meth_cd:
# CV003  - Mercury, bed sed, CV AA, GD
# PLA11  - Metals, wf, ICP-AES (NWQL)
# PLM09  - 42 Elements by ICPMS (GD, NAWQA)
#
# Description of dqi_cd:
# A  - Historical data
#
# Description of rpt_lev_cd:
#
# Data for the following sites are included:
#  USGS 01475430 Darby Creek at Foxcroft, PA
#
agency_cd	site_no	sample_dt	sample_tm	sample_end_dt	sample_end_tm	sample_start_time_datum_cd	tm_datum_rlbty_cd	coll_ent_cd	medium_cd	tu_id	body_part_id	parm_cd	remark_cd	result_va	val_qual_tx	meth_cd	dqi_cd	rpt_lev_va	rpt_lev_cd	lab_std_va	anl_ent_cd
5s	15s	10d	5d	10d	5d	3s	1s	8s	3s	11s	11s	5s	1s	12s	5s	5s	1s	12s	6s	11s	8s
USGS	01475430	2000-05-17	15:30			EDT	T	USGS-WRD	WS			01046		60.7		PLA11	A				
USGS	01475430	2000-05-17	15:30			EDT	T	USGS-WRD	WS			01056		25.6		PLA11	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			04064	<	1		PLM09	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			34790		6.8		PLM09	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			34805		620		PLM09	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			34810		1.6		PLM09	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			34816	<	1		PLM09	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			34825		0.6		PLM09	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			34835		130		PLM09	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			34840		170		PLM09	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			34845		24		PLM09	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			34850		53		PLM09	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			34855		2		PLM09	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			34860		18		PLM09	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			34870	<	1		PLM09	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			34875		2		PLM09	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			34880		5.1		PLM09	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			34885		74		PLM09	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			34890		77		PLM09	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			34895		28		PLM09	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			34905		1200		PLM09	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			34910		0.36		CV003	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			34915		1.1		PLM09	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			34920		64		PLM09	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			34925		96		PLM09	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			34930		19		PLM09	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			34945		17		PLM09	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			34955		0.2		PLM09	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			34965		120		PLM09	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			34975		1		PLM09	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			34985		5		PLM09	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			35005		120		PLM09	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			35010		44		PLM09	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			35015		4		PLM09	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			35020		230		PLM09	A				
USGS	01475430	2000-06-14	14:00			EDT	T	USGS-WRD	SB			49274		0.590		PLM09	A				
USGS	01475430	2000-09-18	09:50			EDT	T	USGS-WRD	WS			01046		18.9		PLA11	A				
USGS	01475430	2000-09-18	09:50			EDT	T	USGS-WRD	WS			01056		10.6		PLA11	A