The current version of the data dump does not have information on whether or not a question is protected. Can we add a ProtectedDate column to this table? It would be NULL on answer records and question records that are not yet protected.
1 Answer
I'm not sure why this still isn't present in the Posts
table (besides perhaps lack of demand), but there is sufficient information in PostHistory
now to determine if a post is currently protected if you really need it.
Grabbing the latest post history entry with a PostHistoryTypeId
of 19 or 20 (protected and unprotected, respectively) will allow you to determine which questions were marked protected at the time the data was last updated, as you can see in this example query.