Iowa Township Fund Balances By Fiscal 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,
  "ending_balance_owned_cemetery" BIGINT  -- ENDING BALANCE - OWNED CEMETERY,
  "beginning_balance_non_owned_cemetery" BIGINT  -- BEGINNING BALANCE - NON OWNED CEMETERY,
  "ending_balance_non_owned_cemetery" BIGINT  -- ENDING BALANCE - NON OWNED CEMETERY,
  "beginning_balance_township_hall" BIGINT  -- BEGINNING BALANCE - TOWNSHIP HALL,
  "ending_balance_township_hall" BIGINT  -- ENDING BALANCE - TOWNSHIP HALL,
  "beginning_balance_township_hall_repairs" BIGINT  -- BEGINNING BALANCE - TOWNSHIP HALL REPAIRS,
  "ending_balance_township_hall_repairs" BIGINT  -- ENDING BALANCE - TOWNSHIP HALL REPAIRS,
  "beginning_balance_library" BIGINT  -- BEGINNING BALANCE - LIBRARY,
  "ending_balance_library" BIGINT  -- ENDING BALANCE - LIBRARY,
  "beginning_balance_litigation" BIGINT  -- BEGINNING BALANCE - LITIGATION,
  "ending_balance_litigation" BIGINT  -- ENDING BALANCE - LITIGATION,
  "beginning_balance_tort_liability" BIGINT  -- BEGINNING BALANCE - TORT LIABILITY,
  "ending_balance_tort_liability" BIGINT  -- ENDING BALANCE - TORT LIABILITY,
  "beginning_balance_fire_ems" BIGINT  -- BEGINNING BALANCE - FIRE/EMS,
  "ending_balance_fire_ems" BIGINT  -- ENDING BALANCE - FIRE/EMS,
  "beginning_balance_other" BIGINT  -- BEGINNING BALANCE - OTHER,
  "ending_balance_other" BIGINT  -- ENDING BALANCE - OTHER,
  "beginning_balance_total" BIGINT  -- BEGINNING BALANCE - TOTAL,
  "ending_balance_total" BIGINT  -- ENDING BALANCE - TOTAL,
  "location" VARCHAR
);