2016 Residential Sewer Rate Survey

The survey includes monthly sewer rates per “equivalent residential unit” (ERU)* served by municipal wastewater treatment plants in Washington State. Information was compiled from August 2016-January 2017 using information from utility billing web pages and phone surveys. Stormwater rates were also included as available.

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 \"wa-gov/2016-residential-sewer-rate-survey-sibs-5k6j\".\"2016_residential_sewer_rate_survey\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.