(iv) Computed-value validation — Philly

Re-derives the computed metrics from the validated raw source and compares

to the served DB. Tolerance: ±0.5 pp.

OSS — oss_pct_any

{
  "name": "OSS \u2014 oss_pct_any",
  "expected_total": 11470,
  "served_total": 8034,
  "common_keys": 8034,
  "expected_null_in_common": 0,
  "matches": 8034,
  "mismatches": 0,
  "expected_only": 3436,
  "served_only": 0,
  "agreement_rate": 1.0,
  "worst_diffs_top10": []
}

OSS — oss_pct_multiple

{
  "name": "OSS \u2014 oss_pct_multiple",
  "expected_total": 11470,
  "served_total": 8034,
  "common_keys": 8034,
  "expected_null_in_common": 0,
  "matches": 8034,
  "mismatches": 0,
  "expected_only": 3436,
  "served_only": 0,
  "agreement_rate": 1.0,
  "worst_diffs_top10": []
}

OSS — oss_pct_chronic

{
  "name": "OSS \u2014 oss_pct_chronic",
  "expected_total": 11470,
  "served_total": 8034,
  "common_keys": 8034,
  "expected_null_in_common": 0,
  "matches": 8034,
  "mismatches": 0,
  "expected_only": 3436,
  "served_only": 0,
  "agreement_rate": 1.0,
  "worst_diffs_top10": []
}

PSES topic rollups (teacher + student × 6 topics)

{
  "name": "PSES topic rollups (teacher + student \u00d7 6 topics)",
  "expected_total": 8219,
  "served_total": 8157,
  "common_keys": 8157,
  "expected_null_in_common": 0,
  "matches": 8157,
  "mismatches": 0,
  "expected_only": 62,
  "served_only": 0,
  "agreement_rate": 1.0,
  "worst_diffs_top10": []
}

Demographic shares (aggregated from grade rows)

{
  "name": "Demographic shares (aggregated from grade rows)",
  "expected_total": 4290,
  "served_total": 4127,
  "common_keys": 4127,
  "expected_null_in_common": 0,
  "matches": 3879,
  "mismatches": 248,
  "expected_only": 163,
  "served_only": 0,
  "agreement_rate": 0.9399,
  "worst_diffs_top10": [
    {
      "key": [
        "4380",
        "2024-25",
        "pct_econ_disadv"
      ],
      "expected": NaN,
      "served": 100.0,
      "delta": NaN
    },
    {
      "key": [
        "5590",
        "2024-25",
        "pct_econ_disadv"
      ],
      "expected": NaN,
      "served": 100.0,
      "delta": NaN
    },
    {
      "key": [
        "2380",
        "2024-25",
        "pct_econ_disadv"
      ],
      "expected": NaN,
      "served": 22.73,
      "delta": NaN
    },
    {
      "key": [
        "5300",
        "2024-25",
        "pct_econ_disadv"
      ],
      "expected": NaN,
      "served": 88.74,
      "delta": NaN
    },
    {
      "key": [
        "5581",
        "2024-25",
        "pct_econ_disadv"
      ],
      "expected": NaN,
      "served": 80.0,
      "delta": NaN
    },
    {
      "key": [
        "5320",
        "2024-25",
        "pct_econ_disadv"
      ],
      "expected": NaN,
      "served": 100.0,
      "delta": NaN
    },
    {
      "key": [
        "3810",
        "2024-25",
        "pct_econ_disadv"
      ],
      "expected": NaN,
      "served": 0.0,
      "delta": NaN
    },
    {
      "key": [
        "1100",
        "2024-25",
        "pct_econ_disadv"
      ],
      "expected": NaN,
      "served": 100.0,
      "delta": NaN
    },
    {
      "key": [
        "1050",
        "2024-25",
        "pct_econ_disadv"
      ],
      "expected": NaN,
      "served": 100.0,
      "delta": NaN
    },
    {
      "key": [
        "5150",
        "2024-25",
        "pct_econ_disadv"
      ],
      "expected": NaN,
      "served": 100.0,
      "delta": NaN
    }
  ]
}