Changes

Jump to navigation Jump to search
772 bytes added ,  17:42, 2 September 2016
no edit summary
Return to [[Patent Data Specifications]].
==Table Purpose==
<section begin="judge"/>
In conjunction with the litigation data, the LexJudge Table may be used to monitor district court activity for the Little Guy Academic Paper and the Patent Troll Academic Paper. If matched with particular cases, trends in a particular judge's case outcomes may be developed and analyzed for use in the Patent Troll Academic Paper or Issue Brief.
<section end="judge"/>
==Table Structure==
Table "public.lexjudge"
Column | Type | Modifiers
court | character varying(8) |
Example of table entries:
name | noopencases numopencases | nocasesinthiscourt numcaseshere | numcases totnumcases | dateappointed | dateretired | circuit | court --------------------------+------+-------------+--------------+------+----------+---------------+-------------+---------+------- Jay A. Garcia-Gregory | | 10 | 80 | 80 | 2000-07-11 | | 1 | DPR Gustavo Antonio Gelpi Jr. | 9 | 81 | 81 | 2006-08-01 | | 1 | DPR Carmen Consuelo Cerezo | 7 | 70 | 70 | 1980-06-30 | | 1 | DPR Aida M. Delgado-Colon | 6 | 44 | 44 | 2006-03-17 | | 1 | DPR Daniel R. Dominguez | 3 | 105 | 105 | 1994-09-29 | | 1 | DPR Jose Antonio Fuste | 3 | 65 | 65 | 1985-10-28 | 2016-06-01 | 1 | DPR Francisco Augusto Besosa | 2 | 46 | 46 | 2006-09-27 | | 1 | DPR Salvador E. Casellas | 1 | 1 | 49 | 49 | 1994-09-29 | | 1 | DPR Jaime Pieras Jr. | 0 | 51 | 51 | 1982-07-15 | 2011-06-11 | 1 | DPR Juan Manuel Perez-Gimenez | 0 | 32 | 32 | 1979-12-06 | | 1 | DPR Raymond L. Acosta | 0 | 30 | 30 | 1982==Table Variables==The table has the name of each judge currently working or that has worked in a district court, the earliest appointed date being 1946-0901-30 03. Numopencases is the number of open cases a judge has a in his or her district court. Numcaseshere is the number of open and terminated cases a judge has presided over in the district court specified. Totnumcases is the total number of cases a judge has presided over. Totnumcases may exceed numcaseshere if the judge has transferred from another district court. The date the judge was appointed and retired are also given. The judge's circuit and district are also specified under circuit and court respectively. ==Current Problems=={{#section:Patent_Data_Issues| 2014-12-23 | 1 | DPRlexjudge}} Hector Manuel Laffitte | 0 | 27 | 27 | 1983-07-27 | 2007-02-16 | 1 | DPR[[Category: Internal]] Pedro Alberto Delgado Hernandez | 0 [[Internal Classification: Data Tables| 0 | 0 | 2014-03-07 | | 1 | DPR]]

Navigation menu