Open repository in Console
Readme
Updated over 9 years ago
‧ Indexed 6 hours ago
Monthly Residential Energy Use
Actual electricity and natural gas meter reads for homes that participated in ME2/California Energy Upgrade pilot. Value is kWh or therms. Improvement date is the date that the energy upgrade was invoiced.
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 \"cityofberkeley-info/monthly-residential-energy-use-77ue-wzxv\".\"monthly_residential_energy_use\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.
Upstream Metadata