About this Dataset

US Schools Dataset

Abstract

Names, addresses and coordinates of all public and private schools in the US.

About this dataset

This dataset, taken from the US Department of Homeland Security, contains information on all public and private schools with attributes regarding their geographical distribution.

Acknowledgements

If you use this dataset in your research, please credit the authors.

BibTeX

@misc{Homeland Infrastructure Foundation-Level Data (HIFLD),
title={Public Schools},
url={https://hifld-geoplatform.opendata.arcgis.com/datasets/public-schools},
journal={Homeland Infrastructure Foundation-Level Data (HIFLD)}}

License

Public Domain.

Splash banner

Photo by Feliphe Schiarolli on Unsplash.

Splash icon

Icon by iconixar available on Flaticon.

More Datasets

Tables

Private Schools

@kaggle.andrewmvd_us_schools_dataset.private_schools

3.8 MB
31064 rows
33 columns


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
);

Public Schools

@kaggle.andrewmvd_us_schools_dataset.public_schools

13.88 MB
102334 rows
33 columns


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
);