From a 33-row sample across 3 columns.
fiscal_yearagencyfiscal_yearagencyfiscal_yearagencyfiscal_yearagencyfiscal_year| fiscal_year | agency | total_value_purchased |
|---|---|---|
| 2020 | FDNY | 7877900.00 |
| 2020 | DOT | 3342100.00 |
| 2020 | NYPD | 2835500.00 |
| 2020 | NYCEM | 2045000.00 |
| 2020 | DEP | 1797800.00 |
| 2020 | DOHMH | 1609500.00 |
| 2020 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
fiscal_year | categorical | Reporting fiscal year | 0% | 201820192020of 3 |
agency | categorical | Name of the agency | 0% | DCASDEPDOHMHof 13 |
total_value_purchased | integer | Dollar value purchased by agency | 0% | 2556100.006795400.007877900.00 |
GET /api/datasets/xt4f-xvjw GET /api/datasets/xt4f-xvjw/quality GET /api/datasets/xt4f-xvjw/related GET /api/columns?dataset=xt4f-xvjw
agencyfiscal_yearagency| DOC |
| 1449700.00 |
| 2020 | DPR | 1314000.00 |
| 2020 | DCAS | 824700.00 |
| 2020 | DSNY | 446400.00 |