1,181
edits
Changes
Jump to navigation
Jump to search
reelno reel | integer | frameno frame | integer |
reelno reel | frameno frame | recdate | actionkeycode | trandate | dateproduced -------+---------+------------+---------------+------------+-------------- 15283 | 39090 287 | 698 | 20161970-0701-07 04 | DA AN | 2016-0701-08 06 | 2013-11-01 39092 5744 | 620 401 | 20161975-0709-07 08 | DA AN | 2016-0701-08 04 | 2013-11-01 39090 3634 | 667 874 | 20161979-0703-07 02 | DA AN | 2016-0701-08 04 | 2013-11-01 39090 3634 | 676 875 | 20161979-0703-07 02 | DA AN | 2016-0701-08 04 | 2013-11-01 39090 3625 | 740 888 | 20161979-0703-07 05 | DA AN | 2016-0701-08 04 | 2013-11-01 39092 8613 | 129 265 | 20161979-0705-07 27 | DA AN | 2016-0701-08 06 | 2013-11-01 39090 3835 | 591 710 | 20161979-0709-07 | DA AN | 2016-0701-08 04 | 2013-11-01 39090 3692 | 664 537 | 20161979-0709-07 26 | DA AN | 2016-0701-08 04 | 2013-11-01 39094 3696 | 73 452 | 20161979-0710-07 11 | DA AN | 2016-0701-08 04 | 2013-11-01 39094 3818 | 38 140 | 20161980-0701-07 02 | DA AN | 2016-0701-08 04 | 2013-11-01
no edit summary
Column | Type | Modifiers
--------------+------------------------+-----------
recdate | date |
actionkeycode | character varying(500) |
trandate | date |
dateproduced | date |
Example of table entries:
==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. The actionkeycode is an indicator for whether the transaction was included in a daily, weekly, bi-monthly or annual release.[http://www.uspto.gov/sites/default/files/products/assign-documentation.pdf] The trandate is when the data was extracted into the file. The table has a composite key consisting of reel, frame, and recdate.
==Current Problems==
Meaning of dateproduced is unknown.
