From a 500-row sample across 13 columns.
agency_nametotalagency_namepublication_dateagency_namepublication_dateagency_number+1agency_name| publication_date | agency_number | agency_name | fiscal_year | personnel_type_code | personnel_type_name | code_for_full_time_ftes | full_time_full_time_equivalents_ft_fte_positions | city_funded_headcount | ifa_funded_headcount | cd_funded_headcount | other_funded_headcount |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 20260630 | 002 | Mayoralty | 2027 | C | Civilian | 3 | Full-Time Plus Full-Time Equivalent | 1129 | 146 | 27 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
publication_date | text | — | 0% | 202306302026051220240116 |
agency_number | text | — | 0% | 827042072 |
agency_name | text | — | 0% | Fire DepartmentPolice DepartmentCity University |
fiscal_year | categorical | — | 0% | 202620252024of 15 |
personnel_type_code |
GET /api/datasets/2t2c-qih9 GET /api/datasets/2t2c-qih9/quality GET /api/datasets/2t2c-qih9/related GET /api/columns?dataset=2t2c-qih9
| 46 |
| 20260630 | 002 | Mayoralty | 2028 | C | Civilian | 3 | Full-Time Plus Full-Time Equivalent | 1111 | 146 | 27 | 46 |
| 20260630 | 002 | Mayoralty | 2026 | C | Civilian | 3 | Full-Time Plus Full-Time Equivalent | 1093 | 139 | 27 | 31 |
| 20260630 | 002 | Mayoralty | 2027 | C | Civilian | 2 | Full-Time Equivalent | 17 | 1 | 3 | 0 |
| 20260630 | 002 | Mayoralty | 2028 | C | Civilian | 1 | Full-Time | 1094 | 145 | 24 | 46 |
| 20260630 | 002 | Mayoralty | 2028 | C | Civilian | 2 | Full-Time Equivalent | 17 | 1 | 3 | 0 |
| 20260630 | 002 | Mayoralty | 2026 | C | Civilian | 1 | Full-Time | 1074 | 138 | 24 | 31 |
| 20260630 | 002 | Mayoralty | 2026 | C | Civilian | 2 | Full-Time Equivalent | 19 | 1 | 3 | 0 |
| 20260630 | 002 | Mayoralty | 2027 | C | Civilian | 1 | Full-Time | 1112 | 145 | 24 | 46 |
| 20260630 | 002 | Mayoralty | 2029 | C | Civilian | 1 | Full-Time | 1089 | 145 | 24 | 21 |
Showing 12 of 13 columns. All of them are listed below.
| categorical |
| — |
| 0% |
CUPof 3 |
personnel_type_name | categorical | — | 0% | CivilianUniformPedagogicalof 3 |
code_for_full_time_ftes | categorical | — | 0% | 123of 3 |
full_time_full_time_equivalents_ft_fte_positions | categorical | — | 0% | Full-Time EquivalentFull-Time Plus Full-Time…Full-Timeof 3 |
city_funded_headcount | integer | — | 0% | 0213 |
ifa_funded_headcount | integer | — | 0% | 013 |
cd_funded_headcount | integer | — | 0% | 012 |
other_funded_headcount | integer | — | 0% | 012 |
total | integer | — | 0% | 0213 |