From a 500-row sample across 8 columns.
racegenderracesexracegender| gender | race | mos_type | ranklit | sex | appdate | yearsonjob | yearsonjob_bins |
|---|---|---|---|---|---|---|---|
| Male | Hispanic | Uniform | Police Officer | Male | 2025-12-17T00:00:00.000 | 0 | 0 |
| Male | Hispanic | Uniform | Police Officer | Male | 2025-12-17T00:00:00.000 | 0 | 0 |
| Male | Hispanic |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
gender | categorical | Field indicating member of service's gender | 0% | MaleFemaleNon-Binaryof 5 |
race | categorical | Field indicating member of service's race | 0% | HispanicWhiteBlackof 5 |
mos_type | categorical | Field categorizing members as either Civilian or Uniform | 0% | UniformCivilianof 2 |
ranklit | text | Field indicating member of service's rank or title | 0% | Police OfficerDetective |
GET /api/datasets/5vr7-5fki GET /api/datasets/5vr7-5fki/quality GET /api/datasets/5vr7-5fki/related GET /api/columns?dataset=5vr7-5fki
racesex| Uniform |
| Police Officer |
| Male |
| 2025-12-17T00:00:00.000 |
| 0 |
| 0 |
| Male | Hispanic | Uniform | Police Officer | Male | 2025-12-17T00:00:00.000 | 0 | 0 |
| Male | Hispanic | Uniform | Police Officer | Male | 2025-12-17T00:00:00.000 | 0 | 0 |
| Male | Hispanic | Uniform | Police Officer | Male | 2025-12-17T00:00:00.000 | 0 | 0 |
| Male | Hispanic | Uniform | Police Officer | Male | 2025-12-17T00:00:00.000 | 0 | 0 |
| Male | Hispanic | Uniform | Police Officer | Male | 2025-12-17T00:00:00.000 | 0 | 0 |
| Male | Hispanic | Uniform | Police Officer | Male | 2025-12-17T00:00:00.000 | 0 | 0 |
| Male | Hispanic | Uniform | Police Officer | Male | 2025-12-17T00:00:00.000 | 0 | 0 |
Sergeantsex | categorical | — | 0% | MaleFemaleNon-Binaryof 5 |
appdate | datetime | Field containing the date the member was appointed | 0% | 2011-07-06T00:00:00.0002025-12-17T00:00:00.0002026-04-22T00:00:00.000 |
yearsonjob | integer | Calculate field determine the number of years the member has in service | 0% | 013 |
yearsonjob_bins | categorical | Field used for charting purposes. Groups Years on Job into 5 year bins/groups | 0% | 0510of 11 |