From a 500-row sample across 13 columns.
community_boardboroughlotzip_code+3house_numberstreet_nameboroughboroughHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| month | cycle | borough | block | lot | tax_class_code | building_class | community_board | council_district | house_number | street_name | zip_code |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2019-04-17T00:00:00.000 | 90 Day Notice | 1 | 16 | 3 | 4 | Z9 | 101 | 1 | 401 | SOUTH END AVENUE | 10280 |
| 2019-04-17T00:00:00.000 | 90 Day Notice |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
month | datetime | Date report published | 0% | 2025-02-01T00:00:00.0002025-03-01T00:00:00.0002019-04-17T00:00:00.000of 19 |
cycle | categorical | Frequency of notification leading up to lien sale. Cycle consists of 90, 60, 30 and 10 Day Notices then Sale(1) and a subsequent Sale(2) | 0% | 90 Day Notice60 Day Notice30 Day Noticeof 9 |
borough | categorical | Borough: 1 = MANHATTAN, 2 = BRONX, 3 = BROOKLYN, 4 = QUEENS 5 = STATEN ISLAND | 0% | 342of 5 |
block | integer | Block | 0% |
GET /api/datasets/9rz4-mjek GET /api/datasets/9rz4-mjek/quality GET /api/datasets/9rz4-mjek/related GET /api/columns?dataset=9rz4-mjek
council_districtcommunity_boardlotzip_codecouncil_district+1boroughmonth| 1 |
| 17 |
| 1213 |
| 4 |
| RB |
| 101 |
| — |
| 50 |
| WEST STREET |
| 10006 |
| 2019-04-17T00:00:00.000 | 90 Day Notice | 1 | 17 | 1215 | 4 | RB | 101 | — | 50 | WEST STREET | 10006 |
| 2019-04-17T00:00:00.000 | 90 Day Notice | 1 | 18 | 1073 | 2 | R4 | 101 | 1 | 88 | GREENWICH STREET | 10006 |
| 2019-04-17T00:00:00.000 | 90 Day Notice | 1 | 18 | 1270 | 2 | R4 | 101 | 1 | 88 | GREENWICH STREET | 10006 |
| 2019-04-17T00:00:00.000 | 90 Day Notice | 1 | 26 | 1260 | 2 | R4 | 101 | 1 | 15 | BROAD STREET | 10005 |
| 2019-04-17T00:00:00.000 | 90 Day Notice | 1 | 26 | 1273 | 2 | R4 | 101 | 1 | 15 | BROAD STREET | 10005 |
| 2019-04-17T00:00:00.000 | 90 Day Notice | 1 | 27 | 1032 | 2 | R4 | 101 | 1 | 55 | WALL STREET | 10005 |
| 2019-04-17T00:00:00.000 | 90 Day Notice | 1 | 27 | 1040 | 2 | R4 | 101 | 1 | 55 | WALL STREET | 10005 |
| 2019-04-17T00:00:00.000 | 90 Day Notice | 1 | 29 | 23 | 4 | K4 | 101 | 1 | 79 | PEARL STREET | 10004 |
Showing 12 of 13 columns. All of them are listed below.
11010278273 |
lot | integer | Lot | 0% | 178 |
tax_class_code | categorical | Tax Class codes. Please consult data dictionary for more information on code definitions. | 0% | 124of 3 |
building_class | text | Type of building. Please consult downloadable data dictionary for more information on Building Class Types | 0% | C0B2B1 |
community_board | integer | New York City government community board. | 0% | 412305303 |
council_district | integer | Local Governing Council District | 1% | 374941 |
house_number | text | House Number | 4% | 870101161 |
street_name | text | Street Name | 0% | CASTLETON AVENUE7 AVENUELIBERTY AVENUE |
zip_code | text | USPS Zip Code | 3% | 112071120811236 |
water_debt_only | categorical | water charges only | 0% | NOYESNof 4 |