Name: Asotin County Vehicle Collisions
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Asotin County Vehicle Collisions

This dataset includes vehicle collisions in Asotin County beginning in January 2016. Only collisions reported to law enforcement and entered in the Washington State Department of Transportation (WSDOT) Crash Database appear here.
Organization: State of Washington
Last updated: 2022-02-28T22:57:54.505759
Tags: car, crash, public-safety, roads

Tables

Table 1

@usgov.state_of_washington_asotin_county_vehicle_collisions.table_1

29.59 kB
414 rows
24 columns

CREATE TABLE table_1 (
  "collision_report_number" VARCHAR,
  "collision_date" VARCHAR,
  "city" VARCHAR,
  "jurisdiction" VARCHAR,
  "agency" VARCHAR,
  "primary_trafficway" VARCHAR,
  "secondary_trafficway" VARCHAR,
  "block_number" VARCHAR,
  "mile_post" DOUBLE,
  "school_zone" BOOLEAN,
  "intersection_related" BOOLEAN,
  "weather_condition" VARCHAR,
  "lighting_condition" VARCHAR,
  "injury_severity" VARCHAR,
  "collision_type" VARCHAR,
  "object_struck" VARCHAR,
  "damage_threshold_met" BOOLEAN,
  "hit_and_run" BOOLEAN,
  "motor_vehicles_involved" BIGINT,
  "passengers_involved" BOOLEAN,
  "commercial_carrier_involved" BOOLEAN,
  "school_bus_involved" BOOLEAN,
  "pedestrians_involved" BIGINT,
  "pedalcyclists_involved" BIGINT
);