Baselight
Sign In

Civil Rights Data Collection State Files 2015-16

Department of Education

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8

Loading...
Loading...

About this Dataset

Civil Rights Data Collection State Files 2015-16

Information on the Civil Rights Data Collection (CRDC), specifically geared for use of the CRDC in the development of State and local report cards. Data on this website is derived directly from the national public-use data file the Office for Civil Rights (OCR) prepares of the CRDC data.
OCR places a high priority on ensuring the accuracy of CRDC data. The data submission system includes a series of embedded edit checks to ensure significant data errors are corrected before a district submits its data. Additionally, each district is required to certify the accuracy of its submission. Although OCR performs these robust data quality checks, there are known data issues and concerns. More information on data quality can be found in the 2015-16 CRDC Data Notes (https://ocrdata.ed.gov/DataNotes)
Organization: Department of Education
Last updated: 2023-08-12T23:21:48.365247
Tags: evaluation, ocr, performance, policy-analysis, trend-analysis

Tables

Alaska - File As Of August 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.alaska_file_as_of_august_2018
  • 1.64 MB
  • 503 rows
  • 1839 columns
Loading... 

CREATE TABLE alaska_file_as_of_august_2018 (
  "lea_state" VARCHAR,
  "lea_state_name" VARCHAR,
  "leaid" BIGINT,
  "lea_name" VARCHAR,
  "schid" BIGINT,
  "sch_name" VARCHAR,
  "combokey" BIGINT,
  "jj" VARCHAR,
  "ccd_latcod" DOUBLE,
  "ccd_loncod" DOUBLE,
  "nces_school_id" DOUBLE,
  "sch_grade_ps" VARCHAR,
  "sch_grade_kg" VARCHAR,
  "sch_grade_g01" VARCHAR,
  "sch_grade_g02" VARCHAR,
  "sch_grade_g03" VARCHAR,
  "sch_grade_g04" VARCHAR,
  "sch_grade_g05" VARCHAR,
  "sch_grade_g06" VARCHAR,
  "sch_grade_g07" VARCHAR,
  "sch_grade_g08" VARCHAR,
  "sch_grade_g09" VARCHAR,
  "sch_grade_g10" VARCHAR,
  "sch_grade_g11" VARCHAR,
  "sch_grade_g12" VARCHAR,
  "sch_grade_ug" VARCHAR,
  "sch_ugdetail_es" VARCHAR,
  "sch_ugdetail_ms" VARCHAR,
  "sch_ugdetail_hs" VARCHAR,
  "sch_status_sped" VARCHAR,
  "sch_status_magnet" VARCHAR,
  "sch_status_charter" VARCHAR,
  "sch_status_alt" VARCHAR,
  "sch_magnetdetail" VARCHAR,
  "sch_altfocus" VARCHAR,
  "sch_psenr_nonidea_a3" VARCHAR,
  "sch_psenr_nonidea_a4" VARCHAR,
  "sch_psenr_nonidea_a5" VARCHAR,
  "sch_psenr_hi_m" BIGINT,
  "sch_psenr_hi_f" BIGINT,
  "sch_psenr_am_m" BIGINT,
  "sch_psenr_am_f" BIGINT,
  "sch_psenr_as_m" BIGINT,
  "sch_psenr_as_f" BIGINT,
  "sch_psenr_hp_m" BIGINT,
  "sch_psenr_hp_f" BIGINT,
  "sch_psenr_bl_m" BIGINT,
  "sch_psenr_bl_f" BIGINT,
  "sch_psenr_wh_m" BIGINT,
  "sch_psenr_wh_f" BIGINT,
  "sch_psenr_tr_m" BIGINT,
  "sch_psenr_tr_f" BIGINT,
  "tot_psenr_m" BIGINT,
  "tot_psenr_f" BIGINT,
  "sch_psenr_lep_m" BIGINT,
  "sch_psenr_lep_f" BIGINT,
  "sch_psenr_idea_m" BIGINT,
  "sch_psenr_idea_f" BIGINT,
  "sch_enr_hi_m" BIGINT,
  "sch_enr_hi_f" BIGINT,
  "sch_enr_am_m" BIGINT,
  "sch_enr_am_f" BIGINT,
  "sch_enr_as_m" BIGINT,
  "sch_enr_as_f" BIGINT,
  "sch_enr_hp_m" BIGINT,
  "sch_enr_hp_f" BIGINT,
  "sch_enr_bl_m" BIGINT,
  "sch_enr_bl_f" BIGINT,
  "sch_enr_wh_m" BIGINT,
  "sch_enr_wh_f" BIGINT,
  "sch_enr_tr_m" BIGINT,
  "sch_enr_tr_f" BIGINT,
  "tot_enr_m" BIGINT,
  "tot_enr_f" BIGINT,
  "sch_enr_lep_m" BIGINT,
  "sch_enr_lep_f" BIGINT,
  "sch_enr_504_m" BIGINT,
  "sch_enr_504_f" BIGINT,
  "sch_enr_idea_m" BIGINT,
  "sch_enr_idea_f" BIGINT,
  "sch_lepenr_hi_m" BIGINT,
  "sch_lepenr_hi_f" BIGINT,
  "sch_lepenr_am_m" BIGINT,
  "sch_lepenr_am_f" BIGINT,
  "sch_lepenr_as_m" BIGINT,
  "sch_lepenr_as_f" BIGINT,
  "sch_lepenr_hp_m" BIGINT,
  "sch_lepenr_hp_f" BIGINT,
  "sch_lepenr_bl_m" BIGINT,
  "sch_lepenr_bl_f" BIGINT,
  "sch_lepenr_wh_m" BIGINT,
  "sch_lepenr_wh_f" BIGINT,
  "sch_lepenr_tr_m" BIGINT,
  "sch_lepenr_tr_f" BIGINT,
  "tot_lepenr_m" BIGINT,
  "tot_lepenr_f" BIGINT,
  "sch_lepprogenr_hi_m" BIGINT,
  "sch_lepprogenr_hi_f" BIGINT,
  "sch_lepprogenr_am_m" BIGINT,
  "sch_lepprogenr_am_f" BIGINT
);

Alaska - File As Of October 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.alaska_file_as_of_october_2018
  • 1.64 MB
  • 503 rows
  • 1839 columns
Loading... 

CREATE TABLE alaska_file_as_of_october_2018 (
  "lea_state" VARCHAR,
  "lea_state_name" VARCHAR,
  "leaid" BIGINT,
  "lea_name" VARCHAR,
  "schid" BIGINT,
  "sch_name" VARCHAR,
  "combokey" BIGINT,
  "jj" VARCHAR,
  "ccd_latcod" DOUBLE,
  "ccd_loncod" DOUBLE,
  "nces_school_id" DOUBLE,
  "sch_grade_ps" VARCHAR,
  "sch_grade_kg" VARCHAR,
  "sch_grade_g01" VARCHAR,
  "sch_grade_g02" VARCHAR,
  "sch_grade_g03" VARCHAR,
  "sch_grade_g04" VARCHAR,
  "sch_grade_g05" VARCHAR,
  "sch_grade_g06" VARCHAR,
  "sch_grade_g07" VARCHAR,
  "sch_grade_g08" VARCHAR,
  "sch_grade_g09" VARCHAR,
  "sch_grade_g10" VARCHAR,
  "sch_grade_g11" VARCHAR,
  "sch_grade_g12" VARCHAR,
  "sch_grade_ug" VARCHAR,
  "sch_ugdetail_es" VARCHAR,
  "sch_ugdetail_ms" VARCHAR,
  "sch_ugdetail_hs" VARCHAR,
  "sch_status_sped" VARCHAR,
  "sch_status_magnet" VARCHAR,
  "sch_status_charter" VARCHAR,
  "sch_status_alt" VARCHAR,
  "sch_magnetdetail" VARCHAR,
  "sch_altfocus" VARCHAR,
  "sch_psenr_nonidea_a3" VARCHAR,
  "sch_psenr_nonidea_a4" VARCHAR,
  "sch_psenr_nonidea_a5" VARCHAR,
  "sch_psenr_hi_m" BIGINT,
  "sch_psenr_hi_f" BIGINT,
  "sch_psenr_am_m" BIGINT,
  "sch_psenr_am_f" BIGINT,
  "sch_psenr_as_m" BIGINT,
  "sch_psenr_as_f" BIGINT,
  "sch_psenr_hp_m" BIGINT,
  "sch_psenr_hp_f" BIGINT,
  "sch_psenr_bl_m" BIGINT,
  "sch_psenr_bl_f" BIGINT,
  "sch_psenr_wh_m" BIGINT,
  "sch_psenr_wh_f" BIGINT,
  "sch_psenr_tr_m" BIGINT,
  "sch_psenr_tr_f" BIGINT,
  "tot_psenr_m" BIGINT,
  "tot_psenr_f" BIGINT,
  "sch_psenr_lep_m" BIGINT,
  "sch_psenr_lep_f" BIGINT,
  "sch_psenr_idea_m" BIGINT,
  "sch_psenr_idea_f" BIGINT,
  "sch_enr_hi_m" BIGINT,
  "sch_enr_hi_f" BIGINT,
  "sch_enr_am_m" BIGINT,
  "sch_enr_am_f" BIGINT,
  "sch_enr_as_m" BIGINT,
  "sch_enr_as_f" BIGINT,
  "sch_enr_hp_m" BIGINT,
  "sch_enr_hp_f" BIGINT,
  "sch_enr_bl_m" BIGINT,
  "sch_enr_bl_f" BIGINT,
  "sch_enr_wh_m" BIGINT,
  "sch_enr_wh_f" BIGINT,
  "sch_enr_tr_m" BIGINT,
  "sch_enr_tr_f" BIGINT,
  "tot_enr_m" BIGINT,
  "tot_enr_f" BIGINT,
  "sch_enr_lep_m" BIGINT,
  "sch_enr_lep_f" BIGINT,
  "sch_enr_504_m" BIGINT,
  "sch_enr_504_f" BIGINT,
  "sch_enr_idea_m" BIGINT,
  "sch_enr_idea_f" BIGINT,
  "sch_lepenr_hi_m" BIGINT,
  "sch_lepenr_hi_f" BIGINT,
  "sch_lepenr_am_m" BIGINT,
  "sch_lepenr_am_f" BIGINT,
  "sch_lepenr_as_m" BIGINT,
  "sch_lepenr_as_f" BIGINT,
  "sch_lepenr_hp_m" BIGINT,
  "sch_lepenr_hp_f" BIGINT,
  "sch_lepenr_bl_m" BIGINT,
  "sch_lepenr_bl_f" BIGINT,
  "sch_lepenr_wh_m" BIGINT,
  "sch_lepenr_wh_f" BIGINT,
  "sch_lepenr_tr_m" BIGINT,
  "sch_lepenr_tr_f" BIGINT,
  "tot_lepenr_m" BIGINT,
  "tot_lepenr_f" BIGINT,
  "sch_lepprogenr_hi_m" BIGINT,
  "sch_lepprogenr_hi_f" BIGINT,
  "sch_lepprogenr_am_m" BIGINT,
  "sch_lepprogenr_am_f" BIGINT
);

Arizona - File As Of August 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.arizona_file_as_of_august_2018
  • 2.5 MB
  • 1977 rows
  • 1839 columns
Loading... 

CREATE TABLE arizona_file_as_of_august_2018 (
  "lea_state" VARCHAR,
  "lea_state_name" VARCHAR,
  "leaid" BIGINT,
  "lea_name" VARCHAR,
  "schid" BIGINT,
  "sch_name" VARCHAR,
  "combokey" BIGINT,
  "jj" VARCHAR,
  "ccd_latcod" DOUBLE,
  "ccd_loncod" DOUBLE,
  "nces_school_id" DOUBLE,
  "sch_grade_ps" VARCHAR,
  "sch_grade_kg" VARCHAR,
  "sch_grade_g01" VARCHAR,
  "sch_grade_g02" VARCHAR,
  "sch_grade_g03" VARCHAR,
  "sch_grade_g04" VARCHAR,
  "sch_grade_g05" VARCHAR,
  "sch_grade_g06" VARCHAR,
  "sch_grade_g07" VARCHAR,
  "sch_grade_g08" VARCHAR,
  "sch_grade_g09" VARCHAR,
  "sch_grade_g10" VARCHAR,
  "sch_grade_g11" VARCHAR,
  "sch_grade_g12" VARCHAR,
  "sch_grade_ug" VARCHAR,
  "sch_ugdetail_es" VARCHAR,
  "sch_ugdetail_ms" VARCHAR,
  "sch_ugdetail_hs" VARCHAR,
  "sch_status_sped" VARCHAR,
  "sch_status_magnet" VARCHAR,
  "sch_status_charter" VARCHAR,
  "sch_status_alt" VARCHAR,
  "sch_magnetdetail" VARCHAR,
  "sch_altfocus" VARCHAR,
  "sch_psenr_nonidea_a3" VARCHAR,
  "sch_psenr_nonidea_a4" VARCHAR,
  "sch_psenr_nonidea_a5" VARCHAR,
  "sch_psenr_hi_m" BIGINT,
  "sch_psenr_hi_f" BIGINT,
  "sch_psenr_am_m" BIGINT,
  "sch_psenr_am_f" BIGINT,
  "sch_psenr_as_m" BIGINT,
  "sch_psenr_as_f" BIGINT,
  "sch_psenr_hp_m" BIGINT,
  "sch_psenr_hp_f" BIGINT,
  "sch_psenr_bl_m" BIGINT,
  "sch_psenr_bl_f" BIGINT,
  "sch_psenr_wh_m" BIGINT,
  "sch_psenr_wh_f" BIGINT,
  "sch_psenr_tr_m" BIGINT,
  "sch_psenr_tr_f" BIGINT,
  "tot_psenr_m" BIGINT,
  "tot_psenr_f" BIGINT,
  "sch_psenr_lep_m" BIGINT,
  "sch_psenr_lep_f" BIGINT,
  "sch_psenr_idea_m" BIGINT,
  "sch_psenr_idea_f" BIGINT,
  "sch_enr_hi_m" BIGINT,
  "sch_enr_hi_f" BIGINT,
  "sch_enr_am_m" BIGINT,
  "sch_enr_am_f" BIGINT,
  "sch_enr_as_m" BIGINT,
  "sch_enr_as_f" BIGINT,
  "sch_enr_hp_m" BIGINT,
  "sch_enr_hp_f" BIGINT,
  "sch_enr_bl_m" BIGINT,
  "sch_enr_bl_f" BIGINT,
  "sch_enr_wh_m" BIGINT,
  "sch_enr_wh_f" BIGINT,
  "sch_enr_tr_m" BIGINT,
  "sch_enr_tr_f" BIGINT,
  "tot_enr_m" BIGINT,
  "tot_enr_f" BIGINT,
  "sch_enr_lep_m" BIGINT,
  "sch_enr_lep_f" BIGINT,
  "sch_enr_504_m" BIGINT,
  "sch_enr_504_f" BIGINT,
  "sch_enr_idea_m" BIGINT,
  "sch_enr_idea_f" BIGINT,
  "sch_lepenr_hi_m" BIGINT,
  "sch_lepenr_hi_f" BIGINT,
  "sch_lepenr_am_m" BIGINT,
  "sch_lepenr_am_f" BIGINT,
  "sch_lepenr_as_m" BIGINT,
  "sch_lepenr_as_f" BIGINT,
  "sch_lepenr_hp_m" BIGINT,
  "sch_lepenr_hp_f" BIGINT,
  "sch_lepenr_bl_m" BIGINT,
  "sch_lepenr_bl_f" BIGINT,
  "sch_lepenr_wh_m" BIGINT,
  "sch_lepenr_wh_f" BIGINT,
  "sch_lepenr_tr_m" BIGINT,
  "sch_lepenr_tr_f" BIGINT,
  "tot_lepenr_m" BIGINT,
  "tot_lepenr_f" BIGINT,
  "sch_lepprogenr_hi_m" BIGINT,
  "sch_lepprogenr_hi_f" BIGINT,
  "sch_lepprogenr_am_m" BIGINT,
  "sch_lepprogenr_am_f" BIGINT
);

Arizona - File As Of October 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.arizona_file_as_of_october_2018
  • 2.49 MB
  • 1977 rows
  • 1839 columns
Loading... 

CREATE TABLE arizona_file_as_of_october_2018 (
  "lea_state" VARCHAR,
  "lea_state_name" VARCHAR,
  "leaid" BIGINT,
  "lea_name" VARCHAR,
  "schid" BIGINT,
  "sch_name" VARCHAR,
  "combokey" BIGINT,
  "jj" VARCHAR,
  "ccd_latcod" DOUBLE,
  "ccd_loncod" DOUBLE,
  "nces_school_id" DOUBLE,
  "sch_grade_ps" VARCHAR,
  "sch_grade_kg" VARCHAR,
  "sch_grade_g01" VARCHAR,
  "sch_grade_g02" VARCHAR,
  "sch_grade_g03" VARCHAR,
  "sch_grade_g04" VARCHAR,
  "sch_grade_g05" VARCHAR,
  "sch_grade_g06" VARCHAR,
  "sch_grade_g07" VARCHAR,
  "sch_grade_g08" VARCHAR,
  "sch_grade_g09" VARCHAR,
  "sch_grade_g10" VARCHAR,
  "sch_grade_g11" VARCHAR,
  "sch_grade_g12" VARCHAR,
  "sch_grade_ug" VARCHAR,
  "sch_ugdetail_es" VARCHAR,
  "sch_ugdetail_ms" VARCHAR,
  "sch_ugdetail_hs" VARCHAR,
  "sch_status_sped" VARCHAR,
  "sch_status_magnet" VARCHAR,
  "sch_status_charter" VARCHAR,
  "sch_status_alt" VARCHAR,
  "sch_magnetdetail" VARCHAR,
  "sch_altfocus" VARCHAR,
  "sch_psenr_nonidea_a3" VARCHAR,
  "sch_psenr_nonidea_a4" VARCHAR,
  "sch_psenr_nonidea_a5" VARCHAR,
  "sch_psenr_hi_m" BIGINT,
  "sch_psenr_hi_f" BIGINT,
  "sch_psenr_am_m" BIGINT,
  "sch_psenr_am_f" BIGINT,
  "sch_psenr_as_m" BIGINT,
  "sch_psenr_as_f" BIGINT,
  "sch_psenr_hp_m" BIGINT,
  "sch_psenr_hp_f" BIGINT,
  "sch_psenr_bl_m" BIGINT,
  "sch_psenr_bl_f" BIGINT,
  "sch_psenr_wh_m" BIGINT,
  "sch_psenr_wh_f" BIGINT,
  "sch_psenr_tr_m" BIGINT,
  "sch_psenr_tr_f" BIGINT,
  "tot_psenr_m" BIGINT,
  "tot_psenr_f" BIGINT,
  "sch_psenr_lep_m" BIGINT,
  "sch_psenr_lep_f" BIGINT,
  "sch_psenr_idea_m" BIGINT,
  "sch_psenr_idea_f" BIGINT,
  "sch_enr_hi_m" BIGINT,
  "sch_enr_hi_f" BIGINT,
  "sch_enr_am_m" BIGINT,
  "sch_enr_am_f" BIGINT,
  "sch_enr_as_m" BIGINT,
  "sch_enr_as_f" BIGINT,
  "sch_enr_hp_m" BIGINT,
  "sch_enr_hp_f" BIGINT,
  "sch_enr_bl_m" BIGINT,
  "sch_enr_bl_f" BIGINT,
  "sch_enr_wh_m" BIGINT,
  "sch_enr_wh_f" BIGINT,
  "sch_enr_tr_m" BIGINT,
  "sch_enr_tr_f" BIGINT,
  "tot_enr_m" BIGINT,
  "tot_enr_f" BIGINT,
  "sch_enr_lep_m" BIGINT,
  "sch_enr_lep_f" BIGINT,
  "sch_enr_504_m" BIGINT,
  "sch_enr_504_f" BIGINT,
  "sch_enr_idea_m" BIGINT,
  "sch_enr_idea_f" BIGINT,
  "sch_lepenr_hi_m" BIGINT,
  "sch_lepenr_hi_f" BIGINT,
  "sch_lepenr_am_m" BIGINT,
  "sch_lepenr_am_f" BIGINT,
  "sch_lepenr_as_m" BIGINT,
  "sch_lepenr_as_f" BIGINT,
  "sch_lepenr_hp_m" BIGINT,
  "sch_lepenr_hp_f" BIGINT,
  "sch_lepenr_bl_m" BIGINT,
  "sch_lepenr_bl_f" BIGINT,
  "sch_lepenr_wh_m" BIGINT,
  "sch_lepenr_wh_f" BIGINT,
  "sch_lepenr_tr_m" BIGINT,
  "sch_lepenr_tr_f" BIGINT,
  "tot_lepenr_m" BIGINT,
  "tot_lepenr_f" BIGINT,
  "sch_lepprogenr_hi_m" BIGINT,
  "sch_lepprogenr_hi_f" BIGINT,
  "sch_lepprogenr_am_m" BIGINT,
  "sch_lepprogenr_am_f" BIGINT
);

Arkansas - File As Of August 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.arkansas_file_as_of_august_2018
  • 2.12 MB
  • 1092 rows
  • 1839 columns
Loading... 

CREATE TABLE arkansas_file_as_of_august_2018 (
  "lea_state" VARCHAR,
  "lea_state_name" VARCHAR,
  "leaid" BIGINT,
  "lea_name" VARCHAR,
  "schid" BIGINT,
  "sch_name" VARCHAR,
  "combokey" BIGINT,
  "jj" VARCHAR,
  "ccd_latcod" DOUBLE,
  "ccd_loncod" DOUBLE,
  "nces_school_id" DOUBLE,
  "sch_grade_ps" VARCHAR,
  "sch_grade_kg" VARCHAR,
  "sch_grade_g01" VARCHAR,
  "sch_grade_g02" VARCHAR,
  "sch_grade_g03" VARCHAR,
  "sch_grade_g04" VARCHAR,
  "sch_grade_g05" VARCHAR,
  "sch_grade_g06" VARCHAR,
  "sch_grade_g07" VARCHAR,
  "sch_grade_g08" VARCHAR,
  "sch_grade_g09" VARCHAR,
  "sch_grade_g10" VARCHAR,
  "sch_grade_g11" VARCHAR,
  "sch_grade_g12" VARCHAR,
  "sch_grade_ug" VARCHAR,
  "sch_ugdetail_es" VARCHAR,
  "sch_ugdetail_ms" VARCHAR,
  "sch_ugdetail_hs" VARCHAR,
  "sch_status_sped" VARCHAR,
  "sch_status_magnet" VARCHAR,
  "sch_status_charter" VARCHAR,
  "sch_status_alt" VARCHAR,
  "sch_magnetdetail" VARCHAR,
  "sch_altfocus" VARCHAR,
  "sch_psenr_nonidea_a3" VARCHAR,
  "sch_psenr_nonidea_a4" VARCHAR,
  "sch_psenr_nonidea_a5" VARCHAR,
  "sch_psenr_hi_m" BIGINT,
  "sch_psenr_hi_f" BIGINT,
  "sch_psenr_am_m" BIGINT,
  "sch_psenr_am_f" BIGINT,
  "sch_psenr_as_m" BIGINT,
  "sch_psenr_as_f" BIGINT,
  "sch_psenr_hp_m" BIGINT,
  "sch_psenr_hp_f" BIGINT,
  "sch_psenr_bl_m" BIGINT,
  "sch_psenr_bl_f" BIGINT,
  "sch_psenr_wh_m" BIGINT,
  "sch_psenr_wh_f" BIGINT,
  "sch_psenr_tr_m" BIGINT,
  "sch_psenr_tr_f" BIGINT,
  "tot_psenr_m" BIGINT,
  "tot_psenr_f" BIGINT,
  "sch_psenr_lep_m" BIGINT,
  "sch_psenr_lep_f" BIGINT,
  "sch_psenr_idea_m" BIGINT,
  "sch_psenr_idea_f" BIGINT,
  "sch_enr_hi_m" BIGINT,
  "sch_enr_hi_f" BIGINT,
  "sch_enr_am_m" BIGINT,
  "sch_enr_am_f" BIGINT,
  "sch_enr_as_m" BIGINT,
  "sch_enr_as_f" BIGINT,
  "sch_enr_hp_m" BIGINT,
  "sch_enr_hp_f" BIGINT,
  "sch_enr_bl_m" BIGINT,
  "sch_enr_bl_f" BIGINT,
  "sch_enr_wh_m" BIGINT,
  "sch_enr_wh_f" BIGINT,
  "sch_enr_tr_m" BIGINT,
  "sch_enr_tr_f" BIGINT,
  "tot_enr_m" BIGINT,
  "tot_enr_f" BIGINT,
  "sch_enr_lep_m" BIGINT,
  "sch_enr_lep_f" BIGINT,
  "sch_enr_504_m" BIGINT,
  "sch_enr_504_f" BIGINT,
  "sch_enr_idea_m" BIGINT,
  "sch_enr_idea_f" BIGINT,
  "sch_lepenr_hi_m" BIGINT,
  "sch_lepenr_hi_f" BIGINT,
  "sch_lepenr_am_m" BIGINT,
  "sch_lepenr_am_f" BIGINT,
  "sch_lepenr_as_m" BIGINT,
  "sch_lepenr_as_f" BIGINT,
  "sch_lepenr_hp_m" BIGINT,
  "sch_lepenr_hp_f" BIGINT,
  "sch_lepenr_bl_m" BIGINT,
  "sch_lepenr_bl_f" BIGINT,
  "sch_lepenr_wh_m" BIGINT,
  "sch_lepenr_wh_f" BIGINT,
  "sch_lepenr_tr_m" BIGINT,
  "sch_lepenr_tr_f" BIGINT,
  "tot_lepenr_m" BIGINT,
  "tot_lepenr_f" BIGINT,
  "sch_lepprogenr_hi_m" BIGINT,
  "sch_lepprogenr_hi_f" BIGINT,
  "sch_lepprogenr_am_m" BIGINT,
  "sch_lepprogenr_am_f" BIGINT
);

Arkansas - File As Of October 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.arkansas_file_as_of_october_2018
  • 2.1 MB
  • 1092 rows
  • 1839 columns
Loading... 

CREATE TABLE arkansas_file_as_of_october_2018 (
  "lea_state" VARCHAR,
  "lea_state_name" VARCHAR,
  "leaid" BIGINT,
  "lea_name" VARCHAR,
  "schid" BIGINT,
  "sch_name" VARCHAR,
  "combokey" BIGINT,
  "jj" VARCHAR,
  "ccd_latcod" DOUBLE,
  "ccd_loncod" DOUBLE,
  "nces_school_id" DOUBLE,
  "sch_grade_ps" VARCHAR,
  "sch_grade_kg" VARCHAR,
  "sch_grade_g01" VARCHAR,
  "sch_grade_g02" VARCHAR,
  "sch_grade_g03" VARCHAR,
  "sch_grade_g04" VARCHAR,
  "sch_grade_g05" VARCHAR,
  "sch_grade_g06" VARCHAR,
  "sch_grade_g07" VARCHAR,
  "sch_grade_g08" VARCHAR,
  "sch_grade_g09" VARCHAR,
  "sch_grade_g10" VARCHAR,
  "sch_grade_g11" VARCHAR,
  "sch_grade_g12" VARCHAR,
  "sch_grade_ug" VARCHAR,
  "sch_ugdetail_es" VARCHAR,
  "sch_ugdetail_ms" VARCHAR,
  "sch_ugdetail_hs" VARCHAR,
  "sch_status_sped" VARCHAR,
  "sch_status_magnet" VARCHAR,
  "sch_status_charter" VARCHAR,
  "sch_status_alt" VARCHAR,
  "sch_magnetdetail" VARCHAR,
  "sch_altfocus" VARCHAR,
  "sch_psenr_nonidea_a3" VARCHAR,
  "sch_psenr_nonidea_a4" VARCHAR,
  "sch_psenr_nonidea_a5" VARCHAR,
  "sch_psenr_hi_m" BIGINT,
  "sch_psenr_hi_f" BIGINT,
  "sch_psenr_am_m" BIGINT,
  "sch_psenr_am_f" BIGINT,
  "sch_psenr_as_m" BIGINT,
  "sch_psenr_as_f" BIGINT,
  "sch_psenr_hp_m" BIGINT,
  "sch_psenr_hp_f" BIGINT,
  "sch_psenr_bl_m" BIGINT,
  "sch_psenr_bl_f" BIGINT,
  "sch_psenr_wh_m" BIGINT,
  "sch_psenr_wh_f" BIGINT,
  "sch_psenr_tr_m" BIGINT,
  "sch_psenr_tr_f" BIGINT,
  "tot_psenr_m" BIGINT,
  "tot_psenr_f" BIGINT,
  "sch_psenr_lep_m" BIGINT,
  "sch_psenr_lep_f" BIGINT,
  "sch_psenr_idea_m" BIGINT,
  "sch_psenr_idea_f" BIGINT,
  "sch_enr_hi_m" BIGINT,
  "sch_enr_hi_f" BIGINT,
  "sch_enr_am_m" BIGINT,
  "sch_enr_am_f" BIGINT,
  "sch_enr_as_m" BIGINT,
  "sch_enr_as_f" BIGINT,
  "sch_enr_hp_m" BIGINT,
  "sch_enr_hp_f" BIGINT,
  "sch_enr_bl_m" BIGINT,
  "sch_enr_bl_f" BIGINT,
  "sch_enr_wh_m" BIGINT,
  "sch_enr_wh_f" BIGINT,
  "sch_enr_tr_m" BIGINT,
  "sch_enr_tr_f" BIGINT,
  "tot_enr_m" BIGINT,
  "tot_enr_f" BIGINT,
  "sch_enr_lep_m" BIGINT,
  "sch_enr_lep_f" BIGINT,
  "sch_enr_504_m" BIGINT,
  "sch_enr_504_f" BIGINT,
  "sch_enr_idea_m" BIGINT,
  "sch_enr_idea_f" BIGINT,
  "sch_lepenr_hi_m" BIGINT,
  "sch_lepenr_hi_f" BIGINT,
  "sch_lepenr_am_m" BIGINT,
  "sch_lepenr_am_f" BIGINT,
  "sch_lepenr_as_m" BIGINT,
  "sch_lepenr_as_f" BIGINT,
  "sch_lepenr_hp_m" BIGINT,
  "sch_lepenr_hp_f" BIGINT,
  "sch_lepenr_bl_m" BIGINT,
  "sch_lepenr_bl_f" BIGINT,
  "sch_lepenr_wh_m" BIGINT,
  "sch_lepenr_wh_f" BIGINT,
  "sch_lepenr_tr_m" BIGINT,
  "sch_lepenr_tr_f" BIGINT,
  "tot_lepenr_m" BIGINT,
  "tot_lepenr_f" BIGINT,
  "sch_lepprogenr_hi_m" BIGINT,
  "sch_lepprogenr_hi_f" BIGINT,
  "sch_lepprogenr_am_m" BIGINT,
  "sch_lepprogenr_am_f" BIGINT
);

Colorado - File As Of August 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.colorado_file_as_of_august_2018
  • 2.54 MB
  • 1868 rows
  • 1839 columns
Loading... 

CREATE TABLE colorado_file_as_of_august_2018 (
  "lea_state" VARCHAR,
  "lea_state_name" VARCHAR,
  "leaid" BIGINT,
  "lea_name" VARCHAR,
  "schid" BIGINT,
  "sch_name" VARCHAR,
  "combokey" BIGINT,
  "jj" VARCHAR,
  "ccd_latcod" DOUBLE,
  "ccd_loncod" DOUBLE,
  "nces_school_id" DOUBLE,
  "sch_grade_ps" VARCHAR,
  "sch_grade_kg" VARCHAR,
  "sch_grade_g01" VARCHAR,
  "sch_grade_g02" VARCHAR,
  "sch_grade_g03" VARCHAR,
  "sch_grade_g04" VARCHAR,
  "sch_grade_g05" VARCHAR,
  "sch_grade_g06" VARCHAR,
  "sch_grade_g07" VARCHAR,
  "sch_grade_g08" VARCHAR,
  "sch_grade_g09" VARCHAR,
  "sch_grade_g10" VARCHAR,
  "sch_grade_g11" VARCHAR,
  "sch_grade_g12" VARCHAR,
  "sch_grade_ug" VARCHAR,
  "sch_ugdetail_es" BIGINT,
  "sch_ugdetail_ms" BIGINT,
  "sch_ugdetail_hs" BIGINT,
  "sch_status_sped" VARCHAR,
  "sch_status_magnet" VARCHAR,
  "sch_status_charter" VARCHAR,
  "sch_status_alt" VARCHAR,
  "sch_magnetdetail" VARCHAR,
  "sch_altfocus" VARCHAR,
  "sch_psenr_nonidea_a3" VARCHAR,
  "sch_psenr_nonidea_a4" VARCHAR,
  "sch_psenr_nonidea_a5" VARCHAR,
  "sch_psenr_hi_m" BIGINT,
  "sch_psenr_hi_f" BIGINT,
  "sch_psenr_am_m" BIGINT,
  "sch_psenr_am_f" BIGINT,
  "sch_psenr_as_m" BIGINT,
  "sch_psenr_as_f" BIGINT,
  "sch_psenr_hp_m" BIGINT,
  "sch_psenr_hp_f" BIGINT,
  "sch_psenr_bl_m" BIGINT,
  "sch_psenr_bl_f" BIGINT,
  "sch_psenr_wh_m" BIGINT,
  "sch_psenr_wh_f" BIGINT,
  "sch_psenr_tr_m" BIGINT,
  "sch_psenr_tr_f" BIGINT,
  "tot_psenr_m" BIGINT,
  "tot_psenr_f" BIGINT,
  "sch_psenr_lep_m" BIGINT,
  "sch_psenr_lep_f" BIGINT,
  "sch_psenr_idea_m" BIGINT,
  "sch_psenr_idea_f" BIGINT,
  "sch_enr_hi_m" BIGINT,
  "sch_enr_hi_f" BIGINT,
  "sch_enr_am_m" BIGINT,
  "sch_enr_am_f" BIGINT,
  "sch_enr_as_m" BIGINT,
  "sch_enr_as_f" BIGINT,
  "sch_enr_hp_m" BIGINT,
  "sch_enr_hp_f" BIGINT,
  "sch_enr_bl_m" BIGINT,
  "sch_enr_bl_f" BIGINT,
  "sch_enr_wh_m" BIGINT,
  "sch_enr_wh_f" BIGINT,
  "sch_enr_tr_m" BIGINT,
  "sch_enr_tr_f" BIGINT,
  "tot_enr_m" BIGINT,
  "tot_enr_f" BIGINT,
  "sch_enr_lep_m" BIGINT,
  "sch_enr_lep_f" BIGINT,
  "sch_enr_504_m" BIGINT,
  "sch_enr_504_f" BIGINT,
  "sch_enr_idea_m" BIGINT,
  "sch_enr_idea_f" BIGINT,
  "sch_lepenr_hi_m" BIGINT,
  "sch_lepenr_hi_f" BIGINT,
  "sch_lepenr_am_m" BIGINT,
  "sch_lepenr_am_f" BIGINT,
  "sch_lepenr_as_m" BIGINT,
  "sch_lepenr_as_f" BIGINT,
  "sch_lepenr_hp_m" BIGINT,
  "sch_lepenr_hp_f" BIGINT,
  "sch_lepenr_bl_m" BIGINT,
  "sch_lepenr_bl_f" BIGINT,
  "sch_lepenr_wh_m" BIGINT,
  "sch_lepenr_wh_f" BIGINT,
  "sch_lepenr_tr_m" BIGINT,
  "sch_lepenr_tr_f" BIGINT,
  "tot_lepenr_m" BIGINT,
  "tot_lepenr_f" BIGINT,
  "sch_lepprogenr_hi_m" BIGINT,
  "sch_lepprogenr_hi_f" BIGINT,
  "sch_lepprogenr_am_m" BIGINT,
  "sch_lepprogenr_am_f" BIGINT
);

Colorado - File As Of October 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.colorado_file_as_of_october_2018
  • 2.54 MB
  • 1868 rows
  • 1839 columns
Loading... 

CREATE TABLE colorado_file_as_of_october_2018 (
  "lea_state" VARCHAR,
  "lea_state_name" VARCHAR,
  "leaid" BIGINT,
  "lea_name" VARCHAR,
  "schid" BIGINT,
  "sch_name" VARCHAR,
  "combokey" BIGINT,
  "jj" VARCHAR,
  "ccd_latcod" DOUBLE,
  "ccd_loncod" DOUBLE,
  "nces_school_id" DOUBLE,
  "sch_grade_ps" VARCHAR,
  "sch_grade_kg" VARCHAR,
  "sch_grade_g01" VARCHAR,
  "sch_grade_g02" VARCHAR,
  "sch_grade_g03" VARCHAR,
  "sch_grade_g04" VARCHAR,
  "sch_grade_g05" VARCHAR,
  "sch_grade_g06" VARCHAR,
  "sch_grade_g07" VARCHAR,
  "sch_grade_g08" VARCHAR,
  "sch_grade_g09" VARCHAR,
  "sch_grade_g10" VARCHAR,
  "sch_grade_g11" VARCHAR,
  "sch_grade_g12" VARCHAR,
  "sch_grade_ug" VARCHAR,
  "sch_ugdetail_es" BIGINT,
  "sch_ugdetail_ms" BIGINT,
  "sch_ugdetail_hs" BIGINT,
  "sch_status_sped" VARCHAR,
  "sch_status_magnet" VARCHAR,
  "sch_status_charter" VARCHAR,
  "sch_status_alt" VARCHAR,
  "sch_magnetdetail" VARCHAR,
  "sch_altfocus" VARCHAR,
  "sch_psenr_nonidea_a3" VARCHAR,
  "sch_psenr_nonidea_a4" VARCHAR,
  "sch_psenr_nonidea_a5" VARCHAR,
  "sch_psenr_hi_m" BIGINT,
  "sch_psenr_hi_f" BIGINT,
  "sch_psenr_am_m" BIGINT,
  "sch_psenr_am_f" BIGINT,
  "sch_psenr_as_m" BIGINT,
  "sch_psenr_as_f" BIGINT,
  "sch_psenr_hp_m" BIGINT,
  "sch_psenr_hp_f" BIGINT,
  "sch_psenr_bl_m" BIGINT,
  "sch_psenr_bl_f" BIGINT,
  "sch_psenr_wh_m" BIGINT,
  "sch_psenr_wh_f" BIGINT,
  "sch_psenr_tr_m" BIGINT,
  "sch_psenr_tr_f" BIGINT,
  "tot_psenr_m" BIGINT,
  "tot_psenr_f" BIGINT,
  "sch_psenr_lep_m" BIGINT,
  "sch_psenr_lep_f" BIGINT,
  "sch_psenr_idea_m" BIGINT,
  "sch_psenr_idea_f" BIGINT,
  "sch_enr_hi_m" BIGINT,
  "sch_enr_hi_f" BIGINT,
  "sch_enr_am_m" BIGINT,
  "sch_enr_am_f" BIGINT,
  "sch_enr_as_m" BIGINT,
  "sch_enr_as_f" BIGINT,
  "sch_enr_hp_m" BIGINT,
  "sch_enr_hp_f" BIGINT,
  "sch_enr_bl_m" BIGINT,
  "sch_enr_bl_f" BIGINT,
  "sch_enr_wh_m" BIGINT,
  "sch_enr_wh_f" BIGINT,
  "sch_enr_tr_m" BIGINT,
  "sch_enr_tr_f" BIGINT,
  "tot_enr_m" BIGINT,
  "tot_enr_f" BIGINT,
  "sch_enr_lep_m" BIGINT,
  "sch_enr_lep_f" BIGINT,
  "sch_enr_504_m" BIGINT,
  "sch_enr_504_f" BIGINT,
  "sch_enr_idea_m" BIGINT,
  "sch_enr_idea_f" BIGINT,
  "sch_lepenr_hi_m" BIGINT,
  "sch_lepenr_hi_f" BIGINT,
  "sch_lepenr_am_m" BIGINT,
  "sch_lepenr_am_f" BIGINT,
  "sch_lepenr_as_m" BIGINT,
  "sch_lepenr_as_f" BIGINT,
  "sch_lepenr_hp_m" BIGINT,
  "sch_lepenr_hp_f" BIGINT,
  "sch_lepenr_bl_m" BIGINT,
  "sch_lepenr_bl_f" BIGINT,
  "sch_lepenr_wh_m" BIGINT,
  "sch_lepenr_wh_f" BIGINT,
  "sch_lepenr_tr_m" BIGINT,
  "sch_lepenr_tr_f" BIGINT,
  "tot_lepenr_m" BIGINT,
  "tot_lepenr_f" BIGINT,
  "sch_lepprogenr_hi_m" BIGINT,
  "sch_lepprogenr_hi_f" BIGINT,
  "sch_lepprogenr_am_m" BIGINT,
  "sch_lepprogenr_am_f" BIGINT
);

Connecticut - File As Of August 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.connecticut_file_as_of_august_2018
  • 2.18 MB
  • 1238 rows
  • 1839 columns
Loading... 

CREATE TABLE connecticut_file_as_of_august_2018 (
  "lea_state" VARCHAR,
  "lea_state_name" VARCHAR,
  "leaid" BIGINT,
  "lea_name" VARCHAR,
  "schid" BIGINT,
  "sch_name" VARCHAR,
  "combokey" BIGINT,
  "jj" VARCHAR,
  "ccd_latcod" DOUBLE,
  "ccd_loncod" DOUBLE,
  "nces_school_id" DOUBLE,
  "sch_grade_ps" VARCHAR,
  "sch_grade_kg" VARCHAR,
  "sch_grade_g01" VARCHAR,
  "sch_grade_g02" VARCHAR,
  "sch_grade_g03" VARCHAR,
  "sch_grade_g04" VARCHAR,
  "sch_grade_g05" VARCHAR,
  "sch_grade_g06" VARCHAR,
  "sch_grade_g07" VARCHAR,
  "sch_grade_g08" VARCHAR,
  "sch_grade_g09" VARCHAR,
  "sch_grade_g10" VARCHAR,
  "sch_grade_g11" VARCHAR,
  "sch_grade_g12" VARCHAR,
  "sch_grade_ug" VARCHAR,
  "sch_ugdetail_es" VARCHAR,
  "sch_ugdetail_ms" VARCHAR,
  "sch_ugdetail_hs" VARCHAR,
  "sch_status_sped" VARCHAR,
  "sch_status_magnet" VARCHAR,
  "sch_status_charter" VARCHAR,
  "sch_status_alt" VARCHAR,
  "sch_magnetdetail" VARCHAR,
  "sch_altfocus" VARCHAR,
  "sch_psenr_nonidea_a3" VARCHAR,
  "sch_psenr_nonidea_a4" VARCHAR,
  "sch_psenr_nonidea_a5" VARCHAR,
  "sch_psenr_hi_m" BIGINT,
  "sch_psenr_hi_f" BIGINT,
  "sch_psenr_am_m" BIGINT,
  "sch_psenr_am_f" BIGINT,
  "sch_psenr_as_m" BIGINT,
  "sch_psenr_as_f" BIGINT,
  "sch_psenr_hp_m" BIGINT,
  "sch_psenr_hp_f" BIGINT,
  "sch_psenr_bl_m" BIGINT,
  "sch_psenr_bl_f" BIGINT,
  "sch_psenr_wh_m" BIGINT,
  "sch_psenr_wh_f" BIGINT,
  "sch_psenr_tr_m" BIGINT,
  "sch_psenr_tr_f" BIGINT,
  "tot_psenr_m" BIGINT,
  "tot_psenr_f" BIGINT,
  "sch_psenr_lep_m" BIGINT,
  "sch_psenr_lep_f" BIGINT,
  "sch_psenr_idea_m" BIGINT,
  "sch_psenr_idea_f" BIGINT,
  "sch_enr_hi_m" BIGINT,
  "sch_enr_hi_f" BIGINT,
  "sch_enr_am_m" BIGINT,
  "sch_enr_am_f" BIGINT,
  "sch_enr_as_m" BIGINT,
  "sch_enr_as_f" BIGINT,
  "sch_enr_hp_m" BIGINT,
  "sch_enr_hp_f" BIGINT,
  "sch_enr_bl_m" BIGINT,
  "sch_enr_bl_f" BIGINT,
  "sch_enr_wh_m" BIGINT,
  "sch_enr_wh_f" BIGINT,
  "sch_enr_tr_m" BIGINT,
  "sch_enr_tr_f" BIGINT,
  "tot_enr_m" BIGINT,
  "tot_enr_f" BIGINT,
  "sch_enr_lep_m" BIGINT,
  "sch_enr_lep_f" BIGINT,
  "sch_enr_504_m" BIGINT,
  "sch_enr_504_f" BIGINT,
  "sch_enr_idea_m" BIGINT,
  "sch_enr_idea_f" BIGINT,
  "sch_lepenr_hi_m" BIGINT,
  "sch_lepenr_hi_f" BIGINT,
  "sch_lepenr_am_m" BIGINT,
  "sch_lepenr_am_f" BIGINT,
  "sch_lepenr_as_m" BIGINT,
  "sch_lepenr_as_f" BIGINT,
  "sch_lepenr_hp_m" BIGINT,
  "sch_lepenr_hp_f" BIGINT,
  "sch_lepenr_bl_m" BIGINT,
  "sch_lepenr_bl_f" BIGINT,
  "sch_lepenr_wh_m" BIGINT,
  "sch_lepenr_wh_f" BIGINT,
  "sch_lepenr_tr_m" BIGINT,
  "sch_lepenr_tr_f" BIGINT,
  "tot_lepenr_m" BIGINT,
  "tot_lepenr_f" BIGINT,
  "sch_lepprogenr_hi_m" BIGINT,
  "sch_lepprogenr_hi_f" BIGINT,
  "sch_lepprogenr_am_m" BIGINT,
  "sch_lepprogenr_am_f" BIGINT
);

Connecticut - File As Of October 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.connecticut_file_as_of_october_2018
  • 2.16 MB
  • 1238 rows
  • 1839 columns
Loading... 

CREATE TABLE connecticut_file_as_of_october_2018 (
  "lea_state" VARCHAR,
  "lea_state_name" VARCHAR,
  "leaid" BIGINT,
  "lea_name" VARCHAR,
  "schid" BIGINT,
  "sch_name" VARCHAR,
  "combokey" BIGINT,
  "jj" VARCHAR,
  "ccd_latcod" DOUBLE,
  "ccd_loncod" DOUBLE,
  "nces_school_id" DOUBLE,
  "sch_grade_ps" VARCHAR,
  "sch_grade_kg" VARCHAR,
  "sch_grade_g01" VARCHAR,
  "sch_grade_g02" VARCHAR,
  "sch_grade_g03" VARCHAR,
  "sch_grade_g04" VARCHAR,
  "sch_grade_g05" VARCHAR,
  "sch_grade_g06" VARCHAR,
  "sch_grade_g07" VARCHAR,
  "sch_grade_g08" VARCHAR,
  "sch_grade_g09" VARCHAR,
  "sch_grade_g10" VARCHAR,
  "sch_grade_g11" VARCHAR,
  "sch_grade_g12" VARCHAR,
  "sch_grade_ug" VARCHAR,
  "sch_ugdetail_es" VARCHAR,
  "sch_ugdetail_ms" VARCHAR,
  "sch_ugdetail_hs" VARCHAR,
  "sch_status_sped" VARCHAR,
  "sch_status_magnet" VARCHAR,
  "sch_status_charter" VARCHAR,
  "sch_status_alt" VARCHAR,
  "sch_magnetdetail" VARCHAR,
  "sch_altfocus" VARCHAR,
  "sch_psenr_nonidea_a3" VARCHAR,
  "sch_psenr_nonidea_a4" VARCHAR,
  "sch_psenr_nonidea_a5" VARCHAR,
  "sch_psenr_hi_m" BIGINT,
  "sch_psenr_hi_f" BIGINT,
  "sch_psenr_am_m" BIGINT,
  "sch_psenr_am_f" BIGINT,
  "sch_psenr_as_m" BIGINT,
  "sch_psenr_as_f" BIGINT,
  "sch_psenr_hp_m" BIGINT,
  "sch_psenr_hp_f" BIGINT,
  "sch_psenr_bl_m" BIGINT,
  "sch_psenr_bl_f" BIGINT,
  "sch_psenr_wh_m" BIGINT,
  "sch_psenr_wh_f" BIGINT,
  "sch_psenr_tr_m" BIGINT,
  "sch_psenr_tr_f" BIGINT,
  "tot_psenr_m" BIGINT,
  "tot_psenr_f" BIGINT,
  "sch_psenr_lep_m" BIGINT,
  "sch_psenr_lep_f" BIGINT,
  "sch_psenr_idea_m" BIGINT,
  "sch_psenr_idea_f" BIGINT,
  "sch_enr_hi_m" BIGINT,
  "sch_enr_hi_f" BIGINT,
  "sch_enr_am_m" BIGINT,
  "sch_enr_am_f" BIGINT,
  "sch_enr_as_m" BIGINT,
  "sch_enr_as_f" BIGINT,
  "sch_enr_hp_m" BIGINT,
  "sch_enr_hp_f" BIGINT,
  "sch_enr_bl_m" BIGINT,
  "sch_enr_bl_f" BIGINT,
  "sch_enr_wh_m" BIGINT,
  "sch_enr_wh_f" BIGINT,
  "sch_enr_tr_m" BIGINT,
  "sch_enr_tr_f" BIGINT,
  "tot_enr_m" BIGINT,
  "tot_enr_f" BIGINT,
  "sch_enr_lep_m" BIGINT,
  "sch_enr_lep_f" BIGINT,
  "sch_enr_504_m" BIGINT,
  "sch_enr_504_f" BIGINT,
  "sch_enr_idea_m" BIGINT,
  "sch_enr_idea_f" BIGINT,
  "sch_lepenr_hi_m" BIGINT,
  "sch_lepenr_hi_f" BIGINT,
  "sch_lepenr_am_m" BIGINT,
  "sch_lepenr_am_f" BIGINT,
  "sch_lepenr_as_m" BIGINT,
  "sch_lepenr_as_f" BIGINT,
  "sch_lepenr_hp_m" BIGINT,
  "sch_lepenr_hp_f" BIGINT,
  "sch_lepenr_bl_m" BIGINT,
  "sch_lepenr_bl_f" BIGINT,
  "sch_lepenr_wh_m" BIGINT,
  "sch_lepenr_wh_f" BIGINT,
  "sch_lepenr_tr_m" BIGINT,
  "sch_lepenr_tr_f" BIGINT,
  "tot_lepenr_m" BIGINT,
  "tot_lepenr_f" BIGINT,
  "sch_lepprogenr_hi_m" BIGINT,
  "sch_lepprogenr_hi_f" BIGINT,
  "sch_lepprogenr_am_m" BIGINT,
  "sch_lepprogenr_am_f" BIGINT
);

Delaware - File As Of August 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.delaware_file_as_of_august_2018
  • 1.54 MB
  • 235 rows
  • 1839 columns
Loading... 

CREATE TABLE delaware_file_as_of_august_2018 (
  "lea_state" VARCHAR,
  "lea_state_name" VARCHAR,
  "leaid" BIGINT,
  "lea_name" VARCHAR,
  "schid" BIGINT,
  "sch_name" VARCHAR,
  "combokey" DOUBLE,
  "jj" VARCHAR,
  "ccd_latcod" DOUBLE,
  "ccd_loncod" DOUBLE,
  "nces_school_id" DOUBLE,
  "sch_grade_ps" VARCHAR,
  "sch_grade_kg" VARCHAR,
  "sch_grade_g01" VARCHAR,
  "sch_grade_g02" VARCHAR,
  "sch_grade_g03" VARCHAR,
  "sch_grade_g04" VARCHAR,
  "sch_grade_g05" VARCHAR,
  "sch_grade_g06" VARCHAR,
  "sch_grade_g07" VARCHAR,
  "sch_grade_g08" VARCHAR,
  "sch_grade_g09" VARCHAR,
  "sch_grade_g10" VARCHAR,
  "sch_grade_g11" VARCHAR,
  "sch_grade_g12" VARCHAR,
  "sch_grade_ug" VARCHAR,
  "sch_ugdetail_es" VARCHAR,
  "sch_ugdetail_ms" VARCHAR,
  "sch_ugdetail_hs" VARCHAR,
  "sch_status_sped" VARCHAR,
  "sch_status_magnet" VARCHAR,
  "sch_status_charter" VARCHAR,
  "sch_status_alt" VARCHAR,
  "sch_magnetdetail" VARCHAR,
  "sch_altfocus" VARCHAR,
  "sch_psenr_nonidea_a3" VARCHAR,
  "sch_psenr_nonidea_a4" VARCHAR,
  "sch_psenr_nonidea_a5" VARCHAR,
  "sch_psenr_hi_m" BIGINT,
  "sch_psenr_hi_f" BIGINT,
  "sch_psenr_am_m" BIGINT,
  "sch_psenr_am_f" BIGINT,
  "sch_psenr_as_m" BIGINT,
  "sch_psenr_as_f" BIGINT,
  "sch_psenr_hp_m" BIGINT,
  "sch_psenr_hp_f" BIGINT,
  "sch_psenr_bl_m" BIGINT,
  "sch_psenr_bl_f" BIGINT,
  "sch_psenr_wh_m" BIGINT,
  "sch_psenr_wh_f" BIGINT,
  "sch_psenr_tr_m" BIGINT,
  "sch_psenr_tr_f" BIGINT,
  "tot_psenr_m" BIGINT,
  "tot_psenr_f" BIGINT,
  "sch_psenr_lep_m" BIGINT,
  "sch_psenr_lep_f" BIGINT,
  "sch_psenr_idea_m" BIGINT,
  "sch_psenr_idea_f" BIGINT,
  "sch_enr_hi_m" BIGINT,
  "sch_enr_hi_f" BIGINT,
  "sch_enr_am_m" BIGINT,
  "sch_enr_am_f" BIGINT,
  "sch_enr_as_m" BIGINT,
  "sch_enr_as_f" BIGINT,
  "sch_enr_hp_m" BIGINT,
  "sch_enr_hp_f" BIGINT,
  "sch_enr_bl_m" BIGINT,
  "sch_enr_bl_f" BIGINT,
  "sch_enr_wh_m" BIGINT,
  "sch_enr_wh_f" BIGINT,
  "sch_enr_tr_m" BIGINT,
  "sch_enr_tr_f" BIGINT,
  "tot_enr_m" BIGINT,
  "tot_enr_f" BIGINT,
  "sch_enr_lep_m" BIGINT,
  "sch_enr_lep_f" BIGINT,
  "sch_enr_504_m" BIGINT,
  "sch_enr_504_f" BIGINT,
  "sch_enr_idea_m" BIGINT,
  "sch_enr_idea_f" BIGINT,
  "sch_lepenr_hi_m" BIGINT,
  "sch_lepenr_hi_f" BIGINT,
  "sch_lepenr_am_m" BIGINT,
  "sch_lepenr_am_f" BIGINT,
  "sch_lepenr_as_m" BIGINT,
  "sch_lepenr_as_f" BIGINT,
  "sch_lepenr_hp_m" BIGINT,
  "sch_lepenr_hp_f" BIGINT,
  "sch_lepenr_bl_m" BIGINT,
  "sch_lepenr_bl_f" BIGINT,
  "sch_lepenr_wh_m" BIGINT,
  "sch_lepenr_wh_f" BIGINT,
  "sch_lepenr_tr_m" BIGINT,
  "sch_lepenr_tr_f" BIGINT,
  "tot_lepenr_m" BIGINT,
  "tot_lepenr_f" BIGINT,
  "sch_lepprogenr_hi_m" BIGINT,
  "sch_lepprogenr_hi_f" BIGINT,
  "sch_lepprogenr_am_m" BIGINT,
  "sch_lepprogenr_am_f" BIGINT
);

Delaware - File As Of October 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.delaware_file_as_of_october_2018
  • 1.54 MB
  • 235 rows
  • 1839 columns
Loading... 

CREATE TABLE delaware_file_as_of_october_2018 (
  "lea_state" VARCHAR,
  "lea_state_name" VARCHAR,
  "leaid" BIGINT,
  "lea_name" VARCHAR,
  "schid" BIGINT,
  "sch_name" VARCHAR,
  "combokey" BIGINT,
  "jj" VARCHAR,
  "ccd_latcod" DOUBLE,
  "ccd_loncod" DOUBLE,
  "nces_school_id" DOUBLE,
  "sch_grade_ps" VARCHAR,
  "sch_grade_kg" VARCHAR,
  "sch_grade_g01" VARCHAR,
  "sch_grade_g02" VARCHAR,
  "sch_grade_g03" VARCHAR,
  "sch_grade_g04" VARCHAR,
  "sch_grade_g05" VARCHAR,
  "sch_grade_g06" VARCHAR,
  "sch_grade_g07" VARCHAR,
  "sch_grade_g08" VARCHAR,
  "sch_grade_g09" VARCHAR,
  "sch_grade_g10" VARCHAR,
  "sch_grade_g11" VARCHAR,
  "sch_grade_g12" VARCHAR,
  "sch_grade_ug" VARCHAR,
  "sch_ugdetail_es" VARCHAR,
  "sch_ugdetail_ms" VARCHAR,
  "sch_ugdetail_hs" VARCHAR,
  "sch_status_sped" VARCHAR,
  "sch_status_magnet" VARCHAR,
  "sch_status_charter" VARCHAR,
  "sch_status_alt" VARCHAR,
  "sch_magnetdetail" VARCHAR,
  "sch_altfocus" VARCHAR,
  "sch_psenr_nonidea_a3" VARCHAR,
  "sch_psenr_nonidea_a4" VARCHAR,
  "sch_psenr_nonidea_a5" VARCHAR,
  "sch_psenr_hi_m" BIGINT,
  "sch_psenr_hi_f" BIGINT,
  "sch_psenr_am_m" BIGINT,
  "sch_psenr_am_f" BIGINT,
  "sch_psenr_as_m" BIGINT,
  "sch_psenr_as_f" BIGINT,
  "sch_psenr_hp_m" BIGINT,
  "sch_psenr_hp_f" BIGINT,
  "sch_psenr_bl_m" BIGINT,
  "sch_psenr_bl_f" BIGINT,
  "sch_psenr_wh_m" BIGINT,
  "sch_psenr_wh_f" BIGINT,
  "sch_psenr_tr_m" BIGINT,
  "sch_psenr_tr_f" BIGINT,
  "tot_psenr_m" BIGINT,
  "tot_psenr_f" BIGINT,
  "sch_psenr_lep_m" BIGINT,
  "sch_psenr_lep_f" BIGINT,
  "sch_psenr_idea_m" BIGINT,
  "sch_psenr_idea_f" BIGINT,
  "sch_enr_hi_m" BIGINT,
  "sch_enr_hi_f" BIGINT,
  "sch_enr_am_m" BIGINT,
  "sch_enr_am_f" BIGINT,
  "sch_enr_as_m" BIGINT,
  "sch_enr_as_f" BIGINT,
  "sch_enr_hp_m" BIGINT,
  "sch_enr_hp_f" BIGINT,
  "sch_enr_bl_m" BIGINT,
  "sch_enr_bl_f" BIGINT,
  "sch_enr_wh_m" BIGINT,
  "sch_enr_wh_f" BIGINT,
  "sch_enr_tr_m" BIGINT,
  "sch_enr_tr_f" BIGINT,
  "tot_enr_m" BIGINT,
  "tot_enr_f" BIGINT,
  "sch_enr_lep_m" BIGINT,
  "sch_enr_lep_f" BIGINT,
  "sch_enr_504_m" BIGINT,
  "sch_enr_504_f" BIGINT,
  "sch_enr_idea_m" BIGINT,
  "sch_enr_idea_f" BIGINT,
  "sch_lepenr_hi_m" BIGINT,
  "sch_lepenr_hi_f" BIGINT,
  "sch_lepenr_am_m" BIGINT,
  "sch_lepenr_am_f" BIGINT,
  "sch_lepenr_as_m" BIGINT,
  "sch_lepenr_as_f" BIGINT,
  "sch_lepenr_hp_m" BIGINT,
  "sch_lepenr_hp_f" BIGINT,
  "sch_lepenr_bl_m" BIGINT,
  "sch_lepenr_bl_f" BIGINT,
  "sch_lepenr_wh_m" BIGINT,
  "sch_lepenr_wh_f" BIGINT,
  "sch_lepenr_tr_m" BIGINT,
  "sch_lepenr_tr_f" BIGINT,
  "tot_lepenr_m" BIGINT,
  "tot_lepenr_f" BIGINT,
  "sch_lepprogenr_hi_m" BIGINT,
  "sch_lepprogenr_hi_f" BIGINT,
  "sch_lepprogenr_am_m" BIGINT,
  "sch_lepprogenr_am_f" BIGINT
);

District Of Columbia

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.district_of_columbia
  • 1.51 MB
  • 221 rows
  • 1839 columns
Loading... 

CREATE TABLE district_of_columbia (
  "lea_state" VARCHAR,
  "lea_state_name" VARCHAR,
  "leaid" BIGINT,
  "lea_name" VARCHAR,
  "schid" BIGINT,
  "sch_name" VARCHAR,
  "combokey" BIGINT,
  "jj" VARCHAR,
  "ccd_latcod" DOUBLE,
  "ccd_loncod" DOUBLE,
  "nces_school_id" DOUBLE,
  "sch_grade_ps" VARCHAR,
  "sch_grade_kg" VARCHAR,
  "sch_grade_g01" VARCHAR,
  "sch_grade_g02" VARCHAR,
  "sch_grade_g03" VARCHAR,
  "sch_grade_g04" VARCHAR,
  "sch_grade_g05" VARCHAR,
  "sch_grade_g06" VARCHAR,
  "sch_grade_g07" VARCHAR,
  "sch_grade_g08" VARCHAR,
  "sch_grade_g09" VARCHAR,
  "sch_grade_g10" VARCHAR,
  "sch_grade_g11" VARCHAR,
  "sch_grade_g12" VARCHAR,
  "sch_grade_ug" VARCHAR,
  "sch_ugdetail_es" VARCHAR,
  "sch_ugdetail_ms" VARCHAR,
  "sch_ugdetail_hs" VARCHAR,
  "sch_status_sped" VARCHAR,
  "sch_status_magnet" VARCHAR,
  "sch_status_charter" VARCHAR,
  "sch_status_alt" VARCHAR,
  "sch_magnetdetail" VARCHAR,
  "sch_altfocus" VARCHAR,
  "sch_psenr_nonidea_a3" VARCHAR,
  "sch_psenr_nonidea_a4" VARCHAR,
  "sch_psenr_nonidea_a5" VARCHAR,
  "sch_psenr_hi_m" BIGINT,
  "sch_psenr_hi_f" BIGINT,
  "sch_psenr_am_m" BIGINT,
  "sch_psenr_am_f" BIGINT,
  "sch_psenr_as_m" BIGINT,
  "sch_psenr_as_f" BIGINT,
  "sch_psenr_hp_m" BIGINT,
  "sch_psenr_hp_f" BIGINT,
  "sch_psenr_bl_m" BIGINT,
  "sch_psenr_bl_f" BIGINT,
  "sch_psenr_wh_m" BIGINT,
  "sch_psenr_wh_f" BIGINT,
  "sch_psenr_tr_m" BIGINT,
  "sch_psenr_tr_f" BIGINT,
  "tot_psenr_m" BIGINT,
  "tot_psenr_f" BIGINT,
  "sch_psenr_lep_m" BIGINT,
  "sch_psenr_lep_f" BIGINT,
  "sch_psenr_idea_m" BIGINT,
  "sch_psenr_idea_f" BIGINT,
  "sch_enr_hi_m" BIGINT,
  "sch_enr_hi_f" BIGINT,
  "sch_enr_am_m" BIGINT,
  "sch_enr_am_f" BIGINT,
  "sch_enr_as_m" BIGINT,
  "sch_enr_as_f" BIGINT,
  "sch_enr_hp_m" BIGINT,
  "sch_enr_hp_f" BIGINT,
  "sch_enr_bl_m" BIGINT,
  "sch_enr_bl_f" BIGINT,
  "sch_enr_wh_m" BIGINT,
  "sch_enr_wh_f" BIGINT,
  "sch_enr_tr_m" BIGINT,
  "sch_enr_tr_f" BIGINT,
  "tot_enr_m" BIGINT,
  "tot_enr_f" BIGINT,
  "sch_enr_lep_m" BIGINT,
  "sch_enr_lep_f" BIGINT,
  "sch_enr_504_m" BIGINT,
  "sch_enr_504_f" BIGINT,
  "sch_enr_idea_m" BIGINT,
  "sch_enr_idea_f" BIGINT,
  "sch_lepenr_hi_m" BIGINT,
  "sch_lepenr_hi_f" BIGINT,
  "sch_lepenr_am_m" BIGINT,
  "sch_lepenr_am_f" BIGINT,
  "sch_lepenr_as_m" BIGINT,
  "sch_lepenr_as_f" BIGINT,
  "sch_lepenr_hp_m" BIGINT,
  "sch_lepenr_hp_f" BIGINT,
  "sch_lepenr_bl_m" BIGINT,
  "sch_lepenr_bl_f" BIGINT,
  "sch_lepenr_wh_m" BIGINT,
  "sch_lepenr_wh_f" BIGINT,
  "sch_lepenr_tr_m" BIGINT,
  "sch_lepenr_tr_f" BIGINT,
  "tot_lepenr_m" BIGINT,
  "tot_lepenr_f" BIGINT,
  "sch_lepprogenr_hi_m" BIGINT,
  "sch_lepprogenr_hi_f" BIGINT,
  "sch_lepprogenr_am_m" BIGINT,
  "sch_lepprogenr_am_f" BIGINT
);

District Of Columbia - File As Of August 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.district_of_columbia_file_as_of_august_2018
  • 1.51 MB
  • 221 rows
  • 1839 columns
Loading... 

CREATE TABLE district_of_columbia_file_as_of_august_2018 (
  "lea_state" VARCHAR,
  "lea_state_name" VARCHAR,
  "leaid" BIGINT,
  "lea_name" VARCHAR,
  "schid" BIGINT,
  "sch_name" VARCHAR,
  "combokey" DOUBLE,
  "jj" VARCHAR,
  "ccd_latcod" DOUBLE,
  "ccd_loncod" DOUBLE,
  "nces_school_id" DOUBLE,
  "sch_grade_ps" VARCHAR,
  "sch_grade_kg" VARCHAR,
  "sch_grade_g01" VARCHAR,
  "sch_grade_g02" VARCHAR,
  "sch_grade_g03" VARCHAR,
  "sch_grade_g04" VARCHAR,
  "sch_grade_g05" VARCHAR,
  "sch_grade_g06" VARCHAR,
  "sch_grade_g07" VARCHAR,
  "sch_grade_g08" VARCHAR,
  "sch_grade_g09" VARCHAR,
  "sch_grade_g10" VARCHAR,
  "sch_grade_g11" VARCHAR,
  "sch_grade_g12" VARCHAR,
  "sch_grade_ug" VARCHAR,
  "sch_ugdetail_es" VARCHAR,
  "sch_ugdetail_ms" VARCHAR,
  "sch_ugdetail_hs" VARCHAR,
  "sch_status_sped" VARCHAR,
  "sch_status_magnet" VARCHAR,
  "sch_status_charter" VARCHAR,
  "sch_status_alt" VARCHAR,
  "sch_magnetdetail" VARCHAR,
  "sch_altfocus" VARCHAR,
  "sch_psenr_nonidea_a3" VARCHAR,
  "sch_psenr_nonidea_a4" VARCHAR,
  "sch_psenr_nonidea_a5" VARCHAR,
  "sch_psenr_hi_m" BIGINT,
  "sch_psenr_hi_f" BIGINT,
  "sch_psenr_am_m" BIGINT,
  "sch_psenr_am_f" BIGINT,
  "sch_psenr_as_m" BIGINT,
  "sch_psenr_as_f" BIGINT,
  "sch_psenr_hp_m" BIGINT,
  "sch_psenr_hp_f" BIGINT,
  "sch_psenr_bl_m" BIGINT,
  "sch_psenr_bl_f" BIGINT,
  "sch_psenr_wh_m" BIGINT,
  "sch_psenr_wh_f" BIGINT,
  "sch_psenr_tr_m" BIGINT,
  "sch_psenr_tr_f" BIGINT,
  "tot_psenr_m" BIGINT,
  "tot_psenr_f" BIGINT,
  "sch_psenr_lep_m" BIGINT,
  "sch_psenr_lep_f" BIGINT,
  "sch_psenr_idea_m" BIGINT,
  "sch_psenr_idea_f" BIGINT,
  "sch_enr_hi_m" BIGINT,
  "sch_enr_hi_f" BIGINT,
  "sch_enr_am_m" BIGINT,
  "sch_enr_am_f" BIGINT,
  "sch_enr_as_m" BIGINT,
  "sch_enr_as_f" BIGINT,
  "sch_enr_hp_m" BIGINT,
  "sch_enr_hp_f" BIGINT,
  "sch_enr_bl_m" BIGINT,
  "sch_enr_bl_f" BIGINT,
  "sch_enr_wh_m" BIGINT,
  "sch_enr_wh_f" BIGINT,
  "sch_enr_tr_m" BIGINT,
  "sch_enr_tr_f" BIGINT,
  "tot_enr_m" BIGINT,
  "tot_enr_f" BIGINT,
  "sch_enr_lep_m" BIGINT,
  "sch_enr_lep_f" BIGINT,
  "sch_enr_504_m" BIGINT,
  "sch_enr_504_f" BIGINT,
  "sch_enr_idea_m" BIGINT,
  "sch_enr_idea_f" BIGINT,
  "sch_lepenr_hi_m" BIGINT,
  "sch_lepenr_hi_f" BIGINT,
  "sch_lepenr_am_m" BIGINT,
  "sch_lepenr_am_f" BIGINT,
  "sch_lepenr_as_m" BIGINT,
  "sch_lepenr_as_f" BIGINT,
  "sch_lepenr_hp_m" BIGINT,
  "sch_lepenr_hp_f" BIGINT,
  "sch_lepenr_bl_m" BIGINT,
  "sch_lepenr_bl_f" BIGINT,
  "sch_lepenr_wh_m" BIGINT,
  "sch_lepenr_wh_f" BIGINT,
  "sch_lepenr_tr_m" BIGINT,
  "sch_lepenr_tr_f" BIGINT,
  "tot_lepenr_m" BIGINT,
  "tot_lepenr_f" BIGINT,
  "sch_lepprogenr_hi_m" BIGINT,
  "sch_lepprogenr_hi_f" BIGINT,
  "sch_lepprogenr_am_m" BIGINT,
  "sch_lepprogenr_am_f" BIGINT
);

Florida - File As Of August 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.florida_file_as_of_august_2018
  • 3.59 MB
  • 3952 rows
  • 1839 columns
Loading... 

CREATE TABLE florida_file_as_of_august_2018 (
  "lea_state" VARCHAR,
  "lea_state_name" VARCHAR,
  "leaid" BIGINT,
  "lea_name" VARCHAR,
  "schid" BIGINT,
  "sch_name" VARCHAR,
  "combokey" DOUBLE,
  "jj" VARCHAR,
  "ccd_latcod" DOUBLE,
  "ccd_loncod" DOUBLE,
  "nces_school_id" DOUBLE,
  "sch_grade_ps" VARCHAR,
  "sch_grade_kg" VARCHAR,
  "sch_grade_g01" VARCHAR,
  "sch_grade_g02" VARCHAR,
  "sch_grade_g03" VARCHAR,
  "sch_grade_g04" VARCHAR,
  "sch_grade_g05" VARCHAR,
  "sch_grade_g06" VARCHAR,
  "sch_grade_g07" VARCHAR,
  "sch_grade_g08" VARCHAR,
  "sch_grade_g09" VARCHAR,
  "sch_grade_g10" VARCHAR,
  "sch_grade_g11" VARCHAR,
  "sch_grade_g12" VARCHAR,
  "sch_grade_ug" VARCHAR,
  "sch_ugdetail_es" BIGINT,
  "sch_ugdetail_ms" BIGINT,
  "sch_ugdetail_hs" BIGINT,
  "sch_status_sped" VARCHAR,
  "sch_status_magnet" VARCHAR,
  "sch_status_charter" VARCHAR,
  "sch_status_alt" VARCHAR,
  "sch_magnetdetail" VARCHAR,
  "sch_altfocus" VARCHAR,
  "sch_psenr_nonidea_a3" VARCHAR,
  "sch_psenr_nonidea_a4" VARCHAR,
  "sch_psenr_nonidea_a5" VARCHAR,
  "sch_psenr_hi_m" BIGINT,
  "sch_psenr_hi_f" BIGINT,
  "sch_psenr_am_m" BIGINT,
  "sch_psenr_am_f" BIGINT,
  "sch_psenr_as_m" BIGINT,
  "sch_psenr_as_f" BIGINT,
  "sch_psenr_hp_m" BIGINT,
  "sch_psenr_hp_f" BIGINT,
  "sch_psenr_bl_m" BIGINT,
  "sch_psenr_bl_f" BIGINT,
  "sch_psenr_wh_m" BIGINT,
  "sch_psenr_wh_f" BIGINT,
  "sch_psenr_tr_m" BIGINT,
  "sch_psenr_tr_f" BIGINT,
  "tot_psenr_m" BIGINT,
  "tot_psenr_f" BIGINT,
  "sch_psenr_lep_m" BIGINT,
  "sch_psenr_lep_f" BIGINT,
  "sch_psenr_idea_m" BIGINT,
  "sch_psenr_idea_f" BIGINT,
  "sch_enr_hi_m" BIGINT,
  "sch_enr_hi_f" BIGINT,
  "sch_enr_am_m" BIGINT,
  "sch_enr_am_f" BIGINT,
  "sch_enr_as_m" BIGINT,
  "sch_enr_as_f" BIGINT,
  "sch_enr_hp_m" BIGINT,
  "sch_enr_hp_f" BIGINT,
  "sch_enr_bl_m" BIGINT,
  "sch_enr_bl_f" BIGINT,
  "sch_enr_wh_m" BIGINT,
  "sch_enr_wh_f" BIGINT,
  "sch_enr_tr_m" BIGINT,
  "sch_enr_tr_f" BIGINT,
  "tot_enr_m" BIGINT,
  "tot_enr_f" BIGINT,
  "sch_enr_lep_m" BIGINT,
  "sch_enr_lep_f" BIGINT,
  "sch_enr_504_m" BIGINT,
  "sch_enr_504_f" BIGINT,
  "sch_enr_idea_m" BIGINT,
  "sch_enr_idea_f" BIGINT,
  "sch_lepenr_hi_m" BIGINT,
  "sch_lepenr_hi_f" BIGINT,
  "sch_lepenr_am_m" BIGINT,
  "sch_lepenr_am_f" BIGINT,
  "sch_lepenr_as_m" BIGINT,
  "sch_lepenr_as_f" BIGINT,
  "sch_lepenr_hp_m" BIGINT,
  "sch_lepenr_hp_f" BIGINT,
  "sch_lepenr_bl_m" BIGINT,
  "sch_lepenr_bl_f" BIGINT,
  "sch_lepenr_wh_m" BIGINT,
  "sch_lepenr_wh_f" BIGINT,
  "sch_lepenr_tr_m" BIGINT,
  "sch_lepenr_tr_f" BIGINT,
  "tot_lepenr_m" BIGINT,
  "tot_lepenr_f" BIGINT,
  "sch_lepprogenr_hi_m" BIGINT,
  "sch_lepprogenr_hi_f" BIGINT,
  "sch_lepprogenr_am_m" BIGINT,
  "sch_lepprogenr_am_f" BIGINT
);

Florida - File As Of October 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.florida_file_as_of_october_2018
  • 3.61 MB
  • 3952 rows
  • 1839 columns
Loading... 

CREATE TABLE florida_file_as_of_october_2018 (
  "lea_state" VARCHAR,
  "lea_state_name" VARCHAR,
  "leaid" BIGINT,
  "lea_name" VARCHAR,
  "schid" BIGINT,
  "sch_name" VARCHAR,
  "combokey" BIGINT,
  "jj" VARCHAR,
  "ccd_latcod" DOUBLE,
  "ccd_loncod" DOUBLE,
  "nces_school_id" DOUBLE,
  "sch_grade_ps" VARCHAR,
  "sch_grade_kg" VARCHAR,
  "sch_grade_g01" VARCHAR,
  "sch_grade_g02" VARCHAR,
  "sch_grade_g03" VARCHAR,
  "sch_grade_g04" VARCHAR,
  "sch_grade_g05" VARCHAR,
  "sch_grade_g06" VARCHAR,
  "sch_grade_g07" VARCHAR,
  "sch_grade_g08" VARCHAR,
  "sch_grade_g09" VARCHAR,
  "sch_grade_g10" VARCHAR,
  "sch_grade_g11" VARCHAR,
  "sch_grade_g12" VARCHAR,
  "sch_grade_ug" VARCHAR,
  "sch_ugdetail_es" BIGINT,
  "sch_ugdetail_ms" BIGINT,
  "sch_ugdetail_hs" BIGINT,
  "sch_status_sped" VARCHAR,
  "sch_status_magnet" VARCHAR,
  "sch_status_charter" VARCHAR,
  "sch_status_alt" VARCHAR,
  "sch_magnetdetail" VARCHAR,
  "sch_altfocus" VARCHAR,
  "sch_psenr_nonidea_a3" VARCHAR,
  "sch_psenr_nonidea_a4" VARCHAR,
  "sch_psenr_nonidea_a5" VARCHAR,
  "sch_psenr_hi_m" BIGINT,
  "sch_psenr_hi_f" BIGINT,
  "sch_psenr_am_m" BIGINT,
  "sch_psenr_am_f" BIGINT,
  "sch_psenr_as_m" BIGINT,
  "sch_psenr_as_f" BIGINT,
  "sch_psenr_hp_m" BIGINT,
  "sch_psenr_hp_f" BIGINT,
  "sch_psenr_bl_m" BIGINT,
  "sch_psenr_bl_f" BIGINT,
  "sch_psenr_wh_m" BIGINT,
  "sch_psenr_wh_f" BIGINT,
  "sch_psenr_tr_m" BIGINT,
  "sch_psenr_tr_f" BIGINT,
  "tot_psenr_m" BIGINT,
  "tot_psenr_f" BIGINT,
  "sch_psenr_lep_m" BIGINT,
  "sch_psenr_lep_f" BIGINT,
  "sch_psenr_idea_m" BIGINT,
  "sch_psenr_idea_f" BIGINT,
  "sch_enr_hi_m" BIGINT,
  "sch_enr_hi_f" BIGINT,
  "sch_enr_am_m" BIGINT,
  "sch_enr_am_f" BIGINT,
  "sch_enr_as_m" BIGINT,
  "sch_enr_as_f" BIGINT,
  "sch_enr_hp_m" BIGINT,
  "sch_enr_hp_f" BIGINT,
  "sch_enr_bl_m" BIGINT,
  "sch_enr_bl_f" BIGINT,
  "sch_enr_wh_m" BIGINT,
  "sch_enr_wh_f" BIGINT,
  "sch_enr_tr_m" BIGINT,
  "sch_enr_tr_f" BIGINT,
  "tot_enr_m" BIGINT,
  "tot_enr_f" BIGINT,
  "sch_enr_lep_m" BIGINT,
  "sch_enr_lep_f" BIGINT,
  "sch_enr_504_m" BIGINT,
  "sch_enr_504_f" BIGINT,
  "sch_enr_idea_m" BIGINT,
  "sch_enr_idea_f" BIGINT,
  "sch_lepenr_hi_m" BIGINT,
  "sch_lepenr_hi_f" BIGINT,
  "sch_lepenr_am_m" BIGINT,
  "sch_lepenr_am_f" BIGINT,
  "sch_lepenr_as_m" BIGINT,
  "sch_lepenr_as_f" BIGINT,
  "sch_lepenr_hp_m" BIGINT,
  "sch_lepenr_hp_f" BIGINT,
  "sch_lepenr_bl_m" BIGINT,
  "sch_lepenr_bl_f" BIGINT,
  "sch_lepenr_wh_m" BIGINT,
  "sch_lepenr_wh_f" BIGINT,
  "sch_lepenr_tr_m" BIGINT,
  "sch_lepenr_tr_f" BIGINT,
  "tot_lepenr_m" BIGINT,
  "tot_lepenr_f" BIGINT,
  "sch_lepprogenr_hi_m" BIGINT,
  "sch_lepprogenr_hi_f" BIGINT,
  "sch_lepprogenr_am_m" BIGINT,
  "sch_lepprogenr_am_f" BIGINT
);

Georgia - File As Of August 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.georgia_file_as_of_august_2018
  • 2.98 MB
  • 2407 rows
  • 1839 columns
Loading... 

CREATE TABLE georgia_file_as_of_august_2018 (
  "lea_state" VARCHAR,
  "lea_state_name" VARCHAR,
  "leaid" BIGINT,
  "lea_name" VARCHAR,
  "schid" BIGINT,
  "sch_name" VARCHAR,
  "combokey" BIGINT,
  "jj" VARCHAR,
  "ccd_latcod" DOUBLE,
  "ccd_loncod" DOUBLE,
  "nces_school_id" DOUBLE,
  "sch_grade_ps" VARCHAR,
  "sch_grade_kg" VARCHAR,
  "sch_grade_g01" VARCHAR,
  "sch_grade_g02" VARCHAR,
  "sch_grade_g03" VARCHAR,
  "sch_grade_g04" VARCHAR,
  "sch_grade_g05" VARCHAR,
  "sch_grade_g06" VARCHAR,
  "sch_grade_g07" VARCHAR,
  "sch_grade_g08" VARCHAR,
  "sch_grade_g09" VARCHAR,
  "sch_grade_g10" VARCHAR,
  "sch_grade_g11" VARCHAR,
  "sch_grade_g12" VARCHAR,
  "sch_grade_ug" VARCHAR,
  "sch_ugdetail_es" VARCHAR,
  "sch_ugdetail_ms" VARCHAR,
  "sch_ugdetail_hs" VARCHAR,
  "sch_status_sped" VARCHAR,
  "sch_status_magnet" VARCHAR,
  "sch_status_charter" VARCHAR,
  "sch_status_alt" VARCHAR,
  "sch_magnetdetail" VARCHAR,
  "sch_altfocus" VARCHAR,
  "sch_psenr_nonidea_a3" VARCHAR,
  "sch_psenr_nonidea_a4" VARCHAR,
  "sch_psenr_nonidea_a5" VARCHAR,
  "sch_psenr_hi_m" BIGINT,
  "sch_psenr_hi_f" BIGINT,
  "sch_psenr_am_m" BIGINT,
  "sch_psenr_am_f" BIGINT,
  "sch_psenr_as_m" BIGINT,
  "sch_psenr_as_f" BIGINT,
  "sch_psenr_hp_m" BIGINT,
  "sch_psenr_hp_f" BIGINT,
  "sch_psenr_bl_m" BIGINT,
  "sch_psenr_bl_f" BIGINT,
  "sch_psenr_wh_m" BIGINT,
  "sch_psenr_wh_f" BIGINT,
  "sch_psenr_tr_m" BIGINT,
  "sch_psenr_tr_f" BIGINT,
  "tot_psenr_m" BIGINT,
  "tot_psenr_f" BIGINT,
  "sch_psenr_lep_m" BIGINT,
  "sch_psenr_lep_f" BIGINT,
  "sch_psenr_idea_m" BIGINT,
  "sch_psenr_idea_f" BIGINT,
  "sch_enr_hi_m" BIGINT,
  "sch_enr_hi_f" BIGINT,
  "sch_enr_am_m" BIGINT,
  "sch_enr_am_f" BIGINT,
  "sch_enr_as_m" BIGINT,
  "sch_enr_as_f" BIGINT,
  "sch_enr_hp_m" BIGINT,
  "sch_enr_hp_f" BIGINT,
  "sch_enr_bl_m" BIGINT,
  "sch_enr_bl_f" BIGINT,
  "sch_enr_wh_m" BIGINT,
  "sch_enr_wh_f" BIGINT,
  "sch_enr_tr_m" BIGINT,
  "sch_enr_tr_f" BIGINT,
  "tot_enr_m" BIGINT,
  "tot_enr_f" BIGINT,
  "sch_enr_lep_m" BIGINT,
  "sch_enr_lep_f" BIGINT,
  "sch_enr_504_m" BIGINT,
  "sch_enr_504_f" BIGINT,
  "sch_enr_idea_m" BIGINT,
  "sch_enr_idea_f" BIGINT,
  "sch_lepenr_hi_m" BIGINT,
  "sch_lepenr_hi_f" BIGINT,
  "sch_lepenr_am_m" BIGINT,
  "sch_lepenr_am_f" BIGINT,
  "sch_lepenr_as_m" BIGINT,
  "sch_lepenr_as_f" BIGINT,
  "sch_lepenr_hp_m" BIGINT,
  "sch_lepenr_hp_f" BIGINT,
  "sch_lepenr_bl_m" BIGINT,
  "sch_lepenr_bl_f" BIGINT,
  "sch_lepenr_wh_m" BIGINT,
  "sch_lepenr_wh_f" BIGINT,
  "sch_lepenr_tr_m" BIGINT,
  "sch_lepenr_tr_f" BIGINT,
  "tot_lepenr_m" BIGINT,
  "tot_lepenr_f" BIGINT,
  "sch_lepprogenr_hi_m" BIGINT,
  "sch_lepprogenr_hi_f" BIGINT,
  "sch_lepprogenr_am_m" BIGINT,
  "sch_lepprogenr_am_f" BIGINT
);

Georgia - File As Of October 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.georgia_file_as_of_october_2018
  • 2.99 MB
  • 2407 rows
  • 1839 columns
Loading... 

CREATE TABLE georgia_file_as_of_october_2018 (
  "lea_state" VARCHAR,
  "lea_state_name" VARCHAR,
  "leaid" BIGINT,
  "lea_name" VARCHAR,
  "schid" BIGINT,
  "sch_name" VARCHAR,
  "combokey" BIGINT,
  "jj" VARCHAR,
  "ccd_latcod" DOUBLE,
  "ccd_loncod" DOUBLE,
  "nces_school_id" DOUBLE,
  "sch_grade_ps" VARCHAR,
  "sch_grade_kg" VARCHAR,
  "sch_grade_g01" VARCHAR,
  "sch_grade_g02" VARCHAR,
  "sch_grade_g03" VARCHAR,
  "sch_grade_g04" VARCHAR,
  "sch_grade_g05" VARCHAR,
  "sch_grade_g06" VARCHAR,
  "sch_grade_g07" VARCHAR,
  "sch_grade_g08" VARCHAR,
  "sch_grade_g09" VARCHAR,
  "sch_grade_g10" VARCHAR,
  "sch_grade_g11" VARCHAR,
  "sch_grade_g12" VARCHAR,
  "sch_grade_ug" VARCHAR,
  "sch_ugdetail_es" VARCHAR,
  "sch_ugdetail_ms" VARCHAR,
  "sch_ugdetail_hs" VARCHAR,
  "sch_status_sped" VARCHAR,
  "sch_status_magnet" VARCHAR,
  "sch_status_charter" VARCHAR,
  "sch_status_alt" VARCHAR,
  "sch_magnetdetail" VARCHAR,
  "sch_altfocus" VARCHAR,
  "sch_psenr_nonidea_a3" VARCHAR,
  "sch_psenr_nonidea_a4" VARCHAR,
  "sch_psenr_nonidea_a5" VARCHAR,
  "sch_psenr_hi_m" BIGINT,
  "sch_psenr_hi_f" BIGINT,
  "sch_psenr_am_m" BIGINT,
  "sch_psenr_am_f" BIGINT,
  "sch_psenr_as_m" BIGINT,
  "sch_psenr_as_f" BIGINT,
  "sch_psenr_hp_m" BIGINT,
  "sch_psenr_hp_f" BIGINT,
  "sch_psenr_bl_m" BIGINT,
  "sch_psenr_bl_f" BIGINT,
  "sch_psenr_wh_m" BIGINT,
  "sch_psenr_wh_f" BIGINT,
  "sch_psenr_tr_m" BIGINT,
  "sch_psenr_tr_f" BIGINT,
  "tot_psenr_m" BIGINT,
  "tot_psenr_f" BIGINT,
  "sch_psenr_lep_m" BIGINT,
  "sch_psenr_lep_f" BIGINT,
  "sch_psenr_idea_m" BIGINT,
  "sch_psenr_idea_f" BIGINT,
  "sch_enr_hi_m" BIGINT,
  "sch_enr_hi_f" BIGINT,
  "sch_enr_am_m" BIGINT,
  "sch_enr_am_f" BIGINT,
  "sch_enr_as_m" BIGINT,
  "sch_enr_as_f" BIGINT,
  "sch_enr_hp_m" BIGINT,
  "sch_enr_hp_f" BIGINT,
  "sch_enr_bl_m" BIGINT,
  "sch_enr_bl_f" BIGINT,
  "sch_enr_wh_m" BIGINT,
  "sch_enr_wh_f" BIGINT,
  "sch_enr_tr_m" BIGINT,
  "sch_enr_tr_f" BIGINT,
  "tot_enr_m" BIGINT,
  "tot_enr_f" BIGINT,
  "sch_enr_lep_m" BIGINT,
  "sch_enr_lep_f" BIGINT,
  "sch_enr_504_m" BIGINT,
  "sch_enr_504_f" BIGINT,
  "sch_enr_idea_m" BIGINT,
  "sch_enr_idea_f" BIGINT,
  "sch_lepenr_hi_m" BIGINT,
  "sch_lepenr_hi_f" BIGINT,
  "sch_lepenr_am_m" BIGINT,
  "sch_lepenr_am_f" BIGINT,
  "sch_lepenr_as_m" BIGINT,
  "sch_lepenr_as_f" BIGINT,
  "sch_lepenr_hp_m" BIGINT,
  "sch_lepenr_hp_f" BIGINT,
  "sch_lepenr_bl_m" BIGINT,
  "sch_lepenr_bl_f" BIGINT,
  "sch_lepenr_wh_m" BIGINT,
  "sch_lepenr_wh_f" BIGINT,
  "sch_lepenr_tr_m" BIGINT,
  "sch_lepenr_tr_f" BIGINT,
  "tot_lepenr_m" BIGINT,
  "tot_lepenr_f" BIGINT,
  "sch_lepprogenr_hi_m" BIGINT,
  "sch_lepprogenr_hi_f" BIGINT,
  "sch_lepprogenr_am_m" BIGINT,
  "sch_lepprogenr_am_f" BIGINT
);

Hawaii - File As Of August 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.hawaii_file_as_of_august_2018
  • 1.57 MB
  • 290 rows
  • 1839 columns
Loading... 

CREATE TABLE hawaii_file_as_of_august_2018 (
  "lea_state" VARCHAR,
  "lea_state_name" VARCHAR,
  "leaid" BIGINT,
  "lea_name" VARCHAR,
  "schid" BIGINT,
  "sch_name" VARCHAR,
  "combokey" BIGINT,
  "jj" VARCHAR,
  "ccd_latcod" DOUBLE,
  "ccd_loncod" DOUBLE,
  "nces_school_id" BIGINT,
  "sch_grade_ps" VARCHAR,
  "sch_grade_kg" VARCHAR,
  "sch_grade_g01" VARCHAR,
  "sch_grade_g02" VARCHAR,
  "sch_grade_g03" VARCHAR,
  "sch_grade_g04" VARCHAR,
  "sch_grade_g05" VARCHAR,
  "sch_grade_g06" VARCHAR,
  "sch_grade_g07" VARCHAR,
  "sch_grade_g08" VARCHAR,
  "sch_grade_g09" VARCHAR,
  "sch_grade_g10" VARCHAR,
  "sch_grade_g11" VARCHAR,
  "sch_grade_g12" VARCHAR,
  "sch_grade_ug" VARCHAR,
  "sch_ugdetail_es" VARCHAR,
  "sch_ugdetail_ms" VARCHAR,
  "sch_ugdetail_hs" VARCHAR,
  "sch_status_sped" VARCHAR,
  "sch_status_magnet" VARCHAR,
  "sch_status_charter" VARCHAR,
  "sch_status_alt" VARCHAR,
  "sch_magnetdetail" BIGINT,
  "sch_altfocus" VARCHAR,
  "sch_psenr_nonidea_a3" VARCHAR,
  "sch_psenr_nonidea_a4" VARCHAR,
  "sch_psenr_nonidea_a5" VARCHAR,
  "sch_psenr_hi_m" BIGINT,
  "sch_psenr_hi_f" BIGINT,
  "sch_psenr_am_m" BIGINT,
  "sch_psenr_am_f" BIGINT,
  "sch_psenr_as_m" BIGINT,
  "sch_psenr_as_f" BIGINT,
  "sch_psenr_hp_m" BIGINT,
  "sch_psenr_hp_f" BIGINT,
  "sch_psenr_bl_m" BIGINT,
  "sch_psenr_bl_f" BIGINT,
  "sch_psenr_wh_m" BIGINT,
  "sch_psenr_wh_f" BIGINT,
  "sch_psenr_tr_m" BIGINT,
  "sch_psenr_tr_f" BIGINT,
  "tot_psenr_m" BIGINT,
  "tot_psenr_f" BIGINT,
  "sch_psenr_lep_m" BIGINT,
  "sch_psenr_lep_f" BIGINT,
  "sch_psenr_idea_m" BIGINT,
  "sch_psenr_idea_f" BIGINT,
  "sch_enr_hi_m" BIGINT,
  "sch_enr_hi_f" BIGINT,
  "sch_enr_am_m" BIGINT,
  "sch_enr_am_f" BIGINT,
  "sch_enr_as_m" BIGINT,
  "sch_enr_as_f" BIGINT,
  "sch_enr_hp_m" BIGINT,
  "sch_enr_hp_f" BIGINT,
  "sch_enr_bl_m" BIGINT,
  "sch_enr_bl_f" BIGINT,
  "sch_enr_wh_m" BIGINT,
  "sch_enr_wh_f" BIGINT,
  "sch_enr_tr_m" BIGINT,
  "sch_enr_tr_f" BIGINT,
  "tot_enr_m" BIGINT,
  "tot_enr_f" BIGINT,
  "sch_enr_lep_m" BIGINT,
  "sch_enr_lep_f" BIGINT,
  "sch_enr_504_m" BIGINT,
  "sch_enr_504_f" BIGINT,
  "sch_enr_idea_m" BIGINT,
  "sch_enr_idea_f" BIGINT,
  "sch_lepenr_hi_m" BIGINT,
  "sch_lepenr_hi_f" BIGINT,
  "sch_lepenr_am_m" BIGINT,
  "sch_lepenr_am_f" BIGINT,
  "sch_lepenr_as_m" BIGINT,
  "sch_lepenr_as_f" BIGINT,
  "sch_lepenr_hp_m" BIGINT,
  "sch_lepenr_hp_f" BIGINT,
  "sch_lepenr_bl_m" BIGINT,
  "sch_lepenr_bl_f" BIGINT,
  "sch_lepenr_wh_m" BIGINT,
  "sch_lepenr_wh_f" BIGINT,
  "sch_lepenr_tr_m" BIGINT,
  "sch_lepenr_tr_f" BIGINT,
  "tot_lepenr_m" BIGINT,
  "tot_lepenr_f" BIGINT,
  "sch_lepprogenr_hi_m" BIGINT,
  "sch_lepprogenr_hi_f" BIGINT,
  "sch_lepprogenr_am_m" BIGINT,
  "sch_lepprogenr_am_f" BIGINT
);

Hawaii - File As Of October 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.hawaii_file_as_of_october_2018
  • 1.57 MB
  • 290 rows
  • 1839 columns
Loading... 

CREATE TABLE hawaii_file_as_of_october_2018 (
  "lea_state" VARCHAR,
  "lea_state_name" VARCHAR,
  "leaid" BIGINT,
  "lea_name" VARCHAR,
  "schid" BIGINT,
  "sch_name" VARCHAR,
  "combokey" BIGINT,
  "jj" VARCHAR,
  "ccd_latcod" DOUBLE,
  "ccd_loncod" DOUBLE,
  "nces_school_id" BIGINT,
  "sch_grade_ps" VARCHAR,
  "sch_grade_kg" VARCHAR,
  "sch_grade_g01" VARCHAR,
  "sch_grade_g02" VARCHAR,
  "sch_grade_g03" VARCHAR,
  "sch_grade_g04" VARCHAR,
  "sch_grade_g05" VARCHAR,
  "sch_grade_g06" VARCHAR,
  "sch_grade_g07" VARCHAR,
  "sch_grade_g08" VARCHAR,
  "sch_grade_g09" VARCHAR,
  "sch_grade_g10" VARCHAR,
  "sch_grade_g11" VARCHAR,
  "sch_grade_g12" VARCHAR,
  "sch_grade_ug" VARCHAR,
  "sch_ugdetail_es" VARCHAR,
  "sch_ugdetail_ms" VARCHAR,
  "sch_ugdetail_hs" VARCHAR,
  "sch_status_sped" VARCHAR,
  "sch_status_magnet" VARCHAR,
  "sch_status_charter" VARCHAR,
  "sch_status_alt" VARCHAR,
  "sch_magnetdetail" BIGINT,
  "sch_altfocus" VARCHAR,
  "sch_psenr_nonidea_a3" VARCHAR,
  "sch_psenr_nonidea_a4" VARCHAR,
  "sch_psenr_nonidea_a5" VARCHAR,
  "sch_psenr_hi_m" BIGINT,
  "sch_psenr_hi_f" BIGINT,
  "sch_psenr_am_m" BIGINT,
  "sch_psenr_am_f" BIGINT,
  "sch_psenr_as_m" BIGINT,
  "sch_psenr_as_f" BIGINT,
  "sch_psenr_hp_m" BIGINT,
  "sch_psenr_hp_f" BIGINT,
  "sch_psenr_bl_m" BIGINT,
  "sch_psenr_bl_f" BIGINT,
  "sch_psenr_wh_m" BIGINT,
  "sch_psenr_wh_f" BIGINT,
  "sch_psenr_tr_m" BIGINT,
  "sch_psenr_tr_f" BIGINT,
  "tot_psenr_m" BIGINT,
  "tot_psenr_f" BIGINT,
  "sch_psenr_lep_m" BIGINT,
  "sch_psenr_lep_f" BIGINT,
  "sch_psenr_idea_m" BIGINT,
  "sch_psenr_idea_f" BIGINT,
  "sch_enr_hi_m" BIGINT,
  "sch_enr_hi_f" BIGINT,
  "sch_enr_am_m" BIGINT,
  "sch_enr_am_f" BIGINT,
  "sch_enr_as_m" BIGINT,
  "sch_enr_as_f" BIGINT,
  "sch_enr_hp_m" BIGINT,
  "sch_enr_hp_f" BIGINT,
  "sch_enr_bl_m" BIGINT,
  "sch_enr_bl_f" BIGINT,
  "sch_enr_wh_m" BIGINT,
  "sch_enr_wh_f" BIGINT,
  "sch_enr_tr_m" BIGINT,
  "sch_enr_tr_f" BIGINT,
  "tot_enr_m" BIGINT,
  "tot_enr_f" BIGINT,
  "sch_enr_lep_m" BIGINT,
  "sch_enr_lep_f" BIGINT,
  "sch_enr_504_m" BIGINT,
  "sch_enr_504_f" BIGINT,
  "sch_enr_idea_m" BIGINT,
  "sch_enr_idea_f" BIGINT,
  "sch_lepenr_hi_m" BIGINT,
  "sch_lepenr_hi_f" BIGINT,
  "sch_lepenr_am_m" BIGINT,
  "sch_lepenr_am_f" BIGINT,
  "sch_lepenr_as_m" BIGINT,
  "sch_lepenr_as_f" BIGINT,
  "sch_lepenr_hp_m" BIGINT,
  "sch_lepenr_hp_f" BIGINT,
  "sch_lepenr_bl_m" BIGINT,
  "sch_lepenr_bl_f" BIGINT,
  "sch_lepenr_wh_m" BIGINT,
  "sch_lepenr_wh_f" BIGINT,
  "sch_lepenr_tr_m" BIGINT,
  "sch_lepenr_tr_f" BIGINT,
  "tot_lepenr_m" BIGINT,
  "tot_lepenr_f" BIGINT,
  "sch_lepprogenr_hi_m" BIGINT,
  "sch_lepprogenr_hi_f" BIGINT,
  "sch_lepprogenr_am_m" BIGINT,
  "sch_lepprogenr_am_f" BIGINT
);

Idaho - File As Of August 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.idaho_file_as_of_august_2018
  • 1.81 MB
  • 720 rows
  • 1839 columns
Loading... 

CREATE TABLE idaho_file_as_of_august_2018 (
  "lea_state" VARCHAR,
  "lea_state_name" VARCHAR,
  "leaid" BIGINT,
  "lea_name" VARCHAR,
  "schid" BIGINT,
  "sch_name" VARCHAR,
  "combokey" BIGINT,
  "jj" VARCHAR,
  "ccd_latcod" DOUBLE,
  "ccd_loncod" DOUBLE,
  "nces_school_id" DOUBLE,
  "sch_grade_ps" VARCHAR,
  "sch_grade_kg" VARCHAR,
  "sch_grade_g01" VARCHAR,
  "sch_grade_g02" VARCHAR,
  "sch_grade_g03" VARCHAR,
  "sch_grade_g04" VARCHAR,
  "sch_grade_g05" VARCHAR,
  "sch_grade_g06" VARCHAR,
  "sch_grade_g07" VARCHAR,
  "sch_grade_g08" VARCHAR,
  "sch_grade_g09" VARCHAR,
  "sch_grade_g10" VARCHAR,
  "sch_grade_g11" VARCHAR,
  "sch_grade_g12" VARCHAR,
  "sch_grade_ug" VARCHAR,
  "sch_ugdetail_es" VARCHAR,
  "sch_ugdetail_ms" VARCHAR,
  "sch_ugdetail_hs" VARCHAR,
  "sch_status_sped" VARCHAR,
  "sch_status_magnet" VARCHAR,
  "sch_status_charter" VARCHAR,
  "sch_status_alt" VARCHAR,
  "sch_magnetdetail" VARCHAR,
  "sch_altfocus" VARCHAR,
  "sch_psenr_nonidea_a3" VARCHAR,
  "sch_psenr_nonidea_a4" VARCHAR,
  "sch_psenr_nonidea_a5" VARCHAR,
  "sch_psenr_hi_m" BIGINT,
  "sch_psenr_hi_f" BIGINT,
  "sch_psenr_am_m" BIGINT,
  "sch_psenr_am_f" BIGINT,
  "sch_psenr_as_m" BIGINT,
  "sch_psenr_as_f" BIGINT,
  "sch_psenr_hp_m" BIGINT,
  "sch_psenr_hp_f" BIGINT,
  "sch_psenr_bl_m" BIGINT,
  "sch_psenr_bl_f" BIGINT,
  "sch_psenr_wh_m" BIGINT,
  "sch_psenr_wh_f" BIGINT,
  "sch_psenr_tr_m" BIGINT,
  "sch_psenr_tr_f" BIGINT,
  "tot_psenr_m" BIGINT,
  "tot_psenr_f" BIGINT,
  "sch_psenr_lep_m" BIGINT,
  "sch_psenr_lep_f" BIGINT,
  "sch_psenr_idea_m" BIGINT,
  "sch_psenr_idea_f" BIGINT,
  "sch_enr_hi_m" BIGINT,
  "sch_enr_hi_f" BIGINT,
  "sch_enr_am_m" BIGINT,
  "sch_enr_am_f" BIGINT,
  "sch_enr_as_m" BIGINT,
  "sch_enr_as_f" BIGINT,
  "sch_enr_hp_m" BIGINT,
  "sch_enr_hp_f" BIGINT,
  "sch_enr_bl_m" BIGINT,
  "sch_enr_bl_f" BIGINT,
  "sch_enr_wh_m" BIGINT,
  "sch_enr_wh_f" BIGINT,
  "sch_enr_tr_m" BIGINT,
  "sch_enr_tr_f" BIGINT,
  "tot_enr_m" BIGINT,
  "tot_enr_f" BIGINT,
  "sch_enr_lep_m" BIGINT,
  "sch_enr_lep_f" BIGINT,
  "sch_enr_504_m" BIGINT,
  "sch_enr_504_f" BIGINT,
  "sch_enr_idea_m" BIGINT,
  "sch_enr_idea_f" BIGINT,
  "sch_lepenr_hi_m" BIGINT,
  "sch_lepenr_hi_f" BIGINT,
  "sch_lepenr_am_m" BIGINT,
  "sch_lepenr_am_f" BIGINT,
  "sch_lepenr_as_m" BIGINT,
  "sch_lepenr_as_f" BIGINT,
  "sch_lepenr_hp_m" BIGINT,
  "sch_lepenr_hp_f" BIGINT,
  "sch_lepenr_bl_m" BIGINT,
  "sch_lepenr_bl_f" BIGINT,
  "sch_lepenr_wh_m" BIGINT,
  "sch_lepenr_wh_f" BIGINT,
  "sch_lepenr_tr_m" BIGINT,
  "sch_lepenr_tr_f" BIGINT,
  "tot_lepenr_m" BIGINT,
  "tot_lepenr_f" BIGINT,
  "sch_lepprogenr_hi_m" BIGINT,
  "sch_lepprogenr_hi_f" BIGINT,
  "sch_lepprogenr_am_m" BIGINT,
  "sch_lepprogenr_am_f" BIGINT
);

Idaho - File As Of October 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.idaho_file_as_of_october_2018
  • 1.78 MB
  • 720 rows
  • 1839 columns
Loading... 

CREATE TABLE idaho_file_as_of_october_2018 (
  "lea_state" VARCHAR,
  "lea_state_name" VARCHAR,
  "leaid" BIGINT,
  "lea_name" VARCHAR,
  "schid" BIGINT,
  "sch_name" VARCHAR,
  "combokey" BIGINT,
  "jj" VARCHAR,
  "ccd_latcod" DOUBLE,
  "ccd_loncod" DOUBLE,
  "nces_school_id" DOUBLE,
  "sch_grade_ps" VARCHAR,
  "sch_grade_kg" VARCHAR,
  "sch_grade_g01" VARCHAR,
  "sch_grade_g02" VARCHAR,
  "sch_grade_g03" VARCHAR,
  "sch_grade_g04" VARCHAR,
  "sch_grade_g05" VARCHAR,
  "sch_grade_g06" VARCHAR,
  "sch_grade_g07" VARCHAR,
  "sch_grade_g08" VARCHAR,
  "sch_grade_g09" VARCHAR,
  "sch_grade_g10" VARCHAR,
  "sch_grade_g11" VARCHAR,
  "sch_grade_g12" VARCHAR,
  "sch_grade_ug" VARCHAR,
  "sch_ugdetail_es" VARCHAR,
  "sch_ugdetail_ms" VARCHAR,
  "sch_ugdetail_hs" VARCHAR,
  "sch_status_sped" VARCHAR,
  "sch_status_magnet" VARCHAR,
  "sch_status_charter" VARCHAR,
  "sch_status_alt" VARCHAR,
  "sch_magnetdetail" VARCHAR,
  "sch_altfocus" VARCHAR,
  "sch_psenr_nonidea_a3" VARCHAR,
  "sch_psenr_nonidea_a4" VARCHAR,
  "sch_psenr_nonidea_a5" VARCHAR,
  "sch_psenr_hi_m" BIGINT,
  "sch_psenr_hi_f" BIGINT,
  "sch_psenr_am_m" BIGINT,
  "sch_psenr_am_f" BIGINT,
  "sch_psenr_as_m" BIGINT,
  "sch_psenr_as_f" BIGINT,
  "sch_psenr_hp_m" BIGINT,
  "sch_psenr_hp_f" BIGINT,
  "sch_psenr_bl_m" BIGINT,
  "sch_psenr_bl_f" BIGINT,
  "sch_psenr_wh_m" BIGINT,
  "sch_psenr_wh_f" BIGINT,
  "sch_psenr_tr_m" BIGINT,
  "sch_psenr_tr_f" BIGINT,
  "tot_psenr_m" BIGINT,
  "tot_psenr_f" BIGINT,
  "sch_psenr_lep_m" BIGINT,
  "sch_psenr_lep_f" BIGINT,
  "sch_psenr_idea_m" BIGINT,
  "sch_psenr_idea_f" BIGINT,
  "sch_enr_hi_m" BIGINT,
  "sch_enr_hi_f" BIGINT,
  "sch_enr_am_m" BIGINT,
  "sch_enr_am_f" BIGINT,
  "sch_enr_as_m" BIGINT,
  "sch_enr_as_f" BIGINT,
  "sch_enr_hp_m" BIGINT,
  "sch_enr_hp_f" BIGINT,
  "sch_enr_bl_m" BIGINT,
  "sch_enr_bl_f" BIGINT,
  "sch_enr_wh_m" BIGINT,
  "sch_enr_wh_f" BIGINT,
  "sch_enr_tr_m" BIGINT,
  "sch_enr_tr_f" BIGINT,
  "tot_enr_m" BIGINT,
  "tot_enr_f" BIGINT,
  "sch_enr_lep_m" BIGINT,
  "sch_enr_lep_f" BIGINT,
  "sch_enr_504_m" BIGINT,
  "sch_enr_504_f" BIGINT,
  "sch_enr_idea_m" BIGINT,
  "sch_enr_idea_f" BIGINT,
  "sch_lepenr_hi_m" BIGINT,
  "sch_lepenr_hi_f" BIGINT,
  "sch_lepenr_am_m" BIGINT,
  "sch_lepenr_am_f" BIGINT,
  "sch_lepenr_as_m" BIGINT,
  "sch_lepenr_as_f" BIGINT,
  "sch_lepenr_hp_m" BIGINT,
  "sch_lepenr_hp_f" BIGINT,
  "sch_lepenr_bl_m" BIGINT,
  "sch_lepenr_bl_f" BIGINT,
  "sch_lepenr_wh_m" BIGINT,
  "sch_lepenr_wh_f" BIGINT,
  "sch_lepenr_tr_m" BIGINT,
  "sch_lepenr_tr_f" BIGINT,
  "tot_lepenr_m" BIGINT,
  "tot_lepenr_f" BIGINT,
  "sch_lepprogenr_hi_m" BIGINT,
  "sch_lepprogenr_hi_f" BIGINT,
  "sch_lepprogenr_am_m" BIGINT,
  "sch_lepprogenr_am_f" BIGINT
);

Illinois - File As Of August 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.illinois_file_as_of_august_2018
  • 3.72 MB
  • 4081 rows
  • 1839 columns
Loading... 

CREATE TABLE illinois_file_as_of_august_2018 (
  "lea_state" VARCHAR,
  "lea_state_name" VARCHAR,
  "leaid" BIGINT,
  "lea_name" VARCHAR,
  "schid" BIGINT,
  "sch_name" VARCHAR,
  "combokey" BIGINT,
  "jj" VARCHAR,
  "ccd_latcod" DOUBLE,
  "ccd_loncod" DOUBLE,
  "nces_school_id" DOUBLE,
  "sch_grade_ps" VARCHAR,
  "sch_grade_kg" VARCHAR,
  "sch_grade_g01" VARCHAR,
  "sch_grade_g02" VARCHAR,
  "sch_grade_g03" VARCHAR,
  "sch_grade_g04" VARCHAR,
  "sch_grade_g05" VARCHAR,
  "sch_grade_g06" VARCHAR,
  "sch_grade_g07" VARCHAR,
  "sch_grade_g08" VARCHAR,
  "sch_grade_g09" VARCHAR,
  "sch_grade_g10" VARCHAR,
  "sch_grade_g11" VARCHAR,
  "sch_grade_g12" VARCHAR,
  "sch_grade_ug" VARCHAR,
  "sch_ugdetail_es" VARCHAR,
  "sch_ugdetail_ms" VARCHAR,
  "sch_ugdetail_hs" VARCHAR,
  "sch_status_sped" VARCHAR,
  "sch_status_magnet" VARCHAR,
  "sch_status_charter" VARCHAR,
  "sch_status_alt" VARCHAR,
  "sch_magnetdetail" VARCHAR,
  "sch_altfocus" VARCHAR,
  "sch_psenr_nonidea_a3" VARCHAR,
  "sch_psenr_nonidea_a4" VARCHAR,
  "sch_psenr_nonidea_a5" VARCHAR,
  "sch_psenr_hi_m" BIGINT,
  "sch_psenr_hi_f" BIGINT,
  "sch_psenr_am_m" BIGINT,
  "sch_psenr_am_f" BIGINT,
  "sch_psenr_as_m" BIGINT,
  "sch_psenr_as_f" BIGINT,
  "sch_psenr_hp_m" BIGINT,
  "sch_psenr_hp_f" BIGINT,
  "sch_psenr_bl_m" BIGINT,
  "sch_psenr_bl_f" BIGINT,
  "sch_psenr_wh_m" BIGINT,
  "sch_psenr_wh_f" BIGINT,
  "sch_psenr_tr_m" BIGINT,
  "sch_psenr_tr_f" BIGINT,
  "tot_psenr_m" BIGINT,
  "tot_psenr_f" BIGINT,
  "sch_psenr_lep_m" BIGINT,
  "sch_psenr_lep_f" BIGINT,
  "sch_psenr_idea_m" BIGINT,
  "sch_psenr_idea_f" BIGINT,
  "sch_enr_hi_m" BIGINT,
  "sch_enr_hi_f" BIGINT,
  "sch_enr_am_m" BIGINT,
  "sch_enr_am_f" BIGINT,
  "sch_enr_as_m" BIGINT,
  "sch_enr_as_f" BIGINT,
  "sch_enr_hp_m" BIGINT,
  "sch_enr_hp_f" BIGINT,
  "sch_enr_bl_m" BIGINT,
  "sch_enr_bl_f" BIGINT,
  "sch_enr_wh_m" BIGINT,
  "sch_enr_wh_f" BIGINT,
  "sch_enr_tr_m" BIGINT,
  "sch_enr_tr_f" BIGINT,
  "tot_enr_m" BIGINT,
  "tot_enr_f" BIGINT,
  "sch_enr_lep_m" BIGINT,
  "sch_enr_lep_f" BIGINT,
  "sch_enr_504_m" BIGINT,
  "sch_enr_504_f" BIGINT,
  "sch_enr_idea_m" BIGINT,
  "sch_enr_idea_f" BIGINT,
  "sch_lepenr_hi_m" BIGINT,
  "sch_lepenr_hi_f" BIGINT,
  "sch_lepenr_am_m" BIGINT,
  "sch_lepenr_am_f" BIGINT,
  "sch_lepenr_as_m" BIGINT,
  "sch_lepenr_as_f" BIGINT,
  "sch_lepenr_hp_m" BIGINT,
  "sch_lepenr_hp_f" BIGINT,
  "sch_lepenr_bl_m" BIGINT,
  "sch_lepenr_bl_f" BIGINT,
  "sch_lepenr_wh_m" BIGINT,
  "sch_lepenr_wh_f" BIGINT,
  "sch_lepenr_tr_m" BIGINT,
  "sch_lepenr_tr_f" BIGINT,
  "tot_lepenr_m" BIGINT,
  "tot_lepenr_f" BIGINT,
  "sch_lepprogenr_hi_m" BIGINT,
  "sch_lepprogenr_hi_f" BIGINT,
  "sch_lepprogenr_am_m" BIGINT,
  "sch_lepprogenr_am_f" BIGINT
);

Illinois - File As Of October 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.illinois_file_as_of_october_2018
  • 3.66 MB
  • 4081 rows
  • 1839 columns
Loading... 

CREATE TABLE illinois_file_as_of_october_2018 (
  "lea_state" VARCHAR,
  "lea_state_name" VARCHAR,
  "leaid" BIGINT,
  "lea_name" VARCHAR,
  "schid" BIGINT,
  "sch_name" VARCHAR,
  "combokey" BIGINT,
  "jj" VARCHAR,
  "ccd_latcod" DOUBLE,
  "ccd_loncod" DOUBLE,
  "nces_school_id" DOUBLE,
  "sch_grade_ps" VARCHAR,
  "sch_grade_kg" VARCHAR,
  "sch_grade_g01" VARCHAR,
  "sch_grade_g02" VARCHAR,
  "sch_grade_g03" VARCHAR,
  "sch_grade_g04" VARCHAR,
  "sch_grade_g05" VARCHAR,
  "sch_grade_g06" VARCHAR,
  "sch_grade_g07" VARCHAR,
  "sch_grade_g08" VARCHAR,
  "sch_grade_g09" VARCHAR,
  "sch_grade_g10" VARCHAR,
  "sch_grade_g11" VARCHAR,
  "sch_grade_g12" VARCHAR,
  "sch_grade_ug" VARCHAR,
  "sch_ugdetail_es" VARCHAR,
  "sch_ugdetail_ms" VARCHAR,
  "sch_ugdetail_hs" VARCHAR,
  "sch_status_sped" VARCHAR,
  "sch_status_magnet" VARCHAR,
  "sch_status_charter" VARCHAR,
  "sch_status_alt" VARCHAR,
  "sch_magnetdetail" VARCHAR,
  "sch_altfocus" VARCHAR,
  "sch_psenr_nonidea_a3" VARCHAR,
  "sch_psenr_nonidea_a4" VARCHAR,
  "sch_psenr_nonidea_a5" VARCHAR,
  "sch_psenr_hi_m" BIGINT,
  "sch_psenr_hi_f" BIGINT,
  "sch_psenr_am_m" BIGINT,
  "sch_psenr_am_f" BIGINT,
  "sch_psenr_as_m" BIGINT,
  "sch_psenr_as_f" BIGINT,
  "sch_psenr_hp_m" BIGINT,
  "sch_psenr_hp_f" BIGINT,
  "sch_psenr_bl_m" BIGINT,
  "sch_psenr_bl_f" BIGINT,
  "sch_psenr_wh_m" BIGINT,
  "sch_psenr_wh_f" BIGINT,
  "sch_psenr_tr_m" BIGINT,
  "sch_psenr_tr_f" BIGINT,
  "tot_psenr_m" BIGINT,
  "tot_psenr_f" BIGINT,
  "sch_psenr_lep_m" BIGINT,
  "sch_psenr_lep_f" BIGINT,
  "sch_psenr_idea_m" BIGINT,
  "sch_psenr_idea_f" BIGINT,
  "sch_enr_hi_m" BIGINT,
  "sch_enr_hi_f" BIGINT,
  "sch_enr_am_m" BIGINT,
  "sch_enr_am_f" BIGINT,
  "sch_enr_as_m" BIGINT,
  "sch_enr_as_f" BIGINT,
  "sch_enr_hp_m" BIGINT,
  "sch_enr_hp_f" BIGINT,
  "sch_enr_bl_m" BIGINT,
  "sch_enr_bl_f" BIGINT,
  "sch_enr_wh_m" BIGINT,
  "sch_enr_wh_f" BIGINT,
  "sch_enr_tr_m" BIGINT,
  "sch_enr_tr_f" BIGINT,
  "tot_enr_m" BIGINT,
  "tot_enr_f" BIGINT,
  "sch_enr_lep_m" BIGINT,
  "sch_enr_lep_f" BIGINT,
  "sch_enr_504_m" BIGINT,
  "sch_enr_504_f" BIGINT,
  "sch_enr_idea_m" BIGINT,
  "sch_enr_idea_f" BIGINT,
  "sch_lepenr_hi_m" BIGINT,
  "sch_lepenr_hi_f" BIGINT,
  "sch_lepenr_am_m" BIGINT,
  "sch_lepenr_am_f" BIGINT,
  "sch_lepenr_as_m" BIGINT,
  "sch_lepenr_as_f" BIGINT,
  "sch_lepenr_hp_m" BIGINT,
  "sch_lepenr_hp_f" BIGINT,
  "sch_lepenr_bl_m" BIGINT,
  "sch_lepenr_bl_f" BIGINT,
  "sch_lepenr_wh_m" BIGINT,
  "sch_lepenr_wh_f" BIGINT,
  "sch_lepenr_tr_m" BIGINT,
  "sch_lepenr_tr_f" BIGINT,
  "tot_lepenr_m" BIGINT,
  "tot_lepenr_f" BIGINT,
  "sch_lepprogenr_hi_m" BIGINT,
  "sch_lepprogenr_hi_f" BIGINT,
  "sch_lepprogenr_am_m" BIGINT,
  "sch_lepprogenr_am_f" BIGINT
);

Indiana - File As Of August 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.indiana_file_as_of_august_2018
  • 2.53 MB
  • 1879 rows
  • 1839 columns
Loading... 

CREATE TABLE indiana_file_as_of_august_2018 (
  "lea_state" VARCHAR,
  "lea_state_name" VARCHAR,
  "leaid" BIGINT,
  "lea_name" VARCHAR,
  "schid" BIGINT,
  "sch_name" VARCHAR,
  "combokey" BIGINT,
  "jj" VARCHAR,
  "ccd_latcod" DOUBLE,
  "ccd_loncod" DOUBLE,
  "nces_school_id" DOUBLE,
  "sch_grade_ps" VARCHAR,
  "sch_grade_kg" VARCHAR,
  "sch_grade_g01" VARCHAR,
  "sch_grade_g02" VARCHAR,
  "sch_grade_g03" VARCHAR,
  "sch_grade_g04" VARCHAR,
  "sch_grade_g05" VARCHAR,
  "sch_grade_g06" VARCHAR,
  "sch_grade_g07" VARCHAR,
  "sch_grade_g08" VARCHAR,
  "sch_grade_g09" VARCHAR,
  "sch_grade_g10" VARCHAR,
  "sch_grade_g11" VARCHAR,
  "sch_grade_g12" VARCHAR,
  "sch_grade_ug" VARCHAR,
  "sch_ugdetail_es" VARCHAR,
  "sch_ugdetail_ms" VARCHAR,
  "sch_ugdetail_hs" VARCHAR,
  "sch_status_sped" VARCHAR,
  "sch_status_magnet" VARCHAR,
  "sch_status_charter" VARCHAR,
  "sch_status_alt" VARCHAR,
  "sch_magnetdetail" VARCHAR,
  "sch_altfocus" VARCHAR,
  "sch_psenr_nonidea_a3" VARCHAR,
  "sch_psenr_nonidea_a4" VARCHAR,
  "sch_psenr_nonidea_a5" VARCHAR,
  "sch_psenr_hi_m" BIGINT,
  "sch_psenr_hi_f" BIGINT,
  "sch_psenr_am_m" BIGINT,
  "sch_psenr_am_f" BIGINT,
  "sch_psenr_as_m" BIGINT,
  "sch_psenr_as_f" BIGINT,
  "sch_psenr_hp_m" BIGINT,
  "sch_psenr_hp_f" BIGINT,
  "sch_psenr_bl_m" BIGINT,
  "sch_psenr_bl_f" BIGINT,
  "sch_psenr_wh_m" BIGINT,
  "sch_psenr_wh_f" BIGINT,
  "sch_psenr_tr_m" BIGINT,
  "sch_psenr_tr_f" BIGINT,
  "tot_psenr_m" BIGINT,
  "tot_psenr_f" BIGINT,
  "sch_psenr_lep_m" BIGINT,
  "sch_psenr_lep_f" BIGINT,
  "sch_psenr_idea_m" BIGINT,
  "sch_psenr_idea_f" BIGINT,
  "sch_enr_hi_m" BIGINT,
  "sch_enr_hi_f" BIGINT,
  "sch_enr_am_m" BIGINT,
  "sch_enr_am_f" BIGINT,
  "sch_enr_as_m" BIGINT,
  "sch_enr_as_f" BIGINT,
  "sch_enr_hp_m" BIGINT,
  "sch_enr_hp_f" BIGINT,
  "sch_enr_bl_m" BIGINT,
  "sch_enr_bl_f" BIGINT,
  "sch_enr_wh_m" BIGINT,
  "sch_enr_wh_f" BIGINT,
  "sch_enr_tr_m" BIGINT,
  "sch_enr_tr_f" BIGINT,
  "tot_enr_m" BIGINT,
  "tot_enr_f" BIGINT,
  "sch_enr_lep_m" BIGINT,
  "sch_enr_lep_f" BIGINT,
  "sch_enr_504_m" BIGINT,
  "sch_enr_504_f" BIGINT,
  "sch_enr_idea_m" BIGINT,
  "sch_enr_idea_f" BIGINT,
  "sch_lepenr_hi_m" BIGINT,
  "sch_lepenr_hi_f" BIGINT,
  "sch_lepenr_am_m" BIGINT,
  "sch_lepenr_am_f" BIGINT,
  "sch_lepenr_as_m" BIGINT,
  "sch_lepenr_as_f" BIGINT,
  "sch_lepenr_hp_m" BIGINT,
  "sch_lepenr_hp_f" BIGINT,
  "sch_lepenr_bl_m" BIGINT,
  "sch_lepenr_bl_f" BIGINT,
  "sch_lepenr_wh_m" BIGINT,
  "sch_lepenr_wh_f" BIGINT,
  "sch_lepenr_tr_m" BIGINT,
  "sch_lepenr_tr_f" BIGINT,
  "tot_lepenr_m" BIGINT,
  "tot_lepenr_f" BIGINT,
  "sch_lepprogenr_hi_m" BIGINT,
  "sch_lepprogenr_hi_f" BIGINT,
  "sch_lepprogenr_am_m" BIGINT,
  "sch_lepprogenr_am_f" BIGINT
);

Share link

Anyone who has the link will be able to view this.