Municipal Fiscal Indicators, 2014
State of Connecticut
@usgov.state_of_connecticut_municipal_fiscal_indicators_2014
State of Connecticut
@usgov.state_of_connecticut_municipal_fiscal_indicators_2014
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
);
Anyone who has the link will be able to view this.