Name: Shelter Repair Scorecard
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Shelter Repair Scorecard

A list of all shelter buildings in the DHS system with the number of violations issued to that building.
Organization: City of New York
Last updated: 2020-11-10T17:02:35.036816
Tags: dhs, scorecard, shelter, shelter-building, shelter-scorecard, violation

Tables

Table 1

@usgov.city_of_new_york_shelter_repair_scorecard.table_1

505.96 KB
34139 rows
55 columns


CREATE TABLE table_1 (
  "month" VARCHAR,
  "dhs_bld_id" DOUBLE,
  "shelter_name_all" VARCHAR,
  "landlord" VARCHAR,
  "borough" VARCHAR,
  "facility_type" VARCHAR,
  "capacity" DOUBLE,
  "highpriority_closed_monthly_dob" DOUBLE,
  "highpriority_new_monthly_dob" DOUBLE,
  "highpriority_open_monthly_dob" DOUBLE,
  "highpriority_closed_monthly_hpd" DOUBLE,
  "highpriority_new_monthly_hpd" DOUBLE,
  "highpriority_open_monthly_hpd" DOUBLE,
  "highpriority_closed_monthly_fdny" DOUBLE,
  "highpriority_new_monthly_fdny" DOUBLE,
  "highpriority_open_monthly_fdny" DOUBLE,
  "highpriority_closed_monthly_dohmh" DOUBLE,
  "highpriority_new_monthly_dohmh" DOUBLE,
  "highpriority_open_monthly_dohmh" DOUBLE,
  "mediumpriority_closed_monthly_dob" DOUBLE,
  "mediumpriority_new_monthly_dob" DOUBLE,
  "mediumpriority_open_monthly_dob" DOUBLE,
  "mediumpriority_closed_monthly_hpd" DOUBLE,
  "mediumpriority_new_monthly_hpd" DOUBLE,
  "mediumpriority_open_monthly_hpd" DOUBLE,
  "mediumpriority_closed_monthly_fdny" DOUBLE,
  "mediumpriority_new_monthly_fdny" DOUBLE,
  "mediumpriority_open_monthly_fdny" DOUBLE,
  "mediumpriority_closed_monthly_dohmh" DOUBLE,
  "mediumpriority_new_monthly_dohmh" DOUBLE,
  "mediumpriority_open_monthly_dohmh" DOUBLE,
  "lowestpriority_closed_monthly_dob" DOUBLE,
  "lowestpriority_new_monthly_dob" DOUBLE,
  "lowestpriority_open_monthly_dob" DOUBLE,
  "lowestpriority_closed_monthly_hpd" DOUBLE,
  "lowestpriority_new_monthly_hpd" DOUBLE,
  "lowestpriority_open_monthly_hpd" DOUBLE,
  "lowestpriority_closed_monthly_fdny" DOUBLE,
  "lowestpriority_new_monthly_fdny" DOUBLE,
  "lowestpriority_open_monthly_fdny" DOUBLE,
  "lowestpriority_closed_monthly_dohmh" DOUBLE,
  "lowestpriority_new_monthly_dohmh" DOUBLE,
  "lowestpriority_open_monthly_dohmh" DOUBLE,
  "commissionerorder_closed_monthly_dob" DOUBLE,
  "commissionerorder_new_monthly_dob" DOUBLE,
  "commissionerorder_open_monthly_dob" DOUBLE,
  "commissionerorder_closed_monthly_hpd" DOUBLE,
  "commissionerorder_new_monthly_hpd" DOUBLE,
  "commissionerorder_open_monthly_hpd" DOUBLE,
  "commissionerorder_closed_monthly_fdny" DOUBLE,
  "commissionerorder_new_monthly_fdny" DOUBLE,
  "commissionerorder_open_monthly_fdny" DOUBLE,
  "commissionerorder_closed_monthly_dohmh" DOUBLE,
  "commissionerorder_new_monthly_dohmh" DOUBLE,
  "commissionerorder_open_monthly_dohmh" DOUBLE
);