About this Dataset

311 Service Requests

311 Service Requests received by the City of Chicago. This dataset includes requests created after the launch of the new 311 system on 12/18/2018 and some records from the previous system, indicated in the LEGACY_RECORD column. For purposes of all columns indicating geographic areas or locations, please note that requests of the type 311 INFORMATION ONLY CALL often are entered with the address of the City's 311 Center.
Organization: City of Chicago
Last updated: 2020-11-10T16:55:31.139399
Tags: 311, service-requests

Tables

Table 1

@usgov.city_of_chicago_311_service_requests.table_1

730.81 MB
11,713,647 rows
39 columns

CREATE TABLE table_1 (
  "sr_number" VARCHAR,
  "sr_type" VARCHAR,
  "sr_short_code" VARCHAR,
  "created_department" VARCHAR,
  "owner_department" VARCHAR,
  "status" VARCHAR,
  "origin" VARCHAR,
  "created_date" VARCHAR,
  "last_modified_date" VARCHAR,
  "closed_date" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" VARCHAR,
  "street_number" VARCHAR,
  "street_direction" VARCHAR,
  "street_name" VARCHAR,
  "street_type" VARCHAR,
  "duplicate" BOOLEAN,
  "legacy_record" BOOLEAN,
  "legacy_sr_number" VARCHAR,
  "parent_sr_number" VARCHAR,
  "community_area" DOUBLE,
  "ward" DOUBLE,
  "electrical_district" DOUBLE,
  "electricity_grid" VARCHAR,
  "police_sector" DOUBLE,
  "police_district" DOUBLE,
  "police_beat" DOUBLE,
  "precinct" DOUBLE,
  "sanitation_division_days" VARCHAR,
  "created_hour" BIGINT,
  "created_day_of_week" BIGINT,
  "created_month" BIGINT,
  "x_coordinate" DOUBLE,
  "y_coordinate" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);