Enrollment by school

School-level enrollment by racial/ethnic designation, gender, and grade.

cde.ca.gov-enrollment-1

Resources | Packages | Documentation| Contacts| References| Data Dictionary

Resources

Documentation

Enrollment by school and demographic group for the years 2007 to 2018. The upstream dataset has enrollment data files for yearlier years, as early as 1981, but these files have a different structure.

Caveats

The download page includes this note:

Note these data files contain enrollment data for primary enrollments only. 
It does not include short-term enrollments. For data on short-term enrollments, 
please refer to the Primary and Short-term Enrollment by School data files.

Some of the annual files have a Race/Ethincity code of ‘8’, which corresponds to “Multiple or No Response” in he 1998 to 2006 file structure, but is not defined for this set of files.

Versions

  1. Initial Version

Contacts

Packages

Accessing Packages in Metapack

import metapack as mp
pkg = mp.open_package('http://library.metatab.org/cde.ca.gov-enrollment-1.zip')

# Create Dataframes

enrollment_07_18_df = pkg.resource('enrollment_07_18').dataframe()
race_eth_07_18_df = pkg.resource('race_eth_07_18').dataframe()

Data Dictionary

enrollment_07_18 | race_eth_07_18

enrollment_07_18

Column NameData TypeDescription
yearintegerFile year of source data
cdscodeintegerThis 14-digit code is the official, unique identification of a school within California. The first two digits identify the county, the next five digits identify the school district, and the last seven digits identify the school.
countystringCounty name.
districtstringDistrict name.
schooltextSchool name.
ethnicintegerRacial/ethnic designation. This field is coded as follows: – Code 0 = Not reported – Code 1 = American Indian or Alaska Native, Not Hispanic – Code 2 = Asian, Not Hispanic – Code 3 = Pacific Islander, Not Hispanic – Code 4 = Filipino, Not Hispanic – Code 5 = Hispanic or Latino – Code 6 = African American, not Hispanic – Code 7 = White, not Hispanic – Code 9 = Two or More Races, Not Hispanic (See Glossary for complete definitions of the ethnic groups.)
genderstringGender. This field is a coded as follows: – M = Male – F = Female
kdgnintegerStudents enrolled in kindergarten.
gr_1integerStudents enrolled in grade one.
gr_2integerStudents enrolled in grade two.
gr_3integerStudents enrolled in grade three.
gr_4integerStudents enrolled in grade four.
gr_5integerStudents enrolled in grade five.
gr_6integerStudents enrolled in grade six.
gr_7integerStudents enrolled in grade seven.
gr_8integerStudents enrolled in grade eight.
ungr_elmintegerStudents enrolled in ungraded elementary classes in grades kindergarten through grade eight.
gr_9integerStudents enrolled in grade nine.
gr_10integerStudents enrolled in grade ten.
gr_11integerStudents enrolled in grade eleven.
gr_12integerStudents enrolled in grade twelve.
ungr_secintegerStudents enrolled in ungraded secondary classes in grades nine through twelve.
enr_totalintegerTotal school enrollment for fields Kindergarten (KDGN) through grade twelve (GR_12) plus ungraded elementary (UNGR_ELM) and ungraded secondary classes (UNGR_SEC). Adults in kindergarten through grade twelve programs are not included.
adultintegerAdults enrolled in kindergarten through grade twelve programs. This data does not include adults in independent study.

race_eth_07_18

Column NameData TypeDescription
cdscodeinteger14 digit CDS code, which uniquely identifies schools
yearintegerYear of enrollment data
nanumberRace/Ethnicity not known.
aiannumberAmerican Indian or Alaska Native, Not Hispanic
asiannumberAsian, Not Hispanic
pinumberPacific Islander, Not Hispanic
filipinonumberFilipino, Not Hispanic
hispnumberHispanic or Latino
blacknumberAfrican American, not Hispanic
nh_whitenumberWhite, not Hispanic
unknumberUnknown code 8;Code 8 is “Multiple or No Response” in the 1998-2006 file structure, but is not defined for the post 2006 file structure.
two_morenumberTwo or More Races, Not Hispanic
totalnumberSum of all other columns

References

Urls used in the creation of this data package.

Last Modified 2019-08-13T18:00:29

Packages

Accessing Packages in Metapack

import metapack as mp
pkg = mp.open_package('http://library.metatab.org/cde.ca.gov-enrollment-1.zip')

# Create Dataframes

enrollment_07_18_df = pkg.resource('enrollment_07_18').dataframe()
race_eth_07_18_df = pkg.resource('race_eth_07_18').dataframe()