About this Dataset

DC Public Schools

This dataset includes all identifiable DCPS public elementary schools, middle schools, education campuses, high schools, and special education schools, as well as learning centers. This dataset does not include private or charter schools. School locations were identified from a database from the District of Columbia Public Schools, Office of Facilities Management.
Organization: District of Columbia
Last updated: 2024-04-30T17:54:25.089917
Tags: dc-public-schools, dcps, district-of-columbia, education-campus, elementary-schools, high-schools, middle-schools, washington-dc

Tables

Table 1

@usgov.district_of_columbia_dc_public_schools.table_1

50.7 kB
123 rows
36 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "name" VARCHAR,
  "address" VARCHAR,
  "facuse" VARCHAR,
  "level" VARCHAR,
  "status" VARCHAR,
  "phone" VARCHAR,
  "total_stud" DOUBLE,
  "ssl" VARCHAR,
  "gis_id" VARCHAR,
  "web_url" VARCHAR,
  "bldg_num" DOUBLE,
  "sch_prog" VARCHAR,
  "capitalgains" VARCHAR,
  "capacity" DOUBLE,
  "year_built" DOUBLE,
  "square_footage" DOUBLE,
  "population_plan" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "school_yea" VARCHAR,
  "lea_name" VARCHAR,
  "lea_id" BIGINT,
  "school_nam" VARCHAR,
  "school_id" BIGINT,
  "grades" VARCHAR,
  "mar_id" BIGINT,
  "xcoord" DOUBLE,
  "ycoord" DOUBLE,
  "zipcode" DOUBLE,
  "facility_id" VARCHAR,
  "globalid" VARCHAR,
  "created" TIMESTAMP,
  "edited" TIMESTAMP,
  "objectid" BIGINT
);