Name: Iowa State Revolving Fund Programs By County
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Iowa State Revolving Fund Programs By County

This dataset includes number of projects and loan amount for Iowa State Revolving Fund Programs in FY 2017 and FY 2018 break down by county.
Organization: State of Iowa
Last updated: 2023-01-19T23:46:22.606996

Tables

Table 1

@usgov.state_of_iowa_iowa_state_revolving_fund_programs_by_county.table_1

20.88 kB
198 rows
16 columns

CREATE TABLE table_1 (
  "fiscal_year" BIGINT,
  "county" VARCHAR,
  "srf_construction_loan_program_investment_amount" DOUBLE  -- SRF Construction Loan Program ($ Investment Amount),
  "srf_construction_loan_program_of_project" DOUBLE  -- SRF Construction Loan Program (# Of Project),
  "srf_planning_design_loan_investment_amount" DOUBLE  -- SRF Planning & Design Loan ($ Investment Amount),
  "srf_planning_design_loan_of_project" DOUBLE  -- SRF Planning & Design Loan (# Of Project),
  "local_water_protection_program_investment_amount" DOUBLE  -- Local Water Protection Program ($ Investment Amount),
  "local_water_protection_program_of_project" DOUBLE  -- Local Water Protection Program (# Of Project),
  "livestock_water_quality_program_investment_amount" DOUBLE  -- Livestock Water Quality Program ($ Investment Amount),
  "livestock_water_quality_program_of_project" DOUBLE  -- Livestock Water Quality Program (# Of Project),
  "on_site_wastewater_assistance_program_investment_amount" DOUBLE  -- On-Site Wastewater Assistance Program ($ Investment Amount),
  "on_site_wastewater_assistance_program_of_project" DOUBLE  -- On-Site Wastewater Assistance Program (# Of Project),
  "general_non_point_source_investment_amount" DOUBLE  -- General Non-Point Source ($ Investment Amount),
  "general_non_point_source_of_project" DOUBLE  -- General Non-Point Source (# Of Project),
  "total_by_county" BIGINT  -- Total $ By County,
  "total_of_projects_by_county" BIGINT  -- Total # Of Projects By County
);