About this Dataset

Road Collision Casualties In Camden

This dataset contains road collisions in Camden dating back to 2005. Data is provided by TfL (Transport for London) on an annual basis in three parts – this is the casualties part; some information has been added from the attendants part. Attendants and vehicles are available on the open data platform as separate datasets and they can all be joined together using the Reference column. If joined, where multiple attendants/casualties/vehicles exists for one Accident Reference there will be multiple records for the same accident. To avoid anomalies it is suggested any data analysis undertaken should use three years of data.
Publisher name: London Borough of Camden
Last updated: 2024-06-28T04:00:03Z

Tables

Table 1

@ukgov.road_collision_casualties_in_camden.table_1

663.94 KB
7375 rows
42 columns


CREATE TABLE table_1 (
  "collision_id" VARCHAR,
  "borough_name" VARCHAR,
  "casualty_class" VARCHAR,
  "casualty_gender" VARCHAR,
  "casualty_age_band" VARCHAR,
  "casualty_age" DOUBLE,
  "casualty_count" BIGINT,
  "casualty_severity" VARCHAR,
  "pedestrian_location" VARCHAR,
  "pedestrian_movement" VARCHAR,
  "casualty_mode_of_travel" VARCHAR,
  "collision_location" VARCHAR,
  "vehicle_count" DOUBLE,
  "collision_date" VARCHAR,
  "day_name" VARCHAR,
  "time" DOUBLE,
  "highway_authority" VARCHAR,
  "first_road_class" VARCHAR,
  "first_road_number" DOUBLE,
  "road_type" VARCHAR,
  "speed_limit" VARCHAR,
  "junction_detail" VARCHAR,
  "junction_control" VARCHAR,
  "second_road_class" VARCHAR,
  "second_road_number" DOUBLE,
  "pedestrian_crossing_facilities" VARCHAR,
  "light_conditions" VARCHAR,
  "weather_details" VARCHAR,
  "road_surface_condition" VARCHAR,
  "special_conditions_at_site" VARCHAR,
  "carriageway_hazards" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "ward_code" VARCHAR,
  "ward_name" VARCHAR,
  "spatial_accuracy" VARCHAR,
  "location" VARCHAR,
  "organisation_uri" VARCHAR,
  "socrata_id" BIGINT,
  "last_uploaded" VARCHAR
);