353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 15:48, 17 April 2017
, 15:48, 17 April 2017→Restructure Address Information
Table "public.ptoassigneend_allus"
Column | Type | Modifiers
----------| -----------------------|-----------
reelno | integer |
frameno | integer |
For example,
city | postcode_extracted
--------------------------------------|-------------------
NEW YORK, NY 10022-3201 | 10022-3201
BEAVERTON, OREGON 97005-6453 | 97005-6453
Examples:
city | state_city
--------------------------------------|-----------
NEW YORK, NY 10022-3201 | NY
BEAVERTON, OREGON 97005-6453 | OREGON
Table "public.ptoassigneend_us_extracted"
Column | Type | Modifiers
---------------|------------------------|-----------
reelno | integer |
frameno | integer |
Examples:
postcode_addr1 | postcode_addr2
---------------|---------------
90401-1708 | 90401-1708
37831-8243 | 37831-8243
addrline1 | postcode_addr1 | postcode
-----------------------------------------------------------------------------------------------------------------------------------------------------------|----------------|-----------
P.O. BOX 6 / 83707-0006 | 83707-0006 | 83716
BLDG. C01, M.S. A126 P.O. BOX 80028 LOS ANGELES, CA 90080-0028 | 90080-0028 | 90045
Example:
addrline2 | postcode_addr2 | postcode
------------------------------------------------------------------------------------------------------|----------------|----------
P.O. BOX 6 / 83707-0006 | 83707-0006 | 83716-9632
P.O. BOX 5800 - MS0161, ALBUQUERQUE, NEW MEXICO 87185-0161 | 87185-0161 | 87123-0161
city | state | postcode_city | postcode
----------------------|----------|---------------|----------
HAUPPAUGE, 11788-8847 | NEW YORK | 11788-8847 | 78759
Examples:
state_addr2 | state_city
------------|-----------
ILLINOIS | ILLINOIS
IL | IL
Examples:
city_addr2 | city_city -------------|--------------
BOISE | BOISE
THOMASVILLE | THOMASVILLE
Table "public.ptoassigneend_us_cleaned"
Column | Type | Modifiers
--------------------|------------------------|-----------
reelno | integer |
frameno | integer |
