About this Dataset

Road Traffic Casualties

This dataset shows numbers of people Killed or Seriously Injured (KSI) in Road Traffic Collisions by calendar year for Lincolnshire and districts. The dataset shows: - Numbers of people KSI in road collisions - KSI numbers of children age 0-15 - Numbers of KSI casualties from collisions involving drivers age 17-24 and age 60 and over - Annual total numbers of fatalities from road collisions Numbers below 5 have been removed, and where needed one or more further counts of 5 or greater have also been removed. This generally only affects district figures but means some figures for districts will not add up to the Lincolnshire total. The data is updated annually in May. 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 Casualties

@ukgov.road_traffic_casualties.road_traffic_casualties

14.01 kB
120 rows
15 columns

CREATE TABLE road_traffic_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
);

Table 2

@ukgov.road_traffic_casualties.table_2

11.58 kB
17 rows
12 columns

CREATE TABLE table_2 (
  "dataset_id" BIGINT,
  "dataset_name" VARCHAR,
  "field" VARCHAR,
  "type" VARCHAR,
  "mandatory_or_optional_requirement_mor" VARCHAR  -- Mandatory Or Optional Requirement (MOR),
  "field_description" VARCHAR,
  "schema" VARCHAR,
  "lcc_mapping" VARCHAR,
  "schema_comments" VARCHAR,
  "schema_data_rules_comment" VARCHAR,
  "formatreference" VARCHAR,
  "example" VARCHAR
);