From a 500-row sample across 6 columns.
incident_keyincident_key| incident_key | victim_id | victim_age_group | victim_sex | victim_race | stat_murder_flg |
|---|---|---|---|---|---|
| 299453927 | 299453927-1 | 25-44 | MALE | BLACK | N |
| 212336415 | 212336415-1 | 18-24 | MALE | BLACK | N |
| 280768895 | 280768895-1 | 25-44 | MALE | BLACK | N |
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% | 31132786320033133380484245 |
victim_id | text | Randomly generated persistent ID for each victim | 0% | 320643662-1321420696-1319347278-1 |
victim_age_group | categorical | Victim’s age within a category | 0% | 25-4418-24<18of 7 |
victim_sex | categorical | Victim’s sex description | 0% | MALEFEMALEUNKNOWN |
GET /api/datasets/pztn-9bne GET /api/datasets/pztn-9bne/quality GET /api/datasets/pztn-9bne/related GET /api/columns?dataset=pztn-9bne
incident_key| 141824677 |
| 141824677-27687 |
| 25-44 |
| MALE |
| BLACK HISPANIC |
| N |
| 270079203 | 270079203-1 | 45-64 | MALE | BLACK | Y |
| 138882700 | 138882700-26963 | 25-44 | MALE | BLACK | N |
| 138882700 | 138882700-26964 | 45-64 | MALE | BLACK | N |
| 289881880 | 289881880-1 | 25-44 | MALE | WHITE HISPANIC | N |
| 305930898 | 305930898-1 | 25-44 | MALE | BLACK | N |
| 138899428 | 138899428-26973 | 18-24 | MALE | BLACK | N |
victim_race | categorical | Victim’s race description | 0% | BLACKWHITE HISPANICBLACK HISPANICof 7 |
stat_murder_flg | categorical | Shooting resulted in the victim’s death which would be counted as a murder | 0% | NYof 2 |