SEDE - Stack Exchange Data Explorer

Not sunday! :(

Sunday

This room is now ten years old. Happy anniversary!

@MartinSleziak 🍰🎆🎈🎉🥳🎂🎊

This room is now nine years old. Happy anniversary!

This room has been relatively silent recently. Just in case it gets frozen, I will remind that moderators can unfreeze chatrooms - so you can ask some moderator (from any site) whether they would be willing to do so. See also: meta.stackexchange.com/tags/frozen-rooms/info and How do I unfreeze a frozen chat room?

Easter!

Sunday Sunday Sunday!

Top users ordered by the amount on bounties of questions by others: data.stackexchange.com/materials/query/1704217

I'm trying to figure out how to write a query, that shows if self-answers (where the question and post are at the same time) put off other answerers

@MartinSleziak I assume Tags is a derived value and only stored in the Posts table for performance reasons. Therefor, what you see on the site is in the database. As you see the current tags on a deleted post you will see the current tags in the PostWithDeleted.Tags field. One way to verify if a post was edited after its deletion is to compare deletiondate and lasteditdate

This room has been relatively silent recently. Just in case it gets frozen, I will remind that moderators can unfreeze chatrooms - so you can ask some moderator (from any site) whether they would be willing to do so. See also: meta.stackexchange.com/tags/frozen-rooms/info and How do I unfreeze a frozen chat room?

@MartinSleziak this might be slightly more efficient due to joining. This works in this case because you want records where no equivalent records exist in the joined tables: data.stackexchange.com/askubuntu/query/1456091/…

Basically, sure. I can find the post that has had suggested edits to them. But then I'm back as looking at a suggested edit and not knowing how to can determine the difference between those being were made by anonymous or a deleted user..

I've been looking at the tables suggestededits and users because I'd like to find suggested edits made by deleted users. Not anonymous users. For anonymous users, I can just do an outer join on the users table and have users.id is null.

Can SEDE get the target for a duplicate question?

I'm looking here at just PostHistory with an event 5 (that is body edited). The text field will have the complete text for that new revision. I got the number of words by splitting the text on a single space. What I can do is find the previous revision, spilt on space to get that word count and then subtract the two. That is about it what can work for a single user.

There is now new SEDE room. Since some users pointed out various potential problems (different chatserver, inaccessible to users with no reputation on Meta Stack Exchange), it's probably worth keeping this one alive, too.

Hi to all! Where can I ask to improve a query in Data.SE?

Hi and welcome to discussions about the Stack Exchange Data Explorer chat room.

it can't be frozen automatically now

@Tim data.stackexchange.com/help#faq

@MartinSleziak out of curiosity, why meta? Another server = another site to check = bookmarked chat rooms I won't see by default so might not remember to visit... is there really more visible than here? Maybe, because of Tavern? Anyway, thanks, and I'll try to remember to check it regularly.

was mainly looking to see where I fell in the rankings of close voters on a site.someone got upset at a close vote I casted and accused me of being to quick to cast close votes so I just was wondering where i stood in the close vote rankings on the site.

Just wondering is there anyway to use the data explorer to get an overview of close votes cast on a site possibly by user?

@ccorn It seems that votes are put into database with midnight as creationdate: data.stackexchange.com/math/query/862670/votes-older-than-posts data.stackexchange.com/math/query/862672/…

Is there any limit on queries as I am observing only 50,000 rows are returned on many of my queries ?

Some similar queries are also mentioned on meta.SE: How do I find my rank for a specific tag? and How to find top users by several tags?

In the event it does I'll unfreeze it, no worries :)

Hi, is it possible to query data.SE from a rest api by posting f.x. a T-SQL statement?