Crash Data

Town of Cary, North Carolina

@usgov.town_of_cary_north_carolina_crash_data

Table List

1 table(1.49 MB)

Table 1

@usgov.town_of_cary_north_carolina_crash_data.table_1

1.49 MB
21243 rows
42 columns

tamainid Tamainid	location_description Location Description	rdfeature Rdfeature	rdcharacter Rdcharacter	rdclass Rdclass	rdconfigur Rdconfigur	rdsurface Rdsurface	rdcondition Rdcondition	lightcond Lightcond	weather Weather	trafcontrl Trafcontrl	lon2 Lon2	lat2 Lat2	zone Zone	possblinj Possblinj	numpassengers Numpassengers	contrcir1_desc Contrcir1 Desc	contrcir3_desc Contrcir3 Desc	vehicle1 Vehicle1	vehicle2 Vehicle2	vehicle3 Vehicle3	workarea Workarea	records Records	ta_date Ta Date	ta_time Ta Time	crash_date Crash Date	year Year	fatalities Fatalities	injuries Injuries	month Month	contributing_factor Contributing Factor	vehicle_type Vehicle Type
43258	CARY	RELATED TO INTERSECTION	STRAIGHT,LEVEL	STATE SECONDARY ROUTE	TWO-WAY,DIVIDED,UNPROTECTED MEDIAN	SMOOTH ASPHALT	DRY	DAYLIGHT	CLEAR	STOP SIGN	-78.8233	35.76359				NONE	NONE	PASSENGER CAR	VAN		NO	3	Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	10:25 AM	Thu Jan 02 2020 15:25:00 GMT+0000 (Coordinated Universal Time)	2020	No	No	1	NONE,NONE	PASSENGER CAR,VAN
43259	CARY	NO SPECIAL FEATURE	STRAIGHT,LEVEL	STATE SECONDARY ROUTE	TWO-WAY,NOT DIVIDED	SMOOTH ASPHALT	WET	DAYLIGHT	RAIN	STOP AND GO SIGNAL	-78.7409	35.7676		2	1	NONE	NONE	PASSENGER CAR	PASSENGER CAR		NO	4	Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	4:24:23 PM	Thu Jan 02 2020 21:24:23 GMT+0000 (Coordinated Universal Time)	2020	No	Yes	1	NONE,NONE	PASSENGER CAR,PASSENGER CAR
43260	200 FEET FROM US HWY 1	NO SPECIAL FEATURE	STRAIGHT,LEVEL	US ROUTE	TWO-WAY,DIVIDED,POSITIVE MEDIAN BARRIER	SMOOTH ASPHALT	WET	DUSK	CLOUDY	NO CONTROL PRESENT	-78.7729	35.7481		1		NONE	NONE	SPORT UTILITY	PASSENGER CAR	PASSENGER CAR	NO	5	Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	5:28:38 PM	Thu Jan 02 2020 22:28:38 GMT+0000 (Coordinated Universal Time)	2020	No	Yes	1	NONE,NONE	SPORT UTILITY,PASSENGER CAR,PASSENGER CAR
43263	CARY	FOUR-WAY INTERSECTION	STRAIGHT,LEVEL	STATE SECONDARY ROUTE	TWO-WAY,DIVIDED,POSITIVE MEDIAN BARRIER	SMOOTH ASPHALT	WET	DARK - LIGHTED ROADWAY	CLOUDY	NO CONTROL PRESENT	-78.9032	35.809			1	NONE	NONE	PASSENGER CAR	SPORT UTILITY		NO	7	Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	7:43:20 PM	Fri Jan 03 2020 00:43:20 GMT+0000 (Coordinated Universal Time)	2020	No	No	1	NONE,NONE	PASSENGER CAR,SPORT UTILITY
43273	20 FEET FROM SR 1010 (TEN TEN RD)	FOUR-WAY INTERSECTION	STRAIGHT,LEVEL	STATE SECONDARY ROUTE	TWO-WAY,DIVIDED,UNPROTECTED MEDIAN	SMOOTH ASPHALT	WET	DAYLIGHT	CLOUDY	STOP AND GO SIGNAL	-78.7945	35.7034				NONE	NONE	VAN	PASSENGER CAR		NO	16	Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1:15:21 PM	Fri Jan 03 2020 18:15:21 GMT+0000 (Coordinated Universal Time)	2020	No	No	1	NONE,NONE	VAN,PASSENGER CAR
43286	405 FEET FROM P.V.A. (501 CAITBOO AV)	NO SPECIAL FEATURE	STRAIGHT,LEVEL	PUBLIC VEHICULAR AREA	TWO-WAY,NOT DIVIDED	SMOOTH ASPHALT	DRY	DAYLIGHT	CLOUDY	NO CONTROL PRESENT	-78.7352	35.7583				NONE	NONE	UNKNOWN	PASSENGER CAR		NO	26	Sat Jan 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	4:23:43 PM	Sat Jan 04 2020 21:23:43 GMT+0000 (Coordinated Universal Time)	2020	No	No	1	NONE,NONE	UNKNOWN,PASSENGER CAR
43291	100 FEET FROM S.R. 55 (NC 55 HWY)	NO SPECIAL FEATURE	STRAIGHT,LEVEL	STATE SECONDARY ROUTE	TWO-WAY,DIVIDED,UNPROTECTED MEDIAN	SMOOTH ASPHALT	WET	DARK - LIGHTED ROADWAY	RAIN	STOP AND GO SIGNAL	-78.8741	35.8232		2		NONE	NONE	SPORT UTILITY	SPORT UTILITY		NO	31	Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	6:14:51 PM	Fri Jan 03 2020 23:14:51 GMT+0000 (Coordinated Universal Time)	2020	No	Yes	1	NONE,NONE	SPORT UTILITY,SPORT UTILITY
43306	118 FEET FROM PVA OF 1299 SR 1300 (KILDAIRE	NO SPECIAL FEATURE	STRAIGHT,GRADE	PUBLIC VEHICULAR AREA	TWO-WAY,NOT DIVIDED	COARSE ASPHALT	WET	DARK - LIGHTED ROADWAY	CLOUDY	NO CONTROL PRESENT	-78.782903	35.762353				NONE	NONE	PASSENGER CAR	SPORT UTILITY		NO	45	Sat Jan 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	6:07:16 PM	Sat Jan 04 2020 23:07:16 GMT+0000 (Coordinated Universal Time)	2020	No	No	1	NONE,NONE	PASSENGER CAR,SPORT UTILITY
43315	100 FEET FROM P.V.A. STAPLES	NO SPECIAL FEATURE	STRAIGHT,LEVEL	PUBLIC VEHICULAR AREA	TWO-WAY,NOT DIVIDED	SMOOTH ASPHALT	DRY	DARK - LIGHTED ROADWAY	CLEAR	NO CONTROL PRESENT	-78.780347	35.804162	113			NONE	NONE	PASSENGER CAR	PASSENGER CAR		NO	54	Sun Jan 05 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	6:07:01 PM	Sun Jan 05 2020 23:07:01 GMT+0000 (Coordinated Universal Time)	2020	No	No	1	NONE,NONE	PASSENGER CAR,PASSENGER CAR
43317	200 FEET FROM SR 1415 (SE MAYNARD RD)	RELATED TO INTERSECTION	STRAIGHT,GRADE	STATE SECONDARY ROUTE	TWO-WAY,DIVIDED,POSITIVE MEDIAN BARRIER	SMOOTH ASPHALT	DRY	DARK - LIGHTED ROADWAY	CLOUDY	STOP AND GO SIGNAL	-78.764209	35.773047			1	NONE	NONE	PASSENGER CAR	PASSENGER CAR		NO	56	Sat Jan 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	7:22:49 PM	Sun Jan 05 2020 00:22:49 GMT+0000 (Coordinated Universal Time)	2020	No	No	1	NONE,NONE	PASSENGER CAR,PASSENGER CAR


CREATE TABLE table_1 (
  "tamainid" BIGINT,
  "location_description" VARCHAR,
  "rdfeature" VARCHAR,
  "rdcharacter" VARCHAR,
  "rdclass" VARCHAR,
  "rdconfigur" VARCHAR,
  "rdsurface" VARCHAR,
  "rdcondition" VARCHAR,
  "lightcond" VARCHAR,
  "weather" VARCHAR,
  "trafcontrl" VARCHAR,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "lon2" DOUBLE,
  "lat2" DOUBLE,
  "tract" VARCHAR,
  "zone" VARCHAR,
  "fatality" BIGINT,
  "possblinj" BIGINT,
  "numpassengers" DOUBLE,
  "numpedestrians" DOUBLE,
  "contrcir1_desc" VARCHAR,
  "contrcir2_desc" VARCHAR,
  "contrcir3_desc" VARCHAR,
  "contrcir4_desc" VARCHAR,
  "vehicle1" VARCHAR,
  "vehicle2" VARCHAR,
  "vehicle3" VARCHAR,
  "vehicle4" VARCHAR,
  "vehicle5" VARCHAR,
  "workarea" VARCHAR,
  "records" BIGINT,
  "ta_date" TIMESTAMP,
  "ta_time" VARCHAR,
  "crash_date" TIMESTAMP,
  "geo_location" VARCHAR,
  "year" BIGINT,
  "fatalities" VARCHAR,
  "injuries" VARCHAR,
  "month" BIGINT,
  "contributing_factor" VARCHAR,
  "vehicle_type" VARCHAR
);