353
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 14:45, 2 May 2017
, 14:45, 2 May 2017→Summary
Union ptoassigneend_us_identify(0-4) to get ptoassigneend_us_identify_subtotal (3195769). 10.5% left in ptoassigneend_us_temp5.
ptoassigneend_us_identify5 doesn't contain clean passcode info, but has contains clean city and state info. 6.7% data left in ptoassigneend_us_temp6.
Note:
The # of records in ptoassigneend_us_temp + # of records in ptoassigneend_us_identify0 != ptoassigneend_allus.
