Changes

Jump to navigation Jump to search
108 bytes added ,  15:14, 13 July 2016
no edit summary
Return to [[Patent Data Specifications]].
==Table Structure==
Table "public.patent"
Column | Type | Modifiers
"patents_pkey" PRIMARY KEY, btree (patent)
"patent_idx" UNIQUE, btree (patent)
 
Example of table entries:
patent | gdate | prioritydate | prioritycountry | prioritypatentnumber | cpcsubgroup | pctpatentnumber | claims | appnum | gyear | appdate | appyear | nber | uspc | uspc_sub
8580666 | 2013-11-12 | | | | 28052 | | 16 | 13246146 | 2013 | 2011-09-27 | 2011 | 46 | 438 | 438
8585041 | 2013-11-19 | 2011-11-02 | JP | 2011-241111 | 18 | | 8 | 13664916 | 2013 | 2012-10-31 | 2012 | 51 | 271 | 271
 
==Table Variables==
==Table Purpose==
==Current Problems==
The steps taken to refine the patent table into its current form have been recorded on [[Patent Data Cleanup - June 2016]].

Navigation menu