Figures obtained from a BBC investigation has found that Yorkshire councils’ government funding has been axed by more than £900m since 2015.