About this Dataset

Public School Facility Location History

Pursuant to D.C. Official Code § 38-2803, the Mayor of the District of Columbia is required to prepare a 10-year Master Facilities Plan for public education facilities and additional annual supplements. As part of this, the Office of the Deputy Mayor for Education collects and updates information about public school facilities in active use and the public schools that occupy them. This dataset contains historic data on public school facilities from SY13-14 to SY25-26 and serves as a record of change of the public school ecosystem over this period. For each year contained in the dataset, users can explore the number of Local Education Agencies (LEA) and Schools as well as their locations and, for District of Columbia Public Schools (DCPS), where they were located during modernization projects.
Organization: District of Columbia
Last updated: 2025-08-20T04:30:27.790012
Tags: dc, dcps, district-of-columbia, district-of-columbia-public-schools, facilities, pcsb, public-charter, public-charter-school-board, public-school, school-facilities, washington-dc

Tables

Table 1

@usgov.district_of_columbia_public_school_facility_location_history.table_1

244.4 kB
3,308 rows
25 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "school_year" VARCHAR,
  "lea_id" BIGINT,
  "lea_name" VARCHAR,
  "school_id" BIGINT,
  "school_name" VARCHAR,
  "school_sector" VARCHAR,
  "facility_id" VARCHAR,
  "facility_sector" VARCHAR,
  "facility_address" VARCHAR,
  "dcps_facility_name" VARCHAR,
  "swinging" BIGINT,
  "swinging_onsite" BIGINT,
  "mar_id" BIGINT,
  "mar_zipcode" BIGINT,
  "mar_xcoord" DOUBLE,
  "mar_ycoord" DOUBLE,
  "mar_latitude" DOUBLE,
  "mar_longitude" DOUBLE,
  "permanent_facility_id" VARCHAR,
  "permanent_facility_address" VARCHAR,
  "se_anno_cad_data" VARCHAR,
  "globalid" VARCHAR
);