Questions to the Mayor of London – answered at on 23 February 2022.
In your responses to questions 2021/3882 and 2021/3883 you stated "Transport for London (TfL) has not removed bus safety data from its website. The same data, dating back to 2014 is available to the same level of detail in an analysis tool called Power BI. This can be found on the Bus Safety Data pages on the TfL website.” However, inter alia, Power BI does not let the user (a) aggregate data across injury classifications (users can select “deaths” or "serious injury” but cannot combine “deaths and serious injuries”, a basic measurement of safety) (b) compare different bus operators’ safety performance across categories (users have no ability to compare operators’ safety performance across years, injury categories, etc, so another important safety metric has been made much more difficult to construct) or (c) download the raw data found on the app. Simply put, the utility and flexibility of the Quarterly Bus Safety data set, which was published on a quarterly basis as an Excel spreadsheet, is no longer available via BI. Will you now publish Excel spreadsheets for Quarterly Bus Safety data starting from Q2 2021 to the present?
As stated in my response to Mayor’s Question 2021/4896, the bus safety dashboard is built using Power BI, an analysis tool which allows users to examine data in an easy and intuitive way, without reliance on costly software. The Power BI publish to web function does not enable users to export data. However, to enable further data analysis, Transport for London (TfL) is able to provide London Assembly members with the ability to export the data.
In response to your specific queries: