2021 Public Data File - Teacher
City of New York
@usgov.city_of_new_york_2021_public_data_file_teacher_442a1
City of New York
@usgov.city_of_new_york_2021_public_data_file_teacher_442a1
CREATE TABLE table_1 (
"dbn" VARCHAR,
"school_name" VARCHAR,
"total_teacher_response_rate" DOUBLE,
"q1_how_many_teachers_at_this_school_are_actively_tryin_3ae93b7d" DOUBLE,
"q1_how_many_teachers_at_this_school_are_actively_tryin_a2d7eebd" DOUBLE,
"q2_how_many_teachers_at_this_school_take_responsibilit_a6de3c67" DOUBLE,
"q2_how_many_teachers_at_this_school_take_responsibilit_df32388f" DOUBLE,
"q3_how_many_teachers_at_this_school_are_eager_to_try_n_11d63103" DOUBLE,
"q3_how_many_teachers_at_this_school_are_eager_to_try_n_329604c9" DOUBLE,
"q4_how_many_teachers_at_this_school_feel_responsible_t_7d42fb61" DOUBLE,
"q4_how_many_teachers_at_this_school_feel_responsible_t_94daeb2f" DOUBLE,
"q5_i_am_able_to_receive_support_around_how_to_incorpor_514f1202" DOUBLE,
"q5_i_am_able_to_receive_support_around_how_to_incorpor_76cbda19" DOUBLE,
"q6_i_am_able_to_use_my_students_prior_knowledge_to_mak_9b836375" DOUBLE,
"q6_i_am_able_to_use_my_students_prior_knowledge_to_mak_47123ac8" DOUBLE,
"q7_i_am_able_to_modify_instructional_activities_and_ma_55047dee" DOUBLE,
"q7_i_am_able_to_modify_instructional_activities_and_ma_c8e6924b" DOUBLE,
"q8_i_am_able_to_ensure_instruction_represents_multiple_583de648" DOUBLE,
"q8_i_am_able_to_ensure_instruction_represents_multiple_1a320188" DOUBLE,
"q9_i_am_able_to_affirm_racial_and_cultural_identities__5fcd62d5" DOUBLE,
"q9_i_am_able_to_affirm_racial_and_cultural_identities__b2ad3eff" DOUBLE,
"q10_i_am_able_to_empower_students_as_agents_of_social__0e36f4a8" DOUBLE,
"q10_i_am_able_to_empower_students_as_agents_of_social__336c37f9" DOUBLE,
"q11_i_am_able_to_design_appropriate_instruction_that_i_32613b5c" DOUBLE,
"q11_i_am_able_to_design_appropriate_instruction_that_i_b0142f9a" DOUBLE,
"q12_i_am_able_to_apply_my_knowledge_of_parents_various_6a631310" DOUBLE,
"q12_i_am_able_to_apply_my_knowledge_of_parents_various_b9edb66b" DOUBLE,
"q13_i_am_able_to_develop_appropriate_individualized_ed_a5872041" DOUBLE,
"q13_i_am_able_to_develop_appropriate_individualized_ed_5739bbda" DOUBLE,
"q14_i_am_able_to_monitor_progress_on_individualized_ed_0ad25cf8" DOUBLE,
"q14_i_am_able_to_monitor_progress_on_individualized_ed_a1647ab6" DOUBLE,
"q15_i_am_able_to_distinguish_linguistic_cultural_diffe_e7567861" DOUBLE,
"q15_i_am_able_to_distinguish_linguistic_cultural_diffe_6a0751a4" DOUBLE,
"q16_i_feel_respected_by_the_nyc_doe_central_administra_85e3b8f5" DOUBLE,
"q16_i_feel_respected_by_the_nyc_doe_central_administra_1f993de8" DOUBLE,
"q17_central_doe_employees_have_confidence_in_the_exper_72536154" DOUBLE,
"q17_central_doe_employees_have_confidence_in_the_exper_0f82d641" DOUBLE,
"q18_central_doe_employees_place_the_needs_of_children__81a0c967" DOUBLE,
"q18_central_doe_employees_place_the_needs_of_children__85263d8f" DOUBLE,
"q19_the_chancellor_is_an_effective_manager_who_makes_t_a29b6b4f" DOUBLE,
"q19_the_chancellor_is_an_effective_manager_who_makes_t_e5652698" DOUBLE,
"q20_i_trust_the_chancellor_at_her_word_agree_strongly_agree" DOUBLE,
"q20_i_trust_the_chancellor_at_her_word_strongly_disagr_20df0f0a" DOUBLE,
"q21_i_usually_look_forward_to_each_working_day_at_this_c5415957" DOUBLE,
"q21_i_usually_look_forward_to_each_working_day_at_this_380a0aee" DOUBLE,
"q22_i_would_recommend_this_school_to_parents_guardians_2a91f894" DOUBLE,
"q22_i_would_recommend_this_school_to_parents_guardians_60126683" DOUBLE,
"q23_teachers_in_this_school_trust_each_other_agree_str_e243fb73" DOUBLE,
"q23_teachers_in_this_school_trust_each_other_strongly__71b32142" DOUBLE,
"q24_it_s_ok_in_this_school_to_discuss_feelings_worries_ed8d42b3" DOUBLE,
"q24_it_s_ok_in_this_school_to_discuss_feelings_worries_a141e2d3" DOUBLE,
"q25_i_have_conversations_about_race_and_racism_at_my_s_a66724e3" DOUBLE,
"q25_i_have_conversations_about_race_and_racism_at_my_s_f9463432" DOUBLE,
"q26_teachers_respect_other_teachers_who_take_the_lead__51ce85a0" DOUBLE,
"q26_teachers_respect_other_teachers_who_take_the_lead__400e8c36" DOUBLE,
"q27_i_feel_respected_by_other_teachers_at_this_school__d66ccfc6" DOUBLE,
"q27_i_feel_respected_by_other_teachers_at_this_school__bcf7cccf" DOUBLE,
"q28_teachers_at_this_school_respect_their_colleagues_s_f1fde71d" DOUBLE,
"q28_teachers_at_this_school_respect_their_colleagues_s_f2ec9176" DOUBLE,
"q29_i_would_recommend_this_school_to_other_teachers_as_4380d39f" DOUBLE,
"q29_i_would_recommend_this_school_to_other_teachers_as_ead2711e" DOUBLE,
"q30_i_feel_respected_by_the_principal_school_leader_at_7342a0de" DOUBLE,
"q30_i_feel_respected_by_the_principal_school_leader_at_afce621d" DOUBLE,
"q31_the_principal_school_leader_at_this_school_is_an_e_5a72dddd" DOUBLE,
"q31_the_principal_school_leader_at_this_school_is_an_e_2e2d42f9" DOUBLE,
"q32_the_principal_school_leader_has_confidence_in_the__c52fbfaa" DOUBLE,
"q32_the_principal_school_leader_has_confidence_in_the__994d9965" DOUBLE,
"q33_i_trust_the_principal_school_leader_at_his_or_her__08a9c198" DOUBLE,
"q33_i_trust_the_principal_school_leader_at_his_or_her__ce4eb098" DOUBLE,
"q34_at_this_school_it_s_ok_to_discuss_feelings_worries_4a90ac3a" DOUBLE,
"q34_at_this_school_it_s_ok_to_discuss_feelings_worries_baba077c" DOUBLE,
"q35_the_principal_school_leader_takes_a_personal_inter_c6b85dfe" DOUBLE,
"q35_the_principal_school_leader_takes_a_personal_inter_245b7d65" DOUBLE,
"q36_the_principal_school_leader_looks_out_for_the_pers_5ac6e5f0" DOUBLE,
"q36_the_principal_school_leader_looks_out_for_the_pers_169c6aa2" DOUBLE,
"q37_the_principal_school_leader_places_the_needs_of_ch_7f18b400" DOUBLE,
"q37_the_principal_school_leader_places_the_needs_of_ch_2db5b68a" DOUBLE,
"q38_the_principal_and_assistant_principals_function_as_4a15603c" DOUBLE,
"q38_the_principal_and_assistant_principals_function_as_6e86e580" DOUBLE,
"q39_in_this_school_the_staff_believes_that_all_student_0eba8207" DOUBLE,
"q39_in_this_school_the_staff_believes_that_all_student_794030a8" DOUBLE,
"q40_i_feel_respected_by_assistant_principals_at_this_s_8de2581c" DOUBLE,
"q40_i_feel_respected_by_assistant_principals_at_this_s_4be31d20" DOUBLE,
"q41_at_this_school_students_with_disabilities_are_incl_9f3a4949" DOUBLE,
"q41_at_this_school_students_with_disabilities_are_incl_10080b2d" DOUBLE,
"q42_this_school_educates_students_with_disabilities_in_e9ed5434" DOUBLE,
"q42_this_school_educates_students_with_disabilities_in_6b348699" DOUBLE,
"q43_at_this_school_there_is_a_positive_school_culture__27ccde4e" DOUBLE,
"q43_at_this_school_there_is_a_positive_school_culture__b9593b16" DOUBLE,
"q44_this_school_has_well_defined_learning_expectations_9ef0d97b" DOUBLE,
"q44_this_school_has_well_defined_learning_expectations_a8b2f225" DOUBLE,
"q45_at_this_school_students_harass_bully_or_intimidate_06c7309d" DOUBLE,
"q45_at_this_school_students_harass_bully_or_intimidate_6efcd2bf" DOUBLE,
"q46_at_this_school_the_principal_school_leader_teacher_8a8d512e" DOUBLE,
"q46_at_this_school_the_principal_school_leader_teacher_f3f1135e" DOUBLE,
"q47_at_this_school_once_we_start_a_new_program_we_foll_2d934a9b" DOUBLE,
"q47_at_this_school_once_we_start_a_new_program_we_foll_5767b625" DOUBLE,
"q48_at_this_school_it_is_clear_how_all_of_the_programs_01cf7e34" DOUBLE,
"q48_at_this_school_it_is_clear_how_all_of_the_programs_bddd6e7b" DOUBLE,
"q49_at_this_school_teachers_design_instructional_progr_ddc0197b" DOUBLE
);
Anyone who has the link will be able to view this.