adjustments for utf8 and a few column names since I'm hacking this for speed and I'm used to my own column naming conventions