Name: Sidewalk Dismissal Inspection Tracking
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Sidewalk Dismissal Inspection Tracking

Tracks dismissal inspection requests and results from property owners who repairs their sidewalk privately.
Organization: City of New York
Last updated: 2020-11-10T17:04:30.659232
Tags: dismissal, inspection, sidewalks, violations

Tables

Table 1

@usgov.city_of_new_york_sidewalk_dismissal_inspection_tracking.table_1

4.88 MB
69,930 rows
29 columns

CREATE TABLE table_1 (
  "sr" VARCHAR  -- SR#,
  "request_date" VARCHAR,
  "site_street_address" VARCHAR,
  "borocode" DOUBLE,
  "community_board" DOUBLE,
  "block" DOUBLE,
  "lot" DOUBLE,
  "violation" DOUBLE  -- Violation#,
  "permit" VARCHAR  -- Permit#,
  "homeowner_contractor" VARCHAR,
  "attempt" DOUBLE  -- Attempt#,
  "violation_issue_date" VARCHAR,
  "assigned_date" VARCHAR,
  "inspection_date" TIMESTAMP,
  "pass_fail" VARCHAR,
  "reason_for_failure" VARCHAR,
  "car_needed_y_n" VARCHAR  -- CAR Needed (Y/N),
  "date_results_are_mailed" VARCHAR,
  "expedited" VARCHAR,
  "vdd" TIMESTAMP,
  "postcode" DOUBLE,
  "borough" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "council_district" DOUBLE,
  "bin" DOUBLE,
  "bbl" DOUBLE,
  "census_tract_2020" DOUBLE  -- Census Tract (2020),
  "neighborhood_tabulation_area_nta_2020" VARCHAR  -- Neighborhood Tabulation Area (NTA) (2020)
);