1,181
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 14:58, 2 May 2017
, 14:58, 2 May 2017→US Patent Assignee Table
===US ONLY Patent Assignee Table===
Note: Table made for Julia by [[Marcela Interiano]]
FROM ptoproperty_patent M1, ptotracking2 M2
WHERE (M1.reelno = M2.reelno) AND (M1.frameno = M2.frameno) AND (M1.patentno = M2.documentid);
Next, the minimum update date was taken, dropping any repetitions or later dates for the same patent assignee.
DROP TABLE ptoproperty_patent_minupdate;
CREATE TABLE ptoproperty_patent_minupdate AS
SELECT reelno, frameno, patentno, min(last_update_date) FROM ptoproperty_patent_update GROUP BY reelno, frameno, patentno, last_update_date;
The US only assignee table was used to construct the final table.
DROP TABLE ptoassignee_us_patent;
SELECT M1.reelno, M1.frameno, M2.name, M1.patentno, M1.last_update_date
FROM ptoproperty_patent_minupdate M1, ptoassigneend_us_cleaned M2
WHERE (M1.reelno = M2.reelno) AND (M1.frameno = M2.frameno);
==Restructure Address Information (First Stage)==
