Sidewalk Dismissal Inspection Tracking by US Government | Demographics and Population Studies

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.66 MB
69930 rows
29 columns


CREATE TABLE table_1 (
  "sr" VARCHAR,
  "request_date" VARCHAR,
  "site_street_address" VARCHAR,
  "borocode" DOUBLE,
  "community_board" DOUBLE,
  "block" DOUBLE,
  "lot" DOUBLE,
  "violation" DOUBLE,
  "permit" VARCHAR,
  "homeowner_contractor" VARCHAR,
  "attempt" DOUBLE,
  "violation_issue_date" VARCHAR,
  "assigned_date" VARCHAR,
  "inspection_date" TIMESTAMP,
  "pass_fail" VARCHAR,
  "reason_for_failure" VARCHAR,
  "car_needed_y_n" VARCHAR,
  "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,
  "neighborhood_tabulation_area_nta_2020" VARCHAR
);