update the tests for the rank.pre -> rank.id changes
updating sql and csv