Name: DOB ECB Violations
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

DOB ECB Violations

Violations by the Department of Buildings that are adjudicated by OATH/ECB. There may also be a DOB violation. (https://data.cityofnewyork.us/Housing-Development/DOB-Violations/3h2n-5cm9)
Organization: City of New York
Last updated: 2020-11-10T17:00:58.051454
Tags: 2018od4a-report, buildings, dob, nov, violation-ecb

Tables

Table 1

@usgov.city_of_new_york_dob_ecb_violations.table_1

270.03 MB
1,753,806 rows
46 columns

CREATE TABLE table_1 (
  "isn_dob_bis_extract" BIGINT,
  "ecb_violation_number" VARCHAR,
  "ecb_violation_status" VARCHAR,
  "dob_violation_number" VARCHAR,
  "bin" VARCHAR,
  "boro" BIGINT,
  "block" DOUBLE,
  "lot" DOUBLE,
  "hearing_date" BIGINT,
  "hearing_time" BIGINT,
  "served_date" BIGINT,
  "issue_date" BIGINT,
  "severity" VARCHAR,
  "violation_type" VARCHAR,
  "respondent_name" VARCHAR,
  "respondent_house_number" VARCHAR,
  "respondent_street" VARCHAR,
  "respondent_city" VARCHAR,
  "respondent_zip" VARCHAR,
  "violation_description" VARCHAR,
  "penality_imposed" BIGINT,
  "amount_paid" BIGINT,
  "balance_due" BIGINT,
  "infraction_code1" VARCHAR,
  "section_law_description1" VARCHAR,
  "infraction_code2" VARCHAR,
  "section_law_description2" VARCHAR,
  "infraction_code3" VARCHAR,
  "section_law_description3" VARCHAR,
  "infraction_code4" VARCHAR,
  "section_law_description4" VARCHAR,
  "infraction_code5" VARCHAR,
  "section_law_description5" VARCHAR,
  "infraction_code6" VARCHAR,
  "section_law_description6" VARCHAR,
  "infraction_code7" VARCHAR,
  "section_law_description7" VARCHAR,
  "infraction_code8" VARCHAR,
  "section_law_description8" VARCHAR,
  "infraction_code9" VARCHAR,
  "section_law_description9" VARCHAR,
  "infraction_code10" VARCHAR,
  "section_law_description10" VARCHAR,
  "aggravated_level" VARCHAR,
  "hearing_status" VARCHAR,
  "certification_status" VARCHAR
);