aggregates table with ids matched to gaul