← All proof trees · ALEXANDER ADAIRE SCHOOL

1. 1
   What you seeAttendance ≥90% rate

   88.8%

   the share of a school's students who attended at least 90% of the days they were enrolled, as published by the district. 100 minus this number is the site's chronic-absenteeism proxy. Based on 188 students.

   vs. peers

   90th percentile

   vs. citywide

   96th percentile

   unit

   percent

   direction

   higher is better

2. 2
   How it was computedvalue = published '% with 90%+ Attendance (Yearly)'; denominator = published 'Total Students (Yearly)'

   1. Read the district's school-level attendance CSV.
   2. Keep rows for district-run schools in the directory; map the file's Category/Group columns to subgroups (all students, race/ethnicity, gender). Grade-level rows are not stored.
   3. Store the published percentage and student count; suppressed cells are flagged, not zeroed.

   Citywide percentile, reconstructed right now

   Among 198 default-included schools with a value for this metric, year, and subgroup, this school has a higher value than 190. Midrank rule: (190 + 0/2) / (198 − 1) = 0.964.Stored: 0.964. ✓ 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; 39 of 40 peers have a value this year. This school is above 35 of them. Midrank: (35 + 0/2) / (40 − 1) = 0.897; stored 0.897. ✓ matches

   The peers and their values (39)

   Peer school	Value
   PENN ALEXANDER SCHOOL	96.7%
   ALBERT M. GREENFIELD SCHOOL	90.2%
   JOSEPH GREENBERG SCHOOL	89.5%
   GEN. GEORGE A. MCCALL SCHOOL	89.2%
   ELIZA B. KIRKBRIDE SCHOOL	87.0%
   COPPIN, FANNY JACKSON SCHOOL	85.5%
   GEORGE W. NEBINGER SCHOOL	83.5%
   MARIAN ANDERSON NEIGHBORHOOD ACADEMY	83.2%
   CHARLES W. HENRY SCHOOL	82.1%
   HENRY H. HOUSTON SCHOOL	79.5%
   VARE-WASHINGTON ELEMENTARY	76.5%
   JAMES DOBSON SCHOOL	76.2%
   MAYFAIR SCHOOL	74.4%
   STEPHEN DECATUR SCHOOL	73.3%
   HANCOCK DEMONSTRATION SCHOOL	72.5%
   EDWIN M. STANTON SCHOOL	72.0%
   COOK-WISSAHICKON SCHOOL	71.2%
   SHAWMONT SCHOOL	71.1%
   THOMAS HOLME SCHOOL	70.6%
   HENRY C. LEA SCHOOL	70.0%
   BACHE-MARTIN SCHOOL	69.7%
   LOUIS H. FARRELL SCHOOL	69.3%
   GILBERT SPRUANCE SCHOOL	67.7%
   D. NEWLIN FELL SCHOOL	65.9%
   J.H. BROWN ACADEMICS PLUS SCHL	64.0%
   A.L. FITZPATRICK SCHOOL	63.3%
   MIFFLIN, THOMAS SCHOOL	62.8%
   NORTHEAST COMMUNITY PROPEL ACADEMY	61.7%
   H.A. BROWN ACADEMICS PLUS SCH	61.3%
   ETHAN ALLEN SCHOOL	60.9%
   GEORGE W CHILDS SCHOOL	60.3%
   BRIDESBURG SCHOOL	59.4%
   GEORGE SHARSWOOD SCHOOL	59.3%
   WILLIAM H. ZIEGLER SCHOOL	59.1%
   HAMILTON DISSTON SCHOOL	57.2%
   ROBERT B. POLLOCK SCHOOL	54.2%
   AMEDEE F. BREGY SCHOOL	50.4%
   ALLEN M. STEARNE SCHOOL	49.2%
   LAURA W. WARING SCHOOL	41.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: Attendance ≥90% rate

3. 3
   The stored cellThe stored cell

   table

   philly_school_year_metrics

   value

   88.83

   denominator

   188

   suppressed

   false

   citywide_percentile

   0.9645

   comparison_group_percentile

   0.8974

   source_load_id

   af82e240-a218-4af8-9ddf-31f8ad10d932

   Evidence: data model overview

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

   source id

   sdp_attendance_90_school

   file URL

   https://cdn.philasd.org/offices/performance/Open_Data/School_Performance/Attendance/Student_Attendance_90_School_20260203.csv

   SHA-256 of the file read

   552bf3bd6d53517b0f72e8b023d40e3fdeafc218abe854e6bd1bf25ac5d01e87Copy hash

   bytes

   1,396,410

   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 fileStudent attendance — % with 90%+ attendance, by school and year

   School District of Philadelphia (Performance Office). For each school and year, the number and share of students who attended at least 90% of their enrolled days, for all students and by grade, race/ethnicity, and gender. District-run schools only.

   format

   CSV

   join key

   ULCS Code

   landing page

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

   • District sector only — no charter, cyber, contracted, or alternative schools.
   • Small groups are suppressed; from 2021-22 one of Male/Female is also suppressed wherever Non-Binary is, including at large high schools.
   • Denominator ('Total Students (Yearly)') counts students enrolled at least 10 days at the school; a student enrolled 10+ days at two schools is counted at each (SDP, Student Attendance Patterns in Philadelphia 2017-18 to 2021-22, June 2023). Summed across schools it is a count of student records, not distinct students.
6. 6
   How it was checkedChecks: 3 passed, 1 flagged

   • ✓ passedBase case: 216 of 216 served 2024-25 cells match an independent re-read of the file
   • ✓ passedCompleteness: every source cell is served for directory schools
   • ⚠ flaggedCross-publisher vs the state's Regular Attendance figure for the same schools and attendance year: closely correlated, not interchangeable (median and per-year values in the report)
   • ✓ passedFull QA: every served cell (value and student count), every year and subgroup, matches a re-read of the district file

   Checked at ±0.5: 0 mismatches, 0 cells served but absent from the file, 0 in the file but not served (ALL, n/a, latest year).

   Evidence: Base case · Completeness · Cross-publisher vs the state's Regular Attendance figure for the same schools and attendance year · Full QA

7. 7
   Assumptions & caveatsAssumptions and caveats

   • '90%+ attendance' is read as the complement of chronic absenteeism: attending less than 90% of enrolled days. A student at exactly 90% is in the 90%+ group (and so outside the below-90 share) but chronically absent under the federal 'missed 10% or more' definition; the district does not document rounding at that boundary.
   • Minimum enrollment: 10 days at the school, with transfers attributed to each qualifying school (SDP, June 2023 attendance report).

   • District-run schools only.
   • Schools closed before 2024-25 are absent from the served table (their rows exist in the source file and are included in the working-analysis packet).

   Algorithms involved: Chronic absenteeism as 100 minus the 90%-attendance share, Citywide and peer-group percentiles, Peer groups: 40 nearest neighbors on demographics