From a 61-row sample across 36 columns.
| geographic_location | pop_white | pop_black | pop_hispanic | pop_asian_pac | pop_amer_indian | pop_white_female | pop_black_female | pop_hispanic_female | pop_asian_pac_female | pop_amer_indian_female | pop_white_male |
|---|---|---|---|---|---|---|---|---|---|---|---|
| New York City | 2284954 | 1485554 | 2075366 | 1001847 | 11665 | 1178415 | 828021 | 1004697 | 533647 | 6545 | 1106539 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
geographic_location | text | The geographic area from which the data was collected. | 0% | CD 110CD 212CD 112 |
pop_white | integer | The number of individuals who report being White. | 0% | 535152967034225 |
pop_black | integer | The number of individuals who report being Black. | 0% | 2071608861581 |
pop_hispanic | integer | The number of individuals who report being Hispanic. | 0% | 116042843515960 |
GET /api/datasets/sw27-mp7d GET /api/datasets/sw27-mp7d/quality GET /api/datasets/sw27-mp7d/related GET /api/columns?dataset=sw27-mp7d
| Bronx |
| 111466 |
| 330305 |
| 681504 |
| 43306 |
| 2624 |
| 57185 |
| 179220 |
| 334143 |
| 22665 |
| 1676 |
| 54281 |
| Brooklyn | 752977 | 626217 | 411282 | 252161 | 2363 | 388106 | 358111 | 198524 | 132535 | 1223 | 364871 |
| Manhattan | 691434 | 171167 | 371692 | 180160 | 1919 | 358899 | 92581 | 186027 | 102283 | 1045 | 332535 |
| Queens | 485788 | 323061 | 540635 | 487394 | 4264 | 247749 | 179421 | 252183 | 255934 | 2307 | 238039 |
| Staten Island | 243289 | 34804 | 70253 | 38826 | 495 | 126476 | 18688 | 33820 | 20230 | 294 | 116813 |
| CD 101_102 | 99945 | 3309 | 10932 | 20842 | 0 | 50876 | 1834 | 5564 | 11475 | 0 | 49069 |
| CD 103 | 50044 | 10974 | 33622 | 44477 | 533 | 23856 | 5982 | 17362 | 23250 | 232 | 26188 |
| CD 104 and 105 | 87915 | 6745 | 23204 | 25249 | 138 | 39852 | 3227 | 10685 | 14278 | 0 | 48063 |
| CD 106 | 92694 | 5704 | 11604 | 22176 | 101 | 48788 | 3094 | 5491 | 12586 | 59 | 43906 |
Showing 12 of 36 columns. All of them are listed below.
pop_asian_pac |
| integer |
| The number of individuals who report being Asian or Pacific Islander. |
| 0% |
39243273275745 |
pop_amer_indian | integer | The number of individuals who report being American Indian. | 0% | 115195204 |
pop_white_female | integer | The number of individuals who report being White and Female. | 0% | 126476123898881 |
pop_black_female | integer | The number of individuals who report being Black and Female. | 0% | 143591596334405 |
pop_hispanic_female | integer | The number of individuals who report being Hispanic and Female. | 0% | 13528573527894 |
pop_asian_pac_female | integer | The number of individuals who report being Asian or Pacific Islander and Female. | 0% | 6452609111340 |
pop_amer_indian_female | integer | The number of individuals who report being American Indian and Female. | 0% | 010572 |
pop_white_male | integer | The number of individuals who report being White and male. | 0% | 283533490912996 |
pop_black_male | integer | The number of individuals who report being Black and male. | 0% | 78586269863168 |
pop_hispanic_male | integer | The number of individuals who report being Hispanic and male. | 0% | 226481862226182 |
pop_asian_pac_male | integer | The number of individuals who report being Asian or Pacific Islander and male. | 0% | 200079723934 |
pop_amer_indian_male | integer | The number of individuals who report being American Indian and male. | 0% | 01739 |
assault_white | integer | The number of intimate partner felony assaults where the victim was White. | 0% | 14169 |
assault_black | integer | The number of intimate partner felony assaults where the victim was Black. | 0% | 121656 |
assault_hispanic | integer | The number of intimate partner felony assaults where the victim was Hispanic | 0% | 1566146 |
assault_asian_pac | integer | The number of intimate partner felony assaults where the victim was Asian or Pacific Islander. | 0% | 328 |
assault_amer_indian | categorical | The number of intimate partner felony assaults where the victim was American Indian. | 0% | 012of 6 |
assault_white_female | integer | The number of intimate partner felony assaults where the victim was reported as a White female. | 0% | 12139 |
assault_black_female | integer | The number of intimate partner felony assaults where the victim was reported as a Black female. | 0% | 111572 |
assault_hispanic_female | integer | The number of intimate partner felony assaults where the victim was reported as a Hispanic female. | 0% | 36145 |
assault_asian_pac_female | integer | The number of intimate partner felony assaults where the victim was reported as an Asian or Pacific Islander female. | 0% | 267 |
assault_amer_indian_female | categorical | The number of intimate partner felony assaults where the victim was reported as an American Indian female. | 0% | 012of 6 |
assault_white_male | integer | The number of intimate partner felony assaults where the victim was reported as a White male. | 0% | 245 |
assault_black_male | integer | The number of intimate partner felony assaults where the victim was reported as a Black male. | 0% | 184 |
assault_hispanic_male | integer | The number of intimate partner felony assaults where the victim was reported as a Hispanic male. | 0% | 10212 |
assault_asian_pac_male | categorical | The number of intimate partner felony assaults where the victim was reported as an Asian or Pacific Islander male. | 0% | 013of 15 |
assault_amer_indian_male | categorical | The number of intimate partner felony assaults where the victim was reported as an American Indian male. | 0% | 012of 3 |
expected_assault_white | integer | The expected number of intimate partner felony assaults where the victim was White. | 0% | 401337 |
expected_assault_black | integer | The expected number of intimate partner felony assaults where the victim was Black. | 0% | 216 |
expected_assault_hispanic | integer | The expected number of intimate partner felony assaults where the victim was Hispanic | 0% | 65511 |
expected_assault_asian_pac | integer | The expected number of intimate partner felony assaults where the victim was Asian or Pacific Islander. | 0% | 11612 |
expected_assault_amer_indian | categorical | The expected number of intimate partner felony assaults where the victim was American Indian. | 0% | 012of 7 |