154
edits
Changes
Jump to navigation
Jump to search
Patent Data Processing - SQL Steps (view source)
Revision as of 17:17, 23 June 2016
, 17:17, 23 June 2016→Patents
Additionally, three columns - nber, uspc, uspc_sub have been added from the historicalpatentdata, a table built from data downloaded from the USPTO Bulk Data Storage. The join was executed on the patent number.
Note : The addition, deletion of columns as through separate [Patent Data Cleanup - June 2016 scripts], therefore the scripts below will be slightly discrepant.
==== Index and Key Creation ====
