Performance Metrics - Public Health - School-Based Oral Health Programming

The Chicago Department of Public Health contracts with licensed dentists to provide and the Chicago Public Schools' students a dental exam/screening, a dental cleaning, a fluoride varnish treatment and apply dental sealant(s) as needed at no cost to students or their families in school. This metric tracks the number of students served by the program per month during the school year. The annual performance goal is to serve 96,000 students per school year.

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 \"cityofchicago/performance-metrics-public-health-schoolbased-oral-uvy2-xbnp\".\"performance_metrics_public_health_schoolbased_oral\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.