About this Dataset

The Relationship Between Domestic Violence And Shooting Incidents In New York City

This data set contains New York City Police Department provided domestic violence incident data for calendar years 2020, 2021 and 2022. In addition, ENDGBV obtained through Open Data the number of shooting incidents for calendar years 2020, 2021 and 2022. The data includes counts of the number of domestic violence incidents, shooting incidents and the number of expected domestic violence incidents and shooting incidents by: race (American Indian/Alaska Native, Asian/Pacific Islander, Black, and White) and sex (male, female) for New York City, each borough (Bronx, Brooklyn, Manhattan, Queens and Staten Island). It also provides the count and rate of domestic violence and shooting incidents by police precinct. The expected number of domestic violence incidents and shooting incidents were calculated by taking the total number of actual domestic violence and shooting incidents for a given geography (New York City, the Bronx, Brooklyn, Manhattan, Queens and Staten Island) and proportioning them by demographic breakdown of the geographic area.
Organization: City of New York
Last updated: 2025-01-17T22:30:36.497357
Tags: domestic-violence, shootings

Tables

Table 1

@usgov.city_of_new_york_the_relationship_between_domestic_vio_4798b9b6.table_1

38.23 kB
83 rows
43 columns

CREATE TABLE table_1 (
  "police_precinct_geographic_location" VARCHAR,
  "location_type" VARCHAR,
  "shootings" BIGINT,
  "overall_dv" DOUBLE,
  "population" DOUBLE,
  "rate_population" DOUBLE,
  "shooting_rate" DOUBLE,
  "overall_dv_rate" DOUBLE,
  "actual_shootings_white" DOUBLE,
  "expected_shootings_white" DOUBLE,
  "actual_shootings_black" DOUBLE,
  "expected_shootings_black" DOUBLE,
  "actual_shootings_asian_pi" DOUBLE,
  "expected_shootings_asian_pi" DOUBLE,
  "actual_shootings_american_indian_an" DOUBLE,
  "expected_shootings_american_indian_an" DOUBLE,
  "actual_shootings_other" DOUBLE,
  "expected_shootings_other" DOUBLE,
  "actual_dirs_white" DOUBLE,
  "expected_dirs_white" DOUBLE,
  "actual_dirs_black" DOUBLE,
  "expected_dirs_black" DOUBLE,
  "actual_dirs_asian_pi" DOUBLE,
  "expected_dirs_asian_pi" DOUBLE,
  "actual_dirs_american_indian_an" DOUBLE,
  "expected_dirs_american_indian_an" DOUBLE,
  "actual_dirs_other" DOUBLE,
  "expected_dirs_other" DOUBLE,
  "nyc_population_white" DOUBLE,
  "nyc_population_black" DOUBLE,
  "nyc_population_asian_pi" DOUBLE,
  "nyc_population_american_indian_an" DOUBLE,
  "nyc_population_other" DOUBLE,
  "actual_shootings_male" DOUBLE,
  "expected_shootings_male" DOUBLE,
  "actual_shootings_female" DOUBLE,
  "expected_shootings_female" DOUBLE,
  "actual_dir_male" DOUBLE,
  "expected_dirs_male" DOUBLE,
  "actual_dirs_female" DOUBLE,
  "expected_dirs_female" DOUBLE,
  "nyc_population_male" DOUBLE,
  "nyc_population_female" DOUBLE
);