← All proof trees · JOHN BARTRAM HIGH SCHOOL

1. 1
   What you see% White

   84.9%

   the share of the school's students who are White.

   vs. peers

   15th percentile

   vs. citywide

   28th percentile

   unit

   percent

   direction

   neither direction is 'better'

2. 2
   How it was computedvalue = 100 × Σ group count / Σ enrollment across the school's grade rows

   1. Read the district's enrollment file (one row per school × grade).
   2. Sum counts across grades to the school level.
   3. Divide the group count by total enrollment to get a share; storing shares re-derived from counts (rather than averaging per-grade percentages) weights grades by their size.

   Citywide percentile, reconstructed right now

   Among 330 default-included schools with a value for this metric, year, and subgroup, this school has a higher value than 92. Midrank rule: (92 + 0/2) / (330 − 1) = 0.280.Stored: 0.280. ✓ 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; 20 of 20 peers have a value this year. This school is above 3 of them. Midrank: (3 + 0/2) / (21 − 1) = 0.150; stored 0.150. ✓ matches

   The peers and their values (20)

   Peer school	Value
   GEORGE WASHINGTON HIGH SCHOOL	28.4%
   ABRAHAM LINCOLN HIGH SCHOOL	15.0%
   NORTHEAST HIGH SCHOOL	14.5%
   KENSINGTON HEALTH SCIENCES	8.1%
   KENSINGTON HIGH SCHOOL	7.4%
   HORACE FURNESS HIGH SCHOOL	7.1%
   SOUTH PHILADELPHIA HIGH SCHOOL	6.6%
   KENSINGTON CAPA	5.7%
   FRANKFORD HIGH SCHOOL	5.6%
   ROXBOROUGH HIGH SCHOOL	3.9%
   SAMUEL S. FELS HIGH SCHOOL	3.1%
   BENJAMIN FRANKLIN HIGH SCHOOL	1.6%
   THOMAS EDISON HIGH SCHOOL	1.3%
   MARTIN L. KING HIGH SCHOOL	1.1%
   STRAWBERRY MANSION HIGH SCHOOL	97.7%
   OVERBROOK HIGH SCHOOL	90.7%
   OLNEY HIGH SCHOOL	87.1%
   VAUX BIG PICTURE HIGH SCHOOL	69.7%
   WEST PHILADELPHIA HIGH SCHOOL	69.5%
   SAYRE HIGH SCHOOL	44.7%

   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: % White

3. 3
   The stored cellThe stored cell

   table

   philly_school_year_metrics

   value

   0.848896434634975

   denominator

   null (not published)

   suppressed

   false

   citywide_percentile

   0.2796

   comparison_group_percentile

   0.1500

   source_load_id

   f4c317af-16df-4cfe-8454-7b9361cd81cd

   Evidence: data model overview

4. 4
   The load that wrote itWritten on 2026-06-03 by sdp_enrollment_demographics.ts

   source id

   sdp_enrollment_demographics_school_2024-25

   file URL

   https://cdn.philasd.org/offices/performance/Open_Data/School_Information/Enrollment_Demographics_School/2024-2025%20Enrollment%20&%20Demographics.csv

   SHA-256 of the file read

   80f169f31c3e31f7f7a4d84138a46caa45f9b16162208c5b02784349fb2f133dCopy hash

   bytes

   492,606

   year covered

   2024-25

   code commit

   63ddc08c2a63170cecb6e78b991559cef9aa3926

   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 fileEnrollment & Demographics, 2024-25

   School District of Philadelphia. October 1 enrollment counts by school and grade, with counts by race/ethnicity, gender, economic disadvantage, English-learner status, and special education.

   format

   CSV (one row per school × grade)

   join key

   ULCS Code

   landing page

   https://opendataphilly.org/datasets/sdp-school-enrollment-and-demographics/

   • Economic disadvantage is recorded as 100% at most district schools (community-eligibility meal reporting), so it can't distinguish schools.
6. 6
   How it was checkedChecks: 0 passed, 1 not run

   • ○ not runNo base-case report yet for demographics (aggregation is arithmetic on published counts; see the algorithm page)
7. 7
   Assumptions & caveatsAssumptions and caveats

   • October 1 enrollment is the reference population for the whole school year.

   • 2024-25 only.

   Algorithms involved: School demographic shares from per-grade counts