DOB Violations by US Government | Demographics and Population Studies

About this Dataset

DOB Violations

Violations that have been issued by the Department of Buildings. There may also be an ECB violation. (https://data.cityofnewyork.us/Housing-Development/DOB-ECB-Violations/6bgk-3dad)
Organization: City of New York
Last updated: 2020-11-10T17:00:30.580434
Tags: buildings, dob, violation

Tables

Table 1

@usgov.city_of_new_york_dob_violations.table_1

118.46 MB
2445507 rows
18 columns


CREATE TABLE table_1 (
  "isn_dob_bis_viol" BIGINT,
  "boro" VARCHAR,
  "bin" DOUBLE,
  "block" VARCHAR,
  "lot" VARCHAR,
  "issue_date" VARCHAR,
  "violation_type_code" VARCHAR,
  "violation_number" VARCHAR,
  "house_number" VARCHAR,
  "street" VARCHAR,
  "disposition_date" DOUBLE,
  "disposition_comments" VARCHAR,
  "device_number" VARCHAR,
  "description" VARCHAR,
  "ecb_number" VARCHAR,
  "number" VARCHAR,
  "violation_category" VARCHAR,
  "violation_type" VARCHAR
);