Capital Improvement Projects ( CIP) Expenditures
Capital improvement expenditures include upgrades to the Distribution and Transmission system such as new substations and transformers. They also include expenditures to build or upgrade power plants, new or upgraded chillers, new or upgraded facilities, and information technology infrastructure. All of these expenditures result in assets for the utility that become part of the rate base. Funding for CIP projects includes both current revenue and short-term debt or commercial paper which is eventually rolled into long-term bonds with a life of 30 years.
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 \"datahub-austintexas-gov/capital-improvement-projects-cip-expenditures-mfi5-y32n\".\"capital_improvement_projects_cip_expenditures\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
