353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 16:21, 17 April 2017
, 16:21, 17 April 2017→Output (Tables)
city_city | text |
*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_city is the city name extracted from 'city'; *city_addr1 is the city name extracted from 'addrline1'; *city_addr2 is the city name extracted from 'addrline2'.
SQL code is in:
