Database Of Economic Incentives

CREATE TABLE table_1 (
  "ein_of_the_recipient" VARCHAR,
  "lead_agency_name" VARCHAR,
  "lead_agency_code" BIGINT,
  "quarter_number_of_the_submission" VARCHAR,
  "project_id_number" VARCHAR,
  "program_through_which_the_funding_was_awarded" VARCHAR,
  "recipient_name" VARCHAR,
  "name_of_project" VARCHAR,
  "is_the_award_to_a_public_or_private_sector_entity" VARCHAR  -- Is The Award To A Public Or Private Sector Entity?,
  "project_description" VARCHAR,
  "industry" VARCHAR,
  "if_the_project_is_a_member_item_the_originating_district" VARCHAR  -- If The Project Is A Member Item, The Originating District,
  "street_address" VARCHAR,
  "county" VARCHAR,
  "postal_code" VARCHAR,
  "economic_development_region" VARCHAR,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "assistance_type" VARCHAR,
  "assistance_amount" DOUBLE,
  "total_lead_agency_benefits_awarded" DOUBLE,
  "disbursements_to_date" DOUBLE,
  "does_this_project_include_additional_nys_benefits" VARCHAR  -- Does This Project Include Additional NYS Benefits?,
  "if_yes_what_is_the_additional_awarding_agency_name" VARCHAR  -- If "YES" What Is The Additional Awarding Agency Name?,
  "other_state_agency_funding_program" VARCHAR,
  "other_state_agency_funding_awarded" DOUBLE,
  "is_the_project_also_receiving_benefits_from_a_local_in_47c4138e" VARCHAR  -- Is The Project Also Receiving Benefits From A Local Industrial Development Agency (IDA)?,
  "if_applicable_from_which_ida_is_the_project_also_recei_1e9ab1be" VARCHAR  -- If Applicable, From Which IDA Is The Project Also Receiving Benefits?,
  "if_applicable_what_is_the_net_value_of_the_tax_benefit_1c2d37f0" DOUBLE  -- If Applicable, What Is The Net Value Of The Tax Benefits Awarded By The IDA?,
  "total_nys_investment" DOUBLE,
  "total_public_private_investment" DOUBLE,
  "project_status" VARCHAR,
  "compliant_with_terms_and_conditions" VARCHAR,
  "reason_for_non_compliant_status" VARCHAR,
  "penalties_applied" VARCHAR  -- Penalties Applied?,
  "rationale_for_termination" VARCHAR,
  "is_this_a_job_creation_retention_project" VARCHAR  -- Is This A Job Creation / Retention Project?,
  "total_employees_at_the_site_ftes" DOUBLE  -- Total Employees At The Site (FTEs),
  "total_employees_at_the_site_pts" DOUBLE  -- Total Employees At The Site (PTs),
  "total_employees_at_the_site_project_hires_in_ftes" VARCHAR  -- Total Employees At The Site (project Hires In FTEs),
  "total_employees_at_the_site_project_hires_in_pt_workers_only" VARCHAR  -- Total Employees At The Site (project Hires In PT Workers Only),
  "job_creation_commitments_ftes" DOUBLE  -- Job Creation Commitments (FTEs),
  "job_creation_commitments_pts" DOUBLE  -- Job Creation Commitments (PTs),
  "job_retention_commitments_ftes" DOUBLE  -- Job Retention Commitments (FTEs),
  "job_retention_commitments_pts" DOUBLE  -- Job Retention Commitments (PTs),
  "jobs_created_to_date_ftes" DOUBLE  -- Jobs Created To-Date (FTEs),
  "jobs_created_to_date_pts" DOUBLE  -- Jobs Created To-Date (PTs),
  "jobs_retained_to_date_ftes" DOUBLE  -- Jobs Retained To-Date (FTEs),
  "jobs_retained_to_date_pts" DOUBLE  -- Jobs Retained To-Date (PTs),
  "project_hires_ftes" DOUBLE  -- Project Hires (FTEs),
  "project_hires_pts" DOUBLE  -- Project Hires (PTs),
  "nys_mwbe_utilization_goal_applied" DOUBLE,
  "current_mwbe_utilization_rate" DOUBLE,
  "is_this_a_legacy_project" VARCHAR,
  "original_assistance_amount" DOUBLE,
  "original_jobs_created_fte" DOUBLE  -- Original Jobs Created (FTE),
  "original_jobs_retained_fte" DOUBLE  -- Original Jobs Retained (FTE),
  "original_total_public_private_investment" DOUBLE,
  "original_recipient" VARCHAR,
  "contact" VARCHAR
);