Source file: Preschool-Enrollment.xlsx (CRDC 2020-21)

Original mirror URL: https://topofire.dbs.umt.edu/public_data/federal_public_datasets/Civil%20Rights%20Data%20Collection/2020-2021/Student%20Enrollment/Preschool-Enrollment.xlsx

Sheet used: Female

Header rows (sheet row indices 3-5 in zero-based pandas):

row3: nan | State | nan | nan | Race/Ethnicity | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | Students With Disabilities Served Under IDEA  | nan | English Language Learners | nan | Number of Schools | Percent of Schools Reporting

row4: nan | nan | Total  | nan | American Indian or

Alaska Native | nan | Asian | nan | Hispanic or Latino of any race | nan | Black or African American | nan | White | nan | Native Hawaiian or Other Pacific Islander | nan | Two or more races | nan | nan | nan | nan | nan | nan | nan

row5: enrolled in Preschool | nan | Number | Percent | Number | Percent  | Number | Percent  | Number | Percent  | Number | Percent  | Number | Percent  | Number | Percent  | Number | Percent  | Number | Percent | Number | Percent | nan | nan

row63: nan | SOURCE: U.S. Department of Education, Office for Civil Rights, Civil Rights Data Collection, 2020-21, Public Use File | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan | nan

 

Column mapping used (0-based): state=col1; Asian_number=col6; Hispanic_or_Latino_number=col8; White_number=col12

Target state rows from Female sheet:

Alabama: Hispanic_or_Latino=651, Asian=111, White=5050, Female_Preschool_Total=9415

California: Hispanic_or_Latino=13689, Asian=2054, White=3847, Female_Preschool_Total=21916

Florida: Hispanic_or_Latino=7478, Asian=383, White=6544, Female_Preschool_Total=21080

Kansas: Hispanic_or_Latino=1726, Asian=155, White=4941, Female_Preschool_Total=7727

Washington: Hispanic_or_Latino=1946, Asian=446, White=2867, Female_Preschool_Total=6447

 

Raw row snippets (state | total | Asian | Hispanic | White):

row7: Alabama | 9415 | 111 | 651 | 5050

row11: California | 21916 | 2054 | 13689 | 3847

row16: Florida | 21080 | 383 | 7478 | 6544

row23: Kansas | 7727 | 155 | 1726 | 4941

row55: Washington | 6447 | 446 | 1946 | 2867