Name: 2016 - 2017 SQS PK
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

2016 - 2017 SQS PK

Metric values contained in Pre-kindergarten School Quality Reports
Organization: City of New York
Last updated: 2020-11-10T17:04:24.127062
Tags: dashboard, office-of-school-performance, pre-k, school-quality-report

Tables

Table 1

@usgov.city_of_new_york_2016_2017_sqs_pk.table_1

178.52 kB
1,983 rows
45 columns

CREATE TABLE table_1 (
  "site_id" VARCHAR,
  "program_code" VARCHAR,
  "program_name" VARCHAR,
  "program_type" VARCHAR,
  "enrollment" DOUBLE,
  "daily_start_time" VARCHAR,
  "length_of_pre_k_day" VARCHAR,
  "early_drop_off_available" VARCHAR,
  "late_pick_up_available" VARCHAR,
  "meals" VARCHAR,
  "playspace" VARCHAR,
  "dual_language" VARCHAR,
  "collaborative_teachers_survey_percent_positive" DOUBLE  -- Collaborative Teachers - Survey Percent Positive,
  "supportive_environment_survey_percent_positive" DOUBLE  -- Supportive Environment - Survey Percent Positive,
  "effective_school_leadership_survey_percent_positive" DOUBLE  -- Effective School Leadership - Survey Percent Positive,
  "strong_family_community_ties_survey_percent_positive" DOUBLE  -- Strong Family-Community Ties - Survey Percent Positive,
  "trust_survey_percent_positive" DOUBLE  -- Trust - Survey Percent Positive,
  "survey_number_of_guardian_responses" DOUBLE  -- Survey - Number Of Guardian Responses,
  "survey_guardian_response_rate" DOUBLE  -- Survey - Guardian Response Rate,
  "class_most_recent_assessment_year" VARCHAR,
  "class_emotional_support_score" DOUBLE,
  "class_emotional_support_rating" DOUBLE,
  "class_classroom_organization_score" DOUBLE,
  "class_classroom_organization_rating" DOUBLE,
  "class_instructional_support_score" DOUBLE,
  "class_instructional_support_rating" DOUBLE,
  "ecers_most_recent_assessment_year" VARCHAR,
  "ecers_observation_average_score" DOUBLE,
  "ecers_observation_average_rating" DOUBLE,
  "ecers_language_reasoning_score" DOUBLE,
  "ecers_language_reasoning_rating" DOUBLE,
  "ecers_interaction_score" DOUBLE,
  "ecers_interaction_rating" DOUBLE,
  "ecers_activities_score" DOUBLE,
  "ecers_activities_rating" DOUBLE,
  "ecers_personal_care_routines_score" DOUBLE,
  "ecers_personal_care_routines_rating" DOUBLE,
  "ecers_space_and_furnishings_score" DOUBLE,
  "ecers_space_and_furnishings_rating" DOUBLE,
  "ecers_program_structure_score" DOUBLE,
  "ecers_program_structure_rating" DOUBLE,
  "quality_review_date_of_review" VARCHAR  -- Quality Review - Date Of Review,
  "quality_review_how_well_do_teachers_work_with_each_other" DOUBLE  -- Quality Review - How Well Do Teachers Work With Each Other?,
  "address_1" VARCHAR,
  "address_2" VARCHAR
);