From a 95-row sample across 9 columns.
totalcategory| category | subcategory | work_type | fy25 | fy26 | fy27 | fy28 | fy29 | total |
|---|---|---|---|---|---|---|---|---|
| I. State of Good Repair | A. New Construction | 1. Building Replacement | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| I. State of Good Repair | B. Major Modernizations and Rehabilitations | 1. Full Modernizations | 0.00 | 0.00 | 0.00 | 0.00 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
category | categorical | — | 0% | I. State of Good RepairII. System ExpansionVI. Emergency, Unspecifi…of 6 |
subcategory | text | — | 0% | E. System ReplacementsC. Building UpgradeA. New Construction-Addi… |
work_type | text | — | 0% | 1. Lunchrooms4. Swimming Pools2. Auditoriums |
fy25 | float | — | 0% | 0.000.12 |
GET /api/datasets/24nr-gahi GET /api/datasets/24nr-gahi/quality GET /api/datasets/24nr-gahi/related GET /api/columns?dataset=24nr-gahi
category| 0.00 |
| 0.00 |
| I. State of Good Repair | B. Major Modernizations and Rehabilitations | 2. Interior Modernizations | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| I. State of Good Repair | B. Major Modernizations and Rehabilitations | 3. Exterior Modernizations | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| I. State of Good Repair | C. Building Upgrade | 1. Asbestos | 39.25 | 50.00 | 54.75 | 53.00 | 53.00 | 250.00 |
| I. State of Good Repair | C. Building Upgrade | 2. Boiler Conversion | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| I. State of Good Repair | C. Building Upgrade | 3. Climate Control | 27.75 | 12.50 | 4.70 | 2.26 | 2.79 | 50.00 |
| I. State of Good Repair | C. Building Upgrade | 4. Indoor Air Pollution Abatement | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| I. State of Good Repair | C. Building Upgrade | 5. Kitchen Conversion | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| I. State of Good Repair | C. Building Upgrade | 6. Low-Voltage Electrical System | 38.74 | 49.83 | 14.81 | 2.73 | 3.89 | 110.00 |
0.24fy26 | float | — | 0% | 0.000.1820.01 |
fy27 | float | — | 0% | 0.000.0214.24 |
fy28 | float | — | 0% | 0.000.310.01 |
fy29 | float | — | 0% | 0.0012.0082.66 |
total | float | — | 0% | 0.0010.0050.00 |