File Structure: Census Day Enrollment Data
File structure for downloadable files containing Census Day TK/Kâ12 enrollment data from the California Longitudinal Pupil Achievement Data System (CALPADS) disaggregated by grade, race/ethnicity, gender, and other student details.These files include state, county, district, and school-level data. Please refer to the file structure for details on which data are contained in the file. These files also contain aggregate data with disaggregated data subsets at different levels and reporting categories to provide enhanced analytical flexibility. For more detailed examples about how to properly use these data, please refer to the Using the Census Day Enrollment Data File examples below.
Note: To protect student privacy, data may be suppressed (*) on the CDEnroll downloadable files based on a combination of factors, including but not limited to the cell sizes at the school-level and within selected student populations that are 10 or fewer, not including race/ethnicity or age range. Data are not included for districts and independently reporting charter schools (IRCs) that did not certify their annual Fall 1 data submission in the California Longitudinal Pupil Achievement Data System (CALPADS).
General Description of the Census Day Enrollment Data File
Field Name | Description |
---|---|
Academic Year |
The academic year corresponding to the 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 include school districts, charter schools, and county offices of education. Census Day or Information Day is the first Wednesday in October. |
Aggregate Level | An indicator of the aggregation level.
Note: One of these values must be chosen to obtain a count at the selected level. |
County Code | A unique two-digit code corresponding to the county. |
District Code | A unique five-digit code corresponding to the district. |
School Code |
A unique seven-digit code corresponding to the school. |
County Name |
County Name. |
District Name |
District or Administrative Authority Name. |
School Name |
School Name. |
Charter (All/Y/N) |
An indicator of the School Type (Charter/Non-Charter) aggregation level.
Note: One of these values must be chosen to obtain a count at the selected level. |
Reporting Category |
An indicator of the student group reporting category disaggregation or subset. Age Range:
English Language Acquisition Status (ELAS):
Gender:
Race/Ethnicity:
Student Group:
Total Count:
Note: Select Reporting Category = TA for aggregate totals without consideration of a Reporting Category student group. |
TOTAL_ENR | Total TK/K–12 enrollment count of students enrolled on Census Day for the selected Aggregate Level and Reporting Category. Census Day enrollment, the official annual enrollment count, is a single-day snapshot of the total number of students enrolled on Census Day, the first Wednesday in October, who have primary and short-term enrollments. Census Day enrollment counts are calculated at each reporting level (e.g., state, county, district, and school) and are considered distinct, unduplicated counts that are additive from one reporting level to the next. |
GR_TK | Count of students enrolled in Transitional Kindergarten (Beginning 2023–24). Beginning in academic year 2023–24, Transitional Kindergarten is collected as a separate grade level in CALPADS, pursuant to Education Code Section 60900(a)(4)(A), for age-eligible students, as defined in Education Code Section 48000(c)(1), who are enrolled in Kindergarten and who are participating in the Transitional Kindergarten program, which is authorized and defined in Education Code Section 48000, pursuant to Education Code Section 48000(d). |
GR_KN | Count of students enrolled in Kindergarten. Kindergarten is a grade level for age-eligible students, as defined in Education Code Section 48000(a), who are enrolled in Kindergarten and who are not participating in the Transitional Kindergarten program, which is authorized and defined in Education Code Section 48000. |
GR_01 |
Count of students enrolled in Grade 1. |
GR_02 | Count of students enrolled in Grade 2. |
GR_03 | Count of students enrolled in Grade 3. |
GR_04 | Count of students enrolled in Grade 4. |
GR_05 | Count of students enrolled in Grade 5. |
GR_06 | Count of students enrolled in Grade 6. |
GR_07 | Count of students enrolled in Grade 7. |
GR_08 | Count of students enrolled in Grade 8. |
GR_09 | Count of students enrolled in Grade 9. |
GR_10 | Count of students enrolled in Grade 10. |
GR_11 | Count of students enrolled in Grade 11. |
GR_12 |
Count of students enrolled in Grade 12. |
General Description of the Data File
The Census Day TK/K–12 enrollment data are submitted by local educational agencies (LEAs) and charter schools to the California Department of Education (CDE) as part of the annual Fall 1 data submission in the CALPADS. Data are reviewed and certified in CALPADS as being accurate by authorized district or school personnel. In order to certify data in CALPADS, authorized district or charter school personnel are required to review the accuracy of all data associated with the applicable CALPADS submission. The data certification must be performed by district superintendents, charter school administrators, or their designees. Please contact the district or school if you have any questions about their certified CALPADS data.
Source: Census Day Enrollment data are submitted and certified by LEAs and/or charter schools as part of the annual CALPADS Fall 1 submission..
Using the Census Day Enrollment Data File
This file contains different subsets of data based on the values of different variables. If these sub-setting variables are not used properly, it is easy to end up with incorrect or duplicative data. Please refer to the following examples below as a guide for properly using these data:
- Get school-level data totals with one record per school (without student group totals)
- Aggregate Level = S (School)
- Reporting Category = TA
- Get school-level data totals by student group (Reporting Category) for all non-charter schoolss
- Aggregate Level = S (School)
- Charter (All/Y/N) = N
- Reporting Category Not equal to TA
- Get school-level data totals of non-traditional adult students enrolled in K-12 grades by age range:
- Aggregate Level = S (School)
- Reporting Category = AR_2329, AR_3039, AR_4049, and AR_50P
Note: The Charter (All/Y/N) column will provide the charter school status (Y/N) of the corresponding schools with data.
- Get district-level data totals with one record per district (without student group totals):
- Aggregate Level = D (District)
- Charter (All/Y/N) = All
- Reporting Category = TA
- Get district-level data totals by student group (Reporting Category) for charter schools:
- Aggregate Level = D (District)
- Charter School (All/Y/N) = Y
- Reporting Category Not equal to TA
- Get district-level data totals of non-traditional adult students enrolled in K-12 grades by age range:
- Aggregate Level = D (District)
- Reporting Category = AR_2329, AR_3039, AR_4049, and AR_50P
Note: The Charter (All/Y/N) column will provide information about the schools within corresponding districts with data.
- Get statewide-level data totals for non-charter schools (without student group totals):
- Aggregate Level = T (State)
- Charter School (All/Y/N) = N
- Reporting Category = TA
- Get statewide-level data totals of non-traditional adult students enrolled in K-12 grades by age range:
- Aggregate Level = T (State)
- Reporting Category = AR_2329, AR_3039, AR_4049, and AR_50P
Note: The Charter (All/Y/N) column will provide information about the schools within the state with data.