Name: US Schools Dataset
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

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.98 MB
31,064 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

14.56 MB
102,334 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
);