From a 500-row sample across 8 columns.
reporting_periodmanaging_agencyfms_idmanaging_agencyfms_idreporting_periodmanaging_agency| reporting_period | managing_agency | fms_id | fiscal_year | total_budget_city_non_city | city | non_city |
|---|---|---|---|---|---|---|
| 202305 | ACS | ACSPDF | 2023 | 0.00 | 0.00 | 0.00 |
| 202305 | ACS | ACSPDF | 2024 | 1525000.00 | 763000.00 | 762000.00 |
| 202305 | ACS | ACSPDF | 2025 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
reporting_period | categorical | The year and the month the report is published (format YYYYMM) | 0% | 202605202601202505of 10 |
managing_agency | text | Common acronym of the city agency that is responsible for managing the construction and delivery of the capital project. This value is derived from the three digit managing agency code. | 0% | DPRDDCDOT |
fms_id | text | Unique identifier in the Financial Management System (FMS) | 0% | C519HW34907HW349LUM |
fiscal_year | text | One-year accounting period | 0% |
GET /api/datasets/gyhf-rsr3 GET /api/datasets/gyhf-rsr3/quality GET /api/datasets/gyhf-rsr3/related GET /api/columns?dataset=gyhf-rsr3
fiscal_yearfiscal_year| 2132000.00 |
| 2132000.00 |
| 0.00 |
| 202305 | ACS | ACSPDF | 2026 | 1571000.00 | 1083000.00 | 488000.00 |
| 202305 | ACS | ACSPDF | 2027 | 1746000.00 | 1746000.00 | 0.00 |
| 202305 | ACS | ACSPDF | 2030 | 9820000.00 | 9820000.00 | 0.00 |
| 202305 | ACS | ACSPDF | 2031 | 9823000.00 | 9823000.00 | 0.00 |
| 202305 | ACS | ACSPDF | 2032 | 20191000.00 | 20191000.00 | 0.00 |
| 202305 | ACS | ACSPDF | 2033 | 20000000.00 | 20000000.00 | 0.00 |
| 202305 | ACS | BXELEVFAR | 2024 | 1284000.00 | 1284000.00 | 0.00 |
202420232025total_budget_city_non_city | integer | The total cost of the project, as reflected by ""Commitments"" in the City's Financial Management System (FMS) and in the https://data.cityofnewyork.us/d/fb86-vt7u dataset’s ""Total Budget"" column | 1% | 0.0050000.00100000.00 |
city | integer | Total planned expenditures for the project funded by the City | 1% | 0.0050000.00100000.00 |
non_city | integer | Total planned expenditures for the project funded by sources other than the City | 1% | 0.001000.00500000.00 |
spend | float | The amount of money spent, as reflected by "Liquidations" in the City's Financial Management System (FMS) | 32% | 0.0050000.0025000.00 |