From a 500-row sample across 10 columns.
agencynotesreporting_fiscal_year+5ps_otps_indagencyagency_codeagency_nameagency| reporting_fiscal_year | agency_code | agency | agency_name | unit_of_appropriation | ps_otps_ind | expenditures_previous_fy | financial_plan_current_fy | applicable_mmr_goals |
|---|---|---|---|---|---|---|---|---|
| 2017 | 068 | ACS | ADMININISTRATION FOR CHILDREN'S SERVICES | 002 - OTHER THAN PERSONAL SERVICES | Other Than Personal Services | 76.4 | 75.0 | NA |
| 2017 | 068 | ACS | ADMININISTRATION FOR CHILDREN'S SERVICES | 004 - HEADSTART/DAYCARE-OTPS |
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 10 |
agency_code | text | The numeric code for the agency | 0% | 040126816 |
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/w4ne-9ea9 GET /api/datasets/w4ne-9ea9/quality GET /api/datasets/w4ne-9ea9/related GET /api/columns?dataset=w4ne-9ea9
agency_nameagency_nameagencyagency_name| Other Than Personal Services |
| 1052.9 |
| 1091.5 |
| NA |
| 2017 | 068 | ACS | ADMININISTRATION FOR CHILDREN'S SERVICES | 006 - CHILD WELFARE-OTPS | Other Than Personal Services | 1172.7 | 1201.8 | NA |
| 2017 | 068 | ACS | ADMININISTRATION FOR CHILDREN'S SERVICES | 008 - JUVENILE JUSTICE - OTPS | Other Than Personal Services | 153.2 | 155.7 | NA |
| 2017 | 068 | ACS | ADMININISTRATION FOR CHILDREN'S SERVICES | 001 - PERSONAL SERVICES | Personal Services | 283.0 | 316.6 | NA |
| 2017 | 068 | ACS | ADMININISTRATION FOR CHILDREN'S SERVICES | 003 - HEADSTART and DAYCARE-PS | Personal Services | 16.9 | 24.2 | NA |
| 2017 | 068 | ACS | ADMININISTRATION FOR CHILDREN'S SERVICES | 005 - ADMINISTRATIVE-PS | Personal Services | 83.7 | 72.9 | NA |
| 2017 | 068 | ACS | ADMININISTRATION FOR CHILDREN'S SERVICES | 007 - JUVENILE JUSTICE - PS | Personal Services | 36.4 | 40.3 | NA |
| 2017 | 829 | BIC | BUSINESS INTEGRITY COMMISSION | 002 - OTHER THAN PERSONAL SERVICES | Other Than Personal Services | 2.8 | 3.1 | NA |
| 2017 | 829 | BIC | BUSINESS INTEGRITY COMMISSION | 001 - PERSONAL SERVICES | Personal Services | 5.3 | 6.0 | 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… |
ps_otps_ind | categorical | Indicates Personal Services or Other Than Personal Services | 0% | Other Than Personal Serv…Personal ServicesNAof 3 |
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.2 |
financial_plan_current_fy | coordinate | Budgeted amounts in dollars for specified fiscal year as reported in adopted budget | 0% | 1.40.11.0 |
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 | categorical | Provides additional information about data included | 93% | These figures are limite…This UA originated in Fi…OCME is contained within…of 19 |