← 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: 2024; 2022; 2023; 2021; 2020
- occurred_date | date | 5000/1702 | e.g.: 2022-03-25; 2023-06-24; 2021-12-23
- occurred_hour | integer | 5000/24 | e.g.: 12; 22; 18
- nibrs_class | text | 5000/45 | e.g.: 23F; 13B; 290
- offense | text | 5000/46 | e.g.: Theft from motor vehicle; Simple assault; Destruction, damage, vandalism
- nibrs_group | text | 5000/4 | values: Group A - Property; Group A - Person; Group B; Group A - Society
- premise | text | 5000/38 | e.g.: Residence, Home (Includes Apartment); Parking Lot, Garage; Highway, Road, Street, Alley
- offense_count | integer | 5000/7 | values: 1; 2; 3; 8; 6; 4; 5
- police_beat | text | 4999/120 | e.g.: 3B10; 22B20; 17E10
- super_neighborhood | text | 4930/89 | e.g.: Alief; Mid West; Greater Greenspoint
- council_district | text | 4940/12 | values: B; D; H; J; A; C; I; G; K; F; E; 
- zip | text | 4937/111 | e.g.: 77036; 77092; 77057
- address | text | 4907/4460 | e.g.: 4412 NORTH FWY; 10630 BEECHNUT ST; 5085 WESTHEIMER RD
- incident_id | text | 5000/4994 | e.g.: 105852522; 140638221; 162621223