select distinct oc1.offender, j.oname, j.sid, j.lid, j.sex, j.lodged, j.maxrelease, e.aname from openclocksview oc1, jailhouseview j, offenders o left outer join employees e on e.employee=o.poemployee where oc1.offender=j.offender and oc1.offender=o.offender and oc1.facility='LINCOL_OR' and oc1.clockin in ('ARRPROB','PSANC','POSANC','PARVIO','PROVIO','SANCPEND') order by j.oname

P&P Inmates for Lincoln County
as of 03/10/2010 00:03

SID LID Name Sex Lodged Release P.O.
15090100 28834 ARISS, KACIE ELIZABETH FEMALE 02/26/2010 03/18/2010 (Not Assigned)
  Clock Status Docket Charge
  03/04/2010 13:15 PRETRIAL 100927 POSSESSION HEROIN
  03/04/2010 13:15 PRETRIAL 100927 POSS CONTROL SUB - SCH II
  03/05/2010 13:15 PROVIO 082237 POSSESSION METHAMPHETAMINE
  03/05/2010 13:15 PROVIO 082237 ENDANGER WELFARE OF MINOR
  02/26/2010 13:15 PSANC 15090100 PAROLE VIOLATION
 
08256596 21764 BARNES, KIMBERLY ANN FEMALE 03/09/2010   (Not Assigned)
  Clock Status Docket Charge
  03/09/2010 09:46 PARVIO 8256596 PAROLE VIOLATION
 
12661216 21808 BENDER, JOHN ALEXANDER MALE 03/07/2010   (Not Assigned)
  Clock Status Docket Charge
  03/07/2010 17:25 PRETRIAL 100951 DRIVE UNDER INFLUENCE
  03/07/2010 17:25 PRETRIAL 100951 DRIVE SUSPENDED/REVOKED FELO
  03/07/2010 17:25 PRETRIAL 100951 CRIM TRESPASS I
  03/08/2010 14:16 SANCPEND 12661216 PAROLE VIOLATION
 
16958333 33074 BORDEN, NICHOLAS DEAN MALE 02/25/2010 04/26/2010 (Not Assigned)
  Clock Status Docket Charge
  02/25/2010 13:24 PSANC 16958333 PAROLE VIOLATION
 
5448816 01419 CLEVELAND, MICHAEL JOHN MALE 02/24/2010   (Not Assigned)
  Clock Status Docket Charge
  02/24/2010 21:05 PRETRIAL 100789 CONTEMPT OF COURT
  02/24/2010 21:05 ARR 094687 RESTRAINING ORDER VIOLATION
  02/25/2010 12:03 PROVIO 084064 ASSAULT IV DOMESTIC VIOLENCE- FELONY
 
12511495 29085 DOROUGH, NATHAN MICHAEL MALE 03/09/2010   (Not Assigned)
  Clock Status Docket Charge
  03/09/2010 12:59 PSANC 12511495 PAROLE VIOLATION
 
16257882 30440 GEORGIYEV, RUSLAN EDUAROVICH MALE 03/04/2010   (Not Assigned)
  Clock Status Docket Charge
  03/04/2010 10:12 PROVIO 055489 DISORDERLY CONDUCT
 
16956278 35325 GETTY, ANTHONY LOWELL MALE 03/03/2010   (Not Assigned)
  Clock Status Docket Charge
  03/03/2010 10:28 SANCPEND 16956278 PAROLE VIOLATION
 
12737722 22032 GODDARD, RICHARD WILLIAM MALE 03/07/2010 03/27/2010 (Not Assigned)
  Clock Status Docket Charge
  03/07/2010 11:32 PSANC 12737722 PAROLE VIOLATION
 
16757199 31708 GOODELL, AMBER DAWN FEMALE 03/02/2010   (Not Assigned)
  Clock Status Docket Charge
  03/02/2010 23:02 PROVIO 081503 BURGLARY I
  03/02/2010 23:02 PROVIO 081503 THEFT III
  03/02/2010 23:02 PROVIO 072486 POSSESSION METHAMPHETAMINE
  03/02/2010 23:02 PROVIO 072486 CRIM MISCHIEF II
 
13617267 23957 HATFIELD, MELISSA BETH FEMALE 03/04/2010 03/11/2010 (Not Assigned)
  Clock Status Docket Charge
  03/04/2010 10:02 POSANC 084572 UNLAWFUL USE OF A WEAPON
 
14906769 27274 HAUSMANN, JEFFREY JOHN MALE 03/07/2010   (Not Assigned)
  Clock Status Docket Charge
  03/08/2010 10:43 PROVIO 090843 POSS CONTROL SUB - SCH II
 
11688540 19344 HILL, SCOTT THOMAS MALE 12/27/2009   (Not Assigned)
  Clock Status Docket Charge
  12/27/2009 22:41 PRETRIAL 095391 FORGERY I
  12/27/2009 22:41 PRETRIAL 095391 FORGERY I
  12/27/2009 22:41 PRETRIAL 095391 FORGERY I
  12/27/2009 22:41 PRETRIAL 095391 FORGERY I
  12/27/2009 22:41 PRETRIAL 095391 FORGERY I
  12/27/2009 22:41 PRETRIAL 095391 POSS FORGED INSTRUMENT I
  12/27/2009 22:41 PRETRIAL 095391 POSS FORGED INSTRUMENT I
  12/27/2009 22:41 PRETRIAL 095391 POSS FORGED INSTRUMENT I
  12/27/2009 22:41 PRETRIAL 095391 POSS FORGED INSTRUMENT I
  12/27/2009 22:41 PRETRIAL 095391 POSS FORGED INSTRUMENT I
  12/27/2009 22:41 PROVIO 082833 FORGERY I
  12/31/2009 13:15 PROVIO 071258 THEFT I
  12/31/2009 13:15 PROVIO 071258 THEFT OF IDENTITY
  12/31/2009 13:15 PROVIO 071258 THEFT OF IDENTITY
 
07196035 09230 LOWERY, TROY MICHAEL MALE 02/24/2010   (Not Assigned)
  Clock Status Docket Charge
  02/24/2010 13:58 PRETRIAL 100027 THEFT I
  02/24/2010 13:58 PRETRIAL 100027 THEFT II
  02/24/2010 13:58 PRETRIAL 100027 FORGERY II
  02/24/2010 13:58 PRETRIAL 100027 RESIST ARREST
  02/24/2010 13:58 PROVIO 080493 THEFT I
  02/24/2010 13:58 PROVIO 080493 FORGERY I
 
08314885 13059 MORTON, GLEN LEON MALE 03/05/2010   (Not Assigned)
  Clock Status Docket Charge
  03/05/2010 20:01 PARVIO 073312 POSS CONTROL SUB - SCH II
 
08872783 33631 NEWHOUSE, MICHAEL VERNON MALE 03/03/2010   (Not Assigned)
  Clock Status Docket Charge
  03/03/2010 14:35 PARVIO 08872783 PAROLE VIOLATION
 
07604977 10827 NYE, KIM NMN MALE 02/20/2010 03/18/2010 (Not Assigned)
  Clock Status Docket Charge
  02/20/2010 16:31 PRETRIAL 100732 THEFT I - AGGRAVATED
  02/20/2010 16:31 PRETRIAL 100732 BURGLARY II
  02/20/2010 16:31 PRETRIAL 100732 UNAUTHORIZED USE VEHICLE
  02/20/2010 16:31 PRETRIAL 100732 DRIVE SUSPENDED/REVOKED MISD
  02/20/2010 16:31 PSANC 7604977 PAROLE VIOLATION
 
17573947 33566 POLELLO, KELLI SUE FEMALE 03/09/2010   (Not Assigned)
  Clock Status Docket Charge
  03/09/2010 09:59 ARRPROB 091115 POSSESSION METHAMPHETAMINE
 
10645123 16949 RAMSEY, TODD WESLEY MALE 03/08/2010 03/05/2010 (Not Assigned)
  Clock Status Docket Charge
  03/08/2010 18:48 SENTJ 043230 RECKLESS DRIVING
  03/08/2010 18:48 SANCPEND 10645123 PAROLE VIOLATION
 
05888073 12408 REED, JAMES PATRICK MALE 02/18/2010   (Not Assigned)
  Clock Status Docket Charge
  02/18/2010 12:35 SANCPEND 05888073 PAROLE VIOLATION
 
04467447 25784 SCHAAD, JEFFREY ALAN MALE 02/10/2010 04/11/2010 (Not Assigned)
  Clock Status Docket Charge
  02/10/2010 10:49 PRETRIAL 100577 DELIVERY HEROIN
  02/10/2010 10:49 PRETRIAL 100577 MANUFACTURE HEROIN
  02/10/2010 10:49 PRETRIAL 100577 POSSESSION HEROIN
  02/10/2010 10:49 POSANC 091716 DELIVERY HEROIN
 
18150900 34830 SCHMIDT, SHANNA LEE FEMALE 02/02/2010   (Not Assigned)
  Clock Status Docket Charge
  02/03/2010 11:00 PRETRIAL 100471 THEFT I
  02/03/2010 11:00 PRETRIAL 100471 FRAUD USE CRED CARD UNDER 200
  02/02/2010 12:45 PRETRIAL 100471 THEFT III
  02/02/2010 12:45 PROVIO 094000 ATT TO COMMIT CRIME
  02/02/2010 12:45 PROVIO 094000 RESIST ARREST
 
05932358 03818 SHORT, JAMES PATRICK MALE 02/12/2010 03/18/2010 LONG T
  Clock Status Docket Charge
  02/12/2010 12:18 PSANC 05932358 PAROLE VIOLATION
 
08611914 16402 SIGLER, DAVID ALLAN MALE 02/19/2010 04/19/2010 (Not Assigned)
  Clock Status Docket Charge
  02/19/2010 22:24 PSANC 08611914 PAROLE VIOLATION
 
15529036 28703 SONDENAA, EDWIN DALE MALE 03/09/2010   (Not Assigned)
  Clock Status Docket Charge
  03/09/2010 13:48 PROVIO 15529036 PAROLE VIOLATION
 
15869243 29846 THOMAS, SHANNON URETTA FEMALE 03/02/2010 03/12/2010 (Not Assigned)
  Clock Status Docket Charge
  03/02/2010 10:29 POSANC 080230632 POSSESSION METHAMPHETAMINE
 
15742751 29322 TROUT, CHRISTOPHER PATRICK MALE 01/27/2010   (Not Assigned)
  Clock Status Docket Charge
  02/05/2010 00:45 PRETRIAL 100488 BURGLARY I
  02/05/2010 00:45 PRETRIAL 100488 THEFT I
  01/27/2010 16:05 PRETRIAL 100488 THEFT II
  01/27/2010 16:05 PARVIO 15742751 PAROLE VIOLATION
 
11963542 19905 WEDDLE, GUY ROBERT MALE 09/30/2009 10/29/2009 (Not Assigned)
  Clock Status Docket Charge
  03/03/2010 16:30 PARVIO 11963542 PAROLE VIOLATION
 
07070913 30943 WENDT, RONALD JAMES MALE 01/20/2010   (Not Assigned)
  Clock Status Docket Charge
  01/20/2010 10:54 PRETRIAL 100275 DELIV/MANU CONT SUB - SCH II
  01/20/2010 10:54 PRETRIAL 100275 MANUFACTURE CONT SUB - SCH II
  01/20/2010 10:54 PRETRIAL 100275 POSS CONTROL SUB - SCH II
  01/21/2010 20:00 PROVIO 090658 DELIV MARIJUANA/NO PAYMENT
 
07779443 30459 WILLIAMS, MARK EDWARD MALE 02/22/2010 04/22/2010 (Not Assigned)
  Clock Status Docket Charge
  02/22/2010 09:10 PSANC 07779443 PAROLE VIOLATION
 
06834711 07685 WOOLEY, TROY LEE MALE 02/03/2010 04/03/2010 (Not Assigned)
  Clock Status Docket Charge
  02/03/2010 14:30 PSANC 06834711 PAROLE VIOLATION
 
14617435 32409 YOUNG, DONALD JAMES MALE 03/06/2010   (Not Assigned)
  Clock Status Docket Charge
  03/06/2010 10:12 SANCPEND 073823 POSSESSION METHAMPHETAMINE
 
Total Inmates: 32