From a 456-row sample across 4 columns.
projectidtypeprojectidprojectidprojectidprojectid| lihtcdwid | projectid | type | annualallocationamount |
|---|---|---|---|
| 2697 | 44218 | 4% LIHTC | 1678083 |
| 1383 | 44225 | 9% LIHTC | 1556280 |
| 1385 | 44239 | 4% LIHTC | 1065981 |
| 1386 | 44249 | 9% LIHTC | 574080 |
| 2379 | 44256 | 4% LIHTC | 3310238 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
lihtcdwid | text | Unique identifier of LIHTC (annual tax credit allocation) in data warehouse | 0% | 140517471611 |
projectid | text | The unique ID that refers back to the Project ID column in the Project table (Foreign Key to the Project table) | 0% | 462996707949481 |
type | categorical | Type of Low Income Housing Tax Credit (LIHTC) | 0% | 4% LIHTC9% LIHTCof 2 |
annualallocationamount | integer | Annual amount of 4% or 9% of Low Income Housing Tax Credits (LIHTC) eligible for allocation, per HPD’s DOCE | 0% | 875000 |
GET /api/datasets/sgvu-nui7 GET /api/datasets/sgvu-nui7/quality GET /api/datasets/sgvu-nui7/related GET /api/columns?dataset=sgvu-nui7
projectidprojectidtypeprojectid| 1390 | 44258 | 9% LIHTC | 889224 |
| 1393 | 44280 | 4% LIHTC | 1986655 |
| 1395 | 44281 | 4% LIHTC | 3011763 |
| 1823 | 44282 | 4% LIHTC | 332087 |
| 1396 | 44295 | 4% LIHTC | 1953384 |
9723651029422