Skip to contents

Downloads the StaffCounts sheet from the redesigned 2024-25 School Performance Reports: counts of staff by role (staff_category, e.g. Administrators, Teachers, Child Study Team Members) for the school, district, and state.

Usage

fetch_spr_staff_counts(end_year, level = "school")

Arguments

end_year

A school year (2021-2025). Year is the end of the academic year - e.g. the 2020-21 school year is end_year 2021.

level

One of "school" or "district".

Value

Data frame with entity identifiers, staff_category, the three staff count columns, and the aggregation flags.

Details

The three count columns (school_total_staff, district_total_staff_members, state_total_staff_members) are returned numeric (thousands commas stripped; cells reading “There is no data available for this school year.” set to NA).

Supported years: end_year >= 2021. The StaffCounts sheet first appears in the SY2020-21 SPR and has the same layout through the redesign. Earlier databases have no equivalent sheet.

Examples

if (FALSE) { # \dontrun{
staff <- fetch_spr_staff_counts(2025)

# The same counts back to SY2020-21
staff_2021 <- fetch_spr_staff_counts(2021)

# Teacher counts by school
library(dplyr)
fetch_spr_staff_counts(2025) %>%
  filter(is_school, staff_category == "Teachers") %>%
  select(district_name, school_name, school_total_staff)

# Statewide staff by role
fetch_spr_staff_counts(2025, level = "district") %>%
  filter(is_state) %>%
  select(staff_category, state_total_staff_members)
} # }