2013-2014 VADIR INCIDENTS

CREATE TABLE table_1 (
  "school_year" VARCHAR,
  "county" VARCHAR,
  "district" VARCHAR,
  "school_name" VARCHAR,
  "beds_code" BIGINT,
  "grade_organization" VARCHAR,
  "need_resource_category" VARCHAR,
  "school_type" VARCHAR,
  "enrollment" BIGINT,
  "homicide_with_weapon_s" BIGINT  -- Homicide With Weapon(s),
  "n__homicidewithout_weapon_s" BIGINT  -- HomicideWithout Weapon(s),
  "forcible_sex_offenses_with_weapon_s" BIGINT  -- Forcible Sex Offenses With Weapon(s),
  "forcible_sex_offenses_without_weapon_s" BIGINT  -- Forcible Sex Offenses Without Weapon(s),
  "other_sex_offenses_with_weapon_s" BIGINT  -- Other Sex Offenses With Weapon(s),
  "other_sex_offenses_without_weapon_s" BIGINT  -- Other Sex Offenses Without Weapon(s),
  "robbery_with_weapon_s" BIGINT  -- Robbery With Weapon(s),
  "robbery_without_weapon_s" BIGINT  -- Robbery Without Weapon(s),
  "n__assault_with_serious_physical_injurywith_weapon_s" BIGINT  -- Assault With Serious Physical InjuryWith Weapon(s),
  "n__assault_with_serious_physical_injurywithout_weapon_s" BIGINT  -- Assault With Serious Physical InjuryWithout Weapon(s),
  "arson_with_weapon_s" BIGINT  -- Arson With Weapon(s),
  "kidnapping_with_weapon_s" BIGINT  -- Kidnapping With Weapon(s),
  "kidnapping_without_weapon_s" BIGINT  -- Kidnapping Without Weapon(s),
  "assault_with_physical_injury_with_weapon_s" BIGINT  -- Assault With Physical Injury With Weapon(s),
  "assault_with_physical_injury_without_weapon_s" BIGINT  -- Assault With Physical Injury Without Weapon(s),
  "reckless_endangerment_with_weapon_s" BIGINT  -- Reckless Endangerment With Weapon(s),
  "reckless_endangerment_without_weapon_s" BIGINT  -- Reckless Endangerment Without Weapon(s),
  "minor_altercations_with_weapon_s" BIGINT  -- Minor Altercations With Weapon(s),
  "minor_altercations_without_weapon_s" BIGINT  -- Minor Altercations Without Weapon(s),
  "intimidation_harassment_menacing_or_bullying_with_weapon_s" BIGINT  -- Intimidation, Harassment, Menacing, Or Bullying With Weapon(s),
  "intimidation_harassment_menacing_or_bullying_without_weapon_s" BIGINT  -- Intimidation, Harassment, Menacing, Or Bullying Without Weapon(s),
  "burglary_with_weapon_s" BIGINT  -- Burglary With Weapon(s),
  "burglary_without_weapon_s" BIGINT  -- Burglary Without Weapon(s),
  "criminal_mischief_with_weapon_s" BIGINT  -- Criminal Mischief With Weapon(s),
  "criminal_mischief_without_weapon_s" BIGINT  -- Criminal Mischief Without Weapon(s),
  "larceny_or_other_theft_with_weapon_s" BIGINT  -- Larceny, Or Other Theft With Weapon(s),
  "larceny_or_other_theft_without_weapon_s" BIGINT  -- Larceny, Or Other Theft Without Weapon(s),
  "bomb_threat" BIGINT,
  "false_alarm" BIGINT,
  "riot_with_weapon_s" BIGINT  -- Riot With Weapon(s),
  "riot_without_weapon_s" BIGINT  -- Riot Without Weapon(s),
  "weapon_possession_through_screening" BIGINT,
  "weapon_possession_under_other_circumstances" BIGINT,
  "drug_possession" BIGINT,
  "alcohol_possession" BIGINT,
  "other_disruptive" BIGINT
);