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 page for details and descriptions of the data contained in the file.

Creating Filters in Microsoft Excel Worksheets

To create a filter on the worksheet columns:

  1. Select the “Data” tab in the toolbar
  2. Within the "Sort & Filter" group, click “Filter”
  3. Click on the 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 AutoFilter External link opens in new window or tab. Microsoft Web page.

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 = Blank
  • 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:

  • AdmFName1, AdmLName1, AdmEmail1

Filtering School-Level Data in Microsoft Excel Worksheets

To retrieve only “traditional” 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

Schools can have between 1 and 3 principals. The principal information will be found under the following fields in the school-level records:

  • AdmFName1, AdmLName1, AdmEmail1
  • AdmFName2, AdmLName2, AdmEmail2
  • AdmFName3, AdmLName3, AdmEmail3

If you wish to contact schools other than “traditional K-12” schools, refer to the File Structure: Public Schools and Districts for additional “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: Monday, April 11, 2016