From a 500-row sample across 7 columns.
fisc_yrpub_dtpub_dtfisc_yrpub_dtfisc_yrpub_dtfisc_yrpub_dt| pub_dt | fisc_yr | mnth | curr_ytd | agen | act | plan |
|---|---|---|---|---|---|---|
| 20210311 | 2021 | December | Current | Police | 611 | 620 |
| 20210311 | 2021 | December | Current | Fire | 250 | 250 |
| 20210311 | 2021 | December | Current | Correction | 131 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
pub_dt | text | The date of publication. | 0% | 202609162021111920240111 |
fisc_yr | categorical | The fiscal year that is being reported. | 0% | 202320222025of 6 |
mnth | categorical | The current month is being reported. | 0% | DecemberMarchAugustof 11 |
curr_ytd | categorical | The current or year-to-date data that is being reported. | 0% | CurrentYear-to-Dateof 2 |
GET /api/datasets/hjjq-k984 GET /api/datasets/hjjq-k984/quality GET /api/datasets/hjjq-k984/related GET /api/columns?dataset=hjjq-k984
fisc_yrpub_dt| 133 |
| 20210311 | 2021 | December | Current | Sanitation | 292 | 310 |
| 20210311 | 2021 | December | Current | Admin. for Children's Services | 117 | 174 |
| 20210311 | 2021 | December | Current | Social Services | 941 | 884 |
| 20210311 | 2021 | December | Current | Homeless Services | 96 | 94 |
| 20210311 | 2021 | December | Current | Health and Mental Hygiene | 130 | 145 |
| 20210311 | 2021 | December | Current | Housing Preservation and Dev. | 9 | 74 |
| 20210311 | 2021 | December | Current | Environmental Protection | 94 | 159 |
agen | text | The name of the agency that is being reported. | 0% | EducationPrior Payable AdjustmentDebt Service |
act | integer | The actual amount that is being reported. | 0% | 09638 |
plan | integer | The plan amount that is being reported. | 0% | 082109 |