# (iii-a) SPREE spot check — same-publisher presentation cross-reference

Compares served DB values against SDP SPREE composite. Same-publisher

(both feed from SDP's data pipeline) — this is a presentation check, NOT

an independent oracle. For independent cross-publisher check, see

__cross_publisher_pssa.md.


## Summary
```json
{
  "spree_source": "sdp_spree_2023-24",
  "tolerance_abs": 1.5,
  "spree_rows_total": 76405,
  "spree_rows_mapped": 12980,
  "pairs_attempted": 12980,
  "null_in_spree": 8966,
  "not_in_db": 3398,
  "pairs_compared": 616,
  "matches_within_tol": 616,
  "mismatches": 0,
  "agreement_rate": 1.0,
  "mean_delta": -0.002,
  "median_delta": 0.0,
  "max_abs_delta": 0.05
}
```


## Worst 30 mismatches (by absolute delta)

- ULCS 1250 2023-24 pssa_all_ela_proficiency ALL: served=22.65 spree=22.70 Δ=-0.05
- ULCS 1290 2023-24 pssa_grade3_ela_proficiency ALL: served=19.05 spree=19.10 Δ=-0.05
- ULCS 1340 2023-24 pssa_all_ela_proficiency ALL: served=36.05 spree=36.10 Δ=-0.05
- ULCS 2190 2023-24 pssa_grade3_math_proficiency ALL: served=57.45 spree=57.50 Δ=-0.05
- ULCS 2370 2023-24 pssa_all_math_proficiency ALL: served=3.85 spree=3.90 Δ=-0.05
- ULCS 2380 2023-24 pssa_grade3_math_proficiency ALL: served=80.95 spree=81.00 Δ=-0.05
- ULCS 2390 2023-24 pssa_grade3_ela_proficiency ALL: served=48.15 spree=48.20 Δ=-0.05
- ULCS 2390 2023-24 pssa_all_math_proficiency ALL: served=15.25 spree=15.30 Δ=-0.05
- ULCS 2470 2023-24 pssa_all_ela_proficiency ALL: served=85.35 spree=85.40 Δ=-0.05
- ULCS 2470 2023-24 pssa_all_math_proficiency ALL: served=74.65 spree=74.70 Δ=-0.05
- ULCS 2470 2023-24 pssa_grade3_math_proficiency ALL: served=78.65 spree=78.70 Δ=-0.05
- ULCS 2480 2023-24 pssa_grade3_math_proficiency ALL: served=67.65 spree=67.70 Δ=-0.05
- ULCS 2490 2023-24 pssa_grade3_math_proficiency ALL: served=19.05 spree=19.10 Δ=-0.05
- ULCS 2580 2023-24 pssa_all_math_proficiency ALL: served=29.75 spree=29.80 Δ=-0.05
- ULCS 2640 2023-24 pssa_grade3_ela_proficiency ALL: served=29.55 spree=29.60 Δ=-0.05
- ULCS 4030 2023-24 pssa_all_math_proficiency ALL: served=46.75 spree=46.80 Δ=-0.05
- ULCS 4240 2023-24 pssa_all_math_proficiency ALL: served=6.15 spree=6.20 Δ=-0.05
- ULCS 4350 2023-24 pssa_all_math_proficiency ALL: served=3.15 spree=3.20 Δ=-0.05
- ULCS 4360 2023-24 pssa_all_ela_proficiency ALL: served=10.65 spree=10.70 Δ=-0.05
- ULCS 4440 2023-24 pssa_all_math_proficiency ALL: served=7.65 spree=7.70 Δ=-0.05
- ULCS 4520 2023-24 pssa_all_ela_proficiency ALL: served=11.55 spree=11.60 Δ=-0.05
- ULCS 4570 2023-24 pssa_all_ela_proficiency ALL: served=15.85 spree=15.90 Δ=-0.05
- ULCS 5210 2023-24 pssa_all_ela_proficiency ALL: served=32.55 spree=32.60 Δ=-0.05
- ULCS 5230 2023-24 pssa_all_math_proficiency ALL: served=13.45 spree=13.50 Δ=-0.05
- ULCS 5260 2023-24 pssa_all_ela_proficiency ALL: served=7.55 spree=7.60 Δ=-0.05
- ULCS 5300 2023-24 pssa_grade3_ela_proficiency ALL: served=54.55 spree=54.60 Δ=-0.05
- ULCS 5300 2023-24 pssa_grade3_math_proficiency ALL: served=51.85 spree=51.90 Δ=-0.05
- ULCS 5470 2023-24 pssa_all_ela_proficiency ALL: served=16.35 spree=16.40 Δ=-0.05
- ULCS 6310 2023-24 pssa_grade3_ela_proficiency ALL: served=45.45 spree=45.50 Δ=-0.05
- ULCS 6360 2023-24 pssa_all_ela_proficiency ALL: served=13.65 spree=13.70 Δ=-0.05