About this Dataset

Report Card Teacher Certificate School Years 2017-18 Through 2023-24

This file includes Report Card teacher certificate types for the 2017-18 through 2023-24 school years. Data is disaggregated by school, LEA, Educational Service District, and the state level. Please review the notes below for more information.
Organization: State of Washington
Last updated: 2025-01-17T21:49:33.505374
Tags: ospi, report-card, teachers

Tables

Table 1

@usgov.state_of_washington_report_card_teacher_certificate_sc_a651b227.table_1

891.6 KB
51884 rows
22 columns


CREATE TABLE table_1 (
  "rowid" BIGINT,
  "schoolyear" VARCHAR,
  "organizationlevelid" BIGINT,
  "organizationlevel" VARCHAR,
  "organizationid" BIGINT,
  "organizationname" VARCHAR,
  "county" VARCHAR,
  "esdorganizationid" VARCHAR,
  "esdname" VARCHAR,
  "leaorganizationid" VARCHAR,
  "leacode" VARCHAR,
  "leaname" VARCHAR,
  "schoolorganizationid" VARCHAR,
  "schoolcode" VARCHAR,
  "schoolname" VARCHAR,
  "certificatetypeid" VARCHAR,
  "certificatetype" VARCHAR,
  "teachercount" VARCHAR,
  "teachertotal" BIGINT,
  "percentage" VARCHAR,
  "iseevalidated" BIGINT,
  "dataasof" TIMESTAMP
);