WDFW-Creel Analysis Interview

CREATE TABLE table_1 (
  "creel_event_id" VARCHAR,
  "event_date" TIMESTAMP,
  "water_body" VARCHAR,
  "project_name" VARCHAR,
  "fishery_name" VARCHAR,
  "interview_id" VARCHAR,
  "interview_number" DOUBLE,
  "angler_type" VARCHAR,
  "interview_location" VARCHAR,
  "fishing_location" VARCHAR,
  "location_id" VARCHAR,
  "crc_area" VARCHAR,
  "angler_count" BIGINT,
  "total_group_count" DOUBLE,
  "pole_count" DOUBLE,
  "trip_status" VARCHAR,
  "fishing_start_time" VARCHAR,
  "fishing_end_time" VARCHAR,
  "interview_time" VARCHAR,
  "target_species" VARCHAR,
  "trip_guided" VARCHAR,
  "boat_type" VARCHAR,
  "boat_used" VARCHAR,
  "fish_from_boat" VARCHAR,
  "vehicle_count" DOUBLE,
  "trailer_count" DOUBLE,
  "state_residence" VARCHAR,
  "zip_code" VARCHAR,
  "previously_interviewed" VARCHAR,
  "comment_txt" VARCHAR,
  "location_type" VARCHAR,
  "survey_type" VARCHAR,
  "location_season_name" VARCHAR,
  "section_num" DOUBLE,
  "surveyor_num" DOUBLE,
  "p_census_bank" DOUBLE,
  "p_census_boat" DOUBLE,
  "indirect_census_bank" DOUBLE,
  "direct_census_bank" DOUBLE,
  "created_datetime" TIMESTAMP,
  "modified_datetime" TIMESTAMP
);