About this Dataset

Consolidated State Performance Report, 2009-10

The Consolidated State Performance Report, 2009-10 (CSPR 2009-10), is part of the Consolidated State Performance Report (CSPR) program: a required annual reporting tool for each state, the Bureau of Indian Education, the District of Columbia, and Puerto Rico; program data is available since 2005-06 at . CSPR 2009-10 (https://www2.ed.gov/admins/lead/account/consolidated/sy09-10part1/index.html; https://www2.ed.gov/admins/lead/account/consolidated/sy09-10part2/index.html) is a cross-sectional report that measures each state's progress towards implementation of the No Child Left Behind Act (NCLB) and the reporting instrument for state formula grant programs authorized by the Elementary and Secondary Education Act (ESEA) as amended by NCLB. The reporting was conducted using state education agencies' (SEAs) reports in the EDFacts online submission system. CSPR 2009-10 is a universe survey. The study's response rate was 100%. Key statistics include information on adequate yearly progress, state performance assessments, highly qualified teachers, public school choice and supplemental education services options.
Organization: Department of Education
Last updated: 2023-08-12T23:58:10.104355
Tags: b5c3333b-259a-49c3-9576-51203d216820, consolidated-state-performance-report, elementary-and-secondary-education, esea-programs, grant-monitoring, high-school-graduation, highly-qualified-teachers, learning-environment, math-proficiency, program-monitoring, reading-language-proficiency, readinglanguage-proficiency, schools, state-activities

Tables

Userssharedsdfachvmntrsltsstateassmtsmathssy200910

@usgov.ed_gov_consolidated_state_performance_report_2009_10_835d9.userssharedsdfachvmntrsltsstateassmtsmathssy200910

13.22 MB
91,205 rows
230 columns

CREATE TABLE userssharedsdfachvmntrsltsstateassmtsmathssy200910 (
  "stnam" VARCHAR,
  "fipst" BIGINT,
  "leaid" BIGINT,
  "leanm09" VARCHAR,
  "ncessch" BIGINT,
  "schnam09" VARCHAR,
  "all_mth00numvalid_0910" BIGINT,
  "all_mth00pctprof_0910" VARCHAR,
  "mam_mth00numvalid_0910" DOUBLE,
  "mam_mth00pctprof_0910" VARCHAR,
  "mas_mth00numvalid_0910" DOUBLE,
  "mas_mth00pctprof_0910" VARCHAR,
  "mbl_mth00numvalid_0910" DOUBLE,
  "mbl_mth00pctprof_0910" VARCHAR,
  "mhi_mth00numvalid_0910" DOUBLE,
  "mhi_mth00pctprof_0910" VARCHAR,
  "mtr_mth00numvalid_0910" DOUBLE,
  "mtr_mth00pctprof_0910" VARCHAR,
  "mwh_mth00numvalid_0910" DOUBLE,
  "mwh_mth00pctprof_0910" VARCHAR,
  "f_mth00numvalid_0910" DOUBLE,
  "f_mth00pctprof_0910" VARCHAR,
  "m_mth00numvalid_0910" DOUBLE,
  "m_mth00pctprof_0910" VARCHAR,
  "cwd_mth00numvalid_0910" DOUBLE,
  "cwd_mth00pctprof_0910" VARCHAR,
  "ecd_mth00numvalid_0910" DOUBLE,
  "ecd_mth00pctprof_0910" VARCHAR,
  "lep_mth00numvalid_0910" DOUBLE,
  "lep_mth00pctprof_0910" VARCHAR,
  "hom_mth00numvalid_0910" DOUBLE,
  "hom_mth00pctprof_0910" VARCHAR,
  "mig_mth00numvalid_0910" DOUBLE,
  "mig_mth00pctprof_0910" VARCHAR,
  "all_mth03numvalid_0910" DOUBLE,
  "all_mth03pctprof_0910" VARCHAR,
  "all_mth04numvalid_0910" DOUBLE,
  "all_mth04pctprof_0910" VARCHAR,
  "all_mth05numvalid_0910" DOUBLE,
  "all_mth05pctprof_0910" VARCHAR,
  "all_mth06numvalid_0910" DOUBLE,
  "all_mth06pctprof_0910" VARCHAR,
  "all_mth07numvalid_0910" DOUBLE,
  "all_mth07pctprof_0910" VARCHAR,
  "all_mth08numvalid_0910" DOUBLE,
  "all_mth08pctprof_0910" VARCHAR,
  "all_mthhsnumvalid_0910" DOUBLE,
  "all_mthhspctprof_0910" VARCHAR,
  "mam_mth03numvalid_0910" DOUBLE,
  "mam_mth03pctprof_0910" VARCHAR,
  "mam_mth04numvalid_0910" DOUBLE,
  "mam_mth04pctprof_0910" VARCHAR,
  "mam_mth05numvalid_0910" DOUBLE,
  "mam_mth05pctprof_0910" VARCHAR,
  "mam_mth06numvalid_0910" DOUBLE,
  "mam_mth06pctprof_0910" VARCHAR,
  "mam_mth07numvalid_0910" DOUBLE,
  "mam_mth07pctprof_0910" VARCHAR,
  "mam_mth08numvalid_0910" DOUBLE,
  "mam_mth08pctprof_0910" VARCHAR,
  "mam_mthhsnumvalid_0910" DOUBLE,
  "mam_mthhspctprof_0910" VARCHAR,
  "mas_mth03numvalid_0910" DOUBLE,
  "mas_mth03pctprof_0910" VARCHAR,
  "mas_mth04numvalid_0910" DOUBLE,
  "mas_mth04pctprof_0910" VARCHAR,
  "mas_mth05numvalid_0910" DOUBLE,
  "mas_mth05pctprof_0910" VARCHAR,
  "mas_mth06numvalid_0910" DOUBLE,
  "mas_mth06pctprof_0910" VARCHAR,
  "mas_mth07numvalid_0910" DOUBLE,
  "mas_mth07pctprof_0910" VARCHAR,
  "mas_mth08numvalid_0910" DOUBLE,
  "mas_mth08pctprof_0910" VARCHAR,
  "mas_mthhsnumvalid_0910" DOUBLE,
  "mas_mthhspctprof_0910" VARCHAR,
  "mbl_mth03numvalid_0910" DOUBLE,
  "mbl_mth03pctprof_0910" VARCHAR,
  "mbl_mth04numvalid_0910" DOUBLE,
  "mbl_mth04pctprof_0910" VARCHAR,
  "mbl_mth05numvalid_0910" DOUBLE,
  "mbl_mth05pctprof_0910" VARCHAR,
  "mbl_mth06numvalid_0910" DOUBLE,
  "mbl_mth06pctprof_0910" VARCHAR,
  "mbl_mth07numvalid_0910" DOUBLE,
  "mbl_mth07pctprof_0910" VARCHAR,
  "mbl_mth08numvalid_0910" DOUBLE,
  "mbl_mth08pctprof_0910" VARCHAR,
  "mbl_mthhsnumvalid_0910" DOUBLE,
  "mbl_mthhspctprof_0910" VARCHAR,
  "mhi_mth03numvalid_0910" DOUBLE,
  "mhi_mth03pctprof_0910" VARCHAR,
  "mhi_mth04numvalid_0910" DOUBLE,
  "mhi_mth04pctprof_0910" VARCHAR,
  "mhi_mth05numvalid_0910" DOUBLE,
  "mhi_mth05pctprof_0910" VARCHAR,
  "mhi_mth06numvalid_0910" DOUBLE,
  "mhi_mth06pctprof_0910" VARCHAR,
  "mhi_mth07numvalid_0910" DOUBLE,
  "mhi_mth07pctprof_0910" VARCHAR
);