Scope and interpretation

This report summarizes the indicators actually supplied: SAP cases and referral reasons (2025–26), graduates relative to grade-12 enrollment (2024–25 source files), regular attendance (2024–25), historical White female teen childbearing (Opportunity Atlas), and adult frequent mental distress (CDC PLACES 2020 release). These sources describe different populations and periods and should not be treated as contemporaneous measures or evidence of a causal effect of OST.

Dropout rates, cohort graduation rates, teen pregnancy, suspensions/expulsions, and violent crime are not supplied. Legislative boundaries provide geographic context; the report does not estimate legislative-district outcomes.

SAP cases and referral rates

NOTE: BC requested on November 5 to Office of School Climate for district-level data.

## [1] "PSAYDN_cache/cc-est2025-syasex-42.csv"

Rates are cases per 1,000 residents ages 0–18, not per 1,000 enrolled students or the percentage of unique children referred. Census vintage 2025 year code 7 is retained from the original report; verify that code against the supplied file’s documentation when replacing the source. Missing or suppressed counts remain missing. The highest-rate flag includes ties at the observed 75th percentile and can include more than one quarter of counties.

 

Graduates relative to grade-12 enrollment

ratio_status school_rows
Above 100 percent 131
Nonpositive enrollment 1
Unmatched/missing enrollment 1
Within 0–100 percent 562

graduation_rate is retained for compatibility but is graduates divided by grade-12 enrollment, not an adjusted cohort graduation rate or dropout rate. Different source timing and populations can produce ratios above 100%. Those values are retained in exports and flagged. The charter label uses the original school-name heuristic and is not verified charter status.

 

Attendance

Attendance match and coverage checks
attendance_status n
Missing attendance 3
Missing/nonpositive enrollment 4
Unmatched enrollment school 160
Usable 2754

County and district attendance values are enrollment-weighted school percentages, not official PDE aggregate attendance rates. Total NCES enrollment supplies the weights and may differ from the population used for PDE’s regular-attendance measure. Missing attendance and invalid weights are excluded together. Coverage is relative to matched, available enrollment; unmatched enrollment cannot be quantified by that percentage. Schools without county matches remain in the school and district exports but are omitted from county aggregation. The geographic DSN must support Windows authentication; otherwise configure credentials securely outside this report.

 

Adult frequent mental distress

## [1] "PSAYDN_cache/cdc_places.csv"
n_tracts mean sd median min max
3196 15.23 3.32 14.8 6.9 32.9

 

Frequent mental distress measures adults reporting at least 14 days of poor mental health in the past 30 days. The CDC PLACES dataset is the 2020 release, not a 2025–26 youth mental-health measure. County values here are derived total-population-weighted tract averages, not official CDC county estimates. No adult population denominator is supplied in the original analysis, so total population weighting is retained and explicitly labeled. Missing estimates or nonpositive/missing weights are excluded as pairs; coverage fields accompany every county result. No county confidence interval is inferred from tract estimates.

 

Historical teen childbearing

Opportunity Atlas estimates describe historical teenage childbearing among White females born in 1978–1983, assigned to childhood neighborhoods using 2010 tract boundaries. They are not current annual birth rates or measures of all pregnancies. County summaries are unweighted means of available tract estimates.

 

## Warning: Removed 239 rows containing non-finite outside the scale range
## (`stat_bin()`).

 

The Atlas measure describes historical teenage childbearing among White females born in 1978–1983, assigned to childhood neighborhoods. It is not a current annual birth rate or a measure of all pregnancies. The statewide map average and county summaries are unweighted means of available tract estimates, not population-level childbearing rates. Missing/suppressed estimates remain missing; county coverage refers to rows supplied in atlas.csv, not all census tracts. The export retains the original field name and stores values as proportions.

 

Interactive indicator map

Choose one county or tract indicator. Toggle county and legislative boundaries independently. Click an indicator polygon for its value and source. Legislative labels identify districts; boundaries do not imply district-level estimates.

 

Legislator Table

Priority calculation: High priority requires all four conditions: bullying and historical Atlas childbearing at or above the 75th percentile, and attendance and graduates/enrollment at or below the 25th percentile. Percentiles are calculated across legislative-district rows. Missing data indicates at least one required indicator is unavailable.

 

Reproducible Power BI exports

Import COUNTYFIPS, TRACTFIPS, school_code, NCESSCH, ST_SCHID, and aun as Text in Power BI before automatic type conversion. CSV cannot enforce identifier types. Set county FIPS to five characters and tract FIPS to eleven. Blank values represent missing or suppressed values, never zero. Percentages are stored on the 0–100 scale; use decimal-number formatting rather than Power BI’s percent format unless dividing by 100 first. Atlas childbearing estimates are stored on the 0–1 scale and should use Power BI percentage formatting. Keep AUN as Text.

Use DimCounty[COUNTYFIPS] on the one side of single-direction relationships to the combined county table, tract table, or SAP reason table. Choose either the combined county table or the separate county facts for each measure to avoid double counting. County prevalence and referral rates must not be summed or averaged across repeated tract/reason rows. Compute combined SAP rates as 1,000 × summed cases / summed corresponding populations, using only counties with both measures observed. The attendance school export links to DimCounty using COUNTYFIPS. The graduate export has no county relationship. Link DimTract2010 to the teen tract fact using TRACTFIPS; validate PLACES tract vintage before sharing a tract dimension. District attendance has one row per AUN. County childbearing summaries are descriptive unweighted tract means; do not interpret them as county birth rates.

The data dictionary lists all exported fields and types. Definitions of key derived fields are: referrals_per_1000 = SAP cases / age 0–18 population × 1,000; highest_rate = observed rate at or above its 75th percentile; mental_distress = tract adult prevalence or the labeled derived county weighted average; population_coverage_pct = usable tract weight / available county tract population × 100; graduation_rate = graduates / grade-12 enrollment × 100; and ratio_status explains exclusions from the histogram.