Skip to main content
California Department of Education Logo

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
Recently Posted in Accessing Educational Data
  • 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.
  • Single-Month Reports (added 09-Apr-2024)
    The page displays California State Preschool Program (CSPP) Enrollment by Program Length, Statutory Age, Agency Classification, and Race/Ethnicity.

  • CSPP Enrollment by Provider County Reports (added 09-Apr-2024)
    The page provides links to annual October California State Preschool Program (CSPP) enrollment reports by provider county for 2020−22 in XLSX format.
  • Annual Aggregate Reports (added 09-Apr-2024)
    The page displays the annual California State Preschool Program enrollment data by Statutory Age and Program Length for fiscal years 2020−23, providing an unduplicated count of children served by the California Department of Education (CDE).
  • Two-Month Average Data Reports (added 09-Apr-2024)
    The page displays two-month average Early Education Division (EED) enrollment data for children by Program Length and Statutory Age for October/April in 2020−23.