2011 - 2012 YABC Progress Report

CREATE TABLE table_1 (
  "dbn" VARCHAR,
  "school_name" VARCHAR,
  "average_score_regents_integrated_algebra" BIGINT,
  "n__passing" DOUBLE  -- % Passing,
  "n__at_college_ready_threshold" DOUBLE  -- % At College Ready Threshold,
  "average_score_regents_english" BIGINT,
  "n__passing_1" DOUBLE  -- % Passing 1,
  "n__at_college_ready_threshold_1" DOUBLE  -- % At College Ready Threshold 1,
  "average_score_regents_us_history" BIGINT,
  "n__passing_2" DOUBLE  -- % Passing 2,
  "average_score_regents_global_history" BIGINT,
  "n__passing_3" DOUBLE  -- % Passing 3,
  "average_score_regents_earth_science" VARCHAR,
  "n__passing_4" VARCHAR  -- % Passing 4,
  "average_score_regents_living_environment" BIGINT,
  "n__passing_5" DOUBLE  -- % Passing 5,
  "average_score_regents_languages_other_than_english" VARCHAR,
  "n__passing_6" VARCHAR  -- % Passing 6,
  "average_score_sat_math" VARCHAR,
  "average_score_sat_critical_reading" VARCHAR,
  "average_score_sat_writing" VARCHAR,
  "post_secondary_enrollment_rate_6_months" DOUBLE  -- Post-secondary Enrollment Rate (6 Months),
  "n_2_year_or_4_year_college_6_months" DOUBLE  -- 2 Year Or 4 Year College (6 Months),
  "cuny_6_months" DOUBLE  -- CUNY (6 Months),
  "nys_public_6_months" DOUBLE  -- NYS Public (6 Months),
  "nys_private_6_months" DOUBLE  -- NYS Private (6 Months),
  "out_of_state_6_months" DOUBLE  -- Out Of State (6 Months),
  "public_service_6_months" BIGINT  -- Public Service (6 Months),
  "vocational_program_6_months" DOUBLE  -- Vocational Program (6 Months),
  "cri_of_6_year_cohort" DOUBLE  -- CRI (% Of 6 Year Cohort),
  "n__attaining_regents_diplma_6_year" DOUBLE  -- % Attaining Regents Diplma (6 Year),
  "n__attaining_math_college_readiness_standard" DOUBLE  -- % Attaining Math College Readiness Standard,
  "n__attaining_english_college_readiness_standard" DOUBLE  -- % Attaining English College Readiness Standard
);