About this Dataset

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.
Organization: State of Connecticut
Last updated: 2020-11-12T14:54:53.664600
Tags: capt, education, school, school-performance

Tables

Table 1

@usgov.state_of_connecticut_capt_school_performance_2010_2012.table_1

57.67 kB
193 rows
36 columns

CREATE TABLE table_1 (
  "facility_code" BIGINT,
  "district_name" VARCHAR,
  "school_name" VARCHAR,
  "overall_spi_overall_2010" DOUBLE,
  "overall_spi_overall_2011" DOUBLE,
  "overall_spi_overall_2012" DOUBLE,
  "black_spi_overall_2010" DOUBLE,
  "black_spi_overall_2011" DOUBLE,
  "black_spi_overall_2012" DOUBLE,
  "hispanic_spi_overall_2010" DOUBLE,
  "hispanic_spi_overall_2011" DOUBLE,
  "hispanic_spi_overall_2012" DOUBLE,
  "ell_spi_overall_2010" DOUBLE,
  "ell_spi_overall_2011" DOUBLE,
  "ell_spi_overall_2012" DOUBLE,
  "frl_spi_overall_2010" DOUBLE,
  "frl_spi_overall_2011" DOUBLE,
  "frl_spi_overall_2012" DOUBLE,
  "swd_spi_overall_2010" DOUBLE,
  "swd_spi_overall_2011" DOUBLE,
  "swd_spi_overall_2012" DOUBLE,
  "high_needs_spi_overall_2010" DOUBLE,
  "high_needs_spi_overall_2011" DOUBLE,
  "high_needs_spi_overall_2012" DOUBLE,
  "overall_spi_math_2010" DOUBLE,
  "overall_spi_math_2011" DOUBLE,
  "overall_spi_math_2012" DOUBLE,
  "overall_spi_read_2010" DOUBLE,
  "overall_spi_read_2011" DOUBLE,
  "overall_spi_read_2012" DOUBLE,
  "overall_spi_write_2010" DOUBLE,
  "overall_spi_write_2011" DOUBLE,
  "overall_spi_write_2012" DOUBLE,
  "overall_spi_science_2010" DOUBLE,
  "overall_spi_science_2011" DOUBLE,
  "overall_spi_science_2012" DOUBLE
);