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 used the following SQL query on Academia Stack Exchange:
SELECT * FROM Posts
This query generated 50,000 rows ... but the total number of questions on the website is approximately 28,000.
With that, it retrieves many missing values: the body of the post is present, but title and tags are missing for some of them.
How do I overcome this?
The Posts table contains both questions and answers (and some other types as well, e.g. tag wikis and excerpts). The total number of posts on Academia is (as of last Sunday morning) 95,073 but the maximum number of rows returned by SEDE is 50,000, so that's why you only get 50,000 rows.
The title and tags will only be present for questions, not for the other types of posts. They simply don't have those properties.
Most information you'll need will be in the Database schema documentation for the public data dump and SEDE, and you'll probably be interested in the tutorial as well.
