329
edits
Changes
Jump to navigation
Jump to search
→Address Data
* Question: "In which zipcodes are the most patents granted?"
** Hacky answer: <code>\COPY (select postcode, count(documentid) as c from june_2017_zipcode_join group by postcode order by c desc) TO '/bulk/zipcodes-oliver/postcodes_ranked.tsv' (format csv, delimiter E'\t')</code>
** <code>Z:/zipcodes-oliver/postcodes_ranked.tsv</code>
* Zipcode granularity--if possible, finer detail wanted
* Filter non-US, null addresses
