From a 500-row sample across 7 columns.
agenmnthcurr_ytd+4mnthcurr_ytdpub_dt+3pub_dtfisc_yrpub_dtfisc_yr| pub_dt | fisc_yr | mnth | curr_ytd | agen | act | plan |
|---|---|---|---|---|---|---|
| 20200928 | 2021 | July | Current | Police | 228 | 230 |
| 20200928 | 2021 | July | Current | Fire | 85 | 83 |
| 20200928 | 2021 | July | Current | Correction | 47 |
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% | 202609162024041720240111 |
fisc_yr | categorical | The fiscal year that is being reported. | 0% | 202620232022of 6 |
mnth | categorical | The current month is being reported. | 0% | DecemberFebruaryOctoberof 11 |
curr_ytd | categorical | The current or year-to-date data that is being reported. | 0% | CurrentYear-to-Dateof 2 |
GET /api/datasets/nhtw-fjuj GET /api/datasets/nhtw-fjuj/quality GET /api/datasets/nhtw-fjuj/related GET /api/columns?dataset=nhtw-fjuj
mnthpub_dtfisc_yrpub_dtfisc_yr| 50 |
| 20200928 | 2021 | July | Current | Sanitation | 63 | 66 |
| 20200928 | 2021 | July | Current | Admin. for Children's Services | 26 | 26 |
| 20200928 | 2021 | July | Current | Social Services | 41 | 43 |
| 20200928 | 2021 | July | Current | Homeless Services | 8 | 8 |
| 20200928 | 2021 | July | Current | Health and Mental Hygiene | 26 | 26 |
| 20200928 | 2021 | July | Current | Housing Preservation and Dev. | 9 | 9 |
| 20200928 | 2021 | July | Current | Environmental Protection | 42 | 34 |
agen | categorical | The name of the agency that is being reported. | 0% | Housing Preservation and…PoliceEnvironmental Protectionof 18 |
act | integer | The actual amount that is being reported. | 0% | 411612 |
plan | integer | The plan amount that is being reported. | 0% | 141741 |