Patent Counts
*Jeemin is a savior, matched and counted 128,000 entries (Jeemin_matcher_matched.txt), manually went through the 6,000 unmatched (Jeemin_matcher_unmatched.txt), Check [[University Patent Matching]]
*Ranking for all time is in Patent Counting ( >Total (All Time) )
*Need to talk with Meghana about grant data
*Need table of all patents associated with matches, join patent numbers with inventors
*Group by last name and first initial (=1 inventor)
'''5/1'''
*Joined patent numbers with inventors -> unipatentinventorcount.sql
**Z:univ/InventorCounts.txt
*Decade patent counts is buggy -> Z:univ/DecadePatentCounts
**still needs some work
Issue brief draft (VERY rough): https://docs.google.com/a/rice.edu/document/d/1MayXQEQ_pM0LMeiV39iaNFjtMZYSB-Ah9gCx1rcgW9M/edit?usp=sharing