Los Angeles Crime Data

Reported crime in Los Angeles from 2020 to present

@kaggle.hemil26_crime_in_los_angeles

Table List

1 table(35.72 MB)

Crime In La

@kaggle.hemil26_crime_in_los_angeles.crime_in_la

35.72 MB
963006 rows
20 columns

dr_no DR NO	date_occ DATE OCC	time_occ TIME OCC	area AREA	area_name AREA NAME	rpt_dist_no Rpt Dist No	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_desc Premis Desc	weapon_used_cd Weapon Used Cd	weapon_desc Weapon Desc	status Status	status_desc Status Desc	location LOCATION	lat LAT	lon LON
190326475	Sun Mar 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	21:30	7	Wilshire	784	510	VEHICLE - STOLEN	0		M	O	STREET	500	UNKNOWN WEAPON/OTHER WEAPON	AA	Adult Arrest	1900 S LONGWOOD AV	34.0375	-118.3506
200106753	Sat Feb 08 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	18:00	1	Central	182	330	BURGLARY FROM VEHICLE	1822 1402 0344	47	M	O	BUS STOP/LAYOVER (ALSO QUERY 124)	500	UNKNOWN WEAPON/OTHER WEAPON	IC	Invest Cont	1000 S FLOWER ST	34.0444	-118.2628
200320258	Wed Nov 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	17:00	3	Southwest	356	480	BIKE - STOLEN	0344 1251	19	X	X	MULTI-UNIT DWELLING (APARTMENT, DUPLEX, ETC)	500	UNKNOWN WEAPON/OTHER WEAPON	IC	Invest Cont	1400 W 37TH ST	34.021	-118.3002
200907217	Tue Mar 10 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	20:37	9	Van Nuys	964	343	SHOPLIFTING-GRAND THEFT ($950.01 & OVER)	0325 1501	19	M	O	CLOTHING STORE	500	UNKNOWN WEAPON/OTHER WEAPON	IC	Invest Cont	14000 RIVERSIDE DR	34.1576	-118.4387
220614831	Mon Aug 17 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	12:00	6	Hollywood	666	354	THEFT OF IDENTITY	1822 1501 0930 2004	28	M	H	SIDEWALK	500	UNKNOWN WEAPON/OTHER WEAPON	IC	Invest Cont	1900 TRANSIENT	34.0944	-118.3277
231808869	Tue Dec 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	23:00	18	Southeast	1826	354	THEFT OF IDENTITY	1822 0100 0930 0929	41	M	H	SINGLE FAMILY DWELLING	500	UNKNOWN WEAPON/OTHER WEAPON	IC	Invest Cont	9900 COMPTON AV	33.9467	-118.2463
230110144	Fri Jul 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	09:00	1	Central	182	354	THEFT OF IDENTITY	0930 0929	25	M	H	MULTI-UNIT DWELLING (APARTMENT, DUPLEX, ETC)	500	UNKNOWN WEAPON/OTHER WEAPON	IC	Invest Cont	1100 S GRAND AV	34.0415	-118.262
220314085	Tue May 12 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	11:10	3	Southwest	303	354	THEFT OF IDENTITY	0100	27	F	B	CELL PHONE STORE	500	UNKNOWN WEAPON/OTHER WEAPON	IC	Invest Cont	2500 S SYCAMORE AV	34.0335	-118.3537
231309864	Wed Dec 09 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	14:00	13	Newton	1375	354	THEFT OF IDENTITY	0100	24	F	B	CYBERSPACE	500	UNKNOWN WEAPON/OTHER WEAPON	IC	Invest Cont	1300 E 57TH ST	33.9911	-118.2521
211904005	Thu Dec 31 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	12:20	19	Mission	1974	624	BATTERY - SIMPLE ASSAULT	0416	26	M	H	MULTI-UNIT DWELLING (APARTMENT, DUPLEX, ETC)	400	STRONG-ARM (HANDS, FIST, FEET OR BODILY FORCE)	IC	Invest Cont	9000 CEDROS AV	34.2336	-118.4535


CREATE TABLE crime_in_la (
  "dr_no" BIGINT,
  "date_occ" TIMESTAMP,
  "time_occ" VARCHAR,
  "area" BIGINT,
  "area_name" VARCHAR,
  "rpt_dist_no" BIGINT,
  "crm_cd" BIGINT,
  "crm_cd_desc" VARCHAR,
  "mocodes" VARCHAR,
  "vict_age" BIGINT,
  "vict_sex" VARCHAR,
  "vict_descent" VARCHAR,
  "premis_desc" VARCHAR,
  "weapon_used_cd" DOUBLE,
  "weapon_desc" VARCHAR,
  "status" VARCHAR,
  "status_desc" VARCHAR,
  "location" VARCHAR,
  "lat" DOUBLE,
  "lon" DOUBLE
);