Baselight

US Schools Dataset

Data on 130k+ schools in the US with georeferences.

@kaggle.andrewmvd_us_schools_dataset

Loading...
Loading...

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
Loading...

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
Loading...

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

Share link

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