About this Dataset

2019-2020 Arts Survey Data

The Annual Arts Education survey collects information on student participation in and access to arts education at NYCDOE schools.

Please note the following arts-related data are now collected from other sources:
The number of certified art teachers and non-certified teachers teaching the arts is collected form the HR and BEDS survey
The arts instructional hours provided to elementary students are collected from the Student Transcript and Academic Recording System (STARS)
The middle and high school participation in the arts data and the NYSED requirement data are collected form STARS and the HS arts sequence data are also collected form STARS
Organization: City of New York
Last updated: 2021-08-07T17:24:28.937456

Tables

Table 1

@usgov.city_of_new_york_2019_2020_arts_survey_data.table_1

459.39 kB
1,240 rows
442 columns

CREATE TABLE table_1 (
  "dbn" VARCHAR,
  "q1_1" VARCHAR,
  "q1_2" VARCHAR,
  "q1_3" VARCHAR,
  "q2_1" BIGINT,
  "q3_1" BIGINT,
  "q3_2" BIGINT,
  "q3_3" BIGINT,
  "q3_4" BIGINT,
  "q4_1" BIGINT,
  "q4_2" BIGINT,
  "q5_1" BIGINT,
  "q5_2" BIGINT,
  "q6_1" DOUBLE,
  "q6_2" DOUBLE,
  "q6_3" DOUBLE,
  "q6_4" DOUBLE,
  "q7_1" DOUBLE,
  "q7_2" DOUBLE,
  "q7_3" DOUBLE,
  "q7_4" DOUBLE,
  "q8_r1_c1" DOUBLE,
  "q8_r1_c2" DOUBLE,
  "q8_r2_c1" DOUBLE,
  "q8_r2_c2" DOUBLE,
  "q8_r3_c1" DOUBLE,
  "q8_r3_c2" DOUBLE,
  "q8_r4_c1" DOUBLE,
  "q8_r4_c2" DOUBLE,
  "q8_r5_c1" DOUBLE,
  "q8_r5_c2" DOUBLE,
  "q9_1" BIGINT,
  "q9_2" BIGINT,
  "q9_3" BIGINT,
  "q9_4" BIGINT,
  "q9_5" BIGINT,
  "q9_6" BIGINT,
  "q9_7" BIGINT,
  "q9_8" BIGINT,
  "q9_9" BIGINT,
  "q9_10" BIGINT,
  "q9_11" BIGINT,
  "q9_12" BIGINT,
  "q9_13" BIGINT,
  "q9_14" BIGINT,
  "q9_15" BIGINT,
  "q9_16" BIGINT,
  "q9_17" BIGINT,
  "q9_18" BIGINT,
  "q9_19" BIGINT,
  "q9_20" BIGINT,
  "q9_21" BIGINT,
  "q9_22" BIGINT,
  "q10_r1_c1" BIGINT,
  "q10_r1_c2" BIGINT,
  "q10_r2_c1" BIGINT,
  "q10_r2_c2" BIGINT,
  "q10_r3_c1" BIGINT,
  "q10_r3_c2" BIGINT,
  "q10_r4_c1" BIGINT,
  "q10_r4_c2" BIGINT,
  "q10_r5_c1" BIGINT,
  "q10_r5_c2" BIGINT,
  "q11_r1_c1" BIGINT,
  "q11_r1_c2" BIGINT,
  "q11_r1_c3" BIGINT,
  "q11_r1_c4" BIGINT,
  "q11_r2_c1" BIGINT,
  "q11_r2_c2" BIGINT,
  "q11_r2_c3" BIGINT,
  "q11_r2_c4" BIGINT,
  "q11_r3_c1" BIGINT,
  "q11_r3_c2" BIGINT,
  "q11_r3_c3" BIGINT,
  "q11_r3_c4" BIGINT,
  "q11_r4_c1" BIGINT,
  "q11_r4_c2" BIGINT,
  "q11_r4_c3" BIGINT,
  "q11_r4_c4" BIGINT,
  "q12_c1_r1" VARCHAR,
  "q12_c1_r2" VARCHAR,
  "q12_c1_r3" VARCHAR,
  "q12_c1_r4" VARCHAR,
  "q13_c1_r1" DOUBLE,
  "q13_c1_r2" DOUBLE,
  "q13_c1_r3" DOUBLE,
  "q13_c1_r4" DOUBLE,
  "q13_c2_r1" DOUBLE,
  "q13_c2_r2" DOUBLE,
  "q13_c2_r3" DOUBLE,
  "q13_c2_r4" DOUBLE,
  "q13_c3_r1" DOUBLE,
  "q13_c3_r2" DOUBLE,
  "q13_c3_r3" DOUBLE,
  "q13_c3_r4" DOUBLE,
  "q13_c4_r1" DOUBLE,
  "q13_c4_r2" DOUBLE,
  "q13_c4_r3" DOUBLE,
  "q13_c4_r4" DOUBLE,
  "q13_c5_r1" DOUBLE
);