353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 16:47, 22 March 2017
, 16:47, 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 'country = 'UNITED STATES' ' or any of the features contains U.S. postcode ~* '\d{5}-\d{4}'.
:::The SQL code is:
