Stage 1. Download the survey data

The data collected from the survey needs to be organised into an Excel file using the template provided by the JLA (xlsx, 15.63 KB).  This will include the suggested uncertainty and the type of submitter, including any background details collected.  This will require data to be downloaded if collected online or entered manually if paper and telephone submissions have been gathered.

The dataset then needs to be cleaned and organised as detailed in the following steps:

  • remove incomplete or blank rows
  • where one respondent has submitted more than one uncertainty, ensure these are separated so there is one submission per row, always ensuring demographic data is copied across so the origins of each submission are retained
  • anonymise the data by removing any personal details such as name and address.

The Excel template will be supplied by the JLA and it is this completed template which will be shown on the JLA website at the end of the PSP.  For an example of how PSP data will appear, please see the Mesothelioma Top 10.