2021 Public Data File - Parent

CREATE TABLE table_1 (
  "dbn" VARCHAR,
  "school_name" VARCHAR,
  "total_parent_response_rate" DOUBLE,
  "q1_school_staff_regularly_communicate_with_me_about_ho_cf496e31" VARCHAR  -- Q1. School Staff Regularly Communicate With Me About How I Can Help My Child Learn. Agree/Strongly Agree,
  "q1_school_staff_regularly_communicate_with_me_about_ho_c83ef3cf" VARCHAR  -- Q1. School Staff Regularly Communicate With Me About How I Can Help My Child Learn. Disagree/Strongly Disagree,
  "q2_teachers_work_closely_with_me_to_meet_my_child_s_ne_af810c16" VARCHAR  -- Q2. Teachers Work Closely With Me To Meet My Child's Needs. Agree/Strongly Agree,
  "q2_teachers_work_closely_with_me_to_meet_my_child_s_ne_adf72b75" VARCHAR  -- Q2. Teachers Work Closely With Me To Meet My Child's Needs. Disagree/Strongly Disagree,
  "q3_i_feel_well_informed_by_the_communications_i_receiv_a018cedf" VARCHAR  -- Q3. I Feel Well-informed By The Communications I Receive From My Child's School. Agree/Strongly Agree,
  "q3_i_feel_well_informed_by_the_communications_i_receiv_107ee3aa" VARCHAR  -- Q3. I Feel Well-informed By The Communications I Receive From My Child's School. Disagree/Strongly Disagree,
  "q4_i_feel_respected_by_my_child_s_teachers_agree_strongly_agree" VARCHAR  -- Q4. I Feel Respected By My Child's Teachers. Agree/Strongly Agree,
  "q4_i_feel_respected_by_my_child_s_teachers_disagree_st_c0dfeaf8" VARCHAR  -- Q4. I Feel Respected By My Child's Teachers. Disagree/Strongly Disagree,
  "q5_staff_at_this_school_work_hard_to_build_trusting_re_4b1b10b1" VARCHAR  -- Q5. Staff At This School Work Hard To Build Trusting Relationships With Parents/guardians Like Me. Agree/Strongly Agree,
  "q5_staff_at_this_school_work_hard_to_build_trusting_re_04b91248" VARCHAR  -- Q5. Staff At This School Work Hard To Build Trusting Relationships With Parents/guardians Like Me. Disagree/Strongly Disagree,
  "q6_my_child_s_school_communicates_with_me_in_a_languag_aebdb8ef" VARCHAR  -- Q6. My Child's School Communicates With Me In A Language That I Can Understand. Agree/Strongly Agree,
  "q6_my_child_s_school_communicates_with_me_in_a_languag_56f48049" VARCHAR  -- Q6. My Child's School Communicates With Me In A Language That I Can Understand. Disagree/Strongly Disagree,
  "q7_my_child_s_school_communicates_with_me_in_a_way_tha_33aee71e" VARCHAR  -- Q7. My Child's School Communicates With Me In A Way That I Can Understand. Agree/Strongly Agree,
  "q7_my_child_s_school_communicates_with_me_in_a_way_tha_a7f42292" VARCHAR  -- Q7. My Child's School Communicates With Me In A Way That I Can Understand. Disagree/Strongly Disagree,
  "q8_i_feel_respected_by_my_child_s_principal_school_lea_dbad0cd8" VARCHAR  -- Q8. I Feel Respected By My Child's Principal/school Leader. Agree/Strongly Agree,
  "q8_i_feel_respected_by_my_child_s_principal_school_lea_9a5a1173" VARCHAR  -- Q8. I Feel Respected By My Child's Principal/school Leader. Disagree/Strongly Disagree,
  "q9_my_child_s_race_ethnicity_culture_or_background_is__39bf23ed" VARCHAR  -- Q9. My Child’s Race, Ethnicity, Culture, Or Background Is Valued At This School. Agree/Strongly Agree,
  "q9_my_child_s_race_ethnicity_culture_or_background_is__521449b8" VARCHAR  -- Q9. My Child’s Race, Ethnicity, Culture, Or Background Is Valued At This School. Disagree/Strongly Disagree,
  "q10_my_child_feels_like_they_belong_at_this_school_agr_e0dbab90" VARCHAR  -- Q10. My Child Feels Like They Belong At This School. Agree/Strongly Agree,
  "q10_my_child_feels_like_they_belong_at_this_school_dis_cba15012" VARCHAR  -- Q10. My Child Feels Like They Belong At This School. Disagree/Strongly Disagree,
  "q11_i_trust_the_principal_school_leader_at_his_or_her__b7518393" VARCHAR  -- Q11. I Trust The Principal/school Leader At His Or Her Word (to Do What He Or She Says That He Or She Will Do). Agree/Strongly Agree,
  "q11_i_trust_the_principal_school_leader_at_his_or_her__78f4ad40" VARCHAR  -- Q11. I Trust The Principal/school Leader At His Or Her Word (to Do What He Or She Says That He Or She Will Do). Disagree/Strongly Disagree,
  "q12_the_principal_school_leader_is_an_effective_manage_ab2ae24e" VARCHAR  -- Q12. The Principal/school Leader Is An Effective Manager Who Makes The School Run Smoothly. Agree/Strongly Agree,
  "q12_the_principal_school_leader_is_an_effective_manage_f9812e65" VARCHAR  -- Q12. The Principal/school Leader Is An Effective Manager Who Makes The School Run Smoothly. Disagree/Strongly Disagree,
  "q13_my_child_s_teachers_think_of_me_as_a_partner_in_ed_2832b34a" VARCHAR  -- Q13. My Child’s Teachers Think Of Me As A Partner In Educating My Child. Agree/Strongly Agree,
  "q13_my_child_s_teachers_think_of_me_as_a_partner_in_ed_626e7c4c" VARCHAR  -- Q13. My Child’s Teachers Think Of Me As A Partner In Educating My Child Disagree/Strongly Disagree,
  "q14_the_principal_school_leader_at_this_school_works_h_9573b85b" VARCHAR  -- Q14. The Principal/school Leader At This School Works Hard To Build Trusting Relationships With Parents/guardians Like Me. Agree/Strongly Agree,
  "q14_the_principal_school_leader_at_this_school_works_h_2ac8e617" VARCHAR  -- Q14. The Principal/school Leader At This School Works Hard To Build Trusting Relationships With Parents/guardians Like Me. Disagree/Strongly Disagree,
  "q15_the_principal_school_leader_offers_regular_opportu_fe8a2530" VARCHAR  -- Q15. The Principal/school Leader Offers Regular Opportunities For Parents/guardians To Provide Feedback. Agree/Strongly Agree,
  "q15_the_principal_school_leader_offers_regular_opportu_12ce2902" VARCHAR  -- Q15. The Principal/school Leader Offers Regular Opportunities For Parents/guardians To Provide Feedback. Disagree/Strongly Disagree,
  "q16_my_child_s_school_will_make_me_aware_if_there_are__c1995934" VARCHAR  -- Q16. My Child's School Will Make Me Aware If There Are Any Concerns About My Child’s Social Or Emotional Well-being. Agree/Strongly Agree,
  "q16_my_child_s_school_will_make_me_aware_if_there_are__b70c5724" VARCHAR  -- Q16. My Child's School Will Make Me Aware If There Are Any Concerns About My Child’s Social Or Emotional Well-being. Disagree/Strongly Disagree,
  "q17_at_this_school_my_child_is_safe_agree_strongly_agree" VARCHAR  -- Q17. At This School My Child Is Safe. Agree/Strongly Agree,
  "q17_at_this_school_my_child_is_safe_disagree_strongly_disagree" VARCHAR  -- Q17. At This School My Child Is Safe. Disagree/Strongly Disagree,
  "q18_the_principal_school_leader_at_this_school_is_stro_f9079189" VARCHAR  -- Q18. The Principal/school Leader At This School…is Strongly Committed To Sharing Decision Making With Families. Agree/Strongly Agree,
  "q18_the_principal_school_leader_at_this_school_is_stro_2a3fb404" VARCHAR  -- Q18. The Principal/school Leader At This School…is Strongly Committed To Sharing Decision Making With Families. Disagree/Strongly Disagree,
  "q19_the_principal_school_leader_at_this_school_works_t_3c7c0fcf" VARCHAR  -- Q19. The Principal/school Leader At This School…works To Create A Sense Of Community In The School. Agree/Strongly Agree,
  "q19_the_principal_school_leader_at_this_school_works_t_3e446493" VARCHAR  -- Q19. The Principal/school Leader At This School…works To Create A Sense Of Community In The School. Disagree/Strongly Disagree,
  "q20_the_principal_school_leader_at_this_school_promote_347bc5c6" VARCHAR  -- Q20. The Principal/school Leader At This School…promotes Family And Community Involvement In The School. Agree/Strongly Agree,
  "q20_the_principal_school_leader_at_this_school_promote_9d449fa9" VARCHAR  -- Q20. The Principal/school Leader At This School…promotes Family And Community Involvement In The School. Disagree/Strongly Disagree,
  "q21_since_the_beginning_of_the_school_year_how_often_h_dc2674b5" VARCHAR  -- Q21. Since The Beginning Of The School Year, How Often Have You…communicated With Your Child's Teacher About Your Child's Performance? Never/Rarely,
  "q21_since_the_beginning_of_the_school_year_how_often_h_2a62acd8" VARCHAR  -- Q21. Since The Beginning Of The School Year, How Often Have You…communicated With Your Child's Teacher About Your Child's Performance? Often/Sometimes,
  "q22_since_the_beginning_of_the_school_year_how_often_h_a773435b" VARCHAR  -- Q22. Since The Beginning Of The School Year, How Often Have You…seen Your Child’s Projects, Artwork, Homework, Tests, Or Quizzes? Never/Rarely,
  "q22_since_the_beginning_of_the_school_year_how_often_h_b636eab9" VARCHAR  -- Q22. Since The Beginning Of The School Year, How Often Have You…seen Your Child’s Projects, Artwork, Homework, Tests, Or Quizzes? Often/Sometimes,
  "q23_i_am_satisfied_with_my_child_s_school_bus_transpor_0bff78e0" VARCHAR  -- Q23. I Am Satisfied With My Child’s School Bus Transportation Service This Year. Agree/Strongly Agree,
  "q23_i_am_satisfied_with_my_child_s_school_bus_transpor_d90870f2" VARCHAR  -- Q23. I Am Satisfied With My Child’s School Bus Transportation Service This Year. Disagree/Strongly Disagree,
  "q24_how_satisfied_are_you_with_the_following_the_respo_4e692ca3" VARCHAR  -- Q24. How Satisfied Are You With The Following? The Response I Get When I Contact This School. Dissatisfied/Very Dissatisfied,
  "q24_how_satisfied_are_you_with_the_following_the_respo_c7f16600" VARCHAR  -- Q24. How Satisfied Are You With The Following? The Response I Get When I Contact This School. Satisfied/Very Satisfied,
  "q25_how_satisfied_are_you_with_the_following_the_educa_7b66aca4" VARCHAR  -- Q25. How Satisfied Are You With The Following? The Education My Child Has Received This Year. Dissatisfied/Very Dissatisfied,
  "q25_how_satisfied_are_you_with_the_following_the_educa_dcdcda52" VARCHAR  -- Q25. How Satisfied Are You With The Following? The Education My Child Has Received This Year. Satisfied/Very Satisfied,
  "q26_how_satisfied_are_you_with_the_following_the_overa_84ba9dd4" VARCHAR  -- Q26. How Satisfied Are You With The Following? The Overall Quality Of My Child's Teachers This Year. Dissatisfied/Very Dissatisfied,
  "q26_how_satisfied_are_you_with_the_following_the_overa_5b1d5400" VARCHAR  -- Q26. How Satisfied Are You With The Following? The Overall Quality Of My Child's Teachers This Year. Satisfied/Very Satisfied,
  "q27_how_satisfied_are_you_with_the_following_the_perfo_7318f3f2" VARCHAR  -- Q27. How Satisfied Are You With The Following? The Performance Of The Citywide Panel For Education Policy With Regard To School Resources, Oversight, Curriculum, And Progress In Student Achievement. Dissatisfied/Very Dissatisfied,
  "q27_how_satisfied_are_you_with_the_following_the_perfo_688589c1" VARCHAR  -- Q27. How Satisfied Are You With The Following? The Performance Of The Citywide Panel For Education Policy With Regard To School Resources, Oversight, Curriculum, And Progress In Student Achievement. Satisfied/Very Satisfied,
  "q28_how_satisfied_are_you_with_the_following_the_perfo_bda2a552" VARCHAR  -- Q28. How Satisfied Are You With The Following? The Performance Of The Schools Chancellor With Regard To School Resources, Oversight, Curriculum, And Progress In Student Achievement. Dissatisfied/Very Dissatisfied,
  "q28_how_satisfied_are_you_with_the_following_the_perfo_768c8e1b" VARCHAR  -- Q28. How Satisfied Are You With The Following? The Performance Of The Schools Chancellor With Regard To School Resources, Oversight, Curriculum, And Progress In Student Achievement. Satisfied/Very Satisfied,
  "q29_during_the_school_year_have_you_attended_a_general_5b5fa785" VARCHAR  -- Q29. During The School Year, Have You...attended A General School Meeting Or School Event (virtually Or In-person)? Yes,
  "q29_during_the_school_year_have_you_attended_a_general_0aded14b" VARCHAR  -- Q29. During The School Year, Have You...attended A General School Meeting Or School Event (virtually Or In-person)? No,
  "q30_during_the_school_year_have_you_attended_a_regular_b64171ef" VARCHAR  -- Q30. During The School Year, Have You...attended A Regularly Scheduled Parent-teacher Conference (virtually Or In-person) With Your Child's Teacher? Yes,
  "q30_during_the_school_year_have_you_attended_a_regular_82bb6a30" VARCHAR  -- Q30. During The School Year, Have You...attended A Regularly Scheduled Parent-teacher Conference (virtually Or In-person) With Your Child's Teacher? No,
  "q31_which_of_the_following_improvements_would_you_most_dafa572f" VARCHAR  -- Q31. Which Of The Following Improvements Would You Most Like Your School To Make (Choose ONE)?,
  "q31_which_of_the_following_improvements_would_you_most_b7a19d97" VARCHAR  -- Q31. Which Of The Following Improvements Would You Most Like Your School To Make (Choose ONE)? 1,
  "q32_if_you_are_a_parent_guardian_of_a_child_in_grades__e6c9fe45" VARCHAR  -- Q32. If You Are A Parent/guardian Of A Child In Grades K-5, ANSWER This Question. Please Mark The Extent To Which You Disagree Or Agree With Each Of The Following Statements. This School Sets High Standards For Academic Success For All Students. Agree/S,
  "q32_if_you_are_a_parent_guardian_of_a_child_in_grades__3ad96635" VARCHAR  -- Q32. If You Are A Parent/guardian Of A Child In Grades K-5, ANSWER This Question. Please Mark The Extent To Which You Disagree Or Agree With Each Of The Following Statements. This School Sets High Standards For Academic Success For All Students. Disagre,
  "q33_if_you_are_a_parent_guardian_of_a_child_in_grades__795cccea" VARCHAR  -- Q33. If You Are A Parent/guardian Of A Child In Grades K-5, ANSWER This Question. Please Mark The Extent To Which You Disagree Or Agree With Each Of The Following Statements. Discipline Is Applied To Students Fairly At This School. Agree/Strongly Agree,
  "q33_if_you_are_a_parent_guardian_of_a_child_in_grades__70f2f96b" VARCHAR  -- Q33. If You Are A Parent/guardian Of A Child In Grades K-5, ANSWER This Question. Please Mark The Extent To Which You Disagree Or Agree With Each Of The Following Statements. Discipline Is Applied To Students Fairly At This School. Disagree/Strongly Dis,
  "q34_if_you_are_a_parent_guardian_of_a_child_in_grades__42853bf7" VARCHAR  -- Q34. If You Are A Parent/guardian Of A Child In Grades 9-12, ANSWER This Question. Please Mark The Extent To Which You Disagree Or Agree With Each Of The Following Statements. This School Helps Keep My Child On Track For College, Career, And Success In Li,
  "q34_if_you_are_a_parent_guardian_of_a_child_in_grades__552e89aa" VARCHAR  -- Q34. If You Are A Parent/guardian Of A Child In Grades 9-12, ANSWER This Question. Please Mark The Extent To Which You Disagree Or Agree With Each Of The Following Statements. This School Helps Keep My Child On Track For College, Career, And Success In 1,
  "q35_if_you_are_a_parent_guardian_of_a_child_in_grades__5c9c9e53" VARCHAR  -- Q35. If You Are A Parent/guardian Of A Child In Grades 9-12, ANSWER This Question. Please Mark The Extent To Which You Disagree Or Agree With Each Of The Following Statements. This School Provides Resources To Me And My Child To Prepare My Child For Colle,
  "q35_if_you_are_a_parent_guardian_of_a_child_in_grades__4e82d501" VARCHAR  -- Q35. If You Are A Parent/guardian Of A Child In Grades 9-12, ANSWER This Question. Please Mark The Extent To Which You Disagree Or Agree With Each Of The Following Statements. This School Provides Resources To Me And My Child To Prepare My Child For Col 1,
  "q36_if_you_are_a_parent_guardian_of_a_child_who_receiv_e1b734e0" VARCHAR  -- Q36. If You Are A Parent/guardian Of A Child Who Receives Special Education Services Through An Individualized Education Program (IEP), ANSWER This Question. Mark The Extent To Which You Disagree Or Agree With Each Of The Following Statements. I Am Sati,
  "q36_if_you_are_a_parent_guardian_of_a_child_who_receiv_05945af0" VARCHAR  -- Q36. If You Are A Parent/guardian Of A Child Who Receives Special Education Services Through An Individualized Education Program (IEP), ANSWER This Question. Mark The Extent To Which You Disagree Or Agree With Each Of The Following Statements. I Am Sa 1,
  "q37_if_you_are_a_parent_guardian_of_a_child_who_receiv_dda091c1" VARCHAR  -- Q37. If You Are A Parent/guardian Of A Child Who Receives Special Education Services Through An Individualized Education Program (IEP), ANSWER This Question. Mark The Extent To Which You Disagree Or Agree With Each Of The Following Statements. This School,
  "q37_if_you_are_a_parent_guardian_of_a_child_who_receiv_6ae70652" VARCHAR  -- Q37. If You Are A Parent/guardian Of A Child Who Receives Special Education Services Through An Individualized Education Program (IEP), ANSWER This Question. Mark The Extent To Which You Disagree Or Agree With Each Of The Following Statements. This Scho 1,
  "q38_if_you_are_a_parent_guardian_of_a_child_who_receiv_28410663" VARCHAR  -- Q38. If You Are A Parent/guardian Of A Child Who Receives Special Education Services Through An Individualized Education Program (IEP), ANSWER This Question. Mark The Extent To Which You Disagree Or Agree With Each Of The Following Statements. This School,
  "q38_if_you_are_a_parent_guardian_of_a_child_who_receiv_3d031ab9" VARCHAR  -- Q38. If You Are A Parent/guardian Of A Child Who Receives Special Education Services Through An Individualized Education Program (IEP), ANSWER This Question. Mark The Extent To Which You Disagree Or Agree With Each Of The Following Statements. This Scho 1,
  "q39_if_you_are_a_parent_guardian_of_a_4_year_old_in_pr_181e46b4" VARCHAR  -- Q39. If You Are A Parent/guardian Of A 4-year-old In Pre-K Or A 3-year-old In 3-K, ANSWER This Question. Mark The Extent To Which You Disagree Or Agree With Each Of The Following Statements. I Feel Good About The Way That My Child’s Teacher Helped My Chil,
  "q39_if_you_are_a_parent_guardian_of_a_4_year_old_in_pr_dd564421" VARCHAR  -- Q39. If You Are A Parent/guardian Of A 4-year-old In Pre-K Or A 3-year-old In 3-K, ANSWER This Question. Mark The Extent To Which You Disagree Or Agree With Each Of The Following Statements. I Feel Good About The Way That My Child’s Teacher Helped My Ch 1,
  "q40_if_you_are_a_parent_guardian_of_a_4_year_old_in_pr_c0fcf732" VARCHAR  -- Q40. If You Are A Parent/guardian Of A 4-year-old In Pre-K Or A 3-year-old In 3-K, ANSWER This Question. Mark The Extent To Which You Disagree Or Agree With Each Of The Following Statements. My Child’s Teacher Gives Me Helpful Ideas About How I Can Suppor,
  "q40_if_you_are_a_parent_guardian_of_a_4_year_old_in_pr_23d88f54" VARCHAR  -- Q40. If You Are A Parent/guardian Of A 4-year-old In Pre-K Or A 3-year-old In 3-K, ANSWER This Question. Mark The Extent To Which You Disagree Or Agree With Each Of The Following Statements. My Child’s Teacher Gives Me Helpful Ideas About How I Can Supp 1,
  "q41_if_you_are_a_parent_guardian_of_a_4_year_old_in_pr_1ca34dcf" VARCHAR  -- Q41. If You Are A Parent/guardian Of A 4-year-old In Pre-K Or A 3-year-old In 3-K, ANSWER This Question. Mark The Extent To Which You Disagree Or Agree With Each Of The Following Statements. My Child’s Teacher Lets Me Know That I Can Make A Difference In,
  "q41_if_you_are_a_parent_guardian_of_a_4_year_old_in_pr_3e95f709" VARCHAR  -- Q41. If You Are A Parent/guardian Of A 4-year-old In Pre-K Or A 3-year-old In 3-K, ANSWER This Question. Mark The Extent To Which You Disagree Or Agree With Each Of The Following Statements. My Child’s Teacher Lets Me Know That I Can Make A Difference I 1,
  "q42_if_you_are_a_parent_guardian_of_a_4_year_old_in_pr_53f1ef02" VARCHAR  -- Q42. If You Are A Parent/guardian Of A 4-year-old In Pre-K Or A 3-year-old In 3-K, ANSWER This Question. Mark The Extent To Which You Disagree Or Agree With Each Of The Following Statements. My Child’s Teacher Gives Me Opportunities To Share What I Know A,
  "q42_if_you_are_a_parent_guardian_of_a_4_year_old_in_pr_f7bbdc4d" VARCHAR  -- Q42. If You Are A Parent/guardian Of A 4-year-old In Pre-K Or A 3-year-old In 3-K, ANSWER This Question. Mark The Extent To Which You Disagree Or Agree With Each Of The Following Statements. My Child’s Teacher Gives Me Opportunities To Share What I Know 1,
  "q43_if_you_are_a_parent_guardian_of_a_4_year_old_in_pr_fc9753f1" VARCHAR  -- Q43. If You Are A Parent/guardian Of A 4-year-old In Pre-K Or A 3-year-old In 3-K, ANSWER This Question. Mark The Extent To Which You Disagree Or Agree With Each Of The Following Statements. Someone At My Child’s Pre-K Or 3-K Program Has Helped Me Conside,
  "q43_if_you_are_a_parent_guardian_of_a_4_year_old_in_pr_99be7e5e" VARCHAR  -- Q43. If You Are A Parent/guardian Of A 4-year-old In Pre-K Or A 3-year-old In 3-K, ANSWER This Question. Mark The Extent To Which You Disagree Or Agree With Each Of The Following Statements. Someone At My Child’s Pre-K Or 3-K Program Has Helped Me Consi 1
);