A-G Completion (Readiness for UC System)

The measurement is percent of students by race/ethnicity who have met the California A-G requirements by the end of high school. There are two components to the requirement: 1) Students must enroll in the right sequence of A-G courses, and 2) They must obtain a grade of “C” or better in each required course. Data includes only OUSD students (not charter or private schools) who have graduated.

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/ag-completion-readiness-for-uc-system-46ht-6csa\".\"ag_completion_readiness_for_uc_system\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.