← All proof trees

1. 1
   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.

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

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

   Loaded	Source file	Years	Cells	Suppressed	File hash	Commit
   2026-09-08	futurereadypa_performance_2024-25	2024-25	3,576	1,639	a16ffc40e7d1…	c19ea6ec
   2026-09-08	futurereadypa_performance_2023-24	2023-24	3,576	1,658	89219f7a7ffb…	c19ea6ec
   2026-09-08	futurereadypa_performance_2022-23	2022-23	3,564	1,643	81fdf381405c…	c19ea6ec
   2026-09-08	futurereadypa_performance_2021-22	2021-22	3,528	1,624	4efe1b1b120f…	c19ea6ec
   2026-06-04	sdp_pssa_keystone_2023-24	2023-24	338	44	d89570e75caa…	de835926
   2026-06-03	sdp_pssa_keystone_2024-25	2024-25	334	40	d040e16c1b88…	63ddc08c

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

   Evidence: futurereadypa_performance.ts · sdp_pssa_keystone_2023-24.ts · sdp_pssa_keystone.ts

3. 3
   The publisher's file6 publisher files

   Future Ready PA Index datafile, 2024-25 — Pennsylvania Department of Education (Future Ready PA Index). The state's school-level accountability indicators for every public school in Pennsylvania — test proficiency, growth (PVAAS), persistent attendance, graduation — by subgroup.

   format

   XLSX (wide: one column per measure × subgroup)

   join key

   AUN + Schl (state IDs), mapped to ULCS via the Master School List

   landing page

   https://futurereadypa.org/Home/DataFiles

   • The chronic-absenteeism column exists in the file but is empty for individual Philadelphia schools; the state reports persistent attendance instead.
   • Publishes no student counts for the attendance measure.
   • Its 90%-attendance figure does not match the district's for the same schools (see the cross-publisher check).

   Future Ready PA Index datafile, 2023-24 — Pennsylvania Department of Education (Future Ready PA Index). Same structure as the 2024-25 file.

   format

   XLSX (wide)

   join key

   AUN + Schl → ULCS

   landing page

   https://futurereadypa.org/Home/DataFiles

   • Same as 2024-25.

   Future Ready PA Index datafile, 2022-23 — Pennsylvania Department of Education (Future Ready PA Index). Same structure as the 2024-25 file.

   format

   XLSX (wide)

   join key

   AUN + Schl → ULCS

   landing page

   https://futurereadypa.org/Home/DataFiles

   • Same as 2024-25.

   Future Ready PA Index datafile, 2021-22 — Pennsylvania Department of Education (Future Ready PA Index). Same structure as the 2024-25 file.

   format

   XLSX (wide)

   join key

   AUN + Schl → ULCS

   landing page

   https://futurereadypa.org/Home/DataFiles

   • Same as 2024-25.

   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) · futurereadypa_performance_2024-25: first-fetch findings · futurereadypa_performance_2023-24: first-fetch findings · futurereadypa_performance_2022-23: first-fetch findings · futurereadypa_performance_2021-22: first-fetch findings · sdp_pssa_keystone_2023-24: first-fetch findings · sdp_pssa_keystone_2024-25: first-fetch findings

4. 4
   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)
5. 5
   Assumptions & caveatsAssumptions and caveats

   Assumptions

   • 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).

   Caveats

   • 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.

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