From a 500-row sample across 10 columns.
service_idorganization_idservice_idagency_idcontract_idorganization_id| contract_id | organization_id | agency_id | agency_name | service_id | contract_number | fiscal_year | contract_amount | contract_end | contract_start |
|---|---|---|---|---|---|---|---|---|---|
| 17 | 2 | 69 | HRA | 5 | CT106920150003384 | FY2018 | — | — | — |
| 18 | 2 | 69 | HRA | 5 | CT106920150003386 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
contract_id | integer | Each contract must have a unique identifier. | 0% | 20427892591 |
organization_id | integer | Each contract entry should be linked to a single organization. The identifier of the organization should be given here. Details of the services the organization delivers at this location should be provided in the services_at_location table. | 0% | 1406623 |
agency_id | categorical | Each contract entry should be linked to a single agency with whom that contract is registered. | 0% | 260816125of 6 |
agency_name | categorical | Name of contracting City government agency. | 0% |
GET /api/datasets/c5up-ki6j GET /api/datasets/c5up-ki6j/quality GET /api/datasets/c5up-ki6j/related GET /api/columns?dataset=c5up-ki6j
organization_idcontract_numbercontract_idagency_name+1| FY2018 |
| — |
| — |
| — |
| 19 | 2 | 69 | HRA | 5 | CT106920161422456 | FY2018 | — | — | — |
| 20 | 2 | 69 | HRA | 5 | CT106920161423838 | FY2018 | — | — | — |
| 21 | 2 | 69 | HRA | 5 | CT106920161426883 | FY2018 | — | — | — |
| 1 | 1 | 69 | HRA | 1 | CT106920171409395 | FY2018 | 1717753 | 2019-09-30T00:00:00.000 | 2016-10-01T00:00:00.000 |
| 2 | 1 | 69 | HRA | 1 | CT106920171413068 | FY2018 | 2099475 | 2019-09-30T00:00:00.000 | 2016-10-01T00:00:00.000 |
| 3 | 1 | 69 | HRA | 2 | CT106920150002542 | FY2018 | — | — | — |
| 4 | 1 | 69 | HRA | 2 | CT106920161416161 | FY2018 | — | — | — |
| 5 | 1 | 69 | HRA | 2 | CT106920161417633 | FY2018 | 1937058 | 2018-09-30T00:00:00.000 | 2015-10-01T00:00:00.000 |
DYCDDOHMHDFTAof 6service_id | integer | The identifier of the service for a given contract. | 0% | 516294667 |
contract_amount | integer | Total Contract Budget, over full period of the contract for all sites. | 12% | 108000010920001318800 |
contract_end | datetime | Contract End Date | 11% | 2018-06-30T00:00:00.0002020-06-30T00:00:00.0002019-06-30T00:00:00.000 |
contract_start | datetime | Contract Start Date | 11% | 2015-07-01T00:00:00.0002016-07-01T00:00:00.0002017-07-01T00:00:00.000 |
contract_number | text | Unique identifier for contract in the Financial Management System (FMS) | 4% | CT178120181408927CT181620161401265CT181620180001833 |
fiscal_year | categorical | Fiscal year for the contract details reported. | 0% | FY2018FY2017of 2 |