Conveyance Table

From edegan.com
Jump to navigation Jump to search

Return to USPTOAssigneesData.

Table Purpose

Table Structure

                 Table "public.conveyance"
    Column      |          Type          | Modifiers 
----------------+------------------------+-----------
reel            | integer                | 
frame           | integer                | 
recdate         | date                   | 
lastupdatedate  | date                   | 
purge_indicator | character varying(500) | 
corrname        | character varying(500) | 
addr1           | character varying(500) | 
addr2           | character varying(500) | 
addr3           | character varying(500) | 
addr4           | character varying(500) | 
conveyancetext  | character varying(500) | 

Example of table entries:

reel | frame |  recdate   | lastupdatedate | purge_indicator |             corrname             
-----+-------+------------+----------------+-----------------+----------------------------------
5534 |   714 | 1990-11-26 | 1993-12-06     | N               | BRUCE E. BURDICK
5534 |   718 | 1990-11-26 | 2002-01-18     | N               | BRUCE E. BURDICK
5534 |   725 | 1990-11-28 | 2008-08-01     | N               | SHERMAN & SHALLOWAY
5534 |   727 | 1990-11-28 | 2008-08-01     | N               | SEED AND BERRY
5534 |   730 | 1990-11-28 | 2008-08-01     | N               | SCHROEDER, DAVIS & ORLISS, INC.
5534 |   735 | 1990-11-28 | 2008-08-01     | N               | FLOYD A. GONZALEZ
5534 |   737 | 1990-11-28 | 2008-08-01     | N               | HAROLD W. MILTON, JR.
5534 |   739 | 1990-11-28 | 2008-08-01     | N               | ROBERT O. WRIGHT
5534 |   744 | 1990-11-28 | 2008-08-01     | N               | BANNER, BIRCH, MCKIE AND BECKETT
5534 |   747 | 1990-11-28 | 2008-08-01     | N               | DAN HUBERT
           addr1             |            addr2             |            addr3             |            addr4             |          conveyancetext           
-----------------------------+------------------------------+------------------------------+------------------------------+-----------------------------------
OLIN CORPORATION             | OLIN CORPORATION             | OLIN CORPORATION             | OLIN CORPORATION             | ASSIGNMENT OF ASSIGNORS INTEREST.
OLIN CORPORATION             | OLIN CORPORATION             | OLIN CORPORATION             | OLIN CORPORATION             | ASSIGNMENT OF ASSIGNORS INTEREST.
413 NORTH WASHINGTON STREET  | 413 NORTH WASHINGTON STREET  | 413 NORTH WASHINGTON STREET  | 413 NORTH WASHINGTON STREET  | ASSIGNMENT OF ASSIGNORS INTEREST.
6300 COLUMBIA CTR.           | 6300 COLUMBIA CTR.           | 6300 COLUMBIA CTR.           | 6300 COLUMBIA CTR.           | ASSIGNMENT OF ASSIGNORS INTEREST.
215 W. FRANKLIN ST,. 4TH FL. | 215 W. FRANKLIN ST,. 4TH FL. | 215 W. FRANKLIN ST,. 4TH FL. | 215 W. FRANKLIN ST,. 4TH FL. | ASSIGNMENT OF ASSIGNORS INTEREST.
IBM CORP., DEPT.             | IBM CORP., DEPT.             | IBM CORP., DEPT.             | IBM CORP., DEPT.             | ASSIGNMENT OF ASSIGNORS INTEREST.
REISING, ETHINGTON, BARNARD, | REISING, ETHINGTON, BARNARD, | REISING, ETHINGTON, BARNARD, | REISING, ETHINGTON, BARNARD, | ASSIGNMENT OF ASSIGNORS INTEREST.
WALL AND ROEHRIG             | WALL AND ROEHRIG             | WALL AND ROEHRIG             | WALL AND ROEHRIG             | ASSIGNMENT OF ASSIGNORS INTEREST.
ONE THOMAS CIRCLE, N.W.      | ONE THOMAS CIRCLE, N.W.      | ONE THOMAS CIRCLE, N.W.      | ONE THOMAS CIRCLE, N.W.      | ASSIGNMENT OF ASSIGNORS INTEREST.
616 FM 1960 WEST, SUITE 400  | 616 FM 1960 WEST, SUITE 400  | 616 FM 1960 WEST, SUITE 400  | 616 FM 1960 WEST, SUITE 400  | ASSIGNMENT OF ASSIGNORS INTEREST.

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. The recdate is when the assignment was recorded in the USPTO. Lastupdatedate is the last date the assignment record was updated. If the assignment record has been erased from the assignment database, the purge indicator will have a Y entry. The corrname is the person or organization dealing with the documentation of the assignment. Typically, the correspondent will be part of a firm involved in the transaction or an attorney. The correspondent's address is given in the four subsequent columns. The conveyance text describes what kind of transaction occurred in the assignment, meaning in what form the intellectual property was assigned. There are 162,613 distinct types of conveyance text included in the table.

SELECT COUNT(DISTINCT conveyancetext) FROM conveyance;
                     count  
                    -------
                    162613

The entries will often only vary a little given the addition of "(SEE DOCUMENT FOR DETAILS)" at the end of entries. The top ten entries are:

  • Assignment of Assignors Interest (See document for details).
  • Assignment of Assignors Interest.
  • Change of Name (See document for details).
  • Confirmatory License (See document for details).
  • Merger (See document for details).
  • Security Agreement.
  • Security Interest (See document for details).
  • Release by secured Party (See document for details).
  • Nunc Pro Tunc Assignment (See document for details).
  • License (See document for details).

The key for the table is composite and consists of reel, frame, and recdate.

Current Problems