Stack Overflow query not returning all data

Question

This is the first time I have tried querying the SO dataset so I may not be doing it correctly.

SELECT CreationDate, ViewCount,  Tags, ClosedDate , id
  FROM Posts

returns to me a datagrid headed thus

which is confirmed when opened locally. Over half the 50,000 rows have no values for ViewCount or Tags.

When I directly enter a specific ID where there is no ViewCount data, such as:

https://stackoverflow.com/questions/27537179 

I get redirected to

Dictionary int:variable(reference) in python

where there are ViewCounts and tags present.

Answer 1

The Posts table contains all questions and answers (and some other types of posts, like tag wikis). Only questions can have a ViewCount, Tags, and ClosedDate. Answers do not have any of those.

Try modifying your query to only select questions (PostTypeId = 1):

SELECT CreationDate, ViewCount, Tags, ClosedDate, Id
FROM Posts
WHERE PostTypeId = 1