California Schools and Districts

California public schools, private schools and districts.

cde.ca.gov-schools-1

Resources | Packages | Documentation| Contacts| Data Dictionary

Resources

Documentation

Contacts

Packages

Accessing Packages in Metapack

import metapack as mp
pkg = mp.open_package('http://library.metatab.org/cde.ca.gov-schools-1.zip')

# Create Dataframes

public_schools_df = pkg.resource('public_schools').dataframe()
school_districts_df = pkg.resource('school_districts').dataframe()
private_schools_2019_df = pkg.resource('private_schools_2019').dataframe()

Data Dictionary

private_schools_2019 | public_schools | school_districts

private_schools_2019

Column NameData TypeDescription
affidavit_idintegerAffidavit ID
countystringCounty
cds_codestringCDS Code
schooltextSchool
streetstringStreet
citytextCity
statestringState
zipintegerZip
mailing_streetstringMailing Street
mailing_citystringMailing City
mailing_statestringMailing State
mailing_zipstringMailing Zip
area_codestringArea Code
phone_prefixstringPhone Prefix
phone_suffixstringPhone Suffix
emailstringEmail
email2stringEmail2
public_districtstringPublic District
site_administrator_salutationstringSite Administrator Salutation
site_administrator_first_nametextSite Administrator First Name
site_administrator_last_nametextSite Administrator Last Name
site_administrator_titlestringSite Administrator Title
adminstrator_emailstringAdminstrator Email
school_typestringSchool Type
school_accomodationsstringSchool Accomodations
low_gradestringLow Grade
high_gradestringHigh Grade
diploma_offeredstringDiploma Offered
low_grade2integerLow Grade2
high_grade3integerHigh Grade3
kindergarten_enrollmentintegerKindergarten Enrollment
grade_1_enrollmentintegerGrade 1 Enrollment
grade_2_enrollmentintegerGrade 2 Enrollment
grade_3_enrollmentintegerGrade 3 Enrollment
grade_4_enrollmentintegerGrade 4 Enrollment
grade_5_enrollmentintegerGrade 5 Enrollment
grade_6_enrollmentintegerGrade 6 Enrollment
grade_7_enrollmentintegerGrade 7 Enrollment
grade_8_enrollmentintegerGrade 8 Enrollment
grade_9_enrollmentintegerGrade 9 Enrollment
grade_10_enrollmentintegerGrade 10 Enrollment
grade_11_enrollmentintegerGrade 11 Enrollment
grade_12_enrollmentintegerGrade 12 Enrollment
ungraded_elementary_enrollmentintegerUngraded Elementary Enrollment
ungraded_secondary_enrollmentintegerUngraded Secondary Enrollment
total_enrollmentintegerTotal Enrollment
diploma_offered4stringDiploma Offered4
graduates_2017_18integerGraduates 2017-18
full_time_teachersintegerFull Time Teachers
part_time_teachersnumberPart Time Teachers
administrative_staffnumberAdministrative Staff
other_staffintegerOther Staff
tax_exempt_501stringTax Exempt 501
tax_exempt_23701stringTax Exempt 23701
tax_exempt_214stringTax Exempt 214
tax_exemptstringTax Exempt
tax_exempt_not_applicablestringTax Exempt Not Applicable
religious_denominationstringReligious Denomination
religious_classificationstringReligious Classification
director_principal_officer_salutationstringDirector/Principal Officer Salutation
director_principal_officer_first_namestringDirector/Principal Officer First Name
director_principal_officer_last_nametextDirector/Principal Officer Last Name
director_principal_officer_titlestringDirector/Principal Officer Title
director_principal_officer_emailtextDirector/Principal Officer Email
custodian_of_records_salutationstringCustodian of Records Salutation
custodian_of_records_first_nametextCustodian of Records First Name
custodian_of_records_last_nametextCustodian of Records Last Name
custodian_of_records_emailstringCustodian of Records Email

public_schools

Column NameData TypeDescription
cdscodeintegerThis 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.
ncesdiststringThis 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.
ncesschoolstringThis field represents the 5-digit NCES school identification number. The NCESSchool combined with the NCESDist form a unique 12-digit ID for each school.
statustypestringThis field identifies the status of the district. Definitions of the valid status types are listed below: – *Active:* The district is in operation and providing instructional services. – *Closed:* The district is not in operation and no longer providing instructional services. – *Merged:* The district has combined with another district or districts. – *Pending:* The district has not opened for operation and instructional services yet, but plans to open within the next 9–12 months.
countystringCounty name.
districtstringDistrict or Administrative Authority name.
schooltextSchool name.
streetstringThe 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.
streetabrstringThe 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.
citystringThe 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.
zipstringThe 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.
statestringThe state in which the school, district, or administrative authority is located.
mailstreetstringThe 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.
mailstrabrstringThe 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.
mailcitystringThe 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.
mailzipstringThe 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.
mailstatestringThe state within the mailing address. For your convenience we have filled the unpopulated MailState cells with State data.
phonestringThe area code and phone number of the school, district, or administrative authority.
extstringThe phone number extension of the school, district, or administrative authority.
websitestringThe website address of the school, district, or administrative authority.
opendatestringThe date the school opened.
closeddatestringThe date the school closed.
charterstringThis field identifies a charter school. The field is coded as follows: – Y = The school is a charter – N = The school is not a charter
charternumstringThe charter school number, which is a 4-digit number assigned to a charter school.
fundingtypestringIndicates the charter school funding type. Values are as follows: – Not in CS funding model – Locally funded – Directly funded
docintegerThe District Ownership Code (DOC) is the numeric code used to identify 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 Occupational Center/Program (ROC/P) *Only the California Education Authority has been included in the non-school location category.
doctypestringThe District Ownership Code Type is the text description of the DOC category. (See text values in DOC field description above)
socstringThe 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 – 31 – State Special Schools – 60 – Elementary School (Public) – 61 – Elementary School in 1 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 District (Public) – 68 – Continuation High Schools – 69 – District Community Day Schools – 70 – Adult Education Centers – 98 – Regional Occupational Center/Program (ROC/P)
soctypestringThe School Ownership Code Type is the text description of the type of school. (See text values in SOC field description above)
edopscodestringThe Education Option Code is a short text description of the type of education 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 – SPECON – District Consortia Special Education School
edopsnamestringThe Educational Option Name is the long text description of the type of education being offered. (See text values in EdOPsCode field description above)
eilcodestringThe Educational Instruction Level Code is a short text description of the institution’s type relative to the grade range served. – A – Adult – ELEM – Elementary – ELEMHIGH – Elementary-High Combination – HS – High School – INTMIDJR – Intermediate/Middle/Junior High – PS – Preschool – UG – Ungraded
eilnamestringThe Educational Instruction Level Name is the long text description of the institution’s type relative to the grade range served. (See text values in EILCode field description above)
gsofferedstringThe 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 California Longitudinal Pupil Achievement (CALPADS) Fall 1 data collection. For example XYZ School might display the following data: GSoffered = P–Adult GSserved = K–12
gsservedstringThis 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 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).
virtualstringThis 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: – F = Exclusively Virtual – The school has no physical building where students meet with each other or with teachers, all instruction is virtual. – V = Primarily Virtual – The school focuses on a systematic program of virtual instruction but includes some physical meetings among students or with teachers. – C = Primarily Classroom – The school offers virtual courses but virtual instruction is not the primary means of instruction. – N = Not Virtual – The school does not offer any virtual instruction. – P = Partial Virtual – The school offers some, but not all, instruction through virtual instruction. Note: This value was retired and replaced with the Primarily Virtual and Primarily Classroom values beginning with the 2016–17 school year.
magnetstringThis 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: – Y = Magnet – The school is a magnet school and/or offers a magnet program. – N = Not Magnet – The school is not a magnet school and/or does not offer a magnet program. Note: Preschools and adult education centers do not contain a magnet school indicator.
yearroundynstringThis 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.
federaldfcdistrictidstringThis field represents the 7-digit National Center for Educational Statistics (NCES) school district identification number 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.
latitudestringThe angular distance (expressed in degrees) between the location of the school, district, or administrative authority and the equator measured north to south.
longitudestringThe 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.
admfname1stringThe superintendent’s or principal’s first name. Only active and pending districts and schools will display administrator information, if applicable.
admlname1textThe superintendent’s or principal’s last name. Only active and pending districts and schools will display administrator information, if applicable.
admemail1stringThe superintendent’s or principal’s e-mail address. Only active and pending districts and schools will display administrator information, if applicable.
admfname2stringThe second principal’s first name (optional). Only active and pending school records will display principal information, if applicable.
admlname2stringThe second principal’s last name (optional). Only active and pending school records will display principal information, if applicable.
admemail2stringThe second principal’s e-mail address (optional). Only active and pending school records will display principal information, if applicable.
admfname3stringThe third principal’s first name (optional). Only active and pending school records will display principal information, if applicable.
admlname3stringThe third principal’s last name (optional). Only active and pending school records will display principal information, if applicable.
admemail3stringThe third principal’s e-mail address (optional). Only active and pending school records will display principal information, if applicable.
lastupdatedateThe date the record was last updated.

school_districts

Column NameData TypeDescription
cd_codeintegerCD Code
countystringCounty
districtstringDistrict
streetstringStreet
citystringCity
zipstringZip
statestringState
mailstreetstringMailStreet
mailcitystringMailCity
mailzipstringMailZip
mailstatestringMailState
phonestringPhone
extstringExt
admfnametextAdmFName
admlnametextAdmLName
admemailstringAdmEmail
latitudenumberLatitude
longitudenumberLongitude
docintegerDOC
doctypestringDOCType
statustypestringStatusType
lastupdatedateLastUpDate

Last Modified 2019-07-23T16:38:03

Packages

Accessing Packages in Metapack

import metapack as mp
pkg = mp.open_package('http://library.metatab.org/cde.ca.gov-schools-1.zip')

# Create Dataframes

public_schools_df = pkg.resource('public_schools').dataframe()
school_districts_df = pkg.resource('school_districts').dataframe()
private_schools_2019_df = pkg.resource('private_schools_2019').dataframe()