Data Science For Good: PASSNYC
Help PASSNYC determine which schools need their services the most
@kaggle.passnyc_data_science_for_good
Help PASSNYC determine which schools need their services the most
@kaggle.passnyc_data_science_for_good
CREATE TABLE d5_shsat_registrations_and_testers (
"dbn" VARCHAR,
"school_name" VARCHAR,
"year_of_shst" BIGINT,
"grade_level" BIGINT,
"enrollment_on_10_31" BIGINT,
"number_of_students_who_registered_for_the_shsat" BIGINT,
"number_of_students_who_took_the_shsat" BIGINT
);
CREATE TABLE n_2016_school_explorer (
"adjusted_grade" VARCHAR,
"new" VARCHAR,
"other_location_code_in_lcgms" VARCHAR,
"school_name" VARCHAR,
"sed_code" BIGINT,
"location_code" VARCHAR,
"district" BIGINT,
"latitude" DOUBLE,
"longitude" DOUBLE,
"address_full" VARCHAR,
"city" VARCHAR,
"zip" BIGINT,
"grades" VARCHAR,
"grade_low" VARCHAR,
"grade_high" VARCHAR,
"community_school" VARCHAR,
"economic_need_index" DOUBLE,
"school_income_estimate" VARCHAR,
"percent_ell" VARCHAR,
"percent_asian" VARCHAR,
"percent_black" VARCHAR,
"percent_hispanic" VARCHAR,
"percent_black_hispanic" VARCHAR,
"percent_white" VARCHAR,
"student_attendance_rate" VARCHAR,
"percent_of_students_chronically_absent" VARCHAR,
"rigorous_instruction" VARCHAR,
"rigorous_instruction_rating" VARCHAR,
"collaborative_teachers" VARCHAR,
"collaborative_teachers_rating" VARCHAR,
"supportive_environment" VARCHAR,
"supportive_environment_rating" VARCHAR,
"effective_school_leadership" VARCHAR,
"effective_school_leadership_rating" VARCHAR,
"strong_family_community_ties" VARCHAR,
"strong_family_community_ties_rating" VARCHAR,
"trust" VARCHAR,
"trust_rating" VARCHAR,
"student_achievement_rating" VARCHAR,
"average_ela_proficiency" DOUBLE,
"average_math_proficiency" DOUBLE,
"grade_3_ela_all_students_tested" BIGINT,
"grade_3_ela_4s_all_students" BIGINT,
"grade_3_ela_4s_american_indian_or_alaska_native" BIGINT,
"grade_3_ela_4s_black_or_african_american" BIGINT,
"grade_3_ela_4s_hispanic_or_latino" BIGINT,
"grade_3_ela_4s_asian_or_pacific_islander" BIGINT,
"grade_3_ela_4s_white" BIGINT,
"grade_3_ela_4s_multiracial" BIGINT,
"grade_3_ela_4s_limited_english_proficient" BIGINT,
"grade_3_ela_4s_economically_disadvantaged" BIGINT,
"grade_3_math_all_students_tested" BIGINT,
"grade_3_math_4s_all_students" BIGINT,
"grade_3_math_4s_american_indian_or_alaska_native" BIGINT,
"grade_3_math_4s_black_or_african_american" BIGINT,
"grade_3_math_4s_hispanic_or_latino" BIGINT,
"grade_3_math_4s_asian_or_pacific_islander" BIGINT,
"grade_3_math_4s_white" BIGINT,
"grade_3_math_4s_multiracial" BIGINT,
"grade_3_math_4s_limited_english_proficient" BIGINT,
"grade_3_math_4s_economically_disadvantaged" BIGINT,
"grade_4_ela_all_students_tested" BIGINT,
"grade_4_ela_4s_all_students" BIGINT,
"grade_4_ela_4s_american_indian_or_alaska_native" BIGINT,
"grade_4_ela_4s_black_or_african_american" BIGINT,
"grade_4_ela_4s_hispanic_or_latino" BIGINT,
"grade_4_ela_4s_asian_or_pacific_islander" BIGINT,
"grade_4_ela_4s_white" BIGINT,
"grade_4_ela_4s_multiracial" BIGINT,
"grade_4_ela_4s_limited_english_proficient" BIGINT,
"grade_4_ela_4s_economically_disadvantaged" BIGINT,
"grade_4_math_all_students_tested" BIGINT,
"grade_4_math_4s_all_students" BIGINT,
"grade_4_math_4s_american_indian_or_alaska_native" BIGINT,
"grade_4_math_4s_black_or_african_american" BIGINT,
"grade_4_math_4s_hispanic_or_latino" BIGINT,
"grade_4_math_4s_asian_or_pacific_islander" BIGINT,
"grade_4_math_4s_white" BIGINT,
"grade_4_math_4s_multiracial" BIGINT,
"grade_4_math_4s_limited_english_proficient" BIGINT,
"grade_4_math_4s_economically_disadvantaged" BIGINT,
"grade_5_ela_all_students_tested" BIGINT,
"grade_5_ela_4s_all_students" BIGINT,
"grade_5_ela_4s_american_indian_or_alaska_native" BIGINT,
"grade_5_ela_4s_black_or_african_american" BIGINT,
"grade_5_ela_4s_hispanic_or_latino" BIGINT,
"grade_5_ela_4s_asian_or_pacific_islander" BIGINT,
"grade_5_ela_4s_white" BIGINT,
"grade_5_ela_4s_multiracial" BIGINT,
"grade_5_ela_4s_limited_english_proficient" BIGINT,
"grade_5_ela_4s_economically_disadvantaged" BIGINT,
"grade_5_math_all_students_tested" BIGINT,
"grade_5_math_4s_all_students" BIGINT,
"grade_5_math_4s_american_indian_or_alaska_native" BIGINT,
"grade_5_math_4s_black_or_african_american" BIGINT,
"grade_5_math_4s_hispanic_or_latino" BIGINT,
"grade_5_math_4s_asian_or_pacific_islander" BIGINT,
"grade_5_math_4s_white" BIGINT,
"grade_5_math_4s_multiracial" BIGINT,
"grade_5_math_4s_limited_english_proficient" BIGINT
);
Anyone who has the link will be able to view this.