About this Dataset

Economic Development Projects - Under Contract

This dataset includes information on economic development projects that have been awarded incentives through Iowa Economic Development Authority programs as early as FY 2003, have signed contracts with the state and are in either the “performance” period, the “maintenance” period or are "in default" as of the end of the fiscal year noted. In most cases, projects are required to have met job, wage and capital investment obligations by their “Project Completion Date”. Beyond the completion date, projects are required to maintain the obligated jobs and investment through the “Maintenance Date." All projects provide information on total project costs, capital investment, as well as the amount of direct assistance and tax credits awarded to the project. Projected and contracted job data is available for all projects. However, project completion jobs and reported jobs is only available for those projects in the "maintenance" period. Projects in the "performance" period are still in the process of being implemented and are not yet complete. Projects in Default were considered “in default” as of the end of the annual report cut-off date (typically end of fiscal year). The status “in default” is a temporary one since businesses are allowed a contractually designated cure period to correct the default. Reasons for being considered “in default” range from not filing required reports to not creating the obligated jobs or investment required by the contract.
Organization: State of Iowa
Last updated: 2023-01-19T23:57:47.525046
Tags: direct-assistance, economic-development, maintenance, new, performance, projects, tax-credits

Tables

Table 1

@usgov.state_of_iowa_economic_development_projects_under_contract.table_1

50.24 kB
176 rows
34 columns

CREATE TABLE table_1 (
  "company_name" VARCHAR,
  "county" VARCHAR,
  "city" VARCHAR,
  "status" VARCHAR,
  "program" VARCHAR,
  "primary_funding_agreement" VARCHAR,
  "award_date" TIMESTAMP,
  "total_project_cost" BIGINT,
  "capital_investment" BIGINT,
  "direct_assistance_awarded" BIGINT,
  "tax_benefits_awarded" BIGINT,
  "projected_jobs_created" BIGINT  -- Projected Jobs - Created,
  "projected_jobs_retained" BIGINT  -- Projected Jobs - Retained,
  "projected_jobs_other" BIGINT  -- Projected Jobs - Other,
  "projected_jobs_total" BIGINT  -- Projected Jobs - Total,
  "projected_qualifying_wage" DOUBLE,
  "contracted_jobs_created" BIGINT  -- Contracted Jobs - Created,
  "contracted_jobs_retained" BIGINT  -- Contracted Jobs - Retained,
  "contracted_jobs_other_created" BIGINT  -- Contracted Jobs - Other Created,
  "contracted_jobs_total" BIGINT  -- Contracted Jobs - Total,
  "contacted_qualifying_wage" DOUBLE,
  "project_completion_jobs_created" DOUBLE  -- Project Completion Jobs - Created,
  "project_completion_jobs_retained" DOUBLE  -- Project Completion Jobs - Retained,
  "project_completion_jobs_other_created" DOUBLE  -- Project Completion Jobs - Other Created,
  "project_completion_jobs_total" DOUBLE  -- Project Completion Jobs - Total,
  "verified_total_project_cost" DOUBLE,
  "project_completion_date" TIMESTAMP,
  "reported_jobs_created" DOUBLE  -- Reported Jobs - Created,
  "reported_jobs_retained" DOUBLE  -- Reported Jobs - Retained,
  "reported_jobs_other_created" DOUBLE  -- Reported Jobs - Other Created,
  "reported_jobs_total" DOUBLE  -- Reported Jobs - Total,
  "date_reported" TIMESTAMP,
  "project_maintenance_date" TIMESTAMP,
  "city_coordinates" VARCHAR
);