# # File created on 2024-05-23 11:35:22 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: # 50468 - Escherichia coli, defined substrate test method (DSTM), water, most probable number per 100 milliliters # 50569 - Total coliforms, defined substrate test method (DSTM), water, most probable number per 100 milliliters # # Description of sample_start_time_datum_cd: # EST - Eastern Standard Time # # Description of tm_datum_rlbty_cd: # K - Known # # Description of coll_ent_cd and anl_ent_cd: # USGS-WRD - U.S. Geological Survey-Water Resources Discipline # USGS-WRD - U.S. Geological Survey-Water Resources Discipline # # Description of medium_cd: # 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: # BAC14 - E coli, water, Colilert (24-28) # BAC15 - E coli, water,Colilert-18(18-22) # BAC47 - Tot coliform, Colilert (24-28hr) # BAC48 - Total coliform, Colilert-18 # # Description of dqi_cd: # S - Provisional # # Description of rpt_lev_cd: # # Data for the following sites are included: # USGS 04168557 DETROIT R 1250 FT DS R ROUGE AT RIVER ROUGE, MI # 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 04168557 2021-09-01 11:00 EST K USGS-WRD WS 50468 5 BAC15 S USGS-WRD USGS 04168557 2021-09-01 11:00 EST K USGS-WRD WS 50569 1100 BAC48 S USGS-WRD USGS 04168557 2021-10-20 12:30 EST K USGS-WRD WS 50468 4 BAC15 S USGS-WRD USGS 04168557 2021-10-20 12:30 EST K USGS-WRD WS 50569 650 BAC48 S USGS-WRD USGS 04168557 2021-11-16 11:15 EST K USGS-WRD WS 50468 6 BAC14 S USGS-WRD USGS 04168557 2021-11-16 11:15 EST K USGS-WRD WS 50569 150 BAC47 S USGS-WRD USGS 04168557 2021-12-14 12:45 EST K USGS-WRD WS 50468 16 BAC15 S USGS-WRD USGS 04168557 2021-12-14 12:45 EST K USGS-WRD WS 50569 280 BAC48 S USGS-WRD USGS 04168557 2022-03-16 10:00 EST K USGS-WRD WS 50468 < 1 BAC15 S USGS-WRD USGS 04168557 2022-03-16 10:00 EST K USGS-WRD WS 50569 11 BAC48 S USGS-WRD USGS 04168557 2022-04-12 15:00 EST K USGS-WRD WS 50468 1 BAC15 S USGS-WRD USGS 04168557 2022-04-12 15:00 EST K USGS-WRD WS 50569 9 BAC48 S USGS-WRD USGS 04168557 2022-04-19 12:00 EST K USGS-WRD WS 50468 4 BAC15 S USGS-WRD USGS 04168557 2022-04-19 12:00 EST K USGS-WRD WS 50569 32 BAC48 S USGS-WRD USGS 04168557 2022-05-02 14:30 EST K USGS-WRD WS 50468 6 BAC14 S USGS-WRD USGS 04168557 2022-05-02 14:30 EST K USGS-WRD WS 50569 37 BAC47 S USGS-WRD USGS 04168557 2022-05-18 10:00 EST K USGS-WRD WS 50468 10 BAC15 S USGS-WRD USGS 04168557 2022-05-18 10:00 EST K USGS-WRD WS 50569 110 BAC48 S USGS-WRD USGS 04168557 2022-06-01 16:00 EST K USGS-WRD WS 50468 56 BAC15 S USGS-WRD USGS 04168557 2022-06-01 16:00 EST K USGS-WRD WS 50569 210 BAC48 S USGS-WRD USGS 04168557 2022-06-15 11:00 EST K USGS-WRD WS 50468 13 BAC15 S USGS-WRD USGS 04168557 2022-06-15 11:00 EST K USGS-WRD WS 50569 100 BAC48 S USGS-WRD USGS 04168557 2022-06-28 13:26 EST K USGS-WRD WS 50468 1 BAC15 S USGS-WRD USGS 04168557 2022-06-28 13:26 EST K USGS-WRD WS 50569 150 BAC48 S USGS-WRD USGS 04168557 2022-07-12 12:15 EST K USGS-WRD WS 50468 2 BAC15 S USGS-WRD USGS 04168557 2022-07-12 12:15 EST K USGS-WRD WS 50569 820 BAC48 S USGS-WRD USGS 04168557 2022-08-30 15:30 EST K USGS-WRD WS 50468 28 BAC15 S USGS-WRD USGS 04168557 2022-08-30 15:30 EST K USGS-WRD WS 50569 1100 BAC48 S USGS-WRD USGS 04168557 2022-09-06 14:15 EST K USGS-WRD WS 50468 5 BAC15 S USGS-WRD USGS 04168557 2022-09-06 14:15 EST K USGS-WRD WS 50569 980 BAC48 S USGS-WRD USGS 04168557 2022-09-20 13:30 EST K USGS-WRD WS 50468 8 BAC15 S USGS-WRD USGS 04168557 2022-09-20 13:30 EST K USGS-WRD WS 50569 1300 BAC48 S USGS-WRD USGS 04168557 2022-10-05 14:15 EST K USGS-WRD WS 50468 21 BAC15 S USGS-WRD USGS 04168557 2022-10-05 14:15 EST K USGS-WRD WS 50569 370 BAC48 S USGS-WRD USGS 04168557 2023-03-30 13:30 EST K USGS-WRD WS 50468 1 BAC15 S USGS-WRD USGS 04168557 2023-03-30 13:30 EST K USGS-WRD WS 50569 3 BAC48 S USGS-WRD USGS 04168557 2023-05-23 15:00 EST K USGS-WRD WS 50468 27 BAC15 S USGS-WRD USGS 04168557 2023-05-23 15:00 EST K USGS-WRD WS 50569 650 BAC48 S USGS-WRD USGS 04168557 2023-06-07 09:45 EST K USGS-WRD WS 50468 43 BAC15 S USGS-WRD USGS 04168557 2023-06-07 09:45 EST K USGS-WRD WS 50569 730 BAC48 S USGS-WRD USGS 04168557 2023-06-22 09:15 EST K USGS-WRD WS 50468 12 BAC15 S USGS-WRD USGS 04168557 2023-06-22 09:15 EST K USGS-WRD WS 50569 270 BAC48 S USGS-WRD USGS 04168557 2023-07-05 13:30 EST K USGS-WRD WS 50468 8 BAC15 S USGS-WRD USGS 04168557 2023-07-05 13:30 EST K USGS-WRD WS 50569 650 BAC48 S USGS-WRD USGS 04168557 2023-07-19 09:30 EST K USGS-WRD WS 50468 2 BAC15 S USGS-WRD USGS 04168557 2023-07-19 09:30 EST K USGS-WRD WS 50569 610 BAC48 S USGS-WRD USGS 04168557 2023-08-02 15:20 EST K USGS-WRD WS 50468 6 BAC15 S USGS-WRD USGS 04168557 2023-08-02 15:20 EST K USGS-WRD WS 50569 1100 BAC48 S USGS-WRD USGS 04168557 2023-08-16 09:00 EST K USGS-WRD WS 50468 3 BAC15 S USGS-WRD USGS 04168557 2023-08-16 09:00 EST K USGS-WRD WS 50569 1300 BAC48 S USGS-WRD USGS 04168557 2023-08-29 13:00 EST K USGS-WRD WS 50468 12 BAC15 S USGS-WRD USGS 04168557 2023-08-29 13:00 EST K USGS-WRD WS 50569 980 BAC48 S USGS-WRD USGS 04168557 2023-09-13 09:10 EST K USGS-WRD WS 50468 17 BAC15 S USGS-WRD USGS 04168557 2023-09-13 09:10 EST K USGS-WRD WS 50569 1400 BAC48 S USGS-WRD USGS 04168557 2023-09-27 17:15 EST K USGS-WRD WS 50468 < 1 BAC15 S USGS-WRD USGS 04168557 2023-10-11 16:40 EST K USGS-WRD WS 50468 28 BAC15 S USGS-WRD USGS 04168557 2023-10-11 16:40 EST K USGS-WRD WS 50569 690 BAC48 S USGS-WRD USGS 04168557 2023-10-26 09:45 EST K USGS-WRD WS 50468 < 1 BAC15 S USGS-WRD USGS 04168557 2023-10-26 09:45 EST K USGS-WRD WS 50569 290 BAC48 S USGS-WRD USGS 04168557 2023-11-06 12:50 EST K USGS-WRD WS 50468 8 BAC15 S USGS-WRD USGS 04168557 2023-11-06 12:50 EST K USGS-WRD WS 50569 170 BAC48 S USGS-WRD USGS 04168557 2023-12-04 16:00 EST K USGS-WRD WS 50468 6 BAC15 S USGS-WRD USGS 04168557 2023-12-04 16:00 EST K USGS-WRD WS 50569 210 BAC48 S USGS-WRD USGS 04168557 2023-12-18 16:00 EST K USGS-WRD WS 50468 13 BAC15 S USGS-WRD USGS 04168557 2023-12-18 16:00 EST K USGS-WRD WS 50569 310 BAC48 S USGS-WRD USGS 04168557 2024-01-03 10:00 EST K USGS-WRD WS 50468 7 BAC15 S USGS-WRD USGS 04168557 2024-01-03 10:00 EST K USGS-WRD WS 50569 390 BAC48 S USGS-WRD