← All proof trees

1. 1
   How it was computedvalue = published '% proficient or advanced' (accountability cohort by default)

   1. Unzip the district's PSSA/Keystone archive and read the accountability-cohort ('Acct') and all-tested ('Actual') school CSVs.
   2. Keep rows for the test, subject, grade, and subgroup this metric represents.
   3. Store the published '% proficient or advanced' as the value and the published number tested as the denominator; suppressed cells (asterisks/blanks) are stored as suppressed, not zero.
   4. Store the accountability-cohort cut as the default (population_cut = 'acct') and the all-tested cut alongside it ('actual').

   Algorithms applied downstream: Citywide and peer-group percentiles, Peer groups: 40 nearest neighbors on demographics

2. 2
   The load that wrote it2 data loads wrote this metric

   Loaded	Source file	Years	Cells	Suppressed	File hash	Commit
   2026-06-04	sdp_pssa_keystone_2023-24	2023-24	756	278	d89570e75caa…	de835926
   2026-06-03	sdp_pssa_keystone_2024-25	2024-25	756	316	d040e16c1b88…	63ddc08c

   The hash identifies the exact file version read; the commit identifies the exact code. Both are recorded at load time.

   Evidence: sdp_pssa_keystone_2023-24.ts · sdp_pssa_keystone.ts

3. 3
   The publisher's file2 publisher files

   PSSA & Keystone results, 2023-24 — School District of Philadelphia (Performance Office). Same structure as the 2024-25 file, one year earlier.

   format

   ZIP of CSVs

   join key

   id_eos (= ULCS Code)

   landing page

   https://opendataphilly.org/datasets/sdp-pssa-keystone-performance/

   • Same as the 2024-25 file.

   PSSA & Keystone results, 2024-25 — School District of Philadelphia (Performance Office). State test results by school, test, subject, grade, and subgroup: counts and shares at each performance level, in two population cuts — the accountability cohort (students enrolled for the full year) and all tested students.

   format

   ZIP of CSVs (accountability-cohort and all-tested cuts)

   join key

   id_eos (= ULCS Code)

   landing page

   https://opendataphilly.org/datasets/sdp-pssa-keystone-performance/

   • Two cuts of the same results; the accountability cohort is the canonical one served by default.
   • District-run and alternative schools only; charter results come from the state's Future Ready file.

   Evidence: source registry (sources.yaml) · sdp_pssa_keystone_2023-24: first-fetch findings · sdp_pssa_keystone_2024-25: first-fetch findings

4. 4
   How it was checkedChecks: 0 passed, 2 flagged, 1 not run

   • ○ not runBase case not run for this grade/subject specifically (run for the all-grades aggregates and grade 3 ELA; same loader and file)
   • ⚠ flaggedAccountability-cohort vs all-tested files are byte-identical after sorting in SDP's 2024-25 archive — a publisher defect, so this check cannot distinguish the two populations
   • ⚠ flaggedCross-publisher sanity check vs the state's Keystone results

   Evidence: Accountability-cohort vs all-tested files are byte-identical after sorting in SDP's 2024-25 archive — a publisher defect, so this check cannot distinguish the two populations · Cross-publisher sanity check vs the state's Keystone results

5. 5
   Assumptions & caveatsAssumptions and caveats

   Assumptions

   • The accountability cohort (students enrolled for the full year) is the intended canonical population. However, the two files SDP publishes for 2024-25 ('Acct' and 'Actual') are identical once sorted — 28,525 rows with no differing value or denominator — so the served 'acct' and 'actual' cuts carry the same numbers. We treat this as a publisher defect (one file published under two names) and cannot say which population the numbers describe.

   Caveats

   • District-run and alternative schools only from this file; charter schools' Keystone results come from the state's Future Ready file.

To see the tree for one school’s number, click any dotted-underlined figure on a school, Outliers, or Movers page.