I've been looking into this as well and also have no idea what the source column refers too. josh.richau your our only hope...
Your hunch is correct that a user can follow a space in multiple streams so you will have to de-dupe based on user ID to get the number of followers instead of follows.
I use the query below for space followers and roll up based on what my end users want to know. I've found the receiveemails field is the most telling as some folks tend to ignore the UI notifications and still live in email. I also found some very interesting custom stream names from our users that provided endless LOLz.
select Streamid, jivestreamassociation.userid, jivestreamassociation.objectid, jivestreamassociation.objecttype, jivestreamassociation.receiveemails, jivestreamconfiguration.name, to_timestamp(jivestreamconfiguration.createddate/1000) as Creationdate, to_timestamp(jivestreamconfiguration.modifieddate/1000) as Modificationdate From jivestreamassociation join jivestreamconfiguration ON (jivestreamconfiguration.id = jivestreamassociation.streamid) Where jivestreamassociation.objecttype=14 --Objectype ID (14 is spaces) and jivestreamassociation.objectid= 3418 --Space ID order by createddate desc
Thank you Caton for the answer. I will try your suggestion