From a 23-row sample across 6 columns.
fisc_yrpub_dtfisc_yragy_nmpub_dtfisc_yragy_nmpub_dtfisc_yrpub_dtfisc_yr| pub_dt | fisc_yr | agy_nm | exp | cap_repr | cap_mgtn |
|---|---|---|---|---|---|
| 20200416 | 2021 | Health and Hospitals Corporation | 122866046.78 | 983458701.05 | 756873320.48 |
| 20200416 | 2021 | Department of Parks and Recreation | 94473680.30999999 | 774866378.5500002 | 245143459.75 |
| 20200416 | 2021 | Department of Environmental Protection | 616903698.5 | 263527391.59000003 | 294856303.48 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
pub_dt | categorical | 8-digit number for date of publication (e. g. 20200416) | 0% | 2020041620210430of 2 |
fisc_yr | text | 4-digit year to identify a period of twelve months that begins July 1 and ends the following June 30 | 0% | 2021of 1 |
agy_nm | categorical | Identifies the Related New York City Agency | 0% | Police DepartmentOther City AgenciesDepartment of Education …of 13 |
exp | float | Disbursement of Funding | 0% | 202164028.73000002 |
GET /api/datasets/h5f7-3btz GET /api/datasets/h5f7-3btz/quality GET /api/datasets/h5f7-3btz/related GET /api/columns?dataset=h5f7-3btz
pub_dtfisc_yrpub_dtfisc_yragy_nmpub_dtpub_dt| 20200416 | 2021 | Department of Education / School Construction Authority | 94888194.50999999 | 544386854.6400001 | 191622407.91000003 |
| 20200416 | 2021 | Department of Transportation | 10499502.94 | 127404685.25999999 | 4604212.07 |
| 20200416 | 2021 | Police Department | 202164028.73000002 | 80800282.00000001 | 11322063.38 |
| 20200416 | 2021 | Fire Department | 25471567.4 | 199616872.10000002 | 4047178.14 |
| 20200416 | 2021 | Department of Sanitation | 177123593.23999995 | 29051893.5 | 11006132.97 |
| 20200416 | 2021 | Department of Cultural Affairs | 1169096.64 | 121830590.76000002 | 69266315.22 |
| 20200416 | 2021 | Department of Corrections | 3375761.12 | 70479189.36 | 14985383 |
2021640293375761.12cap_repr | float | Funding Used to Provide Emergency Capital Repairs | 0% | 207934941758658144129190017.09000002 |
cap_mgtn | float | Funding Used on Projects to Reduce Future Disaster Costs and Losses | 0% | 1458092002245023095120006979 |