The state database will only show the latest right meaning if a change has been implemented somewhere, you won't know that there's been a change. So it's just a snapshot of that very moment. It doesn't dig into transaction level things really. The time is like between each block. We have no way at all of knowing what the value of this contract has been in the past. We don't know if it's changed, if it was once this or that. We only know that right now after this block, it's zero. And we're not going to say as I understand it, you can go backwards and look at the state at different times.
In this introductory episode, we discuss what makes up blocks and block headers. We also cover a bit about state vs history, what exactly makes up a transaction and do a quick intro to a Merkle Tree.
For more, please check out these resources: