4

I'm wondering if there any way to obtain, for a specific Stack Exchange site such as Philosophy, how many questions exist that have 0 upvotes, 1 upvote, -1, etc.

5

You can do this easily with a SEDE query - this one uses the score of a question instead of upvotes only, as I think that's what you're looking for.

enter image description here

For reference, here is the query. Please note that SEDE is updated only once a week, on Sunday morning.

SELECT Score, COUNT(*)
  FROM Posts
  WHERE PostTypeId = 1
  GROUP BY score
  ORDER BY score
  • Thanks! I run the query but there is a lot of rows of text as a result. I know, they are the information we are looking for, but... How to plot it? Do you had to use a external program? – Santropedro Oct 30 '16 at 19:22
  • You're welcome. Next to the Results tab, there's a Graph tab: data.stackexchange.com/philosophy/query/567249#graph – Glorfindel Oct 30 '16 at 19:23
  • Yes, perfect, thank you! Actually it's very visible, I was a little blind when I didn't saw it. – Santropedro Oct 30 '16 at 19:24
  • results are likely skewed because there is no data on deleted posts - if I understand correctly PostsWithDeleted has the information about score and could be used instead of Posts in such SEDE queries – gnat Oct 31 '16 at 8:42
  • 1
    @gnat yes, but one could argue that deleted posts don't exist anymore and should not be included in the results. – Glorfindel Oct 31 '16 at 9:02
  • many deleted posts hang on a site for quite a while, this may impact voting on other posts (through daily vote limit) and perception of users who observe site front page. What was distribution of votes at MSE on Apr 21, 2016? – gnat Oct 31 '16 at 9:11

You must log in to answer this question.

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