From a 50-row sample across 4 columns.
agencyfiscal_yearagencyfiscal_yearagencyfiscal_yearagencyfiscal_yearcountagency| fiscal_year | agency | median_cycle_time_in_days | count |
|---|---|---|---|
| 2020 | ACS | 192 | 2 |
| 2020 | DCAS | 114 | 108 |
| 2020 | DDC | 192 | 59 |
| 2020 | DEP | 157 | 65 |
| 2020 | DOB | 133 | 1 |
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% | DCASDSNYDPRof 19 |
median_cycle_time_in_days | float | Citywide median cycle time (days) for competitive sealed bids (CSBs) | 0% | 232192195 |
count | integer | Count of CSB contracts | 0% | 125 |
GET /api/datasets/d6di-qmzq GET /api/datasets/d6di-qmzq/quality GET /api/datasets/d6di-qmzq/related GET /api/columns?dataset=d6di-qmzq
fiscal_yearagencyfiscal_yearcountagencyfiscal_year| 2020 |
| DOC |
| 191 |
| 7 |
| 2020 | DOF | 279 | 4 |
| 2020 | DOT | 195 | 34 |
| 2020 | DPR | 242 | 112 |
| 2020 | DSNY | 232 | 5 |