Municipal Fiscal Indicators: Individual Town Data, 2014-2022
State of Connecticut
@usgov.state_of_connecticut_municipal_fiscal_indicators_indiv_efda0775
State of Connecticut
@usgov.state_of_connecticut_municipal_fiscal_indicators_indiv_efda0775
CREATE TABLE table_1 (
"town" VARCHAR,
"tax_code" DOUBLE,
"municipality_fips" DOUBLE,
"municipality_fips_geoid" DOUBLE,
"fiscal_year_end" BIGINT,
"population_state_dept_of_public_health" DOUBLE,
"average_daily_membership_school_enrollment_state_educa_1eab3091" DOUBLE,
"bond_rating_as_of_july_1_moody_s" VARCHAR,
"unemployment_annual_average" DOUBLE,
"equalized_net_grand_list" DOUBLE,
"equalized_mill_rate" DOUBLE,
"net_grand_list" DOUBLE,
"mill_rate_real_estate_personal_property" DOUBLE,
"mill_rate_motor_vehicle" DOUBLE,
"current_year_adjusted_tax_levy" BIGINT,
"current_year_tax_collection" DOUBLE,
"total_taxes_collected_as_a_af_total_outstanding" DOUBLE,
"property_tax_revenues" BIGINT,
"intergovernmental_revenues" BIGINT,
"total_revenues" BIGINT,
"total_transfers_in_from_other_funds" BIGINT,
"total_revenues_and_other_financing_sources" BIGINT,
"education_expenditures" BIGINT,
"operating_expenditures" BIGINT,
"total_expenditures" BIGINT,
"total_transfers_out_to_other_funds" BIGINT,
"total_expenditures_and_other_financing_uses" BIGINT,
"net_change_in_fund_balance" BIGINT,
"nonspendable" BIGINT,
"restricted" BIGINT,
"committed" BIGINT,
"assigned" BIGINT,
"unassigned" BIGINT,
"total_fund_balance_deficit" BIGINT,
"net_pension_liability" DOUBLE,
"net_opeb_liability" DOUBLE,
"bonded_long_term_debt" DOUBLE,
"annual_debt_service" BIGINT
);
Anyone who has the link will be able to view this.