From a 500-row sample across 30 columns.
lottery_idlottery_nameborough+13Has borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| lottery_id | lottery_name | development_type | reporting_construction_type | unit_count | hpd_building_id | hc_building_id | house_number | street_name | borough | unit_distribution_1bed | unit_distribution_2bed |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 3600 | 422 East 31 Street | Rental | New Construction | 3 | 256929 | 5986 | 422 | EAST 31 STREET | BK | 1 | 2 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
lottery_id | integer | The Lottery ID is a unique numeric identifier assigned to each housing connect lottery by HPD | 0% | 277946541826 |
lottery_name | text | Name given to the lottery as advertised on Housing Connect | 0% | Amanda's Cove Waiting Li…NEHEMIAH SPRING CREEK PH…NEHEMIAH SPRING CREEK 4B… |
development_type | categorical | Whether the lottery is for rental or homeownership units | 0% | RentalOwnerof 2 |
reporting_construction_type | categorical | Reporting Construction Type indicates whether the building is categorized as ‘new construction’ or ‘preservation’ in HPD housing production statistics. | 0% |
GET /api/datasets/nibs-na6y GET /api/datasets/nibs-na6y/quality GET /api/datasets/nibs-na6y/related GET /api/columns?dataset=nibs-na6y
| 4673 |
| 456 Blake Avenue Apartments |
| Rental |
| New Construction |
| 3 |
| 931125 |
| 6743 |
| 456 |
| BLAKE AVENUE |
| BK |
| 1 |
| 1 |
| 4594 | 2754 Creston Avenue Apartments | Rental | New Construction | 19 | 59296 | 6700 | 2754 | Creston Ave | BX | — | — |
| 4071 | 2882 86th Street Apartment | Rental | New Construction | 2 | 991001 | 6365 | 2882 | 86th St | BK | — | 2 |
| 7322 | The Danby | Rental | New Construction | 35 | 0 | 7774 | 170 | W 225th St | MN | 30 | 5 |
| 2286 | 150 Lenox Road Apartments | Rental | New Construction | 13 | 324075 | 3844 | 150 | LENOX ROAD | BK | — | 13 |
| 2673 | 3506 - 3508 Farragut Road - Units Still Available | Rental | New Construction | 3 | 986445 | 4215 | 3506 | Farragut Rd | BK | 3 | — |
| 4372 | 266 West 96th Street Apartments | Rental | New Construction | 52 | 37229 | 6542 | 266 | W 96th St | MN | 12 | 11 |
| 1806 | 222 East 44th Street Phase II | Rental | New Construction | 16 | 13694 | 3239 | 222 | E 44th St | MN | 7 | 1 |
| 7324 | 69 Hope Street Apartments | Rental | New Construction | 6 | 0 | 7779 | 69 | HOPE STREET | BK | — | — |
Showing 12 of 26 columns. All of them are listed below.
New ConstructionPreservationof 2 |
unit_count | integer | The number of affordable units offered in the building | 0% | 326 |
hpd_building_id | integer | The Building ID is a unique numeric identifier assigned to each building by HPD | 0% | 0985163985164 |
hc_building_id | integer | The Housing Connect Building ID is a unique numeric identifier assigned to each building automatically by Housing Connect | 0% | 779144283808 |
house_number | text | The House Number is the street number in the building’s address. | 0% | 15055 |
street_name | text | The Street Name is the name of the street in the building’s address. | 0% | FULTON AVENUEVandalia AvenueFULTON STREET |
borough | categorical | The Borough is the borough where the building is located. | 0% | BKBXQNof 5 |
unit_distribution_studio | integer | The count of units in the building that are studios. | 53% | 123 |
unit_distribution_1bed | integer | The count of units in the building that are 1-bedroom. | 18% | 132 |
unit_distribution_2bed | integer | The count of units in the building that are 2-bedroom. | 28% | 213 |
unit_distribution_3bed | integer | The count of units in the building that are 3-bedroom. | 78% | 123 |
unit_distribution_4bed | categorical | The count of units in the building that are 4 or more bedrooms. | 99% | 124of 11 |
applied_income_ami_ext_low | integer | The count of units in the building where the applied income is categorized as 30% of the area median income (AMI) or lower | 94% | 123 |
applied_income_ami_very_low | integer | The count of units in the building where the applied income is categorized as between 31% and 50% of the area median income (AMI) | 82% | 342 |
applied_income_ami_low | integer | The count of units in the building where the applied income is categorized as between 51% and 80% of the area median income (AMI) | 63% | 132 |
applied_income_ami_moderate | integer | The count of units in the building where the applied income is categorized as between 81% and 120% of the area median income (AMI) | 85% | 123 |
applied_income_ami_middle | integer | The count of units in the building where the applied income is categorized as between 121% and 165% of the area median income (AMI) | 36% | 326 |
applied_income_ami_above | integer | The count of units in the building where the applied income is categorized as over 165% of the area median income (AMI) | 100% | 60of 1 |
address_zipcode | text | The Postcode is the postcode where the building is located. | 0% | 112261122110467 |
address_latitude | coordinate | Latitude of the site's location | 0% | 40.75087140.65493140.750874 |
address_longitude | coordinate | Longitude of the site's location | 0% | -73.944615-73.959012-73.994041 |
address_communitydistrict | text | Community Boards are volunteer-run neighborhood organizations that work on all kinds of issues pertinent to their communities, often working with elected city officials in doing so. Community Board members, who can be as young as 16, are appointed by Borough Presidents and City Council representatives. They serve two-year terms. There are 59 Community Boards in NYC, each of which represents a unique geographical area, known as a Community District. Note: as a column header, “Community Board” ( | 0% | 301401212 |
address_citycouncildistrict | text | The City Council is the lawmaking body of NYC, on equal footing with the mayor in terms of governing power. Besides legislating, the Council has sole approval power over the city budget, and is the final decision-maker in land use matters. There are 51 City Council members in total, each representing a unique geographical area, called a Council District. | 0% | 153437 |
address_buildingidentificationnumber | text | The BIN (Building Identification Number) is a unique 7-digit number assigned to every known building by the Department of City Planning (DCP), the first digit of which is the borough code. BINs allow city agencies to process and match building-related data easily and in a consistent manner. | 3% | 300000020000004000000 |
address_bbl | text | he BBL (Borough, Block, and Lot) is a combination of three numeric codes - a 1-digit borough number, a block number (up to 5 digits) and a lot number (up to 4 digits) - designated and modified by the Department of Finance (DOF). BBLs are used by various city agencies to identify real estate for taxes, zoning, construction, and other purposes. | 3% | 101760000141553775011009910060 |
address_censustrack2020 | text | The Census Tract (Census 2020) is a small, relatively permanent statistical subdivisions of a county uniquely numbered in each county with a numeric code. | 0% | 1070015187 |
address_nta2020 | text | The Neighborhood Tabulation Area (Census 2020) are small area boundaries, created by the Department of City Planning (DCP) to aggregate population projections in a small area. Each NTA approximates a minimum population of 15,000. While NTAs were initially created to support PlaNYC, the thirty-year (2000-2030) sustainability plan for NYC, NTAs are now also being used to present data from the Decennial Census and American Community Survey. NTA boundaries and their associated names do not definitiv | 0% | BK0301BX1201BK1701 |