ct-gov/uniform-chart-of-accounts-municipal-spending-data-fdjf-7z7f
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 8 months ago
Indexed 1 month ago

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.

 
Preview
  • uniform_chart_of_accounts_municipal_spending_data
     
     
     
     
     
Upstream Metadata