From a 500-row sample across 14 columns.
| report_date | agency_code | agency_description | title_code | title_description | pure_prov_0_9_mos | pure_prov_10_24_mos | pure_prov_25_mos | pure_subtotal | step_prov_0_9_mos | step_prov_10_24_mos | step_prov_25_mos |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2022-08-31T00:00:00.000 | 2 | Office of the Mayor | 05026 | DIRECTOR OF INTERGOVERNMENTAL RELATIONS | 1 | 0 | 0 | 1 | 0 | 0 | 0 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
report_date | datetime | Report Date | 0% | 2008-05-31T00:00:00.0002008-08-31T00:00:00.0002008-11-30T00:00:00.000 |
agency_code | integer | Unique code identifier assigned to agencies for use across various systems | 0% | 996841740 |
agency_description | text | Full agency description | 0% | NYC Housing AuthorityDepartment of Transporta…Department of Education … |
title_code | text | Civil service title code | 0% |
GET /api/datasets/uxsm-hzx3 GET /api/datasets/uxsm-hzx3/quality GET /api/datasets/uxsm-hzx3/related GET /api/columns?dataset=uxsm-hzx3
| 2022-08-31T00:00:00.000 |
| 2 |
| Office of the Mayor |
| 05277 |
| RESEARCH PROJECTS COORDINATOR (MA) |
| 3 |
| 1 |
| 3 |
| 7 |
| 0 |
| 0 |
| 0 |
| 2022-08-31T00:00:00.000 | 2 | Office of the Mayor | 05278 | ASSISTANT TO THE DEPUTY MAYOR (OFFICE OF THE MAYOR) | 2 | 2 | 1 | 5 | 0 | 1 | 0 |
| 2022-08-31T00:00:00.000 | 2 | Office of the Mayor | 0527A | RESEARCH PROJECTS COORDINATOR (MA) (MANAGERIAL ASSIGNMENTS) | 21 | 22 | 48 | 91 | 2 | 1 | 5 |
| 2022-08-31T00:00:00.000 | 2 | Office of the Mayor | 05384 | SECRETARY (MA) | 0 | 0 | 0 | 0 | 0 | 0 | 2 |
| 2022-08-31T00:00:00.000 | 2 | Office of the Mayor | 05454 | ASSISTANT DIRECTOR OF INTRGVRN RELATIONS FOR THE ALBANY OFF | 1 | 0 | 0 | 1 | 0 | 0 | 0 |
| 2022-08-31T00:00:00.000 | 2 | Office of the Mayor | 05482 | SENIOR PROJECT PLANNER (MA) | 0 | 0 | 1 | 1 | 0 | 0 | 0 |
| 2022-08-31T00:00:00.000 | 2 | Office of the Mayor | 06144 | ASSISTANT LEGISLATIVE REPRESENTATIVE (MA) | 0 | 0 | 1 | 1 | 0 | 0 | 0 |
| 2022-08-31T00:00:00.000 | 2 | Office of the Mayor | 06393 | STAFF ASSISTANT (OFFICE OF THE AUDITOR GENERAL-MA) | 1 | 3 | 5 | 9 | 0 | 0 | 0 |
| 2022-08-31T00:00:00.000 | 2 | Office of the Mayor | 06405 | MAYORAL OFFICE ASSISTANT (MA) | 1 | 1 | 15 | 17 | 0 | 0 | 1 |
Showing 12 of 14 columns. All of them are listed below.
100501002610033title_description | text | Civil service title code description | 0% | COMPUTER SYSTEMS MANAGERADMINISTRATIVE STAFF ANA…ADMINISTRATIVE PUBLIC IN… |
pure_prov_0_9_mos | integer | # of provisionals without a permanent line serving fewer than 10 months in their current appointment | 0% | 012 |
pure_prov_10_24_mos | integer | # of provisionals without a permanent line serving between 10 and 24 months in their current appointment | 0% | 012 |
pure_prov_25_mos | integer | # of provisionals without a permanent line serving more than 24 months in their current appointment | 0% | 012 |
pure_subtotal | integer | Total # of pure provisionals | 0% | 102 |
step_prov_0_9_mos | integer | # of provisionals with a permanent line serving fewer than 10 months in their current appointment | 0% | 012 |
step_prov_10_24_mos | integer | # of provisionals with a permanent line serving between 10 and 24 months in their current appointment | 0% | 012 |
step_prov_25_mos | integer | # of provisionals without a permanent line serving more than 24 months in their current appointment | 0% | 012 |
step_subtotal | integer | Total # of "step-up" provisionals | 0% | 012 |
total_count | integer | Total # of provisionals | 0% | 123 |