← All datasets

# explorer.crime
HPD crime (NIBRS offenses) 2020-2024, one row per offense record, typed columns (1,255,717 rows; category: Public safety; geometry column `geom` (Point, EPSG:4326))
Notes: Sum offense_count for totals, or count(*) for records. Crimes against persons (assault, homicide, sex offenses) = nibrs_group 'Group A - Person'; NIBRS files robbery under Property, so for "violent crime" use Group A - Person OR offense = 'Robbery'. Filter offense with ILIKE, e.g. offense ILIKE '%aggravated assault%'. super_neighborhood is already attached (title case) so grouping by it needs no spatial join. Points are hundred-block geocodes. Always say which years.

Fields (expression | type | filled/distinct in a sample | values or examples):
- year | integer | 5000/5 | values: 2022; 2024; 2021; 2023; 2020
- occurred_date | date | 5000/1700 | e.g.: 2022-01-07; 2022-02-26; 2024-03-16
- occurred_hour | integer | 5000/24 | e.g.: 12; 19; 17
- nibrs_class | text | 5000/49 | e.g.: 23F; 13B; 13C
- offense | text | 5000/50 | e.g.: Theft from motor vehicle; Simple assault; Intimidation
- nibrs_group | text | 5000/4 | values: Group A - Property; Group A - Person; Group B; Group A - Society
- premise | text | 5000/42 | e.g.: Residence, Home (Includes Apartment); Parking Lot, Garage; Highway, Road, Street, Alley
- offense_count | integer | 5000/7 | values: 1; 2; 3; 4; 5; 6; 0
- police_beat | text | 4997/122 | e.g.: 3B10; 1A20; 12D10
- super_neighborhood | text | 4926/88 | e.g.: Alief; Sharpstown; Mid West
- council_district | text | 4940/12 | values: B; D; I; H; J; A; C; G; F; K; E; 
- zip | text | 4935/112 | e.g.: 77036; 77092; 77021
- address | text | 4918/4488 | e.g.: 5085 WESTHEIMER RD; 5135 ALABAMA ST; 7800 AIRPORT BLVD
- incident_id | text | 5000/4999 | e.g.: 30854423; 102514522; 27940224