Fetch ESSA Accountability Status Counts (district/state)
Source:R/fetch_spr.R
fetch_spr_essa_status_counts.RdDownloads the ESSAAccountabilityStatusCounts sheet from the redesigned
2024-25 School Performance Reports. Each row tallies, for a district (and the
statewide total), how many of its schools are identified as Comprehensive
Support and Improvement (CSI), Additional Targeted Support and Improvement
(ATSI), and Targeted Support and Improvement (TSI).
Value
Data frame with county_id, county_name, district_id, district_name, school_id, school_name, comprehensive_csi, additional_targeted_atsi, targeted_tsi, end_year, and the aggregation flags.
Details
This sheet exists only in the District/State database, so this function
always reads district-level data (there is no level argument). The
three count columns are returned numeric. The per-school identification
detail behind these tallies is available from fetch_essa_status
(the ESSAAccountabilityStatusList sheet).
Supported years: only end_year >= 2025. The pre-2025
District/State database stored accountability status in a single sheet that
fetch_essa_status reads; the separate counts sheet is new in
the redesign.
Examples
if (FALSE) { # \dontrun{
# District/state CSI/ATSI/TSI tallies
counts <- fetch_spr_essa_status_counts(2025)
# Statewide totals
library(dplyr)
fetch_spr_essa_status_counts(2025) %>%
filter(is_state) %>%
select(comprehensive_csi, additional_targeted_atsi, targeted_tsi)
# Districts with the most CSI schools
fetch_spr_essa_status_counts(2025) %>%
filter(is_district) %>%
slice_max(comprehensive_csi, n = 10) %>%
select(county_name, district_name, comprehensive_csi)
} # }