7,612
edits
Changes
Jump to navigation
Jump to search
[[Category:Internal]]{{Project|Has project output=|Has sponsor=McNair Center|Has title=Patent Data Processing - SQL Steps|Has owner=Shelby Bice,|Has project status=Subsume|Has keywords=Tool}}Return to [[Internal Classification::Legacy| Patent Data (Wiki Page)]].
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 13:34, 21 September 2020
, 13:34, 21 September 2020no edit summary
== Objective ==
== USPTO Consolidated Patent Data ==
/* creating patent data tables from : https://bulkdata.uspto.gov/data2/patent/maintenancefee/*/
--COPY 11191813
[[Category:Internal]]
[[Internal Classification::Legacy| ]]
[[Category:Patent]]
