329
edits
Changes
Jump to navigation
Jump to search
→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;</code> {| class="wikitable"|+Results|-! scope="col" | count(*) !! scope="col" | patent_type|- | 725;"| design"|- | 18;"| plant"|-| 14;"| reissue"|- | 28187;"| utility"</code>|}
where "plant" literally refers to flora.
