From a 125-row sample across 4 columns.
monthyearrate+1monthyearrate+1monthyearrate+1monthyearboroughHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| borough | month | year | rate |
|---|---|---|---|
| Citywide | March | 2016 | 0.3 |
| Citywide | April | 2016 | 0.3 |
| Citywide | May | 2016 | 0.3 |
| Citywide | June | 2016 | 0.3 |
| Citywide | July | 2016 | 0.3 |
| Citywide |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
borough | text | One of the five boroughs of New York City. NYC DOP has offices in each of the five boroughs. | 0% | Citywideof 1 |
month | categorical | The month of the reporting period. | 0% | AprilJuneMayof 12 |
year | categorical | The year of the reporting period. | 0% | 202020252024of 11 |
rate | categorical | The percentage of juvenile probationer arrests relative to all arrests recorded by the Police Department during the reporting period. | 0% | 0.30.20.1 |
GET /api/datasets/7m8q-jgtg GET /api/datasets/7m8q-jgtg/quality GET /api/datasets/7m8q-jgtg/related GET /api/columns?dataset=7m8q-jgtg
monthyearboroughmonthyearboroughmonthyearboroughmonthyearborough| August |
| 2016 |
| 0.3 |
| Citywide | September | 2016 | 0.3 |
| Citywide | October | 2016 | 0.3 |
| Citywide | November | 2016 | 0.3 |
| Citywide | December | 2016 | 0.3 |