cleaned up inspection data and added vendor type