Assignee Info Table

From edegan.com
Jump to navigation Jump to search

Table Variables

The Assignee Table is structured as shown below.

 Table "public.assignee"
   Column      |          Type          | Modifiers 
 ---------------+------------------------+-----------
 lastname      | character varying(200) | 
 firstname     | character varying(200) | 
 address       | character varying(200) | 
 postcode      | character varying(200) | 
 orgname       | character varying(500) | 
 city          | character varying(200) | 
 country       | character varying(200) | 
 patent        | character varying(200) | 
 state         | character varying(200) | 
 patentcountry | character varying(200) | 
 nationality   | character varying(200) | 
 residence     | character varying(200) | 
 asgseq        | integer                | 
 asgtype       | integer                |

The orgname (organization name) and the first and last name columns identify the patent assignee. Other than patentcountry, all other table variables apply to the organization or person. Patentcountry refers to where the patent was granted. Orgname is not standardized. Certain patents have multiple assignees, resulting in repeated patent numbers. The key in this table is composite and consists of a unique combination of last and first name, orgname, and patent number.

lastname | firstname | address | postcode |                   orgname                   |     city     | country | patent  | state | patentcountry | nationality | residence | asgseq | asgtype 
---------+-----------+---------+----------+---------------------------------------------+--------------+---------+---------+-------+---------------+-------------+-----------+--------+---------
         |           |         |          | GM Global Technology Operations LLC         | Detroit      | US      | 9295186 | MI    | US            |             |           |        |        
         |           |         |          | Transistor Devices, Inc.                    | Hackettstown | US      | 9295185 | NJ    | US            |             |           |        |        
         |           |         |          | GM GLOBAL TECHNOLOGY OPERATIONS LLC         | Detroit      | US      | 9295184 | MI    | US            |             |           |        |        
         |           |         |          | TATA CONSULTANCY SERVICES LIMITED           | Mumbai       | IN      | 9295183 |       | US            |             |           |        |        
         |           |         |          | INTERNATIONAL BUSINESS MACHINES CORPORATION | Armonk       | US      | 9295182 | NY    | US            |             |           |        |