In which table can I find all content a specific user has posted to the newsfeed?
ow_newsfeed_status and ow_newsfeed_activity seem to have some, but I am not sure if all or how to sort it by user?  In the newsfeed action table, I can see when I click on the "data" column and look at the content, it includes the user's ID, but is there a better way to sort than clicking one by one through every entry to check if it is associated with a particular user?

And if a user has deleted status updates, will it still be in the table or no?  Do I have to look in a site backup to (hopefully) get them?

Sorry if this is really obvious...