Sex Offenders

City of Chicago

@usgov.city_of_chicago_sex_offenders

Table List

1 table(112.95 KB)

Table 1

@usgov.city_of_chicago_sex_offenders.table_1

112.95 KB
3860 rows
9 columns

last LAST	first FIRST	block BLOCK	gender GENDER	race RACE	birth_date BIRTH DATE	height HEIGHT	weight WEIGHT	victim_minor VICTIM MINOR
WILLIAMS	GLYNN	086XX S COLFAX AVE	MALE	BLACK	Tue Jul 03 1962 00:00:00 GMT+0000 (Coordinated Universal Time)	509	189	Y
CHRISTIANSEN	DWIGHT	004XX N WABASH AVE	MALE	WHITE	Sat Sep 26 1959 00:00:00 GMT+0000 (Coordinated Universal Time)	600	190	Y
OCANA	CUITLAHUAC	054XX N ARTESIAN AVE	MALE	WHITE HISPANIC	Mon Mar 02 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	507	140	Y
VERDINO	LAWRENCE	054XX W BARRY AVE	MALE	WHITE	Thu Sep 26 1957 00:00:00 GMT+0000 (Coordinated Universal Time)	510	230	Y
DUKES	TIMOTHY	(registered as homeless)	MALE	BLACK	Thu Dec 20 1990 00:00:00 GMT+0000 (Coordinated Universal Time)	508	125	Y
GASCOIGNE	DUSTIN	11XXX S STATE ST	MALE	WHITE	Thu Sep 17 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	511	208	Y
BARNETT	UNDERWOOD	014XX W 73RD ST	MALE	BLACK	Sat Jul 31 1948 00:00:00 GMT+0000 (Coordinated Universal Time)	510	175	Y
SCOTT	ELROY	008XX W 51ST PL	MALE	BLACK	Tue Jul 14 1959 00:00:00 GMT+0000 (Coordinated Universal Time)	506	205	Y
GUSTAFSON	CARL	044XX S SPAULDING AVE	MALE	WHITE	Wed Nov 26 1969 00:00:00 GMT+0000 (Coordinated Universal Time)	511	260	N
MACIAS	SALVADOR	022XX S ELMWOOD	MALE	WHITE HISPANIC	Mon Sep 18 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	509	220	Y


CREATE TABLE table_1 (
  "last" VARCHAR,
  "first" VARCHAR,
  "block" VARCHAR,
  "gender" VARCHAR,
  "race" VARCHAR,
  "birth_date" TIMESTAMP,
  "height" BIGINT,
  "weight" BIGINT,
  "victim_minor" VARCHAR
);