Icon for Socrata external plugin
Open repository in Console
Updated 3 years ago
Indexed 4 hours ago

2019 Kansas City Energy and Water Consumption Benchmarking for City-Owned Buildings

2019 Energy and Water consumption of City-Owned buildings 10,000 SQFT or greater, required by the Energy Empowerment Ordinance, using the Energy Star Portfolio Manager tool. The City provided some buildings below this threshold when available. The data were collected in 2020.

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" \
{"sql": "
    SELECT *
    FROM \"kcmo/2019-kansas-city-energy-and-water-consumption-iy94-ug87\".\"2019_kansas_city_energy_and_water_consumption\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • 2019_kansas_city_energy_and_water_consumption