DAAF-Contribution-Community/daaf / .claude/skills/education-data-source-campus-safety
education-data-source-campus-safety
VerifiedCSS — annual Clery Act crime/fire safety for Title IV institutions. Portal: hate crimes only (2005-2021); primary offenses, VAWA, arrests, fire safety need ope.ed.gov directly. Use for campus crime analysis. Identified by IPEDS unitid.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 22.8 KB |
| references/arrests-referrals.md | markdown | 9.0 KB |
| references/campus-geography.md | markdown | 10.9 KB |
| references/clery-act.md | markdown | 9.6 KB |
| references/crime-categories.md | markdown | 10.1 KB |
| references/fire-safety.md | markdown | 8.9 KB |
| references/hate-crimes.md | markdown | 13.0 KB |
| references/limitations.md | markdown | 10.1 KB |
| references/variable-definitions.md | markdown | 18.3 KB |
| references/vawa-offenses.md | markdown | 9.2 KB |
references/hate-crimes.md
View on GitHub# Hate Crimes: Bias Categories and Classification
> **CRITICAL: Portal Integer Encoding**
>
> The Education Data Portal uses **integer codes** for bias categories and crime types:
>
> | Code | Bias Category | Code | Crime Type |
> |------|---------------|------|------------|
> | `1` | Race | `11` | Simple Assault |
> | `2` | Religion | `12` | Larceny |
> | `3` | Sexual orientation (Portal label "Sex") | `13` | Intimidation |
> | `4` | Gender | `14` | Destruction, Damage, or Vandalism |
> | `99` | Total | — | *(crime_type has no Total code)* |
>
> **`crime_type` values are `1`-`18` only** — code `99` (Total) does NOT appear in the actual mirror data (empirically verified 2026-08-07), despite older references documenting it. See `variable-definitions.md` for complete mappings. Verify codes against the live codebook.
> Use `get_codebook_url("csafety/codebook_colleges_csafety_hate_crimes")` from `fetch-patterns.md`.
## Definition
A hate crime is a criminal offense that manifests evidence that the victim was intentionally selected because of the perpetrator's bias against the victim.
**Key Elements**:
- Must be a criminal offense (one of the specified Clery crimes)
- Must show evidence of bias motivation
- Bias must be against the victim (not general bias)
- Selection must be intentional
## Bias Categories (Portal Integer Encoding)
Under the Clery Act, institutions report hate crimes motivated by bias based on eight categories:
### Code 1: Race
**Definition**: A preformed negative attitude toward a group of persons who possess common physical characteristics genetically transmitted by descent and heredity which distinguish them as a distinct division of humankind.
**Examples**: Anti-Black, Anti-White, Anti-Asian, Anti-Hispanic (when based on race rather than ethnicity), Anti-American Indian/Alaska Native, Anti-Native Hawaiian/Pacific Islander, Anti-Multiple Races
### Code 2: Religion
**Definition**: A preformed negative opinion or attitude toward a group of persons who share the same religious beliefs regarding the origin and purpose of the universe and the existence or nonexistence of a supreme being.
**Examples**: Anti-Jewish, Anti-Islamic (Muslim), Anti-Catholic, Anti-Protestant, Anti-Atheist/Agnostic, Anti-Buddhist, Anti-Hindu, Anti-Sikh, Anti-Other Religion
### Code 3: Sexual Orientation (Portal label "Sex")
**Portal code**: the Portal metadata labels code 3 "Sex"; Portal 2017 rows match UC Berkeley's CY2017 ASR entries for "Sexual Orientation". For the code-order provenance (2019 CSS form) and known row-level Portal/ASR disagreements, see `variable-definitions.md` § Bias Category Codes.
**Definition**: A preformed negative opinion or attitude toward a group of persons based on their actual or perceived sexual orientation.
**Sexual orientation**: Physical, romantic, or emotional attraction to members of the same or different sex.
**Examples**: Anti-Gay (Male), Anti-Lesbian, Anti-Bisexual, Anti-Heterosexual, Anti-LGBTQ+ (general)
### Code 4: Gender
**Definition**: A preformed negative opinion or attitude toward a person or group of persons based on their actual or perceived gender.
**Gender**: The actual or perceived sex of a person, including the cultural expectations associated with a person's sex.
**Note**: This is distinct from gender identity.
### Code 5: Gender Identity
**Definition**: A preformed negative opinion or attitude toward a person or group of persons based on their actual or perceived gender identity.
**Gender identity**: The gender-related characteristics or manner in which individuals identify themselves, regardless of their actual sex at birth.
**Examples**: Anti-Transgender, Anti-Gender Non-Conforming
**Note**: Added to the statutory bias categories by VAWA 2013 (Pub. L. 113-4). Code 5 was observed in the UC Berkeley 2016 Portal probe but not the 2010 probe.
### Code 6: Disability
**Definition**: A preformed negative opinion or attitude toward a group of persons based on their physical or mental impairments, whether such disability is temporary or permanent, congenital or acquired by heredity, accident, injury, advanced age, or illness.
**Examples**: Anti-Physical Disability, Anti-Mental Disability
### Code 7: Ethnicity
**Definition**: A preformed negative opinion or attitude toward a group of people whose members identify with each other, through a common heritage, often consisting of a common language, common culture, and/or ideology that stresses common ancestry.
**Examples**: Anti-Hispanic/Latino, Anti-Arab (when based on ethnicity), Anti-Other Ethnicity
**Note**: VAWA 2013 (Pub. L. 113-4) added national origin and gender identity to the statutory bias categories (ethnicity was already listed). The Portal carries pre-2014 ethnicity as code 9 and post-2014 ethnicity/national origin as codes 7/8 — do not splice 9 with 7 without documenting the break.
### Code 8: National Origin (Portal label "Nationality")
**Definition**: A preformed negative opinion or attitude toward a group of people based on their actual or perceived country of birth.
**Examples**: Anti-Mexican National, Anti-Chinese National, Anti-Iranian National
**Note**: National origin was added to the statutory bias categories by VAWA 2013 (Pub. L. 113-4). Portal 2017 rows match UC Berkeley's CY2017 ASR entry for "National Origin".
### Code 9: Ethnicity (Pre 2014)
Portal label "Ethnicity (Pre 2014)": the ethnicity category in pre-2014 rows. Code 9 was observed in the UC Berkeley 2010 Portal probe and not in the 2016 probe; codes 5, 7 and 8 the reverse. Document the break before splicing 9 with 7.
### Code 99: Total
All bias categories combined. Use for aggregate counts across all bias types.
## Hate Crime Offenses
### Primary Clery Crimes
All primary Clery crimes can be classified as hate crimes if bias-motivated:
- Murder and Non-negligent Manslaughter
- Manslaughter by Negligence
- Rape
- Fondling
- Incest
- Statutory Rape
- Robbery
- Aggravated Assault
- Burglary
- Motor Vehicle Theft
- Arson
### Additional Hate Crime-Only Offenses
Four additional offenses are reported **only** when motivated by bias:
#### Larceny-Theft
**Definition**: The unlawful taking, carrying, leading, or riding away of property from the possession or constructive possession of another.
**Includes**:
- Pocket-picking
- Purse-snatching (without force)
- Shoplifting
- Theft from buildings
- Theft from vehicles
- Bicycle theft
- All other larceny
**Note**: Without bias motivation, larceny is NOT a Clery-reportable crime.
#### Simple Assault
**Definition**: An unlawful physical attack by one person upon another where neither the offender displays a weapon, nor the victim suffers obvious severe or aggravated bodily injury involving apparent broken bones, loss of teeth, possible internal injury, severe laceration, or loss of consciousness.
**Distinction from Aggravated Assault**: No weapon, no serious injury
**Note**: Without bias motivation, simple assault is NOT a Clery-reportable crime.
#### Intimidation
**Definition**: To unlawfully place another person in reasonable fear of bodily harm through the use of threatening words and/or other conduct, but without displaying a weapon or subjecting the victim to actual physical attack.
**Examples**:
- Verbal threats
- Written threats
- Threatening gestures
- Following behavior intended to threaten
- Online/cyber intimidation
**Note**: Without bias motivation, intimidation is NOT a Clery-reportable crime.
#### Destruction/Damage/Vandalism of Property
**Definition**: To willfully or maliciously destroy, damage, deface, or otherwise injure real or personal property without the consent of the owner or the person having custody or control of it.
**Examples**:
- Graffiti with bias messages
- Defacing property with hate symbols
- Destruction of religious objects
- Vandalism targeting specific groups
**Note**: Without bias motivation, vandalism is NOT a Clery-reportable crime (unless arson).
## Classification Process
### Determining Bias Motivation
**Evidence of Bias May Include**:
- Oral comments, written statements, or gestures made by the offender
- Drawings, markings, symbols, or graffiti
- Hate group involvement
- Previous bias incidents
- Victim's perception
- Offender's admission
- Community context
- Pattern of similar incidents
**Factors to Consider**:
1. Was the victim a member of a group identifiable by bias category?
2. Were bias indicators present at the scene?
3. Did the offender perceive the victim as belonging to an identifiable group?
4. Was there any connection to prior bias incidents?
5. Was the incident proximate to a date of significance to bias groups?
### Two-Pronged Test
1. **Was a Clery crime committed?** (or hate crime-only offense)
2. **Was there evidence that the victim was selected due to bias?**
If both are yes, it is reported as a hate crime.
### Uncertain Cases
When bias motivation is unclear:
- Report as a hate crime if objective facts support bias determination
- Do not require proof beyond reasonable doubt
- Use "preponderance of evidence" standard
- When in doubt, institutions often consult with law enforcement
## Reporting Requirements
### Statistical Reporting
Hate crimes are reported:
- By calendar year
- By geographic category (on-campus, residence halls, noncampus, public property)
- By bias category
- By crime type
### Hierarchy Rule Exception
**Hate crimes are NOT subject to the hierarchy rule**:
- Report each hate crime regardless of other crimes in the same incident
- If multiple bias categories motivate one crime, select one and note others in caveat
### Multiple Bias Motivations
When a single hate crime is motivated by multiple biases:
- Select one bias for the data table
- Note additional biases in the caveat/notes
- Example: A crime motivated by both race and religion bias would be counted once with one bias selected
### Data Variables (Portal Format)
In Portal mirror parquet files:
| Variable | Type | Description |
|----------|------|-------------|
| `crime_type` | Integer | Crime type code (1-18; no code 99/Total in the data) |
| `bias` | Integer | Bias category code (1-9, 99) |
| `on_campus_hate_crimes` | Integer | Count on campus |
| `residence_hall_hate_crimes` | Integer | Count in residence halls |
| `non_campus_hate_crimes` | Integer | Count at noncampus properties |
| `public_property_hate_crimes` | Integer | Count on public property |
| `other_hate_crimes` | Integer | Count in other locations |
| `total_hate_crimes` | Integer | Sum of location columns; appears to add the residence-hall subset to on-campus (double-counting housing incidents — verified against UC Berkeley CY2016–2017 and UC Riverside CY2015 ASRs). Recompute as on_campus + non_campus + public_property (+ other) |
**Filtering Example**:
```python
import polars as pl
# Race-based intimidation crimes
df.filter(
(pl.col("bias") == 1) & # Race
(pl.col("crime_type") == 13) # Intimidation
)
```
```r
# R equivalent
library(dplyr)
# Race-based intimidation crimes
df |> filter(bias == 1, crime_type == 13)
```
## Historical Changes
### 2008 Changes
Effective with 2008 calendar year:
- Added larceny-theft, simple assault, intimidation, and destruction/damage/vandalism as hate crime-only offenses
### 2013 Changes (VAWA)
VAWA 2013 (Pub. L. 113-4) added national origin and gender identity to the statutory bias categories (ethnicity was already listed). The Portal carries pre-2014 ethnicity as code 9 and post-2014 ethnicity/national origin as codes 7/8 — do not splice 9 with 7 without documenting the break.
VAWA 2013 required good-faith reporting starting with calendar-year 2013 statistics in the October 1, 2014 ASR; the final regulations (79 FR 62752, Oct. 20, 2014) took effect July 1, 2015, and statistics for 2013–2014 did not have to be revised to the final definitions.
**Pre-2014 Portal Data** (observed in UC Berkeley 2010/2016 Portal probes):
- Bias code 9 ("Ethnicity (Pre 2014)") appears; codes 5, 7 and 8 do not
- Gender identity was not a separate category
- Comparisons across this period require caution
## Interpretation Guidance
### What Hate Crime Statistics Show
- Crimes where evidence of bias motivation was present
- Reported to Campus Security Authorities or law enforcement
- Meeting Clery definitions and geography requirements
### What They Do NOT Show
- All bias-motivated incidents on campus
- Microaggressions or bias incidents not rising to criminal level
- Incidents not reported to appropriate officials
- Incidents where bias could not be established
### Contextual Factors
**Low Numbers May Indicate**:
- Actual low incidence of hate crimes
- Underreporting
- Failure to identify bias motivation
- Victims not recognizing incidents as crimes
**Higher Numbers May Indicate**:
- More hate crime activity
- Better reporting mechanisms
- Better identification of bias motivation
- Greater trust in reporting systems
### Research Considerations
- Hate crime statistics are particularly sensitive to reporting culture
- Small absolute numbers make statistical analysis challenging
- Single incidents can significantly affect institutional statistics
- Year-to-year variation may not indicate trends
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| brainstormingobra/superpowersYou MUST use this before any creative work - creating features, building components, adding functionality, modifying behavior, or planning anything new, in software or out of it (a talk, a business, a renovation). | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| brand-guidelinesanthropics/skillsApplies Anthropic's official brand colors and typography to any sort of artifact that may benefit from having Anthropic's look-and-feel. Use it when brand colors or style guidelines, visual formatting, or company design standards apply. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| frontend-designanthropics/skillsGuidance for distinctive, intentional visual design when building new UI or reshaping an existing one. Helps with aesthetic direction, typography, and making choices that don't read as templated defaults. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| mcp-builderanthropics/skillsGuide for creating high-quality MCP (Model Context Protocol) servers that enable LLMs to interact with external services through well-designed tools. Use when building MCP servers to integrate external APIs or services, whether in Python (FastMCP) or Node/TypeScript (MCP SDK). | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |