353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 15:39, 22 March 2017
, 15:39, 22 March 2017→Restructure Address Information
::*ptoassigneend_allus
:::This table contains all the U.S. patents extracted from ptoassigneend table. The rule to extract this table is either by 'country = 'UNITED STATES'' or postcode ~* '\d{5}-\d{4}'.
:::The SQL code is:
