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 
"}
EOF

See the Splitgraph documentation for more information.