Changes

{{McNair ProjectsProject|Project TitleHas project output=University PatentsData,Content,Guide|Topic AreaHas sponsor=McNair Center|Has title=University Patents and Innovation,|OwnerHas owner=Julia Wang,Meghana Pannala, Anne Dayton|KeywordsHas keywords=Patent,|Has project status=Active

Goal: list of all universities and # of patents associated with each university and patent licensingactivity

==Timeline to Deliverable & Documentation= Key Words = Meghana: focus on grants Julia: focus on patent counts Working in E:McNair/University Patents '''3/20-3/24''' Learn SQL, clean data '''3/27-3/31''' Counts of data, name matching Patent Counts*Ran the matcher in the server, only matched ~40,000 entries*Working with Jeemin to develop matcher '''4/3-4/7''' Counts of data, name matching 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 to find variables for regression, develop ranking for last decade and last year*Also need to account for school size (faculty? students? research funding?) '''4/10-4/14''' Develop ranking  Patent Counts*Finish all of above*Start drafting*Load data onto database -> E:McNair/University Patents/unidatajoin.sql in univ (database) '''4/17-4/21''' *Combined Patent Counts, R&D Expenditure, NSF Grant Data*STATA regressions in E:McNair/University Patents/STATA**for finding Universities historical data '''4/24''' From Ed:*Copied inventors table out of PatentDB database on RDP*Script in E:McNair/PatentData, MoveInventors.sql*Copy of data in Z:AllPatents and ran import into patent (database)For Marcela:*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 -> Z:univ/DecadePatentCounts*Calculated Hirschman-Herfindahl index -> E:McNair/University Patents/Inventor Counts and Superstars '''5/5''' Artifacts:#10-Year Ranking All#10-Year Ranking Private#10-Year Ranking Public#Top 10 Movers and Shakers#Graph of Concentration of Innovation#Number of University Patents Over Time#Inventor Concentration#Regression Table *Created Graph of Concentration of Innovation -> E:McNair/University Patents/Inventor Counts and Superstars -> GraphUPS*Created Top Inventors Chart -> University Patents/Report Articles/Inventor Rankings '''5/9''' *Figuring out what's up with the university puller*Developing new 10-Year Rankings*Need to update above two articles*Need to load into STATA and re-run regressions -> University Patents/STATA/univdata.do '''5/10''' *Figured out what was wrong with the data pull and now everything's good!*Updated information on the draft below*Fantastic Artifacts and Where to Find Them**10-Year Ranking All***Chart (University Patents > Report Artifacts > 10-Year University Patent Rankings)**10-Year Ranking Public***Chart (University Patents > Report Artifacts > 10-Year University Patent Rankings)**10-Year Ranking Private***Chart (University Patents > Report Artifacts > 10-Year University Patent Rankings)**Top 10 Movers & Shakers (% change between first 5 years (2006-2010) vs next 5 years (2011-2015) within top 100**Graph of Concentration of Innovation (numbers of patents)***Pie graph (University Patents > Report Artifacts > Concentration of Innovation)***(Excel sheet where this came from is University Patents > Inventor Counts and Concentrations)**Trends Over Time***Total vs. top 10***Graph (University Patents > MoversandTop10)**Inventor Concentration***Chart (University Patents > Report Artifacts > Inventor Rankings)**Reg Table***+Explanation of variables ***(STATA do-file with the most statistically significant regressions is in University Patents > STATA > univdata.do)  Issue brief draft (VERY rough): https://docs.google.com/a/rice.edu/document/d/1MayXQEQ_pM0LMeiV39iaNFjtMZYSB-Ah9gCx1rcgW9M/edit?usp=sharing ==Ranking Development Notes==Sources of University Funding R&D [https://www.aaas.org/page/rd-colleges-and-universities]*Roughly 60% comes from the Federal Government*Less than 10% comes from state and local governments*Roughly 20% is from the University itself (endowment?? tuition? not 100% sure)*Roughly 5% is from private industry*Less than 10% Other Federal Government Funding Breakdown [https://www.aaas.org/page/rd-colleges-and-universities]*Roughly 60% of federal funding is from the NIH*Roughly 15% is from the NSF*Roughly 11% from Department of Defense*Roughly 4% from NASA*Roughly 4% from the Department of Energy*Roughly 3% from the USDA*Roughly 1% from the EPA (probably will go to zero with new admin)*Roughly 1% from the Department of Education*Marginal amounts from everywhere else (<1%)

UNIVERSITY NOTES*overall ranking (total number of patents)*weight by faculty (people)*weight by research funding*weight by endowment (maybe)*public vs private*individuals: surname and first initial**ranking by inventors - also exclusively describes Universitieswho are the superstar inventors and where are they (define superstar inventor - idk 20 patents and rank universities by how many superstars are present**Herfindahl-Hirschmann Index

UNIVERITY ==Key Words== ===Universities (common misspellingPatent Assignees)===BOARD OF REGENTS - pretty much exclusively describes universities UNIVERSITY - also exclusively describes universities*Can we do a close match with University? (its the only word on this list that's frequently misspelled)

** also are used to describe actual schools (i.e. HISD) and other businesses** sometimes present in addresses - can we cut off the adresses?** also used in combination with Business (i.e. Harvard Business School)** use school only in conjuction with medical, medicine, and business COLLEGE *need to cut off addresses for this to work*need to ensure that we include the space after*excl. College Boulevard, college blvd, etc.*double check everything with College Park INSTITUTE OF TECHNOLOGY - almost exclusively describes universities but sometimes describes external research institutes POLYTECHNIC - exclusively university (i.e. RPI, Virginia Tech)

COLLEGE - need RESEARCH FOUNDATION: VAST majority are university *Exclusions: it's really difficult to cut off addresses for this to workdistinguish between university affiliated and not, besides just looking them up on the google **Novartis**Progeria**Washington Research Foundation**Blood Center of Wisconsins**Mental Hygiene**Celiac Sprue**Fidia**Samuel Waxman Cancer Center ***founded by a faculty member at Mt. Sinai Medical School,not affil w/a single university but researchers are also usually faculty at various universities**lifenet**HealthPartners**Dr. Susan Love**La Jolla Cancer Research Foundation**Children's Hospital (? grants degrees but is a hospital system)**Medforte**International Mask **Palo Alto Medical Foundation

INSTITUTE OF TECHNOLOGY ====Exclusions====*LLC*LLP ===Technology Transfer Offices=== ====Job Titles====*Patent Portfolio Manager*Intellectual Property Manager*Licensing Associate/Licensing Liaison*Biological Materials Specialist*Industrial Contracts Officer*Technology Licensing Officer*Associate Officer*Technology Licensing Associates*Patent Coordinator/Patent Administrator*IP Portfolio Specialist*MTA Coordinator*Sponsored Research Administrator*Technology Transfer Specialist/Technology Transfer Associate*Contracts Associate*Portfolio Director*Contracts Specialist*Industry Contracts Analyst*Patent Prosecution Analyst*(Associate) Director of Intellectual Property*(Associate) Director of Technology Transfer Policy*(Associate) Director of Technology Transactions*(Associate) Director of Agreement Administration*Senior Associate - almost exclusively describes universities but sometimes describes external research instituteswatch*Patent Attorney/Patent Agent/Patent Counsel/Paralegal - watch ====TTO Names====*Office of Technology Transfer/Technology Transfer Office*Office of Technology Licensing/Technology Licensing Office*Office of Technology Development*Technology Ventures*Innovation Services*Intellectual Property & Industry Research Alliances*InnovationAccess*Invention Transfer Group*Technology Development Group*Office of Business Development*Office of Technology Commercialization*Office of Innovation and Commercialization*Innovation, Technology & Alliances*Technology & Industry Alliances*Office for Management of Intellectual Property*Innovation & Partnerships Office

How do we feel about affiliated, non===University-degree granting research institutes?Affiliated Startups (Patent Assignees)===

1. lit review *Create ranking**Based on patent portfolio**Licensing income**Quality of TTO **Publications (look at specifically based on research)?**Amount received in grants/Amount of grants - we have numbers on amount of NIH grants and NSF grants***NIH/NSF/STTR**Control for 1-2 daysschool size/endowment**Startups affiliated with university***Value generated from these startups? (ask Avesh), look for holistic picture, **Existence of entrepreneurship program**Geography *Describe average patent portfolio of university**Number of patents**Maybe categorize by research area?*Describe how universities license**USPTO earned revenue Deliverable*Ranking*Explanation of what hasmakes a good ranking/hasn’t been done? what are the questions people are askingfactors a school needs to be more successful Artifacts*Grant Data*Research Funding*Star Scientists*Regression with variables from Carnegie Classification (10-15 variables)*Licensing (?)

2===What We Have=== *Lit Review*List of all post-secondary institutions (University Accreditation 3.2016_trim) - U.S. look at patent Department of Education*Classification of universities (Carnegie Classification 2015) - Carnegie Classification** includes all accredited degree-granting colleges and universities that are included in the National Center for Education Statistics Integrated Postsecondary Education Data System (IPEDS).** Coverage: 4666 institutions of higher learning** Variables: includes 94 variables*** Enrollment data- subdivided into graduate and undergraduate*** degrees conferred - divided into level and division*** information on faculty (number, determine how to find universities divided into levels i.e. assistant, assoc. and full time)**** coverage for this variable is REALLY LOW*** non-faculty research staff (includes post docs)*** Science and Engineering Research and Development expenditures*** Non-STEM research and Development expenditures*Amount spent on R&D (Higher Ed R&D Rankings) - National Science Foundation** includes just total R&D expenditures*STTR full data 1995-2015 (STTRData) - Small Business Administration*University Patent Numbers 1969-2012 - USPTO*Patents that resulted from NIH grants*Information about NSF grants ===What We Need=== *List of university-affiliated startups**looks like AUTM STATT data has this because it was used in patent databasea study by Yael Hochberg [https://papers.ssrn.com/sol3/papers2.cfm?abstract_id=2418000]**[https: board //www.forbes.com/sites/liyanchen/2015/07/29/americas-most-entrepreneurial-research-universities-2015/#3cb9829b3823| Rankings of regents, Research Universities (2015)]**FORBES ranked the country’s most entrepreneurial schools based on the numbers of alumni and students who have identified themselves as founders and business owners on LinkedIn (adjusted to total student body size). This year we rank both research universities in patent and [https://www.forbes.com/sites/liyanchen/2015/07/29/americas-most-entrepreneurial-colleges-2015/#2b2909e04604| smaller colleges] separately.*data about TTOs (find patterns associated # and quality of employees)**LinkedIn crawler: working with university Jeemin and Peter*licensing data from AUTM [http://www.autm.net/statt] or already within the patent data? ==Name Matching==*Jeemin has found all the correct and incorrect spellings of assignees)with "University"*Julia working on "Institute"*We have a list of Universities that have patents from NIH grants, which could be a starting point for our ranking constituents

* Shanghai Jia Jiao Tong University's Academic Ranking of World Universities (ARWU)