Name: DOB NOW: Safety – Facades Compliance Filings
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

DOB NOW: Safety – Facades Compliance Filings

List of all Facades compliance filings submitted in DOB NOW.
Organization: City of New York
Last updated: 2021-08-07T17:55:33.465356
Tags: 2018od4a-video, buildings, compliance, dob, facades, filings, now

Tables

Table 1

@usgov.city_of_new_york_dob_now_safety_facades_compliance_filings.table_1

4.87 MB
76989 rows
36 columns


CREATE TABLE table_1 (
  "tr6_no" VARCHAR,
  "control_no" BIGINT,
  "filing_type" VARCHAR,
  "cycle" BIGINT,
  "bin" BIGINT,
  "house_no" VARCHAR,
  "street_name" VARCHAR,
  "borough" VARCHAR,
  "block" BIGINT,
  "lot" BIGINT,
  "sequence_no" VARCHAR,
  "submitted_on" TIMESTAMP,
  "current_status" VARCHAR,
  "qewi_name" VARCHAR,
  "qewi_bus_name" VARCHAR,
  "qewi_bus_street_name" VARCHAR,
  "qewi_city" VARCHAR,
  "qewi_state" VARCHAR,
  "qewi_zip" VARCHAR,
  "qewi_nys_lic_no" VARCHAR,
  "owner_name" VARCHAR,
  "owner_bus_name" VARCHAR,
  "owner_bus_street_name" VARCHAR,
  "owner_city" VARCHAR,
  "owner_zip" VARCHAR,
  "owner_state" VARCHAR,
  "filing_date" VARCHAR,
  "filing_status" VARCHAR,
  "prior_cycle_filing_date" VARCHAR,
  "prior_status" VARCHAR,
  "field_inspection_completed_date" VARCHAR,
  "qewi_signed_date" VARCHAR,
  "late_filing_amt" DOUBLE,
  "failure_to_file_amt" DOUBLE,
  "failure_to_collect_amt" DOUBLE,
  "comments" VARCHAR
);