Chronic Absenteeism

The measurement is percent of children within OUSD who are chronically absent. Chronic absence is defined as an attendance rate of 90% or less (missing 18 or more days in a 180 day school year), regardless of whether the absences are excused or unexcused. It is not the same as Truancy. Alternative Education schools are not included in the data.

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/chronic-absenteeism-5d4q-57a4\".\"chronic_absenteeism\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.