329
edits
Changes
Jump to navigation
Jump to search
no edit summary
# <del>Create new data structures</del> ''done''
# <del>Database Insert (modify <code>models/</code> files with some mapping to database fields)</del> ''done''
# <del>Create tooling for minions</del> ''skipped''
# Create XPath queries for reissue, design patents (only utility right now)
# Data Cleanup (reference [[Patent_Assignment_Data_Restructure|Marcela and Sonia's work]])
== Schema Reconciliation ==
As it turns out, since many of the fields we care about are date and author data the schemas are the same ("universal")
<code>
select count(*), patent_type from patents group by patent_type;
725;"design"
18;"plant"
14;"reissue"
28187;"utility"
</code>
where "plant" literally refers to flora.
{| class="wikitable"
|style="background: green; color: white;" | Yes
|✓
|✗✓|✗✓
|-
|October 8, 2013 to December 2014
|style="background: green; color: white;" | Yes
|✓
|✗✓|✗✓
|-
|January 2015 to December 2016
|style="background: green; color: white;" | Yes
|✓
|✗✓|✗✓
|}
