paigestjohn / california_detail

California Sex Offenders Detail


Forked from ScraperWiki

Contributors paigestjohn

Last run failed with status code 1.

Console output of last run

Traceback (most recent call last): File "/repo/scraper.py", line 152, in <module> scraperwiki.sqlite.attach("california_megan") AttributeError: 'module' object has no attribute 'attach'

Data

Downloaded 0 times

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (832 KB) Use the API

rows 10 / 1463

uniqueid status violationdate weight dob height eyecolor laterconvictions haircolor sex ethnicity
10401090E9417
Specific address not subject to disclosure
180
07-31-1961
5'7"
HAZEL
DOJ is unable to determine if there are any subsequent felony convictions for this registrant at this time.
BROWN
MALE
UNKNOWN
10401096E9503
210
04-01-1953
5'7"
BROWN
DOJ is unable to determine if there are any subsequent felony convictions for this registrant at this time.
UNKNOWN/BALD
MALE
HISPANIC
10406330L0067
185
07-08-1972
5'7"
BROWN
DOJ is unable to determine if there are any subsequent felony convictions for this registrant at this time.
BLACK
MALE
OTHER
10408199M2756
THIS SEX OFFENDER HAS BEEN IN VIOLATION OF REGISTRATION REQUIREMENTS SINCE 10/30/2009.
200
10-19-1979
5'9"
BROWN
DOJ is unable to determine if there are any subsequent felony convictions for this registrant at this time.
BROWN
MALE
HISPANIC
10903188I0046
200
11-04-1970
5'11"
BROWN
DOJ is unable to determine if there are any subsequent felony convictions for this registrant at this time.
BLACK
MALE
BLACK
10904093I6963
160
05-13-1934
5'6"
BROWN
DOJ is unable to determine if there are any subsequent felony convictions for this registrant at this time.
GRAY/PARTIAL
MALE
WHITE
10998364C4308
240
12-24-1953
5'11"
GREEN
DOJ is unable to determine if there are any subsequent felony convictions for this registrant at this time.
BROWN
MALE
UKNOWN
11001361F6914
195
03-09-1963
5'11"
BLUE
DOJ is unable to determine if there are any subsequent felony convictions for this registrant at this time.
BROWN
MALE
WHITE
11007212L4989
TRANSIENT
160
08-23-1980
5'7"
BROWN
DOJ is unable to determine if there are any subsequent felony convictions for this registrant at this time.
BLACK
MALE
PACIFIC ISLANDER
11100362E6751
220
05-03-1977
6'4"
HAZEL
DOJ is unable to determine if there are any subsequent felony convictions for this registrant at this time.
BLOND/STRAWB
MALE
WHITE

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (832 KB) Use the API

rows 10 / 1471

addresses uniqueid
, MANTECA, 95337
10401090E9417
1046 LOURENCE DR, TRACY, 95376
10401096E9503
658 ARGONAUT ST, MANTECA, 95336
10406330L0067
930 SULTANA DR, TRACY, 95376
10408199M2756
186 SHADYWOOD AVE, LATHROP, 95330
10903188I0046
176 TREVINO AV, MANTECA, 95337
10904093I6963
1694 RAY WISE LN, TRACY, 95376
10998364C4308
10 20TH ST, TRACY, 95376
11001361F6914
,
11007212L4989
309 JESSIE AVE, MANTECA, 95337
11100362E6751

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (832 KB) Use the API

rows 10 / 2727

alias uniqueid
SUMPTER, MARK T
10401090E9417
SUMPTER, MARK TROY
10401090E9417
HERNAN, HERNAN R
10401096E9503
TORRES, HERMAN ROMON
10401096E9503
VALASQUES, RENALDO
10401096E9503
VELADQUEZ, HERNAN RAMON
10401096E9503
VELASQUEL, HERNAN RAYMOND
10401096E9503
VELASQUES, HERNAN R
10401096E9503
VELASQUEZ, HERMAN R
10401096E9503
VELASQUEZ, HERMAN RAMON
10401096E9503

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (832 KB) Use the API

rows 10 / 3562

uniqueid marks
10401090E9417
None
10401096E9503
ARM, LEFT, NONSPECIFIC
10401096E9503
FOREARM, RIGHT
10401096E9503
ARM, RIGHT, NONSPECIFIC
10401096E9503
FOREARM, LEFT
10406330L0067
SHOULDER, LEFT
10408199M2756
None
10903188I0046
ARM, RIGHT UPPER
10903188I0046
ARM, LEFT UPPER
10904093I6963
FOREHEAD

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (832 KB) Use the API

rows 1 / 1

value_blob type name
0
integer
startingvalue

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (832 KB) Use the API

rows 10 / 1978

lastconviction code lastrelease description uniqueid
288(c)(1)
LEWD OR LASCIVIOUS ACTS WITH A CHILD 14 OR 15 YEARS OF AGE AND OFFENDER 10 OR MORE YEARS OLDER THAN VICTIM
10401090E9417
288(c)(1)
LEWD OR LASCIVIOUS ACTS WITH A CHILD 14 OR 15 YEARS OF AGE AND OFFENDER 10 OR MORE YEARS OLDER THAN VICTIM
10401096E9503
288(c)(1)
LEWD OR LASCIVIOUS ACTS WITH A CHILD 14 OR 15 YEARS OF AGE AND OFFENDER 10 OR MORE YEARS OLDER THAN VICTIM
10406330L0067
288(c)(1)
LEWD OR LASCIVIOUS ACTS WITH A CHILD 14 OR 15 YEARS OF AGE AND OFFENDER 10 OR MORE YEARS OLDER THAN VICTIM
10408199M2756
288(c)(1)
LEWD OR LASCIVIOUS ACTS WITH A CHILD 14 OR 15 YEARS OF AGE AND OFFENDER 10 OR MORE YEARS OLDER THAN VICTIM
10903188I0046
288(a)
LEWD OR LASCIVIOUS ACTS WITH A CHILD UNDER 14 YEARS OF AGE
10904093I6963
288(a)
LEWD OR LASCIVIOUS ACTS WITH A CHILD UNDER 14 YEARS OF AGE
10998364C4308
289(j)
SEX PENETRATION WITH FOREIGN OBJECT OF VICTIM UNDER 14 YEARS OF AGE
10998364C4308
288(c)(1)
LEWD OR LASCIVIOUS ACTS WITH A CHILD 14 OR 15 YEARS OF AGE AND OFFENDER 10 OR MORE YEARS OLDER THAN VICTIM
11001361F6914
288(c)(1)
LEWD OR LASCIVIOUS ACTS WITH A CHILD 14 OR 15 YEARS OF AGE AND OFFENDER 10 OR MORE YEARS OLDER THAN VICTIM
11007212L4989

Statistics

Total run time: less than 5 seconds

Total cpu time used: less than 5 seconds

Total disk space used: 857 KB

History

  • Manually ran revision efcc473d and failed .
    1 record added, 1 record removed in the database
  • Manually ran revision 92a199b6 and failed .
    1 record added, 1 record removed in the database
  • Forked from ScraperWiki

Scraper code

Python

california_detail / scraper.py