From a 49-row sample across 8 columns.
fiscal_yearagencyfiscal_yearagencyfiscal_yearagencyfiscal_yearagencyfiscal_year| fiscal_year | agency | construction_count | construction_contract_value | project_labor_agreement_count | project_labor_agreement | apprenticeship_program | apprenticeship_program_1 |
|---|---|---|---|---|---|---|---|
| 2020 | DCAS | 6 | 118829600 | 4 | 110221000.00 | 0 | 0.00 |
| 2020 | DDC | 66 | 775637000 | 13 | 55339800.00 | 44 | 687521300.00 |
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% | 201820202019of 3 |
agency | text | Name of the agency | 0% | DCASDHSFDNY |
construction_count | integer | Count of Total construction contracts | 0% | 123 |
construction_contract_value | integer | Dollar value of total construction contracts | 0% | 690440055367990013987300.00 |
GET /api/datasets/6w36-zfn5 GET /api/datasets/6w36-zfn5/quality GET /api/datasets/6w36-zfn5/related GET /api/columns?dataset=6w36-zfn5
agencyfiscal_yearagencyfiscal_yearagencyfiscal_year| 2020 | DEP | 45 | 553679900 | 36 | 352577900.00 | 2 | 12558000.00 |
| 2020 | DHS | 2 | 9258600 | 1 | 8297000.00 | 0 | 0.00 |
| 2020 | DOB | 1 | 6571600 | 1 | 6571600.00 | 0 | 0.00 |
| 2020 | DOC | 2 | 7550200 | 1 | 7184500.00 | 0 | 0.00 |
| 2020 | DOE | 15 | 176640400 | 0 | 0.00 | 0 | 0.00 |
| 2020 | DOT | 23 | 505217700 | 0 | 0.00 | 21 | 471595300.00 |
| 2020 | DPR | 123 | 446348900 | 17 | 75725000.00 | 32 | 170143900.00 |
| 2020 | DSNY | 3 | 25685200 | 3 | 25685200.00 | 0 | 0.00 |
project_labor_agreement_count |
| categorical |
| Count of contracts under Project Labor Agreement |
| 0% |
013of 16 |
project_labor_agreement | integer | Dollar value of contracts under Project Labor Agreement | 0% | 0.003000000.006904400.00 |
apprenticeship_program | categorical | Count of contracts under Apprenticeship Program Directive | 0% | 012of 14 |
apprenticeship_program_1 | categorical | Dollar value of contracts under Apprenticeship Program Directive | 0% | 0.00138513100.00211870200.00of 17 |