From a 357-row sample across 11 columns.
bblbinbblbinHas cd codes (`community_board`) — joinable, but needs boundary shapes to draw.
| description | vac_date | bor | aka_address | community_board | community_council | bin | bbl | lst_compl_insp_date | status_change_date | ocpcy_desc |
|---|---|---|---|---|---|---|---|---|---|---|
| Dismissal | 1989-04-05T00:00:00.000 | BK | 495 DEKALB AVENUE, BK ;495 DE KALB AVENUE, BK ;247 FRANKLIN AVENUE, BK | 303 | 33 | 3055182 | 3019270005 | 2011-12-12T00:00:00.000 | 2011-12-19T00:00:00.000 | Residential |
| Dismissal | 1989-06-22T00:00:00.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
description | categorical | Status Description | 12% | DismissalRescindedof 2 |
vac_date | datetime | Date of Vacate Order | 0% | 2017-10-30T00:00:00.0002011-05-17T00:00:00.0002016-12-24T00:00:00.000 |
bor | categorical | Borough of vacated building | 0% | BXBKQNof 5 |
aka_address | text | Address of vacated building | 0% | 1302 FINDLAY AVENUE, BX669 JEFFERSON PLACE, BX |
GET /api/datasets/n5xc-7jfa GET /api/datasets/n5xc-7jfa/quality GET /api/datasets/n5xc-7jfa/related GET /api/columns?dataset=n5xc-7jfa
| QN |
| 86-47 126 STREET, QN |
| 409 |
| 29 |
| 4193935 |
| 4092800041 |
| 2012-02-23T00:00:00.000 |
| 2012-03-09T00:00:00.000 |
| Residential |
| Dismissal | 1989-08-30T00:00:00.000 | QN | 32-57 85 STREET, QN | 403 | 25 | 4034690 | 4014150051 | 2012-03-13T00:00:00.000 | 2012-04-10T00:00:00.000 | Residential |
| Dismissal | 1989-11-13T00:00:00.000 | BK | 686 GRAND STREET, BK | 301 | 34 | 3069586 | 3027881004 | 2012-03-13T00:00:00.000 | 2012-04-16T00:00:00.000 | Residential |
| Dismissal | 1990-05-21T00:00:00.000 | QN | 80-24 LEFFERTS BOULEVARD, QN | 409 | 29 | 4080118 | 4033530051 | 2012-02-24T00:00:00.000 | 2012-03-21T00:00:00.000 | Residential |
| Dismissal | 1990-08-21T00:00:00.000 | QN | 86-38 111 STREET, QN | 409 | 32 | 4192612 | 4092240023 | 2012-03-16T00:00:00.000 | 2012-03-21T00:00:00.000 | Residential |
| Dismissal | 1991-01-03T00:00:00.000 | BK | 1082 BUSHWICK AVENUE, BK | 304 | 34 | 3076531 | 3033480034 | 2015-02-12T00:00:00.000 | — | Residential |
| Dismissal | 1991-02-26T00:00:00.000 | BK | 212 LEFFERTS PLACE, BK | 303 | 36 | 3057881 | 3020200043 | 2013-04-11T00:00:00.000 | — | Residential |
| Dismissal | 1991-03-07T00:00:00.000 | BK | 719 BRISTOL STREET, BK | 316 | 42 | 3083058 | 3036420011 | 2012-02-15T00:00:00.000 | 2012-03-02T00:00:00.000 | Residential |
| Dismissal | 1991-09-26T00:00:00.000 | BX | 903 AVENUE SAINT JOHN, BX ;903 AVENUE ST JOHN, BX | 202 | 17 | 2005131 | 2026860016 | 2011-12-12T00:00:00.000 | — | Residential |
594 EAST 167 STREET, BXcommunity_board | integer | Community District of Vacated Building | 1% | 203209201 |
community_council | integer | Council District | 1% | 171816 |
bin | integer | BIN - Building Identification Number | 0% | 200715220252092004266 |
bbl | integer | BBL - Borough-Block-Lot | 0% | 202782015520261300222028890015 |
lst_compl_insp_date | datetime | Last completed Inspection Date | 1% | 2011-12-12T00:00:00.0002012-02-22T00:00:00.0002015-08-31T00:00:00.000 |
status_change_date | datetime | Status Change Date | 11% | 2012-03-21T00:00:00.0002013-03-09T13:34:08.0002018-02-09T00:00:00.000 |
ocpcy_desc | categorical | Occupancy Description - Building's function or use | 1% | ResidentialMercantileStorageof 9 |