Name: 2018 -2019 SQG EC
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

2018 -2019 SQG EC

2018-19 School Quality Guide Data for Early Childhood School
Organization: City of New York
Last updated: 2020-11-10T17:05:07.806156

Tables

Table 1

@usgov.city_of_new_york_2018_2019_sqg_ec.table_1

68.22 kB
48 rows
84 columns

CREATE TABLE table_1 (
  "dbn" VARCHAR,
  "school_name" VARCHAR,
  "school_type" VARCHAR,
  "enrollment" BIGINT,
  "rating_ri_disp" VARCHAR,
  "rating_ct_disp" VARCHAR,
  "rating_se_disp" VARCHAR,
  "rating_es_disp" VARCHAR,
  "rating_sf_disp" VARCHAR,
  "rating_tr_disp" VARCHAR,
  "survey_pp_ri" VARCHAR,
  "survey_pp_ct" VARCHAR,
  "survey_pp_se" VARCHAR,
  "survey_pp_es" VARCHAR,
  "survey_pp_sf" VARCHAR,
  "suvey_pp_tr" VARCHAR,
  "qr_1_1" VARCHAR,
  "qr_1_2" VARCHAR,
  "qr_2_2" VARCHAR,
  "qr_3_4" VARCHAR,
  "qr_4_2" VARCHAR,
  "qr_1_4" VARCHAR,
  "qr_1_3" VARCHAR,
  "qr_3_1" VARCHAR,
  "qr_4_1" VARCHAR,
  "qr_5_1" VARCHAR,
  "dates_of_review" VARCHAR,
  "ell" DOUBLE,
  "iep" DOUBLE,
  "cap_sc_pct" DOUBLE,
  "eni_pct" DOUBLE,
  "temp_housing_pct" DOUBLE,
  "hra_elig_pct" DOUBLE,
  "asian" DOUBLE,
  "black" DOUBLE,
  "hispanic" DOUBLE,
  "white" DOUBLE,
  "principal_experience" VARCHAR,
  "teach_3_more_exp" VARCHAR,
  "stud_attendance" VARCHAR,
  "teacher_attendance" VARCHAR,
  "n_prof_pct_ela_all" VARCHAR,
  "val_prof_pct_ela_all" VARCHAR,
  "pavg_prof_pct_ela_all" VARCHAR,
  "n_prof_pct_mth_all" VARCHAR,
  "val_prof_pct_mth_all" VARCHAR,
  "pavg_prof_pct_mth_all" VARCHAR,
  "val_chronic_absent_all" VARCHAR,
  "element_score_ri" VARCHAR,
  "ri_pp_city" DOUBLE,
  "ri_pp_dist" VARCHAR,
  "element_score_ct" VARCHAR,
  "ct_pp_city" DOUBLE,
  "ct_pp_dist" VARCHAR,
  "element_score_se" VARCHAR,
  "se_pp_city" DOUBLE,
  "se_pp_dist" VARCHAR,
  "srte_lre_all" VARCHAR,
  "npct_lre_all" DOUBLE,
  "nval_lre_all" DOUBLE,
  "val_lre_all" VARCHAR,
  "c2_lre_all" VARCHAR,
  "c3_lre_all" VARCHAR,
  "c4_lre_all" VARCHAR,
  "ctval_lre_all" VARCHAR,
  "element_score_es" VARCHAR,
  "es_pp_city" DOUBLE,
  "es_pp_dist" VARCHAR,
  "element_score_sf" VARCHAR,
  "sf_pp_city" DOUBLE,
  "sf_pp_dist" VARCHAR,
  "element_score_tr" VARCHAR,
  "survey_pp_tr" VARCHAR,
  "tr_pp_city" DOUBLE,
  "tr_pp_dist" VARCHAR,
  "principal" VARCHAR,
  "superintendent" VARCHAR,
  "fsc" VARCHAR,
  "flbl_a_chronic_absent_all" VARCHAR,
  "flbl_m_chronic_absent_all" VARCHAR,
  "flbl_e_chronic_absent_all" VARCHAR,
  "flbl_a_lre_all" VARCHAR,
  "flbl_m_lre_all" VARCHAR,
  "flbl_e_lre_all" VARCHAR
);