indexes by country and refactored index_by_id