Skip to content
Printer-friendly version

Public School Data Filtering Instructions

Instructions on public school data filtering.

The California Department of Education (CDE) posts public school data on its Public Schools Database Web page. This data set includes both district and school-level records that are active, pending, closed, and merged. Please carefully review the file structure to fully understand, retrieve, and organize the available data.

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 this Microsoft Web page:
Quick start: Filter data by using an AutoFilter. External link opens in new window or tab.

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:

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

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:

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

If you wish to contact other than “traditional K-12” schools, refer to the File Structure: Public Schools Database for additional “SOC” values and their definitions.

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

Data Available on CD

Some California public school information is available in CD format and may be purchased through the CDE Press Office. Visit the California Public School Directory CD-ROM Products Web page for further information.

You may also contact the CDE Press by calling 800-995-4099 or by e-mail at sales@cde.ca.gov.

Private School Data

Information related to private schools in California is posted on the Private Schools Web page. The private school data are provided in Microsoft Excel format.

 

Questions:   CDS Administration | cdsadmin@cde.ca.gov | 916-327-4014
Download Free Readers