329
edits
Changes
Jump to navigation
Jump to search
no edit summary
This project is composed of SQL queries against <code>patents.ptoassigneend_allus</code> to gain confidence in the data. The scripts and rationale behind the design decisions in this table are described in its wiki page [[Patent_Assignment_Data_Restructure#Restructure_Address_Information_.28First_Stage.29|here]] and all original work was done by Sonia Zhang.
== Total Row Counts ==
{| class="wikitable"
|+Number of Rows
|-
! scope="col" | Table Name !! scope="col" | count(*) !! scope="col" | Description
|-
| ptoassigneend
| 7234001
| Base data with duplicates removed
|-
| ptoassigneend_allus
| 3572605
| Sonia's subset of only US addresses; 49.4% of ptoassigneend
|-
| 3572605
| ptoassigneend_us_cleaned
| "cleaned postcode, city, and state" of ptoassigneend_allus; '''this is the one we want to work with'''
|-
| 5343
| ptoassigneend_us_extracted
| cleaned up complete addresses; too small to be worthwhile
|}
== Table Origin ==
