Baselight

Public School Characteristics 2020-21

Department of Education

@usgov.ed_gov_public_school_characteristics_2020_21_e279c

Loading...
Loading...

About this Dataset

Public School Characteristics 2020-21

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 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 2020-2021 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-05-23T16:30:47.095488
Tags: 0ee4621b-38be-46bb-8360-219726022a58, 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_2020_21_e279c.table_1
  • 13.7 MB
  • 100722 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,
  "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,
  "titlei" VARCHAR,
  "stitlei" VARCHAR,
  "status" BIGINT,
  "school_type_text" VARCHAR,
  "sy_status_text" VARCHAR,
  "ulocale" VARCHAR,
  "nmcnty" VARCHAR,
  "totfrl" DOUBLE,
  "frelch" DOUBLE,
  "redlch" DOUBLE,
  "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,
  "totmenrol" VARCHAR,
  "totfenrol" VARCHAR,
  "total" DOUBLE,
  "member" DOUBLE,
  "fte" 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.