Downloads ESSA accountability status/ratings (CSI/ATSI/TSI identification)
from the SPR database. Each row carries the entity's status for the school
year (status_for_sy), the category_of_identification that drove
it, the year eligible to exit, and (for targeted statuses) the affected
student group.
Value
Data frame with ESSA status ratings
Supported end_year values are 2019-2025; the 2017-2018 workbooks lack this sheet. Legacy student_group_status_* fields (2019-2024), notes (2020-2024), and redesigned student_groups and status_note (2025) are retained separately, with character NA where not published. The requested school year is filtered before the redundant school_year column is removed.
Details
The 2024-25 (end_year 2025) SPR redesign reorganized the accountability sheets per database file:
School DB: keeps the
ESSAAccountabilityStatussheet (one row per identified school).District/State DB: the
ESSAAccountabilityStatussheet was removed and replaced by two new sheets:ESSAAccountabilityStatusList(one row per identified school, with the same 12-column layout as the School DB sheet) andESSAAccountabilityStatusCounts(per-district CSI/ATSI/TSI tallies). The List sheet is the structural analogue of the legacyESSAAccountabilityStatussheet – it carries the per-entity status andcategory_of_identificationthat downstream functions such asidentify_focus_schoolsrequire – so this function maps district-level 2025+ requests toESSAAccountabilityStatusList. The Counts sheet holds only aggregate tallies and is not used here.
Examples
if (FALSE) { # \dontrun{
# School-level status (all years use the ESSAAccountabilityStatus sheet)
essa <- fetch_essa_status(2024)
# District/State-level status for the redesigned 2024-25 database
essa_dist <- fetch_essa_status(2025, level = "district")
# Identify schools needing comprehensive support
library(dplyr)
fetch_essa_status(2025) %>%
filter(grepl("Comprehensive", status_for_sy))
} # }