Half of Philly schools sit in ESSA support tiers — the federal accountability tail

Summary

Pulled `essa_designation` from philly_schools, counted by tier. The Future Ready loader populates the full DFLT/TSI/CSI/ATSI/ACSI breakdown; the Master List underpopulates (only flags CSI).

Data sources

• Database tablephilly_schools

  One row per Philly school. PK is ulcs_code (SDP canonical, = id_eos in PSSA, = SRC_School_ID × 10). Carries aun_code + pa_code for PDE-side joins.

• External datasetFuture Ready PA Index (PDE)

Steps

1. Per-tier counts.

   SELECT essa_designation::text, count(*)
   FROM philly_schools
   GROUP BY essa_designation
   ORDER BY 2 DESC;

Reproduce

Load both Master List and Future Ready Performance. The Future Ready ESSA designation is reported in the State Assessment Measures sheet but not currently extracted by the loader (a small follow-up).