Meta Stack Exchange is a question and answer site for meta-discussion of the Stack Exchange family of Q&A websites. It only takes a minute to sign up.
Sign up to join this community
I have downloaded the data dump which has several files like posts.xml, posthistory.xml, although I cannot find the compete version of the closed questions: for example, its title, owner user id, comments, answers.
Can anyone help me to find all entire closed questions set?
As with many programming problems, the easy way to do things is to crib from someone who already did it.
Caveat: The following is tied to the Mathematics StackExchange site, basically because it's a good size but not gargantuan like StackOverflow. Each SE site has its own query interface, so you'll need to pick one to run a query against (rather than all sites at once).
You'll probably want to create a login account for the StackExchange Data Explorer. By design you can preserve some extra anonymity by creating an account name there which is unrelated to other site activities, though I did not feel motivated to do so.
I looked through search results for queries containing "close" and found this one:
SELECT *
FROM POSTS
WHERE CLOSEDDATE IS NOT NULL
Probably you really intend to do something more refined, perhaps in the way of a range of dates posted (or closed). Post a follow-up comment if you'd like a bit more of a tutorial. The link in the caption above let's you Run Query, and there are a couple of optional settings to play with.
SELECT * with SELECT COUNT(*) we find that there have been roughly 3,557 posts closed on the Math.SE forum. This probably doesn't include deleted posts. But it says about 3% of math Questions there have been closed for one reason or another.
SELECT * FROM STACKOVERFLOW WHERE CLOSEDDATE IS NOT NULL right ?
POSTS in the SQL Query refers to a table, and each Data Explorer has a separate schema for each StackExchange site, so the one for Mathematics has only records pertaining to that site.
SELECT COUNT(*) FROM POSTS WHERE CLOSEDDATE IS NOT NULL version there? Bear in mind that StackOverflow has well over 4 million posts (Questions), so I too would expect a larger number of closed posts than 50,000. Probably that's a limit set on query execution through the Data Explorer.