You may want to count highway=path foot=designated bicycle=designated ways.

And highway=cycleway foot=designated + highway=cycleway=foot=yes.

This covers things like footway and cycleway being one object, cycleway with allowed walking etc.

And just to reiterate: results will be highly influenced by how well mapped are various places.

Some places have carefully mapped all footways in cemeteries, this may skew results a bit compared to places where sidewalks exists but noone mapped them.