From a 500-row sample across 27 columns.
violationidhouse_numonstname+2contractbblidbblid| broken | cb | certi_date | contract | entrydate | flag | frstname | grace_pd | house_num | onfrtocode | onstname | sq_feet |
|---|---|---|---|---|---|---|---|---|---|---|---|
| X | 10 | 2016-05-23T00:00:00.000 | HWS2016M | 2016-05-13T06:30:00.000 | X | 7 AVENUE | 45 | 170 | 136490110610124690 | WEST 136 STREET | 470 |
| — | 12 | 1996-05-15T00:00:00.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
broken | categorical | The sidewalk is broken at this location. | 26% | X/0of 4 |
cb | integer | The New York City Community Board number. | 0% | 1213 |
certi_date | datetime | The date the property owner received the Notice of Violation in the mail via certified return receipt. | 36% | 2100-01-01T00:00:00.0001997-04-15T00:00:00.0001999-05-28T00:00:00.000 |
contract | text | This field identifies the Prior Notice contract number for performed sidewalk repairs. | 1% | HWS98K |
GET /api/datasets/6kbp-uz6m GET /api/datasets/6kbp-uz6m/quality GET /api/datasets/6kbp-uz6m/related GET /api/columns?dataset=6kbp-uz6m
| HWS93X |
| — |
| — |
| LACONIA AVENUE |
| 45 |
| 1027 |
| 228050257320245020 |
| EAST 214 STREET |
| 10 |
| X | 1 | 2024-06-24T00:00:00.000 | HWS2024K | 2024-06-11T06:30:00.000 | — | METROPOLITAN AVENUE | 75 | 258 | 318630360530365930 | BEDFORD AVENUE | 1789 |
| — | 7 | — | HWQS020 | — | — | 127 STREET | 45 | 127-01 | 406940421740421790 | 23 AVENUE | 335 |
| X | 15 | — | HWS2020K | 2020-12-31T06:30:00.000 | — | WEST 8 STREET | 75 | — | 314680390880390930 | AVENUE V | 132 |
| X | 12 | 1993-05-10T00:00:00.000 | HWKS027 | — | — | 36 STREET | 45 | 3616 | 306480308380308430 | 14 AVENUE | 333 |
| X | 11 | 2012-08-27T00:00:00.000 | HWS2012QC | 2012-08-23T06:10:00.000 | — | GCP WB ENTRANCE LITTLE NECK PKWY | 45 | 25111 | 447390412210427235 | GRAND CENTRAL PARKWAY | 160 |
| X | 1 | 2016-05-27T00:00:00.000 | HWS2016Q | 2016-05-17T06:30:00.000 | — | 25 AVENUE | 45 | 25-86 | 409890407240407540 | 43 STREET | 70 |
| X | 4 | 2013-07-23T00:00:00.000 | HWS2013Q | 2013-07-17T06:30:00.000 | X | 42 AVENUE | 45 | 4127 | 419540409690456690 | 102 STREET | 1370 |
| X | 5 | 2004-03-10T00:00:00.000 | HWS2003Q | — | — | 80 AVENUE | 45 | 8022 | — | 62 STREET | 130 |
Showing 12 of 25 columns. All of them are listed below.
HWKS027HWS98Mentrydate | datetime | The date of the record entry generated by the system. | 47% | 2019-05-24T06:30:00.0002019-09-30T06:30:00.0002010-12-03T06:10:00.000 |
flag | categorical | To determine if this is a freestanding flag. | 81% | Xxof 2 |
frstname | text | The cross street where sidewalk violation was found. | 0% | BEND5 AVENUEBEDFORD AVENUE |
grace_pd | integer | The number of days from property owner receipt of violation until the City can perform sidewalk repairs. | 0% | 457510 |
hardware | categorical | To determine if there are any defective hardware on a sidewalk. | 95% | X`of 2 |
house_num | text | The house number of the address where the violation was issued. | 2% | 152040 |
integrity | categorical | To determine if a sidewalk flag has a structural integrity issue. | 92% | Xx.of 3 |
onfrtocode | text | A combination of unique identifiers assigned to the On, From, and To streets. | 13% | 220020226730226760543190532600570251464290407240407540 |
onstname | text | The street name where the violation was found. | 0% | BROADWAYMYRTLE AVENUEJAMAICA AVENUE |
other_def | text | To determine whether other sidewalk defects are present at the property. | 80% | 6A-STRUCTURAL INTEGRITY6E-ASPHALT6A STRUCTURAL INTEGRITY |
patchwork | categorical | To determine if the defective sidewalk was patched. | 48% | Xxof 2 |
post_date | datetime | The date the Notice of Violation was posted to the taxlot where defective sidewalk was found. | 69% | 2100-01-01T00:00:00.0002024-03-28T00:00:00.0002010-05-19T00:00:00.000 |
slope | categorical | To determine if improper slope or pitch of sidewalk exist. | 85% | Xxof 2 |
sq_feet | integer | The total defective in sq. ft. of sidewalk. | 0% | 5025100 |
sw_missing | text | Determination if there is missing sidewalk. | 98% | Xof 1 |
swv_number | integer | The violation number issued to the property owner that is in ascending order for each borough. | 0% | 18215432622323 |
tostname | text | The closest cross street where sidewalk violation was found. | 1% | BROADWAYBENDNOSTRAND AVENUE |
trip_haz | categorical | To determine if there is a trip hazard/deflection/hole at sidewalk. | 33% | Xx.of 3 |
undermined | text | To determine if any undermined condition or visible void exist at sidewalk. | 86% | Xof 1 |
vdismissdate | datetime | The date of the violation dismissal. | 43% | 2100-01-01T00:00:00.0002010-02-05T00:00:00.0002009-04-23T00:00:00.000 |
violationid | integer | A sequential count for the sidewalk violations. | 0% | 141747165443201395 |
vissuedate | datetime | The date the violation was issued. | 0% | 1993-08-30T00:00:00.0001993-04-29T00:00:00.0001993-03-10T00:00:00.000 |
bblid | integer | 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. | 0% | 1426374473136 |