TubmanProject / data_scraper

Web scraper for pulling data about justice system outcomes
5 stars 1 forks source link

Bexar County Records #5

Open DMalone87 opened 6 years ago

DMalone87 commented 6 years ago

Overview

Data is very well broken out and matches up well with the existing data set. Court dockets are available as well as jail activity reports. Data is stored as .xsls files.

Resources Found

District Criminal Court Records Updated on the first Friday of each month. Separated by the last name. http://gov.bexar.org/dc/dcrecords.html

Jail Activity Reports Provided for the past seven days. Separated by day. http://www.bexar.org/722/Jail-Activity-Reports

Criminal and Civil Court Docket Contains court docket data for the past 5 days. Also contains the pre-hearing docket for the current day. Criminal dockets are stored separately from Civil data. Data is also broken up by day. Updated daily. http://gov.bexar.org/dc/dockets.html

Data Sample

CASE-CAUSE-NBR,FULL-NAME,ALIAS,SEX,RACE,BIRTHDATE,SID,JUDICIAL-NBR,ADDR-HOUSE-NBR,HOUSE-SUF,ADDR-PRE-DIRECTION,ADDR-STREET,ADDR-STREET-SUFFIX,ADDR-POST-DIRECTION,ADDR-UNIT,ADDR-CITY,ADDR-STATE,ADDR-ZIP-CODE,ADDR-ZIP-PLUS-4,OFFENSE-DATE,OFFENSE-CODE,OFFENSE-DESC,OFFENSE-TYPE,REDUCED-OFFENSE-CODE,REDUCED-OFFENSE-DESC,REDUCED-OFFENSE-TYPE,LOCATION,CUSTODY-DATE,COMPLAINT-DATE,FILING-AGENCY-DESCRIPTION,CASE-DATE,CASE-DESC,SETTING-DATE,SETTING-TYPE,G-JURY-DATE,G-JURY-STATUS,DISPOSITION-DATE,DISPOSITION-CODE,DISPOSITION-DESC,JUDGEMENT-DATE,JUDGEMENT-CODE,JUDGEMENT-DESC,SENTENCE-DESC,SENTENCE,SENTENCE-START-DATE,SENTENCE-END-DATE,FINE-AMOUNT,COURT-COSTS,COURT-TYPE,COURT,POST-JUDICIAL-FIELD,POST-JUDICIAL-DATE,BOND-DATE,BOND-STATUS,BOND-AMOUNT,BONDSMAN-NAME,ATTORNEY,ATTORNEY-BAR-NBR,ATTORNEY-APPOINTED-RETAINED,INTAKE-PROSECUTOR,OUTTAKE-PROSECUTOR,PROBATION-PROSECUTOR,REVOKATION-PROSECUTOR,ORIGINAL-SENTENCE
2013CR8555          ,"AARON, DEVIN JOSEPH                     ", ,M,W,11/2/1989,1006149,1584110,12123, ,  ,RIDGE SMT             ,ST  ,  ,      ,SAN ANTONIO           ,TX,78247,3405,7/6/2013,130090,CONTINUOUS VIOLENCE AGAINST FA,F3,131385,ASSAULT-BI- FAMILY/HOUSEHOLD  ,MA,PST,1/20/2016,20130706,BEXAR COUNTY DISTRICT ATTORNEY          ,2/2/2016,SUP TERM UNSAT    ,11/26/2013,T,10/2/2013,IND,2/2/2016,619,DSMD-DEFR ADJUD   ,1/8/2014,727,NC-DEFR ADJUD TERM,                       ,20000000,1/8/2014,1/7/2016,500,227,DC,D186,NC-DEFR ADJUD TERM ,1/8/2014,1/6/2016,RWB,9999999.99,                              ,"BENAVIDES, MARK H             ",24025737,A,"HAYES, MARY CATHERINE         ","HAYES, MARY CATHERINE         ","HAYES, MARY CATHERINE         ","WRIGHT, JULIE A               ",002YR00MTH00DYS000HR
2013CR3467W         ,"AARON, DIANE SUZANNE                    ", ,F,W,9/27/1950,1004547,1562545,1502, ,  ,JACKSON KELLER        ,RD  ,  ,H91   ,SAN ANTONIO           ,TX,78213,3242,2/16/2013,239978,"THEFT ALUM/BRONZE/COPPER <$20,",FS,0,                              ,  ,CLS,2/17/2013,20130216,BEXAR COUNTY DISTRICT ATTORNEY          ,11/7/2015,*** JN CLOSED *** ,4/17/2013,T,4/17/2013,WAV,4/16/2015,619,DSMD-DEFR ADJUD   ,4/17/2013,727,NC-DEFR ADJUD TERM,                       ,20000000,4/17/2013,4/16/2015,1500,714,DC,D399,NC-DEFR ADJUD TERM ,4/17/2013,4/17/2013,CLS,3500,"BAIL BONDS,PERSONAL PROGRAM   ","SHAW, WILLIAM                 ",24064252,A,"FOX, RICHARD H                ","ZEMAN, LINDA B.               ",                              ,                              ,002YR00MTH00DYS000HR
2008CR3679W         ,"AARON, FRANK                            ", ,M,W,11/25/1984,904648,1284317,12303, ,  ,CASCADE HILLS         ,HLS ,  ,      ,SAN ANTONIO           ,TX,78253,5568,2/19/2008,359915,POSS CS PG 1  1 GRAM TO 4 GRAM,F3,0,                              ,  ,CLS,2/20/2008,20080219,BEXAR COUNTY DISTRICT ATTORNEY          ,12/4/2010,*** JN CLOSED *** ,          , ,4/29/2008,WAV,5/18/2010,650,PROB TRMNATD EARLY,7/30/2008,727,NC-DEFR ADJUD TERM,                       ,20000000,7/30/2008,7/29/2010,1500,360,DC,D144,NC-DEFR ADJUD TERM ,7/30/2008,7/30/2008,CLS,5000,"BAIL BONDS,PERSONAL PROGRAM   ","GUTIERREZ, ROLAND             ",24007291,H,"LOVELL, MATT                  ","DIMAIO, SAMANTHA              ","SPEIR, STEVEN                 ",                              ,002YR00MTH00DYS000HR
1986CR2748          ,"AARON, HENRY                            ",X,M,W,11/24/1966,365695,300910,15102, ,  ,MOONLIT               ,GRV ,  ,      ,SAN ANTONIO           ,TX,78247,2939,6/30/1986,220301,BURG W-INTENT THEFT           ,F2,0,                              ,  ,TDC,4/18/1990,19860701,                                        ,5/3/1990,SENTENCED         ,          , ,8/5/1986,IND,9/29/1986,631,PG CT-GUILTY      ,10/31/1986,707,PROBATION TERM    ,PROBATION - TERM       ,30000000,5/3/1990,          ,0,195,DC,D289,SENTENCE-TERM      ,5/3/1990,3/28/1990,RWB,9999999.99,"BAIL BONDS, PERSONAL PROG     ","SAWYER, MICHAEL J             ",17693800,A,"OFFERMAN, PHYLIS WEST         ","MILLER, MICHAEL F             ",                              ,                              ,010YR00MOS00DYS000HR
1987CR1682A         ,"AARON, JULIA ANN                        ",X,F,W,8/20/1944,312178,326416,111, ,  ,ACKARD                ,PL  ,E ,      ,SAN ANTONIO           ,TX,78221,0,3/11/1987,350422,POSS METHAMPHETAMINE U 28 G   ,F2,0,                              ,  ,CLS,3/11/1987,19870312,                                        ,10/19/1987,*** JN CLOSED *** ,8/24/1987,T,4/30/1987,IND,8/27/1987,612,DSMD-CDF CNV-INSF ,          ,0,                  ,                       ,0,          ,          ,0,0,DC,D186,                   ,          ,8/27/1987,CLS,10000,"BAIL BONDS, PERSONAL PROGRAM  ","CAMPION, CHARLES E            ",3728000,H,"COFFEY, EDWARD JOSEPH         ","KOPP, JAMES O                 ",                              ,                              ,                    
1995CR4865          ,"AARON, KENNETH                          ", ,M,W,8/30/1958,651387,673340,405, ,  ,HIGHLAND              ,DR  ,  ,      ,SEAGOVILLE            ,TX,75159,2301,7/15/1995,359911,MAN/DEL CS PG 3/4  28 GRAMS TO,F2,0,                              ,  ,   ,7/15/1995,19950715,BEXAR COUNTY DISTRICT ATTORNEY          ,1/8/1996,SENTENCED         ,          , ,9/26/1995,IND,12/21/1995,641,NOLO CT-GUILTY    ,1/8/1996,701,SENTENCE-TERM     ,SENTENCE - TERM        ,20000000,1/8/1996,1/7/1998,0,399.5,DC,D187,SENTENCE-TERM      ,1/8/1996,1/8/1996,RWB,9999999.99,                              ,"LANGHAM, VERNA VICTORIA       ",11917490,A,                              ,"YOUNG, WAYNE                  ","VALADEZ, MARY NELDA           ",                              ,002YR00MTH00DYS000HR
2007CR0625          ,"AARON, LEVI C                           ",X,M,W,3/26/1986,877652,1208788,305, ,W ,LYONS                 ,AVE ,  ,      ,PLEASANTON            ,TX,78064,3023,11/25/2006,359914,POSS CS PG 1 LESS THAN 1 GRAM ,FS,0,                              ,  ,CLS,11/25/2006,20061125,BEXAR COUNTY DISTRICT ATTORNEY          ,9/5/2009,*** JN CLOSED *** ,          , ,1/30/2007,IND,2/24/2009,619,DSMD-DEFR ADJUD   ,2/16/2007,727,NC-DEFR ADJUD TERM,                       ,20000000,2/16/2007,2/15/2009,1500,306,DC,D175,NC-DEFR ADJUD TERM ,2/16/2007,2/16/2007,CLS,2000,"BAIL BONDS,PERSONAL PROGRAM   ","PIKER, EDWARD P               ",16008800,H,"FLEMING, JOHN D               ","WILSON, WENDI K               ","WILSON, WENDI K               ",                              ,002YR00MTH00DYS000HR
2016CR11266W        ,"AARON, MICHAEL                          ", ,M,W,1/15/1990,1005664,1761157,424, ,  ,LEBANON               ,ST  ,  ,      ,SAN ANTONIO           ,TX,78223,4384,10/17/2016,359939,POSS W/I DEL CS PG1 4G - 200G ,F1,0,                              ,  ,PRB,10/18/2016,20161017,BEXAR COUNTY DISTRICT ATTORNEY          ,12/8/2016,PROBATION GRANTED ,12/8/2016,T,12/8/2016,WAV,12/8/2016,631,PG CT-GUILTY      ,12/8/2016,708,PROB-TERM + FINE  ,PROBATION - TERM & FINE,50000000,12/8/2016,12/7/2021,1500,348,DC,D226,PROB-TERM + FINE   ,12/8/2016,10/18/2016,SET,20000,                              ,"ROGERS, JASON                 ",24088321,H,                              ,"KEMMY, JAC                    ","KEMMY, JAC                    ",                              ,005YR00MTH00DYS000HR
2013CR7277          ,"AARON, MICHAEL                          ", ,M,W,1/15/1990,1005664,1565164,424, ,  ,LEBANON               ,ST  ,  ,      ,SAN ANTONIO           ,TX,78223,4384,3/6/2013,359914,POSS CS PG 1 LESS THAN 1 GRAM ,FS,0,                              ,  ,PST,10/18/2016,20130306,BEXAR COUNTY DISTRICT ATTORNEY          ,12/8/2016,SUP TERM UNSAT    ,11/18/2013,T,8/21/2013,IND,12/8/2016,649,DEF ADJ TERM UNSAT,11/18/2013,727,NC-DEFR ADJUD TERM,                       ,30000000,11/18/2013,11/17/2016,1500,374,DC,D226,NC-DEFR ADJUD TERM ,11/18/2013,11/10/2016,SET,20000,"REED,ROBBY RAY                ","RIDGEWAY, HENRY               ",16896900,H,                              ,"GLASSCOCK, LAUREN             ","GLASSCOCK, LAUREN             ",                              ,003YR00MTH00DYS000HR