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 Aug22

@kaggle.karnikakapoor_sex_offender_registry.sex_offender_registry_aug22

182.65 KB
1304 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
-77.0288527085689	38.9170092677456	1003216	397498	138793	2022/08/24 10:10:34+00	001-828	2009/06/26 13:36:09+00	LEWIS	JOSEPH	JOSEPH LECONTE LEWIS / KEITH LEWIS	B	1964/03/03 05:00:00+00	67	150	BROWN	BLACK	nan	2009/06/26 04:00:00+00	WORK	3	305	1200 BLOCK U STREET NW	NW	20009	{E6FAE444-77BC-0605-E053-782F520AC802}	38.917	-77.028852
-77.0346026717455	38.9325740834947	1003521	397000	140521	2022/08/24 10:10:34+00	001-830	2010/12/13 15:31:03+00	EWING	MALCOLM	MALCOLM SCOTT EWING	B	1964/07/03 04:00:00+00	72	195	BROWN	BROWN	nan	2010/12/13 05:00:00+00	WORK	4	408	1400 BLOCK NEWTON STREET NW	NW	20010	{E6FAE444-77BD-0605-E053-782F520AC802}	38.932567	-77.034601
-77.023097045812	38.9472964760023	1003522	397998	142155	2022/08/24 10:10:34+00	001-830	2010/12/13 15:31:03+00	EWING	MALCOLM	MALCOLM SCOTT EWING	B	1964/07/03 04:00:00+00	72	195	BROWN	BROWN	nan	2010/12/13 05:00:00+00	HOME	4	407	700 BLOCK CRITTENDEN STREET NW	NW	20011	{E6FAE444-77BE-0605-E053-782F520AC802}	38.947293	-77.023095
-76.9269938885654	38.8890551067441	1003523	406334	135692	2022/08/24 10:10:34+00	001-851	2011/11/09 16:11:40+00	MATTHEWS	EVERETT	nan	A	1966/05/12 04:00:00+00	67	190	BROWN	BLACK	nan	2011/11/09 05:00:00+00	HOME	6	604	UNIT BLOCK 52ND STREET SE	SE	20019	{E6FAE444-77BF-0605-E053-782F520AC802}	38.889048	-76.926986
-77.0345776211398	38.9047023169554	1003524	397001	137427	2022/08/24 10:10:34+00	001-856	2010/09/15 18:30:50+00	MORGAN	SHEPARD	BUTCH CROMER / BUTCH MORGAN / QUANTICO MORGAN / SHEPARD DAVIS MORGAN / SHEPPY MORGAN / SHEPPY DVID MORGAN	A	1954/05/27 04:00:00+00	71	215	BROWN	BALD	nan	2010/09/21 04:00:00+00	WORK	2	207	1100 BLOCK 15TH STREET NW	NW	20005	{E6FAE444-77C0-0605-E053-782F520AC802}	38.904692	-77.034573
-76.9560762136881	38.8871959197465	1003525	403811	135484	2022/08/24 10:10:34+00	001-856	2010/09/15 18:30:50+00	MORGAN	SHEPARD	BUTCH CROMER / BUTCH MORGAN / QUANTICO MORGAN / SHEPARD DAVIS MORGAN / SHEPPY MORGAN / SHEPPY DVID MORGAN	A	1954/05/27 04:00:00+00	71	215	BROWN	BALD	nan	2010/09/21 04:00:00+00	HOME	6	603	200 BLOCK 35TH STREET SE	SE	20019	{E6FAE444-77C1-0605-E053-782F520AC802}	38.88719	-76.956074
-76.9938167168728	38.8414412614897	1003526	400537	130404	2022/08/24 10:10:34+00	001-863	2012/12/10 05:00:00+00	SIMMS	VICTOR	nan	A	1969/06/22 04:00:00+00	68	190	BROWN	BLACK	nan	2007/04/10 04:00:00+00	WORK	7	705	3300 BLOCK WHEELER ROAD SE	SE	20032	{E6FAE444-77C2-0605-E053-782F520AC802}	38.84143	-76.993816
-77.0101710137915	38.8252077336934	1003527	399117	128602	2022/08/24 10:10:34+00	001-871	2010/12/13 22:08:31+00	COVINGTON	KENNETH	KENNY / KENNETH COVINGTON	A	1961/08/07 04:00:00+00	71	210	BROWN	BLACK	nan	2011/02/18 05:00:00+00	HOME	7	708	UNIT BLOCK FORRESTER STREET SW	SW	20032	{E6FAE444-77C3-0605-E053-782F520AC802}	38.825199	-77.010164
-77.0219124825602	38.8840491877475	1003528	398099	135134	2022/08/24 10:10:34+00	001-880	2012/12/10 05:00:00+00	FACUNDO	DAVID	nan	A	1965/06/08 04:00:00+00	69	180	BROWN	BROWN	nan	2007/06/14 04:00:00+00	WORK	1	103	400 BLOCK 7TH STREET SW	SW	20410	{E6FAE444-77C4-0605-E053-782F520AC802}	38.884038	-77.021907
-76.9844476387	38.9142642535394	1003529	401349	138488	2022/08/24 10:10:34+00	001-881	2012/02/15 21:49:36+00	ARROYO	RAMON	RAMON LUIS ARROYO-PEREZ	A	1971/09/20 04:00:00+00	67	220	BROWN	BLACK	nan	2012/02/16 05:00:00+00	WORK	5	506	1900 BLOCK FENWICK STREET NE	NE	20002	{E6FAE444-77C5-0605-E053-782F520AC802}	38.914259	-76.984444


CREATE TABLE sex_offender_registry_aug22 (
  "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
);