From a 500-row sample across 42 columns.
| school_year | beds_code | school_name | district_name | school_type | enrollment | homicide_with_weapon_s | homicide_without_weapon_s | forcible_sex_offenses_with | forcible_sex_offenses_without | other_sex_offenses_with_weapon | other_sex_offenses_without |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2008-2009 | 307500011035 | Ps 35 | Nyc Special Schools - District 75 | Public | 274 | 0 | 0 | 0 | 0 | 0 | 0 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
school_year | categorical | School year in which incidents were recorded | 0% | 2014-20152013-20142012-2013of 7 |
beds_code | integer | NYSED unique identifier | 0% | 342500010163342700010051310200010126 |
school_name | text | Name of the school | 0% | Ps 226Ps 138Ps 150 |
district_name | text | Name of district in which the school is located | 0% | New York City Geographic…New York City Geographic… |
GET /api/datasets/fpci-ws56 GET /api/datasets/fpci-ws56/quality GET /api/datasets/fpci-ws56/related GET /api/columns?dataset=fpci-ws56
| 2008-2009 | 307500011079 | Ps 79 Horan | Nyc Special Schools - District 75 | Public | 341 | 0 | 0 | 0 | 0 | 0 | 2 |
| 2008-2009 | 307500011094 | Ps 94 | Nyc Special Schools - District 75 | Public | 207 | 0 | 0 | 0 | 0 | 0 | 0 |
| 2008-2009 | 307500011138 | Ps 138 | Nyc Special Schools - District 75 | Public | 419 | 0 | 0 | 0 | 0 | 0 | 3 |
| 2008-2009 | 307500011169 | Ps 169 Robert F Kennedy | Nyc Special Schools - District 75 | Public | 235 | 0 | 0 | 0 | 0 | 0 | 1 |
| 2008-2009 | 307500011226 | Ps 226 | Nyc Special Schools - District 75 | Public | 277 | 0 | 0 | 0 | 0 | 0 | 5 |
| 2008-2009 | 307500011401 | Hospital Schools | Nyc Special Schools - District 75 | Public | 433 | 0 | 0 | 0 | 0 | 0 | 0 |
| 2008-2009 | 307500011721 | Ps 721 Manhattan Occupational Training Center | Nyc Special Schools - District 75 | Public | 252 | 0 | 0 | 0 | 0 | 0 | 2 |
| 2008-2009 | 307500011751 | Manhattan School For Career Development | Nyc Special Schools - District 75 | Public | 238 | 0 | 0 | 0 | 0 | 0 | 0 |
| 2008-2009 | 307500011811 | Ps 811 Mickey Mantle | Nyc Special Schools - District 75 | Public | 336 | 0 | 0 | 0 | 0 | 0 | 3 |
Showing 12 of 42 columns. All of them are listed below.
New York City Geographic…school_type | text | Public school or charter or other | 0% | Publicof 1 |
enrollment | integer | Number of students enrolled in school | 0% | 447482394 |
homicide_with_weapon_s | categorical | Number of incidents of this type recorded | 0% | 01of 2 |
homicide_without_weapon_s | integer | Number of incidents of this type recorded | 0% | 0of 1 |
forcible_sex_offenses_with | categorical | Number of incidents of this type recorded | 0% | 01of 2 |
forcible_sex_offenses_without | categorical | Number of incidents of this type recorded | 0% | 012of 3 |
other_sex_offenses_with_weapon | categorical | Number of incidents of this type recorded | 0% | 012of 3 |
other_sex_offenses_without | integer | Number of incidents of this type recorded | 0% | 012 |
robbery_with_weapon_s | categorical | Number of incidents of this type recorded | 0% | 012of 4 |
robbery_without_weapon_s | categorical | Number of incidents of this type recorded | 0% | 012of 7 |
assault_with_serious_physical | categorical | Number of incidents of this type recorded | 0% | 012of 4 |
assault_with_serious_physical_1 | categorical | Number of incidents of this type recorded | 0% | 012of 8 |
arson_with_weapon_s | categorical | Number of incidents of this type recorded | 0% | 012of 7 |
kidnapping_with_weapon_s | integer | Number of incidents of this type recorded | 0% | 0of 1 |
kidnapping_without_weapon | integer | Number of incidents of this type recorded | 0% | 0of 1 |
assault_with_physical_injury | categorical | Number of incidents of this type recorded | 0% | 012of 12 |
assault_with_physical_injury_1 | integer | Number of incidents of this type recorded | 0% | 012 |
reckless_endangerment_with | categorical | Number of incidents of this type recorded | 0% | 012of 7 |
reckless_endangerment_without | categorical | Number of incidents of this type recorded | 0% | 012of 17 |
minor_altercations_with_weapon | categorical | Number of incidents of this type recorded | 0% | 012of 19 |
minor_altercations_without | integer | Number of incidents of this type recorded | 0% | 012 |
intimidation_harassment | categorical | Number of incidents of this type recorded | 0% | 012of 15 |
intimidation_harassment_1 | integer | Number of incidents of this type recorded | 0% | 012 |
burglary_with_weapon_s | integer | Number of incidents of this type recorded | 0% | 0of 1 |
burglary_without_weapon_s | categorical | Number of incidents of this type recorded | 0% | 01of 2 |
criminal_mischief_with_weapon | categorical | Number of incidents of this type recorded | 0% | 012of 3 |
criminal_mischief_without | categorical | Number of incidents of this type recorded | 0% | 012of 18 |
larceny_or_other_theft_with | integer | Number of incidents of this type recorded | 0% | 0of 1 |
larceny_or_other_theft_without | integer | Number of incidents of this type recorded | 0% | 012 |
bomb_threat | categorical | Number of incidents of this type recorded | 0% | 012of 7 |
false_alarm | categorical | Number of incidents of this type recorded | 0% | 012of 14 |
riot_with_weapon_s | integer | Number of incidents of this type recorded | 0% | 0of 1 |
riot_without_weapon_s | categorical | Number of incidents of this type recorded | 0% | 012of 3 |
weapon_possessionthrough | integer | Number of incidents of this type recorded | 0% | 012 |
weapon_possession_under_other | integer | Number of incidents of this type recorded | 0% | 012 |
drug_possession | integer | Number of incidents of this type recorded | 0% | 012 |
alcohol_possession | categorical | Number of incidents of this type recorded | 0% | 012of 13 |
other_disruptive | integer | Number of incidents of this type recorded | 0% | 012 |
county | categorical | County in which the school is located | 27% | KingsBronxQueensof 13 |
need_resource_category | text | — | 20% | New York Cityof 1 |
grade_organization | categorical | School organization type | 15% | ElementarySenior HighMiddle Schoolof 11 |