Hi Dinar. Couple of options to suggest.
Firstly, assuming that you want the display to be linear rather than point based, create a copy of the selected street segments from a street vector layer (eg. StreetPro). There are not too many and they are in a relatively small area, so manually selecting the correct street segment shouldn't take too long. I would also probably add an ID field to this copy that matches the walking count data Site_ID field.
Once you have the selected street segments as a separate layer, it should be quite easy to utilise the numeric elements from the walking count table against the relevant street segments to generate a thematic map.
Another option to suggest would be to create a point based layer of locations matching the Site_ID from the walking count data and then using these points to display the walking count data as a thematic map. Again, not too many sites so generating a point layer wouldn't be too difficult.
Hope these help.