← All proof trees

1. 1
   How it was computedvalue = 100 − published '% with Zero OS Suspensions'

   1. Read the district's suspensions CSV; keep directory schools and mapped subgroups.
   2. Derive the share with any suspension as 100 minus the published zero-suspension share.

   Algorithms applied downstream: Suspension shares derived from the published 0/1/2/3 columns, Citywide and peer-group percentiles, Peer groups: 40 nearest neighbors on demographics

2. 2
   The load that wrote it1 data load wrote this metric

   Loaded	Source file	Years	Cells	Suppressed	File hash	Commit
   2026-06-04	sdp_suspensions_school	2019-20, 2020-21, 2021-22, 2022-23, 2023-24, 2024-25	11,443	3,409	6eaa8e3907d8…	f75e3313

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

   Evidence: sdp_attendance_and_suspensions.ts

3. 3
   The publisher's fileOut-of-school suspensions, by school and year

   Out-of-school suspensions, by school and year — School District of Philadelphia (Performance Office). For each school and year, the share of students with 0, 1, 2, and 3 out-of-school suspensions, by subgroup.

   format

   CSV

   join key

   ULCS Code

   landing page

   https://opendataphilly.org/datasets/sdp-school-performance/

   • No published '4 or more' column — derived as a residual (see the suspensions algorithm).

   Evidence: source registry (sources.yaml) · sdp_suspensions_school: first-fetch findings

4. 4
   How it was checkedChecks: 1 passed

   • ✓ passedComputed-value check: 8,034 of 8,034 derived cells match an independent recomputation

   independent recomputation

   8034 of 8034 served cells match (0 mismatches)

   Evidence: Computed-value check

5. 5
   Assumptions & caveatsAssumptions and caveats

   Assumptions

   • The published percentages for 0/1/2/3 suspensions are of the same denominator ('Total Students (Yearly)').

   Caveats

   • District-run schools only.

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