Washington School Improvement Framework (WSIF) 2019 Run
State of Washington
@usgov.state_of_washington_washington_school_improvement_fram_2ccc3df8
State of Washington
@usgov.state_of_washington_washington_school_improvement_fram_2ccc3df8
CREATE TABLE table_1 (
"esd_organization_id" DOUBLE,
"esd_name" VARCHAR,
"district_organization_id" BIGINT,
"district_code" BIGINT,
"district_name" VARCHAR,
"school_code" BIGINT,
"school_name" VARCHAR,
"school_organization_id" BIGINT,
"school_type" VARCHAR,
"student_group" VARCHAR,
"proficiency_ela_numerator" DOUBLE,
"proficiency_ela_denominator" DOUBLE,
"proficiency_ela_rate" VARCHAR,
"proficiency_ela_decile" DOUBLE,
"proficiency_math_numerator" DOUBLE,
"proficiency_math_denominator" DOUBLE,
"proficiency_math_rate" VARCHAR,
"proficiency_math_decile" DOUBLE,
"proficiency_combined_decile" DOUBLE,
"growth_ela_numberofstudents" DOUBLE,
"growth_ela_median_sgp" VARCHAR,
"growth_ela_decile" DOUBLE,
"growth_math_numberofstudents" DOUBLE,
"growth_math_median_sgp" VARCHAR,
"growth_math_decile" DOUBLE,
"growth_combined_decile" DOUBLE,
"grad_fouryear_numerator" DOUBLE,
"grad_fouryear_denominator" DOUBLE,
"grad_fouryear_rate" VARCHAR,
"grad_fouryear_decile" DOUBLE,
"grad_extended_totalincrease" DOUBLE,
"grad_extended_decileincrease" DOUBLE,
"grad_combined_decile" DOUBLE,
"el_progress_numerator" DOUBLE,
"el_progress_denominator" DOUBLE,
"el_progress_rate" VARCHAR,
"el_progress_decile" DOUBLE,
"regularattendance_numerator" DOUBLE,
"regularattendance_denominator" DOUBLE,
"regularattendance_rate" VARCHAR,
"regularattendance_decile" DOUBLE,
"ninthgradeontrack_numerator" DOUBLE,
"ninthgradeontrack_denominator" DOUBLE,
"ninthgradeontrack_rate" VARCHAR,
"ninthgradeontrack_decile" DOUBLE,
"dualcredit_numerator" DOUBLE,
"dualcredit_denominator" DOUBLE,
"dualcredit_rate" VARCHAR,
"dualcredit_decile" DOUBLE,
"sqss_combined_decile" DOUBLE,
"final_school_score" DOUBLE,
"support_tier" VARCHAR,
"ela_metessa_participation" BOOLEAN,
"math_metessa_participation" BOOLEAN,
"wsif_year" BIGINT,
"organizationid" BIGINT
);
Anyone who has the link will be able to view this.