About this Dataset

Arts Ed Profile

The LA County Arts Ed Profile is a research project by the LA County Arts Education Collective that measures the quantity, quality and equity of arts education in all public schools in the county. This available dataset combines data collected through the Arts Ed Profile school survey and data collected by the California Department of Education.

Please see the Data Dictionary under Attachments or download all data from the Source Link.
Organization: City of Los Angeles
Last updated: 2020-11-10T17:52:20.140295
Tags: art, education, la-county, school

Tables

Table 1

@usgov.city_of_los_angeles_arts_ed_profile.table_1

656.2 kB
2,252 rows
228 columns

CREATE TABLE table_1 (
  "cde_cds_code" BIGINT,
  "cde_school_cde" VARCHAR,
  "cde_districtname" VARCHAR,
  "cde_school_address" VARCHAR,
  "cde_closed_school" VARCHAR,
  "lausd_local_district" VARCHAR,
  "charterorother" VARCHAR,
  "survey_status" VARCHAR,
  "charterschool" BOOLEAN,
  "cde_mingrade" VARCHAR,
  "cde_maxgrade" DOUBLE,
  "schoolenrollment" DOUBLE,
  "cde_englishlearnersschool" DOUBLE,
  "cde_freereducedmealsschool" DOUBLE,
  "cde_aioran_pct" DOUBLE,
  "cde_asian_pct" DOUBLE,
  "cde_pi_pct" DOUBLE,
  "cde_filipino_pct" DOUBLE,
  "cde_latino_pct" DOUBLE,
  "cde_afamnh_pct" DOUBLE,
  "cde_whitenh_pct" DOUBLE,
  "cde_twoormore_pct" DOUBLE,
  "cde_nonerprt_pct" DOUBLE,
  "cde_dance_course_count" DOUBLE,
  "cde_music_course_count" DOUBLE,
  "cde_drama_course_count" DOUBLE,
  "cde_visual_arts_course_count" DOUBLE,
  "cde_media_arts_course_count" DOUBLE,
  "cde_estimatedfte_sum_dance" DOUBLE,
  "cde_estimatedfte_sum_music" DOUBLE,
  "cde_estimatedfte_sum_drama" DOUBLE,
  "cde_estimatedfte_sum_visualarts" DOUBLE,
  "cde_estimatedfte_sum_mediaarts" DOUBLE,
  "cde_9th_grade_dance_enrollment" DOUBLE,
  "cde_10th_grade_dance_enrollment" DOUBLE,
  "cde_11th_grade_dance_enrollment" DOUBLE,
  "cde_12th_grade_dance_enrollment" DOUBLE,
  "cde_9th_grade_music_enrollment" DOUBLE,
  "cde_10th_grade_music_enrollment" DOUBLE,
  "cde_11th_grade_music_enrollment" DOUBLE,
  "cde_12th_grade_music_enrollment" DOUBLE,
  "cde_9th_grade_drama_enrollment" DOUBLE,
  "cde_10th_grade_drama_enrollment" DOUBLE,
  "cde_11th_grade_drama_enrollment" DOUBLE,
  "cde_12th_grade_drama_enrollment" DOUBLE,
  "cde_9th_grade_visual_arts_enrollment" DOUBLE,
  "cde_10th_grade_visual_arts_enrollment" DOUBLE,
  "cde_11th_grade_visual_arts_enrollment" DOUBLE,
  "cde_12th_grade_visual_arts_enrollment" DOUBLE,
  "cde_9th_grade_media_arts_enrollment" DOUBLE,
  "cde_10th_grade_media_arts_enrollment" DOUBLE,
  "cde_11th_grade_media_arts_enrollment" DOUBLE,
  "cde_12th_grade_media_arts_enrollment" DOUBLE,
  "cde_9th_grade_dance_courses" DOUBLE,
  "cde_10th_grade_dance_courses" DOUBLE,
  "cde_11th_grade_dance_courses" DOUBLE,
  "cde_12th_grade_dance_courses" DOUBLE,
  "cde_9th_grade_music_courses" DOUBLE,
  "cde_10th_grade_music_courses" DOUBLE,
  "cde_11th_grade_music_courses" DOUBLE,
  "cde_12th_grade_music_courses" DOUBLE,
  "cde_9th_grade_drama_courses" DOUBLE,
  "cde_10th_grade_drama_courses" DOUBLE,
  "cde_11th_grade_drama_courses" DOUBLE,
  "cde_12th_grade_drama_courses" DOUBLE,
  "cde_9th_grade_visual_arts_courses" DOUBLE,
  "cde_10th_grade_visual_arts_courses" DOUBLE,
  "cde_11th_grade_visual_arts_courses" DOUBLE,
  "cde_12th_grade_visual_arts_courses" DOUBLE,
  "cde_9th_grade_media_arts_courses" DOUBLE,
  "cde_10th_grade_media_arts_courses" DOUBLE,
  "cde_11th_grade_media_arts_courses" DOUBLE,
  "cde_12th_grade_media_arts_courses" DOUBLE,
  "elementary" BOOLEAN,
  "es_prektk" VARCHAR,
  "es_kinder" VARCHAR,
  "es_1st" VARCHAR,
  "es_2nd" VARCHAR,
  "es_3rd" VARCHAR,
  "es_4th" VARCHAR,
  "es_5th" VARCHAR,
  "es_6th" VARCHAR,
  "es_7th" VARCHAR,
  "es_8th" VARCHAR,
  "es_dance" VARCHAR,
  "esd_prektk" VARCHAR,
  "esd_kinder" VARCHAR,
  "esd_1st" VARCHAR,
  "esd_2nd" VARCHAR,
  "esd_3rd" VARCHAR,
  "esd_4th" VARCHAR,
  "esd_5th" VARCHAR,
  "esd_6th" VARCHAR,
  "esd_7th" VARCHAR,
  "esd_8th" VARCHAR,
  "esd_prektk_students" VARCHAR,
  "esd_kinder_students" VARCHAR,
  "esd_1st_students" VARCHAR,
  "esd_2nd_students" VARCHAR,
  "esd_3rd_students" VARCHAR
);