K12ATLAS
Release v2026.07
§ Explainer · K12 Atlas release v2026.07

School counselor ratio data: FTE, denominators, and 250:1.

Use counselor FTE and enrollment to calculate student-to-counselor ratios, then compare with the ASCA 250:1 reference without turning the metric into a school score.

What the field means

A counselor ratio is usually read as students per counselor. In K12 Atlas, the counselor field comes from reported counselor full-time-equivalent staffing and school enrollment. That means the ratio is not a survey of services, office hours, case load, or program quality. It is a structured staffing signal.

The useful question is narrow: how much reported counselor staffing exists relative to student enrollment for the same school record? That framing keeps the field factual and prevents it from becoming a label.

Reading rule

Start with the source year, then check enrollment, then check counselor FTE. A ratio without those three pieces is easy to misread.

Before you compare schools

  • Check the vintage first. K12 Atlas uses CRDC SY 2021-22 for counselor FTE, while enrollment fields may come from a newer CCD school year.
  • Check whether the counselor value is zero, blank, or suppressed. Those states are not interchangeable.
  • Remember that FTE can be fractional. A school with 0.5 reported counselors is not the same as a school with no reported counselor.
  • Use the ASCA 250:1 benchmark as context, not as a school score or recommendation.

Reading example

If a school reports 600 students and 2.0 counselor FTE, the simple ratio is 300 students per counselor. If another school reports 600 students and 0.5 counselor FTE, the ratio is 1,200 students per counselor. The second row signals lower reported counselor staffing relative to enrollment, but it does not explain why.

That is where source discipline matters. A district may share staff across campuses, report staffing differently, or use other student support roles that are not counted in the counselor field. The data should prompt better questions, not replace them.

SourceCRDC counselor FTE, school-level reported staffing.
DenominatorSchool enrollment used to calculate students per counselor.
Use caseStaffing context for research, reporting, district review, and due diligence.

What the data cannot say

The ratio does not say whether students can easily access counseling, whether a program is comprehensive, or whether outcomes are caused by staffing. It also does not capture every adult who may support students. Treat it as a comparable staffing field, not a complete student-support picture.

How K12 Atlas uses it

K12 Atlas keeps the field tied to its source and vintage. We show the raw staffing signal, explain the denominator, and avoid converting it into a rank. That makes it usable for analysts, journalists, policy teams, and product teams that need sourced school-level context.

The source-backed page

The matching data story is /data/counselor-deserts. It includes the public CSV slice, state-level context, methodology notes, and Dataset JSON-LD.

Practical use cases

Journalists can use counselor ratios to report on student support deficits relative to national standards. Researchers can use it to study correlations between staffing levels and academic outcomes. Product teams can display counselor FTE to help parents understand school resource levels.

Refresh and maintenance

This page updates biennially when the U.S. Department of Education OCR releases new CRDC files. The counselor ratio columns, ASCA reference threshold, and student enrollment totals should move together in the data pipelines.

Need the school-level counselor field?

Start with the free Austin ISD sample, then choose district, metro, state, or national coverage.

Email me the sample