377
edits
Changes
Jump to navigation
Jump to search
* grantyear (int) year the patent was granted* appdate (date) date that the application was filed, including year* appyear ipcrsubclass (intvarchar(255) year that the application was filed) International patent classification subclass* nber ipcrmaingroup (varchar(255)) International patent classification according to the National Bureau of Economic Research main group* ipcrsubgroup (varchar(NBER255) Patent Citations Data File) International patent classification subgroup* uspc national_classification (varchar(255)) - probably uspc, which is United States patent classificationPatent Classification* uspc_sub natioanl_classification_country (varchar(255)) - should be United States Discrepancies: These fields were previously a a part of the table, but we do not currently have xpaths for them:app_year - the year the application was filedgrant_year - the year the patent classification was granteduspc - United States Patent Classification (might be the same as national_classification)uspcsub - United States Patent subgroup
Redesign Assignment and Patent Database (view source)
Revision as of 16:42, 26 October 2017
, 16:42, 26 October 2017→Patent Database Structure
The foreign key that connects every table is patent_number, which uniquely identifies every patent in the PATENT table and is included in every table.
Full list of tables: patent, assignee, citation, fee, claims, histpatent, lawyers, inventors Update: These tables, as of October 26, are being updated and changed as I determine what data can actually be retrieved from the XML files based on the xpaths that we have determined (you can see these xpaths on the "Equivalent XPath and APS Queries" project page.
===PATENT===
All columns (variables):
* patent_number (varchar(255)) unique identifier for the patent from the UPSTO office, can contain letters hence varchar
* patent_type (varchar(255)) the type of patent, like utility* patent_kind (varchar(2)) the kind of patent, a letter and a number* title (varchar(255)) the title of the patent* grantdate (date) date that patent was officially grantedincluding the year
* prioritydate (date) date used to established novelty of an invention in regards to other inventions (source: http://www.bios.net/daisy/patentlens/2343.html)
* prioritycountry (varchar(255)) country where patent is first filed
* patent_country (varchar(255)) country in which this patent was published
* prioritypatentnumber (varchar(255)) placeholder patent number if the patent is published before it is fully approved
* cpcsubclass (varchar(255)) cooperative patent classification subclass
* cpcsubgroup (varchar(255)) cooperative patent classification subgroup
* cpcmaingroup (varchar(255)) cooperative patent classification main group
* cpctotal (varchar(255)) concatenated version of cpcmaingroup, cpcsubgroup, cpcsubclass
* pctpatentnumber (varchar(255)) international patent number (according to Patent Cooperation Treaty)
* appnum(varchar(255)) application number
===ASSIGNEE===
