329
edits
Changes
Jump to navigation
Jump to search
* 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* Need to cleanup addresses* Extract zipcode or reverse locate to find zip * "The 4-5 digit reel number refers to the microfilm reel number of the assignment entry in physical USPTO records; similarly the 1-4 digit frame number refers to the location of the assignment entry on the reel number in physical USPTO records. Thus, each assignment recorded with the USPTO has a unique reel number and frame number combination. While both reel number and frame number are sequential, there are missing values in the sequence because each only specifies the first page of the assignment records and records may have multiple pages." from https://www.uspto.gov/sites/default/files/documents/USPTO_Patents_Assignment_Dataset_WP.pdf, pg12, footnote 38TODO
→Address Data
== Address Data ==
== Related Pages ==
