Knife crime statistics (March 2017 to March 2019) - GSA 1150/19

Please supply for the period 31 March 2017 to 31 March 2019:

Locations of each knife-related crime either Eastings and Northings or Latitude and longitude, snapped to the street centre line for each crime and the name of each street that the coordinates are snapped to.

For each individual crime, the Home Office minor sub group code ( for example, 131: robbery of personal property, 111: Violence with injury etc) Please DO NOT limit the response just to the two example codes. I would like to receive every instance of where knives have been used in a crime.

The month and year (eg Aug 17, Jan 18) of each crime

The total number of offences recorded in each location for each month. So, for example, if two crimes took place in the same road in the same month, list that as two offences (see examples below).

With regards location, I am very happy to have it suitably anonymised, eg Eastings and Northings or Latitude and Longitude, but to a point "on or near" a named road centre rather than anything that could identify a property.

Please supply the data in a spreadsheet, either .xls or .csv

As an example, this is the format I would like the data in (data below is dummy)

Crime Date (YearMonth) HO Minor Sub Group Location Easting Northing Total

2018 (Aug) 111 On or near Fictional Street 538492 183382 1

2018 (Aug) 111 On or near Fictional Road 530336 175074 1

2018 (Sep) 111 On or near Testing Lane 530458 175073 1

2018 (Sep) 111 On or near Testing Street 530920 175232 1

2018 (Oct) 111 On or near Example Road 536298 171992 2