About this Dataset

Sex Offender Registry

Sex Offender work and home locations, created as part of the DC Geographic Information System (DC GIS) for the D.C. Office of the Chief Technology Officer (OCTO) and participating D.C. government agencies. If users want to obtain more information about sex offenders, they should go to the Sex Offender Mapping Application (https://sexoffender.dc.gov/) and download the “More Details” PDF. Data provided by the Court Services and Offender Supervision Agency identified sex offender registry providing location at the block level. https://www.csosa.gov/.
Organization: District of Columbia
Last updated: 2024-04-30T17:55:25.784927
Tags: cdw, court-services-and-offender-supervision-agency, crime, csosa, district-of-columbia, feeds, livedataset, metropolitan-police-department, open-data, sex-offenders, washington-dc

Tables

Table 1

@usgov.district_of_columbia_sex_offender_registry.table_1

212.57 kB
1,235 rows
33 columns

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
);