1. I would like you to provide me with all repair requests made to the local authority by tenants of residential council housing in the years of 2018, 2019, 2020 and 2021. I would also like you to tell me which category each request fell into or was determined as under the council’s repair type hierarchy, (e.g. “emergency”, “urgent”, “routine”) if the council has such definitions. For context, it would be useful for you to provide me with the number of council housing units currently managed by the authority.

2. For each of these repair requests, I would also like you to tell me what date the request was made and the date the repair was completed. Again, I would like you to provide me with the classification of the repair requested, so ideally this data would be syndicated with the data requested above. Ideally it would be useful to have detail about the nature of the repair (e.g. “mold”, “total loss of power”) but if this creates an unreasonable extra amount of work then simply the repair type will be fine.

We are unable to report on this information and would have to manually go through out records. This request would exceed the appropriate limit so we are applying Section 12 to this request.

Our main repairs contractor averages about 9000 jobs a year. Therefore, over the four years there is likely to be 36,000 jobs to look at. Due to the way we log these jobs, to answer the question accurately we would have to generate a report that identifies all these jobs. The details of the jobs are in the notes section of Northgate (there is a text summary but this is cursory and not always used). Therefore, it would be necessary to search for the property, navigate to the notes section, read what the issue was and then type a summary into a spreadsheet.

18 hours divided by 36,000 = 0.03. Therefore, in order to do this task in less than 18 hours we would have to do all the above in less than 2 seconds per record (2 seconds X 36,000 jobs = 72,000 seconds = 1200 minutes = 20 hours. We do not know how long it would take per job, but think its more reasonable at 3 or 4 minutes per job.