File Structure: Public Schools and Districts
Definitions for all the elements included in the downloadable public schools and districts files.Return to the Public Schools and Districts Data Files web page.
Field Name | Field Type | Width | Description |
---|---|---|---|
CDSCode
|
Character | 14 | County-District-School Code (CDSCode): 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. Please note that a CDS code ending in '0000000' indicates a district record not a school. |
NCESDist
|
Character | 7 | This field represents the 7-digit National Center for Educational Statistics school district (NCESDist) identification number. The first 2 digits identify the state and the last 5 digits identify the school district. Combined, they make a unique 7-digit ID for each school district. |
NCESSchool
|
Character | 5 | This field represents the 5-digit National Center for Educational Statistics school (NCESSchool) identification number. The NCESSchool combined with the NCESDist form a unique 12-digit ID for each school. |
StatusType
|
Character | 50 | This field identifies the status of the district. Definitions of the valid status types are listed below:
|
County
|
Character | 15 | County name. |
District
|
Character | 90 | District or Administrative Authority name. |
School
|
Character | 90 | School name. |
Street
|
Character | 211 | The unabbreviated street (physical) address of this school, district, or administrative authority. Note: Some entities (primarily closed or retired schools) may not have data in this field. |
StreetAbr
|
Character | 201 | The abbreviated street address of the school, district, or administrative authority’s physical location. Note: Some records (primarily records of closed or retired schools) may not have data in this field. |
City
|
Character | 25 | The city where the school, district, or administrative authority is physically located. Note: Some records (primarily records of closed or retired schools) may not have data in this field. |
Zip
|
Character | 10 | The zip code associated with the street address of the school, district, or administrative authority’s physical location. Note: Some records (primarily records of closed or retired schools) may not have data in this field. |
State
|
Character | 2 | The state in which the school, district, or administrative authority is located. |
MailStreet
|
Character | 211 | The unabbreviated mailing address of the school, district, or administrative authority (i.e., P.O. Box). Note: 1) Some entities (primarily closed or retired schools) may not have data in this field; 2) Many active entities have not provided a mailing street address. For your convenience we have filled the unpopulated MailStreet cells with Street data. |
MailStrAbr |
Character | 201 | The abbreviated mailing street address of the school, district, or administrative authority (i.e., P.O. Box).Note: Many active entities have not provided a mailing street address. For your convenience we have filled the unpopulated MailStrAbr cells with StreetAbr data. |
MailCity |
Character | 25 | The city associated with the mailing address of the school, district, or administrative authority. Note: Many entities have not provided a mailing address city. For your convenience we have filled the unpopulated MailCity cells with City data. |
MailZip |
Character | 10 | The zip code associated with the mailing address of the school, district, or administrative authority. Note: Many entities have not provided a mailing address zip code. For your convenience we have filled the unpopulated MailZip cells with Zip data. |
MailState |
Character | 2 | The state within the mailing address. For your convenience we have filled the unpopulated MailState cells with State data. |
Phone |
Character | 14 | The area code and phone number of the school, district, or administrative authority. |
Phone Ext |
Character | 6 | The phone number extension of the school, district, or administrative authority. |
FaxNumber | Character | 14 | The fax number of the school, district, or administrative authority. |
Website |
Character | 100 | The website address of the school, district, or administrative authority. |
OpenDate |
Date | 10 | The date the school opened. |
ClosedDate |
Date | 10 | The date the school closed. |
Charter |
Character | 1 | This field identifies a charter school. The field is coded as follows:
|
CharterNum |
Character | 4 | The charter school number, which is a 4-digit number assigned to a charter school. |
FundingType |
Character | 25 | Indicates the charter school funding type. Values are as follows:
|
DOC |
Character | 2 | The District Ownership Code (DOC) is the numeric code used to identify the category of the Administrative Authority.
*Only the California Education Authority has been included in the non-school location category. |
DOCType |
Character | 50 | The District Ownership Code Type (DOCType) is the text description of the DOC category. (See text values in DOC field description above) |
SOC |
Character | 2 | The School Ownership Code (SOC) is a numeric code used to identify the type of school.
|
SOCType |
Character | 50 | The School Ownership Code Type (SOCType) is the text description of the type of school. (See text values in SOC field description above) |
EdOpsCode |
Character | 20 | The Education Option Code (EdOpsCode) is a short text description of the type of education offered.
|
EdOpsName |
Character | 100 | The Educational Option Name (EdOpsName) is the long text description of the type of education being offered. (See text values in EdOPsCode field description above) |
EILCode |
Character | 50 | The Educational Instruction Level Code (EILCode) is a short text description of the institution's type relative to the grade range served.
|
EILName |
Character | 50 | The Educational Instruction Level Name (EILName) is the long text description of the institution’s type relative to the grade range served. (See text values in EILCode field description above) |
GSoffered |
Character | 101 | The Grade Span offered (GSoffered) is the lowest grade and the highest grade offered or supported by the school, district, or administrative authority. This field might differ from the grade span served as reported in the most recent certified California Longitudinal Pupil Achievement (CALPADS) Fall 1 data collection. For example XYZ School might display the following data: GSoffered = P–Adult GSserved = K–12 |
GSserved |
Character | 101 | This field represents the Grade Span Served (GSserved). It is the lowest grade and the highest grade of student enrollment as reported in the most recent certified CALPADS Fall 1 data collection. Only K–12 enrollment is reported through CALPADS. This field may differ from the grade span offered. Note: Special programs at independent study, alternative education, and special education schools will often exceed the typical grade span for schools of that type (i.e., a high school might serve grades three through twelve). |
Virtual |
Character | 1 | This field identifies the type of virtual instruction offered by the school. Virtual instruction is instruction in which students and teachers are separated by time and/or location, and interaction occurs via computers and/or telecommunications technologies. The field is coded as follows:
|
Magnet | Character | 1 | This field identifies whether a school is a magnet school and/or provides a magnet program. Additional information on magnet schools may be obtained from the CDE Magnets web page. The field is coded as follows:
Note: Preschools and adult education centers do not contain a magnet school indicator. |
YearRound | Character | 1 | This field indicates if the school is operating on a year round calendar. More information about year-round education can be found by visiting the CDE Year-Round Education Program Guide web page. The field is coded as follows:
|
FederalDFCDistrictID | Character | 7 | This field represents the 7-digit National Center for Educational Statistics (NCES) school district identification number (ID) for direct funded charter schools. Beginning in February 2019, direct funded charter schools were issued their own federal district ID and should no longer use the federal district ID associated with their authorizing agency. |
Latitude |
Decimal | 10 | The angular distance (expressed in degrees) between the location of the school, district, or administrative authority and the equator measured north to south. |
Longitude |
Decimal | 10 | The angular distance (expressed in degrees) between the location of the school, district, or administrative authority and the prime meridian (Greenwich, England) measured from west to east. |
AdmFName |
Character | 20 | The superintendent’s or principal’s first name. Only active and pending districts and schools will display administrator information, if applicable. |
AdmLName |
Character | 40 | The superintendent’s or principal’s last name. Only active and pending districts and schools will display administrator information, if applicable. |
LastUpDate |
Date | 10 | The date the record was last updated. |
Multilingual |
Character | 1 | This field indicates whether or not the school offers a multilingual program. A “multilingual instructional program” is an educational program designed to provide instruction to students which leads to linguistic and/or academic proficiency in one or more languages, in addition to English. Schools with 10 or more students enrolled in any of the following programs are reported as offering a multilingual program.
The field is coded as follows:
|
Note: A value of “No Data” indicates that the data element does not apply to that specific entity, or that data was not reported for the entity. Reasons why data may not have been reported for the entity may be that the entity is not required to report the data, the entity is closed, or the entity is new and has not yet reported the data. Some of the elements in this file are specific to schools, therefore, districts and county offices of education, will not have data in the school specific fields.