Source-vs-database crosschecks and universe reconciliation
The district-wide series recomputed straight from the district's file and compared to the served database, plus the list of school-years the database lacks.
- 1How it was computedper year: weighted share from exact counts (file) vs from loaded percentages (database), tolerance 0.02; school membership diff
- universe
- All District-sector schools in the file vs directory schools in the database
- packet block
- crosschecks
Uses: Chronic absenteeism as 100 minus the 90%-attendance share
Evidence: generator — search "// 10 — crosschecks"
- 2What went inInputs
- sdp_attendance_90_school — read directly from the publisher’s file (Student attendance — % with 90%+ attendance, by school and year). findings
- attendance_rate_above_90 — served metric; its own tree covers file, load, and checks.
- 3The generated fileThe committed data file
Generated 2026-09-08 by one script from the inputs above; the page renders only from this file.
This block’s raw values (JSON)
[ { "stat": "common_weighted_2020-21", "from_db": 29.3657, "from_source": 29.3657, "diff": 0, "match": true }, { "stat": "common_n_schools_2020-21", "from_db": 212, "from_source": 212, "diff": 0, "match": true }, { "stat": "common_n_students_2020-21", "from_db": 122895, "from_source": 122895, "diff": 0, "match": true }, { "stat": "common_weighted_2021-22", "from_db": 42.0446, "from_source": 42.0448, "diff": -0.0002, "match": true }, { "stat": "common_n_schools_2021-22", "from_db": 213, "from_source": 213, "diff": 0, "match": true }, { "stat": "common_n_students_2021-22", "from_db": 125830, "from_source": 125830, "diff": 0, "match": true }, { "stat": "common_weighted_2022-23", "from_db": 39.0188, "from_source": 39.0188, "diff": 0, "match": true }, { "stat": "common_n_schools_2022-23", "from_db": 215, "from_source": 215, "diff": 0, "match": true }, { "stat": "common_n_students_2022-23", "from_db": 124435, "from_source": 124435, "diff": 0, "match": true }, { "stat": "common_weighted_2023-24", "from_db": 38.1259, "from_source": 38.1258, "diff": 0, "match": true }, { "stat": "common_n_schools_2023-24", "from_db": 216, "from_source": 216, "diff": 0, "match": true }, { "stat": "common_n_students_2023-24", "from_db": 124034, "from_source": 124034, "diff": 0, "match": true }, { "stat": "common_weighted_2024-25", "from_db": 37.7354, "from_source": 37.7351, "diff": 0.0003, "match": true }, { "stat": "common_n_schools_2024-25", "from_db": 216, "from_source": 216, "diff": 0, "match": true }, { "stat": "common_n_students_2024-25", "from_db": 124306, "from_source": 124306, "diff": 0, "match": true } ]Evidence: packet JSON · generator script
- 4How it was checkedChecked: passed
- ✓ passedThis block IS the check: 15 aggregate comparisons (weighted rate, school count, student count per year) at 0.01 tolerance for rates and exact for counts, all matching, plus the school-membership reconciliation with the signed effect of each dropped school-year.
The QA report behind this status · the report also lists what it does not check.
Each input metric’s own checks are on its metric tree (links above). Only the district-wide all-students series is covered by the packet’s 15 source-vs-database checks; that coverage is not claimed for any other block.
- 5Assumptions & caveatsAssumptions and caveats
None beyond the input metrics’ own assumptions.
The numbers in this block
| Year | District rate | Typical school (median) | 10th–90th percentile schools | Schools | Students |
|---|---|---|---|---|---|
| 2020-21 † | 29.3% | 33.8% | 7.7% – 55.8% | 213 | 123,628 |
| 2021-22 | 42.1% | 44.1% | 18.8% – 66.8% | 214 | 126,244 |
| 2022-23 | 39.0% | 40.0% | 18.0% – 63.0% | 215 | 124,435 |
| 2023-24 | 38.1% | 39.6% | 17.0% – 62.5% | 216 | 124,034 |
| 2024-25 | 37.7% | 39.0% | 17.1% – 61.9% | 216 | 124,306 |
Rates are the share of students who attended less than 90% of school days. † 2020-21 was mostly virtual (hybrid from March 2021) and is excluded from trend statements. The district rate is student-weighted; the median and percentiles describe individual schools.
| Check | Our database | District's file | Difference | Match |
|---|---|---|---|---|
| common_weighted_2020-21 | 29.3657 | 29.3657 | 0 | ✓ |
| common_n_schools_2020-21 | 212 | 212 | 0 | ✓ |
| common_n_students_2020-21 | 122895 | 122895 | 0 | ✓ |
| common_weighted_2021-22 | 42.0446 | 42.0448 | -0.0002 | ✓ |
| common_n_schools_2021-22 | 213 | 213 | 0 | ✓ |
| common_n_students_2021-22 | 125830 | 125830 | 0 | ✓ |
| common_weighted_2022-23 | 39.0188 | 39.0188 | 0 | ✓ |
| common_n_schools_2022-23 | 215 | 215 | 0 | ✓ |
| common_n_students_2022-23 | 124435 | 124435 | 0 | ✓ |
| common_weighted_2023-24 | 38.1259 | 38.1258 | 0 | ✓ |
| common_n_schools_2023-24 | 216 | 216 | 0 | ✓ |
| common_n_students_2023-24 | 124034 | 124034 | 0 | ✓ |
| common_weighted_2024-25 | 37.7354 | 37.7351 | 0.0003 | ✓ |
| common_n_schools_2024-25 | 216 | 216 | 0 | ✓ |
| common_n_students_2024-25 | 124306 | 124306 | 0 | ✓ |
Every school behind this figure
The district's measure: share of each school's students attending less than 90% of days (100 minus the district's 90%+ figure). 2020-21 † was mostly virtual. Click any value for its full trace. 216 schools.