Unduplicated Pupil Counts

Downloadable files for the Unduplicated Pupil Count (UPC) of free or reduced price meal (FRPM) eligibility, English learner (EL), and foster youth data from the California Longitudinal Pupil Achievement Data System (CALPADS).

cde.ca.gov-calpads_upc-1

Resources | Packages | Documentation| Contacts| Data Dictionary

Resources

  • upc_13_lea. Unduplicated pupil count, academic year 2013, LEA Level
  • upc_13_school. Unduplicated pupil count, academic year 2013, School Level
  • upc_14_lea. Unduplicated pupil count, academic year 2014, LEA Level
  • upc_14_school. Unduplicated pupil count, academic year 2014, School Level
  • upc_15_lea. Unduplicated pupil count, academic year 2015, LEA Level
  • upc_15_school. Unduplicated pupil count, academic year 2015, School Level
  • upc_16_lea. Unduplicated pupil count, academic year 2016, LEA Level
  • upc_16_school. Unduplicated pupil count, academic year 2016, School Level
  • upc_17_lea. Unduplicated pupil count, academic year 2017, LEA Level
  • upc_17_school. Unduplicated pupil count, academic year 2017, School Level
  • upc_combined_lea. Combined LEA files, 2014 on
  • upc_combined_school. Combined LEA files, 2014 on

Documentation

Unduplicated Pupil Counts are the counts of pupils that are in one or more categories of eligibility for free or reduced price meals (FRMP), an important part of the Local Control Funding Formula.

Contacts

Packages

Accessing Packages in Metapack

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

# Create Dataframes

upc_13_lea_df = pkg.resource('upc_13_lea').dataframe()
upc_13_school_df = pkg.resource('upc_13_school').dataframe()
upc_14_lea_df = pkg.resource('upc_14_lea').dataframe()
upc_14_school_df = pkg.resource('upc_14_school').dataframe()
upc_15_lea_df = pkg.resource('upc_15_lea').dataframe()
upc_15_school_df = pkg.resource('upc_15_school').dataframe()
upc_16_lea_df = pkg.resource('upc_16_lea').dataframe()
upc_16_school_df = pkg.resource('upc_16_school').dataframe()
upc_17_lea_df = pkg.resource('upc_17_lea').dataframe()
upc_17_school_df = pkg.resource('upc_17_school').dataframe()
upc_combined_lea_df = pkg.resource('upc_combined_lea').dataframe()
upc_combined_school_df = pkg.resource('upc_combined_school').dataframe()

Data Dictionary

upc_13 | upc_14 | upc_combined

upc_13

Column NameData TypeDescription
academic_yearstring
county_codeinteger
district_codeinteger
school_codeinteger
county_namestring
district_namestring
school_namestring
district_typestring
school_typestring
nslp_provision_2_or_3_school_y_nstring
charter_numberstring
charter_funding_typestring
low_gradestring
high_gradestring
enrollment_k_12integer
unduplicated_frpm_eligible_count_unadjustedinteger
english_learner_el_countinteger
cdss_foster_youth_countinteger
unduplicated_frpm_el_foster_count_unadjustedinteger
directly_certified_dec_feb_countinteger
unduplicated_frpm_el_foster_count_adjustedinteger
unduplicated_non_juvenile_hall_pupil_countinteger
unduplicated_juvenile_hall_pupil_countinteger
calpads_unduplicated_pupil_count_upcinteger
2013_14_calpads_fall_1_certification_status_y_nstring

upc_14

Column NameData TypeDescription
academic_yearstring
county_codeinteger
district_codeinteger
school_codeinteger
county_namestring
district_namestring
school_nametext
district_typestring
school_typestring
educational_option_typestring
nslp_provision_statusstring
charter_school_y_nstring
charter_numberstring
charter_funding_typestring
ircstring
low_gradestring
high_gradestring
total_enrollmentinteger
free_reduced_meal_programinteger
fosterinteger
homelessinteger
migrant_programinteger
direct_certificationinteger
unduplicated_frpm_eligible_countinteger
english_learner_elinteger
calpads_unduplicated_pupil_count_upcinteger
calpads_fall_1_certification_status_y_nstring

upc_combined

Column NameData TypeDescription
file_yearinteger
academic_yearstringThe academic year corresponding to the annual Census Day from which official enrollment counts are determined using data submitted as part of the annual Fall 1 submission to the California Longitudinal Pupil Achievement Data System (CALPADS) by local educational agencies (LEAs), which includes school districts, charter schools, and county offices of education. Census Day or Information Day is always the first Wednesday in October.
county_codeintegerA unique two-digit code corresponding to the county.
district_codeintegerA unique five-digit code corresponding to the district.
school_codeintegerA unique seven-digit code corresponding to the school.
county_namestringCounty Name
district_namestringDistrict or Administrative Authority Name
school_namestringSchool Name
district_typestringDistrict Ownership Type Description
school_typestringSchool Ownership Type Description
educational_option_typestringEducational Option Type Description
nslp_provision_statusstringThe values in this field indicate the school-level National School Lunch Program Provision Status for lunch and breakfast. Where no lunch or breakfast provision is specified, then the specified provision applies to both lunch and breakfast. Values are as follows: Community Eligibility Provision (CEP), Provision 1, Provision 2, Provision 3, Lunch Provision 1, Lunch Provision 2, Lunch Provision 3, Breakfast Provision 1, Breakfast Provision 2, Breakfast Provision 3, Multiple Provision Types, or N/A. This information is provided for informational purposes only. No special adjustments were made in the data for provision schools. For more information on NSLP provision status, please refer to the United States Department of Agriculture (USDA) School Meals Guidance and Resources Webpage.
charter_schoolstringA “Y” or “N” value indicating whether a school is a charter school in the current academic year.
charter_numberstringA four character value (any combination of numbers and letters) assigned to a charter school. A blank value indicates the school is not a charter school.
charter_funding_typestringThe values in this field indicate the charter school funding type. Values are as follows: Locally funded, Directly funded, Not in Charter School funding model, or Blank.
ircstringA “Y” or “N” value indicating whether a school is an independently reporting charter (IRC) school in the current academic year.
low_gradestringLowest grade offered
high_gradestringHighest grade offered
total_enrollmentintegerA total count of all K-12 students enrolled (primary or short-term) on Census Day. This count corresponds to the “Total Enrollment” count provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth – Count.
frmpintegerOf the Total Enrollment, a total count of students reported being eligible on Census Day for the National School Lunch Program (NSLP) based on Education Program records with an Education Program Membership Code 181 (Free) or 182 (Reduced). This count corresponds to the “Free & Reduced Meal Program 181/182” count provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth – Count.
fosterintegerOf the Total Enrollment, a total count of students identified through the weekly CALPADS Foster Matching process or matched by the LEA through the CALPADS online match process as being in Foster Students on Census Day. This count corresponds to the “Foster” count provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth – Count.
homelessintegerOf the Total Enrollment, a total count of students reported as being homeless on Census Day based on Education Program record with an Education Program Membership Code 191 (Homeless). This count corresponds to the “Homeless” count provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth – Count.
migrant_programintegerOf the Total Enrollment, a total count of students eligible for the Migrant Education Program on Census Day based on and Education Program record with an Education Program Membership Code 135 (Migrant). This count corresponds to the “Migrant Program: 135” count provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth – Count.
direct_certificationintegerOf the Total Enrollment, a total count of students identified as being “directly certified” through CALPADS as participating in California’s food stamp or CalWORKs programs during July – November and who are therefore eligible for free meals. This count corresponds to the “Direct Certification” count provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth – Count.
frpm_eligibleintegerOf the Total Enrollment, a total unduplicated count of students who meet household income or categorical eligibility criteria for free or reduced price meals (FRPM) based on applying for the National School Lunch Program (NSLP); submitting alternative household income forms; their foster, homeless, or migrant statuses in CALPADS; or being “directly certified” through CALPADS as participating in California’s food stamp or CalWORKs programs during July – November. This count corresponds to the “Unduplicated Eligible Free/Reduced Meal Counts” provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth – Count. This count does NOT represent the “official” FRPM eligible count because early TK children have been removed (Kindergarten students who turn five years old after December 2).
english_learnerlintegerOf the Total Enrollment, a count of students identified in CALPADS as English learners (EL) on Census Day. This count corresponds to the “EL Funding Eligible” count provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth – Count.
unduplicated_pupilsintegerOf the Total Enrollment, an unduplicated count of students who are FRPM eligible (including foster youth students) or EL eligible. This count corresponds to the “Total Unduplicated FRPM/EL Eligible Count” provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth – Count.
certification_statusstringA “Y” or “N” value indicating whether data were submitted and certified in CALPADS. No data are provided where the certification status is “N”.

Last Modified 2019-07-23T05:41:03

Packages

Accessing Packages in Metapack

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

# Create Dataframes

upc_13_lea_df = pkg.resource('upc_13_lea').dataframe()
upc_13_school_df = pkg.resource('upc_13_school').dataframe()
upc_14_lea_df = pkg.resource('upc_14_lea').dataframe()
upc_14_school_df = pkg.resource('upc_14_school').dataframe()
upc_15_lea_df = pkg.resource('upc_15_lea').dataframe()
upc_15_school_df = pkg.resource('upc_15_school').dataframe()
upc_16_lea_df = pkg.resource('upc_16_lea').dataframe()
upc_16_school_df = pkg.resource('upc_16_school').dataframe()
upc_17_lea_df = pkg.resource('upc_17_lea').dataframe()
upc_17_school_df = pkg.resource('upc_17_school').dataframe()
upc_combined_lea_df = pkg.resource('upc_combined_lea').dataframe()
upc_combined_school_df = pkg.resource('upc_combined_school').dataframe()