Changes

Jump to navigation Jump to search
::*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.)'''

Navigation menu