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

About this Dataset

US Prisons

The prison boundary feature class contains secure detention facilities. These facilities range in jurisdiction from federal (excluding military) to local governments. Polygon geometry is used to describe the extent of where the incarcerated population is located (fence lines or building footprints). This feature class’s attribution describes many physical and social characteristics of detention facilities in the United States and some of its territories. The attribution for this feature class was populated by open source search methodologies of authoritative sources. Changes from the previous version include 70 records added, 72 closed, and 37 removed.

Tables

Us Prison Boundaries

@kaggle.joebeachcapital_us_prisons.us_prison_boundaries

3.4 MB
6738 rows
34 columns


CREATE TABLE us_prison_boundaries (
  "geo_point" VARCHAR,
  "geo_shape" VARCHAR,
  "fid" BIGINT,
  "facilityid" DOUBLE,
  "name" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" DOUBLE,
  "zip4" DOUBLE,
  "telephone" VARCHAR,
  "type" VARCHAR,
  "status" VARCHAR,
  "population" DOUBLE,
  "county" VARCHAR,
  "countyfips" VARCHAR,
  "country" VARCHAR,
  "naics_code" DOUBLE,
  "naics_desc" VARCHAR,
  "source" VARCHAR,
  "sourcedate" VARCHAR,
  "val_method" VARCHAR,
  "val_date" VARCHAR,
  "website" VARCHAR,
  "securelvl" VARCHAR,
  "capacity" DOUBLE,
  "shape_leng" DOUBLE,
  "globalid" VARCHAR,
  "creationdate" VARCHAR,
  "creator" VARCHAR,
  "editdate" VARCHAR,
  "editor" VARCHAR,
  "shape_length" DOUBLE,
  "shape_area" DOUBLE
);