From a 500-row sample across 7 columns.
boroughboroughboroughHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| borough | fiscal_qtr | rel_week | title | totalcost | sector_name | sector_desc |
|---|---|---|---|---|---|---|
| Brooklyn | 2016Q1 | 0 | apsw | 21804.00 | — | — |
| Brooklyn | 2016Q1 | 0 | cpw | 9887.00 | — | — |
| Brooklyn | 2016Q1 | 0 | other | 91367.00 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
borough | categorical | Unique identification number for each borough, identified by borough/county (B = Brooklyn; M = Manhattan; Q = Queens; R = Richmond (Staten Island); X = Bronx) and followed by a number. | 0% | QueensManhattanBrooklynof 6 |
sector_name | text | The name of the sector in which the property is located. | 11% | Bronx Sector CBrooklyn Sector CManhattan Sector F |
sector_desc | text | The numbers of the Park Maintenance Districts that comprise the associated Sector | 11% | Districts 1, 2Districts 14Districts 1 |
fiscal_qtr | categorical | The fiscal year followed by the fiscal quarter for a given record. |
GET /api/datasets/caav-grv8 GET /api/datasets/caav-grv8/quality GET /api/datasets/caav-grv8/related GET /api/columns?dataset=caav-grv8
boroughsector_namesector_descfiscal_qtr| — |
| — |
| Brooklyn | 2016Q1 | 0 | pop | 5535.00 | — | — |
| Brooklyn | 2016Q1 | 0 | apsw | 4692.00 | Brooklyn Sector A | Districts 4, 5, 16 |
| Brooklyn | 2016Q1 | 0 | cpw | 11362.00 | Brooklyn Sector A | Districts 4, 5, 16 |
| Brooklyn | 2016Q1 | 0 | csa | 1168.00 | Brooklyn Sector A | Districts 4, 5, 16 |
| Brooklyn | 2016Q1 | 0 | other | 10148.00 | Brooklyn Sector A | Districts 4, 5, 16 |
| Brooklyn | 2016Q1 | 0 | pop | 16900.00 | Brooklyn Sector A | Districts 4, 5, 16 |
| Brooklyn | 2016Q1 | 0 | apsw | 3848.00 | Brooklyn Sector B | Districts 3, 8, 9 |
| 0% |
2016Q12017Q12016Q4of 8 |
rel_week | integer | The relative week of the fiscal year | 0% | 1089 |
title | categorical | The title of the staff associated with a given line of payroll information. | 0% | othercpwapswof 5 |
totalcost | integer | The total dollar amount paid per title, week and sector. | 0% | 642.00476.00658.00 |