6

I'm not sure if this is possible (maybe someone with the access to all the site analytics can answer this question). Which Stack Exchange site has the highest upvote to downvote ratio? Which one has the lowest? Are there any reasons for why this is so?

Let's limit the sites to those which are public, so excluding sites which are still in private beta.

I hope an answer is out there!

0

1 Answer 1

12

According to this SEDE query, TEX.SE has the highest upvote/downvote ratio: 70.57 upvotes for each downvote. Islam.SE has the lowest, only 2.29 upvotes for each downvote.

For reference, here is the complete query:

-- result table, don't rename and keep the site column
create table #results (site nvarchar(250)
                       , votetypeid int
                       , numberofvotes int);

declare @sql nvarchar(max) = ''   -- holds build up sql string

-- build one biq union sql, for each db
select @sql = @sql 
+ iif( len(@sql) > 1 
     , 'union all'
     , 'insert into #results'
) +
-- here goes the per site query, fully qualify the database objects
N'
select ''' + name + '''
     , votetypeid
     , count(*)
from ' + quotename(name) + '.dbo.votes
where votetypeid IN (2, 3) group by votetypeid '
from sys.databases
where database_id > 5
  and (name not like '%.Meta' or name = 'StackExchange.Meta')

-- execute it
exec (@sql)

select u.site,
  u.numberofvotes AS [# upvotes],
  d.numberofvotes AS [# downvotes],
  ROUND(CAST(u.numberofvotes AS FLOAT) / d.numberofvotes, 2) AS [U/D ratio]
  from #results as u
  inner join #results as d
  on u.site = d.site
  where u.votetypeid = 2
    and d.votetypeid = 3
  order by CAST(u.numberofvotes AS FLOAT) / d.numberofvotes desc

drop table #results

Note that SEDE is updated once a week, on Sunday morning.

5
  • Wow this is very cool! I guess its up to the social scientists to posit why this is so.
    – Bensstats
    Commented Mar 6, 2018 at 20:49
  • Tough to say. Overall quality of posts could be a factor, as well as the ratio of users which are able to upvote vs. those who are able to downvote.
    – Glorfindel Mod
    Commented Mar 6, 2018 at 21:57
  • 2
    @Glorfindel My guess is it’s highly correlated with the local “eternal September”, whether that’s already occurs for each site, and if so how long ago it started. A good proxy would be size and age of each site. The smaller and newer a site is, the more friendly I’d expect it to be. Once the public (aka “unwashed masses”) have flooded in, I expect the downvotes to swiftly follow.
    – Dan Bron
    Commented Mar 6, 2018 at 22:09
  • Replace "Nintendo" by "TeX"
    – user315433
    Commented Mar 6, 2018 at 22:23
  • @PloniAlmoni It's likely because Islam is a religion which, like others, contains a lot of subjective opinions and mutually-incompatible views. This leads to substantial disagreements. Commented Apr 23, 2019 at 22:27

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .