460
edits
Changes
Jump to navigation
Jump to search
→Overview
#Summary table displaying number of patents owned, minimum grant year, maximum grant year and average grant year for each company (including the ones that own no patents). It can be found at:<code>E:\McNair\Projects\Venture One Data\venturesummary.txt</code>
#A table contains all patent information for the companies that have patents and can be found at <code>E:\McNair\Projects\Venture One Data\venturefullyjoined.txt</code>
===Desired Variables===
----------------------------------------------------------------------------------------------------------------------
name: <unnamed>
log: C:\Users\ArielSun\Downloads\varlist.log
log type: text
opened on: 5 Jul 2016, 16:49:23
. describe
Contains data from C:\Users\ArielSun\Downloads\allpats_3sectors_06jun13.dta
obs: 19,409
vars: 36 11 Jun 2016 17:31
size: 10,655,541 (_dta has notes)
----------------------------------------------------------------------------------------------------------------------
storage display value
variable name type format label variable label
----------------------------------------------------------------------------------------------------------------------
id_vone double %9.0g VentureOne id
name str39 %39s startup name
patent str9 %9s patno in string
apn str6 %6s pat application number
nmi str40 %40s inventor name
ttl str244 %40s invention title
nma str65 %65s original assignee
ocd str15 %15s main us patent class
icd str15 %15s main intl patent class
apd float %td application date
gdateold float %td Grant date
fnd_year float %8.0g startup founding year
last_yr float %9.0g * OLD last_yr, 2006; see notes
source byte %8.0g 1 if 2012 delphion searches; else from 2004/5 search
pdate float %td priority date, delphion; may pre-date application date if provisional apps
utility float %9.0g * 1 if utility patent as initially awarded; 0 if other (reissued, reexamed, design
state_country str3 %9s state/country of first inventor listed
asscode float %9.0g assignee code; basic.dta
ayear int %9.0g application year
amonth byte %9.0g application month
atype str1 %9s * initial assignee type; see notes
class str3 %9s 3 digit us pat class
subclass str6 %9s patent subclass
gdate int %d grant, or issuance, date
industry str15 %15s semi, software, or med devices
state_hq str2 %9s firm hq location; vone
status06 str4 %9s * status of firm known in 2006; rhs truncation varies by sector
exitdate str8 %9s exit date, if known
exityr str4 %9s exit year, if known
status08 str6 %9s * status of firm in 2008, see notes
last_yr08 int %8.0g * exityr if ipo/acq, else 2008
dcohort float %9.0g 1 if founding yr during 1987-99
lastyr08_minu~r float %9.0g
dsearch_assign float %9.0g 1 if searches of pat assignment data need to be conducted; carlosn confirm?
carlos_chk float %9.0g carlos: pls confirm assignment data = compiled for these pats
entityid long %12.0g unique startup id as of 2008, vone
* indicated variables have notes
----------------------------------------------------------------------------------------------------------------------
Sorted by:
. log close
name: <unnamed>
log: C:\Users\ArielSun\Downloads\varlist.log
log type: text
closed on: 5 Jul 2016, 16:49:34
----------------------------------------------------------------------------------------------------------------------
==Detailed Data Processing==
