austintexas-gov/strategic-measure-percent-of-median-household-unww-rhuk
Icon for Socrata external plugin
 
Readme
Updated 3 months ago
Indexed 2 hours ago

Strategic Measure_ Percent of Median Household Income Spent on the Average Annual Residential Austin Water Bill

This dataset demonstrates the affordability of the average Austin Water residential customer’s annual combined water and wastewater bill as a percentage of median household income.

In 2020, the Austin Water Affordability Metrics Report restated the 2013 to 2018 median household income (MHI) using information from DataUSA, which is an easy-to-use platform that displays specific data about Austin. Due to COVID-19, DataUSA experienced impacts that delayed updating their website with 2020 data, as such Austin Water utilized CensusReporter.org for 2019 and 2020 MHI data. The American Community Survey is the source for both DataUSA and Census Reporter.

Data sources: Austin Water Rates and Charges Group and American Community Survey (ACS) reported by the U.S. Census Bureau, and DataUSA.

View more details and insights related to this dataset on the story page: https://data.austintexas.gov/stories/s/Percent-of-median-household-income-spent-on-the-av/w8c4-v9a2

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"austintexas-gov/strategic-measure-percent-of-median-household-unww-rhuk\".\"strategic_measure_percent_of_median_household\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • strategic_measure_percent_of_median_household
     
Upstream Metadata