Changes

Return to [[Category: Internal]]The Patent Database contains the merged datasets from the USPTO bulk data and Harvard Dataverse using SQL. Specifics on how the datasets were merged are given in [[Patent Data SpecificationsProcessing - SQL Steps]]. The Patent Database focuses on patents, patent litigation, patent maintenance, patent assignment, and other details on patent owners.

===Tables===[[Assignee Table | assignee]]: {{#section:Assignee_Table|assignee}}[[Citation Table | citation]]: {{#section:Citation_Table|citation}}[[Fee Table | fee]]: {{#section:Fee_Table|fee}}[[Fee Status Table | feestatus]]:{{#section:Fee_Status_Table|feestatus}}[[HistPatent Table | histpatent]]:{{#section:HistPatent_Table|hist}} [[LexJudge Table | lexjudge]]:{{#section:LexJudge_Table|judge}}[[Match Orgname Table | matchorgname]]:{{#section:Match_Orgname_Table|orgname}}

===[[Assignee Info Table | assigneeinfo]]==={{#section:Assignee_Info_Table|assignee}}===[[Citation Table | citation]]==={{#section:Citation_Table|citation}}===[[Fee Table | fee]]==={{#section:Fee_Table|fee}}===[[Fee Status Table | feestatus]]==={{#section:Fee_Status_Table|feestatus}}===[[HistPatent Table | histpatent]]==={{#section:HistPatent_Table|hist}} ===[[LexJudge Table | lexjudge]]==={{#section:LexJudge_Table|judge}}===[[Match Orgname Table | matchorgname]]==={{#section:Match_Orgname_Table|orgname}}===[[MSA List Table | msalist]]=== ===[[MSA Wage Table | msawage]]=== ===[[Patent Table | patent]]:==={{#section:Patent_Table|patent}}===[[PTO Tables]]=== ===[[Stdorgname Table|stdorgname]]:==={{#section:Stdorgname_Table|std}}