7,613
edits
Changes
Jump to navigation
Jump to search
Matching VentureOne (Data) (view source)
Revision as of 13:34, 21 September 2020
, 13:34, 21 September 2020no edit summary
{{McNair ProjectsProject|Has project output=|Project TitleHas title=Matching VentureOne (Data)|Topic Area=Patents and Innovation|OwnerHas owner=Ariel Sun, Rosemarie Ziedonis|Start TermHas start date=Summer 2016|StatusDue Date=NA|Has sponsor=McNair Center|Has notes=|Is dependent on=Active|DeliverableDepends upon it=Other|Primary BillingHas project status= AccMcNair01Complete
}}
=Updated=
'''Output'''
Text files are in:<code>E:\McNair\Projects\Venture One Data\</code>
#<code>summarytablefinal</code>: summary on number of patents and grant year for all companies
#<code>ullyjoinedtable</code>: all patent and assignee information for entities that have patents (combining 3 and 4)
#<code>fullyjoinednow</code>: patent information under current name of the company
#<code>fullyjoinedprev</code>: patent information under previous name of the company
A new version of sql script can be cound at :<code>E:\McNair\Projects\Venture One Data\sql script.txt</code>
'''notes'''
<includeonly>
[[Category: McNair Projects]]
</includeonly><!-- flush flush --><!-- flush flush --><!-- flush flush --><!-- flush -->
