Name: US Public Schools
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

US Public Schools

This Public Schools feature dataset is composed of all Public elementary and secondary education facilities in the United States as defined by the Common Core of Data (CCD, https://nces.ed.gov/ccd/ ), National Center for Education Statistics (NCES, https://nces.ed.gov ), US Department of Education for the 2017-2018 school year. This includes all Kindergarten through 12th grade schools as tracked by the Common Core of Data. Included in this dataset are military schools in US territories and referenced in the city field with an APO or FPO address. DOD schools represented in the NCES data that are outside of the United States or US territories have been omitted. This feature class contains all MEDS/MEDS+ as approved by NGA. Complete field and attribute information is available in the ”Entities and Attributes” metadata section. Geographical coverage is depicted in the thumbnail above and detailed in the Place Keyword section of the metadata. This release includes the addition of 3065 new records, modifications to the spatial location and/or attribution of 99,287 records, and removal of 2996 records not present in the NCES CCD data.

Tables

Us Public Schools

@kaggle.joebeachcapital_us_public_schools.us_public_schools

18.83 MB
107299 rows
33 columns


CREATE TABLE us_public_schools (
  "geo_point" VARCHAR,
  "geo_shape" VARCHAR,
  "objectid" BIGINT,
  "ncesid" BIGINT,
  "name" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "zip4" VARCHAR,
  "telephone" VARCHAR,
  "type" BIGINT,
  "status" BIGINT,
  "population" BIGINT,
  "county" VARCHAR,
  "countyfips" BIGINT,
  "country" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "naics_code" BIGINT,
  "naics_desc" VARCHAR,
  "source" VARCHAR,
  "sourcedate" VARCHAR,
  "val_method" VARCHAR,
  "val_date" VARCHAR,
  "website" VARCHAR,
  "level" VARCHAR,
  "enrollment" BIGINT,
  "st_grade" VARCHAR,
  "end_grade" VARCHAR,
  "districtid" BIGINT,
  "ft_teacher" BIGINT,
  "shelter_id" VARCHAR
);