353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 14:34, 3 May 2017
, 14:34, 3 May 2017→Summary
Union ptoassigneend_us_identify(0-4) to get ptoassigneend_us_identify_subtotal (3195769). 10.5% left in ptoassigneend_us_temp5.
Table "public.ptoassigneend_us_identify_subtotal"
Column | Type | Modifiers
-----------------|------------------------|-----------
reelno | integer |
frameno | integer |
name | character varying(500) |
addrline1 | character varying(500) |
addrline2 | character varying(500) |
city_cleaned | text |
state_cleaned | text |
country | character varying(500) |
postcode_cleaned | text |
ptoassigneend_us_identify5 doesn't contain clean passcode info, but contains clean city and state info. 6.7% data left in ptoassigneend_us_temp6.
