added data from malformatted crns
data cleanup