Case Status at a Specific Time
You need to base it on the entire history of activity subjects which is a bit tricky. I'm not sure how to do it in a drupal view.

In pseudocode it would be something like SELECT ChangeCaseStatus activity with MAX(date) earlier than activity date currently being output. If null then Active.