Representation of Student Population

The measurement is the rate of teachers per 1,000 students of the same race/ethnicity in OUSD, in other words how representative are the teachers of the student population? Numbers of teachers and students were calculated from percents of the total number given in OUSD’s Fast Facts report.

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/representation-of-student-population-x2vv-6a89\".\"representation_of_student_population\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.