From a 52-row sample across 8 columns.
fiscal_yearagency| fiscal_year | change_order_type | agency | count | original_contract_value | change_order_contract_value | change_order_contract_in | days_processing_in_fiscal |
|---|---|---|---|---|---|---|---|
| 2018 | Construction Change Order | DCAS | 16 | 37276400.00 | 4514200.00 | 0.12 | 43 |
| 2018 | Construction Change Order | DDC | 915 | 2808608200.00 | 112326100.00 | 0.04 |
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% | 201920182020of 3 |
change_order_type | categorical | Indicates design or construction change order | 0% | Construction Change Orde…Design Change Orderof 2 |
agency | categorical | Name of the agency | 0% | DSNYDDCDEPof 14 |
count | integer | Count of CCO/DCO contracts. Each change order is counted separately, even if they modify the same base contract. | 0% | 1 |
GET /api/datasets/a2w2-wg79 GET /api/datasets/a2w2-wg79/quality GET /api/datasets/a2w2-wg79/related GET /api/columns?dataset=a2w2-wg79
| 57 |
| 2018 | Construction Change Order | DEP | 142 | 4536193700.00 | 26591700.00 | 0.01 | 113 |
| 2018 | Construction Change Order | DHS | 3 | 3872900.00 | 3423900.00 | 0.88 | 201 |
| 2018 | Construction Change Order | DOB | 1 | 190000.00 | 170000.00 | 0.89 | 242 |
| 2018 | Construction Change Order | DOC | 6 | 50699800.00 | 17269300.00 | 0.34 | 46 |
| 2018 | Construction Change Order | DOT | 73 | 792398700.00 | 45422300.00 | 0.06 | 54 |
| 2018 | Construction Change Order | DPR | 217 | 277915000.00 | 15385700.00 | 0.06 | 54 |
| 2018 | Construction Change Order | DSNY | 7 | 158803200 | 43000 | 0 | 11 |
| 2018 | Construction Change Order | FDNY | 2 | 39503200 | 21270100 | 0.54 | 90 |
32original_contract_value | integer | Aggregate dollar value of modified contracts at the time of registration. Base contract values for contracts modified multiple times are counted once. | 0% | 2000000.001779985000474021700.00 |
change_order_contract_value | float | Net aggregate change order dollar amount of CCO/DCO contracts. | 0% | 300000.0015385700.0010909314.00 |
change_order_contract_in | float | Percent dollar amount of total net change orders against base contract amounts. | 0% | 0.010.040.06 |
days_processing_in_fiscal | integer | Number of days for processing in current fiscal year | 0% | 431354 |