← All proof trees · ROXBOROUGH HIGH SCHOOL

1. 1
   What you see6-year cohort graduation rate

   69.9%

   the six-year cohort graduation rate (district file). Based on 123 students.

   vs. peers

   47th percentile

   vs. citywide

   29th percentile

   unit

   percent

   direction

   higher is better

2. 2
   How it was computedvalue = published 6-year cohort graduation rate, by cohort entry year

   1. Read the district's graduation CSV and store the 6-year rate by cohort year.

   Citywide percentile, reconstructed right now

   Among 46 default-included schools with a value for this metric, year, and subgroup, this school has a higher value than 13. Midrank rule: (13 + 0/2) / (46 − 1) = 0.289.Stored: 0.289. ✓ 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 High / catchment / district schools; 15 of 20 peers have a value this year. This school is above 7 of them. Midrank: (7 + 0/2) / (16 − 1) = 0.467; stored 0.467. ✓ matches

   The peers and their values (15)

   Peer school	Value
   GEORGE WASHINGTON HIGH SCHOOL	82.3%
   HORACE FURNESS HIGH SCHOOL	80.2%
   NORTHEAST HIGH SCHOOL	79.1%
   SAMUEL S. FELS HIGH SCHOOL	77.6%
   ABRAHAM LINCOLN HIGH SCHOOL	74.8%
   SOUTH PHILADELPHIA HIGH SCHOOL	74.0%
   WEST PHILADELPHIA HIGH SCHOOL	71.8%
   BENJAMIN FRANKLIN HIGH SCHOOL	71.5%
   JOHN BARTRAM HIGH SCHOOL	68.8%
   MARTIN L. KING HIGH SCHOOL	65.7%
   OVERBROOK HIGH SCHOOL	62.8%
   FRANKFORD HIGH SCHOOL	60.9%
   SAYRE HIGH SCHOOL	56.6%
   THOMAS EDISON HIGH SCHOOL	52.3%
   STRAWBERRY MANSION HIGH SCHOOL	42.9%

   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: 6-year cohort graduation rate

3. 3
   The stored cellThe stored cell

   table

   philly_school_year_metrics

   value

   69.92

   denominator

   123

   suppressed

   false

   citywide_percentile

   0.2889

   comparison_group_percentile

   0.4667

   source_load_id

   8ecdf1ea-7780-4200-bd21-8e8d089c99f1

   Evidence: data model overview

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

   source id

   sdp_graduation_school_2014-2025

   file URL

   https://cdn.philasd.org/offices/performance/Open_Data/School_Performance/Graduation_Rates/OD_SDP_Graduation_Rates_School_S_2026-02-12.csv

   SHA-256 of the file read

   8ae3969118c3a9f01e4d8d04aa634855571ab71e914f3d2b689ad811d5639225Copy hash

   bytes

   3,919,459

   year covered

   2010-11..2021-22

   year of this cell

   2011-12 — this measure is stored under a different year than the file's report year; see the metric page

   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 fileGraduation rates by cohort, 4/5/6-year

   School District of Philadelphia (Performance Office). Four-, five-, and six-year cohort graduation rates by school and subgroup, indexed by the cohort's 9th-grade entry year.

   format

   CSV

   join key

   ULCS Code

   landing page

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

   • Indexed by cohort start year, not graduation year; the state's Future Ready file indexes the same rate by report year.
6. 6
   How it was checkedChecks: 0 passed, 1 not run

   • ○ not runSame file and loader as graduation_rate_4yr (base case passed); not separately reconciled
7. 7
   Assumptions & caveatsAssumptions and caveats

   Stored as published; no modeling assumptions.

   • District-run schools only.

   Algorithms involved: Citywide and peer-group percentiles, Peer groups: 40 nearest neighbors on demographics