About this Dataset

2017-18 Washington State CRDC Data - School Behavior And Climate

The Civil Rights Data Collection (CRDC) is a biennial (i.e., every other school year) survey required by the U.S. Department of Education’s (Department) Office for Civil Rights (OCR) since 1968. The CRDC collects a variety of information including student enrollment and educational programs and services, most of which is disaggregated by race/ethnicity, sex, limited English proficiency, and disability. The CRDC is a longstanding and important aspect of the ED Office for Civil Rights (OCR) overall strategy for administering and enforcing the civil rights statutes for which it is responsible.

Data was reported directly from the school districts to the Office of Civil Rights. This data process is not managed by OSPI and therefore the data is not validated or reviewed by OSPI before being reported to OCR. For this reason data presented in this file will not mirror OSPI reports on similar student and school measures. The 2017-18 data in the report represents the most recent data made publicly available by the CRDC as of 5/10/2021.

In some cases data was unavailable or suppressed by OCR to protect student privacy, for more information on this please visit the CRDC webpage. In addition, directory information for some schools is incomplete, as the names of the organizations provided in the CRDC data files did not match the names of organizations on record with OSPI.

For additional information or questions about this data please visit the CRDC webpage at https://ocrdata.ed.gov/.
Organization: State of Washington
Last updated: 2023-09-02T08:07:21.665219
Tags: 2018, crdc, ospi, reportcard, student

Tables

Table 1

@usgov.state_of_washington_2017_18_washington_state_crdc_scho_e476e1f3.table_1

537.61 KB
32746 rows
35 columns


CREATE TABLE table_1 (
  "schoolyear" VARCHAR,
  "organizationlevel" VARCHAR,
  "organizationid" DOUBLE,
  "county" VARCHAR,
  "esdname" VARCHAR,
  "esdorganizationid" DOUBLE,
  "districtcode" DOUBLE,
  "districtname" VARCHAR,
  "districtorganizationid" DOUBLE,
  "schoolcode" DOUBLE,
  "schoolname" VARCHAR,
  "schoolorganizationid" DOUBLE,
  "currentschooltype" VARCHAR,
  "leaid" BIGINT,
  "schid" BIGINT,
  "studentgrouptype" VARCHAR,
  "studentgroup" VARCHAR,
  "enrollment" BIGINT,
  "in_school_suspension" VARCHAR,
  "out_of_school_suspension" VARCHAR,
  "expulsion" VARCHAR,
  "school_related_arrest" VARCHAR,
  "referral_to_law_enforcement" VARCHAR,
  "chronic_absenteeism" BIGINT,
  "students_reported_as_being_harrassed_based_on_disability" VARCHAR,
  "students_reported_as_being_harrassed_based_on_race_ethnicity" VARCHAR,
  "students_reported_as_being_harrassed_based_on_sex" VARCHAR,
  "percentiss" VARCHAR,
  "percentoss" VARCHAR,
  "percentexpelled" VARCHAR,
  "percentarrested" VARCHAR,
  "percentchronicallyabsent" VARCHAR,
  "percentharrassedbasedondisability" VARCHAR,
  "percentharrassedbasedonrace" VARCHAR,
  "percentharrassedbasedonsex" VARCHAR
);