← All proof trees · GEORGE SHARSWOOD SCHOOL

1. 1
   What you see% Asian

   18.0%

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

   vs. peers

   78th percentile

   vs. citywide

   92th 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 302. Midrank rule: (302 + 0/2) / (330 − 1) = 0.918.Stored: 0.918. ✓ 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-Middle / catchment / district schools; 40 of 40 peers have a value this year. This school is above 31 of them. Midrank: (31 + 0/2) / (41 − 1) = 0.775; stored 0.775. ✓ matches

   The peers and their values (40)

   Peer school	Value
   GEN. GEORGE A. MCCALL SCHOOL	42.8%
   JOHN H. TAGGART SCHOOL	38.2%
   JOSEPH GREENBERG SCHOOL	37.4%
   D. NEWLIN FELL SCHOOL	35.3%
   MAYFAIR SCHOOL	24.9%
   LOUIS H. FARRELL SCHOOL	22.2%
   ELIZA B. KIRKBRIDE SCHOOL	20.2%
   ROBERT B. POLLOCK SCHOOL	19.5%
   SOUTHWARK SCHOOL	18.7%
   STEPHEN DECATUR SCHOOL	17.9%
   HENRY C. LEA SCHOOL	17.7%
   NORTHEAST COMMUNITY PROPEL ACADEMY	17.4%
   THOMAS HOLME SCHOOL	15.6%
   GEORGE W CHILDS SCHOOL	14.9%
   A.L. FITZPATRICK SCHOOL	14.7%
   HANCOCK DEMONSTRATION SCHOOL	14.5%
   AMEDEE F. BREGY SCHOOL	12.5%
   VARE-WASHINGTON ELEMENTARY	11.1%
   GILBERT SPRUANCE SCHOOL	10.6%
   OLNEY ELEMENTARY SCHOOL	10.2%
   ETHAN ALLEN SCHOOL	9.2%
   GEORGE W. NEBINGER SCHOOL	7.5%
   MARIAN ANDERSON NEIGHBORHOOD ACADEMY	6.5%
   H.A. BROWN ACADEMICS PLUS SCH	6.3%
   COPPIN, FANNY JACKSON SCHOOL	6.2%
   WILLIAM H. ZIEGLER SCHOOL	6.1%
   SHAWMONT SCHOOL	4.4%
   ALEXANDER ADAIRE SCHOOL	3.8%
   ANDREW J. MORRISON SCHOOL	3.7%
   J.H. BROWN ACADEMICS PLUS SCHL	3.4%
   BACHE-MARTIN SCHOOL	2.6%
   HAMILTON DISSTON SCHOOL	2.4%
   EDWIN M. STANTON SCHOOL	2.2%
   MIFFLIN, THOMAS SCHOOL	1.9%
   CHARLES W. HENRY SCHOOL	1.9%
   BRIDESBURG SCHOOL	1.9%
   COOK-WISSAHICKON SCHOOL	1.7%
   JAMES DOBSON SCHOOL	1.3%
   ALLEN M. STEARNE SCHOOL	80.2%
   WILLIAM MCKINLEY SCHOOL	35.1%

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

3. 3
   The stored cellThe stored cell

   table

   philly_school_year_metrics

   value

   17.9878048780488

   denominator

   null (not published)

   suppressed

   false

   citywide_percentile

   0.9179

   comparison_group_percentile

   0.7750

   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