# Change Log: Police Department Investigated Hate Crimes

### November 2023

During a routine review of the dataset, multiple inconstancies in data terminology were found between data pre 2021, and post 2021.  These inconstancies were made uniform and reloaded into DataSF.

The following columns had terms adjusted to allow for a unform set of terminology throughout the dataset. This will allow for a more consistent analysis over time with these particular fields.&#x20;

<table><thead><tr><th width="211">Column</th><th>From</th><th>To</th></tr></thead><tbody><tr><td><em>MostSeriousBiasType</em></td><td><em>Race/Ethnicity/National Origin</em></td><td><em>Race/Ethnicity/Ancestry</em></td></tr><tr><td><em>MostSeriousBiasType</em></td><td><em>Religious</em></td><td><em>Religion</em></td></tr><tr><td><em>Offensive_Act</em></td><td><em>Annoying Telephone Calls/Facisimiles</em></td><td><em>Annoying telephone calls/fax</em></td></tr><tr><td><em>MostSeriousBias</em></td><td><em>Anti-Lesbian (Women)</em></td><td><em>Anti-Lesbian</em></td></tr><tr><td><em>MostSeriousLocation</em></td><td><em>Highway/Road/Alley/Street/Sidewalk</em></td><td><em>Highway/Road/Alley/Street</em></td></tr><tr><td><em>WeaponType</em></td><td><em>Blunt Object</em></td><td><em>Blunt object (bludgeon, club, etc.)</em></td></tr><tr><td><em>WeaponType</em></td><td><em>Firearm</em></td><td><em>Firearm (unknown whether handgun, rifle, or shotgun)</em></td></tr><tr><td><em>WeaponType</em></td><td><em>Other ( bottle, rocks, spitting)</em></td><td><em>Other (bottle, rocks, spitting)</em></td></tr><tr><td><em>WeaponType</em></td><td><em>Other Gun</em></td><td><em>Other gun (pellet, BB, stun gun, etc.)</em></td></tr><tr><td><em>WeaponType</em></td><td><em>Personal Weapons</em></td><td><em>Personal weapons (hands, feet, teeth, etc.)</em></td></tr><tr><td><em>WeaponType</em></td><td><em>Other</em></td><td><em>Other (bottle, rocks, spitting)</em></td></tr></tbody></table>
