Consolidated State Performance Report, 2010-11
Department of Education
@usgov.ed_gov_consolidated_state_performance_report_2010_11_51b81
Department of Education
@usgov.ed_gov_consolidated_state_performance_report_2010_11_51b81
CREATE TABLE achvmntrsltsstateassmtsmathssy201011 (
"stnam" VARCHAR,
"fipst" VARCHAR,
"leaid" VARCHAR,
"leanm10" VARCHAR,
"ncessch" VARCHAR,
"schnam10" VARCHAR,
"all_mth00numvalid_1011" VARCHAR,
"all_mth00pctprof_1011" VARCHAR,
"mam_mth00numvalid_1011" VARCHAR,
"mam_mth00pctprof_1011" VARCHAR,
"mas_mth00numvalid_1011" VARCHAR,
"mas_mth00pctprof_1011" VARCHAR,
"mbl_mth00numvalid_1011" VARCHAR,
"mbl_mth00pctprof_1011" VARCHAR,
"mhi_mth00numvalid_1011" VARCHAR,
"mhi_mth00pctprof_1011" VARCHAR,
"mtr_mth00numvalid_1011" VARCHAR,
"mtr_mth00pctprof_1011" VARCHAR,
"mwh_mth00numvalid_1011" VARCHAR,
"mwh_mth00pctprof_1011" VARCHAR,
"f_mth00numvalid_1011" VARCHAR,
"f_mth00pctprof_1011" VARCHAR,
"m_mth00numvalid_1011" VARCHAR,
"m_mth00pctprof_1011" VARCHAR,
"cwd_mth00numvalid_1011" VARCHAR,
"cwd_mth00pctprof_1011" VARCHAR,
"ecd_mth00numvalid_1011" VARCHAR,
"ecd_mth00pctprof_1011" VARCHAR,
"lep_mth00numvalid_1011" VARCHAR,
"lep_mth00pctprof_1011" VARCHAR,
"hom_mth00numvalid_1011" VARCHAR,
"hom_mth00pctprof_1011" VARCHAR,
"mig_mth00numvalid_1011" VARCHAR,
"mig_mth00pctprof_1011" VARCHAR,
"all_mth03numvalid_1011" VARCHAR,
"all_mth03pctprof_1011" VARCHAR,
"all_mth04numvalid_1011" VARCHAR,
"all_mth04pctprof_1011" VARCHAR,
"all_mth05numvalid_1011" VARCHAR,
"all_mth05pctprof_1011" VARCHAR,
"all_mth06numvalid_1011" VARCHAR,
"all_mth06pctprof_1011" VARCHAR,
"all_mth07numvalid_1011" VARCHAR,
"all_mth07pctprof_1011" VARCHAR,
"all_mth08numvalid_1011" VARCHAR,
"all_mth08pctprof_1011" VARCHAR,
"all_mthhsnumvalid_1011" VARCHAR,
"all_mthhspctprof_1011" VARCHAR,
"mam_mth03numvalid_1011" VARCHAR,
"mam_mth03pctprof_1011" VARCHAR,
"mam_mth04numvalid_1011" VARCHAR,
"mam_mth04pctprof_1011" VARCHAR,
"mam_mth05numvalid_1011" VARCHAR,
"mam_mth05pctprof_1011" VARCHAR,
"mam_mth06numvalid_1011" VARCHAR,
"mam_mth06pctprof_1011" VARCHAR,
"mam_mth07numvalid_1011" VARCHAR,
"mam_mth07pctprof_1011" VARCHAR,
"mam_mth08numvalid_1011" VARCHAR,
"mam_mth08pctprof_1011" VARCHAR,
"mam_mthhsnumvalid_1011" VARCHAR,
"mam_mthhspctprof_1011" VARCHAR,
"mas_mth03numvalid_1011" VARCHAR,
"mas_mth03pctprof_1011" VARCHAR,
"mas_mth04numvalid_1011" VARCHAR,
"mas_mth04pctprof_1011" VARCHAR,
"mas_mth05numvalid_1011" VARCHAR,
"mas_mth05pctprof_1011" VARCHAR,
"mas_mth06numvalid_1011" VARCHAR,
"mas_mth06pctprof_1011" VARCHAR,
"mas_mth07numvalid_1011" VARCHAR,
"mas_mth07pctprof_1011" VARCHAR,
"mas_mth08numvalid_1011" VARCHAR,
"mas_mth08pctprof_1011" VARCHAR,
"mas_mthhsnumvalid_1011" VARCHAR,
"mas_mthhspctprof_1011" VARCHAR,
"mbl_mth03numvalid_1011" VARCHAR,
"mbl_mth03pctprof_1011" VARCHAR,
"mbl_mth04numvalid_1011" VARCHAR,
"mbl_mth04pctprof_1011" VARCHAR,
"mbl_mth05numvalid_1011" VARCHAR,
"mbl_mth05pctprof_1011" VARCHAR,
"mbl_mth06numvalid_1011" VARCHAR,
"mbl_mth06pctprof_1011" VARCHAR,
"mbl_mth07numvalid_1011" VARCHAR,
"mbl_mth07pctprof_1011" VARCHAR,
"mbl_mth08numvalid_1011" VARCHAR,
"mbl_mth08pctprof_1011" VARCHAR,
"mbl_mthhsnumvalid_1011" VARCHAR,
"mbl_mthhspctprof_1011" VARCHAR,
"mhi_mth03numvalid_1011" VARCHAR,
"mhi_mth03pctprof_1011" VARCHAR,
"mhi_mth04numvalid_1011" VARCHAR,
"mhi_mth04pctprof_1011" VARCHAR,
"mhi_mth05numvalid_1011" VARCHAR,
"mhi_mth05pctprof_1011" VARCHAR,
"mhi_mth06numvalid_1011" VARCHAR,
"mhi_mth06pctprof_1011" VARCHAR,
"mhi_mth07numvalid_1011" VARCHAR,
"mhi_mth07pctprof_1011" VARCHAR
);
CREATE TABLE achvmntrsltsstateassmtsrlasy201011 (
"stnam" VARCHAR,
"fipst" VARCHAR,
"leaid" VARCHAR,
"leanm10" VARCHAR,
"ncessch" VARCHAR,
"schnam10" VARCHAR,
"all_rla00numvalid_1011" VARCHAR,
"all_rla00pctprof_1011" VARCHAR,
"mam_rla00numvalid_1011" VARCHAR,
"mam_rla00pctprof_1011" VARCHAR,
"mas_rla00numvalid_1011" VARCHAR,
"mas_rla00pctprof_1011" VARCHAR,
"mbl_rla00numvalid_1011" VARCHAR,
"mbl_rla00pctprof_1011" VARCHAR,
"mhi_rla00numvalid_1011" VARCHAR,
"mhi_rla00pctprof_1011" VARCHAR,
"mtr_rla00numvalid_1011" VARCHAR,
"mtr_rla00pctprof_1011" VARCHAR,
"mwh_rla00numvalid_1011" VARCHAR,
"mwh_rla00pctprof_1011" VARCHAR,
"f_rla00numvalid_1011" VARCHAR,
"f_rla00pctprof_1011" VARCHAR,
"m_rla00numvalid_1011" VARCHAR,
"m_rla00pctprof_1011" VARCHAR,
"cwd_rla00numvalid_1011" VARCHAR,
"cwd_rla00pctprof_1011" VARCHAR,
"ecd_rla00numvalid_1011" VARCHAR,
"ecd_rla00pctprof_1011" VARCHAR,
"lep_rla00numvalid_1011" VARCHAR,
"lep_rla00pctprof_1011" VARCHAR,
"hom_rla00numvalid_1011" VARCHAR,
"hom_rla00pctprof_1011" VARCHAR,
"mig_rla00numvalid_1011" VARCHAR,
"mig_rla00pctprof_1011" VARCHAR,
"all_rla03numvalid_1011" VARCHAR,
"all_rla03pctprof_1011" VARCHAR,
"all_rla04numvalid_1011" VARCHAR,
"all_rla04pctprof_1011" VARCHAR,
"all_rla05numvalid_1011" VARCHAR,
"all_rla05pctprof_1011" VARCHAR,
"all_rla06numvalid_1011" VARCHAR,
"all_rla06pctprof_1011" VARCHAR,
"all_rla07numvalid_1011" VARCHAR,
"all_rla07pctprof_1011" VARCHAR,
"all_rla08numvalid_1011" VARCHAR,
"all_rla08pctprof_1011" VARCHAR,
"all_rlahsnumvalid_1011" VARCHAR,
"all_rlahspctprof_1011" VARCHAR,
"mam_rla03numvalid_1011" VARCHAR,
"mam_rla03pctprof_1011" VARCHAR,
"mam_rla04numvalid_1011" VARCHAR,
"mam_rla04pctprof_1011" VARCHAR,
"mam_rla05numvalid_1011" VARCHAR,
"mam_rla05pctprof_1011" VARCHAR,
"mam_rla06numvalid_1011" VARCHAR,
"mam_rla06pctprof_1011" VARCHAR,
"mam_rla07numvalid_1011" VARCHAR,
"mam_rla07pctprof_1011" VARCHAR,
"mam_rla08numvalid_1011" VARCHAR,
"mam_rla08pctprof_1011" VARCHAR,
"mam_rlahsnumvalid_1011" VARCHAR,
"mam_rlahspctprof_1011" VARCHAR,
"mas_rla03numvalid_1011" VARCHAR,
"mas_rla03pctprof_1011" VARCHAR,
"mas_rla04numvalid_1011" VARCHAR,
"mas_rla04pctprof_1011" VARCHAR,
"mas_rla05numvalid_1011" VARCHAR,
"mas_rla05pctprof_1011" VARCHAR,
"mas_rla06numvalid_1011" VARCHAR,
"mas_rla06pctprof_1011" VARCHAR,
"mas_rla07numvalid_1011" VARCHAR,
"mas_rla07pctprof_1011" VARCHAR,
"mas_rla08numvalid_1011" VARCHAR,
"mas_rla08pctprof_1011" VARCHAR,
"mas_rlahsnumvalid_1011" VARCHAR,
"mas_rlahspctprof_1011" VARCHAR,
"mbl_rla03numvalid_1011" VARCHAR,
"mbl_rla03pctprof_1011" VARCHAR,
"mbl_rla04numvalid_1011" VARCHAR,
"mbl_rla04pctprof_1011" VARCHAR,
"mbl_rla05numvalid_1011" VARCHAR,
"mbl_rla05pctprof_1011" VARCHAR,
"mbl_rla06numvalid_1011" VARCHAR,
"mbl_rla06pctprof_1011" VARCHAR,
"mbl_rla07numvalid_1011" VARCHAR,
"mbl_rla07pctprof_1011" VARCHAR,
"mbl_rla08numvalid_1011" VARCHAR,
"mbl_rla08pctprof_1011" VARCHAR,
"mbl_rlahsnumvalid_1011" VARCHAR,
"mbl_rlahspctprof_1011" VARCHAR,
"mhi_rla03numvalid_1011" VARCHAR,
"mhi_rla03pctprof_1011" VARCHAR,
"mhi_rla04numvalid_1011" VARCHAR,
"mhi_rla04pctprof_1011" VARCHAR,
"mhi_rla05numvalid_1011" VARCHAR,
"mhi_rla05pctprof_1011" VARCHAR,
"mhi_rla06numvalid_1011" VARCHAR,
"mhi_rla06pctprof_1011" VARCHAR,
"mhi_rla07numvalid_1011" VARCHAR,
"mhi_rla07pctprof_1011" VARCHAR
);
CREATE TABLE userssharedsdfleaachvrsltsassessmathematicssy201011 (
"stnam" VARCHAR,
"fipst" BIGINT,
"leaid" BIGINT,
"leanm10" VARCHAR,
"all_mth00numvalid_1011" BIGINT,
"all_mth00pctprof_1011" VARCHAR,
"mam_mth00numvalid_1011" DOUBLE,
"mam_mth00pctprof_1011" VARCHAR,
"mas_mth00numvalid_1011" DOUBLE,
"mas_mth00pctprof_1011" VARCHAR,
"mbl_mth00numvalid_1011" DOUBLE,
"mbl_mth00pctprof_1011" VARCHAR,
"mhi_mth00numvalid_1011" DOUBLE,
"mhi_mth00pctprof_1011" VARCHAR,
"mtr_mth00numvalid_1011" DOUBLE,
"mtr_mth00pctprof_1011" VARCHAR,
"mwh_mth00numvalid_1011" DOUBLE,
"mwh_mth00pctprof_1011" VARCHAR,
"f_mth00numvalid_1011" DOUBLE,
"f_mth00pctprof_1011" VARCHAR,
"m_mth00numvalid_1011" DOUBLE,
"m_mth00pctprof_1011" VARCHAR,
"cwd_mth00numvalid_1011" DOUBLE,
"cwd_mth00pctprof_1011" VARCHAR,
"ecd_mth00numvalid_1011" DOUBLE,
"ecd_mth00pctprof_1011" VARCHAR,
"lep_mth00numvalid_1011" DOUBLE,
"lep_mth00pctprof_1011" VARCHAR,
"hom_mth00numvalid_1011" DOUBLE,
"hom_mth00pctprof_1011" VARCHAR,
"mig_mth00numvalid_1011" DOUBLE,
"mig_mth00pctprof_1011" VARCHAR,
"all_mth03numvalid_1011" DOUBLE,
"all_mth03pctprof_1011" VARCHAR,
"all_mth04numvalid_1011" DOUBLE,
"all_mth04pctprof_1011" VARCHAR,
"all_mth05numvalid_1011" DOUBLE,
"all_mth05pctprof_1011" VARCHAR,
"all_mth06numvalid_1011" DOUBLE,
"all_mth06pctprof_1011" VARCHAR,
"all_mth07numvalid_1011" DOUBLE,
"all_mth07pctprof_1011" VARCHAR,
"all_mth08numvalid_1011" DOUBLE,
"all_mth08pctprof_1011" VARCHAR,
"all_mthhsnumvalid_1011" DOUBLE,
"all_mthhspctprof_1011" VARCHAR,
"mam_mth03numvalid_1011" DOUBLE,
"mam_mth03pctprof_1011" VARCHAR,
"mam_mth04numvalid_1011" DOUBLE,
"mam_mth04pctprof_1011" VARCHAR,
"mam_mth05numvalid_1011" DOUBLE,
"mam_mth05pctprof_1011" VARCHAR,
"mam_mth06numvalid_1011" DOUBLE,
"mam_mth06pctprof_1011" VARCHAR,
"mam_mth07numvalid_1011" DOUBLE,
"mam_mth07pctprof_1011" VARCHAR,
"mam_mth08numvalid_1011" DOUBLE,
"mam_mth08pctprof_1011" VARCHAR,
"mam_mthhsnumvalid_1011" DOUBLE,
"mam_mthhspctprof_1011" VARCHAR,
"mas_mth03numvalid_1011" DOUBLE,
"mas_mth03pctprof_1011" VARCHAR,
"mas_mth04numvalid_1011" DOUBLE,
"mas_mth04pctprof_1011" VARCHAR,
"mas_mth05numvalid_1011" DOUBLE,
"mas_mth05pctprof_1011" VARCHAR,
"mas_mth06numvalid_1011" DOUBLE,
"mas_mth06pctprof_1011" VARCHAR,
"mas_mth07numvalid_1011" DOUBLE,
"mas_mth07pctprof_1011" VARCHAR,
"mas_mth08numvalid_1011" DOUBLE,
"mas_mth08pctprof_1011" VARCHAR,
"mas_mthhsnumvalid_1011" DOUBLE,
"mas_mthhspctprof_1011" VARCHAR,
"mbl_mth03numvalid_1011" DOUBLE,
"mbl_mth03pctprof_1011" VARCHAR,
"mbl_mth04numvalid_1011" DOUBLE,
"mbl_mth04pctprof_1011" VARCHAR,
"mbl_mth05numvalid_1011" DOUBLE,
"mbl_mth05pctprof_1011" VARCHAR,
"mbl_mth06numvalid_1011" DOUBLE,
"mbl_mth06pctprof_1011" VARCHAR,
"mbl_mth07numvalid_1011" DOUBLE,
"mbl_mth07pctprof_1011" VARCHAR,
"mbl_mth08numvalid_1011" DOUBLE,
"mbl_mth08pctprof_1011" VARCHAR,
"mbl_mthhsnumvalid_1011" DOUBLE,
"mbl_mthhspctprof_1011" VARCHAR,
"mhi_mth03numvalid_1011" DOUBLE,
"mhi_mth03pctprof_1011" VARCHAR,
"mhi_mth04numvalid_1011" DOUBLE,
"mhi_mth04pctprof_1011" VARCHAR,
"mhi_mth05numvalid_1011" DOUBLE,
"mhi_mth05pctprof_1011" VARCHAR,
"mhi_mth06numvalid_1011" DOUBLE,
"mhi_mth06pctprof_1011" VARCHAR,
"mhi_mth07numvalid_1011" DOUBLE,
"mhi_mth07pctprof_1011" VARCHAR,
"mhi_mth08numvalid_1011" DOUBLE,
"mhi_mth08pctprof_1011" VARCHAR
);
CREATE TABLE userssharedsdflealvlachvmntrsltsforstateassmntsinrlasy201011 (
"stnam" VARCHAR,
"fipst" BIGINT,
"leaid" BIGINT,
"leanm10" VARCHAR,
"all_rla00numvalid_1011" BIGINT,
"all_rla00pctprof_1011" VARCHAR,
"mam_rla00numvalid_1011" DOUBLE,
"mam_rla00pctprof_1011" VARCHAR,
"mas_rla00numvalid_1011" DOUBLE,
"mas_rla00pctprof_1011" VARCHAR,
"mbl_rla00numvalid_1011" DOUBLE,
"mbl_rla00pctprof_1011" VARCHAR,
"mhi_rla00numvalid_1011" DOUBLE,
"mhi_rla00pctprof_1011" VARCHAR,
"mtr_rla00numvalid_1011" DOUBLE,
"mtr_rla00pctprof_1011" VARCHAR,
"mwh_rla00numvalid_1011" DOUBLE,
"mwh_rla00pctprof_1011" VARCHAR,
"f_rla00numvalid_1011" DOUBLE,
"f_rla00pctprof_1011" VARCHAR,
"m_rla00numvalid_1011" DOUBLE,
"m_rla00pctprof_1011" VARCHAR,
"cwd_rla00numvalid_1011" DOUBLE,
"cwd_rla00pctprof_1011" VARCHAR,
"ecd_rla00numvalid_1011" DOUBLE,
"ecd_rla00pctprof_1011" VARCHAR,
"lep_rla00numvalid_1011" DOUBLE,
"lep_rla00pctprof_1011" VARCHAR,
"hom_rla00numvalid_1011" DOUBLE,
"hom_rla00pctprof_1011" VARCHAR,
"mig_rla00numvalid_1011" DOUBLE,
"mig_rla00pctprof_1011" VARCHAR,
"all_rla03numvalid_1011" DOUBLE,
"all_rla03pctprof_1011" VARCHAR,
"all_rla04numvalid_1011" DOUBLE,
"all_rla04pctprof_1011" VARCHAR,
"all_rla05numvalid_1011" DOUBLE,
"all_rla05pctprof_1011" VARCHAR,
"all_rla06numvalid_1011" DOUBLE,
"all_rla06pctprof_1011" VARCHAR,
"all_rla07numvalid_1011" DOUBLE,
"all_rla07pctprof_1011" VARCHAR,
"all_rla08numvalid_1011" DOUBLE,
"all_rla08pctprof_1011" VARCHAR,
"all_rlahsnumvalid_1011" DOUBLE,
"all_rlahspctprof_1011" VARCHAR,
"mam_rla03numvalid_1011" DOUBLE,
"mam_rla03pctprof_1011" VARCHAR,
"mam_rla04numvalid_1011" DOUBLE,
"mam_rla04pctprof_1011" VARCHAR,
"mam_rla05numvalid_1011" DOUBLE,
"mam_rla05pctprof_1011" VARCHAR,
"mam_rla06numvalid_1011" DOUBLE,
"mam_rla06pctprof_1011" VARCHAR,
"mam_rla07numvalid_1011" DOUBLE,
"mam_rla07pctprof_1011" VARCHAR,
"mam_rla08numvalid_1011" DOUBLE,
"mam_rla08pctprof_1011" VARCHAR,
"mam_rlahsnumvalid_1011" DOUBLE,
"mam_rlahspctprof_1011" VARCHAR,
"mas_rla03numvalid_1011" DOUBLE,
"mas_rla03pctprof_1011" VARCHAR,
"mas_rla04numvalid_1011" DOUBLE,
"mas_rla04pctprof_1011" VARCHAR,
"mas_rla05numvalid_1011" DOUBLE,
"mas_rla05pctprof_1011" VARCHAR,
"mas_rla06numvalid_1011" DOUBLE,
"mas_rla06pctprof_1011" VARCHAR,
"mas_rla07numvalid_1011" DOUBLE,
"mas_rla07pctprof_1011" VARCHAR,
"mas_rla08numvalid_1011" DOUBLE,
"mas_rla08pctprof_1011" VARCHAR,
"mas_rlahsnumvalid_1011" DOUBLE,
"mas_rlahspctprof_1011" VARCHAR,
"mbl_rla03numvalid_1011" DOUBLE,
"mbl_rla03pctprof_1011" VARCHAR,
"mbl_rla04numvalid_1011" DOUBLE,
"mbl_rla04pctprof_1011" VARCHAR,
"mbl_rla05numvalid_1011" DOUBLE,
"mbl_rla05pctprof_1011" VARCHAR,
"mbl_rla06numvalid_1011" DOUBLE,
"mbl_rla06pctprof_1011" VARCHAR,
"mbl_rla07numvalid_1011" DOUBLE,
"mbl_rla07pctprof_1011" VARCHAR,
"mbl_rla08numvalid_1011" DOUBLE,
"mbl_rla08pctprof_1011" VARCHAR,
"mbl_rlahsnumvalid_1011" DOUBLE,
"mbl_rlahspctprof_1011" VARCHAR,
"mhi_rla03numvalid_1011" DOUBLE,
"mhi_rla03pctprof_1011" VARCHAR,
"mhi_rla04numvalid_1011" DOUBLE,
"mhi_rla04pctprof_1011" VARCHAR,
"mhi_rla05numvalid_1011" DOUBLE,
"mhi_rla05pctprof_1011" VARCHAR,
"mhi_rla06numvalid_1011" DOUBLE,
"mhi_rla06pctprof_1011" VARCHAR,
"mhi_rla07numvalid_1011" DOUBLE,
"mhi_rla07pctprof_1011" VARCHAR,
"mhi_rla08numvalid_1011" DOUBLE,
"mhi_rla08pctprof_1011" VARCHAR
);
Anyone who has the link will be able to view this.