353
edits
Changes
Jump to navigation
Jump to search
:::The ptoassigneend_allus table may miss some U.S. patents.
Patent Assignment Data Restructure (view source)
Revision as of 17:22, 27 March 2017
, 17:22, 27 March 2017→Restructure Address Information
:::This table contains all the U.S. patents extracted from ptoassigneend table. The rule to generate this table is 'country = 'UNITED STATES' ' or any of the features contains U.S. postcode.
:::Noise existsbecause of postcode errors. :::The ptoassigneend_allus table may miss some U.S. patents which lose postcode records.
:::The SQL code is:
country | character varying(500) |
postcode | character varying(80) |
::*ptoassigneend_missus_final
