About this Dataset

Road Collision Attendants 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 attendant part, casualties 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_attendants_in_camden.table_1

615.61 KB
6630 rows
35 columns


CREATE TABLE table_1 (
  "collision_id" VARCHAR,
  "borough_name" VARCHAR,
  "collision_location" VARCHAR,
  "collision_severity" VARCHAR,
  "casualty_count" DOUBLE,
  "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,
  "socrata_id" BIGINT,
  "last_uploaded" VARCHAR,
  "organisation_uri" VARCHAR
);