FOI Request - Faulty Streetlights

Request 101002999311

1. How many streetlights have been reported as faulty in your area?
2. What was the average amount of time taken between the reporting of a fault with a streetlight and its resolution?
3. What was the longest delay between the reporting of a streetlight problem and its resolution?
4. What is the most recent estimate of the number of streetlights in your area that are currently not functioning or partly functioning?
I would like this information for each of the last six calendar years as follows: 2017/2018/2019/2020/2021/2022
I would like this data to be presented in an Excel or PDF spreadsheet with a new sheet for each year and a section on each point of information.

Response 09-03-2022

Q1 - 3): Please see document located here.

Q4). 17