Uniform Chart of Accounts Municipal Spending Data
This dataset contains data for 2014-2019 sourced from the State of Connecticut Uniform Chart of Accounts (UCOA). This system enables the annual collection of unaudited municipal trial balance data at the local account level, along with a mapping, or “cross walk” of that data to a standard, uniform chart of accounts for comparative purposes. This data is collected and stored in a system of databases developed for the Office of Policy and Management (OPM), including a Data Warehouse of financial balances. These balances are recorded at the account level and contain both local and uniform account metadata.
Additional details can be found here: http://www.ct.gov/opm/cwp/view.asp?a=2984&q=576636
Some Municipalities are not included in this release. They can be found here: https://ucoa.ct.gov/benchmarking/#/
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/uniform-chart-of-accounts-municipal-spending-data-fdjf-7z7f\".\"uniform_chart_of_accounts_municipal_spending_data\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.