1,181
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 16:14, 2 May 2017
, 16:14, 2 May 2017→US ONLY Patent Assignee Table
FROM ptoproperty_patent_minupdate M1, ptoassigneend_us_cleaned M2
WHERE (M1.reelno = M2.reelno) AND (M1.frameno = M2.frameno);
The table below was made to join through using Sonia's zip codes for the ptoassignee data to get patent numbers from reelno and frameno.
DROP TABLE ptoassignee_us_distinct;
CREATE TABLE ptoassignee_us_distinct AS
SELECT DISTINCT reelno, frameno, patentno
FROM ptoassignee_us_patent
GROUP BY reelno, frameno, patentno;
--5391413
==Restructure Address Information (First Stage)==
