353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 16:44, 22 March 2017
, 16:44, 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:
:::The ptoassigneend_allus table may miss some U.S. patents.
::*ptoassigneend_missus_final
:::State and postcode information are extracted from addrline1, addrline2 and city columns and are stored in ptoassigneend_missus_final table.
:::This table is a subset of ptoassigneend_allus table.
:::The postcode extracted from addrline1 and addrline2 may be different. Need further cleaning.
::*ptoassigneend_city
:::City information are extracted from addrline1, addrline2 and city columns and are stored in ptoassigneend_city table.
:::This table is a subset of ptoassigneend_allus table.
:'''2. Postcode(U.S.)'''
