L&I Intent Project Details

CREATE TABLE table_1 (
  "intent_id_number" BIGINT,
  "project_id" BIGINT,
  "awarding_agency_name" VARCHAR,
  "awarding_agency_address" VARCHAR,
  "agency_contact" VARCHAR,
  "agency_phone" VARCHAR,
  "prime_contractor_name" VARCHAR,
  "prime_contractor_phone" VARCHAR,
  "prime_contractor_s_license" VARCHAR,
  "prime_contractor_s_ubi" VARCHAR,
  "project_bid_due_date" TIMESTAMP,
  "project_contract_award_date" VARCHAR,
  "contract_name" VARCHAR,
  "contract_number" VARCHAR,
  "project_location" VARCHAR,
  "estimated_contract_amount" DOUBLE,
  "intent_received_date" TIMESTAMP,
  "city" VARCHAR,
  "any_sub_contractor" VARCHAR  -- Any Sub Contractor?,
  "any_apprentices" VARCHAR  -- Any Apprentices?,
  "contract_amount" DOUBLE,
  "time_and_materials_used" VARCHAR  -- Time And Materials Used?,
  "was_all_work_subcontracted_out" VARCHAR  -- Was All Work Subcontracted Out?,
  "did_owner_operators_perform_work" VARCHAR  -- Did Owner/Operators Perform Work?,
  "number_of_owner_operators_who_performed_work" BIGINT,
  "yourcompanyemployeesworked" VARCHAR  -- YourCompanyEmployeesWorked?,
  "omwbe_certification" BOOLEAN,
  "license" VARCHAR,
  "ubi" VARCHAR,
  "company_name" VARCHAR,
  "phone" VARCHAR,
  "email" VARCHAR,
  "company_address1" VARCHAR,
  "company_address2" VARCHAR,
  "company_city" VARCHAR,
  "company_state" VARCHAR,
  "company_zip" VARCHAR,
  "insurance_account" VARCHAR,
  "hiring_comapany_license" VARCHAR,
  "hiring_comapany_ubi" VARCHAR,
  "hiring_company_name" VARCHAR,
  "hiring_company_insurance" DOUBLE,
  "expected_work_start_date" VARCHAR,
  "prime_intent" DOUBLE
);