About this Dataset

Commissioner's Correspondence

DOT receives, tracks, and responds to correspondences sent to the Commissioner's Correspondence Unit (CCU) and Borough Commissioner’s (BC) offices. This includes some requests initially sent to 311 and the Mayor's Office, and then forwarded to DOT.
Organization: City of New York
Last updated: 2020-11-10T17:01:56.700981
Tags: 311, art, arts, correspondence, customer-service, email, letter, mail

Tables

Table 1

@usgov.city_of_new_york_commissioners_correspondence.table_1

29.38 MB
646,496 rows
49 columns

CREATE TABLE table_1 (
  "createddate" TIMESTAMP,
  "casenumber" VARCHAR,
  "seibelnumber" VARCHAR,
  "mayorsnumber" VARCHAR,
  "casechannel" VARCHAR,
  "casetopic" VARCHAR,
  "caseissue" VARCHAR,
  "caseaddressedto" VARCHAR,
  "clienttype" VARCHAR,
  "clientcompanyname" VARCHAR,
  "translationneeded" VARCHAR,
  "pressname" VARCHAR,
  "initialtranslation" VARCHAR,
  "acknowledgetranslation" VARCHAR,
  "nativelanguage" VARCHAR,
  "coordinator" VARCHAR,
  "closeouttranslation" VARCHAR,
  "acknowledgesent" VARCHAR,
  "locationtype" VARCHAR,
  "locationdetail" VARCHAR,
  "borough" VARCHAR,
  "buildingnumber" VARCHAR,
  "streetname" VARCHAR,
  "fromstreet" VARCHAR,
  "crossstreet" VARCHAR,
  "bridgename" VARCHAR,
  "bridgedirection" VARCHAR,
  "otherbridgename" VARCHAR,
  "highwayname" VARCHAR,
  "directionname" VARCHAR,
  "segmentorexit" VARCHAR,
  "ferrydirection" VARCHAR,
  "ferrydatetime" VARCHAR,
  "facilityname" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "maplocation" VARCHAR,
  "communitydistrict" VARCHAR,
  "policeprecinct" VARCHAR,
  "xcoordinate" DOUBLE,
  "ycoordinate" DOUBLE,
  "zipcode" DOUBLE,
  "category" VARCHAR,
  "externaltrackingnumber" VARCHAR,
  "status" VARCHAR,
  "resolutionreason" VARCHAR,
  "closeddate" TIMESTAMP,
  "businessname" VARCHAR,
  "businessid" VARCHAR
);