curated.safety_crash_2025 · Houston Open Data Explorer

← All datasets
# curated.safety_crash_2025
Every reported traffic crash in Harris County in 2025 (TxDOT CRIS, 124,649; 88% have coordinates) (124,649 rows; category: Traffic safety; geometry column `geom` (Point, EPSG:4326))
Notes: Standard TxDOT CRIS columns in attrs. Severity: attrs->>'Crash_Sev_ID' (1 incapacitating/suspected serious, 2 non-incapacitating, 3 possible injury, 4 fatal, 5 not injured, 0 unknown); counts in attrs->>'Death_Cnt', 'Sus_Serious_Injry_Cnt', 'Tot_Injry_Cnt' (cast ::int). attrs->>'Crash_Fatal_Fl' = 'Y' for fatal crashes. attrs->>'Crash_Date' (YYYY-MM-DD), 'Crash_Time' ('1:15 AM'), 'Day_of_Week', 'Crash_Speed_Limit', 'At_Intrsct_Fl', 'Active_School_Zone_Fl'. Light/weather/surface are numeric CRIS codes (Light_Cond_ID 1 daylight, 2 dawn, 3 dark not lighted, 4 dark lighted, 5 dark unknown lighting, 6 dusk, 8 other). Street: attrs->>'Rpt_Street_Name'. Covers all of Harris County, Houston included. For City of Houston questions filter attrs->>'Rpt_City_ID' = '208' (Houston; 68,833 crashes, 295 fatal) rather than clipping points to the city boundary: the city field is filled even for the ~12% of crashes without coordinates. attrs->>'Rpt_Outside_City_Limit_Fl' = 'Y' marks unincorporated county. Only use geometry (and say ~12% lack it) for maps and for areas smaller than the city.

Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 5000/5000 | e.g.: 120489; 20668; 5510
- attrs->>'Active_School_Zone_Fl' | string | 5000/2 | values: N; Y
- attrs->>'Adt_Adj_Curnt_Amt' | null | 1636/300 | e.g.: 220096; 211640; 288803
- attrs->>'Adt_Curnt_Amt' | number | 1636/300 | e.g.: 220096; 211640; 288803
- attrs->>'Adt_Curnt_Year' | null | 1636/1 | values: 2023
- attrs->>'Amend_Supp_Fl' | string | 5000/2 | values: N; Y
- attrs->>'At_Intrsct_Fl' | string | 5000/2 | values: N; Y
- attrs->>'Base_Type_ID' | null | 164/3 | values: 1; 3; 9
- attrs->>'Bridge_Detail_ID' | number | 5000/4 | values: 8; 4; 6; 1
- attrs->>'City_ID' | number | 5000/31 | e.g.: 208; 9999; 325
- attrs->>'Cmv_Involv_Fl' | string | 5000/2 | values: N; Y
- attrs->>'Cnty_ID' | number | 5000/1 | values: 101
- attrs->>'Control' | null | 1636/35 | e.g.: 271; 500; 27
- attrs->>'Control_2' | string | 36/13 | e.g.: 3256; 1685; 2941
- attrs->>'Crash_Date' | string | 5000/365 | e.g.: 2025-08-18; 2025-02-22; 2025-10-31
- attrs->>'Crash_Fatal_Fl' | string | 5000/2 | values: N; Y
- attrs->>'Crash_ID' | number | 5000/5000 | e.g.: 20934892; 20702601; 20691875
- attrs->>'Crash_Sev_ID' | number | 5000/6 | values: 5; 3; 2; 0; 1; 4
- attrs->>'Crash_Speed_Limit' | number | 5000/16 | e.g.: 35; 45; 30
- attrs->>'Crash_Time' | string | 5000/1247 | e.g.: 3:00 PM; 3:30 PM; 6:00 PM
- attrs->>'CrossingNumber' | string | 1/1 | values: 022770H
- attrs->>'Curb_Type_Left_ID' | null | 1636/3 | values: 0; 1; 2
- attrs->>'Curb_Type_Right_ID' | number | 1636/3 | values: 0; 2; 1
- attrs->>'Day_of_Week' | string | 5000/7 | values: FRI; SAT; WED; TUE; THU; MON; SUN
- attrs->>'Death_Cnt' | number | 5000/3 | values: 0; 1; 2
- attrs->>'Dfo' | null | 1778/1669 | e.g.: 31.769; 26.139; 20.416
- attrs->>'Entr_Road_ID' | number | 5000/9 | values: 0; 4; 2; 98; 3; 5; 6; 7; 8
- attrs->>'FHE_Collsn_ID' | number | 5000/36 | e.g.: 20; 21; 10
- attrs->>'Func_Sys_ID' | number | 1636/5 | values: 1; 3; 2; 4; 5
- attrs->>'Harm_Evnt_ID' | number | 5000/10 | values: 2; 7; 4; 1; 5; 8; 10; 9; 6; 3
- attrs->>'Hp_Median_Width' | null | 1636/46 | e.g.: 20; 0; 2
- attrs->>'Hp_Shldr_Left' | null | 1636/21 | e.g.: 0; 20; 24
- attrs->>'Hp_Shldr_Right' | null | 1636/20 | e.g.: 20; 10; 24
- attrs->>'Hwy_Dsgn_Lane_ID' | null | 1636/5 | values: 5; 3; 2; 4; 0
- attrs->>'Hwy_Nbr' | string | 1922/37 | e.g.: 0045; 0069; 0010
- attrs->>'Hwy_Nbr_2' | null | 276/33 | e.g.: 8; 610; 45
- attrs->>'Hwy_Sfx' | string | 20/5 | values: U; E; A; B; H
- attrs->>'Hwy_Sfx_2' | null | 8/3 | values: E; A; D
- attrs->>'Hwy_Sys' | string | 1922/10 | values: IH; SH; FM; SL; US; UA; SS; BU; BS; BF
- attrs->>'Hwy_Sys_2' | null | 278/10 | values: IH; SH; FM; SL; UA; US; SS; BS; BF; FS
- attrs->>'Intrsct_Relat_ID' | number | 5000/4 | values: 4; 1; 2; 3
- attrs->>'Investigat_Agency_ID' | number | 5000/59 | e.g.: 2469; 1419; 2744
- attrs->>'Investigat_Arrv_Date' | string | 5000/367 | e.g.: 2025-04-24; 2025-08-18; 2025-09-24
- attrs->>'Investigat_Arrv_Time' | string | 5000/1298 | e.g.: 4:00 PM; 6:00 PM; 3:40 PM
- attrs->>'Investigat_Comp_Fl' | string | 5000/2 | values: Y; N
- attrs->>'Investigat_DA_ID' | number | 3724/52 | e.g.: 16; 24; 18
- attrs->>'Investigat_Date_Rwy_Clrd' | string | 5000/368 | e.g.: 2025-04-24; 2025-08-18; 2025-09-24
- attrs->>'Investigat_Date_Scn_Clrd' | string | 5000/368 | e.g.: 2025-04-24; 2025-08-18; 2025-09-24
- attrs->>'Investigat_Notify_Date' | string | 5000/367 | e.g.: 2025-04-24; 2025-08-18; 2025-09-24
- attrs->>'Investigat_Notify_Meth' | string | 5000/215 | e.g.: DISPATCHED; DISPATCH; WALK IN
- attrs->>'Investigat_Notify_Time' | string | 5000/1280 | e.g.: 1:30 PM; 6:00 PM; 12:00 PM
- attrs->>'Investigat_Region_ID' | null | 3901/40 | e.g.: 4; 121; 106
- attrs->>'Investigat_Service_ID' | null | 4839/67 | e.g.: 5; 35; 33
- attrs->>'Investigat_Time_Rwy_Clrd' | string | 5000/1219 | e.g.: 5:00 PM; 4:00 PM; 6:00 PM
- attrs->>'Investigat_Time_Scn_Clrd' | string | 5000/1179 | e.g.: 5:30 PM; 5:00 PM; 4:30 PM
- attrs->>'Latitude' | null | 4406/4238 | e.g.: 29.93774477; 29.93512476; 29.72888481
- attrs->>'Light_Cond_ID' | number | 5000/8 | values: 1; 4; 3; 6; 0; 2; 5; 8
- attrs->>'Local_Use' | null | 915/134 | e.g.: FSGI; FSRA; 1011300
- attrs->>'Located_Fl' | string | 5000/2 | values: Y; N
- attrs->>'Longitude' | number | 4406/4241 | e.g.: -95.24961311; -95.48332305; -95.41280307
- attrs->>'Median_Type_ID' | number | 1636/6 | values: 7; 3; 0; 2; 5; 6
- attrs->>'Median_Width' | number | 1636/46 | e.g.: 20; 0; 2
- attrs->>'Medical_Advisory_Fl' | string | 5000/2 | values: N; Y
- attrs->>'Milepoint' | number | 1636/1524 | e.g.: 12.029; 6.4; 1.673
- attrs->>'Milepoint_2' | string | 36/26 | e.g.: 17.808; 24.549; 17.351
- attrs->>'MPO_ID' | number | 4406/1 | values: 15
- attrs->>'Nbr_Of_Lane' | number | 1636/17 | e.g.: 6; 8; 4
- attrs->>'Near_Trauma_Center_Distance' | number | 4406/3271 | e.g.: 0.813; 1.806; 3.859
- attrs->>'Near_Trauma_Center_ID' | number | 4406/22 | e.g.: 120; 242; 122
- attrs->>'Nonincap_Injry_Cnt' | number | 5000/7 | values: 0; 1; 2; 3; 4; 5; 6
- attrs->>'Non_Injry_Cnt' | number | 5000/14 | e.g.: 2; 1; 0
- attrs->>'Obj_Struck_ID' | number | 5000/33 | e.g.: 64; 39; 33
- attrs->>'Onsys_Fl' | string | 5000/2 | values: N; Y
- attrs->>'ORI_Number' | string | 4975/58 | e.g.: TXHPD0000; TX1010000; TX1014900
- attrs->>'Othr_Factr_ID' | number | 5000/43 | e.g.: 54; 9; 14
- attrs->>'Pct_Combo_Trk_Adt' | number | 1636/97 | e.g.: 1.4; 3.9; 2.9
- attrs->>'Pct_Single_Trk_Adt' | number | 1636/53 | e.g.: 2.7; 2.9; 2.2
- attrs->>'Phys_Featr_1_ID' | number | 5000/10 | values: 21; 33; 32; 1; 15; 14; 20; 17; 12; 11
- attrs->>'Phys_Featr_2_ID' | number | 5000/4 | values: 21; 14; 15; 20
- attrs->>'Pop_Group_ID' | number | 5000/9 | values: 9; 0; 5; 8; 7; 6; 4; 3; 1
- attrs->>'Poss_Injry_Cnt' | number | 5000/8 | values: 0; 1; 2; 3; 4; 5; 7; 9
- attrs->>'Private_Dr_Fl' | string | 5000/2 | values: N; Y
- attrs->>'Ref_Mark_Displ' | null | 1760/1081 | e.g.: 0.132; 0.253; 0.116
- attrs->>'Ref_Mark_Nbr' | null | 1760/235 | e.g.: 700; 694; 698
- attrs->>'Report_Date' | string | 5000/399 | e.g.: 2025-09-24; 2025-04-24; 2025-07-03
- attrs->>'Road_Algn_ID' | number | 5000/8 | values: 1; 2; 4; 3; 8; 7; 5; 6
- attrs->>'Roadbed_Width' | number | 1636/90 | e.g.: 140; 120; 136
- attrs->>'Road_Cls_ID' | number | 5000/7 | values: 5; 1; 4; 9; 2; 6; 3
- attrs->>'Road_Constr_Zone_Fl' | string | 5000/2 | values: N; Y
- attrs->>'Road_Constr_Zone_Wrkr_Fl' | string | 5000/2 | values: N; Y
- attrs->>'Road_Part_Adj_ID' | number | 5000/6 | values: 1; 2; 7; 4; 3; 5
- attrs->>'Road_Relat_ID' | number | 5000/5 | values: 1; 5; 2; 4; 3
- attrs->>'Road_Type_ID' | number | 5000/5 | values: 3; 4; 1; 2; 98
- attrs->>'Rpt_Block_Num' | null | 4913/1195 | e.g.: 100; 1000; 1200
- attrs->>'Rpt_City_ID' | number | 5000/37 | e.g.: 208; 9999; 325
- attrs->>'Rpt_CRIS_Cnty_ID' | number | 5000/6 | values: 101; 113; 79; 170; 84; 20
- attrs->>'Rpt_CrossingNumber' | string | 1/1 | values: 022770H
- attrs->>'Rpt_Dir_Traffic' | string | 4900/8 | values: N; S; W; E; SE; SW; NE; NW
- attrs->>'Rpt_Hwy_Num' | number | 1678/29 | e.g.: 45; 69; 10
- attrs->>'Rpt_Hwy_Sfx' | null | 9/5 | values: U; W; S; N; E
- attrs->>'Rpt_Latitude' | null | 393/388 | e.g.: 29.69169; 30.01856; 29.86755
- attrs->>'Rpt_Longitude' | number | 393/385 | e.g.: -95.43652; -95.21968; -95.17253
- attrs->>'Rpt_Outside_City_Limit_Fl' | string | 5000/2 | values: N; Y
- attrs->>'Rpt_Rdwy_Sys_ID' | number | 5000/14 | e.g.: 19; 1; 12
- attrs->>'Rpt_Ref_Mark_Dir' | string | 5/3 | values: N; S; E
- attrs->>'Rpt_Ref_Mark_Dist_Uom' | string | 7/2 | values: M; F
- attrs->>'Rpt_Ref_Mark_Nbr' | null | 7/7 | values: 54; 0015; 0751; 0072; 0048; 0001; 0064
- attrs->>'Rpt_Ref_Mark_Offset_Amt' | string | 7/7 | values: 0.24; 15; 0.47; 0.1; 100; 5; 0.56
- attrs->>'Rpt_Road_Part_ID' | number | 5000/6 | values: 1; 2; 7; 3; 5; 4
- attrs->>'Rpt_Sec_Block_Num' | null | 3861/627 | e.g.: 100; 1000; 900
- attrs->>'Rpt_Sec_Hwy_Num' | null | 459/31 | e.g.: 10; 45; 1960
- attrs->>'Rpt_Sec_Hwy_Sfx' | string | 6/3 | values: E; A; N
- attrs->>'Rpt_Sec_Rdwy_Sys_ID' | number | 4993/13 | e.g.: 19; 15; 1
- attrs->>'Rpt_Sec_Road_Part_ID' | number | 4993/6 | values: 1; 2; 7; 4; 5; 3
- attrs->>'Rpt_Sec_Speed_Limit' | number | 5000/15 | e.g.: -1; 35; 30
- attrs->>'Rpt_Sec_Street_Desc' | string | 2241/508 | e.g.: CONCRETE; PUBLIC ROADWAY; DRY CONCRETE
- attrs->>'Rpt_Sec_Street_Name' | string | 5000/2146 | e.g.: NOT REPORTED; MAIN; SAM HOUSTON
- attrs->>'Rpt_Sec_Street_Pfx' | string | 745/8 | values: W; N; S; E; NW; SW; NE; SE
- attrs->>'Rpt_Sec_Street_Sfx' | null | 4446/17 | e.g.: RD; ST; DR
- attrs->>'Rpt_Street_Desc' | null | 2782/626 | e.g.: CONCRETE; PUBLIC ROADWAY; DRY CONCRETE
- attrs->>'Rpt_Street_Name' | string | 5000/1335 | e.g.: KATY; GULF; SAM HOUSTON
- attrs->>'Rpt_Street_Pfx' | string | 1689/8 | values: S; W; N; E; NW; SW; NE; SE
- attrs->>'Rpt_Street_Sfx' | string | 4242/17 | e.g.: RD; FWY; DR
- attrs->>'Rr_Relat_Fl' | string | 5000/2 | values: N; Y
- attrs->>'Rural_Fl' | string | 5000/2 | values: N; Y
- attrs->>'Rural_Urban_Type_ID' | null | 1636/2 | values: 4; 1
- attrs->>'Schl_Bus_Fl' | string | 5000/2 | values: N; Y
- attrs->>'Secondary_Crash_Fl' | string | 5000/2 | values: N; Y
- attrs->>'Section' | null | 1636/17 | e.g.: 3; 1; 6
- attrs->>'Section_2' | string | 36/8 | values: 1; 3; 5; 9; 4; 6; 16; 2
- attrs->>'Shldr_Type_Left_ID' | null | 1636/5 | values: 1; 0; 2; 3; 5
- attrs->>'Shldr_Type_Right_ID' | number | 1636/5 | values: 1; 0; 2; 3; 5
- attrs->>'Shldr_Use_Left_ID' | null | 1636/4 | values: 5; 0; 3; 2
- attrs->>'Shldr_Use_Right_ID' | number | 1636/3 | values: 5; 0; 3
- attrs->>'Shldr_Width_Left' | number | 1636/21 | e.g.: 0; 20; 24
- attrs->>'Shldr_Width_Right' | number | 1636/20 | e.g.: 20; 10; 24
- attrs->>'Street_Name' | string | 5000/1248 | e.g.: IH0045; IH0069; IH0010
- attrs->>'Street_Name_2' | string | 5000/1042 | e.g.: N/A; SL0008; IH0610
- attrs->>'Street_Nbr' | null | 1573/1215 | e.g.: 700; 1900; 2100
- attrs->>'Surf_Cond_ID' | number | 5000/9 | values: 1; 2; 0; 6; 3; 5; 8; 9; 10
- attrs->>'Surf_Type_ID' | number | 1636/6 | values: 1; 7; 4; 2; 10; 5
- attrs->>'Surf_Width' | number | 1636/88 | e.g.: 96; 72; 120
- attrs->>'Sus_Serious_Injry_Cnt' | number | 5000/3 | values: 0; 1; 2
- attrs->>'Thousand_Damage_Fl' | string | 5000/2 | values: Y; N
- attrs->>'Toll_Road_Fl' | string | 5000/2 | values: N; Y
- attrs->>'Tot_Injry_Cnt' | number | 5000/9 | values: 0; 1; 2; 3; 4; 5; 8; 7; 9
- attrs->>'Traffic_Cntl_ID' | number | 5000/17 | e.g.: 20; 5; 1
- attrs->>'Trk_Aadt_Pct' | null | 1636/123 | e.g.: 4.8; 6; 8
- attrs->>'TxDot_District_ID' | number | 5000/1 | values: 12
- attrs->>'Txdot_Rptable_Fl' | string | 5000/2 | values: Y; N
- attrs->>'Unkn_Injry_Cnt' | number | 5000/7 | values: 0; 1; 2; 3; 4; 6; 5
- attrs->>'Wthr_Cond_ID' | number | 5000/8 | values: 11; 12; 2; 0; 5; 4; 3; 8
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.