Sitecore 9.2
How can I determine which user has unsubscribed via a sent campaign?
Looking at xdb shards I see ListSubscriptions facet key and I see when a user is added and active.
You can't. There is no difference between someone who has never subscribed and and one who has unsubscribed.
You will need to add your own logic to the HandleListUnsubscribe
or UnsubscribeFromList
and possibly the UnsubscribeFromAllEvent
pipelines.