CAPT School Performance: 2010-2012

This dataset contains the school performance indices (SPIs) for 2009-10 (2010), 2010-11 (2011), and 2011-12 (2012) for all schools that administered the Connecticut Academic Performance Test (CAPT). These data were published in the School Performance Reports released by the CT State Department of Education (CSDE) in December 2013 (see http://www.csde.state.ct.us/public/performancereports/20122013reports.asp)

Note: Cells are left blank if there is no SPI, which happens when there are small N sizes for a particular subgroup or subject.

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 \"ct-gov/capt-school-performance-20102012-92fu-qcsw\".\"capt_school_performance_20102012\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.