1,181
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 16:16, 2 May 2017
, 16:16, 2 May 2017→US ONLY Patent Assignee Table
GROUP BY reelno, frameno, patentno;
--5391413
The total number of distinct patent numbers in the ptoassignee data for only US assignees is 2345763.
SELECT COUNT(*) FROM (SELECT DISTINCT patentno FROM ptoassignee_us_patent) AS P;
--2345763
==Restructure Address Information (First Stage)==
