added bad_date column to flags