Baselight

US Colleges & Universities

All Post Secondary Education Facilities in the United States of America

@kaggle.joebeachcapital_us_colleges_and_universities

Loading...
Loading...

About this Dataset

US Colleges & Universities

The Colleges and Universities feature class/shapefile is composed of all Post Secondary Education facilities as defined by the Integrated Post Secondary Education System (IPEDS, http://nces.ed.gov/ipeds/), National Center for Education Statistics (NCES, https://nces.ed.gov/), US Department of Education for the 2018-2019 school year. Included are Doctoral/Research Universities, Masters Colleges and Universities, Baccalaureate Colleges, Associates Colleges, Theological seminaries, Medical Schools and other health care professions, Schools of engineering and technology, business and management, art, music, design, Law schools, Teachers colleges, Tribal colleges, and other specialized institutions. Overall, this data layer covers all 50 states, as well as Puerto Rico and other assorted U.S. territories. This feature class contains all MEDS/MEDS+ as approved by the National Geospatial-Intelligence Agency (NGA) Homeland Security Infrastructure Program (HSIP) Team. 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 feature class does not have a relationship class but is related to Supplemental Colleges. Colleges and Universities that are not included in the NCES IPEDS data are added to the Supplemental Colleges feature class when found. This release includes the addition of 175 new records, the removal of 468 no longer reported by NCES, and modifications to the spatial location and/or attribution of 6682 records.

Tables

Us Colleges And Universities

@kaggle.joebeachcapital_us_colleges_and_universities.us_colleges_and_universities
  • 1.33 MB
  • 6559 rows
  • 45 columns
Loading...

CREATE TABLE us_colleges_and_universities (
  "geo_point" VARCHAR,
  "geo_shape" VARCHAR,
  "objectid" BIGINT,
  "ipedsid" BIGINT,
  "name" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "zip4" VARCHAR,
  "telephone" VARCHAR,
  "type" BIGINT,
  "status" VARCHAR,
  "population" BIGINT,
  "county" VARCHAR,
  "countyfips" VARCHAR,
  "country" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "naics_code" BIGINT,
  "naics_desc" VARCHAR,
  "source" VARCHAR,
  "sourcedate" VARCHAR,
  "val_method" VARCHAR,
  "val_date" VARCHAR,
  "website" VARCHAR,
  "stfips" VARCHAR,
  "cofips" VARCHAR,
  "sector" BIGINT,
  "level" BIGINT,
  "hi_offer" BIGINT,
  "deg_grant" BIGINT,
  "locale" BIGINT,
  "close_date" VARCHAR,
  "merge_id" BIGINT,
  "alias" VARCHAR,
  "size_set" BIGINT,
  "inst_size" BIGINT,
  "pt_enroll" BIGINT,
  "ft_enroll" BIGINT,
  "tot_enroll" BIGINT,
  "housing" BIGINT,
  "dorm_cap" BIGINT,
  "tot_emp" BIGINT,
  "shelter_id" VARCHAR
);

Share link

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