While trying to examine the distribution of question view counts on Stack Exchange sites, I came across an anomaly - there appear to be questions in the database with NULL ViewCounts. This query I ran on Stack Overflow found a small (but not insignificant) number of questions with this. They all appear to be questions asked between 12.41pm and 12.55pm on 13 January.

SELECT Id AS [Post Link], ViewCount, CreationDate FROM Posts 
WHERE PostTypeId = 1 AND ViewCount IS NULL
ORDER BY CreationDate



These are the last few questions to be imported into the Data Explorer. I'm guessing they got a ViewCount of NULL because their ViewCount is actually zero.

  • Which has always confused me. Doesn't the initial viewing of the post on submit = 1?
    – jcolebrand
    Jan 30, 2013 at 15:00

1 Answer 1


This appears to have been fixed at some point.


You must log in to answer this question.

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