Changes

::::Feature city is quite different from addrline1 and addrline2. Some of the records just contain the city information. Some contain city, state and postcode information, only a small part of the records just contain street names.

:::The ptoassigneend_allus table may miss some U.S. patents.

:::State and postcode information are extracted from addrline1, addrline2 and city columns and are stored in ptoassigneend_missus_final table. See section 3 and 4.

:::This table is a subset of ptoassigneend_allus table.

:::postcode_city is the postcode extracted from 'city'. postcode_addr1 is the postcode extracted from 'addrline1'. postcode_addr2 is the postcode extracted from 'addrline2'.

:::state_city is the state name extracted from 'city'. state_addr1 is the state name extracted from 'addrline1'. state_addr2 is the state name extracted from 'addrline2'.

:::City information are extracted from addrline1, addrline2 and city columns and are stored in ptoassigneend_city table. See section 5.

:::This table is a subset of ptoassigneend_allus table.