← All proof trees · STRAWBERRY MANSION HIGH SCHOOL

1. 1
   What you seeWithheld by the publisher

   The publisher suppressed this cell (too few students to report). The site stores it as suppressed and never as zero.

   vs. peers

   —

   vs. citywide

   —

   unit

   percent

   direction

   higher is better

2. 2
   How it was computedvalue = the state's published percentage for the school × subgroup, as-is

   1. Read the state's wide-format datafile: one row per Pennsylvania school, one column per measure × subgroup (e.g. PercentPersistentAttendance_Black).
   2. Keep Philadelphia rows by mapping the state's AUN + Schl codes to the district's ULCS code through the Master School List.
   3. Unpivot each recognized measure × subgroup column into one served cell; state suppression codes ('IS', '--', '*') are stored as suppressed.

   Note: stored percentiles are computed by a batch script after loads; a difference from the live reconstruction means a newer load changed the comparison set and the batch has not been re-run.

   Evidence: metric tree: Keystone Literature proficiency

3. 3
   The stored cellThe stored cell

   table

   philly_school_year_metrics

   value

   null

   denominator

   19

   suppressed

   true

   citywide_percentile

   null

   comparison_group_percentile

   null

   source_load_id

   96e07ea5-c26b-4f50-acf8-e159bd17d2e0

   Evidence: data model overview

4. 4
   The load that wrote itWritten on 2026-06-04 by sdp_pssa_keystone_2023-24.ts

   source id

   sdp_pssa_keystone_2023-24

   file URL

   https://cdn.philasd.org/offices/performance/Open_Data/School_Performance/PSSA_Keystone/2023_2024_PSSA_Keystone_All_Data.zip

   SHA-256 of the file read

   d89570e75caa9d30bd32f41de7a654b1df298e1a27a8bf6538f6dc4a6cfa9261Copy hash

   bytes

   802,929

   year covered

   2023-24

   code commit

   de835926d57d5e04d34ef3f4666df5b66fa57672

   To confirm you have the same file: download it from the URL above, then run shasum -a 256 <downloaded file> Copy command — the output should equal the hash above. If the publisher has since replaced the file, the hashes will differ, which is itself useful to know.

   Evidence: loader script · first-fetch findings for this file · source registry

5. 5
   The publisher's filePSSA & 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.
6. 6
   How it was checkedChecks: 0 passed, 1 not run

   • ○ not runBase case against the state file not yet run for this metric (the loader is shared with keystone_algebra_proficiency, whose SDP-side base case passed)
7. 7
   Assumptions & caveatsAssumptions and caveats

   • The state's AUN + Schl → ULCS mapping from the 2024-25 Master School List is correct. State rows for schools not in that directory — district schools that closed before 2024-25 — are not loaded, so every year of state data is a survivor-only panel; cyber charters have their own AUNs and are outside the district's directory.
   • Where two directory schools share a state code (a school and its Continuation Academy), the state's single row belongs to the main school (deterministic rule; the full absenteeism QA lists every shared code).

   • The state publishes no student counts for most measures, so served cells carry no denominator.
   • Served from both the district's and the state's files; check the cell's load record.

   Algorithms involved: Reading the state's wide-format datafile, Citywide and peer-group percentiles, Peer groups: 40 nearest neighbors on demographics