From a 500-row sample across 10 columns.
agency_codereporting_fiscal_yearnotes+5agencyagency_codeagencyagency_nameagency| reporting_fiscal_year | agency_code | agency | agency_name | unit_of_appropriation | appropriation_type | expenditures_previous_fy | modified_budget_current_fy | applicable_mmr_goals |
|---|---|---|---|---|---|---|---|---|
| 2016 | 3 | BOE | BOARD OF ELECTIONS | 001 - PERSONAL SERVICES | Personal Services | 51.39 | 61.72 | NA |
| 2016 | 3 | BOE | BOARD OF ELECTIONS | 002 - OTHER THAN PERSONAL SERVICES |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
reporting_fiscal_year | categorical | The fiscal year (FY) for which the data corresponds; a fiscal year begins July 1st and ends June 30th of the next year. For example, FY 2023 is from July 1st 2022 to June 30th 2023. | 0% | 202620252024of 11 |
agency_code | text | The numeric code for the agency | 0% | 12640816 |
agency | text | Acronym of agency name | 0% | DOEDCLADOHMH |
agency_name | text | Name of the agency | 0% | DEPARTMENT OF EDUCATIONDEPARTMENT OF CULTURAL A… |
GET /api/datasets/2jrp-puwz GET /api/datasets/2jrp-puwz/quality GET /api/datasets/2jrp-puwz/related GET /api/columns?dataset=2jrp-puwz
agencyagency_nameagencyagency_name| Other Than Personal Services |
| 55.36 |
| 78.53 |
| NA |
| 2016 | 17 | NYCEM | DEPARTMENT OF EMERGENCY MANAGEMENT | 001 - PERSONAL SERVICES | Personal Services | 11.6 | 6.25 | NA |
| 2016 | 17 | NYCEM | DEPARTMENT OF EMERGENCY MANAGEMENT | 002 - OTHER THAN PERSONAL SERVICES | Other Than Personal Services | 23.44 | 9.78 | NA |
| 2016 | 25 | LAW | LAW DEPARTMENT | 001 - PERSONAL SERVICES | Personal Services | 111.06 | 125.7 | NA |
| 2016 | 25 | LAW | LAW DEPARTMENT | 002 - OTHER THAN PERSONAL SERVICES | Other Than Personal Services | 64.53 | 60.88 | NA |
| 2016 | 30 | DCP | DEPARTMENT OF CITY PLANNING | 001 - PERSONAL SERVICES | Personal Services | 19.22 | 22.97 | NA |
| 2016 | 30 | DCP | DEPARTMENT OF CITY PLANNING | 003 - GEOGRAPHIC SYSTEMS | Personal Services | 1.96 | 2.23 | NA |
| 2016 | 30 | DCP | DEPARTMENT OF CITY PLANNING | 002 - OTHER THAN PERSONAL SERVICES | Other Than Personal Services | 3.26 | 12.62 | NA |
| 2016 | 30 | DCP | DEPARTMENT OF CITY PLANNING | 004 - GEOGRAPHIC SYSTEMS | Other Than Personal Services | 0.28 | 0.3 | NA |
DEPARTMENT OF HEALTH AND…unit_of_appropriation | text | The numeric code and name for the Unit of Appropriation (UoA) within the agency | 0% | 002 - OTHER THAN PERSONA…001 - PERSONAL SERVICES002 - Other Than Persona… |
appropriation_type | categorical | Indicates Personal Services or Other Than Personal Services | 0% | Other Than Personal Serv…Personal ServicesPERSONAL SERVICESof 5 |
expenditures_previous_fy | coordinate | Expenditures in dollars as reported in the City's comprehensive annual financial report, for the previous fiscal year | 0% | NA0.10 |
modified_budget_current_fy | coordinate | Expenditures in dollars as reported in the City's comprehensive annual financial report, for the previous fiscal year | 0% | 1.40.30.1 |
applicable_mmr_goals | text | The MMR goals for which the data corresponds to; indicates relationship between MMR goals and agency expenditures. Agency goals are listed at the beginning of each chapter in the (P)MMR. | 1% | AllNA1a, 1b |
notes | text | Provides additional information about data included | 94% | These figures are limite…This UA originated in Fi…These figures are limite… |