About this Dataset

311 Service Requests - Rodent Baiting - Historical

As described in https://data.cityofchicago.org/stories/s/311-Dataset-Changes-12-11-2018/d7nq-5g7t, the function of this dataset was replaced by https://data.cityofchicago.org/d/v6vf-nfxy. This dataset is historical-only.

All open rodent baiting requests and rat complaints made to 311 and all requests completed since January 1, 2011. The Department of Streets & Sanitation investigates reported rat sightings. Alley conditions are examined. If any damaged carts are identified, Sanitation Ward Offices, which distribute the carts are notified. Rodenticide is placed in rat burrows to eradicate nests. 311 sometimes receives duplicate rat complaints and requests for rodent baiting. Requests that have been labeled as Duplicates are in the same geographic area and have been entered into 311’s Customer Service Requests (CSR) system at around the same time as a previous request. Duplicate reports/requests are labeled as such in the Status field, as either "Open - Dup" or "Completed - Dup." Data is updated daily.
Organization: City of Chicago
Last updated: 2020-11-10T16:54:34.105931
Tags: 311, historical, rats, rodents, service-requests

Tables

Table 1

@usgov.city_of_chicago_311_service_requests_rodent_baiting_historical.table_1

22 MB
319,187 rows
20 columns

CREATE TABLE table_1 (
  "creation_date" TIMESTAMP,
  "status" VARCHAR,
  "completion_date" TIMESTAMP,
  "service_request_number" VARCHAR,
  "type_of_service_request" VARCHAR,
  "number_of_premises_baited" DOUBLE,
  "number_of_premises_with_garbage" DOUBLE,
  "number_of_premises_with_rats" DOUBLE,
  "current_activity" VARCHAR,
  "most_recent_action" VARCHAR,
  "street_address" VARCHAR,
  "zip_code" DOUBLE,
  "x_coordinate" DOUBLE,
  "y_coordinate" DOUBLE,
  "ward" DOUBLE,
  "police_district" DOUBLE,
  "community_area" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);