As a quick and dirty fix, walk through the cases and do the best we can. The script for that is located at <code>E:\McNair\Projects\SimplerPatentData\src\db\ZipCodeHotfixhacks\June2017PostcodeHotfix.sql</code> and it creates the following table:
<nowiki>
DROP VIEW IF EXISTS june_2017_zipcode_hotfixjune_2017_postcodecode_hotfix;