377
edits
Changes
Jump to navigation
Jump to search
Redesigning Patent Database (view source)
Revision as of 14:04, 27 April 2017
, 14:04, 27 April 2017→For the USPTO Maintenance Fee Data
Download the file manually from https://bulkdata.uspto.gov/data2/patent/maintenancefee/and replace existing file in McNair/Patent Data/Maintenance Fee Data.
Schema for maintenance fee table, called according to documentation:
Column | Type | Modifiers
---------+-------------------+-----------
patent | character varying |
appnum | integer |
size | character varying |
filedate | date |
gdate | date |
feedate | date |
feecode | character varying |
Seems to contain instructions for making maintenance fee and fee code tables in table - but how do we parse the original data?
http://mcnair.bakerinstitute.org/wiki/Patent_Expiration_Rules
Based off opening the text file mentioned in the instructions in the above link and the new text file I downloaded from USPTO bulk, that text file is already in the correct format to load into the database using the code in Patent Expiration Rules.
Seems like it was cleaned first though, and there doesn't seem to be a way (currently) to specify where we want to start loading new data into the database.
===For the USPTO Historical Patent Data===
