North Carolina Bicycle Crash Data — ncbikecrash • dsbox

All North Carolina bike crash data from 2007-2014. Data downloaded on Sep 6, 2018.

ncbikecrash

Format

A tibble with 7467 rows and 66 variables:

object_id: Crash ID
city: City of crash
county: County of crash
region: Region of crash
development: Development area of crash
locality: Locality of crash
on_road: Road where crash happened
rural_urban: Whether crash happened on rural or urban road
speed_limit: Speed limit where crash happened
traffic_control: Type of traffic control where crash happened
weather: Weather at the time of crash
workzone: Whether crash happened in a work zone
bike_age: Age of biker
bike_age_group: Age group of biker
bike_alc_drug: Whether biker had alcohol or drugs
bike_alcohol: Whether biker had alcohol
bike_direction: Direction of bike at the time of crash
bike_injury: Injury of biker
bike_position: Position of bike at the time of crash
bike_race: Race of biker
bike_sex: Sex of biker
driver_age: Age of driver
driver_age_group: Age group of driver
driver_alcohol: Whether driver had alcohol
driver_alcohol_drugs: Whether driver had alcohol or drugs
driver_est_speed: Estimated speed of driver
driver_injury: Injury of driver
driver_race: Race of driver
driver_sex: Sex of driver
driver_vehicle_type: Type of vehicle involved in crash
crash_alcohol: Whether alcohol was involved in crash
crash_date: Date of crash
crash_day: Day of crash
crash_group: Type of crash
crash_hour: Hour of crash
crash_location: Location of crash
crash_month: Month of crash
crash_severity: Severity of crash
crash_time: Time of crash
crash_type: Type of crash
crash_year: Year of crash
ambulance_req: Whether ambulance was required
hit_run: Whether accident was a hit and run
light_condition: Light condition at the time of crash
road_character: Road characteristics
road_class: Road class
road_condition: Road condition
road_configuration: Road configuration
road_defects: Road defects
road_feature: Road feature
road_surface: Road surface
num_bikes_ai
num_bikes_bi
num_bikes_ci
num_bikes_ki
num_bikes_no
num_bikes_to
num_bikes_ui
num_lanes: Number of lanes
num_units
distance_mi_from
frm_road
rte_invd_cd
towrd_road
geo_point: Latitude and longitude of crash
geo_shape

Source

https://opendurham.nc.gov/explore/dataset/north_carolina_bicycle_crash_data_heatmap_/table/

Examples

ncbikecrash
#> # A tibble: 7,467 × 66
#>    object_id city         county region development locality on_road rural_urban
#>        <dbl> <chr>        <chr>  <chr>  <chr>       <chr>    <chr>   <chr>      
#>  1      1686 None - Rura… Wayne  Coast… Farms, Woo… Rural (… SR 1915 Rural      
#>  2      1674 Henderson    Vance  Piedm… Residential Mixed (… NICHOL… Urban      
#>  3      1673 None - Rura… Linco… Piedm… Farms, Woo… Rural (… US 321  Rural      
#>  4      1687 Whiteville   Colum… Coast… Commercial  Urban (… W BURK… Urban      
#>  5      1653 Wilmington   New H… Coast… Residential Urban (… RACINE… Urban      
#>  6      1665 None - Rura… Robes… Coast… Farms, Woo… Rural (… SR 1513 Rural      
#>  7      1642 None - Rura… Richm… Piedm… Residential Mixed (… SR 1903 Rural      
#>  8      1675 Raleigh      Wake   Piedm… Commercial  Urban (… PERSON… Urban      
#>  9      1668 Whiteville   Colum… Coast… Residential Rural (… FLOWER… Urban      
#> 10      1662 New Bern     Craven Coast… Residential Urban (… SUTTON… Urban      
#> # ℹ 7,457 more rows
#> # ℹ 58 more variables: speed_limit <chr>, traffic_control <chr>, weather <chr>,
#> #   workzone <chr>, bike_age <chr>, bike_age_group <chr>, bike_alcohol <chr>,
#> #   bike_alcohol_drugs <chr>, bike_direction <chr>, bike_injury <chr>,
#> #   bike_position <chr>, bike_race <chr>, bike_sex <chr>, driver_age <chr>,
#> #   driver_age_group <chr>, driver_alcohol <chr>, driver_alcohol_drugs <chr>,
#> #   driver_est_speed <chr>, driver_injury <chr>, driver_race <chr>, …