Teacher Turnover

The measurement is percent of teachers who turned over between the 2016-17 and 2017-18 school years at OUSD schools (data from charters and private schools were not available). Turnover percents are calculated at a school level out of the total number of teachers at that school. Schools are placed into groups based on the racial and ethnic breakdown of their student population (see note below data table for full explanation of grouping). Average teacher turnover percent is then calculated for each group of schools.

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 \"oaklandca-gov/teacher-turnover-if52-yyug\".\"teacher_turnover\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.