2017-2018 Health Data Report - Middle School

Local Law 14 (2016) requires that NYCDOE provide citywide Health Education data, disaggregated by community school district, city council district and each individual school. This provides information about the number and percent of students scheduled

for at least one semester of health education as reported through the STARS database. NYSED mandates HIV/AIDS instruction with a set number of lessons for every student, every year. There are five required lessons per year for grade levels of K-6 and six required lessons for grade level 7-8; teachers must use the NYCDOE HIV\AIDS curriculum.

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 \"cityofnewyork-us/20172018-health-data-report-middle-school-c5ft-upv9\".\"20172018_health_data_report_middle_school\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.