About this Dataset

Economic Development Projects - Closed

This dataset includes information on economic development projects were awarded incentives through Iowa Economic Development Authority programs as early as FY 2003, and are considered “completed” by IEDA’s compliance team at the end of the fiscal year (annual report cut-off date). Each project has been evaluated to determine if the it met all the terms of the contract. If all contractual terms are met, projects are categorized as "successful" and are under no additional obligation to report information to IEDA regarding the project. If a project was unable to meet all terms required in the contract, the IEDA compliance team determined the award “recapture” – consisting of paying back all or a portion of the direct assistance provided by the state or returning (or not claiming) some or all tax credits that had been awarded. These projects would be categorized as either “full recapture” or “partial recapture” of the award.
Organization: State of Iowa
Last updated: 2023-01-20T00:06:18.790169
Tags: direct-assistance, economic-development, full-recapture, partial-recapture, projects, sucessful, tax-credits

Tables

Table 1

@usgov.state_of_iowa_economic_development_projects_closed.table_1

49.77 kB
238 rows
29 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,
  "contracted_qualifying_wage" DOUBLE,
  "verified_total_project_cost" DOUBLE,
  "project_completion_date" TIMESTAMP,
  "final_jobs_created" BIGINT  -- Final Jobs - Created,
  "final_jobs_retained" BIGINT  -- Final Jobs - Retained,
  "final_jobs_other_created" BIGINT  -- Final Jobs - Other Created,
  "final_jobs_total" BIGINT  -- Final Jobs - Total,
  "project_maintenance_date" TIMESTAMP,
  "city_coordinates" VARCHAR
);