← All datasets

# curated.safety_fatal_serious_crash_2019_2024
Fatal and serious-injury crashes 2019-2024, WEST Harris County only (3,666; west of about Shepherd/Kirby) (3,666 rows; category: Traffic safety; geometry column `geom` (Point, EPSG:4326))
Notes: A county staff extract for the west side only: every point is west of longitude -95.41 (Katy to Tomball, I-10 West, Westheimer/FM 1093). NOT county-wide and NOT all of Houston: never use it for citywide or countywide totals or rankings, and say so if asked. For all of Harris County use curated.safety_crash_2025 (one year). Fields: attrs->>'Crash_Seve' ('K - FATAL INJURY' / 'A - SUSPECTED SERIOUS INJURY'), attrs->>'Crash_Year', attrs->>'Street_Nam'.

Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 3666/3666 | e.g.: 247; 3226; 3542
- attrs->>'Crash_ID' | number | 3666/3666 | e.g.: 18185138; 18790280; 18461990
- attrs->>'Crash_Seve' | string | 3666/2 | values: A - SUSPECTED SERIOUS INJURY; K - FATAL INJURY
- attrs->>'Crash_Year' | number | 3666/6 | values: 2024; 2021; 2023; 2022; 2020; 2019
- attrs->>'FID' | number | 3666/3666 | e.g.: 247; 3226; 3542
- attrs->>'Latitude' | number | 3666/3269 | e.g.: 29.67447782; 29.8310748; 29.66078483
- attrs->>'Longitude' | number | 3666/3291 | e.g.: -95.718963; -95.56038189; -95.41057308
- attrs->>'Street_Nam' | string | 3666/422 | e.g.: IH0010; IH0069; FM1093
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.