From a 500-row sample across 20 columns.
blocklandmark_namelot+7blockstreetlot+4latitudelongitudecommunity_board+4latitudelongitudecommunity_board+3Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| lpc | landmark_name | street | street_name | boro | block | lot | vio_date | wl_date | nov_date | violation_class | rescinded |
|---|---|---|---|---|---|---|---|---|---|---|---|
| VIO-15-0012 | Crown Heights North - Historic District | 1156 | Dean Street | BROOKLYN | 1212 | 24 | 2014-07-08T00:00:00.000 | 2014-07-08T00:00:00.000 | 2014-09-10T00:00:00.000 | Painting base of building without permit(s). | Active |
| VIO-15-0013 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
lpc | text | Internal LPC identifier | 0% | VIO-15-0681VIO-24-0200VIO-15-0279 |
landmark_name | text | Landmarks Preservation Commission designation name of the Historic District or Individual Landmark for the property where the violation occurred | 0% | Greenwich Village - Hist…Jackson Heights - Histor…Upper West Side/Central … |
street | text | Numerical address for the violation property | 0% | 1352 |
street_name | text | Street name for the violation property | 0% |
GET /api/datasets/wycc-5aqt GET /api/datasets/wycc-5aqt/quality GET /api/datasets/wycc-5aqt/related GET /api/columns?dataset=wycc-5aqt
blocklotlatitude+4latitudelongitudecommunity_board+4blocklotbin+1blocklotlatitude+5| Crown Heights North - Historic District |
| 1156 |
| Dean Street |
| BROOKLYN |
| 1212 |
| 24 |
| 2014-07-08T00:00:00.000 |
| 2014-07-08T00:00:00.000 |
| 2019-12-24T00:00:00.000 |
| Installation of security cameras, conduits and light fixtures without permit(s). |
| Active |
| VIO-15-0014 | Bedford Stuyvesant/Expanded Stuyvesant Heights - Historic District | 317 | Decatur Street | BROOKLYN | 1676 | 76 | 2014-07-08T00:00:00.000 | 2014-07-08T00:00:00.000 | — | Installation of bracket sign without permit(s). | Rescinded |
| VIO-15-0011 | Bedford Stuyvesant/Expanded Stuyvesant Heights - Historic District | 382 | Macon Street | BROOKLYN | 1669 | 31 | 2014-07-08T00:00:00.000 | 2014-07-08T00:00:00.000 | 2014-09-05T00:00:00.000 | Installation of exhaust duct in areaway without permit(s). | Rescinded |
| VIO-15-0016 | Crown Heights North II - Historic District | 901 | Sterling Place | BROOKLYN | 1241 | 59 | 2014-07-08T00:00:00.000 | 2014-07-08T00:00:00.000 | 2014-09-05T00:00:00.000 | Installation of exhaust vent at areaway without permit(s). | Active |
| VIO-15-0015 | Crown Heights North - Historic District | 1201 | Bergen Street | BROOKLYN | 1214 | 65 | 2014-07-08T00:00:00.000 | 2014-07-08T00:00:00.000 | 2015-09-16T00:00:00.000 | Resurfacing stoop and base of building without permit(s). | Active |
| VIO-15-0017 | Clinton Hill - Historic District | 103 | St. James Place | BROOKLYN | 1964 | 24 | 2014-07-09T00:00:00.000 | 2014-07-09T00:00:00.000 | — | Ongoing resetting of bluestone sidewalk without permit(s). | Rescinded |
| VIO-15-0018 | Clinton Hill - Historic District | 103 | St. James Place | BROOKLYN | 1964 | 24 | 2014-07-09T00:00:00.000 | 2014-07-09T00:00:00.000 | — | Replacement of areaway paving without permit(s). | Rescinded |
| VIO-15-0019 | Clinton Hill - Historic District | 103 | St. James Place | BROOKLYN | 1964 | 24 | 2014-07-09T00:00:00.000 | 2014-07-09T00:00:00.000 | — | Installation of garbage enclosure and light fixture without permit(s). | Rescinded |
| VIO-15-0021 | Clinton Hill - Historic District | 219 | Clinton Avenue | BROOKLYN | 1916 | 32 | 2014-07-11T00:00:00.000 | 2014-07-14T00:00:00.000 | 2015-09-16T00:00:00.000 | Replacement of parlor floor entrance transom window without permit(s). | Active |
Showing 12 of 20 columns. All of them are listed below.
Broadway37th AvenueHalsey Streetboro | categorical | Borough for the violation property. | 0% | MANHATTANBROOKLYNQUEENSof 6 |
block | text | Tax block for the violation property | 0% | 13195037590 |
lot | text | Tax lot for the violation property | 0% | 1750115 |
vio_date | datetime | Date the violation was issued; date the violation was issued, esp those before FY 1999 | 0% | 2014-12-17T00:00:00.0002016-05-03T00:00:00.0002015-11-05T00:00:00.000 |
wl_date | datetime | Notice of violation date of issue; date the WL was issued, esp those starting FY1999- present | 1% | 2014-12-17T00:00:00.0002016-05-03T00:00:00.0002015-11-05T00:00:00.000 |
nov_date | datetime | Notice of violation date of issue | 22% | 2020-07-10T00:00:00.0002019-03-04T00:00:00.0002016-07-01T00:00:00.000 |
violation_class | text | Text (as issued) of each violation | 0% | Replacement of windows w…Installation of security…Installation of garbage … |
rescinded | categorical | Violation status, Active or Rescinded | 0% | RescindedActiveof 2 |
rescended_date | datetime | Date the violation was rescinded | 44% | 2024-12-09T00:00:00.0002024-10-07T00:00:00.0002024-12-11T00:00:00.000 |
latitude | float | Latitude of the building's location | 0% | 40.8242488082383540.73315834046806640.74034952827405 |
longitude | float | Longitude of the building's location | 0% | -73.94528913437779-73.97108449608857-73.93821323054166 |
community_board | text | New York City Community Board where the building is located | 0% | MN-02BK-02BK-03 |
community_district | text | New York City Council District where the building is located | 0% | 030136 |
bin | text | BIN of building | 0% | 108065730590781061002 |
nta | text | The Neighborhood Tabulation Area (NTA) field indicates the New York City Neighborhood area where the building is located | 25% | West VillageSoHo-TriBeCa-Civic Cente…Crown Heights North |
postcode | text | Postcode where the building is located | 0% | 100141121610013 |