About this Dataset

DOB NOW Elevator Safety Compliance

This data set includes elevator inspection and report filing information through the New York City Department of Buildings' DOB NOW: Elevator Compliance Filings module. The data is collected because the Department of Buildings tracks elevator inspection information.This data include items such as device number, device status, report filing dates, inspetion dates, BIN, and other location information.
Organization: City of New York
Last updated: 2023-06-04T03:18:48.544503
Tags: compliance, device, dob, elevator, safety

Tables

Table 1

@usgov.city_of_new_york_dob_now_elevator_safety_compliance.table_1

4.69 MB
118,314 rows
24 columns

CREATE TABLE table_1 (
  "device_number" VARCHAR,
  "device_type" VARCHAR,
  "device_status" VARCHAR,
  "status_date" TIMESTAMP,
  "equipment_type" VARCHAR,
  "periodic_report_year" DOUBLE,
  "cat1_report_year" DOUBLE,
  "cat1_latest_report_filed_date" TIMESTAMP,
  "cat5_latest_report_filed_date" TIMESTAMP,
  "periodic_latest_inspection_date" TIMESTAMP,
  "bin" DOUBLE,
  "borough" VARCHAR,
  "house_number" VARCHAR,
  "street_name" VARCHAR,
  "block" BIGINT,
  "lot" BIGINT,
  "postcode" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "community_board" DOUBLE,
  "council_district" DOUBLE,
  "bbl" DOUBLE,
  "census_tract_2020" DOUBLE  -- Census Tract (2020),
  "neighborhood_tabulation_area_nta_2020" VARCHAR  -- Neighborhood Tabulation Area (NTA) (2020)
);