About this Dataset

2008 Public Data File Gen Ed

To understand the perceptions of families, students, and teachers regarding their school. School leaders use feedback from the survey to reflect and make improvements to schools and programs. Also, results from the survey used to help measure school quality.
Each year, all parents, teachers, and students in grades 6-12 take the NYC School Survey. The survey is aligned to the DOE's Framework for Great Schools. It is designed to collect important information about each school's ability to support student success.
Organization: City of New York
Last updated: 2020-11-10T17:06:09.706653
Tags: nyc-school-survey, school-survey
Tables

Table 1

@usgov.city_of_new_york_2008_public_data_file_gen_ed.table_1
397.24 kB
1,459 rows
135 columns
CREATE TABLE table_1 (
  "dbn" VARCHAR,
  "students_received_surveys" BIGINT,
  "school_name" VARCHAR,
  "principal" VARCHAR,
  "enrollment" BIGINT,
  "school_type" BIGINT,
  "hor_type" BIGINT,
  "total_parents" BIGINT,
  "total_teachers" DOUBLE,
  "total_students" VARCHAR,
  "parent_respondents" DOUBLE,
  "teacher_respondents" DOUBLE,
  "student_respondents" VARCHAR,
  "parent_response_rate" DOUBLE,
  "teacher_response_rate" DOUBLE,
  "student_response_rate" VARCHAR,
  "student_safety_and_respect_score" VARCHAR,
  "teacher_safety_and_respect_score" DOUBLE,
  "parent_safety_and_respect_score" DOUBLE,
  "student_communication_score" VARCHAR,
  "teacher_communication_score" DOUBLE,
  "parent_communication_score" DOUBLE,
  "student_engagement_score" VARCHAR,
  "teacher_engagement_score" DOUBLE,
  "parent_engagement_score" DOUBLE,
  "student_academic_expectations_score" VARCHAR,
  "teacher_academic_expectations_score" DOUBLE,
  "parent_academic_expectations_score" DOUBLE,
  "safety_and_respect_score" DOUBLE,
  "communication_score" DOUBLE,
  "engagement_score" DOUBLE,
  "academic_expectations_score" DOUBLE,
  "student_horizon_safety_and_respect_score" VARCHAR,
  "student_horizon_communication_score" VARCHAR,
  "student_horizon_engagement_score" VARCHAR,
  "student_horizon_academic_expectations_score" VARCHAR,
  "teacher_horizon_safety_and_respect_score" DOUBLE,
  "teacher_horizon_communication_score" DOUBLE,
  "teacher_horizon_engagement_score" DOUBLE,
  "teacher_horizon_academic_expectations_score" DOUBLE,
  "parent_horizon_safety_and_respect_score" DOUBLE,
  "parent_horizon_communication_score" DOUBLE,
  "parent_horizon_engagement_score" DOUBLE,
  "parent_horizon_academic_expectations_score" DOUBLE,
  "horizion_safety_and_respect_score" DOUBLE,
  "horizion_communication_score" DOUBLE,
  "horizion_engagement_score" DOUBLE,
  "horizion_academic_expectations_score" DOUBLE,
  "change_in_student_safety_and_respect_score_2007_2008" VARCHAR  -- Change In Student Safety And Respect Score, 2007-2008,
  "change_in_student_communication_score_2007_2008" VARCHAR  -- Change In Student Communication Score, 2007-2008,
  "change_in_student_engagement_score_2007_2008" VARCHAR  -- Change In Student Engagement Score, 2007-2008,
  "change_in_student_academic_expectations_score_2007_2008" VARCHAR  -- Change In Student Academic Expectations Score, 2007-2008,
  "change_in_teacher_safety_and_respect_score_2007_2008" VARCHAR  -- Change In Teacher Safety And Respect Score, 2007-2008,
  "change_in_teacher_communication_score_2007_2008" VARCHAR  -- Change In Teacher Communication Score, 2007-2008,
  "change_in_teacher_engagement_score_2007_2008" VARCHAR  -- Change In Teacher Engagement Score, 2007-2008,
  "change_in_teacher_academic_expectations_score_2007_2008" VARCHAR  -- Change In Teacher Academic Expectations Score, 2007-2008,
  "change_in_parent_safety_and_respect_score_2007_2008" VARCHAR  -- Change In Parent Safety And Respect Score, 2007-2008,
  "change_in_parent_communication_score_2007_2008" VARCHAR  -- Change In Parent Communication Score, 2007-2008,
  "change_in_parent_engagement_score_2007_2008" VARCHAR  -- Change In Parent Engagement Score, 2007-2008,
  "change_in_parent_academic_expectations_score_2007_2008" VARCHAR  -- Change In Parent Academic Expectations Score, 2007-2008,
  "change_in_safety_and_respect_score_2007_2008" VARCHAR  -- Change In Safety And Respect Score, 2007-2008,
  "change_in_communication_score_2007_2008" VARCHAR  -- Change In Communication Score, 2007-2008,
  "change_in_engagement_score_2007_2008" VARCHAR  -- Change In Engagement Score, 2007-2008,
  "change_in_academic_expectations_score_2007_2008" VARCHAR  -- Change In Academic Expectations Score, 2007-2008,
  "q2_how_much_do_you_agree_disagree_a_i_feel_welcome_in__c944b6a5" DOUBLE  -- Q2.How Much Do You Agree/disagree? A.I Feel Welcome In My ChildÆs School,
  "q2_how_much_do_you_agree_disagree_b_i_am_satisfied_wit_7bafbaf8" DOUBLE  -- Q2.How Much Do You Agree/disagree? B.I Am Satisfied With The Response I Get When,
  "q2_how_much_do_you_agree_disagree_c_my_childs_makes_it_49da145d" DOUBLE  -- Q2.How Much Do You Agree/disagree? C.My Childs Makes It Easy F/ Parents To Atten,
  "q2_how_much_do_you_agree_disagree_d_the_keeps_me_inf_m_4b491f0b" DOUBLE  -- Q2.How Much Do You Agree/disagree? D.The Keeps Me Inf/med About My ChildÆs Acade,
  "q2_how_much_do_you_agree_disagree_e_the_contacts_me_wh_22ff41bd" DOUBLE  -- Q2.How Much Do You Agree/disagree? E.The Contacts Me When My Child Breaks Rules.,
  "q2_how_much_do_you_agree_disagree_f_the_contacts_me_to_74ed901e" DOUBLE  -- Q2.How Much Do You Agree/disagree? F.The Contacts Me To Tell Me About My ChildÆs,
  "q2_how_much_do_you_agree_disagree_g_there_is_an_adult__f130f203" DOUBLE  -- Q2.How Much Do You Agree/disagree? G.There Is An Adult At The Whom My Child Trus,
  "q3_how_often_a_received_inf_mation_about_what_your_chi_c7030c52" DOUBLE  -- Q3.How Often? A.received Inf/mation About What Your Child Is Studying In School?,
  "q3_how_often_b_received_inf_mation_on_services_f_your__7c6fb445" DOUBLE  -- Q3.How Often? B.received Inf/mation On Services F/ Your Child/f/ You, Such As: T,
  "q3_how_often_c_been_invited_to_a_w_kshop_program_perf__3597eee9" DOUBLE  -- Q3.How Often? C.been Invited To A W/kshop, Program, Perf/mance,/other Event At Y,
  "q5_how_much_do_you_agree_disagree_a_the_has_high_expec_7ef4de97" DOUBLE  -- Q5.How Much Do You Agree/disagree? A.The Has High Expectations F/ My Child.,
  "q5_how_much_do_you_agree_disagree_b_the_clearly_commun_bdf62b9a" DOUBLE  -- Q5.How Much Do You Agree/disagree? B.The Clearly Communicates Its Expectations F,
  "q5_how_much_do_you_agree_disagree_c_my_child_s_teacher_86e233fb" DOUBLE  -- Q5.How Much Do You Agree/disagree? C.My ChildÆs Teacher(s) Give Helpful Comments,
  "q5_how_much_do_you_agree_disagree_d_my_child_is_learni_20f544e3" DOUBLE  -- Q5.How Much Do You Agree/disagree? D.My Child Is Learning What He/she Needs To K,
  "q5_how_much_do_you_agree_disagree_e_answer_this_questi_86e0f6f4" VARCHAR  -- Q5.How Much Do You Agree/disagree? E.Answer This Question Only If You Are A High,
  "q6_my_child_participates_in_the_following_courses_duri_87c52e60" DOUBLE  -- Q6.My Child Participates In The Following Courses During The Regular Day,
  "q7_my_child_participates_in_the_following_before_or_af_9f07a4cb" DOUBLE  -- Q7.My Child Participates In The Following Before Or After School,
  "q8_how_much_do_you_agree_disagree_my_child_s_offers_a__24f1b34a" DOUBLE  -- Q8.How Much Do You Agree/disagree? My ChildÆs Offers A Wide Enough Variety Of Co,
  "q9_how_much_do_you_agree_disagree_a_my_child_is_safe_at_school" DOUBLE  -- Q9.How Much Do You Agree/disagree? A.My Child Is Safe At School.,
  "q9_how_much_do_you_agree_disagree_b_my_child_s_is_clean" DOUBLE  -- Q9.How Much Do You Agree/disagree? B.My ChildÆs Is Clean.,
  "q9_how_much_do_you_agree_disagree_c_discipline_is_enf__77fe4070" DOUBLE  -- Q9.How Much Do You Agree/disagree? C.Discipline Is Enf/ced Fairly At My ChildÆs,
  "q10_how_much_do_you_agree_disagree_answer_this_questio_74282fa2" DOUBLE  -- Q10.How Much Do You Agree/disagree? Answer This Question Only If Your ChildÆs Ha,
  "q11_how_often_do_you_think_a_students_threaten_bully_o_4e4f6362" DOUBLE  -- Q11.How Often Do You Think? A.Students Threaten/bully Other Students.,
  "q11_how_often_do_you_think_b_school_staff_are_disrespe_859b14d9" DOUBLE  -- Q11.How Often Do You Think? B.School Staff Are Disrespectful To Students.,
  "q11_how_often_do_you_think_c_there_is_racial_cultural__760e2c09" DOUBLE  -- Q11.How Often Do You Think? C.There Is Racial/cultural Bias By Staff.,
  "q11_how_often_do_you_think_d_there_is_conflict_at_my_c_1a11b09a" DOUBLE  -- Q11.How Often Do You Think? D.There Is Conflict At My ChildÆs Based On Race, Cul,
  "q11_how_often_do_you_think_e_students_use_alcohol_ille_75eab087" DOUBLE  -- Q11.How Often Do You Think? E.Students Use Alcohol/illegal Drugs During School.,
  "q11_how_often_do_you_think_f_there_is_gang_activity_in_0b0e7c3c" DOUBLE  -- Q11.How Often Do You Think? F.There Is Gang Activity In My ChildÆs School.,
  "q13_how_satisfied_are_you_with_a_the_quality_of_your_c_f88d74a9" DOUBLE  -- Q13.How Satisfied Are You With? A.The Quality Of Your ChildÆs Teacher(s) This Ye,
  "q13_how_satisfied_are_you_with_b_the_level_of_assistan_2c5f563d" DOUBLE  -- Q13.How Satisfied Are You With? B.The Level Of Assistance Your Child Receives Wh,
  "q13_how_satisfied_are_you_with_c_how_well_your_child_s_d2ea11a0" DOUBLE  -- Q13.How Satisfied Are You With? C.How Well Your ChildÆs Communicates With You.,
  "q13_how_satisfied_are_you_with_d_your_opp_tunities_to__c24090f9" DOUBLE  -- Q13.How Satisfied Are You With? D.Your Opp/tunities To Be Involved In Your Child,
  "q13_how_satisfied_are_you_with_e_the_education_your_ch_d337aa1e" DOUBLE  -- Q13.How Satisfied Are You With? E.The Education Your Child Has Received This Yea,
  "q1_number_pre_kindergarten" DOUBLE  -- Q1: Number Pre-Kindergarten,
  "q1_number_kindergarten" DOUBLE  -- Q1: Number Kindergarten,
  "q1_number_1st_grade" DOUBLE  -- Q1: Number 1st Grade
);