Township Revenues, Expenditures & Cash Balances Budgeted By Fund By Year

CREATE TABLE table_1 (
  "unique_line_id" VARCHAR,
  "fiscal_year" BIGINT,
  "township_code" VARCHAR,
  "county_name" VARCHAR,
  "township_name" VARCHAR,
  "beginning_balance_owned_cemetery" BIGINT  -- BEGINNING BALANCE - OWNED CEMETERY,
  "tax_revenues_owned_cemetery" BIGINT  -- TAX REVENUES - OWNED CEMETERY,
  "other_receipts_owned_cemetery" BIGINT  -- OTHER RECEIPTS - OWNED CEMETERY,
  "expenditures_owned_cemetery" BIGINT  -- EXPENDITURES - OWNED CEMETERY,
  "ending_balance_owned_cemetery" BIGINT  -- ENDING BALANCE - OWNED CEMETERY,
  "beginning_balance_non_owned_cemetery" BIGINT  -- BEGINNING BALANCE - NON OWNED CEMETERY,
  "tax_revenue_non_owned_cemetery" BIGINT  -- TAX REVENUE - NON OWNED CEMETERY,
  "other_receipts_non_owned_cemetery" BIGINT  -- OTHER RECEIPTS - NON OWNED CEMETERY,
  "expenditures_non_owned_cemetery" BIGINT  -- EXPENDITURES - NON OWNED CEMETERY,
  "ending_balance_non_owned_cemetery" BIGINT  -- ENDING BALANCE - NON OWNED CEMETERY,
  "beginning_balance_township_hall" BIGINT  -- BEGINNING BALANCE - TOWNSHIP HALL,
  "tax_revenue_township_hall" BIGINT  -- TAX REVENUE - TOWNSHIP HALL,
  "other_receipts_township_hall" BIGINT  -- OTHER RECEIPTS - TOWNSHIP HALL,
  "expenditures_township_hall" BIGINT  -- EXPENDITURES - TOWNSHIP HALL,
  "ending_balance_township_hall" BIGINT  -- ENDING BALANCE - TOWNSHIP HALL,
  "beginning_balance_township_hall_repairs" BIGINT  -- BEGINNING BALANCE - TOWNSHIP HALL REPAIRS,
  "tax_revenue_township_hall_repairs" BIGINT  -- TAX REVENUE - TOWNSHIP HALL REPAIRS,
  "other_receipts_township_hall_repairs" BIGINT  -- OTHER RECEIPTS - TOWNSHIP HALL REPAIRS,
  "expenditures_township_hall_repairs" BIGINT  -- EXPENDITURES - TOWNSHIP HALL REPAIRS,
  "ending_balance_township_hall_repairs" BIGINT  -- ENDING BALANCE - TOWNSHIP HALL REPAIRS,
  "beginning_balance_library" BIGINT  -- BEGINNING BALANCE - LIBRARY,
  "tax_revenue_library" BIGINT  -- TAX REVENUE - LIBRARY,
  "other_receipts_library" BIGINT  -- OTHER RECEIPTS - LIBRARY,
  "expenditures_library" BIGINT  -- EXPENDITURES - LIBRARY,
  "ending_balance_library" BIGINT  -- ENDING BALANCE - LIBRARY,
  "beginning_balance_litigation" BIGINT  -- BEGINNING BALANCE - LITIGATION,
  "tax_revenue_litigation" BIGINT  -- TAX REVENUE - LITIGATION,
  "other_receipts_litigation" BIGINT  -- OTHER RECEIPTS - LITIGATION,
  "expenditures_litigation" BIGINT  -- EXPENDITURES - LITIGATION,
  "ending_balance_litigation" BIGINT  -- ENDING BALANCE - LITIGATION,
  "beginning_balance_tort_liability" BIGINT  -- BEGINNING BALANCE - TORT LIABILITY,
  "tax_revenue_tort_liability" BIGINT  -- TAX REVENUE - TORT LIABILITY,
  "other_receipts_tort_liability" BIGINT  -- OTHER RECEIPTS - TORT LIABILITY,
  "expenditures_tort_liability" BIGINT  -- EXPENDITURES - TORT LIABILITY,
  "ending_balance_tort_liability" BIGINT  -- ENDING BALANCE - TORT LIABILITY,
  "beginning_balance_fire_ems" BIGINT  -- BEGINNING BALANCE - FIRE/EMS,
  "tax_revenues_fire_ems" BIGINT  -- TAX REVENUES - FIRE/EMS,
  "other_receipts_fire_ems" BIGINT  -- OTHER RECEIPTS - FIRE/EMS,
  "expenditures_fire_ems" BIGINT  -- EXPENDITURES - FIRE/EMS,
  "ending_balance_fire_ems" BIGINT  -- ENDING BALANCE - FIRE/EMS,
  "beginning_balance_other_misc" BIGINT  -- BEGINNING BALANCE - OTHER/MISC,
  "other_receipts_other_misc" BIGINT  -- OTHER RECEIPTS - OTHER/MISC,
  "expenditures_other_misc" BIGINT  -- EXPENDITURES - OTHER/MISC,
  "ending_balance_other_misc" BIGINT  -- ENDING BALANCE - OTHER/MISC,
  "beginning_balance_all_funds" BIGINT  -- BEGINNING BALANCE - ALL FUNDS,
  "tax_revenues_all_funds" BIGINT  -- TAX REVENUES - ALL FUNDS,
  "other_receipts_all_funds" BIGINT  -- OTHER RECEIPTS - ALL FUNDS,
  "expenditures_all_funds" BIGINT  -- EXPENDITURES - ALL FUNDS,
  "ending_balance_all_funds" BIGINT  -- ENDING BALANCE - ALL FUNDS,
  "location" VARCHAR
);