The data we require are as follows (for period 1st January 2017 and 31st December 2017) in an electronic format that allows us to read the data into a database. Many hospitals respond to our survey and provide data in the form we require. Preferably this format is in an excel file or comma separated text file.

We require the gender of the patient (M or F), the date that they attended due to assault (dd/mm/yyyy) and their age. Age can either be numerical to the nearest year (preferred) or in age bands (“0-10”, “11-17”, “18-30”, “31-50”, “51+”), we can also accept date of birth.

To calculate the level of assault-related injury in England and Wales we also require the total number of attendances for any reason in the year of interest, i.e. 2017. Please see attached below.


Assault in A&E

©2019 Royal Surrey County Hospital

Log in with your credentials

Forgot your details?