US Crime Data

USA Crimes News Data

@kaggle.johnybhiduri_us_crime_data

Table List

1 table(1.77 MB)

Us Crime Data

@kaggle.johnybhiduri_us_crime_data.us_crime_data

1.77 MB
6783 rows
8 columns

date Date	title Title	organization Organization	city City	state State	url URL	keyword Keyword	summary Summary
2/13/17 9:01	Pizza Hut driver who killed co-worker with shotgun found mentally competent	LGBTQ Nation	Phoenix	AZ	http://www.lgbtqnation.com/2017/02/man-accused-killing-co-worker-hate-crime-stands-trial/	nan	nan
2/13/17 9:37	Residents of NJ township receiving KKK promotional fliers	New York Daily News	nan	nan	http://www.nydailynews.com/news/national/residents-nj-township-receiving-kkk-promotional-fliers-article-1.2971317	nan	nan
2/13/17 15:37	House OKs bill to expand Kentucky's hate crimes law	FOX19	Cincinnati	OH	http://www.fox19.com/story/34494432/house-oks-bill-to-expand-kentuckys-hate-crimes-law	nan	nan
2/13/17 16:56	Amid Protests, 'Blue Lives Matter' Bill Passes Kentucky House	89.3 WFPL	Louisville	KY	http://wfpl.org/amid-protests-blue-lives-matter-bill-passes-state-house/	nan	nan
2/13/17 18:37	Lafourche inmates charged with hate crimes in jail attack	Daily Comet	Thibodaux	LA	http://www.dailycomet.com/news/20170213/lafourche-inmates-charged-with-hate-crimes-in-jail-attack	nan	nan
2/14/17 11:55	Police: Davis hate crime suspect had 'aspirations' to kill	Davis Enterprise	Davis	CA	http://www.davisenterprise.com/local-news/crime-fire-courts/arrest-made-in-davis-mosque-vandalism/	nan	nan
2/14/17 13:45	Fowler's 'Blue Lives Matter' bill is great tribute to our protectors, but...	Harrisburg Daily Register	Harrisburg	IL	http://www.dailyregister.com/news/20170214/fowlers-blue-lives-matter-bill-is-great-tribute-to-our-protectors-but	nan	nan
2/14/17 16:11	Arrest made after bacon strips left at California mosque	GoDanRiver.com	Danville	VA	http://www.godanriver.com/news/national/wire/arrest-made-after-bacon-strips-left-at-california-mosque/article_328bd862-8ba1-5277-91ad-8a9332604cd8.html	nan	nan
2/14/17 16:11	Arrest made after bacon strips left at California mosque - KSBY.com \| San Luis Obispo and Santa Barbara Area News	KSBY San Luis Obispo News	San Luis Obispo	CA	http://www.ksby.com/story/34505277/arrest-made-after-bacon-strips-left-at-california-mosque	nan	nan
2/14/17 18:15	Report: San Diego violent crime rates lowest in decades	San Diego Gay & Lesbian News	San Diego	CA	http://sdgln.com/commentary/2017/02/14/report-san-diego-violent-crime-rates-lowest-decades	nan	nan


CREATE TABLE us_crime_data (
  "date" VARCHAR,
  "title" VARCHAR,
  "organization" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "url" VARCHAR,
  "keyword" VARCHAR,
  "summary" VARCHAR
);