PhiladelphiaProof trees
Where every Philadelphia number comes from
Every value and percentile in the Outliers and Movers tables, every value in a school page’s outcomes, climate and demographics tables, and every figure in the chronic-absenteeism working analysis links to a proof tree: which publisher file the number came from, which version of it (by cryptographic hash), which script read it, what arithmetic was applied, what assumptions that involved, and which checks it passed. Numbers with a dotted underline are the links. A school page’s enrollment, capacity and utilization section is not linked number by number; its four measures have metric trees below, under Access. Story ideas are not yet linked number-by-number; each carries a replication recipe instead. This page indexes the trees by metric, algorithm, and working-analysis statistic.
The trees combine two kinds of record: the factual lineage (file hashes, scripts, commits) read live from the site’s database, and the plain-language explanation of each computation and its assumptions, maintained alongside the code. Everything linked is served on this site from the project repository.
Metrics
Academic performance
- 4-year cohort graduation rate — The four-year cohort graduation rate: the share of a 9th-grade entry cohort that graduated within four years.
- 5-year cohort graduation rate — The five-year cohort graduation rate (district file).
- 6-year cohort graduation rate — The six-year cohort graduation rate (district file).
- Keystone Algebra I proficiency — The share of students scoring proficient or advanced on the Keystone Algebra I end-of-course exam.
- Keystone Biology proficiency — The share of students scoring proficient or advanced on the Keystone Biology exam.
- Keystone Literature proficiency — The share of students scoring proficient or advanced on the Keystone Literature exam.
- PSSA ELA proficiency (all tested grades) — The share of tested students in grades 3–8 scoring proficient or advanced on the PSSA English language arts test.
- PSSA MATH proficiency (all tested grades) — The share of tested students in grades 3–8 scoring proficient or advanced on the PSSA math test.
- 3rd grade ELA proficiency (PSSA) — The share of tested grade-3 students scoring proficient or advanced on the PSSA English language arts test.
- 3rd grade MATH proficiency (PSSA) — The share of tested grade-3 students scoring proficient or advanced on the PSSA math test.
- 4th grade ELA proficiency (PSSA) — The share of tested grade-4 students scoring proficient or advanced on the PSSA English language arts test.
- 4th grade MATH proficiency (PSSA) — The share of tested grade-4 students scoring proficient or advanced on the PSSA math test.
- 5th grade ELA proficiency (PSSA) — The share of tested grade-5 students scoring proficient or advanced on the PSSA English language arts test.
- 5th grade MATH proficiency (PSSA) — The share of tested grade-5 students scoring proficient or advanced on the PSSA math test.
- 6th grade ELA proficiency (PSSA) — The share of tested grade-6 students scoring proficient or advanced on the PSSA English language arts test.
- 6th grade MATH proficiency (PSSA) — The share of tested grade-6 students scoring proficient or advanced on the PSSA math test.
- 7th grade ELA proficiency (PSSA) — The share of tested grade-7 students scoring proficient or advanced on the PSSA English language arts test.
- 7th grade MATH proficiency (PSSA) — The share of tested grade-7 students scoring proficient or advanced on the PSSA math test.
- 8th grade ELA proficiency (PSSA) — The share of tested grade-8 students scoring proficient or advanced on the PSSA English language arts test.
- 8th grade MATH proficiency (PSSA) — The share of tested grade-8 students scoring proficient or advanced on the PSSA math test.
- PVAAS growth — ELA/Literature — The state's PVAAS growth index for English/literature — whether the school's students grew as much as expected (the state's value-added score, on its own scale).
- PVAAS growth — Algebra I — The state's PVAAS growth index for math/Algebra I.
- PVAAS growth — Science/Biology — The state's PVAAS growth index for science/biology.
Attendance, discipline, and climate
- Regular attendance rate (state) — The state's 'Regular Attendance' indicator: the share of a school's students, among those enrolled 90 or more school days, who attended 90% or more of them (the column is named PercentPersistentAttendance in the 2021-22 and later workbooks). Published for every public school, including charters. The year shown is the year the students were in school: the state calls this a lagging indicator, so its 2024-25 workbook reports 2023-24 attendance.
- Attendance ≥90% rate — 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.
- Average daily attendance — The school's year-to-date average daily attendance rate — the share of enrolled student-days actually attended.
- Chronic absenteeism rate — Intended to hold the state's chronic-absenteeism rate; the column is empty for individual Philadelphia schools in the state file, so no cells are served and the metric is hidden from dropdowns.
- OSS — % students with any suspension — The share of a school's students with at least one out-of-school suspension in the year.
- OSS — % students with 4+ suspensions — The share of a school's students with four or more out-of-school suspensions in the year (not a published column — derived).
- OSS — % students with 2+ suspensions — The share of a school's students with two or more out-of-school suspensions in the year.
- PSES student — dei — The student score for the 'Diversity, Equity, and Inclusion' topic of the Philly School Experience Survey — the average of the topic's subtopic scores, on the survey's 0–100 scale.
- PSES student — family engagement — The student score for the 'Family Engagement' topic of the Philly School Experience Survey — the average of the topic's subtopic scores, on the survey's 0–100 scale.
- PSES student — instructional environment — The student score for the 'Instructional Environment' topic of the Philly School Experience Survey — the average of the topic's subtopic scores, on the survey's 0–100 scale.
- PSES student — professional capacity — The student score for the 'Professional Capacity' topic of the Philly School Experience Survey — the average of the topic's subtopic scores, on the survey's 0–100 scale.
- PSES student — school climate — The student score for the 'School Climate' topic of the Philly School Experience Survey — the average of the topic's subtopic scores, on the survey's 0–100 scale.
- PSES student — school leadership — The student score for the 'School Leadership' topic of the Philly School Experience Survey — the average of the topic's subtopic scores, on the survey's 0–100 scale.
- PSES teacher — dei — The teacher score for the 'Diversity, Equity, and Inclusion' topic of the Philly School Experience Survey — the average of the topic's subtopic scores, on the survey's 0–100 scale.
- PSES teacher — family engagement — The teacher score for the 'Family Engagement' topic of the Philly School Experience Survey — the average of the topic's subtopic scores, on the survey's 0–100 scale.
- PSES teacher — instructional environment — The teacher score for the 'Instructional Environment' topic of the Philly School Experience Survey — the average of the topic's subtopic scores, on the survey's 0–100 scale.
- PSES teacher — professional capacity — The teacher score for the 'Professional Capacity' topic of the Philly School Experience Survey — the average of the topic's subtopic scores, on the survey's 0–100 scale.
- PSES teacher — school climate — The teacher score for the 'School Climate' topic of the Philly School Experience Survey — the average of the topic's subtopic scores, on the survey's 0–100 scale.
- PSES teacher — school leadership — The teacher score for the 'School Leadership' topic of the Philly School Experience Survey — the average of the topic's subtopic scores, on the survey's 0–100 scale.
Access
- Pre-K allotment — The Pre-K seats the district allots to the school's site: seats, not enrolled children. They are already inside the enrollment figure and inside utilization.
- Capacity — The seats the district's Facilities Master Plan assigns the school's site: the denominator of utilization. For a school on several sites of its own, the sites' capacities are added.
- Enrollment (incl. Pre-K allotment) — The school's October 1 enrollment plus the Pre-K seats the district allots to its site: the numerator of utilization. For a school on several sites of its own, the enrollment is counted once and the Pre-K seats are added.
- Utilization — The school's enrollment plus the Pre-K seats allotted to its site, as a share of the site's capacity, from the district's Facilities Master Plan. For a school on several sites of its own, the enrollment is counted once and the capacities are added. Descriptive: not ranked against peers.
Demographics
- Enrollment — The school's October 1 enrollment (all grades).
- % American Indian / Alaska Native — The share of the school's students who are American Indian or Alaska Native.
- % Asian — The share of the school's students who are Asian.
- % Black — The share of the school's students who are Black.
- % Economically Disadvantaged — The share of the school's students recorded as economically disadvantaged.
- % English Learner — The share of the school's students who are English learners.
- % Female — The share of the school's students who are female.
- % Hispanic — The share of the school's students who are Hispanic.
- % Male — The share of the school's students who are male.
- % Native Hawaiian / Pacific Islander — The share of the school's students who are Native Hawaiian or Pacific Islander.
- % Special Education (IEP) — The share of the school's students with an individualized education program (special education).
- % Two or More Races — The share of the school's students recorded as two or more races.
- % White — The share of the school's students who are White.
Algorithms and derivations
- Chronic absenteeism as 100 minus the 90%-attendance share — Neither publisher gives a school-level chronic-absenteeism rate, but both give the share of students attending 90%+ of days.
- Citywide and peer-group percentiles — For each metric, year, and subgroup, every school is ranked among all default-included Philadelphia schools (citywide) and among its own peer group (peers).
- Peer groups: 40 nearest neighbors on demographics — Each school's peer group is the 40 schools most similar to it demographically, chosen only from schools with the same grade configuration, the same admission bucket (catchment, lottery, selective, CTE, alternative), and the same sector (district vs charter vs cyber).
- Suspension shares derived from the published 0/1/2/3 columns — The district publishes the share of students with zero, one, two, and three suspensions but not 'four or more'.
- Survey topic scores per respondent type — The district publishes survey subtopic scores per respondent type but topic scores only aggregated across respondents.
- School demographic shares from per-grade counts — The district's enrollment file has one row per school and grade.
- Reading the state's wide-format datafile — The state's Future Ready datafile has one row per school and hundreds of columns named measure_subgroup.
- Movers: change between two years — The Movers table is simply each school's value in the later year minus its value in the earlier year, for schools with an unsuppressed all-students value in both years, sorted by that change..
- Weighting the state's attendance measure by enrollment — The state publishes no student counts for its attendance measure, and enrollment is loaded for every sector only for 2024-25.
Working-analysis statistics
Every figure on the chronic-absenteeism working analysis renders from one committed data file; these trees explain each block of it.
- District-wide chronic absenteeism by year — The share of all students at district-run schools who attended less than 90% of days, each year, plus how individual schools were spread (median and percentiles).
- Chronic absenteeism by grade — The district-wide below-90 share for each grade, K through 12.
- Chronic absenteeism by type of school — The below-90 share by grade configuration (elementary, K-8, middle, middle-high, high).
- Chronic absenteeism vs average daily attendance — How the two measures move together, and by how much more the threshold measure changes.
- Chronic absenteeism by race/ethnicity — Each group's below-90 share over all schools that report the group.
- Chronic absenteeism by gender (schools reporting both) — Male and female below-90 shares restricted to schools reporting both genders in that year, plus a fixed-panel version restricted to schools reporting both in every in-person year.
- Black–White gap at schools reporting both groups — Black and White below-90 shares at schools reporting both groups: the pooled rates and their difference; the mean of each school's own Black-minus-White difference (every school equal, and weighted by the school's Black + White student records) with the level pair behind each; and a fixed panel of schools reporting both groups in every in-person year.
- Chronic absenteeism by school composition (thirds) — Schools split into thirds by a demographic share, and each third's student-weighted below-90 share.
- How many schools at each level — School counts in 5-percent ranges of the below-90 share, and how many schools are above 50%.
- Year-to-year stability — How much a school's below-90 share changes from one year to the next, and how that varies with school size.
- District-wide months, including 2025-26 — The within-month below-90 share, district-wide, each month of each school year, plus a September–March average.
- District-run vs charter on the state's measure — Sector averages, like-for-like comparisons by school type, and within-school subgroup gaps, all on the state's Regular Attendance measure, for attendance years 2017-18 through 2023-24.
- Source-vs-database crosschecks and universe reconciliation — The district-wide series recomputed straight from the district's file and compared to the served database, plus the list of school-years the database lacks.
Publisher files
- Master School List, 2024-25 — School District of Philadelphia. first-fetch findings
- Enrollment & Demographics, 2024-25 — School District of Philadelphia. first-fetch findings
- Student attendance — % with 90%+ attendance, by school and year — School District of Philadelphia (Performance Office). first-fetch findings
- Average daily attendance, by school and year — School District of Philadelphia (Performance Office). first-fetch findings
- District-wide monthly attendance — % with 90%+ attendance within the month — School District of Philadelphia (Performance Office). first-fetch findings
- Out-of-school suspensions, by school and year — School District of Philadelphia (Performance Office). first-fetch findings
- Graduation rates by cohort, 4/5/6-year — School District of Philadelphia (Performance Office). first-fetch findings
- PSSA & Keystone results, 2024-25 — School District of Philadelphia (Performance Office). first-fetch findings
- PSSA & Keystone results, 2023-24 — School District of Philadelphia (Performance Office). first-fetch findings
- Philly School Experience Survey — topic and subtopic scores, 2019-20 to 2024-25 — School District of Philadelphia (Research, Evaluation & Accountability). first-fetch findings
- Future Ready PA Index datafile, 2024-25 — Pennsylvania Department of Education (Future Ready PA Index). first-fetch findings
- Future Ready PA Index datafile, 2023-24 — Pennsylvania Department of Education (Future Ready PA Index). first-fetch findings
- Future Ready PA Index datafile, 2022-23 — Pennsylvania Department of Education (Future Ready PA Index). first-fetch findings
- Future Ready PA Index datafile, 2021-22 — Pennsylvania Department of Education (Future Ready PA Index). first-fetch findings
- Future Ready PA Index datafile, 2020-21 (older long format) — Pennsylvania Department of Education (Future Ready PA Index). first-fetch findings
- Facilities Master Plan dashboard, SY2024-25 — School District of Philadelphia, Office of Operations. method doc
- Future Ready PA Index datafile, 2018-19 (older long format) — Pennsylvania Department of Education (Future Ready PA Index). first-fetch findings
Registry of every source with URLs, column mappings, and caveats: sources.yaml
Data loads
Every run of a loader script is recorded with the file it read (SHA-256 hash), the script, and the code commit. Most recent first.
| Loaded | Source file | Year | Script | Hash | Commit |
|---|---|---|---|---|---|
| 2026-09-24 | sdp_facilities_dashboard | 2024-25 | facilities.ts | 18b9791617ed… | 3b369d04 |
| 2026-09-08 | futurereadypa_performance_2024-25 | 2024-25 | futurereadypa_performance.ts | a16ffc40e7d1… | c19ea6ec |
| 2026-09-08 | futurereadypa_performance_2023-24 | 2023-24 | futurereadypa_performance.ts | 89219f7a7ffb… | c19ea6ec |
| 2026-09-08 | futurereadypa_performance_2022-23 | 2022-23 | futurereadypa_performance.ts | 81fdf381405c… | c19ea6ec |
| 2026-09-08 | futurereadypa_performance_2021-22 | 2021-22 | futurereadypa_performance.ts | 4efe1b1b120f… | c19ea6ec |
| 2026-09-08 | futurereadypa_performance_2020-21 | 2020-21 | futurereadypa_longformat_attendance.ts | fa8e4c859bc7… | c19ea6ec |
| 2026-09-08 | futurereadypa_performance_2019-20 | 2019-20 | futurereadypa_longformat_attendance.ts | 5fc4cdacd70c… | c19ea6ec |
| 2026-09-08 | futurereadypa_performance_2018-19 | 2018-19 | futurereadypa_longformat_attendance.ts | e338ebd19851… | c19ea6ec |
| 2026-09-07 | futurereadypa_performance_2020-21 | 2020-21 | futurereadypa_longformat_attendance.ts | fa8e4c859bc7… | 2e6098c8 |
| 2026-09-07 | futurereadypa_performance_2018-19 | 2018-19 | futurereadypa_longformat_attendance.ts | e338ebd19851… | 2e6098c8 |
| 2026-09-07 | futurereadypa_performance_2021-22 | 2021-22 | futurereadypa_performance.ts | 4efe1b1b120f… | 2e6098c8 |
| 2026-09-07 | futurereadypa_performance_2022-23 | 2022-23 | futurereadypa_performance.ts | 81fdf381405c… | 2e6098c8 |
| 2026-09-07 | futurereadypa_performance_2023-24 | 2023-24 | futurereadypa_performance.ts | 89219f7a7ffb… | 2e6098c8 |
| 2026-09-07 | futurereadypa_performance_2024-25 | 2024-25 | futurereadypa_performance.ts | a16ffc40e7d1… | 2e6098c8 |
| 2026-09-07 | futurereadypa_performance_2021-22 | 2021-22 | futurereadypa_performance.ts | 4efe1b1b120f… | d70724b6 |
| 2026-09-07 | futurereadypa_performance_2022-23 | 2022-23 | futurereadypa_performance.ts | 81fdf381405c… | d70724b6 |
| 2026-09-07 | futurereadypa_performance_2020-21 | 2020-21 | futurereadypa_longformat_attendance.ts | fa8e4c859bc7… | d70724b6 |
| 2026-09-07 | futurereadypa_performance_2018-19 | 2018-19 | futurereadypa_longformat_attendance.ts | e338ebd19851… | d70724b6 |
| 2026-09-07 | futurereadypa_performance_2023-24 | 2023-24 | futurereadypa_performance.ts | 89219f7a7ffb… | d70724b6 |
| 2026-06-04 | sdp_pssa_keystone_2023-24 | 2023-24 | sdp_pssa_keystone_2023-24.ts | d89570e75caa… | de835926 |
| 2026-06-04 | sdp_pssa_keystone_2023-24 | 2023-24 | sdp_pssa_keystone_2023-24.ts | d89570e75caa… | de835926 |
| 2026-06-04 | sdp_pssa_keystone_2023-24 | 2023-24 | sdp_pssa_keystone_2023-24.ts | d89570e75caa… | de835926 |
| 2026-06-04 | futurereadypa_performance_2024-25 | 2024-25 | futurereadypa_performance.ts | a16ffc40e7d1… | f75e3313 |
| 2026-06-04 | futurereadypa_performance_2024-25 | 2024-25 | futurereadypa_performance.ts | a16ffc40e7d1… | f75e3313 |
| 2026-06-04 | pses_topic_subtopic_scores_all_years | 2019-20..2024-25 | pses.ts | 142800f6ae81… | f75e3313 |
| 2026-06-04 | futurereadypa_performance_2024-25 | 2024-25 | futurereadypa_performance.ts | a16ffc40e7d1… | f75e3313 |
| 2026-06-04 | futurereadypa_performance_2024-25 | 2024-25 | futurereadypa_performance.ts | a16ffc40e7d1… | f75e3313 |
| 2026-06-04 | sdp_suspensions_school | — | sdp_attendance_and_suspensions.ts | 6eaa8e3907d8… | f75e3313 |
| 2026-06-04 | sdp_attendance_ada_school | — | sdp_attendance_and_suspensions.ts | 04e0893c5f84… | f75e3313 |
| 2026-06-04 | sdp_attendance_90_school | — | sdp_attendance_and_suspensions.ts | 552bf3bd6d53… | f75e3313 |
| 2026-06-04 | sdp_graduation_school_2014-2025 | 2010-11..2021-22 | sdp_graduation.ts | 8ae3969118c3… | f75e3313 |
| 2026-06-03 | sdp_enrollment_demographics_school_2024-25 | 2024-25 | sdp_enrollment_demographics.ts | 80f169f31c3e… | 63ddc08c |
| 2026-06-03 | sdp_pssa_keystone_2024-25 | 2024-25 | sdp_pssa_keystone.ts | d040e16c1b88… | 63ddc08c |
| 2026-06-03 | futurereadypa_performance_2024-25 | 2024-25 | futurereadypa_performance.ts | a16ffc40e7d1… | 63ddc08c |
| 2026-06-03 | futurereadypa_performance_2024-25 | 2024-25 | futurereadypa_performance.ts | a16ffc40e7d1… | 63ddc08c |
| 2026-06-03 | sdp_master_school_list_2024-25 | 2024-25 | master_school_list.ts | 8877ce7fd147… | c44dbe77 |
| 2026-06-03 | sdp_master_school_list_2024-25 | 2024-25 | master_school_list.ts | 8877ce7fd147… | c44dbe77 |