About this Dataset

Report Card Teacher Program School Years 2017-18 To 2023-24

This file includes Report Card teacher information around teacher assignments by program for the 2017-18 through 2023-24 school years. Data is disaggregated by school, district, Educational Service District, and the state level. Program information includes count and percent of teachers by head count and program as well as by FTE assignment. Please review the notes below for more information.
Organization: State of Washington
Last updated: 2025-01-17T21:49:36.183834
Tags: ospi, report-card, teachers

Tables

Table 1

@usgov.state_of_washington_report_card_teacher_program_school_33e4863b.table_1

1.33 MB
68610 rows
23 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,
  "program" VARCHAR,
  "programformalname" VARCHAR,
  "teachercount" BIGINT,
  "teachertotal" BIGINT,
  "percentage" DOUBLE,
  "totalfte" VARCHAR,
  "iseevalidated" BIGINT,
  "dataasof" TIMESTAMP
);