new views to simplify querying
and some requested reports added as query