460
edits
Changes
Jump to navigation
Jump to search
no edit summary
|Primary Billing= AccMcNair01
}}
=Updated=
'''New Requirements'''
#re-run the match using *both* name-related fields in the startups_cl.dta file: “name” and “name_prev”.
note: the latter field pulls in patents applied for under a former name of the same company
#in the output file, please include…
*include the field “entityid” that corresponds to each startup (this step is critical; else, we can’t link patents filed under alternative names of the company to the same firm); in startups_cl.dta
*all assignee-related fields in your patent data (e.g., assignee name, and any original and current uspto assignee codes listed for the patent); merge in from your patent files
'''Output'''
<code>E:\McNair\Projects\Venture One Data\</code>
#summarytablefinal: summary on number of patents and grant year for all companies
#ullyjoinedtable: all patent and assignee information for entities that have patents (combining 3 and 4)
#fullyjoinednow: patent information under current name of the company
#fullyjoinedprec: patent information under previous name of the company
'''notes'''
In summarytablefinal table: (for all entities)
Variables:
Entity Name|Standard Orgname|Number of patent|
Previous Name|Previous Standard Orgname|Previous Number of Patent|
Total number of Patent|
Orinigal ID | Revised ID|
min grant year|max grant year|avg grant year|
***One company have the exactly same name for entity name and previous name(Z-KAT) and there is double counting of patent. So the total number of patent
should be 11 instead of 22.
In fullyjoinedtable: (for entities that have patent)
Including all patent and assignee variables
33 variables in total
variables start with 'asg' are assignee information, e.g. asgtype = assignee type
The rest are patent information.
=Old=
==Overview==
In this matching process, we will join patent data to VentureOne companies and count the number of patents that affiliated to each company.
