US Schools Dataset
Data on 130k+ schools in the US with georeferences.
@kaggle.andrewmvd_us_schools_dataset
Data on 130k+ schools in the US with georeferences.
@kaggle.andrewmvd_us_schools_dataset
CREATE TABLE private_schools (
"x" DOUBLE,
"y" DOUBLE,
"fid" BIGINT,
"objectid" BIGINT,
"ncesid" VARCHAR,
"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" TIMESTAMP,
"val_method" VARCHAR,
"val_date" TIMESTAMP,
"website" VARCHAR,
"level" BIGINT,
"enrollment" BIGINT,
"start_grad" BIGINT,
"end_grade" BIGINT,
"ft_teacher" BIGINT,
"shelter_id" VARCHAR
);
CREATE TABLE public_schools (
"x" DOUBLE,
"y" DOUBLE,
"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" TIMESTAMP,
"val_method" VARCHAR,
"val_date" TIMESTAMP,
"website" VARCHAR,
"level" VARCHAR,
"enrollment" BIGINT,
"st_grade" VARCHAR,
"end_grade" VARCHAR,
"districtid" BIGINT,
"ft_teacher" BIGINT,
"shelter_id" VARCHAR
);
Anyone who has the link will be able to view this.