Sex Offender Registry

DC Data On Sex Offenders (public domain)

@kaggle.karnikakapoor_sex_offender_registry

Table List

4 tables(709.77 KB)

Sex Offender Registry Aug22

Sex Offender Registry

Sex Offender Registry Feb2022

Sex Offender Registry Nov22

Sex Offender Registry

@kaggle.karnikakapoor_sex_offender_registry.sex_offender_registry

157.13 KB
1323 rows
25 columns

x X	y Y	objectid OBJECTID	block_x BLOCK X	block_y BLOCK Y	dcs_last_mod_dtm DCS LAST MOD DTM	sexoffendercode SEXOFFENDERCODE	adddate ADDDATE	lastname LASTNAME	firstname FIRSTNAME	aliases ALIASES	maxclassification MAXCLASSIFICATION	birthdate BIRTHDATE	heightnum HEIGHTNUM	weightnum WEIGHTNUM	eyecolor EYECOLOR	haircolor HAIRCOLOR	markings MARKINGS	registrationdate REGISTRATIONDATE	type TYPE	district DISTRICT	psa PSA	blockname BLOCKNAME	quadrant QUADRANT	zip ZIP
-76.9739743119999	38.8635423394491	4236689	402259	132858	2021/01/14 06:15:24+00	002-910	2016/08/02 09:34:44+00	SANDERS	ANTHONY	DERRICK JUICE / X JUICE / ANTHONY SANDERS / ANTHONY D SANDERS / ANTHONY DERRECK SANDERS / DERRICK SANDERS / JUICE SANDERS / WHISKEY SANDERS / WHISKEY SANDERS / ANTHONY SAUNDERS / ANTHONY DERRICK SAUNDERS / DERRICK SAUNDERS / JUICE SAUNDERS / X	A	1969/06/19 00:00:00+00	66	138	BROWN	BLACK	TATTOO-LEFT WRIST: CHINESE SYMBOL; RIGHT WRIST-CHINESE SYMBOL TATTOO WRIST, RIGHT / TATTOO WRIST, LEFT	2016/08/29 00:00:00+00	HOME	6	607	2300 - 2399 BLOCK OF GOOD HOPE ROAD SE	SE	20020
-76.972648106514	38.8574994567708	4236690	402374	132187	2021/01/14 06:15:24+00	002-913	2016/08/04 14:42:53+00	GAYLES	JERMAINE	ROBERT GAYLES / JERMAINE IRVIN / JERMAINE IRVING / JERMAINE BRANDON IRVING / JERMAINE B IRVING	B	1986/06/25 00:00:00+00	73	200	BROWN	BLACK	nan	2018/02/22 00:00:00+00	HOME	7	701	2300 - 2399 BLOCK OF AINGER PLACE SE	SE	20020
-76.9714511471898	38.9321298990851	4236691	402476	140472	2021/01/14 06:15:24+00	002-919	2016/08/09 18:06:15+00	HARRIS	REGINALD	REGINALD ELBERT HARRIS-WILLS	B	1995/02/12 00:00:00+00	67	157	BROWN	BLACK	TATTOO ON LOWER RIGHT ARM "LAMONT"; TATTOO ON UPPER RIGHT ARM "F.O.E" TATTOO ON RIGHT HAND "ANGEL"; TATTOO ON LOWER LEFT ARM "RIP KAWON" & "REDZ" TATTOO ARM, LEFT / TATTOO ARM, RIGHT / SCAR ARM, RIGHT / PIERCED EARS / TATTOO HAND, RIGHT	2016/10/20 00:00:00+00	HOME	5	503	2400 - 2499 BLOCK OF LAWRENCE STREET NE	NE	20018
-77.0106047845178	38.9140885141753	4236692	399080	138468	2021/01/14 06:15:24+00	002-927	2016/08/30 11:29:37+00	STRICKLAND	GARY	MELVIN	B	1967/01/22 00:00:00+00	74	245	BROWN	BLACK	TATTOO ON SHOULDER "TINA"; GUNSHOT WOUNDS ON BACK AND LOWER LEFT LEG TATTOO SHOULDER, RIGHT / SCAR FOREHEAD / GLASSES / SCAR BACK / SCAR LEG, LEFT	2016/09/01 00:00:00+00	HOME	3	308	1 - 99 BLOCK OF S STREET NW	NW	20001
-77.0219173366836	38.9133561833154	4236693	398099	138387	2021/01/14 06:15:24+00	002-928	2016/08/31 10:07:09+00	GANT	TIMOTHY	TIMOTHY GANT	B	1989/09/19 00:00:00+00	71	285	BROWN	BLACK	TATTOO ON LEFT SHOULDER 'PICTURE OF A CROSS WITH A CROWN WITH THUG LIFE WRITING"; TATTOO ON RIGHT ARM "PICTURE OF MICROPHONES TATTOO SHOULDER, LEFT / TATTOO ARM, RIGHT / PIERCED EARS	2017/02/09 00:00:00+00	WORK	3	308	1700 - 1799 BLOCK OF 7TH STREET NW	NW	20001
-77.0136556095569	38.8977136273374	4236694	398816	136651	2021/01/14 06:15:24+00	002-928	2016/08/31 10:07:09+00	GANT	TIMOTHY	TIMOTHY GANT	B	1989/09/19 00:00:00+00	71	285	BROWN	BLACK	TATTOO ON LEFT SHOULDER 'PICTURE OF A CROSS WITH A CROWN WITH THUG LIFE WRITING"; TATTOO ON RIGHT ARM "PICTURE OF MICROPHONES TATTOO SHOULDER, LEFT / TATTOO ARM, RIGHT / PIERCED EARS	2017/02/09 00:00:00+00	HOME	1	102	500 - 721 BLOCK OF 2ND STREET NW	NW	20001
-77.0704680418255	38.9620861241417	4236695	393893	143799	2021/01/14 06:15:24+00	002-933	2016/09/07 11:12:57+00	METZ	DUSTIN	nan	B	1983/06/14 00:00:00+00	70	155	BROWN	BROWN	TATTOOS- LEFT SHOULDER: PICTURE OF SAD MASK AND RIGHT SHOULDER: "BEFORE YOU START POINTING FINGERS MAKE SURE YOUR HANDS ARE CLEAN" TATTOO SHOULDER, LEFT / TATTOO SHOULDER, RIGHT	2016/09/09 00:00:00+00	WORK	2	201	3600 - 3699 BLOCK OF LEGATION STREET NW	NW	20015
-77.0742276123102	38.9625915932885	4236696	393567	143855	2021/01/14 06:15:24+00	002-933	2016/09/07 11:12:57+00	METZ	DUSTIN	nan	B	1983/06/14 00:00:00+00	70	155	BROWN	BROWN	TATTOOS- LEFT SHOULDER: PICTURE OF SAD MASK AND RIGHT SHOULDER: "BEFORE YOU START POINTING FINGERS MAKE SURE YOUR HANDS ARE CLEAN" TATTOO SHOULDER, LEFT / TATTOO SHOULDER, RIGHT	2016/09/09 00:00:00+00	HOME	2	201	5420 - 5499 BLOCK OF CONNECTICUT AVENUE NW	NW	20015
-76.9802704714244	38.8630355881353	4236697	401713	132801	2021/01/14 06:15:24+00	002-934	2016/09/07 11:53:03+00	DENSON	DARRELL	DARRELL DENSON / RENALDO DARRELL DENSON / RENALDO DURELL DENSON	A	1983/11/19 00:00:00+00	74	195	BROWN	BALD	nan	2017/10/06 00:00:00+00	HOME	7	701	1600 - 1899 BLOCK OF W STREET SE	SE	20005
-76.967661408213	38.9234457068378	4236698	402804	139508	2021/01/14 06:15:24+00	002-934	2016/09/07 11:53:03+00	DENSON	DARRELL	DARRELL DENSON / RENALDO DARRELL DENSON / RENALDO DURELL DENSON	A	1983/11/19 00:00:00+00	74	195	BROWN	BALD	nan	2017/10/06 00:00:00+00	WORK	5	503	2800 - 2808 BLOCK OF DOUGLAS STREET NE	NE	20018


CREATE TABLE sex_offender_registry (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "block_x" BIGINT,
  "block_y" BIGINT,
  "dcs_last_mod_dtm" VARCHAR,
  "sexoffendercode" VARCHAR,
  "adddate" VARCHAR,
  "lastname" VARCHAR,
  "firstname" VARCHAR,
  "aliases" VARCHAR,
  "maxclassification" VARCHAR,
  "birthdate" VARCHAR,
  "heightnum" BIGINT,
  "weightnum" BIGINT,
  "eyecolor" VARCHAR,
  "haircolor" VARCHAR,
  "markings" VARCHAR,
  "registrationdate" VARCHAR,
  "type" VARCHAR,
  "district" DOUBLE,
  "psa" DOUBLE,
  "blockname" VARCHAR,
  "quadrant" VARCHAR,
  "zip" BIGINT
);