Municipal Fiscal Indicators, 2015
State of Connecticut
@usgov.state_of_connecticut_municipal_fiscal_indicators_2015
State of Connecticut
@usgov.state_of_connecticut_municipal_fiscal_indicators_2015
CREATE TABLE table_1 (
"municipality" VARCHAR,
"numbered" BIGINT,
"comptroller_town_code" BIGINT,
"county_identifier" VARCHAR,
"net_investment_in_capital_assets" DOUBLE,
"unrestricted_net_position" DOUBLE,
"total_net_position" DOUBLE,
"change_in_net_position" DOUBLE,
"nonspendable_fund_bal" DOUBLE,
"restricted_fund_bal" DOUBLE,
"committed_fund_bal" DOUBLE,
"assigned_fund_bal" DOUBLE,
"total_fund_bal" DOUBLE,
"unassigned_fund_bal" DOUBLE,
"unrestricted_fund_bal" DOUBLE,
"restatement_of_fund_balance_y_or_n" VARCHAR,
"inter_gov_rev" DOUBLE,
"tax_rev" DOUBLE,
"total_revenue" DOUBLE,
"education" DOUBLE,
"debt_service" DOUBLE,
"total_expenditures" DOUBLE,
"total_trans_to_genl_fund" DOUBLE,
"other_financing_sources" DOUBLE,
"total_trans_from_genl_fund" DOUBLE,
"other_financing_uses" DOUBLE,
"operating_surplus_deficit_including_transfers" DOUBLE,
"prior_yr_op_surplus_def_including_sources_and_uses" BIGINT,
"operating_surplus_deficit_including_sources_and_uses" DOUBLE,
"special_extraordinary_items" DOUBLE,
"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" DOUBLE,
"total_bonded_long_term_debt_rsd_town" DOUBLE,
"total_net_pension_liability" DOUBLE,
"curr_year_adjusted_taxes_collectible" DOUBLE,
"curr_year_taxes_collected" DOUBLE,
"curr_year_tax_collection_rate" DOUBLE,
"total_adjusted_taxes_collectible" DOUBLE,
"total_taxes_collected" DOUBLE,
"overal_total_tax_collection_rate" DOUBLE,
"n_2015_population" DOUBLE,
"moody_s_bond_ratings_nov_2016" VARCHAR,
"moody_s_bond_ratings_july_2015" VARCHAR,
"area_lmt" DOUBLE,
"acglfy15" DOUBLE,
"egl" DOUBLE,
"tanf15_recipients" DOUBLE,
"empl" DOUBLE,
"acmr" DOUBLE,
"enrollmt" DOUBLE
);
Anyone who has the link will be able to view this.