From a 500-row sample across 5 columns.
incident_keyperp_raceperp_sexperp_age_group+1| incident_key | perp_id | perp_age_group | perp_sex | perp_race |
|---|---|---|---|---|
| 288208647 | 288208647-1 | 25-44 | MALE | ASIAN / PACIFIC ISLANDER |
| 73517103 | 73517103-18843 | 25-44 | MALE | ASIAN / PACIFIC ISLANDER |
| 193462348 | 193462348-1 | 25-44 | MALE | ASIAN / PACIFIC ISLANDER |
| 186606271 | 186606271-1 | 18-24 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
incident_key | integer | Randomly generated persistent ID for each incident | 0% | 194915415137962902141562036 |
perp_id | text | Randomly generated persistent ID for each suspect (perpetrator) | 0% | 322454605-2320906869-1322204084-1 |
perp_age_group | categorical | Perpetrator’s age within a category | 0% | 18-2425-44UNKNOWNof 12 |
perp_sex | categorical | Perpetrator’s sex description | 0% | MALEUNKNOWNFEMALE |
GET /api/datasets/gdk4-mbsv GET /api/datasets/gdk4-mbsv/quality GET /api/datasets/gdk4-mbsv/related GET /api/columns?dataset=gdk4-mbsv
perp_raceperp_sexperp_age_group+1| MALE |
| ASIAN / PACIFIC ISLANDER |
| 168757750 | 168757750-26618 | 25-44 | MALE | ASIAN / PACIFIC ISLANDER |
| 81042175 | 81042175-20813 | 18-24 | MALE | ASIAN / PACIFIC ISLANDER |
| 71701593 | 71701593-18415 | 25-44 | MALE | ASIAN / PACIFIC ISLANDER |
| 59801053 | 59801053-16524 | 18-24 | MALE | ASIAN / PACIFIC ISLANDER |
| 220553700 | 220553700-1 | 18-24 | MALE | ASIAN / PACIFIC ISLANDER |
| 220063007 | 220063007-1 | 18-24 | MALE | ASIAN / PACIFIC ISLANDER |
perp_race | categorical | Perpetrator’s race description | 0% | BLACKWHITE HISPANICUNKNOWNof 7 |