From a 500-row sample across 18 columns.
ntacommunity_boardbin+7ntacommunity_boardbin+3boroughcommunity_boardbin+5ntacommunity_boardbin+3Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| complaint | date | address | street_name | borough | block | lot | bin | postcode | landmark_name | work_reported | action_taken |
|---|---|---|---|---|---|---|---|---|---|---|---|
| CMP-15-00005 | 2014-07-01T00:00:00.000 | 903 | Sterling Place | Brooklyn | 1241 | 58 | 3031568 | 11216 | Crown Heights North II - Historic District | painting base of building without permits | Warning Letter Issued |
| CMP-15-00004 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
complaint | text | Internal LPC identifier | 0% | CMP-19-00379CMP-24-00247CMP-18-00427 |
date | datetime | Date the complaint was received | 0% | 2014-12-03T00:00:00.0002015-12-28T00:00:00.0002015-10-21T00:00:00.000 |
address | text | Numerical address for the complaint property | 0% | 11415 |
street_name | text | Street name for the complaint property | 0% | BroadwayBROADWAY37TH AVENUE |
GET /api/datasets/ck4n-5h6x GET /api/datasets/ck4n-5h6x/quality GET /api/datasets/ck4n-5h6x/related GET /api/columns?dataset=ck4n-5h6x
boroughcommunity_boardbin+4boroughcommunity_boardbin+4ntaboroughcommunity_board+5binlotblock| 2014-07-01T00:00:00.000 |
| 93 |
| St. Johns Place |
| Brooklyn |
| 945 |
| 77 |
| 3019314 |
| 11217 |
| Park Slope - Historic District |
| work being done; working on building façade |
| No Warning Letter Issued |
| CMP-15-00003 | 2014-07-01T00:00:00.000 | 131 | East 65th Street | Manhattan | 1400 | 113 | 1042450 | 10065 | Upper East Side - Historic District | Construction of rear yard addition without permits; photographs with complaint file | Warning Letter Issued |
| CMP-15-00002 | 2014-07-01T00:00:00.000 | 1156 | Dean Street | Brooklyn | 1212 | 24 | 3030313 | 11216 | Crown Heights North - Historic District | Painting front walls | Warning Letter Issued |
| CMP-15-00001 | 2014-07-01T00:00:00.000 | 180 | 10th Avenue | Manhattan | 718 | 7502 | 1088996 | 10011 | Chelsea - Historic District | Installation of bar on patio | No Warning Letter Issued |
| CMP-15-00006 | 2014-07-03T00:00:00.000 | 466 | Broome Street | Manhattan | 485 | 40 | 1007280 | 10013 | SoHo-Cast Iron - Historic District | Installation illumination at periphery of window | Warning Letter Issued |
| CMP-15-00009 | 2014-07-07T00:00:00.000 | 71 | West 12th Street | Manhattan | 576 | 76 | 1009634 | 10011 | Greenwich Village - Historic District | Interior demolition without permits | No Warning Letter Issued |
| CMP-15-00007 | 2014-07-07T00:00:00.000 | 369 | Greenwich Street | Manhattan | 181 | 13 | 1002072 | 10013 | Tribeca West - Historic District | installation of platform at sidewalk café | Warning Letter Issued |
| CMP-15-00008 | 2014-07-07T00:00:00.000 | 568 | Hancock Street | Brooklyn | 1660 | 38 | 3046079 | 11233 | Bedford Stuyvesant/Expanded Stuyvesant Heights - Historic District | Stuccoing over bay, windows in noncompliance, cornice in noncompliance | Warning Letter Issued |
| CMP-15-00010 | 2014-07-08T00:00:00.000 | 41 | Commerce Street | Manhattan | 584 | 58 | 1009848 | 10014 | Greenwich Village - Historic District | Installation of HVAC equipment without permits--visible from Barrow Street | Warning Letter Issued |
Showing 12 of 18 columns. All of them are listed below.
borough | categorical | Borough for the complaint property. The Borough field is expressed as a two character abbreviation (MN=Manhattan, BX=Bronx, BK=Brooklyn, QN=Queens, and SI=Staten Island) | 0% | ManhattanMANHATTANBROOKLYNof 11 |
block | text | Block of complaint property. | 0% | 5752050590 |
lot | text | Lot of complaint property. | 0% | 1750122 |
bin | text | The BIN (Building Identification Number) is a unique identifier for each building in the City | 0% | 300000031826451000000 |
postcode | integer | Zip code | 1% | 100141120110011 |
landmark_name | text | Landmarks Preservation Commission Historic District name in which the violation took place. | 6% | Greenwich Village - Hist…Jackson Heights - Histor…Upper West Side/Central … |
work_reported | text | Work reported by the complainant | 0% | Replacement of windowsInstallation of signagePossible FTM |
action_taken | categorical | Action taken on complaint. | 1% | Warning Letter IssuedNo Warning Letter IssuedViolation Issuedof 3 |
status | categorical | Status of complaint as open or closed. | 0% | ClosedOpenof 2 |
community_council | text | The Council District field indicates the New York City Council District where the building is located | 0% | 030136 |
community_board | text | The Community District field indicates the New York City Community District where the building is located | 1% | MN-02BK-02MN-07 |
nta | text | The Neighborhood Tabulation Area field indicates the New York City Neighborhood area where the building is located | 40% | West VillageSoHo-TriBeCa-Civic Cente…Crown Heights North |
latitude | float | Latitude of the building's location | 0% | 40.6105638790230640.6990710762582940.73347141415002 |
longitude | float | Longitude of the building's location | 0% | -73.95151498381698-73.99224262979689-74.00119433524974 |