Difference between revisions of "Assignor Table"
Jump to navigation
Jump to search
(Created page with "Return to USPTOAssigneesData. ==Table Purpose== ==Table Structure== ==Table Variables== ==Current Problems==") |
|||
| (4 intermediate revisions by one other user not shown) | |||
| Line 2: | Line 2: | ||
==Table Purpose== | ==Table Purpose== | ||
| + | <section begin="assignor" /> | ||
| + | The Assignor Table gives the assignor and location of each assignor involved in an assignment. The table gives a non-standardized inventory of companies involved in assignments as well as an indication of a company's patent portfolio over time. Additionally, the Assignor Table was used to create the Assignment and Assignor Count Tables. | ||
| + | <section end="assignor" /> | ||
==Table Structure== | ==Table Structure== | ||
| + | |||
| + | Table "public.assignor" | ||
| + | Column | Type | Modifiers | ||
| + | ---------+------------------------+----------- | ||
| + | reel | integer | | ||
| + | frame | integer | | ||
| + | recdate | date | | ||
| + | assignor | character varying(500) | | ||
| + | execdate | date | | ||
| + | |||
| + | Example of table entries: | ||
| + | |||
| + | reel | frame | recdate | assignor | execdate | ||
| + | ------+-------+------------+--------------------------------+------------ | ||
| + | 39090 | 676 | 2016-07-07 | BIRKIGT, ANDREAS | 2014-01-10 | ||
| + | 39090 | 676 | 2016-07-07 | STOLLE, MARTIN | 2014-01-10 | ||
| + | 39090 | 664 | 2016-07-07 | GRIMBERG, ERNEST | 2015-09-09 | ||
| + | 39090 | 667 | 2016-07-07 | TANN, EVAN | 2015-07-21 | ||
| + | 39090 | 676 | 2016-07-07 | HENTSCHEL, LARS | 2014-01-10 | ||
| + | 39090 | 676 | 2016-07-07 | SONDER, CLAUDIO-SEBASTIAN | 2014-01-10 | ||
| + | 39090 | 591 | 2016-07-07 | OMNIGENE BIOPRODUCTS, INC. | 2016-07-06 | ||
| + | 39090 | 664 | 2016-07-07 | ABURMAD, SHIMON | 2015-09-03 | ||
| + | 39090 | 740 | 2016-07-07 | HITACHI, LTD. | 2016-03-29 | ||
| + | 39090 | 698 | 2016-07-07 | PARTICLE CONSENSUS HOLDING LTD | 2016-06-10 | ||
==Table Variables== | ==Table Variables== | ||
| + | Reel and frame give the location on the microfilm files where the particular transaction is recorded. The reel number and frame number are unique to a transaction between the assignee and assignor. The recdate is the date the assignment was recorded by the USPTO. Assignor gives the name of the assignor in the transaction. The execdate is when the legal motions were executed for the transaction. [http://www.uspto.gov/sites/default/files/products/assign-documentation.pdf] | ||
| + | ==Current Problems== | ||
| − | + | [[Category: Internal]] | |
| + | [[Internal Classification: Legacy| ]] | ||
Latest revision as of 16:18, 2 September 2016
Return to USPTOAssigneesData.
Table Purpose
The Assignor Table gives the assignor and location of each assignor involved in an assignment. The table gives a non-standardized inventory of companies involved in assignments as well as an indication of a company's patent portfolio over time. Additionally, the Assignor Table was used to create the Assignment and Assignor Count Tables.
Table Structure
Table "public.assignor" Column | Type | Modifiers ---------+------------------------+----------- reel | integer | frame | integer | recdate | date | assignor | character varying(500) | execdate | date |
Example of table entries:
reel | frame | recdate | assignor | execdate ------+-------+------------+--------------------------------+------------ 39090 | 676 | 2016-07-07 | BIRKIGT, ANDREAS | 2014-01-10 39090 | 676 | 2016-07-07 | STOLLE, MARTIN | 2014-01-10 39090 | 664 | 2016-07-07 | GRIMBERG, ERNEST | 2015-09-09 39090 | 667 | 2016-07-07 | TANN, EVAN | 2015-07-21 39090 | 676 | 2016-07-07 | HENTSCHEL, LARS | 2014-01-10 39090 | 676 | 2016-07-07 | SONDER, CLAUDIO-SEBASTIAN | 2014-01-10 39090 | 591 | 2016-07-07 | OMNIGENE BIOPRODUCTS, INC. | 2016-07-06 39090 | 664 | 2016-07-07 | ABURMAD, SHIMON | 2015-09-03 39090 | 740 | 2016-07-07 | HITACHI, LTD. | 2016-03-29 39090 | 698 | 2016-07-07 | PARTICLE CONSENSUS HOLDING LTD | 2016-06-10
Table Variables
Reel and frame give the location on the microfilm files where the particular transaction is recorded. The reel number and frame number are unique to a transaction between the assignee and assignor. The recdate is the date the assignment was recorded by the USPTO. Assignor gives the name of the assignor in the transaction. The execdate is when the legal motions were executed for the transaction. [1]
