Natural Gas Utilities Revenue, Units Sold and Customers by Year

Beginning in 2015, the dataset shows the revenue, units sold, and average number of customers by customer class for each natural gas utility operating in Iowa.

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 \"mydata-iowa-gov/natural-gas-utilities-revenue-units-sold-and-4zs6-cs59\".\"natural_gas_utilities_revenue_units_sold_and\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.