UK Car Accidents 2005-2015

CREATE TABLE accidents0515 (
  "accident_index" VARCHAR,
  "location_easting_osgr" DOUBLE,
  "location_northing_osgr" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "police_force" BIGINT,
  "accident_severity" BIGINT,
  "number_of_vehicles" BIGINT,
  "number_of_casualties" BIGINT,
  "date" TIMESTAMP,
  "day_of_week" BIGINT,
  "time" VARCHAR,
  "local_authority_district" BIGINT,
  "local_authority_highway" VARCHAR,
  "n_1st_road_class" BIGINT,
  "n_1st_road_number" BIGINT,
  "road_type" BIGINT,
  "speed_limit" BIGINT,
  "junction_detail" BIGINT,
  "junction_control" BIGINT,
  "n_2nd_road_class" BIGINT,
  "n_2nd_road_number" BIGINT,
  "pedestrian_crossing_human_control" BIGINT,
  "pedestrian_crossing_physical_facilities" BIGINT,
  "light_conditions" BIGINT,
  "weather_conditions" BIGINT,
  "road_surface_conditions" BIGINT,
  "special_conditions_at_site" BIGINT,
  "carriageway_hazards" BIGINT,
  "urban_or_rural_area" BIGINT,
  "did_police_officer_attend_scene_of_accident" BIGINT,
  "lsoa_of_accident_location" VARCHAR
);