Municipal Fiscal Indicators: Financial Statement Information, 2020-2022 by US Government | Finance and Economics

About this Dataset

Municipal Fiscal Indicators: Financial Statement Information, 2020-2022

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). Municipal Fiscal Indicators contains the most current financial data available for each of Connecticut's 169 municipalities.

The data contained in Indicators provides key financial and demographic information on municipalities in Connecticut. The data includes selected demographic and economic data relating to, or having an impact upon, a municipality’s financial condition.

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. Unlike prior years' where the audited financial information was compiled by OPM, the FY 2020 and beyond information in this edition was based upon the self-reporting by municipalities of their own audited data.

The most recent edition is for the Fiscal Years Ended 2018-2022 published in September 2024.

The most recent data on the Municipal Fiscal Indicators is included in the following datasets:

Municipal-Fiscal-Indicators: Financial Statement Information, 2020-2022
https://data.ct.gov/d/d6pe-dw46

Municipal-Fiscal-Indicators: Uniform Chart of Accounts, 2020-2022
https://data.ct.gov/d/e2qt-k238

Municipal Fiscal Indicators: Pension Funding Information for Defined Benefit Pension Plans, 2020-2022
https://data.ct.gov/d/73q3-sgr8

Municipal Fiscal Indicators: Type and Number of Pension Plans, 2020-2022
https://data.ct.gov/d/i84g-vvfb

Municipal Fiscal Indicators: Other Post-Employment Benefits (OPEB), 2020-2022
https://data.ct.gov/d/ei7n-pnn9

Municipal Fiscal Indicators: Economic and Grand List Data, 2019-2024
https://data.ct.gov/d/xgef-f6jp

Municipal Fiscal Indicators: Benchmark Labor Data, 2020-2024
https://data.ct.gov/d/5ijb-j6bn

Municipal Fiscal Indicators: Bond Ratings, 2019-2022
https://data.ct.gov/d/a65i-iag5

Municipal Fiscal Indicators: Individual Town Data, 2014-2022
https://data.ct.gov/d/ej6f-y2wf

Municipal Fiscal Indicators: Totals and Averages, 2014-2022
https://data.ct.gov/d/ryvc-y5rf
Organization: State of Connecticut
Last updated: 2024-11-29T20:50:28.490383
Tags: 2020-municipal-fiscal-indicators, 2021-municipal-fiscal-indicators, 2022-municipal-fiscal-indicators, municipal-fiscal-indicators, opm

Tables

Table 1

@usgov.state_of_connecticut_municipal_fiscal_indicators_finan_a340f47c.table_1

354.04 KB
510 rows
133 columns


CREATE TABLE table_1 (
  "year" BIGINT,
  "municipality_entity_name" VARCHAR,
  "municipality_fips_geoid" DOUBLE,
  "municipality_fips_code" DOUBLE,
  "municipality_tax_code" DOUBLE,
  "status" VARCHAR,
  "a_1_total_capital_assets_not_being_depreciated" BIGINT,
  "a_2_total_capital_assets_being_depreciated_net_of_accu_3bdcd9bd" BIGINT,
  "a_3_total_capital_assets" BIGINT,
  "a_6_net_investment_in_capital_assets" BIGINT,
  "a_9_restricted_net_position" DOUBLE,
  "a_12_unrestricted_net_position" BIGINT,
  "a_15_total_net_position" BIGINT,
  "b_3_change_in_net_position" BIGINT,
  "c_3_unrestricted_cash_and_cash_equivalents" DOUBLE,
  "c_6_investments" DOUBLE,
  "c_9_property_taxes_receivables_net" DOUBLE,
  "c_12_intergovernmental_receivables_net" DOUBLE,
  "c_15_interfund_receivables_due_from_other_funds" DOUBLE,
  "c_18_all_other_assets" DOUBLE,
  "c_21_total_assets" BIGINT,
  "c_24_total_deferred_outflows" DOUBLE,
  "c_27_accounts_payables" BIGINT,
  "c_28_notes_payable" DOUBLE,
  "c_30_unearned_revenues" DOUBLE,
  "c_33_interfund_payables_due_to_other_funds" DOUBLE,
  "c_36_all_other_liabilities" DOUBLE,
  "c_39_total_liabilities" BIGINT,
  "c_40_total_deferred_inflows" DOUBLE,
  "c_42_non_spendable_fund_balance" DOUBLE,
  "c_45_restricted_fund_balance" DOUBLE,
  "c_48_committed_fund_balance" DOUBLE,
  "c_51_assigned_fund_balance" DOUBLE,
  "c_54_unassigned_fund_balance" BIGINT,
  "c_57_total_fund_balance" BIGINT,
  "d_3_property_tax_revenue" BIGINT,
  "d_6_state_revenues" BIGINT,
  "d_9_federal_revenues" DOUBLE,
  "d_12_all_other_revenues" BIGINT,
  "d_15_total_revenues" BIGINT,
  "d_18_education_expenditures_board_of_education" BIGINT,
  "d_19_education_expenditures_regional_school_district" DOUBLE,
  "d_20_total_education_expenditures" BIGINT,
  "d_21_debt_service_expenditures" DOUBLE,
  "d_24_all_other_expenditures" BIGINT,
  "d_26_total_expenditures" BIGINT,
  "d_27_excess_revenues_over_under_expenditures" BIGINT,
  "d_28_transfers_in" BIGINT,
  "d_29_transfers_out" BIGINT,
  "d_33_all_other_financing_sources" DOUBLE,
  "d_34_all_other_financing_uses" DOUBLE,
  "d_39_total_net_other_financing_sources_uses" DOUBLE,
  "d_42_special_extraordinary_item" DOUBLE,
  "d_45_net_change_in_fund_balance_for_fiscal_year" BIGINT,
  "d_48_beginning_fund_balance_july_1_of_fiscal_year" DOUBLE,
  "d_51_restatement_fund_balance_flag" BOOLEAN,
  "d_54_original_amount_before_the_restatement" DOUBLE,
  "d_57_june_30th_fiscal_year_ended_fund_balance" BIGINT,
  "d_60_debt_service_expenditures_governmental_funds" BIGINT,
  "d_61_capital_outlay_expenditures_governmental_funds" DOUBLE,
  "e_1_enterprise_fund_1_name_of_fund" VARCHAR,
  "e_1_enterprise_fund_1_unrestricted_net_position" DOUBLE,
  "e_1_enterprise_fund_1_total_net_position" DOUBLE,
  "e_2_enterprise_fund_2_name_of_fund" VARCHAR,
  "e_2_enterprise_fund_2_unrestricted_net_position" DOUBLE,
  "e_2_enterprise_fund_2_total_net_position" DOUBLE,
  "e_3_enterprise_fund_3_name_of_fund" VARCHAR,
  "e_3_enterprise_fund_3_unrestricted_net_position" DOUBLE,
  "e_3_enterprise_fund_3_total_net_position" DOUBLE,
  "e_4_enterprise_fund_4_name_of_fund" VARCHAR,
  "e_4_enterprise_fund_4_unrestricted_net_position" DOUBLE,
  "e_4_enterprise_fund_4_total_net_position" DOUBLE,
  "e_5_enterprise_fund_5_name_of_fund" VARCHAR,
  "e_5_enterprise_fund_5_unrestricted_net_position" DOUBLE,
  "e_5_enterprise_fund_5_total_net_position" DOUBLE,
  "e_6_enterprise_fund_6_name_of_fund" DOUBLE,
  "e_6_enterprise_fund_6_unrestricted_net_position" DOUBLE,
  "e_6_enterprise_fund_6_total_net_position" DOUBLE,
  "e_7_enterprise_fund_7_name_of_fund" DOUBLE,
  "e_7_enterprise_fund_7_unrestricted_net_position" DOUBLE,
  "e_7_enterprise_fund_7_total_net_position" DOUBLE,
  "e_8_total_unrestricted_net_position_all_enterprise_funds" BIGINT,
  "e_8_total_net_position_all_enterprise_funds" BIGINT,
  "f_1_internal_service_fund_1_name_of_fund" VARCHAR,
  "f_1_internal_service_fund_1_unrestricted_net_position" DOUBLE,
  "f_1_internal_service_fund_1_total_net_position" DOUBLE,
  "f_2_internal_service_fund_2_name_of_fund" VARCHAR,
  "f_2_internal_service_fund_2_unrestricted_net_position" DOUBLE,
  "f_2_internal_service_fund_2_total_net_position" DOUBLE,
  "f_3_internal_service_fund_3_name_of_fund" VARCHAR,
  "f_3_internal_service_fund_3_unrestricted_net_position" DOUBLE,
  "f_3_internal_service_fund_3_total_net_position" DOUBLE,
  "f_4_internal_service_fund_4_name_of_fund" VARCHAR,
  "f_4_internal_service_fund_4_unrestricted_net_position" DOUBLE,
  "f_4_internal_service_fund_4_total_net_position" DOUBLE,
  "f_5_internal_service_fund_5_name_of_fund" VARCHAR,
  "f_5_internal_service_fund_5_unrestricted_net_position" DOUBLE,
  "f_5_internal_service_fund_5_total_net_position" DOUBLE,
  "f_6_internal_service_fund_6_name_of_fund" VARCHAR,
  "f_6_internal_service_fund_6_unrestricted_net_position" DOUBLE
);