Homicide Reports, 1980-2014

Can you develop an algorithm to detect serial killer activity?

@kaggle.murderaccountability_homicide_reports

Table List

1 table(8.59 MB)

Database

@kaggle.murderaccountability_homicide_reports.database

8.59 MB
638454 rows
24 columns

record_id Record ID	agency_code Agency Code	agency_name Agency Name	agency_type Agency Type	city City	state State	year Year	month Month	incident Incident	crime_type Crime Type	crime_solved Crime Solved	victim_sex Victim Sex	victim_age Victim Age	victim_race Victim Race	victim_ethnicity Victim Ethnicity	perpetrator_sex Perpetrator Sex	perpetrator_age Perpetrator Age	perpetrator_race Perpetrator Race	perpetrator_ethnicity Perpetrator Ethnicity	relationship Relationship	weapon Weapon	perpetrator_count Perpetrator Count	record_source Record Source
1	AK00101	Anchorage	Municipal Police	Anchorage	Alaska	1980	January	1	Murder or Manslaughter	Yes	Male	14	Native American/Alaska Native	Unknown	Male	15	Native American/Alaska Native	Unknown	Acquaintance	Blunt Object		FBI
2	AK00101	Anchorage	Municipal Police	Anchorage	Alaska	1980	March	1	Murder or Manslaughter	Yes	Male	43	White	Unknown	Male	42	White	Unknown	Acquaintance	Strangulation		FBI
3	AK00101	Anchorage	Municipal Police	Anchorage	Alaska	1980	March	2	Murder or Manslaughter	No	Female	30	Native American/Alaska Native	Unknown	Unknown	0	Unknown	Unknown	Unknown	Unknown		FBI
4	AK00101	Anchorage	Municipal Police	Anchorage	Alaska	1980	April	1	Murder or Manslaughter	Yes	Male	43	White	Unknown	Male	42	White	Unknown	Acquaintance	Strangulation		FBI
5	AK00101	Anchorage	Municipal Police	Anchorage	Alaska	1980	April	2	Murder or Manslaughter	No	Female	30	Native American/Alaska Native	Unknown	Unknown	0	Unknown	Unknown	Unknown	Unknown	1	FBI
6	AK00101	Anchorage	Municipal Police	Anchorage	Alaska	1980	May	1	Murder or Manslaughter	Yes	Male	30	White	Unknown	Male	36	White	Unknown	Acquaintance	Rifle		FBI
7	AK00101	Anchorage	Municipal Police	Anchorage	Alaska	1980	May	2	Murder or Manslaughter	Yes	Female	42	Native American/Alaska Native	Unknown	Male	27	Black	Unknown	Wife	Knife		FBI
8	AK00101	Anchorage	Municipal Police	Anchorage	Alaska	1980	June	1	Murder or Manslaughter	Yes	Female	99	White	Unknown	Male	35	White	Unknown	Wife	Knife		FBI
9	AK00101	Anchorage	Municipal Police	Anchorage	Alaska	1980	June	2	Murder or Manslaughter	No	Male	32	White	Unknown	Unknown	0	Unknown	Unknown	Unknown	Firearm		FBI
10	AK00101	Anchorage	Municipal Police	Anchorage	Alaska	1980	June	3	Murder or Manslaughter	Yes	Male	38	White	Unknown	Male	40	Unknown	Unknown	Unknown	Firearm	1	FBI


CREATE TABLE database (
  "record_id" BIGINT,
  "agency_code" VARCHAR,
  "agency_name" VARCHAR,
  "agency_type" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "year" BIGINT,
  "month" VARCHAR,
  "incident" BIGINT,
  "crime_type" VARCHAR,
  "crime_solved" VARCHAR,
  "victim_sex" VARCHAR,
  "victim_age" BIGINT,
  "victim_race" VARCHAR,
  "victim_ethnicity" VARCHAR,
  "perpetrator_sex" VARCHAR,
  "perpetrator_age" VARCHAR,
  "perpetrator_race" VARCHAR,
  "perpetrator_ethnicity" VARCHAR,
  "relationship" VARCHAR,
  "weapon" VARCHAR,
  "victim_count" BIGINT,
  "perpetrator_count" BIGINT,
  "record_source" VARCHAR
);