_id year geography ratio