Reimbursement Rates

by metapack

Child Nutrition Program meal program reimbursement rates.

cde.ca.gov-reimbursements-1.1.1. Modified 2021-03-11T00:14:44

Resources

Documentation

Reimbursement rates that were manually scraped from CDE web pages, then combined into this data package.

Contacts

  • Wrangler

Eric Busboom, Civic Knowledge

Continue Reading →

CAASPP Test Results

by metapack

California Assessment of Student Performance and Progress

cde.ca.gov-caaspp-2015e-2.1.1. Modified 2022-08-09T20:25:49

Resources

Documentation

This dataset is a simple combination of multiple years of California Assessment of Student Performance and Progress (CAASPP) results, for the years 2015 on. The CAASPP was conducted in 2014, but the 2014 file has a different structure from other years ( it’s a “pp” file, see below) so it is excluded from this package.

Continue Reading →

Student Poverty FRPM Data

by metapack

Data files pertaining to students eligible for Free or Reduced Price Meals (FRPM).

cde.ca.gov-frpm-1.2.1. Modified 2021-03-11T00:51:02

Resources

Documentation

Contacts

  • Wrangler

Eric Busboom, Civic Knowledge

Data Dictionary

combined | frp_meals

combined

Column NameData TypeDescription
yearinteger
academic_yearstringThe academic year corresponding to the annual Census Day from which official enrollment counts are determined using data submitted to the California Longitudinal Pupil Achievement Data System (CALPADS) by districts and charter schools. Census Day or Information Day is always the first Wednesday in October.
county_codeintegerA unique two-digit code corresponding to the county.
county_namestring
district_codeintegerA unique five-digit code corresponding to the district.
district_namestringDistrict or Administrative Authority Name
district_typestring
school_codeintegerA unique seven-digit code corresponding to the school.
school_nametext
school_typestring
lea_namestringLocal educational agency (LEA) name.
charter_funding_typestringIndicates the charter school funding type. Values are as follows: Locally funded, Directly funded, Not in Charter School funding model, or Blank.
charter_school_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_school_y_nstringA “Y” or “N” value indicating whether a school is a charter school in the current academic year.
direct_funded_charter_school_numberstring
low_gradestring
high_gradestring
educational_option_typestring
ircstring
fund_typestring
nslp_provision_2_or_3_schoolstringA Y or N value to indicate whether a school is on a National School Lunch Program (NSLP) provision 2 or 3 status. “Y” indicates the school is on a provisional status; “N” indicates the school is not. For more information on provision status, please refer to the United States Department of Agriculture (USDA) Food Nutrition Service Web page External link opens in new window or tab..
nslp_provision_statusstring
provision_2_or_3_school_y_nstring
calpads_enrollmentintegerA total count of students ages 5-17 enrolled (primary or short-term) on Census Day (the first Wednesday in October). These data were submitted to CALPADS as part of the annual Fall 1 submission.
calpads_enrollment_k_12integer
enrollmentintegerA total count of students ages 5-17 enrolled (primary or short-term) on Census Day (the first Wednesday in October). These data were submitted to CALPADS as part of the annual Fall 1 submission.
enrollment_k_12integerA total count of K-12 students enrolled (primary or short-term) on Census Day (the first Wednesday in October). These data were submitted to CALPADS as part of the annual Fall 1 submission.
calpads_fall_1_certification_statusstringA Y or N value to indicate whether data were submitted and certified in CALPADS. No data are provided where the certification status is “N”.
free_meal_countstring
free_meal_count_k_12integerOf the Enrollment (K-12), a total unduplicated count of students who meet household income or categorical eligibility criteria for free meals based on one or more of the following reasons: (1) applying for the National School Lunch Program (NSLP); (2) submitting alternative household income forms; (3) student homeless or migrant statuses in CALPADS; (4) being “directly certified” through CALPADS as participating in California’s food stamp or CalWORKs programs during July - November; or (5) being identified through the weekly CALPADS Foster Matching process or matched by the LEA through the CALPADS online match process as being in Foster Placement or Foster Family Maintenance on Census day. The Free Meal Count (K-12) is not displayed on any CALPADS report; however, this count represents the official Free Meal Count (K-12) for the academic year.
frpm_countintegerOf the Enrollment (Ages 5-17), a total unduplicated count of students who meet household income or categorical eligibility criteria for free or reduced meals (FRPM) based on one or more of the following reasons: (1) applying for the National School Lunch Program (NSLP); (2) submitting alternative household income forms; (3) student homeless or migrant statuses in CALPADS; (4) being “directly certified” through CALPADS as participating in California’s food stamp or CalWORKs programs during July - November; or (5) being identified through the weekly CALPADS Foster Matching process or matched by the LEA through the CALPADS online match process as being in Foster Placement or Foster Family Maintenance on Census day. The FRPM Count (Ages 5-17) generally corresponds to the “Total Unduplicated Eligible Free/Reduced Meal Counts” provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth – Count with the 5-17 Year Olds filter applied; however, this count has been augmented to also included students identified as being in Foster Family Maintenance on Census Day, as these students have been determined to be categorically eligible for free meals. This adjustment was made outside of CALPADS and is not included in the “Total Unduplicated Eligible Free/Reduced Meal Counts” provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth – Count; however, this count represents the official FRPM Count (Ages 5-17) for the academic year.
frpm_count_k_12integerOf the Enrollment (K-12), a total unduplicated count of students who meet household income or categorical eligibility criteria for free or reduced meals (FRPM) based on one or more of the following reasons: (1) applying for the National School Lunch Program (NSLP); (2) submitting alternative household income forms; (3) student homeless or migrant statuses in CALPADS; (4) being “directly certified” through CALPADS as participating in California’s food stamp or CalWORKs programs during July - November; or (5) being identified through the weekly CALPADS Foster Matching process or matched by the LEA through the CALPADS online match process as being in Foster Placement or Foster Family Maintenance on Census day. The FRPM Count (K-12) generally corresponds to the “Total Unduplicated Eligible Free/Reduced Meal Counts” provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth – Count; however, this count has been augmented to also included students identified as being in Foster Family Maintenance on Census Day, as these students have been determined to be categorically eligible for free meals. This adjustment was made outside of CALPADS and is not included in the “Total Unduplicated Eligible Free/Reduced Meal Counts” provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth – Count; however, this count represents the official FRPM Count (K-12) for the academic year.
frpm_total_unduplicated_countstringOf the students (Ages 5–17) enrolled in the school, the total unduplicated count of students who are eligible to receive free or reduced price meals (FRPM). Students may be eligible for free meals based on applying for the National School Lunch Program (NSLP), or who are determined to meet the same income eligibility criteria as the NSLP, through their local schools, their homeless, migrant, or foster status, or participation in California’s food stamp program. There are no counts provided for Provision 2 and 3 schools because only percentages were collected for these schools; as a result, a value of “NULL” is displayed instead of counts of students eligible.
frpm_total_unduplicated_count_k_12stringOf the students (K–12) enrolled in the school, the total unduplicated count of who are eligible to receive free or reduced price meals (FRPM). Students may be eligible for free meals based on applying for the National School Lunch Program (NSLP), or who are determined to meet the same income eligibility criteria as the NSLP, through their local schools, their homeless, migrant, or foster status, or participation in California’s food stamp program. There are no counts provided for Provision 2 and 3 schools because only percentages were collected for these schools; as a result, a value of “NULL” is displayed instead of counts of students eligible.
percent_eligible_freenumberThe percent of students eligible for free meals. [Free Meal Count (Ages 5-17) divided by Enrollment (Ages 5-17)].
percent_eligible_free_k_12numberThe percent of students eligible for free meals. [Free Meal Count (K-12) divided by Enrollment (K-12)].
percent_eligible_frpmnumberThe percent of students eligible for free or reduced price meals (FRPM). [FRPM Count (Ages 5-17) divided by Enrollment (Ages 5-17)].
percent_eligible_frpm_k_12numberThe percent of students eligible for free or reduced price meals (FRPM). [FRPM Count (K-12) divided by Enrollment (K-12)].
percent_frpmnumber
reduced_price_mealsinteger
total_frpminteger
unadjusted_free_meal_countinteger
unadjusted_free_meal_count_k_12integer
unadjusted_frpm_countintegerOf the Enrollment (K-12) count, a total unduplicated count of students who are eligible to receive free meals. Students may be eligible for free meals based on applying for the National School Lunch Program (NSLP), or who are determined to meet the same income eligibility criteria as the NSLP through their local schools, or their homeless, migrant, or foster status in CALPADS, or those students “directly certified” as participating in California’s food stamp program during July - November 2013. This count corresponds to the “Free Meal Count” provided in the CALPADS certification report 5.1a: Free or Reduced Price Meal Eligibility – Count.
unadjusted_frpm_count_k_12integerOf the Enrollment (K-12) count, a total unduplicated count of students who are eligible to receive free or reduced price meals (FRPM). Students may be eligible for free or reduced price meals based on applying for the National School Lunch Program (NSLP), or who are determined to meet the same income eligibility criteria as the NSLP through their local schools, or their homeless, migrant, or foster status in CALPADS, or those students “directly certified” as participating in California’s food stamp program during July - November 2013. This count corresponds to the “Free & Reduced Meal Count” provided in the CALPADS certification report 5.1a: Free or Reduced Price Meal Eligibility - Count.
data_source_for_frpmstring
data_source_for_provision_2_or_3_schoolstringThis indicates the data source for Provision 2 or 3 school data. “NSD” indicates that the data are sourced from October 2012 claim data submitted to the CDE’s Nutrition Services Division (NSD); “CARS” indicates that the data are sourced from base percentages that LEAs certified in the Consolidated Application and Reporting System (CARS) in 2011–12. Since only percentages were collected for Provision 2 and 3 schools, a value of “NULL” is displayed instead of counts of students eligible for these schools.

frp_meals

Column NameData TypeDescription
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.
charter_school_numberintegerA 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_typestringIndicates the charter school funding type. Values are as follows: Locally funded, Directly funded, Not in Charter School funding model, or Blank.
lea_namestringLocal educational agency (LEA) name.
school_nametext
low_gradestring
high_gradeinteger
enrollmentintegerA total count of students ages 5-17 enrolled (primary or short-term) on Census Day (the first Wednesday in October). These data were submitted to CALPADS as part of the annual Fall 1 submission.
free_meal_countinteger
reduced_price_mealsinteger
total_frpminteger
percent_frpmnumber
county_namestring
data_source_for_frpmstring
academic_yearstringThe academic year corresponding to the annual Census Day from which official enrollment counts are determined using data submitted to the California Longitudinal Pupil Achievement Data System (CALPADS) by districts and charter schools. Census Day or Information Day is always the first Wednesday in October.
provision_2_or_3_school_y_nstring
data_source_for_provision_2_or_3_schoolstringThis indicates the data source for Provision 2 or 3 school data. “NSD” indicates that the data are sourced from October 2012 claim data submitted to the CDE’s Nutrition Services Division (NSD); “CARS” indicates that the data are sourced from base percentages that LEAs certified in the Consolidated Application and Reporting System (CARS) in 2011–12. Since only percentages were collected for Provision 2 and 3 schools, a value of “NULL” is displayed instead of counts of students eligible for these schools.
free_meal_count_k_12integerOf the Enrollment (K-12), a total unduplicated count of students who meet household income or categorical eligibility criteria for free meals based on one or more of the following reasons: (1) applying for the National School Lunch Program (NSLP); (2) submitting alternative household income forms; (3) student homeless or migrant statuses in CALPADS; (4) being “directly certified” through CALPADS as participating in California’s food stamp or CalWORKs programs during July - November; or (5) being identified through the weekly CALPADS Foster Matching process or matched by the LEA through the CALPADS online match process as being in Foster Placement or Foster Family Maintenance on Census day. The Free Meal Count (K-12) is not displayed on any CALPADS report; however, this count represents the official Free Meal Count (K-12) for the academic year.
percent_eligible_free_k_12numberThe percent of students eligible for free meals. [Free Meal Count (K-12) divided by Enrollment (K-12)].
frpm_total_unduplicated_count_k_12stringOf the students (K–12) enrolled in the school, the total unduplicated count of who are eligible to receive free or reduced price meals (FRPM). Students may be eligible for free meals based on applying for the National School Lunch Program (NSLP), or who are determined to meet the same income eligibility criteria as the NSLP, through their local schools, their homeless, migrant, or foster status, or participation in California’s food stamp program. There are no counts provided for Provision 2 and 3 schools because only percentages were collected for these schools; as a result, a value of “NULL” is displayed instead of counts of students eligible.
percent_eligible_frpm_k_12numberThe percent of students eligible for free or reduced price meals (FRPM). [FRPM Count (K-12) divided by Enrollment (K-12)].
calpads_enrollmentintegerA total count of students ages 5-17 enrolled (primary or short-term) on Census Day (the first Wednesday in October). These data were submitted to CALPADS as part of the annual Fall 1 submission.
percent_eligible_freenumberThe percent of students eligible for free meals. [Free Meal Count (Ages 5-17) divided by Enrollment (Ages 5-17)].
nslp_provision_2_or_3_schoolstringA Y or N value to indicate whether a school is on a National School Lunch Program (NSLP) provision 2 or 3 status. “Y” indicates the school is on a provisional status; “N” indicates the school is not. For more information on provision status, please refer to the United States Department of Agriculture (USDA) Food Nutrition Service Web page External link opens in new window or tab..
unadjusted_free_meal_count_k_12integer
unadjusted_frpm_count_k_12integerOf the Enrollment (K-12) count, a total unduplicated count of students who are eligible to receive free or reduced price meals (FRPM). Students may be eligible for free or reduced price meals based on applying for the National School Lunch Program (NSLP), or who are determined to meet the same income eligibility criteria as the NSLP through their local schools, or their homeless, migrant, or foster status in CALPADS, or those students “directly certified” as participating in California’s food stamp program during July - November 2013. This count corresponds to the “Free & Reduced Meal Count” provided in the CALPADS certification report 5.1a: Free or Reduced Price Meal Eligibility - Count.
frpm_count_k_12integerOf the Enrollment (K-12), a total unduplicated count of students who meet household income or categorical eligibility criteria for free or reduced meals (FRPM) based on one or more of the following reasons: (1) applying for the National School Lunch Program (NSLP); (2) submitting alternative household income forms; (3) student homeless or migrant statuses in CALPADS; (4) being “directly certified” through CALPADS as participating in California’s food stamp or CalWORKs programs during July - November; or (5) being identified through the weekly CALPADS Foster Matching process or matched by the LEA through the CALPADS online match process as being in Foster Placement or Foster Family Maintenance on Census day. The FRPM Count (K-12) generally corresponds to the “Total Unduplicated Eligible Free/Reduced Meal Counts” provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth – Count; however, this count has been augmented to also included students identified as being in Foster Family Maintenance on Census Day, as these students have been determined to be categorically eligible for free meals. This adjustment was made outside of CALPADS and is not included in the “Total Unduplicated Eligible Free/Reduced Meal Counts” provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth – Count; however, this count represents the official FRPM Count (K-12) for the academic year.
unadjusted_free_meal_countinteger
unadjusted_frpm_countintegerOf the Enrollment (K-12) count, a total unduplicated count of students who are eligible to receive free meals. Students may be eligible for free meals based on applying for the National School Lunch Program (NSLP), or who are determined to meet the same income eligibility criteria as the NSLP through their local schools, or their homeless, migrant, or foster status in CALPADS, or those students “directly certified” as participating in California’s food stamp program during July - November 2013. This count corresponds to the “Free Meal Count” provided in the CALPADS certification report 5.1a: Free or Reduced Price Meal Eligibility – Count.
frpm_countintegerOf the Enrollment (Ages 5-17), a total unduplicated count of students who meet household income or categorical eligibility criteria for free or reduced meals (FRPM) based on one or more of the following reasons: (1) applying for the National School Lunch Program (NSLP); (2) submitting alternative household income forms; (3) student homeless or migrant statuses in CALPADS; (4) being “directly certified” through CALPADS as participating in California’s food stamp or CalWORKs programs during July - November; or (5) being identified through the weekly CALPADS Foster Matching process or matched by the LEA through the CALPADS online match process as being in Foster Placement or Foster Family Maintenance on Census day. The FRPM Count (Ages 5-17) generally corresponds to the “Total Unduplicated Eligible Free/Reduced Meal Counts” provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth – Count with the 5-17 Year Olds filter applied; however, this count has been augmented to also included students identified as being in Foster Family Maintenance on Census Day, as these students have been determined to be categorically eligible for free meals. This adjustment was made outside of CALPADS and is not included in the “Total Unduplicated Eligible Free/Reduced Meal Counts” provided in CALPADS certification report 1.17: FRPM/English Learner/Foster Youth – Count; however, this count represents the official FRPM Count (Ages 5-17) for the academic year.
calpads_fall_1_certification_statusstringA Y or N value to indicate whether data were submitted and certified in CALPADS. No data are provided where the certification status is “N”.
district_typestring
school_typestring
educational_option_typestring
nslp_provision_statusstring
charter_school_y_nstringA “Y” or “N” value indicating whether a school is a charter school in the current academic year.
ircstring

References

Urls used in the creation of this data package.

Continue Reading →

Unduplicated Pupil Counts

by metapack

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.1.1. Modified 2021-03-11T00:51:50

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.

Continue Reading →

Current Expense of Education

by metapack

Calculation of current expense (cost) of education per average daily attendance (ADA) pursuant to Education Code Section 41372.

cde.ca.gov-current_expense-1.2.2. Modified 2022-08-09T16:57:45

Resources

Documentation

Calculation of current expense (cost) of education per average daily attendance.

Continue Reading →

Chronic Absenteeism

by metapack

Student absenteeism data by ethnicity, gender, program subgroup, and grade span. Chronic absenteeism counts, cumulative enrollment, and chronic absenteeism rate data are provided.

cde.ca.gov-absenteeism-2

Resources

Documentation

Contacts

  • Wrangler

Eric Busboom, Civic Knowledge

Packages

Accessing Packages in Metapack

import metapack as mp
# ZIP Package
pkg = mp.open_package('https://library-metatab-org.s3.amazonaws.com/cde.ca.gov-absenteeism-2.zip')
# CSV Package
pkg = mp.open_package('https://library-metatab-org.s3.amazonaws.com/cde.ca.gov-absenteeism-2.csv') 

resource = pkg.resource('resource_name') # Get a resource
df = resource.dataframe() # Create a pandas Dataframe
gdf = resource.geoframe() # Create a GeoPandas GeoDataFrame

Data Dictionary

chab17 | chab16 | chronic_absenteeism

Continue Reading →