7,627
edits
Changes
Jump to navigation
Jump to search
The Effect of Leverage Buyouts on Innovation (view source)
Revision as of 17:42, 25 June 2019
, 17:42, 25 June 2019→Analyzing DataExtension.sql
*(patentgrantbuy,patentsale,patentexpired)-> patenthistorybase (1513045)
*patenthistorybase ...,GvkeyYear -> gvkeyyearpatentdata (395213)
Note that Patentsassigneessimple is not in '''allpatentsprocessed''' but assignee is, and it can easy be rebuilt:
SELECT COUNT(*) FROM assignees WHERE orgname IS NOT NULL AND patentnumber IS NOT NULL;
--5426556
And patenthistwoprebuys is a solid master table:
Table "public.patenthistwoprebuys"
Column | Type | Collation | Nullable | Default
--------------+------------------+-----------+----------+---------
gvkey | text | | |
patentnumber | integer | | |
startdate | date | | |
startyear | double precision | | |
grants | integer | | |
buy | integer | | |
enddate | date | | |
endyear | double precision | | |
sell | integer | | |
term | integer | | |
notrenewed | integer | | |
unknownexp | integer | | |
Therefore needed inputs to DataExtension.sql are:
