About this Dataset

Road Traffic Collisions And Casualties

This dataset shows annual numbers of road traffic Collisions causing Casualties. It shows the numbers of resulting Casualties split into categories of injury levels, or death. It thus includes disaggregated data for Killed or Seriously Injured (KSI). Data is shown at Lincolnshire geography, and is updated annually. Data source: Lincolnshire Road Safety Partnership (LRSP). For any enquiries about this publication contact stayingalive@lincolnshire.gov.uk
Publisher name: Lincolnshire County Council
Last updated: 2024-07-13T04:00:52Z

Tables

Road Traffic Collisions And Casualties

@ukgov.road_traffic_collisions_and_casualties.road_traffic_collisions_and_casualties

13.68 KB
120 rows
15 columns


CREATE TABLE road_traffic_collisions_and_casualties (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "publisheddate" TIMESTAMP,
  "durationfrom" TIMESTAMP,
  "durationto" TIMESTAMP,
  "latestdata" VARCHAR,
  "geoentityname" VARCHAR,
  "geocode" VARCHAR,
  "geoname" VARCHAR,
  "geouri" VARCHAR,
  "reportingperiodtype" VARCHAR,
  "year" BIGINT,
  "casualtiescategory" VARCHAR,
  "collisions" BIGINT,
  "casualties" BIGINT
);