change db.r to return the latest survey of each facility