353
edits
Changes
Jump to navigation
Jump to search
ptoassigneend_us_identify5 ptoassigneend_us_candid1 is a subset of ptoassigneend_us_temp5. It doesn't contain clean passcode postcode info, but contains clean city and state info. 6.7% data left in ptoassigneend_us_temp6. ptoassigneend_us_candid2 is also a subset of ptoassigneend_us_temp5. It contains clean postcode info. 5.0% data left in ptoassigneend_us_temp7.
Patent Assignment Data Restructure (view source)
Revision as of 16:02, 3 May 2017
, 16:02, 3 May 2017→Summary
ptoassigneend_us_identify4 | 38
ptoassigneend_us_temp5 | 376797
ptoassigneend_us_identify_subtotal | 3195769
---------------------------|-------------
ptoassigneend_us_candid1 (city and state is clean) | 136958 ptoassigneend_us_temp6 ptoassigneend_us_candid2 (postcode is clean) | 239837184123
Union ptoassigneend_us_identify(0-4) to get ptoassigneend_us_identify_subtotal (3195769). 10.5% left in ptoassigneend_us_temp5.
Note:
About 60 records are missing. For example, the # of records in ptoassigneend_us_temp + # of records in ptoassigneend_us_identify0 != # ptoassigneend_allus.
