cleaned up rawdata