modified index view to reflect information present in database