IBM Data Science Chicago Assignment

A project with data from Chicago's education, census and crime

@kaggle.antonioskokiantonis_ibm_data_science_chicago_assignment

Table List

3 tables(249.69 KB)

Chicagocensusdata

Chicagocrimedata

Chicagopublicschools

Chicagocrimedata

@kaggle.antonioskokiantonis_ibm_data_science_chicago_assignment.chicagocrimedata

68.35 KB
533 rows
21 columns

id ID	case_number CASE NUMBER	date DATE	block BLOCK	iucr IUCR	primary_type PRIMARY TYPE	description DESCRIPTION	location_description LOCATION DESCRIPTION	arrest ARREST	beat BEAT	district DISTRICT	ward WARD	community_area_number COMMUNITY AREA NUMBER	fbicode FBICODE	x_coordinate X COORDINATE	y_coordinate Y COORDINATE	year YEAR	latitude LATITUDE	longitude LONGITUDE	location LOCATION
3512276	HK587712	Sat Aug 28 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	047XX S KEDZIE AVE	890	THEFT	FROM BUILDING	SMALL RETAIL STORE		911	9	14	58	6	1155838	1873050	2004	41.8074405	-87.70395585	(41.8074405, -87.703955849)
3406613	HK456306	Sat Jun 26 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	009XX N CENTRAL PARK AVE	820	THEFT	$500 AND UNDER	OTHER		1112	11	27	23	6	1152206	1906127	2004	41.89827996	-87.71640551	(41.898279962, -87.716405505)
8002131	HT233595	Mon Apr 04 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	043XX S WABASH AVE	820	THEFT	$500 AND UNDER	NURSING HOME/RETIREMENT HOME		221	2	3	38	6	1177436	1876313	2011	41.81593313	-87.62464213	(41.815933131, -87.624642127)
7903289	HT133522	Thu Dec 30 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	083XX S KINGSTON AVE	840	THEFT	FINANCIAL ID THEFT: OVER $300	RESIDENCE		423	4	7	46	6	1194622	1850125	2010	41.74366532	-87.56246276	(41.743665322, -87.562462756)
10402076	HZ138551	Tue Feb 02 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	033XX W 66TH ST	820	THEFT	$500 AND UNDER	ALLEY		831	8	15	66	6	1155240	1860661	2016	41.7734553	-87.70648047	(41.773455295, -87.706480471)
7732712	HS540106	Wed Sep 29 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	006XX W CHICAGO AVE	810	THEFT	OVER $500	PARKING LOT/GARAGE(NON.RESID.)		1323	12	27	24	6	1171668	1905607	2010	41.89644677	-87.64493868	(41.896446772, -87.644938678)
10769475	HZ534771	Wed Nov 30 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	050XX N KEDZIE AVE	810	THEFT	OVER $500	STREET		1713	17	33	14	6	1154133	1933314	2016	41.97284491	-87.70860008	(41.972844913, -87.708600079)
4494340	HL793243	Fri Dec 16 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	005XX E PERSHING RD	860	THEFT	RETAIL THEFT	GROCERY FOOD STORE	true	213	2	3	38	6	1180448	1879234	2005	41.82387989	-87.61350386	(41.823879885, -87.613503857)
3778925	HL149610	Fri Jan 28 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	100XX S WASHTENAW AVE	810	THEFT	OVER $500	STREET		2211	22	19	72	6	1160129	1838040	2005	41.71128051	-87.6891791	(41.711280513, -87.689179097)
3324217	HK361551	Thu May 13 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	033XX W BELMONT AVE	820	THEFT	$500 AND UNDER	SMALL RETAIL STORE		1733	17	35	21	6	1153590	1921084	2004	41.93929582	-87.71092344	(41.939295821, -87.710923442)


CREATE TABLE chicagocrimedata (
  "id" BIGINT,
  "case_number" VARCHAR,
  "date" TIMESTAMP,
  "block" VARCHAR,
  "iucr" VARCHAR,
  "primary_type" VARCHAR,
  "description" VARCHAR,
  "location_description" VARCHAR,
  "arrest" BOOLEAN,
  "domestic" BOOLEAN,
  "beat" BIGINT,
  "district" BIGINT,
  "ward" DOUBLE,
  "community_area_number" DOUBLE,
  "fbicode" VARCHAR,
  "x_coordinate" DOUBLE,
  "y_coordinate" DOUBLE,
  "year" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);