About this Dataset

California Public Schools 2022-23

This layer serves as the authoritative geographic data source for California's K-12 public school locations during the 2022-23 academic year. Schools are mapped as point locations and assigned coordinates based on the physical address of the school facility. The school records are enriched with additional demographic and performance variables from the California Department of Education's data collections. These data elements can be visualized and examined geographically to uncover patterns, solve problems and inform education policy decisions.

The schools in this file represent a subset of all records contained in the CDE's public school directory database. This subset is restricted to K-12 public schools that were open in October 2022 to coincide with the official 2022-23 student enrollment counts collected on Fall Census Day in 2022 (first Wednesday in October). This layer also excludes nonpublic nonsectarian schools and district office schools.

The CDE's California School Directory provides school location other basic school characteristics found in the layer's attribute table. The school enrollment, demographic and program data are collected by the CDE through the California Longitudinal Achievement System (CALPADS) and can be accessed as publicly downloadable files from the Data & Statistics web page on the CDE website.

Schools are assigned X, Y coordinates using a quality controlled geocoding and validation process to optimize positional accuracy. Most schools are mapped to the school structure or centroid of the school property parcel and are individually verified using aerial imagery or assessor's parcels databases. Schools are assigned various geographic area values based on their mapped locations including state and federal legislative district identifiers and National Center for Education Statistics (NCES) locale codes.
Organization: State of California
Last updated: 2025-07-23T21:58:17.171340
Tags: california-department-of-education, education, master, open-data, school-site

Tables

Table 1

@usgov.ca_gov_california_public_schools_2022_23.table_1

1.44 MB
10009 rows
70 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "academic_year" VARCHAR,
  "fed_id" BIGINT,
  "cds_code" BIGINT,
  "district_code" BIGINT,
  "school_code" BIGINT,
  "region" BIGINT,
  "county_name" VARCHAR,
  "district_name" VARCHAR,
  "school_name" VARCHAR,
  "school_type" VARCHAR,
  "status" VARCHAR,
  "open_date" VARCHAR,
  "closed_date" VARCHAR,
  "school_level" VARCHAR,
  "grade_low" VARCHAR,
  "grade_high" VARCHAR,
  "charter" VARCHAR,
  "charter_num" VARCHAR,
  "funding_type" VARCHAR,
  "virtual" VARCHAR,
  "magnet" VARCHAR,
  "title_i" VARCHAR,
  "dass" VARCHAR,
  "assistance_status_essa" VARCHAR,
  "street" VARCHAR,
  "city" VARCHAR,
  "zip" BIGINT,
  "state" VARCHAR,
  "us_congress_district" BIGINT,
  "ca_senate_district" BIGINT,
  "ca_assembly_district" BIGINT,
  "locale" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "enroll_total" BIGINT,
  "african_american" BIGINT,
  "african_american_72c7ba" DOUBLE,
  "american_indian" BIGINT,
  "american_indian_pct" DOUBLE,
  "asian" BIGINT,
  "asian_35911f" DOUBLE,
  "filipino" BIGINT,
  "filipino_6a83e1" DOUBLE,
  "hispanic" BIGINT,
  "hispanic_ee88b8" DOUBLE,
  "pacific_islander" BIGINT,
  "pacific_islander_568399" DOUBLE,
  "white" BIGINT,
  "white_47d4dd" DOUBLE,
  "two_or_more_races" BIGINT,
  "two_or_more_races_ee073b" DOUBLE,
  "not_reported" BIGINT,
  "not_reported_8bebc3" DOUBLE,
  "english_learner" BIGINT,
  "english_learner_203ced" DOUBLE,
  "foster" BIGINT,
  "foster_b50417" DOUBLE,
  "homeless" BIGINT,
  "homeless_fa9174" DOUBLE,
  "migrant" BIGINT,
  "migrant_2aaa29" DOUBLE,
  "socioeconomically_disadvantaged" BIGINT,
  "socioeconomically_disadvantaged_22083a" DOUBLE,
  "students_with_disabilities" BIGINT,
  "students_with_disabilities_4511ee" DOUBLE,
  "free_reduced_meal_eligible" BIGINT,
  "free_reduced_meal_eligible_eb0412" DOUBLE,
  "x" DOUBLE,
  "y" DOUBLE
);