From a 500-row sample across 11 columns.
projectidtotalunitsbuildingidprojectidprojectidprojectidprojectid| projectid | buildingid | bedroomsize | maxallowableincome | totalunits | medianinitiallegalrent | highinitiallegalrent | lowinitiallegalrent | medianactualrent | highactualrent | lowactualrent |
|---|---|---|---|---|---|---|---|---|---|---|
| 50206 | 287193 | 2-BR | 0%-30% | 1 | 1554 | 1554 | 1554 | 0 | 0 | 0 |
| 50206 | 383480 | STUDIO |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
projectid | text | The unique ID that refers back to the Project ID column in the Project table (Foreign Key to the Project table) | 0% | 685306667069490 |
buildingid | text | The HPD Building ID is the unique numeric identifier assigned by HPD to all buildings | 0% | 8323066012842019 |
bedroomsize | categorical | Number of bedrooms in an apartment | 0% | 2-BR1-BR3-BRof 13 |
maxallowableincome | text | Apartment sizes grouped by number of bedrooms and AMI band | 0% | 41%-50% |
GET /api/datasets/9ay9-xkek GET /api/datasets/9ay9-xkek/quality GET /api/datasets/9ay9-xkek/related GET /api/columns?dataset=9ay9-xkek
projectidbuildingidprojectidprojectid| 0%-30% |
| 1 |
| 1531 |
| 1531 |
| 1531 |
| 0 |
| 0 |
| 0 |
| 50206 | 383478 | 2-BR | 0%-30% | 1 | 1554 | 1554 | 1554 | 0 | 0 | 0 |
| 52674 | 4060 | 2-BR | 0%-30% | 1 | — | — | — | — | — | — |
| 52674 | 41105 | 2-BR | 0%-30% | 1 | — | — | — | — | — | — |
| 52674 | 40979 | STUDIO | 0%-30% | 1 | — | — | — | — | — | — |
| 52674 | 40957 | 2-BR | 0%-30% | 1 | — | — | — | — | — | — |
| 52674 | 2660 | 2-BR | 0%-30% | 1 | — | — | — | — | — | — |
| 52674 | 39807 | 2-BR | 0%-30% | 1 | — | — | — | — | — | — |
| 58589 | 332727 | 1-BR | 0%-30% | 1 | 1411 | 1411 | 1411 | 906 | 906 | 906 |
51%-60%71%-80%totalunits | integer | Number of units with a particular number of bedrooms and AMI% band | 0% | 123 |
medianinitiallegalrent | integer | Median initial legal rent for those units with the same number of bedrooms and AMI band, initial legal rent registered upon completion as the rent stabilized rent | 70% | 015111741 |
highinitiallegalrent | integer | High end of the range of initial legal rents for those units with the same number of bedrooms and AMI band, initial legal rent registered upon completion as the rent stabilized rent | 70% | 015111741 |
lowinitiallegalrent | integer | Low end of the range of initial legal rents for those units with the same number of bedrooms and AMI band, low end of the range of initial legal rents for those units with the same number of bedrooms and AMI band | 70% | 015111741 |
medianactualrent | integer | Median actual rent for those units with the same number of bedrooms and AMI band, actual initial rent projected upon rent-up or completion of the project | 57% | 0929882 |
highactualrent | integer | High end of the range of Actual Rents for those units with the same number of bedrooms and AMI band, actual initial rent projected upon rent-up or completion of the project | 57% | 01101909 |
lowactualrent | integer | Low end of the range of actual rents for those units with the same number of bedrooms and AMI band, actual initial rent projected upon rent-up or completion of the project | 57% | 0685929 |