← All proof trees · WILLIAM H. LOESCHE SCHOOL

1. 1
   What you seeOSS — % students with 4+ suspensions

   0.0%

   the share of a school's students with four or more out-of-school suspensions in the year (not a published column — derived). Based on 645 students. For this measure, lower is better — percentiles below are flipped so that a high percentile is always the good outcome.

   vs. peers

   54th percentile

   vs. citywide

   61th percentile

   unit

   percent

   direction

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

2. 2
   How it was computedvalue = max(0, 100 − (%0 + %1 + %2 + %3 suspensions))

   1. Read the suspensions CSV.
   2. Derive the residual share not covered by the published 0/1/2/3 columns.

   Citywide percentile, reconstructed right now

   Among 108 default-included schools with a value for this metric, year, and subgroup, this school has a better (lower) value than 23 and ties 84. Midrank rule: (23 + 84/2) / (108 − 1) = 0.607.Stored: 0.607. ✓ matches

   How percentiles are computed · How peer groups are chosen

   Peer percentile, reconstructed right now

   Peer group: up to 40 of the demographically nearest schools among Elementary / catchment / district schools; 23 of 40 peers have a value this year. This school beats 2 and ties 21 of them. Midrank: (2 + 21/2) / (24 − 1) = 0.543; stored 0.543. ✓ matches

   The peers and their values (23)

   Peer school	Value
   STEPHEN GIRARD SCHOOL	0.0%
   A.S. JENKS ACADEMICS PLUS SCH	0.0%
   FRANCIS SCOTT KEY SCHOOL	0.0%
   JOHN MOFFET SCHOOL	0.0%
   LEWIS ELKIN SCHOOL	0.0%
   GLORIA CASAREZ ELEMENTARY SCHOOL	0.0%
   HENRY W. LAWTON SCHOOL	0.0%
   SOLOMON SOLIS-COHEN SCHOOL	0.0%
   ANNE FRANK SCHOOL	0.0%
   KENNEDY C. CROSSAN SCHOOL	0.0%
   J. HAMPTON MOORE SCHOOL	0.0%
   CLARA BARTON SCHOOL	0.0%
   FRANCES E. WILLARD SCHOOL	0.0%
   LAURA H. CARNELL SCHOOL	0.0%
   WATSON COMLY SCHOOL	0.0%
   FOX CHASE SCHOOL	0.0%
   JOHN H. WEBSTER SCHOOL	0.0%
   RHAWNHURST SCHOOL	0.0%
   EDWIN FORREST SCHOOL	0.0%
   HACKETT SCHOOL	0.0%
   SAMUEL POWEL SCHOOL	0.0%
   RICHMOND SCHOOL	83.0%
   JAMES J. SULLIVAN SCHOOL	2.2%

   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 4+ suspensions

3. 3
   The stored cellThe stored cell

   table

   philly_school_year_metrics

   value

   0

   denominator

   645

   suppressed

   false

   citywide_percentile

   0.6075

   comparison_group_percentile

   0.5435

   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 residual is entirely students with 4+ suspensions; rounding of the four published shares makes small residuals uncertain to about ±0.2 percent.

   • Derived, not published; small values are rounding-sensitive.
   • 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