About this Dataset

Intimate Partner Homicide Suicide In New York City (2010-2018)

The dataset contains count data for the number of intimate partner homicides and homicide-suicides that occurred in New York City from 2010 through 2018. The report provides information on the borough and month of occurrence; the relationship between the victim and the perpetrator; the sex of the victim; the location (residence/non-residence) where homicide-suicide occurred and the type of weapon used.
Organization: City of New York
Last updated: 2020-11-10T17:05:40.970830

Tables

Table 1

@usgov.city_of_new_york_intimate_partner_homicide_suicide_in__ccfe2990.table_1

47.06 kB
3 rows
63 columns

CREATE TABLE table_1 (
  "case_type" VARCHAR,
  "borough_bk" DOUBLE,
  "borough_bx" DOUBLE,
  "borough_mn" DOUBLE,
  "borough_qn" DOUBLE,
  "borough_si" DOUBLE,
  "vic_sex_female" BIGINT,
  "vic_sex_male" BIGINT,
  "vic_perp_relation_spouse" BIGINT,
  "vic_perp_relation_bgfriend" BIGINT,
  "vic_perp_relation_cl" BIGINT,
  "vic_perp_relation_exbgfriend" BIGINT,
  "vic_perp_relation_childc" BIGINT,
  "vic_perp_relation_samesex" BIGINT,
  "vic_perp_other" BIGINT,
  "loc_homicide_residence" BIGINT,
  "loc_homicide_residence_oth" BIGINT,
  "loc_homicide_out_residence" BIGINT,
  "weapon_gun" BIGINT,
  "weapon_sharpe_instrument" BIGINT,
  "weapon_blunt_trauma" BIGINT,
  "weapon_other" BIGINT,
  "hist_dv_dir" BIGINT,
  "hist_dv_cr" BIGINT,
  "hist_dv_aop" BIGINT,
  "hist_dv_op_oth" BIGINT,
  "month_jan" DOUBLE,
  "month_feb" DOUBLE,
  "month_mar" DOUBLE,
  "month_apr" DOUBLE,
  "month_may" DOUBLE,
  "month_jun" DOUBLE,
  "month_jul" DOUBLE,
  "month_aug" DOUBLE,
  "month_sep" DOUBLE,
  "month_oct" DOUBLE,
  "month_nov" DOUBLE,
  "month_dec" DOUBLE,
  "asc_contact_vic" DOUBLE,
  "acs_contact_vic" DOUBLE,
  "dfta_contact_vic" DOUBLE,
  "dhs_contact_vic" DOUBLE,
  "hra_contact_dv_vic" DOUBLE,
  "hra_contact_asst_vic" DOUBLE,
  "hra_contact_child_sup_vic" DOUBLE,
  "nycha_contact_vic" DOUBLE,
  "fjc_contact_vic" DOUBLE,
  "prob_contact_vic" DOUBLE,
  "asc_contact_perp" DOUBLE,
  "dfta_contact_perp" DOUBLE,
  "dhs_contact_perp" DOUBLE,
  "hra_contact_dv_perp" DOUBLE,
  "hra_contact_asst_perp" DOUBLE,
  "hra_contact_child_sup_perp" DOUBLE,
  "nycha_contact_perp" DOUBLE,
  "fjc_contact_perp" DOUBLE,
  "prob_contact_perp" DOUBLE,
  "circum_breakup" DOUBLE,
  "circum_abuse_behav" DOUBLE,
  "circum_threat_kill" DOUBLE,
  "cirucm_previous_threat" DOUBLE,
  "circum_stalked" DOUBLE,
  "cirucm_ment_health" DOUBLE
);