Changes

==This project is concerned with maintaining and updating patent data, to enable the McNair Center staff to extract meaningful data for academic papers and reports. Currently, there are two primary sources for this data - the US Patent and Trademark Office as well as the Harvard Dataverse. Data Background==from the LexMachina online database has been added to provide information on [[Guide to Patent Litigation (Wiki Page) | patent litigation]]. All the acquired data is stored in normalized tables to be accessed and modified using SQL. The patent data has been separated into multiple databases based on data source or subject matter. Each database consists of several tables for which the known issues have been recorded.

This project is concerned with maintaining and updating patent data, to enable ==Data Sources==The [[Patent|Patent Database]] contains the merged datasets from the McNair Center staff to extract meaningful data for academic papers and reports. Currently, there are two primary sources for this USPTO bulk data - the US Patent and Trademark Office as well as the Harvard Dataverseusing SQL. Data from Specifics on how the LexMachina online database may be added to have data on datasets were merged are given in [[Guide to Patent Litigation (Wiki Page) | patent litigationData Processing - SQL Steps]]. All the acquired data is stored in normalized tables to be accessed and modified using SQL.

The patent data has been separated into multiple databases based on data source or subject matter. Each database consists of several tables for which the known issues have been recorded. The [[Patent|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 Processing - SQL Steps]]. ==The Patent Database focuses on patents, patent litigation, patent maintenance, patent assignment, and other details on patent owners. The [[USPTOAssigneesData|USPTO Assignees Database (version 2)]] focuses on patent assignments, a transaction between one or more patent owners with one or more parties where ownership or interest in one or more patents is assigned or shared. The database consists of historical assignment data provided by the USPTO in XML files. Specifics on how the database are given on the [[USPTO Assignees Data Processing]] Page.