Consolidated State Performance Report, 2008-09
Department of Education
@usgov.ed_gov_consolidated_state_performance_report_2008_09_77a3d
Department of Education
@usgov.ed_gov_consolidated_state_performance_report_2008_09_77a3d
The Consolidated State Performance Report, 2008-09 (CSPR 2008-09), 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 2008-09 (https://www2.ed.gov/admins/lead/account/consolidated/sy08-09part1/index.html; https://www2.ed.gov/admins/lead/account/consolidated/sy08-09part2/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 2008-09 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:57:55.837728
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
CREATE TABLE achvmntrsltsstateassmtsmathssy200809 (
"stnam" VARCHAR,
"fipst" VARCHAR,
"leaid" VARCHAR,
"leanm08" VARCHAR,
"ncessch" VARCHAR,
"schnam08" VARCHAR,
"all_mth00numvalid_0809" VARCHAR,
"all_mth00pctprof_0809" VARCHAR,
"mam_mth00numvalid_0809" VARCHAR,
"mam_mth00pctprof_0809" VARCHAR,
"mas_mth00numvalid_0809" VARCHAR,
"mas_mth00pctprof_0809" VARCHAR,
"mbl_mth00numvalid_0809" VARCHAR,
"mbl_mth00pctprof_0809" VARCHAR,
"mhi_mth00numvalid_0809" VARCHAR,
"mhi_mth00pctprof_0809" VARCHAR,
"mtr_mth00numvalid_0809" VARCHAR,
"mtr_mth00pctprof_0809" VARCHAR,
"mwh_mth00numvalid_0809" VARCHAR,
"mwh_mth00pctprof_0809" VARCHAR,
"f_mth00numvalid_0809" VARCHAR,
"f_mth00pctprof_0809" VARCHAR,
"m_mth00numvalid_0809" VARCHAR,
"m_mth00pctprof_0809" VARCHAR,
"cwd_mth00numvalid_0809" VARCHAR,
"cwd_mth00pctprof_0809" VARCHAR,
"ecd_mth00numvalid_0809" VARCHAR,
"ecd_mth00pctprof_0809" VARCHAR,
"lep_mth00numvalid_0809" VARCHAR,
"lep_mth00pctprof_0809" VARCHAR,
"hom_mth00numvalid_0809" VARCHAR,
"hom_mth00pctprof_0809" VARCHAR,
"mig_mth00numvalid_0809" VARCHAR,
"mig_mth00pctprof_0809" VARCHAR,
"all_mth03numvalid_0809" VARCHAR,
"all_mth03pctprof_0809" VARCHAR,
"all_mth04numvalid_0809" VARCHAR,
"all_mth04pctprof_0809" VARCHAR,
"all_mth05numvalid_0809" VARCHAR,
"all_mth05pctprof_0809" VARCHAR,
"all_mth06numvalid_0809" VARCHAR,
"all_mth06pctprof_0809" VARCHAR,
"all_mth07numvalid_0809" VARCHAR,
"all_mth07pctprof_0809" VARCHAR,
"all_mth08numvalid_0809" VARCHAR,
"all_mth08pctprof_0809" VARCHAR,
"all_mthhsnumvalid_0809" VARCHAR,
"all_mthhspctprof_0809" VARCHAR,
"mam_mth03numvalid_0809" VARCHAR,
"mam_mth03pctprof_0809" VARCHAR,
"mam_mth04numvalid_0809" VARCHAR,
"mam_mth04pctprof_0809" VARCHAR,
"mam_mth05numvalid_0809" VARCHAR,
"mam_mth05pctprof_0809" VARCHAR,
"mam_mth06numvalid_0809" VARCHAR,
"mam_mth06pctprof_0809" VARCHAR,
"mam_mth07numvalid_0809" VARCHAR,
"mam_mth07pctprof_0809" VARCHAR,
"mam_mth08numvalid_0809" VARCHAR,
"mam_mth08pctprof_0809" VARCHAR,
"mam_mthhsnumvalid_0809" VARCHAR,
"mam_mthhspctprof_0809" VARCHAR,
"mas_mth03numvalid_0809" VARCHAR,
"mas_mth03pctprof_0809" VARCHAR,
"mas_mth04numvalid_0809" VARCHAR,
"mas_mth04pctprof_0809" VARCHAR,
"mas_mth05numvalid_0809" VARCHAR,
"mas_mth05pctprof_0809" VARCHAR,
"mas_mth06numvalid_0809" VARCHAR,
"mas_mth06pctprof_0809" VARCHAR,
"mas_mth07numvalid_0809" VARCHAR,
"mas_mth07pctprof_0809" VARCHAR,
"mas_mth08numvalid_0809" VARCHAR,
"mas_mth08pctprof_0809" VARCHAR,
"mas_mthhsnumvalid_0809" VARCHAR,
"mas_mthhspctprof_0809" VARCHAR,
"mbl_mth03numvalid_0809" VARCHAR,
"mbl_mth03pctprof_0809" VARCHAR,
"mbl_mth04numvalid_0809" VARCHAR,
"mbl_mth04pctprof_0809" VARCHAR,
"mbl_mth05numvalid_0809" VARCHAR,
"mbl_mth05pctprof_0809" VARCHAR,
"mbl_mth06numvalid_0809" VARCHAR,
"mbl_mth06pctprof_0809" VARCHAR,
"mbl_mth07numvalid_0809" VARCHAR,
"mbl_mth07pctprof_0809" VARCHAR,
"mbl_mth08numvalid_0809" VARCHAR,
"mbl_mth08pctprof_0809" VARCHAR,
"mbl_mthhsnumvalid_0809" VARCHAR,
"mbl_mthhspctprof_0809" VARCHAR,
"mhi_mth03numvalid_0809" VARCHAR,
"mhi_mth03pctprof_0809" VARCHAR,
"mhi_mth04numvalid_0809" VARCHAR,
"mhi_mth04pctprof_0809" VARCHAR,
"mhi_mth05numvalid_0809" VARCHAR,
"mhi_mth05pctprof_0809" VARCHAR,
"mhi_mth06numvalid_0809" VARCHAR,
"mhi_mth06pctprof_0809" VARCHAR,
"mhi_mth07numvalid_0809" VARCHAR,
"mhi_mth07pctprof_0809" VARCHAR
);CREATE TABLE achvmntrsltsstateassmtsrlasy200809 (
"stnam" VARCHAR,
"fipst" BIGINT,
"leaid" BIGINT,
"leanm08" VARCHAR,
"ncessch" BIGINT,
"schnam08" VARCHAR,
"all_rla00numvalid_0809" BIGINT,
"all_rla00pctprof_0809" VARCHAR,
"mam_rla00numvalid_0809" DOUBLE,
"mam_rla00pctprof_0809" VARCHAR,
"mas_rla00numvalid_0809" DOUBLE,
"mas_rla00pctprof_0809" VARCHAR,
"mbl_rla00numvalid_0809" DOUBLE,
"mbl_rla00pctprof_0809" VARCHAR,
"mhi_rla00numvalid_0809" DOUBLE,
"mhi_rla00pctprof_0809" VARCHAR,
"mtr_rla00numvalid_0809" DOUBLE,
"mtr_rla00pctprof_0809" VARCHAR,
"mwh_rla00numvalid_0809" DOUBLE,
"mwh_rla00pctprof_0809" VARCHAR,
"f_rla00numvalid_0809" DOUBLE,
"f_rla00pctprof_0809" VARCHAR,
"m_rla00numvalid_0809" DOUBLE,
"m_rla00pctprof_0809" VARCHAR,
"cwd_rla00numvalid_0809" DOUBLE,
"cwd_rla00pctprof_0809" VARCHAR,
"ecd_rla00numvalid_0809" DOUBLE,
"ecd_rla00pctprof_0809" VARCHAR,
"lep_rla00numvalid_0809" DOUBLE,
"lep_rla00pctprof_0809" VARCHAR,
"hom_rla00numvalid_0809" DOUBLE,
"hom_rla00pctprof_0809" VARCHAR,
"mig_rla00numvalid_0809" DOUBLE,
"mig_rla00pctprof_0809" VARCHAR,
"all_rla03numvalid_0809" DOUBLE,
"all_rla03pctprof_0809" VARCHAR,
"all_rla04numvalid_0809" DOUBLE,
"all_rla04pctprof_0809" VARCHAR,
"all_rla05numvalid_0809" DOUBLE,
"all_rla05pctprof_0809" VARCHAR,
"all_rla06numvalid_0809" DOUBLE,
"all_rla06pctprof_0809" VARCHAR,
"all_rla07numvalid_0809" DOUBLE,
"all_rla07pctprof_0809" VARCHAR,
"all_rla08numvalid_0809" DOUBLE,
"all_rla08pctprof_0809" VARCHAR,
"all_rlahsnumvalid_0809" DOUBLE,
"all_rlahspctprof_0809" VARCHAR,
"mam_rla03numvalid_0809" DOUBLE,
"mam_rla03pctprof_0809" VARCHAR,
"mam_rla04numvalid_0809" DOUBLE,
"mam_rla04pctprof_0809" VARCHAR,
"mam_rla05numvalid_0809" DOUBLE,
"mam_rla05pctprof_0809" VARCHAR,
"mam_rla06numvalid_0809" DOUBLE,
"mam_rla06pctprof_0809" VARCHAR,
"mam_rla07numvalid_0809" DOUBLE,
"mam_rla07pctprof_0809" VARCHAR,
"mam_rla08numvalid_0809" DOUBLE,
"mam_rla08pctprof_0809" VARCHAR,
"mam_rlahsnumvalid_0809" DOUBLE,
"mam_rlahspctprof_0809" VARCHAR,
"mas_rla03numvalid_0809" DOUBLE,
"mas_rla03pctprof_0809" VARCHAR,
"mas_rla04numvalid_0809" DOUBLE,
"mas_rla04pctprof_0809" VARCHAR,
"mas_rla05numvalid_0809" DOUBLE,
"mas_rla05pctprof_0809" VARCHAR,
"mas_rla06numvalid_0809" DOUBLE,
"mas_rla06pctprof_0809" VARCHAR,
"mas_rla07numvalid_0809" DOUBLE,
"mas_rla07pctprof_0809" VARCHAR,
"mas_rla08numvalid_0809" DOUBLE,
"mas_rla08pctprof_0809" VARCHAR,
"mas_rlahsnumvalid_0809" DOUBLE,
"mas_rlahspctprof_0809" VARCHAR,
"mbl_rla03numvalid_0809" DOUBLE,
"mbl_rla03pctprof_0809" VARCHAR,
"mbl_rla04numvalid_0809" DOUBLE,
"mbl_rla04pctprof_0809" VARCHAR,
"mbl_rla05numvalid_0809" DOUBLE,
"mbl_rla05pctprof_0809" VARCHAR,
"mbl_rla06numvalid_0809" DOUBLE,
"mbl_rla06pctprof_0809" VARCHAR,
"mbl_rla07numvalid_0809" DOUBLE,
"mbl_rla07pctprof_0809" VARCHAR,
"mbl_rla08numvalid_0809" DOUBLE,
"mbl_rla08pctprof_0809" VARCHAR,
"mbl_rlahsnumvalid_0809" DOUBLE,
"mbl_rlahspctprof_0809" VARCHAR,
"mhi_rla03numvalid_0809" DOUBLE,
"mhi_rla03pctprof_0809" VARCHAR,
"mhi_rla04numvalid_0809" DOUBLE,
"mhi_rla04pctprof_0809" VARCHAR,
"mhi_rla05numvalid_0809" DOUBLE,
"mhi_rla05pctprof_0809" VARCHAR,
"mhi_rla06numvalid_0809" DOUBLE,
"mhi_rla06pctprof_0809" VARCHAR,
"mhi_rla07numvalid_0809" DOUBLE,
"mhi_rla07pctprof_0809" VARCHAR
);CREATE TABLE userssharedsdflealvlachvmntrsltsforstateassmntsinmathssy200809 (
"stnam" VARCHAR,
"fipst" BIGINT,
"leaid" BIGINT,
"leanm08" VARCHAR,
"all_mth00numvalid_0809" BIGINT,
"all_mth00pctprof_0809" VARCHAR,
"mam_mth00numvalid_0809" DOUBLE,
"mam_mth00pctprof_0809" VARCHAR,
"mas_mth00numvalid_0809" DOUBLE,
"mas_mth00pctprof_0809" VARCHAR,
"mbl_mth00numvalid_0809" DOUBLE,
"mbl_mth00pctprof_0809" VARCHAR,
"mhi_mth00numvalid_0809" DOUBLE,
"mhi_mth00pctprof_0809" VARCHAR,
"mtr_mth00numvalid_0809" DOUBLE,
"mtr_mth00pctprof_0809" VARCHAR,
"mwh_mth00numvalid_0809" DOUBLE,
"mwh_mth00pctprof_0809" VARCHAR,
"f_mth00numvalid_0809" DOUBLE,
"f_mth00pctprof_0809" VARCHAR,
"m_mth00numvalid_0809" DOUBLE,
"m_mth00pctprof_0809" VARCHAR,
"cwd_mth00numvalid_0809" DOUBLE,
"cwd_mth00pctprof_0809" VARCHAR,
"ecd_mth00numvalid_0809" DOUBLE,
"ecd_mth00pctprof_0809" VARCHAR,
"lep_mth00numvalid_0809" DOUBLE,
"lep_mth00pctprof_0809" VARCHAR,
"hom_mth00numvalid_0809" DOUBLE,
"hom_mth00pctprof_0809" VARCHAR,
"mig_mth00numvalid_0809" DOUBLE,
"mig_mth00pctprof_0809" VARCHAR,
"all_mth03numvalid_0809" DOUBLE,
"all_mth03pctprof_0809" VARCHAR,
"all_mth04numvalid_0809" DOUBLE,
"all_mth04pctprof_0809" VARCHAR,
"all_mth05numvalid_0809" DOUBLE,
"all_mth05pctprof_0809" VARCHAR,
"all_mth06numvalid_0809" DOUBLE,
"all_mth06pctprof_0809" VARCHAR,
"all_mth07numvalid_0809" DOUBLE,
"all_mth07pctprof_0809" VARCHAR,
"all_mth08numvalid_0809" DOUBLE,
"all_mth08pctprof_0809" VARCHAR,
"all_mthhsnumvalid_0809" DOUBLE,
"all_mthhspctprof_0809" VARCHAR,
"mam_mth03numvalid_0809" DOUBLE,
"mam_mth03pctprof_0809" VARCHAR,
"mam_mth04numvalid_0809" DOUBLE,
"mam_mth04pctprof_0809" VARCHAR,
"mam_mth05numvalid_0809" DOUBLE,
"mam_mth05pctprof_0809" VARCHAR,
"mam_mth06numvalid_0809" DOUBLE,
"mam_mth06pctprof_0809" VARCHAR,
"mam_mth07numvalid_0809" DOUBLE,
"mam_mth07pctprof_0809" VARCHAR,
"mam_mth08numvalid_0809" DOUBLE,
"mam_mth08pctprof_0809" VARCHAR,
"mam_mthhsnumvalid_0809" DOUBLE,
"mam_mthhspctprof_0809" VARCHAR,
"mas_mth03numvalid_0809" DOUBLE,
"mas_mth03pctprof_0809" VARCHAR,
"mas_mth04numvalid_0809" DOUBLE,
"mas_mth04pctprof_0809" VARCHAR,
"mas_mth05numvalid_0809" DOUBLE,
"mas_mth05pctprof_0809" VARCHAR,
"mas_mth06numvalid_0809" DOUBLE,
"mas_mth06pctprof_0809" VARCHAR,
"mas_mth07numvalid_0809" DOUBLE,
"mas_mth07pctprof_0809" VARCHAR,
"mas_mth08numvalid_0809" DOUBLE,
"mas_mth08pctprof_0809" VARCHAR,
"mas_mthhsnumvalid_0809" DOUBLE,
"mas_mthhspctprof_0809" VARCHAR,
"mbl_mth03numvalid_0809" DOUBLE,
"mbl_mth03pctprof_0809" VARCHAR,
"mbl_mth04numvalid_0809" DOUBLE,
"mbl_mth04pctprof_0809" VARCHAR,
"mbl_mth05numvalid_0809" DOUBLE,
"mbl_mth05pctprof_0809" VARCHAR,
"mbl_mth06numvalid_0809" DOUBLE,
"mbl_mth06pctprof_0809" VARCHAR,
"mbl_mth07numvalid_0809" DOUBLE,
"mbl_mth07pctprof_0809" VARCHAR,
"mbl_mth08numvalid_0809" DOUBLE,
"mbl_mth08pctprof_0809" VARCHAR,
"mbl_mthhsnumvalid_0809" DOUBLE,
"mbl_mthhspctprof_0809" VARCHAR,
"mhi_mth03numvalid_0809" DOUBLE,
"mhi_mth03pctprof_0809" VARCHAR,
"mhi_mth04numvalid_0809" DOUBLE,
"mhi_mth04pctprof_0809" VARCHAR,
"mhi_mth05numvalid_0809" DOUBLE,
"mhi_mth05pctprof_0809" VARCHAR,
"mhi_mth06numvalid_0809" DOUBLE,
"mhi_mth06pctprof_0809" VARCHAR,
"mhi_mth07numvalid_0809" DOUBLE,
"mhi_mth07pctprof_0809" VARCHAR,
"mhi_mth08numvalid_0809" DOUBLE,
"mhi_mth08pctprof_0809" VARCHAR
);Anyone who has the link will be able to view this.