From a 500-row sample across 8 columns.
totalagency_nameagency_nameagency_nameagency_name| pub_date | agency | agency_name | fyear | unipedname | agy_grp | city | total |
|---|---|---|---|---|---|---|---|
| 20200416 | 002 | Mayoralty | 2021 | Civilian | Mayoral Agencies & Elected Officials | 1106 | 1331 |
| 20200416 | 002 | Mayoralty | 2022 | Civilian | Mayoral Agencies & Elected Officials | 1100 | 1325 |
| 20200416 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
pub_date | categorical | 8 - digit number for date of publication. | 0% | 202605122021011420250501of 13 |
agency | text | 3 - digit code which identifies an agency. | 16% | 072057827 |
agency_name | text | Descriptive name associated with the 3 -digit code. | 0% | Fire DepartmentPolice DepartmentCity University |
fyear | categorical | Indicates the fiscal year. | 0% | 202620252024of 10 |
GET /api/datasets/84ax-hg3y GET /api/datasets/84ax-hg3y/quality GET /api/datasets/84ax-hg3y/related GET /api/columns?dataset=84ax-hg3y
| 002 |
| Mayoralty |
| 2023 |
| Civilian |
| Mayoral Agencies & Elected Officials |
| 1098 |
| 1298 |
| 20200416 | 002 | Mayoralty | 2024 | Civilian | Mayoral Agencies & Elected Officials | 1098 | 1298 |
| 20200416 | 003 | Board of Elections | 2021 | Civilian | Mayoral Agencies & Elected Officials | 1079 | 1079 |
| 20200416 | 003 | Board of Elections | 2022 | Civilian | Mayoral Agencies & Elected Officials | 1079 | 1079 |
| 20200416 | 003 | Board of Elections | 2023 | Civilian | Mayoral Agencies & Elected Officials | 1079 | 1079 |
| 20200416 | 003 | Board of Elections | 2024 | Civilian | Mayoral Agencies & Elected Officials | 1079 | 1079 |
| 20200416 | 004 | Campaign Finance Board | 2021 | Civilian | Mayoral Agencies & Elected Officials | 151 | 151 |
| 20200416 | 004 | Campaign Finance Board | 2022 | Civilian | Mayoral Agencies & Elected Officials | 110 | 110 |
unipedname | categorical | Civilian, Pedagogical, Uniform. | 0% | CivilianUniformPedagogicalof 3 |
agy_grp | categorical | Mayoral Agencies & Elected Officials, Covered Organizations. | 0% | Mayoral Agencies & Elect…Covered Organizationsof 2 |
city | integer | Number of estimated city funded positions. | 0% | 01371 |
total | integer | Number of estimated total funded positions. | 0% | 13871 |