About this Dataset

CDPH Environmental Complaints

Environmental complaints received by the Department of Environment (DOE) from January 1993 to December 31, 2011 and by the Department of Public Health (CDPH) since January 1, 2012. On January 1, 2012, the DOE was disbanded and all its inspection, permitting, and enforcement authorities were transferred to the CDPH.
Organization: City of Chicago
Last updated: 2020-11-10T16:54:55.058942
Tags: environmental-complaints, environmental-health

Tables

Table 1

@usgov.city_of_chicago_cdph_environmental_complaints.table_1

7.63 MB
61012 rows
17 columns


CREATE TABLE table_1 (
  "complaint_id" VARCHAR,
  "complaint_type" VARCHAR,
  "address" VARCHAR,
  "street_number_from" BIGINT,
  "street_number_to" DOUBLE,
  "direction" VARCHAR,
  "street_name" VARCHAR,
  "street_type" VARCHAR,
  "inspector" VARCHAR,
  "complaint_date" TIMESTAMP,
  "complaint_detail" VARCHAR,
  "data_source" VARCHAR,
  "resolution" VARCHAR,
  "resolved_date" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);