About this Dataset

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/#/
Organization: State of Connecticut
Last updated: 2020-11-12T14:55:56.898382
Tags: expenditures, municipal, spending, ucoa

Tables

Table 1

@usgov.state_of_connecticut_uniform_chart_of_accounts_municip_bd0ce4bf.table_1

30.12 MB
954,970 rows
17 columns

CREATE TABLE table_1 (
  "fiscalyear" BIGINT,
  "municipality" VARCHAR,
  "localaccount" VARCHAR,
  "localfund" VARCHAR,
  "localfunction" VARCHAR,
  "localdepartment" VARCHAR,
  "localsubdepartment" DOUBLE,
  "localobject" VARCHAR,
  "localproject" VARCHAR,
  "uniformaccount" VARCHAR,
  "uniformfund" VARCHAR,
  "uniformfunction" VARCHAR,
  "uniformdepartment" VARCHAR,
  "uniformobject" VARCHAR,
  "uniformprojectname" VARCHAR,
  "debit" DOUBLE,
  "credit" DOUBLE
);