Public Schools and Districts Data FilesDownloadable files containing general information about California's public schools and districts.
Attention: The California Department of Education (CDE) needs your feedback! In an effort to improve the data and data usage quality regarding the identification of school types, the CDE asks that you provide feedback on your usage of the School Ownership Code (SOC), School Ownership Short Description, and School Type (SOCType) elements in the County-District School (CDS) database, the downloadable public schools file, and the California School Directory by completing the School Ownership Code Feedback Survey.
For users' convenience, the public schools and districts data files are posted in Excel and tab delimited text formats. These data files are updated daily; therefore, the indicated file sizes are approximate, as the files may change from day to day:
- Public Schools and Districts (XLS; 11MB) | TXT (7MB) (Updated 5:00 A.M. Daily)
Contains all active, pending, closed, and merged public schools and districts.
- Public Districts (XLS) | TXT (Updated 5:00 A.M. Daily)
Contains all active and pending districts and county offices of education.
For details on what information are contained in each file, please refer to the corresponding file structure below.
For details on modifications made to these files and to the file structures, refer to the Changes to the Public Schools File Web page.
- File Structure: Public Schools and Districts (Revised 08-Aug-2016)
Descriptions of the elements in the downloadable public schools and districts files.
- File Structure: Public Districts (Posted 28-Mar-2016)
Descriptions of the elements in the downloadable public districts files.
- Schools and Districts Data Filtering Instructions (Revised 28-Mar-2016)
- Importing Data Files into Access and Excel (Revised 28-Mar-2016)
Instructions for importing the Public Schools and Districts text data file into Microsoft Access and Excel.
Below are links to additional data that were previously included in the Public Schools Database. Because these data are not updated as regularly as CDS data are updated, the CDE no longer includes these data in the Public Schools Database.
Locale codes may be obtained from the National Center for Education Statistics (NCES) on the NCES Public Elementary/Secondary School Universe Survey Data Web page. To learn more about locale codes, visit the NCES Identification of Rural Locales Web page.
Legislative districts for California public school districts (XLS; 01-Jul-2016)
This document is alphabetized by local educational agency and includes both summary and detail sections. The detail report includes the name of the current elected official, their party affiliation, and the percentage of the total school district area that is distributed among each intersecting legislative district. This list is updated every two years, when the school district boundaries are updated.
Additional information may be obtained from the California State Legislative Districts Web page. Note that the California legislative district boundaries are redrawn every ten years. Congressional district maps are available from the California Citizens Redistricting Commission.
Would you like to stay up-to-date on changes being made to the CDS data, Public Schools Database, or California School Directory? Join the CDS Users listserv today!
- To subscribe to the CDS Users listserv:
Send a "blank" e-mail message to email@example.com.
- To unsubscribe from the CDS Users listserv:
Send a "blank" e-mail message to firstname.lastname@example.org.