School Performance Reports (SPR) Database
The New Jersey Department of Education’s School Performance Reports (SPR) databases contain 63 sheets of data per year (2017-18 to 2023-24), covering comprehensive school performance metrics.
This document provides a dictionary of available sheets and examples of how to use them.
Quick Start
Using the Generic Extractor
# The generic extractor pulls any sheet by its NJ DOE name.
# level = "district" returns district + state aggregates from one ~30 MB
# workbook; level = "school" returns school-level rows (a much larger download).
ca <- fetch_spr_data("ChronicAbsenteeism", 2024, level = "district")
teachers <- fetch_spr_data("TeachersExperience", 2024, level = "district")
grad_dist <- fetch_spr_data("6YrGraduationCohortProfile", 2024, level = "district")Using Convenience Functions
# Convenience wrappers track the sheet renames NJ DOE makes across years,
# so you do not have to remember which name a given year uses.
ca <- fetch_chronic_absenteeism(2024, level = "district")
ca_grade <- fetch_absenteeism_by_grade(2024, level = "district")
days <- fetch_days_absent(2024, level = "district")Available SPR Sheets
Attendance & Discipline
| Sheet Name | Description | Years |
|---|---|---|
ChronicAbsenteeism |
Overall chronic absenteeism rates | 2017-2024 |
ChronicAbsenteeismByGrade |
Chronic absenteeism by grade level | 2017-2024 |
DaysAbsent |
Days absent statistics (avg, median) | 2017-2024 |
ViolenceVandalismHIBSubstanceOf |
Incident counts | 2017-2024 |
HIBInvestigations |
HIB investigation details | 2017-2024 |
DisciplinaryRemovals |
Suspension/expulsion data | 2017-2024 |
Staffing & Human Resources
| Sheet Name | Description | Years |
|---|---|---|
TeachersExperience |
Teacher experience levels | 2017-2024 |
AdministratorsExperience |
Administrator experience | 2017-2024 |
StaffCounts |
Staff counts by category | 2017-2024 |
StudentToStaffRatios |
Student-to-staff ratios | 2017-2024 |
TeachersAdminsDemographics |
Demographics (race, gender) | 2017-2024 |
TeachersAdminsLevelOfEducation |
Educational attainment | 2017-2024 |
TeachersAdminsOneYearRetention |
Staff retention rates | 2017-2024 |
TeachersBySubjectArea |
Teachers by subject | 2017-2024 |
College & Career Readiness
| Sheet Name | Description | Years |
|---|---|---|
PSAT-SAT-ACTParticipation |
SAT/ACT/PSAT participation rates | 2017-2024 |
PSAT-SAT-ACTPerformance |
SAT/ACT/PSAT score distributions | 2017-2024 |
APIBCourseworkPartPerf |
AP/IB performance (detailed) | 2017-2024 |
APIBDualEnrPartByStudentGrp |
AP/IB dual enrollment by subgroup | 2017-2024 |
APIBCoursesOffered |
AP/IB course offerings | 2017-2024 |
CTE_SLEParticipation |
Career/Technical Ed data | 2017-2024 |
CTEParticipationByStudentGroup |
CTE by subgroup | 2017-2024 |
IndustryValuedCredentialsEarned |
Industry credentials | 2017-2024 |
WorkbasedLearningByCareerClust |
Work-based learning | 2017-2024 |
Apprenticeship |
Apprenticeship data | 2017-2024 |
SealofBiliteracy |
Biliteracy seal earners | 2017-2024 |
Course Enrollment
| Sheet Name | Description | Years |
|---|---|---|
MathCourseParticipation |
Math course enrollment | 2017-2024 |
ScienceCourseParticipation |
Science course enrollment | 2017-2024 |
SocStudiesHistoryCourseParticip |
Social studies enrollment | 2017-2024 |
WorldLanguagesCourseParticipati |
World language enrollment | 2017-2024 |
ComputerScienceCourseParticipat |
CS enrollment | 2017-2024 |
VisualAndPerformingArts |
Arts enrollment | 2017-2024 |
Graduation & Dropout
| Sheet Name | Description | Years |
|---|---|---|
GraduatonRateTrendsProgress |
Graduation rate trends | 2017-2024 |
5YrGraduationCohortProfile |
5-year graduation detailed | 2017-2024 |
6YrGraduationCohortProfile |
6-year graduation detailed | 2021-2024 |
FederalGraduationRates |
Federal graduation rates | 2017-2024 |
AccountabilityGraduationRates |
ESSA graduation rates | 2017-2024 |
GraduationPathways |
Alternate graduation pathways | 2017-2024 |
DropoutRateTrends |
Dropout trends | 2017-2024 |
Accountability
| Sheet Name | Description | Years |
|---|---|---|
ESSAAccountabilityStatus |
ESSA status ratings | 2017-2024 |
ESSAAccountabilityProgress |
ESSA progress indicators | 2017-2024 |
Enrollment & Demographics
| Sheet Name | Description | Years |
|---|---|---|
EnrollmentTrendsbyGrade |
Grade-level enrollment trends | 2017-2024 |
EnrollmentTrendsByStudentGroup |
Enrollment by subgroup trends | 2017-2024 |
EnrollmentByRacialEthnicGroup |
Detailed racial/ethnic breakdowns | 2017-2024 |
PreKAndK-FullDayHalfDay |
Pre-K and K program detail | 2017-2024 |
EnrollmentTrendsFullSharedTime |
Full vs shared time | 2017-2024 |
EnrollmentByHomeLanguage |
Home language data | 2017-2024 |
Assessment Performance
| Sheet Name | Description | Years |
|---|---|---|
StudentGrowthTrends |
Student growth percentiles | 2017-2024 |
ELAMathPerformanceTrends |
Historical ELA/Math trends | 2017-2024 |
NJSLAELAPerformanceTrends |
NJSLA ELA detailed trends | 2017-2024 |
NJSLAMathPerformanceTrends |
NJSLA Math detailed trends | 2017-2024 |
NJSLAScience |
Science assessment results | 2017-2024 |
AlternateAssessmentParticipatio |
Alternate assessment data | 2017-2024 |
EnglishLangParticipationPerform |
ELL participation/performance | 2017-2024 |
Postsecondary
| Sheet Name | Description | Years |
|---|---|---|
PostSecondaryEnrRateSummary |
Postsecondary summary | 2017-2024 |
PostsecondaryEnrRatesFall |
Fall enrollment rates | 2017-2024 |
PostsecondaryEnrRates16mos |
16-month enrollment rates | 2017-2024 |
Usage Examples
Chronic Absenteeism Analysis
Which districts have the highest chronic absenteeism, and how has the statewide rate moved since COVID?
ca <- fetch_chronic_absenteeism(2024, level = "district")
# Districts where more than 30% of students are chronically absent
high_absent <- ca %>%
filter(is_district,
subgroup == "total population",
chronically_absent_rate > 30) %>%
arrange(desc(chronically_absent_rate)) %>%
select(district_name, chronically_absent_rate)
stopifnot(nrow(high_absent) > 0)
head(high_absent, 8)
#> # A tibble: 8 × 2
#> district_name chronically_absent_r…¹
#> <chr> <dbl>
#> 1 LEAD Charter School 71.4
#> 2 Camden Prep, Inc. 50.2
#> 3 Camden City School District 46.9
#> 4 KIPP: Cooper Norcross, A New Jersey Nonprofit Corporat… 45.5
#> 5 Ocean Gate School District 43
#> 6 Roseville Community Charter School 39.4
#> 7 Seaside Heights School District 39.1
#> 8 TEAM Academy Charter School 37.7
#> # ℹ abbreviated name: ¹chronically_absent_rateCompare the statewide rate before and after the pandemic. Wrapping each year’s fetch means a missing year surfaces as a warning, not a silent gap.
ca_trend <- map_dfr(c(2019, 2022, 2024), function(yr) {
tryCatch(
fetch_chronic_absenteeism(yr, level = "district") %>%
filter(is_state, subgroup == "total population") %>%
transmute(end_year, chronically_absent_rate),
error = function(e) {
warning("chronic absenteeism ", yr, " failed: ", conditionMessage(e))
NULL
}
)
})
stopifnot(nrow(ca_trend) == 3)
ca_trend
#> # A tibble: 3 × 2
#> end_year chronically_absent_rate
#> <dbl> <dbl>
#> 1 2019 10.6
#> 2 2022 18.1
#> 3 2024 14.9
ggplot(ca_trend, aes(end_year, chronically_absent_rate)) +
geom_line(color = "#c0392b", linewidth = 1) +
geom_point(color = "#c0392b", size = 3) +
geom_text(aes(label = paste0(chronically_absent_rate, "%")), vjust = -1.1) +
scale_x_continuous(breaks = c(2019, 2022, 2024)) +
labs(
title = "NJ chronic absenteeism spiked after COVID and is still elevated",
subtitle = "Statewide share of students chronically absent (total population)",
x = NULL, y = "Chronically absent (%)"
) +
theme_minimal()
Teacher Experience Analysis
Which districts rely most on out-of-field teachers? Several SPR numeric columns arrive as character text, so coerce them before sorting.
teachers <- fetch_spr_data("TeachersExperience", 2024, level = "district")
out_of_field <- teachers %>%
filter(is_district) %>%
transmute(
district_name,
avg_years_exp = as.numeric(teacher_avg_years_exp_school),
pct_out_of_field = as.numeric(percentage_of_out_of_field_teachers)
) %>%
arrange(desc(pct_out_of_field))
stopifnot(nrow(out_of_field) > 0)
head(out_of_field, 8)
#> # A tibble: 8 × 3
#> district_name avg_years_exp pct_out_of_field
#> <chr> <dbl> <dbl>
#> 1 Kindle Education Public Charter School 6.3 58.3
#> 2 Achievers Early College Prep Charter School 1.5 50
#> 3 Great Oaks Legacy Charter School 7.4 40.7
#> 4 Sussex County Educational Services Commission 2.4 35.7
#> 5 Pride Academy Charter School District 10 34.8
#> 6 Northern Region Educational Services Commission 4.6 34
#> 7 People's Achieve Community Charter School 4.6 33.3
#> 8 Community Charter School of Paterson 11.4 30.6Course Access Analysis
APIBCoursesOffered lists one row per course with
enrollment counts. The counts are stored as character, so coerce before
ranking.
ap <- fetch_spr_data("APIBCoursesOffered", 2024, level = "district")
# Most-enrolled AP/IB courses statewide
top_ap <- ap %>%
filter(is_state) %>%
transmute(course_name, enrolled = as.numeric(student_enroll_count)) %>%
arrange(desc(enrolled))
stopifnot(nrow(top_ap) > 0)
head(top_ap, 8)
#> # A tibble: 8 × 2
#> course_name enrolled
#> <chr> <dbl>
#> 1 AP U.S. History 20003
#> 2 AP English Language and Composition 19956
#> 3 AP English Literature and Composition 15717
#> 4 AP Psychology 13709
#> 5 AP Statistics 11029
#> 6 AP Calculus AB 9988
#> 7 AP Biology 9044
#> 8 AP Environmental Science 8337Discipline Analysis
For 2024 the discipline sheet is
DisciplinaryRemovalsByStudgroup;
fetch_disciplinary_removals() picks the right sheet name
for each year. The grouping column is student_group_grade,
and the sheet reports suspension and expulsion percentages directly (no
enrollment denominator).
discipline <- fetch_disciplinary_removals(2024, level = "district")
# Suspension and expulsion rates by student group, statewide
susp_by_group <- discipline %>%
filter(
is_state,
student_group_grade %in% c(
"Statewide", "Black or African American", "Hispanic", "White",
"Students with disabilities", "Economically Disadvantaged Students"
)
) %>%
transmute(
student_group_grade,
pct_any_suspension = as.numeric(any_susp_pct),
pct_expulsions = as.numeric(expulsion_pct)
) %>%
arrange(desc(pct_any_suspension))
stopifnot(nrow(susp_by_group) > 0)
susp_by_group
#> # A tibble: 6 × 3
#> student_group_grade pct_any_suspension pct_expulsions
#> <chr> <dbl> <dbl>
#> 1 Black or African American 9.02 0.01
#> 2 Students with disabilities 6.56 0
#> 3 Economically Disadvantaged Students 6.24 0
#> 4 Hispanic 4.56 0
#> 5 Statewide 4.26 0
#> 6 White 2.78 0Data Structure
All SPR data returned by fetch_spr_data() includes:
Standard Identifier Columns
-
end_year- School year end (e.g., 2024 for 2023-24 school year) -
county_id,county_name- County code and name -
district_id,district_name- District code and name -
school_id,school_name- School code and name (school-level only)
Data Quality Notes
- 2020-2021 Data: Some data not available due to COVID-19 pandemic disruptions
- Small Cell Suppression: Values may be suppressed (NA) for small subgroups to protect privacy
- Data Validation: Always check for NA values and data completeness before analysis
See Also
sessionInfo()
#> R version 4.6.2 (2026-10-29)
#> Platform: x86_64-pc-linux-gnu
#> Running under: Ubuntu 26.04.1 LTS
#>
#> Matrix products: default
#> BLAS: /usr/lib/x86_64-linux-gnu/openblas-pthread/libblas.so.3
#> LAPACK: /usr/lib/x86_64-linux-gnu/openblas-pthread/libopenblasp-r0.3.32.so; LAPACK version 3.12.0
#>
#> locale:
#> [1] LC_CTYPE=C.UTF-8 LC_NUMERIC=C LC_TIME=C.UTF-8
#> [4] LC_COLLATE=C.UTF-8 LC_MONETARY=C.UTF-8 LC_MESSAGES=C.UTF-8
#> [7] LC_PAPER=C.UTF-8 LC_NAME=C LC_ADDRESS=C
#> [10] LC_TELEPHONE=C LC_MEASUREMENT=C.UTF-8 LC_IDENTIFICATION=C
#>
#> time zone: UTC
#> tzcode source: system (glibc)
#>
#> attached base packages:
#> [1] stats graphics grDevices utils datasets methods base
#>
#> other attached packages:
#> [1] ggplot2_4.0.4 purrr_1.2.2 dplyr_1.2.1
#> [4] njschooldata_0.11.0
#>
#> loaded via a namespace (and not attached):
#> [1] utf8_1.2.6 rappdirs_0.3.4 sass_0.5.0 generics_0.1.4
#> [5] tidyr_1.3.2 stringi_1.8.9 hms_1.1.4 digest_0.6.39
#> [9] magrittr_2.0.5 evaluate_1.0.5 grid_4.6.2 timechange_0.4.0
#> [13] RColorBrewer_1.1-3 fastmap_1.2.0 cellranger_1.1.0 jsonlite_2.0.0
#> [17] scales_1.4.0 codetools_0.2-20 textshaping_1.1.0 jquerylib_0.1.4
#> [21] cli_3.6.6 rlang_1.3.0 withr_3.0.3 cachem_1.1.0
#> [25] yaml_2.3.12 otel_0.3.0 tools_4.6.2 tzdb_0.5.0
#> [29] vctrs_0.7.3 R6_2.6.1 lifecycle_1.0.5 lubridate_1.9.5
#> [33] snakecase_0.11.1 stringr_1.6.0 fs_2.1.0 ragg_1.5.2
#> [37] janitor_2.2.1 pkgconfig_2.0.3 desc_1.4.3 pkgdown_2.2.1
#> [41] pillar_1.11.1 bslib_0.12.0 gtable_0.3.6 glue_1.8.1
#> [45] systemfonts_1.3.3 xfun_0.62 tibble_3.3.1 tidyselect_1.2.1
#> [49] knitr_1.52 farver_2.1.2 htmltools_0.5.9 labeling_0.4.3
#> [53] rmarkdown_2.32 readr_2.2.0 compiler_4.6.2 S7_1.0.0
#> [57] readxl_1.6.0