Crime Dataset

crime dataset u can analyze that

@kaggle.haseefalam_crime_dataset

Table List

1 table(39.67 MB)

Crime Data From 2020 To Present

@kaggle.haseefalam_crime_dataset.crime_data_from_2020_to_present

39.67 MB
955339 rows
28 columns

dr_no DR NO	date_rptd Date Rptd	date_occ DATE OCC	time_occ TIME OCC	area AREA	area_name AREA NAME	rpt_dist_no Rpt Dist No	part_1_2 Part 1-2	crm_cd Crm Cd	crm_cd_desc Crm Cd Desc	mocodes Mocodes	vict_age Vict Age	vict_sex Vict Sex	vict_descent Vict Descent	premis_cd Premis Cd	premis_desc Premis Desc	weapon_used_cd Weapon Used Cd	weapon_desc Weapon Desc	status Status	status_desc Status Desc	crm_cd_1 Crm Cd 1	crm_cd_2 Crm Cd 2	location LOCATION	cross_street Cross Street	lat LAT	lon LON
190326475	03/01/2020 12:00:00 AM	03/01/2020 12:00:00 AM	2130	7	Wilshire	784	1	510	VEHICLE - STOLEN	nan		M	O	101	STREET		nan	AA	Adult Arrest	510	998	1900 S LONGWOOD AV	nan	34.0375	-118.3506
200106753	02/09/2020 12:00:00 AM	02/08/2020 12:00:00 AM	1800	1	Central	182	1	330	BURGLARY FROM VEHICLE	1822 1402 0344	47	M	O	128	BUS STOP/LAYOVER (ALSO QUERY 124)		nan	IC	Invest Cont	330	998	1000 S FLOWER ST	nan	34.0444	-118.2628
200320258	11/11/2020 12:00:00 AM	11/04/2020 12:00:00 AM	1700	3	Southwest	356	1	480	BIKE - STOLEN	0344 1251	19	X	X	502	MULTI-UNIT DWELLING (APARTMENT, DUPLEX, ETC)		nan	IC	Invest Cont	480		1400 W 37TH ST	nan	34.021	-118.3002
200907217	05/10/2023 12:00:00 AM	03/10/2020 12:00:00 AM	2037	9	Van Nuys	964	1	343	SHOPLIFTING-GRAND THEFT ($950.01 & OVER)	0325 1501	19	M	O	405	CLOTHING STORE		nan	IC	Invest Cont	343		14000 RIVERSIDE DR	nan	34.1576	-118.4387
220614831	08/18/2022 12:00:00 AM	08/17/2020 12:00:00 AM	1200	6	Hollywood	666	2	354	THEFT OF IDENTITY	1822 1501 0930 2004	28	M	H	102	SIDEWALK		nan	IC	Invest Cont	354		1900 TRANSIENT	nan	34.0944	-118.3277
231808869	04/04/2023 12:00:00 AM	12/01/2020 12:00:00 AM	2300	18	Southeast	1826	2	354	THEFT OF IDENTITY	1822 0100 0930 0929	41	M	H	501	SINGLE FAMILY DWELLING		nan	IC	Invest Cont	354		9900 COMPTON AV	nan	33.9467	-118.2463
230110144	04/04/2023 12:00:00 AM	07/03/2020 12:00:00 AM	900	1	Central	182	2	354	THEFT OF IDENTITY	0930 0929	25	M	H	502	MULTI-UNIT DWELLING (APARTMENT, DUPLEX, ETC)		nan	IC	Invest Cont	354		1100 S GRAND AV	nan	34.0415	-118.262
220314085	07/22/2022 12:00:00 AM	05/12/2020 12:00:00 AM	1110	3	Southwest	303	2	354	THEFT OF IDENTITY	0100	27	F	B	248	CELL PHONE STORE		nan	IC	Invest Cont	354		2500 S SYCAMORE AV	nan	34.0335	-118.3537
231309864	04/28/2023 12:00:00 AM	12/09/2020 12:00:00 AM	1400	13	Newton	1375	2	354	THEFT OF IDENTITY	0100	24	F	B	750	CYBERSPACE		nan	IC	Invest Cont	354		1300 E 57TH ST	nan	33.9911	-118.2521
211904005	12/31/2020 12:00:00 AM	12/31/2020 12:00:00 AM	1220	19	Mission	1974	2	624	BATTERY - SIMPLE ASSAULT	0416	26	M	H	502	MULTI-UNIT DWELLING (APARTMENT, DUPLEX, ETC)	400	STRONG-ARM (HANDS, FIST, FEET OR BODILY FORCE)	IC	Invest Cont	624		9000 CEDROS AV	nan	34.2336	-118.4535


CREATE TABLE crime_data_from_2020_to_present (
  "dr_no" BIGINT,
  "date_rptd" VARCHAR,
  "date_occ" VARCHAR,
  "time_occ" BIGINT,
  "area" BIGINT,
  "area_name" VARCHAR,
  "rpt_dist_no" BIGINT,
  "part_1_2" BIGINT,
  "crm_cd" BIGINT,
  "crm_cd_desc" VARCHAR,
  "mocodes" VARCHAR,
  "vict_age" BIGINT,
  "vict_sex" VARCHAR,
  "vict_descent" VARCHAR,
  "premis_cd" DOUBLE,
  "premis_desc" VARCHAR,
  "weapon_used_cd" DOUBLE,
  "weapon_desc" VARCHAR,
  "status" VARCHAR,
  "status_desc" VARCHAR,
  "crm_cd_1" DOUBLE,
  "crm_cd_2" DOUBLE,
  "crm_cd_3" DOUBLE,
  "crm_cd_4" DOUBLE,
  "location" VARCHAR,
  "cross_street" VARCHAR,
  "lat" DOUBLE,
  "lon" DOUBLE
);