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 Feb2022
@kaggle.karnikakapoor_sex_offender_registry.sex_offender_registry_feb2022
- 188.55 KB
- 1347 rows
- 33 columns
xX | yY | objectidOBJECTID | block_xBLOCK X | block_yBLOCK Y | dcs_last_mod_dtmDCS LAST MOD DTM | sexoffendercodeSEXOFFENDERCODE | adddateADDDATE | lastnameLASTNAME | firstnameFIRSTNAME | aliasesALIASES | maxclassificationMAXCLASSIFICATION | birthdateBIRTHDATE | heightnumHEIGHTNUM | weightnumWEIGHTNUM | eyecolorEYECOLOR | haircolorHAIRCOLOR | markingsMARKINGS | registrationdateREGISTRATIONDATE | typeTYPE | districtDISTRICT | psaPSA | blocknameBLOCKNAME | quadrantQUADRANT | zipcodeZIPCODE | gis_idGIS ID | globalidGLOBALID | creatorCREATOR | createdCREATED | editorEDITOR | editedEDITED | latitudeLATITUDE | longitudeLONGITUDE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| -77.0326176206175 | 38.9045317219186 | 768068 | 397171 | 137408 | 2022/01/31 11:10:35+00 | 002-531 | 2015/02/27 23:26:17+00 | CLARK | ANTHONY | nan | B | 1976/12/21 05:00:00+00 | 70 | 205 | BROWN | BLACK | TATTOO ON BACK - PICTURES WITH "ONE LIFE"; TATTOO ON THE NECK - CLARK & RUSH"; TATTOO ON LEG - PICTURE OF PRAYING HANDS TATTOO NECK / TATTOO ARM, LEFT / TATTOO ARM, RIGHT / TATTOO LEG, LEFT / TATTOO BACK / SCAR NOSE | 2016/08/04 04:00:00+00 | SCHOOL | 2 | 207 | 1100 BLOCK VERMONT AVENUE NW | NW | 20005 | {D6DFD571-DB98-7EA6-E053-792F520A2B5B} | -77.032614 | -77.032614 | |||||
| -77.016379553127 | 38.881293528108 | 768069 | 398579 | 134828 | 2022/01/31 11:10:35+00 | 002-531 | 2015/02/27 23:26:17+00 | CLARK | ANTHONY | nan | B | 1976/12/21 05:00:00+00 | 70 | 205 | BROWN | BLACK | TATTOO ON BACK - PICTURES WITH "ONE LIFE"; TATTOO ON THE NECK - CLARK & RUSH"; TATTOO ON LEG - PICTURE OF PRAYING HANDS TATTOO NECK / TATTOO ARM, LEFT / TATTOO ARM, RIGHT / TATTOO LEG, LEFT / TATTOO BACK / SCAR NOSE | 2016/08/04 04:00:00+00 | HOME | 1 | 103 | 300 BLOCK G STREET SW | SW | 20024 | {D6DFD571-DB99-7EA6-E053-792F520A2B5B} | -77.016376 | -77.016376 | |||||
| -76.9798775524355 | 38.8875988135485 | 768070 | 401746 | 135528 | 2022/01/31 11:10:35+00 | 002-532 | 2015/02/27 23:36:52+00 | CHERRY | MICHAEL | MICHAEL TORY CHERRY | A | 1962/03/08 05:00:00+00 | 69 | 203 | BROWN | BALD | ? MARK C DOG TATTOO ARM, LEFT / TATTOO ARM, RIGHT | 2015/03/27 04:00:00+00 | WORK | 1 | 107 | 1700 BLOCK INDEPENDENCE AVENUE SE | SE | 20003 | {D6DFD571-DB9A-7EA6-E053-792F520A2B5B} | -76.97988 | -76.97988 | |||||
| -76.9629205688406 | 38.8691815018516 | 768071 | 403218 | 133484 | 2022/01/31 11:10:35+00 | 002-532 | 2015/02/27 23:36:52+00 | CHERRY | MICHAEL | MICHAEL TORY CHERRY | A | 1962/03/08 05:00:00+00 | 69 | 203 | BROWN | BALD | ? MARK C DOG TATTOO ARM, LEFT / TATTOO ARM, RIGHT | 2015/03/27 04:00:00+00 | HOME | 6 | 607 | 1700 BLOCK 31ST STREET SE | SE | 20020 | {D6DFD571-DB9B-7EA6-E053-792F520A2B5B} | -76.962921 | -76.962921 | |||||
| -77.0337735256546 | 38.9352407842121 | 768072 | 397072 | 140817 | 2022/01/31 11:10:35+00 | 002-541 | 2015/03/14 12:24:33+00 | SHEEHAN | PAUL | nan | B | 1970/03/31 04:00:00+00 | 74 | 275 | BLUE | BLONDE | LEFT ARM: USAF TATTOO ARM, LEFT | 2016/06/07 04:00:00+00 | HOME | 4 | 408 | 1400 BLOCK OTIS PLACE NW | NW | 20010 | {D6DFD571-DB9C-7EA6-E053-792F520A2B5B} | -77.033773 | -77.033773 | |||||
| -77.036488673109 | 38.9218536137488 | 768073 | 396836 | 139331 | 2022/01/31 11:10:35+00 | 002-541 | 2015/03/14 12:24:33+00 | SHEEHAN | PAUL | nan | B | 1970/03/31 04:00:00+00 | 74 | 275 | BLUE | BLONDE | LEFT ARM: USAF TATTOO ARM, LEFT | 2016/06/07 04:00:00+00 | WORK | 3 | 303 | 2400 BLOCK 16TH STREET NW | NW | 20009 | {D6DFD571-DB9D-7EA6-E053-792F520A2B5B} | -77.03649 | -77.03649 | |||||
| -76.9863625233388 | 38.9099675141992 | 768074 | 401183 | 138011 | 2022/01/31 11:10:35+00 | 002-550 | 2015/03/16 17:31:54+00 | CHILDS | LAVONE | LADON CHILDA / LADON CHILDS / LAVON C CHILDS / LAVON DECONTE CHILDS / LAVONE DECONTE CHILDS / LAVONE D CHILDS / LAVONED CHILDS / LONDON GREEN | B | 1982/11/05 04:00:00+00 | 74 | 180 | BROWN | BLACK | TATTOO ON THE NECK: LAUREN; TATTOO ON LEFT ARM: LAND; TATTOO ON RIGHT ARM: THE; TATTOO ON WRIST: PAPPU TATTOO WRIST, RIGHT / TATTOO NECK / TATTOO ARM, LEFT / TATTOO ARM, RIGHT | 2017/03/29 04:00:00+00 | HOME | 5 | 506 | 1700 BLOCK WEST VIRGINIA AVENUE NE | NE | 20018 | {D6DFD571-DB9E-7EA6-E053-792F520A2B5B} | -76.986365 | -76.986365 | |||||
| -76.9472117336109 | 38.903974841227 | 768075 | 404579 | 137347 | 2022/01/31 11:10:35+00 | 002-551 | 2015/03/19 18:12:51+00 | WALKER | RAY | nan | A | 1954/04/14 04:00:00+00 | 65 | 125 | BROWN | BLACK/GRAY | WALKS USING A CANE CANE | 2015/03/20 04:00:00+00 | HOME | 6 | 601 | 3500 BLOCK JAY STREET NE | NE | 20019 | {D6DFD571-DB9F-7EA6-E053-792F520A2B5B} | -76.947206 | -76.947206 | |||||
| -77.0136512295449 | 38.8977161504553 | 768076 | 398816 | 136651 | 2022/01/31 11:10:35+00 | 002-552 | 2015/03/21 15:55:18+00 | FREELAND | MILBON | nan | A | 1963/01/06 05:00:00+00 | 67 | 150 | BROWN | BALD | nan | 2015/03/24 04:00:00+00 | HOME | 1 | 102 | 500 BLOCK 2ND STREET NW | NW | 20001 | {D6DFD571-DBA0-7EA6-E053-792F520A2B5B} | -77.013653 | -77.013653 | |||||
| -76.9865575522655 | 38.9151563405808 | 768077 | 401166 | 138587 | 2022/01/31 11:10:35+00 | 002-555 | 2015/03/21 16:22:07+00 | WALLACE | CHRISTOPHER | nan | A | 1984/11/09 05:00:00+00 | 71 | 195 | BROWN | BLACK | LEFT HAND - STAR RIGHT HAND - "GOD'S SON" LEFT ARM - PANTHER RIGHT ARM - "CHRIS" CHEST - WOLF LEFT SHOULDER - PRAYING HANDS RIGHT SHOULDER - "TEAM" TATTOO ARM, LEFT / TATTOO ARM, RIGHT / TATTOO HAND, LEFT / TATTOO HAND, RIGHT / TATTOO CHEST | 2020/09/24 04:00:00+00 | HOME | 5 | 506 | 1200 BLOCK NEW YORK AVENUE NE | NE | 20002 | {D6DFD571-DBA1-7EA6-E053-792F520A2B5B} | -76.986557 | -76.986557 |
CREATE TABLE sex_offender_registry_feb2022 (
"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
);