Sidewalk Management Database - Violations
Sidewalk Management System is used to track and organize inspections, violations and the status of New York City sidewalks. Identifies a Notice of Violation has been issued for a sidewalk defect. For more information please visit NYC DOT website: www.nyc.gov/sidewalks
Open in the graph · Relate this dataset · What these columns mean
Freshness
The publisher's promise
How the agency that publishes this data says it keeps the data current.
Due
- Says it updates
- Daily
- Actually updates about every
- 1 days
- Publisher last updated the data
- Oct 7, 2026
Our mirror
Whether our copy of this data is current with the source.
In sync
- We last synced
- Oct 7, 2026, 8:05 AM
- Rows in our copy
- 314,382
- Rows at the source
- 314,382
- Our copy trails the source by
- under a minute
Columns
Each source column, with the name and type we use to store it.
0 of 27 columns carry a concept; 27 carry a description from the publisher. Read the concept column before you join. A column with no concept carries no claim from us, and a name that looks like a key is not one.
| Source field | Display name | What the publisher says it is | Concept | Source type | Stored as | Stored type | Row identifier | Unit |
|---|---|---|---|---|---|---|---|---|
cb | CB | The New York City Community Board number. | Not bound | Number | cb | numeric | — | |
tostname | TOSTNAME | The closest cross street where sidewalk violation was found. | Not bound | Text | tostname | text | — | |
certi_date | CERTI_DATE | The date the property owner received the Notice of Violation in the mail via certified return receipt. | Not bound | Calendar date | certi_date | timestamp | — | |
swv_number | SWV_Number | The violation number issued to the property owner that is in ascending order for each borough. | Not bound | Number | swv_number | numeric | — | |
bblid | BBLID | The ID number assigned to a Borough-Block-Lot (BBL) value in the Lotinfo table; BBLID is an identifier for a BBL and should not be interpreted as the BBL itself. | Not bound | Number | bblid | numeric | — | |
entrydate | EntryDate | The date of the record entry generated by the system. | Not bound | Calendar date | entrydate | timestamp | — | |
sq_feet | SQ_FEET | The total defective in sq. ft. of sidewalk. | Not bound | Number | sq_feet | numeric | — | |
patchwork | PATCHWORK | To determine if the defective sidewalk was patched. | Not bound | Text | patchwork | text | — |
Download
This file was produced on Oct 7, 2026, 10:16 PM.
Refresh this dataset
Source and attribution
Where this data comes from, which version we hold, and what we changed.
- Source
- https://data.cityofnewyork.us/d/6kbp-uz6m
- Version
- Content hash:
24df4717886af303465a3ef90fec3bb43558b423e7c4a4f9b9528016746cc2c0 - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- Oct 7, 2026, 8:05 AM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Oct 7, 2026, 3:26 PM | full_replace | success | 314,382 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 6, 2026, 3:31 PM | full_replace | success | 314,382 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 2, 2026, 3:54 PM | full_replace | success | 314,382 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 1, 2026, 3:49 PM | full_replace | success | 314,307 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Sep 30, 2026, 3:39 PM | full_replace | success | 314,306 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Sep 29, 2026, 4:01 PM | full_replace | success | 314,282 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Sep 25, 2026, 3:24 PM | full_replace | success | 314,256 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Sep 23, 2026, 3:15 PM | full_replace | success | 314,197 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.83 |
| Sep 22, 2026, 4:01 PM | full_replace | success | 314,197 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.82 |
| Sep 19, 2026, 3:06 PM | full_replace | success | 314,197 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.82 |