Sex Offender Registry

District of Columbia

@usgov.district_of_columbia_sex_offender_registry

Table List

1 table(207.58 KB)

Table 1

@usgov.district_of_columbia_sex_offender_registry.table_1

207.58 KB
1235 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
400261	140498	2179143	400261	140498	Mon May 05 2025 10:10:38 GMT+0000 (Coordinated Universal Time)	002-069	Fri Dec 14 2012 16:13:34 GMT+0000 (Coordinated Universal Time)	STENGEL	NICHOLAS	NICHOLAS ALAN STENGEL / NICHOLAS JOACHIM STENGEL / NICHOLAS ALAN JOACHIM STENGEL / NICK UNK	B	Tue Jul 10 1973 04:00:00 GMT+0000 (Coordinated Universal Time)	72	210	HAZEL	BROWN		Fri Dec 21 2012 05:00:00 GMT+0000 (Coordinated Universal Time)	WORK	5	502	600 BLOCK MONROE STREET NE	NE	20017	{3461B62A-A72C-2AC2-E063-792F520AA3BA}	38.932364	-76.996991
406139	137111	2179144	406139	137111	Mon May 05 2025 10:10:38 GMT+0000 (Coordinated Universal Time)	002-077	Wed Dec 26 2012 21:01:12 GMT+0000 (Coordinated Universal Time)	LOGGINS	KENT	ADAM KENT LOGGINS / ADAM K LOGGINS / KENT ADAMS LOGGINS	A	Mon May 02 1966 04:00:00 GMT+0000 (Coordinated Universal Time)	71	207	BROWN	BALD		Fri Nov 28 2014 05:00:00 GMT+0000 (Coordinated Universal Time)	HOME	6	608	4900 BLOCK JAY STREET NE	NE	20019	{3461B62A-A72D-2AC2-E063-792F520AA3BA}	38.901834	-76.929222
397318	139544	2179145	397318	139544	Mon May 05 2025 10:10:38 GMT+0000 (Coordinated Universal Time)	002-095	Mon Jan 14 2013 20:32:55 GMT+0000 (Coordinated Universal Time)	STRAWDER	GREGORY	STRAWDER GREGORY / BOBBY STRAWDER / ELLIS STRAWDER / ERIC STRAWDER / GREG STRAWDER / GREGGO STRAWDER / GREGORY LEE STRAWDER / GREGORY L STRAWDER / GREGORY STRAWDER / RONALD STRAWDER	A	Sat Jul 04 1959 04:00:00 GMT+0000 (Coordinated Universal Time)	76	219	BROWN	BLACK		Wed Oct 07 2015 04:00:00 GMT+0000 (Coordinated Universal Time)	HOME	3	304	1300 BLOCK EUCLID STREET NW	NW	20009	{3461B62A-A72E-2AC2-E063-792F520AA3BA}	38.923765	-77.030927
400385	136326	2179146	400385	136326	Mon May 05 2025 10:10:38 GMT+0000 (Coordinated Universal Time)	002-108	Thu Feb 07 2013 15:05:06 GMT+0000 (Coordinated Universal Time)	SHARP	DENNIS	DENNIS D SHARP / DENNIS SHARPE	B	Tue Mar 18 1952 04:00:00 GMT+0000 (Coordinated Universal Time)	67	200	HAZEL	BLACK	SUGICAL SCAR - BACK; SUGICAL SCAR - RIGHT SHOULDER; SUGICAL SCAR - LEFT ANKLE SCAR ANKLE, LEFT / SCAR ARM, RIGHT UPPER	Tue Feb 12 2013 05:00:00 GMT+0000 (Coordinated Universal Time)	HOME	1	108	700 BLOCK D STREET NE	NE	20002	{3461B62A-A72F-2AC2-E063-792F520AA3BA}	38.894784	-76.995565
402259	132858	2179147	402259	132858	Mon May 05 2025 10:10:38 GMT+0000 (Coordinated Universal Time)	002-114	Tue Feb 19 2013 14:25:32 GMT+0000 (Coordinated Universal Time)	WOOD	DAVON	DAVON WOOD	B	Mon Dec 31 1990 05:00:00 GMT+0000 (Coordinated Universal Time)	71	200	BROWN	BLACK		Tue Feb 19 2013 05:00:00 GMT+0000 (Coordinated Universal Time)	HOME	6	607	2300 BLOCK MARION BARRY AVENUE SE	SE	20020	{3461B62A-A730-2AC2-E063-792F520AA3BA}	38.863535	-76.973972
399951	139210	2179148	399951	139210	Mon May 05 2025 10:10:38 GMT+0000 (Coordinated Universal Time)	002-114	Tue Feb 19 2013 14:25:32 GMT+0000 (Coordinated Universal Time)	WOOD	DAVON	DAVON WOOD	B	Mon Dec 31 1990 05:00:00 GMT+0000 (Coordinated Universal Time)	71	200	BROWN	BLACK		Tue Feb 19 2013 05:00:00 GMT+0000 (Coordinated Universal Time)	WORK			2300 BLOCK 4TH STREET NE	NE	20002	{3461B62A-A731-2AC2-E063-792F520AA3BA}	38.920761	-77.000569
403859	135396	2179149	403859	135396	Mon May 05 2025 10:10:38 GMT+0000 (Coordinated Universal Time)	002-115	Thu Feb 28 2013 17:47:25 GMT+0000 (Coordinated Universal Time)	PEELE	FRED	FRED PEELE / FRED L PEELE	A	Tue Feb 04 1964 05:00:00 GMT+0000 (Coordinated Universal Time)	65	150	BROWN	BLACK/GRAY		Wed Dec 23 2020 05:00:00 GMT+0000 (Coordinated Universal Time)	HOME	6	603	3500 BLOCK MINNESOTA AVENUE SE	SE	20019	{3461B62A-A732-2AC2-E063-792F520AA3BA}	38.886397	-76.955516
397497	136959	2179150	397497	136959	Mon May 05 2025 10:10:38 GMT+0000 (Coordinated Universal Time)	002-115	Thu Feb 28 2013 17:47:25 GMT+0000 (Coordinated Universal Time)	PEELE	FRED	FRED PEELE / FRED L PEELE	A	Tue Feb 04 1964 05:00:00 GMT+0000 (Coordinated Universal Time)	65	150	BROWN	BLACK/GRAY		Wed Dec 23 2020 05:00:00 GMT+0000 (Coordinated Universal Time)	WORK	2	209	1200 BLOCK NEW YORK AVENUE NW	NW	20005	{3461B62A-A733-2AC2-E063-792F520AA3BA}	38.90048	-77.028853
399823	129355	2179151	399823	129355	Mon May 05 2025 10:10:38 GMT+0000 (Coordinated Universal Time)	002-118	Tue Mar 12 2013 16:12:29 GMT+0000 (Coordinated Universal Time)	DAWSON	ROGER	DANIEL THOMAS WHITE	A	Mon May 18 1959 04:00:00 GMT+0000 (Coordinated Universal Time)	66	169	BROWN	BLACK	MR. DAWSON CONFIRMED THAT HE HAS NO TATTOOS ON FRIDAY 3/28/2025. SCAR SCAR FOREHEAD / SCAR NECK / SCAR ELBOW, RIGHT / SCAR ELBOW, LEFT / SCAR FINGER(S), LEFT HAND	Mon Mar 18 2013 04:00:00 GMT+0000 (Coordinated Universal Time)	HOME	7	708	200 BLOCK VALLEY AVENUE SE	SE	20032	{3461B62A-A734-2AC2-E063-792F520AA3BA}	38.831983	-77.002037
398640	137185	2179152	398640	137185	Mon May 05 2025 10:10:38 GMT+0000 (Coordinated Universal Time)	002-122	Mon Mar 18 2013 17:09:21 GMT+0000 (Coordinated Universal Time)	SKINNER	SHAKIR	JAMAL SKINNER / SHAKIR SKINNER / SHAKIR M SKINNER / SHARIE MALIK SKINNER	A	Sat Feb 06 1993 05:00:00 GMT+0000 (Coordinated Universal Time)	72	150	BROWN	BLACK	TATTOO OF A STAR NEAR LEFT EYE; TATTOO NEAR RIGHT EYE OF A DOLLAR SIGN; TATTOO ON LEFT KNUCKLES 7133; TATTOO ON RIGHT HAND;GMC TATTOO CHEEK (FACE), LEFT / TATTOO CHEEK (FACE), RIGHT / TATTOO FINGER(S), LEFT HAND / TATTOO FINGER(S), RIGHT HAND	Mon Mar 18 2013 04:00:00 GMT+0000 (Coordinated Universal Time)	HOME	1	101	300 BLOCK K STREET NW	NW	20001	{3461B62A-A735-2AC2-E063-792F520AA3BA}	38.90252	-77.015677


CREATE TABLE table_1 (
  "x" BIGINT,
  "y" BIGINT,
  "objectid" BIGINT,
  "block_x" BIGINT,
  "block_y" BIGINT,
  "dcs_last_mod_dtm" TIMESTAMP,
  "sexoffendercode" VARCHAR,
  "adddate" TIMESTAMP,
  "lastname" VARCHAR,
  "firstname" VARCHAR,
  "aliases" VARCHAR,
  "maxclassification" VARCHAR,
  "birthdate" TIMESTAMP,
  "heightnum" BIGINT,
  "weightnum" BIGINT,
  "eyecolor" VARCHAR,
  "haircolor" VARCHAR,
  "markings" VARCHAR,
  "registrationdate" TIMESTAMP,
  "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
);