Skip to main content
California Department of Education Logo

School & District Data Filtering Instructions

Instructions for filtering data in the public schools and districts data file.

The California Department of Education (CDE) posts public school and district data on the Public Schools and Districts Data Files web page. The public schools and districts file includes both district and school-level records that are active, pending, closed, and merged. To fully understand, retrieve, and organize the data contained in this file, we have provided some basic filtering instructions below. We also highly recommend that you review the File Structure: Public Schools and Districts web page for details and descriptions of the data contained in the file.

Microsoft Excel 2019 was used to create the following instructions.

Creating Filters in Microsoft Excel Worksheets

To create a filter on worksheet columns:

  1. Place the active cell within the data set
  2. Select the DATA tab located in the Ribbon
  3. Within the Sort & Filter group, select Filter
  4. Select the down arrow in the desired column header to display a list in which you can make filter choices

Additional information about creating filters in a Microsoft Excel worksheet can be found on the Quick start: Filter data by using an AutoFilterExternal link opens in new window or tab. Microsoft web page.

Please note that filters are already applied to the public schools and districts downloadable data file that is available on the CDE website.

Filtering District-Level Data in Microsoft Excel Worksheets

To retrieve only active or soon-to-be active (pending) district-level records, you will need to filter for:

  • StatusType = Active or Pending
  • SOC = No Data
  • DOC = 00, 02, 03, 52, 54, 56

District-level records have only one superintendent. The superintendent information will be found under the following fields in the district-level records:

  • AdmFName, AdmLName, AdmEmail

Filtering School-Level Data in Microsoft Excel Worksheets

To retrieve only “traditional K–12" active or soon-to-be active (pending) school-level records, you will need to filter for:

  • StatusType = Active or Pending
  • SOC = 60, 61, 62, 64, 65, 66, 67

If you wish to obtain a list of schools other than “traditional K–12” schools, refer to the File Structure: Public Schools and Districts web page for additional School Ownership Code (SOC) values and their definitions.

Additional questions regarding the public schools and districts data should be sent to CDSAdmin@cde.ca.gov.

Questions:   CDS Administration | cdsadmin@cde.ca.gov | 916-327-4014
Last Reviewed: Friday, July 3, 2020
Recently Posted in School & District Information
  • 2020–21 District Reorganizations & Charter Changes (added 06-Jul-2020)
    Contains information on local educational agency (LEA) reorganizations, territory transfers, lapses, and name changes, as well as information on charter school restructuring and changes in authorizers for the 2020–21 school year.