About this Dataset

GM Road Casualty Accidents (Full STATS19 Data)

Full standard STATS19 fields data on reported road accidents in Greater Manchester. Please bear in mind that our STATS19 data (police data on road accidents is in a standardised national format) is a relational database, it consists of accident, vehicle and casualty records. The underlying structure of the data is essentially hierarchical. For each accident there is a single accident record, followed by a variable number of vehicle records and a variable number of casualty records. Casualty records are linked to vehicle records either because the vehicle struck the casualty or because the casualty was a driver or a passenger in a vehicle. In Greater Manchester, different councils have different viewpoints on which terminology should be used. However, it has been decided that at a Greater Manchester level, the term road accident should be used. This is the term that most members of the public would use and is also the one used by the Department for Transport on the national form used for the collection of the data. This data will be refreshed annually. A key to the codes used in the data can be found in the STATS19 road accident injury statistics - report form which is provided in the supporting information below. Please acknowledge the source of this information using the following attribution statement: Contains Transport for Greater Manchester data. Contains OS data © Crown copyright and database right 2024.
Publisher name: Transport for Greater Manchester
Last updated: 2024-06-14T04:01:45Z

Tables

2010-2021 STATS19 Data - Accidents Greater Manchester

@ukgov.gm_road_casualty_accidents.n_2010_2021_stats19_data_accidents_greater_manchester

1.13 MB
45626 rows
27 columns


CREATE TABLE n_2010_2021_stats19_data_accidents_greater_manchester (
  "accident_index" BIGINT,
  "year" BIGINT,
  "severity" BIGINT,
  "numbervehicles" BIGINT,
  "numbercasualties" BIGINT,
  "outputdate" TIMESTAMP,
  "day" BIGINT,
  "outputtime" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "localauthority" BIGINT,
  "road1class" BIGINT,
  "road1number" BIGINT,
  "carriagewaytype" BIGINT,
  "speedlimit" BIGINT,
  "junctiondetail" BIGINT,
  "junctioncontrol" BIGINT,
  "road2class" BIGINT,
  "road2number" BIGINT,
  "pedcrossinghumancontrol" BIGINT,
  "pedcrossingphysicalfacilities" BIGINT,
  "lightingcondition" BIGINT,
  "weathercondition" BIGINT,
  "roadsurface" BIGINT,
  "specialconditions" BIGINT,
  "carriagewayhazard" BIGINT,
  "placereported" BIGINT
);

2010-2021 STATS19 Data - Casualties Greater Manchester

@ukgov.gm_road_casualty_accidents.n_2010_2021_stats19_data_casualties_greater_manchester

589.62 KB
62615 rows
14 columns


CREATE TABLE n_2010_2021_stats19_data_casualties_greater_manchester (
  "accident_index" BIGINT,
  "year" BIGINT,
  "vehiclereferencenumber" BIGINT,
  "casualtynumber" BIGINT,
  "casualtyclass" BIGINT,
  "sex" BIGINT,
  "agebandofcasualty" BIGINT,
  "casualtyseverity" BIGINT,
  "pedlocation" BIGINT,
  "pedmovement" BIGINT,
  "carpassenger" BIGINT,
  "buspassenger" BIGINT,
  "pedinjwork" BIGINT,
  "castypecode" BIGINT
);

2010-2021 STATS19 Data - Vehicles Greater Manchester

@ukgov.gm_road_casualty_accidents.n_2010_2021_stats19_data_vehicles_greater_manchester

766.52 KB
85356 rows
17 columns


CREATE TABLE n_2010_2021_stats19_data_vehicles_greater_manchester (
  "accident_index" BIGINT,
  "year" BIGINT,
  "vehiclereferencenumber" BIGINT,
  "vehicletype" BIGINT,
  "arttowing" BIGINT,
  "manoeuvre" BIGINT,
  "vehiclelocationoffroad" BIGINT,
  "junctionlocation" BIGINT,
  "skidding" BIGINT,
  "hitobjectoncway" BIGINT,
  "vehicleleavecway" BIGINT,
  "hitobjectoffcway" BIGINT,
  "firstpointimpact" BIGINT,
  "journeypurpose" BIGINT,
  "foreignreg" BIGINT,
  "sexofdriver" BIGINT,
  "agebandofdriver" BIGINT
);