delete from report_county where county_cd = '069' and id = '791972' and type_cd = 'D';
delete from report_county where county_cd = '069' and id = '792777' and type_cd = 'O'; 
delete from report_county where county_cd = '055' and id = '13424' and type_cd = 'D';
delete from report_county where county_cd = '055' and id = '12647' and type_cd = 'D';
delete from report_county where county_cd = '055' and id = '12647' and type_cd = 'O'; 
delete from report_county where county_cd = '055' and id = '13424' and type_cd = 'O'; 
delete from report_county where county_cd = '093' and id = '791380' and type_cd = 'D';
delete from report_county where county_cd = '093' and id = '11110' and type_cd = 'O'; 
delete from report_county where county_cd = '093' and id = '11110' and type_cd = 'O'; 
delete from report_county where county_cd = '073' and id = '790944' and type_cd = 'O'; 
delete from report_county where county_cd = '073' and id = '790656' and type_cd = 'D';
delete from report_county where county_cd = '107' and id = '12518' and type_cd = 'D';
delete from report_county where county_cd = '107' and id = '770118' and type_cd = 'D';
delete from report_county where county_cd = '107' and id = '770108' and type_cd = 'D';
delete from report_county where county_cd = '093' and id = '792322' and type_cd = 'D';
delete from report_county where county_cd = '111' and id = '13477' and type_cd = 'D';
delete from report_county where county_cd = '111' and id = '10045' and type_cd = 'D';
delete from report_county where county_cd = '069' and id = '6739' and type_cd = 'D';
delete from report_county where county_cd = '069' and id = '6739' and type_cd = 'D';
delete from report_county where county_cd = '047' and id = '13691' and type_cd = 'O'; 
delete from report_county where county_cd = '047' and id = '750237' and type_cd = 'O'; 
delete from report_county where county_cd = '047' and id = '8705' and type_cd = 'O'; 
delete from report_county where county_cd = '047' and id = '750024' and type_cd = 'D';
delete from report_county where county_cd = '047' and id = '823' and type_cd = 'O'; 
delete from report_county where county_cd = '047' and id = '750059' and type_cd = 'O'; 
delete from report_county where county_cd = '047' and id = '2518' and type_cd = 'D';
delete from report_county where county_cd = '047' and id = '2518' and type_cd = 'D';
delete from report_county where county_cd = '047' and id = '4070' and type_cd = 'O'; 
delete from report_county where county_cd = '047' and id = '788' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '400005' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '400064' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '400020' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '791645' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '792683' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '400076' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '400018' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '3314' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '8910' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '770251' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '4979' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '115' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '10985' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '10986' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '7422' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '7427' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '9361' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '400097' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '4975' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '13725' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '9359' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '400014' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '9397' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '7400' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '9396' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '10988' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '400048' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '4968' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '770372' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '790631' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '7432' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '14041' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '791125' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '400026' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '9391' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '7415' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '770249' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '12446' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '400040' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '4094' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '3317' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '4976' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '790608' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '12447' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '9357' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '13735' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '125' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '770254' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '116' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '770253' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '120' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '790769' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '400086' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '400086' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '400021' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '12862' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '127' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '7409' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '9401' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '7423' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '9395' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '791179' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '4984' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '9362' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '15325' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '791864' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '790747' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '13769' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '13771' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '400030' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '792387' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '15324' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '12448' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '400025' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '10997' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '13734' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '3324' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '4985' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '13729' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '4983' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '12864' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '792313' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '3320' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '7404' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '400094' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '7428' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '114' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '7431' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '400028' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '790377' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '7416' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '400078' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '9352' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '98' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '9358' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '7421' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '4982' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '4965' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '10992' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '792325' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '9346' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '792313' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '98' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '98' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '1200' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '7430' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '13731' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '790316' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '4962' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '791794' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '7414' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '107' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '4989' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '101' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '13724' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '11000' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '400027' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '790840' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '400035' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '4966' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '13730' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '791324' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '4972' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '12317' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '4973' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '4967' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '3322' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '3322' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '4964' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '9331' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '11006' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '12497' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '15321' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '791061' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '128' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '10998' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '4978' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '792313' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '4974' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '11015' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '11013' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '14032' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '400039' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '13742' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '791583' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '4974' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '15308' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '92' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '7399' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '10990' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '791881' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '400110' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '7429' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '111' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '7433' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '790348' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '790650' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '111' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '14042' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '4959' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '9312' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '7401' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '400089' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '790345' and type_cd = 'D';
delete from report_county where county_cd = '077' and id = '400051' and type_cd = 'O'; 
delete from report_county where county_cd = '077' and id = '790926' and type_cd = 'O'; 
delete from report_county where county_cd = '077' and id = '7416' and type_cd = 'O'; 
delete from report_county where county_cd = '077' and id = '128' and type_cd = 'O'; 
delete from report_county where county_cd = '077' and id = '9331' and type_cd = 'O'; 
delete from report_county where county_cd = '077' and id = '9342' and type_cd = 'O'; 
delete from report_county where county_cd = '077' and id = '790304' and type_cd = 'O'; 
delete from report_county where county_cd = '077' and id = '771410' and type_cd = 'O'; 
delete from report_county where county_cd = '077' and id = '771808' and type_cd = 'O'; 
delete from report_county where county_cd = '077' and id = '400045' and type_cd = 'O'; 
delete from report_county where county_cd = '077' and id = '4094' and type_cd = 'O'; 
delete from report_county where county_cd = '077' and id = '771353' and type_cd = 'O'; 
delete from report_county where county_cd = '077' and id = '771405' and type_cd = 'O'; 
delete from report_county where county_cd = '077' and id = '127' and type_cd = 'O'; 
delete from report_county where county_cd = '077' and id = '7401' and type_cd = 'O'; 
delete from report_county where county_cd = '077' and id = '791224' and type_cd = 'O'; 
delete from report_county where county_cd = '077' and id = '4990' and type_cd = 'O'; 
delete from report_county where county_cd = '047' and id = '15145' and type_cd = 'O'; 
delete from report_county where county_cd = '107' and id = '791690' and type_cd = 'D';
delete from report_county where county_cd = '107' and id = '550045' and type_cd = 'D';
delete from report_county where county_cd = '107' and id = '770187' and type_cd = 'D';
delete from report_county where county_cd = '107' and id = '770188' and type_cd = 'D';
delete from report_county where county_cd = '107' and id = '10023' and type_cd = 'D';
delete from report_county where county_cd = '107' and id = '10029' and type_cd = 'D';
delete from report_county where county_cd = '107' and id = '792481' and type_cd = 'D';
delete from report_county where county_cd = '107' and id = '12517' and type_cd = 'D';
delete from report_county where county_cd = '107' and id = '12521' and type_cd = 'D';
delete from report_county where county_cd = '107' and id = '12516' and type_cd = 'D';
delete from report_county where county_cd = '107' and id = '12519' and type_cd = 'D';
delete from report_county where county_cd = '107' and id = '12515' and type_cd = 'D';
delete from report_county where county_cd = '107' and id = '12513' and type_cd = 'D';
delete from report_county where county_cd = '107' and id = '12520' and type_cd = 'D';
delete from report_county where county_cd = '107' and id = '790036' and type_cd = 'D';
delete from report_county where county_cd = '107' and id = '11657' and type_cd = 'D';
delete from report_county where county_cd = '107' and id = '14099' and type_cd = 'D';
delete from report_county where county_cd = '047' and id = '791111' and type_cd = 'D';
delete from report_county where county_cd = '147' and id = '793815' and type_cd = 'O'; 
delete from report_county where county_cd = '093' and id = '793838' and type_cd = 'O'; 
delete from report_county where county_cd = '093' and id = '793862' and type_cd = 'O'; 
delete from report_county where county_cd = '093' and id = '793860' and type_cd = 'O'; 
delete from report_county where county_cd = '093' and id = '793870' and type_cd = 'O'; 
delete from report_county where county_cd = '093' and id = '791715' and type_cd = 'O'; 
delete from report_county where county_cd = '093' and id = '771446' and type_cd = 'O'; 
delete from report_county where county_cd = '147' and id = '200106' and type_cd = 'D';
delete from report_county where county_cd = '147' and id = '200106' and type_cd = 'D';
delete from report_county where county_cd = '147' and id = '200106' and type_cd = 'D';
delete from report_county where county_cd = '147' and id = '350142' and type_cd = 'D';
delete from report_county where county_cd = '147' and id = '790444' and type_cd = 'D';
delete from report_county where county_cd = '147' and id = '750230' and type_cd = 'D';
delete from report_county where county_cd = '147' and id = '791962' and type_cd = 'D';
delete from report_county where county_cd = '147' and id = '791318' and type_cd = 'D';
delete from report_county where county_cd = '017' and id = '100026' and type_cd = 'D';
delete from report_county where county_cd = '093' and id = '771631' and type_cd = 'O'; 
delete from report_county where county_cd = '093' and id = '480053' and type_cd = 'D';
delete from report_county where county_cd = '073' and id = '792042' and type_cd = 'D';
delete from report_county where county_cd = '073' and id = '792042' and type_cd = 'D';
delete from report_county where county_cd = '093' and id = '792871' and type_cd = 'D';
delete from report_county where county_cd = '093' and id = '792871' and type_cd = 'D';
delete from report_county where county_cd = '093' and id = '792827' and type_cd = 'D';
delete from report_county where county_cd = '093' and id = '9572' and type_cd = 'O'; 
delete from report_county where county_cd = '093' and id = '793869' and type_cd = 'O'; 
delete from report_county where county_cd = '119' and id = '10945' and type_cd = 'D';
