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.365253
Tags: evaluation, ocr, performance, policy-analysis, trend-analysis

Tables

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.63 MB
  • 1,977 rows
  • 1,839 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.62 MB
  • 1,977 rows
  • 1,839 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
);

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.68 MB
  • 1,868 rows
  • 1,839 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.68 MB
  • 1,868 rows
  • 1,839 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
);

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.83 MB
  • 3,952 rows
  • 1,839 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.87 MB
  • 3,952 rows
  • 1,839 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
);

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.9 MB
  • 720 rows
  • 1,839 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.87 MB
  • 720 rows
  • 1,839 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.93 MB
  • 4,081 rows
  • 1,839 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.87 MB
  • 4,081 rows
  • 1,839 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
);

Kentucky - File As Of August 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.kentucky_file_as_of_august_2018
  • 2.42 MB
  • 1,407 rows
  • 1,839 columns
Loading... 
CREATE TABLE kentucky_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
);

Kentucky - File As Of October 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.kentucky_file_as_of_october_2018
  • 2.37 MB
  • 1,407 rows
  • 1,839 columns
Loading... 
CREATE TABLE kentucky_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
);

Louisiana - File As Of August 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.louisiana_file_as_of_august_2018
  • 2.36 MB
  • 1,367 rows
  • 1,839 columns
Loading... 
CREATE TABLE louisiana_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
);

Louisiana - File As Of October 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.louisiana_file_as_of_october_2018
  • 2.32 MB
  • 1,367 rows
  • 1,839 columns
Loading... 
CREATE TABLE louisiana_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
);

Maryland - File As Of August 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.maryland_file_as_of_august_2018
  • 2.36 MB
  • 1,434 rows
  • 1,839 columns
Loading... 
CREATE TABLE maryland_file_as_of_august_2018 (
  "lea_state" VARCHAR,
  "lea_state_name" VARCHAR,
  "leaid" VARCHAR,
  "lea_name" VARCHAR,
  "schid" BIGINT,
  "sch_name" VARCHAR,
  "combokey" VARCHAR,
  "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
);

Maryland - File As Of October 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.maryland_file_as_of_october_2018
  • 2.36 MB
  • 1,434 rows
  • 1,839 columns
Loading... 
CREATE TABLE maryland_file_as_of_october_2018 (
  "lea_state" VARCHAR,
  "lea_state_name" VARCHAR,
  "leaid" VARCHAR,
  "lea_name" VARCHAR,
  "schid" BIGINT,
  "sch_name" VARCHAR,
  "combokey" VARCHAR,
  "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
);

Massachusetts - File As Of August 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.massachusetts_file_as_of_august_2018
  • 2.68 MB
  • 1,873 rows
  • 1,839 columns
Loading... 
CREATE TABLE massachusetts_file_as_of_august_2018 (
  "lea_state" VARCHAR,
  "lea_state_name" VARCHAR,
  "leaid" VARCHAR,
  "lea_name" VARCHAR,
  "schid" BIGINT,
  "sch_name" VARCHAR,
  "combokey" VARCHAR,
  "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
);

Massachusetts - File As Of October 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.massachusetts_file_as_of_october_2018
  • 2.68 MB
  • 1,873 rows
  • 1,839 columns
Loading... 
CREATE TABLE massachusetts_file_as_of_october_2018 (
  "lea_state" VARCHAR,
  "lea_state_name" VARCHAR,
  "leaid" VARCHAR,
  "lea_name" VARCHAR,
  "schid" BIGINT,
  "sch_name" VARCHAR,
  "combokey" VARCHAR,
  "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
);

Montana - File As Of August 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.montana_file_as_of_august_2018
  • 1.81 MB
  • 825 rows
  • 1,839 columns
Loading... 
CREATE TABLE montana_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" BIGINT,
  "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
);

Montana - File As Of October 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.montana_file_as_of_october_2018
  • 1.81 MB
  • 825 rows
  • 1,839 columns
Loading... 
CREATE TABLE montana_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" BIGINT,
  "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
);

New York - File As Of August 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.new_york_file_as_of_august_2018
  • 4.27 MB
  • 4,916 rows
  • 1,839 columns
Loading... 
CREATE TABLE new_york_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
);

New York - File As Of October 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.new_york_file_as_of_october_2018
  • 4.21 MB
  • 4,916 rows
  • 1,839 columns
Loading... 
CREATE TABLE new_york_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
);

North Carolina - File As Of August 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.north_carolina_file_as_of_august_2018
  • 3.2 MB
  • 2,618 rows
  • 1,839 columns
Loading... 
CREATE TABLE north_carolina_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
);

North Carolina - File As Of October 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.north_carolina_file_as_of_october_2018
  • 3.14 MB
  • 2,618 rows
  • 1,839 columns
Loading... 
CREATE TABLE north_carolina_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
);

Ohio - File As Of August 2018

@usgov.ed_gov_civil_rights_data_collection_state_files_2015_16_cf9b8.ohio_file_as_of_august_2018
  • 3.61 MB
  • 3,631 rows
  • 1,839 columns
Loading... 
CREATE TABLE ohio_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.