File Structure: Transitional Kindergarten Data

File structure for the downloadable data files for school-level Transitional Kindergarten participation data disaggregated by race/ethnicity, gender, and student group.

Note: Pursuant to Education Code Section 60900(a)(4)(A), beginning in 2023–24, the CDE began collecting TK as a separate grade in CALPADS, rather than as a program participation record which has now been retired. Moving forward, information about TK students is available in the Census Day Enrollment Data file.

File Name: TKDATAyy.txt

Files include state, county, district, and school level data.

Field Name	Type Field	Width	Description
Year	Character	7	Academic year
CDS Code	Character	14	This 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.
Name	Character	50	School, District, or County name
Reporting Level	Character	10	Level of aggregation – State, County, District or School
Subgroup	Character	3	Subgroup designation. This field is coded as follows: ALL = Total for all subgroups EL = English learners MIG = Migrant SD = Socioeconomically Disadvantaged
Race	Character	3	Racial/ethnic designation. This field is coded as follows: ALL = Total for all races. 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
Gender	Character	3	Gender. This field is a coded as follows: ALL = Total of all genders M = Male F = Female X = Nonbinary (Beginning in 2019–20)
Total Kindergarten Enrollment (Census Day)	Numeric	7	The official number of students enrolled in kindergarten on Census Day, the first Wednesday in October, as reported through the California Longitudinal Pupil Achievement Data System (CALPADS).
Kindergarten TK Program Participation (Census Day)	Numeric	7	The total number of students enrolled in kindergarten who were participating in the Transitional Kindergarten (TK) program on Census Day.
Kindergarten TK Program Participation (Cumulative)	Numeric	7	The total number of students enrolled in kindergarten who participated in the Transitional Kindergarten (TK) program at any point during the academic year.

Questions: Data Reporting Office | dro@cde.ca.gov | 916-327-0219

Last Reviewed: Thursday, May 16, 2024

Trending in Accessing Educational Data

Recently Posted in Accessing Educational Data

DataQuest Schedule (added 20-Jun-2024)
An overview of the DataQuest reports expected to be released in the coming year.
DataQuest Update, Issue #20 (added 17-May-2024)
DataQuest is an online data reporting resource that provides access to a wide variety of data reports and downloadable data files.
File Structure: CBEDS by Race/Ethnic & Gender 2023 (added 16-May-2024)
File structure for CBEDS data by race/ethnicity, gender, and school for 2023-24. Data include classified staff and home-to-school transportation data.
File Structure: CBEDS Data About Schools/Districts (added 16-May-2024)
File structure for California Basic Educational Data System (CBEDS) data about schools and districts for 2023.
File Structure: Census Day Enrollment Data (added 16-May-2024)
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.