About this Dataset

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

This file includes Report Card teacher limited certificates for the 2017-18 through 2023-24 school years. Data is disaggregated by school, district, Educational Service District, and the state level. Certificate information indicates the count and percent of teachers by limited certificate subcategories. Please review the notes below for more information.
Organization: State of Washington
Last updated: 2025-01-17T21:54:41.507079
Tags: ospi, report-card, teachers

Tables

Table 1

@usgov.state_of_washington_report_card_teacher_limited_certif_f17eaa01.table_1

902.8 kB
45,011 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,
  "limitedcertificatetypeid" VARCHAR,
  "limitedcertificatetype" VARCHAR,
  "teachercount" VARCHAR,
  "teachertotal" BIGINT,
  "percentage" VARCHAR,
  "iseevalidated" BIGINT,
  "dataasof" TIMESTAMP
);