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

About this Dataset

Sidewalk Correspondences

Tracks all written correspondences to the Sidewalk Program.
Organization: City of New York
Last updated: 2020-11-10T17:01:59.437430
Tags: complaints, correspondence, expedite, repair, sidewalk, sim

Tables

Table 1

@usgov.city_of_new_york_sidewalk_correspondences.table_1

1.49 MB
21476 rows
27 columns


CREATE TABLE table_1 (
  "date_received" TIMESTAMP,
  "borough" VARCHAR,
  "block" VARCHAR,
  "lot" VARCHAR,
  "class" VARCHAR,
  "community_board" VARCHAR,
  "violation" VARCHAR,
  "osm" VARCHAR,
  "ccu" VARCHAR,
  "sim" VARCHAR,
  "bc" VARCHAR,
  "other_log" VARCHAR,
  "issue" VARCHAR,
  "address" VARCHAR,
  "cross_streets" VARCHAR,
  "referred_routed_to" VARCHAR,
  "resoultion" VARCHAR,
  "date_closed" VARCHAR,
  "results_of_inspection" VARCHAR,
  "postcode" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "council_district" DOUBLE,
  "census_tract" DOUBLE,
  "bin" DOUBLE,
  "bbl" DOUBLE,
  "nta" VARCHAR
);