2021 -2022 Guidance Counselor

CREATE TABLE table_1 (
  "dbn" VARCHAR,
  "school_name" VARCHAR,
  "location_type" VARCHAR,
  "total_guidance_counselors_gc_social_workers_sw_include_8d3da758" VARCHAR  -- Total Guidance Counselors (GC) & Social Workers (SW) (includes GCs, SWs, ATRs, School Response Clinicians, High Needs Counselors, High Need SWs, Single Shepherds, Bridging The Gap SWs),
  "total_gc" DOUBLE,
  "total_sw" DOUBLE,
  "full_time_gc" BIGINT,
  "full_time_sw" DOUBLE,
  "part_time_gc" DOUBLE,
  "part_time_sw" DOUBLE,
  "bilingual_gc" BIGINT,
  "bilingual_sw" BIGINT,
  "gc_serving_more_than_one_location" DOUBLE,
  "sw_serving_more_than_one_location" DOUBLE,
  "high_needs_gc" VARCHAR,
  "high_needs_sw" VARCHAR,
  "bridging_the_gap" VARCHAR,
  "school_response_clinician" VARCHAR,
  "single_shepherd" VARCHAR,
  "learning_to_work" VARCHAR,
  "school_psychologist_providing_mandated_counseling" VARCHAR,
  "cbo_partner_for_mental_health_support" VARCHAR,
  "n_2020_21_sy_enrollment" VARCHAR  -- 2020-21 SY Enrollment,
  "ratio_gc_sw" VARCHAR  -- Ratio GC & SW,
  "ratio_gc_only" VARCHAR,
  "ratio_sw_only" VARCHAR
);