US Colleges & Universities
All Post Secondary Education Facilities in the United States of America
@kaggle.joebeachcapital_us_colleges_and_universities
All Post Secondary Education Facilities in the United States of America
@kaggle.joebeachcapital_us_colleges_and_universities
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
);
Anyone who has the link will be able to view this.