Description

Access PESB's data related to characteristics of Washington's public school certified workforce.  This information is pulled from OSPI's S-275 Apportionment Data.  

URL

https://script.google.com/macros/s/AKfycbzKlAGI0uwmSAANYz3Q_iwpsGJhfmEjxkeRLQhJ6dzBYXC5N5k/exec

Method

GET


Parameters

 Parameters TYPE

 count

 STRING

 pivot

 BOOLEAN

 schoolYear

 STRING

 dutyType

 STRING

 districtCode 

 INTEGER

 schoolCode 

 INTEGER

 certificateNumber

 STRING

 Special Parameters

 Type

 getRules

 BOOLEAN

 getAllDistricts

 BOOLEAN

 getAllSchools

 BOOLEAN



Base Table

A call to this url will return the base table, which has the following elements.
 Elements Type Description

SchoolYearCode

 STRING

The academic year associated with this row

DutyType

 STRING

Teacher, School Administrator, District Administrator, or Educational Staff Associate.


Example

Return all years and course categories.
Note - this has the returnType category set to CSV to make it easier to read.  See here for additional returnType options.

Select Elements to Count

count

Adding the count parameter defaults to counting students.

Added Elements

 Elements Type Description

 Category

 STRING

Adds the count parameter value.  For example when selecting gender this element will include Female, Male, and Unknown

Note:  This is left out when the count=count parameter is selected.

 Count

 FLOAT

 A unique count of individuals (distinct count). 

Valid Values

 Value Description

 count

A simple count of the unique individuals

 hiring

Returns the following categories from the S-275 CBTRN code

  • New Hired Beginning
  • New Hired Experienced
  • Returned to District
  • Continuing in District

 gender

Returns Gender information in the following categories

  • Female
  • Male
  • Unknown

 ethnicity

Returns race/ethnicity information in the following categories*

  • Asian
  • Black
  • Hispanic
  • Native American
  • Multiple Selected
  • Pacific Islander
  • White
  • Unknown
Note - The federal guidelines have created significant changes in the way this information is collected.  Some longitudinal trends may be related to those changes. 
 ageReturns age information in the following categories*
  • Under 30 
  • Between30 and 39 
  • Between40 and 49 
  • Between 50 and 59 
  • Over 59 
  • Unknown
Note - The total from this returned data may be slightly different than the total count
 experienceReturns years of experience information in the following categories*
    • Less than 5 
    • Between 5 and 10 
    • Between 10 and 15 
    • Between 15 and 20 
    • Between 20 and 25 
    • Greater than 25 
    • Unknown 
    Note - The total from this returned data may be slightly different than the total count
     degreeReturns highest degree earned information in the following categories* 
    • Bachelors 
    • Masters 
    • Doctorate 
    • Vocational 
    • Special Circumstances 
    • Unknown

    Example


    Drill-down, limit, and pivot parameters

    The parameters below are used to drill down (add elements) to the query, limiting the values returned, and pivoting the count category.


    pivot

    Pivots category data.

    Valid Value

     Value Description

     true

    Pivots the data



    schoolYear

    Limits by school year. If not included the results will include all available data. 

    Added Elements

    School Year Code is returned by default.

    Valid Values

     Value Description

     latest

    The latest school year

     2013-2014

     Returns the results from the 2013-2014 school year.

     ....

    ....

     2002-2003

    Returns the results from the 2002-2003 school year.

    Note - Multiple years can be selected by separating the values by a comma 
    Note: It is best practice to encode urls. For example schoolYear=2003-2004,2006-2007 should be replaced with schoolYear%3D2003-2004%2C2006-2007


    dutyType

    Limits results by role.

    Added Elements

    Role is returned by default.

    Valid Values

     Value Description

     teacher

    Returns only Teacher results 

     school_admin

    Returns only School Administrator results 

     district_admin

    Returns only District Administrator results 

     esa

    Returns only Educational Staff Associate results 

    Note - Multiple dutyTypes can be selected by separating the values by a comma 

    Example

    Count Educational Staff Associates and pivot by gender.

    districtCode

    Adds district elements to the base table.  Use a district code to limit to a specific district, or use 'true' to return all districts.e

    Added Element

     Elements Type Description

     DistrictCode

     INTEGER

    OSPI's County/District Code.


     DistrictName

     STRING

    The school district name.


    Valid Values

     Value Description

     true

    Returns all information, but adds the district elements

     INTEGER

    Adds the district elements and limits the return to only this district code. 

    Note - Multiple districts can be selected by separating the values by a comma

    Example

    Count school administrators in Evergreen School District (Clark) and pivot by highest degree earned
    Note, returning districtCode=true without other limiting factors will take longer to return (large file).  Developers are encouraged to cache this information to avoid latency issues.  


    schoolCode


    Adds district and school elements to the base table.  Use a school code to limit to a specific school, or use 'true' to return all schools.  Can be combined with districtCode parameter to return school level data from a specific district.

    Added Element

     Elements Type Description

     DistrictCode

     INTEGER

    OSPI's County/District Code.


     DistrictName

     STRING

    The school district name.

     SchoolCode

     INTEGER

    OSPI's school building code

     SchoolName

     STRING

    The school name. 


    Valid Values

     Value Description

     true

    Returns all information, but adds the school and district elements

     INTEGER

    Adds the school and district elements and limits the return to only this school code. 


    Note - Multiple schools can be selected by separating the values by a comma

    Example

    Count the number of students by school where districtCode=6114 and pivot by assignment status




    Special Parameters

    Special parameters work independently to extract helpful information.  If there is a special parameter included in your fetch it will ignore other parameters.  If you have multiple special parameters it will default to the first special parameter listed below.

    getAllDistricts

    This special parameter returns all districts contained in the assignment data. 

    Added Element

     Elements Type Description

     DistrictCode

     INTEGER

    OSPI's County/District Code.


     DistrictName

     STRING

    The school district name.


    Valid Values

     Value Description

     true

    Returns all information.


    Example

    Get all districts associated with this data

    getAllSchools

    This special parameter returns schools for a specific district.

    Added Element

     Elements Type Description

     DistrictCode

     INTEGER

    OSPI's County/District Code.


     DistrictName

     STRING

    The school district name.

     SchoolLevel

     STRING

    The level associated with the school.

     SchoolName

     STRING

    The school name. 


    Valid Values

     Value Description

     INTEGER

    District Code


    Example

    Get all schools associated with 27403 (Bethel School District)





    Return Type and Download

    Select how data returns as well as an option to download using PESB's shared API parameters.