Patent Table
Revision as of 14:14, 13 July 2016 by MarcelaInteriano (talk | contribs)
Return to Patent Data Specifications.
Table Structure
Table "public.patent"
Column | Type | Modifiers
---------------------+-------------------+-----------
patent | integer | not null
gdate | date |
prioritydate | date |
prioritycountry | character varying |
prioritypatentnumber | character varying |
cpcsubgroup | character varying |
pctpatentnumber | character varying |
claims | integer |
appnum | integer |
gyear | integer |
appdate | date |
appyear | integer |
nber | integer |
uspc | character varying |
uspc_sub | character varying |
Indexes:
"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 --------+------------+--------------+-----------------+----------------------+-------------+-------------------+--------+----------+-------+------------+---------+------+------+---------- 8448569 | 2013-05-28 | | | | 076 | | 14 | 13409475 | 2013 | 2012-03-01 | 2012 | 61 | 99 | 99 8468109 | 2013-06-18 | | | | 063 | | 10 | 13338869 | 2013 | 2011-12-28 | 2011 | 22 | 706 | 706 8484000 | 2013-07-09 | | | | 00 | | 16 | 11219521 | 2013 | 2005-09-02 | 2005 | 25 | 703 | 703 8501233 | 2013-08-06 | | | | 0052 | PCT/US2008/003332 | 27 | 12530852 | 2013 | 2008-03-13 | 2008 | 31 | 424 | 424 8507880 | 2013-08-13 | | | | 20 | | 20 | 13507121 | 2013 | 2012-06-04 | 2012 | 44 | 250 | 250 8511948 | 2013-08-20 | 2010-02-08 | IL | 203798 | 113 | | 22 | 13017535 | 2013 | 2011-01-31 | 2011 | 51 | 408 | 408 8521310 | 2013-08-27 | | | | 04 | | 22 | 11862391 | 2013 | 2007-09-27 | 2007 | 22 | 700 | 700 8522762 | 2013-09-03 | | | | 0094 | | 23 | 12496063 | 2013 | 2009-07-01 | 2009 | 59 | 124 | 124 8526253 | 2013-09-03 | | | | 50 | | 20 | 13220104 | 2013 | 2011-08-29 | 2011 | 24 | 365 | 365 8561736 | 2013-10-22 | | | | 061 | | 22 | 12903435 | 2013 | 2010-10-13 | 2010 | 55 | 180 | 180 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.
