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: Analysis Measurement & Accountability Reporting Division | dro@cde.ca.gov

Last Reviewed: Friday, October 25, 2024

Trending in Accessing Educational Data

Recently Posted in Accessing Educational Data

DataQuest Update, Issue #24 (added 17-Jul-2025)
DataQuest is an online data reporting resource that provides access to a wide variety of data reports and downloadable data files.
Information about the Staff Experience Data (added 17-Jul-2025)
Overview of the Staff Experience data, including data sources, DataQuest reports, downloadable files, definitions, and other information helpful to understanding the data, reports, and downloadable files.
Information about the Staff Race/Ethnicity Data (added 17-Jul-2025)
Overview of the Staff Race/Ethnicity data, including data sources, DataQuest reports, downloadable files, definitions, and other information helpful to understanding the data, reports, and downloadable files.
Student/Staff Ratios Downloadable Data Files (added 17-Jul-2025)
Downloadable data files about student/staff ratios as of Census Day disaggregated by staff type, academic year, and school grade span.
Staff Experience Downloadable Data Files (added 17-Jul-2025)
Downloadable data files about certificated staff employed on Census Day disaggregated by years of experience, academic year, staff type, school grade span, and gender.

File Structure: Staff Race/Ethnicity Data (added 17-Jul-2025)
File structure for downloadable data files containing Certificated Staff by Race/Ethnicity disaggregated by academic year, staff type, school grade span, and gender.
File Structure: Staff Experience Data (added 17-Jul-2025)
File structure for downloadable data files containing Certificated Staff Experience disaggregated by academic year, staff type, school grade span, and gender.
File Structure: Staff Education Data (added 17-Jul-2025)
File structure for downloadable data files containing Certificated Staff Education disaggregated by academic year, staff type, school grade span, and gender.
Staff Counts by Experience (added 17-Jul-2025)
Reports and data about certificated staff employed on Census Day disaggregated by years of experience, academic year, staff type, school grade span, and gender.
Staff Counts by Education (added 17-Jul-2025)
Reports and data about certificated staff employed on Census Day disaggregated by education level, academic year, staff type, school grade span, and gender.