London Borough of Camden

Close
Author
kiwanowska
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; 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.
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
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
Speed Limit
speed_limit
Junction Detail
junction_detail
Light Condition Band
light_condition_band
Weather
weather
Road Surface
road_surface
Longitude
longitude
Latitude
latitude
Ward Name
ward_name
Location
location
:@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.