About this Dataset

Code Enforcement 20200101 To Current

This dataset contains Enforcement records from the following sources: Building Code Enforcement, Zoning Code Enforcement, Blight Remediation Team, Housing Code Enforcement, and Health and Human Services. It is downloaded to our Enterprise GIS database nightly from our cloud based Accela Permit system.
Organization: City of Hartford
Last updated: 2025-06-09T20:49:36.344170
Tags: code-enforcement, development, hartford-ct, housing

Tables

Table 1

@usgov.city_of_hartford_code_enforcement_20200101_to_current.table_1

1.88 MB
26685 rows
21 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "case_number" VARCHAR,
  "parcelid" VARCHAR,
  "address" VARCHAR,
  "unit" VARCHAR,
  "record_module" VARCHAR,
  "dept_division" VARCHAR,
  "record_name" VARCHAR,
  "record_type" VARCHAR,
  "record_status" VARCHAR,
  "date_opened" TIMESTAMP,
  "date_closed" TIMESTAMP,
  "property_owner" VARCHAR,
  "contact_first_name" VARCHAR,
  "contact_last_name" VARCHAR,
  "inspector_name" VARCHAR,
  "inspection_type" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" DOUBLE,
  "globalid" VARCHAR
);