Baselight

Public School Characteristics 2017-18

Department of Education

@usgov.ed_gov_public_school_characteristics_2017_18_96c75

Loading...
Loading...

About this Dataset

Public School Characteristics 2017-18

The National Center for Education Statistics' (NCES) Education Demographic and Geographic Estimate (EDGE) program develops annually updated point locations (latitude and longitude) for public elementary and secondary schools included in the NCES Common Core of Data (CCD). The NCES EDGE program collaborates with the U.S. Census Bureau's Education Demographic, Geographic, and Economic Statistics (EDGE) Branch to develop point locations for schools reported in the annual CCD directory file. The CCD program annually collects administrative and fiscal data about all public schools, school districts, and state education agencies in the United States. The data are supplied by state education agency officials and include basic directory and contact information for schools and school districts, as well as characteristics about student demographics, number of teachers, school grade span, and various other administrative conditions. CCD school and agency point locations are derived from reported information about the physical location of schools and agency administrative offices. The point locations and administrative attributes in this data layer were developed from the 2017-2018 CCD collection. For more information about NCES school point data, see: https://nces.ed.gov/programs/edge/Geographic/SchoolLocations. For more information about these CCD attributes, as well as additional attributes not included, see: https://nces.ed.gov/ccd/files.asp.

Notes:

-1 or M Indicates that the data are missing.
-2 or N Indicates that the data are not applicable.
-9 Indicates that the data do not meet NCES data quality standards.

All information contained in this file is in the public domain. Data users are advised to review NCES program documentation and feature class metadata to understand the limitations and appropriate use of these data.
Organization: Department of Education
Last updated: 2024-04-16T10:13:00.581823
Tags: ccd, common-core-of-data, edge, education-demographic-and-geographic-estimates-program, national-center-for-education-statistics, nces, points, public-school-locations, public-schools, u-s-census-bureau, united-states, us-census-bureau

Tables

Table 1

@usgov.ed_gov_public_school_characteristics_2017_18_96c75.table_1
  • 14.79 MB
  • 100729 rows
  • 79 columns
Loading...

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "ncessch" BIGINT,
  "survyear" VARCHAR,
  "stabr" VARCHAR,
  "leaid" BIGINT,
  "st_leaid" VARCHAR,
  "lea_name" VARCHAR,
  "sch_name" VARCHAR,
  "lstreet1" VARCHAR,
  "lstreet2" VARCHAR,
  "lstreet3" VARCHAR,
  "lcity" VARCHAR,
  "lstate" VARCHAR,
  "lzip" BIGINT,
  "lzip4" VARCHAR,
  "phone" VARCHAR,
  "charter_text" VARCHAR,
  "magnet_text" VARCHAR,
  "virtual" VARCHAR,
  "gslo" VARCHAR,
  "gshi" VARCHAR,
  "school_level" VARCHAR,
  "stitlei" VARCHAR,
  "status" BIGINT,
  "school_type_text" VARCHAR,
  "sy_status_text" VARCHAR,
  "nmcnty" VARCHAR,
  "ulocale" VARCHAR,
  "totfrl" BIGINT,
  "frelch" BIGINT,
  "redlch" BIGINT,
  "pk" DOUBLE,
  "kg" DOUBLE,
  "g01" DOUBLE,
  "g02" DOUBLE,
  "g03" DOUBLE,
  "g04" DOUBLE,
  "g05" DOUBLE,
  "g06" DOUBLE,
  "g07" DOUBLE,
  "g08" DOUBLE,
  "g09" DOUBLE,
  "g10" DOUBLE,
  "g11" DOUBLE,
  "g12" DOUBLE,
  "g13" DOUBLE,
  "ug" DOUBLE,
  "ae" DOUBLE,
  "totfenrol" DOUBLE,
  "totmenrol" DOUBLE,
  "total" DOUBLE,
  "fte" DOUBLE,
  "member" DOUBLE,
  "stuteratio" DOUBLE,
  "amalm" DOUBLE,
  "amalf" DOUBLE,
  "am" DOUBLE,
  "asalm" DOUBLE,
  "asalf" DOUBLE,
  "as" DOUBLE,
  "blalm" DOUBLE,
  "blalf" DOUBLE,
  "bl" DOUBLE,
  "hpalm" DOUBLE,
  "hpalf" DOUBLE,
  "hp" DOUBLE,
  "hialm" DOUBLE,
  "hialf" DOUBLE,
  "hi" DOUBLE,
  "tralm" DOUBLE,
  "tralf" DOUBLE,
  "tr" DOUBLE,
  "whalm" DOUBLE,
  "whalf" DOUBLE,
  "wh" DOUBLE,
  "latcod" DOUBLE,
  "loncod" DOUBLE
);

Share link

Anyone who has the link will be able to view this.