311 Service Requests

City of Chicago

@usgov.city_of_chicago_311_service_requests

Table List

1 table(696.96 MB)

Table 1

@usgov.city_of_chicago_311_service_requests.table_1

696.96 MB
11713647 rows
39 columns

sr_number SR NUMBER	sr_type SR TYPE	sr_short_code SR SHORT CODE	created_department CREATED DEPARTMENT	owner_department OWNER DEPARTMENT	status STATUS	origin ORIGIN	created_date CREATED DATE	last_modified_date LAST MODIFIED DATE	closed_date CLOSED DATE	street_address STREET ADDRESS	city CITY	state STATE	zip_code ZIP CODE	street_number STREET NUMBER	street_direction STREET DIRECTION	street_name STREET NAME	street_type STREET TYPE	legacy_record LEGACY RECORD	legacy_sr_number LEGACY SR NUMBER	community_area COMMUNITY AREA	ward WARD	electrical_district ELECTRICAL DISTRICT	electricity_grid ELECTRICITY GRID	police_sector POLICE SECTOR	police_district POLICE DISTRICT	police_beat POLICE BEAT	precinct PRECINCT	sanitation_division_days SANITATION DIVISION DAYS	created_hour CREATED HOUR	created_day_of_week CREATED DAY OF WEEK	created_month CREATED MONTH	x_coordinate X COORDINATE	y_coordinate Y COORDINATE	latitude LATITUDE	longitude LONGITUDE	location LOCATION
SR18-00181082	Street Light Pole Damage Complaint	SFK		CDOT - Department of Transportation	Completed	Phone Call	11/24/2018 09:40:37 AM	04/03/2025 08:20:07 AM	04/03/2025 08:20:07 AM	7797 W DEVON AVE	CHICAGO	IL	60631	7797	W	DEVON	AVE	true	CSR18-03215982	9	41	1	W106	1	16	1612	7	Monday	9	7	11	1123410.96996794	1941858.63998169	41.99689022872318	-87.82130157690764	(41.99689022872318, -87.82130157690764)
SR19-00067091	Street Light Pole Damage Complaint	SFK		CDOT - Department of Transportation	Completed	Phone Call	01/15/2019 06:35:38 AM	04/03/2025 08:24:00 AM	04/03/2025 08:24:00 AM	5540 W GOODMAN ST				5540	W	GOODMAN	ST				45								6	3	1
SR19-01133849	Sidewalk Inspection Request	PBS		CDOT - Department of Transportation	Completed	Internet	03/10/2019 11:36:45 AM	04/10/2025 01:26:57 PM	04/10/2025 01:26:57 PM	7340 W BRYN MAWR AVE			60631	7340	W	BRYN MAWR	AVE			10	41	1	X108	1	16	1612	43	Monday	11	1	3	1126268.064844	1936780.177305	41.98287620424388	-87.81099506841116	(41.98287620424388, -87.81099506841116)
SR19-01234163	Consumer Fraud Complaint	CSF		BACP - Business Affairs and Consumer Protection	Completed	Internet	03/28/2019 10:23:14 AM	03/28/2025 12:03:22 PM	03/28/2025 12:03:19 PM	5101 N SHERIDAN RD			60640	5101	N	SHERIDAN	RD			3	48		N010	2	20	2024	23		10	5	3	1168817.632132	1934388.137834	41.9754936971209	-87.65457632338163	(41.9754936971209, -87.65457632338163)
SR19-01236849	Sidewalk Inspection Request	PBS		CDOT - Department of Transportation	Completed	Internet	03/28/2019 04:10:49 PM	03/28/2025 09:30:48 AM	03/28/2025 09:30:48 AM	3159 S PRINCETON AVE			60616	3159	S	PRINCETON	AVE			34	11		P029	1	9	915	34		16	5	3	1174933.891644	1883765.548107	41.83644767556129	-87.63360338888594	(41.83644767556129, -87.63360338888594)
SR19-01284143	Traffic Signal Out Complaint	SFB		CDOT - Department of Transportation	Completed	Phone Call	04/06/2019 05:39:09 PM	02/22/2025 12:10:47 PM	02/22/2025 12:10:46 PM	5729 N CALIFORNIA AVE			60659	5729	N	CALIFORNIA	AVE			2	40		J008	1	20	2011	2		17	7	4	1156644.681525	1937960.676437	41.98555286162652	-87.69924337612233	(41.98555286162652, -87.69924337612233)
SR19-01630259	Street Light Pole Damage Complaint	SFK	CDOT - Department of Transportation	CDOT - Department of Transportation	Completed	Phone Call	06/04/2019 01:51:07 PM	04/03/2025 09:16:12 AM	04/03/2025 09:16:12 AM	5542 W LELAND AVE			60630	5542	W	LELAND	AVE			15	45		C011	2	16	1623	16		13	3	6	1138358.805413	1930662.699452	41.96587837315923	-87.76667601523656	(41.96587837315923, -87.76667601523656)
SR19-01800638	Street Light Pole Damage Complaint	SFK	Alderman	CDOT - Department of Transportation	Completed	Phone Call	06/26/2019 01:35:33 PM	04/03/2025 08:24:50 AM	04/03/2025 08:24:50 AM	4739 N MARIA CT			60656	4739	N	MARIA	CT			76	38		U111	1	16	1614	12		13	4	6	1118552.046021	1930714.009176	41.96635553325131	-87.83950224500296	(41.96635553325131, -87.83950224500296)
SR19-02035831	Traffic Signal Out Complaint	SFB	CDOT - Department of Transportation	CDOT - Department of Transportation	Completed	Phone Call	07/25/2019 09:49:54 AM	04/10/2025 01:47:09 PM	04/10/2025 01:47:09 PM	1700 S LAKE SHORE DR			60616	1700	S	LAKE SHORE	DR			33	4		R026	3	1	132	19		9	5	7	1179311.630024	1892022.505318	41.85900633756127	-87.61728736057661	(41.85900633756127, -87.61728736057661)
SR19-02038367	Traffic Signal Out Complaint	SFB	CDOT - Department of Transportation	CDOT - Department of Transportation	Completed	Phone Call	07/25/2019 01:37:37 PM	04/10/2025 01:17:33 PM	04/10/2025 01:17:33 PM	3500 S INDIANA AVE			60653	3500	S	INDIANA	AVE			35	3		Q030	1	2	212	23		13	5	7	1178166.02083	1881798.253622	41.83097640558052	-87.62180339763749	(41.830976405580515, -87.62180339763749)


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