From a 500-row sample across 9 columns.
projectidprojectidprojectidprojectidprojectid| projectdwid | projectid | acquisitionprice | highestbestappraisalamount | intendeduseappraisalamount | isnominal | asisappraisalamount |
|---|---|---|---|---|---|---|
| 19294 | 44218 | 9251897 | 63500000 | 0 | Yes | — |
| 19487 | 44223 | 8 | 6410000 | 6270000 | No | — |
| 19059 | 44225 | 455047 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
projectdwid | text | A unique internal identifier from HPD's data warehouse | 0% | 473311850930462 |
projectid | text | The unique ID that refers back to the Project ID column in the Project table (Foreign Key to the Project table) | 0% | 555005542855396 |
hpdpbvhapyear1amount | float | Estimated dollar amount of HPD Section 8 Project Based Voucher (PBV) annual Housing Assistance Payments (HAP) contract for Year 1 | 88% | 023024.5386.8 |
iscreditfacility | text | Notes whether the project received funding from a credit facility | 100% |
GET /api/datasets/7r6i-tdj2 GET /api/datasets/7r6i-tdj2/quality GET /api/datasets/7r6i-tdj2/related GET /api/columns?dataset=7r6i-tdj2
projectidprojectidprojectid| — |
| — |
| No |
| 835000 |
| 19421 | 44230 | 5 | 2548000 | 2215000 | No | 256687 |
| 19348 | 44239 | 2 | 5110000 | 0 | Yes | 5110000 |
| 18601 | 44249 | 1 | 550000 | 0 | Yes | 550000 |
| 19420 | 44250 | 1 | — | — | No | 2155000 |
| 19611 | 44256 | 2 | 54600000 | 0 | Yes | 54600000 |
| 18604 | 44258 | 4 | — | — | No | 2380000 |
| 19416 | 44280 | 252816 | 6116463 | 0 | Yes | 6116463 |
Yesacquisitionprice | integer | Purchase price identified in the City deed | 19% | 012 |
asisappraisalamount | integer | Value of the property based on the "As Is" appraisal | 68% | 028000001550000 |
highestbestappraisalamount | integer | Value of the property based on the "Highest and Best" appraisal | 80% | 0300000022000000 |
intendeduseappraisalamount | integer | Value of the property based on the "Intended Use" appraisal | 82% | 055250008700000 |
isnominal | categorical | Value of the property based on the "Intended Use" appraisal. | 0% | NoYesof 2 |