wa-gov/report-card-teacher-demographics-vdfh-vn22
Icon for Socrata external plugin
 
Readme
Updated 7 months ago
Indexed 2 hours ago

Report Card Teacher Demographics

This file includes Report Card educator demographic data for the 2017-18 through 2020-21 school years. Data is disaggregated by school, district, and the state level and includes demographic information on classroom teachers, including: count and percent by race/ethnicity and gender, count and percent with Master's degrees or higher by race/ethnicity, and average years of experience by race/ethnicity. Please review the notes below for more information.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
MA+Percentma_percentma_percentTextRepresents the percent of classroom teachers by demographic category who hold a Master's degree or another higher degree. Other higher degree include, for example, PhD's and EdD's. When inexperienced status is not null or where TeacherDemographicCategoryId is 10, 11 or 12, or IsEEValidated = 0, this field will be NULL
AvgYearsExperienceavgyearsexperienceavgyearsexperienceTextRepresents the average years of teaching experience by demographic category. When TeacherDemographicCategoryId is 9, 10 ,11, or 12, or IsEEValidated = 0, this field will be NULL
SumYearsExperiencesumyearsexperiencesumyearsexperienceTextRepresents the sum of years experience by demographic category in the organization. When TeacherDemographicCategoryId is 9, 10, 11, or 12, or IsEEValidated = 0, this field will be NULL
TeacherPercentteacherpercentteacherpercentTextRepresents the percent of teachers by demographic category in the organization. When IsEEValidated = 0, this field will be NULL
TeacherCountteachercountteachercountTextRepresents the head count of teachers by demographic category in the organization. When teacher count = 0 for a demographic category, row will not exist. When IsEEValidated = 0, this field will be NULL
DemographicCategorydemographiccategorydemographiccategoryTextTeacher Demographic Category Name. "All" indicates all teachers are included. When IsEEValidated = 0, this field will be NULL
SchoolNameschoolnameschoolnameTextSchool name. When OrganizationLevel = "State" or "District", this field will be NULL
DistrictOrganizationIddistrictorganizationiddistrictorganizationidTextUnique district identification number. When OrganizationLevel = "State", this field will be NULL
DistrictNamedistrictnamedistrictnameTextDistrict name. When OrganizationLevel = "State", this field will be NULL
ESDNameesdnameesdnameTextName the the Educational Service District serving the district or school. When OrganizationLevel = "State", this field will be NULL
CountycountycountyTextCounty Name in which the school or district resides. When OrganizationLevel = "State", this field will be reported as "Multiple"
organizationidorganizationidorganizationidNumberUnique organization identification number
IsEEValidatediseevalidatediseevalidatedText0 indicates that educator data is not currently reported through the Educator Equity Data collection tool. Only directory information is currently provided for organizations not reporting through the Educator Equity Data Collection Tool. 1 indicates integration of data was vetted by school and/or district reporting or HR personnel through the Educator Equity Data Collection Tool.
MA+Countma_countma_countTextRepresents the distinct head count of classroom teachers by demographic category who hold a Master's degree or another higher degree. Other higher degrees include, for example, PhD's and EdD's. When inexperienced status is not null or where TeacherDemographicCategoryId is 10, 11 or 12, or IsEEValidated = 0, this field will be NULL
DemographicCategoryIddemographiccategoryiddemographiccategoryidTextThis field describes the teachers by parsing out the specific TeacherDemographicCategoryType into their subgroup ids. TeacherDemographicCategoryId represents an id generated by OSPI's Title II A office to describe teacher demographic categories. 0 indicates all teachers are included. Gender X, or Non Low-income and Low Income student groups. When IsEEValidated = 0, this field will be NULL
TeacherTotalCountteachertotalcountteachertotalcountTextRepresents the total distinct head count of all classroom teachers within the organization. When IsEEValidated = 0, this field will be NULL
SchoolOrganizationIdschoolorganizationidschoolorganizationidTextUnique school identification number. When OrganizationLevel = "State" or "District", this field will be NULL
SchoolCodeschoolcodeschoolcodeTextUnique school code. When OrganizationLevel = "State" or "District", this field will be NULL
DistrictCodedistrictcodedistrictcodeTextUnique district code. When OrganizationLevel = "State", this field will be NULL
ESDOrganizationIdesdorganizationidesdorganizationidTextUnique ESD Identification number. When OrganizationLevel = "State", this field will be NULL
RowIdrowidrowidNumberUnique row identity for data table
DataAsOfdataasofdataasofCalendar dateDate file was last updated
DemographicCategoryTypedemographiccategorytypedemographiccategorytypeTextThis field describes the teacher demographic category type being measured: Gender, Race/Ethnicity, or All Classroom Teachers. When IsEEValidated = 0, this field will be NULL
CurrentSchoolTypecurrentschooltypecurrentschooltypeTextSchool type code, please see https://eds.ospi.k12.wa.us/DirectoryEDS.aspx for more on school type codes . When OrganizationLevel = "State" or "District", this field will be NULL
SchoolYearschoolyearschoolyearText7 character year displayed as YYYY-YY (e.g., 2019-20)
OrganizationLevelorganizationlevelorganizationlevelTextThe level at which the data is aggregated. Allowable values = School, District, and State.
 
Preview
  • report_card_teacher_demographics
     
Upstream Metadata