← All proof trees · ANDREW HAMILTON 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

   lower is better (percentiles are flipped so a high percentile is always good)

2. 2
   How it was computedvalue = published % with 2 + published % with 3 + derived % with 4+ (where 4+ = 100 − (%0 + %1 + %2 + %3), floored at 0)

   1. Read the suspensions CSV.
   2. Derive the unpublished '4 or more' share as the residual of the published 0/1/2/3 shares.
   3. Sum the 2, 3, and 4+ shares.

   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: OSS — % students with 2+ suspensions

3. 3
   The stored cellThe stored cell

   table

   philly_school_year_metrics

   value

   null

   denominator

   1

   suppressed

   true

   citywide_percentile

   null

   comparison_group_percentile

   null

   source_load_id

   9ed07178-853d-4052-aa83-1bfe11ce1d24

   Evidence: data model overview

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

   source id

   sdp_suspensions_school

   file URL

   https://cdn.philasd.org/offices/performance/Open_Data/School_Performance/Suspensions/SDP_OSS_School_S_20260213.csv

   SHA-256 of the file read

   6eaa8e3907d80e2572464dbcef793fafb312567cdfa120f3a4820f08fca517c4Copy hash

   bytes

   2,057,896

   year covered

   —

   code commit

   f75e33137e8166eec3f8b5a4b39463d306ef710c

   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 fileOut-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).
6. 6
   How it was checkedChecks: 1 passed

   • ✓ passedComputed-value check: derived cells match an independent recomputation

   Evidence: Computed-value check

7. 7
   Assumptions & caveatsAssumptions and caveats

   • The 0/1/2/3 shares are exhaustive and sum to at most 100; small negative residuals from rounding are floored at 0.

   • District-run schools only.

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