query db to generate list of checkins