About this Dataset

Municipal Fiscal Indicators, 2017

Municipal Fiscal Indicators is an annual compendium of information compiled by the Office of Policy and Management, Office of Finance, Municipal Finance Services Unit (MFS). The data contained in Indicators provides key financial and demographic information on municipalities in Connecticut.

Municipal Fiscal Indicators contains the most current financial data available for each of Connecticut's 169 municipalities. The majority of this data was compiled from the audited financial statements that are filed annually with the State of Connecticut, Office of Policy and Management, Office of Finance. This database of information includes selected demographic and economic data relating to, or having an impact upon, a municipality’s financial condition. The most recent edition is for the Fiscal Years Ended 2017 published in December of 2018
Organization: State of Connecticut
Last updated: 2020-11-12T14:58:38.704834
Tags: fiscal, indicators, municipal, municipal-fiscal-indicators

Tables

Table 1

@usgov.state_of_connecticut_municipal_fiscal_indicators_2017.table_1

90.29 kB
170 rows
51 columns

CREATE TABLE table_1 (
  "municipality" VARCHAR,
  "numbered" BIGINT,
  "comptroller_town_code" BIGINT,
  "county_identifier" VARCHAR,
  "net_investment_in_capital_assets" BIGINT,
  "unrestricted_net_position" BIGINT,
  "total_net_position" BIGINT,
  "change_in_net_position" BIGINT,
  "nonspendable_fund_bal" BIGINT,
  "restricted_fund_bal" BIGINT,
  "committed_fund_bal" BIGINT,
  "assigned_fund_bal" BIGINT,
  "total_fund_bal" BIGINT,
  "unassigned_fund_bal" BIGINT,
  "unrestricted_fund_bal" BIGINT,
  "restatement_of_fund_balance_y_or_n" BOOLEAN  -- Restatement Of Fund Balance (Y Or N),
  "inter_gov_rev" BIGINT,
  "tax_rev" BIGINT,
  "total_revenue" BIGINT,
  "education" BIGINT,
  "debt_service" BIGINT,
  "total_expenditures" BIGINT,
  "total_trans_to_genl_fund" BIGINT,
  "other_financing_sources" BIGINT,
  "total_trans_from_genl_fund" BIGINT,
  "other_financing_uses" BIGINT,
  "operating_surplus_deficit_including_transfers" BIGINT  -- Operating Surplus (Deficit) Including Transfers,
  "prior_yr_op_surplus_def_including_sources_and_uses" BIGINT  -- Prior Yr OP Surplus (Def) Including Sources And Uses,
  "operating_surplus_deficit_including_sources_and_uses" BIGINT  -- Operating Surplus (Deficit) Including Sources And Uses,
  "special_extraordinary_items" BIGINT  -- Special / Extraordinary Items,
  "rsd_debt" DOUBLE,
  "town_bonded_long_term_debt" BIGINT,
  "total_bonded_long_term_debt_rsd_town" DOUBLE  -- Total Bonded Long Term Debt (RSD + Town),
  "total_net_pension_liability" BIGINT,
  "curr_year_adjusted_taxes_collectible" BIGINT,
  "curr_year_taxes_collected" BIGINT,
  "curr_year_tax_collection_rate" DOUBLE,
  "total_adjusted_taxes_collectible" BIGINT,
  "total_taxes_collected" BIGINT,
  "overal_total_tax_collection_rate" DOUBLE,
  "n_2017_population" DOUBLE  -- 2017 Population,
  "moody_s_bond_ratings_june_2017" VARCHAR,
  "area_lmt" DOUBLE,
  "acglfy17" DOUBLE,
  "egl" DOUBLE,
  "tanf17_recipients" DOUBLE,
  "tfa17_recipients" DOUBLE,
  "empl" DOUBLE,
  "acmr" VARCHAR,
  "enrollmt" DOUBLE,
  "rpa_identifier" VARCHAR
);