Report Card Teacher Ratio Program Certificate

This file includes Report Card teacher information around teacher-student ratios, teacher assignments by program, and teacher certificate types for the 2017-18 to 2021-22 school years. Data is disaggregated by school, district, Educational Service District, and the state level. Ratio information includes teacher and student head counts, average class size, and student-to-teacher ratio as a percent. Program information includes count and percent of teachers by head count and program as well as by FTE assignment. Certificate information indicates the count and percent of teachers by certificate type and by limited certificate subcategories. Please review the notes below for more information.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"wa-gov/report-card-teacher-ratio-program-certificate-48sv-aigs\".\"report_card_teacher_ratio_program_certificate\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.