From a 500-row sample across 29 columns.
unit_distribution_3bedboroughlottery_id+13longitudelatitudepostcodelongitudelatitudepostcodelongitudeMappable — coordinate pair `latitude` / `longitude`.
Open on the map →| lottery_id | lottery_name | lottery_status | development_type | lottery_start_date | lottery_end_date | building_count | unit_count | unit_distribution_1bed | unit_distribution_2bed | unit_distribution_3bed | applied_income_ami_very_low |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 3249 | Melrose North Apartments | All Units Filled | Rental | 2022-12-01T00:00:00.000 | 2023-01-30T00:00:00.000 | 1 | 67 | 36 | 25 | 6 | 26 |
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% | 228643921961 |
lottery_name | text | Name given to the lottery as advertised on Housing Connect | 0% | 601 West 29th Street Apa…The Gregory3214 Cruger Avenue |
lottery_status | categorical | The status the lottery was in when the data was most recently collected | 0% | All Units FilledTenant SelectionClosedof 4 |
development_type | categorical | Whether the lottery is for rental or homeownership units | 0% |
GET /api/datasets/vy5i-a666 GET /api/datasets/vy5i-a666/quality GET /api/datasets/vy5i-a666/related GET /api/columns?dataset=vy5i-a666
latitudelongitudelatitudeboroughlongitudecommunity_board+1longitudecommunity_boardlatitude| 4646 | NME 3 Coops | Tenant Selection | Owner | 2024-04-19T00:00:00.000 | 2024-06-18T00:00:00.000 | 2 | 52 | 20 | 19 | 12 | — |
| 3722 | 134-16 36 Road Apartments | Tenant Selection | Rental | 2023-05-05T00:00:00.000 | 2023-06-01T00:00:00.000 | 1 | 8 | 5 | 2 | — | — |
| 2150 | 545 St. Marks Avenue Apartments | All Units Filled | Rental | 2021-05-03T00:00:00.000 | 2021-05-24T00:00:00.000 | 1 | 3 | 3 | — | — | — |
| 3600 | 422 East 31 Street | All Units Filled | Rental | 2023-04-03T00:00:00.000 | 2023-05-24T00:00:00.000 | 1 | 3 | 1 | 2 | — | — |
| 4667 | 35-10 Union Street Apartments | All Units Filled | Rental | 2024-03-28T00:00:00.000 | 2024-05-09T00:00:00.000 | 1 | 14 | 4 | 7 | — | — |
| 4155 | Astoria West Waitlist | Tenant Selection | Rental | 2023-11-24T00:00:00.000 | 2023-12-26T00:00:00.000 | 1 | 36 | 28 | 8 | — | — |
| 3581 | 187 20th Street Apartments | All Units Filled | Rental | 2023-03-31T00:00:00.000 | 2023-05-12T00:00:00.000 | 1 | 3 | 3 | — | — | — |
| 2775 | 50 Nevins Street Apartments | All Units Filled | Rental | 2022-03-21T00:00:00.000 | 2022-05-20T00:00:00.000 | 1 | 50 | — | 7 | 2 | — |
| 3728 | 311 Franklin Avenue Apartments | All Units Filled | Rental | 2023-05-05T00:00:00.000 | 2023-05-25T00:00:00.000 | 1 | 3 | — | 3 | — | — |
Showing 12 of 26 columns. All of them are listed below.
RentalOwnerof 2 |
lottery_start_date | datetime | The date the lottery opened for applications on Housing Connect | 0% | 2025-10-16T00:00:00.0002025-10-27T00:00:00.0002024-04-01T00:00:00.000 |
lottery_end_date | datetime | The date the lottery stopped collecting applications on Housing Connect | 0% | 2024-02-05T00:00:00.0002025-08-25T00:00:00.0002021-08-30T00:00:00.000 |
building_count | categorical | The number of buildings included in the lottery | 0% | 123of 19 |
unit_count | integer | The number of units included in the lottery | 0% | 364 |
unit_distribution_studio | integer | The number of Studio Units included in the lottery | 46% | 123 |
unit_distribution_1bed | integer | The number of 1 bedroom units included in the lottery | 13% | 321 |
unit_distribution_2bed | integer | The number of 2 bedroom units included in the lottery | 26% | 231 |
unit_distribution_3bed | integer | The number of 3 bedroom units included in the lottery | 82% | 123 |
unit_distribution_4bed | categorical | The number of 4+ bedroom units included in the lottery | 99% | 1104of 11 |
applied_income_ami_ext_low | integer | The count of units in the lottery where the income limit is categorized as 30% of the area median income (AMI) or lower | 95% | 18510 |
applied_income_ami_very_low | integer | The count of units in the lottery where the income limit is categorized as between 31% and 50% of the area median income (AMI) | 83% | 759 |
applied_income_ami_low | integer | The count of units in the lottery where the income limit is categorized as between 51% and 80% of the area median income (AMI) | 66% | 362 |
applied_income_ami_moderate | integer | The count of units in the lottery where the income limit is categorized as between 81% and 120% of the area median income (AMI) | 90% | 342 |
applied_income_ami_middle | integer | The count of units in the lottery where the income limit is categorized as between 121% and 165% of the area median income (AMI) | 28% | 365 |
applied_income_ami_above | integer | The count of units in the lottery where the income limit is categorized as over 165% of the area median income (AMI) | 100% | 60of 1 |
lottery_mobility_percent | categorical | Percentage of units set-aside for applicant households that have at least one member with a mobility accessibility | 73% | 5210of 6 |
lottery_vision_hearing_percent | categorical | Percentage of units set-aside for applicant households that have at least one member with a vision or hearing accessibility | 74% | 258of 5 |
lottery_community_board_percent | categorical | Percentage of units that give preference to residents of the Community Board(s) the lottery is located in | 76% | 502040of 4 |
lottery_municipal_employee_percent | categorical | Percentage of units that give preference to households that have at least one member who is a municipal employee (i.e. works for the City of New York) or is a military veteran | 76% | 5102of 5 |
lottery_nycha_percent | categorical | Percentage of units that give preference to residents of New York City Housing Authority (NYCHA) | 99% | 253321of 5 |
lottery_62_percent | categorical | Percentage of units set-aside for applicant households that have at least one member who is a senior (typically 62+) | 96% | 1009020of 19 |
borough | categorical | The Borough is the borough where the building is located. | 0% | BKBXQNof 6 |
postcode | text | The Postcode is the postcode where the building is located. | 0% | 112261122111206 |
community_board | text | Community Board indicates the New York City Community District where the lottery is located | 0% | 301401303 |
latitude | coordinate | The Latitude and Longitude specify the location of the property on the earth’s surface. The coordinates provided are an estimate of the location based on the street segment and address range. | 0% | Multiple40.744415070022140.711135284106 |
longitude | coordinate | The Latitude and Longitude specify the location of the property on the earth’s surface. The coordinates provided are an estimate of the location based on the street segment and address range. | 0% | Multiple-73.9444416535848-73.8943498483841 |