{"action":"opened","issue":{"url":"https://api.github.com/repos/18F/crime-data-api/issues/664","repository_url":"https://api.github.com/repos/18F/crime-data-api","labels_url":"https://api.github.com/repos/18F/crime-data-api/issues/664/labels{/name}","comments_url":"https://api.github.com/repos/18F/crime-data-api/issues/664/comments","events_url":"https://api.github.com/repos/18F/crime-data-api/issues/664/events","html_url":"https://github.com/18F/crime-data-api/issues/664","id":277447972,"number":664,"title":"Not all NIBRS victims are people","user":{"login":"harrisj","id":2044,"avatar_url":"https://avatars2.githubusercontent.com/u/2044?v=4","gravatar_id":"","url":"https://api.github.com/users/harrisj","html_url":"https://github.com/harrisj","followers_url":"https://api.github.com/users/harrisj/followers","following_url":"https://api.github.com/users/harrisj/following{/other_user}","gists_url":"https://api.github.com/users/harrisj/gists{/gist_id}","starred_url":"https://api.github.com/users/harrisj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/harrisj/subscriptions","organizations_url":"https://api.github.com/users/harrisj/orgs","repos_url":"https://api.github.com/users/harrisj/repos","events_url":"https://api.github.com/users/harrisj/events{/privacy}","received_events_url":"https://api.github.com/users/harrisj/received_events","type":"User","site_admin":false},"labels":[{"id":441986653,"url":"https://api.github.com/repos/18F/crime-data-api/labels/bug","name":"bug","color":"ee0701","default":true},{"id":547196093,"url":"https://api.github.com/repos/18F/crime-data-api/labels/data%20quality","name":"data quality","color":"b60205","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-11-28T16:25:09Z","updated_at":"2017-11-28T16:25:09Z","closed_at":null,"author_association":"MEMBER","body":"So, one potential source of confusion specifically in regards to how expert users might count things differently from the general public is that not all NIBRS victims are people. From the NIBRS documentation we have this\r\n\r\n> During a bank robbery, the offender pointed a gun at a teller, demanded, and received money. The robber also pistol-whipped a customer who stood in his way as he made his getaway from the bank. There were three victims: the bank (F = Financial Institution), the teller\r\n(I = Individual), and the pistol-whipped customer (I = Individual). Therefore, agencies should enter the appropriate codes into their respective Victim Segments.\r\n\r\nIndeed, when I look at the nibrs_victim table, I see the following breakdown of victim types for 2014:\r\n\r\n| victim_type_code |    victim_type_name     |  count  |\r\n|------------------|-------------------------|---------|\r\n| B                | Business                |  881,129 |\r\n| F                | Financial Institution   |   16,416 |\r\n| G                | Government              |   69,065 |\r\n| I                | Individual              | 3,873,256 |\r\n| L                | Law Enforcement Officer |   14,889 |\r\n| O                | Other                   |   14,868 |\r\n| R                | Religious Organization  |    9,689 |\r\n| S                | Society/Public          |  614,460 |\r\n| U                | Unknown                 |   15,284 |\r\n\r\nSo, ~1.5 million of the victims are actually not people, which is a pretty sizeable percentage. It doesn't look like we copy this field over to the nibrs_victim_denorm table right now nor do we use it to reduce the victims included in that table."}}
{"actor":{"display_login":"harrisj"}}