-1

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?

1

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.

  • Thank you for the response...i want to download the data of all question posts which have title , tag, creationDate, body of the posts...how to get that only – mohitji May 20 at 18:46
  • SELECT Title, Tags, Body FROM Posts WHERE PostTypeId = 1 – mohitji May 20 at 18:53
  • That should work, yes. – Glorfindel May 20 at 18:54

You must log in to answer this question.

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