Difference between revisions of "Reproducible Patent Data"
| Line 14: | Line 14: | ||
# <del>Splitter</del> ''done'' | # <del>Splitter</del> ''done'' | ||
# <del>Parser</del> ''done'' | # <del>Parser</del> ''done'' | ||
| − | # Data Source Merger | + | # Data Source Merger (''only USPTO'' not Harvard Dataverse or Lex Machina) |
# Database Insert (modify <code>models/</code> files with some mapping to database fields) | # Database Insert (modify <code>models/</code> files with some mapping to database fields) | ||
# Data Cleanup (reference [[Patent_Assignment_Data_Restructure|Marcela and Sonia's work]]) | # Data Cleanup (reference [[Patent_Assignment_Data_Restructure|Marcela and Sonia's work]]) | ||
Revision as of 20:05, 30 May 2017
| Reproducible Patent Data | |
|---|---|
| Project Information | |
| Project Title | Reproducible Patent Data |
| Owner | Oliver Chang |
| Start Date | May 17 |
| Deadline | |
| Primary Billing | |
| Notes | |
| Has project status | Active |
| Subsumes: | Redesigning Patent Database, Patent Assignment Data Restructure |
| Copyright © 2016 edegan.com. All Rights Reserved. | |
A continuation of Redesigning Patent Database that aims to write faster, more centralized code to deal with the USPTO data. By having an end-to-end pipeline we can easily reproduce or update data without worrying about unintentional side effects or missing data.
Contents
Progress
DownloaderdoneSplitterdoneParserdone- Data Source Merger (only USPTO not Harvard Dataverse or Lex Machina)
- Database Insert (modify
models/files with some mapping to database fields) - Data Cleanup (reference Marcela and Sonia's work)
Directory Layout
All of the information for this project is located at E:\McNair\Projects\SimplerPatentData
There are three interesting directories:
data/downloads/is USPTO bulkdata, unmodified straight from the scraperdata/extracts/is a directory of a strict subset of the information stored indata/downloads/. It is the result of running a bulk 7-zip job on that directory to get everything unzipped in a flat data structure. Note that these files have the USPTO modified-by time since that metadata is stored in the zipfiles. To extract files in this nice format, select all of the zipfiles and setup an extraction job like in this screenshotdata/backups/is a 7zip'd backup of the corresponding directory in extractssrc/is the main code repository for the java project
Input Files
All of the text-only Red Book files for granted patents from 1976 to 2016, inclusive. To find a specific year's XML file, find it in
E:\McNair\Projects\SimplerPatentData\data\extracts\granted\
To find assignment data, look in
E:\McNair\Projects\SimplerPatentData\data\extracts\granted\
To find maintenance fee data, look in
E:\McNair\Projects\SimplerPatentData\data\downloads\maintenance
Schema Reconciliation
| Dates Used | Format | Supported by Parser? |
|---|---|---|
| January 1976 to December 2001 | APS | Yes (syntactic parsing but little semantic knowledge) |
| January 2002 to December 2004 | XML Version 2.5 | No |
| January 2005 to December 2005 | XML Version 4.0 ICE | Maybe |
| January 2006 to December 2006 | XML Version 4.1 ICE | Maybe |
| January 2007 to December 2012 | XML Version 4.2 ICE | Maybe |
| January 2013 to September 24, 2013 | XML Version 4.3 ICE | Yes |
| October 8, 2013 to December 2014 | XML Version 4.4 ICE | Yes |
| January 2015 to December 2016 | XML Version 4.5 ICE | Yes |
Attributes
See E:\McNair\Projects\SimplerPatentData\src\main\java\org\bakerinstitute\mcnair\models\GrantedPatent.java. In the first couple of lines there is a public enum Fields which describes what attributes are parsed out. In addition, there are 5 lists of citations, scirefs, inventors, assignees, and lawyers associated with this patent--each of which has its own parsed attributes which you can find by looking in the same directory. These attributes (except for the number of claims) are stored as strings (text) rather than numbers.
