353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 17:26, 4 April 2017
, 17:26, 4 April 2017→Master Table
c. Postcode is the priority
=====Postcode=====
Reminder: postcode_city is the postcode extracted from 'city'; postcode_addr1 is the postcode extracted from 'addrline1'; postcode_addr2 is the postcode extracted from 'addrline2'.
city | state | postcode_city | postcode
HAUPPAUGE, 11788-8847 | NEW YORK | 11788-8847 | 78759
Postcodes extracted from addrline1, addrline2 and city are stored in ptoassigneend_postcode.
All the cleaned postcodes for U.S. patents are stored in ptoassigneend_us_postcodecleaned.
====Issues====
