Landmarks Violations by US Government | Demographics and Population Studies

About this Dataset

Landmarks Violations

The Landmarks Violations contains information related to designated landmark violations issued by the LPC.
Organization: City of New York
Last updated: 2020-11-10T17:06:01.825842
Tags: complaints, landmarks, preservation, violations

Tables

Table 1

@usgov.city_of_new_york_landmarks_violations.table_1

370.72 KB
5191 rows
20 columns


CREATE TABLE table_1 (
  "lpc" VARCHAR,
  "landmark_name" VARCHAR,
  "street" VARCHAR,
  "street_name" VARCHAR,
  "boro" VARCHAR,
  "block" BIGINT,
  "lot" BIGINT,
  "vio_date" TIMESTAMP,
  "wl_date" TIMESTAMP,
  "nov_date" TIMESTAMP,
  "violation_text" VARCHAR,
  "status" VARCHAR,
  "rescended_date" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "community_board" VARCHAR,
  "council_district" DOUBLE,
  "bin" BIGINT,
  "nta" VARCHAR,
  "postcode" DOUBLE
);