From a 500-row sample across 24 columns.
device_numberlothouse_number+5lotbinviolation_type+1lotboroughbin+5bincouncil_districtbbl+3Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| bin | violation_issue_date | violation_number | violation_type | violation_remarks | violation_status | device_type | borough | block | lot | house_number | street |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1054869 | 2026-10-08T00:00:00.000 | VIO-FTF-EN-2025LL97321-202612-0000305 | FTF-EN-LL97321 | FAILURE TO FILE A COMPLIANCE REPORT AS REQUIRED BY AD CODE SEC. 28-321.3 IN ACCORDANCE WITH 1 RCNY § 103-17(B). | Active | GHG Emissions - LL97 | Manhattan | 1807 | 30 | 438 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
bin | text | Building Identification Number assigned by Department of City Planning | 0% | 103538133475322096863 |
violation_issue_date | datetime | The date of violation issuance | 0% | 2023-10-23T00:00:00.0002023-06-30T00:00:00.0002023-06-20T00:00:00.000 |
violation_number | text | The violation identifier | 0% | 081512EACC100968100810VCAT101922100112EVCAT100579 |
violation_type | text | The type of violation issued | 0% | LBLVIO |
GET /api/datasets/855j-jady GET /api/datasets/855j-jady/quality GET /api/datasets/855j-jady/related GET /api/columns?dataset=855j-jady
house_numberbincouncil_district+4lotbincouncil_district+6lotbincouncil_district+5lotboroughhouse_number+7| EAST 120 STREET |
| 3327327 | 2026-10-08T00:00:00.000 | VIO-FTF-EN-2025LL97321-202612-0000545 | FTF-EN-LL97321 | FAILURE TO FILE A COMPLIANCE REPORT AS REQUIRED BY AD CODE SEC. 28-321.3 IN ACCORDANCE WITH 1 RCNY § 103-17(B). | Active | GHG Emissions - LL97 | Brooklyn | 5240 | 1 | 1204 | OCEAN AVENUE |
| 1046419 | 2026-10-08T00:00:00.000 | VIO-FTF-EN-2025LL97321-202612-0000285 | FTF-EN-LL97321 | FAILURE TO FILE A COMPLIANCE REPORT AS REQUIRED BY AD CODE SEC. 28-321.3 IN ACCORDANCE WITH 1 RCNY § 103-17(B). | Active | GHG Emissions - LL97 | Manhattan | 1490 | 28 | 542 | EAST 79 STREET |
| 1074257 | 2026-10-08T00:00:00.000 | VIO-FTF-EN-2025LL97321-202612-0000296 | FTF-EN-LL97321 | FAILURE TO FILE A COMPLIANCE REPORT AS REQUIRED BY AD CODE SEC. 28-321.3 IN ACCORDANCE WITH 1 RCNY § 103-17(B). | Active | GHG Emissions - LL97 | Manhattan | 1637 | 28 | 169 | EAST 109 STREET |
| 2016026 | 2026-10-08T00:00:00.000 | VIO-FTF-EN-2025LL97321-202612-0000429 | FTF-EN-LL97321 | FAILURE TO FILE A COMPLIANCE REPORT AS REQUIRED BY AD CODE SEC. 28-321.3 IN ACCORDANCE WITH 1 RCNY § 103-17(B). | Active | GHG Emissions - LL97 | Bronx | 3263 | 104 | 3855 | ORLOFF AVENUE |
| 3018357 | 2026-10-08T00:00:00.000 | VIO-FTF-EN-2025LL97321-202612-0000476 | FTF-EN-LL97321 | FAILURE TO FILE A COMPLIANCE REPORT AS REQUIRED BY AD CODE SEC. 28-321.3 IN ACCORDANCE WITH 1 RCNY § 103-17(B). | Active | GHG Emissions - LL97 | Brooklyn | 925 | 42 | 4220 | 9 AVENUE |
| 2049475 | 2026-10-08T00:00:00.000 | VIO-FTF-EN-2025LL97321-202612-0000542 | FTF-EN-LL97321 | FAILURE TO FILE A COMPLIANCE REPORT AS REQUIRED BY AD CODE SEC. 28-321.3 IN ACCORDANCE WITH 1 RCNY § 103-17(B). | Active | GHG Emissions - LL97 | Bronx | 4324 | 1 | 2126 | MULINER AVENUE |
| 3173770 | 2026-10-08T00:00:00.000 | VIO-FTF-EN-2025LL97321-202612-0000498 | FTF-EN-LL97321 | FAILURE TO FILE A COMPLIANCE REPORT AS REQUIRED BY AD CODE SEC. 28-321.3 IN ACCORDANCE WITH 1 RCNY § 103-17(B). | Active | GHG Emissions - LL97 | Brooklyn | 6587 | 17 | 1416 | OCEAN PARKWAY |
| 2015344 | 2026-10-08T00:00:00.000 | VIO-FTF-EN-2025LL97321-202612-0000426 | FTF-EN-LL97321 | FAILURE TO FILE A COMPLIANCE REPORT AS REQUIRED BY AD CODE SEC. 28-321.3 IN ACCORDANCE WITH 1 RCNY § 103-17(B). | Active | GHG Emissions - LL97 | Bronx | 3249 | 120 | 125 | WEST 195 STREET |
| 2009716 | 2026-10-08T00:00:00.000 | VIO-FTF-EN-2025LL97321-202612-0000409 | FTF-EN-LL97321 | FAILURE TO FILE A COMPLIANCE REPORT AS REQUIRED BY AD CODE SEC. 28-321.3 IN ACCORDANCE WITH 1 RCNY § 103-17(B). | Active | GHG Emissions - LL97 | Bronx | 2931 | 98 | 605 | EAST 169 STREET |
Showing 12 of 22 columns. All of them are listed below.
FTC-AEU-HAZLL6291violation_remarks | text | Note recorded about the violation | 45% | VIOLATION ISSUED FOR FAI…VIOLATION ISSUED-FAILURE…VIOLATION ISSUED-FAILURE… |
violation_status | categorical | The status of the violation | 0% | ActiveDismissedDisputed Successfullyof 7 |
device_number | text | The devices identification number | 76% | 1P72871P103931F4871 |
device_type | categorical | The specific type of device | 0% | BoilerElevatorsAEUHAZof 15 |
cycle_end_date | datetime | The end date of the compliance cycle | 34% | 2022-12-31T00:00:00.0002024-12-31T00:00:00.0002023-12-31T00:00:00.000 |
borough | categorical | The borough where the violating condition was observed | 0% | BrooklynManhattanQueensof 5 |
block | integer | The block where the violating condition was observed | 0% | 128024505778 |
lot | integer | The lot where the violating condition was observed | 0% | 175017502 |
house_number | text | The address number where the violating condition was observed | 0% | 12100 |
street | text | The address name where the violating condition was observed | 0% | BROADWAY5 AVENUE3 AVENUE |
city | text | The city where the violating condition was observed | 0% | New Yorkof 1 |
state | text | The state where the violating condition was observed | 0% | New Yorkof 1 |
zip | text | The postal code where the violating condition was observed | 0% | 112011121111101 |
latitude | float | Latitude of the site's location | 0% | 40.75230140.64533840.753629 |
longitude | float | Longitude of the site's location | 0% | -73.978081-74.022864-73.884162 |
community_board | integer | Community Boards are volunteer-run neighborhood organizations that work on all kinds of issues pertinent to their communities, often working with elected city officials in doing so. Community Board members, who can be as young as 16, are appointed by Borough Presidents and City Council representatives. They serve two-year terms. There are 59 Community Boards in NYC, each of which represents a unique geographical area, known as a Community District. Note: as a column header, “Community Board” ( | 0% | 105301303 |
council_district | integer | The City Council is the lawmaking body of NYC, on equal footing with the mayor in terms of governing power. Besides legislating, the Council has sole approval power over the city budget, and is the final decision-maker in land use matters. There are 51 City Council members in total, each representing a unique geographical area, called a Council District. | 0% | 431 |
bbl | integer | The BBL (Borough, Block, and Lot) is a unique combination of three numeric codes - a 1-digit borough number, a block number (up to 5 digits) and a lot number (up to 4 digits) -- designated and modified by the Department of Finance (DOF). BBLs are used by various city agencies to identify real estate for taxes, zoning, construction, and other purposes. | 1% | 101280000130577800012026050040 |
census_tract_2020_ | integer | The Census Tract (Census 2020) field indicates the U.S. Census Tract where the site is located. Please note that as part of the geocoding process, leading and trailing zeros are dropped | 0% | 332139 |
neighborhood_tabulation_area_nta_2020_ | text | NTAs are small area boundaries, created by the Department of City Planning (DCP) to aggregate population projections in a small area.. Each NTA approximates a minimum population of 15,000. While NTAs were initially created to support PlaNYC, the thirty-year (2000-2030) sustainability plan for NYC, NTAs are now also being used to present data from the Decennial Census and American Community Survey. NTA boundaries and their associated names do not definitively represent neighborhood boundaries. | 0% | Midtown-Times SquareUpper East Side-Carnegie…Bedford-Stuyvesant (West… |