db.query(
    "    LOAD DATA INFILE '%s'     INTO TABLE %s     CHARACTER SET utf8     FIELDS TERMINATED BY ','     (null, name, alt_name, population)     "
     % (temp_file, table))
LOAD DATA INFILE doesn't load all my data