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.

Column
From
To

MostSeriousBiasType

Race/Ethnicity/National Origin

Race/Ethnicity/Ancestry

MostSeriousBiasType

Religious

Religion

Offensive_Act

Annoying Telephone Calls/Facisimiles

Annoying telephone calls/fax

MostSeriousBias

Anti-Lesbian (Women)

Anti-Lesbian

MostSeriousLocation

Highway/Road/Alley/Street/Sidewalk

Highway/Road/Alley/Street

WeaponType

Blunt Object

Blunt object (bludgeon, club, etc.)

WeaponType

Firearm

Firearm (unknown whether handgun, rifle, or shotgun)

WeaponType

Other ( bottle, rocks, spitting)

Other (bottle, rocks, spitting)

WeaponType

Other Gun

Other gun (pellet, BB, stun gun, etc.)

WeaponType

Personal Weapons

Personal weapons (hands, feet, teeth, etc.)

WeaponType

Other

Other (bottle, rocks, spitting)

Last updated

Was this helpful?