154
edits
Changes
Jump to navigation
Jump to search
ScriptsThe USPTO has a repository of patent data on their Bulk Data Storage system. We have this data downloaded and loaded into a table on the patent database. Here are the steps followed:* Download file from the BDS system - we have access to CSV files.* Create table with required specs* use the \COPY command to copy the data from the file into the table. Script follows. '''Script:'''
Patent Data Processing - SQL Steps (view source)
Revision as of 12:51, 6 July 2016
, 12:51, 6 July 2016→USPTO Consolidated Patent Data
== USPTO Consolidated Patent Data ==
/* creating patent data tables from : https://bulkdata.uspto.gov/data2/patent/maintenancefee/*/
