Custody Problems

I am working on a system to automatically detect places where our custody status is out of date. The most urgent of these (maybe! Maybe not, if their case won’t be resolved until after a more serious case finishes) are times when we think a client is NOT in custody but the sheriff's office thinks they are. Such cases are highlighted. I am still debugging this system, so please let me know if I made an error. I included all the clients here because I thought you might want to know. I'm matching on the first part of the first name (before any dashes or spaces), ditto the last name, and DOB.
The custody status lives on the client, not the case, so it might not be an emergency for us or anything if a client is in custody, but it’s still useful information to know where they are. This should save people the effort of having to go to the WCS website most of the time.
I am still debugging this system, so please let me know if either your client was not actually in custody or if I missed someone. I included all the clients here because I thought you might want to know. I'm matching on the first part of the first name (before any dashes or spaces), ditto the last name, and DOB

Admin: Mark Procida


Client with first name containing KIMBERLY, last name containing DANIELS, and dob 06/10/1995. According to DD their status is Released but on GPS Tether, but on the sheriff's website their status is Andrew C. Baird Detention Facility. WCS Link
Client with first name containing DWAYNE, last name containing POTTS, and dob 05/22/1960. According to DD their status is Not in Custody, but on the sheriff's website their status is Andrew C. Baird Detention Facility. WCS Link
Client: JOSHUA BEGLEY . In DD: Held at Wayne County Jail (New) WCS: None.
Client: SPENCER BLANCH 03/13/1995. In DD: Held at Wayne County Jail (New) WCS: Released but on GPS Tether. WCS Link
Client: KAREN FIGURSKI 11/04/1972. In DD: Held at Wayne County Jail (New) WCS: None.
Client: PHILIP GABRIEL 09/26/1989. In DD: Held at Wayne County Jail (Old) WCS: None.
Client: GERELLE RHAN 02/20/2001. In DD: Held at Wayne County Jail (New) WCS: None.

FNS: Donald Johnson


Client with first name containing ALEXANDER, last name containing CAMPBELL, and dob 03/12/1988. According to DD their status is None, but on the sheriff's website their status is Andrew C. Baird Detention Facility. WCS Link
Client with first name containing ANDRE, last name containing ROBINSON, and dob 10/08/1974. According to DD their status is Not in Custody, but on the sheriff's website their status is Andrew C. Baird Detention Facility. WCS Link
Client with first name containing CALVIN, last name containing SAILES, and dob 11/30/1985. According to DD their status is Not in Custody, but on the sheriff's website their status is Andrew C. Baird Detention Facility. WCS Link
Client: CURTIS ADAMS 02/09/1960. In DD: Held at Wayne County Jail (New) WCS: None.
Client: ORLANDO BAKER 02/19/1971. In DD: Held at Wayne County Jail (New) WCS: None.
Client: PAUL BENNETT 05/21/1980. In DD: Held at Dickerson Facility (Hamtramack) WCS: None.
Client: CHARLES BINION 11/14/1984. In DD: Held at Dickerson Facility (Hamtramack) WCS: None.
Client: JERRY CARMICHAEL 12/28/1983. In DD: Held at Dickerson Facility (Hamtramack) WCS: None.
Client: JAQUAN DIXON 07/01/1994. In DD: Held at Dickerson Facility (Hamtramack) WCS: None.
Client: RICHARD EDDINGS 12/28/1950. In DD: Held at Dickerson Facility (Hamtramack) WCS: None.
Client: KALVIN GRAVES 12/07/1980. In DD: Held at Dickerson Facility (Hamtramack) WCS: None.
Client: WADE HAMILTON 01/31/1991. In DD: Held at Wayne County Jail (New) WCS: Released but on GPS Tether. WCS Link
Client: MICHAEL JOHNSTON 12/31/1982. In DD: Held at Wayne County Jail (New) WCS: None.
Client: JOSEPH JOSLYN 03/30/1964. In DD: Held at Wayne County Jail (New) WCS: None.
Client: MICHAEL KIDD 11/07/1962. In DD: Held at Wayne County Jail (New) WCS: None.
Client: TERMAINE LOCKETT 08/16/1988. In DD: Held at Wayne County Jail (New) WCS: None.
Client: DANIEL LONGORIA 05/26/1980. In DD: Held at Dickerson Facility (Hamtramack) WCS: None.
Client: YIA LOR 06/12/1985. In DD: Held at Wayne County Jail (New) WCS: None.
Client: REUBEN MADISON 08/12/1974. In DD: Held at Dickerson Facility (Hamtramack) WCS: None.
Client: MARLIN MARTIN 07/05/1996. In DD: Held at Wayne County Jail (New) WCS: None.
Client: JAVEIZ MATON 02/26/1997. In DD: Held at Dickerson Facility (Hamtramack) WCS: None.
Client: JOSE MITCHELL 03/31/1999. In DD: Held at Dickerson Facility (Hamtramack) WCS: None.
Client: OMAR SMITH 05/21/1981. In DD: Held at Dickerson Facility (Hamtramack) WCS: None.
Client: BRYAN SPARKMAN 01/14/2000. In DD: Held at Dickerson Facility (Hamtramack) WCS: None.
Client: JOVAN SPARKS 05/16/1984. In DD: Held at Wayne County Jail (New) WCS: None.
Client: RODERICK STRICKLAND 03/03/1971. In DD: Held at Wayne County Jail (Old) WCS: None.
Client: RODRICK STRICKLAND 03/03/1971. In DD: Held at Wayne County Jail (New) WCS: None.
Client: BRIAN TAYLOR 08/02/1973. In DD: Held at Wayne County Jail (New) WCS: None.
Client: KEITH WALLS 01/30/1988. In DD: Held at Wayne County Jail (New) WCS: Released but on GPS Tether. WCS Link
Client: LOREN WAPSKINCH 08/12/1987. In DD: Held at Wayne County Jail (New) WCS: None.
Client: SEMAJ WHATLEY 04/28/1998. In DD: Held at Dickerson Facility (Hamtramack) WCS: None.
Client: MICHAEL WILSON 09/09/1994. In DD: Held at Wayne County Jail (New) WCS: None.

FNS: Lauren Pereny


Client: JOHNNY ALEXANDER 01/14/1974. In DD: Held at Dickerson Facility (Hamtramack) WCS: None.
Client: DON JOHNSON 06/04/1974. In DD: Held at Wayne County Jail (New) WCS: None.
Client: WILLIAM JORDAN 10/30/1967. In DD: Held at Wayne County Jail (New) WCS: None.
Client: RONALD KING 04/03/1979. In DD: Held at Wayne County Jail (New) WCS: None.
Client: DARYL REESE 10/11/1970. In DD: Held at Wayne County Jail (New) WCS: None.
Client: ANTONIO SANDERS 07/28/1988. In DD: Held at Wayne County Jail (New) WCS: None.
Client: JAMALIEL SMITH 06/16/1975. In DD: Held at Dickerson Facility (Hamtramack) WCS: None.

Team A: Earl Washington


Client: RODRICK BAKER 05/23/1991. In DD: Held at Wayne County Jail (New) WCS: None.
Client: KEITH COLE 03/05/1998. In DD: Held at Dickerson Facility (Hamtramack) WCS: None.
Client: JASON HAWKINS 05/13/1978. In DD: Held at Dickerson Facility (Hamtramack) WCS: Released but on GPS Tether. WCS Link
Client: CALVIN WARE 09/13/1996. In DD: Held at Wayne County Jail (New) WCS: None.

Team A: Emily New


Client: KEITH APPLING 02/13/1992. In DD: Held at Wayne County Jail (New) WCS: None.

Team A: Keshava A Kirkland


Client: DEMETRIUS CARMICHAEL 11/09/1983. In DD: Held at Wayne County Jail (New) WCS: None.
Client: ANTHONY ROBINSON 04/24/1992. In DD: Held at Wayne County Jail (New) WCS: None.
Client: MICHAEL TOLBERT 03/25/2002. In DD: Held at Wayne County Jail (New) WCS: Released but on GPS Tether. WCS Link
Client: NOAH WEINBURGER 01/07/2001. In DD: Held at Wayne County Jail (New) WCS: None.

Team A: Robert Burton-Harris


Client with first name containing RONALD, last name containing BENNETT, and dob 05/01/1964. According to DD their status is Not in Custody, but on the sheriff's website their status is Andrew C. Baird Detention Facility. WCS Link
Client with first name containing JOSEPH, last name containing WILLIAMS, and dob 03/06/1962. According to DD their status is Released but on GPS Tether, but on the sheriff's website their status is Andrew C. Baird Detention Facility. WCS Link

Team A: Tyrone Bickerdt


Client with first name containing RAFFEAL, last name containing BUSH, and dob 03/20/1979. According to DD their status is Not otherwise listed, but on the sheriff's website their status is Andrew C. Baird Detention Facility. WCS Link
Client: TITUS ANDERSON 02/14/1999. In DD: Held at Wayne County Jail (New) WCS: Released but on GPS Tether. WCS Link
Client: DAJUAN BANKS 12/04/1993. In DD: Held at Wayne County Jail (New) WCS: None.
Client: CARTAZ GASTON 11/25/1999. In DD: Held at Wayne County Jail (New) WCS: None.
Client: LYDELL GREEN 02/12/1988. In DD: Held at Wayne County Jail (New) WCS: Residential MH Treatment Programs. WCS Link
Client: STEVE GRIFFEN 03/25/1990. In DD: Held at Wayne County Jail (New) WCS: None.
Client: DAMON MOORE 04/03/1978. In DD: Held at Wayne County Jail (New) WCS: None.
Client: WILL MORRIS 08/10/1989. In DD: Held at Wayne County Jail (New) WCS: None.
Client: RYAN SEXTON 03/10/1995. In DD: Held at Wayne County Jail (New) WCS: None.
Client: TIMOTHY URQUHART 07/21/1985. In DD: Held at Wayne County Jail (New) WCS: Released but on GPS Tether. WCS Link
Client: BRANDON WILLIAMS 06/07/1984. In DD: Held at Wayne County Jail (New) WCS: Released but on GPS Tether. WCS Link

Team B: Cheryl Quick


Client: TURMAN COMPTON 08/15/1995. In DD: Held at Wayne County Jail (New) WCS: Released but on GPS Tether. WCS Link
Client: CHRISTOPHER KRUSAC 04/17/1990. In DD: Held at Wayne County Jail (New) WCS: Released but on GPS Tether. WCS Link
Client: JEREMY NEELEY 10/09/1984. In DD: Held at Wayne County Jail (New) WCS: Released but on GPS Tether. WCS Link
Client: LAMAR STATEN 07/15/1993. In DD: Held at Wayne County Jail (New) WCS: None.

Team B: Emily Elijah


Client: ALEXANDER CRAWL 04/07/1980. In DD: Held at Wayne County Jail (New) WCS: Released but on GPS Tether. WCS Link
Client: JASON LOVEJOY 09/27/1990. In DD: Held at Dickerson Facility (Hamtramack) WCS: Released but on GPS Tether. WCS Link
Client: AUNDRIA THOMAS 03/31/1995. In DD: Held at Dickerson Facility (Hamtramack) WCS: None.
Client: TYREIK VANN 07/14/1999. In DD: Held at Wayne County Jail (New) WCS: None.
Client: RUDOLLPH WALKER 06/25/1969. In DD: Held at Wayne County Jail (New) WCS: None.

Team B: Glen Oh


Client: LEROY NORRIS 06/14/1993. In DD: Held at Wayne County Jail (New) WCS: None.
Client: JAVAUGHN REDMOND . In DD: Held at Wayne County Jail (New) WCS: None.
Client: EDWIN TURNER 11/04/1955. In DD: Held at Wayne County Jail (New) WCS: None.

Team B: James O'Donnell


Client: JAVION CAMPER 07/27/2001. In DD: Held at Wayne County Jail (New) WCS: Released but on GPS Tether. WCS Link
Client: LEROY HARRIS 09/06/1994. In DD: Held at Wayne County Jail (New) WCS: Released but on GPS Tether. WCS Link
Client: BRANDON JEFFRIES 07/26/1994. In DD: Held at Wayne County Jail (Old) WCS: Released but on GPS Tether. WCS Link
Client: JAYSHAWN MINCEY 11/30/1998. In DD: Held at Wayne County Jail (New) WCS: Released but on GPS Tether. WCS Link
Client: MARTEZ POOLE 08/13/1996. In DD: Held at Dickerson Facility (Hamtramack) WCS: None.
Client: DONTA RUSSELL 09/24/1996. In DD: Held at Wayne County Jail (Old) WCS: Released but on GPS Tether. WCS Link

Team B: Joan Morgan


Client: RONALD NEDROW 12/06/1993. In DD: Held at Wayne County Jail (New) WCS: None.

Team B: Ken Riggins


Client: KIMBERLY BOLTON 06/07/1966. In DD: Held at Dickerson Facility (Hamtramack) WCS: Released but on GPS Tether. WCS Link
Client: LARRY BOWERS 08/02/1996. In DD: Held at Dickerson Facility (Hamtramack) WCS: None.
Client: DESHAWN BROWN 04/23/1988. In DD: Held at Wayne County Jail (New) WCS: None.
Client: DEVONTE BRUMBILL 06/09/2001. In DD: Held at Wayne County Jail (New) WCS: Released but on GPS Tether. WCS Link
Client: KHRISTOPHER IRVING 11/02/1993. In DD: Held at Wayne County Jail (New) WCS: Released but on GPS Tether. WCS Link
Client: DEJUAN LAWSON 10/24/1985. In DD: Held at Wayne County Jail (New) WCS: Residential MH Treatment Programs. WCS Link

Team B: Nanci Kastaw


Client with first name containing TIMOTHY, last name containing BIERINGER, and dob 08/06/2001. According to DD their status is Not in Custody, but on the sheriff's website their status is Old Jail. WCS Link
Client: ZACHARY BANKHEAD 09/29/1962. In DD: Held at Wayne County Jail (New) WCS: None.
Client: MALCOLM MITCHELL 03/11/1992. In DD: Held at Wayne County Jail (New) WCS: None.
Client: TOM ROBINSON 06/30/1980. In DD: Held at Wayne County Jail (New) WCS: None.
Client: WILLIAM ROSS 10/11/1996. In DD: Held at Wayne County Jail (New) WCS: None.
Client: KEITH STEPTOE 03/28/1991. In DD: Held at Wayne County Jail (Old) WCS: None.
Client: JAMES WEBSTER 12/16/1995. In DD: Held at Wayne County Jail (Old) WCS: None.

Team C: Blase Kearney


Client: JENNIFER DENNARD 12/10/1987. In DD: Held at Dickerson Facility (Hamtramack) WCS: None.
Client: TERRY LOVELY 06/16/1986. In DD: Held at Wayne County Jail (New) WCS: None.
Client: BEREYDA ORTIZ 03/07/1979. In DD: Held at Wayne County Jail (New) WCS: None.
Client: SHONTEZ REEDY 08/22/1998. In DD: Held at Wayne County Jail (New) WCS: None.
Client: CLIFFORD WILLIAMS 03/29/1981. In DD: Held at Wayne County Jail (New) WCS: None.

Team C: Brandy Robinson


Client with first name containing BRADLEY, last name containing TROJANOWSKI, and dob 11/14/2001. According to DD their status is Not in Custody, but on the sheriff's website their status is Andrew C. Baird Detention Facility. WCS Link
Client: ANTONIO MILLER 12/05/1994. In DD: Held at Wayne County Jail (New) WCS: Released but on GPS Tether. WCS Link
Client: ROBERT MORAN 02/20/1981. In DD: Held at Wayne County Jail (New) WCS: Released but on GPS Tether. WCS Link
Client: ROBERT PARKS 10/19/1989. In DD: Held at Wayne County Jail (New) WCS: Released but on GPS Tether. WCS Link

Team C: Hannah Baron


Client: JAMES LITWILLER 02/04/1969. In DD: Held at Wayne County Jail (New) WCS: Released but on GPS Tether. WCS Link
Client: JAMIN MONTGOMERY 02/03/1977. In DD: Held at Wayne County Jail (New) WCS: None.
Client: ROMAN WEBB 05/31/1993. In DD: Held at Dickerson Facility (Hamtramack) WCS: None.

Team C: James Parker


Client with first name containing RIELEY, last name containing SORDINO, and dob 09/02/1996. According to DD their status is Not otherwise listed, but on the sheriff's website their status is Andrew C. Baird Detention Facility. WCS Link
Client: PIERRE JEFFERSON 05/21/1998. In DD: Held at Wayne County Jail (New) WCS: None.
Client: KEVIN JORDAN 01/23/1965. In DD: Held at Wayne County Jail (New) WCS: Residential MH Treatment Programs. WCS Link
Client: JERRY MCKINNEY 06/05/1976. In DD: Held at Wayne County Jail (New) WCS: Released but on GPS Tether. WCS Link
Client: COREY THOMAS 05/28/1980. In DD: Held at Wayne County Jail (New) WCS: None.

Team C: Jonathan Hordos


Client: HAWK BRANTLEY 03/31/1987. In DD: Held at Wayne County Jail (New) WCS: Released but on GPS Tether. WCS Link
Client: BRANDON DAMON 07/20/1991. In DD: Held at Wayne County Jail (New) WCS: Released but on GPS Tether. WCS Link
Client: IAN WRIGHT 04/09/2000. In DD: Held at Wayne County Jail (Old) WCS: None.

Team C: Lauren Anderson


Client: ARTHUR HALL 09/23/1958. In DD: Held at Wayne County Jail (New) WCS: Released but on GPS Tether. WCS Link
Client: TIMOTHY HARRIS 05/15/1988. In DD: Held at Wayne County Jail (New) WCS: None.
Client: EON HOVER 11/02/1994. In DD: Held at Wayne County Jail (New) WCS: Released but on GPS Tether. WCS Link
Client: DARIUS WILLIAMS 01/26/1993. In DD: Held at Wayne County Jail (New) WCS: None.

Team C: Natalie Phelps


Client: MATTIE JONES 05/15/1962. In DD: Held at Wayne County Jail (New) WCS: Released but on GPS Tether. WCS Link
Client: RICK LITTLE 05/31/1988. In DD: Held at Wayne County Jail (New) WCS: None.
Client: CORRELL TILLMAN 10/25/1978. In DD: Held at Wayne County Jail (New) WCS: Released but on GPS Tether. WCS Link

Team D: Brian Gagniuk


Client: JASER ABUAUN 05/31/1981. In DD: Held at Wayne County Jail (New) WCS: None.
Client: DIONTE DAVIS 01/11/1994. In DD: Held at Dickerson Facility (Hamtramack) WCS: Released but on GPS Tether. WCS Link
Client: RUSSELL HALLIBURTON 06/30/1960. In DD: Held at Wayne County Jail (New) WCS: None.
Client: HUGH MCMANUS 11/20/1989. In DD: Held at Wayne County Jail (New) WCS: None.

Team D: Dezha Dial


Client: KRISTOFER BRADFORD 01/16/2001. In DD: Held at Wayne County Jail (New) WCS: None.
Client: L'RONTAE HICKMAN 05/18/1998. In DD: Held at Wayne County Jail (New) WCS: None.

Team D: Jackie Pilcowitz


Client: ROBERT JOHNSON 02/17/1986. In DD: Held at Wayne County Jail (New) WCS: Released but on GPS Tether. WCS Link

Team D: Jeffrey Knoche


Client with first name containing KAVON, last name containing BUCK, and dob 05/13/1994. According to DD their status is None, but on the sheriff's website their status is Old Jail. WCS Link
Client: WILLIAM BOMMARRITO 03/07/1991. In DD: Held at Wayne County Jail (New) WCS: None.
Client: WADE HAMILTON 01/31/1991. In DD: Held at Wayne County Jail (New) WCS: Released but on GPS Tether. WCS Link

Team D: Kim Basen-Michon


Client with first name containing DAVID, last name containing HAMBLIN, and dob 09/26/1986. According to DD their status is None, but on the sheriff's website their status is Andrew C. Baird Detention Facility. WCS Link
Client: BENNY KILLINGSWORTH 04/27/1989. In DD: Held at Wayne County Jail (New) WCS: None.
Client: MATTHEW PARKER 01/12/1986. In DD: Held at Wayne County Jail (New) WCS: None.

Team D: Kristine Longstreet


Client: ZENOVIS JENKINS 05/23/1996. In DD: Held at Dickerson Facility (Hamtramack) WCS: None.
Client: MICHAEL LEAK 09/06/1966. In DD: Held at Wayne County Jail (Old) WCS: None.
Client: ALEJANDRO MADRIGAL 01/11/1998. In DD: Held at Wayne County Jail (New) WCS: None.
Client: QUINCY PERRY 12/06/1995. In DD: Held at Wayne County Jail (New) WCS: None.
Client: GREGORY PHILLIPS . In DD: Held at Dickerson Facility (Hamtramack) WCS: None.
Client: MICHAEL SHEALY 11/23/1989. In DD: Held at Dickerson Facility (Hamtramack) WCS: None.
Client: KYLE WOODS 06/15/1997. In DD: Held at Dickerson Facility (Hamtramack) WCS: None.

Team D: William Noakes


Client with first name containing DANIEL, last name containing CONNOLLY, and dob 12/20/1962. According to DD their status is None, but on the sheriff's website their status is Andrew C. Baird Detention Facility. WCS Link
Client: NATHANIEL BALDWIN 10/09/1999. In DD: Held at Wayne County Jail (New) WCS: None.
Client: EUJENIO CALDERON 05/27/1963. In DD: Held at Wayne County Jail (New) WCS: None.
Client: LAKIESHA CROSS 03/03/1998. In DD: Held at Dickerson Facility (Hamtramack) WCS: None.
Client: CAMERON DAVIDSON 02/10/1990. In DD: Held at Wayne County Jail (New) WCS: None.
Client: EUGENE FLATT 12/12/1996. In DD: Held at Wayne County Jail (New) WCS: Released but on GPS Tether. WCS Link
Client: WILLIAM GILLAM 06/22/1966. In DD: Held at Wayne County Jail (New) WCS: Released but on GPS Tether. WCS Link
Client: TANIA GORDON 02/22/1980. In DD: Held at Dickerson Facility (Hamtramack) WCS: None.
Client: DWAYNE HENRY 08/22/1995. In DD: Held at Wayne County Jail (New) WCS: None.
Client: LAMONT HERROD 03/27/1967. In DD: Held at Wayne County Jail (New) WCS: Released but on GPS Tether. WCS Link
Client: RAY LAKE 09/21/1989. In DD: Held at Wayne County Jail (New) WCS: None.
Client: NICHOLAS PHILLIPS 05/04/1999. In DD: Held at Wayne County Jail (New) WCS: None.
Client: DRAKKARI ROBINSON 03/31/2002. In DD: Held at Wayne County Jail (New) WCS: None.
Client: JOE TAYLOR 06/16/1989. In DD: Held at Wayne County Jail (New) WCS: None.
Client: NICOLE TYSON 04/24/1989. In DD: Held at Dickerson Facility (Hamtramack) WCS: None.
Client: CLARENCE WATKINS 12/23/1971. In DD: Held at Wayne County Jail (New) WCS: None.
Client: TREVOR WHALIN 02/19/2000. In DD: Held at Wayne County Jail (New) WCS: None.

Team T: Melissa Kliemann


Client: KHALAN BROADNAX 03/16/1996. In DD: Held at Wayne County Jail (New) WCS: None.
Client: ERVIN GROSS 09/30/1969. In DD: Held at Dickerson Facility (Hamtramack) WCS: None.
Client: SHATEZE JONES 08/28/1988. In DD: Held at Dickerson Facility (Hamtramack) WCS: None.
Client: ANTHONY ROBINSON 04/24/1992. In DD: Held at Wayne County Jail (New) WCS: None.
Client: KEVIN SPELLER 07/19/1983. In DD: Held at Wayne County Jail (New) WCS: None.
Client: HEATHER TUCK 02/05/1990. In DD: Held at Wayne County Jail (Old) WCS: None.
Client: TIMOTHY WALKER 04/21/1991. In DD: Held at Dickerson Facility (Hamtramack) WCS: None.