London Borough of Camden

Close
Author
Michael Webb
Description
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, 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.
Category
Transport
Tags
traffic, accident
Rating
Current value: 0 out of 5
Data Provided By
London Borough Of Camden Council
Source Link
http://www.camden.gov.uk
License
UK Open Government Licence v3
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

Reference
reference
London Borough Name
london_borough_name
Casualty Class
casualty_class
Casualty Sex
casualty_sex
Casualty Age Band
casualty_age_band
Casualty Age
casualty_age
Number Of Casualties
number_of_casualties
Casualty Severity
casualty_severity
Pedestrian Location
pedestrian_location
Pedestrian Movement
pedestrian_movement
Mode Of Travel
mode_of_travel
Attendant Location
attendant_location
Number Of Vehicles
number_of_vehicles
Date
date
Day
day
Time
time
Highway
highway
Road Class 1
road_class_1
Road Number 1
road_number_1
Road Type
road_type
Speed Limit
speed_limit
Junction Detail
junction_detail
Junction Control
junction_control
Road Class 2
road_class_2
Road Number 2
road_number_2
Pedestrian Crossing
pedestrian_crossing
Light Condition Band
light_condition_band
Weather
weather
Road Surface
road_surface
Special Conditions
special_conditions
Carriage Way Hazard
carriage_way_hazard
Easting
easting
Northing
northing
Longitude
longitude
Latitude
latitude
Ward Code
ward_code
Ward Name
ward_name
Spatial Accuracy
spatial_accuracy
Location
location
Organisation URI
organisation_uri
Socrata ID
socrata_id
Last Uploaded
last_uploaded
:@computed_region_6i9a_26nj
:@computed_region_6i9a_26nj
:@computed_region_hxwp_gyfc
:@computed_region_hxwp_gyfc

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.