HistPatent Table

From edegan.com
Jump to navigation Jump to search

Return to Patent Data Specifications.

Table Structure

              Table "public.histpatent"
    Column      |       Type        | Modifiers 
----------------+-------------------+-----------
applicationid   | integer           | 
pubno           | character varying | 
patentnumber    | character varying | 
nber            | integer           | 
uspc            | character varying | 
uspc_sub        | character varying | 
applicationdate | date              | 
prioritydate    | date              | 
pubdate         | date              | 
displaydate     | date              | 
disptype        | character varying | 
exp_dt          | date              | 
exp_dt_max      | date              | 
pta             | integer           | 

Example of table entries:

applicationid |      pubno      | patentnumber | nber | uspc | uspc_sub | applicationdate | prioritydate |  pubdate   | displaydate | disptype |   exp_dt   | exp_dt_max | pta 
--------------+-----------------+--------------+------+------+----------+-----------------+--------------+------------+-------------+----------+------------+------------+-----
      9728079 | US20010000377A1 | 6301920      |   69 | 62   | 374      | 2000-12-04      | 1998-12-04   | 2001-04-26 | 2001-10-16  | ISS      | 2009-10-16 |            |   0
      9738354 | US20010000378A1 | 6327947      |   51 | 82   | 1        | 2000-12-18      | 1996-09-04   | 2001-04-26 | 2001-12-11  | ISS      | 2016-09-03 |            |   0
      9730148 | US20010000379A1 | -2938081     |   51 | 83   | 013      | 2000-12-04      | 2000-12-04   | 2001-04-26 | 2003-01-28  | ABN      |            |            |   0
      9730180 | US20010000380A1 | 6461408      |   13 | 95   | 55       | 2000-12-05      | 1997-09-24   | 2001-04-26 | 2002-10-08  | ISS      | 2017-09-23 |            |   0
      9734424 | US20010000381A1 | 6491741      |   13 | 95   | 90       | 2000-12-11      | 1998-10-08   | 2001-04-26 | 2002-12-10  | ISS      | 2018-10-07 |            |   0
      9732670 | US20010000382A1 | 6393980      |   69 | 101  | 128      | 2000-12-08      | 1998-10-16   | 2001-04-26 | 2002-05-28  | ISS      | 2014-05-28 |            |   0
      9739809 | US20010000383A1 | 6497774      |   19 | 149  | 45       | 2000-12-20      | 1997-03-31   | 2001-04-26 | 2002-12-24  | ISS      | 2017-03-30 |            |   0
      9739203 | US20010000384A1 | 6247415      |   69 | 109  | 33       | 2000-12-19      | 2000-12-19   | 2001-04-26 | 2001-06-19  | ISS      | 2009-06-19 |            |   0
      9729711 | US20010000385A1 | 6550416      |   69 | 116  | 142      | 2000-12-06      | 1998-04-10   | 2001-04-26 | 2003-04-22  | ISS      | 2007-04-22 |            |   0
      9735177 | US20010000386A1 | 6805134      |   61 | 131  | 299      | 2000-12-12      | 1999-04-26   | 2001-04-26 | 2004-10-19  | ISS      | 2019-04-25 |            |   0
      9741335 | US20010000387A1 | -3349739     |   19 | 149  | 019      | 2000-12-21      | 2000-12-21   | 2001-04-26 | 2001-12-10  | ABN      |            |            |   0
      9730265 | US20010000388A1 | 6491078      |   55 | 152  | 539      | 2000-12-05      | 1999-05-25   | 2001-04-26 | 2002-12-10  | ISS      | 2019-05-24 |            |   0
      9738655 | US20010000389A1 | 6521075      |   19 | 156  | 251      | 2000-12-15      | 1999-04-08   | 2001-04-26 | 2003-02-18  | ISS      | 2019-04-07 |            |   0
      9728280 | US20010000390A1 | -1342275     |   19 | 156  | 472      | 2000-12-01      | 2000-12-01   | 2001-04-26 | 2003-01-06  | ABN      |            |            |   0
      9736673 | US20010000391A1 | 6877544      |   59 | 157  | 1        | 2000-12-13      | 1998-06-01   | 2001-04-26 | 2005-04-12  | ISS      | 2019-08-01 |            | 427
      9737195 | US20010000392A1 | 6362417      |   41 | 174  | 384      | 2000-12-15      | 1999-02-03   | 2001-04-26 | 2002-03-26  | ISS      | 2019-02-02 |            |   0
      9737877 | US20010000393A1 | 6283228      |   64 | 175  | 58       | 2000-12-15      | 1997-01-08   | 2001-04-26 | 2001-09-04  | ISS      | 2017-01-07 |            |   0
      9728070 | US20010000394A1 | -2976897     |   55 | 180  | 002      | 2000-11-30      | 2000-11-30   | 2001-04-26 | 2002-01-11  | ABN      |            |            |   0
      9727786 | US20010000395A1 | 6325178      |   55 | 187  | 382      | 2000-12-04      | 1999-08-03   | 2001-04-26 | 2001-12-04  | ISS      | 2019-08-02 |            |   0
      9730968 | US20010000396A1 | 6613214      |   19 | 205  | 118      | 2000-12-05      | 1998-11-30   | 2001-04-26 | 2003-09-02  | ISS      | 2019-03-05 |            |  96

Table Variables

Table Purpose

Current Problems

Data Issues