Road Collision Casualties in Camden - last three years heat map

Road Collision Casualties in Camden - last three years heat mapThis 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.Visit the full page to view this data.

This view cannot be displayed

Embed this Dataset

      <div><iframe width="_width_px" title="Road Collision Casualties in Camden - last three years heat map" height="_height_px" src="https://opendata.camden.gov.uk/w/nuva-tqdn/jubw-4nes?cur=AKtbzD2_tcX&from=4GkaHZrnq3j" frameborder="0"scrolling="no"><a href="https://opendata.camden.gov.uk/Transport/Road-Collision-Casualties-in-Camden-last-three-yea/nuva-tqdn" title="Road Collision Casualties in Camden - last three years heat map" target="_blank">Road Collision Casualties in Camden - last three years heat map</a></iframe></div>

Size

500x425
760x646
950x808

Custom Size

425x425 is the minimum size

Width

Height

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:

Collision ID: collision_id
Borough Name: borough_name
Casualty Class: casualty_class
Casualty Gender: casualty_gender
Casualty Age Band: casualty_age_band
Casualty Age: casualty_age
Casualty Count: casualty_count
Casualty Severity: casualty_severity
Pedestrian Location: pedestrian_location
Pedestrian Movement: pedestrian_movement
Casualty Mode Of Travel: casualty_mode_of_travel
Collision Location: collision_location
Vehicle Count: vehicle_count
Collision Date: collision_date
Day Name: day_name
Time: time
Highway Authority: highway_authority
First Road Class: first_road_class
First Road Number: first_road_number
Road Type: road_type
Speed Limit: speed_limit
Junction Detail: junction_detail
Junction Control: junction_control
Second Road Class: second_road_class
Second Road Number: second_road_number
Pedestrian Crossing Facilities: pedestrian_crossing_facilities
Light Conditions: light_conditions
Weather Details: weather_details
Road Surface Condition: road_surface_condition
Special Conditions At Site: special_conditions_at_site
Carriageway Hazards: carriageway_hazards
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
Lower Layer Super Output Area (LSOA): :@computed_region_6i9a_26nj
Ward: :@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.

London Borough of Camden

API Endpoint:

Field Names:

OData V4 Endpoint:

OData V2 Endpoint:

Want to leave a comment?

You are leaving opendata.camden.gov.uk.

Notice