Annual Mean Concentration of Nitrate in Drinking Water, 2022
healthdata.tn.gov | Last Updated 9 Aug 2024This dataset describes the annual mean concentration of the contaminant, nitrate, in community water systems across Tennessee in 2022.
This dataset has the following 8 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Row Identifier | row_identifier | number | Number assigned to line of data for identification purposes | 17298646 16852765 16524208 16593079 17181315 view top 100 |
Year | year | number | Year of analysis | 2022 view top 100 |
County FIPS | county_fips | number | County FIPS code assigned by the U.S. Census Bureau for county level identification | 47073 47131 47155 47033 47065 view top 100 |
County Name | county_name | text | Name of County | Hawkins Sevier Obion Crockett Knox view top 100 |
PWS ID | pws_id | text | Identification number assigned to public water system (PWS) | TN0000133 TN0000101 TN0000147 TN0000525 TN0000024 view top 100 |
Average Concentration | average_concentration | number | Average concentration level of analyte observed in county's drinking water, measured in milligrams per liter (mg/L) | 0.20 0.10 0.44 0.30 0.61 view top 100 |
MCL Category ID | mcl_category_id | number | Maximum contaminant level category (1=Greater than MCL, 2=Less than or equal to MCL, 3=Not detected) | 2 view top 100 |
Population Served | population_served | number | Number of people drinking water is supplied to, in a county | 5411 24929 3149 5893 5155 view top 100 |