What kind of evidence each role is reading

For each role, how many of its items are normative, code, presenter-reported, vendor-reported and so on.

Custom SQL query returning 10 rows (hide) 

select rr.role,
  sum(r.evidence = 'normative') as normative, sum(r.evidence = 'official') as official, sum(r.evidence = 'code') as code,
  sum(r.evidence = 'informative') as informative, sum(r.evidence = 'presenter-reported') as presenter_reported,
  sum(r.evidence = 'vendor-reported') as vendor_reported, sum(r.evidence = 'unverified') as unverified, count(*) as items
from resource_roles rr join resources r on r.id = rr.resource_id group by rr.role order by items desc

Edit SQL

This data as json, CSV

rolenormativeofficialcodeinformativepresenter_reportedvendor_reportedunverifieditems
communications 0 42 4 119 173 25 11 374
researcher 9 5 3 168 160 6 3 354
standards-policy 18 197 3 81 28 6 3 336
business-development 0 51 8 46 203 21 4 333
developer 18 6 53 90 22 2 2 193
infrastructure-operator 0 32 55 48 27 13 2 177
security-architect 18 4 11 121 16 0 1 171
investor 0 39 9 41 21 25 7 142
product 0 34 4 36 22 21 5 122
newcomer 0 3 2 30 33 3 5 76