From a 500-row sample across 17 columns.
year3_amtyear4_amtfunding+7year3_amtyear4_amtfunding+4pub_date| pub_date | projtype | projtype_desc | typc | funding | yr1_fy | year1_amt | year2_amt | year3_amt | year4_amt | year5_amt | year6_amt |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 20190207 | BR and HB | Department of Transportation - Bridges | East River Bridges | City | 2020 | 79101 | 45714 | 30863 | 257000 | 0 | 0 |
| 20190207 | BR and HB |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
pub_date | categorical | Date data published | 0% | 202104262019042520210114of 8 |
projtype | text | Identifier derived from the Budget Line | 0% | PHWED |
projtype_desc | text | Agency or Department Name | 0% | Department of Transporta…Department of Small Busi…Department of Parks & Re… |
typc | text | Categories of work in the Ten-Year Capital Strategy | 0% | CityFederal |
GET /api/datasets/b37a-3faw GET /api/datasets/b37a-3faw/quality GET /api/datasets/b37a-3faw/related GET /api/columns?dataset=b37a-3faw
pub_datetypc| Department of Transportation - Bridges |
| Fair Bridges |
| City |
| 2020 |
| 320502 |
| 815263 |
| 650917 |
| 901940 |
| 420459 |
| 59264 |
| 20190207 | BR and HB | Department of Transportation - Bridges | Fair Bridges | Federal | 2020 | 75889 | 0 | 0 | 122434 | 33141 | 0 |
| 20190207 | BR and HB | Department of Transportation - Bridges | Fair Bridges | State | 2020 | 13000 | 0 | 0 | 0 | 0 | 0 |
| 20190207 | BR and HB | Department of Transportation - Bridges | Fair Bridges | Private | 2020 | 1951 | 0 | 0 | 0 | 0 | 0 |
| 20190207 | BR and HB | Department of Transportation - Bridges | Useful Life Extension and Miscellaneous Work | City | 2020 | 25 | 58 | 0 | 0 | 0 | 0 |
| 20190207 | BR and HB | Department of Transportation - Bridges | Bridge Life Extension and Miscellaneous Work | City | 2020 | 405112 | 196323 | 201874 | 513134 | 601700 | 217694 |
| 20190207 | BR and HB | Department of Transportation - Bridges | Bridge Life Extension and Miscellaneous Work | Federal | 2020 | 41139 | 3160 | 54136 | 0 | 0 | 0 |
| 20190207 | BR and HB | Department of Transportation - Bridges | Bridge Life Extension and Miscellaneous Work | State | 2020 | 194 | 0 | 0 | 0 | 0 | 0 |
| 20190207 | BR and HB | Department of Transportation - Bridges | Bridge Painting | City | 2020 | 31970 | 21946 | 25000 | 32000 | 32000 | 32000 |
Showing 12 of 17 columns. All of them are listed below.
Statefunding | categorical | City, Federal, State or Private | 0% | CityFederal2024of 5 |
yr1_fy | text | Defines Fiscal Year of Year1 | 0% | 202220202026 |
year1_amt | integer | Yr1_FY | 0% | 010005000 |
year2_amt | integer | Year1 + 1 | 0% | 05000500 |
year3_amt | integer | Year1 + 2 | 0% | 05000300 |
year4_amt | integer | Year1 + 3 | 0% | 0500010000 |
year5_amt | integer | Year1 + 4 | 0% | 0500010000 |
year6_amt | integer | Year1 + 5 | 0% | 0100005000 |
year7_amt | integer | Year1 + 6 | 0% | 0100005000 |
year8_amt | integer | Year1 + 7 | 0% | 0500025000 |
year9_amt | integer | Year1 + 8 | 0% | 0500010000 |
year10_amt | integer | Year1 + 9 | 0% | 0500035000 |
total | integer | Sum of Year1 through Year10 | 12% | 10001550000 |