Utility Use and Cost Data for Executive Branch Agencies
This dataset summarizes the utility use and expenditures data for FY19 through FY22 for Executive Branch agencies.
The data was pulled from the state's utility tracking system, EnergyCAP, on March 20, 2023, with the exception of the waste disposal data, which was pulled from Core-CT, the state's human resource management and financials system.
The data below may be incomplete and will be updated once data collection has been completed.
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 \"ct-gov/utility-use-and-cost-data-for-executive-branch-3nmk-z2bz\".\"utility_use_and_cost_data_for_executive_branch\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
