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 Nov22

@kaggle.karnikakapoor_sex_offender_registry.sex_offender_registry_nov22

181.44 KB
1288 rows
33 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	zipcode ZIPCODE	globalid GLOBALID	latitude LATITUDE	longitude LONGITUDE
-76.9250275843539	38.8845676858294	1095037	406505	135194	2022/11/15 11:10:37+00	004-366	2021/12/22 16:03:10+00	WYNN	RONALD	RONALD WYN / BOY WYNN	A	1957/01/07 05:00:00+00	68	180	BROWN	BLACK	nan	2022/01/12 05:00:00+00	HOME	6	604	5300 BLOCK C STREET SE	SE	20019	{ED8167D4-D37B-5038-E053-792F520A2494}	38.884557	-76.925021
-76.9865575522655	38.9151563405808	1095038	401166	138587	2022/11/15 11:10:37+00	004-367	2021/12/23 17:24:17+00	JEFFERSON	DONQUALE	DONQUALE DELMONTE JEFFERSON	B	1993/10/29 04:00:00+00	70	240	BROWN	BLACK	nan	2022/07/20 04:00:00+00	HOME	5	506	1200 BLOCK NEW YORK AVENUE NE	NE	20002	{ED8167D4-D37C-5038-E053-792F520A2494}	38.915145	-76.986557
-77.0013050555195	38.904689410363	1095039	399887	137425	2022/11/15 11:10:37+00	004-372	2021/12/28 19:28:09+00	HORN	MONTERAY	MONTERAY HORN / MONTERAY UNKNOWN HORN / MONTERAY ALI HORN / MONTREY UNKNOWN HORNE	B	1979/10/25 04:00:00+00	66	150	BROWN	RED	FRECKLES ON THE ARMS OUT LAW CHEST A PICTURE OF A CHILD COVERING THE ENTIRE CHEST TO INCLUDE THE LOWER NECK TATTOO ARM, RIGHT / TATTOO ARM, LEFT / TATTOO CHEST / TATTOO NECK	2022/08/23 04:00:00+00	HOME	5	501	1100 BLOCK ABBEY PLACE NE	NE	20002	{ED8167D4-D37D-5038-E053-792F520A2494}	38.904686	-77.001298
-76.9860273261196	38.9142194114033	1095040	401212	138483	2022/11/15 11:10:37+00	004-372	2021/12/28 19:28:09+00	HORN	MONTERAY	MONTERAY HORN / MONTERAY UNKNOWN HORN / MONTERAY ALI HORN / MONTREY UNKNOWN HORNE	B	1979/10/25 04:00:00+00	66	150	BROWN	RED	FRECKLES ON THE ARMS OUT LAW CHEST A PICTURE OF A CHILD COVERING THE ENTIRE CHEST TO INCLUDE THE LOWER NECK TATTOO ARM, RIGHT / TATTOO ARM, LEFT / TATTOO CHEST / TATTOO NECK	2022/08/23 04:00:00+00	WORK	5	506	1300 BLOCK OKIE STREET NE	NE	20002	{ED8167D4-D37E-5038-E053-792F520A2494}	38.914214	-76.98603
-76.9476551969867	38.8966602514109	1095041	404541	136535	2022/11/15 11:10:37+00	004-379	2022/01/07 12:17:48+00	MCLAUGHLIN	ANTONIO	nan	A	1976/02/29 05:00:00+00	63	165	BROWN	BLACK	nan	2022/06/30 04:00:00+00	HOME	6	602	4000 BLOCK MINNESOTA AVENUE NE	NE	20019	{ED8167D4-D37F-5038-E053-792F520A2494}	38.896656	-76.947648
-77.0144124373886	38.8995537649807	1095042	398750	136855	2022/11/15 11:10:37+00	004-412	2022/01/11 17:22:31+00	CATES	PATRICK	nan	B	1987/09/06 04:00:00+00	68	200	HAZEL	BROWN	UPPER BACK - GEOMETRIC DESIGN TATTOO BACK	2022/03/04 05:00:00+00	WORK			200 BLOCK MASSACHUSETTS AVENUE NW	NW	20001	{ED8167D4-D380-5038-E053-792F520A2494}	38.89955	-77.014407
-77.0058877219182	38.8337570638979	1095043	399489	129551	2022/11/15 11:10:37+00	004-451	2022/01/19 02:10:23+00	LEFTWICH	MICHAEL	nan	A	1975/02/24 05:00:00+00	69	210	BROWN	BLACK	ARM - SUPERMAN SYMBOL LEFT ARM - BLACK PANTHER ARM RIGHT - DESIGN RIGHT UPPER ARM - JESUS FIGHTING DEVIL RIGHT UPPER ARM - CROSS WITH BARBWIRE TATTOO ARM, NONSPECIFIC / TATTOO ARM, LEFT UPPER / TATTOO ARM, RIGHT / TATTOO ARM, RIGHT UPPER	2022/02/25 05:00:00+00	HOME	7	707	3800 BLOCK 1ST STREET SE	SE	20032	{ED8167D4-D381-5038-E053-792F520A2494}	38.833747	-77.005884
-76.9897371035197	38.8552148789743	1095044	400891	131933	2022/11/15 11:10:37+00	004-455	2022/01/20 23:30:46+00	MCQUEEN	STEVE	STEVE MCQUEEN	A	1967/01/05 05:00:00+00	67	215	BROWN	BLACK	FADED TATTOO FULL SLEEVES ON RIGHT AND LEFT ARM DOVE, CROSS. FAMILY FIRST AND MIKE TATTOO ARM, LEFT / TATTOO ARM, RIGHT / TATTOO NECK	2022/06/07 04:00:00+00	HOME	7	703	2400 BLOCK POMEROY ROAD SE	SE	20020	{ED8167D4-D382-5038-E053-792F520A2494}	38.855203	-76.989731
-76.976782585115	38.8704552660354	1095045	402015	133625	2022/11/15 11:10:37+00	004-456	2022/01/20 23:44:16+00	HILL	GARY	nan	A	1964/01/11 05:00:00+00	66	220	BROWN	BLACK/GRAY	nan	2022/03/21 04:00:00+00	HOME	6	607	1900 BLOCK MINNESOTA AVENUE SE	SE	20020	{ED8167D4-D383-5038-E053-792F520A2494}	38.870451	-76.976779
-76.9730892291445	38.9165593154334	1095046	402334	138743	2022/11/15 11:10:37+00	004-462	2022/01/27 14:44:49+00	EVANS	IVOR	IVOR A EVANS / IVOR ANTHONY EVANS / IVOR EVANS-BEY / MIKE MICHAEL ANTHONY GOMES	A	1950/06/17 04:00:00+00	69	160	BROWN	GRAY	nan	2022/02/14 05:00:00+00	HOME	5	503	1900 BLOCK BLADENSBURG ROAD NE	NE	20002	{ED8167D4-D384-5038-E053-792F520A2494}	38.916555	-76.973092


CREATE TABLE sex_offender_registry_nov22 (
  "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,
  "zipcode" BIGINT,
  "gis_id" VARCHAR,
  "globalid" VARCHAR,
  "creator" VARCHAR,
  "created" VARCHAR,
  "editor" VARCHAR,
  "edited" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);