353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 16:11, 5 April 2017
, 16:11, 5 April 2017→Master Table
All the cleaned postcodes for U.S. patents are stored in ptoassigneend_us_postcodecleaned. (# 3572460)
=====State=====
Reminder: state_city is the states extracted from 'city'; state_addr1 is the states extracted from 'addrline1'; state_addr2 is the states extracted from 'addrline2'.
The state_city, state_addr1 and state_addr2 are consistent.
Examples:
state_addr2 | state_city
ILLINOIS | ILLINOIS
IL | IL
IL | IL
CT | CT
MN | MN
CA | CA
====Issues====
