ALTER TABLE june_2017_zipcode_join
ADD UNIQUE (documentid);</nowiki>
=== Analyzing the Stopgap ===
See <code>Z:\zipcodes-oliver\postcodes_ranked.tsv</code> where the first column is zipcode and the second column is number of patents in that zipcode, in descending order.