From a 83-row sample across 43 columns.
| police_precinct_geographic | location_type | shootings | overall_dv | population | rate_population | shooting_rate | overall_dv_rate |
|---|---|---|---|---|---|---|---|
| 1 | Police Precinct | 6 | 2375 | 74684 | 224052 | 0.27 | 106.00 |
| 5 | Police Precinct | 14 | 2529 | 52533 | 157599 | 0.89 | 160.47 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
police_precinct_geographic | text | The geographic area from which the data was collected | 0% | 509026 |
location_type | categorical | The geographic type from where the data was collected. | 0% | Police PrecinctBoroughNew York Cityof 3 |
shootings | integer | The number of shooting incidents reported to the NYPD. | 0% | 144124 |
overall_dv | integer | The number of domestic violence (DV) incident reports (DIRs) recorded by the NYPD | 1% | 104215501 |
GET /api/datasets/rvmf-4sg6 GET /api/datasets/rvmf-4sg6/quality GET /api/datasets/rvmf-4sg6/related GET /api/columns?dataset=rvmf-4sg6
| 6 |
| Police Precinct |
| 5 |
| 1282 |
| 63195 |
| 189585 |
| 0.26 |
| 67.62 |
| 7 | Police Precinct | 34 | 5530 | 58019 | 174057 | 1.95 | 317.71 |
| 9 | Police Precinct | 26 | 5376 | 78647 | 235941 | 1.10 | 227.85 |
| 10 | Police Precinct | 19 | 3522 | 59220 | 177660 | 1.07 | 198.24 |
| 13 | Police Precinct | 14 | 3112 | 96200 | 288600 | 0.49 | 107.83 |
| 14 | Police Precinct | 29 | 2969 | 24370 | 73110 | 3.97 | 406.10 |
| 17 | Police Precinct | 4 | 1885 | 82829 | 248487 | 0.16 | 75.86 |
| 18 | Police Precinct | 10 | 3105 | 60539 | 181617 | 0.55 | 170.96 |
8201population | integer | The population of the geographic location. | 1% | 752177059789676 |
rate_population | integer | The population size used to calculate the rate of a geographic location. | 1% | 5267131631377009371 |
shooting_rate | float | The rate of shootings for a geographic location | 1% | 0.170.161.23 |
overall_dv_rate | float | The rate of domestic violence (DV) for a given geographic location. | 1% | 220.71415.77118.72 |
actual_shootings_white | integer | The actual number of shooting incidents where the victim was White | 99% | 117of 1 |
expected_shootings_white | integer | The expected number of shooting incidents where the victim was White. | 99% | 1876of 1 |
actual_shootings_black | integer | The actual number of shooting incidents where the victim was Black. | 99% | 3950of 1 |
expected_shootings_black | integer | The expected number of shooting incidents where the victim was Black. | 99% | 1259of 1 |
actual_shootings_asian_pi | integer | The actual number of shooting incidents where the victim was Asian/Pacific Islander. | 99% | 115of 1 |
expected_shootings_asian | integer | The expected number of shooting incidents where the victim was Asian/Pacific Islander. | 99% | 831of 1 |
actual_shootings_american | integer | The actual number of shotting incidents where the victim was American Indian/Alaska Native. | 99% | 1of 1 |
expected_shootings_american | integer | The expected number of shotting incidents where the victim was American Indian/Alaska Native. | 99% | 10of 1 |
actual_shootings_other | integer | The actual number of shooting incidents where the victim was other race/ethnicity. | 99% | 1491of 1 |
expected_shootings_other | integer | The expected number of shooting incidents where the victim was other race/ethnicity. | 99% | 1698of 1 |
actual_dirs_white | integer | The actual number of DV incidents where the victim was White | 99% | 187099of 1 |
expected_dirs_white | integer | The expected number of DV incidents where the victim was White. | 99% | 190805of 1 |
actual_dirs_black | integer | The actual number of DV incidents where the victim was Black. | 99% | 292246of 1 |
expected_dirs_black | integer | The expected number of DV incidents where the victim was Black. | 99% | 128026of 1 |
actual_dirs_asian_pi | integer | The actual number of DV incidents where the victim was Asian/Pacific Islander. | 99% | 30629of 1 |
expected_dirs_asian_pi | integer | The expected number of DV incidents where the victim was Asian/Pacific Islander | 99% | 84472of 1 |
actual_dirs_american_indian | integer | The actual number of DV incidents where the victim was American Indian/Alaska Native. | 99% | 2761of 1 |
expected_dirs_american_indian | integer | The expected number of DV incidents where the victim was American Indian/Alaska Native. | 99% | 993of 1 |
actual_dirs_other | integer | The actual number of DV incidents where the victim was other race/ethnicity. | 99% | 64260of 1 |
expected_dirs_other | integer | The expected number of DV incidents where the victim was other race/ethnicity. | 99% | 172699of 1 |
nyc_pop_white | integer | The number of New York City residents who identify as White | 99% | 2677579of 1 |
nyc_pop_black | integer | The number of New York City residents who identify as Black | 99% | 1796602of 1 |
nyc_pop_asian_pi | integer | The number of New York City residents who identify as Asian/Pacific Islander | 99% | 1185400of 1 |
nyc_pop_american_indian_an | integer | The number of New York City residents who identify as American Indian/Alaskan Native | 99% | 13934of 1 |
nyc_pop_other | integer | The number of New York City residents who identify as other race/ethnicity | 99% | 2423499of 1 |
actual_shootings_male | integer | The actual number of shooting incidents reported to the NYPD involving a male victim. | 99% | 5063of 1 |
expected_shootings_male | integer | The expected number of shooting incidents reported to the NYPD involving a male victim. | 99% | 2710of 1 |
actual_shootings_female | integer | The actual number of shooting incidents reported to the NYPD involving a female victim. | 99% | 612of 1 |
expected_shootings_female | integer | The expected number of shooting incidents reported to the NYPD involving a female victim. | 99% | 2965of 1 |
actual_dir_male | integer | The actual number of domestic incidents reported to the NYPD involving a male victim. | 99% | 165769of 1 |
expected_dir_male | integer | The actual number of domestic incidents reported to the NYPD involving a male victim. | 99% | 280295of 1 |
actual_dir_female | integer | The actual number of domestic incidents reported to the NYPD involving a female victim. | 99% | 421209of 1 |
expected_dir_female | integer | The expected number of domestic incidents reported to the NYPD involving a female victim. | 99% | 306683of 1 |
nyc_pop_male | integer | The number of New York City residents who identify as male. | 99% | 3866509of 1 |
nyc_pop_female | integer | The number of New York City residents who identify as female. | 99% | 4230505of 1 |