Part of the reason that the latter has almost no visitors is that it is not shown in sidebar of any site. (Notice the link starting with chat.stackexchange.com rather than chat.meta.stackexchange.com.) We discussed this briefly also with Tim Stone: chat.stackexchange.com/transcript/13526/2018/6/9
I think that occasionally some users have inquiries about SEDE and SEDE queries. So a room devoted to this might be useful. We will see whether this room will get noticed and whether there will be some activity here.
I have added a few users who appeared in the old room a few times to the room owners. I hope it's ok. (After all, if somebody does not wish to be a room owner, you can easily remove your name from that list.)
Discussion related to the usage of Stack Exchange's Data Explorer
Should some other users be added as room owners?
Just for comparison - the other rooms I've linked to show total of 900 messages (in about 600 days) and 620 messages (in cca 1600 days). Let's hope this room will be more active than that.
For SEDE specific questions we now have https://chat.meta.stackexchange.com/rooms/1223/data-explorer-sede as well.
Thanks for doing that. Mentioning the room in other places might help some users to notice it.
Probably even the more important is whether there will be users who will have questions related to SEDE and who will post them here. (And also users willing to answer them here.)
@Martin PendingFlags is maybe a candidate but beyond that you can only rely on posthistory with the rows of type 10: Close event. It has in the text the json with closevoters
> If PostHistoryTypeId in (10,11,12,13,14,15,19,20,35) this column will contain a JSON encoded string with all users who have voted for the PostHistoryTypeId
But to use this in some way, I have to download query results and then work with it locally, right?
I mean, in this way I cannot obtain the wanted information directly as results of SEDE query.
I'll revisit that request from Joe W tonight and will see if I can come up with something that will come close ... I don't think a 100% fit is possible because we don't have reliable data on what was aged away
I'd guess that this is the difference which could be explained to a large extent by deleted posts. (A question which was closed is more likely to get deleted. Such questions are still counted in the votes tab.)
What you see in your votes tab is what you casted in total, even if that leads to a closed question or not. And deleted questions are still in that 1699 , correct.
Yes. That count includes both questions that weren't closed. And also questions that have been deleted and no longer are in the table used in the query.
It seems we typed at the same time - just to say basically the same thing. :-)
I was curious how whether the results will be similar if we restrict this to duplicates, so I have modified your query a bit (basically just added the condition comment=101) data.stackexchange.com/math/query/879924/…
IIRC this happens where a new feed is added to any room. The first five messages are collected at the beginning. The new ones are added as they appear on the site.
@Martin yes, I first had a feed for only MSE in mind but reckoned other meta's might have some SEDE stuff as well, I know at least MSO does. I do hope every meta site uses the [data-explorer] tag for SEDE otherwise we get some interesting but off-topic posts...
Just now I have seen this room in the sidebar for the first time.
It is at least good to know that this indeed works. As mentioned above, I creating the new room hoping that the room might have bigger chance to get noticed when it is shown in the sidebar.