text: -- Duplicate FL Zip5 records
  DELETE FROM tariff400ng_zip5_rate_areas WHERE zip5 = '32162' AND rate_area = 'US49';
  DELETE FROM tariff400ng_zip5_rate_areas WHERE zip5 = '32195' AND rate_area = 'US4964400';
  DELETE FROM tariff400ng_zip5_rate_areas WHERE zip5 = '32702' AND rate_area = 'US49';
  DELETE FROM tariff400ng_zip5_rate_areas WHERE zip5 = '32757' AND rate_area = 'US49';
  DELETE FROM tariff400ng_zip5_rate_areas WHERE zip5 = '32776' AND rate_area = 'US49';
  DELETE FROM tariff400ng_zip5_rate_areas WHERE zip5 = '32784' AND rate_area = 'US49';
  DELETE FROM tariff400ng_zip5_rate_areas WHERE zip5 = '34449' AND rate_area = 'US4964400';
  
  -- Duplicate TX Zip5 records
  DELETE FROM tariff400ng_zip5_rate_areas WHERE zip5 = '75831' AND rate_area = 'US66';
  DELETE FROM tariff400ng_zip5_rate_areas WHERE zip5 = '75844' AND rate_area = 'US66';
  DELETE FROM tariff400ng_zip5_rate_areas WHERE zip5 = '75846' AND rate_area = 'US66';
  DELETE FROM tariff400ng_zip5_rate_areas WHERE zip5 = '75855' AND rate_area = 'US66';
  DELETE FROM tariff400ng_zip5_rate_areas WHERE zip5 = '75969' AND rate_area = 'US66';
  DELETE FROM tariff400ng_zip5_rate_areas WHERE zip5 = '76511' AND rate_area = 'US68';
  DELETE FROM tariff400ng_zip5_rate_areas WHERE zip5 = '76519' AND rate_area = 'US66';
  DELETE FROM tariff400ng_zip5_rate_areas WHERE zip5 = '76527' AND rate_area = 'US66';
  DELETE FROM tariff400ng_zip5_rate_areas WHERE zip5 = '76534' AND rate_area = 'US68';
  DELETE FROM tariff400ng_zip5_rate_areas WHERE zip5 = '76569' AND rate_area = 'US68';
  DELETE FROM tariff400ng_zip5_rate_areas WHERE zip5 = '76570' AND rate_area = 'US68';
  DELETE FROM tariff400ng_zip5_rate_areas WHERE zip5 = '76629' AND rate_area = 'US66';
  DELETE FROM tariff400ng_zip5_rate_areas WHERE zip5 = '76687' AND rate_area = 'US68';
  DELETE FROM tariff400ng_zip5_rate_areas WHERE zip5 = '76883' AND rate_area = 'US66';
  DELETE FROM tariff400ng_zip5_rate_areas WHERE zip5 = '76943' AND rate_area = 'US68';
  DELETE FROM tariff400ng_zip5_rate_areas WHERE zip5 = '76950' AND rate_area = 'US68';
  DELETE FROM tariff400ng_zip5_rate_areas WHERE zip5 = '78631' AND rate_area = 'US66';
  DELETE FROM tariff400ng_zip5_rate_areas WHERE zip5 = '78642' AND rate_area = 'US66';
  DELETE FROM tariff400ng_zip5_rate_areas WHERE zip5 = '78654' AND rate_area = 'US68';
  DELETE FROM tariff400ng_zip5_rate_areas WHERE zip5 = '78669' AND rate_area = 'US66';
  
  -- Duplicate CA Zip5 records
  DELETE FROM tariff400ng_zip5_rate_areas WHERE zip5 = '93215' AND rate_area = 'US87';
  DELETE FROM tariff400ng_zip5_rate_areas WHERE zip5 = '93238' AND rate_area = 'US87';
  DELETE FROM tariff400ng_zip5_rate_areas WHERE zip5 = '93527' AND rate_area = 'US87';