From a 500-row sample across 223 columns.
dbndbndbn| dbn | location_name | location_category | administrative_district | a06_disrupting_the_educational | a06_disrupting_the_educational_1 | a07_verbally_rude_or | a07_verbally_rude_or_1 | a13_profane_obscene_vulgar | a14_lying_to_giving_false | a15_misusing_property | a17_leaving_class_or_school |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 01M015 | P.S. 015 Roberto Clemente | Elementary | 1 | R | R | R | R | R | R | R |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
dbn | text | — | 0% | 01M01501M01901M020 |
location_name | text | — | 0% | P.S. 376P.S. 360P.S. 253 |
location_category | categorical | — | 0% | ElementaryHigh schoolJunior High-Intermediate…of 10 |
administrative_district | integer | — | 0% | 21031 |
a06_disrupting_the_educational |
GET /api/datasets/naib-xtez GET /api/datasets/naib-xtez/quality GET /api/datasets/naib-xtez/related GET /api/columns?dataset=naib-xtez
dbn| R |
| 01M019 | P.S. 019 Asher Levy | Elementary | 1 | R | R | R | R | R | R | R | R |
| 01M020 | P.S. 020 Anna Silver | Elementary | 1 | R | R | R | R | R | R | R | R |
| 01M034 | P.S. 034 Franklin D. Roosevelt | K-8 | 1 | R | R | R | R | R | R | R | R |
| 01M063 | The STAR Academy - P.S.63 | Elementary | 1 | R | R | R | R | R | R | R | R |
| 01M064 | P.S. 064 Robert Simon | Elementary | 1 | R | R | R | R | R | R | R | R |
| 01M110 | P.S. 110 Florence Nightingale | Elementary | 1 | R | R | R | R | R | R | R | R |
| 01M134 | P.S. 134 Henrietta Szold | Elementary | 1 | R | R | R | R | R | R | R | R |
| 01M140 | P.S. 140 Nathan Straus | K-8 | 1 | R | R | R | R | R | R | R | R |
| 01M142 | P.S. 142 Amalia Castro | Elementary | 1 | R | R | R | R | R | R | R | R |
Showing 12 of 223 columns. All of them are listed below.
| categorical |
| — |
| 0% |
R6258of 7 |
a06_disrupting_the_educational_1 | text | — | 0% | Rof 1 |
a07_verbally_rude_or | categorical | — | 0% | R140of 2 |
a07_verbally_rude_or_1 | text | — | 0% | Rof 1 |
a13_profane_obscene_vulgar | categorical | — | 0% | R6204of 3 |
a14_lying_to_giving_false | categorical | — | 0% | R14of 2 |
a15_misusing_property | categorical | — | 0% | R24of 2 |
a17_leaving_class_or_school | categorical | — | 0% | R66of 2 |
a18_inappropriate_or_unwanted | categorical | — | 0% | R1084of 3 |
a19_violating_doe_s_internet | categorical | — | 0% | R9of 2 |
a20_scholastic_dishonesty | text | — | 0% | Rof 1 |
a21_inappropriate_use_of | categorical | — | 0% | R16of 2 |
a22_insubordination_r | categorical | — | 0% | R76of 8 |
a22_insubordination_p | categorical | — | 0% | R30of 2 |
a23_using_slurs_bias_r | categorical | — | 0% | R667of 4 |
a23_using_slurs_bias_p | categorical | — | 0% | R35of 2 |
a23_using_slurs_bias_s | text | — | 0% | Rof 1 |
a24_minor_altercation_r | text | — | 0% | R76 |
a24_minor_altercation_p | categorical | — | 0% | R7340of 7 |
a25_bringing_unauthorized | text | — | 0% | Rof 1 |
a26_possession_of_property | categorical | — | 0% | R21of 2 |
a26_possession_of_property_1 | text | — | 0% | Rof 1 |
a26_possession_of_property_2 | text | — | 0% | Rof 1 |
a27_tampering_altering_records | text | — | 0% | Rof 1 |
a28_inappropriate_or_unwanted | categorical | — | 0% | R36of 2 |
a28_inappropriate_or_unwanted_1 | categorical | — | 0% | R27of 2 |
a28_inappropriate_or_unwanted_2 | text | — | 0% | Rof 1 |
a29_gang_related_behavior | text | — | 0% | Rof 1 |
a30_vandalism_graffiti_r | categorical | — | 0% | R7130of 3 |
a30_vandalism_graffiti_p | categorical | — | 0% | R49of 2 |
a30_vandalism_graffiti_s | text | — | 0% | Rof 1 |
a32_posting_distributing | categorical | — | 0% | R9of 2 |
a31_posting_distributing | text | — | 0% | Rof 1 |
a32_posting_distributing_1 | categorical | — | 0% | R9of 2 |
a32_posting_distributing_2 | text | — | 0% | Rof 1 |
a33_altercation_and_or | text | — | 0% | R67 |
a33_altercation_and_or_1 | categorical | — | 0% | R67of 11 |
a33_altercation_and_or_2 | categorical | — | 0% | R6203of 6 |
a34_coercion_threats_r | categorical | — | 0% | R69of 6 |
a34_coercion_threats_p | categorical | — | 0% | R6251of 4 |
a34_coercion_threats_s | categorical | — | 0% | R77of 2 |
a35_disruptive_behavior_on | categorical | — | 0% | R7of 2 |
a35_disruptive_behavior_on_1 | categorical | — | 0% | R186of 3 |
a35_disruptive_behavior_on_2 | text | — | 0% | Rof 1 |
a36_intimidating_and_bullying | categorical | — | 0% | R168of 2 |
a36_intimidating_and_bullying_1 | categorical | — | 0% | R9152of 4 |
a36_intimidating_and_bullying_2 | categorical | — | 0% | R56of 2 |
a37_intimidating_and_bullying | categorical | — | 0% | R55of 2 |
a37_intimidating_and_bullying_1 | categorical | — | 0% | R47of 2 |
a37_intimidating_and_bullying_2 | categorical | — | 0% | R19of 2 |
a38_sexually_suggestive_verbal | categorical | — | 0% | R39of 2 |
a38_sexually_suggestive_verbal_1 | categorical | — | 0% | R67of 2 |
a38_sexually_suggestive_verbal_2 | categorical | — | 0% | R26of 2 |
a39_possession_of_controlled | text | — | 0% | Rof 1 |
a39_possession_of_controlled_1 | text | — | 0% | Rof 1 |
a39_possession_of_controlled_2 | text | — | 0% | Rof 1 |
a40_taking_property_without | categorical | — | 0% | R25of 2 |
a40_taking_property_without_1 | categorical | — | 0% | R26of 2 |
a40_taking_property_without_2 | categorical | — | 0% | R12of 2 |
a41_false_activation_of_fire | categorical | — | 0% | R18of 2 |
a41_false_activation_of_fire_1 | text | — | 0% | Rof 1 |
a41_false_activation_of_fire_2 | categorical | — | 0% | R9of 2 |
a42_bomb_threat_r | text | — | 0% | Rof 1 |
a42_bomb_threat_p | text | — | 0% | Rof 1 |
a43_reckless_behavior_with | categorical | — | 0% | R610of 4 |
a43_reckless_behavior_with_1 | categorical | — | 0% | R1136of 3 |
a43_reckless_behavior_with_2 | categorical | — | 0% | R84of 2 |
a44_reckless_behavior_that | text | — | 0% | Rof 1 |
a44_reckless_behavior_that_1 | categorical | — | 0% | R7of 2 |
a44_reckless_behavior_that_2 | categorical | — | 0% | R9of 2 |
a46_weapon_possession_category | text | — | 0% | Rof 1 |
a46_weapon_possession_category_1 | categorical | — | 0% | R8of 2 |
a46_weapon_possession_category_2 | text | — | 0% | Rof 1 |
a47_using_controlled | text | — | 0% | Rof 1 |
a47_using_controlled_1 | categorical | — | 0% | R6of 2 |
a48_starting_a_fire_r | text | — | 0% | Rof 1 |
a48_starting_a_fire_p | categorical | — | 0% | R8of 2 |
a48_starting_a_fire_s | categorical | — | 0% | R17of 2 |
a50_using_force_against | categorical | — | 0% | R33of 2 |
a50_using_force_against_1 | categorical | — | 0% | R60of 2 |
a50_using_force_against_2 | categorical | — | 0% | R667of 3 |
a51_using_extreme_force | text | — | 0% | Rof 1 |
a51_using_extreme_force_1 | categorical | — | 0% | R12of 2 |
a51_using_extreme_force_2 | categorical | — | 0% | R346of 3 |
a52_group_violence_r | text | — | 0% | Rof 1 |
a52_group_violence_p | text | — | 0% | Rof 1 |
a52_group_violence_s | categorical | — | 0% | R197of 3 |
a54_engaging_physical_sexual | text | — | 0% | Rof 1 |
a54_engaging_physical_sexual_1 | text | — | 0% | Rof 1 |
a56_weapon_possession_category | categorical | — | 0% | R27of 2 |
a56_weapon_possession_category_1 | categorical | — | 0% | R25of 2 |
a56_weapon_possession_category_2 | categorical | — | 0% | R1477of 3 |
a57_using_weapon_category | text | — | 0% | Rof 1 |
a57_using_weapon_category_1 | text | — | 0% | Rof 1 |
a57_using_weapon_category_2 | categorical | — | 0% | R15of 2 |
a58_using_weapon_category | text | — | 0% | Rof 1 |
a58_using_weapon_category_1 | text | — | 0% | Rof 1 |
a58_using_weapon_category_2 | categorical | — | 0% | R26of 2 |
a59_using_weapon_other_than | text | — | 0% | Rof 1 |
a59_using_weapon_other_than_1 | text | — | 0% | Rof 1 |
a59_using_weapon_other_than_2 | text | — | 0% | Rof 1 |
b07_disrupting_the_educational | text | — | 0% | R68 |
b07_disrupting_the_educational_1 | categorical | — | 0% | R9of 2 |
b08_verbally_rude_or | categorical | — | 0% | R97of 14 |
b08_verbally_rude_or_1 | text | — | 0% | Rof 1 |
b14_gambling_r | categorical | — | 0% | R1116of 3 |
b15_profane_obscene_vulgar | categorical | — | 0% | R68of 13 |
b15_profane_obscene_vulgar_1 | text | — | 0% | Rof 1 |
b16_lying_to_giving_false | categorical | — | 0% | R547of 3 |
b17_misusing_property | categorical | — | 0% | R477of 3 |
b19_inappropriate_use_of | categorical | — | 0% | R6163of 6 |
b20_leaving_class_or_school | categorical | — | 0% | R1097of 3 |
b20_leaving_class_or_school_1 | text | — | 0% | Rof 1 |
b21_insubordination_r | categorical | — | 0% | R76of 14 |
b21_insubordination_p | text | — | 0% | R68 |
b22_trespassing_r | categorical | — | 0% | R17of 2 |
b22_trespassing_p | categorical | — | 0% | R67of 19 |
b23_using_slurs_bias_r | categorical | — | 0% | R1266of 3 |
b23_using_slurs_bias_p | categorical | — | 0% | R126of 11 |
b23_using_slurs_bias_s | categorical | — | 0% | R11of 2 |
b24_minor_altercation_r | text | — | 0% | R67 |
b24_minor_altercation_p | text | — | 0% | R610 |
b25_bringing_unauthorized | text | — | 0% | Rof 1 |
b25_bringing_unauthorized_1 | categorical | — | 0% | R86of 2 |
b25_bringing_unauthorized_2 | text | — | 0% | Rof 1 |
b26_gang_related_behavior | categorical | — | 0% | R8of 2 |
b26_gang_related_behavior_1 | categorical | — | 0% | R426of 3 |
b26_gang_related_behavior_2 | text | — | 0% | Rof 1 |
b27_tampering_altering_records | text | — | 0% | Rof 1 |
b27_tampering_altering_records_1 | text | — | 0% | Rof 1 |
b28_vandalism_graffiti_r | categorical | — | 0% | R96of 2 |
b28_vandalism_graffiti_p | categorical | — | 0% | R68of 9 |
b28_vandalism_graffiti_s | categorical | — | 0% | R80of 2 |
b29_possession_of_property | categorical | — | 0% | R388of 3 |
b29_possession_of_property_1 | categorical | — | 0% | R78of 7 |
b29_possession_of_property_2 | categorical | — | 0% | R20of 2 |
b30_violating_doe_s_internet | categorical | — | 0% | R10of 2 |
b30_violating_doe_s_internet_1 | categorical | — | 0% | R42of 2 |
b30_violating_doe_s_internet_2 | categorical | — | 0% | R6of 2 |
b31_scholastic_dishonesty | categorical | — | 0% | R176of 3 |
b31_scholastic_dishonesty_1 | categorical | — | 0% | R106of 7 |
b31_scholastic_dishonesty_2 | categorical | — | 0% | R7of 2 |
b32_posting_distributing | text | — | 0% | Rof 1 |
b32_posting_distributing_1 | categorical | — | 0% | R750of 3 |
b32_posting_distributing_2 | text | — | 0% | Rof 1 |
b33_engaging_in_sexual_conduct | text | — | 0% | Rof 1 |
b33_engaging_in_sexual_conduct_1 | categorical | — | 0% | R798of 3 |
b33_engaging_in_sexual_conduct_2 | categorical | — | 0% | R30of 2 |
b34_sexually_suggestive_verbal | categorical | — | 0% | R102of 2 |
b34_sexually_suggestive_verbal_1 | categorical | — | 0% | R67of 11 |
b34_sexually_suggestive_verbal_2 | categorical | — | 0% | R6285of 4 |
b35_posting_distributing | categorical | — | 0% | R42of 2 |
b35_posting_distributing_1 | categorical | — | 0% | R8252of 4 |
b35_posting_distributing_2 | categorical | — | 0% | R94of 2 |
b36_altercation_and_or | categorical | — | 0% | R76of 12 |
b36_altercation_and_or_1 | text | — | 0% | R86 |
b36_altercation_and_or_2 | categorical | — | 0% | R67of 19 |
b37_coercion_threats_r | categorical | — | 0% | R1986of 3 |
b37_coercion_threats_p | text | — | 0% | R67 |
b37_coercion_threats_s | categorical | — | 0% | R67of 10 |
b38_disruptive_behavior_on | text | — | 0% | Rof 1 |
b38_disruptive_behavior_on_1 | categorical | — | 0% | R31of 2 |
b38_disruptive_behavior_on_2 | categorical | — | 0% | R6of 2 |
b39_intimidating_and_bullying | categorical | — | 0% | R6148of 4 |
b39_intimidating_and_bullying_1 | categorical | — | 0% | R67of 18 |
b39_intimidating_and_bullying_2 | categorical | — | 0% | R67of 6 |
b40_intimidating_and_bullying | categorical | — | 0% | R688of 3 |
b40_intimidating_and_bullying_1 | categorical | — | 0% | R76of 8 |
b40_intimidating_and_bullying_2 | categorical | — | 0% | R178of 2 |
b41_possession_of_controlled | categorical | — | 0% | R14of 2 |
b41_possession_of_controlled_1 | categorical | — | 0% | R610of 13 |
b41_possession_of_controlled_2 | categorical | — | 0% | R8273of 5 |
b42_false_activation_of_fire | text | — | 0% | Rof 1 |
b42_false_activation_of_fire_1 | categorical | — | 0% | R75of 2 |
b42_false_activation_of_fire_2 | categorical | — | 0% | R52of 2 |
b43_bomb_threat_p | categorical | — | 0% | R8of 2 |
b43_bomb_threat_s | categorical | — | 0% | R17of 2 |
b44_taking_property_without | categorical | — | 0% | R23of 2 |
b44_taking_property_without_1 | categorical | — | 0% | R76of 6 |
b44_taking_property_without_2 | categorical | — | 0% | R7263of 5 |
b45_reckless_behavior_with | categorical | — | 0% | R49of 2 |
b45_reckless_behavior_with_1 | categorical | — | 0% | R67of 9 |
b45_reckless_behavior_with_2 | categorical | — | 0% | R610of 9 |
b46_reckless_behavior_that | categorical | — | 0% | R36of 2 |
b46_reckless_behavior_that_1 | categorical | — | 0% | R63of 2 |
b47_inciting_causing_riot | categorical | — | 0% | R256of 3 |
b47_inciting_causing_riot_1 | categorical | — | 0% | R327of 4 |
b48_weapon_possession_category | categorical | — | 0% | R1036of 3 |
b48_weapon_possession_category_1 | categorical | — | 0% | R56of 2 |
b49_using_controlled | categorical | — | 0% | R8of 2 |
b49_using_controlled_1 | categorical | — | 0% | R79of 6 |
b49_using_controlled_2 | categorical | — | 0% | R97of 2 |
b50_starting_a_fire_p | categorical | — | 0% | R11of 2 |
b50_starting_a_fire_s | categorical | — | 0% | R116of 2 |
b51_threatening_using_force | text | — | 0% | Rof 1 |
b51_threatening_using_force_1 | categorical | — | 0% | R685of 3 |
b52_using_force_against | categorical | — | 0% | R207of 3 |
b52_using_force_against_1 | categorical | — | 0% | R69of 5 |
b53_using_extreme_force | categorical | — | 0% | R12of 2 |
b53_using_extreme_force_1 | categorical | — | 0% | R2916of 5 |
b54_group_violence_p | categorical | — | 0% | R878of 3 |
b54_group_violence_s | categorical | — | 0% | R67of 15 |
b55_threaten_dangerous | text | — | 0% | Rof 1 |
b55_threaten_dangerous_1 | categorical | — | 0% | R116of 4 |
b56_engaging_physical_sexual | text | — | 0% | Rof 1 |
b56_engaging_physical_sexual_1 | categorical | — | 0% | R41of 2 |
b57_selling_distributing | categorical | — | 0% | R356of 3 |
b57_selling_distributing_1 | categorical | — | 0% | R86of 4 |
b58_weapon_possession_category | categorical | — | 0% | R8of 2 |
b58_weapon_possession_category_1 | categorical | — | 0% | R67of 14 |
b59_using_weapon_category | text | — | 0% | Rof 1 |
b59_using_weapon_category_1 | categorical | — | 0% | R94of 2 |
b60_using_weapon_category | text | — | 0% | Rof 1 |
b60_using_weapon_category_1 | categorical | — | 0% | R123of 2 |
b61_using_weapon_other_than | text | — | 0% | Rof 1 |
b61_using_weapon_other_than_1 | categorical | — | 0% | R67of 2 |
b62_possessing_or_using_a | text | — | 0% | Rof 1 |
b62_possessing_or_using_a_1 | categorical | — | 0% | R236of 3 |
sy1718_total_removals | text | — | 0% | R06 |