Municipal Fiscal Indicators, 2019

CREATE TABLE table_1 (
  "year" BIGINT,
  "town" 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_fund_balance_flag" BOOLEAN,
  "inter_gov_revenue" BIGINT,
  "tax_revenue" BIGINT,
  "total_revenue" BIGINT,
  "education" BIGINT,
  "annual_debt_service" BIGINT,
  "total_expenditures" BIGINT,
  "total_transfers_in" BIGINT,
  "other_financing_sources" BIGINT,
  "total_trans_to_general_fund" BIGINT,
  "other_financing_uses" BIGINT,
  "operating_surplus_deficit_including_transactions" BIGINT,
  "previous_year_operating_surplus_def_including_transactions" BIGINT,
  "operating_surplus_deficit_including_sources_and_uses" BIGINT,
  "special_or_extraordinary_items" BIGINT,
  "large_deficit_indicator_entprise_fund" BIGINT,
  "large_deficit_indicator_internal_service_fund" BIGINT,
  "regional_school_district_rsd_debt" BIGINT,
  "town_bonded_long_term_debt" BIGINT,
  "total_bonded_long_term_debt" BIGINT,
  "net_pension_liability" BIGINT,
  "current_year_adjusted_taxes_collectible" BIGINT,
  "current_year_taxes_collected" BIGINT,
  "property_tax_collection_rate_current_year" DOUBLE,
  "total_adjusted_taxes_collectible" BIGINT,
  "total_taxes_collected" BIGINT,
  "overall_tot_tax_colleton_rate" DOUBLE,
  "population" BIGINT,
  "area_limit" DOUBLE,
  "net_grand_list" BIGINT,
  "egl" DOUBLE,
  "rpa_identifier" VARCHAR,
  "deficit_bonds" BOOLEAN,
  "n_10_year_scheduled_repayment_principal_amount" BIGINT,
  "total_net_opeb_liability" BIGINT
);