From a 42-row sample across 6 columns.
pub_dtfisc_yrpub_dtfisc_yrpub_dtfisc_yrpub_dt| pub_dt | fisc_yr | cat | cat_scp | est__of_cnt | cnt_amt |
|---|---|---|---|---|---|
| 20200416 | 2021 | Social Service Related and Health Services | Home Care, Child Welfare, Employment Services, Public Assistance, Day Care, Family Services, Homeless Programs, AIDS, Senior Citizen Programs, Health, Mental Hygiene & Prison Health, etc. | 4682 | 5730 |
| 20200416 | 2021 | Youth and Student Related Services | (including Transportation of Pupils and Payments to Contract Schools) | 3096 | 5847 |
| 20200416 | 2021 | Other Services |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
pub_dt | categorical | 8-digit number for date of publication | 0% | 202004162025050120230426of 7 |
fisc_yr | categorical | 4-digit year indicating the fiscal year | 0% | 202620232022of 7 |
cat | categorical | Contract Category | 0% | Social Service Related a…Youth and Student Relate…Maintenance and Operatio…of 6 |
cat_scp | categorical | Examples of the types of contracts within the category | 0% |
GET /api/datasets/h59m-jnyu GET /api/datasets/h59m-jnyu/quality GET /api/datasets/h59m-jnyu/related GET /api/columns?dataset=h59m-jnyu
| Custodial, Security Services, Secretarial, Cultural Related, Employee Related, Economic Development, Transportation, Municipal Waste Exporting, etc. |
| 3100 |
| 1707 |
| 20200416 | 2021 | Professional Services/Consultants | Accounting, Auditing, Actuarial, Education, Investment Analysis, Legal Engineering & Architectural, System Development & Management Analysis, etc. | 3550 | 1742 |
| 20200416 | 2021 | Maintenance and Operation of Infrastructure | Lighting, Street Repair, Buildings, Parks, Water Supply, Sewage and Waste Disposal, etc. | 1644 | 1241 |
| 20200416 | 2021 | Maintenance of Equipment | Data Processing, Office Equipment, Telecommunications & Motorized Equipment, etc. | 1719 | 434 |
| 20210426 | 2022 | Social Service Related and Health Services | Home Care, Child Welfare, Employment Services, Public Assistance, Day Care, Family Services, Homeless Programs, AIDS, Senior Citizen Programs, Health, Mental Hygiene & Prison Health, etc. | 4692 | 6175 |
| 20210426 | 2022 | Youth and Student Related Services | (including Transportation of Pupils and Payments to Contract Schools) | 3096 | 7106 |
| 20210426 | 2022 | Other Services | Custodial, Security Services, Secretarial, Cultural Related, Employee Related, Economic Development, Transportation, Municipal Waste Exporting, etc. | 3210 | 2096 |
| 20210426 | 2022 | Professional Services/Consultants | Accounting, Auditing, Actuarial, Education, Investment Analysis, Legal Engineering & Architectural, System Development & Management Analysis, etc. | 3599 | 1924 |
(including Transportatio…Lighting, Street Repair,…Accounting, Auditing, Ac…of 6est__of_cnt | integer | Estimated number of contracts | 0% | 311530963220 |
cnt_amt | integer | Budgeted dollar amount (rounded to millions) | 0% | 51471062407 |