File Structure: Public Schools Database

CDSCode

Character

14

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 (NCES) school district 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 NCES school 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 school or district. Definitions of the valid status types are listed below:

• Active: The district or school is in operation and providing instructional services.
• Closed: The district or school is not in operation and no longer providing instructional services.
• Merged: The district has combined with another district, and the schools within the merged district have closed and re-opened in the newly formed district.
• Pending: The district or school has not opened yet, but plans to open within the next 9-12 months.

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.

Ext

Character

6

The phone number extension 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. An empty cell indicates that the start date precedes July 1, 1980, the date the California Department of Education began to maintain this information.

ClosedDate

Date

10

The date the school closed. An empty cell indicates that the entity is not closed.

Charter

Character

1

This field identifies charter schools. The field is coded as follows:

• Y = The school is a charter
• N = The school is not a charter school

CharterNum

Character

4

The schools charter number.

A four character value (any combination of numbers and letters) assigned to a charter school . A blank value indicates the school is not a charter school.

Example: 0108

DOC

Character

2

The District Ownership Code (DOC) is the numeric code used to identity the category of the Administrative Authority.

• 00 – County Office of Education
• 02 – State Board of Education
• 03 – Statewide Benefit Charter
• 31 – State Special Schools
• 34 – Non-school Location
• 52 – Elementary School District
• 54 – Unified School District
• 56 – High School District
• 98 – Regional Occupation Center/Program (ROC/P)

DOCType

Character

50

The District Ownership Code Type is the text description of the DOC category. (See text values in DOC field description above)

SOC

Character

2

The School Ownership Code is a numeric code used to identify the type of school.

• 08 – Preschool
• 09 – Special Education Schools (Public)
• 10 – County Community
• 11 – Youth Authority Facilities (CEA)
• 13 – Opportunity Schools
• 14 – Juvenile Court Schools
• 15 – Other County or District Programs
• 16 – Home & Hospital
• 17 – Licensed Childcare (Group Home)++
• 31 – State Special Schools
• 60 – Elementary School (Public)
• 61 – Elementary School in 1 school School District (Public)
• 62 – Intermediate/Middle Schools (Public)
• 63 – Alternative Schools of Choice
• 64 – Junior High Schools (Public)
• 65 – K-12 Schools (Public
• 66 – High Schools (Public)
• 67 – High Schools In 1 School Dist. (Public)
• 68 – Continuation High Schools
• 69 – District Community Day Schools
• 70 – Adult Education Centers
• 98 – Regional Occupational Center/Program (ROC/P)

SOCType

Character

50

The School Ownership Code Type is the text description of the type of school.

(See text values in SOC field description above)

EdOpsCode

Character

20

The Educational Option Code is a short text description of the type of education being offered.

• ALTSOC – Alternative School of Choice
• COMM – County Community School
• COMMDAY – Community Day School
• CON – Continuation School
• JUV – Juvenile Court School
• OPP – Opportunity School
• YTH – Youth Authority School
• SSS – State Special School
• SPEC – Special Education School
• TRAD – Traditional
• ROP – Regional Occupational Program
• HOMHOS – Home and Hospital
• NPS – Nonpublic Nonsectarian Certified School
• SPECON – District Consortia Special Education School
• SSSDIAG – State Special Schools Diagnostic Center
• LCI – Licensed Children's Institution

EdOpsName

Character

100

The Educational Option Name 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 is a short text description of the institution’s type relative to the grade range offered.

• A – Adult
• ELEM – Elementary
• ELEMHIGH – Elementary-High Combination
• HS – High School
• INTMIDJR – Intermediate/Middle/Junior High
• PS – Preschool
• UG – Ungraded

EILName

Character

50

The Educational Instruction Level Name is the long text description of the institution’s type relative to the grade range offered.

(See text values in EILCode field description above)

GSoffered

Character

101

The grade span offered 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 CBEDS 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. It is the lowest grade and the highest grade of student enrollment as reported in the most recent certified CBEDS data collection. Only K-12 enrollment is reported through CBEDS. 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).

Example: K–12

PopStat

Character

2

This field classifies the location of a school relative to twelve categories of populous areas. The codes, categories, and descriptions are listed below. The data in this field are provided by the National Center for Education Statistics (NCES) in conjunction with the U.S. Census Bureau. The new coding system was established in 2006-07. The former system consisted of eight categories. See the NCES Web site for additional information.

• 11 = City, Large Territory inside an urbanized area and inside a principal city with population of 250,000 or more.
• 12 = City, Mid-size Territory inside an urbanized area and inside a principal city with a population less than 250,000 and greater than or equal to 100,000.
• 13 = City, Small Territory inside an urbanized area and inside a principal city with a population less than 100,000.
• 21 = Suburb, Large Territory outside a principal city and inside an urbanized area with population of 250,000 or more.
• 22 = Suburb, Mid-size Territory outside a principal city and inside an urbanized area with a population less than 250,000 and greater than or equal to 100,000.
• 23 = Suburb, Small Territory outside a principal city and inside an urbanized area with a population less than 100,000.
• 31 =Town, Fringe Territory inside an urban cluster that is less than or equal to 10 miles from an urbanized area.
• 32 = Town, Distant Territory inside an urban cluster that is more than 10 miles and less than or equal to 35 miles from an urbanized area.
• 33 = Town, Remote Territory inside an urban cluster that is more than 35 miles from an urbanized area.
• 41 = Rural, Fringe Census-defined rural territory that is less than or equal to 5 miles from an urbanized area, as well as rural territory that is less than or equal to 2.5 miles from an urban cluster.
• 42 = Rural, Distant Census-defined rural territory that is more than 5 miles but less than or equal to 25 miles from an urbanized area, as well as rural territory that is more than 2.5 miles but less than or equal to 10 miles from an urban cluster.
• 43 = Rural, Remote Census-defined rural territory that is more than 25 miles from an urbanized area and is also more than 10 miles from an urban cluster.
• Blank (Data Not Available): New school not yet assigned a population status code by the Census Bureau, or where there has been a change in the CDS Code, or a school not reporting on the California Basic Educational Data System (CBEDS) collection.

Latitude

Character

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

Character

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.

AdmFName1

Character

20

The superintendent’s or principal’s first name. Only active and pending districts and schools will display administrator information, if applicable.

AdmLName1

Character

40

The superintendent’s or principal’s last name. Only active and pending districts and schools will display administrator information, if applicable.

AdmEmail1

Character

50

The superintendent’s or principal’s e-mail address. Only active and pending districts and schools will display administrator information, if applicable.

AdmFName2

Character

20

The second principal’s first name (optional). Only active and pending school records will display principal information, if applicable.

AdmLName2

Character

40

The second principal’s last name (optional). Only active and pending school records will display principal information, if applicable

AdmEmail2

Character

50

The second principal’s e-mail address (optional). Only active and pending school records will display principal information, if applicable.

AdmFName3

Character

20

The third principal’s first name (optional).  Only active and pending school records will display principal information, if applicable.

AdmLName3

Character

40

The third principal’s last name (optional). Only active and pending school records will display principal information, if applicable

AdmEmail3

Character

50

The third principal’s e-mail address (optional). Only active and pending school records will display principal information, if applicable.

LastUpDate

Date

10

The date the record was last updated.