responding with a total count for each connection property