1,181
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 14:47, 3 May 2017
, 14:47, 3 May 2017→Data Cleanup Progress
==Data Cleanup Progress==
The tables that currently comprise the assignment data are as follows.
Table "public.ptoassignment"
Column | Type | Modifiers
-------------------------+------------------------+-----------
reelno | integer |
frameno | integer |
last_update_date | date |
purge_indicator | character varying(2) |
recorded_date | date |
correspondent_name | character varying(500) |
correspondent_address_1 | character varying(500) |
correspondent_address_2 | character varying(500) |
correspondent_address_3 | character varying(500) |
correspondent_address_4 | character varying(500) |
conveyance_text | character varying(500) |
Table "public.ptoassignee"
Column | Type | Modifiers
-----------+------------------------+-----------
reelno | integer |
frameno | integer |
name | character varying(500) |
addrline1 | character varying(500) |
addrline2 | character varying(500) |
city | character varying(500) |
state | character varying(500) |
country | character varying(500) |
postcode | character varying(80) |
Table "public.ptoassignor"
Column | Type | Modifiers
----------------+------------------------+-----------
reel_no | integer |
frame_no | integer |
assignor_name | character varying(500) |
execution_date | date |
Table "public.ptoproperty"
Column | Type | Modifiers
-----------------+------------------------+-----------
reelno | integer |
frameno | integer |
documentid | character varying(20) |
country | character varying(500) |
kind | character varying(3) |
filingdate | date |
invention_title | character varying(500) |
Table "public.ptopatentfile"
Column | Type | Modifiers
------------------------+-----------------------+-----------
reel_no | integer |
frame_no | integer |
action_key_code | character varying(10) |
uspto_transaction_date | date |
uspto_date_produced | date |
version | numeric |
This section explains the series of steps that were taken to clean and to take note of problems in the data. Additionally, this section includes the codes for new tables that combine patent properties from different tables in the original assignment data.
===Patent Number Cleanup===
