Baselight

Municipal Fiscal Indicators, 2014

State of Connecticut

@usgov.state_of_connecticut_municipal_fiscal_indicators_2014

Loading...
Loading...

About this Dataset

Municipal Fiscal Indicators, 2014

Municipal Fiscal Indicators is an annual compendium of information compiled by the Office of Policy and Management, Intergovernmental Policy Division (IGP), 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, IGP Division. This database of information includes selected demographic and economic data relating to, or having an impact upon, a municipality’s financial condition.
Organization: State of Connecticut
Last updated: 2020-11-12T14:54:08.122708
Tags: fiscal-indicators, municipal, municipal-fiscal-indicators, opm

Tables

Table 1

@usgov.state_of_connecticut_municipal_fiscal_indicators_2014.table_1
  • 89.01 KB
  • 170 rows
  • 53 columns
Loading...

CREATE TABLE table_1 (
  "municipality" VARCHAR,
  "initials" VARCHAR,
  "fiscal_year_end" BIGINT,
  "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_balance" BIGINT,
  "restricted_fund_balance" BIGINT,
  "committed_fund_balance" BIGINT,
  "assigned_fund_balance" BIGINT,
  "total_fund_balance" BIGINT,
  "unassigned_fund_balance" BIGINT,
  "unrestricted_fund_balance" BIGINT,
  "restatement_of_fund_balance_y_or_n" VARCHAR,
  "inter_governmental_revenue" BIGINT,
  "tax_revenue" 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,
  "prior_yr_op_surplus_def_including_sources_and_uses" BIGINT,
  "operating_surplus_deficit_including_sources_and_uses" BIGINT,
  "special_extraordinary_items" BIGINT,
  "deficit_individual_enterprise_funds_y_or_n" VARCHAR,
  "deficit_individual_internal_service_funds_y_or_n" VARCHAR,
  "rsd_debt" DOUBLE,
  "town_bonded_long_term_debt" BIGINT,
  "total_bonded_long_term_debt_rsd_town" DOUBLE,
  "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_2014_population" DOUBLE,
  "moody_s_bond_ratings_dec_2014" VARCHAR,
  "moody_s_bond_ratings_july_2014" VARCHAR,
  "area_lmt" DOUBLE,
  "acglfy14" DOUBLE,
  "egl" DOUBLE,
  "tanf14_recipients" DOUBLE,
  "empl" DOUBLE,
  "acmr" DOUBLE,
  "enrollmt" DOUBLE
);

Share link

Anyone who has the link will be able to view this.