From a 500-row sample across 24 columns.
blockpostcodelotnovcodenovnumberHas borough codes (`boro`) — joinable, but needs boundary shapes to draw.
| complaintid | srnumber | complainttype | boro | block | lot | number | street | city | state | postcode | initialinspectiondate |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 10039 | 1684652914 | Defacement | Queens | 6682 | 52 | 14719 | 75TH AVE. | FLUSHING | NY | 11367-2931 | 2019-02-25T00:00:00.000 |
| 12818 | 311-02157300 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
complaintid | text | — | 0% | 1060217037778 |
srnumber | text | — | 0% | 311-18671622311-006985981735927143 |
complainttype | text | — | 0% | DefacementEncroachmentATM |
boro | categorical | — | 0% | QueensBrooklynBronxof 5 |
block | text |
GET /api/datasets/kyvb-rbwd GET /api/datasets/kyvb-rbwd/quality GET /api/datasets/kyvb-rbwd/related GET /api/columns?dataset=kyvb-rbwd
statecity| Defacement |
| Brooklyn |
| 6260 |
| 19 |
| 1730 |
| 78TH ST. |
| BROOKLYN |
| NY |
| 11214-1129 |
| 2020-03-18T00:00:00.000 |
| 10697 | 1737992158 | Defacement | Queens | 9393 | 6 | 10914 | ATLANTIC AVE. | JAMAICA | NY | 11419-1025 | 2019-06-24T00:00:00.000 |
| 1004 | 048159731 | Defacement | Brooklyn | 6035 | 6 | 402 | 85 STREET | BROOKLYN | NY | 11209 | 2014-12-26T00:00:00.000 |
| 10040 | 1686009191 | Defacement | Bronx | 3965 | 18 | 2280 | LYON AVE. | BRONX | NY | 10462-4956 | 2019-03-25T00:00:00.000 |
| 10041 | 1684652956 | Defacement | Queens | 6682 | 54 | 14715 | 75TH AVE. | FLUSHING | NY | 11367-2931 | 2019-03-25T00:00:00.000 |
| 10042 | 1687005071 | Defacement | Brooklyn | 4659 | 12 | 156 | E. 54TH ST. | BROOKLYN | NY | 11203-3656 | 2019-03-06T00:00:00.000 |
| 10043 | 1685667351 | Defacement | Brooklyn | 6647 | 72 | 1751 | W. 10TH ST. | BROOKLYN | NY | 11223-1148 | 2019-03-05T00:00:00.000 |
| 10044 | 1685656821 | Defacement | Brooklyn | 6647 | 71 | 1753 | W. 10TH ST. | BROOKLYN | NY | 11223-1148 | 2019-03-05T00:00:00.000 |
| 10045 | 1686973911 | Defacement | Staten Island | 5491 | 282 | 523 | LEVERETT AVE. | STATEN ISLAND | NY | 10308-1920 | 2019-02-27T00:00:00.000 |
Showing 12 of 20 columns. All of them are listed below.
| — |
| 0% |
65369967848 |
lot | text | — | 0% | 14011 |
number | text | — | 0% | 252227521991 |
street | text | — | 0% | 38TH ST.WEST 15 STREETPARK AVENUE |
city | text | — | 0% | BROOKLYNJAMAICAFLUSHING |
state | text | — | 0% | NYof 1 |
postcode | text | — | 0% | 114191002111420 |
unit | text | — | 99% | 465 |
initialinspectiondate | datetime | — | 0% | 2019-06-12T00:00:00.0002015-09-22T00:00:00.0002018-07-10T00:00:00.000 |
initialinspectionresults | categorical | — | 0% | FailPassof 2 |
ordermailingdate | datetime | — | 16% | 2019-06-20T00:00:00.0002015-09-24T00:00:00.0002018-07-20T00:00:00.000 |
postinginspectiondate | text | — | 98% | 202406062019042620220215 |
followupinspectiondate | datetime | — | 16% | 2019-07-20T00:00:00.0002015-10-24T00:00:00.0002018-08-19T00:00:00.000 |
daysbetween | text | — | 0% | 30of 1 |
closeddate | datetime | — | 27% | 2017-12-29T00:00:00.0002016-09-24T00:00:00.0002016-06-23T00:00:00.000 |
reinspectiondate | datetime | — | 22% | 2017-12-29T00:00:00.0002016-09-24T00:00:00.0002019-06-02T00:00:00.000 |
reinspectionresult | categorical | — | 22% | PassFailof 2 |
novnumber | text | — | 78% | 206263540206244134206244280 |
novcode | categorical | — | 78% | D31DC2D30of 10 |
novdate | datetime | — | 78% | 2020-09-10T00:00:00.0002019-10-17T00:00:00.0002020-02-29T00:00:00.000 |
novdescription | categorical | — | 78% | Defacement of roadway, s…Unauthorized projections…Maintaining an unlawful …of 3 |